| 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 : | |
| Number | Content | Example |
| 1. Location | Plant , Warehouse , Distribution Center | 003 |
| 2. Item Number | Item code | 0015688 |
| 3. Null | Empty | Null |
| 4. Vendor Number | Supplier | 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. Unit Cost | Value of 1 unit of sales history | 1.1516 |
| 12. Minimum | Minum Order Size(Usually the same as the Multiple) | 100 |
| 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. Null | Empty | Null |
| 17. Null | Empty | Null |
| 18. Rush Week | Week number from now the on hand will go negative | 2 |
| 19. P | Planned Order record Code | P |
| 19a. Location of Details | Disk Location of this item in FFRP\MYGATEF1.TXT | #578856 |
| 19b. Customer Orders | Customer Orders in units past due for this cc | #20 |
| 19c. Customer Orders | Customer Orders in units past due for week 1 | #17 |
| 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. |