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

    ACCOMMIT   - This file contains commitments not yet posted to the general
                 ledger.


    ACCOMMITX  - This file contains commitment details not yet posted to the
                 general ledger.


    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.

    COLINEDTL  - Contains line allocation information created when an item is
                 tracked by bin, lot, serial number, or multiple unit of
                 measure.


    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.


    ICLOT      - Stores the expiration dates and hold flag for lots.

    ICPLANORD  - Used for the display of planned data and updating
                 modifications effected by the user.


    ICRECEIPTS - Used to edit the deletion of an item.

    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.

    ITSERIAL   - Created when items are received as serial number tracked.

    MMDIST     - Holds an account number and possibly an activity code intended
                 for a general ledger distribution of an inventory item.


    MMUAVAL    - This file stores the user analysis values defined for
                 transactions.


    POINTERFAC - Interfaces input from the Inventory Control and Order Entry
                 systems and outside systems into the Purchase Order system.


    POLINE     - Contains purchase order line item information.

    PURCHORDER - Contains header information for each purchase order.

    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.


    RQCOMMENTS - Contains both the header and line comments for a requisition.

    SOHDETAIL  - Used to extract detail quantities.

    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.


    WHDEMNDCMT - Contains comments on the demand records.

    WHDEMNDHDR - Contains document header records.

    WODMNDFCST - This file is used to allow for a source of non-document demand
                 to be used as input into the production scheduling process for
                 work orders.



Referenced Files

    ACACCTCAT  - Used to validate account categories maintained in the Activity
                 Management system.


    ACACTGRP   - Highest reporting level in the Activity Management system.

    ACACTIVITY - Used to validate the activities maintained in the Activity
                 Management system.


    ACCAL      - Contains calendar information from the Activity Management
                 system.


    ACCALX     - Contains detailed calendar information from the Activity
                 Management system.


    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.

    APCPYVND   - Contains default codes assigned to a vendor or alternate
                 vendor location at the company level.


    APHLDINV   - Contains records of vendors, invoices, and payments that are
                 on hold.


    APVENCLASS - A subgroup of vendors that share common payment or processing
                 characteristics, such as office supply vendors or employees.


    APVENGROUP - A group of vendors that can be shared by one or more Accounts
                 Payable companies.


    APVENLOC   - Used to validate the vendor purchase from locations.

    APVENMAST  - Used to validate the vendor numbers.

    BUYER      - Used to validate the buyer codes.

    COMPONENT  - Contains the component items that make up a kit item.

    CUACCT     - This file contains account numbers that variance amounts are
                 posted to when a timing difference occurs between the beginning
                 and the completion of a transaction.


    CUCONV     - Used to obtain currency conversion information.

    CURELAT    - Used to validate currency relationships.

    CUTABLE    - This file defines currency tables.

    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.

    ICRPTGRP   - Used to validate report groups.

    ITEMMAST   - Used to print the item description.

    ITEMSUB    - Stores valid substitutes for an item.

    KITITEM    - Contains those items that are also kits.

    MAJORCL    - Used to validate major classes.

    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.

    POCOMMENTS - Contains all purchase order comments associated with actual
                 and standard purchase orders.


    POCOMPANY  - Used to retrieve Purchase Order historical transactions.

    POITEMVEN  - Used to validate the vendor item number.

    POLOCCON   - Contains a list of valid override contracts for a location.

    POQUOTES   - Used in a Purchase Order common routine.

    POVENDOR   - Used in a Purchase Order common routine.

    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.


    RQTEMPLINE - Contains the items on a requisition template.

    STCOMMCODE - Contains a list of valid standard comment codes used to add
                 comments to a purchase order.


    STPOLINE   - Used to edit the deletion of an item.

    STPURCHORD - Used to obtain standard purchase order information.

    SYSTEMCODE - This file contains system code information used for remote
                 site processing.


    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
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS