Dispatch Advice (DESADV)

Dispatch Advice (DESADV) is the message used for sending and receiving dispatch advices. It is sent from a delivery note in IFS/Customer Order or through a shipment with source ref types of Customer Orders/Shipment orders and received in IFS/Purchasing/Shipment Orders. The message is used to provide the receiver detailed information about goods that are to be delivered. The message can be used as basis for the arrival registration. The dispatch advice can cover a number of different items or packages from different orders. The sent information will make it possible to register arrivals automatically using barcode scanning.

A dispatch advice consists of the information on the delivery note such as source order number, names and addresses, terms of delivery, and delivery date. Information about packaging, weight, marks and numbers, quantities, date and time information, and handling information are also included as well as information about forward agent and ship via codes. Details of how the individual dispatched items are packed into handling units are defined in the shipment. Note that no handling unit structure is sent when delivering in the order flow, to get the full handling unit structure the shipment must be used.

This message has three types of rows:

Dispatch Advice 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 MESSAGE_ ID Unique ID of the message generated by IFS.       MESSAGE_ID Unique ID of the message generated by IFS.      
NUMBER MESSAGE_
LINE		 MESSAGE_LINE Header should always be row number 1.       Row of message Header should always be row number 1.      
VARCHAR2 NAME HEADER Type of message line.       HEADER Type of message line.      
VARCHAR2 ERROR_
MESSAGE		 Error message
for line		 Generated by EDI converter.       Error message for line Generated by EDI converter.      
VARCHAR2 C00 DELNOTE_NO Delivery note number(s). 2000 M Upper case letters are recommended to be used in the delivery note number if not the IFS default numbers are used. DELNOTE_NO Delivery note number(s). 2000 M Upper case letters are recommended to be used in the delivery note number if not the IFS default numbers are used.
VARCHAR2 C03 CONSIGNMENT_ID Consignment ID. 50 N   SHIPPING_DOCUMENT_ID Shipment identity 2000 N  
VARCHAR2 C04 CONTRACT Site. 5 M   SENDER_CONTRACT Sender contract     Sender contract is used to convert Actual_Ship_Date. This value is not stored in the database.
VARCHAR2 C05 SENDER_ID Consignor/Shipper ID. 20 N   VENDOR_NO Consignor/Shipper ID. 20 M  
VARCHAR2 C06 SENDER_NAME Consignor/Shipper name. 100 C COMPANY_TAB.NAME,
SHIPMENT_TAB.SHIPPER_NAME,
If shipment id is null this will definitely have a value, else could be nulll		      
VARCHAR2 C07 SENDER_ADDRESS1 Consignor/Shipper address 1. 35 N        
VARCHAR2 C08 SENDER_ADDRESS2 Consignor/Shipper address 2. 35 N        
VARCHAR2 C09 SENDER_ZIP_CODE Consignor/Shipper zip code. 35 N        
VARCHAR2 C10 SENDER_CITY Consignor/Shipper city. 35 N        
VARCHAR2 C11 SENDER_COUNTY Consignor/Shipper county. 35 N        
VARCHAR2 C12 SENDER_STATE Consignor/Shipper state. 35 N        
VARCHAR2 C13 SENDER_COUNTRY Consignor/Shipper country code. 2 C If shipment_id exists this is not
 mandatory. COMPANY_ADDRESS_
TAB.country, corresponding column
 is not nullable. SHIPMENT_
TAB.shipper_country, corresponding column is nullable.		      
VARCHAR2 C14 SENDER_REFERENCE Consignor/Shipper reference. 35 N        
VARCHAR2 C15 DOCK_CODE Receiver's dock code 35 N            
VARCHAR2 C16 SUB_DOCK_CODE Receiver's sub dock code 35 N            
VARCHAR2 C17 REF_ID Receiver's reference ID 35 N            
VARCHAR2 C18 LOCATION_NO Receiver's location no 35 N
VARCHAR2 C19 RECEIVER_TYPE Receiver type of the shipment 20 N            
VARCHAR2 C20 RECEIVER_ID Consignee/Receiver. 20 M        
VARCHAR2 C21 RECEIVER_NAME Consignee/Receiver name. 100 C CUST_ORD_CUSTOMER_
ADDRESS_TAB.company_
name2 - nullable,  CUSTOMER_INFO_
TAB.name - not null, CUSTOMER_ORDER_DELIV_
NOTE_TAB.addr_1 - nullable. If single occurrence address c21 can be null, else not null		 RECEIVER_NAME Consignee/Receiver name. 2000 N  
VARCHAR2 C22 RECEIVER_ADDRESS1 Consignee/Receiver address 1. 35 N   RECEIVER_ADDRESS1 Consignee/Receiver address 1. 2000 N  
VARCHAR2 C23 RECEIVER_ADDRESS2 Consignee/Receiver address 2. 35 N   RECEIVER_ADDRESS2 Consignee/Receiver address 2. 2000 N  
VARCHAR2 C24 RECEIVER_ZIP_CODE Consignee/Receiver zip code. 35 N   RECEIVER_ZIP_CODE Consignee/Receiver zip code. 2000 N  
VARCHAR2 C25 RECEIVER_CITY Consignee/Receiver city. 35 N   RECEIVER_CITY Consignee/Receiver city. 2000 N  
VARCHAR2 C26 RECEIVER_COUNTY Consignee/Receiver county. 35 N   RECEIVER_COUNTY Consignee/Receiver county. 2000 N  
VARCHAR2 C27 RECEIVER_STATE Consignee/Receiver state. 35 N   RECEIVER_STATE Consignee/Receiver state. 2000 N  
VARCHAR2 C28 RECEIVER_COUNTRY Consignee/Receiver country code. 2 C If shipment ID exists and address
is not single occurrence, this is
mandatory.CUSTOMER_INFO_
ADDRESS_TAB.country, corresponding column is not nullable, CUSTOMER_ORDER_
DELIV_NOTE_TAB.country_code, corresponding column is nullable		 RECEIVER_COUNTRY Consignee/Receiver country code. 2000 N  
VARCHAR2 C29 CONSIGNEE_REF Consignee/Receiver reference. 35 N        
VARCHAR2 C30 EAN_DOC_ADDR EAN location no. for customer document address. 100 C CUSTOMER_INFO_ADDRESS_
TAB.EAN_LOCATION , Condition: Will have a value only if customer has a default
address flag for "Document" address type.		      
VARCHAR2 C31 EAN_DEL_ADDR EAN location no. for customer delivery address. 100 C CUSTOMER_INFO_ADDRESS_
TAB.EAN_LOCATION, if single Occurance,
no value fetch for C31.If delivery address
exists, value for C31 will be fetched.		      
VARCHAR2 C32 EAN_PAY_ADDR EAN location no. for payer document address. 100 C CUSTOMER_INFO_ADDRESS_
TAB.EAN_LOCATION, If invoice customer at customer->order-> general tab exists and if there exists a default document address, this value will be fetched.		 100 C  
VARCHAR2 C35 FORWARD_AGENT_ID Carrier/Forwarder ID. 20 N   FORWARDER_ID Carrier/Forwarder ID. 20 N  
VARCHAR2 C36 FORWARD_AGENT_NAME Carrier/Forwarder name. 100 N        
VARCHAR2 C37 ADDRESS1 Carrier/Forwarder address 1. 35 N        
VARCHAR2 C38 ADDRESS2 Carrier/Forwarder address 1. 35 N        
VARCHAR2 C39 ZIP_CODE Carrier/Forwarder zip code. 35 N        
VARCHAR2 C40 CITY Carrier/Forwarder city. 35 N        
VARCHAR2 C41 COUNTY Carrier/Forwarder county. 35 N        
VARCHAR2 C42 STATE Carrier/Forwarder state. 35 N        
VARCHAR2 C43 COUNTRY Carrier/Forwarder country code. 2 M        
VARCHAR2 C45 ALT_DEL_NO Alternative delivery note number(s). 2000 N   ALT_DELNOTE_NO Alternative delivery note number(s). 2000 N  
VARCHAR2 C50 AIRWAY_BILL_NO Airway bill number. 50 N        
VARCHAR2 C51 PRO_NO The tracking or booking number for transport of goods. 50 N        
VARCHAR2 C52 SENDER_ADDRESS3 Consignor/Shipper address 3. 100 N            
VARCHAR2 C53 SENDER_ADDRESS4 Consignor/Shipper address 4. 100 N            
VARCHAR2 C54 SENDER_ADDRESS5 Consignor/Shipper address 5. 100 N            
VARCHAR2 C55 SENDER_ADDRESS6 Consignor/Shipper address 5. 100 N            
VARCHAR2 C56 RECEIVER_ADDRESS3 Consignee/Receiver address 3. 100 N            
VARCHAR2 C57 RECEIVER_ADDRESS4 Consignee/Receiver address 4. 100 N            
VARCHAR2 C58 RECEIVER_ADDRESS5 Consignee/Receiver address 5. 100 N            
VARCHAR2 C59 RECEIVER_ADDRESS6 Consignee/Receiver address 6. 100 N            
VARCHAR2 C60 ADDRESS3 Carrier/Forwarder address 3. 100 N            
VARCHAR2 C61 ADDRESS4 Carrier/Forwarder address 4. 100 N            
VARCHAR2 C62 ADDRESS5 Carrier/Forwarder address 5. 100 N            
VARCHAR2 C63 ADDRESS6 Carrier/Forwarder address 6. 100 N            
VARCHAR2 C70 DELIVERY_TERMS Delivery terms. 3 N        
VARCHAR2 C71 DELIVERY_TERMS_DESC Delivery terms description. 35 M   DELIVERY_TERMS_DESC Delivery terms description. 2000 N  
VARCHAR2 C72 SHIP_VIA_CODE Ship via code. 3 N        
VARCHAR2 C73 SHIP_VIA_DESC Ship via description. 35 M   SHIP_VIA_DESC Ship via description. 2000 N  
VARCHAR2 C74 CROSS_REFERENCE_INFO_1 Free text 200 N        
VARCHAR2 C75 CROSS_REFERENCE_INFO_2 Free text 200 N        
VARCHAR2 C76 CROSS_REFERENCE_INFO_3 Free text 200 N        
VARCHAR2 C77 CROSS_REFERENCE_INFO_4 Free text 200 N        
VARCHAR2 C78 CROSS_REFERENCE_INFO_5 Free text 200 N        
VARCHAR2 C79 DEL_TERMS_LOCATION Delivery terms location 100 N   DEL_TERMS_LOCATION Delivery terms location (Received externally only) 100 N  
VARCHAR2 C80       SUPPLIER_ORDER_NO Customer Order  (Received externally only)      
VARCHAR2 C81       PO_NO Purchase Order Number (Received externally only)      
VARCHAR2 C82           LABEL_NOTE Label note. (Received externally only) 2000 N
VARCHAR2 C83           SHIPMENT_NOTES Shipment notes. (Received externally only) 2000 N
VARCHAR2 C84       DOCK_ID Dock identity 2000 N
VARCHAR2 C85       GATE_ID Gate identity 2000 N
VARCHAR2 C86           CONVEY_REF_NO Convey reference number. (Received externally only) 2000 N
VARCHAR2 C87           MESSAGE_TYPE_DB Message type DB. (Received externally only) 20 N
VARCHAR2 C88 UOM_FOR_WEIGHT Unit of measure for weight 30 N            
VARCHAR2 C89 UOM_FOR_VOLUME Unit of measure for volume 30 N            
VARCHAR2 C90 PHONE_NO Consignor/Shipper Phone 200 N   PHONE_NO Consignor/Shipper Phone 200 N  
VARCHAR2 C91 FAX_NO Consignor/Shipper Fax 200 N   FAX_NO Consignor/Shipper Fax 200 N  
VARCHAR2 C94 EMAIL_ID Consignor/Shipper Email 200 N   EMAIL_ID Consignor/Shipper Email 200 N  
VARCHAR2 C95 CONSIGNOR_ASSOCIATION_NO Consignor/Shipper Association number 50 N   CONSIGNOR_ASSOCIATION_NO Consignor/Shipper Association number 50 N  
VARCHAR2 C96 CONSIGNEE_ASSOCIATION_NO Consignee/Receiver Association number 50 N   CONSIGNEE_ASSOCIATION_NO Consignee/Receiver Association number 50 N  
VARCHAR2 C97 SENDER_TYPE Sender Type 200 N   SENDER_TYPE Sender Type 200 N  
NUMBER N00 SHIPMENT_ ID Shipment ID.   N        
NUMBER N01 TOP_LEVEL_HU_COUNT Number of pallets on Shipment.   C A count of the number of top node handling units connected to the shipment.      
NUMBER N02 SECOND_LEVEL_HU_COUNT Number of second level HUs on Shipment.   C A count of the number of second level node handling units connected to the shipment.      
NUMBER N03 NET_TOTAL Net weight of the shipment.   C Not Mandatory: A value appears
only if the shipment_id is not NULL		      
NUMBER N04 GROSS_TOTAL Gross weight of the shipment.   C Not Mandatory: A value comes only
if the shipment_id is not NULL		      
NUMBER N05 TOTAL_VOLUME Total volume of the shipment.   C Not Mandatory: A value comes only
 if the shipment_id is not NULL		      
NUMBER N10           DELIVERY_LEADTIME Delivery lead time (Received externally only)   N
NUMBER N20 SEQUENCE_NO DESADV message sequence number         M  
NUMBER N21 VERSION_NO DESADV message version number         M  
DATE D01 ACTUAL_SHIP_DATE Dispatch date and time.   M   DESPATCH_DATE Dispatch date and time.   N DESPATCH_DATE
DATE D10           DELNOTE_DATE Date and time on the delivery note. (Received externally only)   N  
VARCHAR2 STATE Status of message line Handled by IFS Connectivity.       Status of message line        

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

Dispatch Advice Consolidated Shipment 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 Unique ID of the message generated by IFS.       MESSAGE_ID Unique ID of the message generated by IFS.      
NUMBER MESSAGE_
LINE		 MESSAGE_LINE Message can hold one line for Consolidated Shipment info.       Row of message Message can hold one line for Consolidated Shipment info.      
VARCHAR2 NAME CONSOLIDATED SHIPMENT Type of message line.       CONSOLIDATED SHIPMENT Type of message line.      
VARCHAR2 ERROR_
MESSAGE		 Error message
for line		 Generated by EDI converter.       Error message for line Generated by EDI converter.      
VARCHAR2 C03 CONSOLIDATED_SHIPMENT_ID Consolidated Shipment ID. 50 N   CONSOLIDATED_SHIPMENT_ID Consolidated Shipment identity 2000 N  
VARCHAR2 C22 DELIVER_VIA_ADDRESS1 Deliver Via address 1. 35 N   DELIVER_VIA_ADDRESS1 Deliver Via address 1. 2000 N  
VARCHAR2 C23 DELIVER_VIA_ADDRESS2 Deliver Via address 2. 35 N   DELIVER_VIA_ADDRESS2 Deliver Via address 2. 2000 N  
VARCHAR2 C24 DELIVER_VIA_ZIP_CODE Deliver Via zip code. 35 N   DELIVER_VIA_ZIP_CODE Deliver Via zip code. 2000 N  
VARCHAR2 C25 DELIVER_VIA_CITY Deliver Via city. 35 N   DELIVER_VIA_CITY Deliver Via city. 2000 N  
VARCHAR2 C26 DELIVER_VIA_COUNTY Deliver Via county. 35 N   DELIVER_VIA_COUNTY Deliver Via county. 2000 N  
VARCHAR2 C27 DELIVER_VIA_STATE Deliver Via state. 35 N   DELIVER_VIA_STATE Deliver Via state. 2000 N  
VARCHAR2 C28 DELIVER_VIA_COUNTRY Deliver Via country code. 2 N   DELIVER_VIA_COUNTRY Deliver Via country code. 2000 N  
VARCHAR2 C56 DELIVER_VIA_ADDRESS3 Deliver Via address 3. 100 N   DELIVER_VIA_ADDRESS3 Deliver Via address 3. 2000 N  
VARCHAR2 C57 DELIVER_VIA_ADDRESS4 Deliver Via address 4. 100 N   DELIVER_VIA_ADDRESS4 Deliver Via address 4. 2000 N  
VARCHAR2 C58 DELIVER_VIA_ADDRESS5 Deliver Via address 5. 100 N   DELIVER_VIA_ADDRESS5 Deliver Via address 5. 2000 N  
VARCHAR2 C59 DELIVER_VIA_ADDRESS6 Deliver Via address 6. 100 N   DELIVER_VIA_ADDRESS6 Deliver Via address 6. 2000 N  
VARCHAR2 STATE Status of message line Handled by IFS Connectivity.       Status of message line        

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

 

Dispatch Advice Handling Unit Row  

DATA TYPE COLUMN Send Message Receive Message
Value Description SIZE M/N/C* COMMENT Value Description SIZE M/N/C* COMMENT
NUMBER MESSAGE_ID MESSAGE_ID Unique ID of the message generated by IFS.       MESSAGE_ID Unique ID of the message generated by IFS.      
NUMBER MESSAGE_LINE Row of message Each message can hold several lines.       Row of message Each message can hold several lines.      
VARCHAR2 NAME HANDLING UNIT Type of message line.       HANDLING UNIT Type of message line.      
VARCHAR2 ERROR_MESSAGE Error message for line Generated by the EDI converter.       Error message for line Generated by the EDI converter.      
VARCHAR2 C01 COMPOSITION Handling unit composition. 200 N Displays if the handling unit is SIMPLIFIED/HOMOGENOUS or MIXED HANDLING_UNIT_TYPE Handling unit type. 2000 N  
VARCHAR2 C02 HANDLING_UNIT_TYPE_ID Handling unit type. 4000 N   PALLET_TYPE Handling unit type. 2000 N  
VARCHAR2 C03 SOURCE_REF1 First source reference of the conneceted source. Only displayed if all attached shipment lines have common information. 12 N   SUPPLIER_ORDER_NO Customer order number. Only displayed if all attached shipment lines have common information. 2000 N  
VARCHAR2 C04 SOURCE_REF2 Second source reference of the conneceted source. Only displayed if all attached shipment lines have common information. 4 N   SUPPLIER_LINE_NO Customer order line number. Only displayed if all attached shipment lines have common information. 2000 N  
VARCHAR2 C05 SOURCE_REF3 Third source reference of the conneceted source. Only displayed if all attached shipment lines have common information. 4 N   SUPPLIER_REL_NO Customer order release number. Only displayed if all attached shipment lines have common information. 2000 N  
VARCHAR2 C06 SOURCE_REF4 Fourth source reference of the conneceted source. Only displayed if all attached shipment lines have common information   N            
VARCHAR2 C07 SOURCE_REF_TYPE Type of the source conneceted the shipment. Only displayed if all attached shipment lines have common information   N            
VARCHAR2 C15 ENG_CHG_LEVEL The engineering revision number of the items placed on the handling unit. Only displayed if all attached shipment lines have common information. 25 N   ENG_CHG_LEVEL The engineering revision number of the items placed on the handling unit. Only displayed if all attached shipment lines have common information. 2000 N  
VARCHAR2 C16 LOT_BATCH_NO The lot/batch number of the items placed on the handling unit. Only displayed if all attached shipment lines have common information. 25 N   LOT_BATCH_NO The lot/batch number of the items placed on the handling unit. Only displayed if all attached shipment lines have common information. 2000 N  
VARCHAR2 C17 SERIAL_NO The serial number of the items placed on the handling unit. Only displayed if all attached shipment lines have common information. 50 N   SERIAL_NO The serial number of the items placed on the handling unit. Only displayed if all attached shipment lines have common information. 2000 N  
VARCHAR2 C18 WAIV_DEV_REJ_NO The W/D/R number of the items placed on the handling unit. Only displayed if all attached shipment lines have common information. 15 N   WAIV_DEV_REJ_NO The W/D/R number of the items placed on the handling unit. Only displayed if all attached shipment lines have common information. 15 N  
VARCHAR2 C19 SSCC The serial shipping container code for the handling unit.   N   SSCC The serial shipping container code for the handling unit.      
VARCHAR2 C20 ALT_HANDLING_UNIT_LABEL_ID The alternative Handling Unit label ID for the handling unit.   N   ALT_TRANSP_LABEL_ID The alternative transport label ID for the handling unit.      
VARCHAR2 C22 UOM_FOR_WEIGHT The UoM used for weight values.   N   UOM_FOR_WEIGHT The UoM used for weight values.      
VARCHAR2 C23 UOM_FOR_VOLUME The UoM used for volume values.   N   UOM_FOR_VOLUME The UoM used for volume values.      
VARCHAR2 C24 UOM_FOR_LENGTH The UoM used for length values.   N   UOM_FOR_LENGTH The UoM used for length values.      
NUMBER C25 HANDLING_UNIT_ID Handling Unit ID.   M   HANDLING_UNIT_ID Handling Unit ID.   M  
NUMBER C26 PARENT_HANDLING_UNIT_ID Parent Handling Unit ID.   N   PARENT_HANDLING_UNIT_ID Parent Handling Unit ID.   N  
NUMBER N01 LINE_ITEM_NO Customer order line item number on the handling unit. Only displayed if all attached shipment lines hav common information.   N   SUPPLIER_LINE_ITEM_NO Customer order line item number on the handling unit. Only displayed if all attached shipment lines have common information.   N  
NUMBER N02 QTY_ON_HANDL_UNIT Total number of all items attached on the handling unit.   N   HANDLING_UNIT_QTY Total number of all items attached on the handling unit.   N  
NUMBER N03 NO_OF_CHILDREN Total number of handling units that are children to this handling unit.   N   NO_OF_PACKAGES Total number of handling units that are children to this handling unit (second level in handling unit structure).   N  
NUMBER N04 NET_WEIGHT Total net weight of all parts on the handling unit.   C Total net weight of the handling unit ID. NET_WEIGHT Total net weight of all parts on the handling unit.   N  
NUMBER N05 TARE_WEIGHT The weight of the handling unit itself.   C Total tare weight of the handling unit ID. TARE_WEIGHT The weight of the handling unit itself.   N  
NUMBER N06 SOURCE_QTY_ON_HANDLING_UNIT The shipped quantity in handling unit expressed in source unit of measure.   M            
VARCHAR2 STATE Status of the message line Handled by IFS Connectivity.       Status of the message line Handled by IFS Connectivity.      

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

Dispatch Advice Line Row  

DATA TYPE COLUMN Send Message Receive Message
Value Description SIZE M/N/C* COMMENT Value Description SIZE M/N/C* COMMENT
NUMBER MESSAGE_ID MESSAGE_ID Unique ID of the message generated by IFS.       MESSAGE_ID Unique ID of the message generated by IFS.      
NUMBER MESSAGE_LINE MESSAGE_LINE Each message can hold several lines.       MESSAGE_LINE Each message can hold several lines.      
VARCHAR2 NAME LINE Type of message line.       LINE Type of message line.      
VARCHAR2 ERROR_MESSAGE Error message for line Generated by EDI converter.       Error message for line Generated by EDI converter.      
VARCHAR2 C00 SOURCE_REF1 First source reference of the sender's source order.  eg:Customer order 50 N   SUPPLIER_ORDER_NO Customer order number. 2000 N  
VARCHAR2 C01 SOURCE_REF2 Second source reference of the sender's source order.  eg:Customer order 50 N   SUPPLIER_LINE_NO Customer order line number. 2000 N  
VARCHAR2 C02 SOURCE_REF3 Third source reference of the sender's source order.  eg:Customer order 50 N   SUPPLIER_REL_NO Customer order release number. 2000 N  
VARCHAR2 C03 INPUT_UNIT_MEAS Input unit of measure 30 N            
VARCHAR2 C04 RECEIVER_SOURCE_REF1 First source reference of the receiver's source order.  eg:Purchase order 50 N   ORDER_NO Purchase order number. 12 M  
VARCHAR2 C05 CATALOG_NO source part number. 25 M   SALES_PART_NO Your sales part number. 2000 N  
VARCHAR2 C06 CATALOG_DESC source part description. 200 N        
VARCHAR2 C07 SOURCE_REF4 Fourth source reference of the sender's source order.  eg:Customer order 50 N            
VARCHAR2 C08 RECEIVER_PART_NO Receiver's part number. 45 N   PART_NO Customer part number. 25 M
VARCHAR2 C09 RECEIVER_PART_ DESC receiver's part description. 200 N        
VARCHAR2 C10 SOURCE_REF_TYPE source reference type 20 N            
VARCHAR2 C11 SOURCE_UNIT_OF_MEASURE source unit of measure. 10 M   SALES_UNIT_MEAS Sales unit of measure. 10 N  
VARCHAR2 C12 RECEIVER_SOURCE_REF2 Second source reference of the receiver's source order.  eg:Purchase order 50 N            
VARCHAR2 C13 RECEIVER_SOURCE_REF3 Third source reference of the receiver's source order.  eg:Purchase order 50 N            
VARCHAR2 C14 INV_UOM Inventory unit of measure 10 N            
VARCHAR2 C15 COUNTRY_OF_ORIGIN Inventory part's country of origin. 3 N   COUNTRY_OF_ORIGIN The country code of the country where the products where produced. 2 N  
VARCHAR2 C16 DOCK_CODE Identifies a large area within the receiver's facilities where goods are to be delivered, i.e., the cargo bay. 35 N   DOCK_CODE Identifies a large area within the receiver's facilities where goods are to be delivered, i.e., the cargo bay. 2000 N  
VARCHAR2 C17 SUB_DOC_CODE Identifies a specific area within the area specified by the dock code, i.e., the gate on the cargo bay. 35 N   SUB_DOCK_CODE Identifies a specific area within the area specified by the dock code, i.e., the gate on the cargo bay. 2000 N  
VARCHAR2 C18 REF_ID Unique identifier for a demand, provided by the receiver. 35 N   REFERENCE_ID Unique identifier for a demand, provided by the customer. 2000 N  
VARCHAR2 C19 LOCATION_NO The receiver's location number. 35 N   LOCATION_NO The customer's location number. 2000 N  
VARCHAR2 C20 RECEIVER_SOURCE_REF_TYPE Type of the receiver's source. 20 N            
VARCHAR2 C21 RECEIVER_SOURCE_REF4 Fourth source reference of the receiver's source order.  eg:Purchase order 50 N
VARCHAR2 C22 LINE_DELNOTE_NO Delivery note number for line 50 N LINE_DELNOTE_NO Delivery note number for line 50 N
VARCHAR2 C23 LINE_ALT_DELNOTE_NO Alt delivery note number for line 50 N LINE_ALT_DELNOTE_NO Alt delivery note number for line 50 N
VARCHAR2 C80 LOT_BATCH_NO Lot/batch number. 20 C If CUSTOMER_ORDER_LINE_TAB
.catalog_type = 'INV' then Mandatory, CUSTOMER_ORDER_RESERVATION
.t_batch_no corresponding column is not nullable		 LOT_BATCH_NO Lot/batch number. (Received from external order)   N  
VARCHAR2 C81 SERIAL_NO Serial number. 50 C If CUSTOMER_ORDER_LINE_TAB.catalog_type = 'INV' then MandatoryCUSTOMER_ORDER_RESERVATION
.serial_no corresponding column is not nullable		 SERIAL_NO Serial number. (Received from external order)   N  
VARCHAR2 C82 WAIV_DEV_REJ_NO Waiver, Deviation and Rejection number. 15 C   WAIV_DEV_REJ_NO Waiver, Deviation and Rejection number. (Received from external order)   N  
VARCHAR2 C83 ENG_CHG_LEVEL The engineering revision number. 2 C If CUSTOMER_ORDER_LINE_TAB.catalog_type = 'INV' then MandatoryCUSTOMER_ORDER_RESERVATION
.eng_chg_level corresponding column is not nullable		 ENG_CHG_LEVEL The engineering revision number. (Received from external order)   N  
VARCHAR2 C85 CLASSIFICATION_STANDARD Classification Standard No(Customer Order information) 25 N   CLASSIFICATION_STANDARD   2000 N  
VARCHAR2 C86 CLASSIFICATION_PART_NO Classification part no(Customer Order information) 25 N   CLASSIFICATION_PART_NO   2000 N  
VARCHAR2 C87 CLASSIFICATION_UNIT_MEAS Classification unit meas(Customer Order information) 10 N   CLASSIFICATION_UNIT_MEAS   2000 N  
VARCHAR2 C88 GTIN_NO The default GTIN of the part 14 N   GTIN_NO        
VARCHAR2 C89 HANDLING_UNIT_ID Lowest level handling unit ID connected to the line 25 N   HANDLING_UNIT_ID     N  
VARCHAR2 C90           CUSTOMS_DECLARATION_NO This is the Customs Declaration Number for the import of the goods provided by the customs authority in the country receiving the products. 50 N  
VARCHAR2 C91 SENDER_DEMAND_CODE The type of demand object, that is originally requesting the delivery of the material.This helps the receiver better understand the origin of the demand.The value of the demand code can vary depending on the functional scenario. 200 N   SENDER_DEMAND_CODE The type of demand object, that is originally requesting the delivery of the material.This helps the receiver better understand the origin of the demand.The value of the demand code can vary depending on the functional scenario. 200 N  
VARCHAR2 C92 SENDER_DEMAND_REF1 The reference of the demand object, that is originally requesting the delivery of the material. 50 N   SENDER_DEMAND_REF1 The reference of the demand object, that is originally requesting the delivery of the material. 50 N  
VARCHAR2 C93 SENDER_DEMAND_REF2 The reference of the demand object, that is originally requesting the delivery of the material. 50 N   SENDER_DEMAND_REF2 The reference of the demand object, that is originally requesting the delivery of the material. 50 N  
VARCHAR2 C94 SENDER_DEMAND_REF3 The reference of the demand object, that is originally requesting the delivery of the material. 50 N   SENDER_DEMAND_REF3 The reference of the demand object, that is originally requesting the delivery of the material. 50 N  
VARCHAR2 C95 SENDER_DEMAND_REF4 The reference of the demand object, that is originally requesting the delivery of the material. 50 N   SENDER_DEMAND_REF4 The reference of the demand object, that is originally requesting the delivery of the material. 50 N  
DATE D00 WANTED_DELIVERY_DATE Wanted delivery date.   M        
DATE D01 REAL_SHIP_DATE The date on which the cargo was shipped.   N        
DATE D02 EXPIRATION_DATE Expiration date   N   EXPIRATION_DATE Expiration date (Received from external order)   N  
DATE D03           CUSTOMS_DECLARATION_DATE The date that the customs declaration for the import has been issued by the customs authority in the country receiving the product.   N  
NUMBER N01 SHIPMENT_LINE_NO Shipment line number   M   SUPPLIER_LINE_ITEM_NO Customer order line item number.   N  
NUMBER N02 SHIPPED_QTY The shipped quantity expressed in inventory unit of measure.   N DESPATCH_QTY The delivered quantity expressed in inventory unit of measure (Received internal only). N
NUMBER N03 SHIPPED_SOURCE_QTY The shipped quantity expressed in source unit of measure.   N DESPATCH_SALES_QTY The delivered quantity expressed in sales unit of measure (Received externally only). N
NUMBER N09 INPUT_QTY Input quantity   N   INPUT_QTY        
NUMBER N20 SEQUENCE_NO DESADV message sequence number   M        
NUMBER N21 VERSION_NO DESADV 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).