ACCUAMTX FILE AC Currency Amount Detail This file contains currency amount details by period. REFERENCED BY AC130 AC21.2 AC21.3 AC30.2 AC30.3 AC32.1 AC410 AC420 AC473 AC480 AC220 AC401 AC295 AC297 AC95.1 AC95.2 AC97.1 AC97.2 ACDL.1 UPDATED BY AC120 AC121 AC123 AC127 AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC300 AC310 AC580 AC980 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ACX-ACTIVITY-GRP Alpha 15 AC120 AC121 Activity Group Required key. This is the activity AC123 AC127 group for the currency information. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC580 AC980 ACX-ACTIVITY Alpha 15 AC120 AC121 Activity Required key. This is the activity for AC123 AC127 the currency information. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC580 AC980 ACX-BUDGET-NBR Numeric 3 AC120 AC121 Budget Number Required key. This is the budget number AC123 AC127 for the currency information.. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC580 AC980 ACX-FISCAL-YEAR Numeric 4 AC120 AC121 Fiscal Year Required key. This is the fiscal year. AC123 AC127 AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC580 AC980 ACX-ACCT-CATEGORY Alpha 5 AC120 AC121 Account Category Required key. This is the account AC123 AC127 category for the currency information. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC580 AC980 ACX-CURRENCY-CODE Alpha 5 AC120 AC121 Currency Code Required key. This field defines the AC123 AC127 base currency code for the activity AC190 AC20.1 group. It is defined in AC00.1 (Activity AC20.2 AC20.3 Group). AC20.4 AC22.1 AC580 AC980 ACX-PERIOD Numeric 2 AC120 AC121 Period Required key. This is the fiscal period AC123 AC127 for the currency information. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC580 AC980 ACX-AMOUNT Currency 15.2 AC120 AC121 Amount This is the period amount for the AC123 AC127 currency information for the specified AC190 AC20.1 record. AC20.2 AC20.3 AC20.4 AC22.1 AC580 AC980 ACX-UNIT Signed 15.2 AC120 AC121 Unit This is the number of units for the AC123 AC127 period. AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC580 AC980 ACX-FACTOR Alpha 15 AC121 AC123 Factor The element that affects the budget AC127 AC20.1 change. AC20.2 AC20.3 AC20.4 AC22.1 ACX-FACTOR-RATE Signed 12.6 AC121 AC123 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 AC22.1 If you select units and amounts, the rate is calculated. ACCUAMTX FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ACXSET1 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 PERIOD AC21.3 AC22.1 AC30.2 AC30.3 AC300 AC310 AC32.1 AC410 AC420 AC473 AC480 AC580 AC980 ACXSET2 ACTIVITY-GRP AC220 AC401 ACTIVITY BUDGET-NBR ACCT-CATEGORY FISCAL-YEAR CURRENCY-CODE PERIOD ACXSET3 ACTIVITY-GRP AC295 AC297 ACTIVITY AC95.1 AC95.2 BUDGET-NBR AC97.1 AC97.2 CURRENCY-CODE ACCT-CATEGORY FISCAL-YEAR* PERIOD* ACXSET4 ACTIVITY-GRP ACTIVITY CURRENCY-CODE FISCAL-YEAR PERIOD BUDGET-NBR ACCT-CATEGORY ACXSET5 FISCAL-YEAR AC473 ACDL.1 PERIOD ACTIVITY-GRP ACTIVITY ACCT-CATEGORY BUDGET-NBR CURRENCY-CODE ACCUAMTX FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Acbuddtlx ACBUDDTLX Not Required ACX-ACTIVITY-GRP -> BDX-ACTIVITY-GRP ACX-ACTIVITY -> BDX-ACTIVITY ACX-BUDGET-NBR -> BDX-BUDGET-NBR ACX-ACCT-CATEGORY -> BDX-ACCT-CATEGORY ACX-FISCAL-YEAR -> BDX-FISCAL-YEAR ACX-PERIOD -> BDX-PERIOD Accuamt ACCUAMT Required ACX-ACTIVITY-GRP -> ACU-ACTIVITY-GRP ACX-ACTIVITY -> ACU-ACTIVITY ACX-BUDGET-NBR -> ACU-BUDGET-NBR ACX-FISCAL-YEAR -> ACU-FISCAL-YEAR ACX-ACCT-CATEGORY -> ACU-ACCT-CATEGORY ACX-CURRENCY-CODE -> ACU-CURRENCY-CODE Acmasterx ACMASTERX Not Required ACX-ACTIVITY-GRP -> MSX-ACTIVITY-GRP ACX-ACTIVITY -> MSX-ACTIVITY ACX-ACCT-CATEGORY -> MSX-ACCT-CATEGORY ACX-FISCAL-YEAR -> MSX-FISCAL-YEAR ACX-PERIOD -> MSX-PERIOD |