Invoices (INVOIC)

Invoices (INVOIC) message is used to send the invoice information from the supplier to the customer. This message can be sent by MHS or EDI.

This message has two types of rows:

Invoice 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)		 EDI message ID Unique ID of message generated by IFS Connectivity       MESSAGE_ID (FK) EDI message ID      
NUMBER MESSAGE_
LINE		 Row of message Header should always be row number 1       MESSAGE_LINE Row of message      
VARCHAR2 NAME Header Type of message line       NAME Header      
VARCHAR2 ERROR_
MESSAGE		 Error message
for line		 Generated by EDI converter       ERROR_MESSAGE Error message for line      
VARCHAR2 C00 INVOICE_TYPE Type of invoice 20 M   INVOICE_TYPE Type of invoice 20 N  
VARCHAR2 C01 INVOICE_SERIES_ID+ INVOICE_NO (concatenated) Invoice identity 70 M   INVOICE_NO Invoice identity 50 M  
VARCHAR2 C02 ORDER_NO Supplier order number 12 N   SUPPLIER_ORDER_NO Customer order number 12 N  
VARCHAR2 C03 PO_REFERENCE Purchase order number 50 N   PO_REFERENCE Purchase order number 2000
(4000)		 N  
VARCHAR2 C04 CURRENCY Invoice currency 3 N   CURRENCY Invoice currency 3 M  
VARCHAR2 C05 PAY_TERM_DESC Payment terms description 100 M        
VARCHAR2 C88 INVOICE_TEXT_ID Identity of invoice text 20 N   INVOICE_TEXT_ID Identity of invoice text 20 N
VARCHAR2 C93 INVOICE_TEXT Invoice text 2000 N   INVOICE_TEXT Invoice text 2000 N
DATE D00 INVOICE_DATE Creation date of invoice   M   INVOICE_DATE Creation date of invoice   M  
DATE D01 DUE_DATE Payment due date   M   DUE_DATE Payment due date   M  
DATE D02 ORDER_DATE The date when the order was entered   N        
DATE D03 DELIVERY_DATE The latest date on which the order was delivered   N   DELIVERY_DATE The latest date on which the order was delivered   N  
DATE D04 PAY_TERM_
BASE_DATE		 The date to be used as the base for payment term calculations to calculate the due date   M   PAY_TERM_BASE
_DATE		 The date to be used as the base for payment term calculations to calculate the due date   N  
DATE D05 WANTED_
DELIVERY_DATE		 Date on which the customer wants the order to be delivered at the customer's delivery address.   N        
DATE D07 REF_DATE The date of the invoice communicated to the customer.   C If debit invoice no has a value      
NUMBER N00 PAY_TERM_
DUE_DAYS		 Due Date - Invoice Date   M        
NUMBER N07 INVOICE_FEE Invoicing fee   N   INVOICE_FEE Invoicing fee   N  
NUMBER N08 ROUNDING_
INVOICE_FEE		 Invoice rounding amount   N   INVOICE_ROUNDING Invoice rounding amount   N  
NUMBER N09     N ORIGINAL_GROSS
_AMOUNT		 Gross amount of the invoice when it was originally loaded   N  
NUMBER N13 REF_NET_CURR_AMOUNT Reference Invoice Total Net Amount in Invoice Currency   N        
NUMBER N14 REF_VAT_
CURR_AMOUNT		 Reference Invoice Total Tax Amount in Invoice Currency   N        
NUMBER N15 REF_VAT_
DOM_AMOUNT		 Reference Invoice Total Tax Amount in Accounting Currency   N        
NUMBER N16 NET_CURR_AMOUNT Invoice net amount   N        
NUMBER N17 VAT_CURR_AMOUNT Invoice TAX amount   N        
NUMBER N18 SHIPMENT_ID Shipment ID   N   SHIPMENT_ID Shipment ID   N  
NUMBER N20 SEQUENCE_NO INVOIC message sequence number   M        
NUMBER N21 VERSION_NO INVOIC message version number   M        
VARCHAR2 C06 CUSTOMER_ID Customer identity 20 M   CUSTOMER_ID Supplier identity 20 N  
VARCHAR2 C07 CUST_NAME Customer name 100 M        
VARCHAR2 C08 VAT_NO Customer TAX number 50 N        
VARCHAR2 C09 INVOICE_
ADRESS_ID		 Invoice address identity 50 N        
VARCHAR2 C10 INV_ADDR1 Invoice address 1 75 N        
VARCHAR2 C11 INV_ADDR2 Invoice address 2 35 N        
VARCHAR2 C12 INV__ZIP_CODE Invoice address Zip Code 35 N        
VARCHAR2 C13 INV_CITY Invoice address City 35 N        
VARCHAR2 C14 INV_STATE Invoice address State 35 N        
VARCHAR2 C15 INV_COUNTRY
_CODE		 Invoice address country code 2 M        
VARCHAR2 C16 DELIV_
CUSTOMER_ID		 Delivery customer number 200 M        
VARCHAR2 C17 VAT_NO Delivery customer TAX number 50 N        
VARCHAR2 C18 DELIVERY
ADDRESS_ID		 Delivery address identity 50 N        
VARCHAR2 C19 DELIVERY_ADDRESS Receiver name for delivery address 100 M        
VARCHAR2 C20 DEL_ADDR1 Delivery address 1 75 N        
VARCHAR2 C21 DEL_ADDR2 Delivery address 2 35 N        
VARCHAR2 C22 DEL_ZIP_CODE Delivery address Zip code 35 N        
VARCHAR2 C23 DEL_CITY Delivery address City 35 N        
VARCHAR2 C24 DEL_STATE Delivery address State 35 N        
VARCHAR2 C25 DEL_COUNTRY
 CODE		 Delivery address country code 2 M        
VARCHAR2 C26 SUPPLIER_NO Supplier identity 20 N   SUPPLIER_NO Customer identity 20 N  
VARCHAR2 C27 SUPPLIER_NAME Name of the company to which the supplier is linked 100 M        
VARCHAR2 C28 SUPPLIER_
VAT_NO		 Supplier TAX number 50 N        
VARCHAR2 C29 SUPPLIER_
ADRESS_ID		 Supplier document address identity 50 C   This will be mandatory when the invoice creator is INSTANT_INVOICE_API or PROJECT_INVOICE_API      
VARCHAR2 C30 SUP_ADDR1 Supplier's Document address 1 75 N        
VARCHAR2 C31 SUP_ADDR2 Supplier's Document address 2 35 N        
VARCHAR2 C32 SUP_ZIP_CODE Supplier's Document address zip code 35 N        
VARCHAR2 C33 SUP_CITY Supplier's Document address city 35 N        
VARCHAR2 C34 SUP_STATE Supplier's Document address state 35 N        
VARCHAR2 C35 SUP_COUNTRY
_CODE		 Supplier's document address country code 2 M        
VARCHAR2 C36 YOUR_REFERENCE Customer's reference 100 N   OUR_REFERENCE Name of the contact 200 N  
VARCHAR2 C37 OUR_REFERENCE Your reference 100 N   YOUR_REFERENCE Customer's reference 200 N  
VARCHAR2 C38 DELIVERY_TERMS
_DESC		 Delivery terms description 50 N   DELIVERY_TERMS
_DESC		 Delivery terms description 200 N  
VARCHAR2 C39 SHIP_VIA_DESC Ship via description 50 N   SHIP_VIA_DESC Ship via description 200 N  
VARCHAR2 C40 FORWARD_AGENT
_ID		 Forward agent 35 N   FORWARD_AGENT_ID Forward agent 200 N  
VARCHAR2 C41 LABEL_NOTE Label note 100 N   LABEL_NOTE Label note 200 N  
VARCHAR2 C42 HEADER_DOC_
TEXT		 Header Document Text   N   TEXT Header Note 2000    
VARCHAR2 C43 ADDRESS Customers EDI address 200 M        
VARCHAR2 C44 ADDRESS Company EDI address 30 N SUPPLIER_COMMUNICATION_ID is fetched from company’s message setup if that exists or else from the customer’s message setup.      
VARCHAR2 C45 MEDIA_CODE Way of communication (EDI, MHS, etc)            
VARCHAR2 C46 Cust EAN Location
 Doc Addr		 EAN location no. for customer document address 100 N        
VARCHAR2 C47 Cust EAN Location
 Del Addr		 EAN location no. for customer delivery address 100 N        
VARCHAR2 C48 EAN Location Doc
 Addr		 EAN location no. for your document address            
VARCHAR2 C49       EDI_RECEIVER EDI receiver ID for company      
VARCHAR2 C50 CUSTOMER_COMPANY EDI receiver ID for company       COMPANY Company      
VARCHAR2 C51       CREATORS_REFERENCE The name of the person who created the invoice      
VARCHAR2 C52   20 N INVOICE_RECIPIENT The recipient of the invoices for the supplier 20 N  
VARCHAR2 C53   2000 N RECEIPT_REF Reference to one or more delivery receipts 2000 N  
VARCHAR2 C54   50 N BATCH If the invoice is processed as a batch job, the ID given to the batch to which the invoice belonged 50 N  
VARCHAR2 C55 SERIES_REFERENCE + NUMBER_REFERENCE Invoice series and invoice number of the connected debit invoice, when the invoice message is of a credit invoice 70 N   SERIES_REFERENCE + NUMBER_REFERENCE Invoice series and invoice number of the connected debit invoice, when the invoice message is of a credit invoice 70 N  
VARCHAR2 C56 DEL_COUNTY Invoice Address County 3 N        
VARCHAR2 C57 COUNTY   35        
VARCHAR2 C58 SUP_COUNTY   35        
VARCHAR3 C59 NCF_REFERENCE The reference number on the invoice 50 N   NCF_REFERENCE The payment reference number on the supplier invoice 50 N  
VARCHAR2 C60 REF_CURRENCY Reference Invoice Currency (The reference invoice currency can be specified in the Customer Orders/Invoicing of Customer Orders/Customer Invoice/General tab or in the Invoice/Customer Invoices/Customer Invoice/Line tab.) 3 N       N
VARCHAR2 C61 ACCOUNT The bank account number. 100 M   ACCOUNT The bank account number. 100 M  
VARCHAR2 C62 BIC_CODE The bank identifier code used with the bank account. 20 M            
VARCHAR2 C65 INVOICE_TYPE Correction Invoice /Advance Invoice /Credit Invoice/Collective Invoice /Invoice 2000 M        
VARCHAR2 C66 CROSS_REFERENCE
_INFO_1		 Free text 200 N        
VARCHAR2 C67 CROSS_REFERENCE
_INFO_2		 Free text 200 N        
VARCHAR2 C68 CROSS_REFERENCE
_INFO_3		 Free text 200 N        
VARCHAR2 C69 CROSS_REFERENCE
_INFO_4		 Free text 200 N        
VARCHAR2 C70 CROSS_REFERENCE
_INFO_5		 Free text 200 N

 

        
VARCHAR2 C71 CROSS_REFERENCE
_INFO_1		 Free text 200 N        
VARCHAR2 C72 CROSS_REFERENCE
_INFO_2		 Free text 200 N        
VARCHAR2 C73 CROSS_REFERENCE
_INFO_3		 Free text 200 N        
VARCHAR2 C74 CROSS_REFERENCE
_INFO_4		 Free text 200 N        
VARCHAR2 C75 CROSS_REFERENCE
_INFO_5		 Free text 200 N        
VARCHAR2 C76 DEL_TERMS_LOCATION Delivery terms location 200 N   DEL_TERMS_LOCATION Delivery terms location 100 N  
VARCHAR2 C80 SOURCE_COMP_COUNTRY Country Code of the Sender Company 2 M   SOURCE_COMP_COUNTRY Country Code of the Sender Company 2 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).

Invoice 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 (FK) EDI message ID Unique ID of message generated by IFS Connectivity       EDI message ID Unique ID of message generated by IFS Connectivity      
NUMBER MESSAGE_LINE Row of message Each message can hold several lines       Row of message Each message can hold several lines      
VARCHAR2 NAME Row Type of message line       Row 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 SERIES_ID+ INVOICE_NO (concatenated) Invoice identity 70 M   INVOICE_NO Invoice identity 50 M  
VARCHAR2 C01 ITEM_POS Invoice item position 20 M   ITEM_POS Invoice item position 20 M  
VARCHAR2 C02 CATALOG_NO Supplier part number 25 N   SUP_PART_NO Supplier's part number 80 N  
VARCHAR2 C03 DESCRIPTION Supplier part description / Invoice text 200 N   SUP_PART_DESC Supplier's part description 200 N  
VARCHAR2 C04 PURCHASE_PART Purchase part number 50 N   PUR_PART_NO Purchase part number 25 N  
VARCHAR2 C05 PURCHASE_PART_DESCRIPTION Purchase part description 200 N   PUR_PART_DESC Purchase part description 200 N  
VARCHAR2 C06 SALES_UNIT_MEAS Supplier sales unit measures 100 N   SALES_UM Supplier sales unit measures 20 N  
VARCHAR2 C07 PRICE_UNIT_MEAS Supplier price unit meas. 100 N   PRICE_UM Supplier price unit meas. 20 N  
VARCHAR2 C08 VAT_CODE TAX code 20 N   VAT_CODE TAX code 20 N  
VARCHAR2 C09 ORDER_NO Supplier order number 100 N        
VARCHAR2 C10 LINE_NO Supplier order line number 100 N   LINE_NO Supplier order line number 2000 N  
VARCHAR2 C11 RELEASE_NO Supplier release number of order line 4 N   RELEASE_NO Supplier release number of order line 2000 N  
VARCHAR2 C12 CUSTOMER_PO_NO Customer purchase order number 100 N   PO_REFERENCE A reference to one or more purchase orders 1000 N  
VARCHAR2 C13 TAX_TEXT Tax code text 500 N   TAX_TEXT Tax code text 500 N  
VARCHAR2 C14 SERIES_REFERENCE + NUMBER_REFERENCE The reference to the debit invoice origin of the credit invoice line 70 N   SERIES_REFERENCE + NUMBER_REFERENCE The reference to the debit invoice origin of the credit invoice line 50 N  
VARCHAR2 C15 REF_CURRENCY Reference Invoice Currency 3 N        
VARCHAR2 C16 LINE_DOC_TEXT Line Document Text + Charge line Document Text 2000 N        
VARCHAR2 C17 DELIVERY_ADDRESS_ID Delivery Address Id 50 N        
VARCHAR2 C18 DELIVERY_ADDRESS    Receiver name for delivery address 100 N        
VARCHAR2 C19 DELIVERY_ADDRESS1   Delivery address 1 75 N        
VARCHAR2 C20 DELIVERY_ADDRESS2   Delivery address 2 35 N        
VARCHAR2 C21 DELIVERY_ADDRESS3   Delivery address Zip Code 35 N        
VARCHAR2 C22 DELIVERY_ADDRESS4   Delivery address City 35 N        
VARCHAR2 C23 DELIVERY_ADDRESS5 Delivery address State 35 N        
VARCHAR2 C24 DELIVERY_ADDRESS6 Delivery address County 35 N        
VARCHAR2 C25 DELIVERY_COUNTRY    Delivery address Country Code 35 N        
VARCHAR2 C29** DELIVERY_NOTE_NOS Delivery note number(s) 2000 N          
VARCHAR2 C31 INVOICE_TEXT_ID Identity of invoice text 20 N   INVOICE_TEXT_ID Identity of invoice text 20 N
VARCHAR2 C32 INVOICE_TEXT Invoice text 2000 N   INVOICE_TEXT Invoice text 2000 N
VARCHAR2 C34 SOURCE_UNIT_MEAS Customer unit of measure 50 N            
VARCHAR2 C49 GTIN_NO THE DEFAULT GTIN OF THE PART 14

N

   GTIN_NO GTIN used for identification of the part      
VARCHAR2 C56 DELIV_TYPE_ID Identity of the delivery type 20 N   DELIV_TYPE_ID Identity of the delivery type 20 N  
VARCHAR2 C57 DELIV_TYPE_DESCRIPTION Delivery Type 2000 N            
NUMBER N00 SALES_UNIT_PRICE Supplier sales unit price in order currency   N   SALES_UNIT_PRICE Supplier sales unit price in order currency      
NUMBER N01 PRICE_CONV Price conversion factor   N        
NUMBER N02 INV_QTY Invoiced quantity   N   INVOICED_QTY Invoiced quantity   N  
NUMBER N03 NET_CURR_AMOUNT Line net amount in invoice currency   M   NET_CURR_AMOUNT Line net amount in invoice currency   N  
NUMBER N04 VAT_CURR_AMOUNT Line TAX amount in invoice currency   M   VAT_CURR_AMOUNT Line TAX amount in invoice currency   N  
NUMBER N05 VAT_PERCENT TAX percentage   N   TAX_RATE Tax expressed as a percentage   N  
NUMBER N06 ORDER_DISCOUNT Order discount   N   ORDER_DISCOUNT Order discount   N  
NUMBER N07 DISCOUNT Line discount   N   LINE_DISCOUNT Line discount   N  
NUMBER N08 DISCOUNT_AMOUNT Discount amount   N   DISCOUNT_AMOUNT Discount amount   N  
NUMBER N09 REF_NET_CURR_AMOUNT Reference Invoice Total Net Amount in Invoice Currency   N        
NUMBER N10 REF_VAT_CURR_AMOUNT Reference Invoice Total Tax Amount in Invoice Currency   N        
NUMBER N11 REF_VAT_DOM_AMOUNT Reference Invoice Total Tax Amount in Accounting Currency   N        
NUMBER N12 ADDITIONAL_DISCOUNT Additional discount   N        
NUMBER N13 TOTAL_DISCOUNT      Total discount   N        
NUMBER N16 INVOICED_SOURCE_QTY Invoiced quantity expressed in customer's unit of measure   N            
DATE D00 DELIVERY_DATE Delivery date of the order   N   DELIVERY DATE Delivery date of the order   N  
DATE D01       MAN_TAX_LIABILITY_DATE Date on which the invoice line amount becomes liable for tax.   N  
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).

** Consists of the alternative delivery note number, if applicable.

Installment 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) EDI message ID Unique ID of message generated by IFS Connectivity       EDI message ID Unique ID of message generated by IFS Connectivity      
NUMBER MESSAGE_LINE Row of message Each message can hold several lines       Row of message Each message can hold several lines      
VARCHAR2 NAME Installment Type of message line       Installment Type of message line      
VARCHAR2 C00 SERIES_ID+
INVOICE_NO (concatenated)		 Invoice identity 70 M    INVOICE_NO Invoice identity 50 M  
NUMBER N00 CURR_AMOUNT Installment amount   M   AMOUNT Installment amount   M  
DATE D00 DUE_DATE Due Date   M   DUE_DATE Due Date   M  
DATE D01 DISC_DATE First Discount Date Filled only if discount exists. Up to 3 discount lines handled.       DISCOUNT_DATE_1 First Discount Date   N  
NUMBER N01 TAX_AMOUNT Tax Amount   N   TAX Tax amount   N  
NUMBER N02 DISC_PERCENT First Discount Percent   C This will be mandatory when there are discounts available for the invoice DISCOUNT_PERC1 First Discount Percent   N  
NUMBER N03 DISCOUNT_
CURR_AMOUNT		 First Discount Amount       DISCOUNT_CURRAMOUNT1 First Discount Amount   N  
DATE D02 DISC_DATE Second Discount Date       DISCOUNT_DATE2 Second Discount Date   N  
NUMBER N04 DISC_PERCENT Second Discount Percent   C This will be mandatory when there is a second discount available for the invoice DISCOUNT_PERC2 Second Discount Percent   N  
NUMBER N05 DISCOUNT_
CURR_AMOUNT		 Second Discount Amount       DISCOUNT_CURRAMOUNT2 Second Discount Amount   N  
DATE D03 DISC_DATE Third Discount Date       DISCOUNT_DATE3 Third Discount Date   N  
NUMBER N06 DISC_PERCENT Third Discount Percent   C This will be mandatory when there is a third discount available for the invoice DISCOUNT_PERC3 Third Discount Percent   N  
NUMBER N07 DISCOUNT_
CURR_AMOUNT		 Third Discount Amount       DISCOUNT_CURRAMOUNT3 Third Discount Amount   N  
VARCHAR2 STATE Status of
message line		 Handled by IFS Connectivity            

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

Tax Total 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) EDI message ID Unique ID of message generated by IFS Connectivity                
NUMBER MESSAGE_LINE Row of message Each message can hold several lines                
VARCHAR2 NAME Tax Total Type of message line                
VARCHAR2 C00 SERIES_ID+ INVOICE_NO (concatenated) Invoice identity 70 M            
VARCHAR2 C01 VAT_CODE TAX code 20 M            
VARCHAR2 C02 VAT_CODE_DESC TAX code description 100 N            
VARCHAR2 C03 TAX_CODE_TEXT Tax Code Text 500 N            
NUMBER N00 VAT_PERCENTAGE TAX percentage   M            
NUMBER N01 SUM_NET_CURR_AMOUNT Net Amount   M            
NUMBER N02 SUM_VAT_CURR_AMOUNT TAX Amount   M            
NUMBER N03 SUM_VAT_DOM_AMOUNT TAX Amount in accounting currency   M            
NUMBER N04 SUM_GROSS_CURR_AMOUNT Gross Amount                

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