|
|
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 BL245 BL246
BL247 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 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 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE283 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
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 BL245 BL246
Element: Percent Enter the percent to be used in BL247 BL44.1
calculating the order line discount.
OED-APP-GROSS-FL Alpha 1 Occurs 3 Times BL246 BL247
Element: All Flag Indicates whether the second and third BL44.1
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 BL246 BL247
Element: Accounting UniThe general ledger account unit that BL44.1
will be debited when a discount is
created by the system using this
discount reason code.
OED-ACCOUNT Numeric 6 Occurs 3 Times BL246 BL247
Element: Account The general ledger account number that BL44.1
will be debited when a discount is
created by the system for this discount
reason code.
OED-SUB-ACCOUNT Numeric 4 Occurs 3 Times BL246 BL247
Element: Subaccount This is the general ledger subaccount BL44.1
that is debited when a discount is
created by the system for this discount
reason code.
OED-INVC-DESC Alpha 30 (Lower Case) BL245 BL246
Element: Description Occurs 3 Times BL247 BL44.1
The description of the discount that BL45.1 BL45.2
will print out on the invoice. If this BL45.3 BL46.2
description is identical for all three BL46.3 BL47.1
discount accounts, the system will roll BL47.2 BL47.3
the three discounts into one line and
description when printing on the
invoice.
OED-ACTIVE-FLAG Alpha 1 BL44.1
Element: Status 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 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
BL245 BL246
BL247 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
...
OEDISCOUNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OED-COMPANY -> OEC-COMPANY
|
