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 |