|
ACTOTBAL FILE
REFERENCED BY
AC10.1 ACTA.1
UPDATED BY
AC121 AC123 AC127 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC22.1 AC300
AC310 ACDR.1 SB515
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TOT-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Year Contains the fiscal year for the data AC127 AC20.1
stored on this record. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
TOT-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Nbr The Budget Number field contains the AC127 AC20.1
budget number. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
TOT-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity Grp The activity group is the overall AC127 AC20.1
project. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
TOT-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Activities are the processes or AC127 AC20.1
procedures that produce work. Cost AC20.2 AC20.3
objects (products, services, customers, AC20.4 AC20.5
and so on) are the reasons for AC20.6 AC20.7
performing the activity. AC22.1 ACDR.1
SB515
TOT-CATEGORY-TYPE Alpha 1 AC121 AC123
Element: Category Type This Field is used to set up the AC127 AC20.1
default category type for the AC20.2 AC20.3
Distribution File. AC20.4 AC20.5
(EEDISTRIB) AC20.6 AC20.7
A = Accrual AC22.1 ACDR.1
C = Cost SB515
R = Revenue
F = Fee
TOT-CURRENCY-CODE Alpha 5 AC121 AC123
Element: Currency Code This field contains the company base AC127 AC20.1
currency code established in Company AC20.2 AC20.3
(GL10.1 ). AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
TOT-LEVEL-DEPTH Numeric 1 AC121 AC123
Element: Level Depth The number of variable levels AC127 AC20.1
pertaining AC20.2 AC20.3
to this record. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
TOT-VAR-LEVELS Alpha 30 AC121 AC123
Element: Var Levels A level that represents the location of AC127 AC20.1
an accounting unit in an organization's AC20.2 AC20.3
level structure. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
TOT-PARENT-ACTV Alpha 15 AC121 AC123
Element: Parent Actv The parent activity field contains the AC127 AC20.1
activity name of the member parent. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
TOT-BALANCE-AMOUNT Signed 18.2 AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1 SB515
TOT-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Balance Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1 SB515
TOT-BEGIN-BAL-AMT Signed 18.2 AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1 SB515
TOT-BEGIN-BAL-UNT Signed 15.2 AC121 AC123
Element: Begin Bal Unt The units beginning balance. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1 SB515
TOT-PERIOD-AMT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1 SB515
TOT-PERIOD-UNIT Signed 15.2 Occurs 13 Times AC121 AC123
Element: Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC310
ACDR.1 SB515
ACTOTBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TOTSET1 FISCAL-YEAR AC10.1 AC121
BUDGET-NBR AC123 AC127
ACTIVITY-GRP AC20.1 AC20.2
ACTIVITY AC20.3 AC20.4
CURRENCY-CODE AC20.5 AC20.6
CATEGORY-TYPE AC20.7 AC22.1
AC310 ACDR.1
ACTA.1 SB515
TOTSET2 ACTIVITY-GRP KeyChange AC300
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
ACTIVITY
TOTSET4 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC20.1
CURRENCY-CODE AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
CATEGORY-TYPE AC20.6 AC20.7
FISCAL-YEAR* AC22.1 AC310
ACDR.1 ACTA.1
SB515
TOTSET5 ACTIVITY-GRP KeyChange AC121 AC123
ACTIVITY AC127 AC20.1
CURRENCY-CODE AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
CATEGORY-TYPE AC20.6 AC20.7
FISCAL-YEAR AC22.1 ACDR.1
SB515
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
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 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 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
|