General Description of The RPDATA\MYGATEF1.TXT output from Resource Planning
There is an output record from Resource Planning for each location and item
containing the following fields :
NumberContentExample
1. LocationPlant , Warehouse , Distribution Center003
2. Item NumberItem code0015688
3. NullEmptyNull
4. Vendor NumberSupplierA200420
5. Product Classie Glassware1210
6. Management Codeie BuyerRP
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)1.7
8a. Replenishment Time (field 8. followed by a #)Planned Order weeks to order at one time.#3
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. 6 Months Sales HistorySales History in units except New Items = NEW27 or NEW
14. Excess InventoryExcess in units over 6 months history and 26 weeks needs12
15. Unit ValuationsUnit Cost#Unit Weight # Unit Others21.00#4.5#1#etc.
16. NullEmptyNull
17. NullEmptyNull
18. Rush WeekWeek number from now the on hand will go negative2
19. PPlanned Order record CodeP
19a. Location of DetailsDisk Location of this item in FFRP\MYGATEF1.TXT#578856
19b. Customer OrdersCustomer Orders in units past due for this cc#20
19c. Customer OrdersCustomer Orders in units past due for week 1#17
20. Long form : from past due plus 104 weeksCoded in ffcfg as follows*SOURCE REPORT INCLUDE*1*@
20a. Calc PO 20 through 124Calculated purchases or production**6*2*2*2 etc.
20b. On Hand 125 through 229On hand balance week by week in units*-2*0*0*6 etc.
20c. Needs 230 through 334Requirements or customer orders whichever is higher in units*2*4** etc.
20d. Inbound 335 through 439Open Orders (Not Received Inbound)**6*2*2*2 etc.
20e. Customer Orders 440 through 544Customer orders by week**6*2*2*2 etc.
21. Short form : from past due plus 26 weeksCoded in ffcfg as follows*SOURCE REPORT INCLUDE*0*@
21a. Calc PO 20 through 46Calculated purchases or production**6*2*2*2 etc.
21b. Needs 47 through 73Requirements or customer orders whichever is higher in units*2*4** etc.
21c. Inbound 74 through 100Open Orders (Not Received Inbound)**6*2*2*2 etc.
21d. Customer Orders 101 through 127Customer orders by week**6*2*2*2 etc.