Order Confirmation Import
Order Header Confirmations
Column Name | Description | Data Type | Required | Allowable Values |
---|---|---|---|---|
Header | Always has the same value as Header | String | Yes | Header |
PO number | Coupa PO Number that is available in the CSP portal | String(20) | Yes | any |
Action | Three actions are supported in total: accept, reject, and line_level where line_level means confirmation details will be provided at the line level and not the header level | String | Yes | accept, reject or line_level |
Reason Code | Reason code is required only if rejecting the confirmation | String(255) | No | any |
Reason Comment | Comment is required only if rejecting the confirmation | String | No | any |
Order Line Confirmations
Column Name | Description | Data Type | Required | Allowable Values |
---|---|---|---|---|
Line | Always has the same value as Line | String | Yes | Line |
Line Number | Coupa PO Line Number that is being cofirmed | String | Yes | any |
Action | Three actions are supported in total: accept, reject, and propose change | String | Yes | accept, reject, propose_change |
Quantity | Quantity that is being confirmed | decimal(30,6) | No | any |
Price | Price that is being confirmed | decimal(30,6) | No | any |
Promise Date | Delivery date of the goods | Date | No | any |
Reason Code | Reason code is required only if rejecting the line | String(255) | No | any |
Reason Comment | Comment is required only if rejecting the line | String | No | any |
Schedule Lines
Column Name | Description | Data Type | Required | Allowable Values |
---|---|---|---|---|
Schedule Line | Always has the same value as Schedule Line | String | Yes | Schedule Line |
Order Line Number | Coupa PO Line Number that is being confirmed | String | Yes | any |
Id | ||||
Action | Three actions are supported in total: add, update, and delete | String | Yes | add, update, delete |
Quantity | Quantity that wil be delivered for this specific schedule line | decimal(30,6) | Yes | any |
Delivery Date | Delivery date for the quantity mentiond in the schedule line | Date | Yes | any |
Order Confirmation CSV Example
Header,PO number,Action,Reason Code,Reason Comment
Line,Line Number,Action,Quantity,Price,Promise date,Reason Code,Reason Comment
Schedule Line,Order Line Number,Id,Action,Quantity,Delivery Date
Header,3175,line_level,,,,,
Line,1,propose_change,24,20,6/15/23,Out of stock,preparing them
Line,2,propose_change,123,230,,Out of stock,preparing them
Schedule Line,2,,add,100,6/20/23,,
Schedule Line,2,,add,23,6/22/23,,