SeanHoppe.com › ERP › VAI/S2K › Target.com Outbound 810 › 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 **