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    AC03.7    AC06.1    AC06.2    AC08.2    AC08.3
AC08.7    AC10.1    AC10.3    AC10.5    AC10.6    AC108
AC11.1    AC112     AC113     AC12.1    AC12.2    AC13.1
AC13.2    AC130     AC131     AC135     AC14.1    AC14.2
AC14.3    AC14.4    AC14.6    AC14.7    AC145     AC160
AC165     AC18.1    AC18.2    AC18.3    AC18.4    AC18.5
AC190     AC191     AC197     AC198     AC200     AC203
AC206     AC207     AC21.1    AC21.2    AC21.3    AC21.4
AC210     AC213     AC218     AC220     AC225     AC227
AC240     AC246     AC25.1    AC255     AC256     AC261
AC265     AC27.1    AC290     AC295     AC298     AC30.3
AC32.1    AC34.1    AC346     AC35.1    AC36.1    AC37.1
AC40.1    AC40.4    AC400     AC401     AC41.1    AC41.4
AC410     AC412     AC42.1    AC420     AC421     AC440
AC45.1    AC45.2    AC46.1    AC46.2    AC460     AC471
AC472     AC473     AC480     AC490     AC493     AC494
AC50.1    AC50.2    AC500     AC502     AC510     AC52.1
AC520     AC54.1    AC540     AC55.1    AC580     AC583
AC61.1    AC65.1    AC65.2    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    AC96.4    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     AP211     AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP520     AP95.3    API1.1
API2.1    AR115     AR124     AR190     AR20.1    AR21.1
AR21.2    AR21.3    AR24.1    AR250     AR29.2    AR30.1
AR30.5    AR33.2    AR34.1    AR42.1    AR42.2    AR42.7
AR43.1    AR560     AR570     AR575     AR580     ARLL.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
BN150     BR00.1    BR00.2    BR00.3    BR01.1    BR01.2
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     BR13.1    BR130     BR131     BR14.1
BR140     BR142     BR145     BR15.2    BR165     BR19.1
BR19.2    BR190     BR20.1    BR20.2    BR20.3    BR20.4
BR20.5    BR20.6    BR20.7    BR20.9    BR200     BR202
BR204     BR205     BR21.1    BR210     BR212     BR215
BR220     BR245     BR265     BR300     BR40.1    BR40.3
BR40.4    BR400     BR405     BR41.1    BR41.4    BR42.1
BR420     BR43.1    BR430     BR44.1    BR45.1    BR450
BR46.1    BR46.2    BR46.4    BR515     BR516     BR521
BR530     BR580     BR65.1    BR65.2    BR90.1    BR90.2
BR96.1    BRCC.1    BRIP.1    CB10.1    CB15.1    CB15.2
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
GL70.1    GL70.2    GL70.3    GL70.5    GL70.6    GL75.1
HCHP.1    DR100     IC140     IC28.1    IC531     IC83.1
IFGT.1    MX123     MX500     MA180     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    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE14.4
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE81.1    OE810
OE830     OE90.1    OE90.2    PA182     PO100     PO101
PO122     PO131     PO150     PO20.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO25.1    PO25.6
PO25.7    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     POCP.1    POI3.1    POID.1    POIE.1
POIF.1    POII.1    POIJ.1    PR128     PR130     PR131
PR132     PR134     PR136     PR137     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
PR35.9    PR36.1    PR37.1    PR38.1    PR45.1    PR529
PR530     PR560     PR82.1    PR85.1    PRSA.1    UK102
UK330     RQ10.1    RQ10.2    RQ12.1    RQ13.1    RQ13.2
RQ140     RQ300     RQ35.1    RQ40.1    RQ41.1    RQ42.1
RQ44.1    RQ44.2    RQ500     RQIA.1    RQIF.1    TA147
TP135     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     MX202     MX223

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        AC197   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.   AC197   AC198
Description

AGP-OBJ-ID             Numeric 12                                AC00.1  AC110
Object                 This is the object identifier. It is
Identification         used to relate activity group attributes
                       to the activity group.

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  AC197
Element: Currency Code This is the base currency code of the     AC198   BR02.3
                       activity group. You define the base       BR120   BR121
                       currency code in AC00.1 (Activity         BR122   BR140
                       Group). Consolidation amounts are         BR20.1  BR20.2
                       reported in activity group base           BR20.3  BR20.4
                       currency.                                 BR20.5  BR420
                                                                 BR521

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  BR02.3
Element: Calendar Name Required. Enter the name of a calendar    BR120   BR121
                       that defines the fiscal periods for the   BR122   BR140
                       activity group. The calendar is defined   BR20.1  BR20.2
                       in AC00.3 (Calendar).                     BR20.3  BR20.4
                                                                 BR20.5  BR420
                                                                 BR521

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  AC197
Base Number of         This is the number of decimal positions   AC198
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 18.2                               AC00.1  AC110
Element: Total Budget  This is the sum of the activity budgets   AC20.1  AC20.2
                       for the activity group. This field is     AC20.3  AC20.4
                       used in editing to determine if the sum   AC20.5  AC20.6
                       of the activity budgets exceeds the       AC20.7  ACDR.1
                       budget cap.

AGP-BUDGET-CAP         Signed 18.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
                       4 = Activity-Summary Account Cat

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.
                       Y = Yes
                       N = No

AGP-PR-COMMIT          Alpha 1                                   AC00.1
Element: Pr Commit     Overrides the PR Commit flag on the
                       system codes (GL01.4) to determine
                       whether PR commitments are created
                       during PR processing for transactions
                       involving activities associated with the
                       activity group.
                       N = No
                       Y = Yes

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-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.
                       " " = No Purge
                       B = Balances Only
                       C = Complete

AGP-OUTPUT-MEASURE     Signed 18.2                               AC00.1
Element: Intl 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
Report Currency 1      Type or select a name that identifies
Name                   the report currency. You must define
                       exchange rates (CU10.1) and currency
                       relationships (CU02.1) for the report
                       currency with the company base currency.


                       The report currencies are additional
                       non-base currencies that identify a
                       company operating currency. This report
                       currency is for reports and analysis
                       only.

                       The report currencies are calculated in
                       the same manner as base currency.

                       Transaction amounts will always be
                       converted to the Base Currency. If you
                       also use a report currency, amounts will
                       convert to both the Base and Report
                       Currency.

                       Note: The report currency cannot be the
                       same as the company base currency.






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

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



AGP-CURR-CODE-ND-1     Numeric 1                                 AC00.1  AC198
Account Currency       The number of decimal positions defined   AC581
Code                   for Report Currency 1.


AGP-CURR-NAME-2        Alpha 12                                  AC00.1  AC581
Report Currency 2      Type or select a name that identifies
Name                   the report currency. You must define
                       exchange rates (CU10.1) and currency
                       relationships (CU02.1) for the report
                       currency with the company base currency.


                       The report currencies are additional
                       non-base currencies that identify a
                       company operating currency. This
                       report currency is for reports and
                       analysis only. The report currencies are
                       calculated in the same manner as base
                       currency.

                       Transaction amounts will always be
                       converted to the Base Currency. If you
                       also use a report currency, amounts will
                       convert to both the Base and Report
                       Currency.

                       Note: The report currency cannot be the
                       same as the company base currency.






AGP-CURR-CODE-2        Alpha 5                                   AC00.1  AC197
Report Currency 2      Type the currency code you want to        AC198   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       The number of decimal positions defined
Code                   for Report Currency 2.


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  BR02.3
Element: Bill Consol FlY = Yes                                   BR120   BR121
                       N = No                                    BR122   BR140
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR420
                                                                 BR521

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 = Activity Expense Account
                       E = Employee Expense Account

AGP-TE-ACCT-CAT-DF     Alpha 1                                   AC00.1
Element: Te Acct Cat DfA = Activity Acct Category
                       E = Employee 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    This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

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-POP-FLAG           Alpha 1                                   AC00.1
Element: Pop Flag      Period of Performance flag. Will
                       indicate the use of period of
                       performance.  This will be edited when
                       transactions are added.
                       N = No
                       Y = Yes

AGP-BRDN-DATE-EDIT     Alpha 1                                   AC00.1
Element: Brdn Date EditDetermines whether burden rates are
                       based on the ACTRANS transaction date or
                       posting date.
                       P = Posting Date
                       T = Transaction Date

AGP-STRUCTURE          Alpha 15                                  AC00.1
Element: Structure     The name of the category structure.
                       This represents the category structure
                       assigned to the activity group.

AGP-CAT-CONSOL-FL      Alpha 1                                   AC00.1
Element: Consol Flag   Y = Yes
                       N = No

                         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  AC03.7
                                                                 AC06.1  AC06.2
                                                                 AC07.1  AC08.2
                                                                 AC08.3  AC10.1
                                                                 AC10.3  AC10.5
                                                                 AC10.6  AC105
                                                                 AC108   AC11.1
                                                                 AC110   AC112
                                                                 AC113   AC12.1
                                                                 AC12.2  AC120
                                                                 AC121   AC123
                                                                 ...

AGPSET2   OBJ-ID                                                 AC01.1  AC105
                                                                 AC112   AC113
                                                                 AC120   AC121
                                                                 AC123   AC130
                                                                 AC135   AC14.2
                                                                 AC14.3  AC14.4
                                                                 AC145   AC160
                                                                 AC165   AC190
                                                                 AC191   AC197
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 ...

AGPSET3   STRUCTURE     KeyChange                                AC08.7
          ACTIVITY-GRP

                         ACACTGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acaddlcntr     ACADDLCNTR   Not Required

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

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      Not Required

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

Curr 2         CUCODES      Not Required

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

Cutable        CUTABLE      Not Required

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

Structure      STRUCTURE    Required

                            AGP-STRUCTURE         -> SRE-STRUCTURE

                         ACACTGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY

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

Acactivity Lvl ACACTIVITY

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

Acasnrole      ACASNROLE

                            AGP-ACTIVITY-GRP      -> ALE-ACTIVITY-GRP
                            Spaces                -> ALE-ACTIVITY
                                                     ALE-RESOURCE-TYPE
                                                     ALE-COMPANY
                                                     ALE-RESOURCE-CODE
                                                     ALE-ROLE

Acassign       ACASSIGN

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

Acbrdndtl      ACBRDNDTL

                            AGP-ACTIVITY-GRP      -> BRD-ACTIVITY-GRP
                            Spaces                -> BRD-ACTIVITY
                                                     BRD-ACCT-CATEGORY
                                                     BRD-BURDEN-CD
                                                     BRD-POOL-NBR

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

Accatsum       ACCATSUM

                            AGP-STRUCTURE         -> SRS-STRUCTURE
                                                     SRS-SUM-ACCT-CAT

Accatsumx      ACCATSUMX

                            AGP-STRUCTURE         -> SRX-STRUCTURE
                                                     SRX-ACCT-CATEGORY

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-COMP
                                                     GCO-RESOURCE-CODE
                                                     GCO-FISCAL-YEAR

Acprdperf      ACPRDPERF

                            AGP-ACTIVITY-GRP      -> PFM-ACTIVITY-GRP
                            Spaces                -> PFM-ACTIVITY
                                                     PFM-SYSTEM
                                                     PFM-SEQ-NUMBER

Acreshist      ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                                                     RSH-ACTIVITY
                                                     RSH-RESOURCE-TYPE
                                                     RSH-RESOURCE-CODE
                                                     RSH-COMPANY
                                                     RSH-ROLE
                                                     RSH-FIELD-ID
                                                     RSH-SEQ-NUMBER

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

Histastasgn    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "A"                   -> RSH-RESOURCE-TYPE
                            340                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histastrole    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "A"                   -> RSH-RESOURCE-TYPE
                            341                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histempasgn    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "E"                   -> RSH-RESOURCE-TYPE
                            320                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histemprole    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "E"                   -> RSH-RESOURCE-TYPE
                            321                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histeqpasgn    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "Q"                   -> RSH-RESOURCE-TYPE
                            350                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histeqprole    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "Q"                   -> RSH-RESOURCE-TYPE
                            351                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histperasgn    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "P"                   -> RSH-RESOURCE-TYPE
                            310                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histperrole    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "P"                   -> RSH-RESOURCE-TYPE
                            311                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histvenasgn    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "V"                   -> RSH-RESOURCE-TYPE
                            330                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histvenrole    ACRESHIST

                            AGP-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            "V"                   -> RSH-RESOURCE-TYPE
                            331                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Perfhist       ACPRDPERF

                            AGP-ACTIVITY-GRP      -> PFM-ACTIVITY-GRP
                            Spaces                -> PFM-ACTIVITY
                                                     PFM-SYSTEM
                                                     PFM-SEQ-NUMBER