|
ACCUAMT FILE
Activity Currency Amount
This file holds values for both budgets and actual amounts only when
multicurrency is an issue because the activity currency is different from the
activity group currency.
Budget information is stored in the budget's currency because the base
currency values are stored in the Activity Budget and Activity Budget Detail
files.
Actual amount information is stored in the base (activity group) currency
because the transaction currency values are stored in the Activity Master
file.
REFERENCED BY
AC130 AC21.1 AC21.2 AC21.3 AC21.4 AC220
AC32.1 AC37.1 AC420 AC472 AC473 AC490
AC527 AC96.1 AC96.4 AC98.2 ACDL.1 ACTA.1
AC145 AC190 AC421 AC93.3
UPDATED BY
AC120 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
ACU-ACTIVITY-GRP Alpha 15 AC120 AC121
Element: Activity GroupRequired key. This is the activity AC123 AC127
group for the budget and actual amount AC20.1 AC20.2
information. AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC22.1
ACDR.1 SB515
ACU-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Required key. This is the activity for AC127 AC20.1
the budget and actual amount AC20.2 AC20.3
information. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Number Required key. This is the budget number AC127 AC20.1
for the budget and actual amount AC20.2 AC20.3
information. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Fiscal Year Required key. This is the fiscal year AC127 AC20.1
for the budget and actual amount AC20.2 AC20.3
information.. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-ACCT-CATEGORY Alpha 5 AC121 AC123
Element: Account CategoRequired key. This is the account AC127 AC20.1
category for the budget and actual AC20.2 AC20.3
amount information. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-CURRENCY-CODE Alpha 5 AC121 AC123
Element: Currency Code Required key. This field contains the AC127 AC20.1
base currency code for the activity AC20.2 AC20.3
group. It is defined in AC00.1 (Activity AC20.4 AC20.5
Group). AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-VAR-LEVELS Alpha 30 AC120 AC121
Element: Variable LevelThis is the variable level for the AC123 AC127
budget and actual amount information. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC22.1
ACDR.1 SB515
ACU-PARENT-ACTV Alpha 15 AC120 AC121
Element: Parent Actv The parent activity field contains the AC123 AC127
activity name of the member parent. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC22.1
ACDR.1 SB515
ACU-CURR-ND Numeric 1 AC121 AC123
Currency Number of This field defines the number of AC127 AC20.1
Decimals decimals for the budget currency. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-BALANCE-AMOUNT Signed 18.2 AC121 AC123
Element: Amount BalanceThis is the amount balance for the AC127 AC20.1
current year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Units Balance This is the unit balance for the AC127 AC20.1
current year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-BEGIN-BAL-AMT Signed 18.2 AC121 AC123
Amount Beginning This is the life-to-date amount up AC127 AC20.1
Balance until the start of the current year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-BEGIN-BAL-UNT Signed 15.2 AC121 AC123
Units Beginning This is the life-to-date units up until AC127 AC20.1
Balance the start of the current year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-LTD-AMOUNT Derived
Element: Life-to-Date AThis is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
ACU-LTD-UNIT Derived
Element: Life-to-Date UThis is the sum of the Unit Balance and
the Unit Beginning Balance fields for
the fiscal year.
ACU-FACTOR Alpha 15 AC121 AC123
Element: Factor The element that affects the budget AC127 AC20.1
change. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-FACTOR-RATE Signed 14.7 AC121 AC123
Element: Factor Rate You can type or select the rate that AC127 AC20.1
affects the factor. For example, you AC20.2 AC20.3
could type the inflation rate. AC20.4 AC20.5
AC20.6 AC20.7
If you select units and amounts, the AC22.1 ACDR.1
rate is calculated. SB515
ACU-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Maint Date The date last changed. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Sys Time AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACU-ACCT-CAT-TYPE Derived
Element: Acct Cat Type
ACU-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 ACDR.1
SB515
ACU-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 ACDR.1
SB515
ACU-PERIOD-RATE Signed 14.7 Occurs 13 Times AC121 AC123
Element: Factor Rate You can type or select the rate that AC127 AC20.1
affects the factor. For example, you AC20.2 AC20.3
could type the inflation rate. AC20.4 AC20.5
AC20.6 AC20.7
If you select units and amounts, the AC22.1 ACDR.1
rate is calculated. SB515
ACU-PERIOD-FACTOR Alpha 15 Occurs 13 Times AC121 AC123
Element: Factor The element that affects the budget AC127 AC20.1
change. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACCUAMT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACUSET1 ACTIVITY-GRP AC120 AC121
ACTIVITY AC123 AC127
CURRENCY-CODE AC130 AC20.1
BUDGET-NBR AC20.2 AC20.3
FISCAL-YEAR AC20.4 AC20.5
ACCT-CATEGORY AC20.6 AC20.7
AC21.1 AC21.2
AC21.3 AC21.4
AC22.1 AC220
AC300 AC310
AC32.1 AC37.1
AC420 AC472
AC473 AC490
AC527 AC96.1
AC96.4 AC98.2
...
ACUSET2 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC20.1
CURRENCY-CODE AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
ACCT-CATEGORY AC20.6 AC20.7
FISCAL-YEAR AC22.1 AC220
ACDR.1 ACTA.1
SB515
ACUSET3 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
CURRENCY-CODE AC145 AC190
BUDGET-NBR AC20.1 AC20.2
ACCT-CATEGORY AC20.3 AC20.4
FISCAL-YEAR* AC20.5 AC20.6
AC20.7 AC22.1
AC32.1 AC37.1
AC421 AC473
AC490 AC93.3
AC96.1 AC96.4
AC98.2 ACDR.1
ACTA.1 SB515
ACUSET4 ACTIVITY-GRP AC20.6 AC20.7
ACTIVITY
BUDGET-NBR
CURRENCY-CODE
FISCAL-YEAR
ACCT-CATEGORY
ACUSET5 ACTIVITY-GRP KeyChange
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
ACCUAMT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
ACU-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactgrp ACACTGRP Required
ACU-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
ACU-ACTIVITY-GRP -> ACV-ACTIVITY-GRP
ACU-ACTIVITY -> ACV-ACTIVITY
Acbuddtl ACBUDDTL Not Required
ACU-ACTIVITY-GRP -> BDT-ACTIVITY-GRP
ACU-ACTIVITY -> BDT-ACTIVITY
ACU-BUDGET-NBR -> BDT-BUDGET-NBR
ACU-ACCT-CATEGORY -> BDT-ACCT-CATEGORY
ACU-FISCAL-YEAR -> BDT-FISCAL-YEAR
Acbudhdr ACBUDHDR Required
ACU-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
ACU-ACTIVITY -> BDH-ACTIVITY
ACU-BUDGET-NBR -> BDH-BUDGET-NBR
Acmaster ACMASTER Not Required
ACU-ACTIVITY-GRP -> MST-ACTIVITY-GRP
ACU-ACTIVITY -> MST-ACTIVITY
ACU-ACCT-CATEGORY -> MST-ACCT-CATEGORY
ACU-FISCAL-YEAR -> MST-FISCAL-YEAR
Cucodes CUCODES Not Required
ACU-CURRENCY-CODE -> CUC-CURRENCY-CODE
ACCUAMT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accommit ACCOMMIT
ACU-ACTIVITY-GRP -> MIT-ACTIVITY-GRP
ACU-ACTIVITY -> MIT-ACTIVITY
ACU-ACCT-CATEGORY -> MIT-ACCT-CATEGORY
ACU-FISCAL-YEAR -> MIT-FISCAL-YEAR
MIT-PERIOD
MIT-SYSTEM
MIT-COMPANY
MIT-CURRENCY-CODE
Accommitx ACCOMMITX
ACU-ACTIVITY-GRP -> MIX-ACTIVITY-GRP
ACU-ACTIVITY -> MIX-ACTIVITY
ACU-ACCT-CATEGORY -> MIX-ACCT-CATEGORY
ACU-FISCAL-YEAR -> MIX-FISCAL-YEAR
MIX-PERIOD
MIX-SYSTEM
MIX-COMPANY
MIX-CURRENCY-CODE
MIX-ATN-OBJ-ID
Actrans ACTRANS
ACU-ACTIVITY -> ATN-ACTIVITY
ACU-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
ACU-FISCAL-YEAR -> ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
|