What can we help you find? Products Coupa Product Documentation Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Export Contracts Export

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.

Note

CSV exports for SFTP only include a known issue where the Expires field adds an extra day to the expiry date. This does not affect exports made using the UI.

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