Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEORDDISC


                             OEORDDISC FILE

                             Order Discount

This file stores the order discounts that have been assessed.  Order
discounts are set up in the Lawson Order Entry system and are placed onto the
customer master accounts indicating that those customers will have the
percentage associated with the order discount code discounted from their
orders.

REFERENCED BY

AR08.1    AR10.1    AR501     AR550     WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OOD-COMPANY            Numeric 4
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

OOD-ORD-DISC-CODE      Alpha 4
Accounts Receivable    This order discount code is user
Code                   defined and is designed to be added to
                       the customer master accounts indicating
                       which customers are to be affected by
                       the discount rules tied to the code. The
                       discounts are assessed on the order
                       amount as a whole.

OOD-CURRENCY-CODE      Alpha 5
Element: Currency Code This is the currency code the system
                       will use when assessing the order
                       discount. The discount must use the same
                       currency code as the order.

OOD-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   The description explaining the order
                       discount code.

OOD-ACCT-UNIT          Alpha 15
Element: Accounting UniThe general ledger account unit that
                       will be debited when an order discount
                       is created.

OOD-ACCOUNT            Numeric 6
Element: Account       General ledger account number debited
                       when the discount is calculated.

OOD-SUB-ACCT           Numeric 4
Element: Subaccount    General ledger subaccount number
                       debited when the discount is calculated.

OOD-DOLLAR-LIMIT       Numeric 11 Occurs 6 Times
Element: Dollar Limit  Amount indicating how much the order
                       amount should be before the associated
                       discount is assessed.

OOD-PCT                Percent 5.2  (Percent) Occurs 6 Times
Element: Percent       The order discount percentage to be
                       used when the order dollar amount is
                       exceeded.

                         OEORDDISC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OODSET1   COMPANY                                                AR08.1  AR10.1
          ORD-DISC-CODE                                          AR501   AR550
          CURRENCY-CODE                                          WH20.2  WH20.7

                         OEORDDISC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cucodes        CUCODES      Required
                            When OOD-CURRENCY-CODE != Spaces

                            OOD-CURRENCY-CODE    -> -CURRENCY-CODE

Glchartdtl     GLCHARTDTL   Not Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            GLM-SUMM-ACCT-ID     -> GDT-SUMRY-ACCT-ID
                            OOD-ACCOUNT          -> GDT-ACCOUNT
                            OOD-SUB-ACCT         -> GDT-SUB-ACCOUNT

Glmaster       GLMASTER     Required

                            OOD-COMPANY          -> GLM-COMPANY
                            OOD-ACCT-UNIT        -> GLM-ACCT-UNIT
                            OOD-ACCOUNT          -> GLM-ACCOUNT
                            OOD-SUB-ACCT         -> GLM-SUB-ACCOUNT

Glsystem       GLSYSTEM     Required

                            OOD-COMPANY          -> GLS-COMPANY

Oecompany      OECOMPANY    Required

                            OOD-COMPANY          -> OEC-COMPANY