SeanHoppe.com ERP VAI/S2K Amazon.com Inbound 945 Field Mappings
CLEO Integrator Message class format fields SHOPPE QPADEV0004 4/26/15 8:04:58 Page 1
MMFPF3R
Message ID . . . . . . : 945 Message class : I945-3PL 3PL 945 WHSE SHIPPING ADVICE 4010
Message class status . : D Direction . . : R Receive
Standard class . . . . : X Industry group : X Version-release : 004010
Application file set . : VAI945R
File name Format K Field Seq Field text Typ Len Start Dgt Dec S/D Misc Sub Clr Trn Edit Qual Code table
Frml inst Formula Parm
VEDSWAP EDSWAPR SWAAD1 1 N301 - Address Line 1 A 30 176
VEDSWAP EDSWAPR SWAAD2 1 N301 - Address Line 2 A 30 206
VEDSWAP EDSWAPR SWAAD3 1 N301 - Address Line 3 A 30 236
VEDSWAP EDSWAPR SWAAD4 1 N301 - Address Line 4 A 30 266
VEDSWAP EDSWAPR SWACCTD 1 Creation Date S 8 374 8 0
VEDSWAP EDSWAPR SWACCTP 1 Creation PGM A 10 398
VEDSWAP EDSWAPR SWACCTT 1 Creation Time S 6 382 6 0
VEDSWAP EDSWAPR SWACCTU 1 Creation User A 10 388
VEDSWAP EDSWAPR SWACITY 1 N401 - City A 17 296
VEDSWAP EDSWAPR SWACMP 1 COMPANY # S 3 2 3 0
VEDSWAP EDSWAPR SWACTRY 1 N404 - Country Code A 3 330
VEDSWAP EDSWAPR SWACUST 1 CUSTOMER # A 7 15
VEDSWAP EDSWAPR SWADEL 1 Status Code A 1 1
VEDSWAP EDSWAPR SWAEDOC 1 ELECTRONIC DOC # A 10 5 M1
VEDSWAP EDSWAPR SWAEDPF 1 Processed-Y/N, Error-E A 1 373
VEDSWAP EDSWAPR SWAENNM 1 N102 - Entity Name A 30 64 D0
VEDSWAP EDSWAPR SWAENQL 1 N101 - Entity ID Code A 3 61 D0
VEDSWAP EDSWAPR SWAIDCD 1 N104 - ID Code A 20 96
VEDSWAP EDSWAPR SWAIDQL 1 N103 - ID Qualifier A 2 94
VEDSWAP EDSWAPR SWALCGD 1 Change Date S 8 408 8 0
VEDSWAP EDSWAPR SWALCGP 1 Change PGM A 10 432
VEDSWAP EDSWAPR SWALCGT 1 Change Time S 6 416 6 0
VEDSWAP EDSWAPR SWALCGU 1 Change User A 10 422
VEDSWAP EDSWAPR SWALNNO 1 Line Number S 4 22 4 0
VEDSWAP EDSWAPR SWANM1 1 N201 - Additional Name 1 A 30 116
VEDSWAP EDSWAPR SWANM2 1 N202 - Additional Name 2 A 30 146
VEDSWAP EDSWAPR SWAPRID 1 Trading Partner Id A 15 333 TP
VEDSWAP EDSWAPR SWAPRQL 1 Trading Partner QL A 25 348
VEDSWAP EDSWAPR SWAPTN 1 W0502 - Pick Ticket Nbr A 22 32 D0
VEDSWAP EDSWAPR SWAPTN 2 W0502 - Pick Ticket Nbr A 22 32 M5
VEDSWAP EDSWAPR SWASEQN 1 Sequence Number S 6 26 6 0
VEDSWAP EDSWAPR SWASHID 1 W0604 - Shipment ID S 7 54 7 0 D0
VEDSWAP EDSWAPR SWAST 1 N402 - State A 2 313
VEDSWAP EDSWAPR SWAZIP 1 N403 - Postal Code A 15 315
VEDSWHP EDSWHPR SWASID 1 W0605 - Agents Shipment I A 12 60 D0
VEDSWHP EDSWHPR SWDEPT 1 N902 - Department A 10 314
VEDSWHP EDSWHPR SWENNM 1 N102 - Entity Name A 30 441
VEDSWHP EDSWHPR SWFRT 1 G7208 - Freight Charges S 11 667 11 2
VEDSWHP EDSWHPR SWHAND 1 G7208 - Handling Charges S 11 678 11 2
VEDSWHP EDSWHPR SWHAPPT 1 N902 - Appointment Number A 30 234
VEDSWHP EDSWHPR SWHBOL 1 N902 - Bill of Lading A 30 94 D0
VEDSWHP EDSWHPR SWHCAC 1 W2702 - Carrier Code A 4 354 D0
VEDSWHP EDSWHPR SWHCAEC 1 W2705 - Carrier Equi Qual A 2 393
VEDSWHP EDSWHPR SWHCAEI 1 W2706 - Carrier Equi Init A 4 395
VEDSWHP EDSWHPR SWHCAEQ 1 W2707 - Carrier Equipment A 10 399
VEDSWHP EDSWHPR SWHCAN 1 W2703 - Carrier Name A 35 358 D0
VEDSWHP EDSWHPR SWHCAT 1 W2701 - Carrier Type A 2 352 D0
VEDSWHP EDSWHPR SWHCCTD 1 Creation Date S 8 599 8 0
VEDSWHP EDSWHPR SWHCCTP 1 Creation PGM A 10 623
EXTOL Integrator Message class format fields SHOPPE QPADEV0004 4/26/15 8:04:58 Page 2
MMFPF3R
File name Format K Field Seq Field text Typ Len Start Dgt Dec S/D Misc Sub Clr Trn Edit Qual Code table
Frml inst Formula Parm
VEDSWHP EDSWHPR SWHCCTT 1 Creation Time S 6 607 6 0
VEDSWHP EDSWHPR SWHCCTU 1 Creation User A 10 613
VEDSWHP EDSWHPR SWHCMP 1 COMPANY # S 3 2 3 0
VEDSWHP EDSWHPR SWHCUST 1 CUSTOMER # A 7 15
VEDSWHP EDSWHPR SWHDEL 1 STATUS CODE A 1 1
VEDSWHP EDSWHPR SWHDPDT 1 W0603 - Depositor Date S 8 45 8 0 D0
VEDSWHP EDSWHPR SWHEDDT 1 Transmission Date S 8 533 8 0 I6
VEDSWHP EDSWHPR SWHEDFT 1 Map Name A 10 588 M4
VEDSWHP EDSWHPR SWHEDGC 1 Group Control# A 10 558 G1
VEDSWHP EDSWHPR SWHEDIC 1 Interchange Control# A 10 548 I1
VEDSWHP EDSWHPR SWHEDOC 1 ELECTRONIC DOC # A 10 5 M1
VEDSWHP EDSWHPR SWHEDPF 1 Processed Flag A 1 598
VEDSWHP EDSWHPR SWHEDPT 1 Test/Production A 1 547 IH
VEDSWHP EDSWHPR SWHEDST 1 Document ID A 10 578 MC
VEDSWHP EDSWHPR SWHEDTC 1 Trans Control# A 10 568 D0
VEDSWHP EDSWHPR SWHEDTM 1 Transmission Time S 6 541 6 0 I7
VEDSWHP EDSWHPR SWHEDVD 1 G6202 - Estimated Delv Da S 8 324 8 0
VEDSWHP EDSWHPR SWHEDVT 1 G6204 - Estimated Delv Ti S 6 332 6 0
VEDSWHP EDSWHPR SWHENQL 1 N101 - Entity ID Code A 3 438
VEDSWHP EDSWHPR SWHIDCD 1 N104 - ID Code A 20 473
VEDSWHP EDSWHPR SWHIDQL 1 N103 - ID Qualifier A 2 471
VEDSWHP EDSWHPR SWHLCGD 1 Change Date S 8 633 8 0
VEDSWHP EDSWHPR SWHLCGP 1 Change PGM A 10 657
VEDSWHP EDSWHPR SWHLCGT 1 Change Time S 6 641 6 0
VEDSWHP EDSWHPR SWHLCGU 1 Change User A 10 647
VEDSWHP EDSWHPR SWHLOAD 1 N902 - Load Plan Number A 30 174 D0
VEDSWHP EDSWHPR SWHMANF 1 N902 - Manifest Number A 30 144 D0
VEDSWHP EDSWHPR SWHPO 1 W0606 - Purchase Order A 22 72 D0
VEDSWHP EDSWHPR SWHPRID 1 Trading Partner Id A 15 493 TP
VEDSWHP EDSWHPR SWHPRO 1 N902 - Pro Number A 20 124 D0
VEDSWHP EDSWHPR SWHPRO 2 N902 - Pro Number A 20 124 D0
VEDSWHP EDSWHPR SWHPRQL 1 Trading Partner QL A 25 508
VEDSWHP EDSWHPR SWHPTN 1 W0602 - Pick Ticket Nbr A 22 23 D0
VEDSWHP EDSWHPR SWHRC 1 W0601 - Report Code A 1 22 D0
VEDSWHP EDSWHPR SWHSHDT 1 G6202 - Shipped Date S 8 338 8 0 D0
VEDSWHP EDSWHPR SWHSHID 1 W0604 - Shipment ID S 7 53 7 0 D0
VEDSWHP EDSWHPR SWHSHID 2 W0604 - Shipment ID S 7 53 7 0 M6
VEDSWHP EDSWHPR SWHSHTM 1 G6204 - Shipped Time S 6 346 6 0 D0
VEDSWHP EDSWHPR SWHSMP 1 Ship Pay Meth W2704 A 2 713 D0
VEDSWHP EDSWHPR SWHSTRU 1 N902 - Structure Code A 30 264
VEDSWHP EDSWHPR SWHTLQT 1 Lading Qty W0306 S 7 706 7 0 D0
VEDSWHP EDSWHPR SWHTUNT 1 W0301 - Total Units S 7 409 7 0 D0
VEDSWHP EDSWHPR SWHTVOL 1 Tot Volume W0304 P 6 700 11 4 D0
VEDSWHP EDSWHPR SWHUBOL 1 N902 - UCC Bill of Lading A 30 204
VEDSWHP EDSWHPR SWHVEND 1 N902 - Vendor Number A 10 294
VEDSWHP EDSWHPR SWHVOLM 1 N0304 - Total Volume S 9 427 9 4
VEDSWHP EDSWHPR SWHVUM 1 W0305 - Total Volume UOM A 2 436 D0
VEDSWHP EDSWHPR SWHWGHT 1 W0302 - Total Weight S 9 416 9 4 D0
VEDSWHP EDSWHPR SWHWTUM 1 W0303 - Weight UOM A 2 425 D0
VEDSWHP EDSWHPR SWMISC 1 G7208 - Misc. Charges S 11 689 11 2
VEDSWHP EDSWHPR SWMRCOD 1 N902 - Merchandise Code A 10 304
VEDSWIP EDSWIPR SWIBCLR 1 N902 - Buyer Color A 30 228
VEDSWIP EDSWIPR SWIBSIZ 1 N902 - Buyer Size A 30 258
VEDSWIP EDSWIPR SWICCTD 1 Creation Date S 8 329 8 0
EXTOL Integrator Message class format fields SHOPPE QPADEV0004 4/26/15 8:04:58 Page 3
MMFPF3R
File name Format K Field Seq Field text Typ Len Start Dgt Dec S/D Misc Sub Clr Trn Edit Qual Code table
Frml inst Formula Parm
VEDSWIP EDSWIPR SWICCTP 1 Creation PGM A 10 353
VEDSWIP EDSWIPR SWICCTT 1 Creation Time S 6 337 6 0
VEDSWIP EDSWIPR SWICCTU 1 Creation User A 10 343
VEDSWIP EDSWIPR SWICMP 1 COMPANY # S 3 2 3 0
VEDSWIP EDSWIPR SWICUST 1 CUSTOMER # A 7 15
VEDSWIP EDSWIPR SWIDEL 1 Status Code A 1 1
VEDSWIP EDSWIPR SWIEDOC 1 ELECTRONIC DOC # A 10 5 M1
VEDSWIP EDSWIPR SWIEDPF 1 Processed-Y/N, Error-E A 1 328
VEDSWIP EDSWIPR SWILCGD 1 Change Date S 8 363 8 0
VEDSWIP EDSWIPR SWILCGP 1 Change PGM A 10 387
VEDSWIP EDSWIPR SWILCGT 1 Change Time S 6 371 6 0
VEDSWIP EDSWIPR SWILCGU 1 Change User A 10 377
VEDSWIP EDSWIPR SWILNNO 1 Line Number S 4 22 4 0 D0
VEDSWIP EDSWIPR SWIORQT 1 W1202 - Order Quantity S 7 63 7 0 D0
VEDSWIP EDSWIPR SWIPD01 1 W1208 - Product Desc 01 A 20 93 D0
VEDSWIP EDSWIPR SWIPD02 1 W1218 - Product Desc 02 A 20 126
VEDSWIP EDSWIPR SWIPD03 1 W1222 - Product Desc 03 A 20 148
VEDSWIP EDSWIPR SWIPOQ 1 Order Number N902 A 20 404 D0
VEDSWIP EDSWIPR SWIPQTD 1 Qty diff W1204 S 7 397 7 0 D0
VEDSWIP EDSWIPR SWIPQ01 1 W1207 - Product Qual 01 A 2 91 D0
VEDSWIP EDSWIPR SWIPQ02 1 W1217 - Product Qual 02 A 2 124
VEDSWIP EDSWIPR SWIPQ03 1 W1221 - Product Qual 03 A 2 146
VEDSWIP EDSWIPR SWIPRID 1 Trading Partner Id A 15 288 TP
VEDSWIP EDSWIPR SWIPRQL 1 Trading Partner QL A 25 303
VEDSWIP EDSWIPR SWIPTN 1 W0502 - Pick Ticket Nbr A 22 32 D0
VEDSWIP EDSWIPR SWIPTR 1 Trans Ref # N902 A 20 444 D0
VEDSWIP EDSWIPR SWIPX9 1 Int Cntrl # N902 A 20 424 D0
VEDSWIP EDSWIPR SWISEQN 1 Sequence Number S 6 26 6 0 D0
VEDSWIP EDSWIPR SWISHID 1 W0604 - Shipment ID S 7 54 7 0 D0
VEDSWIP EDSWIPR SWISHQT 1 W1203 - Ship Quantity S 7 70 7 0 D0
VEDSWIP EDSWIPR SWISHST 1 W1201 - Ship Status A 2 61 D0
VEDSWIP EDSWIPR SWISHUM 1 W1205 - Ship Quanity UOM A 2 77 D0
VEDSWIP EDSWIPR SWIUPCC 1 W1206 - UPC Case Code A 12 79 D0
VEDSWIP EDSWIPR SWIVCLR 1 N902 - Vendor Color A 30 168
VEDSWIP EDSWIPR SWIVSIZ 1 N902 - Vendor Size A 30 198
VEDSWIP EDSWIPR SWIWGHT 1 W1210 - Weight S 9 113 9 4 D0
VEDSWIP EDSWIPR SWIWTQL 1 W1211 - Weight Qualifier A 2 122 D0
VEDSWPP EDSWPPR SWPCCTD 1 Creation Date S 8 140 8 0
VEDSWPP EDSWPPR SWPCCTP 1 Creation PGM A 10 164
VEDSWPP EDSWPPR SWPCCTT 1 Creation Time S 6 148 6 0
VEDSWPP EDSWPPR SWPCCTU 1 Creation User A 10 154
VEDSWPP EDSWPPR SWPCMP 1 COMPANY # S 3 2 3 0
VEDSWPP EDSWPPR SWPCUST 1 CUSTOMER # A 7 15
VEDSWPP EDSWPPR SWPDEL 1 Status Code A 1 1
VEDSWPP EDSWPPR SWPEDOC 1 ELECTRONIC DOC # A 10 5 M1
VEDSWPP EDSWPPR SWPEDPF 1 Processed-Y/N, Error-E A 1 139
VEDSWPP EDSWPPR SWPLCGD 1 Change Date S 8 174 8 0
VEDSWPP EDSWPPR SWPLCGP 1 Change PGM A 10 198
VEDSWPP EDSWPPR SWPLCGT 1 Change Time S 6 182 6 0
VEDSWPP EDSWPPR SWPLCGU 1 Change User A 10 188
VEDSWPP EDSWPPR SWPLNNO 1 Line Number S 4 22 4 0 D0
VEDSWPP EDSWPPR SWPMN01 1 MAN02 - Mark Number 1 A 20 57 D0
VEDSWPP EDSWPPR SWPMN02 1 MAN02 - Mark Number 2 A 20 79
VEDSWPP EDSWPPR SWPMQ01 1 MAN01 - ID Qualifier 1 A 2 55 D0
EXTOL Integrator Message class format fields SHOPPE QPADEV0004 4/26/15 8:04:58 Page 4
MMFPF3R
File name Format K Field Seq Field text Typ Len Start Dgt Dec S/D Misc Sub Clr Trn Edit Qual Code table
Frml inst Formula Parm
VEDSWPP EDSWPPR SWPMQ02 1 MAN03 - ID Qualifier 2 A 2 77
VEDSWPP EDSWPPR SWPPRID 1 Trading Partner Id A 15 99 TP
VEDSWPP EDSWPPR SWPPRQL 1 Trading Partner QL A 25 114
VEDSWPP EDSWPPR SWPPTN 1 Pick Ticket Nbr A 22 26 D0
VEDSWPP EDSWPPR SWPSHID 1 W0604 - Shipment ID S 7 48 7 0 D0
** End of report **
