Lawson Insight Technical Documentation |
|
ACTOTBAL
ACTOTBAL FILE
REFERENCED BY
ACTA.1
UPDATED BY
AC121 AC123 AC127 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC22.1 AC300
AC310 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TOT-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Last Closed YeThis is the current fiscal year. This AC127 AC20.1
field is updated by Period Closing AC20.2 AC20.3
(GL199). AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
TOT-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Number The Budget Number field contains the AC127 AC20.1
budget number. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
TOT-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity GroupThe activity group is the overall AC127 AC20.1
project. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
TOT-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Activities are the processes or AC127 AC20.1
procedures that produce work. Cost AC20.2 AC20.3
objects (products, services, customers, AC20.4 AC20.5
and so on) are the reasons for AC20.6 AC20.7
performing the activity. AC22.1 ACDR.1
TOT-CATEGORY-TYPE Alpha 1 AC121 AC123
Element: Category Type This Field is used to set up the AC127 AC20.1
default category type for the AC20.2 AC20.3
Distribution File. AC20.4 AC20.5
(EEDISTRIB) AC20.6 AC20.7
A = Accrual AC22.1 ACDR.1
C = Cost
R = Revenue
F = Fee
TOT-CURRENCY-CODE Alpha 5 AC121 AC123
Element: Currency Code This field contains the company base AC127 AC20.1
currency code established in Company AC20.2 AC20.3
(GL10.1 ). AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
TOT-LEVEL-DEPTH Numeric 1 AC121 AC123
Element: Level Depth The number of variable levels AC127 AC20.1
pertaining AC20.2 AC20.3
to this record. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
TOT-VAR-LEVELS Alpha 30 AC121 AC123
Element: Variable LevelA level that represents the location of AC127 AC20.1
an accounting unit in an organization's AC20.2 AC20.3
level structure. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
TOT-PARENT-ACTV Alpha 15 AC121 AC123
Element: Parent Actv The parent activity field contains the AC127 AC20.1
activity name of the member parent. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
TOT-BALANCE-AMOUNT Signed 18.2 AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1
TOT-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Balance Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1
TOT-BEGIN-BAL-AMT Signed 18.2 AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1
TOT-BEGIN-BAL-UNT Signed 15.2 AC121 AC123
Unit Beginning The units beginning balance. AC127 AC20.1
Balance AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1
TOT-PERIOD-AMT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1
TOT-PERIOD-UNIT Signed 15.2 Occurs 13 Times AC121 AC123
Element: Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1
ACTOTBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TOTSET1 FISCAL-YEAR AC121 AC123
BUDGET-NBR AC127 AC20.1
ACTIVITY-GRP AC20.2 AC20.3
ACTIVITY AC20.4 AC20.5
CURRENCY-CODE AC20.6 AC20.7
CATEGORY-TYPE AC22.1 AC310
ACDR.1 ACTA.1
TOTSET2 ACTIVITY-GRP KeyChange AC300
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
ACTIVITY
TOTSET4 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC20.1
CURRENCY-CODE AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
CATEGORY-TYPE AC20.6 AC20.7
FISCAL-YEAR* AC22.1 AC310
ACDR.1 ACTA.1
TOTSET5 ACTIVITY-GRP KeyChange AC121 AC123
ACTIVITY AC127 AC20.1
CURRENCY-CODE AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
CATEGORY-TYPE AC20.6 AC20.7
FISCAL-YEAR AC22.1 ACDR.1
ACTOTBAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
TOT-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
TOT-ACTIVITY -> ACV-ACTIVITY
Aclevel ACLEVEL Required
TOT-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
ACV-VAR-LEVELS -> LVL-VAR-LEVELS
Actotbal Parnt ACTOTBAL Not Required
Valid When TOT-ACTIVITY != Spaces
TOT-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
TOT-PARENT-ACTV -> TOT-ACTIVITY
TOT-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR -> TOT-BUDGET-NBR
TOT-CATEGORY-TYPE -> TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR -> TOT-FISCAL-YEAR
ACTOTBAL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acconsol ACCONSOL
Valid When LVL-POSTING-FLAG = "S"
Or LVL-POSTING-FLAG = "C"
TOT-FISCAL-YEAR -> CSL-FISCAL-YEAR
TOT-BUDGET-NBR -> CSL-BUDGET-NBR
TOT-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
TOT-ACTIVITY -> CSL-ACTIVITY
TOT-CURRENCY-CODE -> CSL-CURRENCY-CODE
CSL-ACCT-CATEGORY
Acconsol Grp ACCONSOL
TOT-FISCAL-YEAR -> CSL-FISCAL-YEAR
TOT-BUDGET-NBR -> CSL-BUDGET-NBR
TOT-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
Spaces -> CSL-ACTIVITY
TOT-CURRENCY-CODE -> CSL-CURRENCY-CODE
CSL-ACCT-CATEGORY
Accuamt ACCUAMT
TOT-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
TOT-ACTIVITY -> ACU-ACTIVITY
TOT-BUDGET-NBR -> ACU-BUDGET-NBR
TOT-CURRENCY-CODE -> ACU-CURRENCY-CODE
TOT-FISCAL-YEAR -> ACU-FISCAL-YEAR
ACU-ACCT-CATEGORY
Acmaster ACMASTER
Valid When LVL-POSTING-FLAG = "P"
TOT-ACTIVITY-GRP -> MST-ACTIVITY-GRP
TOT-ACTIVITY -> MST-ACTIVITY
TOT-FISCAL-YEAR -> MST-FISCAL-YEAR
MST-ACCT-CATEGORY
Actotbal Child ACTOTBAL
Valid When TOT-ACTIVITY != Spaces
TOT-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
TOT-ACTIVITY -> TOT-PARENT-ACTV
TOT-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR -> TOT-BUDGET-NBR
TOT-CATEGORY-TYPE -> TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR -> TOT-FISCAL-YEAR
TOT-ACTIVITY
Actotbal Type ACTOTBAL
TOT-FISCAL-YEAR -> TOT-FISCAL-YEAR
TOT-BUDGET-NBR -> TOT-BUDGET-NBR
TOT-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
TOT-ACTIVITY -> TOT-ACTIVITY
TOT-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-CATEGORY-TYPE
Actotbal Year ACTOTBAL
TOT-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
TOT-ACTIVITY -> TOT-ACTIVITY
TOT-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR -> TOT-BUDGET-NBR
TOT-CATEGORY-TYPE -> TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
Actotbal Yr Tp ACTOTBAL
TOT-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
TOT-ACTIVITY -> TOT-ACTIVITY
TOT-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR -> TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
Tot Type Grp ACTOTBAL
TOT-FISCAL-YEAR -> TOT-FISCAL-YEAR
TOT-BUDGET-NBR -> TOT-BUDGET-NBR
TOT-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
Spaces -> TOT-ACTIVITY
TOT-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-CATEGORY-TYPE
Tot Year Grp ACTOTBAL
TOT-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
Spaces -> TOT-ACTIVITY
TOT-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR -> TOT-BUDGET-NBR
TOT-CATEGORY-TYPE -> TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
Tot Yr Tp Grp ACTOTBAL
TOT-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
Spaces -> TOT-ACTIVITY
TOT-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR -> TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
|