Lawson Insight Technical Documentation |
|
ACTOTBAL
ACTOTBAL FILE
UPDATED BY
AC190 AC20.7 AC300 AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TOT-FISCAL-YEAR Numeric 4 AC190 AC20.7
Element: Last Closed YeThis is the current fiscal year. This AC45.1 ACDR.1
field is updated by Period Closing
(GL199).
TOT-BUDGET-NBR Numeric 3 AC190 AC20.7
Element: Budget Number The Budget Number field contains the AC45.1 ACDR.1
budget number.
TOT-ACTIVITY-GRP Alpha 15 AC190 AC20.7
Element: Group AC45.1 ACDR.1
TOT-ACTIVITY Alpha 15 AC190 AC20.7
Element: Activity Activities are the processes or AC45.1 ACDR.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
TOT-CATEGORY-TYPE Alpha 1 AC190 AC20.7
Element: Category Type This Field is used to set up the AC45.1 ACDR.1
default category type for the
Distribution File.
(EEDISTRIB)
A = Accrual
C = Cost
R = Revenue
F = Fee
TOT-CURRENCY-CODE Alpha 5 AC190 AC20.7
Element: Currency Code This field contains the company base AC45.1 ACDR.1
currency code established in Company
(GL10.1 ).
TOT-LEVEL-DEPTH Numeric 1 AC190 AC20.7
Element: Level Depth The number of variable levels AC45.1 ACDR.1
pertaining
to this record.
TOT-VAR-LEVELS Alpha 30 AC190 AC20.7
Element: New Levels AC45.1 ACDR.1
TOT-PARENT-ACTV Alpha 15 AC190 AC20.7
Element: Parent Actv AC45.1 ACDR.1
TOT-BALANCE-AMOUNT Signed 17.2 AC190 AC20.7
Element: Balance AC310 AC45.1
ACDR.1
TOT-BALANCE-UNIT Signed 17.2 AC190 AC20.7
Element: Balance Unit AC310 AC45.1
ACDR.1
TOT-BEGIN-BAL-AMT Signed 15.2 AC190 AC20.7
Element: Adj Amt AC310 AC45.1
ACDR.1
TOT-BEGIN-BAL-UNT Signed 15.2 AC190 AC20.7
Element: Current Balance AC310 AC45.1
ACDR.1
ACTOTBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TOTSET1 FISCAL-YEAR AC190 AC20.7
BUDGET-NBR AC45.1 ACDR.1
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
CATEGORY-TYPE
TOTSET2 ACTIVITY-GRP AC300 ACDR.1
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
ACTIVITY
TOTSET3 CATEGORY-TYPE
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
FISCAL-YEAR*
BUDGET-NBR
TOTSET4 ACTIVITY-GRP AC190 AC20.7
ACTIVITY AC310 AC45.1
CURRENCY-CODE ACDR.1
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
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
Actotbalx ACTOTBALX
TOT-FISCAL-YEAR -> TOX-FISCAL-YEAR
TOT-BUDGET-NBR -> TOX-BUDGET-NBR
TOT-ACTIVITY-GRP -> TOX-ACTIVITY-GRP
TOT-ACTIVITY -> TOX-ACTIVITY
TOT-CURRENCY-CODE -> TOX-CURRENCY-CODE
TOT-CATEGORY-TYPE -> TOX-CATEGORY-TYPE
TOX-PERIOD
Actotbalx Grp ACTOTBALX
TOT-FISCAL-YEAR -> TOX-FISCAL-YEAR
TOT-BUDGET-NBR -> TOX-BUDGET-NBR
TOT-ACTIVITY-GRP -> TOX-ACTIVITY-GRP
Spaces -> TOX-ACTIVITY
TOT-CURRENCY-CODE -> TOX-CURRENCY-CODE
TOT-CATEGORY-TYPE -> TOX-CATEGORY-TYPE
TOX-PERIOD
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
|