Solution Properties
Solution ID:
210729103418837
Last Modified Date:
Wed May 03 11:32:58 UTC 2023
Taxonomy Path:
Finance - Supplier//New Connections
Author:
vi1795
EDI - Tradacoms Invoice specifications
Supplier Actions

Table of Contents

Envelope header

Seg Field Description Req Data Length Value Notes
STX   Start of transmission M      
  STDS1 Syntax rules identifier M an4 ANAA Although we can accept ANA if no RSG message is being sent
  :STDS2 Version M n1 1  
  +FROM2 Transmission sender's code M an14   Supplier's ANA number
  :FROM2 Transmission sender's name n     not used
  +UNTO1 Transmission recipient code M an14 5023949000004 JL ANA number
  :UNTO2 Transmission recipient name n     not used
  +TRDT1 Date of transmission M n6   format YYMMDD
  :TRDT2 Time of transmisson M n6   format HHMMSS
  +SNRF Sender's transmission ref. M an14   Unique ref. no. for
each transmission from your mailbox
  +RCRF Recipient's transmission ref M an14 Network passord  
  +APRF Application ref M an14 INVTES For test transmision
          INVFIL For live transmission
  +PRCD Priority code n     Not used

 

Invoice Header

Seg Field Description Req Data Length Value Notes
MHD   Message header M      
  MSRF Message ref M n12   Message count seq
  +TYPE1  Type M an6  INVFIL  
  :TYPE2 Version M n1 9  
TYP   Transaction type M      
  TCDE Transaction code M n4 0700  
  +TTYP Transaction type M n12 INVOICES  
SDT   Supplier's details M      
  SIDN1 Supplier's ID M n13 Supplier's identity ANA no. to ID the supplier
  :SIDN2 Customer's ref for supplier n     Not used
  +SNAM Supplier's name M an40 Supplier's name Legal name as printed on invoices
  +SADD1 Supplier's address 1 O     Optional
  :SADD2 Supplier's address 2 O     Optional
  :SADD3 Supplier's address 3 O     Optional
  :SADD4 Supplier's address 4 O     Optional
  :SADD5 Supplier's postcode O     Optional
  +VATN1 Supplier's VAT number M n9 Your VAT reg. no. Supplier's numeric VAT registration
  :VATN2 Supplier's VAT no. M an17 Your VAT reg. no. Alphanumeric (non-UK)
CDT   Customer Details M      
  CIDN1 Customer's Identity M n13 5023949000004 JL ANA number
  :CIDN2 Customer's ref for suplier n     Not used
  +CNAM Customer's name O     Optional
  +CADD Customer's address O     Optional
  +VATR Customer's VAT no. O     Optional

 

File details

Seg Field Description Req Data Length Value Notes
FIL   File Details M      
  FLGN File generation no. M n4   Sequence no. unique to supplier's ANA and this INVFIL doc. We check this no. and will reject any files that are out of sequence.
  +FLVN File version M n4 1  
  +FLDT File date M an6 Date file created Format YYMMDD
  +FLID File Identification n     Not used
MTR   Message trailer M      
  NOSG No. of segments M n10 No. of segments in message Including MHD/MTR
MHD   Message Header M      
  MSRF Message ref. M n12   Message count sequence
  +TYPE1 Type M an6 INVOIC  
  :TYPE2 Version M n1 9  

Customer's location

Seg Field Description Req Data Length Value Notes
CLO   Customer's location M      
  CLOC1 Cuastomer's EAN location M n13 JL Delivery location This field is mandatory
  :CLOC2 Customer's own locationno. M an17 Branch name  Or branch no. Can be ommited if location code is sent in CLOC1
  :CLOC3 Supplier's ID of customer location n     Not used
  +CNAM Customer's name n      Not used
  +CADD Customer's address n     Not used
IRF   Invoice Reference M      
  INVN Invoice number M an17 Your invoice no.  
  +IVDT Invoice date M an6 Invoice date Format YYMMDD
  +TXDT Tax date M an6 Tax point date Format YYMMDD
DNA            
  SEQA First level seq. no. M n10    
  +DNAC Data narritive code n     Not used
  +RTEX1 Register code 1 M an3   Optional
  :RTEX2 Registered text 1 M an40   Optional
  :RTEX3 Registered code 2 M an3   Optional
  :RTEX4 Registered text 2 M an40   Optional
  :RTEX5 Registered code 3 M an3   Optional
  :RTEX6 Registered text 3 M an40   Optional
  :RTEX7 Registered code 4 M an3 022 =carriage charges
          280 = Misc. charges
  :RTEX8 Registered text 4 M an40 C = carriage charge (VAT liable)
          D = delivery charges
          T = RetailEye / Tradeplace
  +GNAR1 General narrative 1  M an40   General text
  :GNAR2 General narrative 2 M an40   General text
  :GNAR3 General narrative 3 M an40   General text
  :GNAR4 General narrative 4 M an40   General text

 

Order and Delivery References

Seg Field Description Req Data Length Value Notes
ODD   Order and delivery refs M      
             
  SEQA First level seq. no. M n10   Start at 2 and is incremented by 1 for each segment of this type in message
  +ORNO1 Customer's order number M an17 123456/789 JL 6 digit order no. & dept. no.
  :ORNO2 Supplier's order number O     Optional
  :ORNO3 Date placed O     Optional
  :ORNO4 Date received O     Optional
  +DELN1 Delivery note no. M an17 Supplier's del. note no. Delivery note no. as allocated by the supplier
  :DELN2 Delivey note date M n6   Date of despatch, format YYMMDD
  +NODU No. of delivery units n     Not used
  +DEWT Delivery weights n     Not used
  +PODN1 Proof of delivery ref.  O an17   Optional
  :PODN2 Proof of delivery date O n6   Format YYMMDD
  +SCAR Name of carrier O an40   Optional
  +DLOC Despatch location n     Not used
  +TLOC  Transshipment location n     Not used
  +JORF Journey ref. n     Not used
  +SCRF Specification no. n     Not used

 

Invoice Line Details

Seg Field Description Req Data Length Value Notes
ILD   Invoice Line Details M      
  SEQA First seq no. M n10 =ODD SEQA Takes the same value as in the corresponding order and delivery references segment
  +SEQB Second seq. no. M n10   Starts at 1 and is successively incremented by 1 for each second level nested sequence of this segment
  +SPRO1 EAN-13 no. M n13   EAN13 Traded Unit Code
  :SPRO2 Supplier's code M an30   UPC12, EAN8, DUN14 or supplier's code
  :SPRO3 DUN14 no. O n14   Optional
  +SACU Customer's unit code O n15   Optional
  +CPRO Customer's product number O     Optional
  +UNOR1 Customer's units in traded unit M n15 pack size Number of consumer units making up the supplier's traded unit
          1 For measured & metred stock
  :UNOR2 Order measure M n10.3 Piece length For measured sq metred stock only
  :UNOR3 Measure indicator M an6 M If UNOR2 sent 
  +QTY1 Invoiced quantity M n15 No of traded units invoiced For measured and sq metred stock, thisis the no. of pieced invoiced
  :QTY2 Invoice measure total M n10.3 Total piece length For measured & sq metred stock only
  :QTY3 Measure indicator M an6 M If QTY1 2 sent. For measured stock only
          M2 If QTY1 2 sent. For measured stock only
  +AUCT1 Unit cost price M n10.4 Net line of discount before VAT Cost of order unit having applied line discount
  :AUCT2 Measure indicator M an6   For measured stock
  +LEXC Extended line cost M n10.4 AUCT X
QTY1 X
UNOR2 X
width		 For sq metred stock
          AUCT X
QTY1 X
UNOR2 X
width		 For sq metred stock
  +VATC VAT category code M an1 S = Standard rate
          Z = Zero value
          X  = Exempt
          L = Lower rate
  +VATP VAT percentage M n3.3 S e.g. 20.00% 
  +MIXI Mixed VAT indicator n     Not used
  +CRLI Credit line indicator n     Not used
  +TDES1 Product description M an40   Traded unit description
  :TDES2 Product description n     Not used
  +MSPR Selling-on price n     Not used
  +SRSP Statutory retail selling price n     Not used
  +BUCT Unit cost price before discount M n10.4   Before applying line discount, before VAT
  +DSCV  Discount value O n10.4 Line discount value Optional
  +DSCP Discount percentage n     Not used
  +SUBA  Subsidiary amount n     Not used
  +PRND Special price indicator n     Not used
  +IGPI Item group indicator n     Not used
  +CSDI Cash supplement discount indicator n     Not used
  +TSUP VAT type of supply n     Not used
  +SCRF Specification/contract references n     Not used

 

Data Narrative

Seg Field Description Req Data Length Value Notes
DNC   Data Narrative M      
  SEQA First level seq, no. M n10    
  +SEQB Second level seq. no. M n10    
  +SEQC Third level seq. no. M n10    
  +DNAC Data narrative code n     Not used
  +RTEX Registered text n     Not used
  +GNAR1 General narrative one M an40   General text
  +GNAR2 General narrative two M an40   General text
  +GNAR3 General narrative three M an40   General text
  :GNAR4 General narrative four M an40   General text

 

VAT Rate Sub-trailer

Seg Field Description Req Data Length Value Notes
STL   VAT rate sub-trailer M     One for each VAT rate used on this invoice
  SEQA First level seq. no. m n10   Start at 1 and is incremented by 1 for each segment of this type in the message
  +VATC VAT categorey code M an1 S = Standard rate
          Z =Zero value
          X = Exempt
          L = Lower rate
  +VATP VAT percentage M n3.3   e.g. 20.00%
  +NRIL No. of item lines M n10   Number of ILD segs with this VAT category code
  +LVLA Line sub-total amount M n10.2 Sum of LEXC Before VAT has been applied
  +QYDA Discount amount for invoice qty n     Not used
  +VLDA Discount amount for invoice value n     Not used
  +SURA Surcharge amount M n10.2   Freight, carriage charges etc
  +SSUB Subtotal subsidy n     Not used
  +EVLA Extended subtotal amount M n10.2 LVLA + SURA Before VAT has been applied
  +SEDA Subtotal settlement discount amount O n10.2   Optional
  +ASDA Extended subtotal amount(after settlement discount) M n10.2 EVLA - SEDA  
  +VATA VAT amount payable M n10.2 EVLA - SEDA  
  +APSE Payable subtotal amount(before settlement discount) M n10.2 EVLA + VAT rate  
  +APSI Payable subtotal amount (after settlement discount) M n10.2 ASDA + VATA  

 

Invoice Trailer

Seg Field Description Req Data Length Value Notes
TLR   Invoice Trailer        
  NSTL No. of VAT segments M n10 No. of STL segments  
  +LVLT Line total amount M n10.2 Sum of LVLA Line total amount before settlement discount has been applied
  +QYDT Discount amount for invoice quantity n     Not used
  +LVDT Discount amount for invoice file n     Not used
  +SURT Surcharge amount M n10.2 Sum of SURA  
  +TSUB Subtotal subsidy n     Not used
  +EVLT Extended total amount M n10.2 Sun of EVLA Total extended amount before discount has been applied
  +SEDT Total settlement discount amount M n10.2 Sum of SEDA  
  +ASDT Extended total amount M n10.2 Sum of ASDA Total amount after settlement discount has been applied
  +TVAT VAT amount payable M n10.2 Sum of VATA  
  +TPSE Payable total amount M n10.2 Sum of APSE Total payable before settlement discount has been applied
  +TPSI Payable total amount M  n10.2 Sum of APSI Total payable after settlement discount has been applied

 

Message Trailer

Seg Field Description Req Data Length Value Notes
MTR   Message Trailer M      
  NOSG Number of segments M n10   No. of segments in message inc. MHD/MTR

 

VAT Trailer

Seg Field Description Req Data Length Value Notes
MHD   Message Header M      
  MSRF Message reference M n12   Message count seq
  +TYPE1 Type M an6 VATTLR  
  :TYPE2 Version number M n1 9 Version of message
VRS   VAT Rate Summary M     One for each VAT rate used in this file of invoices
  SEQA First level seq. no. M n10    
  +VATC VAT category code M an1 S = Standard rate
          Z = Zero value 
          X = Exempt 
          L = Lower rate
  +VATP VAT percentage  M n3.3 20.00 eg 20.00
  +VSDE Extended summary amount M n10.2 Sum of EVLA  
  +VSDI Extended summary amount (after discount applied) M n10.2 Sum of ASDA  
  +VVAT VAT amount payable M n10.2 Sum of VATA  
  +VPSE Payable summary amount (before settlement discount) M n10.2 Sum of APSE  
  +VPSI Payable summary amount (after settlement discount) M n10.2 Sum of APSI  
MTR   Message Trailer M      
  NOSG No. of segments M n10 No. of segments in message Including MHD/MTR (-3 for this message)

 

Invoice Trailer

Seg Field Description Req Data Length Value Notes
MHD   Message header M      
  MSRF Message ref. M n12   Message count seq
  +TYPE1 Type M an6 INVTLR  
  :TYPE2 Version  M n1 9 Message version
TOT   Invoice file totals M      
  FASE Extended total amount M n10.2 Sum of VSDE File total amount before VAT and settlement discount
  +FASE1 Extended total amount (after settlement discount) M n10.2 Sum of VSDI  
  +FVAT  VAT amount payable  M n10.2 Sum of VVAT  
  +FPSE Payable total amount (before settlement discount) M n10.2 Sum of VPSE Optional
  +FPSI Payable total (after settlement discount) M n10.2 Sum of VPSI  
  +FTNI No. of invoices M n10   File total number of invoices
MTR   Message Trailer  M      
  NOSG No. of segments M n10 no. of segments in message Including MHD/MTR (=3 for this message)

 

Reconciliation Message

Seg Field Description Req Data Length Value Notes
MHD   Message Header M      
  MSRF Message reference M n12   Message
  +TYPE1 Type M an6 RSGRSG  
  :TYPE2 Version M n1 2  
RSG   Reconciliation M      
  RSGA STX SNRF M an14 =SNRF in STX Reference no. in STX
  +RSGB STX UNTO reconciliation M an14 = UNTO1 in STX John Lewis ANA no.
MTR   Message Trailer M n10 No. of segments in message Including MHD/MTR (=3 for this message)

 

End Transmission

Seg Field Description Req Data Length Value Notes
END   End of Transmission M      
  NMST No. of messages M n5 No. of messages in transmission No. of invoices