Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OECREDOVR


                             OECREDOVR FILE

                      Credit Limit Override Audit

The Credit Limit Override Audit file carries the audit trail for all orders
on credit hold that have been manually taken off credit hold or their credit
hold has been overridden.  A record is created when a user overrides a credit
hold on an order.  Records are reported and purged by running OE284 (Credit
Overrides Report).

REFERENCED BY

OE284

UPDATED BY

OE90.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OCO-COMPANY            Numeric 4                                 OE90.1
Element: Company       This field contains the company number.

OCO-PROCESS-LEVEL      Alpha 5                                   OE90.1
Element: Process Level This field contains the process level.

OCO-OPR-CODE           Alpha 10  (Lower Case)                    OE90.1
Element: Operator Code This field contains the operator code.
                       This is the user ID of the person who
                       last maintained this record.

OCO-CUSTOMER           Alpha 9  (Right Justified)                OE90.1
Element: Customer NumbeThis field contains the number that
                       represents a customer.

OCO-ORDER-NBR          Numeric 8                                 OE90.1
Element: Order Number  This field contains the order number.

OCO-LINE-NBR           Numeric 6                                 OE90.1
Element: Line Number   This field contains the line number.

OCO-OVERRIDE-DT        Numeric 8  (yyyymmdd)                     OE90.1
Element: Date          This field contains the date when the
                       order was released from credit hold.

OCO-OVERRIDE-TM        Numeric 6  (hhmmss)                       OE90.1
Element: Sys Time      This field contains the time when the
                       user released the order from credit
                       hold.

OCO-HOLD-CODE          Alpha 4                                   OE90.1
Element: Hold Code     This field contains the hold code. Hold
                       codes are set up in the Lawson Accounts
                       Receivable system.

OCO-ORDER-AMOUNT       Signed 18.2                               OE90.1
Element: Intl Amt      This field contains the amount of the
                       order.

OCO-CURR-BALANCE       Signed 18.2                               OE90.1
Element: Intl Amt      This field contains the total open
                       balance on the customer's account when
                       this order was placed on hold.

OCO-CREDIT-LIMIT       Numeric 8                                 OE90.1
Element: Credit Limit  This field contains the credit limit of
                       the customer whose order is on hold.

OCO-OPEN-ORDERS        Signed 18.2                               OE90.1
Element: Intl Amt      This field contains the open order
                       total on the customer's account at the
                       time when the order was taken off credit
                       hold.

OCO-ORDER-LIMIT        Numeric 8                                 OE90.1
Element: Order Limit   This field contains the order limit of
                       the customer whose order was placed on
                       hold.

                         OECREDOVR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCOSET1   COMPANY                                                OE284
          PROCESS-LEVEL
          OPR-CODE
          CUSTOMER
          ORDER-NBR
          LINE-NBR
          OVERRIDE-DT
          OVERRIDE-TM

                         OECREDOVR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            OCO-COMPANY          -> ACO-COMPANY

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            OCO-CUSTOMER         -> CUD-CUSTOMER

Custorder      CUSTORDER    Required

                            OCO-COMPANY          -> COR-COMPANY
                            OCO-ORDER-NBR        -> COR-ORDER-NBR

Holdcodes      HOLDCODES    Required

                            ACO-CUST-GROUP       -> HDD-CUST-GROUP
                            OCO-HOLD-CODE        -> HDD-HOLD-CODE

Oecompany      OECOMPANY    Required

                            OCO-COMPANY          -> OEC-COMPANY

Oeproclev      OEPROCLEV    Required

                            OCO-COMPANY          -> OEP-COMPANY
                            OCO-PROCESS-LEVEL    -> OEP-PROCESS-LEVEL

Operator       OPERATOR     Required

                            OCO-COMPANY          -> OPE-DEF-COMPANY
                            OCO-OPR-CODE         -> OPE-OPR-CODE