|
|
ACGLMAST FILE
AC GL Acct Unit Master
This file maintains posting-level activity balances by account category,
company, accounting unit, and year in the activity group base currency. This
file is updated by AC191 (AC Accounting Unit Posting).
AC170 (Revenue Calculation) uses this file to determine cost and revenue
amounts by accounting unit within an activity.
REFERENCED BY
ACDL.1 AC94.1 AC94.3 AC94.5 AC94.2 AC94.4
AC94.6 AC170
UPDATED BY
AC120 AC191 AC300 AC310 AC580 AC980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMT-ACTIVITY-GRP Alpha 15 AC120 AC191
Activity Group Required key. This is the activity AC580 AC980
group. 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.
GMT-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.
GMT-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).
GMT-COMPANY Numeric 4 AC120 AC191
Company Required key. This is the company AC580 AC980
number the transaction was posted to in
the general ledger.
GMT-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.
GMT-FISCAL-YEAR Numeric 4 AC120 AC191
Year Required key. This is the fiscal year. AC580 AC980
GMT-VAR-LEVELS Alpha 30 AC120 AC191
Variable Level This is the activity variable level, AC580 AC980
representing the location of an
accounting unit in an organization's
level structure.
GMT-BASE-ND Numeric 1 AC120 AC191
Base Number of The number of decimal positions defined AC580 AC980
Decimals for the activity group base currency.
GMT-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.
GMT-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.
GMT-BALANCE-AMOUNT Signed 17.2 AC120 AC191
Amount Balance This is the fiscal year amount balance. AC580 AC980
GMT-BALANCE-UNIT Signed 17.2 AC120 AC191
Units Balance This is the fiscal year units balance. AC580 AC980
GMT-LTD-AMOUNT Derived
Life-to-Date Amount This is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
GMT-LTD-UNIT Derived
Life-to-Date Units This is the sum of the Unit Balance and
the Unit Beginning Balance fields for
the fiscal year.
GMT-MAINT-DATE Numeric 8 (yyyymmdd) AC120 AC191
Maintenance Date The date last changed. AC580 AC980
GMT-MAINT-TIME Numeric 6 (hhmmss) AC120 AC191
Maintenance Time The time last changed. AC580 AC980
ACGLMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMTSET1 ACTIVITY-GRP AC120 AC191
ACTIVITY AC300 AC310
ACCT-CATEGORY AC580 AC980
COMPANY ACDL.1
ACCT-UNIT
FISCAL-YEAR
GMTSET2 ACTIVITY-GRP
ACTIVITY
COMPANY
ACCT-UNIT
FISCAL-YEAR
ACCT-CATEGORY
GMTSET3 ACTIVITY-GRP AC94.1 AC94.3
ACTIVITY AC94.5
ACCT-CATEGORY
FISCAL-YEAR
COMPANY
ACCT-UNIT
GMTSET4 ACTIVITY-GRP
ACTIVITY
FISCAL-YEAR
ACCT-CATEGORY
COMPANY
ACCT-UNIT
GMTSET5 ACTIVITY-GRP AC120 AC170
ACTIVITY AC191 AC580
ACCT-CATEGORY AC94.1 AC94.2
COMPANY AC94.3 AC94.4
ACCT-UNIT AC94.5 AC94.6
FISCAL-YEAR* AC980
ACGLMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
GMT-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
GMT-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
GMT-ACTIVITY -> ACV-ACTIVITY
Acgltotrev ACGLTOTREV Not Required
GMT-ACTIVITY -> GRV-ACTIVITY
GMT-ACCT-CATEGORY -> GRV-ACCT-CATEGORY
GMT-COMPANY -> GRV-COMPANY
GMT-ACCT-UNIT -> GRV-ACCT-UNIT
Aclevel ACLEVEL Required
GMT-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
GMT-VAR-LEVELS -> LVL-VAR-LEVELS
Glnames GLNAMES Not Required
GMT-COMPANY -> GLN-COMPANY
GMT-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
GMT-COMPANY -> GLS-COMPANY
ACGLMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acglmastx ACGLMASTX
GMT-ACTIVITY-GRP -> GMX-ACTIVITY-GRP
GMT-ACTIVITY -> GMX-ACTIVITY
GMT-ACCT-CATEGORY -> GMX-ACCT-CATEGORY
GMT-COMPANY -> GMX-COMPANY
GMT-ACCT-UNIT -> GMX-ACCT-UNIT
GMT-FISCAL-YEAR -> GMX-FISCAL-YEAR
GMX-PERIOD
|