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 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.
OED-DISC-CODE Element: Discount Code	Alpha 10 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 Element: Pct	Percent 5.2 (Percent) Occurs 3 Times Enter the percent to be used in calculating the order line discount.
OED-APP-GROSS-FL Element: All Flag	Alpha 1 Occurs 3 Times 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 Element: Acct Unit	Alpha 15 Occurs 3 Times The general ledger account unit that will be debited when a discount is created by the system using this discount reason code.
OED-ACCOUNT Element: Account	Numeric 6 Occurs 3 Times 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 Element: Sub Acct	Numeric 4 Occurs 3 Times 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 Element: Description	Alpha 30 (Lower Case) 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 Element: Active Flag	Alpha 1 This flag indicates whether the discount code is active or not. A = Active I = Inactive
OED-USED-FL Element: Used Fl	Alpha 1 Indicates if the discount code has been used or not. Y = Yes N = No
OED-PCT-1 Element: Pct 1	Derived The first percent discount to be calculated when this order discount reason code is used.
OED-PCT-2 Element: Pct 2	Derived The second percent discount to be calculated for this discount reason code.
OED-PCT-3 Element: Pct 3	Derived The third percent discount to be calculated for this discount reason code.
OED-APP-GR-FL-1 Element: App Gr Fl 1	Derived Flag indicating whether the first discount percent should be applied to the full amount of the order.
OED-APP-GR-FL-2 Element: App Gr Fl 2	Derived 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 Element: App Gr Fl 3	Derived 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 Element: Acct Unit 1	Derived This is the first general ledger discount account that will be debited when a discount is given.
OED-ACCT-UNIT-2 Element: Acct Unit 2	Derived This is the second general ledger account unit that will be debited if the second discount percent is calculated.
OED-ACCT-UNIT-3 Element: Acct Unit 3	Derived This is the third general ledger account unit that will be debited if the third discount line is calculated.
OED-ACCOUNT-1 Element: Account 1	Derived This is the first general ledger account number that will be debited when the first discount line is calculated.
OED-ACCOUNT-2 Element: Account 2	Derived This is the second general ledger account number that will be debited if the second discount line is calculated.
OED-ACCOUNT-3 Element: Account 3	Derived This is the general ledger account number that will be debited when the third discount line is calculated.
OED-SUB-ACCOUNT-1 Element: Sub Account 1	Derived This is the general ledger subaccount number that is debited when the first discount line is calculated.
OED-SUB-ACCOUNT-2 Element: Sub Account 2	Derived This is the general ledger subaccount number that is debited when the second discount line is calculated.
OED-SUB-ACCOUNT-3 Element: Sub Account 3	Derived This is the general ledger subaccount number that is debited when the third discount line is calculated.
OED-INVC-DESC-1 Element: Invc Desc 1	Derived This is the description of the first discount line that will print on the invoice.
OED-INVC-DESC-2 Element: Invc Desc 2	Derived This is the description of the second discount line that will print on the invoice.
OED-INVC-DESC-3 Element: Invc Desc 3	Derived This is the description of the third discount line that will print on the invoice.

OEDISCOUNT FILE INDEX

OEDISCOUNT FILE RELATIONS

ONE TO ONE RELATIONS

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