|
|
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 AR501 AR550 BL120 BL122
BL123 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE111 OE113 OE114 OE129 OE13.2 OE13.3
OE13.5 OE14.4 OE259 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE810 OE830 WH20.2 WH20.7
UPDATED BY
OE59.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOD-COMPANY Numeric 4 OE59.1
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 OE59.1
Element: Order DiscountThis 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 OE59.1
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) OE59.1
Element: Description The description explaining the order
discount code.
OOD-ACCT-UNIT Alpha 15 OE59.1
Element: Accounting UniThe general ledger account unit that
will be debited when an order discount
is created.
OOD-ACCOUNT Numeric 6 OE59.1
Element: Account General ledger account number debited
when the discount is calculated.
OOD-SUB-ACCT Numeric 4 OE59.1
Element: Subaccount General ledger subaccount number
debited when the discount is calculated.
OOD-DOLLAR-LIMIT Numeric 11 Occurs 6 Times OE59.1
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 OE59.1
Element: 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 AR10.1
ORD-DISC-CODE AR501 AR550
CURRENCY-CODE BL120 BL122
BL123 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
...
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
|
