|
|
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 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL243 BL244 BL245 BL246 BL247
BL29.1 BL29.2 BL520 BL820 BL85.1 BL85.2
BL90.1 BL92.1 BL940 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 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE283 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE810 OE830 OE920 OE950 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
Company The company number represents an
established company and is entered on
all function codes.
OED-DISC-CODE Alpha 10 BL44.1
Disc 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
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
App Gross Fl 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
Accounting Unit The 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
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
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
Invoice Type Occurs 3 Times BL247 BL44.1
Description 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
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
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
Pct 1 The first percent discount to be
calculated when this order discount
reason code is used.
OED-PCT-2 Derived
Pct 2 The second percent discount to be
calculated for this discount reason
code.
OED-PCT-3 Derived
Pct 3 The third percent discount to be
calculated for this discount reason
code.
OED-APP-GR-FL-1 Derived
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
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
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
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
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
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
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
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
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
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
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
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
Invc Desc 1 This is the description of the first
discount line that will print on the
invoice.
OED-INVC-DESC-2 Derived
Invc Desc 2 This is the description of the second
discount line that will print on the
invoice.
OED-INVC-DESC-3 Derived
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 BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL243
BL244 BL245
BL246 BL247
BL29.1 BL29.2
BL44.1 BL45.1
BL45.2 BL45.3
BL46.1 BL46.2
BL46.3 BL47.1
BL47.2 BL47.3
BL520 BL820
BL85.1 BL85.2
BL90.1 BL92.1
...
OEDISCOUNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OED-COMPANY -> OEC-COMPANY
|