Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACCEILINGX FILE

UPDATED BY

AC300     AC310     BR00.3    BR120     BR21.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CEX-ACTIVITY         Alpha 15                                    BR00.3
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.


CEX-ACCT-CATEGORY    Alpha 5                                     BR00.3
Account Category     Account 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.

CEX-ACCT-CAT-CLASS   Alpha 5                                     BR00.3
Acct Cat Class

CEX-MATRIX-CAT       Alpha 12                                    BR00.3
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.

CEX-MX-VALUE         Alpha 32                                    BR00.3
Attribute Value

CEX-CEILING-AMT      Signed 15.2                                 BR00.3
Ceiling Amt

CEX-CEILING-UNIT     Signed 15.2                                 BR00.3
Ceiling Unit

CEX-TOT-BILLED-AMT   Signed 15.2                                 AC300   BR21.1
Tot Billed Amt

CEX-TOT-BILLED-UNT   Signed 15.2                                 AC300   BR21.1
Tot Billed Unt

CEX-TOT-REV-AMT      Signed 15.2                                 AC300
Tot Rev Amt

CEX-TOT-REV-UNIT     Signed 15.2                                 AC300
Tot Rev Unit

CEX-TOLERANCE-AMT    Signed 15.2                                 BR00.3
Tolerance Amt

CEX-TOLERANCE-UNIT   Signed 15.2                                 BR00.3
Tolerance Unit

CEX-APPLY-TOL-AMT    Signed 15.2
Apply Tol Amt

CEX-APPLY-TOL-UNIT   Signed 15.2
Apply Tol Unit

                         ACCEILINGX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CEXSET1   ACTIVITY                                               AC300   AC310
          ACCT-CATEGORY                                          BR00.3  BR120
          ACCT-CAT-CLASS                                         BR21.1
          MATRIX-CAT
          MX-VALUE

                         ACCEILINGX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            CEX-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Acacctclss     ACACCTCLSS   Required

                            CEX-ACCT-CAT-CLASS    -> AXA-ACCT-CAT-CLASS

Acactivity     ACACTIVITY   Required

                            CEX-ACTIVITY          -> ACV-ACTIVITY

Acceiling      ACCEILING    Required

                            CEX-ACTIVITY          -> CEH-ACTIVITY
                            CEX-ACCT-CATEGORY     -> CEH-ACCT-CATEGORY
                            CEX-ACCT-CAT-CLASS    -> CEH-ACCT-CAT-CLASS
                            CEX-MATRIX-CAT        -> CEH-MATRIX-CAT

Mxcatdef       MXCATDEF     Required

                            CEX-MATRIX-CAT        -> MXC-MATRIX-CAT