Order Changes (ORDCHG)

The use of the Order Changes (ORDCHG) message is dependent upon whether the customer order to be updated has been created by an already-sent ORDER message. If no ORDER message has been sent for the purchase order, you cannot send an ORDCHG message.

This is a purchase order change request which is sent to the supplier.

This message has three types of rows:

Order Change Request Header Row

Data typeCOLUMNSend MessageReceive Message
ValueDescriptionSIZEM/N/C*COMMENTValueDescriptionSIZEM/N/C*COMMENT
NUMBERMESSAGE_ID (FK)EDI message IDUnique ID of message generated by IFS Connectivity   EDI message IDUnique ID of message generated by IFS Connectivity   
NUMBERMESSAGE_LINERow of messageHeader should always be row number 1   Row of messageHeader should always be row number 1   
VARCHAR2NAMEHeaderType of message line   HeaderType of message line   
VARCHAR2ERROR_MESSAGEError message for lineGenerated by EDI converter   Error message for lineGenerated by EDI converter   
VARCHAR2C00ORDER_NOInternal PO number12M INTERNAL_PO_NOThe order number of the corresponding internal purchase order, for internal customer orders.2000N 
VARCHAR2C01ACQUISITION_SITESupplier site (used for internal order)5N CONTRACTSupplier site5CIn 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
VARCHAR2C02BUYERCustomer buyer100M    
VARCHAR2C03AUTHORIZER_CODEPO coordinator20M    
VARCHAR2C04VENDOR_NOCustomer ID of supplier20M    
VARCHAR2C05ADDR_NOSupplier address number (Document address)50  50M 
VARCHAR2C06CURRENCY_CODESupplier's currency3M CURRENCY_CODESupplier's currency3N 
VARCHAR2C07DLY_ ADDR_NAMEReceiver's name for delivery address100N DELIVERY_ADDRESS_NAMEReceiver's name for delivery address100N 
VARCHAR2C08DLY_ADDR1Delivery address 135N SHIP_ADDRESS1Delivery address 135N 
VARCHAR2C09DLY_ADDR2Delivery address 235N SHIP_ADDRESS2Delivery address 235N 
VARCHAR2C10DLY_ADDR3Delivery address Zip code35N SHIP_ZIP_CODEZip code35N 
VARCHAR2C11DLY_ADDR4Delivery address City35N SHIP_CITYCity35N 
VARCHAR2C12DLY_ADDR5Delivery address State35N SHIP_STATEState35N 
VARCHAR2C49DLY_ADDR6Delivery address County35N SHIP_COUNTYCounty35N 
VARCHAR2C13COUNTRY_CODEDelivery address country code35N COUNTRY_CODEReceiver's country code35N 
VARCHAR2C14PO_REF / CONTACT (If not order code=4)Company contact person100N INTERNAL_REFThe reference of the corresponding internal purchase order, for internal customer orders.30N 
VARCHAR2C15DELIVERY_TERMS_DESCDelivery terms description35M DELIVERY_TERMS_DESCDelivery terms description35N 
VARCHAR2C16SHIP_VIA_DESCShip via description (Full text)35M SHIP_VIA_DESCShip via description (Full text)2000N 
VARCHAR2C17FORWARD_IDForward agent ID20N FORWARD_AGENT_IDForward agent ID20N 
VARCHAR2C18LABEL_NOTEExternal CO label note50NIf 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 the 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_NOTEExternal CO label note50N 
VARCHAR2C19BLANKET_ORDERCustomer agreement number12N    
VARCHAR2C20COMPANY_FAXCustomer's fax number200N COMPANY_FAXCustomer's fax number200N 
VARCHAR2C21COMPANY_PHONECustomer's phone number200N COMPANY_PHONECustomer's phone number200N 
VARCHAR2C22POSTAL_ADDRESSCustomer's postal address (Complete address)180N    
VARCHAR2C23COMPANY_NAMECustomer's company name100M    
VARCHAR2C24COMPANY_COUNTRYCustomer company country35N 
VARCHAR2C25OUR_IDCustomer ID at supplier20N CUSTOMER_NOCustomer number2000CIn ORDERS message if internal customer site (c39) is not null then take the value for customer_no from CUST_ORD_CUSTOMER_TAB.customer_no where it is a not null column else it should be possible to get a unique customer from the EAN Address Location otherwise it is mandatory to send the customer_no with the message. In ORDCHG the receiving value is ony used for logic handling hence stored in ext_cust_order_change_tab.customer_no is a nuallable column
VARCHAR2C26HEADER_NOTEHeader document text2000N NOTE_TEXTDocument text entered on the purchase order2000N 
VARCHAR2C27BLANKET_HEADER_NOTEAgreement header document text2000N    
VARCHAR2C29RECEIVER_ADDRESSSupplier EDI address200  200  
VARCHAR2C30MESSAGE_CLASSIn this case, "ORDCHG"30  30  
VARCHAR2C31MEDIA_CODEWay of communication (EDI, MHS, etc)30  30  
VARCHAR2C33EAN_LOC_DEL_ADDREAN location no. for your delivery address100N EAN_LOC_DEL_ADDREAN location no. for your delivery address2000N 
VARCHAR2C34EAN_LOC_DOC_ADDREAN location no. for your document address100N INTERNAL_DELIVERY_TYPEIf order code=4 the value is 'INTERSITE'2000N 
VARCHAR2C35   CUSTOMER_NO_PAYCustomer to be invoiced instead of the ordering customer, when the customer order is invoiced to a company other than the customer's   
VARCHAR2C36     CUSTOMER_NO_PAY_ADDR_NOEAN location number of the customer to be invoiced instead of the ordering customer2000C 
VARCHAR2C37ORDER_CODEType of order (Internal direct or transit, etc. Used for MHS)3M3N
VARCHAR2C38CUSTOMER_PO_NOThe purchase order number of the customer50NIf 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_NOPO for customer50N 
VARCHAR2C39CONTRACTUsed to identify customer when using internal order5CSending value only if supplier_catagery = 'Internal'. Value Purchase_Order_Tab.contract is NOT NULL columnINTERNAL_CUSTOMER_SITEOrdering site5N 
VARCHAR2C40VENDOR_CO_NOCO for supplier (used as reference)15N ORDER_NOThe customer order number15M 
VARCHAR2C41PAY_TERM_IDPayment term ID20CSends value of Purchase_Order__tab.pay_term_id(NOT NULL) only if PO Order_Code = 1 or 4PAY_TERM_IDPayment term ID20N 
VARCHAR2C42DELIVERY_TERMSDelivery term ID3CSends value of Purchase_Order__tab.delivery_terms(NOT NULL) only if PO Order_Code = 1 or 4DELIVERY_TERMSDelivery term ID3M 
VARCHAR2C43SHIP_VIA_CODEShip via code3CSends value of Purchase_Order__tab.ship_via_code(NOT NULL) only if PO Order_Code = 1 or 4SHIP_VIA_CODEShip via code3M 
VARCHAR2C44   SALESMAN_CODESalesman identity20N 
VARCHAR2C47    EXTERNAL_REFReference that is used to refer to the customer's system.2000N 
VARCHAR2C48   ROUTE_IDUsed in Internal Purch Direct Delivery, route on external CO12N 
VARCHAR2C51INTERNAL_DESTINATIONName of internal destination2000N    
VARCHAR2C50BACKORDER_OPTIONBackorder option of the pegged customer order40CIf 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_OPTIONBackorder option of the pegged customer order40MDetermines how the order will be treated when performing reservations, when creating the pick list and when reporting picking.
VARCHAR2C52AUTHORIZER_NAMEPO coordinator name100M    
VARCHAR2C54   VAT_NOThe tax identity number for the customer50N 
VARCHAR2C55DEL_TERMS_LOCATIONDelivery terms location100N DEL_TERMS_LOCATIONDelivery terms location100N 
VARCHAR2C56PRINT_DELIVERED_LINES_DBShow only delivered lines in delivery note NIf 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_DBShow Only Delivered Lines in Delivery Note NDetermines whether or not already delivered lines should be printed on the customer order delivery note and/or on the shipment delivery note.
VARCHAR2C61CUST_REFReferences of the pegged customer order30NIf 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_REFReferences of the pegged customer order  30N 
VARCHAR2C77VENDOR_PART_DESCOriginal Sales Part Description200N VENDOR_PART_DESCThe original value for the description of the part on the ordering site or company. This value is not retrieved to the customer order.200N 
VARCHAR2C85LABEL_NOTELabel note in purchase order50N LABEL_NOTELabel note in purchase order50N 
VARCHAR2C86PAY_TERM_DESCPayment terms description100       
VARCHAR2C94COMPANY_EMAILCustomer's email address200N COMPANY_EMAILCustomer's email address200N 
VARCHAR2C95COMPANY_ASSOCIATION_NOCompany's Association number50N COMPANY_ASSOCIATION_NOCompany's Association number50N 
VARCHAR2C96SUPPLIER_ASSOCIATION_NOSupplier's Association number50N SUPPLIER_ASSOCIATION_NOSupplier's Association number50N 
DATED00ORDER_DATECreation date of order M    
DATED01WANTED_RECEIPT_DATEThe desired date of receipt into stock M DELIVERY_DATEThe date the order should be delivered at the customer's delivery address. M 
DATED02BLANKET_ORDER_DATEAgreement date Cif 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   
NUMBERN00REVISIONRevision of purchase order M    
NUMBERN10TRANSIT_DELIVERY_LEAD_TIMEUsed in Internal Purch Direct Delivery and Transit Delivery leadtime on external CO CSends 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 4DELIVERY_LEADTIMEUsed in Internal Purch Direct Delivery and Transit Delivery leadtime on external CO N 
NUMBERN12PICKING_LEAD_TIMEUsed in Transit Delivery to send any default picking lead time between the sites. CIf Order_Code = 4 (IPT), sends the default picking lead time between the sites.PICKING_LEAD_TIMEUsed in Transit Delivery to send any default picking lead time between the sites.   
NUMBERN20SEQUENCE_NOORDCHG message sequence number M    
NUMBERN21VERSION_NOORDCHG message version number M    
VARCHAR2STATEStatus of message lineHandled by IFS Connectivity   Status of message lineHandled by IFS Connectivity   

Order Change Request Line Row

Data typeCOLUMNSend MessageReceive Message
ValueDescriptionSIZEM/N/C*COMMENTSValueDescriptionSIZEM/N/C*COMMENTS
NUMBERMESSAGE_ID (FK)EDI message IDUnique ID of message generated by IFS Connectivity   EDI message IDUnique ID of message generated by IFS Connectivity   
NUMBERMESSAGE_LINERow of messageEach message can hold several lines   Row of messageEach message can hold several lines   
VARCHAR2NAMERowType of message line200M RowType of message line   
VARCHAR2ERROR_MESSAGEError message for lineGenerated by EDI converter   Error message for lineGenerated by EDI converter   
VARCHAR2C00ORDER_NOOrder number12M    
VARCHAR2C01LINE_NOPO line number   LINE_NOLine number   
VARCHAR2C02RELEASE_NORelease number of row4M REL_NORelease number4N 
VARCHAR2C03PART_NOCustomer part number25M CUSTOMER_PART_NOThe part number of the ordering site45  
VARCHAR2C04DESCRIPTIONCustomer description purchase part200M CATALOG_DESCThe part description of the delivering site200  
VARCHAR2C05BUY_UNIT_MEASBuy unit meas. from supplier10M    
VARCHAR2C06UNIT_MEASCustomer unit meas. (inventory)10N    
VARCHAR2C07PRICE_UNIT_MEASPrice Unit Meas10M    
VARCHAR2C08CURRENCY_CODESupplier's currency code3M    
VARCHAR2C09VENDOR_PART_NOSupplier part number80N CATALOG_NOThe part number of the delivering site25  
VARCHAR2C10BLANKET_ORDERBlanket order number12N    
VARCHAR2C11DETAIL_NOTERow document text2000N NOTESDocument text entered on purchase order of the ordering site2000  
VARCHAR2C12BLANKET_DETAIL_NOTEBlanket row document text2000N    
VARCHAR2C13SUPPLIER_PART_NOTESupplier part document text2000N    
VARCHAR2C14VENDOR_CO_NOCO for supplier (used as reference)15N    
VARCHAR2C15ORDCHG_LINE_STATEState of ORDCHG row20M ORD_CHG_STATEState of ORDCHG row20  
VARCHAR2C16ORDERS_PRICE_OPTION_DBDetermines whether the price should be handled or not20M SENDING_PRICE_FLAGDetermines whether the price should be handled or not20  
VARCHAR2C17LINE_ADDRESS_NAMEReceiver's name for delivery address  

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_NAMEExternal customer’s delivery address name when Internal purchase direct   
VARCHAR2C18LINE_ADDRESS1Delivery address 1  Same logic as LINE_ADDRESS_NAME above (C17).SHIP_ADDRESS1Delivery address 1   
VARCHAR2C19LINEADDRESS2Delivery address 2  Same logic as LINE_ADDRESS_NAME above (C17).SHIP_ADDRESS2Delivery address 2   
VARCHAR2C20LINE_ZIP_CODEPostal code  Same logic as LINE_ADDRESS_NAME above (C17).SHIP_ZIP_CODEPostal code   
VARCHAR2C21LINE_CITYCity  Same logic as LINE_ADDRESS_NAME above (C17).SHIP_CITYCity   
VARCHAR2C49LINE_COUNTYCounty  Same logic as LINE_ADDRESS_NAME above (C17).SHIP_COUNTYCounty   
VARCHAR2C22LINE_ADDR_STATEState  Same logic as LINE_ADDRESS_NAME above (C17).SHIP_STATEState   
VARCHAR2C23LINE_COUNTRY_CODEReceiver's country code (ISO)  Same logic as LINE_ADDRESS_NAME above (C17).COUNTRY_CODEReceiver's country code (ISO)   
VARCHAR2C24DELIVERY_TERMSDelivery terms ID3MThe 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_TERMSDelivery terms ID   
VARCHAR2C25DELIVERY_TERMS_DESCDelivery terms description35MThe 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_DESCDelivery terms description35  
VARCHAR2C26SHIP_VIA_CODEShip via ID3MThe 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_CODEShip via ID3  
VARCHAR2C27SHIP_VIA_DESCShip via description35MThe 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_DESCShip via description35  
VARCHAR2C28EAN_LOCATIONDeliver-to-customer's own identification of the delivery address.100N

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_ADRDeliver-to-customer's own identification of the delivery address.100 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.
VARCHAR2C29ROUTE_IDRoute ID12NOnly 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 e ID12  
VARCHAR2C30FORWARD_IDForwarding agent20NThe 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_IDForwarding agent20  
VARCHAR2C37ORDER_CODEType of order (Internal direct or transit etc.)3M INTERNAL_DELIVERY_TYPE_DBType of order (Internal direct or transit etc.)   
VARCHAR2C44IPD_TAX_NOUsed 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.50N VAT_NOUsed 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  
VARCHAR2C45IPD_TAX_FREE_TAX_CODEOnly used in an internal purchase direct situation, for the intra EC tax free trade20N VAT_FREE_VAT_CODEOnly used in an internal purchase direct situation, for the intra EC tax free trade20  
VARCHAR2C46IPD_TAX_LIABILITYPay Tax20N TAX_LIABILITYUsed 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 country20  
VARCHAR2C50INTERNAL_DEST_DESCInternal destination2000N    
VARCHAR2C51DOCK_CODEDock35NFor 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_CODEDock35  
VARCHAR2C52SUBDOCK_CODESubdock35NFor 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_CODESubdock35  
VARCHAR2C53LOCATION_NOLocation35NFor 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_NOThe location number of the destination location for the part at your customer site35  
VARCHAR2C55CONDITION_CODEcondition code   CONDITION_CODECondition code   
VARCHAR2C56DELIVER_TO_CUSTOMER_NOCustomer ID to which the order items are delivered20N DELIVER_TO_CUSTOMER_NOIdentity of customer  to whom the items on the order line are delivered20  
VARCHAR2C57DISTRICT_CODEGeographical district to which the goods will be sent10NOnly 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_CODEGeographical district to which the goods will be sent10  
VARCHAR2C58REGION_CODEGeographical region to which the goods will be sent10NOnly 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_CODEGeographical region to which the goods will be sent10  
VARCHAR2C59CO_LINE_CONTACTCustomer contact90NOnly 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.CONTACTCustomer contact90  
VARCHAR2C60INTRASTAT_EXEMPT_DBIndicates if the delivery address is exempted from intrastat reporting20M INTRASTAT_EXEMPT_DBIndicates if the delivery address is exempted from intrastat reporting20  
VARCHAR2C62     RENTAL_TRANSFER_DB 5  
VARCHAR2C63DEL_TERMS_LOCATIONDelivery terms location200NThe 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_LOCATIONDelivery terms location100  
VARCHAR2C64CLASSIFICATION_STANDARDSupplier's Classification Standard No25N CLASSIFICATION_STANDARD 2000N 
VARCHAR2C65CLASSIFICATION_PART_NOActive 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.25N CLASSIFICATION_PART_NO 2000N 
VARCHAR2C66CLASSIFICATION_UNIT_MEAS 30N CLASSIFICATION_UNIT_MEAS 2000N 
VARCHAR2C67GTIN_NOThe default GTIN of the part14N GTIN_NOGTIN used for identification of the part14N 
VARCHAR2C69PACKING_INSTRUCTION_IDThe packing instruction ID NOnly 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 
VARCHAR2C70ORIGINATING_CO_LANG_CODELanguage code2NOnly 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_CODELanguage code2N 
VARCHAR2C71CUST_CALENDAR_IDCustomer calendar10NOnly 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_IDCustomer calendar10N 
VARCHAR2C72EXT_TRANS_CALENDAR_IDExternal transport calendar10NOnly 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_IDExternal transport calendar10N 
VARCHAR2C73SHIPMENT_TYPECustomer order shipment type NOnly used when a new customer order line with supply code Internal Purchase Direct (IPD) is added as a new purchase order line to an already existing purchase order the value is taken from the pegged customer order line.SHIPMENT_TYPECustomer order shipment type N 
VARCHAR2C75SHIPMENT_CREATIONCustomer order shipment creation NOnly used when a new customer order line with supply code Internal Purchase Direct (IPD) is added as a new purchase order line to an already existing purchase order the value is taken from the pegged customer order line.SHIPMENT_CREATIONCustomer order shipment creation N 
VARCHAR2C76CHANGED_ATTRIB_NOT_IN_POLA technical field to handle replication of line with supply code Internal Purchase Direct (IPD) when more than one supply site involved. N

This column is set to ‘TRUE’ when replicating a change in customer order line which does not exist in purchase order line e.g. route, customer calendar. This is to trigger a sending of a change request to the next supply site in case the supply code on the first supply site is Internal Purchase Direct (IPD). If the replicated attribute exist in the purchase order line, it is set to 'FALSE' and the change request will be triggered from changing the internal purchase order. If nothing is changed of the field is not relevant i.e. not inter-site, the field is NULL.

CHANGED_ATTRIB_NOT_IN_POL    
VARCHAR2C82EXT_CUST_PART_DESCExternal Customer Part Description200N EXT_CUST_PART_DESCExternal Customer Part Description200N 
DATED00WANTED_DELIVERY_DATEWanted delivery date / part M WANTED_DELIVERY_DATEDate on which the customer wants the order to be delivered at the customer's delivery address.   
DATED05PLANNED DELIVERY DATEThe date on which the goods are to be delivered to the receiver's address M ORIGINAL_PLAN_DELIV_DATEThe original value for Wanted Delivery Date/Time.   
DATED06PLANNED_RENTAL_START_DATEThe date on which the rental period is planned to be started. CApplicable only for rental linesPLANNED_RENTAL_END_DATEThe date on which the rental period is planned to be started. CApplicable only for rental lines
DATED07PLANNED_RENTAL_END_DATEThe end date of the rental CApplicable only for rental linesPLANNED_RENTAL_END_DATEThe end date of the rental CApplicable only for rental lines
NUMBERN00BUY_QTY_DUEBuy quantity due in supplier unit M BUY_QTY_DUEOrdered quantity, expressed in the supplier's unit of measure.   
NUMBERN01CONV_FACTOR= #UNIT_MEAS / #BUY_UNIT_MEAS M    
NUMBERN02FBUY_UNIT_PRICE_INCL_TAXBuying unit price including tax in supplier currency M UNIT_PRICE_INCL_TAXOriginal value for sales price N 
NUMBERN03BUY_UNIT_PRICE_INCL_TAXBuying unit price including tax in your currency M      
NUMBERN04PRICE_CONV_FACTOR= #BUY_UNIT_MEAS / #PRICE_UNIT_MEAS M    
NUMBERN05CURRENCY_RATECurrency rate M    
NUMBERN06DISCOUNTDiscount M    
NUMBERN07ADDITIONAL_COST_INCL_TAXAdditional cost amount including tax in supplier currency M    
NUMBERN08BLANKET_LINEBlanket order line N    
NUMBERN09CUSTOMER_SALES_QTYIn customer buy unit (empty)   CUSTOMER_QUANTITYOrdered quantity in customer's unit of measure   
VARCHAR2N10TRANSIT_DELIVERY_LEADTIMEUsed in Internal Direct Delivery and Transit Delivery leadtime on external CO CValue 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_LEADTIMEUsed in Internal Direct Delivery and Transit Delivery leadtime on external CO   
NUMBERN11INPUT_QTYInput Qty from CO when PO is pegged to CO. N INPUT_QTYIf received GTIN is a GTIN-14 with a connected package, this is the ordered quantity, expressed in this package.   
NUMBERN12PICKING_LEAD_TIME Picking lead time of external CO COnly 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_TIMEPicking lead time of external CO   
VARCHAR2STATEStatus of message lineHandled by IFS Connectivity   Status of message lineHandled by IFS Connectivity   

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

Order Change Request Configuration Line Row

DATA TYPECOLUMNSend MessageReceive Message
ValueDescriptionSIZEM/N/C*COMMENTSValueDescriptionSIZEM/N/C*COMMENTS
NUMBERMESSAGE_ID     MESSAGE_IDMessage ID   
NUMBERMESSAGE_LINE     MESSAGE_LINEMessage line number   
VARCHAR2NAME   CThe value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. CHARROWCONFIGROWName of the line, always Configrow for configuration lines in the message   
VARCHAR2C01LINE_NOPurchase line number4CThe value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from Purchase_Order_Line_TAB.Line_No NOT NULL columnLINE_NOPurchase line number2000N 
VARCHAR2C02REL_NOPurchase release number4CThe value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. Purchase_Order_Line_TAB.Release_no Not Null columnREL_NOPurchase release number2000N 
VARCHAR2C03CUSTOMER_PART_NOPurchase part number25CThe value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. Purchase_Order_Line_TAB.part_no Nullable column but the value is from purchase_order_line_part view where it is MandatoryCUSTOMER_PART_NOPurchase part number2000CIn 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
VARCHAR2C04CATALOG_DESCPurchase part description200CThe value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from INVENTORY_PART_TAB.description (NOT NULL)CATALOG_DESCPurchase part description2000N 
VARCHAR2C05LANGUAGE_CODE 4CThe 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 columnLANGUAGE_CODE 2000N 
VARCHAR2C06CHARACTERISTIC_ID 25CThe 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 columnCHARACTERISTIC_ID  CIn 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
VARCHAR2C07CHARACTERISTIC_ID_DESC 100CThe value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from CONFIG_CHARACTERISTIC_TAB.description is a NOT NULL columnCHARACTERISTIC_ID_DESC 2000N 
VARCHAR2C08CHARACTERISTIC_VALUE 2000N CHARACTERISTIC_VALUE 2000N 
VARCHAR2C09CHARACTERISTIC_VALUE_DESC 100N CHARACTERISTIC_VALUE_DESCConfiguration characteristic value description (when discrete)2000N 
VARCHAR2C10CHARACTERISTIC_UOM 30N CHARACTERISTIC_UOM  N 
VARCHAR2C11CONFIG_VALUE_TYPE 20CThe 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 ColumnNOTESDocument text entered on purchase order of the ordering site2000N 
VARCHAR2C12CONFIG_DATA_TYPE 20CThe value sends in both ORDERS and ORDCHG messages only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.config_data_type is a NOT NULL Column  2000N 
VARCHAR2C14CONFIGURATION_ID 50CThe 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 valueCONFIGURATION_ID 50CIn 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
VARCHAR2C15     ORD_CHG_STATEState of ORDCHG row   
VARCHAR2C17     DELIVERY_ADDRESS_NAMEReceiver's name for delivery address   
VARCHAR2C18     SHIP_ADDRESS_1Delivery address1   
VARCHAR2C19     SHIP_ADDRESS_2Delivery address2   
VARCHAR2C20     SHIP_ZIP_CODEZip code   
VARCHAR2C21     SHIP_CITYCity   
VARCHAR2C22     SHIP_STATEState   
VARCHAR2C49     SHIP_COUNTYCounty   
VARCHAR2C23     COUNTRY_CODECountry code   
VARCHAR2C24     DELIVERY_TERMSDelivery terms   
VARCHAR2C25     DELIVERY_TERMS_DESCDelivery terms description   
VARCHAR2C26     SHIP_VIA_CODEShip via code   
VARCHAR2C27     SHIP_VIA_DESCShip via code description   
VARCHAR2C28     EAN_LOCATION_DEL_ADDRDeliver-to-customer's own identification of the delivery address.   
VARCHAR2C56     DELIVER_TO_CUSTOMER_NOIdentity of customer  to whom the items on the order line are delivered   
VARCHAR2C59     CONTACTCustomer contact   
DATED00     WANTED_DELIVERY_DATEDate on which the customer wants the order to be delivered at the customer's delivery address.   
DATED05     ORIGINAL_PLAN_DELIV_DATEThe original value for Wanted Delivery Date/Time.   
NUMBERN01    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 
NUMBERN02        N 
NUMBERN06     DISCOUNTDiscount   
NUMBERN09     CUSTOMER_QUANTITYOrdered quantity in customer's unit of measure   

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

Order Change Request Package Component Line Row

Data typeCOLUMNSend MessageReceive Message
ValueDescriptionSIZEM/N/C*COMMENTSValueDescriptionSIZEM/N/C*COMMENTS
NUMBERMESSAGE_IDEDI message IDUnique ID of message generated by IFS Connectivity   EDI message IDUnique ID of message generated by IFS Connectivity   
NUMBERMESSAGE_LINERow of messageEach message can hold several lines   Row of messageEach message can hold several lines   
VARCHAR2NAMEComprowType of message line M ComprowType of message line M 
VARCHAR2ERROR_MESSAGEError message for lineGenerated by EDI converter   Error message for lineGenerated by EDI converter   
VARCHAR2C00ORDER_NOPurchase Order No12M ORDER_NOPurchase Order No12M 
VARCHAR2C01LINE_NOPO line number4M LINE_NOThe line number of the received or created order line4M 
VARCHAR2C02REL_NOPO release number of line4M REL_NOPO release number of line4N 
VARCHAR2C03PART_NOPurchase part number of the component part of the package part25M PART_NOPurchase part number of the component part of the package part25M 
VARCHAR2C08VENDOR_PART_NOSupplier's part number80NVENDOR_PART_NOSupplier's part number80C
VARCHAR2C09VENDOR_PART_DESCRIPTIONThe 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.200N VENDOR_PART_DESCRIPTIONThe 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.200N 
NUMBERN00COMPONENT_LINE_ITEM_NOLine item number of the external customer order line. M COMPONENT_LINE_ITEM_NOLine item number of the external customer order line M 
NUMBERN01TOTAL_QTYOrdered quantity, expressed in purchase unit of measure.MTOTAL_QTYOrdered quantity, expressed in purchase unit of measure.M
NUMBERN10COMPONENT_CANCELLEDUsed to indicate canceled lines.   COMPONENT_CANCELLEDUsed to indicate canceled lines.   

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

Order Change Request Package Component Configuration Line Row

Data typeCOLUMNSEND MESSAGEReceive Message
ValueDescriptionSIZEM/N/C*COMMENTSValueDescriptionSIZEM/N/C*COMMENTS
NUMBERMESSAGE_ID     MESSAGE_IDMessage ID   
NUMBERMESSAGE_LINE     MESSAGE_LINEMessage line number   
VARCHAR2NAMECOMPCHAROW  CThe value sends ORDERS message only if configuration_id_ <> '*'. CHARROWCOMPCHAROWName of the line, always Configrow for characteristic lines in the message   
VARCHAR2C00ORDER_NO 12C ORDER_NO 12C 
VARCHAR2C01LINE_NO 4C LINE_NOPurchase order line number2000N 
VARCHAR2C02RELEASE_NO 4C RELEASE_NOPurchase order release number2000N 
VARCHAR2C03PART_NO 25C BASE_ITEM_NUMBERThe part number of the ordering site2000CIn 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
VARCHAR2C04BASE_ITEM_DESCRIPTION 200CThe value sends ORDERS message only if configuration_id_ <> '*'. The value is from INVENTORY_PART_TAB.description (NOT NULL)BASE_ITEM_DESCRIPTIONPart description of the delivering site2000N 
VARCHAR2C05LANGUAGE_CODE 4C LANGUAGE_CODE 2000N 
VARCHAR2C06CHARACTERISTIC_ID 25CThe value sends ORDERS message only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.characteristic_id is a NOT NULL columnCHARACTERISTIC_ID 2000CIn 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
VARCHAR2C07CHARACTERISTIC_ID_DESCRIPTION 100CThe value sends ORDERS message only if configuration_id_ <> '*'. The value is from CONFIG_CHARACTERISTIC_TAB.description is a NOT NULL columnCHARACTERISTIC_ID_DESCRIPTION 2000N 
VARCHAR2C08CHARACTERISTIC_VALUE 2000N CHARACTERISTIC_VALUE 2000N 
VARCHAR2C09CHARACTERISTIC_VALUE_DESC 100N CHARACTERISTIC_VALUE_DESCPart number of the delivering site2000N 
VARCHAR2C10CHARACTERISTIC_VALUE_UOM 30N CHARACTERISTIC_UOM 2000N 
VARCHAR2C11CONFIG_VALUE_TYPE 20CThe value sends ORDERS message only if configuration_id_ <> '*'. The value is from CONFIG_SPEC_VALUE_TAB.config_value_type is a NOT NULL ColumnCHARACTERISTIC_VALUE_TYPEDocument text entered on the purchase order line at ordering site2000N 
 C12CONFIG_DATA_TYPE 20C CHARACTERISTIC_DATA_TYPE 2000N 
VARCHAR2C13PACKAGE_CONTENT 2000N PACKAGE_CONTENTPackage content of the characteristic ID.2000N 
VARCHAR2C28     EAN_LOCATION_DEL_ADDRDeliver-to-customer's own identification of the delivery address.100N 
VARCHAR2C56     DELIVER_TO_CUSTOMER_NOCustomer ID to which the order items are delivered   
VARCHAR2C59     CONTACTThe contact person for this particular customer address identity.   
NUMBERN00CONFIGURATION_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 valueCONFIGURATION_ID  CIn 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
NUMBERN01SPEC_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 ColumnSPEC_REVISION_NO  N 
NUMBERN02QTY_CHARACTERISTIC    QTY_OF_OPTION  N 
NUMBERN03COMPONENT_LINE_ITEM_NOLine item number of the component part M COMPONENT_LINE_ITEM_NOLine item number of the component part M 
NUMBERN06     DISCOUNTDiscount   
NUMBERN09     CUSTOMER_QUANTITYQuantity ordered in customer unit of measure N 
DATED00     WANTED_DELIVERY_DATEDate 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 typeCOLUMNReceive Message
ValueDescriptionSIZEM/N/C*COMMENTS
NUMBERMESSAGE_IDMESSAGE_IDMessage ID   
NUMBERMESSAGE_LINEMESSAGE_LINEMessage line number   
VARCHAR2NAMECHARROWName of the line, always Charrow for characteristic lines in the message   
VARCHAR2C01LINE_NOPurchase line number   
VARCHAR2C02RELEASE_NOPurchase release number   
VARCHAR2C03BASE_ITEM_NOPurchase part number   
VARCHAR2C04BASE_ITEM_DESCPurchase part description   
VARCHAR2C05LANGUAGE_CODELanguage code on the purchase order   
VARCHAR2C06CHARACTERISTIC_IDConfiguration characteristic ID   
VARCHAR2C07CHARACTERISTIC_ID_DESCConfiguration characteristic description   
VARCHAR2C08CHARACTERISTIC_VALUEConfiguration characteristic value   
VARCHAR2C09CHARACTERISTIC_VALUE_DESCConfiguration characteristic value description (when discrete)   
VARCHAR2C10CHARACTERISTIC_UOMCharacteristic unit of measure: when variable value   
VARCHAR2C11CHARACTERISTIC_VALUE_TYPEType of option: discrete or variable value   
VARCHAR2C12CHARACTERISTIC_DATA_TYPENumeric or alphanumeric   
NUMBERN00CONFIGURATION_IDConfiguration ID   
NUMBERN01SPEC_REVISION_NOConfiguration specification number   
NUMBERN02QTY_OF_OPTIONQty of configuration characteristic, when discrete   

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