Order Confirmation Import

Order Confirmation

Field Name	Required Field	Unique?	Field Type	Field Description	Possible Values
Header	No	No		Header
PO number	No	No		PO number
Action On Behalf of Supplier	No	No		Action On Behalf of Supplier
Reason Code	No	No		Reason Code
Reason Comment	No	No		Reason Comment
Line	No	No		Line
Order Line Number	No	No		Order Line Number
Action On Behalf of Supplier	No	No		Action On Behalf of Supplier
Quantity On Behalf of Supplier	No	No		Quantity On Behalf of Supplier
Price On Behalf of Supplier	No	No		Price On Behalf of Supplier
Promise date On Behalf of Supplier	No	No		Promise date On Behalf of Supplier
Item On Behalf of Supplier	No	No		Item On Behalf of Supplier
Supplier Part Number On Behalf of Supplier	No	No		Supplier Part Number On Behalf of Supplier
Supplier Auxiliary Part Number On Behalf of Supplier	No	No		Supplier Auxiliary Part Number On Behalf of Supplier
Manufacturer Name On Behalf of Supplier	No	No		Manufacturer Name On Behalf of Supplier
Manufacturer Part Number On Behalf of Supplier	No	No		Manufacturer Part Number On Behalf of Supplier
UOM Code On Behalf of Supplier	No	No		UOM Code On Behalf of Supplier
Schedule Line	No	No		Schedule Line
Schedule Line Reference	No	No		Schedule Line Reference
Delivery Date On Behalf of Supplier	No	No		Delivery Date On Behalf of Supplier

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

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

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

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,,