DR100 - Distribution Requirements Report
Run this program to print the Distribution Requirements report. This report
applies to items set up with the time-phased ordering method (TPO) in IC12.1
(Item Location). The TPO reordering method tracks item order requirements and
available stock over time. With this method, it is possible to anticipate
future situations rather than react to the current situation, and to offer
better customer service with a lower inventory investment.
TPO is a way of expressing future demand, supply, and inventory by time
period, and calculating when a replenishment order should be placed to satisfy
the demand. The program calculates new planned orders based on the current
order demand, remaining forecast, scheduled purchase orders, intransit
inventory, requisitions, and current stock on hand.
The kind of document created by this program is based on the document code set
up for items using the Reorder form tab of IC12.1 (Item Location).
The program follows the dates defined for the Company. If the report is run
for a 53 week company and the report spans more than 1 year, the ending period
and the starting period will be 1 day apart. This situation must be taken into
account when entering forecasts.
Note: To create requisitions, you must set up requesters in RQ04.1
(Requesters). Requesters for this program are defined as DR100 followed by the
Location. For example, for Company 36 and Location EAST, a requester of
DR100EAST must be defined.
After printing DR100, use DR25.1 (Planned Orders) to display and adjust
planned orders generated by this program.
Updated Files
CKPOINT - This file is used in the event of a program or system failure
to enable a batch update program to continue from where it left
off.
COCOMP - Contains the kit components that make up a line on a document.
ICACTIVITY - Created for items with a reorder document code equal to I, T,
or X and the program is run in update mode.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate inventory locations and display location
names.
ICPLANORD - Used for the display of planned data and updating
modifications effected by the user.
ICTRANS - Used to edit the deletion of an item.
ITEMGROUP - Used to validate the item group.
ITEMLOC - Used to validate the existence of an item at a location.
MMDIST - Holds an account number and possibly an activity code intended
for a general ledger distribution of an inventory item.
MMUAVAL -
POCODE -
POINTAOC -
POINTERFAC - Interfaces input from the Inventory Control and Order Entry
systems and outside systems into the Purchase Order system.
REQHEADER - Created when the program is run in update mode and the reorder
document code is equal to R.
REQLINE - Created when the program is run in update mode and the reorder
document code is equal to R.
ROUTEDOC - Contains documents that are to be delivered along a route.
ROUTEHDR - For all routes created, a header record is added to the Route
Header file.
ROUTESTOP - Contains records set up to identify the stops along a route.
RQAPPROVE - Contains the open approval records needing to be approved,
created for each approval amount level that is less than the
requisition total value.
TXCODEMAST - Contains tax codes, descriptions, and the tax types that
define how the tax code is to be used.
TXCOMPANY - Contains Tax system company information, as well as which tax
system the company uses.
TXTAXCODE - Contains tax code information used to calculate tax
transactions.
TXTAXTABLE - Used in an Accounts Payable common routine.
WHDEMAND - Contains all the records that the Warehouse system needs for
processing demands.
WHDEMNDHDR - Contains document header records.
WODMNDFCST -
Referenced Files
AMASSET - Used to validate the asset numbers maintained in the Asset
Management system.
AMTEMPLATE - Used to validate the asset template numbers maintained in the
Asset Management system.
APACCRCODE - Used to link a general ledger invoice accrual account to an
invoice.
APCOMPANY - Used to get the vendor group for vendor number validation.
APVENGROUP - A group of vendors that can be shared by one or more Accounts
Payable companies.
BUYCLASS -
BUYCMPLOC -
BUYER - Used to validate the buyer codes.
BUYVENPF -
COMPONENT - Contains the component items that make up a kit item.
CUCONV - Used to obtain currency conversion information.
CURELAT - Used to validate a currency relationship.
CUSTORDER -
GLADDRESS - Used in a General Ledger common routine.
GLCHART - Contains chart and system account information in the General
Ledger system.
GLCODES - Used in a General Ledger common routine.
GLINTCO - Contains interzone and intercompany relationships.
GLSYSTEM - Used in a General Ledger common routine.
ICBIN - Used to validate bin numbers.
ICCATEGORY - Used to retrieve account information.
ICFORECAST - Contains the forecast records by year.
ICRECEIPTS - Used to edit the deletion of an item.
ICRPTGRP - Used to validate report groups.
ICVALUOM -
INSTCTRYCD -
ITEMMAST - Used to print the item description.
ITEMSRC -
ITEMSUB - Stores valid substitutes for an item.
KITITEM - Contains those items that are also kits.
MACOMPANY -
MAJORCL - Used to validate major classes.
MAMTCHELEM -
MATCHCLASS -
MINORCL -
OECOMPANY -
OEFRTCODE - Contains freight codes that can be used in the Warehouse
system.
OEROUTE - Contains user-defined routes that are set up in the Warehouse
system.
ORDERTYPE - Stores order type parameters.
POCOMPANY - Used to retrieve Purchase Order historical transactions.
POITEMVEN - Used to validate the vendor item number.
POVAGRMTHD -
POVENDOR - Used in a Purchase Order common routine.
PROCTEMPLN -
PROCUREGRP -
REQUESTER - Used to validate a requester name.
RQACCTU - List of valid accounting units that this requester can enter
on a requisition.
RQAPPCODE - Used to obtain valid approval codes.
RQLOC - Used to retrieve requesting location names.
RQPURCHCLS - Contains a list of valid purchasing major classes that a
requester can enter items for on a requisition.
STCOMMCODE - Contains a list of valid standard comment codes used to add
comments to a purchase order.
TXTAXRATE - Used in an Accounts Payable common routine.
WFSETUP -
WHPROCTYPE - Contains process type records used for determining the steps a
document is to take in the Warehouse system.
INVOKED Programs
ACAC
ACCL
IFCU
IFSG
API3
IFAC
IFAU
SLSE
SLSU
API4
ICI1
ICI8
POIF
IFOB
IFRS
POIG
POIH
RQCP
|
