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
AC494 ACDL.1 AC121 AC123 AC130 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC30.2 AC30.3
AC32.1 AC490 AC92.1 AC92.2 AC92.4 AC92.6
AC94.1 AC94.2 AC94.4 AC94.6
UPDATED BY
AC191 AC300 AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMT-ACTIVITY-GRP Alpha 15 AC191 AC45.1
Activity Group Required key. This is the activity ACDR.1
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 AC191 AC45.1
Activity Required key. Activities are the ACDR.1
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 AC191 AC45.1
Account Category Required key. Account categories are ACDR.1
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 AC191 AC45.1
Company Required key. This is the company ACDR.1
number the transaction was posted to in
the general ledger.
GMT-ACCT-UNIT Alpha 15 AC191 AC45.1
Accounting Unit Required key. This is the accounting ACDR.1
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-RESOURCE-CODE Alpha 10 AC191 AC45.1
Resource Code ACDR.1
GMT-RESOURCE-TYPE Alpha 1 AC191 AC45.1
Resource Type ACDR.1
GMT-FISCAL-YEAR Numeric 4 AC191 AC45.1
Year Required key. This is the fiscal year. ACDR.1
GMT-VAR-LEVELS Alpha 30 AC191 AC45.1
Variable Level This is the activity variable level, ACDR.1
representing the location of an
accounting unit in an organization's
level structure.
GMT-PARENT-ACTV Alpha 15 AC191 AC45.1
Parent Actv ACDR.1
GMT-BASE-ND Numeric 1 AC191 AC45.1
Base Number of The number of decimal positions defined ACDR.1
Decimals for the activity group base currency.
GMT-BEGIN-BAL-AMT Signed 15.2 AC191 AC45.1
Beginning Amount This is the life-to-date amount up to AC92.2 AC92.4
Balance the start of the current fiscal year. AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMT-BEGIN-BAL-UNT Signed 15.2 AC191 AC45.1
Beginning Units This is the life-to-date number of AC92.2 AC92.4
Balance units up to the start of the current AC92.6 AC94.2
fiscal year. AC94.4 AC94.6
ACDR.1
GMT-BALANCE-AMOUNT Signed 17.2 AC191 AC45.1
Amount Balance This is the fiscal year amount balance. AC92.2 AC92.4
AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMT-BALANCE-UNIT Signed 17.2 AC191 AC45.1
Units Balance This is the fiscal year units balance. AC92.2 AC92.4
AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
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-RESOURCE-DESC Alpha 30 (Lower Case) AC191 AC45.1
Resource Desc ACDR.1
GMT-MAINT-DATE Numeric 8 (yyyymmdd) AC191 AC45.1
Maintenance Date The date last changed. ACDR.1
GMT-MAINT-TIME Numeric 6 (hhmmss) AC191 AC45.1
Maintenance Time The time last changed. ACDR.1
ACGLMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMTSET1 ACTIVITY-GRP AC191 AC300
ACTIVITY AC310 AC45.1
ACCT-CATEGORY AC494 ACDL.1
COMPANY ACDR.1
ACCT-UNIT
FISCAL-YEAR
RESOURCE-TYPE
RESOURCE-CODE
GMTSET10 RESOURCE-TYPE KeyChange, Subset
RESOURCE-CODE Where RESOURCE-TYPE != Spaces
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
COMPANY
ACCT-UNIT
GMTSET2 ACTIVITY-GRP KeyChange AC121 AC123
ACTIVITY AC130 AC191
ACCT-CATEGORY AC20.1 AC20.2
COMPANY AC20.3 AC20.4
ACCT-UNIT AC20.5 AC30.2
RESOURCE-TYPE AC30.3 AC32.1
RESOURCE-CODE AC45.1 AC490
FISCAL-YEAR AC92.1 AC92.2
AC92.4 AC92.6
AC94.1 AC94.2
AC94.4 AC94.6
ACDR.1
GMTSET3 ACTIVITY-GRP KeyChange
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
COMPANY
ACCT-UNIT
RESOURCE-TYPE
RESOURCE-CODE
GMTSET4 ACTIVITY-GRP
PARENT-ACTV
ACCT-CATEGORY
COMPANY
ACCT-UNIT
FISCAL-YEAR
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
GMTSET5 ACTIVITY-GRP KeyChange AC121 AC123
ACTIVITY AC130 AC20.1
ACCT-CATEGORY AC20.2 AC20.3
COMPANY AC20.4 AC20.5
ACCT-UNIT AC30.2 AC30.3
FISCAL-YEAR* AC32.1 AC490
RESOURCE-TYPE
RESOURCE-CODE
GMTSET6 COMPANY KeyChange
ACCT-UNIT
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
RESOURCE-TYPE
RESOURCE-CODE
GMTSET7 COMPANY KeyChange
ACCT-UNIT
ACCT-CATEGORY
ACTIVITY-GRP
ACTIVITY
FISCAL-YEAR
RESOURCE-TYPE
RESOURCE-CODE
GMTSET8 ACTIVITY-GRP KeyChange
ACTIVITY
ACCT-CATEGORY
RESOURCE-TYPE
RESOURCE-CODE
FISCAL-YEAR
COMPANY
ACCT-UNIT
GMTSET9 ACTIVITY-GRP KeyChange
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
ACCT-CATEGORY
FISCAL-YEAR
COMPANY
ACCT-UNIT
ACGLMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
GMT-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
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-RESOURCE-TYPE -> GMX-RESOURCE-TYPE
GMT-RESOURCE-CODE -> GMX-RESOURCE-CODE
GMT-FISCAL-YEAR -> GMX-FISCAL-YEAR
GMX-PERIOD
|
