• Last edited on: 26 May 2022

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
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
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 Allowable Values
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

Related Items


Sourcing Quote Response Export

26 May 2022

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

Sourcing Export

16 August 2022

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

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.