Lawson Insight Technical Documentation |
|
ACGLCONSL
ACGLCONSL FILE
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
AC130 AC32.1 AC37.1 AC490 AC92.2 AC92.4
AC92.6 AC92.1 AC494 AC94.2 AC94.4 AC94.6
AC94.1 ACDL.1
UPDATED BY
AC121 AC123 AC127 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC22.1 AC300
AC310 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCO-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Year Required key. This is the fiscal year. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
GCO-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity GroupRequired key. An activity group or AC127 AC20.1
activity center is a group of activities AC20.2 AC20.3
related by process or function. An AC20.4 AC20.5
activity group is the highest entity for AC20.6 AC20.7
which you can inquire and report on AC22.1 ACDR.1
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.
GCO-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Required key. Activities are the AC127 AC20.1
processes or procedures that produce AC20.2 AC20.3
work. Cost objects (products, services, AC20.4 AC20.5
customers, and so on) are the reasons AC20.6 AC20.7
for performing the activity. Activities AC22.1 ACDR.1
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.
GCO-ACCT-CATEGORY Alpha 5 AC121 AC123
Element: Account CategoRequired key. Account categories are AC127 AC20.1
groupings of costs, revenues, or a AC20.2 AC20.3
combination of both used for reporting AC20.4 AC20.5
and inquiries for activities in the AC20.6 AC20.7
Lawson Activity Management system. All AC22.1 ACDR.1
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.
GCO-COMPANY Numeric 4 AC121 AC123
Element: Company Required key. This is the company AC127 AC20.1
number the transaction was posted to in AC20.2 AC20.3
the general ledger. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
GCO-ACCT-UNIT Alpha 15 AC121 AC123
Element: Accounting UniRequired key. This is the accounting AC127 AC20.1
unit the transaction was posted to in AC20.2 AC20.3
the general ledger. The accounting unit AC20.4 AC20.5
is a shorthand notation representing the AC20.6 AC20.7
variable level number. The accounting AC22.1 ACDR.1
unit must be defined in the General
Ledger Names file as a posting
accounting unit.
GCO-RESOURCE-TYPE Alpha 1 AC121 AC123
Element: Resource Type The type of resource. Valid values AC127 AC20.1
include: AC20.2 AC20.3
P - AC Person AC20.4 AC20.5
Q - Equipment AC20.6 AC20.7
E - Employee AC22.1 ACDR.1
V - Vendor
A - Asset
A = Asset
E = Employee
P = AC Person
Q = Equipment
V = Vendor
GCO-RESOURCE-COMP Numeric 4 AC121 AC123
Element: Company Resource Company. Identifies the AP AC127 AC20.1
company if the resource type = V. AC20.2 AC20.3
Identifies the HR company if the AC20.4 AC20.5
resource type = E. It is blank for AC20.6 AC20.7
resource type A, P, or Q resources. AC22.1 ACDR.1
GCO-RESOURCE-CODE Alpha 10 AC121 AC123
Element: Resource Code The code identifying the resource AC127 AC20.1
assigned to the activity or activity AC20.2 AC20.3
group. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
GCO-LEVEL-DEPTH Numeric 1
Element: Level Depth This is the level depth number for the
activity.
GCO-VAR-LEVELS Alpha 30 AC121 AC123
Element: Variable LevelThis is the activity variable level. A AC127 AC20.1
variable level represents the location AC20.2 AC20.3
of an accounting unit in an AC20.4 AC20.5
organization's level structure. AC20.6 AC20.7
AC22.1 ACDR.1
GCO-PARENT-ACTV Alpha 15 AC121 AC123
Element: Parent Actv The parent activity field contains the AC127 AC20.1
activity name of the member parent. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
GCO-BASE-ND Numeric 1 AC121 AC123
Base Number of The number of decimal positions defined AC127 AC20.1
Decimals for the activity group base currency. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
GCO-BALANCE-AMOUNT Signed 18.2 AC121 AC123
Element: Amount BalanceThis is the amount balance for the AC127 AC20.1
fiscal year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC92.2
AC92.4 AC92.6
AC94.2 AC94.4
AC94.6 ACDR.1
GCO-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Units Balance This is the units balance for the AC127 AC20.1
fiscal year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC92.2
AC92.4 AC92.6
AC94.2 AC94.4
AC94.6 ACDR.1
GCO-BEGIN-BAL-AMT Signed 18.2 AC121 AC123
Beginning Amount This is the life-to-date amount up to AC127 AC20.1
Balance the start of the current fiscal year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC92.2
AC92.4 AC92.6
AC94.2 AC94.4
AC94.6 ACDR.1
GCO-BEGIN-BAL-UNT Signed 15.2 AC121 AC123
Beginning Units This is the life-to-date number of AC127 AC20.1
Balance units up to the start of the current AC20.2 AC20.3
fiscal AC20.4 AC20.5
year. AC20.6 AC20.7
AC22.1 AC92.2
AC92.4 AC92.6
AC94.2 AC94.4
AC94.6 ACDR.1
GCO-RESOURCE-DESC Alpha 30 (Lower Case) AC121 AC123
Element: Description AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
GCO-PERIOD-AMT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC92.2
AC92.4 AC92.6
AC94.2 AC94.4
AC94.6 ACDR.1
GCO-PERIOD-UNIT Signed 15.2 Occurs 13 Times AC121 AC123
Element: Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC92.2
AC92.4 AC92.6
AC94.2 AC94.4
AC94.6 ACDR.1
ACGLCONSL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCOSET1 FISCAL-YEAR AC121 AC123
ACTIVITY-GRP AC127 AC130
ACTIVITY AC20.1 AC20.2
ACCT-CATEGORY AC20.3 AC20.4
COMPANY AC20.5 AC20.6
ACCT-UNIT AC20.7 AC22.1
RESOURCE-TYPE AC32.1 AC37.1
RESOURCE-COMP AC490 AC92.2
RESOURCE-CODE AC92.4 AC92.6
ACDR.1
GCOSET2 ACTIVITY-GRP AC300 AC494
ACTIVITY AC92.4 AC92.6
ACCT-CATEGORY AC94.2 AC94.4
FISCAL-YEAR AC94.6 ACDL.1
RESOURCE-TYPE ACDR.1
RESOURCE-COMP
RESOURCE-CODE
COMPANY
ACCT-UNIT
GCOSET3 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
ACCT-CATEGORY AC20.1 AC20.2
COMPANY AC20.3 AC20.4
ACCT-UNIT AC20.5 AC20.6
RESOURCE-TYPE AC20.7 AC22.1
RESOURCE-COMP AC310 AC32.1
RESOURCE-CODE AC37.1 AC490
FISCAL-YEAR* AC92.1 AC92.2
AC92.4 AC92.6
AC94.1 AC94.2
AC94.4 AC94.6
ACDR.1
GCOSET5 COMPANY KeyChange
ACCT-UNIT
ACCT-CATEGORY
ACTIVITY-GRP
ACTIVITY
FISCAL-YEAR
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
GCOSET8 ACTIVITY-GRP KeyChange AC121 AC123
ACTIVITY AC127 AC20.1
ACCT-CATEGORY AC20.2 AC20.3
COMPANY AC20.4 AC20.5
ACCT-UNIT AC20.6 AC20.7
RESOURCE-TYPE AC22.1 ACDR.1
RESOURCE-COMP
RESOURCE-CODE
FISCAL-YEAR
GCOSET9 RESOURCE-TYPE KeyChange, Subset
RESOURCE-COMP Where RESOURCE-TYPE != Spaces
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
COMPANY
ACCT-UNIT
ACGLCONSL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|