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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#SMB-ACTIVITY-GRP PKACTIVITY_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 PKACTIVITY | 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 PKSUM_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 PKFISCAL_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-AMTBEGIN_BAL_AMT | Signed 18.2 | — | AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more |
#SMB-BEGIN-BAL-UNITBEGIN_BAL_UNIT | Signed 17.2 | — | AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more |
#SMB-BALANCE-AMTBALANCE_AMT | Signed 18.2 | — | AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more |
#SMB-BALANCE-UNITBALANCE_UNIT | Signed 17.2 | — | AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more |
#SMB-PERIOD-AMTPERIOD_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-UNITPERIOD_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 PKBUDGET_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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
SMBSET1 |
| Primary | AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3, AC20.4 +9 more | |
SMBSET2 |
| 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