Purchase Orders (ORDERS)

Purchase Orders (ORDERS) message is used to send a purchase order to the supplier and to receive a customer order from the customer.

This message has five types of rows:

Order header row
Order line row
Order configuration line row
Package component line row
Package Component Configuration Line Row

Order Header Row

Data type	Column	Send Message					Receive Message
Data type	Column	Value	Description	SIZE	M/N/C*	COMMENTS	Value	Description	SIZE	M/N/C*	COMMENTS
NUMBER	MESSAGE_ID (FK)	EDI message ID	Unique ID of message generated by IFS Connectivity
NUMBER	MESSAGE_LINE	Row of message	Header should always be row number 1
VARCHAR2	NAME	Header	Type of message line
VARCHAR2	ERROR_MESSAGE	Error message for line	Generated by EDI converter
VARCHAR2	C00	ORDER_NO	Purchase Order number	12	M		INTERNAL_PO_NO	The order number of the corresponding internal purchase order, for internal customer orders.	12	N
VARCHAR2	C01	ACQUISITION_SITE	Supplier site (used for internal order)	5	N		CONTRACT	Site used for the order	5	C	In ORDERS message if receiving contact is null get the value from CUST_ORD_CUSTOMER_TAB.edi_site(nullable) . But insert the value into Customer_Order_Tab.contract which is a not null column. Hence if CUST_ORD_CUSTOMER_TAB.edi_site is null it is required to receive the value from the message. In ORDCHG message this no use for CO hence only stored in ext_cust_order_change_tab.contract is a NULLable column
VARCHAR2	C02	BUYER	Customer's buyer	100	M
VARCHAR2	C03	AUTHORIZER_CODE	PO Coordinator	20	M
VARCHAR2	C04	VENDOR_NO	Supplier's ID (for customer)	20	M				20
VARCHAR2	C05	ADDR_NO	Supplier's address number (Document address)	50	M				50
VARCHAR2	C06	CURRENCY_CODE	Supplier's currency	3	M		CURRENCY	The currency in which the customer is being charged	3	N
VARCHAR2	C07	DLY_ADDR_NAME	Delivery address Name	100	N		DELIVERY_ADDRESS_NAME	Customer’s delivery address name	100	N
VARCHAR2	C08	DLY_ADDR1	Address 1	35	N		SHIP_ADDRESS1	Delivery address 1	35	N
VARCHAR2	C09	DLY_ADDR2	Address 2	35	N		SHIP_ADDRESS2	Delivery address 2	35	N
VARCHAR2	C10	DLY_ADDR3	Postal code	35	N		SHIP_ZIP CODE	Delivery zip code	35	N
VARCHAR2	C11	DLY_ADDR4	City	35	N		SHIP_CITY	Delivery city	25	N
VARCHAR2	C12	DLY_ADDR5	State	35	N		SHIP_STATE	Delivery state	35	N
VARCHAR2	C49	DLY_ADDR6	County				SHIP_COUNTY	Delivery county
VARCHAR2	C13	COUNTRY_CODE	Country code	2	C	In Sending header(c13) if single occurance the value is taken from Purchase_Order_tab.country_code is a nullable column but if not single occurance this is mendatory as COMPANY_ADDRESS_TAB.country is a NOT NULL column. In send PO Line (c23) if single occurance the value is from pur_order_line_address_tab.country_code is a nullable column but if not single occurance this is mendatory as COMPANY_ADDRESS_TAB.country is a Not Null column.	COUNTRY_CODE	Delivery country code	2	N
VARCHAR2	C14	PO_REF/CONTACT	Company contact person	100	N		INTERNAL_REF	Customer's reference	30	N
VARCHAR2	C15	DELIVERY_TERMS_DESC	Delivery terms description	35	M		DELIVERY_TERMS_DESC	Delivery terms description	35	N
VARCHAR2	C16	SHIP_VIA_DESC	Ship via description	35	M		SHIP_VIA_DESC	Ship via description	35	N
VARCHAR2	C17	FORWARDER_ID	Forward agent	20	N		FORWARD_AGENT_ID	Forward agent	20	N
VARCHAR2	C18	LABEL_NOTE	External CO label note	50	N	If at least one purchase order line is pegged to a customer order line having supply code Internal Purchase Direct (IPD), the value is taken from the external label note of pegged customer order. If the label note is NULL in the purchase order and any purchase order line is pegged to a customer order line having Purchase Direct (PD) or Purchase Transit (PT), the value is taken from the external label note of pegged customer order. Otherwise if the header order code does not equal 4, the value is taken from the label note in the purchase order.	LABEL_NOTE	External CO label note	50	N
VARCHAR2	C19	BLANKET_ORDER	Customer's blanket number	12	N
VARCHAR2	C20	COMPANY_FAX	Customer's fax number	200	N		COMPANY_FAX	Customer's fax number	200	N
VARCHAR2	C21	COMPANY_PHONE	Customer's phone number	200	N		COMPANY_PHONE	Customer's phone number	200	N
VARCHAR2	C22	POSTAL_ADDRESS	Customer's postal address (Full address)	180	N
VARCHAR2	C23	COMPANY_NAME	Customer's company name	100	M
VARCHAR2	C24	COMPANY_COUNTRY	Customer's company country	35	N
VARCHAR2	C25	CUSTOMER_NO	Customer's ID at supplier	20	N		CUSTOMER_NO	Customer who sent PO	20	C	When INTERNAL_CUSTOMER_SITE (c39) is not received, CUSTOMER_NO (c25) and EAN_LOCATION_DEL_ADDR (c33) are used to identify the address, with priority given to CUSTOMER_NO.
VARCHAR2	C26	HEADER_NOTE	Header document text	2000	N		NOTE_TEXT	Document text entered on the purchase order header	2000	N
VARCHAR2	c27	BLANKET_HEADER_NOTE	Supplier Agreement header document text	2000	N
VARCHAR2	C29	RECEIVER_ADDRESS	Supplier's EDI address	255					255
VARCHAR2	C30	MESSAGE_CLASS	In this case, "ORDERS"	30					30
VARCHAR2	C31	MEDIA_CODE	Way of communication (EDI, MHS, etc)	30					30
VARCHAR2	C32	EAN_SUPPLIER_DOCUMENT_ADDRESS		100	N
VARCHAR2	c33	EAN_LOCATION_DEL_ADDR	EAN location no. for your delivery address	100	N		EAN_LOCATION_DEL_ADDR	EAN location no. for customer's delivery address	100	N
VARCHAR2	c34	EAN_LOC_DOC_ADDR	EAN location no. for your document address	100	N		EAN_LOC_DOC_ADDR	EAN Loc. No for customer's document address	100	N
VARCHAR2	c35						CUSTOMER_NO_PAY	ID of the customer to be invoiced instead of the ordering customer	20	N	When a value is received also with a CUSTOMER_NO_PAY_ADDR_NO (c36), priority is given to CUSTOMER_NO_PAY to select the invoice address. If no address exists with received CUSTOMER_NO_PAY_ADDR_NO for the received CUSTOMER_NO_PAY, the default address is used.
VARCHAR2	C36						CUSTOMER_NO_PAY_ADDR_NO	EAN location number of the customer to be invoiced instead of the ordering customer.	2000	C	When a value is received also with a CUSTOMER_NO_PAY (c35), priority is given to CUSTOMER_NO_PAY to select the invoice address. If no address exists with received CUSTOMER_NO_PAY_ADDR_NO for the received CUSTOMER_NO_PAY, the default address is used.
VARCHAR2	C37	ORDER_CODE	Type of order (Internal direct or transit etc.)	3	M		INTERNAL DELIVERY_TYPE	Type of order (Internal direct or transit etc.)	3	N
VARCHAR2	C38	CUSTOMER_PO_NO	The purchase order number of the customer	50	N	If at least one purchase order line is pegged to a customer order line having supply code Internal Purchase Direct (IPD), the value is taken from the Customer's PO No of the pegged customer order. Otherwise if all purchase order lines are pegged to customer order lines having Internal Purchase Transit (IPT), the value is taken from the Customer's PO No of pegged customer order unless NULL then the purchase order number is passed.	CUSTOMER_PO_NO	The purchase order number of the customer	50	N
VARCHAR2	C39	CONTRACT	Ordering site	5	C	Sending value only if supplier_catagery = 'Internal'. Value Purchase_Order_Tab.contract is NOT NULL column	INTERNAL_CUSTOMER_SITE	Site connected to customer (used for internal order)	5	N
VARCHAR2	C40	VENDOR_NO		15	N
VARCHAR2	C41	PAY_TERM_ID	Payment terms ID	20	C	Sends value of Purchase_Order__tab.pay_term_id(NOT NULL) only if PO Order_Code = 1 or 4	PAY_TERM_ID	Payment terms ID	20	N
VARCHAR2	C42	DELIVERY_TERMS	Delivery terms ID	3	C	Sends value of Purchase_Order__tab.delivery_terms(NOT NULL) only if PO Order_Code = 1 or 4	DELIVERY_TERMS	Delivery terms ID	3	M
VARCHAR2	C43	SHIP_VIA_CODE	Ship via code ID	3	C	Sends value of Purchase_Order__tab.ship_via_code(NOT NULL) only if PO Order_Code = 1 or 4	SHIP_VIA_CODE	Ship via code ID	3	N
VARCHAR2	C44						SALESMAN_CODE	Salesman identity	20	N
VARCHAR2	C45						LANGUAGE	Language code	2	N
VARCHAR2	C46						IMPORT_MODE	Default value is ORDER	15	M
VARCHAR2	C47						EXTERNAL_REF	A reference that is used to refer to the customer's system.	25	N
VARCHAR2	C48	ROUTE_ID	The ID of the route to be used for the delivery. This is only relevant when the purchase order line has the Internal Customer Direct demand code.	12			ROUTE_ID	The ID of the route to be used for the delivery. This is only relevant when the purchase order line has the Internal Customer Direct demand code.	12	N
VARCHAR2	C50	BACKORDER_OPTION_DB	Backorder option of the pegged customer order	40	C	If the purchase order is pegged to a customer order without any customer order lines having supply code Internal Purchase Transit (IPT), the value is taken from the pegged customer order.	BACKORDER_OPTION_DB	Backorder option of the pegged customer order	40	M	Determines how the order will be treated when performing reservations, when creating the pick list and when reporting picking.
VARCHAR2	C51	INTERNAL_DESTINATION	Internal destination ID	2000	N
VARCHAR2	C52	AUTHORIZER_NAME	PO coordinator name	100	M
VARCHAR2	C54	VAT_NO	Tax identity no				VAT_NO	The tax identity number for the customer.	50	N
VARCHAR2	C55	DEL_TERMS_LOCATION	Delivery terms location	100	N		DEL_TERMS_LOCATION	Delivery terms location	100	N
VARCHAR2	C56	PRINT_DELIVERED_LINES_DB	Show Only Delivered Lines in Delivery Note		N	If the purchase order is pegged to a customer order without any customer order lines having supply code Internal Purchase Transit (IPT), the value is taken from the pegged customer order.	PRINT_DELIVERED_LINES_DB	Show Only Delivered Lines in Delivery Note		N	Determines whether or not already delivered lines should be printed on the customer order delivery note and/or shipment delivery note.
VARCHAR2	C61	CONTACT or CUST_REF	References of the pegged customer order	30	N	If at least one purchase order line is pegged to a customer order line having supply code Internal Purchase Direct (IPD), the value is taken from the Reference of the pegged customer order header.	CUST_REF	References of the pegged customer order	30	N
VARCHAR2	C73	SHIPMENT_TYPE	Used in Transit Delivery to send any default shipment type between the sites.		N	If Order_Code = 4, sends the default shipment type between the sites.	SHIPMENT_TYPE	Used in Transit Delivery to send any default shipment type between the sites.		N
VARCHAR2	C85	LABEL_NOTE	The label note in the purchase order header	50	N		LABEL_NOTE	The label note in the purchase order header	50	N
VARCHAR2	C86	PAY_TERM_DESC	Payment terms description	100
VARCHAR2	C94	COMPANY_EMAIL	Customer's email address	200	N		COMPANY_EMAIL	Customer's email address	200	N
VARCHAR2	C95	COMPANY_ASSOCIATION_NO	Customer's Company Association number	50	N		COMPANY_ASSOCIATION_NO	Customer's Company Association number	50	N
VARCHAR2	C96	SUPPLIER_ASSOCIATION_NO	Supplier's Association number	50	N		SUPPLIER_ASSOCIATION_NO	Supplier's Association number	50	N
DATE	D00	ORDER_DATE	Order creation date		M
DATE	D01	WANTED_RECEIPT_DATE	Wanted delivery date		M		DELIVERY_DATE	Date on which the customer wants the order to be delivered at the customer's delivery address.		M
DATE	D02	BLANKET_ORDER_DATE	Blanket date		C	if Purchase_Order_Tab.blanket_Order is NOT NULL then This is mandatory as it contains the value from SUPPLIER_BLANKET_TAB.blanket_order_date is a NOT NULL column
NUMBER	N00	REVISION	PO revision		M
VARCHAR2	N10	TRANSIT_DELIVERY_LEAD_TIME	Used in Internal Purch Direct Delivery and Transit Delivery leadtime on external CO		C	Sends value of vendor_delivery_leadtime_ from Pur_Order_Leadtime_Util_API.Get_Leadtime_Values always returns a value(NVL=0) only if PO Order_Code = 1 or 4	DELIVERY_LEADTIME	Used in Internal Purch Direct Delivery and Transit Delivery leadtime on external CO		N
NUMBER	N12	PICKING_LEAD_TIME	Used in Transit Delivery to send any default picking lead time between the sites.		C	If Order_Code = 4 (IPT), sends the default picking lead time between the sites.	PICKING_LEAD_TIME	Used in Transit Delivery to send any default picking lead time between the sites.
NUMBER	N20	SEQUENCE_NO	Orders message sequence number		M
NUMBER	N21	VERSION_NO	Orders message version number		M
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).

Order Line Row

Data type	COLUMN	Send Message					Receive Message
Data type	COLUMN	Value	Description	SIZE	M/N/C*	COMMENTS	Value	Description	SIZE	M/N/C*	COMMENTS
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		M		Row	Type of message line		M
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 (Customer PO number )	12	M				12	M
VARCHAR2	C01	LINE_NO	PO line number		M		LINE_NO	Customer order line number		M
VARCHAR2	C02	RELEASE_NO	PO release number of row	4	M		REL_NO	Customer order delivery note number of row	4	N
VARCHAR2	C03	PART_NO	Part number of the purchase part	25	M		CUSTOMER_PART_NO	Part number of the ordering site	45	C	If no sales part cross reference exist and internal_po_no is NOT NULL then the value received into Customer_Order_Line_Tab.catalog_no is a NOT NULL column. Otherwsie the value received into Customer_Order_Line_Tab.customer_part_no is a nullable column. Used in both ORDERS and ORDCHG messages
VARCHAR2	C04	DESCRIPTION	The description of the part on the ordering site or company. This value may be retrieved from the part description on the purchase order line.	200	M		CATALOG_DESC	The original value for the description of the part on the ordering site or company as received in the incoming customer order (ORDERS) message. This value is not retrieved to the customer order.	200	N
VARCHAR2	C05	BUY_UNIT_MEAS	Supplier sales unit meas.	10	M
VARCHAR2	C06	UNIT_MEAS	Customer inventory unit meas.	10	N
VARCHAR2	C07	PRICE_UNIT_MEAS	Our Price Unit Meas	10	M
VARCHAR2	C08	CURRENCY_CODE		3	M
VARCHAR2	C09	VENDOR_PART_NO	Supplier part number	80	N		CATALOG_NO	Part number of the delivering site	25	C	customer_Order_Line_tab.catalog_no is a NOT NULL column. but the value is taken from Sales_Part_Cross_Reference_API.Get_Catalog_No if it is null only it uses the value from the incoming message.
VARCHAR2	C10	BLANKET_ORDER	Blanket order number	12	N
VARCHAR2	C11	DETAIL_NOTE	Row document text	2000	N		NOTES	Document text entered on the purchase order line at ordering site	2000	N
VARCHAR2	C12	BLANKET_DETAIL_NOTE	Blanket row document text	2000	N
VARCHAR2	C13	SUPPLIER_PART_NOTE	Supplier part document text	2000	N
VARCHAR2	C16	SENDING_PRICE_FLAG	Determines whether the price should be sent	20	M		SENDING_PRICE_FLAG	Determines whether the price should be sent	20	C	The values for SALE_UNIT_PRICE and CATALOG_DESC are fetched from the receiving message only if sending_price_flag_ = 'SENDPRICE' But this incoming value is not stored.
VARCHAR2	C17	LINE_ADDRESS_NAME	Receiver name for delivery address	100	N	If not a single occurrence address, the value is taken from the company delivery address of the purchasing site. If single occurrence address, the value is taken from the purchase order line. For a purchase order line pegged to a customer order line with supply code Purchase Direct (PD) or Internal Purchase Direct (IPD), the value is replicated from the pegged customer order line to the purchase order line. Note that for direct deliveries the purchase order line address will always be single occurrence.	DELIVERY_ADDRESS_NAME	Delivery address name	100	N
VARCHAR2	C18	LINE_ADDRESS_1	Address 1	35	N	Same logic as LINE_ADDRESS_NAME above (C17).	SHIP_ADDRESS1	Delivery address 1	35	N
VARCHAR2	C19	LINE_ADDRESS_2	Address 2	35	N	Same logic as LINE_ADDRESS_NAME above (C17).	SHIP_ADDRESS2	Delivery address 2	35	N
VARCHAR2	C20	LINE_ZIP_CODE	Postal code	35	N	Same logic as LINE_ADDRESS_NAME above (C17).	SHIP_ZIP_CODE	Delivery zip code	35	N
VARCHAR2	C21	LINE_CITY	City	35	N	Same logic as LINE_ADDRESS_NAME above (C17).	SHIP_CITY	Delivery city	35	N
VARCHAR2	C22	LINE_ADDR_STATE	State	35	N	Same logic as LINE_ADDRESS_NAME above (C17).	SHIP_ STATE	Delivery state	35	N
VARCHAR2	C49	LINE_COUNTY	County	35	N	Same logic as LINE_ADDRESS_NAME above (C17).	SHIP_COUNTY	Delivery county	35	N
VARCHAR2	C23	LINE_COUNTRY_CODE	Receiver country code (ISO code)	2	C	Same as logic as LINE_ADDRESS_NAME above (C17).	COUNTRY_CODE	Delivery country code	2	N
VARCHAR2	C24	DELIVERY_TERMS	Delivery terms ID	3	M	The value is taken from the purchase order line. For a purchase order line pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is replicated from the pegged customer order line to the purchase order line.	DELIVERY_TERMS	Delivery terms ID	3	N
VARCHAR2	C25	DELIVERY_TERMS_DESC	Delivery terms description	35	M	The value is taken from the purchase order line. For a purchase order line pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is replicated from the pegged customer order line to the purchase order line.	DELIVERY_TERMS_DESC	Delivery terms description	35	N
VARCHAR2	C26	SHIP_VIA_CODE	Ship via code ID	3	M	The value is taken from the purchase order line. For a purchase order line pegged to a customer order line with supply code Purchase Direct (PD) or Internal Purchase Direct (IPD), the value is replicated from the pegged customer order line to the purchase order line.	SHIP_VIA_CODE	Ship via code ID	3	N
VARCHAR2	C27	SHIP_VIA_DESC	Ship via description	35	M	The value is taken from the purchase order line. For a purchase order line pegged to a customer order line with supply code Purchase Direct (PD) or Internal Purchase Direct (IPD), the value is replicated from the pegged customer order line to the purchase order line.	SHIP_VIA_DESC	Ship via description	35	N
VARCHAR2	C28	EAN_LOCATION	Deliver-to-customer's own identification of the delivery address.	100	N	If not a single occurrence address, the value is taken from the company delivery address of the purchasing site. If single occurrence address, the value is taken from the purchase order line and there will only be a value if the purchase order is pegged to a customer order line with supply code Internal Purchase Direct (IPD). The value is replicated from the pegged customer order line to the purchase order line based on the delivery address of the customer order line. Note that for direct deliveries the purchase order line address will always be single occurrence.	EAN_LOCATION_DEL_ADDR	Deliver-to-customer's own identification of the delivery address.	100	N	This value is passed to the supplier in order to identify the delivery address as a known address. If correctly configured this means that the address will not be single occurrence on the internal customer order on the the supply site.
VARCHAR2	C29	ROUTE_ID	Route ID	12	N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line.	ROUTE_ID	Route ID	12	N
VARCHAR2	C30	FORWARDER_ID	Forwarding Agent	20	N	The value is taken from the purchase order line. For a purchase order line pegged to a customer order line with supply code Purchase Direct (PD) or Internal Purchase Direct (IPD), the value is replicated from the pegged customer order line to the purchase order line.	FORWARD_AGENT_ID	Forwarding Agent	20	N
VARCHAR2	C31	CONDITION_CODE	Condition code of the part	10	C		CONDITION_CODE	Condition code of the part	10	N
VARCHAR2	C36	SHIPMENT_CREATION	Customer order shipment creation method.	25	N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line.	SHIPMENT_CREATION	Customer order shipment creation method	25	N
VARCHAR2	C37	ORDER_CODE	order line code (for internal flow only)	3	M		INTERNAL_DELIVERY_TYPE	order line code (for internal flow only)
VARCHAR2	C44	IPD_TAX_NO	Used in an internal direct delivery situation, and refers to the tax ID number of the order taking site's company, in the country where the delivery takes place.	50	N		VAT_NO	Used in an internal direct delivery situation, and refers to the tax ID number of the order taking site's company, in the country where the delivery takes place.	50	N
VARCHAR2	C45	IPD_TAX_FREE_TAX_CODE	Only used in an internal purchase direct situation, for the intra EC tax free trade	20	N		VAT_FREE_VAT_CODE	Only used in an internal purchase direct situation, for the intra EC tax free trade	20	N
VARCHAR2	C46	IPD_TAX_LIABILITY	Pay Tax	20	N		TAX_LIABILITY	Used in an internal direct delivery situation for intra EC trade. It indicates whether the order taking site is liable for tax in the customer's country	20	N
VARCHAR2	C50	INTERNAL_DEST_DESC	Internal destination	2000	N
VARCHAR2	C51	DOCK_CODE	Dock	35	N	For a purchase order line pegged to a customer order line with supply code Purchase Direct (PD) or Internal Purchase Direct (IPD), the value is taken from the pegged customer order line. For other purchase order lines the value is taken from a the purchase order line (technically from a sub-table called pur_ord_line_ext_tab)	DOCK_CODE	Dock	35	N
VARCHAR2	C52	SUBDOCK_CODE	Subdock	35	N	For a purchase order line pegged to a customer order line with supply code Purchase Direct (PD) or Internal Purchase Direct (IPD), the value is taken from the pegged customer order line. For other purchase order lines the value is taken from a the purchase order line (technically from a sub-table called pur_ord_line_ext_tab)	SUBDOCK_CODE	Subdock	35	N
VARCHAR2	C53	LOCATION	Location where the goods shall be delivered	35	N	For a purchase order line pegged to a customer order line with supply code Purchase Direct (PD) or Internal Purchase Direct (IPD), the value is taken from the pegged customer order line. For other purchase order lines the value is taken from a the purchase order line (technically from a sub-table called pur_ord_line_ext_tab)	LOCATION	Location where the goods shall be delivered	35	N
VARCHAR2	C54	INV_FLAG_DB	Indicates if the ordered part is a stocked part in the customer site (for internal flow only, relevant when both sites are in the same company)	1	M		INVENTORY_FLAG_DB	Indicates if the ordered part is a stocked part in the customer site (for internal flow only, relevant when both sites are in the same company)	1	N
VARCHAR2	C56	DELIVER_TO_CUSTOMER_NO	Customer ID to which the order items are delivered	20	N		DELIVER_TO_CUSTOMER_NO	Customer ID to which the order items are delivered	20	N
VARCHAR2	C57	DISTRICT_CODE	Geographical district to which the goods will be sent	10	N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line.	DISTRICT_CODE	Geographical district to which the goods will be sent	10	N
VARCHAR2	C58	REGION_CODE	Geographical region to which the goods will be sent	10	N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line.	REGION_CODE	Geographical region to which the goods will be sent	10	N
VARCHAR2	C59	CONTACT	Customer contact	90	N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line.	CONTACT	Customer contact	90	N
VARCHAR2	C60	INTRASTAT_EXEMPT_DB	Indicates if the delivery address is exempted from intrastat reporting	20	M		INTRASTAT_EXEMPT_DB	Indicates if the delivery address is exempted from intrastat reporting	20	N
VARCHAR2	C62						IN_CITY		5	N
VARCHAR2	C63	DEL_TERMS_LOCATION	Delivery terms location			The value is taken from the purchase order line. For a purchase order line pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is replicated from the pegged customer order line to the purchase order line.	DEL_TERMS_LOCATION	Delivery terms location
VARCHAR2	C64	CLASSIFICATION_STANDARD	Supplier's Classification Standard No	25	N		CLASSIFICATION_STANDARD		2000	N
VARCHAR2	C65	CLASSIFICATION_PART_NO	Active assortment node's classification part no for a classification standard, when a supplier's classification standard no is equal to intersite-delivery, Classification standard no on ext. CO line.	25	N		CLASSIFICATION_PART_NO		2000	N
VARCHAR2	C66	CLASSIFICATION_UNIT_MEAS	Active assortment node's classification unit meas for a classification standard, when a supplier's classification standard no is equal to intersite-delivery, Classification standard no on ext. CO line.	30	N		CLASSIFICATION_UNIT_MEAS		2000	N
VARCHAR2	C67	GTIN_NO	The default GTIN of the part	14	N		GTIN_NO	GTIN used for identification of the part	14	N
VARCHAR2	C68	VENDOR_PART_DESCRIPTION	The description of the part on the delivering site or company. This value may be retrieved from the supplier part description on the purchase order line.	200	N		VENDOR_PART_DESC	The original value for the description of the part on the delivering site or company as received in the incoming customer order (ORDERS) message. This value is only retrieved to the customer order if the Send Order Price option is enabled on the Supplier for Purchase Part window.	200	N
VARCHAR2	C69	PACKING_INSTRUCTION_ID	The packing instruction ID		N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line. It is used so that the external customer order that set the requirement on how parts should be packed on a shipment.	PACKING_INSTRUCTION_ID			N
VARCHAR2	C70	ORIGINATING_CO_LANG_CODE	Language code	2	N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order. If no value is found on the pegged customer order line, it is taken from the customer order header.	ORIGINATING_CO_LANG_CODE	Language code	2	N
VARCHAR2	C71	CUST_CALENDAR_ID	Customer calendar	10	N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line.	CUST_CALENDAR_ID	Customer calendar	10	N
VARCHAR2	C72	EXT_TRANS_CALENDAR_ID	External transport calendar	10	N	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line.	EXT_TRANS_CALENDAR_ID	External transport calendar	10	N
VARCHAR2	C73	SHIPMENT_TYPE	Used in Internal Purch Direct Delivery for shipment type of external CO or in Internal Transit Delivery for any default shipment type between the sites.		N	If Order_Code = 3 (IPD), sends the shipment type from the external customer order. If Order_Code = 4 (IPT), sends the default shipment type between the sites.	SHIPMENT_TYPE	Used in Internal Purch Direct Delivery for shipment type of external CO or in Internal Transit Delivery for any default shipment type between the sites.		N
VARCHAR2	C82	EXT_CUST_PART_DESC	External Customer Part Description	200	N		EXT_CUST_PART_DESC	External Customer Part Description	200	N
VARCHAR2	C83	PACKAGE_PART_FLAG	The value indicates if the ordered part is a package part		M
DATE	D00	WANTED_DELIVERY_DATE	Wanted delivery date / part		M					M
DATE	D05	PLANNED_DELIVERY_DATE	The date on which the goods are planned to be delivered at the receiver's address		M		ORIGINAL_PLAN_DELIV_DATE	The original value for Wanted Delivery Date/Time
DATE	D07	PLANNED_RENTAL_START_DATE	The date on which the rental period is planned to be started.		C	Applicable only for rental lines	PLANNED_RENTAL_START_DATE	The date on which the rental period is planned to be started.		C	Applicable only for rental lines
DATE	D08	PLANNED_RENTAL_END_DATE	The end date of the rental.		C	Applicable only for rental lines	PLANNED_RENTAL_END_DATE	The end date of the rental.		C	Applicable only for rental lines
NUMBER	N00	BUY_QTY_DUE	Buy quantity due in supplier sales unit		M		BUY_QTY_DUE	Ordered quantity due in supplier unit of measure		C	The value stored in Customer_Order_Line_tab.BUY_QTY_DUE is a NOT NULL column. But if customer_Quantity is null only BUY_QTY_DUE from the message is used. This used in ORDERS messages when order_change_status = CHANGED.
NUMBER	N01	CONV_FACTOR	= #UNIT_MEAS / #BUY_UNIT_MEAS		M
NUMBER	N02	FBUY_UNIT_PRICE	Buy unit price in your currency		M		SALES_UNIT_PRICE	Original price received		C	If part_ownership IN ('CUSTOMER OWNED','SUPPLIER LOANED') then a default value = 0 is set for SALE_UNIT_PRICE. If c16 sending_price_flag_ = 'SENDPRICE' then only the value for SALE_UNIT_PRICE is received. But in Customer_Order_Line_tab.SALE_UNIT_PRICE is a NOT NULL column. Used in both ORDERS and ORDCHG messages
NUMBER	N03	BUY_UNIT_PRICE	Buy unit price in customer currency		M
NUMBER	N04	PRICE_CONV_FACTOR	= #BUY_UNIT_MEAS / #PRICE_UNIT_MEAS		M
NUMBER	N05	CURRENCY_RATE	Currency rate		M
NUMBER	N06	DISCOUNT	Discount		M
NUMBER	N07	ADDITIONAL_COST_AMOUNT	Additional cost amount in supplier currency		M
NUMBER	N08	BLANKET_LINE	Blanket order line		N
NUMBER	N09	CUSTOMER_QUANTITY	In customer buy unit				CUSTOMER_QUANTITY	Quantity ordered in customer unit of measure		N
VARCHAR2	N10	TRANSIT_DELIVERY_LEAD_TIME	Used in Internal Purch Direct Delivery and Transit Delivery leadtime on external CO		C	Value is sent only if order_code = 3, 4 and 2. When order_code = 3 the value is taken from Customer_Order_Line_Tab.delivery_leadtime is a NOT NULL column. When order_code = 4 the value is taked from Pur_Order_Leadtime_Util_API.Get_Leadtime_Values is also not null. When order_code = 2 then the value is takedn from Pur_Order_Leadtime_Util_API.Get_Total_Leadtime_For_Part is also NOT NULL.	DELIVERY_LEADTIME	Used in Internal Purch Direct Delivery and Transit Delivery leadtime on external CO		N
NUMBER	N11	INPUT_QTY	Input Qty from CO when PO is pegged to CO.		N		INPUT_QTY	If received GTIN is a GTIN-14 with a connected package, this is the ordered quantity, expressed in this package.		N
NUMBER	N12	PICKING_LEAD_TIME	Picking lead time of external CO		C	Only used when a purchase order line is pegged to a customer order line with supply code Internal Purchase Direct (IPD), the value is taken from the pegged customer order line.	PICKING_LEAD_TIME	Picking lead time of external CO
NUMBER	N13	FBUY_UNIT_PRICE_INCL_TAX	Buying unit price including tax in your currency		M		UNIT_PRICE_INCL_TAX	Original price including tax received		C	If c16 sending_price_flag_ = 'SENDPRICE' then only the value for UNIT_PRICE_INCL_TAX is received. But in Customer_Order_Line_tab.UNIT_PRICE_INCL_TAX is a NOT NULL column. Used in both ORDERS and ORDCHG messages
NUMBER	N14	BUY_UNIT_PRICE_INCL_TAX	Buying unit price including tax in customer currency		M
NUMBER	N15	ADDITIONAL_COST_INCL_TAX	Additional cost amount including tax in supplier currency		M
NUMBER	N16	REPLACEMENT_RENTAL_NO	The rental number to which the replacement purchase order line is connected.		C		REPLACEMENT_RENTAL_NO	The rental number to which the replacement purchase order line is connected.
NUMBER	N20	DEMAND_OPERATION_NO	Demand OPeration number of the PO line		C		COMPONENT_LINE_ITEM_NO	Line item number of the component		M
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).

Order Configuration Line Row

Data type	COLUMN	SEND MESSAGE					Receive Message
Data type	COLUMN	Value	Description	SIZE	M/N/C*	COMMENTS	Value	Description	SIZE	M/N/C*	COMMENTS
NUMBER	MESSAGE_ID						MESSAGE_ID	Message ID
NUMBER	MESSAGE_LINE						MESSAGE_LINE	Message line number
VARCHAR2	NAME				C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. CHARROW	CONFIGROW	Name of the line, always Configrow for characteristic lines in the message
NUMBER	C01			4	C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from Purchase_Order_Line_TAB.Line_No NOT NULL column	LINE_NO	Purchase order line number	2000	N
NUMBER	C02			4	C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. Purchase_Order_Line_TAB.Release_no Not Null column	RELEASE_NO	Purchase order release number	2000	N
VARCHAR2	C03			25	C		CUSTOMER_PART_NO	The part number of the ordering site	2000	C	In ORDERS message the receiving value considered only if a corresponding line exist in external_cust_order_char_tab. The receiving value stored in config_spec_value_tab.part_no and config_char_price_tab.part_no are NOT NULL columns. Not Handled in ORDCHG message
VARCHAR2	C04			200	C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from INVENTORY_PART_TAB.description (NOT NULL)	CATALOG_DESC	Part description of the delivering site	2000	N
VARCHAR2	C05			4	C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from PURCHASE_ORDER_TAB.language_code is a NOT NULL column			2000	N
VARCHAR2	C06			25	C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.characteristic_id is a NOT NULL column			2000	C	In ORDERS receiving message the receiving value considered only if a corresponding line exist in external_cust_order_char_tab. The receiving values stored in config_spec_value_tab.characteristic_id and config_char_price_tab.characteristic_id are nOT NULL columns. Not Handled in ORDCHG message
VARCHAR2	C07			100	C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from CONFIG_CHARACTERISTIC_TAB.description is a NOT NULL column			2000	N
VARCHAR2	C08	CHARACTERISTIC_VALUE		2000	N		CHARACTERISTIC_VALUE		2000	N
VARCHAR2	C09	CHARACTERISTIC_VALUE_DESC		100	N		CHARACTERISTIC_VALUE_DESC	Part number of the delivering site	2000	N
VARCHAR2	C10	CHARACTERISTIC_VALUE_UOM		30	N		CHARACTERISTIC_UOM		2000	N
VARCHAR2	C11	CONFIG_VALUE_TYPE		20	C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.config_value_type is a NOT NULL Column	NOTES	Document text entered on the purchase order line at ordering site	2000	N
	C12	CONFIG_DATA_TYPE		20	C		CHARACTERISTIC_DATA_TYPE		2000	N
VARCHAR2	C13	PACKAGE_CONTENT		2000	N			Package content of the characteristic ID.	2000	N
VARCHAR2	C14	CONFIGURATION_ID			C	The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from PURCHASE_ORDER_LINE_TAB.configuration_id NULLable column but sends in the message only if it has a value	CONFIGURATION_ID			C	In ORDERS message, the receiving value considered only if a corresponding line exist in external_cust_order_char_tab. The received value stored in config_spec_value_tab.configuration_id and config_char_price_tab.configuration_id are NOT NULL columns. Not Handled in ORDCHG message
VARCHAR2	C28						EAN_LOCATION_DEL_ADDR	Deliver-to-customer's own identification of the delivery address.	100	N
VARCHAR2	C56						DELIVER_TO_CUSTOMER_NO	Customer ID to which the order items are delivered
VARCHAR2	C59						CONTACT	The contact person for this particular customer address identity.
NUMBER	N01					The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.spec_revision_no is a NOT NULL Column				N
NUMBER	N02						SALE_UNIT_PRICE	Original sales price		N
NUMBER	N06						DISCOUNT	Discount
NUMBER	N09						CUSTOMER_QUANTITY	Quantity ordered in customer unit of measure		N
DATE	D00						WANTED_DELIVERY_DATE	Date on which the customer wants the order to be delivered at the customer's delivery address.		M

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

Package Component Line Row

Data type	COLUMN	Send Message					Receive Message
Data type	COLUMN	Value	Description	SIZE	M/N/C*	COMMENTS	Value	Description	SIZE	M/N/C*	COMMENTS
NUMBER	MESSAGE_ID	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	Comprow	Type of message line		M		Comprow	Type of message line		M
VARCHAR2	ERROR_MESSAGE	Error message for line	Generated by EDI converter				Error message for line	Generated by EDI converter
VARCHAR2	C00	ORDER_NO	Purchase Order No	12	M		ORDER_NO	Purchase Order No	12	M
VARCHAR2	C01	LINE_NO	PO line number	4	M		LINE_NO	The line number of the received or created order line	4	M
VARCHAR2	C02	REL_NO	PO release number of line	4	M		REL_NO	PO release number of line	4	N
VARCHAR2	C03	PART_NO	Purchase part number of the component part of the package part	25	M		PART_NO	Purchase part number of the component part of the package part	25	M
VARCHAR2	C04	DESCRIPTION	The description of the component part	200	M		DESCRIPTION	The description of the component part	200	N
VARCHAR2	C05	BUY_UNIT_MEAS	Buy unit of measure in which the part is bought	10	M
VARCHAR2	C06	UNIT_MEAS	Customer's Inventory Unit Meas	10	N
VARCHAR2	C07	CONDITION_CODE	Condition code of the component part	10	C
VARCHAR2	C08	VENDOR_PART_NO	Supplier's part number	80	N		VENDOR_PART_NO	Supplier's part number	80	C
VARCHAR2	C09	VENDOR_PART_DESCRIPTION	The description of the part on the delivering site or company. This value may be retrieved from the supplier part description on the purchase order line.	200	N		VENDOR_PART_DESCRIPTION	The description of the part on the delivering site or company. This value may be retrieved from the supplier part description on the purchase order line.	200	N
NUMBER	C10	INV_FLAG	Indicates if the ordered part is a stocked part in the customer site (for internal flow only, relevant when both sites are in the same company)		M		INV_FLAG	Indicates if the ordered part is a stocked part in the customer site (for internal flow only, relevant when both sites are in the same company)		M
NUMBER	N00	COMPONENT_LINE_ITEM_NO	Line item number of the external customer order line.		M		COMPONENT_LINE_ITEM_NO	Line item number of the external customer order line		M
NUMBER	N01	TOTAL_QTY	Total Purchase Quantity in supplier's sales unit.		M		TOTAL_QTY	Total Purchase Quantity in supplier's sales unit.		M

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

Package Component Configuration Line Row

Data type	COLUMN	SEND MESSAGE					Receive Message
Data type	COLUMN	Value	Description	SIZE	M/N/C*	COMMENTS	Value	Description	SIZE	M/N/C*	COMMENTS
NUMBER	MESSAGE_ID						MESSAGE_ID	Message ID
NUMBER	MESSAGE_LINE						MESSAGE_LINE	Message line number
VARCHAR2	NAME	COMPCHAROW			C	The value sends ORDERS message only if configuration_id_ <> '*'. CHARROW	COMPCHAROW	Name of the line, always Configrow for characteristic lines in the message
VARCHAR2	C00	ORDER_NO		12	C		ORDER_NO		12	C
VARCHAR2	C01	LINE_NO		4	C		LINE_NO	Purchase order line number	2000	N
VARCHAR2	C02	RELEASE_NO		4	C		RELEASE_NO	Purchase order release number	2000	N
VARCHAR2	C03	PART_NO		25	C		BASE_ITEM_NUMBER	The part number of the ordering site	2000	C	In ORDERS message the receiving value considered only if a corresponding line exist in external_cust_order_char_tab. The receiving value stored in config_spec_value_tab.part_no and config_char_price_tab.part_no are NOT NULL columns. Not Handled in ORDCHG message
VARCHAR2	C04	BASE_ITEM_DESCRIPTION		200	C	The value sends ORDERS message only if configuration_id_ <> '*'. The value is from INVENTORY_PART_TAB.description (NOT NULL)	BASE_ITEM_DESCRIPTION	Part description of the delivering site	2000	N
VARCHAR2	C05	LANGUAGE_CODE		4	C		LANGUAGE_CODE		2000	N
VARCHAR2	C06	CHARACTERISTIC_ID		25	C	The value sends ORDERS message only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.characteristic_id is a NOT NULL column	CHARACTERISTIC_ID		2000	C	In ORDERS receiving message the receiving value considered only if a corresponding line exist in external_cust_order_char_tab. The receiving values stored in config_spec_value_tab.characteristic_id and config_char_price_tab.characteristic_id are nOT NULL columns. Not Handled in ORDCHG message
VARCHAR2	C07	CHARACTERISTIC_ID_DESCRIPTION		100	C	The value sends ORDERS message only if configuration_id_ <> '*'. The value is from CONFIG_CHARACTERISTIC_TAB.description is a NOT NULL column	CHARACTERISTIC_ID_DESCRIPTION		2000	N
VARCHAR2	C08	CHARACTERISTIC_VALUE		2000	N		CHARACTERISTIC_VALUE		2000	N
VARCHAR2	C09	CHARACTERISTIC_VALUE_DESC		100	N		CHARACTERISTIC_VALUE_DESC	Part number of the delivering site	2000	N
VARCHAR2	C10	CHARACTERISTIC_VALUE_UOM		30	N		CHARACTERISTIC_UOM		2000	N
VARCHAR2	C11	CONFIG_VALUE_TYPE		20	C	The value sends ORDERS message only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.config_value_type is a NOT NULL Column	CHARACTERISTIC_VALUE_TYPE	Document text entered on the purchase order line at ordering site	2000	N
	C12	CONFIG_DATA_TYPE		20	C		CHARACTERISTIC_DATA_TYPE		2000	N
VARCHAR2	C13	PACKAGE_CONTENT		2000	N		PACKAGE_CONTENT	Package content of the characteristic ID.	2000	N
VARCHAR2	C28						EAN_LOCATION_DEL_ADDR	Deliver-to-customer's own identification of the delivery address.	100	N
VARCHAR2	C56						DELIVER_TO_CUSTOMER_NO	Customer ID to which the order items are delivered
VARCHAR2	C59						CONTACT	The contact person for this particular customer address identity.
NUMBER	N00	CONFIGURATION_ID				The value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from PURCHASE_ORDER_LINE_TAB.configuration_id NULLable column but sends in the message only if it has a value	CONFIGURATION_ID			C	In ORDERS message, the receiving value considered only if a corresponding line exist in external_cust_order_char_tab. The received value stored in config_spec_value_tab.configuration_id and config_char_price_tab.configuration_id are NOT NULL columns. Not Handled in ORDCHG message
NUMBER	N01	SPEC_REVISION_NO				The value sends ORDERS message only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.spec_revision_no is a NOT NULL Column	SPEC_REVISION_NO			N
NUMBER	N02	QTY_CHARACTERISTIC					QTY_OF_OPTION			N
NUMBER	N03	COMPONENT_LINE_ITEM_NO	Line item number of the component part		M		COMPONENT_LINE_ITEM_NO	Line item number of the component part		M
NUMBER	N06						DISCOUNT	Discount
NUMBER	N09						CUSTOMER_QUANTITY	Quantity ordered in customer unit of measure		N
DATE	D00						WANTED_DELIVERY_DATE	Date on which the customer wants the order to be delivered at the customer's delivery address.		M

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

Data type	COLUMN	Receive Message
Data type	COLUMN	Value	Description	SIZE	M/N/C*	COMMENTS
NUMBER	MESSAGE_ID	MESSAGE_ID	Message ID
NUMBER	MESSAGE_LINE	MESSAGE_LINE	Message line number
VARCHAR2	NAME	CHARROW	Name of the line, always Charrow for characteristic lines in the message
NUMBER	C01	LINE_NO	Purchase order line number
NUMBER	C02	RELEASE_NO	Purchase order release number
VARCHAR2	C03	BASE_ITEM_NO	Purchase part number
VARCHAR2	C04	BASE_ITEM_DESC	Purchase part description
VARCHAR2	C05	LANGUAGE_CODE	Language code on the purchase order
NUMBER	C06	CHARACTERISTIC_ID	Configuration characteristic ID
VARCHAR2	C07	CHARACTERISTIC_ID_DESC	Configuration characteristic description
VARCHAR2	C08	CHARACTERISTIC_VALUE	Configuration characteristic value
VARCHAR2	C09	CHARACTERISTIC_VALUE_DESC	Configuration characteristic value description (when discrete)
VARCHAR2	C10	CHARACTERISTIC_UOM	Characteristic unit of measure: when variable value
VARCHAR2	C11	CHARACTERISTIC_VALUE_TYPE	Type of option: discrete or variable value
VARCHAR2	C12	CHARACTERISTIC_DATA_TYPE	Numeric or alphanumeric
NUMBER	N00	CONFIGURATION_ID	Configuration ID
NUMBER	N01	SPEC_REVISION_NO	Configuration specification number
NUMBER	N02	QTY_OF_OPTION	Qty of configuration characteristic, when discrete

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