Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ACLEVEL FILE

                            Activity Levels

This file contains information on variable levels from AC10.1 (Activity). It
includes level, level depth, activity level detail, and posting flag.

REFERENCED BY

AC01.1    AC105     AC11.1    AC112     AC121     AC123
AC127     AC13.2    AC13.3    AC130     AC160     AC165
AC170     AC190     AC191     AC196     AC198     AC20.1
AC20.2    AC20.3    AC20.4    AC20.5    AC20.7    AC203
AC206     AC207     AC210     AC213     AC218     AC22.1
AC220     AC240     AC256     AC258     AC261     AC265
AC27.1    AC29.1    AC290     AC295     AC297     AC298
AC30.1    AC30.2    AC30.3    AC30.4    AC32.1    AC34.1
AC35.1    AC36.1    AC40.1    AC40.4    AC400     AC401
AC41.1    AC41.4    AC410     AC412     AC42.1    AC420
AC421     AC440     AC45.1    AC460     AC471     AC472
AC473     AC480     AC490     AC493     AC494     AC50.1
AC530     AC54.1    AC54.2    AC54.3    AC540     AC541
AC542     AC55.1    AC550     AC551     AC65.1    AC65.2
AC66.1    AC70.1    AC70.4    AC720     AC741     AC750
AC90.1    AC90.2    AC90.4    AC90.6    AC90.8    AC92.1
AC92.2    AC92.4    AC92.6    AC93.1    AC93.2    AC93.3
AC93.4    AC93.5    AC94.1    AC94.2    AC94.4    AC94.6
AC95.1    AC95.2    AC95.4    AC95.6    AC97.1    AC97.2
AC97.4    AC97.6    ACAC.1    ACBA.1    ACDL.1    ACDR.1
ACVW.1    GR741     SE90.1    AR250     AR251     AR30.1
AR30.2    AR30.3    AR30.5    BR00.1    BR00.2    BR00.3
BR01.2    BR01.3    BR02.1    BR02.3    BR03.1    BR03.2
BR03.3    BR05.1    BR05.2    BR05.3    BR05.4    BR05.5
BR10.1    BR120     BR121     BR142     BR200     BR202
BR204     BR205     BR210     BR220     BR265     BR40.3
BR400     BR405     BR41.1    BR420     BR430     BR450
BR65.1    BR65.2    BRCC.1    MX123     MX223     MX500

UPDATED BY

AC10.1    AC110     AC120     AC300     AC310     AC500

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

LVL-ACTIVITY-GRP     Alpha 15                                    AC10.1  AC110
Activity Group       Required key. This is the activity          AC120   AC500
                     group for the activity.

LVL-VAR-LEVELS       Alpha 30                                    AC10.1  AC110
Variable Levels      Required key. Levels define an              AC120   AC500
                     addressing system that organizes
                     activities into a reporting hierarchy.
                     Level names are defined for an activity
                     group and should be able to be used
                     across all activities in an activity
                     group. Levels facilitate rollup or
                     consolidation of budgets, costs, and
                     revenues from activities at lower levels
                     to macro activities at a higher level
                     within the hierarchy.

LVL-ACTIVITY         Alpha 15                                    AC10.1  AC110
Activity             This is the activity for the levels.        AC500

LVL-POSTING-FLAG     Alpha 1                                     AC10.1  AC110
Posting Flag         This field indicates whether this level     AC400   AC493
                     is the posting or the summary level.        AC494   AC500
                     Posting should be done at the lowest
                     level and summary at the higher levels.
                     P = Posting
                     S = Summary
                     C = Contract

LVL-VAR-LEVEL-DISP   Alpha 34                                    AC10.1  AC110
Variable Level       The level structure for the activity        AC120   AC500
Display              displays.

LVL-LEVEL-DEPTH      Numeric 1                                   AC10.1  AC110
Level Depth          This is the number of variable levels       AC120   AC500
                     pertaining to this activity.

LVL-LEVEL-DETAIL     Numeric 15 Occurs 5 Times                   AC10.1  AC110
Level Detail         Each occurrence of this field describes     AC120   AC500
                     detail for one of the Activity
                     Management variable levels.

                         ACLEVEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LVLSET1   ACTIVITY-GRP  KeyChange                                AC01.1  AC10.1
          VAR-LEVELS                                             AC10.3  AC10.5
                                                                 AC105   AC11.1
                                                                 AC110   AC112
                                                                 AC120   AC121
                                                                 AC123   AC127
                                                                 AC13.2  AC13.3
                                                                 AC130   AC160
                                                                 AC165   AC170
                                                                 AC190   AC191
                                                                 AC196   AC198
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.7
                                                                 AC203   AC206
                                                                 ...

LVLSET2   ACTIVITY-GRP  KeyChange                                BR00.1  BR00.2
          VAR-LEVELS
          LEVEL-DEPTH*

LVLSET3   ACTIVITY-GRP  KeyChange                                AC01.1  AC10.5
          LEVEL-DEPTH                                            AC550   AC750
          VAR-LEVELS*                                            ACDL.1

LVLSET4   POSTING-FLAG  KeyChange                                AC750
          ACTIVITY-GRP
          VAR-LEVELS

                         ACLEVEL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            LVL-ACTIVITY-GRP    -> ACV-ACTIVITY-GRP
                            LVL-VAR-LEVELS      -> ACV-VAR-LEVELS

                         ACLEVEL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Actrans        ACTRANS

                            LVL-ACTIVITY-GRP    -> ATN-ACTIVITY-GRP
                            LVL-VAR-LEVELS      -> ATN-VAR-LEVELS
                                                   ATN-STATUS
                                                   ATN-ACCT-CATEGORY
                                                   ATN-FISCAL-YEAR
                                                   ATN-PERIOD
                                                   ATN-OBJ-ID