Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACLEVEL


                              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

BR00.1    BR00.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

LVL-ACTIVITY-GRP       Alpha 15
Element: Activity GroupRequired key. This is the activity
                       group for the activity.

LVL-VAR-LEVELS         Alpha 30
Element: Variable LevelRequired key. Levels define an
                       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
Element: Activity      This is the activity for the levels.

LVL-POSTING-FLAG       Alpha 1
Element: Posting Flag  This field indicates whether this level
                       is the posting or the summary level.
                       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
Variable Level         The level structure for the activity
Display                displays.

LVL-LEVEL-DEPTH        Numeric 1
Element: Level Depth   This is the number of variable levels
                       pertaining to this activity.

LVL-LEVEL-DETAIL       Numeric 15 Occurs 5 Times
Element: Level Detail  Each occurrence of this field describes
                       detail for one of the Activity
                       Management variable levels.

                         ACLEVEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LVLSET1   ACTIVITY-GRP  KeyChange                                BR00.1  BR00.2
          VAR-LEVELS

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

LVLSET3   ACTIVITY-GRP  KeyChange
          LEVEL-DEPTH
          VAR-LEVELS*

LVLSET4   POSTING-FLAG  KeyChange
          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  (ACVSET8)
                            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