Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCEILINGX


                            ACCEILINGX FILE

UPDATED BY

AC300     AC310     BR00.3    BR120     BR122     BR130
BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR530

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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


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

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

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

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

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

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

CEX-TOT-BILLED-AMT     Signed 15.2                               AC300   BR122
Element: Tot Billed Amt                                          BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5

CEX-TOT-BILLED-UNT     Signed 15.2                               AC300   BR122
Element: Tot Billed Unt                                          BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5

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

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

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

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

CEX-APPLY-TOL-AMT      Signed 15.2                               AC300   BR130
Element: Apply Tol Amt                                           BR530

CEX-APPLY-TOL-UNIT     Signed 15.2                               AC300
Element: 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                                         BR122   BR130
          MATRIX-CAT                                             BR20.1  BR20.2
          MX-VALUE                                               BR20.3  BR20.4
                                                                 BR20.5  BR530

                         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