|
|
OEDISCOUNT FILE
Discount Code
Discount codes and their associated discount logic are stored in this file.
These codes are designed to be used on the pricing modifiers (price list,
promotion, and contract). When a discount code is assigned to a price
modifier, each item priced using that modifier will be affected by the
discount. Each discount code can specify up to three separate discount
percentages. These percentages can be applied either to an item gross price,
or to an item price less any discount percentages already applied.
REFERENCED BY
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OED-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
OED-DISC-CODE Alpha 10
Element: Discount Code User-defined discount code to be used
on any of the price modifiers: the price
list, promotion, or contract parameters.
If this discount code is placed on any
of the price modifiers, all items priced
with that modifier will be affected by
this discount code.
OED-PCT Percent 5.2 (Percent) Occurs 3 Times
Element: Percent Enter the percent to be used in
calculating the order line discount.
OED-APP-GROSS-FL Alpha 1 Occurs 3 Times
Element: All Flag Indicates whether the second and third
discounts taken should be calculated
from the gross amount of the order or
the net amount after the previous
discount has been subtracted from the
gross amount.
Y = Yes
N = No
OED-ACCT-UNIT Alpha 15 Occurs 3 Times
Element: Accounting UniThe general ledger account unit that
will be debited when a discount is
created by the system using this
discount reason code.
OED-ACCOUNT Numeric 6 Occurs 3 Times
Element: Account The general ledger account number that
will be debited when a discount is
created by the system for this discount
reason code.
OED-SUB-ACCOUNT Numeric 4 Occurs 3 Times
Element: Subaccount This is the general ledger subaccount
that is debited when a discount is
created by the system for this discount
reason code.
OED-INVC-DESC Alpha 30 (Lower Case)
Element: Description Occurs 3 Times
The description of the discount that
will print out on the invoice. If this
description is identical for all three
discount accounts, the system will roll
the three discounts into one line and
description when printing on the
invoice.
OED-ACTIVE-FLAG Alpha 1
Element: Status This flag indicates whether the
discount code is active or not.
A = Active
I = Inactive
OED-USED-FL Alpha 1
Element: Used Indicates if the discount code has been
used or not.
Y = Yes
N = No
OED-PCT-1 Derived
Element: Pct 1 The first percent discount to be
calculated when this order discount
reason code is used.
OED-PCT-2 Derived
Element: Pct 2 The second percent discount to be
calculated for this discount reason
code.
OED-PCT-3 Derived
Element: Pct 3 The third percent discount to be
calculated for this discount reason
code.
OED-APP-GR-FL-1 Derived
Element: App Gr Fl 1 Flag indicating whether the first
discount percent should be applied to
the full amount of the order.
OED-APP-GR-FL-2 Derived
Element: App Gr Fl 2 Flag indicating whether the second
discount percent should be calculated
from the gross order amount or the net
order amount (subtracting previous
discounts).
OED-APP-GR-FL-3 Derived
Element: App Gr Fl 3 Flag indicating whether the third
discount should be calculated from the
gross order amount or the net order
amount (subtracting previous discount
amounts).
OED-ACCT-UNIT-1 Derived
Element: Acct Unit 1 This is the first general ledger
discount account that will be debited
when a discount is given.
OED-ACCT-UNIT-2 Derived
Element: Acct Unit 2 This is the second general ledger
account unit that will be debited if the
second discount percent is calculated.
OED-ACCT-UNIT-3 Derived
Element: Acct Unit 3 This is the third general ledger
account unit that will be debited if the
third discount line is calculated.
OED-ACCOUNT-1 Derived
Element: Account 1 This is the first general ledger
account number that will be debited when
the first discount line is calculated.
OED-ACCOUNT-2 Derived
Element: Account 2 This is the second general ledger
account number that will be debited if
the second discount line is calculated.
OED-ACCOUNT-3 Derived
Element: Account 3 This is the general ledger account
number that will be debited when the
third discount line is calculated.
OED-SUB-ACCOUNT-1 Derived
Element: Sub Account 1 This is the general ledger subaccount
number that is debited when the first
discount line is calculated.
OED-SUB-ACCOUNT-2 Derived
Element: Sub Account 2 This is the general ledger subaccount
number that is debited when the second
discount line is calculated.
OED-SUB-ACCOUNT-3 Derived
Element: Sub Account 3 This is the general ledger subaccount
number that is debited when the third
discount line is calculated.
OED-INVC-DESC-1 Derived
Element: Invc Desc 1 This is the description of the first
discount line that will print on the
invoice.
OED-INVC-DESC-2 Derived
Element: Invc Desc 2 This is the description of the second
discount line that will print on the
invoice.
OED-INVC-DESC-3 Derived
Element: Invc Desc 3 This is the description of the third
discount line that will print on the
invoice.
OEDISCOUNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEDSET1 COMPANY WH20.2 WH20.7
DISC-CODE
OEDISCOUNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OED-COMPANY -> OEC-COMPANY
|
