Contracts Export
Coupa's contracts flat file integration object contains only a single set of header columns.
Export of these records is included as a Standard CSV Export.
Contract headers
| Position | Column Name | Description | Type | Req/Unique | Allowable Values |
|---|---|---|---|---|---|
| 1 | Contract # | The contract number | string(50) | Yes/Yes | |
| 2 | Contract Name | The name of the contract | string(100) | Yes/Yes | |
| 3 | Content Groups | The content groups that can view this contract | string | No/No | |
| 4 | Status | The status of the contract | string(50) | Yes/No | |
| 5 | Supplier | The supplier ID assocaited with the contract | integer(11) | No/No | |
| 6 | Supplier Number | Supplier Number | string(255) | No/No | |
| 7 | Supplier Account # | The supplier account for the contract | string(255) | No/No | |
| 8 | Starts | The date the contract begins | datetime | Yes/No | |
| 9 | Expires | The date the contract expires | datetime | Yes/No | |
| 10 | Owner | The currency ID associated with the contract | integer(11) | No/No | |
| 11 | Owner Login | The user login that owns the contract | string(255) | No/No | |
| 12 | Currency Code | Currency Code | string(6) | No/No | |
| 13 | Savings % | The % savings created by the contract | decimal(20,2) | No/No | A percentage between 0 and 100 |
| 14 | Version | The version number of the contract | integer | No/No | |
| 15 | Created By | The user ID that created the contract | integer | No/No | |
| 16 | Created By Login | Created By Login | string(255) | No/No | |
| 17 | Created Date | The date the contract was created | datetime | No/No | |
| 18 | Updated By | The user ID that most recently updated the contract | integer(11) | No/No | |
| 19 | Updated By Login | The user login that most recently updated the contract | string(255) | No/No | |
| 20 | Updated Date | The date the contract was most recently updated | datetime | No/No | |
| 21 | Submitted Date | The date the contract was submitted | datetime | No/No | |
| 22 | Submitted By | The user ID of the person that submitted the contract | integer(11) | No/No | |
| 23 | Submitted By Login | The user login that submitted the approval | string(255) | No/No | |
| 24 | Is Default | Is this the default (Y/N) | boolean | No/No | |
| 25 | Default Account ID | The default account ID for the contract | integer(11) | No/No | |
| 26 | Default Account Code | The default account code for the contract | string(21024) | No/No | |
| 27 | Linked Projects | List of Project IDs linked to this contract | No/No | ||
| 28 | Linked Events | List of Event IDs linked to this contract | No/No |