OEORDDISC FILE
Order Discount
This file stores the order discounts that have been assessed. Order
discounts are set up in the Lawson Order Entry system and are placed onto the
customer master accounts indicating that those customers will have the
percentage associated with the order discount code discounted from their
orders.
REFERENCED BY
AR08.1 AR501 AR550 BL123
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOD-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OOD-ORD-DISC-CODE Alpha 4
Order Discount Code This order discount code is user
defined and is designed to be added to
the customer master accounts indicating
which customers are to be affected by
the discount rules tied to the code. The
discounts are assessed on the order
amount as a whole.
OOD-CURRENCY-CODE Alpha 5
Currency Code This is the currency code the system
will use when assessing the order
discount. The discount must use the same
currency code as the order.
OOD-DESCRIPTION Alpha 30 (Lower Case)
Description The description explaining the order
discount code.
OOD-ACCT-UNIT Alpha 15
Accounting Unit The general ledger account unit that
will be debited when an order discount
is created.
OOD-ACCOUNT Numeric 6
Account General ledger account number debited
when the discount is calculated.
OOD-SUB-ACCT Numeric 4
Subaccount General ledger subaccount number
debited when the discount is calculated.
OOD-DOLLAR-LIMIT Numeric 11 Occurs 6 Times
Dollar Limit Amount indicating how much the order
amount should be before the associated
discount is assessed.
OOD-PCT Percent 5.2 (Percent) Occurs 6 Times
Percent The order discount percentage to be
used when the order dollar amount is
exceeded.
OEORDDISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OODSET1 COMPANY AR08.1 AR501
ORD-DISC-CODE AR550 BL123
CURRENCY-CODE
OEORDDISC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cucodes CUCODES Required
When OOD-CURRENCY-CODE != Spaces
OOD-CURRENCY-CODE -> CUC-CURRENCY-CODE
Glchartdtl GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GLM-SUMM-ACCT-ID -> x u u ( -SUMRY-ACCT-ID
OOD-ACCOUNT -> x u u ( -ACCOUNT
OOD-SUB-ACCT -> x u u ( -SUB-ACCOUNT
Glmaster GLMASTER Required
OOD-COMPANY -> GLM-COMPANY
OOD-ACCT-UNIT -> GLM-ACCT-UNIT
OOD-ACCOUNT -> GLM-ACCOUNT
OOD-SUB-ACCT -> GLM-SUB-ACCOUNT
Glsystem GLSYSTEM Required
OOD-COMPANY -> GLS-COMPANY
Oecompany OECOMPANY Required
OOD-COMPANY -> OEC-COMPANY
|
