|
|
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
BL00.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL243 BL244 BL29.1 BL29.2
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.3
BL32.4 BL520 BL820 BL85.1 BL85.2 BL90.1
BL92.1 WH20.2 WH20.7
UPDATED BY
BL44.1 BL45.1 BL45.2 BL45.3 BL46.1 BL46.2
BL46.3 BL47.1 BL47.2 BL47.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OED-COMPANY Numeric 4 BL44.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.
OED-DISC-CODE Alpha 10 BL44.1
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 BL44.1
Element: Pct Enter the percent to be used in
calculating the order line discount.
OED-APP-GROSS-FL Alpha 1 Occurs 3 Times BL44.1
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 BL44.1
Element: Acct Unit The 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 BL44.1
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 BL44.1
Element: Sub Acct 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) BL44.1 BL45.1
Element: Description Occurs 3 Times BL45.2 BL45.3
The description of the discount that BL46.2 BL46.3
will print out on the invoice. If this BL47.1 BL47.2
description is identical for all three BL47.3
discount accounts, the system will roll
the three discounts into one line and
description when printing on the
invoice.
OED-ACTIVE-FLAG Alpha 1 BL44.1
Element: Active Flag This flag indicates whether the
discount code is active or not.
A = Active
I = Inactive
OED-USED-FL Alpha 1 BL44.1 BL45.1
Element: Used Fl Indicates if the discount code has been BL45.2 BL45.3
used or not. BL46.1 BL46.2
Y = Yes BL46.3 BL47.1
N = No BL47.2 BL47.3
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 BL00.1 BL120
DISC-CODE BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL243 BL244
BL29.1 BL29.2
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL44.1
BL45.1 BL45.2
BL45.3 BL46.1
BL46.2 BL46.3
BL47.1 BL47.2
BL47.3 BL520
...
OEDISCOUNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OED-COMPANY -> OEC-COMPANY
|
