|
|
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 AR10.1 AR120 AR501 AR550 BL120
BL122 BL123 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOD-COMPANY Numeric 4
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OOD-ORD-DISC-CODE Alpha 4
Element: Ord Disc 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
Element: 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)
Element: Description The description explaining the order
discount code.
OOD-ACCT-UNIT Alpha 15
Element: Acct Unit The general ledger account unit that
will be debited when an order discount
is created.
OOD-ACCOUNT Numeric 6
Element: Account General ledger account number debited
when the discount is calculated.
OOD-SUB-ACCT Numeric 4
Element: Sub Acct General ledger subaccount number
debited when the discount is calculated.
OOD-DOLLAR-LIMIT Numeric 11 Occurs 6 Times
Element: 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
Element: Pct 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 AR10.1
ORD-DISC-CODE AR120 AR501
CURRENCY-CODE AR550 BL120
BL122 BL123
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.2 WH20.7
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 -> -CURRENCY-CODE
Glchartdtl GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
GLM-SUMM-ACCT-ID -> GDT-SUMRY-ACCT-ID
OOD-ACCOUNT -> GDT-ACCOUNT
OOD-SUB-ACCT -> GDT-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
|
