| 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 : | |
| Number | Content | Example |
| 1. Consolidation Ctr Number | Plant , Warehouse , Distribution Center | 001 |
| 2. Item Number | Item code | 0000028 |
| 3. Record Type | 1DC 1BM or 2CC | 1DC |
| 4. Vendor Number | Supplier Code | A200420 |
| 5. Product Class | ie Glassware | 1210 |
| 6. Management Code | ie Buyer | RP |
| 7. Type | Type of item : Y = Make to stock NS = Make to order NB = discontinue | Y |
| 8. Safety Time | Minimum 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 Quantity | Minimum quantity to keep on hand | 0 |
| 10. Lead Time | Minimum resupply time in weeks (Adds to Vendor Lead Time) | Y |
| 11. NUll | Empty | Null |
| 12. Null | Empty | Null |
| 13. 6 Months Sales History | Sales History in units except New Items = NEW | 27 or NEW |
| 14. Excess Inventory | Excess in units over 6 months history and 26 weeks needs | 12 |
| 15. Unit Valuations | Unit Cost#Unit Weight # Unit Others | 21.00#4.5#1#etc. |
| 16. Item Multiple | Used after Item Minimum is used once | 1 |
| 17. Null | Empty | Null |
| 18. Rush Week | Week number from now the on hand will go negative | 2 |
| 19. Record Type | 1DC 1BM or 2CC | 1DC |
| 19-2CC. Record Type | 2CC | 2DC |
| 19-2CCa. Location of Details | Disk Location of this item in FFRP\MYGATEF1.TXT | #578856 |
| 19-2CCb. Customer Orders | Customer Orders in units past due for this cc | #20 |
| 19-2CCc. Customer Orders | Customer Orders in units past due for week 1 | #17 |
| 19-1DC or 1BM. Record Type | 1DC | 2BM |
| 19-2DCa. Kit or dc identifier | Dist Ctr Number or BOM Number | 011 or AB1112 |
| 19-2DCb. Customer BackOrder | Customer Orders in units past due for this dc | #20 |
| 19-2DCc. Item Minimum | Minimum Order Size | #100 |
| 19-2DCd. On Hand | Physical Count of quantity in inventory | #27 |
| 19-2DCe. 6 Months Sales | Sales History in units or (NEW) | #35 |
| 19-2DCf. Type | Buy Code | #NB , #NS , #Y |
| 19-2DCg. Total Inbound | Total On Order | #345 |
| 20. Long form : from past due plus 104 weeks | Coded in ffcfg as follows | *SOURCE REPORT INCLUDE*1*@ |
| 20a. Calc PO 20 through 124 | Calculated purchases or production | **6*2*2*2 etc. |
| 20b. On Hand 125 through 229 | On hand balance week by week in units | *-2*0*0*6 etc. |
| 20c. Needs 230 through 334 | Requirements or customer orders whichever is higher in units | *2*4** etc. |
| 20d. Inbound 335 through 439 | Open Orders (Not Received Inbound) | **6*2*2*2 etc. |
| 20e. Customer Orders 440 through 544 | Customer orders by week | **6*2*2*2 etc. |
| 21. Short form : from past due plus 26 weeks | Coded in ffcfg as follows | *SOURCE REPORT INCLUDE*0*@ |
| 21a. Calc PO 20 through 46 | Calculated purchases or production | **6*2*2*2 etc. |
| 21b. Needs 47 through 73 | Requirements or customer orders whichever is higher in units | *2*4** etc. |
| 21c. Inbound 74 through 100 | Open Orders (Not Received Inbound) | **6*2*2*2 etc. |
| 21d. Customer Orders 101 through 127 | Customer orders by week | **6*2*2*2 etc. |