SeanHoppe.com ERP VAI/S2K Amazon.com Outbound 846 Field Mappings
CLEO Integrator Message class format fields SHOPPE QPADEV0004 4/25/15 16:23:31 Page 1
MMFPF3R
Message ID . . . . . . : 846 Message class : O846-AMZN AMAZON INVENTORY INQ/ADVICE 4010 IB
Message class status . : D Direction . . : S Send
Standard class . . . . : X Industry group : X Version-release : 004010
Application file set . : VAI846S
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
VCPCSCD6 COCSCDR OKCCTD 1 Creation Date S 8 95 8 0
VCPCSCD6 COCSCDR OKCCTT 1 Creation Time S 6 103 6 0
VCPCSCD6 COCSCDR OKCCTU 1 Creation User A 10 109
VCPCSCD6 COCSCDR OKCMP 1 Company No. S 3 2 3 0
VCPCSCD6 COCSCDR OKCRCD 1 Currency Code A 3 143
VCPCSCD6 COCSCDR K OKCUST 1 Customer No. A 7 12 FD K K
VCPCSCD6 COCSCDR OKDEL 1 Delete Code A 1 1
VCPCSCD6 COCSCDR OKDISC 1 Discount Rate P 2 76 3 3
VCPCSCD6 COCSCDR OKFDTE 1 From Date S 8 26 8 0
VCPCSCD6 COCSCDR K OKITEM 1 Item No. A 20 42 FD
VCPCSCD6 COCSCDR OKLAO 1 Markup on L/A/O A 1 86
VCPCSCD6 COCSCDR OKLCGD 1 Last Change Date S 8 119 8 0
VCPCSCD6 COCSCDR OKLCGT 1 Last Change Time S 6 127 6 0
VCPCSCD6 COCSCDR OKLCGU 1 Last Change User A 10 133
VCPCSCD6 COCSCDR OKLOC 1 Location No. A 4 8
VCPCSCD6 COCSCDR OKMARK 1 Cost Markup Percent S 7 79 7 4
VCPCSCD6 COCSCDR OKPCLS 1 Price Class S 2 87 2 0
VCPCSCD6 COCSCDR OKPGRP 1 Price Group A 7 19
VCPCSCD6 COCSCDR OKPMAT 1 Price Matrix A 3 5
VCPCSCD6 COCSCDR OKPRIC 1 Item Sell Price P 6 70 11 4 D0
VCPCSCD6 COCSCDR OKREBT 1 Rebate Amount P 6 89 11 4
VCPCSCD6 COCSCDR OKSORL 1 Discount Based On S/L A 1 78
VCPCSCD6 COCSCDR OKSQTY 1 Starting Quantity P 5 65 9 2
VCPCSCD6 COCSCDR OKTDTE 1 To Date S 8 34 8 0
VCPCSCD6 COCSCDR OKTOMK 1 Type of Markup A 1 146
VCPCSCD6 COCSCDR OKUM 1 Unit of Measure A 3 62
VEDIAD EDIBDR EBAFS 1 Application File Set A 10 362
VEDIAD EDIBDR EBBI03 1 BIA03-Report Reference No A 30 12
VEDIAD EDIBDR EBCMP 1 Company No. S 3 2 3 0
VEDIAD EDIBDR EBCUST 1 Customer No. A 7 5
VEDIAD EDIBDR EBDTM1 1 DTM01-Date Qualifier A 3 173
VEDIAD EDIBDR EBDTM2 1 DTM02-Date CCYYMMDD S 8 176 8 0
VEDIAD EDIBDR EBEDOC 1 Mailbox #/Message Log# A 10 352
VEDIAD EDIBDR EBEDPF 1 Processed-Y/N, Error-E A 1 372
VEDIAD EDIBDR EBLIN1 1 LIN01-Line Number S 4 62 4 0 D0
VEDIAD EDIBDR EBN104 1 N104-Warehouse Location A 20 42
VEDIAD EDIBDR EBPID1 1 PID01-Item Desc Type A 1 140
VEDIAD EDIBDR EBPID2 1 PID02-Product Code A 2 141
VEDIAD EDIBDR EBPID5 1 PID05-Product Description A 30 143
VEDIAD EDIBDR EBPRID 1 Trading Partner ID A 15 312
VEDIAD EDIBDR EBPRQL 1 Trading Partner QL A 25 327
VEDIAD EDIBDR EBQTY1 1 QTY01-Quantity Qualifier A 2 217 D0
VEDIAD EDIBDR EBQTY2 1 QTY02-Quantity S 10 219 10 0 D0
VEDIAD EDIBDR EBQTY3 1 QTY03-Unit of Measure A 2 229 D0
VEDIAD EDIBDR EBREF1 1 REF01-Reference Qualifier A 3 184
VEDIAD EDIBDR EBREF2 1 REF02-Reference Number A 30 187
VEDIAD EDIBDR EBSDQ01 1 SDQ01-Unit of Measure A 2 231
VEDIAD EDIBDR EBSDQ02 1 SDQ02-ID Qualifier A 2 233
VEDIAD EDIBDR EBSDQ03 1 SDQ03-Quantity Type A 5 235
VEDIAD EDIBDR EBSDQ04 1 SDQ04-Quantity S 10 240 10 0
VEDIAD EDIBDR EBSDQ05 1 SDQ05-Quantity Type A 5 250
VEDIAD EDIBDR EBSDQ06 1 SDQ06-Quantity S 10 255 10 0
VEDIAD EDIBDR EBSDQ07 1 SDQ07-Quantity Type A 5 265
VEDIAD EDIBDR EBSDQ08 1 SDQ08-Quantity S 10 270 10 0
VEDIAD EDIBDR EBSDQ09 1 SDQ09-Quantity Type A 5 280
VEDIAD EDIBDR EBSDQ10 1 SDQ10-Quantity S 10 285 10 0
VEDIAD EDIBDR EBSDQ23 1 SDQ23-Location ID A 17 295
VEDIAD EDIBDR EBSKU# 1 LIN07-Item SKU A 30 110 D0
VEDIAD EDIBDR EBSKUQ 1 LIN06-SKU Qualifier A 2 108 D0
VEDIAD EDIBDR EBSTCD 1 Status Code A 1 1
VEDIAD EDIBDR EBUPC# 1 LIN05-Item UPC A 18 90 D0
VEDIAD EDIBDR EBUPCQ 1 LIN04-UPC Qualifier A 2 88 D0
VEDIAD EDIBDR EBVNIT 1 LIN03-Item VN A 20 68 D0
VEDIAD EDIBDR EBVNIT 2 LIN03-Item VN A 20 68 FS
VEDIAD EDIBDR EBVNQL 1 LIN02-Item Qualifier A 2 66 D0
VEDIAH EDIBHR EAAFS 1 Application File Set A 10 261
VEDIAH EDIBHR EABI01 1 BIA01-Purpose Code A 2 12
VEDIAH EDIBHR EABI02 1 BIA02-Report Code A 2 14
VEDIAH EDIBHR EABI03 1 BIA03-Report Reference No A 30 16 D0
VEDIAH EDIBHR EABI04 1 BIA04-Transmission Date S 8 46 8 0 D0
VEDIAH EDIBHR EABI05 1 BIA05-Transmission Time S 4 54 4 0 D0 O C RTVDTM
VEDIAH EDIBHR EACCTD 1 Creation Date S 8 282 8 0
VEDIAH EDIBHR EACCTP 1 Creation Pgm A 10 306
VEDIAH EDIBHR EACCTT 1 Creation Time S 6 290 6 0
VEDIAH EDIBHR EACCTU 1 Creation User A 10 296
VEDIAH EDIBHR EACMP 1 Company No. S 3 2 3 0
VEDIAH EDIBHR EACUST 1 Customer No. A 7 5 FS
VEDIAH EDIBHR EAEDDT 1 Transmission Date S 8 196 8 0
VEDIAH EDIBHR EAEDFT 1 Translation Format A 10 251
VEDIAH EDIBHR EAEDGC 1 Group Control# A 10 221
VEDIAH EDIBHR EAEDIC 1 Interchange Control# A 10 211
VEDIAH EDIBHR EAEDOC 1 Mailbox #/Message Log# A 10 186
VEDIAH EDIBHR EAEDPF 1 Processed-Y/N, Error-E A 1 281
VEDIAH EDIBHR EAEDPT 1 Test/Production A 1 210
VEDIAH EDIBHR EAEDST 1 Transaction Set A 10 241
VEDIAH EDIBHR EAEDTC 1 Transaction Control# A 10 231
VEDIAH EDIBHR EAEDTM 1 Transmission Time S 6 204 6 0
VEDIAH EDIBHR EAGRP 1 Transaction Group A 10 271
VEDIAH EDIBHR EALCGD 1 Change Date S 8 316 8 0
VEDIAH EDIBHR EALCGP 1 Change Pgm A 10 340
VEDIAH EDIBHR EALCGT 1 Change Time S 6 324 6 0
VEDIAH EDIBHR EALCGU 1 Change User A 10 330
VEDIAH EDIBHR EAN101 1 N101-Entity ID A 3 91
VEDIAH EDIBHR EAN102 1 N104-Location Name A 30 94
VEDIAH EDIBHR EAN103 1 N101-Warehouse Qualifier A 2 124
VEDIAH EDIBHR EAN104 1 N104-Warehouse Location A 20 126
VEDIAH EDIBHR EAPRID 1 Trading Partner ID A 15 146
VEDIAH EDIBHR EAPRQL 1 Trading Partner QL A 25 161
VEDIAH EDIBHR EAREF1 1 REF01-Reference Qualifier A 3 58
VEDIAH EDIBHR EAREF2 1 REF02-Reference Number A 30 61
VEDIAH EDIBHR EASTCD 1 Status Code A 1 1
** End of report **
