EDI - Tradacoms Invoice specifications

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