Lookup Values Export
Coupa's lookup values flat file integration object contains only a single set of header columns.
Export of these records is included as a Standard CSV Export.
| 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 |