General Description of The History File MYGATEFH.TXT
There is generally a history record for each location and item
containing The following fields :
NumberContentExample
1. LocationPlant , Warehouse , Distribution CenterDENVER
2. Item NumberItem code134-789-0A
3. Item DescriptionItem characteristic or nameYellow 50 Watt Florescent Light Bulb
4. Vendor codeWho is the ultimate source vendor , plant , warehouse number abbreviationGE
5. Product ClassGrouping of items by family or generic codeFLORESCENTS
6. Management CodeGrouping of items by buyer or work centerHARDWARE
7. TypeType of item : Y = Make to stock NS = Make to order NB = discontinueY
8. Safety TimeMinimum time supply in weeks (Adds to Vendor Safety Time)0
9. Safety QuantityMinimum quantity to keep on hand0
10. Lead TimeMinimum resupply time in weeks (Adds to Vendor Lead Time)Y
11. Unit CostValue of 1 unit of sales history1.1516
12. MinimumMinum Order Size(Usually the same as the Multiple)100
13. MultipleShip Pack100
14. WeightHeaviness of 1 unit of sales history.086
15. Other Unit of MeasureUnit Factor(s) of 1 unit of sales history.07 cubes
16. Unit of Measure DescriptionCartons , Gallons , Packs of 100 , Pallets , etc.Eaches
17. On HandPhysical count (or equivalent) of quantity in inventory1265
18. Month to date salesShipped so far this month in unit of measure25
19. BlankNot NeededH
20. Most recent complete month of salesFor example how many we sold in August37
21. Month before that complete month of salesFor example how many we sold in July45
22. Month before that complete month of salesKeep going back in time June etc. up to 48 months69