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
Company              This field contains the company number.

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

OCO-OPR-CODE         Alpha 10  (Lower Case)                      OE90.1
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
Customer             This field contains the number that
                     represents a customer.

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

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

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

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

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

OCO-ORDER-AMOUNT     Signed 15.2                                 OE90.1
Order Amount         This field contains the amount of the
                     order.

OCO-CURR-BALANCE     Signed 15.2                                 OE90.1
Current Balance      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
Credit Limit         This field contains the credit limit of
                     the customer whose order is on hold.

OCO-OPEN-ORDERS      Signed 15.2                                 OE90.1
Open Orders          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
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