ACGLMAST

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 AC92.4
AC92.1 AC92.2 AC92.6 ACDL.1 BR130 BR530


UPDATED BY
AC121 AC123 AC127 AC145 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.5
AC22.1 AC300 AC45.1 ACDR.1 AC494 AC94.1
AC94.2 AC94.4 AC94.6

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMT-ACTIVITY-GRP
Element: Activity Group
Alpha 15
Required 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-ACTIVITY
Element: Activity
Alpha 15
Required 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-ACCT-CATEGORY
Element: Account Category
Alpha 5
Required 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-COMPANY
Element: Company
Numeric 4
Required 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-ACCT-UNIT
Element: Accounting Unit
Alpha 15
Required 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-RESOURCE-COMP
Element: Company
Numeric 4
Identifies 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-RESOURCE-TYPE
Element: Resource Type
Alpha 1
The 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-FISCAL-YEAR
Element: Year
Numeric 4
Required key. This is the fiscal year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-VAR-LEVELS
Element: Variable Level
Alpha 30
This 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
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-PARENT-ACTV
Element: Parent Actv
Alpha 15
The parent activity field contains the activity name of the member parent.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-BASE-ND
Base Number of
Decimals
Numeric 1
The number of decimal positions defined for the activity group base currency.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-BEGIN-BAL-AMT
Beginning Amount
Balance
Signed 18.2
This 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
AC20.6 AC20.7
AC21.5 AC22.1
AC92.2 AC92.4
AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMT-BEGIN-BAL-UNT
Beginning Units
Balance
Signed 15.2
This 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
AC20.6 AC20.7
AC21.5 AC22.1
AC92.2 AC92.4
AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMT-BALANCE-AMOUNT
Element: Amount Balance
Signed 18.2
This is the fiscal year amount balance.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC92.2 AC92.4
AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMT-BALANCE-UNIT
Element: Units Balance
Signed 17.2
This is the fiscal year units balance.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC92.2 AC92.4
AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMT-LTD-AMOUNT
Element: Life-to-Date Amount
Derived
This is the sum of the Amount Balance and the Amount Beginning Balance fields for the fiscal year.
GMT-LTD-UNIT
Element: Life-to-Date Units
Derived
This is the sum of the Unit Balance and the Unit Beginning Balance fields for the fiscal year.
GMT-RESOURCE-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
GMT-PERIOD-AMT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC92.2 AC92.4
AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMT-PERIOD-UNIT
Element: Unit
Signed 15.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC92.2 AC92.4
AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1


ACGLMAST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMTSET1 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
FISCAL-YEAR
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
AC121 AC123
AC127 AC130
AC145 AC191
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 AC300
AC32.1 AC37.1
AC45.1 AC490
AC494 AC92.4
ACDL.1 ACDR.1
BR130 BR530
GMTSET10 RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
COMPANY
ACCT-UNIT
KeyChange, Subset
WhereRESOURCE-TYPE !=Spaces
GMTSET2 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
FISCAL-YEAR
KeyChange
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC92.1 AC92.2
AC92.4 AC92.6
AC94.1 AC94.2
AC94.4 AC94.6
ACDR.1
GMTSET5 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
FISCAL-YEAR*
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
KeyChange
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490
GMTSET7 COMPANY
ACCT-UNIT
ACCT-CATEGORY
ACTIVITY-GRP
ACTIVITY
FISCAL-YEAR
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
KeyChange
GMTSET8 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
FISCAL-YEAR*
KeyChange
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1


ACGLMAST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:03:04 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.