Since it is possible to send the message from both price lists and customer agreements, there is one specification for price lists and one for customer agreements defined below.
Both the price list message and the customer agreement message contain two types of rows: header and line.
| Data Type | COLUMN | Send Message | Receive Message | ||||||||
| Value | Description | SIZE | M/N/C* | COMMENT | Value | Description | SIZE | M/N/C* | COMMENT | ||
| NUMBER | MESSAGE_ID (FK) | MESSAGE_ID | Unique ID of message generated by IFS Connectivity | MESSAGE_ID | 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 | Line type | Identifies the line type of the message; in this case, HEADER | Line type | Identifies the line type of the message; in this case, HEADER | ||||||
| VARCHAR2 | ERROR_MESSAGE | Error message for line | Generated by EDI converter | Error message for line | Generated by EDI converter | ||||||
| VARCHAR2 | C00 | PRICE_LIST_NO | The customer price list ID | 10 | M | PRICE_CATALOG_NO | Supplier's price catalog number | 2000 | N | ||
| VARCHAR2 | C01 | STATUS | Code that indicates if this price catalog is a original price catalog or a replacement price catalog | 12 | M | PRICE_CATALOG_STATUS_DB | Code that indicates if this price catalog is a original price catalog or a replacement price catalog | 2000 | N | ||
| VARCHAR2 | C02 | CUSTOMER_AGREEMENT_IDENTITY | Customer's agreement | 25 | N | AGREEMENT_REF | If the message is connected to a supplier agreement, the supplier agreement number | 2000 | N | ||
| VARCHAR2 (NUMBER in EDIFACT) | C03 | EAN_LOCATION | Identified by EAN | 100 | N | SUPPLIER_ID_EAN | Supplier's ID | 2000 | N | ||
| VARCHAR2 | C04 | GET_SUPPLIER_ID | Your ID at customer | 20 | N | SUPPLIER_ID | Identity of the supplier to whom the price list is being sent | 20 | N | ||
| VARCHAR2 | C05 | COMPANY | Company name | 20 | M | SUPPLIERS_OWN_ID | The company identity used by the supplier for its own address when the supplier participates in EDI communication. | 20 | N | ||
| VARCHAR2 (NUMBER in EDIFACT) | C06 | GET_EAN_LOCATION | 100 | N | OUR_ID_EAN | Company's identity as the supplier has it entered in EAN format. | 100 | N | |||
| VARCHAR2 | C07 | CUSTOMER_NO | Customer number | 20 | M | OUR_ID | Your company's identity as the supplier has it entered in text format (if EAN is not used). | 2000 | N | ||
| VARCHAR2 | C08 | COMPANY | Company name | 20 | N | ||||||
| VARCHAR2 | C09 | SUP_PRICE_LIST_NO | The number of the price list sent to the customer | 10 | C | Send_Price_List / If the price list is already
sent to any customer, for the second time this field will have a value
else this could be null. SALES_PRICE_LIST_TAB.sup_price_list_no, corresponding
column is nullable or Send by the client. sales_price_list_tab.price_list_no,
corresponding column is not nullable Send_Agreement / If the agreement
is already sent to any customer, for the second time this field will
have a value else this could be null. CUSTOMER_AGREEMENT_TAB .sup_agreement_id, corresponding column is nullable or Send by the client. customer_Agreement_tab.agreement_id, corresponding column is not nullable | PRICE_CATALOG_REF | Price catalog to which this message refers (used when C01 is replacement) | 20 | N | |
| VARCHAR2 | C10 | CURRENCY_CODE | Currency used for the prices in the list | 3 | M | CURRENCY_CODE | Currency used for the prices in the list | 2000 | N | ||
| VARCHAR2 | C11 | CUSTOMER_AGREEMENT_IDENTITY | Our agreement reference | 10 | M | SUPPLIER_AGREEMENT_REF | Reference to the supplier's supplier agreement | 20 | N | ||
| VARCHAR2 | C13 | DELIVERY TERMS CODE | Delivery Terms Identity | 3 | N | ||||||
| VARCHAR2 | C14 | DELIVERY TERMS DESCRIPTION | Delivery Terms Description | 35 | C | Send_Agreement / If delivery term code exists, this is mandatory. ORDER_DELIVERY_TERM_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | C15 | SHIP VIA CODE | Ship Via Code | 3 | N | ||||||
| VARCHAR2 | C16 | SHIP VIA DESCRIPTION | Ship Via Code Description | 35 | C | Send_Agreement / If ship via code exists, this is mandatory. MPCCOM_SHIP_VIA_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | C17 | USE_PRICE_INCL_TAX | Use Price Including Tax | 20 | M |
| USE_PRICE_INCL_TAX_DB | Use Price Including Tax | 20 | M | |
| VARCHAR2 | C95 | COMPANY_ASSOCIATION_NO | Company Association Number | 50 | N | COMPANY_ASSOCIATION_NO | Company Association Number | 50 | N | ||
| VARCHAR2 | C96 | CUSTOMER_ASSOCIATION_NO | Customer's Association Number | 50 | N | CUSTOMER_ASSOCIATION_NO | Customer's Association Number | 50 | N | ||
| NUMBER | N20 | MESSAGE SEQUENCE NO | Message Sequence Number | M | |||||||
| NUMBER | N21 | MESSAGE VERSION NO | Connectivity Message Version | M | |||||||
| DATE | D00 | SITE_DATE | Date when the price catalog was published, i.e., Sender date | M | DATE_PUBLISHED | Date when the price catalog was published by the supplier. | N | ||||
| DATE | D01 | VALID_FROM | Date from which the price catalog is valid; Fetched from Sender dialog. | M | VALID_ FROM | Date from which the price catalog is valid; Fetched from Sender dialog. | N | ||||
| DATE | D02 | VALID_TO | Date to which the price catalog is valid (only used if the prices are not valid until further notice) | N | VALID_ TO | Date to which the price catalog is valid (only used if the prices are not valid until further notice) | N | ||||
| VARCHAR2 | STATE | STATUS | 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* | COMMENT | Value | Description | SIZE | M/N/C* | COMMENT | ||
| NUMBER | MESSAGE_ID | MESSAGE_ID | Generated by IFS/Connectivity | MESSAGE_ID | Generated by IFS/Connectivity | ||||||
| NUMBER | MESSAGE_LINE | Row of message | Each message can consist of several lines | Row of message | Each message can consist of several lines | ||||||
| VARCHAR2 | NAME | LINE TYPE | Identifies the line type of the message, in this case LINE | LINE TYPE | Identifies the line type of the message, in this case LINE | ||||||
| VARCHAR2 | ERROR_MESSAGE | Error Message for the line | Generated by the EDI converter | Error Message for the line | Generated by the EDI converter | ||||||
| VARCHAR2 | C00 | PRICE_CATALOG_ACTION_CODE | Code that indicates action code for part. Will always be "Added" in IFS Cloud. | 5 | M | ACTION_CODE_DB | Code that indicates action code for part. Will always be "Added" in IFS Cloud. | 7 | M | ||
| VARCHAR2 | C02 | CATALOG_NO | Part number | 25 | M | SUPPLIER_PART_NO | Supplier's own part number in text format (if EAN code is not used). | 2000 | N | ||
| VARCHAR2 | C03 | CUSTOMER_PART_NO | Customer part number | 45 | N | PART_NO | The part number of the purchase part | 25 | N | ||
| VARCHAR2 | C04 | CURRENCY_CODE | Currency associated with the price list | 3 | M | CURRENCY_CODE | Currency of the price | 3 | N | ||
| VARCHAR2 | C05 | PRICE_UNIT_MEAS | The price unit used for this part on price list | 10 | N | BUY_UNIT_MEAS | The price unit of measure used for the part,as specified by the supplier. | 30 | N | ||
| VARCHAR2 | C06 | AGREEMENT REFERENCE | Customer Agreement Identity | 10 | M | AGREEMENT_REFERENCE | If the message is connected to a supplier agreement, the number of the supplier agreement | 12 | N | ||
| VARCHAR2 | C07 | CATALOG_GROUP | Sales group ID for sales part | 10 | M | ||||||
| VARCHAR2 | C08 | CATALOG_GROUP_DESC | Sales group description for sales part | 35 | M | ||||||
| VARCHAR2 | C09 | SALES_PRICE_GROUP_ID | Sales price group ID for sales part | 10 | M | ||||||
| VARCHAR2 | C10 | SALES_PRICE_GROUP_DESC | Sales price group description for sales part | 35 | M | ||||||
| VARCHAR2 | C11 | PRIME_COMMODITY | Commodity group1 ID for inventory part | 5 | N | ||||||
| VARCHAR2 | C12 | PRIME_COMMODITY_DESC | Commodity group1 description for inventory part | 35 | C | Send_Price_List / Exists when CommodityGroup1Id is there. COMMODITY_GROUP_TAB.description, corresponding column is not nullable Send_Agreement / Exists when CommodityGroup1Id is there. COMMODITY_GROUP_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | C13 | SECOND_COMMODITY | Commodity group2 ID for inventory part | 5 | N | ||||||
| VARCHAR2 | C14 | SECOND_COMMODITY_DESC | Commodity group2 description for inventory part | 35 | C | Send_Price_List / Exists when CommodityGroup2Id is there. COMMODITY_GROUP_TAB.description, corresponding column is not nullable Send_Agreement / Exists when CommodityGroup1Id is there. COMMODITY_GROUP_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | C15 | PART_PRODUCT_CODE | Product code for inventory part | 5 | N | ||||||
| VARCHAR2 | C16 | PART_PRODUCT_CODE_DESC | Product code description for inventory part | 35 | C | Send_Price_List / Exists when ProductCodeId is there. INVENTORY_PRODUCT_CODE_TAB.description, corresponding column is nullable Send_Agreement / Exists when ProductCodeId is there. INVENTORY_PRODUCT_CODE_TAB.description, corresponding column is nullable | |||||
| VARCHAR2 | C17 | PART_PRODUCT_FAMILY | Shows product family for inventory part | 5 | N | ||||||
| VARCHAR2 | C18 | PART_PRODUCT_FAMILY_DESC | Product family description for inventory part | 35 | C | Send_Price_List / Exists when ProductFamilyId is there. INVENTORY_PRODUCT_FAMILY_TAB.description, corresponding column is not nullable Send_Agreement / Exists when ProductFamilyId is there. INVENTORY_PRODUCT_FAMILY_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | C19 | GTIN_NO | The Default GTIN of the part | 14 | N | GTIN_NO | GTIN used for identification of the part | 14 | N | ||
| DATE | D00 | VALID_FROM_DATE | The date from which this price is valid; Can differ from the date on the message header | M | VALID_FROM | The date from which this price is valid; Can differ from the date on the message header | N | ||||
| DATE | D01 | VALID_TO_DATE | The date until which this price is valid; Fetch date from header as it is not specified per line | N | VALID_UNTIL | The date until which this price is valid; Fetch date from header as it is not specified per line | N | ||||
| DATE | D02 | LAST_UPDATED | Date when the price list line last was updated | M | |||||||
| NUMBER | N00 | SALES_PRICE | Sales price of the sales part | M | PRICE | Price expressed in the currency of the supplier for purchase part. | N | ||||
| NUMBER | N01 | DISCOUNT | Discount in percent | M | DISCOUNT | Discount in percent | N | ||||
| NUMBER | N02 | MIN_QUANTITY | Minimum quantity for a certain price | M | MIN_QUANTITY | Minimum quantity for a certain price | N | ||||
| NUMBER | N03 | MAX_QTY | Maximum quantity for a certain price; Always set to null | N | |||||||
| NUMBER | N05 | SALES_PRICE_INCL_TAX | Sales price including tax of the sales part | M | PRICE_INCL_TAX | Price including tax expressed in the currency of the supplier for purchase part. | N | ||||
| NUMBER | N06 | ADDITIONAL_COST_INCL_TAX | Additional cost amount including tax | N | |||||||
| NUMBER | N04 | ADDITIONAL_COST_AMOUNT | Additional cost amount | N | |||||||
| NUMBER | N20 | SEQUENCE_NO | PRICAT message sequence number | ||||||||
| NUMBER | N21 | VERSION_NO | PRICAT message version number | ||||||||
| VARCHAR2 | STATE | STATUS | 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* | COMMENT | Value | Description | SIZE | M/N/C* | COMMENT | ||
| NUMBER | MESSAGE_ID (FK) | MESSAGE_ID | Unique ID of message generated by IFS ConneESSAGE_LINE | Row of message | Header should always be row number 1 | ||||||
| VARCHAR2 | NAME | Line_type | Identifies the line type of the message; in this case, HEADER | ||||||||
| VARCHAR2 | ERROR_MESSAGE | Error message for line | Generated by EDI converter | ||||||||
| VARCHAR2 | C01 | STATUS | Code that indicates if this price catalog is a original price catalog or a replacement price catalog | 12 | M | PRICE_CATALOG_STATUS | 2000 | N | |||
| DATE | D00 | AGREEMENT_DATE | Date when the price catalog was published, i.e., agreement date | M | DATE_PUBLISHED | N | |||||
| VARCHAR2 | C02 | CUST_AGREEMENT_ID | Reference to customer ID of the agreement | 25 | N | AGREEMENT_REF | 2000 | N | |||
| VARCHAR2 (NUMBER in EDIFACT) | C03 | EAN_LOCATION | Identified by EAN | 100 | N | SUPPLIER_ID_EAN | 2000 | N | |||
| VARCHAR2 | C04 | SUPPLIER_ID | Your ID at customer | 20 | N | SUPPLIER_ID | 20 | N | |||
| VARCHAR2 | C05 | COMPANY | Company Identity | 20 | M | SUPPLIERS_OWN_ID | 20 | N | |||
| VARCHAR2 (NUMBER in EDIFACT) | C06 | OUR_CUSTOMER_ID_ IN_EAN | Customer's own ID for an address | 100 | N | OUR_ID_EAN | 100 | N | |||
| VARCHAR2 | C07 | CUSTOMER_NO | Customer identity | 20 | M | OUR_ID | 2000 | N | |||
| DATE | D01 | VALID_FROM | Date from which the customer agreement is valid | M | |||||||
| DATE | D02 | VALID_TO | Date to which the price catalog is valid (only used if the prices are not valid until further notice) | N | |||||||
| VARCHAR2 | C09 | SUP_AGREEMENT_ID | The superseded agreement identity (used when C01 is replacement) | 10 | C | Send_Price_List / If the price list is already sent to any customer, for the second time this field will have a value else this could be null. SALES_PRICE_LIST_TAB.sup_price_list_no, corresponding column is nullable or Send by the client. sales_price_list_tab.price_list_no, corresponding column is not nullable Send_Agreement / If the agreement is already sent to any customer, for the second time this field will have a value else this could be null. CUSTOMER_AGREEMENT_TAB.sup_agreement_id, corresponding column is nullable or Send by the client. customer_Agreement_tab.agreement_id, corresponding column is not nullable | 20 | N | |||
| VARCHAR2 | C10 | CURRENCY_CODE | Currency used for the prices in the list | 3 | M | CURRENCY_CODE | 2000 | N | |||
| VARCHAR2 | C11 | AGREEMENT_ID | Reference to your agreement ID, for which these prices are valid | 10 | M | SUPPLIER_AGREEMENT_REF | 20 | N | |||
| VARCHAR2 | C13 | DELIVERY_TERMS | Delivery terms code | 3 | N | ||||||
| VARCHAR2 | C14 | DELIVERY_TERMS_DESC | Delivery terms description | 35 | C | Send_Agreement / If delivery term code exists, this is mandatory. ORDER_DELIVERY_TERM_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | C15 | SHIP_VIA_CODE | Ship via code | 3 | N | ||||||
| VARCHAR2 | C16 | SHIP_VIA_CODE_DESC | Ship via description | 35 | C | Send_Agreement / If ship via code exists, this is mandatory. MPCCOM_SHIP_VIA_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | STATE | STATUS | 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* | COMMENT | VALUE | DESCRIPTION | SIZE | M/N/C* | COMMENT | ||
| NUMBER | MESSAGE_ID | EDI/MHS_Message_ID | Generated by IFS/Connectivity | ||||||||
| NUMBER | MESSAGE_LINE | Row of message | Each message can consist of several lines | ||||||||
| VARCHAR2 | NAME | Line_Type | Identifies the line type of the message; in this case, LINE | ||||||||
| VARCHAR2 | ERROR_MESSAGE | Error Message for the line | Generated by the EDI converter | ||||||||
| VARCHAR2 | C00 | PRICE_CATALOG_ACTION_CODE | Code that indicates action code for part; Will always be "Added" in IFS Cloud. | 5 | M | ACTION_CODE_DB | 7 | M | |||
| VARCHAR2 | C02 | CATALOG_NO | Our part number in text format (if C01 is not used) | 25 | M | SUPPLIER_PART_NO | 2000 | N | |||
| VARCHAR2 | C03 | CUSTOMER_PART_NO | Customer part number | 45 | N | PART_NO | 25 | N | |||
| VARCHAR2 | C04 | CURRENCY_CODE | Currency which the price is stated in | 3 | M | CURRENCY_CODE | 3 | N | |||
| VARCHAR2 | C06 | AGREEMENT_ID | Reference to the agreement ID for which these prices are valid; Not used for price lists | 10 | M | 12 | N | ||||
| VARCHAR2 | C07 | CATALOG_GROUP | Sales group ID for sales part | 10 | M | ||||||
| VARCHAR2 | C08 | CATALOG_GROUP_DESCRIPTION | Sales group description for sales part | 35 | M | ||||||
| VARCHAR2 | C09 | SALES_PRICE_GROUP_ID | Sales price group ID for sales part | 10 | M | ||||||
| VARCHAR2 | C10 | SALES_PRICE_GROUP_DESC | Sales price group description for sales part | 35 | M | ||||||
| VARCHAR2 | C11 | PRIME_COMMODITY | Commodity group1 ID for inventory part | 5 | N | ||||||
| VARCHAR2 | C12 | PRIME_COMMODITY_DESC | Commodity group1 description for inventory part | 35 | C | Send_Price_List / Exists when CommodityGroup1Id is there. COMMODITY_GROUP_TAB.description, corresponding column is not nullable Send_Agreement / Exists when CommodityGroup1Id is there. COMMODITY_GROUP_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | C13 | SECOND_COMMODITY | Commodity group2 ID for inventory part | 5 | N | ||||||
| VARCHAR2 | C14 | SECOND_COMMODITY_DESC | Commodity group2 description for inventory part | 35 | C | Send_Price_List / Exists when CommodityGroup2Id is there. COMMODITY_GROUP_TAB.description, corresponding column is not nullable Send_Agreement / Exists when CommodityGroup1Id is there. COMMODITY_GROUP_TAB.description, corresponding column is not nullable | |||||
| VARCHAR2 | C15 | PART_PRODUCT_CODE | Product code for inventory part | 5 | N | ||||||
| VARCHAR2 | C16 | PART_PRODUCT_DESC | Product code description for inventory part | 35 | C | ||||||
| VARCHAR2 | C17 | PART_PRODUCT_FAMILY | Product family for inventory part | 5 | N | ||||||
| VARCHAR2 | C18 | PART_PRODUCT_FAMILY_DESC | Product family description for inventory part | 35 | C | ||||||
| VARCHAR2 | C19 | GTIN_NO | The Default GTIN of the part | 14 | N | GTIN_NO | GTIN used for identification of the part | 14 | N | ||
| DATE | D00 | VALID_FROM | The date from which this price is valid; Fetch date from header as it is not specified per line | M | VALID_FROM | N | |||||
| DATE | D01 | VALID_UNTIL | The date until this price is valid; Fetch date from header as it is not specified per line | N | VALID_UNTIL | N | |||||
| VARCHAR2 | C21 | PRICE_UNIT_MEAS | The price unit used for this part on customer agreement | SALES_UNIT | |||||||
| NUMBER | N00 | DEAL_PRICE | Price for the part | M | PRICE | ||||||
| NUMBER | N01 | DISCOUNT | Discount in percent | M | DISCOUNT | ||||||
| VARCHAR2 | STATE | STATUS | Status of the message line | ||||||||
* States whether a value in the field is mandatory (M), non-mandatory (N), or conditional (C).