What can we help you find? Products Total Spend Management Platform Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Export Sourcing Export

Sourcing Export

Sourcing exports include various details of Sourcing event records.

Quote award columns

Columns that detail supplier responses or response lines that have been awarded.

Position	Column Name	Description	Req/Unique	Unique	Type	Allowable Values
1	Quote Award	Quote Award	Quote Award	FALSE
2	Quote Award ID	Quote Award ID	FALSE	FALSE	integer	any
3	Created At Date	Created At Date	FALSE	FALSE	datetime	any
4	Updated At Date	Updated At Date	TRUE	FALSE	datetime	any
5	Event Awardable ID	Event Awardable ID	FALSE	FALSE	integer	any
6	Event Awardable Type	Event Awardable Type	FALSE	FALSE	string(255)	any

Quote request columns

Columns with header level details for a Sourcing event.

Position	Column Name	Description	Req/Unique	Unique	Type	Allowable Values
1	Quote Request	Quote Request	FALSE	FALSE
2	Quote Request Header ID	Quote Request Header ID	FALSE	FALSE	integer
3	Original ID	Original ID	FALSE	FALSE	integer
4	Revision	Revision	FALSE	FALSE	string(255)
5	Event Header Name	Event Header Name	FALSE	FALSE	text
6	Created At Date	Created At Date	FALSE	FALSE	datetime
7	Created by ID	Created by ID	FALSE	FALSE	integer
8	Updated At Date	Updated At Date	FALSE	FALSE	datetime
9	Updated by ID	Updated by ID	FALSE	FALSE	integer
10	Start Date	Start Date	FALSE	FALSE	datetime
11	End Date	End Date	FALSE	FALSE	datetime
12	State	State	FALSE	FALSE	string(255)
13	Event Type	Event Type	TRUE	FALSE	string(255)
14	Type	Type	FALSE	FALSE	string(255)
15	Start On Submit	Start On Submit	FALSE	FALSE	boolean
16	Bid On Start	Bid On Start	FALSE	FALSE	boolean
17	Time To Respond	Time To Respond	FALSE	FALSE	integer
18	Beaten Price Options - Total Event	Beaten Price Options - Total Event	FALSE	FALSE
19	Beaten Price Options - Any Lot	Beaten Price Options - Any Lot	FALSE	FALSE
20	Beaten Price Options - Individual Line	Beaten Price Options - Individual Line	FALSE	FALSE
21	Incremental Bidding Options - Any Lot Allow - Tie For First Place	Incremental Bidding Options - Any Lot Allow - Tie For First Place	FALSE	FALSE
22	Incremental Bidding Options - Any Lot - Require To Improve Size	Incremental Bidding Options - Any Lot - Require To Improve Size	FALSE	FALSE
23	Incremental Bidding Options - Any Lot - Size	Incremental Bidding Options - Any Lot - Size	FALSE	FALSE
24	Incremental Bidding Options - Any Lot - Size Total	Incremental Bidding Options - Any Lot - Size Total	FALSE	FALSE
25	Incremental Bidding Options - Individual Line Allow - Tie For First Place	Incremental Bidding Options - Individual Line Allow - Tie For First Place	FALSE	FALSE
26	Incremental Bidding Options - Individual Line - Require To Improve - Size	Incremental Bidding Options - Individual Line - Require To Improve - Size	FALSE	FALSE
27	Incremental Bidding Options - Individual Line - Size	Incremental Bidding Options - Individual Line - Size	FALSE	FALSE
28	Incremental Bidding Options - Individual Line - Size Total	Incremental Bidding Options - Individual Line - Size Total	FALSE	FALSE
29	Incremental Bidding Options - Total Event Allow - Tie For First Place	Incremental Bidding Options - Total Event Allow - Tie For First Place	FALSE	FALSE
30	Incremental Bidding Options - Total Event - Require To Improve - Size	Incremental Bidding Options - Total Event - Require To Improve - Size	FALSE	FALSE
31	Incremental Bidding Options - Total Event - Size	Incremental Bidding Options - Total Event - Size	FALSE	FALSE
32	Incremental Bidding Options - Total Event - Size Total	Incremental Bidding Options - Total Event - Size Total	FALSE	FALSE
33	Suppliers See	Suppliers See	FALSE	FALSE	string(255)
34	Automatic Bid Extensions	Automatic Bid Extensions	FALSE	FALSE	boolean
35	Competitive Bidding	Competitive Bidding	FALSE	FALSE	boolean
36	Currency Code	Currency Code	FALSE	FALSE
37	Banner Title	Banner Title	FALSE	FALSE	string(255)
38	Banner Text	Banner Text	FALSE	FALSE	text
39	Commodity Name	Commodity Name	FALSE	FALSE
40	Custom Field 1	Custom Field 1	FALSE	FALSE	string(255)
41	Custom Field 1	Custom Field 1	FALSE	FALSE	string(255)
42	Custom Field 3	Custom Field 3	FALSE	FALSE	string(255)
43	Custom Field 4	Custom Field 4	FALSE	FALSE	string(255)
44	Custom Field 5	Custom Field 5	FALSE	FALSE	string(255)
45	Custom Field 6	Custom Field 6	FALSE	FALSE	string(255)
46	Custom Field 7	Custom Field 7	FALSE	FALSE	string(255)
47	Custom Field 8	Custom Field 8	FALSE	FALSE	string(255)
48	Custom Field 9	Custom Field 9	FALSE	FALSE	string(255)
49	Custom Field 10	Custom Field 10	FALSE	FALSE	string(255)
50	Custom Field 11	Custom Field 11	FALSE	FALSE	string(255)
51	Custom Field 12	Custom Field 12	FALSE	FALSE	string(255)
52	Custom Field 13	Custom Field 13	FALSE	FALSE	string(255)
53	Custom Field 14	Custom Field 14	FALSE	FALSE	string(255)
54	Custom Field 15	Custom Field 15	FALSE	FALSE	string(255)
55	Custom Field 16	Custom Field 16	FALSE	FALSE	string(255)
56	Custom Field 17	Custom Field 17	FALSE	FALSE	string(255)
57	Custom Field 18	Custom Field 18	FALSE	FALSE	string(255)
58	Custom Field 19	Custom Field 19	FALSE	FALSE	string(255)
59	Custom Field 20	Custom Field 20	FALSE	FALSE	string(255)
60	Savings	Savings	FALSE	FALSE	decimal(32,4)
61	Weight Attachments Score	Weight Attachments Score (Points)	FALSE	FALSE	integer
62	Weight Questionnaires Score	Weight Questionnaires Score (Points)	FALSE	FALSE	integer
63	Weight Items Score	Weight Items Score (Points)	FALSE	FALSE	integer
64	Closed At State	Closed At State	FALSE	FALSE	string(255)
65	Allow Multiple Response	Allow Multiple Response	FALSE	FALSE	boolean
66	Sealed Bids	Sealed Bids	FALSE	FALSE	boolean
67	Item Required Fields	Item Required Fields	FALSE	FALSE	text
68	Pause Start Time	Pause Start Time	FALSE	FALSE	datetime
69	Paused At State	Paused At State	FALSE	FALSE	string(255)
70	Creatable From Object ID	Creatable From Object ID	FALSE	FALSE	integer
71	Creatable From Object Type	Creatable From Object Type	FALSE	FALSE	string(255)
72	Followed From Event #	Followed From Event #	FALSE	FALSE	integer
73	Reporting Savings	Reporting Savings	FALSE	FALSE	decimal(32,4)
74	Next Revision Event ID	Next Revision Event ID	FALSE	FALSE	integer
75	Allow Award Individual Line Items	Allow Award Individual Line Items	FALSE	FALSE	boolean
76	Event Timezone	Event Timezone	FALSE	FALSE	string(255)
77	End At Price	End At Price	FALSE	FALSE	decimal(30,6)
78	Max Number Of Steps	Max Number Of Steps	FALSE	FALSE	integer
79	Price Increase Interval	Price Increase Interval	FALSE	FALSE	integer
80	Planned Savings	Planned Savings	FALSE	FALSE	decimal(30,6)
81	Reporting Planned Savings	Reporting Planned Savings	FALSE	FALSE	decimal(30,6)
82	Allow Suppliers To Choose Currency	Allow Suppliers To Choose Currency	FALSE	FALSE	boolean
83	Sealing Type	Sealing Type	FALSE	FALSE	integer	one_step_unsealing, two_steps_unsealing
84	Sealing Stage	Sealing Stage	FALSE	FALSE	integer	all_envelopes_sealed, envelope1_unsealed, envelope2_unsealed
85	Base Price Calculation Method	Base Price Calculation Method	FALSE	FALSE	integer
86	Cost Avoidance	Cost Avoidance	FALSE	FALSE	decimal(30,4)
87	Public	Public	FALSE	FALSE	boolean
88	Allow Supplier To Send Attachments	Allow Supplier To Send Attachments	FALSE	FALSE	boolean
89	Allow Evaluators To View Event	Allow Evaluators To View Event	FALSE	FALSE	boolean
90	Related Requisitions	Related Requisitions	FALSE	FALSE
91	Related Contracts	Related Contracts	FALSE	FALSE
92	Related Orders	Related Orders	FALSE	FALSE
93	Related Invoices	Related Invoices

Quote Request Line columns

Columns with line-level details for a Sourcing event.

Position	Column Name	Description	Req/Unique	Unique	Type
1	Quote Request Line	Quote Request Line	FALSE	FALSE
2	Quote Request Line Id	Quote Request Line Id	FALSE	FALSE	integer
3	Created At Date	Created At Date	FALSE	FALSE	datetime
4	Created by ID	Created by ID	FALSE	FALSE	integer
5	Updated At Date	Updated At Date	FALSE	FALSE	datetime
6	Updated by ID	Updated by ID	FALSE	FALSE	integer
7	Event #	Event #	FALSE	FALSE	integer
8	Type	Type	TRUE	FALSE	string(255)
9	Quantity	Quantity	FALSE	FALSE	decimal(30,6)
10	UOM	UOM	FALSE	FALSE	integer
11	Position	Position	FALSE	FALSE	integer
12	Price Amount	Price Amount	FALSE	FALSE	decimal(30,6)
13	Price Currency Code	Price Currency Code	FALSE	FALSE	integer
14	Item ID	Item ID	FALSE	FALSE	integer
15	Description	Description	FALSE	FALSE	string(255)
16	Ship To Address ID	Ship To Address ID	FALSE	FALSE	integer
17	Ship To Address Street Line 1	Ship To Address Street Line 1	FALSE	FALSE
18	Ship To Address Street Line 2	Ship To Address Street Line 2	FALSE	FALSE
19	Ship To Address City	Ship To Address City	FALSE	FALSE
20	Ship To Address State/Province	Ship To Address State/Province	FALSE	FALSE
21	Ship To Address Postal Code	Ship To Address Postal Code	FALSE	FALSE
22	Ship To Address Country Code	Ship To Address Country Code	FALSE	FALSE
23	Ship To Address Location Code	Ship To Address Location Code	FALSE	FALSE
24	Reporting Price Amount	Reporting Price Amount	FALSE	FALSE	decimal(30,6)
25	Lot ID	Lot ID	FALSE	FALSE	integer
26	Commodity Name	Commodity Name	FALSE	FALSE	integer
27	Weight	Weight	FALSE	FALSE	integer
28	Creatable From Object ID	Creatable From Object ID	FALSE	FALSE	integer
29	Creatable From Object Type	Creatable From Object Type	FALSE	FALSE	string(255)
30	Cost Formula ID	Cost Formula ID	FALSE	FALSE	integer
31	Initial Price	Initial Price	FALSE	FALSE	decimal(30,6)
32	Incremental Increase Unit	Incremental Increase Unit	FALSE	FALSE	string(255)
33	Incremental Increase	Incremental Increase	FALSE	FALSE	decimal(30,6)
34	Need By Date	Need By Date	FALSE	FALSE	datetime
35	Price Amount In Event Currency	Price Amount In Event Currency	FALSE	FALSE	decimal(30,6)
36	Form ID	Form ID	FALSE	FALSE	integer
37	Manually Entered Base Price	Manually Entered Base Price	FALSE	FALSE	boolean
38	Manufacturer Name	Manufacturer Name	FALSE	FALSE	string(255)
39	Manufacturer Part Number	Manufacturer Part Number	FALSE	FALSE	string(255)

Quote request user columns

Columns that detail the team from the buyer side.

Position	Column Name	Description	Req/Unique	Unique	Type	Allowable Values
1	Quote Request User	Quote Request User	FALSE	FALSE
2	Quote Request User Id	Quote Request User Id	FALSE	FALSE	integer
3	Quote Request ID	Quote Request ID	FALSE	FALSE	integer
4	User ID	User ID	FALSE	TRUE	integer
5	Attitude	Attitude	FALSE	TRUE	string(255)	creator, owner, watcher, evaluator
6	Evaluation State	Evaluation State	FALSE	FALSE	string(255)
7	Evaluation File	Evaluation File	FALSE	FALSE	string(255)
8	Evaluation Sections	Evaluation Sections	FALSE	FALSE	integer
9	Created At Date	Created At Date	FALSE	FALSE	datetime
10	Updated At Date	Updated At Date	FALSE	FALSE	datetime

Quote Response columns

Columns detailing supplier responses at the header level.

Position	Column Name	Description	Req/Unique	Unique	Type
1	Quote Response	Quote Response	FALSE	FALSE
2	Quote Response Header ID	Quote Response Header ID	FALSE	FALSE	integer
3	Created At Date	Created At Date	FALSE	FALSE	datetime
4	Created by ID	Created by ID	FALSE	FALSE	integer
5	Updated At Date	Updated At Date	FALSE	FALSE	datetime
6	Updated by ID	Updated by ID	FALSE	FALSE	integer
7	Event #	Event #	FALSE	FALSE	integer
8	Comments	Comments	FALSE	FALSE	text
9	Submitted At	Submitted At	TRUE	FALSE	datetime
10	Quote Supplier ID	Quote Supplier ID	FALSE	FALSE	integer
11	State	State	FALSE	FALSE	string(255)
12	Position	Position	FALSE	FALSE	integer
13	Type	Type	FALSE	FALSE	string(255)
14	Name	Name	TRUE	TRUE	string(255)
15	Track ID	Track ID	FALSE	FALSE	integer
16	Quote Response Status	Quote Response Status	FALSE	FALSE	integer
17	Updated By Supplier	Updated By Supplier	FALSE	FALSE	boolean
18	Is Bargain	Is Bargain	FALSE	FALSE	boolean
19	Best Total	Best Total	FALSE	FALSE	decimal(30,6)
20	Nearby Best Total	Nearby Best Total	FALSE	FALSE	decimal(30,6)
21	Is Best	Whether this response has the same price as the best response. This field is only valid for the best response from each supplier	FALSE	FALSE	boolean
22	Rank	The rank of the response. This field is only valid for the best response from each supplier	FALSE	FALSE	integer
23	Bid Total	Bid Total	FALSE	FALSE	decimal(30,6)
24	All Responded	All Responded	FALSE	FALSE	boolean
25	Awarded Supplier ID	The ID of the awarded master supplier record	FALSE	FALSE	integer
26	Awarded	Awarded	FALSE	FALSE
27	Promoted	Promoted	FALSE	FALSE	boolean

Quote response line columns

Columns that detail supplier responses at the line level.

Position	Column Name	Description	Req/Unique	Unique	Type
1	Quote Response Line	Quote Response Line	FALSE	FALSE
2	Quote Response Line Id	Quote Response Line Id	FALSE	FALSE	integer
3	Created At Date	Created At Date	FALSE	FALSE	datetime
4	Created by ID	Created by ID	FALSE	FALSE	integer
5	Updated At Date	Updated At Date	FALSE	FALSE	datetime
6	Updated by ID	Updated by ID	FALSE	FALSE	integer
7	Event Response ID	Event Response ID	FALSE	FALSE	integer
8	Event Request Line ID	Event Request Line ID	FALSE	FALSE	integer
9	Type	Type	FALSE	FALSE	string(255)
10	Quantity	Quantity	FALSE	FALSE	decimal(30,6)
11	Position	Position	FALSE	FALSE	integer
12	Price Amount	Price Amount	TRUE	FALSE	decimal(30,6)
13	Lot ID	Lot ID	FALSE	FALSE	integer
14	Weight	Weight	FALSE	FALSE	integer
15	Supplier Item Name	Supplier Item Name	FALSE	FALSE	string(255)
16	Item Part Number	Item Part Number	FALSE	FALSE	string(255)
17	Item Description	Item Description	FALSE	FALSE	text
18	Price Currency Code	Price Currency Code	FALSE	FALSE	integer
19	UOM	UOM	FALSE	FALSE	integer
20	Reporting Price Amount	Reporting Price Amount	FALSE	FALSE	decimal(30,6)
21	Lead Time	Lead Time	FALSE	FALSE	integer
22	Price Amount In Event Currency	Price Amount In Event Currency	TRUE	FALSE	decimal(30,6)
23	Form Response ID	Form Response ID	FALSE	FALSE	integer

Quote response status columns

Columns that detail supplier response status.

Position	Column Name	Description	Req/Unique	Unique	Type
1	Quote Response Status	Quote Response Status	FALSE	FALSE
2	Quote Response Status Id	Quote Response Status Id	FALSE	FALSE	integer
3	Name	Name	TRUE	TRUE	string(255)
4	Active	Active	FALSE	FALSE	boolean
5	Created At Date	Created At Date	FALSE	FALSE	datetime
6	Updated At Date	Updated At Date	FALSE	FALSE	datetime

Quote supplier columns

Columns that detail suppliers participating in the event.

Position	Column Name	Description	Req/Unique	Unique	Type
1	Quote Supplier	Quote Supplier	FALSE	FALSE
2	Quote Supplier ID	Quote Supplier ID	FALSE	FALSE	integer
3	Created At Date	Created At Date	FALSE	FALSE	datetime
4	Created by ID	Created by ID	FALSE	FALSE	integer
5	Updated At Date	Updated At Date	FALSE	FALSE	datetime
6	Updated by ID	Updated by ID	FALSE	FALSE	integer
7	Type	Type	FALSE	FALSE	string(255)
8	Supplier ID	Supplier ID	TRUE	FALSE	integer
9	Supplier Name	Supplier Name	TRUE	TRUE	string(255)
10	Supplier Email	Supplier Email	TRUE	FALSE	string(255)
11	Supplier Contact Name	Supplier Contact Name	FALSE	FALSE	string(255)
12	Supplier Display Name	Supplier Display Name	FALSE	FALSE	string(255)
13	Event Request ID	Event Request ID	FALSE	FALSE	integer
14	Supplier Default locale	Supplier Default locale	FALSE	FALSE	string(255)
15	Emailed	Emailed	FALSE	FALSE	boolean
16	Changes Review Confirmed	Changes Review Confirmed	FALSE	FALSE	boolean
17	Revision Changes Reviewed	Revision Changes Reviewed	FALSE	FALSE	boolean
18	Terms Accepted	Terms Accepted	FALSE	FALSE	boolean