|
DB Column
|
Field name
|
Sample
|
Sequence
|
Begin
|
End
|
Length
|
Decimal Placess
|
|
item_num_im
|
Item Number
|
101901
|
1
|
1
|
28
|
28
|
N/A
|
|
item_desc_im
|
Item Descr
|
ACME WIDGET
|
2
|
29
|
58
|
30
|
N/A
|
|
unit_meas_im
|
Unit of Measure
|
CASE
|
3
|
59
|
62
|
4
|
N/A
|
|
whse_im
|
Location
|
ATL
|
4
|
63
|
67
|
5
|
N/A
|
|
s_ind_im
|
Season Ind
|
1
|
5
|
68
|
70
|
3
|
N/A
|
|
vendor_im
|
Vendor Id
|
9
|
6
|
71
|
79
|
9
|
N/A
|
|
abc_class_im
|
ABC Class
|
A
|
7
|
80
|
80
|
1
|
N/A
|
|
qty_on_hand_im
|
Quantity on Hand
|
140000 (= 14)
|
8
|
81
|
94
|
14
|
4
|
|
qty_on_ord_im
|
Quantity on Order
|
50.000 (= 5)
|
9
|
95
|
108
|
14
|
4
|
|
qty_cmt_im
|
Quantity Committed
|
160000 (= 16)
|
10
|
109
|
122
|
14
|
4
|
|
qty_back_im
|
Quantity Back Ordered
|
100000 (= 10)
|
11
|
123
|
136
|
14
|
4
|
|
price_brk_im
|
Volume
|
10000 (= 10)
|
12
|
137
|
146
|
10
|
3
|
|
min_ord_qty_im
|
Vendor Minimum
|
100 (= 100)
|
13
|
147
|
160
|
14
|
0
|
|
unit_cost_im
|
Unit Cost
|
2900000 (= 29)
|
14
|
161
|
174
|
14
|
5
|
|
brand_im
|
Group I
|
|
15
|
175
|
183
|
9
|
N/A
|
|
brand_2_im
|
Group II
|
|
16
|
184
|
192
|
9
|
N/A
|
|
s_vendor_im
|
Super Vendor
|
|
17
|
193
|
201
|
9
|
N/A
|
|
mtd_im
|
Period to Date Depletions
|
200000 (= 20)
|
18
|
202
|
215
|
14
|
4
|
|
wght_im
|
Weight
|
31000 (= 31)
|
19
|
216
|
225
|
10
|
3
|
|
min_ot_im
|
Shelf Minimum
|
100000 (= 10)
|
20
|
226
|
239
|
14
|
4
|
|
dump_flg_im
|
Remove Flag
|
(D will remove the item)
|
21
|
240
|
240
|
1
|
N/A
|
|
lead_time_im
|
Item Lead Time
|
16 (= 16)
|
22
|
241
|
244
|
4
|
0
|
|
item_date_im
|
Item Create Date
|
20230131 (=01/31/2023)
|
23
|
245
|
252
|
8
|
N/A
|
|
lot_size_im
|
Lot Size (TI)
|
20 (= 20)
|
24
|
253
|
258
|
6
|
0
|
|
lot_size_2_im
|
Lot Size 2 (HI)
|
10 (=10)
|
25
|
259
|
262
|
4
|
N/A
|
|
lot_sens_im
|
Lot Sensitivity
|
50 (=50)
|
26
|
263
|
265
|
3
|
N/A
|
|
lot_sens_2_im
|
Lot Sensitivity 2
|
80 (=80)
|
27
|
266
|
269
|
4
|
N/A
|
|
rep_item_im
|
Replacement Item
|
|
28
|
270
|
297
|
28
|
N/A
|
|
mcode_im
|
Item Monitor Code
|
|
29
|
298
|
306
|
9
|
N/A
|
|
ccode_im
|
Product Class Code
|
|
30
|
307
|
315
|
9
|
N/A
|
|
markmgr_im
|
Portfolio Manager
|
|
31
|
316
|
324
|
9
|
N/A
|
|
mbrand_im
|
Brand Description
|
|
32
|
325
|
364
|
40
|
N/A
|
|
m9l_im
|
Conversion Factor
|
120000 (=12)
|
33
|
365
|
378
|
14
|
4
|
|
r_monf_im
|
Supplier ID
|
A123456789
|
34
|
379
|
388
|
10
|
N/A
|
|
mvname_im
|
Supplier Name
|
ACME Supply
|
35
|
389
|
418
|
30
|
N/A
|
|
m_size_im
|
Sort Unit Size
|
750ML
|
36
|
419
|
428
|
10
|
0
|
|
h_im_1
|
History 1
|
000000048.0000 (= 48)
|
37
|
429
|
442
|
14
|
4
|
|
h_im_2
|
History 2
|
00000000580000 (= 58)
|
38
|
443
|
456
|
14
|
4
|
|
h_im_3
|
History 3
|
-0000000420000 (= -42)
|
39
|
457
|
470
|
14
|
4
|
|
h_im_4
|
History 4
|
540000 (= 54)
|
40
|
471
|
484
|
14
|
4
|
|
h_im_5
|
History 5
|
820000 (= 82)
|
41
|
485
|
498
|
14
|
4
|
|
h_im_6
|
History 6
|
900000 (= 90)
|
42
|
499
|
512
|
14
|
4
|
|
h_im_7
|
History 7
|
700000 (= 70)
|
43
|
513
|
526
|
14
|
4
|
|
h_im_8
|
History 8
|
500000 (= 50)
|
44
|
527
|
540
|
14
|
4
|
|
h_im_9
|
History 9
|
320000 (= 32)
|
45
|
541
|
554
|
14
|
4
|
|
h_im_10
|
History 10
|
380000 (= 38)
|
46
|
555
|
568
|
14
|
4
|
|
h_im_11
|
History 11
|
500000 (= 50)
|
47
|
569
|
582
|
14
|
4
|
|
h_im_12
|
History 12
|
460000 (= 46)
|
48
|
583
|
596
|
14
|
4
|
|
l_h_im_1
|
History 13
|
540000 (= 54)
|
49
|
597
|
610
|
14
|
4
|
|
l_h_im_2
|
History 14
|
820000 (= 82)
|
50
|
611
|
624
|
14
|
4
|
|
l_h_im_3
|
History 15
|
900000 (= 90)
|
51
|
625
|
638
|
14
|
4
|
|
l_h_im_4
|
History 16
|
700000 (= 70)
|
52
|
639
|
652
|
14
|
4
|
|
l_h_im_5
|
History 17
|
500000 (= 50)
|
53
|
653
|
666
|
14
|
4
|
|
l_h_im_6
|
History 18
|
320000 (= 32)
|
54
|
667
|
680
|
14
|
4
|
|
l_h_im_7
|
History 19
|
380000 (= 38)
|
55
|
681
|
694
|
14
|
4
|
|
l_h_im_8
|
History 20
|
500000 (= 50)
|
56
|
695
|
708
|
14
|
4
|
|
l_h_im_9
|
History 21
|
460000 (= 46)
|
57
|
709
|
722
|
14
|
4
|
|
l_h_im_10
|
History 22
|
540000 (= 54)
|
58
|
723
|
736
|
14
|
4
|
|
l_h_im_11
|
History 23
|
820000 (= 82)
|
59
|
737
|
750
|
14
|
4
|
|
l_h_im_12
|
History 24
|
900000 (= 90)
|
60
|
751
|
764
|
14
|
4
|
|
p_h_im_1
|
History 25
|
700000 (= 70)
|
61
|
765
|
778
|
14
|
4
|
|
p_h_im_2
|
History 26
|
500000 (= 50)
|
62
|
779
|
792
|
14
|
4
|
|
p_h_im_3
|
History 27
|
320000 (= 32)
|
63
|
793
|
806
|
14
|
4
|
|
p_h_im_4
|
History 28
|
380000 (= 38)
|
64
|
807
|
820
|
14
|
4
|
|
p_h_im_5
|
History 29
|
500000 (= 50)
|
65
|
821
|
834
|
14
|
4
|
|
p_h_im_6
|
History 30
|
460000 (= 46)
|
66
|
835
|
848
|
14
|
4
|
|
p_h_im_7
|
History 31
|
540000 (= 54)
|
67
|
849
|
862
|
14
|
4
|
|
p_h_im_8
|
History 32
|
820000 (= 82)
|
68
|
863
|
876
|
14
|
4
|
|
p_h_im_9
|
History 33
|
900000 (= 90)
|
69
|
877
|
890
|
14
|
4
|
|
p_h_im_10
|
History 34
|
700000 (= 70)
|
70
|
891
|
904
|
14
|
4
|
|
p_h_im_11
|
History 35
|
500000 (= 50)
|
71
|
905
|
918
|
14
|
4
|
|
p_h_im_12
|
History 36
|
320000 (= 32)
|
72
|
919
|
932
|
14
|
4
|
