ACGLACCT – Activity GL Accounts
- System
- Activity Management (AC)
- Prefix
AGA- Primary key
ACTIVITY-GRP,ACTIVITY,ACCT-CATEGORY,SEQ-NUMBER- Fields
- 9
- Updated by
- 8 programs
- Referenced by
- 3 programs
ACGLACCT is the Activity GL Accounts table in Lawson Activity Management (prefix AGA). It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, SEQ-NUMBER (AGASET1); alternate indexes: AGASET2 and AGASET3. It is related 1:1 to ACACTGRP and ACACTIVITY. It is updated by AC00.1, AC07.1, AC10.1, AC105, AC110, AC120, AC300 and AC560 and referenced by AC08.3, AC207 and ACAC.1. The table has 9 fields, 3 indexes and 2 documented relations.
About ACGLACCT
This file contains valid general ledger accounts in the Activity Management system. The file contains activity group, activity, account category, the account field, and account group, as well as beginning and ending values and an Include/Exclude flag. Activity Management system general ledger account records are created by AC07.1 (Account Assignment). All Lawson subsystems verify accounts in this file if general ledger account editing in Activity Management is specified. This file can be listed by running AC207 (Account Assignment Listing).
Fields (9)
Column = COBOL field name without the AGA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AGA-ACTIVITY-GRP PKACTIVITY_GRP | Alpha 15 | Key field. This is the activity group for the general ledger accounts. | AC07.1, AC105, AC110, AC120, AC560 |
AGA-ACTIVITY PKACTIVITY | Alpha 15 | Required key. This is the activity for the general ledger accounts. The All Activities flag is valid. Use All to signify all activities in the activity group. | AC07.1, AC105, AC110, AC120, AC560 |
AGA-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | Required key. This is the account category for the general ledger accounts. The All Account Categories flag is valid. Use All to signify all account categories for the activity group and activity. | AC07.1, AC105 |
AGA-SEQ-NUMBER PKSEQ_NUMBER | Numeric 6 | Key field. This is the sequence number. | AC07.1, AC105 |
AGA-ACCT-FIELDACCT_FIELD | Numeric 1 | Required. This field indicates the account field you are defining values for.
| AC07.1, AC105 |
AGA-INC-EXC-FLAGINC_EXC_FLAG | Alpha 1 | Required. Select Include or Exclude to indicate whether the value or value range is included in or excluded from an account. List values and ranges to be excluded first.
| AC07.1, AC105 |
AGA-BEG-VALBEG_VAL | Alpha 15 | Required. Enter a beginning value that is valid for the account field you are defining. For example, if you select Accounting Unit in the Account field, the value in this field must be a valid accounting unit. | AC07.1, AC105 |
AGA-END-VALEND_VAL | Alpha 15 | Optional. An ending value is only required if you define a range of more than one value. You can enter an ending value that is valid for the account field you are defining. For example, if you select Accounting Unit in the Account field, the value in this field must be a valid accounting unit. | AC07.1, AC105 |
AGA-ACCOUNT-GRPACCOUNT_GRP | Alpha 1 | Required. Use the account group to group Account field definitions into groups of values and ranges that define conditions. Within an account group, all value and range criteria associated with the group must be met for the condition. An account only needs to meet the value and range criteria of one account group (although the account can meet criteria for more than one group). | AC07.1, AC105 |
Indexes (3)
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 |
|---|---|---|---|---|
AGASET1 | ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, SEQ-NUMBER | Primary | AC00.1, AC07.1, AC08.3, AC10.1, AC105, AC110, AC120, AC300 +2 more | |
AGASET2 | ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, ACCOUNT-GRP, ACCT-FIELD, BEG-VAL, SEQ-NUMBER | KeyChange | AC07.1, AC105, AC207, ACAC.1 | |
AGASET3 | ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, ACCOUNT-GRP, ACCT-FIELD, INC-EXC-FLAG, SEQ-NUMBER | KeyChange | AC07.1, AC105 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acactgrp | ACACTGRP | Required | AGA-ACTIVITY-GRP → AGP-ACTIVITY-GRP | |
| Acactivity | ACACTIVITY | Not Required | AGA-ACTIVITY-GRP → ACV-ACTIVITY-GRP, AGA-ACTIVITY → ACV-ACTIVITY |
Programs
Updated by (8)
- AC00.1 Activity Group
- AC07.1 Account Assignment
- AC10.1 Activity
- AC105 Assignment Copy
- AC110 Activity Copy
- AC120 Level Reorganization
- AC300 Activity Group Purge
- AC560 Setup Interface