ACTOTBAL

REFERENCED BY
AC10.1 AC93.2 AC93.3 AC93.4


UPDATED BY
AC121 AC123 AC127 AC145 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.5
AC22.1 AC300 AC45.1 ACDR.1 ACTA.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TOT-FISCAL-YEAR
Element: Year		Numeric 4
Contains the fiscal year for the data stored on this record.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-BUDGET-NBR
Element: Budget Nbr		Numeric 3
The Budget Number field contains the budget number.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-ACTIVITY-GRP
Element: Activity Grp		Alpha 15
The activity group is the overall project.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-ACTIVITY
Element: Activity		Alpha 15
Activities 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-CATEGORY-TYPE
Element: Category Type		Alpha 1
This 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-CURRENCY-CODE
Element: Currency Code		Alpha 5
This 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-LEVEL-DEPTH
Element: Level Depth		Numeric 1
The number of variable levels pertaining to this record.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-VAR-LEVELS
Element: Var Levels		Alpha 30
A 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-PARENT-ACTV
Element: Parent Actv		Alpha 15
The parent activity field contains the activity name of the member parent.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-BALANCE-AMOUNT
Element: Intl Amt		Signed 18.2
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-BALANCE-UNIT
Element: Balance Unit		Signed 17.2
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-BEGIN-BAL-AMT
Element: Intl Amt		Signed 18.2
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-BEGIN-BAL-UNT
Element: Begin Bal Unt		Signed 15.2
The units beginning balance.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-PERIOD-AMT
Element: Intl Amt		Signed 18.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
TOT-PERIOD-UNIT
Element: Unit		Signed 15.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1


ACTOTBAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TOTSET1 FISCAL-YEAR
BUDGET-NBR
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
CATEGORY-TYPE
AC10.1 AC121
AC123 AC127
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 ACDR.1
ACTA.1
TOTSET2 ACTIVITY-GRP
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
ACTIVITY
KeyChange
AC300
TOTSET4 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC93.2 AC93.3
AC93.4 ACDR.1
ACTA.1
TOTSET5 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR
KeyChange
AC121 AC123
AC127 AC145
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 AC45.1
ACDR.1


ACTOTBAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
TOT-ACTIVITY-GRP->AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
TOT-ACTIVITY->ACV-ACTIVITY
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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acconsol ACCONSOL
Valid When ACV-POSTING-FLAG ="S"
OrACV-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 ACV-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

File created: Thu Jun 09 11:04:16 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.