ACTOTBAL

REFERENCED BY
AC10.1


UPDATED BY
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.
TOT-BUDGET-NBR
Element: Budget Nbr
Numeric 3
The Budget Number field contains the budget number.
TOT-ACTIVITY-GRP
Element: Activity Grp
Alpha 15
The activity group is the overall project.
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.
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
TOT-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
TOT-LEVEL-DEPTH
Element: Level Depth
Numeric 1
The number of variable levels pertaining to this record.
TOT-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
TOT-PARENT-ACTV
Element: Parent Actv
Alpha 15
The parent activity field contains the activity name of the member parent.
TOT-BALANCE-AMOUNT
Element: Intl Amt
Signed 18.2
TOT-BALANCE-UNIT
Element: Balance Unit
Signed 17.2
TOT-BEGIN-BAL-AMT
Element: Intl Amt
Signed 18.2
TOT-BEGIN-BAL-UNT
Element: Begin Bal Unt
Signed 15.2
The units beginning balance.
TOT-PERIOD-AMT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
TOT-PERIOD-UNIT
Element: Unit
Signed 15.2 Occurs 13 Times


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 ACTA.1
TOTSET2 ACTIVITY-GRP
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
ACTIVITY
KeyChange
TOTSET4 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
ACTA.1
TOTSET5 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR
KeyChange


ACTOTBAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
TOT-ACTIVITY-GRP->AGP-ACTIVITY-GRP (AGPSET1)
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: Wed Jun 08 20:46:56 2016

Home
Contact Us



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