Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACGLCONSL


                             ACGLCONSL FILE

                     AC GL Acct Unit Consolidation

This file maintains summary-level activity consolidation balances by account
category, company, accounting unit, and year in the activity group base
currency. Whether this file is updated depends on the value in the Accounting
Unit Detail field on AC00.1 (Activity Group), which is stored in the Activity
Group file. This file is updated by AC191 (AC Accounting Unit Posting).

REFERENCED BY

AC130     AC32.1    AC37.1    AC490     AC92.2    AC92.4
AC92.6    AC92.1    AC94.2    AC94.4    AC94.6    AC94.1
ACDL.1    AC494

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

GCO-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

GCO-ACTIVITY-GRP       Alpha 15                                  AC121   AC123
Element: Activity GroupRequired key. An activity group or        AC127   AC20.1
                       activity center is a group of activities  AC20.2  AC20.3
                       related by process or function. An        AC20.4  AC20.5
                       activity group is the highest entity for  AC20.6  AC20.7
                       which you can inquire and report on       AC22.1  ACDR.1
                       costs, revenues, and budgets in the       SB515
                       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.

GCO-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.

GCO-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).

                       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.

GCO-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

GCO-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.

GCO-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

GCO-RESOURCE-COMP      Numeric 4                                 AC121   AC123
Element: Company       Resource Company.  Identifies the AP      AC127   AC20.1
                       company if the resource type = V.         AC20.2  AC20.3
                       Identifies the HR company if the          AC20.4  AC20.5
                       resource type = E.  It is blank for       AC20.6  AC20.7
                       resource type A, P, or Q resources.       AC22.1  ACDR.1
                                                                 SB515

GCO-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

GCO-LEVEL-DEPTH        Numeric 1
Element: Level Depth   This is the level depth number for the
                       activity.

GCO-VAR-LEVELS         Alpha 30                                  AC121   AC123
Element: Variable LevelThis is the activity variable level. A    AC127   AC20.1
                       variable level represents the location    AC20.2  AC20.3
                       of an accounting unit in an               AC20.4  AC20.5
                       organization's level structure.           AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

GCO-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

GCO-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

GCO-BALANCE-AMOUNT     Signed 18.2                               AC121   AC123
Element: Amount BalanceThis is the amount balance for the        AC127   AC20.1
                       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

GCO-BALANCE-UNIT       Signed 17.2                               AC121   AC123
Element: Units Balance This is the units balance for the         AC127   AC20.1
                       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

GCO-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

GCO-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                                    AC20.4  AC20.5
                       year.                                     AC20.6  AC20.7
                                                                 AC22.1  AC92.2
                                                                 AC92.4  AC92.6
                                                                 AC94.2  AC94.4
                                                                 AC94.6  ACDR.1
                                                                 SB515

GCO-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

GCO-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

GCO-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

                         ACGLCONSL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCOSET1   FISCAL-YEAR                                            AC121   AC123
          ACTIVITY-GRP                                           AC127   AC130
          ACTIVITY                                               AC20.1  AC20.2
          ACCT-CATEGORY                                          AC20.3  AC20.4
          COMPANY                                                AC20.5  AC20.6
          ACCT-UNIT                                              AC20.7  AC22.1
          RESOURCE-TYPE                                          AC32.1  AC37.1
          RESOURCE-COMP                                          AC490   AC92.2
          RESOURCE-CODE                                          AC92.4  AC92.6
                                                                 ACDR.1  SB515

GCOSET2   ACTIVITY-GRP                                           AC300   AC92.4
          ACTIVITY                                               AC92.6  AC94.2
          ACCT-CATEGORY                                          AC94.4  AC94.6
          FISCAL-YEAR                                            ACDL.1  ACDR.1
          RESOURCE-TYPE
          RESOURCE-COMP
          RESOURCE-CODE
          COMPANY
          ACCT-UNIT

GCOSET3   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC127   AC130
          ACCT-CATEGORY                                          AC20.1  AC20.2
          COMPANY                                                AC20.3  AC20.4
          ACCT-UNIT                                              AC20.5  AC20.6
          RESOURCE-TYPE                                          AC20.7  AC22.1
          RESOURCE-COMP                                          AC310   AC32.1
          RESOURCE-CODE                                          AC37.1  AC490
          FISCAL-YEAR*                                           AC92.1  AC92.2
                                                                 AC92.4  AC92.6
                                                                 AC94.1  AC94.2
                                                                 AC94.4  AC94.6
                                                                 ACDR.1  SB515

GCOSET5   COMPANY       KeyChange
          ACCT-UNIT
          ACCT-CATEGORY
          ACTIVITY-GRP
          ACTIVITY
          FISCAL-YEAR
          RESOURCE-TYPE
          RESOURCE-COMP
          RESOURCE-CODE

GCOSET8   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  AC494
          RESOURCE-COMP                                          ACDR.1  SB515
          RESOURCE-CODE
          FISCAL-YEAR

GCOSET9   RESOURCE-TYPE KeyChange, Subset
          RESOURCE-COMP Where RESOURCE-TYPE != Spaces
          RESOURCE-CODE
          ACTIVITY-GRP
          ACTIVITY
          ACCT-CATEGORY
          FISCAL-YEAR
          COMPANY
          ACCT-UNIT

                         ACGLCONSL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            GCO-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY  (AAXSET1)

Acactgrp       ACACTGRP     Required

                            GCO-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            GCO-ACTIVITY         -> ACV-ACTIVITY

Glnames        GLNAMES      Not Required

                            GCO-COMPANY          -> GLN-COMPANY
                            GCO-ACCT-UNIT        -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Not Required

                            GCO-COMPANY          -> GLS-COMPANY