Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

OE90

OE90.1 - Release Orders On Hold

Use this form to display orders on hold for a specific customer.  You can
remove hold codes on an order-by-order basis.

Updated Files

    COCOMP     - Used to store component information when customer order line
                 is for a kit item.

    COLINE     - Used to store customer order line information.

    COLINEDTL  - Used to store allocated details (lot, serial number, bin, unit
                 of measure quantity)
                 for a customer order line.

    COSGBLK    -

    CUSTORDER  - Primary file maintained by this program. Orders are released
                 from credit hold using this form.

    HOLDCODES  - Used to validate the hold code.  If this is the first time the
                 hold code is
                 referenced, the used flag is set.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOT      - Used to obtain the lot expiration date.

    ICRECEIPTS - Used to record receipts of stock.

    ITEMLOC    - Used to maintain and validate quantity, cost, and reordering
                 information for an inventoried item at a stock location.

    ITSERIAL   - Used to store serial numbers for serial number tracked items.

    OEAUDIT    - Used to store audits of changes to released customer orders
                 and order lines.

    OECREDOVR  - Used to audit credit overrides.  Records a customer's status
                 at the time of
                 the override and the user ID of the person who entered the
                 override.

    POINTAOC   - Used to pass add-on costs for purchase order items that are to
                 be ordered from a vendor rather than filled from stock.

    POINTERFAC - Used to pass purchase order items that are to be ordered from
                 a vendor rather than filled from stock.

    ROUTEDOC   - Used to store total cubic feet, weight, and items for an order
                 on a route.

    ROUTEHDR   - Used to store total cubic feet, weight, and items for a route.

    ROUTESTOP  - Used to store total cubic feet, weight, and items for a route
                 stop.

    SOHDETAIL  - Used to store stock-on-hand details.  Lot, bin, and unit of
                 measure
                 quantities are kept on these records.

    WHDEMAND   - Used to validate the Warehouse demand.

    WHDEMNDCMT - Contains comments for the demand records.  Created from order
                 comments or requisition comments.

    WHDEMNDHDR - Used to validate the Warehouse demand header.


Referenced Files

    AGINGCODE  - Used to validate Accounts Receivable aging code override
                 information.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used to maintain and validate user-defined field information
                 for each customer.

    ARCUSTGRP  - Used to maintain and validate customer group records.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARCUSTTOTS - Used to maintain and validate information on customers'
                 inclusion process levels for invoicing.

    ARLOCKBOX  - Used to maintain and validate lock box record information,
                 including lock box addresses and default process level and cash
                 code information for cash entry.

    ARPAYMENT  - Used to maintain and validate detail payment records entered
                 for a given batch.

    COMPONENT  - Used to obtain Inventory Control definition of components for
                 a kit item.

    CUSTDESC   - Used to validate and maintain customer master records.

    GLCODES    - Used in the General Ledger Account Edit routine.

    ICBIN      - Used to validate Inventory Control bins.

    ICCATEGORY - Used to validate inventory and offset general ledger accounts
                 used to post inventory transactions.

    INSTCTRYCD - Validates the Intrastat country code.

    ITEMMAST   - Used to validate the Inventory Control item.

    KITITEM    - Used to identify kit items.

    NATACCT    - Used to maintain and validate national account records that
                 identify payment relationships between customers.

    NATBALANCE - Used to maintain and validate summary information for a
                 national account customer.
                 Used in the Customer Edit routine.

    OECOMPANY  - Used to validate the Billing company.

    OECUST     - Used to maintain and validate customer order processing
                 information.

    OEFRTCODE  - Used to validate the freight code.  If this is the first time
                 the freight
                 code is referenced, the used flag is set.

    OEPROCLEV  - Used to maintain and validate information on the valid process
                 levels for the Order Entry system.

    OEROUTE    - Used to validate routes.

    OPERATOR   - Used to maintain and validate operator or user ID records.

    ORDERTYPE  - Used to validate the order type.  If this is the first time
                 the order type is referenced, the used flag is set.

    STATICCUST - Used to maintain and validate customer static aging amounts.

    WFSETUP    -

    WHDEMNDCMT - Contains comments for the demand records.  Created from order
                 comments or requisition comments.

    WHPROCTYPE - Used to validate the Warehouse process type.


OE90.2 - Release Order Lines On Hold

With this form, you can display and release order lines that are on hold.

Note:  Removal of the profit margin hold code(s) that you defined using
BL05.1 (Sales Class Accounts) creates an audit record for OE284 (Credit
Overrides Report).

Updated Files

    COLINE     - Primary file maintained by this program.  Order lines are
                 released from credit hold using this screen.

    HOLDCODES  - Used to validate the hold code.  If this is the first time the
                 hold code is
                 referenced, the used flag is set.

    POINTAOC   - Used to pass add-on costs for purchase order items that are to
                 be ordered from a vendor rather than filled from stock.

    POINTERFAC - Used to pass purchase order items that are to be ordered from
                 a vendor rather than filled from stock.

    ROUTEDOC   - Used to store total cubic feet, weight, and items for an order
                 on a route.

    ROUTEHDR   - Used to store total cubic feet, weight, and items for a route.

    ROUTESTOP  - Used to store total cubic feet, weight, and items for a route
                 stop.

    WHDEMAND   - Used to validate the Warehouse demand.

    WHDEMNDCMT - Contains comments for the demand records.  Created from order
                 comments or requisition comments.

    WHDEMNDHDR - Used to validate the Warehouse demand header.


Referenced Files

    AGINGCODE  - Used to validate Accounts Receivable aging code override
                 information.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used to maintain and validate user-defined field information
                 for each customer.

    ARCUSTGRP  - Used to maintain and validate customer group records.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARCUSTTOTS - Used to maintain and validate information on customers'
                 inclusion process levels for invoicing.

    ARLOCKBOX  - Used to maintain and validate lock box record information,
                 including lock box addresses and default process level and cash
                 code information for cash entry.

    ARPAYMENT  - Used to maintain and validate detail payment records entered
                 for a given batch.

    CUCONV     - Used to access general ledger and currency information.

    CURELAT    - Used to validate currency relationships.

    CUSTDESC   - Used to validate and maintain customer master records.

    CUSTORDER  - Stores a record for every order entered in the Order Entry
                 system.

    GLSYSTEM   - Used to validate the General Ledger company.

    ICCOMPANY  - Used to validate the Inventory Control company.

    INSTCTRYCD - Validates the Intrastat country code.

    ITEMLOC    - Used to maintain and validate quantity, cost, and reordering
                 information for an inventoried item at a stock location.

    ITEMMAST   - Used to validate the Inventory Control item.

    NATACCT    - Used to maintain and validate national account records that
                 identify payment relationships between customers.

    NATBALANCE - Used to maintain and validate summary information for a
                 national account customer.

    OECOMPANY  - Used to validate the Billing company.

    OECUST     - Used to maintain and validate customer order processing
                 information.

    OEPROCLEV  - Used to maintain and validate information on the valid process
                 levels for the Order Entry system.

    OEROUTE    - Used to validate routes.

    OESLSACCT  - Used to validate sales class accounts.

    OPERATOR   - Used to maintain and validate operator or user ID records.

    STATICCUST - Used to maintain and validate customer static aging amounts.

    WHDEMNDCMT - Contains comments for the demand records.  Created from order
                 comments or requisition comments.

    WHPROCTYPE - Used to validate the Warehouse process type.


INVOKED Programs

    IFSG