ICPLANORD

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.
UPDATED BY
DR100 DR25.1 DR40.1 DR42.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.
DR100
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.
DR100
IPL-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
DR100
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.
DR100
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.
DR100 DR25.1
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.
DR100 DR25.1
IPL-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
This field contains the vendor's identification code.
DR100
IPL-FR-LOCATION
Element: Location
Alpha 5
This field contains the location from which the item is ordered or supplied.
DR100 DR25.1
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.
DR100
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.
DR100
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.
DR100
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.
DR100
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.
DR100
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.
DR100
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.
DR100 DR25.1
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.
DR100


ICPLANORD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPLSET1 COMPANY
LOCATION
ITEM
PERIOD-DT
DR100 DR25.1
DR40.1
IPLSET2 COMPANY
FR-LOCATION
ITEM
PLAN-SHIP-DT
LOCATION
KeyChange, Subset
WhereFR-LOCATION !=Spaces
AndPLAN-SHIP-DT >Zeroes
DR100 DR25.1
IPLSET3 COMPANY
LOCATION
ITEM
PLAN-RECV-DT
KeyChange, Subset
WherePLAN-RECV-DT >Zeroes
DR25.1
IPLSET4 COMPANY
LOCATION
BUYER-CODE
ITEM
PERIOD-DT
DR42.1


ICPLANORD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
IPL-COMPANY->CPY-COMPANY
Company ICCOMPANY Required
IPL-COMPANY->ICC-COMPANY
Iclocation ICLOCATION Required
IPL-COMPANY->ICL-COMPANY
IPL-LOCATION->ICL-LOCATION
Itemloc ITEMLOC Required
IPL-COMPANY->ITL-COMPANY
IPL-LOCATION->ITL-LOCATION
IPL-ITEM->ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
IPL-ITEM->ITE-ITEM
Vendor APVENMAST Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
IPL-VENDOR->VEN-VENDOR
Vendorgroup APVENGROUP Required
CPY-VENDOR-GROUP->VGP-VENDOR-GROUP


File created: Thu Jun 09 11:17:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.