Lawson Insight Technical Documentation |
|
ACCUAMT
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 AC400 AC410 AC420 AC472
AC473 AC490 AC96.1 AC96.4 AC98.2 ACDL.1
AC295 ACTA.1 AC145 AC190 AC421 AC93.3
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACU-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity GroupRequired key. This is the activity AC127 AC20.1
group for the budget and actual amount AC20.2 AC20.3
information. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
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
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
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
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
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
ACU-VAR-LEVELS Alpha 30 AC121 AC123
Element: Variable LevelThis is the variable level for the AC127 AC20.1
budget and actual amount information. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
ACU-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
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
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
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
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
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
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
ACU-FACTOR-RATE Signed 14.7 AC121 AC123
Element: 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.
ACU-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Maintenance DaThe date last changed. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
ACU-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Sys Time The time last changed. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
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
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
ACU-PERIOD-RATE Signed 14.7 Occurs 13 Times AC121 AC123
Element: Rate AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
ACU-PERIOD-FACTOR Alpha 15 Occurs 13 Times AC121 AC123
Element: Factor AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
ACCUAMT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACUSET1 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
CURRENCY-CODE AC20.1 AC20.2
BUDGET-NBR AC20.3 AC20.4
FISCAL-YEAR AC20.5 AC20.6
ACCT-CATEGORY AC20.7 AC21.1
AC21.2 AC21.3
AC21.4 AC22.1
AC220 AC300
AC310 AC32.1
AC37.1 AC400
AC410 AC420
AC472 AC473
AC490 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
AC295 ACDR.1
ACTA.1
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
AC295 AC32.1
AC37.1 AC400
AC421 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
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
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
Cucodes CUCODES Not Required
ACU-CURRENCY-CODE -> CUC-CURRENCY-CODE
|