Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

RQ961

RQ961 - 61 to 70 REQLINE Load

Run RQ961 to upgrade Requisition Line data from the 6.1 Healthcare Release to
7.0.

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     - The Demand Line Kit Components file contains the kit
                 components that make up a line on a document.

    COLINEDTL  - The Order Line Allocated Details file contains line allocation
                 information created when the item is tracked by bin, lot,
                 serial, or multiple unit of measure.

    ICCOMPANY  - This file is used to validate the company number.

    ICLOT      - The Lots with Expire Date/On Hold file stores the expiration
                 dates and/or the hold flag for lots.

    ICRECEIPTS - The cost history file is used for LIFO and FIFO costing.

    ITEMLOC    - The Item Location file contains the dynamic information for an
                 inventoried item at a stocking location.

    ITSERIAL   - This file stores the valid serial numbers currently in stock
                 and issued.

    REQHEADER  - This file contains the header information for each
                 requisition.

    REQLINE    - This file contains the line item information for the
                 requisition.

    ROUTEDOC   - The Route Document file contains documents that are to be
                 delivered along a route.

    ROUTEHDR   - For all routes created, the system added a header record to
                 the Route Header file.

    ROUTESTOP  - The Route Stop file contains records set up to identify the
                 stops along a route.

    SOHDETAIL  - The Stock On Hand Detail File contains the detail quantities
                 for an item at a location for items controlled by bin or
                 lot/sublot or multiple units of measure.

    WHDEMAND   - The Demand file contains all the records that the Warehouse
                 system needs for processing demands.

    WHDEMNDCMT - Referenced by warehouse API's that validate item type.

    WHDEMNDHDR - The Demand Header file contains document header records.


Referenced Files

    ACACTREL   - This file is used in conversion of non-Lawson activity
                 information to the Activity Management system.

    COMPONENT  - This file contains the component items that make up a kit
                 item.

    GLCODES    - This file holds information relating to systems, source codes,
                 folders and process groups.

    ICBIN      - The Bin Numbers file is a master list of valid bin numbers in
                 a location used for tracking items by bin.

    ICCATEGORY - The GL Account Category file is a master file which defines
                 the Inventory and offset GL accounts used to post inventory
                 transactions.

    ITEMMAST   - The Item Master file stores static information about each item
                 such as description, classes, units of measure, and weight.

    KITITEM    - This file contains the valid kit or parent items for a kit or
                 assembly.

    OEFRTCODE  - This file contains freight codes that can be used in the
                 Lawson Order Entry system.

    OEROUTE    - This file contains all user-defined routes that are set up in
                 the Lawson Order Entry system.

    ORDERTYPE  - The Order Type file stores order type parameters.

    RQLOC      - This file contains the valid requesting locations for the
                 company.

    WHDEMNDCMT - Referenced by warehouse API's that validate item type.

    WHPROCTYPE - The Shipment Process Type file contains process type records
                 used for determining the steps an order is to take in the
                 Warehouse system.