Order Confirmation (ORDRSP)

Order Confirmation (ORDRSP) is a customer order confirmation that the supplier sends to its customer.

This message has two types of rows:

Order confirmation header row
Order confirmation line row

Data type	COLUMN	Send Message					Receive Message
Data type	COLUMN	Value	Description	SIZE	M/N/C*	COMMENT	Value	Description	SIZE	M/N/C*	COMMENT
NUMBER	MESSAGE_ID (FK)	EDI message ID	Unique ID of message generated by IFS Connectivity				EDI message ID	Unique ID of message generated by IFS Connectivity
NUMBER	MESSAGE_LINE	Row of message	Header should always be row number 1				Row of message	Header should always be row number 1
VARCHAR2	NAME	Header	Type of message line				Header	Type of message line
VARCHAR2	ERROR_MESSAGE	Error message for line	Generated by EDI converter				Error message for line	Generated by EDI converter
VARCHAR2	C00	ORDER_NO	Order number	12	M		SUPPLIER_ORDER_NO	The customer order number	15	N
VARCHAR2	C01	CUSTOMER_PO_NO	Customer's PO number	12	N		ORDER_NO	Purchase order number	12	M
VARCHAR2	C02	CONTRACT	Customer's site (used for internal order)	5	N		CONTRACT	Site where the purchase order is placed.	2000	N
VARCHAR2	C03	SALESMAN	Supplier's salesperson	100	N		SALESMAN	Supplier's salesperson on the ordering site	2000	N
VARCHAR2	C04	AUTHORIZER	Authorizer (Name)	100	M
VARCHAR2	C05	CUSTOMER_NO	Supplier's ID of customer	20	M
VARCHAR2	C06	VAT	TAX (Coded)	50	N
VARCHAR2	C07	SHIP_ADDR_NO	Supplier's address number (Document address)	50	N
VARCHAR2	C08	CURRENCY_CODE	Customer currency	3	M
VARCHAR2	C09	DELIVERY ADDRESS	Customer's name for delivery address	35	N				35	N
VARCHAR2	C10	ADDR1	Delivery address 1	35	N				35	N
VARCHAR2	C11	ADDR2	Delivery address 2	35	N				35	N
VARCHAR2	C12	ZIP_CODE	Delivery zip code	35	N				35	N
VARCHAR2	C13	CITY	Delivery city	35	N				35	N
VARCHAR2	C14	STATE	Delivery state	35	N				35	N
VARCHAR2	C15	COUNTRY CODE	Customer's country code	2	N				2	N
VARCHAR2	C16	CUSTOMER_NO_PAY	Supplier's customer number for payer	20	N
VARCHAR2	C17	CUSTOMER_NO_PAY_ADDR_NO	Payer address number (Document address)	50	C	The value is from customer_order_tab.CUSTOMER_NO_PAY_ADDR_NO which is mandatory when customer_Order_tab.customer_no_pay is having a value. Refer customer_Order_api.Unpack_Check_Insert___ .
VARCHAR2	C18	CUST_REF	Customer Reference	30	N
VARCHAR2	C19	PAY_TERM_ID	ID of payment terms (Coded)	20	N
VARCHAR2	C20	DELIVERY_TERMS_DESC	Delivery terms description	35	M
VARCHAR2	C21	SHIP_VIA_DESC	Ship via description	35	N
VARCHAR2	C22	FORWARD_AGENT	Forward agent	20	N
VARCHAR2	C23	LABEL_NOTE	Label note (Full text)	50	N		LABEL_NOTE	Label note (Full text)	2000	N
VARCHAR2	C25	FAX	Supplier fax number	200	N		FAX	Supplier fax number	200	N
VARCHAR2	C26	PHONE	Supplier phone number	200	N		PHONE	Supplier phone number	200	N
VARCHAR2	C27	POSTAL_ADDRESS	Supplier postal address	215	N
VARCHAR2	C28	POST	Supplier Postal giro account	200	N
VARCHAR2	C29	BANK	Supplier bank giro account	200	N
VARCHAR2	C30	COMPANY	Supplier's company name	35	M
VARCHAR2	C31	COMPANY_COUNTRY	Supplier's company country	35	N
VARCHAR2	C32	OUR_SUPPLIER_NO	Supplier's ID at customer	20	N		OUR_SUPPLIER_NO	Supplier's ID at customer	2000	N
VARCHAR2	C33	NOTE_ID	Header document text	2000	N		HEADER_NOTE	Header document text	2000	N
VARCHAR2	C34	AGREEMENT_NOTE_ID	Agreement note ID	2000	N
VARCHAR2	C35	CUSTOMER_NOTE	Customer document text		N
VARCHAR2	C36	RECEIVER ADDRESS	Customer's EDI address	200	M				255
VARCHAR2	C37	MESSAGE_TYPE	In this case, "ORDRSP"	30	N		MESSAGE_TYPE	In this case, "ORDRSP"	30	N	Applicable only for EDI/MHS
VARCHAR2	C38	MEDIA_CODE	Way of communication (EDI, MHS, etc)	30	N		MEDIA_CODE	Way of communication (EDI, MHS, etc)	30	N	Applicable only for EDI/MHS
VARCHAR2	C39	EAN_ DOC_ADDR	EAN location no. for customer document address	100	N
VARCHAR2	C40	EAN_ DEL_ADDR	EAN location no. for customer delivery address	100	N
VARCHAR2	C41	EAN_ PAY_ADDR	EAN location no. for payer document address	100	N
VARCHAR2	C42	ORDRSP_STATUS	Type of order response	30	M
VARCHAR2	C43	COUNTY	Delivery County
VARCHAR2	C49	DEL_TERMS_LOCATION		100	N
VARCHAR2	C86	PAY_TERM_DESC	Payment terms description	100
VARCHAR2	C94	EMAIL	Supplier email address	200	N		EMAIL	Supplier email address	200	N
VARCHAR2	C95	COMPANY_ASSOCIATION_NO	Supplier's Company Association number	50	N		COMPANY_ASSOCIATION_NO	Supplier's Company Association number	50	N
VARCHAR2	C96	CUSTOMER_ASSOCIATION_NO	Customer's Association number	50	N		CUSTOMER_ASSOCIATION_NO	Customer's Association number	50	N
DATE	D00	DATE_ENTERED	Creation date of order		M
DATE	D01	WANTED_DELIVERY_DATE	Wanted delivery date		M
NUMBER	N00	DELIVERY LEADTIME	Delivery lead time	3	M
	N20	MESSAGE_SEQUENCE_NO			M
	N21	MESSAGE_SEQUENCE_NO			M
VARCHAR2	STATE	Status of message line	Handled by IFS Connectivity				STATE	Status of message line

* States whether a value in the field is mandatory (M), non-mandatory (N), or conditional (C).

Order Confirmation Line Row

Data type	COLUMN	Send Message					Receive Message
Data type	COLUMN	Value	Description	SIZE	M/N/C*	COMMENT	Value	Description	SIZE	M/N/C*	COMMENT
NUMBER	MESSAGE_ID (FK)	EDI message ID	Unique ID of message generated by IFS Connectivity				EDI message ID	Unique ID of message generated by IFS Connectivity
NUMBER	MESSAGE_LINE	Row of message	Each message can hold several lines				Row of message	Each message can hold several lines
VARCHAR2	NAME	Row	Type of message line				Row	Type of message line
VARCHAR2	ERROR_MESSAGE	Error message for line	Generated by EDI converter				Error message for line	Generated by EDI converter
VARCHAR2	C00	ORDER_NO	Supplier's order number (CO)	12	M		SUPPLIER_ORDER_NO	Customer order number	2000	N
VARCHAR2	C01	CUSTOMER_PO_NO	Customer's PO number	12	N		ORDER_NO	Purchase order number	12	M
VARCHAR2	C02	LINE_NO	Customer's PO line number	4	M		LINE_NO	Purchase order line number	4	M
VARCHAR2	C03	REL_NO	Customer's PO release number of row	4	M		REL_NO	Purchase order release number	4	M
VARCHAR2	C04	CATALOG_NO	Supplier part number	25	M		SUPPLIER_PART_NO	Part number the supplier uses for the purchase part
VARCHAR2	C05	CATALOG_DESC	Supplier description of sales part	200	N
VARCHAR2	C06	SALES_UNIT_MEAS	Supplier sales unit meas.		N		SALES_UNIT_MEAS	The purchase unit of measure for this part.		2000	N
VARCHAR2	C07	PRICE_UNIT_MEAS	Supplier price unit meas.		N		PRICE_UNIT_MEAS	The price unit of measure used for the part as specified by the supplier.		2000	N
VARCHAR2	C08	CURRENCY_CODE	Supplier currency code
VARCHAR2	C09	NOTE_ID	Row document text	2000	N		DETAIL_NOTE	Row document text	2000	N
VARCHAR2	C10	BLANKET_DETAIL_NOTE	Blanket row document text	3	M
VARCHAR2	C11	CUSTOMER_PART_NO	Customer ID of sales part	45	N
VARCHAR2	C12	CUSTOMER_PART_UNIT_MEAS	Customer unit of measure.	10	N
VARCHAR2	C13	ORDRSP_STATUS	Type of order response line	30	M		SUPPLIER_RESPONSE	Type of response	2000	M
VARCHAR2	C14	CLASSIFICATION_STANDARD	Classification Standard No(Supplier Site Internal CO information)	25	N		CLASSIFICATION_STANDARD
VARCHAR2	C15	CLASSIFICATION_PART_NO	Classification part no(Supplier Site Internal CO information)	25	N		CLASSIFICATION_PART_NO
VARCHAR2	C16	CLASSIFICATION_UNIT_MEAS		10	N		CLASSIFICATION_UNIT_MEAS
VARCHAR2	C17	GTIN_NO	The default GTIN of the part	14	N		GTIN_NO
VARCHAR2	C18	SHIP_VIA_CODE	Ship via code	3	M	Sent for demand code Internal Purchase Direct (IPD) or Internal Purchase Transit (IPT)	SHIP_VIA_CODE	Ship via code			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, both the purchase order line and pegged customer order line is updated with this value.For the supply code Internal Purchase Transit the purchase order line is updated with this value
VARCHAR2	C19	FORWARDER_ID	Forwarder agent	20	N	Sent for demand code Internal Purchase Direct (IPD) or Internal Purchase Transit (IPT)	FORWARDER_ID	Forwarder agent			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, both the purchase order line and pegged customer order line is updated with this value.For the supply code Internal Purchase Transit the purchase order line is updated with this value
VARCHAR2	C20	ROUTE_ID	Route ID	12	N	Sent for demand code Internal Purchase Direct (IPD)	ROUTE_ID	Route ID			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, the pegged customer order line is updated with this value.
VARCHAR2	C21	PACKING_INSTRUCTION_ID	The packing instruction ID		N	Sent for demand code Internal Purchase Direct (IPD)	PACKING_INSTRUCTION_ID	External transport calendar			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, the pegged customer order line is updated with this value. It is used to confirm to the external customer how parts should be packed on a shipment.
VARCHAR2	C22	EXT_TRANSPORT_CALENDAR_ID	External transport calendar	20	N	Sent for demand code Internal Purchase Direct (IPD)	EXT_TRANSPORT_CALENDAR_ID	External transport calendar			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, both the purchase order line and pegged customer order line is updated with this value.
VARCHAR2	C23	DELIVERY_TERMS	Delivery terms	5	N	Sent for demand code Internal Purchase Direct (IPD) or Internal Purchase Transit (IPT)	DELIVERY_TERMS	Delivery terms			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, both the purchase order line and pegged customer order line is updated with this value.For the supply code Internal Purchase Transit the purchase order line is updated with this value
VARCHAR2	C24	DEL_TERMS_LOCATION	Delivery Terms Locations	100	N	Sent for demand code Internal Purchase Direct (IPD) or Internal Purchase Transit (IPT)	DEL_TERMS_LOCATION	Delivery Terms Locations			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, both the purchase order line and pegged customer order line is updated with this value.For the supply code Internal Purchase Transit the purchase order line is updated with this value
DATE	D00	PLANNED_DELIVERY_DATE	Planned delivery date / part		M		PLANNED_DELIVERY_DATE	The date on which the goods are planned to be delivered at the receivers address, as specified on the purchase order line.		M
DATE	D01	WANTED_DELIVERY_DATE	Original customer desired delivery date		N		ORIGIN_DESIRED_DATE	Original wanted date		N
DATE	D02	PLANNED_RENTAL_START_DATE			C	Applicable only for rental lines	PLANNED_RENTAL_START_DATE			C	Applicable only for rental lines
DATE	D03	PLANNED_RENTAL_END_DATE			C	Applicable only for rental lines	PLANNED_RENTAL_END_DATE			C	Applicable only for rental lines
DATE	D04	ORG_RENTAL_START_DATE			C	Applicable only for rental lines	ORG_RENTAL_START_DATE			C	Applicable only for rental lines
DATE	D05	ORG_RENTAL_END_DATE			C	Applicable only for rental lines	ORG_RENTAL_END_DATE			C	Applicable only for rental lines
NUMBER	N00	BUY_QTY_DUE	Buy quantity due in sales units		M		BUY_QTY_DUE	The quantity of parts that could be delivered.		M
NUMBER	N01	ORIGIN_SALES_QUANTITY	Origin buy quantity due in sales units		N		ORIGIN_SALES_QUANTITY	The quantity of parts originally ordered, expressed in purchase unit of measure.		N
NUMBER	N02	SALE_UNIT_PRICE	Sale unit price in customer currency		M		SALES_UNIT_PRICE	The price per purchase unit in base currency		M
NUMBER	N03	BASE_SALE_UNIT_PRICE	Base sale unit price in supplier currency		M
NUMBER	N04	PRICE_CONV_FACTOR	= # PRICE_UNIT_MEAS / # BUY_UNIT_MEAS		M
NUMBER	N05	CURRENCY_RATE	Currency rate
NUMBER	N06	DISCOUNT	Discount		M		DISCOUNT	Discount		N
NUMBER	N07	CUSTOMER_PART_BUY_QTY	Quantity sold, expressed in customer's unit of measure		N
NUMBER	N08	Customer_PRICE_currency	Net amount in order currency		N
NUMBER	N09	GROUP_DISCOUNT	Group discount percentage
NUMBER	N10	ADDITIONAL_DISCOUNT	Additional discount percentage
NUMBER	N11	DISCOUNT_AMOUNT	Discount amount in order currency
NUMBER	N12	TOTAL_DISCOUNT	Total discount percentage		N		TOTAL_DISCOUNT	Total discount percentage		N
NUMBER	N13	INPUT_QTY	Input Qty from CO.		N		INPUT_QTY
NUMBER	N14	CUSTOMER_PART_CONV_FACTOR	Customer's part conversion factor		N		CUSTOMER_PART_CONV_FACTOR	Customer's part conversion factor			Used to calculate price on purchase order.
NUMBER	N15	DELIVERY_LEADTIME	External transport lead time		C	Sent for demand code Internal Purchase Direct (IPD)	DELIVERY_LEADTIME	External transport lead time			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, the pegged customer order line is updated with this value.
NUMBER	N16	UNIT_PRICE_INCL_TAX	Sale unit price including tax in customer currency		M		SALES_UNIT_PRICE_INCL_TAX		N
NUMBER	N17	BASE_UNIT_PRICE_INCL_TAX	Base sale unit price including tax in supplier currency		M						.
NUMBER	N18	GROSS_CURR_AMOUNT	Gross Amt/Curr		N			External transport lead time			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, the pegged customer order line is updated with this value.
NUMBER	N19	PICKING_LEADTIME	Picking lead time		C		PICKING_LEADTIME	Picking lead time			When purchase order line is pegged to a customer order line having supply code Internal Purchase Direct, the pegged customer order line is updated with this value.
VARCHAR2	STATE	Status of message line	Handled by IFS Connectivity				Status of message line	Handled by IFS Connectivity

* States whether a value in the field is mandatory (M), non-mandatory (N), or conditional (C).