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

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC37.1    AC490     AC494
ACDL.1    AC92.1    AC92.2    AC92.4    AC92.6    AC94.1
AC94.2    AC94.4    AC94.6

UPDATED BY

AC191     AC300     AC310     AC45.1    ACDR.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GCO-FISCAL-YEAR        Numeric 4                                 AC191   AC45.1
Element: Year          Required key. This is the fiscal year.    ACDR.1

GCO-ACTIVITY-GRP       Alpha 15                                  AC191   AC45.1
Element: Activity GroupRequired key. An activity group or        ACDR.1
                       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.

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

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

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

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

GCO-RESOURCE-TYPE      Alpha 1                                   AC191   AC45.1
Element: Resource Type                                           ACDR.1

GCO-RESOURCE-CODE      Alpha 10                                  AC191   AC45.1
Element: Resource Code                                           ACDR.1

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

GCO-VAR-LEVELS         Alpha 30                                  AC191   AC45.1
Element: Variable LevelThis is the activity variable level. A    ACDR.1
                       variable level represents the location
                       of an accounting unit in an
                       organization's level structure.

GCO-PARENT-ACTV        Alpha 15                                  AC191   AC45.1
Element: Parent Actv                                             ACDR.1

GCO-BASE-ND            Numeric 1                                 AC191   AC45.1
Base Number of         The number of decimal positions defined   ACDR.1
Decimals               for the activity group base currency.

GCO-BALANCE-AMOUNT     Signed 17.2                               AC191   AC45.1
Element: Amount BalanceThis is the amount balance for the        AC92.2  AC92.4
                       fiscal year.                              AC92.6  AC94.2
                                                                 AC94.4  AC94.6
                                                                 ACDR.1

GCO-BALANCE-UNIT       Signed 17.2                               AC191   AC45.1
Element: Units Balance This is the units balance for the         AC92.2  AC92.4
                       fiscal year.                              AC92.6  AC94.2
                                                                 AC94.4  AC94.6
                                                                 ACDR.1

GCO-BEGIN-BAL-AMT      Signed 15.2                               AC191   AC45.1
Beginning Amount       This is the life-to-date amount up to     AC92.2  AC92.4
Balance                the start of the current fiscal year.     AC92.6  AC94.2
                                                                 AC94.4  AC94.6
                                                                 ACDR.1

GCO-BEGIN-BAL-UNT      Signed 15.2                               AC191   AC45.1
Beginning Units        This is the life-to-date number of        AC92.2  AC92.4
Balance                units up to the start of the current      AC92.6  AC94.2
                       fiscal                                    AC94.4  AC94.6
                       year.                                     ACDR.1

GCO-RESOURCE-DESC      Alpha 30  (Lower Case)                    AC191   AC45.1
Element: Description                                             ACDR.1

                         ACGLCONSL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCOSET1   FISCAL-YEAR                                            AC121   AC123
          ACTIVITY-GRP                                           AC130   AC191
          ACTIVITY                                               AC20.1  AC20.2
          ACCT-CATEGORY                                          AC20.3  AC20.4
          COMPANY                                                AC20.5  AC32.1
          ACCT-UNIT                                              AC37.1  AC45.1
          RESOURCE-TYPE                                          AC490   ACDR.1
          RESOURCE-CODE

GCOSET2   ACTIVITY-GRP                                           AC300   AC494
          ACTIVITY                                               ACDL.1  ACDR.1
          ACCT-CATEGORY
          FISCAL-YEAR
          RESOURCE-TYPE
          RESOURCE-CODE
          COMPANY
          ACCT-UNIT

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

GCOSET4   ACTIVITY-GRP  KeyChange
          PARENT-ACTV
          ACCT-CATEGORY
          COMPANY
          ACCT-UNIT
          RESOURCE-TYPE
          RESOURCE-CODE
          FISCAL-YEAR*
          ACTIVITY

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

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

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

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

GCOSET9   RESOURCE-TYPE KeyChange, Subset
          RESOURCE-CODE Where RESOURCE-TYPE != Spaces
          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

                         ACGLCONSL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acglconslx     ACGLCONSLX

                            GCO-ACTIVITY-GRP     -> GCX-ACTIVITY-GRP
                            GCO-ACTIVITY         -> GCX-ACTIVITY
                            GCO-ACCT-CATEGORY    -> GCX-ACCT-CATEGORY
                            GCO-COMPANY          -> GCX-COMPANY
                            GCO-ACCT-UNIT        -> GCX-ACCT-UNIT
                            GCO-FISCAL-YEAR      -> GCX-FISCAL-YEAR
                            GCO-RESOURCE-TYPE    -> GCX-RESOURCE-TYPE
                            GCO-RESOURCE-CODE    -> GCX-RESOURCE-CODE
                                                    GCX-PERIOD