Lawson - Lawson Software Technical Library - Data File Text for ICPLANORD

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