Version 7 Item Record
This format includes five additional fields to be used in conjunction with the Venus Marketing Forecast module
The following is the detailed record layout for Version 7
MONTHLY ITEM RECORD LAYOUT FILE NAME MUST BE: MARSUPDT.D10
|
Field name
|
|
|
Begin
|
End
|
Length
|
Decimals
|
|
Item Number
|
101901
|
|
1
|
28
|
28
|
N/A
|
|
Item Descr
|
KETTLE ONE VODKA
|
|
29
|
58
|
30
|
N/A
|
|
U of M
|
750M
|
|
59
|
62
|
4
|
N/A
|
|
locations
|
ATL
|
|
63
|
67
|
5
|
N/A
|
|
Season Ind
|
01
|
|
68
|
70
|
3
|
N/A
|
|
Lot Sens.
|
50
|
|
71
|
73
|
3
|
N/A
|
|
Vendor
|
09
|
|
74
|
82
|
9
|
N/A
|
|
ABC Class
|
A
|
|
83
|
83
|
1
|
N/A
|
|
Qty on Hand
|
140000
|
(= 14)
|
84
|
97
|
14
|
4
|
|
Qty on Ord
|
50000
|
(= 5)
|
98
|
111
|
14
|
4
|
|
Qty Comm.
|
160000
|
(= 16)
|
112
|
125
|
14
|
4
|
|
History 1
|
480000
|
(= 48)
|
126
|
139
|
14
|
4
|
|
History 2
|
580000
|
(= 58)
|
140
|
153
|
14
|
4
|
|
History 3
|
0000000420000
|
(=42)
|
154
|
167
|
14
|
4
|
|
History 4
|
540000
|
(= 54)
|
168
|
181
|
14
|
4
|
|
History 5
|
820000
|
(= 82)
|
182
|
195
|
14
|
4
|
|
History 6
|
900000
|
(= 90)
|
196
|
209
|
14
|
4
|
|
History 7
|
700000
|
(= 70)
|
210
|
223
|
14
|
4
|
|
History 8
|
500000
|
(= 50)
|
224
|
237
|
14
|
4
|
|
History 9
|
320000
|
(= 32)
|
238
|
251
|
14
|
4
|
|
History 10
|
380000
|
(= 38)
|
252
|
265
|
14
|
4
|
|
History 11
|
500000
|
(= 50)
|
266
|
279
|
14
|
4
|
|
History 12
|
460000
|
(= 46)
|
280
|
293
|
14
|
4
|
|
Volume
|
10000
|
(= 10)
|
294
|
303
|
10
|
3
|
|
Lot Size
|
20
|
(= 20)
|
304
|
309
|
6
|
0
|
|
Vendor min.
|
100
|
(= 100)
|
310
|
323
|
14
|
0
|
|
Unit Cost
|
2900000
|
(=29.00)
|
324
|
337
|
14
|
5
|
|
Group I
|
|
|
338
|
346
|
9
|
N/A
|
|
Group II
|
|
|
347
|
355
|
9
|
N/A
|
|
Super Vendor
|
|
|
356
|
364
|
9
|
N/A
|
|
P-T-D
|
200000
|
(= 20)
|
365
|
378
|
14
|
4
|
|
Weight
|
31000
|
(= 31)
|
379
|
388
|
10
|
3
|
|
Shelf min.
|
100000
|
(= 10)
|
389
|
402
|
14
|
4
|
|
Back Order
|
100000
|
(= 10)
|
403
|
416
|
14
|
4
|
|
Remove Flag
|
(D will remove the item)
|
|
417
|
417
|
1
|
N/A
|
|
Item Lead Time
|
16
|
(= 16)
|
418
|
421
|
4
|
0
|
|
Item Create Date
|
19950131
|
(=01/31/1995)
|
422
|
429
|
8
|
N/A
|
|
Lot Size 2
|
10
|
(=10)
|
430
|
433
|
4
|
N/A
|
|
Lot Sens 2
|
80
|
(=80)
|
434
|
437
|
4
|
N/A
|
|
Replacement Item
|
|
|
438
|
465
|
28
|
N/A
|
|
Monitor Code
|
|
|
466
|
474
|
9
|
N/A
|
|
Class Code
|
|
|
475
|
483
|
9
|
N/A
|
|
Marketing Manager
|
|
|
484
|
492
|
9
|
N/A
|
|
Brand Description
|
|
|
493
|
532
|
40
|
N/A
|
|
9L Value Numeric 120000
|
|
(=12)
|
533
|
546
|
14
|
4
|
|
*Supplier ID
|
A123456789
|
|
547
|
556
|
10
|
N/A
|
|
*Supplier Name
|
ACME Supply
|
|
557
|
586
|
30
|
N/A
|
