Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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