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
Dispatch advice consolidated shipment row
Dispatch advice handling unit row
Dispatch advice line row

Dispatch Advice Header Row

DATA TYPE	COLUMN	Send Message					Receive Message
DATA TYPE	COLUMN	Value	Description	SIZE	M/N/C*	COMMENTS	Value	Description	SIZE	M/N/C*	COMMENTS
NUMBER	MESSAGE ID	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
DATA TYPE	COLUMN	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
DATA TYPE	COLUMN	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
DATA TYPE	COLUMN	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).