Lookup Values Export

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

Lookup Value

Field NameDescriptionField TypeRequired/UniquePossible Values
IdCoupa unique identifierintegerNo/No
Created DateAutomatically created by Coupa in the format YYYY-MM-DDTHH:MM:SS+HH:MMZdatetimeNo/No
Last Updated DateAutomatically created by Coupa in the format YYYY-MM-DDTHH:MM:SS+HH:MMZdatetimeNo/No
External Ref CodeUsed 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.string(255)No/Yes
External Ref NumExternal Ref Num (actual account value when used in accounting)string(255)No/Yes
NameLookup value namestring(255)Yes/Yes
DescriptionLookup value descriptionstring(255)No/No
Lookup IDLookup IDintegerNo/No
Lookup NameLookup NameNo/No
Parent External Ref CodeExternal Ref Code of Parent elementNo/No
Parent IDParent IDintegerNo/No
DepthdepthintegerNo/No
ActiveA false value will inactivate the account making it no longer available to users. A true value will make it active and available to users.booleanNo/No
Account Type IDAcccount Type IDNo/No
Account Type NameAcccount Type nameNo/No