SeanHoppe.com ERP VAI/S2K Amazon.com Outbound 810 Element to Field Mappings
CLEO Integrator Message class element map
Message class . : 810 O810-AMZN *All elements
Message class . . . . . : 810 O810-AMZN AMAZON.com 4010 IN Status: D Direction code : S
Date/time created . . . : 4/19/11 16:01:08.89 Date/time last changed . . . : 2/06/15 12:47:11.85
Standard class . . . . : ASC X12 Standards Industry group . . : Full X12 standards VerRel : 004010
Application file set . : VAI810S VAI Outbound Invoice - 810 Send File set status: D
Message area . : 1. First section
Loop level 1 Seg seq 010 Seg inst 1 Segment ST Transaction Set Header
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
ST 1 1 1 143 Transaction Set Identifie ID S 3 3 M S0 Special process
ST 1 2 1 329 Transaction Set Control N AN 4 9 M S0 Special process
Loop level 1 Seg seq 020 Seg inst 1 Segment BIG Beginning Segment for Invoice
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
BIG 1 1 1 373 Date DT 8 8 M A0 VEDXINH/EDXINHR SAINDT Invoice Date
BIG 1 2 1 76 Invoice Number N 1 22 M L A0 VEDXINH/EDXINHR SAINV Invoice No.
BIG 1 3 1 373 Date DT 8 8 O A0 VEDXINH/EDXINHR SAPODT P.O. Date
BIG 1 4 1 324 Purchase Order Number AN 1 22 O A0 VEDXINH/EDXINHR SACPO Customer P.O.
Loop level 1 Seg seq 040 Seg inst 1 Segment CUR Currency
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
CUR 1 1 1 98 Entity Identifier Code ID S 2 3 M C2 BT Bill-to-Party
CUR 1 2 1 100 Currency Code ID 3 3 M C3 USD Constant 3 characters
Loop level 1 Seg seq 070 Seg inst 1 Segment N1 Name
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N1 1 1 1 98 Entity Identifier Code ID S 2 3 M C2 RI Remit To
N1 1 2 1 93 Name AN 1 60 C C0 O810-AMZN NAME OHIO ART CO.
Loop level 2 Seg seq 090 Seg inst 1 Segment N3 Address Information
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N3 1 1 1 166 Address Information AN 1 55 M C0 O810-AMZN ADD1 P O BOX 72085
Loop level 2 Seg seq 100 Seg inst 1 Segment N4 Geographic Location
EXTOL Integrator Message class element map SHOPPE QPADEV0007 4/25/15 11:11:45 Page 2
Message class . : 810 O810-AMZN *All elements
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N4 1 1 1 19 City Name AN 2 30 O C0 O810-AMZN ADD3 CLEVELAND
N4 1 2 1 156 State or Province Code ID 2 2 O C0 O810-AMZN STE OH
N4 1 3 1 116 Postal Code ID 3 15 O C0 O810-AMZN ZIP 44192-0002
N4 1 4 1 26 Country Code ID 2 3 O C2 US Constant 2 characters
Loop level 1 Seg seq 070 Seg inst 2 Segment N1 Name
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N1 2 1 1 98 Entity Identifier Code ID S 2 3 M C2 ST Ship To
N1 2 2 1 93 Name AN 1 60 C A0 VEDXINH/EDXINHR SASNAM Ship to Name
N1 2 3 1 66 Identification Code Quali ID S 1 2 C C1 9 D-U-N-S+4, D-U-N-S Number
N1 2 4 1 67 Identification Code AN 2 80 C A0 VEDXINH/EDXINHR SAEDIN EDI Ship-To
Loop level 2 Seg seq 090 Seg inst 1 Segment N3 Address Information
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N3 1 1 1 166 Address Information AN 1 55 M A0 VEDXINH/EDXINHR SASAD1 Ship to Address 1
N3 1 2 1 166 Address Information AN 1 55 O A0 VEDXINH/EDXINHR SASAD2 Ship to Address 2
Loop level 2 Seg seq 100 Seg inst 1 Segment N4 Geographic Location
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N4 1 1 1 19 City Name AN 2 30 O A0 VEDXINH/EDXINHR SACITY Ship to City
N4 1 2 1 156 State or Province Code ID 2 2 O A0 VEDXINH/EDXINHR SAST Ship to State
N4 1 3 1 116 Postal Code ID 3 15 O A0 VEDXINH/EDXINHR SAZIP Ship to Zip Code
Loop level 1 Seg seq 130 Seg inst 1 Segment ITD Terms of Sale/Deferred Terms of Sale
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
ITD 1 1 1 336 Terms Type Code ID S 2 2 O C2 01 Basic
ITD 1 2 1 333 Terms Basis Date Code ID S 1 2 O C1 3 Invoice Date
ITD 1 3 1 338 Terms Discount Percent R 1 6 O
ITD 1 4 1 370 Terms Discount Due Date DT 8 8 C
ITD 1 5 1 351 Terms Discount Days Due N0 1 3 C A0 VEDXINH/EDXINHR SAITD5 Terms Discount Days Due
ITD 1 6 1 446 Terms Net Due Date DT 8 8 O A0 VEDXINH/EDXINHR SAITD6 Terms Net Due Date
ITD 1 8 1 362 Terms Discount Amount N2 1 10 O A0 VEDXINH/EDXINHR SAITD8 Terms Discount Amount
ITD 1 12 1 352 Description AN 1 80 O A0 VEDXINH/EDXINHR SATRMD Terms Discount Desc
Loop level 1 Seg seq 150 Seg inst 1 Segment FOB F.O.B. Related Instructions
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
FOB 1 1 1 146 Shipment Method of Paymen ID S 2 2 M A0 VEDXINH/EDXINHR SAFOB F.O.B. Code
Message area . : 2. Second section
Loop level 1 Seg seq 010 Seg inst 1 Segment IT1 Baseline Item Data (Invoice)
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
IT1 1 1 1 350 Assigned Identification N 1 20 O L A0 VEDXIND/EDXINDR SBEPOLN Customer PO Line #
IT1 1 2 1 358 Quantity Invoiced R 1 10 C A0 VEDXIND/EDXINDR SBQSHP Ship Quantity
IT1 1 3 1 355 Unit or Basis for Measure ID S 2 2 C A0 VEDXIND/EDXINDR SBUM Unit of Measure
IT1 1 4 1 212 Unit Price R 1 17 C A0 VEDXIND/EDXINDR SBPRIC Item Sell Price
IT1 1 5 1 639 Basis of Unit Price Code ID S 2 2 O C2 NT Net
IT1 1 6 1 235 Product/Service ID Qualif ID S 2 2 C C2 UP U.P.C. Consumer Package C
IT1 1 7 1 234 Product/Service ID AN 1 48 C A0 VEDXIND/EDXINDR SBUPC UPC Code
IT1 1 8 1 235 Product/Service ID Qualif ID S 2 2 C C2 VN Vendor's (Seller's) Item
IT1 1 9 1 234 Product/Service ID AN 1 48 C A0 VEDXIND/EDXINDR SBITEM Item No.
IT1 1 10 1 235 Product/Service ID Qualif ID S 2 2 C C2 PO Purchase Order Number
IT1 1 11 1 234 Product/Service ID AN 1 48 C A0 VEDXINS/EDXINSR GSCPO Customer P.O.
Loop level 2 Seg seq 060 Seg inst 1 Segment PID Product/Item Description
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
PID 1 1 1 349 Item Description Type ID S 1 1 M C1 F Free-form
PID 1 5 1 352 Description AN 1 80 C A0 VEDXIND/EDXINDR SBITD1 Description 1
Loop level 2 Seg seq 100 Seg inst 1 Segment PO4 Item Physical Details
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
PO4 1 1 1 356 Pack N0 1 6 O A0 VEDXIND/EDXINDR SBPKQTY Pack Quantity -PO401/356
PO4 1 14 1 810 Inner Pack N0 1 6 O A0 VEDXIND/EDXINDR SBPKINQ Inner Pack Qty -PO414/810
Loop level 2 Seg seq 180 Seg inst 1 Segment SAC Service, Promotion, Allowance, or Charge Information
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
SAC 1 1 1 248 Allowance or Charge Indic ID S 1 1 M A0 VEDXINDS/EDXINDR SBAC01 A/C SAC SAC01/248
SAC 1 2 1 1300 Service, Promotion, Allow ID S 4 4 C A0 VEDXINDS/EDXINDR SBAC02 SAC CODE /SAC02
SAC 1 5 1 610 Amount N2 1 15 M L A0 VEDXINDS/EDXINDR SBAC05 DOLLAR AMOUNT /SAC05
SAC 1 8 1 118 Rate R 1 9 O A0 VEDXINDS/EDXINDR SBAC08 Unit Disc. Amt. Rate /SAC
SAC 1 9 1 355 Unit or Basis for Measure ID S 2 2 C A0 VEDXIND/EDXINDR SBUM Unit of Measure
SAC 1 10 1 380 Quantity R 1 15 C A0 VEDXINDS/EDXINDR SBAC10 SAC Qty1 /SAC10
SAC 1 11 1 380 Quantity R 1 15 O
SAC 1 12 1 331 Allowance or Charge Metho ID S 2 2 O A0 VEDXINDS/EDXINDR SBAC12 Meth of Handling CD SAC12
SAC 1 15 1 352 Description AN 1 80 C A0 VEDXINDS/EDXINDR SBAC15 Description /SAC15
Message area . : 3. Third section
Loop level 1 Seg seq 010 Seg inst 1 Segment TDS Total Monetary Value Summary
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
TDS 1 1 1 610 Amount N2 1 15 M A0 VEDXINH/EDXINHR SAITOT Invoice Total
TDS 1 3 1 610 Amount N2 1 15 O A0 VEDXINH/EDXINHR SAIT10 Terms Discount Amt Due
TDS 1 4 1 610 Amount N2 1 15 O A0 VEDXINH/EDXINHR SAITD8 Terms Discount Amount
Loop level 1 Seg seq 040 Seg inst 1 Segment SAC Service, Promotion, Allowance, or Charge Information
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
SAC 1 1 1 248 Allowance or Charge Indic ID S 1 1 M A0 VEDXINA/EDXINAR SSAC01 A/C SAC SAC01/248
SAC 1 2 1 1300 Service, Promotion, Allow ID S 4 4 C A0 VEDXINA/EDXINAR SSAC02 SAC CODE /SAC02
SAC 1 5 1 610 Amount N2 1 15 M L A0 VEDXINA/EDXINAR SSAC05 DOLLAR AMOUNT /SAC05
SAC 1 8 1 118 Rate R 1 9 O A0 VEDXINA/EDXINAR SSAC08 Rate /SAC08
SAC 1 9 1 355 Unit or Basis for Measure ID S 2 2 C A0 VEDXINA/EDXINAR SSAC09 UOM /SAC09
SAC 1 10 1 380 Quantity R 1 15 C A0 VEDXINA/EDXINAR SSAC10 SAC Qty1 /SAC10
SAC 1 12 1 331 Allowance or Charge Metho ID S 2 2 O A0 VEDXINA/EDXINAR SSAC12 Meth of Handling CD /SAC
SAC 1 15 1 352 Description AN 1 80 C A0 VEDXINA/EDXINAR SSAC15 Description /SAC15
Loop level 1 Seg seq 070 Seg inst 1 Segment CTT Transaction Totals
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
CTT 1 1 1 354 Number of Line Items N0 1 6 M SC S01 Segment counter
CTT 1 2 1 347 Hash Total R 1 10 O A0 VEDXINS/EDXINSR GSTSHP Total Shipped
Loop level 1 Seg seq 080 Seg inst 1 Segment SE Transaction Set Trailer
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
SE 1 1 1 96 Number of Included Segmen N0 1 10 M S0 Special process
SE 1 2 1 329 Transaction Set Control N AN 4 9 M S0 Special process
** End of report **
