Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACTGRP


                             ACACTGRP FILE

                             Activity Group

This file contains information from AC00.1 (Activity Group) about activity
group set up and definitions. The activity group is the highest reporting
level in the Activity  Management system. This file also includes information
about the activity processing and reporting structure (work breakdown
structure) and the appearance and function of the activity group in
the Activity Management system.

REFERENCED BY

AC01.1    AC01.5    AC03.2    AC03.3    AC03.4    AC03.5
AC03.6    AC06.1    AC08.2    AC10.1    AC10.3    AC10.5
AC11.1    AC112     AC113     AC12.1    AC12.2    AC13.1
AC13.2    AC130     AC131     AC135     AC160     AC165
AC176     AC18.1    AC18.2    AC18.3    AC18.4    AC18.5
AC190     AC191     AC192     AC196     AC198     AC200
AC203     AC206     AC207     AC208     AC21.1    AC21.2
AC21.3    AC21.4    AC210     AC213     AC218     AC220
AC225     AC227     AC240     AC25.1    AC255     AC256
AC258     AC261     AC265     AC27.1    AC290     AC295
AC297     AC298     AC32.1    AC34.1    AC37.1    AC40.1
AC40.4    AC400     AC401     AC41.1    AC41.4    AC410
AC412     AC42.1    AC420     AC421     AC440     AC45.1
AC45.2    AC460     AC471     AC472     AC473     AC480
AC490     AC493     AC494     AC50.1    AC500     AC510
AC52.1    AC520     AC530     AC54.1    AC54.2    AC54.3
AC540     AC541     AC542     AC55.1    AC550     AC58.1
AC580     AC61.1    AC65.1    AC65.2    AC66.1    AC81.1
AC90.1    AC90.2    AC90.4    AC90.6    AC90.8    AC92.1
AC92.2    AC92.4    AC92.6    AC93.1    AC93.2    AC93.3
AC93.4    AC93.5    AC94.1    AC94.2    AC94.4    AC94.6
AC95.1    AC95.2    AC95.4    AC95.6    AC96.1    AC97.1
AC97.2    AC97.4    AC97.6    AC98.1    AC98.2    ACAC.1
ACBA.1    ACCL.1    ACDL.1    ACDM.2    ACDM.9    ACSR.1
ACVW.1    SE90.1    AP125     AP126     AP131     AP170
AP193     AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.7    AP23.1    AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    AP32.2    AP520     AP95.3    API1.1
API2.1    AR115     AR124     AR129     AR130     AR131
AR135     AR190     AR20.1    AR21.1    AR21.2    AR21.3
AR24.1    AR29.2    AR30.1    AR30.2    AR30.3    AR30.4
AR30.6    AR30.8    AR31.6    AR35.1    AR36.1    AR42.1
AR42.2    AR42.7    AR43.1    AR48.3    AR560     AR570
AR575     AR580     BN150     BN66.1    BR00.1    BR00.2
BR00.3    BR01.1    BR01.2    BR01.3    BR02.1    BR02.2
BR02.3    BR03.1    BR03.2    BR03.3    BR04.1    BR05.1
BR05.2    BR05.3    BR05.4    BR05.5    BR10.1    BR10.2
BR10.3    BR10.4    BR10.5    BR120     BR121     BR122
BR123     BR124     BR13.1    BR130     BR131     BR14.1
BR142     BR15.1    BR15.2    BR15.3    BR151     BR152
BR153     BR154     BR155     BR156     BR157     BR165
BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR20.7
BR200     BR202     BR204     BR205     BR21.1    BR210
BR212     BR215     BR220     BR251     BR252     BR253
BR254     BR265     BR40.1    BR40.3    BR40.4    BR400
BR405     BR41.1    BR41.4    BR42.1    BR420     BR43.1
BR430     BR450     BR51.1    BR51.2    BR52.1    BR52.2
BR52.5    BR521     BR53.1    BR530     BR54.1    BR54.2
BR54.3    BR54.4    BR55.1    BR56.1    BR65.1    BR65.2
BR900     BR901     BRCC.1    BRIP.1    BRPI.1    CB10.1
CB180     CB191     CB20.1    CB30.1    CB500     CB80.1
CXCP.1    EE135     EE20.3    EE35.1    EE35.2    EE520
GL146     GL165     GL170     GL197     GL199     GL40.1
GL40.2    GL40.3    GL40.7    GL40.8    GL44.1    GL45.1
GL75.1    DR100     IC140     IC28.1    IC531     IC83.1
CU00.1    IFGT.1    MA180     MA41.2    MA41.7    MA43.1
MA43.2    MA43.3    MA43.9    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA65.1    MA66.2    MA66.3
MA67.1    MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1
PO100     PO101     PO122     PO131     PO135     PO150
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POCP.1    POD0.1
POI3.1    POID.1    POIF.1    POIG.1    POII.1    POIJ.1
PR128     PR130     PR131     PR132     PR134     PR136
PR137     PR140     PR189     PR195     PR197     PR29.1
PR32.1    PR32.2    PR33.1    PR33.2    PR33.3    PR35.1
PR35.2    PR35.3    PR35.4    PR35.5    PR35.6    PR35.8
PR36.1    PR37.1    PR38.1    PR45.1    PR529     PR530
PR560     PR80.1    PR82.1    PR85.1    PR89.1    PRSA.1
UK102     UK330     UK560     RQ10.1    RQ10.2    RQ10.3
RQ11.1    RQ12.1    RQ13.1    RQ140     RQ300     RQ35.1
RQ40.1    RQ41.1    RQ42.1    RQ44.1    RQ44.2    RQ500
RQD0.1    RQIA.1    RQIE.1    RQIF.1    TA147     UK120
WH130     WH132     WH190     WH20.2    WH20.7    WH222
WH25.1    WH25.2    WH30.1    WH30.2    WH30.3    WH30.4
WH31.1    WH31.2    WH31.3    WH31.4    WH32.1    WH32.2
WH32.3    WH32.4    WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830
WO132     WO140

UPDATED BY

AC00.1    AC00.3    AC07.1    AC105     AC110     AC120
AC121     AC123     AC127     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC20.6    AC20.7    AC22.1    AC300
AC310     AC581     ACDR.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AGP-ACTIVITY-GRP       Alpha 15                                  AC00.1  AC110
Element: Activity GroupRequired key. An activity group or        AC198
                       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.

AGP-DESCRIPTION        Alpha 30  (Lower Case)                    AC00.1  AC110
Activity Group         This is the activity group description.   AC198
Description

AGP-CURRENCY-TABLE     Alpha 12                                  AC00.1
Element: Currency TableThis is the currency table, a table of
                       currency relationships, currency
                       exchange rates, and translation rates.

AGP-CURRENCY-CODE      Alpha 5                                   AC00.1  AC198
Element: Currency Code This is the base currency code of the
                       activity group. You define the base
                       currency code in AC00.1 (Activity
                       Group). Consolidation amounts are
                       reported in activity group base
                       currency.

AGP-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC00.1
Element: Begin Date    This is the beginning date for the
                       activity group. If you leave this field
                       blank, the activity group date range
                       defaults to the activity date range.
                       Activity dates cannot be outside the
                       activity group date range.

AGP-END-DATE           Numeric 8  (yyyymmdd)                     AC00.1
Element: End Date      This is the ending date for the
                       activity group. If you leave this field
                       blank, the activity group date range
                       defaults to the activity date range.

                       The activity date range cannot be
                       outside the activity group date range.

AGP-CALENDAR-NAME      Alpha 12                                  AC00.1
Element: Calendar Name Required. Enter the name of a calendar
                       that defines the fiscal periods for the
                       activity group. The calendar is defined
                       in AC00.3 (Calendar).

AGP-SECURITY-CD        Numeric 4                                 AC00.1
Element: Security Code You can define a security code for the
                       activity group. The security code is
                       used with the Lawson Security module.
                       Security in Activity Management is
                       established by security code and
                       activity.

AGP-LEVEL-DESC         Alpha 12  (Lower Case)                    AC00.1
Element: Level DescriptOccurs 5 Times
                       This is the level description. Levels
                       define an addressing system that
                       organizes activities into a reporting
                       hierarchy. Level names are defined for
                       an activity group and should be able to
                       be used across all activities in an
                       activity group. Levels facilitate rollup
                       or consolidation of budgets, costs, and
                       revenues from activities at lower levels
                       to macro activities at a higher level
                       within the hierarchy.

AGP-LEVEL-SIZE         Numeric 2 Occurs 5 Times                  AC00.1
Element: Level Size    This is the level size. Variable levels
                       make up a hierarchical numbering scheme
                       that allows detail to be aggregated or
                       "rolled-up" in summarized form. Five
                       levels are available in the Activity
                       Management system. No one level can be
                       greater than 15; all of the levels taken
                       together cannot exceed 30.

AGP-ACTIVE-STATUS      Alpha 1                                   AC00.1  AC00.3
Element: Active Status The status of the activity group. If
                       the activity group is inactive, no
                       activities can be assigned to this
                       activity group.
                       O = Open
                       C = Closed
                       G = GL only

AGP-BASE-ND            Numeric 1                                 AC00.1  AC198
Base Number of         This is the number of decimal positions
Decimals               defined for the activity group base
                       currency.

AGP-ACTIVE-BUD         Numeric 3                                 AC110   AC127
Element: Active Budget This is the budget number for the         AC20.6
                       activity group's active budget. The
                       active budget is the default budget used
                       for inquiries and reporting. It is also
                       used for calculating percentage complete
                       in AC65.1 (Account Category Percent of
                       Completion). You can change the activity
                       group active budget in AC20.4 (New
                       Activity Group Budget).

AGP-TOTAL-BUDGET       Signed 15.2                               AC00.1  AC110
Element: Total Budget  This is the sum of the activity budgets   AC121   AC123
                       for the activity group. This field is     AC127   AC20.1
                       used in editing to determine if the sum   AC20.2  AC20.3
                       of the activity budgets exceeds the       AC20.4  AC20.5
                       budget cap.                               AC20.7  AC22.1
                                                                 ACDR.1

AGP-BUDGET-CAP         Signed 15.2                               AC00.1
Element: Budget Cap    This is the budget cap or budget
                       maximum for the activity group. It is
                       used in editing budget programs and in
                       determining if the sum of the activity
                       budgets exceeds the budget cap. If the
                       sum of the activity budgets exceeds the
                       budget cap, a warning message displays.

AGP-WORKFLOW-FLAG      Alpha 1
Element: Workflow Flag This field will be used in implementing
                       Activity Management Workflow.
                       Y = Yes
                       N = No

AGP-CHG-ORDER-FLAG     Alpha 1                                   AC00.1
Element: Change Order FThis is the change order flag.

                       Yes = Change order records are kept on
                       file to provide an audit trail of budget
                       change order revisions.

                       No = Change order detail records are
                       deleted after the change order is
                       released.

AGP-CONSOL-FLAG        Alpha 1                                   AC00.1
Element: Consolidation This is the consolidation flag. Use Yes
                       to create consolidation files for
                       actuals and budgets at the activity
                       level within the activity group. Use No
                       if you do not want to create
                       consolidation files at the activity
                       level. Consolidation files keep
                       consolidated balances for summary level
                       activities and for reporting summary
                       balances. Consolidation records are
                       always kept at the activity group level.

                       Y = Yes
                       N = No

AGP-ACCT-EDIT-FLAG     Alpha 1                                   AC00.1
Element: Account Edit FThis field determines the type of
                       activity editing to be done in the
                       Lawson subsystems. 1 is valid only for
                       GL-only activity groups.

                       Valid values are

                       1 = Activity
                       2 = Activity and Account Category
                       3 = Activity, Account Category, and
                       Activity Account (Soft Errors)
                       4 = Activity, Account Category, and
                       Activity Account (Hard Errors)

AGP-BUDGET-EDIT        Alpha 1                                   AC00.1
Element: Budget Edit   This field determines whether to edit
                       budget amounts in the Purchase Order,
                       Requisitions, or Accounts Payable
                       systems.

                       The default is no editing of budget
                       amounts.
                       1 = No Edit
                       2 = Period Edit
                       3 = Annual Edit
                       4 = Total Edit

AGP-BUDGET-LEVEL       Alpha 1                                   AC00.1
Element: Budget Level  This flag determines which level of the
                       budget to edit in Purchase Order,
                       Requisitions, or Accounts Payable: the
                       activity (posting) or the activity group
                       (summary) level.

                       This field is required if budgets are
                       edited.
                       1 = Activity-Acct Cat
                       2 = Activity Group
                       3 = Activity

AGP-BUD-TOLERANCE      Signed 5.2                                AC00.1
Element: Budget ToleranThis field defines what percentage over
                       the budget, if any, is acceptable.
                       Budget Tolerance Percent is required if
                       budgets are edited.

AGP-EDIT-PR            Alpha 1                                   AC00.1
Element: Edit Payroll  This field indicates whether to edit
                       employee information in Payroll. Select
                       Yes if you want to edit employee
                       information.
                       1 = Yes-Commitments
                       2 = Yes-No Commitments
                       3 = No-Commitments
                       4 = No-No Commitments

AGP-EDIT-AP-EE         Alpha 1                                   AC00.1
Element: Edit AP and EEThis field indicates whether to edit
                       vendor information in Accounts Payable
                       (AP) and Employee Expense (EE). Select
                       Yes if you want to edit vendor
                       information. The default is No.
                       Y = Yes
                       N = No

AGP-EDIT-TRANSREL      Alpha 1                                   AC00.1
Element: Edit Transrel Y = Yes
                       N = No

AGP-LAST-COMMENT       Numeric 6
Element: Last Comment  This is the last sequence number used
                       for comments relating to the activity
                       group.

AGP-FRINGE-PCT         Signed 5.2
Element: Fringe PercentEnter a percentage by which to multiply
                       Payroll paywage amounts for commitment
                       reporting. Since fringe benefits are not
                       known at the time Payroll time records
                       (gross amounts) update commitments, you
                       can enter a fringe percentage to
                       multiple Payroll transactions by to get
                       a more accurate commitment amount.

AGP-LAST-AGA-SEQ       Numeric 6                                 AC07.1  AC105
Last Activity Grp      This is the last line added in AC07.1     AC110   AC120
Sequence Nbr           (Account Assignment). Account assignment
                       records are stored in the Activity GL
                       Accounts file.

AGP-RELEASED           Alpha 1
Element: Released      This is the change order status for the
                       activity group. Only one change order
                       for the activity group can be
                       unreleased.
                       Y = Released
                       N = Not Released

AGP-INV-AUDIT          Alpha 1                                   AC00.1
Element: Inv Audit     Y = Yes
                       N = No

AGP-BEGIN-YR           Derived
Element: Begin Year    This is the year in which activities in
                       the activity group begin.

AGP-END-YR             Derived
Element: End Year      This is the year in which the
                       activities in the activity group end.

AGP-GL-CONSOL-FL       Alpha 1                                   AC00.1
Accounting Unit        This flag indicates whether you want to
Consolidate            create summary-level activity
                       consolidation records in the Activity CL
                       Accounting Unit Consolidation header and
                       detail files.
                       Y = Yes
                       N = No

AGP-RESOURCE-FL        Alpha 1                                   AC00.1
Element: All Flag      Y = Yes
                       N = No

AGP-LEVEL-1-DESC       Derived
Element: Level 1 DescriThis is the description for level 1.

AGP-LEVEL-2-DESC       Derived
Element: Level 2 DescriThis is the description for level 2.

AGP-LEVEL-3-DESC       Derived
Element: Level 3 DescriThis is the description for level 3.

AGP-LEVEL-4-DESC       Derived
Element: Level 4 DescriThis is the description for level 4.

AGP-LEVEL-5-DESC       Derived
Element: Level 5 DescriThis is the description for level 5.

AGP-PURGE-STATUS       Alpha 1                                   AC00.3  AC300
Element: Purge Status  This field indicates the purge status
                       for the activity group. Use C for a
                       complete purge. Use B to purge balances
                       only.

AGP-OUTPUT-MEASURE     Signed 15.2                               AC00.1
Element: Adj Amt       This is the output measurement.

AGP-OUTPUT-DESC        Alpha 30                                  AC00.1
Element: Output Desc   This is the output description.

AGP-CURR-NAME-1        Alpha 12                                  AC00.1  AC581
Element: Name User

AGP-CURR-CODE-1        Alpha 5                                   AC00.1  AC198
Element: Currency Code                                           AC581

AGP-CURR-CODE-ND-1     Numeric 1                                 AC00.1  AC198
Account Currency                                                 AC581
Code

AGP-CURR-NAME-2        Alpha 12                                  AC00.1  AC581
Element: Name User

AGP-CURR-CODE-2        Alpha 5                                   AC00.1  AC198
Report Currency 2      Type the currency code you want to        AC581
Code                   associate with the report currency name.

                       The currency code must exist in CU01.1
                       (Currency Codes).



AGP-CURR-CODE-ND-2     Numeric 1                                 AC00.1  AC581
Account Currency
Code

AGP-BURDEN-CALC-FL     Alpha 1                                   AC00.1
Element: Burden Calc FlY = Yes
                       N = No

AGP-ACTIVITY-FLAG      Alpha 1                                   AC00.1
Element: Activity Flag Y = Yes
                       N = No

AGP-ASSET-FLAG         Alpha 1                                   AC00.1
Element: Asset Flag    Y = Yes
                       N = No

AGP-RESC-ASSIGN-FL     Alpha 1                                   AC00.1
Element: Resc Assign FlY = Yes
                       N = No

AGP-ATTRIBUTE-FLAG     Alpha 1                                   AC00.1
Element: Attribute FlagY = Yes
                       N = No

AGP-BILLING-FLAG       Alpha 1                                   AC00.1
Element: Billing Flag  Y = Yes
                       N = No

AGP-CONTRACT-FLAG      Alpha 1                                   AC00.1
Element: Contract Flag Y = Yes
                       N = No

AGP-CEILING-FLAG       Alpha 1                                   AC00.1
Element: Ceiling Flag  Y = Yes
                       N = No

AGP-BILL-CONSOL-FL     Alpha 1                                   AC00.1
Element: Bill Consol FlY = Yes
                       N = No

AGP-DATE-EDIT          Alpha 1                                   AC00.1
Element: Date Edit     Used with the ACAC Edit.  Valid values
                       are posting and transaction date.
                       P = Posting Date
                       T = Transaction Date

AGP-BILL-CALC-DATE     Alpha 1                                   AC00.1
Element: Bill Calc DateUsed with the activity billing
                       calculation logic. Valid values are
                       posting and transaction date.
                       P = Posting Date
                       T = Transaction Date

AGP-TE-ACCT-DF-FL      Alpha 1                                   AC00.1
Element: Te Acct Df Fl A = Use Activity Expense Account
                       " " = Use PR Default Expense Account

AGP-TE-ACCT-CAT-DF     Alpha 1                                   AC00.1
Element: Te Acct Cat Df" " = No Account Category Default
                       E = Use HR11 Default Acct Category

AGP-ACCOUNT            Numeric 6                                 AC00.1
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

AGP-SUB-ACCOUNT        Numeric 4                                 AC00.1
Element: Subaccount

AGP-GL-CODE            Alpha 4                                   AC00.1
Element: Gl Code

AGP-EXPENSE-FL         Alpha 1                                   AC00.1
Element: Expense Fl

AGP-ASSET-EDIT         Alpha 1                                   AC00.1
Element: Asset Edit    Y = Yes
                       N = No

AGP-CNTRCT-MOD-FL      Alpha 1                                   AC00.1
Element: Cntrct Mod Fl Y = Yes
                       N = No

AGP-TEMPLATE-FL        Alpha 1
Element: Template Fl

                         ACACTGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGPSET1   ACTIVITY-GRP                                           AC00.1  AC00.3
                                                                 AC01.1  AC01.5
                                                                 AC03.2  AC03.3
                                                                 AC03.4  AC03.5
                                                                 AC03.6  AC06.1
                                                                 AC07.1  AC08.2
                                                                 AC10.1  AC10.3
                                                                 AC10.5  AC105
                                                                 AC11.1  AC110
                                                                 AC112   AC113
                                                                 AC12.1  AC12.2
                                                                 AC120   AC121
                                                                 AC123   AC127
                                                                 AC13.1  AC13.2
                                                                 AC130   AC131
                                                                 ...

                         ACACTGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbudhdr Actv  ACBUDHDR     Not Required

                            AGP-ACTIVITY-GRP      -> BDH-ACTIVITY-GRP
                            Spaces                -> BDH-ACTIVITY
                            AGP-ACTIVE-BUD        -> BDH-BUDGET-NBR

Cucodes        CUCODES      Required

                            AGP-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Curr 1         CUCODES      Required

                            AGP-CURR-CODE-1       -> CUC-CURRENCY-CODE

Curr 2         CUCODES      Required

                            AGP-CURR-CODE-2       -> CUC-CURRENCY-CODE

Cutable        CUTABLE      Required

                            AGP-CURRENCY-TABLE    -> CTB-CURRENCY-TABLE

                         ACACTGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcatx     ACACCTCATX

                            AGP-ACTIVITY-GRP      -> AXX-ACTIVITY-GRP
                                                     AXX-ACCT-CATEGORY
                                                     AXX-ACTIVITY

Acactivity     ACACTIVITY

                            AGP-ACTIVITY-GRP      -> ACV-ACTIVITY-GRP
                                                     ACV-ACTIVITY

Acactivity Lvl ACACTIVITY

                            AGP-ACTIVITY-GRP      -> ACV-ACTIVITY-GRP
                                                     ACV-VAR-LEVELS

Acaddlcntr     ACADDLCNTR

                            AGP-ACTIVITY-GRP      -> ADN-ACTIVITY-GRP
                                                     ADN-CONTRACT

Acassign       ACASSIGN

                            AGP-ACTIVITY-GRP      -> AAN-ACTIVITY-GRP
                            Spaces                -> AAN-ACTIVITY
                                                     AAN-RESOURCE-TYPE
                                                     AAN-RESOURCE-CODE

Acbuddtl Actv  ACBUDDTL

                            AGP-ACTIVITY-GRP      -> BDT-ACTIVITY-GRP
                            Spaces                -> BDT-ACTIVITY
                            AGP-ACTIVE-BUD        -> BDT-BUDGET-NBR
                                                     BDT-ACCT-CATEGORY
                                                     BDT-FISCAL-YEAR

Acbudhdr       ACBUDHDR

                            AGP-ACTIVITY-GRP      -> BDH-ACTIVITY-GRP
                            Spaces                -> BDH-ACTIVITY
                                                     BDH-BUDGET-NBR

Accal          ACCAL

                            AGP-CALENDAR-NAME     -> CDH-CALENDAR-NAME
                                                     CDH-FISCAL-YEAR

Acchgorder     ACCHGORDER

                            AGP-ACTIVITY-GRP      -> CHO-ACTIVITY-GRP
                            Spaces                -> CHO-ACTIVITY
                            AGP-ACTIVE-BUD        -> CHO-BUDGET-NBR
                                                     CHO-CHG-ORDER-NBR

Accommit       ACCOMMIT

                            AGP-ACTIVITY-GRP      -> MIT-ACTIVITY-GRP
                                                     MIT-ACTIVITY
                                                     MIT-ACCT-CATEGORY
                                                     MIT-FISCAL-YEAR
                                                     MIT-PERIOD
                                                     MIT-SYSTEM
                                                     MIT-COMPANY
                                                     MIT-CURRENCY-CODE

Acconsol       ACCONSOL

                            AGP-ACTIVITY-GRP      -> CSL-ACTIVITY-GRP
                            Spaces                -> CSL-ACTIVITY
                                                     CSL-CURRENCY-CODE
                                                     CSL-ACCT-CATEGORY
                                                     CSL-BUDGET-NBR
                                                     CSL-FISCAL-YEAR

Acconsol Bud   ACCONSOL

                            AGP-ACTIVITY-GRP      -> CSL-ACTIVITY-GRP
                            Spaces                -> CSL-ACTIVITY
                                                     CSL-CURRENCY-CODE
                                                     CSL-ACCT-CATEGORY
                                                     CSL-BUDGET-NBR
                                                     CSL-FISCAL-YEAR

Accontacts     ACCONTACTS

                            AGP-ACTIVITY-GRP      -> CTS-ACTIVITY-GRP
                                                     CTS-CONTRACT
                                                     CTS-RESP-CODE

Acglacct       ACGLACCT

                            AGP-ACTIVITY-GRP      -> AGA-ACTIVITY-GRP
                            Spaces                -> AGA-ACTIVITY
                                                     AGA-ACCT-CATEGORY
                                                     AGA-SEQ-NUMBER

Acglconsl      ACGLCONSL

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

Actotbal Base  ACTOTBAL

                            AGP-ACTIVITY-GRP      -> TOT-ACTIVITY-GRP
                            Spaces                -> TOT-ACTIVITY
                            AGP-CURRENCY-CODE     -> TOT-CURRENCY-CODE
                                                     TOT-BUDGET-NBR
                                                     TOT-CATEGORY-TYPE
                                                     TOT-FISCAL-YEAR

Actotbal Cur1  ACTOTBAL

                            AGP-ACTIVITY-GRP      -> TOT-ACTIVITY-GRP
                            Spaces                -> TOT-ACTIVITY
                            AGP-CURR-CODE-1       -> TOT-CURRENCY-CODE
                                                     TOT-BUDGET-NBR
                                                     TOT-CATEGORY-TYPE
                                                     TOT-FISCAL-YEAR

Actotbal Cur2  ACTOTBAL

                            AGP-ACTIVITY-GRP      -> TOT-ACTIVITY-GRP
                            Spaces                -> TOT-ACTIVITY
                            AGP-CURR-CODE-2       -> TOT-CURRENCY-CODE
                                                     TOT-BUDGET-NBR
                                                     TOT-CATEGORY-TYPE
                                                     TOT-FISCAL-YEAR