• Last edited on: 28 May 2019

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

Related Items


Budget Line Adjustment Import

01 February 2019

The Budget Line Adjustment integration loader uses only a single set of header columns.

Enterprise Import

03 February 2019

The Enterprises integration loader uses only a single set of header columns.

Exchange Rate Import

03 February 2019

The exchange rates integration loader uses only a single set of header columns.

Expense Category Import

03 February 2019

The Expense Category loader uses only a single set of header columns.