Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACTIVITY


                            ACACTIVITY FILE

                                Activity

This file contains activity set-up and definition information from AC10.1
(Activity). Activities identify the actual tasks that make up an activity.
Project and Activity Accounting stores data such as activity group,
responsible company, date ranges,  status, long description, levels and
location. This information is used to  collect and report on costs and
revenues. You must set up an activity before  you can create activity budgets
and post transactions.

An activity's level number configuration relates it to other activities in a
hierarchy for consolidating, or rolling up, data on certain forms and reports.


Transactions in Project and Activity Accounting are posted to activities.
Journal entries destined for  activity posting are entered in the General
Ledger or a subledger with an  entry in the Activity and Account Category
fields on the transaction line.

REFERENCED BY

AC01.1    AC02.1    AC03.2    AC03.3    AC03.4    AC03.5
AC03.6    AC03.7    AC06.1    AC06.2    AC07.1    AC08.3
AC105     AC108     AC11.1    AC121     AC123     AC128
AC13.1    AC13.2    AC13.3    AC13.4    AC13.7    AC13.8
AC130     AC131     AC135     AC145     AC160     AC165
AC169     AC18.1    AC18.2    AC18.3    AC18.4    AC18.5
AC19.1    AC191     AC197     AC198     AC200     AC203
AC206     AC207     AC21.1    AC21.2    AC21.3    AC21.4
AC210     AC213     AC218     AC22.1    AC220     AC225
AC227     AC240     AC246     AC25.1    AC256     AC261
AC265     AC27.1    AC29.1    AC290     AC295     AC298
AC30.1    AC30.2    AC30.3    AC30.4    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    AC42.3    AC420     AC421     AC440     AC45.1
AC45.4    AC46.1    AC46.2    AC460     AC471     AC472
AC473     AC480     AC490     AC493     AC494     AC50.1
AC50.2    AC502     AC51.1    AC510     AC52.1    AC520
AC527     AC54.1    AC540     AC55.1    AC56.1    AC560
AC580     AC581     AC583     AC60.1    AC60.2    AC61.1
AC65.1    AC65.2    AC69.1    AC704     AC71.1    AC81.1
AC881     AC90.1    AC90.2    AC90.4    AC90.6    AC90.8
AC92.1    AC92.2    AC92.4    AC92.6    AC93.1    AC93.4
AC93.5    AC93.2    AC93.3    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    ACSB.1    ACSR.1    ACVW.1
SE10.1    SE90.1    AM18.2    AP125     AP126     AP131
AP170     AP178     AP190     AP193     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP21.1    AP211
AP23.1    AP237     AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    AP520     AP95.3    API1.1    API2.1
AR115     AR124     AR129     AR130     AR131     AR135
AR190     AR20.1    AR21.1    AR21.2    AR21.3    AR237
AR239     AR24.1    AR250     AR251     AR257     AR27.2
AR29.1    AR29.2    AR293     AR296     AR30.1    AR30.5
AR30.8    AR32.1    AR33.1    AR33.2    AR33.3    AR33.6
AR34.1    AR35.1    AR36.1    AR38.5    AR39.1    AR39.2
AR39.3    AR39.4    AR42.1    AR42.2    AR42.7    AR43.1
AR48.3    AR502     AR503     AR55.1    AR560     AR570
AR575     AR580     AR800     AR91.1    ARLL.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    BN150
BN66.1    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
BR06.1    BR12.2    BR121     BR123     BR124     BR13.1
BR131     BR14.1    BR142     BR145     BR15.2    BR151
BR152     BR153     BR154     BR155     BR156     BR157
BR165     BR18.1    BR18.2    BR18.3    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     BR206     BR21.1    BR210     BR212     BR215
BR22.1    BR220     BR245     BR251     BR252     BR253
BR254     BR265     BR300     BR40.1    BR40.3    BR40.4
BR400     BR405     BR41.1    BR41.4    BR42.1    BR420
BR422     BR43.1    BR430     BR44.1    BR45.1    BR450
BR46.1    BR46.2    BR46.3    BR46.4    BR51.1    BR51.2
BR515     BR516     BR52.1    BR52.2    BR52.4    BR52.5
BR53.1    BR53.2    BR54.1    BR54.2    BR54.3    BR54.4
BR55.1    BR56.1    BR570     BR580     BR65.1    BR65.2
BR65.3    BR70.1    BR70.2    BR90.1    BR96.1    BRIP.1
CB10.1    CB15.1    CB15.2    CB150     CB180     CB191
CB20.1    CB30.1    CB45.1    CB46.1    CB500     CB543
CB544     CB55.1    CB554     CB80.1    CB82.1    CXCP.1
EE135     EE20.3    EE35.1    EE35.2    EE520     ET175
ET530     ET540     ET542     ETI2.1    GL146     GL165
GL170     GL197     GL199     GL40.1    GL40.2    GL40.3
GL40.7    GL40.8    GL44.1    GL45.1    GL50.4    GL70.1
GL70.2    GL70.3    GL70.5    GL70.6    GL75.1    GL90.3
HCHP.1    HACV.1    IFGT.1    MX123     MX500     LP130
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PA182     PD10.1    PD10.2
PD130     PD20.1    PD20.2    PD20.3    PO100     PO101
PO122     PO131     PO135     PO150     PO190     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO23.1    PO24.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    PO32.4    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    HS36.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    PR35.9    PR36.1    PR37.1    PR38.1
PR45.1    PR529     PR530     PR560     PR80.1    PR82.1
PR85.1    PR89.1    UK102     UK330     UK560     PW90.1
PWI2.1    RQ10.1    RQ10.2    RQ12.1    RQ13.1    RQ13.2
RQ35.1    RQ500     RQD0.1    RQIF.1    SB15.1    SN02.1
SNAC.1    TA147     WH130     WH132     WH190     WH20.2
WH20.7    WH222     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
ET700     MX202     MX223

UPDATED BY

AC00.1    AC10.1    AC10.5    AC10.6    AC110     AC112
AC113     AC12.1    AC120     AC127     AC190     AC20.7
AC300     AC310     AC500     ACDR.1    BR10.1    BR10.9
BR120     BR122     BR130     BR140     BR521     BR530
PW110     PW510     SB515

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACV-ACTIVITY           Alpha 15                                  AC10.1  AC110
Element: Activity      Activities are the processes or           AC197   AC198
                       procedures that produce work. Cost        AC500   AC540
                       objects (products, services, customers,   AC90.2  AC90.4
                       and so on) are the reasons for            AC90.6  AC90.8
                       performing the activity. Activities and   AC95.2  ET540
                       cost object activities are used           PW110   PW510
                       synonymously in Project Accounting.
                       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.

ACV-DESCRIPTION        Alpha 30  (Lower Case)                    AC10.1  AC110
Element: Activity DescrThis is the activity description.         AC145   AC197
                                                                 AC198   AC500
                                                                 PW110   PW510

ACV-ACTIVITY-GRP       Alpha 15                                  AC10.1  AC110
Element: Activity GroupThis is the activity group for the        AC120   AC500
                       activity.                                 AC90.2  AC90.4
                                                                 AC90.6  AC90.8
                                                                 AC95.2  PW110
                                                                 PW510

ACV-CONTRACT           Alpha 15                                  BR10.1  BR10.9
Element: Contract      If this Activity is a Contract type, and  PW110
                       is idetified in BR0 as the 'Contract
                       Activity', th name of the related
                       Contrct will be updated to this field.

ACV-COMPANY            Numeric 4                                 AC10.1  AC110
Element: Company       This field defines the responsible        AC113   AC500
                       company number for the activity. The      AC540   PW110
                       responsible company is defined in the     PW510
                       General Ledger system. The responsible
                       company determines the activity
                       currency.

ACV-ACCT-UNIT          Alpha 15                                  AC10.1  AC110
Element: Accounting UniThis is an accounting unit for the        AC113   AC500
                       activity. The accounting unit is a        PW110   PW510
                       shorthand notation representing a
                       location or variable level. The
                       accounting unit must be defined in the
                       General Ledger Names file as a posting
                       accounting unit.

ACV-ACCOUNT            Numeric 6                                 AC10.1  AC110
Element: Account       This field along with the accounting      AC113   AC500
                       unit and subaccount make up the location  PW110   PW510
                       (account) where amounts and other
                       account information is stored.

ACV-SUB-ACCT           Numeric 4                                 AC10.1  AC110
Element: Subaccount    This field contains the subaccount from   AC113   AC500
                       your general ledger chart of accounts     PW110   PW510
                       that was charged with the amount carried
                       on this record.

ACV-ACCT-CATEGORY      Alpha 5                                   AC10.1  AC110
Element: Account CategoThis is an account category for the       AC500   PW110
                       activity. Account categories are          PW510
                       groupings of costs, revenues, or a
                       combination of both used for reporting
                       and inquiries for activities in Project
                       Accounting. All transactions are posted
                       to an account category within an
                       activity. Using AC07.1 (Account
                       Assignment), you can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) to the
                       transactions posted to an account
                       category .

ACV-CURRENCY-CODE      Alpha 5                                   AC10.1  AC110
Element: Currency Code This is the company currency code.        AC197   AC198
                                                                 AC500   PW110
                                                                 PW510

ACV-USR-STATUS         Alpha 2                                   AC10.1  AC110
Element: Status        This is a user-defined code indicating    AC112   AC12.1
                       the status of the activity. You can       AC500   PW110
                       define various parameters relating to     PW510
                       the status in AC02.1 (Status), including
                       whether an activity allows posting,
                       billing, revenue recognition, budgeting,
                       capitalization, or purging. This field
                       is required for activities assigned to
                       Activity Management activity groups. It
                       is not required for GL-only activities.

ACV-VAR-LEVELS         Alpha 30                                  AC10.1  AC110
Element: Variable LevelLevels define an addressing system that   AC120   AC500
                       organizes activities into a reporting     AC90.2  AC90.4
                       hierarchy. Level names are defined for    AC90.6  AC90.8
                       an activity group and should be able to   AC95.2  PW110
                       be used across all activities in an       PW510
                       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.

                       Up to 15 characters can be used to name
                       a single level. The number of characters
                       used to name all levels can total 30.

ACV-VAR-LEVEL-DISP     Alpha 34                                  AC10.1  AC110
Variable Level         This field shows the hierarchical         AC120   AC197
Display                numbering scheme that allows detail to    AC198   AC500
                       be aggregated or "rolled-up" in           PW110   PW510
                       summarized form. Five levels are
                       available in the Activity Management
                       system.

ACV-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC10.1  AC110
Element: Begin Date    This is the beginning date for the        AC500   PW110
                       activity. The activity date range must    PW510
                       be within the date range for the
                       activity group. If you leave this field
                       blank, the activity group begin date
                       defaults.

ACV-END-DATE           Numeric 8  (yyyymmdd)                     AC10.1  AC110
Element: End Date      This is the ending date for the           AC113   AC500
                       activity. The activity date range must    PW110   PW510
                       be within the date range for the
                       activity group. If you leave this field
                       blank, the activity group begin date
                       defaults.

ACV-ACTIVE-BUD         Numeric 3                                 AC110   AC127
Element: Active Budget This is the budget number for the         AC20.7  AC310
                       activity group active budget. The active  SB515
                       budget is the default budget used for
                       inquiries and reporting and in
                       calculating percentage of completion for
                       AC65.1 (Account Category Percent of
                       Completion).

ACV-LONG-DESC          Alpha 60  (Lower Case)                    AC10.1  AC110
Element: Long DescriptiOccurs 4 Times                            AC500   PW110
                       This is the long description of the       PW510
                       activity.

ACV-ESTIMATE           Signed 18.2                               AC10.1  AC110
Element: Estimate      This is a budget estimate for the         AC500
                       activity. This estimate is informational
                       only.

ACV-OBJ-ID             Numeric 12                                AC10.1  AC110
Element: Activity ObjecThis field defines the activity. The      AC197   AC198
                       object ID is used with activity           AC500   PW110
                       attributes. Attribute matrix files are    PW510
                       keyed by object ID. The value in this
                       field is unique and generated by the
                       system.

ACV-PARENT-ACTV        Alpha 15                                  AC10.1  AC110
Element: Parent Actv   The parent activity field contains the    AC120   AC500
                       activity name of the member parent.       PW110   PW510

ACV-ACTIVITY-ND        Numeric 1                                 AC10.1  AC110
Activity Curr Nbr      This is the number of decimal positions   AC145   AC197
of Decimals            defined for the activity currency.        AC198   AC500
                                                                 PW110   PW510

ACV-HIGH-PST-DATE      Numeric 8  (yyyymmdd)                     AC110   AC190
Element: Highest PostinThis is the latest posting date for       AC300   AC500
                       transactions posted to the activity.      ACDR.1  PW110
                                                                 PW510

ACV-BALANCE-AMOUNT     Signed 18.2                               AC110   AC300
Element: Balance AmountThis is the amount balance for the        ACDR.1
                       life-to-date activity actuals amount.

ACV-BALANCE-UNIT       Signed 17.2                               AC110   AC300
Element: Units Balance This is the unit balance for the          ACDR.1
                       activity actuals.

ACV-SHORT-DESC         Derived
Element: Short DescriptThis is the short description of the
                       activity.

ACV-BILLABLE-FLAG      Alpha 1                                   AC10.1  AC110
Element: Billable Flag This field indicates whether the          AC197   AC198
                       activity is billable. Use Yes (Y) for     AC500   PW110
                       billable. Use No (N) for nonbillable.     PW510
                       Y = Yes
                       N = No
                       H = Hold

ACV-SECURITY-CD        Numeric 4                                 AC00.1  AC10.1
Element: Security Cd   This field contains the security code     AC110   AC120
                       for the activity.                         AC500   PW110
                                                                 PW510

ACV-POST-OR-GLONLY     Derived
Element: Post Or Glonly

ACV-OUTPUT-MEASURE     Signed 18.2                               AC10.1  AC500
Element: Intl Amt      This is the output measurement.

ACV-OUTPUT-DESC        Alpha 30                                  AC10.1  AC500
Element: Output Desc   This is the output description.

ACV-SEGMENT-FLAG       Alpha 1                                   AC10.1  AC110
Element: Segment Flag  Indicates whether user analysis values    AC500   PW110
                       (SL segment) have been populated for the  PW510
                       distribution line.

ACV-GRP-CURR-CODE1     Derived
Element: Grp Curr Code1

ACV-GRP-CURR-CODE2     Derived
Element: Grp Curr Code2

ACV-ACT-SEG-BLOCK      Derived
Element: Act Seg Block

ACV-BILL-WBS-CODE      Alpha 3                                   AC10.1  AC500
Element: Bill Wbs Code

ACV-LOCATION-NAME      Alpha 15                                  AC10.1
Element: Location Name A user-defined location name which
                       represents where an asset is physically
                       located. Locations are used to report
                       asset information.

ACV-DIVISION           Alpha 15                                  AC10.1
Element: Division      A user-defined division which is used
                       for reporting assets.

ACV-POP-FLAG           Alpha 1                                   AC10.6  AC110
Element: Pop Flag      Period of Performance flag.  If records   AC120
                       are added into the ACPRDPERF file for
                       the related activity, the flag will be
                       updated to Y.
                       N = No
                       Y = Yes

ACV-AWARD-FLAG         Alpha 1                                   AC10.1  AC110
Element: Award Flag    Flag to indicate whether this activity    AC113   AC500
                       is an award for the GM system or a
                       posting level activity within an award.
                       Y = Yes
                       N = No

ACV-EFFORT-FLAG        Alpha 1                                   AC10.1  AC110
Element: Effort Flag   Flag to indicate whether this activity    AC113   AC500
                       is subject to effort reporting, and if
                       it is, whether it prints in the
                       sponsored or non-sponsored section of
                       the report for effort reporting.
                       Y = Yes
                       N = No

ACV-SALARY-CAP-FL      Alpha 1                                   AC10.1  AC110
Element: Salary Cap Fl This flag indicates whether the salary    AC113   AC500
                       cap applies to this grant/project.  The
                       actual salary cap amount is stored on
                       the GMSALCAP record.
                       Y = Yes
                       N = No

ACV-FRNG-RATE          Signed 14.7                               AC10.1  AC110
Element: Curr Rate     The currency rate.                        AC113   AC500

ACV-FRNG-ACCT-CAT      Alpha 5                                   AC10.1  AC110
Element: Frng Acct Cat A default post-to fringe account          AC113   AC500
                       category that can be used by GM110
                       program to create commitments for fringe
                       amounts.  There is a parameter choice on
                       the GM110 program that allows the user
                       to default the rate, post-to account and
                       account category information from the
                       activity or employee.

ACV-FRNG-ACCOUNT       Numeric 6                                 AC10.1  AC110
Element: Frng Account  A default post-to fringe account that     AC113   AC500
                       can be used by the GM110 program to
                       create commitments for fringe amounts.
                       There is a parameter choice on the GM110
                       program that allows the user to default
                       the fringe rate, post-to account and
                       account category information from the
                       activity or employee.

ACV-FRNG-SUB-ACCT      Numeric 4                                 AC10.1  AC110
Element: Frng Sub Acct A default post-to fringe sub account      AC113   AC500
                       that can be used by the GM110 program to
                       create commitments for fringe amounts.
                       There is a parameter choice on the GM110
                       program that allows the user to default
                       the fringe rate, post-to account and
                       account category information from the
                       activity or employee.

ACV-SALARY-CAP-AMT     Signed 18.2
Element: Intl Amt      Salary cap amount for the activity. It
                       is assummed to be in the activity
                       currency.

ACV-STRUCTURE          Alpha 15                                  AC10.1  AC110
Element: Structure     The name of the category structure.       AC500   PW110
                       This represents the category structure    PW510
                       assigned to the activity.

ACV-BILL-REV-FLAG      Alpha 1                                   AC10.1  AC120
Element: Bill Rev Flag Y = Yes                                   BR120   BR122
                       N = No                                    BR130   BR140
                                                                 BR521   BR530

ACV-BACKOUT-STATUS     Alpha 1                                   AC10.1  AC10.5
Element: Backout StatusY = Yes                                   AC120   BR140
                       N = No

ACV-PAR-ACT-STRCT      Alpha 15 Occurs 4 Times                   AC10.1  AC110
Element: Parent Actv   This field will contain the parent of     AC120   AC500
                       the Activity at each variable level in    PW110   PW510
                       the Activity Groups hierarchy.

ACV-POSTING-FLAG       Alpha 1                                   AC10.1  AC110
Element: Posting Flag  P = Posting                               AC500   PW110
                       S = Summary                               PW510
                       C = Contract

ACV-LEVEL-DEPTH        Numeric 1                                 AC10.1  AC110
Element: Level Depth   The number of variable levels             AC120   AC500
                       pertaining                                PW110   PW510
                       to this record.


ACV-LEVEL-DETAIL       Numeric 15 Occurs 5 Times                 AC10.1  AC110
Element: Level Detail                                            AC120   AC500
                                                                 PW110   PW510

ACV-BUDGET-EDIT        Alpha 1                                   AC10.1  AC110
Element: Budget Edit   1 = No Edit                               AC113   AC500
                       2 = Period Edit
                       3 = Annual Edit
                       4 = Total Edit

ACV-BUDGET-LEVEL       Alpha 1                                   AC10.1  AC110
Element: Budget Level  1 = Activity-Acct Cat                     AC113   AC500
                       3 = Activity
                       4 = Activity-Summary Account Cat

ACV-BUD-TOLERANCE      Signed 5.2                                AC10.1  AC110
Element: Bud Tolerance                                           AC113   AC500

ACV-SCHEDULE           Alpha 9                                   AC10.1  AC110
Element: Schedule      Stores the applicable salary cap          AC113   AC500
                       schedule when the grant activity is
                       subject to a salary cap.  Only one
                       schedule can exist per grant activity
                       (the grant structure requires one
                       activity per funding source and salary
                       caps are driven by funding sources).

                       Valid only if ACV-SALARY-CAP-FL is set
                       to Y.

ACV-CURRENT-CAP        Alpha 1                                   AC10.1  AC110
Element: Flag          Determines which salary cap amount is     AC113   AC500
                       used to determine salary cap overage on
                       labor distribution templates and
                       reports.

                       Y indicates that the most current active
                       salary cap amount in the schedule is
                       used.

                       N or blank (the default) indicates that
                       the salary cap amount in effect in the
                       schedule on the activity start date is
                       used.
                       Y = Yes
                       N = No

ACV-CAP-ACTIVITY       Alpha 15                                  AC10.1  AC110
Element: Activity      Identifies the activity to charge with    AC113   AC500
                       the salary cap overage on the labor
                       distribution template.

                       When a salary cap overage occurs, a new
                       template line is created with the GL
                       account and activity (if any) to which
                       the overage should be charged.

                       If this field is blank, salary cap
                       overages are not charged to any activity
                       or account categories.

ACV-CAP-ACCT-CAT       Alpha 5                                   AC10.1  AC110
Element: Acct Category Valid only if an activity is selected.    AC113   AC500

                       Identifies the account category to
                       charge with the salary cap overage on
                       the labor distribution template.

                       When a salary cap overage occurs, a new
                       template line is created with the GL
                       account and activity/account category
                       (if any) to which the overage should be
                       charged.

                       If the account category field is blank
                       and the activity field is populated, the
                       overage is charged to the account
                       category on the labor distribution
                       template line from which the overage is
                       initiated.

                       If the activity field is not populated,
                       the account category field cannot be
                       populated. Overage is not charged to AC.

ACV-CAP-COMPANY        Numeric 4                                 AC10.1  AC110
Element: Company       Identifies the GL company to charge with  AC113   AC500
                       the salary cap overage on the labor
                       distribution template.

                       When a salary cap overage occurs, a new
                       template line is created with the GL
                       account and activity (if any) to which
                       the overage should be charged.

                       If the company field is blank, the
                       overage is charged to the GL company on
                       the labor distribution template line
                       from which the overage is initiated.

ACV-CAP-ACCT-UNIT      Alpha 15                                  AC10.1  AC110
Element: Acct Unit     Identifies the accounting unit to charge  AC113   AC500
                       with the salary cap overage on the labor
                       distribution template.

                       When a salary cap overage occurs, a new
                       template line is created with the GL
                       account and activity (if any) to which
                       the overage should be charged.

                       If the Accounting Unit field is blank,
                       overage is charged to the accounting
                       unit on the labor distribution template
                       line from which the overage is
                       initiated.

ACV-CAP-ACCOUNT        Numeric 6                                 AC10.1  AC110
Element: Account       Identifies the account to charge with     AC113   AC500
                       the salary cap overage on the labor
                       distribution template.

                       When a salary cap overage occurs, a new
                       template line is created with the GL
                       account and activity (if any) to which
                       the overage should be charged.

                       If the Account field is blank, overage
                       is charged to the account on the labor
                       distribution template line from whcih
                       the overage is initiated.

ACV-CAP-SUB-ACCT       Numeric 4                                 AC10.1  AC110
Element: Sub Acct      Identified the subaccount to cahrge with  AC113   AC500
                       the salary cap overage on the labor
                       distribution template.

                       When a salary cap overage occurs, a new
                       template line is created with the GL
                       account and activity (if any) to which
                       the overage should be charged.

                       If the Subaccount field is blank, the
                       overage is charged to the subaccount (if
                       any) on the labor distribution template
                       line from which the overage is
                       initiated.

ACV-CAP-SEG-FLAG       Alpha 1                                   AC10.1  AC110
Element: Segment Flag  Identifies the user analysis (if any) to  AC113   AC500
                       charge with the salary cap overage on
                       the labor distribution template.

                       When a salary cap overage occurs, a new
                       template line is created with GL
                       account, activity (if any) and user
                       analysis (if any) to which the overage
                       should be charged.

                       If this field is blank, overage is
                       charged to the user analysis (if any) on
                       the labor distribution template line
                       from which the overage is initiated.

ACV-DATE-CREATED       Numeric 8  (yyyymmdd)
Element: Date          This field displays the system date
                       when this was created.

                         ACACTIVITY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACVSET1   ACTIVITY                                               AC01.1  AC02.1
                                                                 AC03.2  AC03.3
                                                                 AC03.4  AC03.5
                                                                 AC03.6  AC03.7
                                                                 AC06.1  AC06.2
                                                                 AC07.1  AC08.3
                                                                 AC10.1  AC10.2
                                                                 AC10.3  AC10.5
                                                                 AC10.6  AC105
                                                                 AC108   AC11.1
                                                                 AC110   AC112
                                                                 AC113   AC12.1
                                                                 AC120   AC121
                                                                 AC123   AC127
                                                                 AC128   AC13.1
                                                                 ...

ACVSET2   ACTIVITY-GRP  KeyChange                                AC00.1  AC01.1
          ACTIVITY                                               AC10.1  AC10.5
                                                                 AC105   AC110
                                                                 AC112   AC113
                                                                 AC12.1  AC120
                                                                 AC121   AC123
                                                                 AC128   AC13.3
                                                                 AC130   AC135
                                                                 AC145   AC160
                                                                 AC165   AC169
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC20.5  AC20.8
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 ...

ACVSET3   COMPANY       KeyChange                                AC12.1
          ACTIVITY

ACVSET4   ACTIVITY-GRP  KeyChange                                AC01.1  AC10.1
          LEVEL-DEPTH                                            AC560   PW90.1
          VAR-LEVELS*                                            PWI2.1
          ACTIVITY

ACVSET6   OBJ-ID                                                 AC01.1  AC105
                                                                 AC112   AC113
                                                                 AC120   AC121
                                                                 AC123   AC128
                                                                 AC13.2  AC13.3
                                                                 AC13.4  AC130
                                                                 AC135   AC145
                                                                 AC160   AC165
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 ...

ACVSET7   PARENT-ACTV   KeyChange
          ACTIVITY

ACVSET8   ACTIVITY-GRP  KeyChange, Subset                        AC01.1  AC10.1
          VAR-LEVELS    Where (VAR-LEVELS != Spaces )            AC10.5  AC11.1
                                                                 AC110   AC112
                                                                 AC113   AC12.1
                                                                 AC120   AC121
                                                                 AC123   AC128
                                                                 AC135   AC145
                                                                 AC160   AC165
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 AC198   AC200
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC225
                                                                 ...

                         ACACTIVITY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            ACV-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Acactgrp       ACACTGRP     Required

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

Acactseg       ACACTSEG     Not Required

                            ACV-OBJ-ID            -> CSG-OBJ-ID

Acaddlcntr     ACADDLCNTR   Not Required

                            ACV-ACTIVITY-GRP      -> ADN-ACTIVITY-GRP
                            CNT-CONTRACT          -> ADN-CONTRACT

Acbill         ACBILL       Not Required

                            ACV-ACTIVITY          -> ACI-ACTIVITY

Acbudhdr Set1  ACBUDHDR     Not Required
                            Valid When ACV-ACTIVE-BUD != Zeroes

                            ACV-ACTIVITY-GRP      -> BDH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> BDH-ACTIVITY
                            ACV-ACTIVE-BUD        -> BDH-BUDGET-NBR

Accntract      ACCNTRACT    Not Required

                            ACV-CONTRACT          -> CNT-CONTRACT

Accustomer     ACCUSTOMER   Not Required

                            CNT-COMPANY           -> CMR-COMPANY
                            CNT-CUSTOMER          -> CMR-CUSTOMER
                            CNT-AC-CUSTOMER-ID    -> CMR-AC-CUSTOMER-ID

Acstatus       ACSTATUS     Required

                            ACV-USR-STATUS        -> STS-USR-STATUS

Cucodes        CUCODES      Required

                            ACV-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Glnames        GLNAMES      Not Required

                            ACV-COMPANY           -> GLN-COMPANY
                            ACV-ACCT-UNIT         -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Required

                            ACV-COMPANY           -> GLS-COMPANY

Gmaward        GMAWARD      Not Required

                            ACV-ACTIVITY          -> GMG-ACTIVITY

Gmsalcap       GMSALCAP     Not Required

                            ACV-SCHEDULE          -> GMC-SCHEDULE
                            ACV-CURRENCY-CODE     -> GMC-CURRENCY-CODE

Object Id      OBJID        Not Required

                            "ACTVY"               -> OBI-OBJ-TYPE

Parent         ACACTIVITY   Not Required

                            ACV-PARENT-ACTV       -> ACV-ACTIVITY

Structure      STRUCTURE    Required

                            ACV-STRUCTURE         -> SRE-STRUCTURE

                         ACACTIVITY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcatx     ACACCTCATX

                            ACV-ACTIVITY-GRP      -> AXX-ACTIVITY-GRP
                            ACV-ACTIVITY          -> AXX-ACTIVITY
                                                     AXX-ACCT-CATEGORY

Acacctcatxset2 ACACCTCATX

                            ACV-ACTIVITY-GRP      -> AXX-ACTIVITY-GRP
                                                     AXX-ACCT-CATEGORY
                                                     AXX-ACTIVITY

Acacresrtx     ACACRESRTX

                            ACV-ACTIVITY-GRP      -> CRX-ACTIVITY-GRP
                            ACV-ACTIVITY          -> CRX-ACTIVITY
                                                     CRX-RESOURCE-TYPE
                                                     CRX-RESOURCE-CODE
                                                     CRX-COMPANY
                                                     CRX-EFFECTIVE-DATE

Acacresrtx Grp ACACRESRTX

                            ACV-ACTIVITY-GRP      -> CRX-ACTIVITY-GRP
                            Spaces                -> CRX-ACTIVITY
                                                     CRX-RESOURCE-TYPE
                                                     CRX-RESOURCE-CODE
                                                     CRX-COMPANY
                                                     CRX-EFFECTIVE-DATE

Acactmxval     ACACTMXVAL

                            ACV-OBJ-ID            -> AJV-OBJ-ID
                                                     AJV-MATRIX-CAT

Acactmxvdt     ACACTMXVDT

                            ACV-OBJ-ID            -> MXD-OBJ-ID
                                                     MXD-MATRIX-CAT
                                                     MXD-EFFECTIVE-DATE

Acaddassgn     ACADDASSGN

                            ACV-ACTIVITY          -> AAS-ACTIVITY
                                                     AAS-ADDRESS-CODE

Acamcode       ACAMCODE

                            ACV-ACTIVITY          -> MCD-ACTIVITY
                                                     MCD-ACCT-CATEGORY

Acamcode 1     ACAMCODE

                            ACV-ACTIVITY          -> MCD-ACTIVITY
                                                     MCD-ACCT-CATEGORY

Acasnrole      ACASNROLE

                            ACV-ACTIVITY-GRP      -> ALE-ACTIVITY-GRP
                            ACV-ACTIVITY          -> ALE-ACTIVITY
                                                     ALE-RESOURCE-TYPE
                                                     ALE-COMPANY
                                                     ALE-RESOURCE-CODE
                                                     ALE-ROLE

Acassign       ACASSIGN

                            ACV-ACTIVITY-GRP      -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY          -> AAN-ACTIVITY
                                                     AAN-COMPANY
                                                     AAN-RESOURCE-TYPE
                                                     AAN-RESOURCE-CODE

Acaudit        ACAUDIT

                            ACV-ACTIVITY          -> AUD-ACTIVITY
                                                     AUD-PROCESS-DATE
                                                     AUD-PROCESS-TIME
                                                     AUD-COPY-FR-AG
                                                     AUD-COPY-TO-AG
                                                     AUD-REORG-OR-COPY

Acbillx        ACBILLX

                            ACV-ACTIVITY          -> AIX-ACTIVITY
                                                     AIX-SUM-ACCT-CAT
                                                     AIX-CTR-CAT-GRP
                                                     AIX-ACCT-CATEGORY

Acblactv       ACBLACTV

                            ACV-ACTIVITY          -> BLA-ACTIVITY
                                                     BLA-ACCT-CATEGORY
                                                     BLA-CTR-CAT-GRP
                                                     BLA-SUM-ACCT-CAT
                                                     BLA-BILL-ACTIVITY

Acblratex      ACBLRATEX

                            ACV-ACTIVITY          -> ALX-ACTIVITY
                                                     ALX-SUM-ACCT-CAT
                                                     ALX-CTR-CAT-GRP
                                                     ALX-ACCT-CATEGORY
                                                     ALX-SOURCE-CODE
                                                     ALX-MATRIX-CAT
                                                     ALX-EFFECTIVE-DT
                                                     ALX-MX-VALUE

Acbrdnblrx     ACBRDNBLRX

                            ACV-ACTIVITY          -> BRX-ACTIVITY
                                                     BRX-BURDEN-CD
                                                     BRX-BURDEN-TYPE
                                                     BRX-POOL-NBR
                                                     BRX-EFFECTIVE-DATE

Acbrdndtl      ACBRDNDTL

                            ACV-ACTIVITY-GRP      -> BRD-ACTIVITY-GRP
                            ACV-ACTIVITY          -> BRD-ACTIVITY
                                                     BRD-ACCT-CATEGORY
                                                     BRD-BURDEN-CD
                                                     BRD-POOL-NBR

Acbudhdr       ACBUDHDR

                            ACV-ACTIVITY-GRP      -> BDH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> BDH-ACTIVITY
                                                     BDH-BUDGET-NBR

Accatsum       ACCATSUM

                            ACV-STRUCTURE         -> SRS-STRUCTURE
                                                     SRS-SUM-ACCT-CAT

Accatsumx      ACCATSUMX

                            ACV-STRUCTURE         -> SRX-STRUCTURE
                                                     SRX-ACCT-CATEGORY

Acceilingx     ACCEILINGX

                            ACV-ACTIVITY          -> CEX-ACTIVITY
                                                     CEX-ACCT-CATEGORY
                                                     CEX-SUM-ACCT-CAT
                                                     CEX-CTR-CAT-GRP
                                                     CEX-MATRIX-CAT
                                                     CEX-MX-VALUE

Acchgord All   ACCHGORDER

                            ACV-ACTIVITY-GRP      -> CHO-ACTIVITY-GRP
                            ACV-ACTIVITY          -> CHO-ACTIVITY
                                                     CHO-BUDGET-NBR
                                                     CHO-CHG-ORDER-NBR

Acchgorder     ACCHGORDER

                            ACV-ACTIVITY-GRP      -> CHO-ACTIVITY-GRP
                            ACV-ACTIVITY          -> CHO-ACTIVITY
                            ACV-ACTIVE-BUD        -> CHO-BUDGET-NBR
                                                     CHO-CHG-ORDER-NBR

Accntractx     ACCNTRACTX

                            ACV-ACTIVITY          -> CNX-ACTIVITY
                                                     CNX-CONTRACT

Accommit       ACCOMMIT

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

Acconsol       ACCONSOL

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

Accuamt Allbud ACCUAMT

                            ACV-ACTIVITY-GRP      -> ACU-ACTIVITY-GRP
                            ACV-ACTIVITY          -> ACU-ACTIVITY
                                                     ACU-CURRENCY-CODE
                                                     ACU-BUDGET-NBR
                                                     ACU-ACCT-CATEGORY
                                                     ACU-FISCAL-YEAR

Acglacct       ACGLACCT

                            ACV-ACTIVITY-GRP      -> AGA-ACTIVITY-GRP
                            ACV-ACTIVITY          -> AGA-ACTIVITY
                                                     AGA-ACCT-CATEGORY
                                                     AGA-SEQ-NUMBER

Acglacct All   ACGLACCT

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

Acglconsl      ACGLCONSL

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

Acglmast       ACGLMAST

                            ACV-ACTIVITY-GRP      -> GMT-ACTIVITY-GRP
                            ACV-ACTIVITY          -> GMT-ACTIVITY
                                                     GMT-ACCT-CATEGORY
                                                     GMT-COMPANY
                                                     GMT-ACCT-UNIT
                                                     GMT-FISCAL-YEAR
                                                     GMT-RESOURCE-TYPE
                                                     GMT-RESOURCE-COMP
                                                     GMT-RESOURCE-CODE

Acgltotrev     ACGLTOTREV

                            ACV-ACTIVITY          -> GRV-ACTIVITY
                                                     GRV-ACCT-CATEGORY
                                                     GRV-COMPANY
                                                     GRV-ACCT-UNIT

Achistory      ACHISTORY

                            ACV-ACTIVITY          -> HST-ACTIVITY
                                                     HST-FIELD-ID
                                                     HST-DATE-STAMP
                                                     HST-SEQ-NBR

Acmaster       ACMASTER

                            ACV-ACTIVITY-GRP      -> MST-ACTIVITY-GRP
                            ACV-ACTIVITY          -> MST-ACTIVITY
                                                     MST-ACCT-CATEGORY
                                                     MST-FISCAL-YEAR

Acmilestn      ACMILESTN

                            ACV-ACTIVITY          -> MLS-ACTIVITY
                                                     MLS-MILESTONE-CAT

Acmilestnx     ACMILESTNX

                            ACV-ACTIVITY          -> MLX-ACTIVITY
                                                     MLX-MILESTONE-CAT
                                                     MLX-MILESTONE

Acperccmpl     ACPERCCMPL

                            ACV-ACTIVITY          -> PEC-ACTIVITY
                                                     PEC-RECORD-TYPE
                                                     PEC-BUDGET-TYPE
                                                     PEC-DATE

Acpercmplx     ACPERCMPLX

                            ACV-ACTIVITY          -> PEX-ACTIVITY
                                                     PEX-RECORD-TYPE
                                                     PEX-BUDGET-TYPE
                                                     PEX-ACCT-CATEGORY
                                                     PEX-DATE

Acprdperf      ACPRDPERF

                            ACV-ACTIVITY-GRP      -> PFM-ACTIVITY-GRP
                            ACV-ACTIVITY          -> PFM-ACTIVITY
                                                     PFM-SYSTEM
                                                     PFM-SEQ-NUMBER

Acreshist      ACRESHIST

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

Acretain       ACRETAIN

                            ACV-ACTIVITY          -> RET-ACTIVITY
                                                     RET-RETAIN-ID

Acretng        ACRETNG

                            ACV-ACTIVITY          -> RTG-ACTIVITY
                                                     RTG-SUM-ACCT-CAT
                                                     RTG-CTR-CAT-GRP
                                                     RTG-ACCT-CATEGORY

Actotbal Base  ACTOTBAL

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

Actotbal Cur1  ACTOTBAL

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

Actotbal Cur2  ACTOTBAL

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

Actrans Commit ACTRANS

                            ACV-ACTIVITY-GRP      -> ATN-ACTIVITY-GRP
                            ACV-ACTIVITY          -> ATN-ACTIVITY
                                                     ATN-ACCT-CATEGORY
                                                     ATN-POSTING-DATE
                                                     ATN-OBJ-ID

Actrans Error  ACTRANS

                            ACV-ACTIVITY-GRP      -> ATN-ACTIVITY-GRP
                            ACV-ACTIVITY          -> ATN-ACTIVITY
                                                     ATN-ACCT-CATEGORY
                                                     ATN-POSTING-DATE
                                                     ATN-OBJ-ID

Actrans Hist   ACTRANS

                            ACV-ACTIVITY          -> ATN-ACTIVITY
                                                     ATN-ACCT-CATEGORY
                                                     ATN-FISCAL-YEAR
                                                     ATN-PERIOD
                                                     ATN-OBJ-ID

Actrans Posted ACTRANS

                            ACV-ACTIVITY          -> ATN-ACTIVITY
                                                     ATN-ACCT-CATEGORY
                                                     ATN-FISCAL-YEAR
                                                     ATN-PERIOD
                                                     ATN-OBJ-ID

Actrans Releas ACTRANS

                            ACV-ACTIVITY-GRP      -> ATN-ACTIVITY-GRP
                            ACV-ACTIVITY          -> ATN-ACTIVITY
                                                     ATN-ACCT-CATEGORY
                                                     ATN-POSTING-DATE
                                                     ATN-OBJ-ID

Acu Act Curr   ACCUAMT

                            ACV-ACTIVITY-GRP      -> ACU-ACTIVITY-GRP
                            ACV-ACTIVITY          -> ACU-ACTIVITY
                            ACV-CURRENCY-CODE     -> ACU-CURRENCY-CODE
                            Zeroes                -> ACU-BUDGET-NBR
                                                     ACU-FISCAL-YEAR
                                                     ACU-ACCT-CATEGORY

Acu Rpt Curr 1 ACCUAMT

                            ACV-ACTIVITY-GRP      -> ACU-ACTIVITY-GRP
                            ACV-ACTIVITY          -> ACU-ACTIVITY
                            AGP-CURR-CODE-1       -> ACU-CURRENCY-CODE
                            Zeroes                -> ACU-BUDGET-NBR
                                                     ACU-FISCAL-YEAR
                                                     ACU-ACCT-CATEGORY

Acu Rpt Curr 2 ACCUAMT

                            ACV-ACTIVITY-GRP      -> ACU-ACTIVITY-GRP
                            ACV-ACTIVITY          -> ACU-ACTIVITY
                            AGP-CURR-CODE-2       -> ACU-CURRENCY-CODE
                            Zeroes                -> ACU-BUDGET-NBR
                                                     ACU-FISCAL-YEAR
                                                     ACU-ACCT-CATEGORY

Acvhistbegdt   ACHISTORY

                            ACV-ACTIVITY          -> HST-ACTIVITY
                            14                    -> HST-FIELD-ID
                                                     HST-DATE-STAMP
                                                     HST-SEQ-NBR

Acvhistenddt   ACHISTORY

                            ACV-ACTIVITY          -> HST-ACTIVITY
                            15                    -> HST-FIELD-ID
                                                     HST-DATE-STAMP
                                                     HST-SEQ-NBR

Aracpivot      ARACPIVOT

                            ACV-ACTIVITY          -> CCP-ACTIVITY
                                                     CCP-DUE-DATE
                                                     CCP-TRANS-TYPE
                                                     CCP-BATCH-NBR
                                                     CCP-TRANSACTION
                                                     CCP-PAYMENT-SEQ
                                                     CCP-COMPANY

Atnset4        ACTRANS

                            ACV-ACTIVITY          -> ATN-ACTIVITY
                                                     ATN-ACCT-CATEGORY
                                                     ATN-FISCAL-YEAR
                                                     ATN-PERIOD
                                                     ATN-OBJ-ID

Billable       ACTRANS

                            ACV-ACTIVITY          -> ATN-ACTIVITY
                                                     ATN-ACCT-CATEGORY
                                                     ATN-TRAN-CURRENCY
                                                     ATN-UNIT-MEASURE
                                                     ATN-MATRIX-CAT
                                                     ATN-MX-VALUE
                                                     ATN-POSTING-DATE
                                                     ATN-OBJ-ID

Children       ACACTIVITY

                            ACV-ACTIVITY          -> ACV-PARENT-ACTV
                                                     ACV-ACTIVITY

Csl Bud Base   ACCONSOL

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

Csl Bud Rpt 1  ACCONSOL

                            ACV-ACTIVITY-GRP      -> CSL-ACTIVITY-GRP
                            ACV-ACTIVITY          -> CSL-ACTIVITY
                            AGP-CURR-CODE-1       -> CSL-CURRENCY-CODE
                                                     CSL-BUDGET-NBR
                                                     CSL-ACCT-CATEGORY
                                                     CSL-FISCAL-YEAR

Csl Bud Rpt 2  ACCONSOL

                            ACV-ACTIVITY-GRP      -> CSL-ACTIVITY-GRP
                            ACV-ACTIVITY          -> CSL-ACTIVITY
                            AGP-CURR-CODE-2       -> CSL-CURRENCY-CODE
                                                     CSL-BUDGET-NBR
                                                     CSL-ACCT-CATEGORY
                                                     CSL-FISCAL-YEAR

Csl Cur1       ACCONSOL

                            ACV-ACTIVITY-GRP      -> CSL-ACTIVITY-GRP
                            ACV-ACTIVITY          -> CSL-ACTIVITY
                            AGP-CURR-CODE-1       -> CSL-CURRENCY-CODE
                            Zeroes                -> CSL-BUDGET-NBR
                                                     CSL-ACCT-CATEGORY
                                                     CSL-FISCAL-YEAR

Csl Cur2       ACCONSOL

                            ACV-ACTIVITY-GRP      -> CSL-ACTIVITY-GRP
                            ACV-ACTIVITY          -> CSL-ACTIVITY
                            AGP-CURR-CODE-2       -> CSL-CURRENCY-CODE
                            Zeroes                -> CSL-BUDGET-NBR
                                                     CSL-ACCT-CATEGORY
                                                     CSL-FISCAL-YEAR

Gmcostshr      GMCOSTSHR

                            ACV-ACTIVITY          -> GMO-ACTIVITY
                                                     GMO-CS-ACTIVITY

Gmcostshr Post GMCOSTSHR

                            ACV-ACTIVITY          -> GMO-CS-ACTIVITY
                                                     GMO-ACTIVITY

Gmdeliv        GMDELIV

                            ACV-ACTIVITY          -> GLV-ACTIVITY
                                                     GLV-DELIV-CODE-DE

Gmlabdistx     GMLABDISTX

                            ACV-ACTIVITY          -> GMA-ACTIVITY
                                                     GMA-ACCT-CATEGORY
                                                     GMA-COMPANY
                                                     GMA-ACCT-UNIT
                                                     GMA-ACCOUNT
                                                     GMA-EFFECT-DATE
                                                     GMA-GML-OBJ-ID
                                                     GMA-OBJ-ID

Gmpginc Post   GMPGMINC

                            ACV-ACTIVITY          -> GMQ-PI-ACTIVITY
                                                     GMQ-ACTIVITY

Gmpgminc       GMPGMINC

                            ACV-ACTIVITY          -> GMQ-ACTIVITY
                                                     GMQ-PI-ACTIVITY

Gmprotocol     GMPROTOCOL

                            ACV-ACTIVITY          -> GMM-ACTIVITY
                                                     GMM-PROT-CODE-PC
                                                     GMM-PROTOCOL-NBR
                                                     GMM-EXPIRE-DATE

Gmretdistx     GMRETDISTX

                            ACV-ACTIVITY          -> GMH-ACTIVITY
                                                     GMH-ACCT-CATEGORY
                                                     GMH-COMPANY
                                                     GMH-ACCT-UNIT
                                                     GMH-ACCOUNT
                                                     GMH-SUB-ACCOUNT
                                                     GMH-GMI-OBJ-ID
                                                     GMH-OBJ-ID

Gmtranefrt     GMTRANEFRT

                            ACV-ACTIVITY          -> GEF-ACTIVITY
                                                     GEF-ACCT-CATEGORY
                                                     GEF-OBJ-ID

Histastasgn    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "A"                   -> RSH-RESOURCE-TYPE
                            440                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histastrole    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "A"                   -> RSH-RESOURCE-TYPE
                            441                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histempasgn    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "E"                   -> RSH-RESOURCE-TYPE
                            420                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histemprole    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "E"                   -> RSH-RESOURCE-TYPE
                            421                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histeqpasgn    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "Q"                   -> RSH-RESOURCE-TYPE
                            450                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histeqprole    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "Q"                   -> RSH-RESOURCE-TYPE
                            451                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histperasgn    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "P"                   -> RSH-RESOURCE-TYPE
                            410                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histperrole    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "P"                   -> RSH-RESOURCE-TYPE
                            411                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histvenasgn    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "V"                   -> RSH-RESOURCE-TYPE
                            430                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Histvenrole    ACRESHIST

                            ACV-ACTIVITY-GRP      -> RSH-ACTIVITY-GRP
                            ACV-ACTIVITY          -> RSH-ACTIVITY
                            "V"                   -> RSH-RESOURCE-TYPE
                            431                   -> RSH-FIELD-ID
                                                     RSH-COMPANY
                                                     RSH-RESOURCE-CODE
                                                     RSH-SEQ-NUMBER

Member In List MXLISTMBR

                            "ACTVY"               -> MLM-OBJ-TYPE
                            ACV-OBJ-ID            -> MLM-OBJ-ID
                                                     MLM-MATRIX-LIST

Mxlisthdr      MXLISTHDR

                            "ACTVY"               -> MLH-OBJ-TYPE
                                                     MLH-MATRIX-LIST

Pr Accommit    ACCOMMIT

                            ACV-ACTIVITY-GRP      -> MIT-ACTIVITY-GRP
                            ACV-ACTIVITY          -> MIT-ACTIVITY
                            "PR"                  -> MIT-SYSTEM
                                                     MIT-COMPANY
                                                     MIT-CURRENCY-CODE
                                                     MIT-ACCT-CATEGORY
                                                     MIT-FISCAL-YEAR
                                                     MIT-PERIOD

Tot Child Base ACTOTBAL

                            ACV-ACTIVITY-GRP      -> TOT-ACTIVITY-GRP
                            ACV-ACTIVITY          -> TOT-PARENT-ACTV
                            AGP-CURRENCY-CODE     -> TOT-CURRENCY-CODE
                                                     TOT-BUDGET-NBR
                                                     TOT-CATEGORY-TYPE
                                                     TOT-FISCAL-YEAR
                                                     TOT-ACTIVITY

Tot Child Cur1 ACTOTBAL

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

Tot Child Cur2 ACTOTBAL

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

Tot Parnt Base ACTOTBAL

                            ACV-ACTIVITY-GRP      -> TOT-ACTIVITY-GRP
                            ACV-PARENT-ACTV       -> TOT-ACTIVITY
                            AGP-CURRENCY-CODE     -> TOT-CURRENCY-CODE
                                                     TOT-BUDGET-NBR
                                                     TOT-CATEGORY-TYPE
                                                     TOT-FISCAL-YEAR

Tot Parnt Cur1 ACTOTBAL

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

Tot Parnt Cur2 ACTOTBAL

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