To properly display this page you need a browser with JavaScript support.
Version 6 Item Record (USED FOR ALL DOWNLOADS BEFORE 1/1/99)
The following Record Layout is provided with fixed field length definition. When the Comma Delimited Interface files switch is selected, this Record Layout should be used to define the order and maximum length of the text fields.
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
69
2
N/A
Lot Sens.
40
70
72
3
N/A
Vendor
9
73
81
9
N/A
ABC Class
A
82
82
1
N/A
Qty on Hand
140000
(= 14)
83
96
14
4
Qty on Order
50000
(= 5)
97
110
14
4
Qty Comm.
160000
(= 16)
111
124
14
4
History 1
480000
(= 48)
125
138
14
4
History 2
580000
(= 58)
139
152
14
4
History 3
420000
(= 42)
153
166
14
4
History 4
540000
(= 54)
167
180
14
4
History 5
820000
(= 82)
181
194
14
4
History 6
900000
(= 90)
195
208
14
4
History 7
700000
(= 70)
209
222
14
4
History 8
500000
(= 50)
223
236
14
4
History 9
320000
(= 32)
237
250
14
4
History 10
380000
(= 38)
251
264
14
4
History 11
500000
(= 50)
265
278
14
4
History 12
460000
(= 46)
279
292
14
4
Volume
10000
(= 10)
293
302
10
3
Lot Size
20
(= 20)
303
308
6
0
Vendor min.
100
(= 100)
309
322
14
0
Unit Cost
2900000
(=29.00)
323
336
14
5
Group I
337
340
4
N/A
Group II
341
344
4
N/A
Super Vendor
345
353
9
N/A
P-T-D
20
(= 20)
354
359
6
0
Weight
31000
(= 31)
360
369
10
3
Shelf min.
100000
(= 10)
370
383
14
4
Back Order
100000
(= 10)
384
397
14
4
Remove Flag
(D will remove the item)
398
398
1
N/A
Item Lead Time
16
(= 16)
399
402
4
0
Item Create Date
19950131
(=01/31/1995)
403
410
8
N/A
Lot Size 2
420
423
4
N/A
Lot Sensitivity 2
424
427
4
N/A
Replacement Item
428
455
28
N/A
