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.4 AC220 AC32.1
AC37.1 AC410 AC420 AC472 AC473 AC490
AC96.1 AC98.2 ACDL.1 AC295 AC297 AC400
AC421 AC93.3 ACTA.1
UPDATED BY
AC121 AC123 AC127 AC190 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.7 AC20.6 AC22.1
AC300 AC310 AC45.1 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 AC190
group for the budget and actual amount AC20.1 AC20.2
information. AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Required key. This is the activity for AC127 AC190
the budget and actual amount AC20.1 AC20.2
information. AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Number Required key. This is the budget number AC127 AC190
for the budget and actual amount AC20.1 AC20.2
information. AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Fiscal Year Required key. This is the fiscal year AC127 AC190
for the budget and actual amount AC20.1 AC20.2
information.. AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-ACCT-CATEGORY Alpha 5 AC121 AC123
Element: Account CategoRequired key. This is the account AC127 AC190
category for the budget and actual AC20.1 AC20.2
amount information. AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-CURRENCY-CODE Alpha 5 AC121 AC123
Element: Currency Code Required key. This field contains the AC127 AC190
base currency code for the activity AC20.1 AC20.2
group. It is defined in AC00.1 (Activity AC20.3 AC20.4
Group). AC20.5 AC22.1
ACDR.1
ACU-VAR-LEVELS Alpha 30 AC121 AC123
Element: Variable LevelThis is the variable level for the AC127 AC190
budget and actual amount information. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-PARENT-ACTV Alpha 15 AC121 AC123
Element: Parent Actv AC127 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-CURR-ND Numeric 1 AC121 AC123
Currency Number of This field defines the number of AC127 AC190
Decimals decimals for the budget currency. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-BALANCE-AMOUNT Signed 17.2 AC121 AC123
Element: Amount BalanceThis is the amount balance for the AC127 AC190
current year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Units Balance This is the unit balance for the AC127 AC190
current year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
ACDR.1
ACU-BEGIN-BAL-AMT Signed 15.2 AC121 AC123
Amount Beginning This is the life-to-date amount up AC127 AC190
Balance until the start of the current year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 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 AC190
Balance the start of the current year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 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
AC22.1
ACU-FACTOR-RATE Signed 12.6 AC121 AC123
Element: Account Rate AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC22.1
ACU-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Date AC127 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
AC45.1 ACDR.1
ACU-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Sys Time AC127 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
AC45.1 ACDR.1
ACU-ACCT-CAT-TYPE Derived
Element: Acct Cat Type
ACCUAMT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACUSET1 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
CURRENCY-CODE AC190 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.4 AC22.1
AC220 AC300
AC310 AC32.1
AC37.1 AC410
AC420 AC45.1
AC472 AC473
AC490 AC96.1
AC98.2 ACDL.1
...
ACUSET10 FISCAL-YEAR
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
ACCT-CATEGORY
BUDGET-NBR
ACUSET2 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC20.1
CURRENCY-CODE AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
ACCT-CATEGORY AC22.1 AC220
FISCAL-YEAR
ACUSET3 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
CURRENCY-CODE AC190 AC20.1
BUDGET-NBR AC20.2 AC20.3
ACCT-CATEGORY AC20.4 AC20.5
FISCAL-YEAR* AC22.1 AC295
AC297 AC32.1
AC37.1 AC400
AC421 AC473
AC490 AC93.3
AC96.1 AC98.2
ACDR.1 ACTA.1
ACUSET4 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
CURRENCY-CODE
FISCAL-YEAR
ACCT-CATEGORY
ACUSET5 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
FISCAL-YEAR
BUDGET-NBR
ACCT-CATEGORY
ACUSET6 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
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
ACU-CURRENCY-CODE -> ACX-CURRENCY-CODE
Zeroes -> ACX-BUDGET-NBR
ACU-FISCAL-YEAR -> ACX-FISCAL-YEAR
ACU-ACCT-CATEGORY -> ACX-ACCT-CATEGORY
ACX-PERIOD
Accuamtx Bud ACCUAMTX
Valid When ACU-BUDGET-NBR != Zeroes
ACU-ACTIVITY-GRP -> ACX-ACTIVITY-GRP
ACU-ACTIVITY -> ACX-ACTIVITY
ACU-CURRENCY-CODE -> ACX-CURRENCY-CODE
ACU-BUDGET-NBR -> ACX-BUDGET-NBR
ACU-FISCAL-YEAR -> ACX-FISCAL-YEAR
ACU-ACCT-CATEGORY -> ACX-ACCT-CATEGORY
ACX-PERIOD
|