SeanHoppe.com ERP VAI/S2K Amazon.com Outbound 940 Field Mappings
CLEO Integrator Message class format fields SHOPPE QPADEV0004 4/26/15 7:58:48 Page 1
MMFPF3R
Message ID . . . . . . : 940 Message class : O940-3PL 3PL - Outbound 940 Whse Shipping Order ver 4010
Message class status . : D Direction . . : S Send
Standard class . . . . : X Industry group : X Version-release : 004010
Application file set . : VAI940S
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
VEDOWCP EDOWOCR OCAFS 1 Application File Set/AFS/ A 10 174
VEDOWCP EDOWOCR OCCCTD 1 CREATION DATE S 8 185 8 0
VEDOWCP EDOWOCR OCCCTP 1 CREATION PGM A 10 209
VEDOWCP EDOWOCR OCCCTT 1 CREATION TIME S 6 193 6 0
VEDOWCP EDOWOCR OCCCTU 1 CREATION USER A 10 199
VEDOWCP EDOWOCR OCCMP 1 COMPANY # S 3 2 3 0
VEDOWCP EDOWOCR OCCUST 1 CUSTOMER # A 7 15
VEDOWCP EDOWOCR OCDEL 1 Status Code A 1 1
VEDOWCP EDOWOCR OCEDOC 1 ELECTRONIC DOC # A 10 5
VEDOWCP EDOWOCR OCEDPF 1 Processed Flag A 1 184
VEDOWCP EDOWOCR OCLCGD 1 CHANGE DATE S 8 219 8 0
VEDOWCP EDOWOCR OCLCGP 1 CHANGE PGM A 10 243
VEDOWCP EDOWOCR OCLCGT 1 CHANGE TIME S 6 227 6 0
VEDOWCP EDOWOCR OCLCGU 1 CHANGE USER A 10 233
VEDOWCP EDOWOCR OCNTE1 1 NTE01 - Ref Code A 3 51
VEDOWCP EDOWOCR OCNTE2 1 NTE01 - Description A 80 54 D0
VEDOWCP EDOWOCR OCPRID 1 Trading Partner Id A 15 134
VEDOWCP EDOWOCR OCPRQL 1 Trading Partner QL A 25 149
VEDOWCP EDOWOCR OCPTN 1 W0502 - Pick Ticket Nbr A 22 22
VEDOWCP EDOWOCR OCSEQ 1 Seq Number S 7 44 7 0
VEDOWHP EDOWOHR OHAFS 1 App File Set A 10 337
VEDOWHP EDOWOHR OHASPO 1 N902 - Associated PO A 10 107
VEDOWHP EDOWOHR OHCAC 1 SHIP VIA CODE A 4 426
VEDOWHP EDOWOHR OHCAN 1 SHIP VIA DESCRIPTION A 35 430 D0
VEDOWHP EDOWOHR OHCCTD 1 Creation Date S 8 358 8 0
VEDOWHP EDOWOHR OHCCTP 1 Creation PGM A 10 382
VEDOWHP EDOWOHR OHCCTT 1 Creation Time S 6 366 6 0
VEDOWHP EDOWOHR OHCCTU 1 Creation User A 10 372
VEDOWHP EDOWOHR OHCMP 1 COMPANY # S 3 2 3 0
VEDOWHP EDOWOHR OHCNDT 1 G6202 - Cancel After Date S 8 141 8 0 D0
VEDOWHP EDOWOHR OHCNTM 1 G6204 - Cancel After Time S 6 149 6 0
VEDOWHP EDOWOHR OHCUST 1 CUSTOMER # A 7 15
VEDOWHP EDOWOHR OHDEL 1 Status Code A 1 1
VEDOWHP EDOWOHR OHDEPT 1 N902 - Department A 10 67 D0
VEDOWHP EDOWOHR OHDEPT 2 N902 - Department A 10 67 D0 O C EXQUAL2
VEDOWHP EDOWOHR OHDRTM 1 G6204 - Delivery Rqst Tim S 6 163 6 0
VEDOWHP EDOWOHR OHEDDT 1 Transmission Date S 8 272 8 0
VEDOWHP EDOWOHR OHEDFT 1 Map Name A 10 327
VEDOWHP EDOWOHR OHEDGC 1 Group Control# A 10 297
VEDOWHP EDOWOHR OHEDIC 1 Interchange Control# A 10 287
VEDOWHP EDOWOHR OHEDOC 1 ELECTRONIC DOC # A 10 5
VEDOWHP EDOWOHR OHEDPF 1 Processed Flag A 1 357
VEDOWHP EDOWOHR OHEDPT 1 Test/Production A 1 286
VEDOWHP EDOWOHR OHEDST 1 Document ID A 10 317
VEDOWHP EDOWOHR OHEDTC 1 Trans Control# A 10 307
VEDOWHP EDOWOHR OHEDTM 1 Transmission Time S 6 280 6 0
VEDOWHP EDOWOHR OHGRP 1 Document Group A 10 347
VEDOWHP EDOWOHR OHINV 1 N902 - Invoice Number A 10 117
VEDOWHP EDOWOHR OHIVND 1 N902 - Internal Vendor A 10 97
EXTOL Integrator Message class format fields SHOPPE QPADEV0004 4/26/15 7:58:48 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
VEDOWHP EDOWOHR OHLCGD 1 Change Date S 8 392 8 0
VEDOWHP EDOWOHR OHLCGP 1 Change PGM A 10 416
VEDOWHP EDOWOHR OHLCGT 1 Change Time S 6 400 6 0
VEDOWHP EDOWOHR OHLCGU 1 Change User A 10 406
VEDOWHP EDOWOHR OHLOC 1 N902 - Inventory Location A 4 137
VEDOWHP EDOWOHR OHMADT 1 G6202 - Must Arr By Date S 8 211 8 0
VEDOWHP EDOWOHR OHMATM 1 G6204 - Must Arr By Time S 6 219 6 0
VEDOWHP EDOWOHR OHMRTP 1 N902 - Merchandise Type A 10 77
VEDOWHP EDOWOHR OHOSC 1 W0501 - Order status code A 1 22 D0
VEDOWHP EDOWOHR OHPOEV 1 N902 - PO Event A 10 87
VEDOWHP EDOWOHR OHPONO 1 W0503 - Purchase Order A 22 45 D0
VEDOWHP EDOWOHR OHPRID 1 Trading Partner Id A 15 232
VEDOWHP EDOWOHR OHPRQL 1 Trading Partner QL A 25 247
VEDOWHP EDOWOHR OHPTN 1 W0502 - Pick ticket nbr A 22 23 D0
VEDOWHP EDOWOHR OHRDDT 1 G6202 - Delivery Rqst Dat S 8 155 8 0 D0
VEDOWHP EDOWOHR OHREFST 1 N902 Ship To A 17 495 D0
VEDOWHP EDOWOHR OHREFST 2 N902 Ship To A 17 495 D0 O C EXQUAL2
VEDOWHP EDOWOHR OHREF25 1 N902 Reference ID A 30 465 D0
VEDOWHP EDOWOHR OHREF25 2 N902 Reference ID A 30 465 D0 O C EXQUAL2
VEDOWHP EDOWOHR OHRSDT 1 G6202 - Request Ship Date S 8 169 8 0 D0
VEDOWHP EDOWOHR OHRSTM 1 G6204 - Request Ship Time S 6 177 6 0
VEDOWHP EDOWOHR OHSBDT 1 G6202 - Ship Not B4 Date S 8 183 8 0
VEDOWHP EDOWOHR OHSBTM 1 G6204 - Ship Not B4 Time S 6 191 6 0
VEDOWHP EDOWOHR OHSLDT 1 G6202 - Ship Not Ltr Date S 8 197 8 0
VEDOWHP EDOWOHR OHSLTM 1 G6204 - Ship Not Ltr Time S 6 205 6 0
VEDOWHP EDOWOHR OHSTRU 1 N902 - Structure Code A 10 127
VEDOWHP EDOWOHR OHTUNT 1 W7601 - Total Quantity S 7 225 7 0 D0
VEDOWHP EDOWOHR OHVOL 1 W7604 - Volume P 6 518 11 4 D0
VEDOWHP EDOWOHR OHWGHT 1 W7602 - Weight P 6 512 11 4 D0
VEDOWIP EDOWOIR OIAFS 1 App File Set A 10 317
VEDOWIP EDOWOIR OIBCLR 1 N902 - Buyer Color A 30 217
VEDOWIP EDOWOIR OIBSIZ 1 N902 - Buyer Size A 30 247
VEDOWIP EDOWOIR OICCTD 1 Creation Date S 8 328 8 0
VEDOWIP EDOWOIR OICCTP 1 Creation PGM A 10 352
VEDOWIP EDOWOIR OICCTT 1 Creation Time S 6 336 6 0
VEDOWIP EDOWOIR OICCTU 1 Creation User A 10 342
VEDOWIP EDOWOIR OICMP 1 COMPANY # S 3 2 3 0
VEDOWIP EDOWOIR OICUST 1 CUSTOMER # A 7 15
VEDOWIP EDOWOIR OIDEL 1 Status Code A 1 1
VEDOWIP EDOWOIR OIEDOC 1 ELECTRONIC DOC # A 10 5
VEDOWIP EDOWOIR OIEDPF 1 Processed-Y/N, Error-E A 1 327
VEDOWIP EDOWOIR OIICTL 1 N902 - Internal Control # A 25 426 D0
VEDOWIP EDOWOIR OIIDESC 1 G6901 - Item Description A 30 396 D0
VEDOWIP EDOWOIR OIIWGHT 1 W2004 - Item Weight P 6 451 11 4 D0
VEDOWIP EDOWOIR OILCGD 1 Change Date S 8 362 8 0
VEDOWIP EDOWOIR OILCGP 1 Change PGM A 10 386
VEDOWIP EDOWOIR OILCGT 1 Change Time S 6 370 6 0
VEDOWIP EDOWOIR OILCGU 1 Change User A 10 376
VEDOWIP EDOWOIR OILNNO 1 Line Number S 4 22 4 0 D0
VEDOWIP EDOWOIR OIORQT 1 W0101 - Order Quantity S 7 54 7 0 D0
VEDOWIP EDOWOIR OIORUM 1 W0102 - Order Qty UOM A 2 61 D0
VEDOWIP EDOWOIR OIPACK 1 W2001 - Pack S 6 141 6 0 D0
VEDOWIP EDOWOIR OIPD01 1 W0105 - Product Desc 1 A 20 77 D0 O C EXQUAL2
VEDOWIP EDOWOIR OIPD01 2 W0105 - Product Desc 1 A 20 77 D0
EXTOL Integrator Message class format fields SHOPPE QPADEV0004 4/26/15 7:58:48 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
VEDOWIP EDOWOIR OIPD02 1 W0105 - Product Desc 2 A 20 99 D0
VEDOWIP EDOWOIR OIPD02 2 W0105 - Product Desc 2 A 20 99 D0 O C EXQUAL2
VEDOWIP EDOWOIR OIPD03 1 W0105 - Product Desc 3 A 20 121
VEDOWIP EDOWOIR OIPQ01 1 W0104 - Product Qual 1 A 2 75
VEDOWIP EDOWOIR OIPQ02 1 W0104 - Product Qual 2 A 2 97
VEDOWIP EDOWOIR OIPQ03 1 W0104 - Product Qual 3 A 2 119
VEDOWIP EDOWOIR OIPRID 1 Trading Partner Id A 15 277
VEDOWIP EDOWOIR OIPRQL 1 Trading Partner QL A 25 292
VEDOWIP EDOWOIR OIPTN 1 W0502 - Pick Ticket Nbr A 22 32
VEDOWIP EDOWOIR OIQUOM 1 W2003 - Unit of Measure A 2 155 D0
VEDOWIP EDOWOIR OISEQN 1 Sequence Number S 6 26 6 0
VEDOWIP EDOWOIR OISIZE 1 W2002 - Size S 8 147 8 0
VEDOWIP EDOWOIR OIUPC 1 W0103 - UPC Case Code A 12 63 D0
VEDOWIP EDOWOIR OIVCLR 1 N902 - Vendor Color A 30 157
VEDOWIP EDOWOIR OIVSIZ 1 N902 - Vendor Size A 30 187
VEDOWIP EDOWOIR OIXVOL 1 W2008 - Ext Item Vol P 6 463 11 4 D0
VEDOWIP EDOWOIR OIXWGHT 1 W2007 - Ext Item Weight P 6 457 11 4 D0
VEDOWNP EDOWONR ONAD1 1 N301 - Address Line 1 A 30 169 D0
VEDOWNP EDOWONR ONAD2 1 N301 - Address Line 2 A 30 199 D0
VEDOWNP EDOWONR ONAD3 1 N301 - Address Line 3 A 30 229
VEDOWNP EDOWONR ONAD4 1 N301 - Address Line 4 A 30 259
VEDOWNP EDOWONR ONAFS 1 App File Set A 10 366
VEDOWNP EDOWONR ONCCTD 1 Creation Date S 8 377 8 0
VEDOWNP EDOWONR ONCCTP 1 Creation PGM A 10 401
VEDOWNP EDOWONR ONCCTT 1 Creation Time S 6 385 6 0
VEDOWNP EDOWONR ONCCTU 1 Creation User A 10 391
VEDOWNP EDOWONR ONCITY 1 N401 - City A 17 289 D0
VEDOWNP EDOWONR ONCMP 1 COMPANY # S 3 2 3 0
VEDOWNP EDOWONR ONCMP 2 COMPANY # S 3 2 3 0 D0 O C EXT002
VEDOWNP EDOWONR ONCTRY 1 N404 - Country Code A 3 323
VEDOWNP EDOWONR ONCUST 1 CUSTOMER # A 7 15
VEDOWNP EDOWONR ONCUST 3 CUSTOMER # A 7 15 D0 O C EXT002
VEDOWNP EDOWONR ONDEL 1 Status Code A 1 1
VEDOWNP EDOWONR ONEDOC 1 ELECTRONIC DOC # A 10 5
VEDOWNP EDOWONR ONEDPF 1 Processed-Y/N, Error-E A 1 376
VEDOWNP EDOWONR ONENAM 1 N102 - Entity Name A 30 57 D0
VEDOWNP EDOWONR ONENQL 1 N101 - Entity ID Code A 3 54 D0
VEDOWNP EDOWONR ONENQL 2 N101 - Entity ID Code A 3 54 D0 O C EXT002
VEDOWNP EDOWONR ONIDCD 1 N104 - ID Code A 20 89 D0 O C EXT002
VEDOWNP EDOWONR ONIDCD 3 N104 - ID Code A 20 89 D0 O C EXT002
VEDOWNP EDOWONR ONIDQL 1 N103 - ID Qualifier A 2 87 D0
VEDOWNP EDOWONR ONLCGD 1 Change Date S 8 411 8 0
VEDOWNP EDOWONR ONLCGP 1 Change PGM A 10 435
VEDOWNP EDOWONR ONLCGT 1 Change Time S 6 419 6 0
VEDOWNP EDOWONR ONLCGU 1 Change User A 10 425
VEDOWNP EDOWONR ONLNNO 1 Line Number S 4 22 4 0
VEDOWNP EDOWONR ONNM1 1 N201 - Additional Name 1 A 30 109
VEDOWNP EDOWONR ONNM2 1 N202 - Additional Name 2 A 30 139
VEDOWNP EDOWONR ONPRID 1 Trading Partner Id A 15 326
VEDOWNP EDOWONR ONPRQL 1 Trading Partner QL A 25 341
VEDOWNP EDOWONR ONPTN 1 W0502 - Pick Ticket Nbr A 22 32
VEDOWNP EDOWONR ONSEQN 1 Sequence Number S 6 26 6 0
VEDOWNP EDOWONR ONST 1 N402 - State A 2 306 D0
VEDOWNP EDOWONR ONZIP 1 N403 - Postal Code A 15 308 D0
EXTOL Integrator Message class format fields SHOPPE QPADEV0004 4/26/15 7:58:48 Page 4
MMFPF3R
** End of report **
