Sourcing 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 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 | 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 |
Quote Response columns
Columns detailing supplier responses at the header level.
Position | Column Name | Description | Req/Unique | Unique | Type | Allowable Values |
---|---|---|---|---|---|---|
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 | Allowable Values |
---|---|---|---|---|---|---|
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 | Allowable Values | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | Allowable Values |
---|---|---|---|---|---|---|
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 |