 |
Lawson Insight Technical Documentation |
|
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
Fiscal Year This 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
Budget Number The Budget Number field contains the AC45.1 ACDR.1
budget number.
TOT-ACTIVITY-GRP Alpha 15 AC190 AC20.7
Activity Group AC45.1 ACDR.1
TOT-ACTIVITY Alpha 15 AC190 AC20.7
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
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
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
Level Depth The number of variable levels AC45.1 ACDR.1
pertaining
to this record.
TOT-VAR-LEVELS Alpha 30 AC190 AC20.7
Variable Levels A level that represents the location of AC45.1 ACDR.1
an accounting unit in an organization's
level structure.
TOT-PARENT-ACTV Alpha 15 AC190 AC20.7
Parent Actv AC45.1 ACDR.1
TOT-BALANCE-AMOUNT Signed 17.2 AC190 AC20.7
Balance Amount AC310 AC45.1
ACDR.1
TOT-BALANCE-UNIT Signed 17.2 AC190 AC20.7
Balance Unit AC310 AC45.1
ACDR.1
TOT-BEGIN-BAL-AMT Signed 15.2 AC190 AC20.7
Beginning Amount AC310 AC45.1
Balance ACDR.1
TOT-BEGIN-BAL-UNT Signed 15.2 AC190 AC20.7
Unit Beginning The units beginning balance. AC310 AC45.1
Balance 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 TOT-POSTING-FLAG = "S"
Or TOT-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 TOT-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
|