Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEDISCOUNT

                            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