ACCUAMT – Activity Currency Amount

System: Activity Management (AC)
Prefix: ACU
Primary key: ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, BUDGET-NBR, FISCAL-YEAR, ACCT-CATEGORY
Fields: 24
Updated by: 18 programs
Referenced by: 19 programs

ACCUAMT is the Activity Currency Amount table in Lawson Activity Management (prefix ACU). It is indexed by ACTIVITY-GRP, ACTIVITY, CURRENCY-CODE, BUDGET-NBR, FISCAL-YEAR, ACCT-CATEGORY (ACUSET1); alternate indexes: ACUSET2, ACUSET3, ACUSET4 and ACUSET5. It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY, ACBUDDTL, ACBUDHDR, ACMASTER and CUCODES and 1:M to ACCOMMIT, ACCOMMITX and ACTRANS. It is updated by AC120, AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3 and 10 more and referenced by AC130, AC190, AC220, AC297, AC310, AC32.1, AC37.1, AC421 and 11 more. The table has 24 fields, 5 indexes and 10 documented relations.

About ACCUAMT

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.

Fields (24)

Column = COBOL field name without the ACU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ACU-ACTIVITY-GRP` PK ACTIVITY_GRP	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 +6 more
`ACU-ACTIVITY` PK 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 +5 more
`ACU-BUDGET-NBR` PK BUDGET_NBR	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 +5 more
`ACU-FISCAL-YEAR` PK 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 +5 more
`ACU-ACCT-CATEGORY` PK ACCT_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 +5 more
`ACU-CURRENCY-CODE` PK 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 +5 more
`ACU-VAR-LEVELS` VAR_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 +6 more
`ACU-PARENT-ACTV` 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 +6 more
`ACU-CURR-ND` CURR_ND	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 +5 more
`ACU-BALANCE-AMOUNT` BALANCE_AMOUNT	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 +5 more
`ACU-BALANCE-UNIT` BALANCE_UNIT	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 +5 more
`ACU-BEGIN-BAL-AMT` BEGIN_BAL_AMT	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 +5 more
`ACU-BEGIN-BAL-UNT` BEGIN_BAL_UNT	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 +5 more
`ACU-LTD-AMOUNT` LTD_AMOUNT	Derived	This is the sum of the Amount Balance and the Amount Beginning Balance fields for the fiscal year.	—
`ACU-LTD-UNIT` LTD_UNIT	Derived	This is the sum of the Unit Balance and the Unit Beginning Balance fields for the fiscal year.	—
`ACU-FACTOR` FACTOR	Alpha 15	The element that affects the budget change.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`ACU-FACTOR-RATE` 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 +5 more
`ACU-MAINT-DATE` MAINT_DATE	Numeric 8 (yyyymmdd)	The date last changed.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`ACU-MAINT-TIME` MAINT_TIME	Numeric 6 (hhmmss)	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`ACU-ACCT-CAT-TYPE` ACCT_CAT_TYPE	Derived	—	—
`ACU-PERIOD-AMT` PERIOD_AMT	Signed 18.2 Occurs 13 Times ×13	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`ACU-PERIOD-UNIT` PERIOD_UNIT	Signed 15.2 Occurs 13 Times ×13	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`ACU-PERIOD-RATE` PERIOD_RATE	Signed 14.7 Occurs 13 Times ×13	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 +5 more
`ACU-PERIOD-FACTOR` PERIOD_FACTOR	Alpha 15 Occurs 13 Times ×13	The element that affects the budget change.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`ACUSET1`	`ACTIVITY-GRP`, `ACTIVITY`, `CURRENCY-CODE`, `BUDGET-NBR`, `FISCAL-YEAR`, `ACCT-CATEGORY`	Primary	AC120, AC121, AC123, AC127, AC130, AC145, AC20.1, AC20.2 +22 more (list truncated in source)
`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 +8 more
`ACUSET3`	`ACTIVITY-GRP`, `ACTIVITY`, `CURRENCY-CODE`, `BUDGET-NBR`, `ACCT-CATEGORY`, `FISCAL-YEAR*`		AC121, AC123, AC127, AC130, AC145, AC190, AC20.1, AC20.2 +20 more
`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	—

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Field map
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`

One to many (3) — child tables

Relation	Table	Field map
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`

Programs

Updated by (18)

AC120 Level Reorganization
AC121 Budget Calculation
AC123 Budget Copy
AC127 Budget Interface
AC145 Mass Transaction Backout
AC20.1 Life Only Budget
AC20.2 Annual Budget
AC20.3 Period Budget
AC20.4 Activity Budgets by Activity
AC20.5 Activity Budgets by Account Category
AC20.6 Activity Group Budget Header
AC20.7 Activity Budget Header
AC21.5 Period Budget Change Order Import
AC22.1 Change Order Approval
AC300 Activity Group Purge
AC311 Purge and Archive
AC45.1 Transaction Edit
ACDR.1 AC Data Rebuild

Referenced by (19)

AC130 Allocation Calculation
AC190 Activity Posting
AC220 Budget Listing
AC297 Commitment Analysis Summary
AC310 Transaction Consolidation
AC32.1 Allocation Pool
AC37.1 Allocation Group
AC421 Change Order History
AC47.2 Commitment Totals
AC472 Bill of Activities
AC473 Profit and Loss Statement
AC490 Activity Reconciliation
AC527 AC to GL Budget Interface
AC93.3 Activity Group Output Measure Analysis Totals
AC96.1 Transaction Analysis
AC96.4 Transaction Analysis
AC98.2 Commitment Totals
ACDL.1 Olap Data Load
ACTA.1 Calculate to Date Totals