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

Data type Column Send Message Receive Message
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
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
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
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
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
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).