Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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. The
Lawson Activity Management system 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 the Activity Management system 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    AC03.2    AC03.3    AC03.4    AC03.5    AC03.6
AC06.1    AC07.1    AC105     AC11.1    AC121     AC123
AC13.1    AC13.2    AC13.3    AC13.4    AC13.7    AC13.8
AC130     AC131     AC135     AC160     AC165     AC170
AC176     AC18.1    AC18.2    AC18.3    AC18.4    AC18.5
AC191     AC192     AC196     AC198     AC203     AC206
AC207     AC21.1    AC21.2    AC21.3    AC21.4    AC210
AC213     AC218     AC22.1    AC220     AC225     AC227
AC240     AC25.1    AC256     AC258     AC261     AC265
AC27.1    AC29.1    AC290     AC295     AC297     AC298
AC30.1    AC30.2    AC30.3    AC30.4    AC32.1    AC34.1
AC35.1    AC36.1    AC40.1    AC40.4    AC400     AC401
AC41.1    AC41.4    AC410     AC412     AC42.1    AC42.3
AC420     AC421     AC440     AC460     AC471     AC472
AC473     AC480     AC490     AC493     AC494     AC50.1
AC51.1    AC510     AC52.1    AC520     AC530     AC54.1
AC54.2    AC54.3    AC540     AC541     AC542     AC55.1
AC550     AC551     AC58.1    AC581     AC60.1    AC60.2
AC61.1    AC65.1    AC65.2    AC66.1    AC70.1    AC70.4
AC70.6    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    AC97.1    AC97.2    AC97.4    AC97.6
AC98.1    AC98.2    ACAC.1    ACBA.1    ACCL.1    ACDL.1
ACDM.2    ACDM.9    ACSR.1    ACVW.1    DA233     DA240
GR240     SE10.1    SE90.1    AM18.2    AP125     AP126
AP131     AP170     AP193     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.2    AP30.4    AP32.2    AP520
AP95.3    API1.1    API2.1    AR115     AR124     AR190
AR20.1    AR21.1    AR21.2    AR21.3    AR24.1    AR250
AR251     AR29.2    AR293     AR30.1    AR30.2    AR30.3
AR30.4    AR30.5    AR42.1    AR42.2    AR42.7    AR43.1
AR560     AR570     AR575     AR580     DA91.1    BN150
BN66.1    BR00.1    BR00.2    BR00.3    BR01.1    BR01.2
BR01.3    BR02.1    BR02.2    BR02.3    BR03.1    BR03.2
BR03.3    BR04.1    BR05.1    BR05.2    BR05.3    BR05.4
BR05.5    BR06.1    BR120     BR121     BR130     BR131
BR14.1    BR142     BR165     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR20.6    BR20.7    BR200     BR202
BR204     BR205     BR21.1    BR210     BR220     BR265
BR40.1    BR40.3    BR40.4    BR400     BR405     BR41.1
BR42.1    BR420     BR430     BR44.1    BR44.2    BR44.3
BR450     BR65.1    BR65.2    BRCC.1    BRIP.1    CB10.1
CB180     CB191     CB20.1    CB30.1    CB500     CB80.1
EE135     EE35.1    EE35.2    EE520     GL199     GL50.4
GL90.3    HCAC.1    HACV.1    IC28.1    IFGT.1    MX123
MX500     MA180     MA41.2    MA43.2    MA43.9    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA66.3
MA67.1    MA67.2    MA70.1    MAI1.1    PO100     PO101
PO122     PO131     PO20.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    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     POI3.1    POIE.1    POIF.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    PR36.1    PR37.1    PR38.1
PR45.1    PR529     PR530     PR560     PR80.1    PR82.1
PR85.1    PR89.1    PRSA.1    UK102     UK330     RQ10.1
RQ10.2    TA147     UK120     WH20.2    WH20.7    AC200
DA90.1    AC02.1    MX202     MX223

UPDATED BY

AC00.1    AC10.1    AC110     AC112     AC12.1    AC120
AC127     AC190     AC20.7    AC300     AC310     AC45.1
AC500     ACDR.1    BR10.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ACV-ACTIVITY         Alpha 15                                    AC10.1  AC110
Activity             Activities are the processes or             AC121   AC123
                     procedures that produce work. Cost          AC127   AC190
                     objects (products, services, customers,     AC198   AC20.1
                     and so on) are the reasons for              AC20.2  AC20.3
                     performing the activity. Activities and     AC20.4  AC20.5
                     cost object activities are used             AC20.7  AC22.1
                     synonymously in the Lawson Activity         AC45.1  AC500
                     Management system. Direct costs are         AC540   AC90.2
                     posted to activities, and indirect costs    AC90.4  AC90.6
                     are allocated to activities based on        AC90.8  AC95.2
                     activity drivers.                           ACDR.1

                     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
Activity Description This is the activity description.           AC190   AC198
                                                                 AC500

ACV-ACTIVITY-GRP     Alpha 15                                    AC10.1  AC110
Activity Group       This is the activity group for the          AC120   AC500
                     activity.                                   AC90.2  AC90.4
                                                                 AC90.6  AC90.8
                                                                 AC95.2

ACV-CONTRACT         Alpha 10                                    BR10.1
Contract

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

ACV-ACCT-UNIT        Alpha 15                                    AC10.1  AC110
Accounting Unit      This is an accounting unit for the          AC500
                     activity. The accounting unit is a
                     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
Account              This field along with the accounting        AC500
                     unit and subaccount make up the location
                     (account) where amounts and other
                     account information is stored.

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

ACV-ACCT-CATEGORY    Alpha 5                                     AC10.1  AC110
Account Category     This is an account category for the         AC500
                     activity. Account categories are
                     groupings of costs, revenues, or a
                     combination of both used for reporting
                     and inquiries for activities in the
                     Lawson Activity Management system. All
                     transactions are posted to an account
                     category within an activity. 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
Currency Code        This is the company currency code.          AC198   AC500

ACV-USR-STATUS       Alpha 2                                     AC10.1  AC110
Status               This is a user-defined code indicating      AC112   AC12.1
                     the status of the activity. You can         AC500
                     define various parameters relating to
                     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
Variable Levels      Levels define an addressing system that     AC120   AC121
                     organizes activities into a reporting       AC123   AC127
                     hierarchy. Level names are defined for      AC190   AC20.1
                     an activity group and should be able to     AC20.2  AC20.3
                     be used across all activities in an         AC20.4  AC20.5
                     activity group. Levels facilitate rollup    AC20.7  AC22.1
                     or consolidation of budgets, costs, and     AC45.1  AC500
                     revenues from activities at lower levels    AC90.2  AC90.4
                     to macro activities at a higher level       AC90.6  AC90.8
                     within the hierarchy.                       AC95.2  ACDR.1

                     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   AC198
Display              numbering scheme that allows detail to      AC500
                     be aggregated or "rolled-up" in
                     summarized form. Five levels are
                     available in the Activity Management
                     system.

ACV-BEGIN-DATE       Numeric 8  (yyyymmdd)                       AC10.1  AC110
Begin Date           This is the beginning date for the          AC500
                     activity. The activity date range must
                     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
End Date             This is the ending date for the             AC500
                     activity. The activity date range must
                     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
Active Budget        This is the budget number for the           AC20.7  AC310
                     activity group active budget. The active
                     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
Long Description     Occurs 4 Times                              AC500
                     This is the long description of the
                     activity.

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

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

ACV-PARENT-ACTV      Alpha 15                                    AC10.1  AC110
Parent Actv                                                      AC120   AC190
                                                                 AC20.7  AC45.1
                                                                 AC500   ACDR.1

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

ACV-HIGH-PST-DATE    Numeric 8  (yyyymmdd)                       AC110   AC190
Highest Posting Date This is the latest posting date for         AC300   AC500
                     transactions posted to the activity.        ACDR.1

ACV-BALANCE-AMOUNT   Signed 17.2                                 AC110   AC190
Balance Amount       This is the amount balance for the          AC300   ACDR.1
                     life-to-date activity actuals amount.

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

ACV-SHORT-DESC       Derived
Short Description    This is the short description of the
                     activity.

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

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

ACV-POST-OR-GLONLY   Derived
Post Or Glonly

ACV-OUTPUT-MEASURE   Signed 15.2                                 AC10.1
Output Measure       This is the output measurement.

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

ACV-SEGMENT-FLAG     Alpha 1                                     AC10.1  AC110
Segment Flag                                                     AC500

ACV-GRP-CURR-CODE1   Derived
Grp Curr Code1

ACV-GRP-CURR-CODE2   Derived
Grp Curr Code2

ACV-ACT-SEG-BLOCK    Derived
Act Seg Block

ACV-BILL-WBS-CODE    Alpha 3                                     AC10.1  BR02.3
Bill Wbs Code

ACV-LOCATION-NAME    Alpha 15                                    AC10.1
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
Division             A user-defined division which is used
                     for reporting assets.

                         ACACTIVITY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACVSET1   ACTIVITY                                               AC01.1  AC03.2
                                                                 AC03.3  AC03.4
                                                                 AC03.5  AC03.6
                                                                 AC06.1  AC07.1
                                                                 AC10.1  AC10.2
                                                                 AC10.3  AC10.5
                                                                 AC105   AC11.1
                                                                 AC110   AC112
                                                                 AC12.1  AC120
                                                                 AC121   AC123
                                                                 AC127   AC13.1
                                                                 AC13.2  AC13.3
                                                                 AC13.4  AC13.7
                                                                 AC13.8  AC130
                                                                 AC131   AC135
                                                                 ...

ACVSET2   ACTIVITY-GRP  KeyChange                                AC00.1  AC01.1
          ACTIVITY                                               AC06.1  AC10.1
                                                                 AC10.5  AC105
                                                                 AC110   AC112
                                                                 AC12.1  AC120
                                                                 AC121   AC135
                                                                 AC160   AC165
                                                                 AC170   AC190
                                                                 AC191   AC192
                                                                 AC196   AC198
                                                                 AC20.5  AC20.8
                                                                 AC200   AC210
                                                                 AC213   AC218
                                                                 AC240   AC261
                                                                 AC265   AC290
                                                                 ...

ACVSET3   COMPANY       KeyChange                                AC12.1
          ACTIVITY

ACVSET5   USR-STATUS    KeyChange                                AC02.1  AC12.1
          ACTIVITY

ACVSET6   OBJ-ID                                                 AC01.1  AC105
                                                                 AC112   AC120
                                                                 AC121   AC123
                                                                 AC13.2  AC13.3
                                                                 AC13.4  AC130
                                                                 AC135   AC160
                                                                 AC165   AC190
                                                                 AC191   AC196
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC240
                                                                 ...

ACVSET7   PARENT-ACTV
          ACTIVITY

ACVSET8   ACTIVITY-GRP  KeyChange, Subset                        AC01.1  AC10.1
          VAR-LEVELS    Where (VAR-LEVELS != Spaces )            AC10.5  AC210
                                                                 AC310   AC50.1
                                                                 AC500   AC97.2
                                                                 ACBA.1

                         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

Aclevel        ACLEVEL      Required

                            ACV-ACTIVITY-GRP     -> LVL-ACTIVITY-GRP
                            ACV-VAR-LEVELS       -> LVL-VAR-LEVELS

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

Object Id      OBJID        Not Required

                            "ACTVY"              -> OBI-OBJ-TYPE

Parent         ACACTIVITY   Not Required

                            ACV-PARENT-ACTV      -> ACV-ACTIVITY

                         ACACTIVITY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

A Assign       ACASSIGN

                            ACV-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AAN-ACTIVITY
                            "A"                  -> AAN-RESOURCE-TYPE
                                                    AAN-RESOURCE-CODE

Acacctcatx     ACACCTCATX

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

Acacctcatx All ACACCTCATX

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

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

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

Acassign       ACASSIGN

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

Acassign Admin ACASSIGN

                            ACV-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AAN-ACTIVITY
                            "A"                  -> AAN-MGR-FLAG
                                                    AAN-RESOURCE-TYPE
                                                    AAN-RESOURCE-CODE

Acassign Mngr  ACASSIGN

                            ACV-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AAN-ACTIVITY
                            "Y"                  -> AAN-MGR-FLAG
                                                    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

Acblactv       ACBLACTV

                            ACV-ACTIVITY         -> BLA-ACTIVITY
                                                    BLA-ACCT-CATEGORY
                                                    BLA-ACCT-CAT-CLASS
                                                    BLA-BILL-ACTIVITY

Acblratex      ACBLRATEX

                            ACV-ACTIVITY         -> ALX-ACTIVITY
                                                    ALX-ACCT-CAT-CLASS
                                                    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

Acbudhdr       ACBUDHDR

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

Acceilingx     ACCEILINGX

                            ACV-ACTIVITY         -> CEX-ACTIVITY
                                                    CEX-ACCT-CATEGORY
                                                    CEX-ACCT-CAT-CLASS
                                                    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

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

Acempexpx      ACEMPEXPX

                            ACV-ACTIVITY-GRP     -> AEA-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AEA-ACTIVITY
                                                    AEA-ACCT-CATEGORY
                                                    AEA-EXPENSE-CODE

Acempexpx Grp  ACEMPEXPX

                            ACV-ACTIVITY-GRP     -> AEA-ACTIVITY-GRP
                            Spaces               -> AEA-ACTIVITY
                                                    AEA-ACCT-CATEGORY
                                                    AEA-EXPENSE-CODE

Acfeeclng      ACFEECLNG

                            ACV-ACTIVITY-GRP     -> FCL-ACTIVITY-GRP
                            ACV-ACTIVITY         -> FCL-ACTIVITY
                                                    FCL-ACCT-CATEGORY

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-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-CODE

Acgltotrev     ACGLTOTREV

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

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

Acretain       ACRETAIN

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

Acretng        ACRETNG

                            ACV-ACTIVITY         -> RTG-ACTIVITY
                                                    RTG-ACCT-CAT-CLASS
                                                    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

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

E Assign       ACASSIGN

                            ACV-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AAN-ACTIVITY
                            "E"                  -> AAN-RESOURCE-TYPE
                                                    AAN-COMPANY
                                                    AAN-EMPLOYEE-ASSET
                                                    AAN-RESOURCE-CODE

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

P Assign       ACASSIGN

                            ACV-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AAN-ACTIVITY
                            "P"                  -> AAN-RESOURCE-TYPE
                                                    AAN-RESOURCE-CODE

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

Q Assign       ACASSIGN

                            ACV-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AAN-ACTIVITY
                            "Q"                  -> AAN-RESOURCE-TYPE
                                                    AAN-RESOURCE-CODE

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

V Assign       ACASSIGN

                            ACV-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AAN-ACTIVITY
                            "V"                  -> AAN-RESOURCE-TYPE
                                                    AAN-COMPANY
                                                    AAN-EMPLOYEE-ASSET
                                                    AAN-RESOURCE-CODE