Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACDISCDTL


                             ACDISCDTL FILE

UPDATED BY

AC300     AC310

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DSL-ACTIVITY           Alpha 15
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


DSL-ACCT-CATEGORY      Alpha 5
Element: Account CategoAccount categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

DSL-ACCT-CAT-CLASS     Alpha 5
Element: Acct Cat Class

DSL-MATRIX-CAT         Alpha 12
Element: Attribute     Attribute name assigned to an object
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

DSL-MX-VALUE           Alpha 32
Element: Attribute Value

DSL-DISC-PERCENT       Percent 15.2  (Percent)
Element: Disc Percent

DSL-EFFECTIVE-LVL      Numeric 15
Element: Effective Lvl

DSL-AMOUNT             Currency 15.2
Element: Amount        This is the amounts by period for the
                       specified record.

DSL-UNIT               Signed 15.2
Element: Unit

DSL-MAX-DISCOUNT       Signed 15.2
Element: Max Discount

DSL-TOT-DISCOUNT       Signed 15.2
Element: Tot Discount

                         ACDISCDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DSLSET1   ACTIVITY                                               AC300   AC310
          ACCT-CATEGORY
          ACCT-CAT-CLASS
          MATRIX-CAT
          MX-VALUE

                         ACDISCDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            DSL-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Acacctclss     ACACCTCLSS   Required

                            DSL-ACCT-CAT-CLASS    -> AXA-ACCT-CAT-CLASS

Acactivity     ACACTIVITY   Required

                            DSL-ACTIVITY          -> ACV-ACTIVITY