SeanHoppe.com > ERP > VAI/S2K > Amazon.com Outbound 810 > Element to Field Mappings

Cleo/VAI :: 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 **



By: on