BGI ASC X12 INVOICE (810) for Standard and eCommerce MAPPING VERSION 004010 TRANSACTION 810
Transmit your invoices to Waldenbooks and Borders on a weekly basis Invoice Hierarchy ________________________________________________________________________ ISA Interchange Control Header Segment GS Functional Group header ____________________________________________________________________ INVOICE________________________________________ ST Start Transaction Segment BIG Beginning PO Segment REF Program or Deal Code Information (Borders only) N1 Bill to SAN N1 Ship to _____________________________________________________ Line Items__________________________________ IT1 Invoice Item Description IT3 Additional Item Data CTP Pricing (discount) information PID Product Description ____________________________________________________ TDS Total Invoice Cost TXI Total Tax Information SAC Total Invoice Charges and Allowances ____________________________________________________ CTT Transaction Total Segments SE End Transaction ________________________________________________________ __________________________________________________________________ GE Functional Group Trailer IEA Interchange Control Trailer ______________________________________________________________________
Page 1 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Interchange Control Header
ISA
ISA01 I01 Authorization Qualif M ID 2/2 Constant 00
ISA02 I02 Authorization Info M AN 10/10 Constant spaces
ISA03 I03 Security Qualif M ID 2/2 Constant 00
ISA04 I04 Security Info M ID 10/10 Constant spaces
ISA05 I05 Interchange Qualif M ID 2/2
Network assigned qualifier of the sender
ISA11 I10 Interchange Stand ID M ID 1/1 Constant U
ISA06 I06 Sender’s Network ID M AN 15/15 Network assigned ID of the sender
ISA07 I05 Interchange ID Qaulif M ID 2/2 Constant ZZ
ISA08 I07 Receiver’s ID M AN 15/15 Network assigned Receiver’s ED
ISA09 I08 Interchange Date M DT 6/6 YYMMDD
ISA10 I09 Interchange Time M TM 6/6 HHMM
ISA12 I11 Version Number M ID 5/5 Constant 00401
ISA13 I12 Interchange control M NO 9/9 Sequentially assigned number
ISA14 I13 Acknow Requested M ID 1/1 0 = No 1 = Yes Constant 0
ISA15 Test Indicator M ID T = Test data P = Production
I14 1/1
ISA16 I15 Subelement separator M ID 1/1 Character used as the subelement sep.
Example:
ISA*00* *00* *ZZ*SENDER ID *ZZ*877729368 *YYMMDD*HHMM*U*00401*000000002*0*T*:
Page 2 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Transmit your invoices to Waldenbooks and Borders on a weekly basis Functional Group Header
GS GS01 479 Functional ID Code M ID 2/2 Constant IN GS02 142 Sender’s appl M AN 2/15 Sender’s application name GS03 124 Receiver’s appl M AN 2/15 Receiver’s application name GS04 9829 Interch. Date M DT 8/8 CCYYMMDD GS05 9830 Interch. Time M TM 4/4 HHMM GS06 9828 Control No. M NO 1/9 Sequentially assigned number
GS07 455 Responsible Agency M ID 1/2 Constant X
GS08 480 Version/Release M AN 1/12 004010
Example: GS*IN*SENDER ID*RECEIVER ID*CCYYMMDD*HHMM*2*X*004010
Our receiver id should be 877729368B for Borders business Our receiver id should be 877729368E for Waldenbooks business
Transmit your invoices to Waldenbooks and Borders on a weekly basis.
Page 3 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Start of transaction segment
ST01 143 Transaction Set ID M ID 3/3 Constant 810 ST02 329 Control number M NO 4/9 Sequentially assigned number
ST
Example: ST*810*0002
Transmit your invoices to Waldenbooks and Borders on a weekly basis.
Page 4 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Beginning Segment for Invoice
BIG01 Invoice Date M DT Invoice Date YYYYMMDD 245 8/8 BIG02 76 Invoice Number M AN 1/22 Invoice Number BIG04 324 P.O. Number M AN 1/22 P.O. Number BIG07 640 Trans Type Cd M ID 2/2 Transaction Type Code *
BIG
Valid Transaction Type Codes DI Invoice
Example: BIG*YYYYMMDD*123456**7890123-0201***DI
Reference segment to send the Packing Slip or Bill of Lading number for the invoiced material.
REF REF01 128 Reference No Qualif. O ID 2/2 Constant PK ( for Borders) Constant BM (Waldenbooks) REF02 127 Reference Number C AN 1/30 Packing slip number Bill of Lading
Example:
REF*PK*0176733
Page 5 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Bill to Segment for Invoice
N1
N101 Entity Code M ID BT = Bill to indicator
98 2/2
N103 66 ID Code Qualif. C ID ½ Constant 15 = Std Address No
N104 ID Code C AN
67 2/17
Standard Address No.
Example: N1*BT**15*1523546 For BordersPurchase orders received with Bill to SAN 1523546. N1*BT**15*148625X For Waldens Purchase orders received with Bill to SAN148625X Ship to segment
N1 N101 Entity Code M ID ST = Ship to 98 2/2 N102 Name C N 93 1/35 N103 66 ID Code Qualif. C ID 1/2 Constant 15 = Std Address No N104 ID Code C AN 67 2/17
Store number
Standard Address No.
Example: N1*ST*0025*15*1557181
Please note that N102 is a numeric field. The N102 can be left blank if you have the correct San number in N104.
Page 6 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Invoice Baseline Item Description
IT1 IT101 350 Line Item ID O AN 1/20 Assign ID or Prime Line Number* IT102 358 Quantity Ordered M R 1/10 Quantity IT103 355 Unit of Measure M ID 2/2 Constant “EA” IT104 212 Unit Price M R 1/14 Cost IT106 235 Prod ID Qual M ID 2/2 IB = ISBN UP = UPC VC = Vendor Catalog number IT111 234 Product ID C AN 1/30 GTIN-14
IT107 234 Product ID C AN 1/30 ISBN-10 UPC or
IT108 235 Product Qualifier O ID 2/2 EN
IT109 234 Product ID X AN 1/30 ISBN-13
IT110 235 Product Qualifier O ID 2/2 UK
IT112 235 Product Qualifier O ID 2/2 “PO” if there are multiple PO’s per invoice
IT113 234 Product ID C AN 1/30 Purchase order if multiple PO’s per invoice
Example: IT1*1*12*EA*8.95**IB*0553452185*EN*9780553452186*UK*09780553452186 *Note that if an eCommerce invoice is sent that the IT1_01 field must contain the Prime Line Number that was sent in the PO1_01 field of the purchase order 850 transaction.
Page 7 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Additional Item Data
IT3 IT303 368 Shipment Order Status Code M ID 2/2
Example: IT3***AS
Pricing Information
CTP03 Retail Price M R Retail Price 212 1/14 CTP06 648 Multiplier Qual M ID 3/3 Constant “DIS” CTP07 Multiplier M R 649 1/10
CTP
Discount Percent
Example: CTP***59.95***DIS*.52
Retail value can be zero (0), otherwise Retail must be greater than cost. Retail value multiplied by discount percent equals the unit cost in IT104.
Page 8 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Title Segment. This segment is necessary if the ISBN is not available for the line item.
PID01 349 Item Description Type M ID 1/1 F = Free-form PID05 Description M AN Title of book 352 1/60
PID
Example: PID*F****THE CAT IN THE HAT
Total Invoice Cost Segment
TDS01 Total Invoice Cost M N2 Total cost of the invoice 361 1/10
TDS
Example: TDS*129950 Notice that there is not a decimal point
Page 9 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Total Tax Information
TXI01 Tax Type Code O ID 963 2/2 TXI02 782 Monetary Amount C R 1/15 Total Amount of Tax
TXI
TXI*LS*24.98
For Domestic vendors use “LS” for reporting State and Local sales tax. For international vendors use “ZZ” for reporting GST.
Page 10 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Total Invoice Freight and Special Handling Charges (Optional)
SAC01 248 SAC Allowance/Charge Ind M ID 1/1 SAC02 1300 Service, Promotion, Allowance, or Charge Information X ID 4/4 Allowance or Charge Code. See tables below SAC03 559 Agency Qualifier Code X ID 2/2 Constant “VI” Voluntary InterIndustry Commerce Standard SAC05 Amount M N2 610 1/15
“A” - Allowance “C” - Charge
Amount of allowance or charge
Example: SAC*A*I410*VI**860 Not that there is not a decimal. It is implied
SAC02 Allowance Codes Recognized by BGI DSC - Discount – Incentive PAH - Promotional allowance E800 - No return credit allowance H000 - Special allowance I410 - Unsalable merchandise allowance SAC02 Charge Codes Recognized by BGI D240 - Freight D920 - Insurance Fee D800 - Inland transportation B700 - Converting D200 - Freight charge to destination D500 - Handling A010 - Minimum order/minimum billing charge aka Absolute Minimum Charge MRK - Marking or tagging charge SCG - Small order charge SUR – Surcharge SAC02 Charge Codes Recognized by BGI for Multi-Media Vendors only MAD - Small Order Charge E560 - Stickering Charge
Page 11 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Transaction Total Segment
CTT01 354 Total Line Item M NO 1/6 Total number of line items
CTT
Example: CTT*12
Transaction Set Trailer
SE01 96 Number of Segments M NO 1/6 Total no. of segments including the ST & SE segments in this transaction SE02 329 Control Number M AN 4/9 Sequentially assigned number must be the same as the number in STO2
S E
Example: SE*12*0002
Page 12 of 14
Revision: 1/29/2008
BGI ASC X12 INVOICE MAPPING VERSION 004010 TRANSACTION 810
Functional Group Trailer Segment
GE01 97 No. of Transaction set M NO 1/6 Total no. of ST segments in the group GE02 28 Control Number M AN 1/9 Sequentially assigned number must be the same as the number in GS06
GE
Example: GE*1*2
Interchange Control Trailer
IEA
IEA01 I16 No. of Functional Groups M NO 1/5 Total no. of GS segments in the transmission
IEA02 I12 Control Number M AN 9/9 Sequentially assigned number must be the same as the number in ISA13
Example: IEA*1*000000002
Page 13 of 14
Revision: 1/29/2008
Invoice Example ISA*00* *00* *ZZ*xxxxxxxxxxxxxxx*ZZ*877729368T *041111*1645*X*00401*000000019*0*P*/~ GS*IN*xxxxxxxxxxxxxx*877729368BT*20041111*1645*19*X*004010~ ST*810*0001~ BIG*20040922*01714239**GBHC0088***DI~ N1*BT**15*1523546~ N1*ST**15*9020640~ IT1*1*12*EA*8.95**IB*0553452185*EN*9780553452186*UK*09780553 452186*PO705129812~ CTP***55***DIS*.0~ PID*F****CHARMAINE SOLOMON COMPLETE VEGETARIAN~ TDS*27500~ TXI*LS*24.98~ SAC*A*I410*VI**8.60~ CTT*1~ SE*10*0001~ GE*1*19~ IEA*1*000000019~
Page 14 of 14
Revision: 1/29/2008