BGI ANSI X12 EXPENSE INVOICE MAPPING (810) VERSION 004010 TRANSACTION 810
ASC X12 INVOICE HIERARCHY
_______________________________________________________________________
ISA Interchange Control Header Segment GS Functional Group Header _____________________________________________________________ INVOICE__________________________________________ ST Start Transaction Segment BIG Beginning Invoice Segment REF Packing Slip Number N1 Bill to Segment N1 Ship to Segment ______________________________________________ Line Items___________________________ IT1 Item Description TXI Tax Information PID Product/Item Description N1 Cost Center info REF Cost Center data ____________________________________ ______________________________________________ TDS Invoice Total Cost TXI Tax information SAC Allowance or Charge at Invoice Level CTT Invoice Totals SE End Transaction Segment __________________________________________________ ____________________________________________________________ GE IEA Functional Group Trailer Transaction Control Trailer
__________________________________________________________________
Revision: 1/29/2008
1
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
ISA04 I04 Security Info M ID 10/10
ISA05 I05 Interchange Qualif M ID 2/2 Constant ZZ
Constant 00
Constant spaces
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
ISA11 I10 Interchange Stand ID M ID 1/1 Constant U
ISA12 I11 Version Number M ID 5/5
Constant 00200
ISA13 I12 Interchange control M NO 9/9 Sequentially assigned number
ISA14 I13 Acknow Requested M ID 1/1 0 = No
ISA15 I14 Test Indicator M ID 1/1 T = Test data P = Production
ISA16 I15 Subelement separator M ID 1/1 Character used as the subelement sep.
Example:
ISA*00* *00* *ZZ*SENDER ID *ZZ*RECEIVER ID *YYMMDD*HHMM*U*00200*000000002*0*T*:
Revision: 1/29/2008
2
BGI ANSI X12 EXPENSE INVOICE MAPPING VERSION 004010 TRANSACTION 810
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 ½ Constant X
GS08 480 Version/Release M AN 1/12 004010
Example: GS*IN*SENDER ID*RECEIVER ID*YYMMDD*HHMM*2*X*004010 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
Revision: 1/29/2008
3
BGI ANSI X12 EXPENSE INVOICE MAPPING VERSION 004010 TRANSACTION 810
Beginning Segment for Invoice (Mandatory)
BIG01 Invoice Date M DT Invoice Date CCYYMMDD 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
** PO number is optional, but if available, should be present at header level or at detail line item level. If the invoice is for multiple POs, then please send the PO number at detail line item level. Example: BIG*CCYYMMDD*123456**7890123-0201***DI
Reference segment to send the Packing Slip or Bill of Lading number for the invoiced material. (Optional)
REF REF01 128 Reference No Qualif. M ID 2/2 Constant PK ( for Borders) Constant BM (Waldenbooks) REF02 127 Reference Number C AN 1/20 Packing slip number Bill of Lading
Example:
REF*PK*0176733
Revision: 1/29/2008
4
BGI ANSI X12 EXPENSE INVOICE MAPPING VERSION 004010 TRANSACTION 810
Bill to Segment for Invoice (Optional ) N101 98 Entity Code M ID 2/2 BT = Bill to indicator N103 66 ID Code Qualif. C ID ½ Constant 15 = Std Address No N104 ID Code C AN 67 2/17
N1
Standard Address No.
Example:N1*BT**15*1523546
Ship to segment (Mandatory)
N1 N101 98 Entity Code M ID 2/2 ST = Store N102 Name C N 93 1/4 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*080*15*1557181
Revision: 1/29/2008
5
BGI ANSI X12 EXPENSE INVOICE MAPPING VERSION 004010 TRANSACTION 810
Invoice Baseline Item Description (Mandatory)
IT1 IT102 358 Quantity Ordered M R 1/10 Quantity IT103 355 Unit of Measure M ID 2/2 Constant “EA” IT104 212 Unit Price C R 1/14 Cost IT106 235 Prod ID Qual M ID 2/2 VC - Vendor catalog number IT107 234 Product ID C AN 1/30 Vendor Catalog Number
IT108 235 Prod ID Qual O ID 2/2 **PO
IT109 234 Product ID O AN 1/30 **PO number
** If the invoice is for mulitple POs, then the PO number is sent in IT109 and is mandatory.
Example: IT1**12*EA*8.95**VC*0553452185 Tax Information (Optional): ( tax at line item level)
TXI TXI01 Tax Type Code O AN TXI02 Tax Amount C N2 Tax amount
2/2
1/10
LS – state and local sales tax
Example: TXI*LS*12.50 Product/Item Description (Optional)
PID PID01 349 Item Description Type O ID 1/1 F = Free-form PID05 Description C AN Product Description 352 1/60
Example: PID*F****cup 20 oz, 2002 ppr
Revision: 1/29/2008
6
BGI ANSI X12 EXPENSE INVOICE MAPPING VERSION 004010 TRANSACTION 810
Cost Center Information (Mandatory) N101 98 Entity Code M ID 2/2 PD = Purchaser’s Department N102 93 Name M AN 1/35 Cost Center Number
N1
Example: N1*PD*1400
The REF segment is optional.
REF
REF01 128 Reference No Qualifier M ID 2/2 RE = Release
REF02 127 Reference Number C AN 1/30 Cost Center Release No.
REF03 352 Reference Number C AN 1/80 Cost Center Routing
Revision: 1/29/2008
7
BGI ANSI X12 EXPENSE INVOICE MAPPING VERSION 004010 TRANSACTION 810
Total Invoice Cost Segment (Mandatory)
TDS01 Total Invoice Cost M N2 Total cost of the invoice 361 1/10
TDS
Example: TDS*129950
Tax Information (Optional)
TXI01 Tax Type Code O AN TXI02 Tax Amount C N2 Tax amount
TXI
2/2
1/10
LS – state and local sales tax
Example: TXI*LS*12.50
Revision: 1/29/2008
8
BGI ANSI X12 EXPENSE INVOICE MAPPING VERSION 004010 TRANSACTION 810
Total Invoice Allowance or Charges (Optional)
** This segment can only be sent at the summary level SAC01 248 SAC02 150 SAC Allowance/Charge Ind Charge Code O ID 1/1 O ID 3/3 See tables below “A” - Allowance “C” - Charge SAC03 559 Agency Qualifier Code X ID 2/2 Constant “VI” Voluntary InterIndustry Commerce Standard SAC04 1301 Agency Code X AN 1/10 Agency Service Promotion, Allowance or Charge Code
SAC05 Amount C N2
360 1/9
SAC12 331 Method of Handling O ID 2/2 Constant “06” for charges and “02” for allowances
Allowance or charge Amount
SAC15 352 Descritpion O AN 1/25 Charge or Allowance descripton
Example: SAC*C*D220*VI*ZZ*1205*******06***Freight Note: decimal is implied
Revision: 1/29/2008
9
BGI ANSI X12 EXPENSE INVOICE MAPPING VERSION 004010 TRANSACTION 810
Expense Vendors
SAC02 Allowance Codes Recognized by BGI C260 - Discount - Incentive F800 - Promotional allowance SAC02 Charge Codes Recognized by BGI H090 - Special handling service D220 – Freight/Fuel charge C040 – Delivery G970 - Small order charge H550 - Surcharge
Transaction Total Segment (Mandatory)
CTT01 354 Total Line Item M NO 1/6 Total number of line items
CTT
Example: CTT*12 Transaction Set Trailer
S E 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
Example: SE*12*0002
Revision: 1/29/2008
10
BGI ANSI X12 EXPENSE 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
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
IEA
Example: IEA*1*000000002
Revision: 1/29/2008
11
APPENDIX A
Invoice Example
ISA*00* *00* *ZZ*BCOPECTST *ZZ*B169366 *001115*1129*U*00200*000000031*0*T*>~ GS*IN*BCOPECTST*B169366*20001115*1129*31*X*004010~ ST*810*000017534~ BIG*20000929*1319**092800***DR~ N1*ST*214*15*1552066~ IT1*1*5*CT*16~14**VC*W210X6X18BAG~ TXI*LS*4~84~ PID*F****BAG,BORDERS 10X6X18 1000~ N1*PD*7230~ IT1*2*24*EA*2~6**VC*S2BM152~ TXI*LS*3~74~ PID*F****RIBBON,NYL BK MX 80 1/BX~ N1*PD*7240~ IT1*3*4*BG*~45**VC*A6RB90QA~ TXI*LS*~11~ PID*F****RUBBERBAND,90% AST ~25LB~ N1*PD*7240~ IT1*4*4*BG*~45**VC*A6RB90Q19~ TXI*LS*~11~ PID*F****RUBBERBAND,90% #19 ~25LB~ N1*PD*1400~ IT1*5*4*BG*~45**VC*A6RB90Q33~ TXI*LS*~11~ PID*F****RUBBERBAND,90% #33 ~25LB~ N1*PD*7240~ TDS*15741*17301~ TXI*LS*8~91~
SAC*C*D220*VI*ZZ*1205*******06***Freight~
CTT*5~ SE*27*000017534~ GE*1*32~ IEA*1*000000032~
Revision: 1/29/2008
12