ACGLMAST – AC GL Acct Unit Master

System
Activity Management (AC)
Prefix
GMT
Primary key
ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, FISCAL-YEAR, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE
Fields
23
Updated by
21 programs
Referenced by
12 programs

ACGLMAST is the AC GL Acct Unit Master table in Lawson Activity Management (prefix GMT). It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, FISCAL-YEAR, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE (GMTSET1); alternate indexes: GMTSET10, GMTSET2, GMTSET5, GMTSET7 and GMTSET8. It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY, ACGLTOTREV, GLNAMES and GLSYSTEM and 1:M to ACCOMMIT, ACCOMMITX and ACTRANS. It is updated by AC121, AC123, AC127, AC145, AC20.1, AC20.2, AC20.3, AC20.4 and 13 more and referenced by AC130, AC191, AC32.1, AC37.1, AC490, AC92.1, AC92.2, AC92.4 and 4 more. The table has 23 fields, 6 indexes and 9 documented relations.

About ACGLMAST

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.

Fields (23)

Column = COBOL field name without the GMT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GMT-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15Required key. This is the activity 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.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-ACTIVITY PK
ACTIVITY		Alpha 15Required key. Activities are the 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.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Required key. Account categories are 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).AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-COMPANY PK
COMPANY		Numeric 4Required key. This is the company number the transaction was posted to in the general ledger.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-ACCT-UNIT PK
ACCT_UNIT		Alpha 15Required key. This is the accounting 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.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-RESOURCE-COMP PK
RESOURCE_COMP		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-RESOURCE-TYPE PK
RESOURCE_TYPE		Alpha 1The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset
  • A Asset
  • E Employee
  • P AC Person
  • Q Equipment
  • V Vendor
AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Required key. This is the fiscal year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-VAR-LEVELS
VAR_LEVELS		Alpha 30This is the activity variable level, representing the location of an accounting unit in an organization's level structure.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-PARENT-ACTV
PARENT_ACTV		Alpha 15The parent activity field contains the activity name of the member parent.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the activity group base currency.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-BEGIN-BAL-AMT
BEGIN_BAL_AMT		Signed 18.2This is the life-to-date amount up to the start of the current fiscal year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
GMT-BEGIN-BAL-UNT
BEGIN_BAL_UNT		Signed 15.2This is the life-to-date number of units up to the start of the current fiscal year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
GMT-BALANCE-AMOUNT
BALANCE_AMOUNT		Signed 18.2This is the fiscal year amount balance.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
GMT-BALANCE-UNIT
BALANCE_UNIT		Signed 17.2This is the fiscal year units balance.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
GMT-LTD-AMOUNT
LTD_AMOUNT		DerivedThis is the sum of the Amount Balance and the Amount Beginning Balance fields for the fiscal year.—
GMT-LTD-UNIT
LTD_UNIT		DerivedThis is the sum of the Unit Balance and the Unit Beginning Balance fields for the fiscal year.—
GMT-RESOURCE-DESC
RESOURCE_DESC		Alpha 30 (Lower Case)This field displays the description.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
GMT-PERIOD-AMT
PERIOD_AMT		Signed 18.2 Occurs 13 Times ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
GMT-PERIOD-UNIT
PERIOD_UNIT		Signed 15.2 Occurs 13 Times ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GMTSET1ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, FISCAL-YEAR, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODEPrimaryAC121, AC123, AC127, AC130, AC145, AC191, AC20.1, AC20.2 +18 more
GMTSET10RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, COMPANY, ACCT-UNITKeyChange, SubsetWhere RESOURCE-TYPE != Spaces—
GMTSET2ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, FISCAL-YEARKeyChangeAC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +13 more
GMTSET5ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, FISCAL-YEAR*, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODEKeyChangeAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +3 more
GMTSET7COMPANY, ACCT-UNIT, ACCT-CATEGORY, ACTIVITY-GRP, ACTIVITY, FISCAL-YEAR, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODEKeyChange—
GMTSET8ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, FISCAL-YEAR*KeyChangeAC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequiredGMT-ACCT-CATEGORY → AAX-ACCT-CATEGORY
AcactgrpACACTGRPRequiredGMT-ACTIVITY-GRP → AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequiredGMT-ACTIVITY → ACV-ACTIVITY
AcgltotrevACGLTOTREVNot RequiredGMT-ACTIVITY → GRV-ACTIVITY, GMT-ACCT-CATEGORY → GRV-ACCT-CATEGORY, GMT-COMPANY → GRV-COMPANY, GMT-ACCT-UNIT → GRV-ACCT-UNIT
GlnamesGLNAMESNot RequiredGMT-COMPANY → GLN-COMPANY, GMT-ACCT-UNIT → GLN-ACCT-UNIT
GlsystemGLSYSTEMNot RequiredGMT-COMPANY → GLS-COMPANY

One to many (3) — child tables

RelationTableRulesConditionField map
AccommitACCOMMITGMT-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
AccommitxACCOMMITXGMT-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
ActransACTRANSGMT-ACTIVITY → ATN-ACTIVITY, GMT-ACCT-CATEGORY → ATN-ACCT-CATEGORY, GMT-FISCAL-YEAR → ATN-FISCAL-YEAR, → ATN-PERIOD, → ATN-OBJ-ID

Programs

Updated by (21)

Referenced by (12)