Field Mappings

EXTOL/VAI :: Target.com Outbound 856 - Field Mappings

  EXTOL Integrator                        Message class format fields           SHOPPE     QPADEV000R  4/30/15 13:10:05   Page     1
                                                                                                                          MMFPF3R
 Message ID . . . . . . :   856        Message class  :   O856_TRGT   Target.com (12345) 4010 ASN - SOIP
 Message class status . :   d          Direction  . . :   S  Send
 Standard class . . . . :   X          Industry group :   X           Version-release :   004010
 Application file set . :   VAI856S1
 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
 VEDXSHB    EDXSHBR      E3AFS        1 Application File Set/AFS/  A     10   140
 VEDXSHB    EDXSHBR      E3BOCD       1 Backorder Code             S      3    21   3   0
 VEDXSHB    EDXSHBR      E3BOX        1 EDI Box Number             S      4    24   4   0
 VEDXSHB    EDXSHBR      E3CMP        1 Company No.                S      3     9   3   0
 VEDXSHB    EDXSHBR      E3EDOC       1 Mailbox #/Message Log#     A     10   130
 VEDXSHB    EDXSHBR      E3EDPF       1 Processed Flag             A      1   150
 VEDXSHB    EDXSHBR      E3GWGH       1 Gross Weight               P      6    54  11   4
 VEDXSHB    EDXSHBR      E3LINE       1 Order Line                 S      4   151   4   0
 VEDXSHB    EDXSHBR      E3ORD        1 Customer Order #           S      9    12   9   0
 VEDXSHB    EDXSHBR      E3PRID       1 Trading Partner Id         A     15    90
 VEDXSHB    EDXSHBR      E3PRQL       1 Trading Partner QL         A     25   105
 VEDXSHB    EDXSHBR      E3SCTL       1 EDI Shipping Control       S      7     2   7   0
 VEDXSHB    EDXSHBR      E3SCTN       1 Serial Container #         A     20    28          D0
 VEDXSHB    EDXSHBR      E3STUS       1 Box Status                 A      1     1
 VEDXSHB    EDXSHBR      E3TRAC       1 Carrier Tracking Number    A     30    60
 VEDXSHB    EDXSHBR      E3WGHT       1 Net Box Weight             P      6    48  11   4
 VEDXSHD    EDXSHDR      E4AFS        1 Application File Set/AFS/  A     10   375
 VEDXSHD    EDXSHDR      E4BOCD       1 Backorder Code             S      3    25   3   0
 VEDXSHD    EDXSHDR      E4BOX        1 Box Number                 S      4    12   4   0
 VEDXSHD    EDXSHDR      E4CMP        1 Company No.                S      3     9   3   0
 VEDXSHD    EDXSHDR      E4COLR       1 EDI Buyer Color            A     30   171
 VEDXSHD    EDXSHDR      E4EDOC       1 Mailbox #/Message Log#     A     10   365
 VEDXSHD    EDXSHDR      E4EDPF       1 Processed Flag             A      1   385
 VEDXSHD    EDXSHDR      E4EPOLN      1 Customer PO Line #         S      9   299   9   0  D0
 VEDXSHD    EDXSHDR      E4GBIN       1 Global Trade Item#         A     30   269
 VEDXSHD    EDXSHDR      E4IPK        1 Inner Pack Qty             P      4   167   7   0
 VEDXSHD    EDXSHDR      E4ITD1       1 Description 1              A     30    52
 VEDXSHD    EDXSHDR      E4ITEM       1 Item No.                   A     20    32
 VEDXSHD    EDXSHDR      E4LINE       1 Order Line                 S      4    28   4   0
 VEDXSHD    EDXSHDR      E4MPK        1 Master Pack Qty            P      4   163   7   0
 VEDXSHD    EDXSHDR      E4ORD        1 Customer Order #           S      9    16   9   0
 VEDXSHD    EDXSHDR      E4OSTS       1 Order Status Code          A      2   161
 VEDXSHD    EDXSHDR      E4PKCD       1 Pack Code -PO404/103       A      5   314
 VEDXSHD    EDXSHDR      E4PKINQ      1 Inner Pack Qty -PO414/810  S      6   319   6   0
 VEDXSHD    EDXSHDR      E4PKQTY      1 Pack Quantity -PO401/356   S      6   263   6   0
 VEDXSHD    EDXSHDR      E4PKSZ       1 PK Unit Size UOM -PO403/3  A      2   261
 VEDXSHD    EDXSHDR      E4PKUSZ      1 Pack Unit Size -PO402/357  P      6   308  11   5
 VEDXSHD    EDXSHDR      E4PRIC       1 Net Price                  P      6    90  11   4
 VEDXSHD    EDXSHDR      E4PRID       1 Trading Partner Id         A     15   325
 VEDXSHD    EDXSHDR      E4PRQL       1 Trading Partner QL         A     25   340
 VEDXSHD    EDXSHDR      E4QORD       1 Quantity Ordered           P      5   156   9   2
 VEDXSHD    EDXSHDR      E4QSHP       1 Ship Quantity              P      5    82   9   2  D0
 VEDXSHD    EDXSHDR      E4SCTL       1 EDI Shipping Control       S      7     2   7   0
 VEDXSHD    EDXSHDR      E4SIZE       1 EDI Buyer Size             A     30   201
 VEDXSHD    EDXSHDR      E4SKU        1 EDI Buyer SKU#             A     30   126          D0
 VEDXSHD    EDXSHDR      E4STUS       1 Status                     A      1     1
 VEDXSHD    EDXSHDR      E4STYL       1 EDI Buyer Style            A     30   231
 VEDXSHD    EDXSHDR      E4UM         1 Unit of Measure            A      3    87          D0
 VEDXSHD    EDXSHDR      E4UPC        1 EDI UPC Code               A     30    96
 VEDXSHH    EDXSHHR      E0AFS        1 Application File Set/AFS/  A     10   225
 VEDXSHH    EDXSHHR      E0CCTD       1 Creation Date              S      8   246   8   0
 VEDXSHH    EDXSHHR      E0CCTP       1 Creation Pgm               A     10   270
 VEDXSHH    EDXSHHR      E0CCTT       1 Creation Time              S      6   254   6   0
 VEDXSHH    EDXSHHR      E0CCTU       1 Creation User              A     10   260
 VEDXSHH    EDXSHHR      E0CMP        1 Company No.                S      3     9   3   0
 VEDXSHH    EDXSHHR      E0CUST       1 Customer No.               A      7    12
 VEDXSHH    EDXSHHR      E0EDDT       1 Transmission Date          S      8   160   8   0
 VEDXSHH    EDXSHHR      E0EDFT       1 Translation Format         A     10   215
 VEDXSHH    EDXSHHR      E0EDGC       1 Group Control#             A     10   185
 VEDXSHH    EDXSHHR      E0EDIC       1 Interchange Control#       A     10   175
 VEDXSHH    EDXSHHR      E0EDOC       1 Mailbox #/Message Log#     A     10   150
 VEDXSHH    EDXSHHR      E0EDPF       1 Processed Flag             A      1   245
 VEDXSHH    EDXSHHR      E0EDPT       1 Test/Production            A      1   174
 VEDXSHH    EDXSHHR      E0EDST       1 Transaction Set 830/DELFO  A     10   205
 VEDXSHH    EDXSHHR      E0EDTC       1 Transaction Control#       A     10   195
 VEDXSHH    EDXSHHR      E0EDTM       1 Transmission Time          S      6   168   6   0  D0        S
 VEDXSHH    EDXSHHR      E0GRP        1 Transaction Set Group IN/  A     10   235
 VEDXSHH    EDXSHHR      E0GWGH       1 Gross Weight               P      7    76  13   4
 VEDXSHH    EDXSHHR      E0LCGD       1 Change Date                S      8   280   8   0
 VEDXSHH    EDXSHHR      E0LCGP       1 Change Pgm                 A     10   304
 VEDXSHH    EDXSHHR      E0LCGT       1 Change Time                S      6   288   6   0
 VEDXSHH    EDXSHHR      E0LCGU       1 Change User                A     10   294
 VEDXSHH    EDXSHHR      E0PCKS       1 Total Packages             P      5    71   9   0
 VEDXSHH    EDXSHHR      E0PRID       1 Trading Partner Id         A     15   110
 VEDXSHH    EDXSHHR      E0PRON       1 Pro Number                 A     15    21
 VEDXSHH    EDXSHHR      E0PRQL       1 Trading Partner QL         A     25   125
 VEDXSHH    EDXSHHR      E0PTNR       1 EDI Trading Partner ID     A      9    93
 VEDXSHH    EDXSHHR      E0SCAC       1 EDI Ship Via /Carrier Des  A     35    36
 VEDXSHH    EDXSHHR      E0SCTL       1 EDI Shipping Control       S      7     2   7   0  D0
 VEDXSHH    EDXSHHR      E0STUS       1 Shipping Status            A      1     1
 VEDXSHH    EDXSHHR      E0TRDT       1 Transm Date- YMD           S      6    83   6   0
 VEDXSHH    EDXSHHR      E0TRD8       1 Transm Date- CYMD          S      8   102   8   0  D0
 VEDXSHH    EDXSHHR      E0TRTM       1 Transm Time- HM            S      4    89   4   0
 VEDXSHH    EDXSHHR      E0TYPE       1 00=Orig, 07= Dupl          A      2    19
 VEDXSHO    EDXSHOR      E2AFS        1 Application File Set/AFS/  A     10   413
 VEDXSHO    EDXSHOR      E2BOCD       1 Backorder Code             S      3    21   3   0
 VEDXSHO    EDXSHOR      E2BOL        1 Bill of Lading Number      A     30   165
 VEDXSHO    EDXSHOR      E2CLOC       1 Consolidated Location      A      7    61
 VEDXSHO    EDXSHOR      E2CLOE       1 Consolidator               A     17   287
 VEDXSHO    EDXSHOR      E2CMP        1 Company No.                S      3     9   3   0
 VEDXSHO    EDXSHOR      E2CPO        1 Customer P.O.              A     20    68          D0
 VEDXSHO    EDXSHOR      E2CUST       1 Customer No.               A      7    33
 VEDXSHO    EDXSHOR      E2DEPT       1 EDI Department             A      9   115
 VEDXSHO    EDXSHOR      E2DSTC       1 Distribution Center        A      7    47
 VEDXSHO    EDXSHOR      E2DSTE       1 Distribution Center        A     17   253
 VEDXSHO    EDXSHOR      E2EDOC       1 Mailbox #/Message Log#     A     10   403
 VEDXSHO    EDXSHOR      E2EDPF       1 Processed Flag             A      1   423
 VEDXSHO    EDXSHOR      E2FRT        1 Freight Charges            P      6   139  11   2
 VEDXSHO    EDXSHOR      E2GLNT       1 Global Location Nbr        A     17   316
 VEDXSHO    EDXSHOR      E2GWGH       1 Gross Weight               P      7    99  13   4
 VEDXSHO    EDXSHOR      E2HAND       1 Handling Charges           P      6   145  11   2
 VEDXSHO    EDXSHOR      E2INV        1 Invoice No.                S      9    24   9   0
 VEDXSHO    EDXSHOR      E2ITOT       1 Invoice Total              P      6   133  11   2
 VEDXSHO    EDXSHOR      E2MISC       1 Misc Charges               P      6   151  11   2
 VEDXSHO    EDXSHOR      E2ORD        1 Customer Order #           S      9    12   9   0
 VEDXSHO    EDXSHOR      E2ORSTS      1 Order Status               A      2   314
 VEDXSHO    EDXSHOR      E2PCKS       1 Total Packages             P      4   106   7   0
 VEDXSHO    EDXSHOR      E2PKCD       1 EDI Packaging Code         A      5   110
 VEDXSHO    EDXSHOR      E2POD2       1 CC PO Date                 S      2   304   2   0
 VEDXSHO    EDXSHOR      E2POD8       1 CYMD PO Date               S      8   306   8   0
 VEDXSHO    EDXSHOR      E2POYM       1 YMD PO Date                S      6   230   6   0
 VEDXSHO    EDXSHOR      E2PRID       1 Trading Partner Id         A     15   363
 VEDXSHO    EDXSHOR      E2PRQL       1 Trading Partner QL         A     25   378
 VEDXSHO    EDXSHOR      E2RLNO       1 EDI Release Number         A      9   124
 VEDXSHO    EDXSHOR      E2SCTL       1 EDI Shipping Control       S      7     2   7   0
 VEDXSHO    EDXSHOR      E2SDAT       1 Ship Date                  S      8   157   8   0
 VEDXSHO    EDXSHOR      E2SHIP       1 SHIP TO CODE               A      7    40
 VEDXSHO    EDXSHOR      E2SHPE       1 Ship To Store              A     17   236
 VEDXSHO    EDXSHOR      E2SHTE       1 EDI Ship To Location       A     17   270
 VEDXSHO    EDXSHOR      E2SHTO       1 Ship Location              A      7    54
 VEDXSHO    EDXSHOR      E2SQTY       1 Total Ship Qty             P      5   225   9   2
 VEDXSHO    EDXSHOR      E2STUS       1 Status                     A      1     1
 VEDXSHO    EDXSHOR      E2TCRT       1 Total Cartons              P      4    88   7   0
 VEDXSHO    EDXSHOR      E2VND        1 Supplier No                A     30   195
 VEDXSHO    EDXSHOR      E2VND2       1 Buyer Vendor NBR2          A     30   333
 VEDXSHO    EDXSHOR      E2WGHT       1 Net Weight                 P      7    92  13   4
 VEDXSHS    EDXSHSR      E1AFS        1 Application File Set/AFS/  A     10   421
 VEDXSHS    EDXSHSR      E1BOL        1 Bill of Lading Number      A     30   168
 VEDXSHS    EDXSHSR      E1CITY       1 Ship to City               A     17   116
 VEDXSHS    EDXSHSR      E1CMP        1 Company No.                S      3     9   3   0
 VEDXSHS    EDXSHSR      E1CUST       1 Customer No.               A      7    12
 VEDXSHS    EDXSHSR      E1EDOC       1 Mailbox #/Message Log#     A     10   411
 VEDXSHS    EDXSHSR      E1EDPF       1 Processed Flag             A      1   431
 VEDXSHS    EDXSHSR      E1EDT2       1 Est. Del. CC               S      2   318   2   0
 VEDXSHS    EDXSHSR      E1EDT6       1 Est. Del. YYMMDD           S      6   312   6   0
 VEDXSHS    EDXSHSR      E1EDT8       1 Est. Del. Date             S      8   304   8   0
 VEDXSHS    EDXSHSR      E1FOB1       1 Payment Method             A      2   290
 VEDXSHS    EDXSHSR      E1GLNT       1 Global  Location Nbr       A     17   324
 VEDXSHS    EDXSHSR      E1GWGH       1 Gross Weight               P      7   260  13   4
 VEDXSHS    EDXSHSR      E1LOAD       1 Load Number                A     50   432
 VEDXSHS    EDXSHSR      E1PCKS       1 Total Packages             P      5   255   9   0
 VEDXSHS    EDXSHSR      E1PKCD       1 EDI Transportation Method  A      2   322
 VEDXSHS    EDXSHSR      E1PRID       1 Trading Partner Id         A     15   371
 VEDXSHS    EDXSHSR      E1PRON       1 Pro Number                 A     15   198
 VEDXSHS    EDXSHSR      E1PRQL       1 Trading Partner QL         A     25   386
 VEDXSHS    EDXSHSR      E1SAD1       1 Ship to Address 1          A     30    56
 VEDXSHS    EDXSHSR      E1SAD2       1 Ship to Address 2          A     30    86
 VEDXSHS    EDXSHSR      E1SAD3       1 Ship to Address 3          A     30   512
 VEDXSHS    EDXSHSR      E1SCAC       1 ROUTING DESCRIPTION        A     35   213
 VEDXSHS    EDXSHSR      E1SCTL       1 EDI Shipping Control       S      7     2   7   0
 VEDXSHS    EDXSHSR      E1SDAT       1 Ship Date                  S      8   150   8   0  D0
 VEDXSHS    EDXSHSR      E1SDCC       1 Ship Date- CC              S      2   302   2   0
 VEDXSHS    EDXSHSR      E1SHTE       1 EDI Ship-To                A     17   273
 VEDXSHS    EDXSHSR      E1SHTO       1 Ship To Number             A      7    19
 VEDXSHS    EDXSHSR      E1SNAM       1 Ship to Name               A     30    26
 VEDXSHS    EDXSHSR      E1ST         1 Ship to State              A      2   133
 VEDXSHS    EDXSHSR      E1STUS       1 Shipping Status            A      1     1
 VEDXSHS    EDXSHSR      E1SYMD       1 Ship Date YMD              S      6   267   6   0
 VEDXSHS    EDXSHSR      E1TIME       1 Ship Time                  S      6   158   6   0
 VEDXSHS    EDXSHSR      E1TLID       1 EDI Trailer ID             A     10   292
 VEDXSHS    EDXSHSR      E1TMTH       1 EDI Transportation Method  A      2   320
 VEDXSHS    EDXSHSR      E1TRACK      1 Tracking/Pro #             A     30   482
 VEDXSHS    EDXSHSR      E1VIA        1 CARRIER ID/SCAC            A      4   164          D0
 VEDXSHS    EDXSHSR      E1VND2       1 Buyer Vendor NBR2          A     30   341
 VEDXSHS    EDXSHSR      E1WGHT       1 Net Weight                 P      7   248  13   4
 VEDXSHS    EDXSHSR      E1ZIP        1 Ship to Zip Code           A     15   135
 ** End of report **



By: on