| | | | 210916153546307 DOCU133 EDI guide - table standards, invoicing EDI_Standards_Invoicing 410_20210916153433_edi guide-table standards -invoicing.doc.pdf 410_20210916153433_edi guide-table standards -invoicing.doc.pdf edi guide-table standards -invoicing.doc * Remarks Specific to Waitrose Requirements M Mandatory C Conditional Message Type INVOICE FILE HEADER INVFIL FILE: INVOICE FILE Page 1 of 1 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) STX = . START OF TRANSMISSION M M STDS Syntax Rules Identifier M M : Identifier M M V X(4) Value = ANA Version M M F 9 Value = 1 + FROM : Identification of Transmission Sender Code Name M C C M C C V V X(14) X(35) Code or name transmitted Codes can be agreed by interchange parties Mandatory if no code used. + UNTO : Identificaiton of Transmission Recipient Code Name M C C M C C V V X(14) X(35) Code or name transmitted Codes can be agreed by interchange parties. Mandatory if no code used + TRDT : Date and Time of Transmission Date Time M M C M M C F F 9(6) 9(6) Format: YYMMDD Formatt: HHMMSS (if required by the particular applicaiton) + SNRF Senders Transmission Reference M M V x(14) Reference for the transmission. + RCRF Recipient’s Transmission Reference C C V X(14) If known to sender + APRF Applicaiton Reference C C V X(14) + {RCD Transmission Priority Code C C F X(1) Code Values List 1 END = END OF TRANSMISSION M M * Remarks Specific to Waitrose Requirements M Mandatory NMST Number of Messages in Transmission M M V 9(5) Control Count of the number of messages in a tape or transmission. * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE HEADER INVFIL FILE: INVOICE FILE Page 1 of 6 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) MHD = . MESSAGE HEADER M M MSRF Message Reference M M V 9(12) Consecutive count of messages within the transmission + TYPE : Type of Message M M Type Version Number M M M M F F X(6) 9(1) ‘INVFIL’ ‘9’ for this version TYP = TRANSACTION TYPE DETAILS M M TCDE Transaction Code M M F 9(4) Code Values List 2 + TTYP Transaction Type C C V X(12) Code Values List 3 SDT = SUPPLIER DETAILS M M Identifies the Invoicer SIDN : Supplier’s Identity M C M M C C F V 9(13) X(17) EAN location number identifying supplier. Supplier’s EAN Location Number Supplier’s Identity Allocated by Customer WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory Supplier’s Code as allocated/used by customer (MAX 6 DIGITS) * + SNAM Supplier’s Name C C V X(40) Supplier’s legal name as printed on invoices. C Conditional Message Type INVOICE FILE HEADER INVFIL FILE: INVOICE FILE Page 2 of 6 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + . SADD Supplier’s Address C C A maximum of five lines to give the supplier’s address. Supplier’s Address Line 1 C C V X(35) WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory : : : : Supplier’s Address Line 2 Supplier’s Address Line 3 Supplier’s Address Line 4 Supplier’s Post Code C C C C C C C C V V V V X(35) X(35) X(35) X(8) + VATN Supplier’s VAT Registration Number M C : Numeric VAT Registration Number Alphanumeric VAT Registration Number C C C F V 9(9) X(17) Trader’s VAT number allocated by HM Customs & Excise Government department or non-UK VAT number. CDT = CUSTOMER DETAILS M M Identifies the invoicee CIDN Customer’s Identity M M : Customer’s EAN Location Number Customer’s Identity Allocated by Supplier C C C C F V 9(13) X(17) EAN Location number identifying the customer. Customer’s Code as allocated/used by supplier. + CNAM Customers Name C C V X(40) Customer’s registered legal name. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE HEADER INVFIL FILE: INVOICE FILE Page 3 of 6 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + CADD : : : : Customer’s Address Customer’s Address Line 1 Customer’s Address Line 2 Customer’s Address Line 3 Customer’s Address Line 4 Customer’s Post Code C C C C C C C C C C C C V V V V V X(35) X(35) X(35) X(35) X(8) A maximum of five lines to give the customer’s address. + VATR Customer’s VAT Registration Number C C : Numeric VAT Registration Number Alphanumeric VAT Registration Number C C C C F V 9(9) X(17) Trader’s VAT number allocated by HM Customs & Excise Government department or non-UK VAT number DNA = DATA NARRATIVE C C WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory SEQA First Level Sequence Number M M V 9(10) Starts at 1 and incremented by 1 for each 1st level repeat. + DNAC Data Narrative Code C C Standard data narrative previously defined and agreed by sender and receiver. : Code Table Number C C V 9(4) Number of relevant code list Code Value C C V X(3) Code Value from code list C Conditional Message Type INVOICE FILE HEADER INVFIL FILE: INVOICE FILE Page 4 of 6 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + RTEX : Registered Text C Essential text, where not provided for by specific fields may be communicated using this element. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory : : : : : : First Registered Application Code Application Text Second Registered Application Code Application Text Third Registered Application Code Application Text Fourth Registered Application Code Application Text C C C C C C C C C C C C C C C C V V V V V V V V X(3) X(40) X(3) X(40) X(3) X(40) X(3) X(40) Application codes to define the function of the test must be registered with the ANA prior to use. The same application code may be repeated up to 4 times, or up to 4 different codes may be used. + GNAR : : : General Narrative General Narrative Line 1 General Narrative Line 2 General Narrative Line 3 C C C C C C C C V V V X(40) X(40) X(40) Narrative covering information which cannot be sent in a coded form i.e. RTEX/DNAC. This is likely to preclude automatic processing. General Narrative Line 4 C C V X(40) FIL = FILE DETAILS M M FLGN File Generation Number M M V 9(4) This number is sequential, per file type, per trading partner. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE HEADER INVFIL FILE: INVOICE FILE Page 5 of 6 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + FLVN File Version Number M M V 9(4) Original (which is always 1) is incremented by 1 for each additional copy created. + FLDT File Creation Date M M F 9(6) Date the file is created. Format: YYMMDD + FLID File (Reel) Identification C C V X(6) Reference on the outside reel containing the file FDT = FILE PERIOD DATES C C IVED Invoice Period End Date C C F 9(6) Format: YYMMDD + DVED Delivery Period End Date C C F 9(6) Format: YYMMDD ACD = AUDIT CONTROL DETAILS C C INLO Invoice System Location Details C C : Invoice System EAN Location Number Invoice System Supplier’s Own Code C C C C F V 9(13) X(17) EAN location number for system WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory generating this invoice file. Supplier’s own code for system generating this invoice file. C Conditional Message Type INVOICE FILE HEADER INVFIL FILE: INVOICE FILE Page 6 of 6 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) MTR = MESSAGE TRAILER M M NOSG Number of Segments M M V 9(10) Control count of the number of segments comprising message. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory The count includes the MHD and MTR segments surrounding the message. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 1 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) MHD = . MESSAGE HEADER M M MSRF Message Reference M M V 9(12) Consecutive count of messages within the transmission + TYPE : Type of Message M M Type Version Number M M M M F F X(6) 9(1) ‘INVOIC’ ‘9’ for this version CLO = CUSTOMER’S LOCATION M M CLOC Customer’s Location M M One of the following three customer’s references must be present: : : Customer’s EAN Location Number Customer’s Own Location Code Supplier’s Identification of Customer’s Location C M C C C C F V V 9(13) X(17) X(17) EAN location number identifying the customer’s location Customer’s own identity for the location to which the WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory goods ordered are to be/have been delivered - MAX 3 DIGITS * Supplier’s reference for the customer’s location + CNAM Customer’s Name C C V X(40) Customer’s registered legal name WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 2 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + CADD : : : : Customer’s address C C A maximum of five lines to give the customer’s address Customer’s address line 1 Customer’s address line 2 Customer’s address line 3 Customer’s address line 4 Customer’s address Post Code C C C C C C C C C C V V V V V X(35) X(35) X(35) X(35) X(8) IRF = INVOICE REFERENCES M M INVN Invoice Number M M V X(17) As allocated by the supplier + IVDT Date of Invoice M M F 9(6) Format: YYMMDD + TXTD Tax-point Date M M F 9(6) Format: YYMMDD (may be the same as the date of invoice) PYT = SETTLEMENT TERMS C C This segment is used to specify the settlement terms WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory which apply to the invoice. The most favourable must be used for the VAT calculation SEQA First Level Sequence Number M M V 9(10) Sequence number. Starts at 1 and increases for each occurrence of the PYT segment WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 3 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + PAYT Terms of Payment C C V X(40) Textual description of the settlement terms + PAYD Payment Date and Terms C C Settlement terms agreed between the buyer and seller, expressed in terms of payment due date and percentage : Payment Date Settlement Discount Percentage M M M M F V 9(6) 9(3)V9(3) Date that payment should be made available to the payee to obtain the specified discount. Percentage discount applicable + PAYY Settlement Terms C C Settlement terms described using calendar days after a WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory reference date and/or code : : Number of days Settlement Discount Percentage Settlement Code M C C M C C V V V 9(3) 9(3)V9(3) X(3) Days until payment is due is defined as the number of calendar days after a reference date, commonly the date of invoice, that the payment is to be made available to the payee Percentage discount applicable Code for settlement terms. User defined WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 4 of 18 WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) DNA = DATA NARRATIVE C C SEQA First Level Sequence Number M M V 9(10) Starts at 1 and is incremented by 1 for each 1st level repeat. + DNAC : Data Narrative Code C C Standard data narrative previously defined and agreed by sender and receiver. Code Table Number Code Value C C V 9(4) Number of relevant Code List C C V X(3) Code Value from Code List + RTEX : : : : : : : Registered Text C C Essential text, where not provided for by specific fields may be communicated using this element. Application Codes to define the function of the text must be registered with ANA prior to use. The same application code First Registered Application Code C C V X(3) Application Text C C V X(40) Second Registered Application Code C C V X(3) Application Text C C V X(40) Third Registered Application Code C C V X(3) Application Text Fourth Registered Application Code Application Text C C C C C C V V V X(40) X(3) X(40) WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory may be repeated up to four times, or up to four different codes may be used. + GNAR General Narrative General Narrative Line 1 General Narrative Line 2 General Narrative Line 3 C C C C C C C C V V V X(40) X(40) X(40) Narrative covering information which cannot be sent in a coded form i.e. "RTEX/DNCA. This is likely to preclude automatic processing. General Narrative Line 4 C C V X(40) C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 5 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) ODD = . ORDER AND DELIVERY REFERENCES M M SEQA First Level Sequence Number M M V 9(10) Starts at 1 and is incremented by 1 for WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory each segment of this type in this message + ORNO Order Number and Date M M Customer’s Order Number M C V X(17) Max 6 Digits. 1st 4 Alpha or numeric Last 2 all numeric * : Supplier’s Order Number C C V X(17) As allocated by the supplier when processing orders on behalf of the customer. : Date Order Placed by Customer M C F 9(6) File date can be issued instead if customer and supplier agree. Format YYMMDD : Date Order Received by Supplier C C F 9(6) Format YYMMDD + DELN Delivery Note Details M M Delivery Note Number M C V X(17) Delivery note number as allocated by the supplier.(16 characters only for Waitrose). : Date of Document C C F 9(6) Date of despatch where appropriate. YYMMDD WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 6 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + NODU Number of Delivery or Uplift Units C C V 9(15) Number of Cases, cartons, packages etc. transported + DEWT Delivery Weights C C V Vehicle Tare Weights C C V 9(10)V9(3) In kilos : Total Goods Weight C C V 9(10)V9(3) In kilos : + PODN Proof of Delivery Details C C Delivery Note Number C C V X(17) Customer’s proof of delivery reference. Delivery vehicle Reg. No. may be used. : Date Goods Delivered to Customer M C F 9(6) YYMMDD WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory + . SCAR Name of Carrier C C V X(40) If known to supplier + DLOC : Despatch Location C C Code for location from which goods were despatched. Supplier’s Despatch EAN Location number C C F 9(13) EAN Location number for the despatch location Supplier’s Own Location Code C C V X(17) Supplier’s own code for the despatch location WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 7 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + TLOC Trans-shipment Location C C Secondary or trans-shipment location Supplier’s EAN Location Number C C F 9(13) EAN location number for the trans-shipment location : Supplier’s Own Location Code C C V X(17) Supplier’s own code for the location + JORF Journey Reference C C V X(17) Reference number for journey + SCRF Specification/Contract References C C : Specification Number Contract Number C C C C V V X(17) X(17) Specification No. to which order relates Contract No. to which order relates. ILD = INVOICE LINE DETAILS M M SEQA First Level Sequence Number M M V 9(10) Takes the same value as in the WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory corresponding order and delivery references segment + SEQB Second Level Sequence Number M M V 9(10) Starts at 1 and is successively incremented by 1 for each second level nested sequence of this segment. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 8 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + SPRO Supplier’s Product Number M M Either the EAN traded unit code or the supplier’s code must be quoted, otherwise special arrangements need to be negotiated : : EAN-13 Article Number for Traded Unit C C F 9(13) EAN article number allocated to the unit of trade Supplier’s Code for Traded Unit DUN-14 Code for Traded Unit C C C C V F X(30) 9(14) Maximum 14 digits for Waitrose * Code for the traded unit allocated under the alternative (DUN-14) EAN System + SACU Supplier’s EAN Number for the Designated Consumer Unit C C F 9(13) EAN number allocated to the retail WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory (POS) unit. (Insert five leading zeros before eight digit codes) + CPRO Customer’s Product Number C C : Customer’s Own Brand RAN Number Customer’s Item Code C C C C F V 9(15) X(30) Can be used for ‘own label’ items allocated an in-store number in a general format. EAN prefix - 2 dig: customer's number - 5 dig: consumer unit number - 8 dig Customer’s internal reference for the item non-EAN format. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 9 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + UNOR : : : Unit Ordering M C At least one of the following sub elements must be quoted. Measure Indicator must be quoted if the Ordering Measure is used. Consumer Units in Traded Unit C C V 9(15) Number of consumer units making up the supplier’s traded unit. Ordering Measure C C V 9(10)V9(3) Required when an item is ordered as a multiple of a defined measure Measure Indicator C C V X(6) Abbreviation for the ordering measure, WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory see Code List 4. Mandatory if Ordering Measure used. + QTY1 Quantity Invoiced M M At least one of the following sub-elements must be quoted. If the total measure invoiced is quoted the measure indicator must be quoted too : : : Number of Traded Units Invoiced C C V 9(15) Number of supplier’s traded units invoiced Total Measure Invoiced Measure Indicator C C C C V V 9(10)v9(3) X(6) Total invoiced volume, size etc required when invoicing variable measure items. Abbreviation for the ordering measure see Code List 4. Mandatory if Ordering Measure used WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 10 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + AUCT Unit cost Price (excluding VAT) M M Cost Price (Excluding VAT) M M V 9(10)V9(4) Cost of order unit having applied line discount. In pounds Measure Indicator C C V X(6) Abbreviation for the measure. Mandatory for variable measure items. See Code List 4. + LEXC Extended Line Cost (Excluding VAT) M M V 9(10)V9(4) Having applied line discounts. In pounds. LEXC = AUCT X QTY1 + VATC VAT Rate Category Code M M F X(1) Code Values List 12 + VATP VAT Rate Percentage M M V 9(3)V9(3) Percentage rate for VAT Category Code + MIXI Mixed VAT Rate Product Indicator C C F 9(1) Value zero for the invoice item line for a composite product WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory with component groups with different VAT rate codes. Starts at 1 and is incremented by 1 for each following invoice item line for the component groups. + CRLI Credit Line Indicator C C V X(4) Code Values List 9 WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 11 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + TDES : Traded Unit Description M C Full description of the item being traded. Consistent with Product Information data on any labels or packaging. Traded Unit Description Line 1 Traded Unit Description Line 2 M C C V V X(40) X(40) + MSPR : : Selling On Price C C Manufacturer’s Recommended Selling Price Marked Price Split Pack Price C C C C C C V V V 9(10)V9(4) 9(10)V9(4) 9(10)V9(4) In pounds Price marked on unit. In pounds In pounds + SRSP Statutory Retail Selling Price (including VAT) C C v 9(10)V9(4) Required for items such as drugs, which must be sold at a WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory regular price. In pounds + BUCT Unit Cost Price (excluding VAT) discount M C V 9(10)V9(4) Cost of order unit before applying line discount. In pounds + DSCV Discount Value C C V 9(10)V9(4) Line discount value. In pounds + |DSCP Discount Percentage C C V 9(3)V9(3) Line item discount percentage + SUBA Subsidy Amount C C V 9(10)V9(4) Subsidy value for this line + PIND Special Price Indicator C C C X(4) Code Values List 5 + IGPI Item Group Identifier C C V X(4) Code Values List 10 WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 12 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + CSDI Cash Settlement Discount Identifier C C F X(1) Code Values List 11 + TSUP VAT - Type of Supply C C F X(1) Code as defined by H M Customs & Excise. Mandatory unless code is A (ordinary sale), in which case this element is omitted. Code Values List 14 + SCRF : : Specification/Contract References C C Specification Number Contract Number C C C C V V X(17) X(17) Specification No to which invoice line relates Contract No to which invoice line relates CIA = COMPLEX INVOICE LINE ADJUSTMENTS C C WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory SEQA First Level Sequence Number M M V 9(10) Takes the value of SEQA in the preceding segment with which this segment is nested + SEQB Second Level Sequence Number M M V 9(10) Takes the value of SEQB in the preceding segment with which this segment is nested + SEQC Third Level Sequence Number M M V 9(10) Starts at 1 and is incremented by 1 for each third level nesting. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 13 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + DTYP Discount Type M M V X(3) Code Values List 32 + AOCI Allowance (Discount)/Charge Indicator M M F X(1) A = Allowance, C = Charge + ACCR Accumulation Rules M M F X(1) G = Gross, N = Nett + AADJ : Actual Adjustment M M Adjustment Percentage Adjustment Amount C C C C V V 9(3)V9(3) 9(10)V9(4) Actual adjustment percentage Actual adjustment amount DNC = DATA NARRATIVE C M SEQA First Level Sequence Number M M V 9(10) Takes the value of SEQA in the corresponding ODD segment with which this segment is nested. + SEQB Second Level Sequence Number M M V 9(10) Takes the value of SEQB in the corresponding ILD WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory segment with which this segment is nested + SEQC Third Level Sequence Number M M V 9(10) Starts at 1 and is incremented by 1 for each third level nesting + DNAC : Data Narrative Code C C Standard data narrative previously defined and agreed by sender and receiver Code Table Number Code Value C C C C V V 9(4) X(3) Number of relevant code list Code Value from code list WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 14 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + RTEX : : : : : : : Registered Text C C Essential text, where not provided for by specific fields may be communicated using this element. Application codes to define the function of the text must be registered with ANA prior to use. The same application code may be repeated up to four times, or up to four different codes may be used First Registered Application Code Application Text Second Registered Application Code Application Text Third Registered Application Code Application Text Fourth Registered Application Code Application Text C C C C C C C C C C C C C C C C V V V V V V V V X(3) X(40) X(3) X(40) X(3) X(40) X(3) X(40) + GNAR : General Narrative C C Narrative covering information which cannot be sent in a General Narrative Line 1 General Narrative Line 2 C C C C V V X(40) X(40) WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory : : coded form ie RTEX/DNAC. This is likely to preclude automatic processing. General Narrative Line 3 General Narrative Line 4 C C C C V V X(40) X(40) STL = VAT RATE INVOICE SUB-TRAILER M All values are in pounds SEQA First Level Sequence Number M M V 9(10) Starts at 1 and is incremented by 1 for each segment of this type in the message. + VATC VAT Rate Category Code M M F X(1) Code Values List 12 WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 15 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + VATP VAT Rate percentage M M V 9(3)V9(3) Percentage rate for VAT Category Code + NRIL Number of Item Lines M M V 9(10) Number of ILD segments with this VAT Category Code + LVLA Line Sub-Total Amount (before VAT) M M V 9(10)V9(2) Before VAT has been applied. Total of Net Cost Values (LEXC) for this VAT Category Code + QYDA Discount Amount for Invoice Quantity C C V 9(10)V9(2) Value of discount for total quantity for VAT Category Code + VLDA Discount Amount for Invoice Value C C V 9(10)V9(2) Value of discount for total value for VAT Category Code + SURA Surcharge Amount C C V 9(10)V9(2) Freight charges etc for this VAT Category Code WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory + SSUB Sub-Total Subsidy C C V 9(10)V9(2) Sub-total of line subsidy values for this VAT Category Code + EVLA Extended Sub-Total Amount (before settlement discount has been applied) M M C 9(10)V9(2) Before VAT has been applied. EVLA = LVLA - QYDA - VLDA + SURA - SSUB + SEDA Sub-Total Settlement Discount Amount C C V 9(10)V9(2) For this VAT Category Code WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 16 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + ASDA Extended Sub-Total Amount (after settlement discount has been applied) M M V 9(10)V9(2) Before VAT has been applied. ADSA = EVLA - SEDA + VATA VAT Amount Payable M M V 9(10)V9(2) VAT amount at quoted VAT rate + APSE Payable Sub-Total Amount (before settlement discount) M C V 9(10)V9(2) After VAT has been applied. APSE = EVLA + VATA + APSI Payable Sub-Total Amount (after settlement discount has been applied) M M V 9(10)V9(2) After VAT has been applied. APSI = ASDA + VATA TLR = INVOICE TRAILER M M NSTL Number of Total Segments M M V 9(10) Number of preceding STL segments + LVLT Lines Total Amount (before settlement discount has been applied) M M V 9(10)V9(2) Sum of LVLAs in preceding STL WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory segments. Before VAT + QYDT Total Discount Amount for Invoice Quantity C C V 9(10)V9(2) Sum of QYDAs in preceding STL segments + VLDT Total Discount Amount for Invoice Value C C V 9(10)V9(2) Sum of VLDAs in preceding STL segments WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 17 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + SURT Total Surcharge Amount C C V 9(10)V9(2) Sum of SURAs in preceding STL segments + TSUB Total Subsidy Amount C C V 9(10)V9(2) Sum of SSUBs in preceding STL segments + EVLT Total Extended Amount (before settlement discount has been applied) M M V 9(10)V9(2) Sum of EVLAs in preceding STL segments. Before VAT. + SEDT Total Settlement Discount Amount C C V 9(10)V9(2) Sum of SEDAs in preceding STL segments + ASDT Total Amount (after settlement discount has been applied) M M V 9(10)V9(2) Sum of ASDAs in preceding STL segments. Before VAT WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory + TVAT Total VAT Amount Payable M M V 9(10)V9(2) Sum of VATAs in preceding STL segments + TPSE Total payable (before settlement discount) C C V 9(10)V9(2) Sum of APSEs in preceding STL segments + TPSI Total payable (after settlement discount) M M V 9(10)V9(2) Sum of APSIs in preceding STL segments WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE DETAILS INVOIC FILE: INVOICE FILE Page 18 of 18 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) MTR = MESSAGE TRAILER M M NOSG Number of Segments in Message M M V 9(10) Control count of the number of segments comprising message. The count includes the MHD and MTR segments surrounding the message WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type FILE VAT TRAILER VATTLR FILE: INVOICE FILE Page 1 of 2 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) MHD = MESSAGE HEADER M M MSRF Message Reference M M V 9(12) Consecutive count of messages within the transmission + TYPE Type of Message M M ‘VATTLR’ ‘9’ for this version: Type Version Number M M M M F F X(6) 9(1) VRS = VAT RATE SUMMARY M M SEQA First Level Sequence Number M M V 9(10) Starts at 1 and is incremented by 1 for each segment of this type in the message + VATC VAT Rate Category M M F X(1) Codes Values List 12 + VATP VAT Rate Percentage M M V 9(3)V9(3) Percentage rate for VAT Category Code. As used in INVOIC messages WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory + VSDE File Sub-Total Amount (before settlement discount) M M V 9(10)V9(2) Sum of EVLAs in corresponding STL segments. Before VAT + VSDA File Sub-Total Amount (after settlement discount) M M V 9(10)V9(2) Sum of ASDAs in corresponding STL segments. Before VAT WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type FILE VAT TRAILER VATTLR FILE: INVOICE FILE Page 2 of 2 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + VVAT File VAT Sub-Total M M V 9(10)V9(2) Sum of VATAs in corresponding STL segments + VPSE File Sub-Total Payable (before settlement discount) M C V 9(10)V9(2) Sum of APSEs in corresponding STL segments. After VAT + VPSI File Sub-Total Payable (after settlement discount) M M V 9(10)V9(2) Sum of APSIs in corresponding STL segments. After VAT MTR = MESSAGE TRAILER M M V NOSG Number of Segments in Message M M V 9(10) Control count of the number of segments comprising message. The count includes the MHD and MTR segments WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory surrounding the message. WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE TRAILER INVTLR FILE: INVOICE FILE Page 1 of 2 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) MHD = MESSAGE HEADER M M MSRF Message Reference M M V 9(12) Consecutive count of messages within the transmission + TYPE Type of Message M M ‘INVTLR’ ‘9’ for this version: Type Version Number M M M M F F X(6) 9(1) TOT = FILE TOTALS M M FASE File Total Amount (before VAT settlement discount) M M V 9(10)V9(2) Sum of VSDEs in VATTLR message + FASI File Total Amount (before VAT but after settlement discount has been applied) M M V 9(10)V9(2) Sum of VSDIs in VATTLR message + FVAT File Total VAT Amount M M V 9(10)V9(2) Sum of VVATs in VATTLR message + FPSE File Total Payable (before settlement discount) C C V 9(10)V9(2) Sum of VPSEs in VATTLR message. After VAT WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory + FPSI File total Payable (after settlement discount has been applied) M M V 9(10)V9(2) Sum of VPSIs in VATTLR message. After VAT WA/A/38527a * Remarks Specific to Waitrose Requirements WA/A/38483 M Mandatory C Conditional Message Type INVOICE FILE TRAILER INVTLR FILE: INVOICE FILE Page 2 of 2 SEGMENT DATAELEMENT DATA ELEMENT NAME WR M/C F/V PICTURE REMARKS (See also General Remarks in Directory) + FTNI File Total Number of Invoice Messages M M V 9(10) Number of Invoice Details Messages, ‘INVOIC’ for this file MTR = MESSAGE TRAILER M M NOSG Number of Segments in Message M M V 9(10) Control count of the number of segments comprising message. The count includes the MHD and MTR segments surrounding the message WA/A/38527a |
|