OEORDDISC

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 WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OOD-COMPANY
Element: Company
Numeric 4
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
Element: Ord Disc Code
Alpha 4
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
Element: Currency Code
Alpha 5
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
Element: Description
Alpha 30 (Lower Case)
The description explaining the order discount code.
OOD-ACCT-UNIT
Element: Acct Unit
Alpha 15
The general ledger account unit that will be debited when an order discount is created.
OOD-ACCOUNT
Element: Account
Numeric 6
General ledger account number debited when the discount is calculated.
OOD-SUB-ACCT
Element: Sub Acct
Numeric 4
General ledger subaccount number debited when the discount is calculated.
OOD-DOLLAR-LIMIT
Element: Dollar Limit
Numeric 11 Occurs 6 Times
Amount indicating how much the order amount should be before the associated discount is assessed.
OOD-PCT
Element: Pct
Percent 5.2 (Percent) Occurs 6 Times
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
ORD-DISC-CODE
CURRENCY-CODE
AR08.1 AR10.1
AR501 AR550
WH20.2 WH20.7


OEORDDISC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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->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


File created: Thu Jun 09 02:09:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.