ACGLCONSL – AC GL Acct Unit Consolidation

System: Activity Management (AC)
Prefix: GCO
Primary key: FISCAL-YEAR, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE
Fields: 20
Updated by: 20 programs
Referenced by: 9 programs

ACGLCONSL is the AC GL Acct Unit Consolidation table in Lawson Activity Management (prefix GCO). It is indexed by FISCAL-YEAR, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE (GCOSET1); alternate indexes: GCOSET2, GCOSET3, GCOSET5, GCOSET8 and GCOSET9. It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY, GLNAMES and GLSYSTEM. It is updated by AC10.1, AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4 and 12 more and referenced by AC130, AC32.1, AC37.1, AC490, AC92.1, AC92.2, AC92.4, AC92.6 and 1 more. The table has 20 fields, 6 indexes and 5 documented relations.

About ACGLCONSL

This file maintains summary-level activity consolidation balances by account category, company, accounting unit, and year in the activity group base currency. Whether this file is updated depends on the value in the Accounting Unit Detail field on AC00.1 (Activity Group), which is stored in the Activity Group file. This file is updated by AC191 (AC Accounting Unit Posting).

Fields (20)

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

Field / column	Type	Description & values	Updated by
`GCO-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	Required key. This is the fiscal year.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-ACTIVITY-GRP` PK ACTIVITY_GRP	Alpha 15	Required key. An activity group or activity center is a group of activities related by process or function. An activity group is the highest entity for which you can inquire and report on costs, revenues, and budgets in the Activity Management system. An activity group is set up to budget for, report on, process, and store information common to one or more activities. You must set up an activity group before you can set up activities, budgets, transactions, and inquiries. To collect costs and revenues, at least one activity must be linked to an activity group.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-ACTIVITY` PK ACTIVITY	Alpha 15	Required key. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Lawson Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-ACCT-CATEGORY` PK ACCT_CATEGORY	Alpha 5	Required key. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Lawson Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-COMPANY` PK COMPANY	Numeric 4	Required key. This is the company number the transaction was posted to in the general ledger.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	Required key. This is the accounting unit the transaction was posted to in the general ledger. The accounting unit is a shorthand notation representing the variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-RESOURCE-TYPE` PK RESOURCE_TYPE	Alpha 1	The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset `A` Asset `E` Employee `P` AC Person `Q` Equipment `V` Vendor	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-RESOURCE-COMP` PK RESOURCE_COMP	Numeric 4	Resource Company. Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for resource type A, P, or Q resources.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-RESOURCE-CODE` PK RESOURCE_CODE	Alpha 10	The code identifying the resource assigned to the activity or activity group.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-LEVEL-DEPTH` LEVEL_DEPTH	Numeric 1	This is the level depth number for the activity.	—
`GCO-VAR-LEVELS` VAR_LEVELS	Alpha 30	This is the activity variable level. A variable level represents the location of an accounting unit in an organization's level structure.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-PARENT-ACTV` PARENT_ACTV	Alpha 15	The parent activity field contains the activity name of the member parent.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the activity group base currency.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-BALANCE-AMOUNT` BALANCE_AMOUNT	Signed 18.2	This is the amount balance for the fiscal year.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
`GCO-BALANCE-UNIT` BALANCE_UNIT	Signed 17.2	This is the units balance for the fiscal year.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
`GCO-BEGIN-BAL-AMT` BEGIN_BAL_AMT	Signed 18.2	This is the life-to-date amount up to the start of the current fiscal year.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
`GCO-BEGIN-BAL-UNT` BEGIN_BAL_UNT	Signed 15.2	This is the life-to-date number of units up to the start of the current fiscal year.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
`GCO-RESOURCE-DESC` RESOURCE_DESC	Alpha 30 (Lower Case)	This field displays the description.	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
`GCO-PERIOD-AMT` PERIOD_AMT	Signed 18.2 Occurs 13 Times ×13	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
`GCO-PERIOD-UNIT` PERIOD_UNIT	Signed 15.2 Occurs 13 Times ×13	—	AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more

Indexes (6)

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
`GCOSET1`	`FISCAL-YEAR`, `ACTIVITY-GRP`, `ACTIVITY`, `ACCT-CATEGORY`, `COMPANY`, `ACCT-UNIT`, `RESOURCE-TYPE`, `RESOURCE-COMP`, `RESOURCE-CODE`	Primary		AC121, AC123, AC127, AC130, AC20.1, AC20.2, AC20.3, AC20.4 +12 more
`GCOSET2`	`ACTIVITY-GRP`, `ACTIVITY`, `ACCT-CATEGORY`, `FISCAL-YEAR`, `RESOURCE-TYPE`, `RESOURCE-COMP`, `RESOURCE-CODE`, `COMPANY`, `ACCT-UNIT`			AC10.1, AC300, AC92.4, AC92.6, AC94.2, AC94.4, AC94.6, ACDL.1 +1 more
`GCOSET3`	`ACTIVITY-GRP`, `ACTIVITY`, `ACCT-CATEGORY`, `COMPANY`, `ACCT-UNIT`, `RESOURCE-TYPE`, `RESOURCE-COMP`, `RESOURCE-CODE`, `FISCAL-YEAR*`			AC121, AC123, AC127, AC130, AC20.1, AC20.2, AC20.3, AC20.4 +17 more
`GCOSET5`	`COMPANY`, `ACCT-UNIT`, `ACCT-CATEGORY`, `ACTIVITY-GRP`, `ACTIVITY`, `FISCAL-YEAR`, `RESOURCE-TYPE`, `RESOURCE-COMP`, `RESOURCE-CODE`	KeyChange		—
`GCOSET8`	`ACTIVITY-GRP`, `ACTIVITY`, `ACCT-CATEGORY`, `COMPANY`, `ACCT-UNIT`, `RESOURCE-TYPE`, `RESOURCE-COMP`, `RESOURCE-CODE`, `FISCAL-YEAR`	KeyChange		AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +6 more
`GCOSET9`	`RESOURCE-TYPE`, `RESOURCE-COMP`, `RESOURCE-CODE`, `ACTIVITY-GRP`, `ACTIVITY`, `ACCT-CATEGORY`, `FISCAL-YEAR`, `COMPANY`, `ACCT-UNIT`	KeyChange, Subset	Where RESOURCE-TYPE != Spaces	—

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Field map
Acacctcat	ACACCTCAT	Required	`GCO-ACCT-CATEGORY` → `AAX-ACCT-CATEGORY (AAXSET1)`
Acactgrp	ACACTGRP	Required	`GCO-ACTIVITY-GRP` → `AGP-ACTIVITY-GRP`
Acactivity	ACACTIVITY	Required	`GCO-ACTIVITY` → `ACV-ACTIVITY`
Glnames	GLNAMES	Not Required	`GCO-COMPANY` → `GLN-COMPANY`, `GCO-ACCT-UNIT` → `GLN-ACCT-UNIT`
Glsystem	GLSYSTEM	Not Required	`GCO-COMPANY` → `GLS-COMPANY`

Programs

Updated by (20)

AC10.1 Activity
AC121 Budget Calculation
AC123 Budget Copy
AC127 Budget Interface
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
AC494 Activity Accounting Unit Analysis
AC94.1 Activity Accounting Unit Analysis
AC94.2 Activity, Account Category Analysis
AC94.4 Company, Accounting Unit Analysis
AC94.6 Account Category Analysis
ACDR.1 AC Data Rebuild

Referenced by (9)

AC130 Allocation Calculation
AC32.1 Allocation Pool
AC37.1 Allocation Group
AC490 Activity Reconciliation
AC92.1 Resource Analysis
AC92.2 Resource
AC92.4 Activity Resource Balances
AC92.6 Activity, Account Category Resource Balances
ACDL.1 Olap Data Load