|
|
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
AC94.1 AC94.3 AC94.5 AC94.2 AC94.4 AC94.6
UPDATED BY
AC120 AC191 AC300 AC310 AC580 AC980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCO-FISCAL-YEAR Numeric 4 AC120 AC191
Year Required key. This is the fiscal year. AC580 AC980
GCO-ACTIVITY-GRP Alpha 15 AC120 AC191
Activity Group Required key. An activity group or AC580 AC980
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.
GCO-ACTIVITY Alpha 15 AC120 AC191
Activity Required key. Activities are the AC580 AC980
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.
GCO-ACCT-CATEGORY Alpha 5 AC120 AC191
Account Category Required key. Account categories are AC580 AC980
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.
GCO-COMPANY Numeric 4 AC120 AC191
Company Required key. This is the company AC580 AC980
number the transaction was posted to in
the general ledger.
GCO-ACCT-UNIT Alpha 15 AC120 AC191
Accounting Unit Required key. This is the accounting AC580 AC980
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.
GCO-LEVEL-DEPTH Numeric 1 AC120 AC191
Level Depth This is the level depth number for the AC580 AC980
activity.
GCO-VAR-LEVELS Alpha 30 AC120 AC191
Variable Level This is the activity variable level. A AC580 AC980
variable level represents the location
of an accounting unit in an
organization's level structure.
GCO-BASE-ND Numeric 1 AC120 AC191
Base Number of The number of decimal positions defined AC580 AC980
Decimals for the activity group base currency.
GCO-BALANCE-AMOUNT Signed 17.2 AC120 AC191
Amount Balance This is the amount balance for the AC580 AC980
fiscal year.
GCO-BALANCE-UNIT Signed 17.2 AC120 AC191
Units Balance This is the units balance for the AC580 AC980
fiscal year.
GCO-BEGIN-BAL-AMT Signed 15.2 AC120 AC191
Beginning Amount This is the life-to-date amount up to AC580 AC980
Balance the start of the current fiscal year.
GCO-BEGIN-BAL-UNT Signed 15.2 AC120 AC191
Beginning Units This is the life-to-date number of AC580 AC980
Balance units up to the start of the current
fiscal
year.
ACGLCONSL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCOSET1 FISCAL-YEAR AC120 AC191
ACTIVITY-GRP AC580 AC980
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
GCOSET2 ACTIVITY-GRP AC120 AC300
ACTIVITY AC580 AC94.1
ACCT-CATEGORY AC94.3 AC94.5
FISCAL-YEAR
COMPANY
ACCT-UNIT
GCOSET3 ACTIVITY-GRP AC120 AC191
ACTIVITY AC310 AC580
ACCT-CATEGORY AC94.1 AC94.2
COMPANY AC94.3 AC94.4
ACCT-UNIT AC94.5 AC94.6
FISCAL-YEAR* AC980
ACGLCONSL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
GCO-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
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
ACGLCONSL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acglconslx ACGLCONSLX
GCO-ACTIVITY-GRP -> GCX-ACTIVITY-GRP
GCO-ACTIVITY -> GCX-ACTIVITY
GCO-ACCT-CATEGORY -> GCX-ACCT-CATEGORY
GCO-COMPANY -> GCX-COMPANY
GCO-ACCT-UNIT -> GCX-ACCT-UNIT
GCO-FISCAL-YEAR -> GCX-FISCAL-YEAR
GCX-PERIOD
|