SeanHoppe.com ERP VAI/S2K Amazon.com Inbound 945 Element to Field Mappings
CLEO Integrator Message class element map SHOPPE QPADEV0004 4/26/15 8:04:58 Page 1
Message class . : 945 I945-3PL *All elements
Message class . . . . . : 945 I945-3PL 3PL 945 WHSE SHIPPING ADVICE 4010 Status: D Direction code : R
Date/time created . . . : 7/20/11 11:31:28.40 Date/time last changed . . . : 4/23/15 09:12:30.73
Standard class . . . . : ASC X12 Standards Industry group . . : Full X12 standards VerRel : 004010
Application file set . : VAI945R VAI Inbound 945 Warehouse Shipping Advice 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
ST 1 2 1 329 Transaction Set Control N AN 4 9 M A0 VEDSWHP/EDSWHPR SWHEDTC Trans Control#
Loop level 1 Seg seq 020 Seg inst 1 Segment W06 Warehouse Shipment Identification
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W06 1 1 1 514 Reporting Code ID S 1 1 M A0 VEDSWHP/EDSWHPR SWHRC W0601 - Report Code
W06 1 2 1 285 Depositor Order Number AN 1 22 O A0 VEDSWHP/EDSWHPR SWHPTN W0602 - Pick Ticket Nbr
W06 1 2 2 285 Depositor Order Number AN 1 22 O A0 VEDSWAP/EDSWAPR SWAPTN W0502 - Pick Ticket Nbr
W06 1 2 3 285 Depositor Order Number AN 1 22 O A0 VEDSWIP/EDSWIPR SWIPTN W0502 - Pick Ticket Nbr
W06 1 2 4 285 Depositor Order Number AN 1 22 O A0 VEDSWPP/EDSWPPR SWPPTN Pick Ticket Nbr
W06 1 2 5 285 Depositor Order Number AN 1 22 O M5 Message log reference #1
W06 1 3 1 373 Date DT 8 8 O A0 VEDSWHP/EDSWHPR SWHDPDT W0603 - Depositor Date
W06 1 4 1 145 Shipment Identification N AN 1 30 O A0 VEDSWAP/EDSWAPR SWASHID W0604 - Shipment ID
W06 1 4 2 145 Shipment Identification N AN 1 30 O A0 VEDSWHP/EDSWHPR SWHSHID W0604 - Shipment ID
W06 1 4 3 145 Shipment Identification N AN 1 30 O A0 VEDSWIP/EDSWIPR SWISHID W0604 - Shipment ID
W06 1 4 4 145 Shipment Identification N AN 1 30 O A0 VEDSWPP/EDSWPPR SWPSHID W0604 - Shipment ID
W06 1 4 5 145 Shipment Identification N AN 1 30 O A0 VEDSWHP/EDSWHPR SWHLOAD N902 - Load Plan Number
W06 1 5 1 531 Agent Shipment ID Number AN 1 12 O A0 VEDSWHP/EDSWHPR SWASID W0605 - Agents Shipment I
W06 1 6 1 324 Purchase Order Number AN 1 22 O A0 VEDSWHP/EDSWHPR SWHPO W0606 - Purchase Order
W06 1 6 2 324 Purchase Order Number AN 1 22 O M6 Message log reference #2
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 VEDSWAP/EDSWAPR SWAENQL N101 - Entity ID Code
N1 1 2 1 93 Name AN 1 60 C A0 VEDSWAP/EDSWAPR SWAENNM N102 - Entity Name
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
N9 1 2 1 127 Reference Identification AN 1 30 C A0* VEDSWHP/EDSWHPR SWHBOL N902 - Bill of Lading
Qualified by BM = N9 -01
N9 1 2 2 127 Reference Identification AN 1 30 C A0* VEDSWHP/EDSWHPR SWHPRO N902 - Pro Number
Qualified by CN = N9 -01
EXTOL Integrator Message class element map SHOPPE QPADEV0004 4/26/15 8:04:58 Page 2
Message class . : 945 I945-3PL *All elements
N9 1 3 1 369 Free-form Description AN 1 45 C A0* VEDSWHP/EDSWHPR SWHPRO N902 - Pro Number
Qualified by CN = N9 -01
N9 1 3 2 369 Free-form Description AN 1 45 C A0* VEDSWHP/EDSWHPR SWHMANF N902 - Manifest Number
Qualified by CN = N9 -01
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
G62 1 2 1 373 Date DT 8 8 C A0* VEDSWHP/EDSWHPR SWHSHDT G6202 - Shipped Date
Qualified by 11 = G62-01
G62 1 3 1 176 Time Qualifier ID S 1 2 C
G62 1 4 1 337 Time TM 4 8 C A0 VEDSWHP/EDSWHPR SWHSHTM G6204 - Shipped Time
Loop level 1 Seg seq 130 Seg inst 1 Segment W27 Carrier Detail
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W27 1 1 1 91 Transportation Method/Typ ID S 1 2 M A0 VEDSWHP/EDSWHPR SWHCAT W2701 - Carrier Type
W27 1 2 1 140 Standard Carrier Alpha Co ID 2 4 C A0 VEDSWHP/EDSWHPR SWHCAC W2702 - Carrier Code
W27 1 3 1 387 Routing AN 1 35 C A0 VEDSWHP/EDSWHPR SWHCAN W2703 - Carrier Name
W27 1 4 1 146 Shipment Method of Paymen ID S 2 2 O A0 VEDSWHP/EDSWHPR SWHSMP Ship Pay Meth W2704
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 VEDSWPP/EDSWPPR SWPLNNO Line Number
LX 1 1 2 554 Assigned Number N0 1 6 M A0 VEDSWIP/EDSWIPR SWILNNO Line Number
Loop level 2 Seg seq 010 Seg inst 1 Segment MAN Marks and Numbers
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
MAN 1 1 1 88 Marks and Numbers Qualifi ID S 1 2 M A0 VEDSWPP/EDSWPPR SWPMQ01 MAN01 - ID Qualifier 1
MAN 1 2 1 87 Marks and Numbers AN 1 48 M A0 VEDSWPP/EDSWPPR SWPMN01 MAN02 - Mark Number 1
Loop level 2 Seg seq 020 Seg inst 1 Segment W12 Warehouse Item Detail
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W12 1 1 1 368 Shipment/Order Status Cod ID S 2 2 M A0 VEDSWIP/EDSWIPR SWISHST W1201 - Ship Status
W12 1 2 1 330 Quantity Ordered R 1 15 O A0 VEDSWIP/EDSWIPR SWIORQT W1202 - Order Quantity
W12 1 3 1 382 Number of Units Shipped R 1 10 O A0 VEDSWIP/EDSWIPR SWISHQT W1203 - Ship Quantity
W12 1 4 1 383 Quantity Difference R 1 9 O A0 VEDSWIP/EDSWIPR SWIPQTD Qty diff W1204
W12 1 5 1 355 Unit or Basis for Measure ID S 2 2 O A0 VEDSWIP/EDSWIPR SWISHUM W1205 - Ship Quanity UOM
W12 1 6 1 438 U.P.C. Case Code AN 12 12 C A0 VEDSWIP/EDSWIPR SWIUPCC W1206 - UPC Case Code
W12 1 7 1 235 Product/Service ID Qualif ID S 2 2 C A0 VEDSWIP/EDSWIPR SWIPQ01 W1207 - Product Qual 01
EXTOL Integrator Message class element map SHOPPE QPADEV0004 4/26/15 8:04:58 Page 3
Message class . : 945 I945-3PL *All elements
W12 1 8 1 234 Product/Service ID AN 1 48 C A0 VEDSWIP/EDSWIPR SWIPD01 W1208 - Product Desc 01
W12 1 10 1 81 Weight R 1 10 C A0 VEDSWIP/EDSWIPR SWIWGHT W1210 - Weight
W12 1 11 1 187 Weight Qualifier ID S 1 2 C A0 VEDSWIP/EDSWIPR SWIWTQL W1211 - Weight Qualifier
W12 1 12 1 188 Weight Unit Code ID S 1 1 C
Loop level 3 Seg seq 040 Seg inst 1 Segment N9 Reference Identification
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
N9 1 1 1 128 Reference Identification ID S 2 3 M
N9 1 2 1 127 Reference Identification AN 1 30 C A0* VEDSWIP/EDSWIPR SWIPOQ Order Number N902
Qualified by 0Q = N9 -01
N9 1 2 2 127 Reference Identification AN 1 30 C A0* VEDSWIP/EDSWIPR SWIPX9 Int Cntrl # N902
Qualified by X9 = N9 -01
N9 1 2 3 127 Reference Identification AN 1 30 C A0* VEDSWIP/EDSWIPR SWIPTR Trans Ref # N902
Qualified by TN = N9 -01
N9 1 2 4 127 Reference Identification N0 1 30 C L A0* VEDSWIP/EDSWIPR SWISEQN Sequence Number
Element SST start,len: 16 , 4
Qualified by X9 = N9 -01
Message area . : 3. Third section
Loop level 1 Seg seq 010 Seg inst 1 Segment W03 Total Shipment Information
Inst/Formula/Parm or
___ ___ ___ ___ ___ __ ____ ____ ___ ___ _ _ ___ ____________________ ___________________________
W03 1 1 1 382 Number of Units Shipped R 1 10 M A0 VEDSWHP/EDSWHPR SWHTUNT W0301 - Total Units
W03 1 2 1 81 Weight R 1 10 O A0 VEDSWHP/EDSWHPR SWHWGHT W0302 - Total Weight
W03 1 3 1 355 Unit or Basis for Measure ID S 2 2 C A0 VEDSWHP/EDSWHPR SWHWTUM W0303 - Weight UOM
W03 1 4 1 183 Volume R 1 8 C A0 VEDSWHP/EDSWHPR SWHTVOL Tot Volume W0304
W03 1 5 1 355 Unit or Basis for Measure ID S 2 2 C A0 VEDSWHP/EDSWHPR SWHVUM W0305 - Total Volume UOM
W03 1 6 1 80 Lading Quantity N0 1 7 C A0 VEDSWHP/EDSWHPR SWHTLQT Lading Qty W0306
W03 1 7 1 355 Unit or Basis for Measure ID S 2 2 C
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
SE 1 2 1 329 Transaction Set Control N AN 4 9 M
** End of report **
