Price Lists/Agreements (PRICAT)

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.

Price List Header 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 (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).

Price List 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 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).

Agreement Header 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 (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).

Agreement 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 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).