Version 6 Item Record (USED FOR ALL DOWNLOADS AFTER 1/1/99)
This format expands the Season Ind code from 2 characters to 3 characters and changes the Period To Date field (MTD) from 6.0 to 14.4.
The following is the detailed record layout for later versions of Mars 6.
MONTHLY ITEM RECORD LAYOUT FILE NAME MUST BE MARSUPDT.D10
|
Field name
|
|
|
Begin
|
End
|
Length
|
Decimals
|
|
Item Number
|
AX0001
|
|
1
|
28
|
28
|
N/A
|
|
Item Descr
|
AUTO BATTERY-Gp45-475 cca
|
|
29
|
58
|
30
|
N/A
|
|
U of M
|
EACH
|
|
59
|
62
|
4
|
N/A
|
|
Location
|
1
|
|
63
|
67
|
5
|
N/A
|
|
Season Ind
|
22
|
|
68
|
70
|
3
|
N/A-length chgd
|
|
Lot Sens.
|
40
|
|
71
|
73
|
3
|
N/A
|
|
Vendor
|
9
|
|
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
|
421000
|
(=42.10)
|
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
|
341
|
4
|
N/A
|
|
Group II
|
|
|
342
|
345
|
4
|
N/A
|
|
Super Vendor
|
|
|
346
|
354
|
9
|
N/A
|
|
P-T-D
|
200000
|
(= 20)
|
355
|
368
|
14
|
4
|
|
Weight
|
31000
|
(= 31)
|
369
|
378
|
10
|
3
|
|
Shelf min.
|
100000
|
(= 10)
|
379
|
392
|
14
|
4
|
|
Back Order
|
100000
|
(= 10)
|
393
|
406
|
14
|
4
|
|
Remove Flag
|
(D will remove the item)
|
|
407
|
407
|
1
|
N/A
|
|
Item Lead Time
|
16
|
(= 16)
|
408
|
411
|
4
|
0
|
|
Item Create Date
|
19950131
|
(=01/31/1995)
|
412
|
419
|
8
|
N/A
|
|
Lot Size 2
|
10
|
(=10)
|
420
|
423
|
4
|
N/A
|
|
Lot Sens 2
|
80
|
(=80)
|
424
|
427
|
4
|
N/A
|
|
Replacement Item
|
|
|
428
|
455
|
28
|
N/A
|
