Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACGLCONSLX FILE

                     AC GL Acct Unit Consol Detail

This detail file maintains summary-level activity consolidation balances by
account category, company, accounting unit, year, and period 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    AC490     AC494     AC92.2
AC92.4    AC92.6    AC94.2    AC94.4    AC94.6    ACDL.1

UPDATED BY

AC191     AC300     AC310     AC45.1    ACDR.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

GCX-ACTIVITY-GRP     Alpha 15                                    AC191   AC45.1
Activity Group       Required 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.

GCX-ACTIVITY         Alpha 15                                    AC191   AC45.1
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.

GCX-ACCT-CATEGORY    Alpha 5                                     AC191   AC45.1
Account Category     Required 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.

GCX-COMPANY          Numeric 4                                   AC191   AC45.1
Company              Required key. This is the company           ACDR.1
                     number the transaction was posted to in
                     the general ledger.

GCX-ACCT-UNIT        Alpha 15                                    AC191   AC45.1
Accounting Unit      Required key. This is the accounting        ACDR.1
                     unit the transaction was posted to in
                     the general ledger. An 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.

GCX-RESOURCE-TYPE    Alpha 1                                     AC191   AC45.1
Resource Type                                                    ACDR.1

GCX-RESOURCE-CODE    Alpha 10                                    AC191   AC45.1
Resource Code                                                    ACDR.1

GCX-PERIOD           Numeric 2                                   AC191   AC45.1
Period               Required key. This is the fiscal            ACDR.1
                     period.

GCX-PARENT-ACTV      Alpha 15                                    AC191   AC45.1
Parent Actv                                                      ACDR.1

GCX-AMOUNT           Currency 15.2                               AC191   AC45.1
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

GCX-UNIT             Signed 15.2                                 AC191   AC45.1
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

GCX-RESRC-DESC       Derived
Resrc Desc

                         ACGLCONSLX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCXSET1   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                                              AC45.1  AC490
          PERIOD                                                 ACDR.1
          RESOURCE-TYPE
          RESOURCE-CODE

GCXSET2   ACTIVITY-GRP                                           AC300   AC310
          ACTIVITY                                               AC494   AC92.2
          ACCT-CATEGORY                                          AC92.4  AC92.6
          COMPANY                                                AC94.2  AC94.4
          ACCT-UNIT                                              AC94.6  ACDL.1
          FISCAL-YEAR                                            ACDR.1
          RESOURCE-TYPE
          RESOURCE-CODE
          PERIOD

GCXSET3   ACTIVITY-GRP  KeyChange
          PARENT-ACTV
          ACCT-CATEGORY
          COMPANY
          ACCT-UNIT
          RESOURCE-TYPE
          RESOURCE-CODE
          FISCAL-YEAR
          PERIOD
          ACTIVITY

                         ACGLCONSLX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

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

Acactgrp       ACACTGRP     Required

                            GCX-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            GCX-ACTIVITY         -> ACV-ACTIVITY

Acglconsl      ACGLCONSL    Required

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

Glnames        GLNAMES      Not Required

                            GCX-COMPANY          -> GLN-COMPANY
                            GCX-ACCT-UNIT        -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Not Required

                            GCX-COMPANY          -> GLS-COMPANY