ACTOTBAL – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
TOT
Primary key
FISCAL-YEAR, BUDGET-NBR, ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, CATEGORY-TYPE
Fields
15
Updated by
20 programs
Referenced by
1 program

ACTOTBAL is a Lawson Activity Management table (prefix TOT); no description in the lawson data dictionary. It is indexed by FISCAL-YEAR, BUDGET-NBR, ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, CATEGORY-TYPE (TOTSET1); alternate indexes: TOTSET2, TOTSET4 and TOTSET5. It is related 1:1 to ACACTGRP, ACACTIVITY and ACTOTBAL and 1:M to ACCONSOL, ACCUAMT, ACMASTER and ACTOTBAL. It is updated by AC10.1, AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3 and 12 more and referenced by ACTA.1. The table has 15 fields, 4 indexes and 14 documented relations.

About ACTOTBAL

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the TOT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#TOT-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-BUDGET-NBR PK
BUDGET_NBR		Numeric 3The Budget Number field contains the budget number.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15The activity group is the overall project.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-ACTIVITY PK
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-CATEGORY-TYPE PK
CATEGORY_TYPE		Alpha 1This Field is used to set up the default category type for the Distribution File. (EEDISTRIB)
  • A Accrual
  • C Cost
  • R Revenue
  • F Fee
AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-CURRENCY-CODE PK
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-LEVEL-DEPTH
LEVEL_DEPTH		Numeric 1The number of variable levels pertaining to this record.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-VAR-LEVELS
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-PARENT-ACTV SET2
PARENT_ACTV		Alpha 15The parent activity field contains the activity name of the member parent.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-BALANCE-AMOUNT
BALANCE_AMOUNT		Signed 18.2—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-BALANCE-UNIT
BALANCE_UNIT		Signed 17.2—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-BEGIN-BAL-AMT
BEGIN_BAL_AMT		Signed 18.2—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-BEGIN-BAL-UNT
BEGIN_BAL_UNT		Signed 15.2The units beginning balance.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-PERIOD-AMT
PERIOD_AMT		Signed 18.2 Occurs 13 Times ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#TOT-PERIOD-UNIT
PERIOD_UNIT		Signed 15.2 Occurs 13 Times ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TOTSET1
  1. FISCAL-YEAR
  2. BUDGET-NBR
  3. ACTIVITY-GRP
  4. ACTIVITY
  5. CURRENCY-CODE
  6. CATEGORY-TYPE
PrimaryAC10.1, AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4 +7 more
TOTSET2
  1. ACTIVITY-GRP
  2. PARENT-ACTV
  3. CURRENCY-CODE
  4. BUDGET-NBR
  5. CATEGORY-TYPE
  6. FISCAL-YEAR ↓
  7. ACTIVITY
KeyChangeAC300
TOTSET4
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. CURRENCY-CODE
  4. BUDGET-NBR
  5. CATEGORY-TYPE
  6. FISCAL-YEAR ↓
AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +9 more
TOTSET5
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. CURRENCY-CODE
  4. BUDGET-NBR
  5. CATEGORY-TYPE
  6. FISCAL-YEAR
KeyChangeAC10.1, AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3 +8 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTGRPACACTIVITYACTOTBALACCONSOLACCUAMTACMASTERACTOTBALACTOTBAL

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequired
TOT-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
TOT-ACTIVITY→ACV-ACTIVITY
Actotbal ParntACTOTBALNot RequiredValid 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

One to many (11) — child tables

RelationTableRulesConditionField map
AcconsolACCONSOLValid When ACV-POSTING-FLAG = "S" Or ACV-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 GrpACCONSOL
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
AccuamtACCUAMT
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
AcmasterACMASTERValid When ACV-POSTING-FLAG = "P"
TOT-ACTIVITY-GRP→MST-ACTIVITY-GRP
TOT-ACTIVITY→MST-ACTIVITY
TOT-FISCAL-YEAR→MST-FISCAL-YEAR
—→MST-ACCT-CATEGORY
Actotbal ChildACTOTBALValid 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 TypeACTOTBAL
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 YearACTOTBAL
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 TpACTOTBAL
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 GrpACTOTBAL
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 GrpACTOTBAL
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 GrpACTOTBAL
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

Programs

Updated by (20)

Referenced by (1)