Skip to main content



Coupa Success Portal

Lookup Values Export

Export of these records is included as a Standard CSV Export.

Lookup values columns

Column Description Req'd Unique Type Allowable Values
Id Coupa unique identifier false false integer any
Created Date Automatically created by Coupa in the format YYYY-MM-DDTHH:MM:SS+HH:MMZ false false datetime any
Last Updated Date Automatically created by Coupa in the format YYYY-MM-DDTHH:MM:SS+HH:MMZ false false datetime any
External Ref Code Used for Identification of individual Lookup Value when using Hierarchical Lookups. This field is a concatenation of the External Ref Num fields starting with the root LookupValue. It does not get set by the integration, but is used to identify an existing lookup to update. false true string(255) any
External Ref Num External Ref Num (actual account value when used in accounting) false true string(255) any
Name Lookup value name true true string(255) any
Description Lookup value description false false string(255) any
Lookup ID Lookup ID false false integer any
Lookup Name Lookup Name false false   any
Parent External Ref Code External Ref Code of Parent element false false   any
Parent ID Parent ID false false integer any
Depth depth false false integer any
Active A false value will inactivate the account making it no longer available to users. A true value will make it active and available to users. false false boolean any
Account Type ID Acccount Type ID false false   any
Account Type Name Acccount Type name false false   any
custom-field-1 Integration Custom Field 1 false false string(255) any
custom-field-2 Integration Custom Field 2 false false string(255) any
custom-field-3 Integration Custom Field 3 false false string(255) any
custom-field-4 Integration Custom Field 4 false false string(255) any
custom-field-5 Integration Custom Field 5 false false string(255) any
custom-field-6 Integration Custom Field 6 false false string(255) any
custom-field-7 Integration Custom Field 7 false false string(255) any
custom-field-8 Integration Custom Field 8 false false string(255) any
custom-field-9 Integration Custom Field 9 false false string(255) any
custom-field-10 Integration Custom Field 10 false false string(255) any


  • Was this article helpful?