Lawson Insight Technical Documentation |
|
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
AC01.1 AC105 AC11.1 AC112 AC113 AC121
AC123 AC127 AC13.2 AC13.3 AC130 AC131
AC135 AC160 AC165 AC190 AC191 AC192
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 AC37.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 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
SE90.1 AR129 AR130 AR131 AR135 AR250
AR251 AR30.1 AR30.2 AR30.3 AR30.4 AR30.5
AR30.6 AR30.8 AR31.6 AR35.1 AR36.1 AR48.3
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
BR130 BR131 BR142 BR15.1 BR151 BR152
BR153 BR154 BR155 BR156 BR157 BR165
BR200 BR202 BR204 BR205 BR210 BR212
BR215 BR220 BR251 BR252 BR253 BR254
BR265 BR40.3 BR40.4 BR400 BR405 BR41.1
BR41.4 BR420 BR43.1 BR430 BR450 BR51.1
BR52.2 BR52.4 BR52.5 BR521 BR530 BR54.1
BR54.2 BR54.3 BR54.4 BR65.1 BR65.2 BR900
BRCC.1 MX123 MX223 MX500 AC58.1
UPDATED BY
AC10.1 AC110 AC120 AC300 AC310 AC500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LVL-ACTIVITY-GRP Alpha 15 AC10.1 AC110
Element: Group Required key. This is the activity AC120 AC500
group for the activity.
LVL-VAR-LEVELS Alpha 30 AC10.1 AC110
Element: Variable LevelRequired 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
Element: Activity This is the activity for the levels. AC500
LVL-POSTING-FLAG Alpha 1 AC10.1 AC110
Element: 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
Element: 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
Element: 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
AC113 AC120
AC121 AC123
AC127 AC13.2
AC13.3 AC130
AC131 AC135
AC160 AC165
AC190 AC191
AC192 AC196
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
...
LVLSET2 ACTIVITY-GRP KeyChange BR00.1 BR00.2
VAR-LEVELS
LEVEL-DEPTH*
LVLSET3 ACTIVITY-GRP KeyChange AC01.1 AC10.5
LEVEL-DEPTH ACDL.1
VAR-LEVELS*
LVLSET4 POSTING-FLAG KeyChange AC190 AC191
ACTIVITY-GRP AC198 AC240
VAR-LEVELS AC290 AC295
AC471 AC490
AC550 AC58.1
AC90.1 AC90.2
AC90.4 AC90.6
AC90.8 AC92.1
AC92.2 AC92.4
AC92.6 AC93.4
AC93.5 AC94.1
AC94.2 AC94.4
AC94.6 AC95.1
AC95.2 AC95.4
AC95.6 AC97.2
...
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
|