|
|
ACGLMASTX FILE
AC GL Acct Unit Master Detail
This file maintains detailed posting-level activity balances by account
category, company, accounting unit, year, and period in the activity group
base currency. This file is updated by AC191 (AC Accounting Unit Posting).
REFERENCED BY
ACDL.1 AC121 AC123 AC130 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC32.1 AC37.1 AC490
AC494 AC92.2 AC92.4 AC92.6 AC94.2 AC94.4
AC94.6 BR130 BR530
UPDATED BY
AC191 AC300 AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMX-ACTIVITY-GRP Alpha 15 AC191 AC45.1
Element: Activity GroupRequired 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.
GMX-ACTIVITY Alpha 15 AC191 AC45.1
Element: 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.
GMX-ACCT-CATEGORY Alpha 5 AC191 AC45.1
Element: Account CategoRequired 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).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
GMX-COMPANY Numeric 4 AC191 AC45.1
Element: Company Required key. This is the company ACDR.1
number the transaction was posted to in
the general ledger.
GMX-ACCT-UNIT Alpha 15 AC191 AC45.1
Element: Accounting UniRequired 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.
GMX-RESOURCE-CODE Alpha 10 AC191 AC45.1
Element: Resource Code ACDR.1
GMX-FISCAL-YEAR Numeric 4 AC191 AC45.1
Element: Year Required key. This is the fiscal year. ACDR.1
GMX-PERIOD Numeric 2 AC191 AC45.1
Element: Period Required key. This is the fiscal ACDR.1
period.
GMX-PARENT-ACTV Alpha 15 AC191 AC45.1
Element: Parent Actv ACDR.1
GMX-RESOURCE-TYPE Alpha 1 AC191 AC45.1
Element: Resource Type ACDR.1
GMX-RESOURCE-DESC Alpha 30 (Lower Case)
Element: Description
GMX-AMOUNT Currency 15.2 AC191 AC45.1
Element: Amount This is the period amount balance for AC92.2 AC92.4
the current fiscal year. AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMX-UNIT Signed 15.2 AC191 AC45.1
Element: Units This is the period units balance for AC92.2 AC92.4
the current fiscal year. AC92.6 AC94.2
AC94.4 AC94.6
ACDR.1
GMX-RESRC-DESC Derived
Element: Resrc Desc
ACGLMASTX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMXSET1 ACTIVITY-GRP AC191 AC300
ACTIVITY AC310 AC45.1
ACCT-CATEGORY ACDL.1 ACDR.1
COMPANY
ACCT-UNIT
FISCAL-YEAR
PERIOD
RESOURCE-TYPE
RESOURCE-CODE
GMXSET2 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
RESOURCE-TYPE AC490 AC494
RESOURCE-CODE AC92.2 AC92.4
FISCAL-YEAR AC92.6 AC94.2
PERIOD AC94.4 AC94.6
BR130 BR530
GMXSET3 ACTIVITY-GRP KeyChange
PARENT-ACTV
ACCT-CATEGORY
COMPANY
ACCT-UNIT
FISCAL-YEAR
PERIOD
RESOURCE-TYPE
RESOURCE-CODE
ACTIVITY
ACGLMASTX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
GMX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactivity ACACTIVITY Required
GMX-ACTIVITY -> ACV-ACTIVITY
Acglmast ACGLMAST Required
GMX-ACTIVITY-GRP -> GMT-ACTIVITY-GRP
GMX-ACTIVITY -> GMT-ACTIVITY
GMX-ACCT-CATEGORY -> GMT-ACCT-CATEGORY
GMX-COMPANY -> GMT-COMPANY
GMX-ACCT-UNIT -> GMT-ACCT-UNIT
GMX-FISCAL-YEAR -> GMT-FISCAL-YEAR
GMX-RESOURCE-TYPE -> GMT-RESOURCE-TYPE
GMX-RESOURCE-CODE -> GMT-RESOURCE-CODE
Glnames GLNAMES Not Required
GMX-COMPANY -> GLN-COMPANY
GMX-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
GMX-COMPANY -> GLS-COMPANY
ACGLMASTX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Posted Actrans ACTRANS
GMX-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
ACV-VAR-LEVELS -> ATN-VAR-LEVELS
9 -> ATN-STATUS
GMX-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
GMX-FISCAL-YEAR -> ATN-FISCAL-YEAR
GMX-PERIOD -> ATN-PERIOD
ATN-OBJ-ID
|
