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 |
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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). |
|
||||||||||||||||||||
GMT-COMPANY Element: Company | Numeric 4 Required key. This is the company number the transaction was posted to in the general ledger. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
GMT-RESOURCE-CODE Element: Resource Code | Alpha 10 The code identifying the resource assigned to the activity or activity group. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
GMT-FISCAL-YEAR Element: Year | Numeric 4 Required key. This is the fiscal year. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
GMT-PARENT-ACTV Element: Parent Actv | Alpha 15 The parent activity field contains the activity name of the member parent. |
|
||||||||||||||||||||
GMT-BASE-ND Base Number of Decimals | Numeric 1 The number of decimal positions defined for the activity group base currency. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
GMT-BALANCE-AMOUNT Element: Amount Balance | Signed 18.2 This is the fiscal year amount balance. |
|
||||||||||||||||||||
GMT-BALANCE-UNIT Element: Units Balance | Signed 17.2 This is the fiscal year units balance. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
GMT-MAINT-DATE Element: Maint Date | Numeric 8 (yyyymmdd) The date last changed. |
|
||||||||||||||||||||
GMT-MAINT-TIME Element: Sys Time | Numeric 6 (hhmmss) |
|
||||||||||||||||||||
GMT-PERIOD-AMT Element: Intl Amt | Signed 18.2 Occurs 13 Times |
|
||||||||||||||||||||
GMT-PERIOD-UNIT Element: Unit | Signed 15.2 Occurs 13 Times |
|
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 |
|
| ||||||||||||||||||||||||||||||||
GMTSET10 |
RESOURCE-TYPE RESOURCE-COMP RESOURCE-CODE ACTIVITY-GRP ACTIVITY ACCT-CATEGORY FISCAL-YEAR COMPANY ACCT-UNIT |
|
|||||||||||||||||||||||||||||||||
GMTSET2 |
ACTIVITY-GRP ACTIVITY ACCT-CATEGORY COMPANY ACCT-UNIT RESOURCE-TYPE RESOURCE-COMP RESOURCE-CODE FISCAL-YEAR |
|
| ||||||||||||||||||||||||||||||||
GMTSET5 |
ACTIVITY-GRP ACTIVITY ACCT-CATEGORY COMPANY ACCT-UNIT FISCAL-YEAR* RESOURCE-TYPE RESOURCE-COMP RESOURCE-CODE |
|
| ||||||||||||||||||||||||||||||||
GMTSET7 |
COMPANY ACCT-UNIT ACCT-CATEGORY ACTIVITY-GRP ACTIVITY FISCAL-YEAR RESOURCE-TYPE RESOURCE-COMP RESOURCE-CODE |
|
|||||||||||||||||||||||||||||||||
GMTSET8 |
ACTIVITY-GRP ACTIVITY ACCT-CATEGORY COMPANY ACCT-UNIT RESOURCE-TYPE RESOURCE-COMP RESOURCE-CODE FISCAL-YEAR* |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Required
| ||||||||||||
Acactgrp | ACACTGRP |
Required
| ||||||||||||
Acactivity | ACACTIVITY |
Required
| ||||||||||||
Acgltotrev | ACGLTOTREV |
Not Required
| ||||||||||||
Glnames | GLNAMES |
Not Required
| ||||||||||||
Glsystem | GLSYSTEM |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accommit | ACCOMMIT |
| |||||||||||||||||||||||||||
Accommitx | ACCOMMITX |
| |||||||||||||||||||||||||||
Actrans | ACTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.