SeanHoppe.com > ERP > VAI/S2K > Amazon.com Outbound 940 > Field Mappings

CLEO/VAI :: 3PL 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 **



By: on