Delivery Plans (DELSCH) is the message used for sending and receiving delivery plans. The message is sent from a supplier schedule in IFS/Supplier Schedules and received in IFS/Customer Schedules. The delivery plan message contains both the long-term and short-term demands of a customer. In IFS/Customer Schedules, the message is the basis for creating customer schedules, which later leads to releases of customer orders. This message has five types of rows; header, article, package, demand line and previous dispatch note.
The information in the delivery plan message is defined differently by different standards and should not be seen as a message corresponding to a certain EDI standard. In the ANSI world, this message would be called 830, in EDIFACT it is called DELFOR.
The DELSCH message can be sent by either MHS or EDI, but is handled in the same manner since the information looks the same from either source when it reaches the application.
This message has five types of rows:
| DATA TYPE | COLUMN | Send Message | Receive Message | ||||||||
| Value | Description | SIZE | M/N/C* | COMMENTS | Value | Description | SIZE | M/N/C* | COMMENTS | ||
| NUMBER | MESSAGE_ID | EDI message no | Unique ID of message generated by IFS/Connectivity. | EDI message no | Unique ID of message generated by IFS/Connectivity. | ||||||
| NUMBER | MESSAGE_LINE | Row of message | 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 | VENDOR_NO | Identity of supplier for which the agreement is created | 20 | M | ||||||
| VARCHAR2 | C01 | VENDOR_NAME | Name of supplier for which the agreement is created. | 100 | M | ||||||
| VARCHAR2 | CO2 | CONTRACT | Site for which agreement is created | 5 | M | ||||||
| VARCHAR2 | C03 | INFORMATION_TYPE | The type of message that has generated the incoming schedule. | 2000 | N | ||||||
| VARCHAR2 | C04 | SHIP_FROM | Supplementary information received from the customer about the location from which the parts are to be delivered | 2000 | N | ||||||
| VARCHAR2 | C05 | SHIP_TO | To which factory or site, the part is going to be be shipped. | 2000 | N | ||||||
| VARCHAR2 | C07 | SUPP_SCHEDULE_TYPE_DB | Type of schedule i.e Plan, Call-off | 20 | M | CUST_SCHEDULE_TYPE | Schedule Type, Plan or Call-off. | M | |||
| VARCHAR2 | C09 | SUPP_COUNTRY | Document Country of Supplier | 2000 | C | ||||||
| VARCHAR2 | C11 | ADDRESS_NAME | Alternative company address name | 100 | N | ||||||
| VARCHAR2 | C12 | COMPANY_ADDR | Company delivery address | 180 | N | ||||||
| VARCHAR2 | C13 | COMPANY_COUNTRY | Country of delivery for company | 2000 | N | ||||||
| VARCHAR2 | C14 | PHONE | Company phone | 200 | N | ||||||
| VARCHAR2 | C15 | FAX | Company fax | 200 | N | ||||||
| VARCHAR2 | C26 | EAN_LOCATION | Our own ID of the goods receiving address (i.e. our own address ID of the goods receiving site or customer's delivery address). | 100 | N | EAN_LOCATION_DEL_ADDR | Customer's own identification of the delivery address | 2000 | M | ||
| VARCHAR2 | C27 | MESSAGE_ID | Message identity | DOC_NO | Document Number. | 35 | M | ||||
| VARCHAR2 | C28 | OUR_CUSTOMER_NO | Customer ID at supplier. | 20 | C | supplier_info_our_id_tab.our_id, corresponding column is nullable, Both OurCustomerNo and internal supplier are NULL. Raise an error. | CUSTOMER_NO | Identification of the ordering customer | 20 | C | When INTERNAL_CUSTOMER_SITE (c30) is not received, CUSTOMER_NO (c28)
and EAN_LOCATION_DEL_ADDR (c26) are used to identify the address,
with priority given to CUSTOMER_NO. |
| VARCHAR2 | C30 | CONTRACT | The ordering site if internal supplier is used | 5 | M | INT_CUSTOMER_SITE | The site if internal supplier is used, will give the customer number. | N | |||
| DATE | D03 | VALID_FROM | Date/Time from which the schedule is valid. | M | VALID_FROM | Date/Time from which the schedule is valid. | M | ||||
| DATE | D04 | VALID_UNTIL | Date/Time until which the schedule is valid. | M | VALID_UNTIL | Date/Time until which the schedule is valid. | N | ||||
| VARCHAR2 | ROWSTATE | STATE | Status of the message line. | STATE | Status of message line. | ||||||
* States whether a value in the field is mandatory (M), non-mandatory (N), or conditional (C).
| DATA TYPE | COLUMN | Send Message | Receive Message | ||||||||
| Value | Description | SIZE | M/N/C* | COMMENTS | Value | Description | SIZE | M/N/C* | COMMENTS | ||
| NUMBER | MESSAGE_ID | EDI message no | Unique ID of the message generated by IFS/Connectivity. | EDI message no | Unique ID of the message generated by IFS/Connectivity. | ||||||
| NUMBER | MESSAGE_LINE | Row of message | Header should always be row number 1. | Row of message | Header should always be row number 1. | ||||||
| VARCHAR2 | NAME | ART | Type of message line (article). | ART | Type of message line (article). | ||||||
| VARCHAR2 | ERROR_MESSAGE | Error message for line | Generated by EDI converter. | Error message for line | Generated by EDI converter. | ||||||
| VARCHAR2 | C00 | PART_NO | Purchase part number | 25 | M | CUSTOMER_PART_NO | Customer's part number corresponding to the sales part number | 2000 | M | ||
| VARCHAR2 | C01 | PART_DESCRIPTION | Purchase part description | 200 | M | ||||||
| VARCHAR2 | C02 | LAST_RECEIPT_REFERENCE | Any delivery reference from the supplier for the last delivery considered prior to creating this schedule. If customer scheduling is used, this reference is equal to the delivery note number from last received delivery. | 15 | N | LAST_DELNOTE_NO | The delivery note number of the last delivery received by the customer for this part at the time of the customer schedule creation. | 2000 | N | ||
| VARCHAR2 | C03 | VENDOR_PART_NO | Supplier part number | 80 | N | ||||||
| VARCHAR2 | C04 | VENDOR_PART_DESCRIPTION | Supplier part description | 200 | N | ||||||
| VARCHAR2 | C05 | DELIVERY_POINT | Point of delivery for the part at the customer's address. | DELIVERY_POINT | Details to the delivery address that are specific for this part. | ||||||
| VARCHAR2 | C06 | NOTE_TEXT | Free note text sent from the customer. | 2000 | N | NOTE_TEXT | Free note text sent from the customer. | 2000 | N | ||
| VARCHAR2 | C07 | AGREEMENT_ID | Agreement number | 17 | M | ||||||
| VARCHAR2 | C08 | BUYER_CODE | Buyer code on purchase order | 20 | N | ||||||
| VARCHAR2 | C09 | BUYER_NAME | Buyer name on purchase order | 100 | N | CONTACT_PERSON | Contact person for this customer | 2000 | N | ||
| VARCHAR2 | C10 | PAY_TERM_ID | Payment terms on purchase order | 20 | N | ||||||
| VARCHAR2 | C11 | CURRENCY_CODE | Currency code on purchase order | 3 | N | ||||||
| VARCHAR2 | C12 | DELIVERY_TERMS | Delivery terms on purchase order | N | |||||||
| VARCHAR2 | C13 | DELIVERY_TERMS_DESC | Delivery terms description on purchase order | N | |||||||
| VARCHAR2 | C14 | SHIP_VIA_CODE | Ship via code on purchase order | N | |||||||
| VARCHAR2 | C15 | SHIP_VIA_DESC | Ship via code description on purchase order | N | |||||||
| VARCHAR2 | C16 | SCHED_REVISION | Revision number of the schedule | N | REF_SCHEDULE_NO | Customer's identification of the schedule | 2000 | N | |||
| VARCHAR2 | C17 | GTIN_NO | The default GTIN of the part | 14 | N | ||||||
| DATE | D00 | CUM_RECEIPT_START_DATE | Receipts made on or after this date are included in the cumulative receipt quantity | N | CUM_RECEIPT_DATE | Receipts made by the customer on or after this date are included in the cumulative receipt quantity. | N | ||||
| DATE | D01 | LAST_RECEIPT_DATE | Date/Time when the last receipt was made by the customer. | N | LAST_RECEIPT_DATE | The date the customer received the latest delivery from our company. | N | ||||
| DATE | D02 | CREATE_DATE | Date on which the schedule was created. | M | CREATED_DATE_CUSTOMER | Date on which the schedule was created at customer. | N | ||||
| DATE | D03 | APPROVED_DATE | Date on which the approval process was run. | N | APPROVED_DATE_CUSTOMER | Date on which the approval process was run at customer. | N | ||||
| NUMBER | N00 | QTY_IN_STOCK | Quantity of parts in stock when schedule was created | N | STOCK_QTY | Quantity of parts the customer has in stock. | N | ||||
| NUMBER | N01 | CUM_RECEIPT_QTY | Cumulative quantity of parts received from the supplier from a common date that both the supplier and we have agreed to count from | N | CUM_RECEIPT_QTY | Total quantity received by the customer from a common date that both the customer and we have agreed to count from | N | ||||
| NUMBER | N02 | LAST_RECEIPT_QTY | Quantity received last by the customer. | N | LAST_RECEIPT_QTY | Quantity of the part received by the customer at the last delivery | N | ||||
| NUMBER | N03 | SCHEDULE_NO | Schedule number | M | |||||||
| NUMBER | N20 | SEQUENCE_NO | DELSCH message sequence number | M | |||||||
| NUMBER | N21 | VERSION_NO | DELSCH message version number | N | |||||||
| VARCHAR2 | ROWSTATE | STATE | Status of the message line. | STATE | Status of the message line. | ||||||
* States whether a value in the field is mandatory (M), non-mandatory (N), or conditional (C).
| DATA TYPE | COLUMN | Send Message | Receive Message | ||||||||
| Value | Description | SIZE | M/N/C* | COMMENTS | Value | Description | SIZE | M/N/C* | COMMENTS | ||
| NUMBER | MESSAGE_ID | EDI message no | Unique ID of message generated by IFS/Connectivity. | EDI message no | Unique ID of message generated by IFS/Connectivity. | ||||||
| NUMBER | MESSAGE_LINE | Row of message | (Header should always be row number 1). | Row of message | (Header should always be row number 1). | ||||||
| VARCHAR2 | NAME | LIN | Type of message line (demand line). | LIN | Type of message line (demand line). | ||||||
| VARCHAR2 | ERROR_MESSAGE | Error message for line | Generated by EDI converter. | Error message for line | Generated by EDI converter. | ||||||
| VARCHAR2 | C00 | VENDOR_NO | Supplier number | 20 | M | ||||||
| VARCHAR2 | C01 | CONTRACT | Site for which agreement is created. | 5 | M | ||||||
| VARCHAR2 | C02 | PART_NO | Purchase part number | 25 | M | ||||||
| VARCHAR2 | C03 | NOTE_TEXT | Free note text sent from customer. | 2000 | N | NOTE_TEXT | Free note text sent from customer. | 2000 | N | ||
| VARCHAR2 | C04 | REF_ID | Automatically created unique identifier for the demand and only used in connection with IFS/Kanban | 35 | N | REF_ID | Customer-provided reference ID for a specific demand | 35 | N | ||
| VARCHAR2 | C05 | LINE_TYPE_ID | Line Type Indicator (Firm, Material, etc). | 3 | M | LINE_TYPE_ID | Specifies whether the schedule line should be used for demand or for information only. | 3 | N | ||
| VARCHAR2 | C06 | LINE_TYPE_DESC | Displays whether the schedule line should be delivery authorized | 35 | M | ||||||
| VARCHAR2 | C07 | CURR_CODE | Currency code | 3 | M | ||||||
| VARCHAR2 | C08 | UNIT_MEAS | Purchase unit of measure | 10 | M | ||||||
| VARCHAR2 | C09 | DOCK_CODE | Identifies a larger area within the receivers' facilities where goods are to be delivered. I.e., cargo bay. | 35 | N | DOCK_CODE | Identifies a larger area within the receivers' facilities where goods are to be delivered. I.e., cargo bay. | 35 | N | ||
| VARCHAR2 | C10 | SUB_DOCK_CODE | Identifies a specific area within the area specified by the dock code. I.e., gate on the cargo bay. | 35 | N | SUB_DOCK_CODE | Identifies a specific area within the area specified by the dock code. I.e., gate on the cargo bay. | 35 | N | ||
| VARCHAR2 | C12 | LOCATION_NO | Identifies an internal plant location beyond the subdock code. | LOCATION_NO | Identifies an internal plant location beyond the subdock code. | ||||||
| VARCHAR2 | C13 | CUSTOMER_PO_ NO | Identifies the customer's purchase order number. | CUSTOMER_PO_ NO | Identifies the customer's purchase order number. | 50 | N | ||||
| VARCHAR2 | C14 | CUSTOMER_PO_LINE NO | Identifies the customer's purchase order line number. | CUSTOMER_PO_LINE NO | Identifies the customer's purchase order line number. | 4 | N | ||||
| VARCHAR2 | C15 | CUSTOMER_PO_REL_NO | Identifies the customer's purchase order release number. | CUSTOMER_PO_REL_NO | Identifies the customer's purchase order release number. | 4 | N | ||||
| VARCHAR2 | C16 | PATTERN_DESCRIPTION | Information received from the customer about the time frame a specific demand quantity covers | 2000 | N | ||||||
| VARCHAR2 | C17 | PORT_OF_LOADING | Information received from the customer about the location at which the parts are to be loaded. | 2000 | N | ||||||
| VARCHAR2 | C18 | MANUFACTURING_DEPARTMENT | The manufacturing department to which the part should be delivered. | 2000 | N | ||||||
| VARCHAR2 | C19 | USE_CONTRACT | Information received from the customer regarding the price that should be used when releasing a customer schedule and creating customer order lines. | 200 | N | ||||||
| VARCHAR2 | C20 | PROVISIONAL_PRICE | Provisional price indicator tells if the part price received in the same schedule is provisional or fixed. | 200 | N | ||||||
| DATE | D00 | DUE_DATE | Delivery date/time when goods are to be at customer plant. | M | DUE_DATE | Date when the customer wants this particular delivery. | |||||
| DATE | D01 | TO_DATE | The date and time until which the line quantity is covered. | N | |||||||
| NUMBER | N00 | SCHEDULE_NO | Schedule number | N | |||||||
| NUMBER | N01 | SEQUENCE_NO | Sequence number on schedule | M | |||||||
| NUMBER | N02 | QTY_DUE | Reconciled quantity due for the schedule line or supply qty due if the quantity is not reconciled | M | QTY_DUE | The quantity of parts that the customer needs for this schedule line. | N | ||||
| NUMBER | N03 | QTY_DUE_CUM | Quantity of parts that you wish to receive in total. | N | QTY_DUE_CUM | The quantity of parts that your customer wish to receive in total. | N | ||||
| NUMBER | N04 | FBUY_UNIT_PRICE | Price per part assumed to be in the customer's default currency. | N | PART_PRICE | Information received from the customer regarding the price of a part. The price is usually expressed in the customers default currency. | N | ||||
| NUMBER | N05 | DELIVERY_SEQUENCE | Information received from the customer regarding the order in which the deliveries should be made. | N | |||||||
| VARCHAR2 | ROWSTATE | STATE | Status of the message line. | STATE | Status of the message line. | ||||||
* States whether a value in the field is mandatory (M), non-mandatory (N), or conditional (C).
Delivery Plan Previous Dispatch Note Row
| DATA TYPE | COLUMN | Send Message | Receive Message | ||||||||
| Value | Description | SIZE | M/N/C* | COMMENTS | Value | Description | SIZE | M/N/C* | COMMENTS | ||
| NUMBER | MESSAGE_ID | EDI message no | Unique ID of message generated by IFS/Connectivity. | EDI message no | Unique ID of message generated by IFS/Connectivity. | ||||||
| NUMBER | MESSAGE_LINE | Row of message | Header should always be row number 1. | Row of message | Header should always be row number 1. | ||||||
| VARCHAR2 | NAME | PDN | Type of message line (previous dispatch note). | PDN | Type of message line (previous dispatch note). | ||||||
| VARCHAR2 | ERROR_MESSAGE | Error message for line | Generated by EDI converter. | Error message for line | Generated by EDI converter. | ||||||
| VARCHAR2 | C00 | VENDOR_NO | Supplier number | 20 | M | ||||||
| VARCHAR2 | C01 | CONTRACT | Site for which agreement is created. | 5 | M | ||||||
| VARCHAR2 | C02 | PART_NO | Purchase part number | 25 | M | ||||||
| VARCHAR2 | C03 | RECEIPT_REFERENCE | Delivery reference from the supplier for the last delivery considered prior to creating this schedule. | 15 | N | DELNOTE_NO | Delivery note number of the delivery note created for the delivery, or partial delivery, of a customer order. | 2000 | N | ||
| VARCHAR2 | C04 | NOTE_TEXT | Free note text sent from customer. | 2000 | N | NOTE_TEXT | Free note text sent from customer. | 2000 | N | ||
| NUMBER | N00 | SCHEDULE_NO | Schedule number | M | |||||||
| NUMBER | N01 | SEQUENCE_NO | Number of the receipt | M | |||||||
| NUMBER | N02 | RECEIPT_QTY | Previous received quantity. | M | QTY_RECEIVED | Previous received quantity. | N | ||||
| NUMBER | N03 | BUY_QTY_DUE | Advised quantity for previously received dispatch. | N | QTY_ADVISED | Advised quantity for previously received dispatch. | N | ||||
| DATE | D00 | RECEIPT_DATE | Previous received delivery date. | M | DELIVERY_DATE | Previous received delivery date. | M | ||||
| VARCHAR2 | ROWSTATE | STATE | Status of the message line. | STATE | Status of the message line. | ||||||
* States whether a value in the field is mandatory (M), non-mandatory (N), or conditional (C).