BGI TRADACOM Invoice MAPPING VERSION 9 TRANSACTION INVFIL
Inbound Invoice Message
Message INVFIL Invoice File Header Consisting of segments MHD TYP SDT CDT FIL FDT MTR INVOIC Invoice Details MHD CLO IRF ODD ILD STL TLR MTR VATTLR File VAT Trailer INVTLR Invoice File Trailer MHD VRS MTR MHD TOT MTR = Message Header = Transaction Type Details = Supplier Details = Customer Details = File Details = File Period Dates = Message Trailer = Message Header = Customer's Location = Invoice References = Order and Delivery References = Invoice Line Details = VAT Rate Invoice Sub Trailer = Invoice Trailer = Message Trailer = Message Header = VAT Rate Summary = Message Trailer = Message Header = File Totals = Message Trailer One message only, at the end of the file One message only, after all INVOIC messages in the file Repeat for each VAT rate in the file Repeat for each order in a multiple order invoice Repeat for each line item Repeat for each VAT rate in the message One message for each invoice Repeat as follows One message only, at the start of the file
NOTE: Every transmission must begin with segment STX and end with segment END.
Page: 1
Revision: 12/16/2004
BGI TRADACOM Invoice MAPPING VERSION 9 TRANSACTION INVFIL
Message INVOICE FILE HEADER FILE: INVOICE FILE DATA ELEMENT = MSRF + TYPE : TYP = TCDE SDT = SIDN BORDERS GROUP, INC. REMARKS Consecutive count of messages within the transmission ‘INVFIL’ ‘9’ for this version Type INVFIL
SEGMENT MHD
DATA ELEMENT NAME MESSAGE HEADER Message Reference Type of Message Type Version Number TRANSACTION TYPE DETAILS Transaction Code SUPPLIER DETAILS Supplier’s Identity Supplier’s EAN Location Number Supplier’s Identity Allocated by Customer Supplier’s Name Supplier’s Address Supplier’s VAT Registration Number CUSTOMER DETAILS Customer’s Identity Customer’s EAN Location Customer’s Identity Allocated by Supplier Customer’s Name Customer’s Address Customer’s VAT Registration Number FILE DETAILS File Generation Number File Version Number File Creation Date MESSAGE TRAILER Number of Segments
M/C PICTURE M M 9(12) M M M M M M M C C C C C C M M C C C C C C M M M M M M
X(6) 9(1)
9(4)
‘0700’ or ‘0709’ Identifies the invoicer EAN location (STX/FROM) Border’s Vendor Number Not Used Not Used Supplier’s VAT number Identifies the invoicee EAN location (STX/UNTO) Borders Group SAN number Not Used Not Used Border’s VAT number This number is sequential, per file type, per trading partner ‘1’ Date the file is created. Control count of the number of segments comprising message. The count includes the MHD and MTR segments surrounding the message
9(13) X(17) X(40)
: + + + CDT = CIDN : + + + FIL = FLGN + + MTR = NOSG FLVN FLDT CNAM CADD VATR SNAM SADD VATN
9(9)
9(13) X(17) X(40)
9(9) 9(4) 9(4) 9(6) 9(10)
Page: 2
Revision: 12/16/2004
BGI TRADACOM Invoice MAPPING VERSION 9 TRANSACTION INVFIL
Message INVOICE FILE DETAILS FILE: INVOICE FILE DATA ELEMENT = MSRF + TYPE : CLO = CLOC BORDERS GROUP, INC. REMARKS Consecutive count of messages within the transmission ‘INVOIC’ ‘9’ for this version At least Store # or SAN location must be present Not Used (Optional Location – Store #) Border’s SAN location As allocated by the supplier Invoice date Not Used Type INVOIC
SEGMENT MHD
DATA ELEMENT NAME MESSAGE HEADER Message Reference Type of Message Type Version Number CUSTOMER’S LOCATION Customer’s Location Customer’s EAN Location Customer’s Own Location Customer’s SAN Location INVOICE REFERENCES Invoice Number Date of Invoice Tax-point Date ORDER AND DELIVERY REFERENCES First Level Sequence Number
M/C PICTURE M M 9(12) M M M M M C C C M M M C M M
X(6) 9(1)
: : IRF = + + ODD = SEQA INVN IVDT TXDT
9(13) X(17) X(17) X(17) 9(6) 9(6)
9(10)
Starts at 1 and is incremented by 1 for each segment of this type in this message Border’s Purchase Order Number Delivery note number as allocated by the supplier Date of despatch. Not Used Not Used Not Used Not Used Not Used Not Used Not Used Optional Special Deals or Publisher’s Promotion Number
+ +
ORNO DELN
Order Number and Date Customer’s Order Number Delivery Note Details Delivery Note Number : Date of Document Number of Delivery or Uplift Units Delivery Weights Proof of Delivery Details Name of Carrier Despatch Location Transhipment Location Journey Reference Specification/Contract References Specification Number Contract Number
M M M C C C C C C C C C C C C
X(17) X(17) 9(6) 9(15)
+ + + + + + + +
NODU DEWT PODN SCAR DLOC TLOC JORF SCRF :
X(40)
X(17) X(17) X(17)
Page: 3
Revision: 12/16/2004
BGI TRADACOM Invoice MAPPING VERSION 9 TRANSACTION INVFIL
Message INVOICE FILE DETAILS FILE: ILD INVOICE FILE (Cont) = SEQA + + SEQB SPRO INVOICE LINE DETAILS First Level Sequence Number Second Level Sequence Number Supplier’s Product Number EAN-13 Article Number for Traded Unit Supplier’s Code for Traded Unit Supplier’s EAN Number Customer’s Product Number Customer’s Own Brand EAN # Customer’s Item Code Unit of Ordering Quantity Invoiced Number of Traded Units Invoiced Unit Cost Cost Price (excluding VAT) Extended Line Cost (excluding VAT) VAT Rate Category Code VAT Rate Percentage Mixed VAT Rate Product Indicator Credit Line Indicator Traded Unit Description Traded Unit Description Line 1 Traded Unit Description Line 2 Selling On Price Manufacturer’s Selling Price Statutory Retail Selling Price (including VAT) Unit Cost Price (excluding VAT) before discount Discount Value Discount Percentage M M M M C C C C C C C M M M M M 9(13) X(30) 9(13) 9(15) X(30) Type INVOIC
9(10) 9(10)
Takes the same value as in the corresponding ODD segment Starts at 1 and is successively incremented for each item Must match the Order SPRO. Either must exist EAN-13 article number ISBN or UPC code Not Used Optional Not Used Borders BIC number Not Used Number of supplier's traded units invoiced Cost of order unit having applied line discount. Having applied line discounts. In pounds. LEXC = AUCT X QTYI Code Values List 12 Percentage rate for VAT Category Code Not Used Not Used Description of the item being traded, consistent with Product Information data and any labels or packaging Not Used Not Used Retail Cost Line discount value. In pounds Line item discount percentage
: + + SACU CPRO : + + UNOR QTYI
9(15)
+ +
AUCT LEXC
9(10)V9(4) 9(10)V9(4)
+ + + + +
VATC VATP MIXI CRLI TDES :
M M C C C C C C C C C C C
X(1) 9(3)V9(3) 9(1) X(4) X(40) X(40)
+ + + + +
MSPR SRSP BUCT DSCV DSCP
9(10)V9(4) 9(10)V9(4) 9(10)V9(4) 9(10)V9(4) 9(3)V9(3)
Page: 4
Revision: 12/16/2004
BGI TRADACOM Invoice MAPPING VERSION 9 TRANSACTION INVFIL
Message INVOICE FILE DETAILS FILE: STL INVOICE FILE (Cont) = SEQA VATC VATP NRIL LVLA VAT RATE INVOICE SUBTRAILER First Level Sequence Number VAT Rate Category Code VAT Rate percentage Number of Item Lines Line Sub-Total Amount (before VAT) Discount Amount for Invoice Quantity Discount Amount for Invoice Value Surcharge Amount Sub-Total Subsidy Extended Sub-Total Amount (before settlement discount has been applied) Sub-Total Settlement Discount Amount Extended Sub-Total Amount (after settlement discount has been applied) VAT Amount Payable Payable Sub-Total Amount (before settlement discount) Payable Sub-Total Amount (after settlement discount has been applied) M M M M M M 9(10) X(1) 9(3)V9(3) 9(10) 9(10)V9(2) All values are in pounds Start at 1 and incremented by 1. VAT Rate Code Value List 12 VAT Percentage Number of ILD segments with this VAT Category Code Before VAT has been applied. Total of Net Cost Values (LEXC) for this VAT Category Code Not Used Not Used Not Used Not Used Before VAT. EVLA = LVLA QYDA - VLDA + SURA – SSUB Not Used Before VAT has been applied. ASDA = EVLA – SEDA VAT amount at quoted VAT rate After VAT has been applied. APSE = EVLA + VATA After VAT has been applied. APSI = ASDA + VATA Type INVOIC
+ + + +
+ + + + +
QYDA VLDA SURA SSUB EVLA
C C C C M
9(10)V9(2) 9(10)V9(2) 9(10)V9(2) 9(10)V9(2) 9(10)V9(2)
+ +
SEDA ASDA
C M
9(10)V9(2) 9(10)V9(2)
+ + +
VATA APSE APSI
M C M
9(10)V9(2) 9(10)V9(2) 9(10)V9(2)
Page: 5
Revision: 12/16/2004
BGI TRADACOM Invoice MAPPING VERSION 9 TRANSACTION INVFIL
Message INVOICE FILE DETAILS FILE: TLR INVOICE FILE (Cont) = NSTL + LVLT INVOICE TRAILER Number of Total Segments Lines Total Amount (before settlement discount has been applied) Total Discount Amount for Invoice Quantity Total Discount Amount for Invoice Value Total Surcharge Amount Total Subsidy Amount Total Extended Amount (before settlement discount has been applied) Total Settlement Discount Amount Total Amount (after settlement discount has been applied) Total VAT Amount Payable Total payable (before settlement discount) Total payable (after settlement discount) MESSAGE TRAILER Number of Segments in Message M M M Type INVOIC
9(10) 9(10)V9(2)
Number of preceding STL segments Total Cost – Must match all line item costs. Not Used Not Used Not Used Not Used Sum of EVLA’s in preceding STL segments. Before VAT Not Used Sum of ASDA’s in preceding STL segments. Before VAT Sum of VATA’s in preceding STL segments Sum of APSE’s in preceding STL segments Sum of APSI’s in preceding STL segments Control count of the number of segments comprising message. The count includes the MHD and MTR segments surrounding the message
+ + + + +
QYDT VLDT SURT TSUB EVLT
C C C C M
9(10)V9(2) 9(10)V9(2) 9(10)V9(2) 9(10)V9(2) 9(10)V9(2)
+ + + + + MTR =
SEDT ASDT TVAT TPSE TPSI
C M M C M M M
9(10)V9(2) 9(10)V9(2) 9(10)V9(2) 9(10)V9(2) 9(10)V9(2)
NOSG
9(10)
Page: 6
Revision: 12/16/2004
BGI TRADACOM Invoice MAPPING VERSION 9 TRANSACTION INVFIL
Message FILE VAT TRAILER Type VATTLR
FILE:
INVOICE FILE DATA ELEMENT = MSRF + TYPE : BORDERS GROUP, INC. REMARKS Consecutive count of messages within the transmission ‘VATTLR’ ‘9’ for this version Starts at 1 and is incremented by 1 for each segment of this type in the message Code Values List 12 Percentage rate for VAT Category Code. As used in INVOIC messages Sum of EVLA’s in corresponding STL segments. Before VAT Sum of ASDA’s in corresponding STL segments. Before VAT Sum of VATA’s in corresponding STL segments Sum of APSE’s in corresponding STL segments. After VAT Sum of APSI’s in corresponding STL segments. After VAT Control count of the number of segments comprising message. The count includes the MHD and MTR segments surrounding the message
SEGMENT MHD
DATA ELEMENT NAME MESSAGE HEADER Message Reference Type of Message Type Version Number VAT RATE SUMMARY First Level Sequence Number
M/C PICTURE M M 9(12) M M M M M
X(6) 9(1) 9(10)
VRS
= SEQA
+ +
VATC VATP
VAT Rate Category Code VAT Rate Percentage
M M
X(1) 9(3)V9(3)
+
VSDE
File Sub-Total Amount (before settlement discount) File Sub-Total Amount (after settlement discount) File VAT Sub-Total File Sub-Total Payable (before settlement discount) File Sub-Total Payable (after settlement discount) MESSAGE TRAILER Number of Segments in Message
M
9(10)V9(2)
+
VSDI
M
9(10)V9(2)
+ + + MTR =
VVAT VPSE VPSI
M C M M M
9(10)V9(2) 9(10)V9(2) 9(10)V9(2)
NOSG
9(10)
Page: 7
Revision: 12/16/2004
BGI TRADACOM Invoice MAPPING VERSION 9 TRANSACTION INVFIL
Message INVOICE FILE TRAILER Type INVTLR
FILE:
INVOICE FILE DATA ELEMENT = MSRF + TYPE : BORDERS GROUP, INC. REMARKS Consecutive count of messages within the transmission ‘INVTLR’ ‘9’ for this version Sum of VSDE’s in VATTLR message Sum of VSDI’s in VATTLR message Sum of VVAT’s in VATTLR message Sum of VPSE’s in VATTLR message. After VAT Sum of VPSI’s in VATTLR message. After VAT Number of Invoice Details Messages, ‘INVOIC’ for this file Control count of the number of segments comprising message. The count includes the MHD and MTR segments surrounding the message
SEGMENT MHD
DATA ELEMENT NAME MESSAGE HEADER Message Reference Type of Message Type Version Number FILE TOTALS File Total Amount (before VAT and settlement discount) File Total Amount (before VAT but after settlement discount has been applied) File Total VAT Amount File Total Payable (before settlement discount) File Total Payable (after settlement discount has been applied) File Total Number of Invoice Messages MESSAGE TRAILER Number of Segments in Message
M/C PICTURE M M 9(12) M M M M M M
X(6) 9(1) 9(10)V9(2) 9(10)V9(2)
TOT
= FASE + FASI
+ + +
FVAT FPSE FPSI
M C M
9(10)V9(2) 9(10)V9(2) 9(10)V9(2)
+ MTR =
FTNI
M M M
9(10)
NOSG
9(10)
Page: 8
Revision: 12/16/2004