Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

RQ13

RQ13.1 - Direct Approval

Use this form to bypass Enterprise Workflow and manually approve a
requisition.

Updated Files

    ACCOMMIT   - This file contains commitment information.

    ACCOMMITX  - This field contains commitment information.

    CKPOINT    - 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 number, or multiple unit of measure.

    ICCOMPANY  - 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 stock location.

    ITSERIAL   - Stores the valid serial numbers currently in stock and issued.

    MMDIST     - This record holds an account number and possibly an activity
                 code intended for a general ledger distribution of an
                 non-inventory item.

    REQHEADER  - Contains the header information for each requisition.

    REQLINE    - 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.

    RQAPPROVE  - Contains open approval records that need approval because the
                 approval amount level is less than the requisition total value.


    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 - Used to create or update a Warehouse system demand header
                 record. The Demand Header file contains document header
                 records.


Referenced Files

    ACACCTCAT  - This file contains the account category information.

    ACACTGRP   - This file contains information about activity group set up and
                 definitions.

    ACACTIVITY - This file contains information about activity set up and
                 definitions.

    ACCAL      - This file contains calendar information.

    ACCALX     - This file contains detailed calendar information.

    AMASSET    - This file store asset records.

    AMTEMPLATE - This file contains asset template information.

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

    CUCONV     - This file maintains rate tables for each defined currency
                 relationship.

    CURELAT    - This file contains the valid currency relationships used for a
                 specific currency table.

    GLADDRESS  - This file contains the name, address, and communication
                 numbers for the company and necessary accounting units.

    GLCHART    - This file contains chart and system account information in the
                 General Ledger system.

    GLCODES    - Holds information relating to systems, source codes, folders
                 and process groups.

    GLINTCO    - This file contains interzone and intercompany relationships.
                 ~11RQ13 1GLSYSTEM                (Referenced)
                 Contains company information used primarily by the General
                 Ledger, but the file is also referenced by LAWSON INSIGHT
                 subsystems.

    GLSYSTEM   - This file contains company information used by the Lawson
                 General Ledger system and subsystems.

    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 general ledger 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    - Contains the valid kit or parent items for a kit or assembly.

    OEFRTCODE  - Contains freight codes that can be used in the Order Entry
                 system.

    OEROUTE    - Contains all user-defined routes that are set up in the Order
                 Entry system.

    ORDERTYPE  - The Order Type file stores order type parameters.

    RQAPPROVE  - Contains open approval records that need approval because the
                 approval amount level is less than the requisition total value.


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

    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.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS