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.2 AC21.3 AC220 AC30.2 AC30.3
AC32.1 AC410 AC420 AC295 AC297 AC421
AC473 AC480 AC95.1 AC95.2 AC97.1 AC97.2
UPDATED BY
AC120 AC121 AC123 AC127 AC190 AC20.1
AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC300
AC310 AC580 AC701 AC980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACU-ACTIVITY-GRP Alpha 15 AC120 AC123
Activity Group Required key. This is the activity AC127 AC190
group for the budget and actual amount AC20.2 AC20.3
information. AC20.4 AC580
AC980
ACU-ACTIVITY Alpha 15 AC120 AC123
Activity Required key. This is the activity for AC127 AC190
the budget and actual amount AC20.2 AC20.3
information. AC20.4 AC580
AC980
ACU-BUDGET-NBR Numeric 3 AC120 AC123
Budget Number Required key. This is the budget number AC127 AC190
for the budget and actual amount AC20.2 AC20.3
information. AC20.4 AC580
AC980
ACU-FISCAL-YEAR Numeric 4 AC120 AC123
Fiscal Year Required key. This is the fiscal year AC127 AC190
for the budget and actual amount AC20.2 AC20.3
information.. AC20.4 AC580
AC980
ACU-ACCT-CATEGORY Alpha 5 AC120 AC123
Account Category Required key. This is the account AC127 AC190
category for the budget and actual AC20.2 AC20.3
amount information. AC20.4 AC580
AC980
ACU-CURRENCY-CODE Alpha 5 AC120 AC123
Currency Code Required key. This field contains the AC127 AC190
base currency code for the activity AC20.2 AC20.3
group. It is defined in AC00.1 (Activity AC20.4 AC580
Group). AC980
ACU-VAR-LEVELS Alpha 30 AC120 AC123
Variable Levels This is the variable level for the AC190 AC580
budget and actual amount information. AC980
ACU-CURR-ND Numeric 1 AC120 AC123
Currency Number of This field defines the number of AC190 AC580
Decimals decimals for the budget currency. AC980
ACU-BALANCE-AMOUNT Signed 17.2 AC120 AC121
Amount Balance This is the amount balance for the AC123 AC127
current year. AC190 AC20.2
AC20.3 AC20.4
AC22.1 AC580
AC980
ACU-BALANCE-UNIT Signed 17.2 AC120 AC121
Units Balance This is the unit balance for the AC123 AC127
current year. AC190 AC20.2
AC20.3 AC20.4
AC22.1 AC580
AC980
ACU-BEGIN-BAL-AMT Signed 15.2 AC120 AC121
Amount Beginning This is the life-to-date amount up AC123 AC127
Balance until the start of the current year. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC22.1
AC580 AC701
AC980
ACU-BEGIN-BAL-UNT Signed 15.2 AC120 AC121
Units Beginning This is the life-to-date units up until AC123 AC127
Balance the start of the current year. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC22.1
AC580 AC701
AC980
ACU-LTD-AMOUNT Derived
Life-to-Date Amount This is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
ACU-LTD-UNIT Derived
Life-to-Date Units This is the sum of the Unit Balance and
the Unit Beginning Balance fields for
the fiscal year.
ACU-FACTOR Alpha 15 AC121 AC127
Factor The element that affects the budget AC20.2 AC20.3
change. AC20.4 AC22.1
ACU-FACTOR-RATE Signed 12.6 AC127 AC20.1
Rate You can type or select the rate that AC20.2 AC20.3
affects the factor. For example, you AC20.4 AC22.1
could type the inflation rate.
If you select units and amounts, the
rate is calculated.
ACU-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Maintenance Date The date last changed. AC127 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC701
ACU-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Maintenance Time The time last changed. AC127 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC701
ACCUAMT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACUSET1 ACTIVITY-GRP AC120 AC121
ACTIVITY AC123 AC127
BUDGET-NBR AC130 AC190
FISCAL-YEAR AC20.1 AC20.2
ACCT-CATEGORY AC20.3 AC20.4
CURRENCY-CODE AC20.6 AC21.2
AC21.3 AC22.1
AC220 AC30.2
AC30.3 AC300
AC310 AC32.1
AC410 AC420
AC580 AC701
AC980
ACUSET10 FISCAL-YEAR
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
BUDGET-NBR
CURRENCY-CODE
ACUSET2 ACTIVITY-GRP AC20.2 AC220
ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
CURRENCY-CODE
ACUSET3 ACTIVITY-GRP AC120 AC121
ACTIVITY AC123 AC127
BUDGET-NBR AC130 AC190
CURRENCY-CODE AC20.1 AC20.2
ACCT-CATEGORY AC20.3 AC20.4
FISCAL-YEAR* AC22.1 AC295
AC297 AC30.2
AC30.3 AC32.1
AC410 AC421
AC473 AC480
AC580 AC95.1
AC95.2 AC97.1
AC97.2
ACUSET4 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
CURRENCY-CODE
FISCAL-YEAR
ACCT-CATEGORY
ACUSET5 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
FISCAL-YEAR
BUDGET-NBR
ACCT-CATEGORY
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)
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
Aclevel ACLEVEL Required
ACU-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
ACU-VAR-LEVELS -> LVL-VAR-LEVELS
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
ACCUAMT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accuamtx ACCUAMTX
ACU-ACTIVITY-GRP -> ACX-ACTIVITY-GRP
ACU-ACTIVITY -> ACX-ACTIVITY
Zeroes -> ACX-BUDGET-NBR
ACU-FISCAL-YEAR -> ACX-FISCAL-YEAR
ACU-ACCT-CATEGORY -> ACX-ACCT-CATEGORY
ACU-CURRENCY-CODE -> ACX-CURRENCY-CODE
ACX-PERIOD
Accuamtx Bud ACCUAMTX
Valid When ACU-BUDGET-NBR != Zeroes
ACU-ACTIVITY-GRP -> ACX-ACTIVITY-GRP
ACU-ACTIVITY -> ACX-ACTIVITY
ACU-BUDGET-NBR -> ACX-BUDGET-NBR
ACU-FISCAL-YEAR -> ACX-FISCAL-YEAR
ACU-ACCT-CATEGORY -> ACX-ACCT-CATEGORY
ACU-CURRENCY-CODE -> ACX-CURRENCY-CODE
ACX-PERIOD
|