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
|
