This appendix contains the topic:
This document reviews the pristine quantity type table (UDC 34/QT), as provided with the software, and provides an explanation for each quantity type. While JD Edwards recommends that you run the planning programs (P3482 & P3483) using the pristine table, you may set up any number of alternate tables to view the time series according to user preference. (See Section 54.3, "Time Series (P3413).")
If you choose to create alternate tables, you must base them on the pristine table so that the numeric codes will always represent the same quantity type. For example, 20 must always be adjusted purchase orders, regardless of how you modify the first and second descriptions on the table.
Note:
The first three quantity types are not written by the World planning programs but are available for population by a user written program. The first and second descriptions are just examples of how they might be used. If populated, the values would be for reference only, i.e. they have no affect on MRP calculations.| Code | Label | Description | Explanation |
|---|---|---|---|
| 02 | LYR | Last Year Actual | |
| 03 | SF | Sales Forecast | |
| 04 | SP | Special Promotion | |
| 05 | +BAU | + Beginning Avail (Unadjusted) | The beginning available balance without adjusting for MRP action messages. |
| 10 | +BA | + Beginning Avail | The beginning available balance adjusted according to MRP action messages. |
| 13 | +IR | + In Receipt Routing | PO receipts or WO completions in receipt routing. There is an MRP processing option that allows quantities in the receipt routing operations you specify to be considered on hand, otherwise they will appear in the appropriate time period on the +IR line. |
| 15 | +POU | + Purchase Orders (Unadjusted) | Supply from pending purchase order receipts (including the purchase order side of transfer orders) without adjusting for action messages; i.e. promised delivery dates (PDDJ/F4311) and quantities at the time of the MRP run. |
| 20 | +PO | + Purchase Orders | Supply from pending purchase order receipts (including the purchase order side of transfer orders) adjusted according to MRP action messages (Defer, Expedite, Increase, and Decrease). |
| 25 | +WOU | + Work Orders (Unadjusted) | Supply from pending work order completions without adjusting for MRP action messages; i.e. requested dates (DRQJ/F4801) and quantities at the time of the MRP run. |
| 30 | +WO | + Work Orders | Supply from pending work order completions adjusted according to MRP action messages (Defer, Expedite, Increase, and Decrease). |
| 40 | +RSU | + Rate Schedule (Unadjusted) | Supply from pending rate schedule completions without adjusting for MRP action messages; i.e. dates (STRT, DRQJ/F4801) and quantities (spread according to rate period) at the time of the MRP run. |
| 35 | +RS | + Rate Schedule | Supply from planned rate schedules (Create Rate messages) and pending rate schedule completions adjusted according to MRP action messages (Decrease, Increase). |
| 42 | -LEXP | - Lot Expired | A processing option determines whether lot expiration dates will be included in MRP calculations. If so, this represents lot quantities that have not been consumed by their expiration date. This line will not appear on the time series if all of the lot is consumed before the expiration date (this might include forecast demand). |
| 45 | -FCU | - MPS/Forecast (Unadjusted) | A processing option determines forecast types to be included. This is the sum of the specified forecast types from the detail forecast file unadjusted by MRP planning parameters. |
| 50 | -FC | - MPS/Forecast | This is the forecast quantity adjusted according to MRP planning parameters (planning fence and rule/forecast consumption). |
| 52 | -SHIP | - Shipped Quantity | This quantity is only written when using forecast consumption (planning fence rule H) and reflects sales orders quantities shipped based on the Forecast Shipment Summary (F3462). When an order is ship confirmed, if the sales order document type is set up in the 40/CF UDC table (all doc types in the inclusion rules used for MRP should be included on this table if using forecast consumption), the quantity is written to the F3462. Note that if a sales order document type is added to 40/CF after shipments are made for orders with that doc type, the orders already shipped will not be included in F3462, and therefore the -SHIP for the period in which they were shipped will not appear. -SHIP quantities continue to consume forecast until their scheduled pick date is prior to the current forecast consumption period. |
| 55 | -SOU | - Sales Orders (Unadjusted) | Demand from sales orders directly from the sales order detail file (F4211). This reflects actual dates (PDDJ) and quantities of sales orders. When running multi-facility MRP (P3483), this represents an independent sales order for the supply branch - i.e. not inter-plant demand. |
| 60 | -SO | - Sales Orders | This quantity type is only written by Single Plant MRP (P3482) and represents sales order quantities adjusted according to MRP planning parameters (planning fence and rule/forecast consumption). When using forecast consumption, this represents the sales order quantity consuming the forecast in that bucket. The -TI quantity type replaces this for Multi-Plant MRP. |
The following five quantity types are only generated by multi-facility MRP (P3483) and will only appear in a supply branch.
| Code | Label | Description | Explanation |
|---|---|---|---|
| 65 | -ID | - Inter-Plant Demand | Planned transfers; i.e. demand from another branches based on an established branch relationships. There will be corresponding planned transfers (+PLO) in the demand branches. |
| 66 | -FIDU | - Firm Inter-Plant (Unadj) | Firm Inter-Plant Demand Unadjusted. Demand from existing transfer orders unadjusted for MRP action messages. |
| 67 | -FID | - Firm Inter-Plant Demand | Firm Inter-Plant Demand Adjusted. Demand from existing transfer orders adjusted for MRP action messages. |
| 68 | -TIU | - Total Indep. Demand (Unadj) | Total Independent Demand Unadjusted. The calculation of this quantity type depends on how the processing option that specifies whether interplant demand should consume forecast. When the processing option is turned on (set to 1), -TIU = the sum of -SOU, -ID, and -FID. When the processing option is turned off (blank), -TIU = -SOU. |
| 69 | -TI | - Total Independent Demand | Total Independent Demand Adjusted. This quantity type takes the place of -SO when multi-facility planning is run. It is -TIU adjusted according to MRP planning parameters (planning fence and rule/forecast consumption). |
Unless lead time offsets are established, the required dates for the following three dependent demand quantity types will be the start dates of the parent items work orders or planned orders.