General Description of The FFRP\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. Consolidation Ctr NumberPlant , Warehouse , Distribution Center001
2. Item NumberItem code0000028
3. Record Type1DC 1BM or 2CC1DC
4. Vendor NumberSupplier CodeA200420
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. NUllEmptyNull
12. NullEmptyNull
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. Item MultipleUsed after Item Minimum is used once1
17. NullEmptyNull
18. Rush WeekWeek number from now the on hand will go negative2
19. Record Type1DC 1BM or 2CC1DC
19-2CC. Record Type2CC2DC
19-2CCa. Location of DetailsDisk Location of this item in FFRP\MYGATEF1.TXT#578856
19-2CCb. Customer OrdersCustomer Orders in units past due for this cc#20
19-2CCc. Customer OrdersCustomer Orders in units past due for week 1#17
19-1DC or 1BM. Record Type1DC2BM
19-2DCa. Kit or dc identifierDist Ctr Number or BOM Number011 or AB1112
19-2DCb. Customer BackOrderCustomer Orders in units past due for this dc#20
19-2DCc. Item MinimumMinimum Order Size#100
19-2DCd. On HandPhysical Count of quantity in inventory#27
19-2DCe. 6 Months SalesSales History in units or (NEW)#35
19-2DCf. TypeBuy Code#NB , #NS , #Y
19-2DCg. Total InboundTotal On Order#345
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.