AC GL Acct Unit Consolidation

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).

REFERENCED BY

AC494

ACDL.1

UPDATED BY

AC121	AC123	AC127	AC130	AC20.1	AC20.2
AC20.3	AC20.4	AC20.5	AC20.6	AC20.7	AC21.5
AC22.1	AC300	AC32.1	AC37.1	AC490	AC92.1
AC92.2	AC92.4	AC92.6	AC94.1	AC94.2	AC94.4
AC94.6	ACDR.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GCO-FISCAL-YEAR Element: Year	Numeric 4 Required key. This is the fiscal year.	AC121 AC123 AC127 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-ACTIVITY-GRP Element: Activity Group	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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-ACTIVITY Element: 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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-ACCT-CATEGORY Element: Account 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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-COMPANY Element: 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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-ACCT-UNIT Element: Accounting 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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-RESOURCE-TYPE Element: 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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-RESOURCE-COMP Element: Company	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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-RESOURCE-CODE Element: 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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-LEVEL-DEPTH Element: Level Depth	Numeric 1 This is the level depth number for the activity.
GCO-VAR-LEVELS Element: Variable Level	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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-PARENT-ACTV Element: 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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-BASE-ND Base Number of Decimals	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 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-BALANCE-AMOUNT Element: Amount Balance	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 AC20.6 AC20.7 AC21.5 AC22.1 AC92.2 AC92.4 AC92.6 AC94.2 AC94.4 AC94.6 ACDR.1
GCO-BALANCE-UNIT Element: Units Balance	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 AC20.6 AC20.7 AC21.5 AC22.1 AC92.2 AC92.4 AC92.6 AC94.2 AC94.4 AC94.6 ACDR.1
GCO-BEGIN-BAL-AMT Beginning Amount Balance	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 AC20.6 AC20.7 AC21.5 AC22.1 AC92.2 AC92.4 AC92.6 AC94.2 AC94.4 AC94.6 ACDR.1
GCO-BEGIN-BAL-UNT Beginning Units Balance	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 AC20.6 AC20.7 AC21.5 AC22.1 AC92.2 AC92.4 AC92.6 AC94.2 AC94.4 AC94.6 ACDR.1
GCO-RESOURCE-DESC Element: Description	Alpha 30 (Lower Case) This field displays the description.	AC121 AC123 AC127 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.5 AC22.1 ACDR.1
GCO-PERIOD-AMT Element: Intl Amt	Signed 18.2 Occurs 13 Times	AC121 AC123 AC127 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.5 AC22.1 AC92.2 AC92.4 AC92.6 AC94.2 AC94.4 AC94.6 ACDR.1
GCO-PERIOD-UNIT Element: Unit	Signed 15.2 Occurs 13 Times	AC121 AC123 AC127 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.5 AC22.1 AC92.2 AC92.4 AC92.6 AC94.2 AC94.4 AC94.6 ACDR.1

ACGLCONSL FILE INDEX

ACGLCONSL FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.