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

Sourcing Quote Request Export

Coupa's Sourcing flat file integration objects include various details of Sourcing event records.

Sourcing exports include various details of Sourcing event records.

Quote request header 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	string(6)
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	integer	A comma (,) separated list of Requisitions IDs within brackets []. For example: [123, 234]
91	Related Contracts	Related Contracts	FALSE	FALSE	integer	A comma (,) separated list of Requisitions IDs within brackets []. For example: [123, 234]
92	Related Orders	Related Orders	FALSE	FALSE	integer	A comma (,) separated list of Requisitions IDs within brackets []. For example: [123, 234]
93	Related Invoices	Related Invoices			integer	A comma (,) separated list of Requisitions IDs within brackets []. For example: [123, 234]
94	Hidden	Hidden	FALSE	FALSE
95	Template ID	Template ID	FALSE	FALSE	integer	any

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	string(255)
18	Ship To Address Street Line 2	Ship To Address Street Line 2	FALSE	FALSE	string(255)
19	Ship To Address City	Ship To Address City	FALSE	FALSE	string(255)
20	Ship To Address State/Province	Ship To Address State/Province	FALSE	FALSE	string(255)
21	Ship To Address Postal Code	Ship To Address Postal Code	FALSE	FALSE	string(255)
22	Ship To Address Country Code	Ship To Address Country Code	FALSE	FALSE	string(4)
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	string(255)
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