SeanHoppe.com ERP VAI/S2K Amazon.com Outbound 940 Element to Field Mappings
CLEO Integrator Message class element map SHOPPE QPADEV0004 4/26/15 7:58:46 Page 1
Message class . : 940 O940-3PL *All elements
Message class . . . . . : 940 O940-3PL 3PL - Outbound 940 Whse Shipping Order ver 4010 Status: D Direction code : S
Date/time created . . . : 12/15/11 11:55:55.77 Date/time last changed . . . : 4/23/15 09:07:36.52
Standard class . . . . : ASC X12 Standards Industry group . . : Full X12 standards VerRel : 004010
Application file set . : VAI940S VAI Outbound 940 Warehouse Shipping Order 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 N 4 9 M L S0 Special process
Loop level 1 Seg seq 020 Seg inst 1 Segment W05 Shipping Order Identification
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W05 1 1 1 473 Order Status Code ID S 1 1 M A0 VEDOWHP/EDOWOHR OHOSC W0501 - Order status code
W05 1 2 1 285 Depositor Order Number AN 1 22 M A0 VEDOWHP/EDOWOHR OHPTN W0502 - Pick ticket nbr
W05 1 3 1 324 Purchase Order Number AN 1 22 O A0 VEDOWHP/EDOWOHR OHPONO W0503 - Purchase Order
Loop level 1 Seg seq 040 Seg inst 1 Segment N1 Name
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N1 1 1 1 98 Entity Identifier Code ID S 2 3 M A0 VEDOWNP/EDOWONR ONENQL N101 - Entity ID Code
N1 1 2 1 93 Name AN 1 60 C A0 VEDOWNP/EDOWONR ONENAM N102 - Entity Name
N1 1 3 1 66 Identification Code Quali ID S 1 2 C A0 VEDOWNP/EDOWONR ONCMP COMPANY #
Code table: F EXT002 qual: C COMP
N1 1 3 2 66 Identification Code Quali ID S 1 2 C A0 VEDOWNP/EDOWONR ONIDCD N104 - ID Code
Code table: F EXT002 qual: C SHIPTO
N1 1 3 3 66 Identification Code Quali ID S 1 2 C A0 VEDOWNP/EDOWONR ONCUST CUSTOMER #
Code table: F EXT002 qual: C CUST
N1 1 3 4 66 Identification Code Quali ID S 1 2 C A0 VEDOWNP/EDOWONR ONENQL N101 - Entity ID Code
Code table: F EXT002 qual: C QUAL
N1 1 3 5 66 Identification Code Quali ID S 1 2 C A0 VEDOWNP/EDOWONR ONIDQL N103 - ID Qualifier
N1 1 4 1 67 Identification Code AN 2 80 C A0 VEDOWNP/EDOWONR ONIDCD N104 - ID Code
Code table: F EXT002 qual: C RETURN
Loop level 2 Seg seq 060 Seg inst 1 Segment N3 Address Information
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N3 1 1 1 166 Address Information AN 1 55 M A0 VEDOWNP/EDOWONR ONAD1 N301 - Address Line 1
N3 1 2 1 166 Address Information AN 1 55 O A0 VEDOWNP/EDOWONR ONAD2 N301 - Address Line 2
Loop level 2 Seg seq 070 Seg inst 1 Segment N4 Geographic Location
EXTOL Integrator Message class element map SHOPPE QPADEV0004 4/26/15 7:58:46 Page 2
Message class . : 940 O940-3PL *All elements
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N4 1 1 1 19 City Name AN 2 30 O A0 VEDOWNP/EDOWONR ONCITY N401 - City
N4 1 2 1 156 State or Province Code ID 2 2 O A0 VEDOWNP/EDOWONR ONST N402 - State
N4 1 3 1 116 Postal Code ID 3 15 O A0 VEDOWNP/EDOWONR ONZIP N403 - Postal Code
Loop level 1 Seg seq 090 Seg inst 1 Segment N9 Reference Identification
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N9 1 1 1 128 Reference Identification ID S 2 3 M A0 VEDOWHP/EDOWOHR OHREF25 N902 Reference ID
Code table: E EXQUAL2 qual: C ZZ
N9 1 2 1 127 Reference Identification AN 1 30 C A0 VEDOWHP/EDOWOHR OHREF25 N902 Reference ID
Loop level 1 Seg seq 090 Seg inst 2 Segment N9 Reference Identification
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N9 2 1 1 128 Reference Identification ID S 2 3 M A0 VEDOWHP/EDOWOHR OHREFST N902 Ship To
Code table: E EXQUAL2 qual: C LU
N9 2 2 1 127 Reference Identification AN 1 30 C A0 VEDOWHP/EDOWOHR OHREFST N902 Ship To
Loop level 1 Seg seq 090 Seg inst 3 Segment N9 Reference Identification
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N9 3 1 1 128 Reference Identification ID S 2 3 M A0 VEDOWHP/EDOWOHR OHDEPT N902 - Department
Code table: E EXQUAL2 qual: C DP
N9 3 2 1 127 Reference Identification AN 1 30 C A0 VEDOWHP/EDOWOHR OHDEPT N902 - Department
Loop level 1 Seg seq 110 Seg inst 1 Segment G62 Date/Time
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
G62 1 1 1 432 Date Qualifier ID S 2 2 C C2 10 Requested Ship Date/Pick-
G62 1 2 1 373 Date DT 8 8 M L A0 VEDOWHP/EDOWOHR OHRSDT G6202 - Request Ship Date
Loop level 1 Seg seq 110 Seg inst 2 Segment G62 Date/Time
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
G62 2 1 1 432 Date Qualifier ID S 2 2 C C2 01 Cancel After This Date
G62 2 2 1 373 Date DT 8 8 M L A0 VEDOWHP/EDOWOHR OHCNDT G6202 - Cancel After Date
Loop level 1 Seg seq 110 Seg inst 3 Segment G62 Date/Time
EXTOL Integrator Message class element map SHOPPE QPADEV0004 4/26/15 7:58:46 Page 3
Message class . : 940 O940-3PL *All elements
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
G62 3 1 1 432 Date Qualifier ID S 2 2 C C2 02 Delivery Requested on Thi
G62 3 2 1 373 Date DT 8 8 M L A0 VEDOWHP/EDOWOHR OHRDDT G6202 - Delivery Rqst Dat
Loop level 1 Seg seq 120 Seg inst 1 Segment NTE Note/Special Instruction
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
NTE 1 1 1 363 Note Reference Code ID S 3 3 O C3 WHI Warehouse Instruction
NTE 1 2 1 352 Description AN 1 80 M A0 VEDOWCP/EDOWOCR OCNTE2 NTE01 - Description
Loop level 1 Seg seq 140 Seg inst 1 Segment W66 Warehouse Carrier Information
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W66 1 1 1 146 Shipment Method of Paymen ID S 2 2 M C2 CC Collect
W66 1 2 1 91 Transportation Method/Typ ID S 1 2 M C1 M Motor (Common Carrier)
W66 1 5 1 387 Routing AN 1 35 O A0 VEDOWHP/EDOWOHR OHCAN SHIP VIA DESCRIPTION
Message area . : 2. Second section
Loop level 1 Seg seq 005 Seg inst 1 Segment LX Assigned Number
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
LX 1 1 1 554 Assigned Number N0 1 6 M A0 VEDOWIP/EDOWOIR OILNNO Line Number
Loop level 2 Seg seq 020 Seg inst 1 Segment W01 Line Item Detail - Warehouse
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W01 1 1 1 330 Quantity Ordered R 1 15 M A0 VEDOWIP/EDOWOIR OIORQT W0101 - Order Quantity
W01 1 2 1 355 Unit or Basis for Measure ID S 2 2 M A0 VEDOWIP/EDOWOIR OIORUM W0102 - Order Qty UOM
W01 1 3 1 438 U.P.C. Case Code AN 12 12 C A0 VEDOWIP/EDOWOIR OIUPC W0103 - UPC Case Code
W01 1 4 1 235 Product/Service ID Qualif ID S 2 2 C A0 VEDOWIP/EDOWOIR OIPD02 W0105 - Product Desc 2
Code table: E EXQUAL2 qual: C CB
W01 1 5 1 234 Product/Service ID AN 1 48 C A0 VEDOWIP/EDOWOIR OIPD02 W0105 - Product Desc 2
Loop level 3 Seg seq 030 Seg inst 1 Segment G69 Line Item Detail - Description
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
G69 1 1 1 369 Free-form Description AN 1 45 M A0 VEDOWIP/EDOWOIR OIIDESC G6901 - Item Description
Loop level 3 Seg seq 040 Seg inst 1 Segment N9 Reference Identification
EXTOL Integrator Message class element map SHOPPE QPADEV0004 4/26/15 7:58:46 Page 4
Message class . : 940 O940-3PL *All elements
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N9 1 1 1 128 Reference Identification ID S 2 3 M C2 X9 Internal Control Number
N9 1 2 1 127 Reference Identification AN 1 30 C A0 VEDOWIP/EDOWOIR OIICTL N902 - Internal Control #
Loop level 3 Seg seq 040 Seg inst 2 Segment N9 Reference Identification
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N9 2 1 1 128 Reference Identification ID S 2 3 M A0 VEDOWIP/EDOWOIR OIPD01 W0105 - Product Desc 1
Code table: E EXQUAL2 qual: C 0Q
N9 2 2 1 127 Reference Identification AN 1 30 C A0 VEDOWIP/EDOWOIR OIPD01 W0105 - Product Desc 1
Loop level 3 Seg seq 050 Seg inst 1 Segment W20 Line-Item Detail - Miscellaneous
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W20 1 1 1 356 Pack N0 1 6 O A0 VEDOWIP/EDOWOIR OIPACK W2001 - Pack
W20 1 3 1 355 Unit or Basis for Measure ID S 2 2 C A0 VEDOWIP/EDOWOIR OIQUOM W2003 - Unit of Measure
W20 1 4 1 81 Weight R 1 10 C A0 VEDOWIP/EDOWOIR OIIWGHT W2004 - Item Weight
W20 1 5 1 187 Weight Qualifier ID S 1 2 C C1 G Gross Weight
W20 1 6 1 188 Weight Unit Code ID S 1 1 C C1 L Pounds
W20 1 7 1 395 Unit Weight R 1 8 O A0 VEDOWIP/EDOWOIR OIXWGHT W2007 - Ext Item Weight
W20 1 8 1 183 Volume R 1 8 C A0 VEDOWIP/EDOWOIR OIXVOL W2008 - Ext Item Vol
W20 1 9 1 355 Unit or Basis for Measure ID S 2 2 C C2 CF Cubic Feet
Message area . : 3. Third section
Loop level 1 Seg seq 010 Seg inst 1 Segment W76 Total Shipping Order
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W76 1 1 1 330 Quantity Ordered R 1 15 M A0 VEDOWHP/EDOWOHR OHTUNT W7601 - Total Quantity
W76 1 2 1 81 Weight R 1 10 C A0 VEDOWHP/EDOWOHR OHWGHT W7602 - Weight
W76 1 3 1 355 Unit or Basis for Measure ID S 2 2 C C2 LB Pound
W76 1 4 1 183 Volume R 1 8 C A0 VEDOWHP/EDOWOHR OHVOL W7604 - Volume
W76 1 5 1 355 Unit or Basis for Measure ID S 2 2 C C2 CF Cubic Feet
Loop level 1 Seg seq 020 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 N 4 9 M L S0 Special process
** End of report **
