Lawson Insight Technical Documentation |
|
ACGLMAST
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
AC130 AC191 AC32.1 AC37.1 AC490 AC494
AC92.4 AC92.1 AC92.2 AC92.6 ACDL.1 BR130
BR530 AC94.1 AC94.2 AC94.4 AC94.6
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 SB515
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMT-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity GroupRequired key. This is the activity AC127 AC20.1
group. An activity group or activity AC20.2 AC20.3
center is a group of activities related AC20.4 AC20.5
by process or function. An activity AC20.6 AC20.7
group is the highest entity for which AC22.1 ACDR.1
you can inquire and report on costs, SB515
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 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 SB515
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 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 SB515
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 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
SB515
GMT-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 SB515
Ledger Names file as a posting
accounting unit.
GMT-RESOURCE-COMP Numeric 4 AC121 AC123
Element: Company Identifies the AP company if the AC127 AC20.1
resource type = V. Identifies the HR AC20.2 AC20.3
company if the resource type = E. It is AC20.4 AC20.5
blank for type A, P or Q resources. AC20.6 AC20.7
AC22.1 ACDR.1
SB515
GMT-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
SB515
GMT-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 SB515
A - Asset
A = Asset
E = Employee
P = AC Person
Q = Equipment
V = Vendor
GMT-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
SB515
GMT-VAR-LEVELS Alpha 30 AC121 AC123
Element: Variable LevelThis is the activity variable level, AC127 AC20.1
representing the location of an AC20.2 AC20.3
accounting unit in an organization's AC20.4 AC20.5
level structure. AC20.6 AC20.7
AC22.1 ACDR.1
SB515
GMT-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
SB515
GMT-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
SB515
GMT-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
SB515
GMT-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 year. AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC92.2
AC92.4 AC92.6
AC94.2 AC94.4
AC94.6 ACDR.1
SB515
GMT-BALANCE-AMOUNT Signed 18.2 AC121 AC123
Element: Amount BalanceThis is the fiscal year amount balance. 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
SB515
GMT-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Units Balance This is the fiscal year units balance. 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
SB515
GMT-LTD-AMOUNT Derived
Element: Life-to-Date AThis is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
GMT-LTD-UNIT Derived
Element: Life-to-Date UThis is the sum of the Unit Balance and
the Unit Beginning Balance fields for
the fiscal year.
GMT-RESOURCE-DESC Alpha 30 (Lower Case) AC121 AC123
Element: Description This field displays the description. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
GMT-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Maint Date The date last changed. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
GMT-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Sys Time AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
GMT-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
SB515
GMT-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
SB515
ACGLMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMTSET1 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
ACCT-CATEGORY AC191 AC20.1
COMPANY AC20.2 AC20.3
ACCT-UNIT AC20.4 AC20.5
FISCAL-YEAR AC20.6 AC20.7
RESOURCE-TYPE AC22.1 AC300
RESOURCE-COMP AC310 AC32.1
RESOURCE-CODE AC37.1 AC490
AC494 AC92.4
ACDL.1 ACDR.1
BR130 BR530
SB515
GMTSET10 RESOURCE-TYPE KeyChange, Subset
RESOURCE-COMP Where RESOURCE-TYPE != Spaces
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
COMPANY
ACCT-UNIT
GMTSET2 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 AC92.1
RESOURCE-COMP AC92.2 AC92.4
RESOURCE-CODE AC92.6 AC94.1
FISCAL-YEAR AC94.2 AC94.4
AC94.6 ACDR.1
SB515
GMTSET3 ACTIVITY-GRP KeyChange
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
COMPANY
ACCT-UNIT
RESOURCE-TYPE
RESOURCE-COMP
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 AC32.1 AC37.1
FISCAL-YEAR* AC490
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
GMTSET6 COMPANY KeyChange
ACCT-UNIT
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
GMTSET7 COMPANY KeyChange
ACCT-UNIT
ACCT-CATEGORY
ACTIVITY-GRP
ACTIVITY
FISCAL-YEAR
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
GMTSET8 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 SB515
RESOURCE-CODE
FISCAL-YEAR*
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
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
Accommit ACCOMMIT
GMT-ACTIVITY-GRP -> MIT-ACTIVITY-GRP
GMT-ACTIVITY -> MIT-ACTIVITY
GMT-ACCT-CATEGORY -> MIT-ACCT-CATEGORY
GMT-FISCAL-YEAR -> MIT-FISCAL-YEAR
MIT-PERIOD
MIT-SYSTEM
MIT-COMPANY
MIT-CURRENCY-CODE
Accommitx ACCOMMITX
GMT-ACTIVITY-GRP -> MIX-ACTIVITY-GRP
GMT-ACTIVITY -> MIX-ACTIVITY
GMT-ACCT-CATEGORY -> MIX-ACCT-CATEGORY
GMT-FISCAL-YEAR -> MIX-FISCAL-YEAR
MIX-PERIOD
MIX-SYSTEM
MIX-COMPANY
MIX-CURRENCY-CODE
MIX-ATN-OBJ-ID
Actrans ACTRANS
GMT-ACTIVITY -> ATN-ACTIVITY
GMT-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
GMT-FISCAL-YEAR -> ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
|