ACCUAMT

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
AC310 AC527 AC47.2 AC96.1 AC96.4 ACDL.1


UPDATED BY
AC120 AC121 AC123 AC127 AC130 AC145
AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC20.6 AC20.7 AC21.5 AC22.1 AC220 AC297
AC300 AC311 AC32.1 AC37.1 AC421 AC45.1
AC472 AC473 AC490 AC93.3 AC98.2 ACDR.1
ACTA.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACU-ACTIVITY-GRP
Element: Activity Group		Alpha 15
Required key. This is the activity group for the budget and actual amount information.
AC120 AC121
AC123 AC127
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 ACDR.1
ACU-ACTIVITY
Element: Activity		Alpha 15
Required key. This is the activity for the budget and actual amount information.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-BUDGET-NBR
Element: Budget Number		Numeric 3
Required key. This is the budget number for the budget and actual amount information.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
Required key. This is the fiscal year for the budget and actual amount information..
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-ACCT-CATEGORY
Element: Account Category		Alpha 5
Required key. This is the account category for the budget and actual amount information.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-CURRENCY-CODE
Element: Currency Code		Alpha 5
Required key. This field contains the base currency code for the activity group. It is defined in AC00.1 (Activity Group).
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-VAR-LEVELS
Element: Variable Levels		Alpha 30
This is the variable level for the budget and actual amount information.
AC120 AC121
AC123 AC127
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 ACDR.1
ACU-PARENT-ACTV
Element: Parent Actv		Alpha 15
The parent activity field contains the activity name of the member parent.
AC120 AC121
AC123 AC127
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 ACDR.1
ACU-CURR-ND
Currency Number of
Decimals		Numeric 1
This field defines the number of decimals for the budget currency.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-BALANCE-AMOUNT
Element: Amount Balance		Signed 18.2
This is the amount balance for the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-BALANCE-UNIT
Element: Units Balance		Signed 17.2
This is the unit balance for the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-BEGIN-BAL-AMT
Amount Beginning
Balance		Signed 18.2
This is the life-to-date amount up until the start of the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-BEGIN-BAL-UNT
Units Beginning
Balance		Signed 15.2
This is the life-to-date units up until the start of the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-LTD-AMOUNT
Element: Life-to-Date Amount		Derived
This is the sum of the Amount Balance and the Amount Beginning Balance fields for the fiscal year.
ACU-LTD-UNIT
Element: Life-to-Date Units		Derived
This is the sum of the Unit Balance and the Unit Beginning Balance fields for the fiscal year.
ACU-FACTOR
Element: Factor		Alpha 15
The element that affects the budget change.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-FACTOR-RATE
Element: Factor Rate		Signed 14.7
You can type or select the rate that affects the factor. For example, you could type the inflation rate. If you select units and amounts, the rate is calculated.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-MAINT-DATE
Element: Maint Date		Numeric 8 (yyyymmdd)
The date last changed.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-MAINT-TIME
Element: Sys Time		Numeric 6 (hhmmss)
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-ACCT-CAT-TYPE
Element: Acct Cat Type		Derived
ACU-PERIOD-AMT
Element: Intl Amt		Signed 18.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-PERIOD-UNIT
Element: Unit		Signed 15.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-PERIOD-RATE
Element: Factor Rate		Signed 14.7 Occurs 13 Times
You can type or select the rate that affects the factor. For example, you could type the inflation rate. If you select units and amounts, the rate is calculated.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
ACU-PERIOD-FACTOR
Element: Factor		Alpha 15 Occurs 13 Times
The element that affects the budget change.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1


ACCUAMT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACUSET1 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
FISCAL-YEAR
ACCT-CATEGORY
...
AC120 AC121
AC123 AC127
AC130 AC145
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.1
AC21.2 AC21.3
AC21.4 AC21.5
AC22.1 AC220
AC300 AC310
AC311 AC32.1
AC37.1 AC45.1
AC47.2 AC472
AC473 AC490
ACUSET2 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC220 AC297
ACDR.1 ACTA.1
ACUSET3 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR*
AC121 AC123
AC127 AC130
AC145 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 AC297
AC32.1 AC37.1
AC421 AC47.2
AC473 AC490
AC93.3 AC96.1
AC96.4 AC98.2
ACDR.1 ACTA.1
ACUSET4 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
CURRENCY-CODE
FISCAL-YEAR
ACCT-CATEGORY
AC20.6 AC20.7
AC311
ACUSET5 ACTIVITY-GRP
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
KeyChange


ACCUAMT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 11:04:06 2016

Home
Contact Us



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