Inventory Planned Order File
The Inventory Planned Order File is a repository of planned orders. Orders are created by the Distribution Requirements Report (DR100), which takes the supply and demand data for an item at a location over time. Based on the time phased order point algorithm, a planned replenishment order is determined. This file is updated with the planned order information used for inquiry and possibly as a demand against another location.
REFERENCED BY
DR40.1 | DR42.1 |
DR100 | DR25.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
IPL-COMPANY Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
||
IPL-LOCATION Element: Location | Alpha 5 This field contains a valid stock location within the company inventory. This location represents the location doing the planning. |
|
||
IPL-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||
IPL-PERIOD-DT Element: Period Dt | Numeric 8 (yyyymmdd) This field contains the date representing the first day of the planned week. All planning is done by week. The first period date defaults to the computer date. Each successive beginning period is calculated by adding seven. |
|
||
IPL-PLAN-RECV-DT Element: Plan Recv Dt | Numeric 8 (yyyymmdd) This field contains the date the planned order is to be received at the planning location. |
|
||
IPL-PLAN-SHIP-DT Element: Plan Ship Dt | Numeric 8 (yyyymmdd) This field contains the date that the planned order is to be shipped from the source. |
|
||
IPL-VENDOR Element: Vendor | Alpha 9 (Right Justified) This field contains the vendor's identification code. |
|
||
IPL-FR-LOCATION Element: Location | Alpha 5 This field contains the location from which the item is ordered or supplied. |
|
||
IPL-CREATED-DT Element: Created Dt | Numeric 8 (yyyymmdd) This field contains the date the planned order was created. This field is updated by the system. |
|
||
IPL-CREATED-TIME Element: Created Time | Numeric 6 (hhmmss) This field contains the time the planned order was created. This field is updated by the system. |
|
||
IPL-BUYER-CODE Element: Buyer | Alpha 3 This field contains the user-defined buyer identifier. This is used by the buyer for planning. |
|
||
IPL-FIRM-DEMAND Element: Firm Demand | Signed 13.4 This field contains the total demand of logged customer orders from the Order Entry and Requisitions systems. Also included are any planned orders from other locations that are replenished from this location. The estimated shipping date is used to determine which week the customer order creates demand. All demand due for shipping before the current week that was not shipped is included in the current week total. |
|
||
IPL-REMAIN-FORCST Element: Remain Forcst | Signed 13.4 This field contains the period forecast quantity minus the firm demand, but is not less than zero. If the forecast is setup as weekly, the weekly period forecast quantity is used. If the forecast is set up as monthly, the quantity is divided by 4.33. |
|
||
IPL-SCHED-RECEIPT Element: Sched Receipt | Signed 13.4 This field contains scheduled receipts, which are the sum of open supply coming into this location for this period. The sum includes open purchase orders, open intransits, and open incoming requisitions. |
|
||
IPL-PROJ-AVAIL Element: Proj Avail | Signed 13.4 For the first week, this field contains the total of the stock-on-hand minus firm demand minus remaining forecast plus scheduled receipts by week. If any planned orders are calculated to arrive this week, they are added to this quantity. For each subsequent week, the on-hand balance is the previous week's on-hand balance minus the gross demand and remaining forecast quantities plus the scheduled receipts and planned orders quantities. |
|
||
IPL-PLAN-ORDER Element: Plan Order | Signed 13.4 This field contains the reorder quantities, backed off by the leadtime, that should be ordered to prevent the on hand balance from becoming negative or from going below the safety stock quantity. Reorder quantities are printed in the week they should be released based on leadtime, not the week that they are to be delivered. These planned orders are stored here for this location. Each one is also a demand against another location, if the replenishment location field is filled in. This demand is stored on this file as demand against the replenishment location. |
|
||
IPL-FIRM-PLAN-ORD Element: Firm Plan Ord | Signed 13.4 This field contains the quantity of planned orders that fall within the planned order period cutoff parameter. These planned orders turn into unreleased purchase orders. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IPLSET1 |
COMPANY LOCATION ITEM PERIOD-DT |
|
| ||||||||||||||||||||
IPLSET2 |
COMPANY FR-LOCATION ITEM PLAN-SHIP-DT LOCATION |
|
| ||||||||||||||||||||
IPLSET3 |
COMPANY LOCATION ITEM PLAN-RECV-DT |
|
| ||||||||||||||||||||
IPLSET4 |
COMPANY LOCATION BUYER-CODE ITEM PERIOD-DT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| |||||||||
Company | ICCOMPANY |
Required
| |||||||||
Iclocation | ICLOCATION |
Required
| |||||||||
Itemloc | ITEMLOC |
Required
| |||||||||
Itemmast | ITEMMAST |
Required
| |||||||||
Vendor | APVENMAST |
Required
| |||||||||
Vendorgroup | APVENGROUP |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.