ACSUMBAL – No description in the Lawson data dictionary

System: Activity Management (AC)
Prefix: SMB
Primary key: ACTIVITY-GRP, ACTIVITY, SUM-ACCT-CAT, BUDGET-NBR, FISCAL-YEAR
Fields: 11
Updated by: 16 programs
Referenced by: 1 program

ACSUMBAL is a Lawson Activity Management table (prefix SMB); no description in the lawson data dictionary. It is indexed by ACTIVITY-GRP, ACTIVITY, SUM-ACCT-CAT, BUDGET-NBR, FISCAL-YEAR (SMBSET1); alternate indexes: SMBSET2. It is updated by AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3, AC20.4 and 8 more and referenced by ACTA.1. The table has 11 fields, 2 indexes and 0 documented relations.

About ACSUMBAL

No description in the Lawson data dictionary.

Fields (11)

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

Field / column	Type	Description & values	Updated by
`SMB-ACTIVITY-GRP` PK ACTIVITY_GRP	Alpha 15	The activity group is the overall project.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`SMB-ACTIVITY` PK ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`SMB-SUM-ACCT-CAT` PK SUM_ACCT_CAT	Alpha 5	The name of the summary account category.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`SMB-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	This is the current fiscal year. This field is updated by Period Closing (GL199).	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`SMB-BEGIN-BAL-AMT` BEGIN_BAL_AMT	Signed 18.2	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more
`SMB-BEGIN-BAL-UNIT` BEGIN_BAL_UNIT	Signed 17.2	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more
`SMB-BALANCE-AMT` BALANCE_AMT	Signed 18.2	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more
`SMB-BALANCE-UNIT` BALANCE_UNIT	Signed 17.2	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more
`SMB-PERIOD-AMT` PERIOD_AMT	Signed 18.2 Occurs 13 Times ×13	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more
`SMB-PERIOD-UNIT` PERIOD_UNIT	Signed 15.2 Occurs 13 Times ×13	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more
`SMB-BUDGET-NBR` PK BUDGET_NBR	Numeric 3	The Budget Number field contains the budget number.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`SMBSET1`	`ACTIVITY-GRP`, `ACTIVITY`, `SUM-ACCT-CAT`, `BUDGET-NBR`, `FISCAL-YEAR`	Primary		AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3, AC20.4 +9 more
`SMBSET2`	`ACTIVITY-GRP`, `ACTIVITY`, `SUM-ACCT-CAT`, `BUDGET-NBR`, `FISCAL-YEAR*`			AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more

Programs

Updated by (16)

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
AC45.1 Transaction Edit
ACDR.1 AC Data Rebuild

Referenced by (1)

ACTA.1 Calculate to Date Totals