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. 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     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    AC37.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    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    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     AR129
AR130     AR131     AR135     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
AR30.6    AR30.8    AR31.6    AR35.1    AR36.1    AR42.1
AR42.2    AR42.7    AR43.1    AR48.3    AR560     AR570
AR575     AR580     BN150     BN66.1    BR00.1    BR00.2
BR00.3    BR01.1    BR01.2    BR01.3    BR02.1    BR02.2
BR02.3    BR03.1    BR03.2    BR03.3    BR04.1    BR05.1
BR05.2    BR05.3    BR05.4    BR05.5    BR06.1    BR120
BR121     BR122     BR123     BR124     BR130     BR131
BR14.1    BR142     BR151     BR152     BR153     BR154
BR155     BR156     BR157     BR165     BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR20.6    BR20.7    BR200
BR202     BR204     BR205     BR21.1    BR210     BR212
BR215     BR220     BR251     BR252     BR253     BR254
BR265     BR40.1    BR40.3    BR40.4    BR400     BR405
BR41.1    BR41.4    BR42.1    BR420     BR43.1    BR430
BR44.1    BR44.2    BR44.3    BR450     BR51.1    BR51.2
BR52.1    BR52.2    BR52.4    BR52.5    BR521     BR53.1
BR53.2    BR530     BR54.1    BR54.2    BR54.3    BR54.4
BR55.1    BR56.1    BR65.1    BR65.2    BR900     BR901
BRCC.1    BRIP.1    BRPI.1    CB10.1    CB180     CB191
CB20.1    CB30.1    CB500     CB80.1    CXCP.1    EE135
EE20.3    EE35.1    EE35.2    EE520     GL146     GL165
GL170     GL197     GL199     GL40.1    GL40.2    GL40.3
GL40.7    GL40.8    GL44.1    GL45.1    GL50.4    GL75.1
GL90.3    HCAC.1    HACV.1    DR100     IC140     IC28.1
IC531     IC83.1    IFGT.1    MX123     MX500     MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA65.1    MA66.2    MA66.3    MA67.1    MA67.2    MA70.1
MA75.1    MA80.1    MAI1.1    PO100     PO101     PO122
PO131     PO135     PO150     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    PO25.1
PO25.5    PO25.6    PO25.7    PO27.2    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POCP.1    POD0.1    POI3.1    POID.1    POIF.1
POIG.1    POII.1    POIJ.1    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
UK560     RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1
RQ13.1    RQ140     RQ300     RQ35.1    RQ40.1    RQ41.1
RQ42.1    RQ44.1    RQ44.2    RQ500     RQD0.1    RQIE.1
RQIF.1    TA147     UK120     WH130     WH132     WH190
WH20.2    WH20.7    WH222     WH25.1    WH25.2    WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830     WO132     WO140     AC200
AC02.1    MX202     MX223

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACV-ACTIVITY           Alpha 15                                  AC10.1  AC110
Element: 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
Element: Activity DescrThis is the activity description.         AC190   AC198
                                                                 AC500

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

ACV-CONTRACT           Alpha 10                                  BR10.1  BR15.1
Element: Bid Name

ACV-COMPANY            Numeric 4                                 AC10.1  AC110
Element: Company       This field defines the responsible        AC113   AC500
                       company number for the activity. The      AC540
                       responsible company is defined in the
                       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
                       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
                       (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
                       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
                       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
Element: Currency Code This is the company currency code.        AC198   AC500

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
                       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
Element: Variable LevelLevels 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
Element: 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
Element: 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
Element: 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
Element: Long DescriptiOccurs 4 Times                            AC500
                       This is the long description of the
                       activity.

ACV-ESTIMATE           Signed 15.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      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
Element: 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
Element: Highest PostinThis is the latest posting date for       AC300   AC500
                       transactions posted to the activity.      ACDR.1

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

ACV-BALANCE-UNIT       Signed 17.2                               AC110   AC190
Element: Units Balance This is the unit balance for the          AC300   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          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
Element: Security Cd   This field contains the security code     AC110   AC120
                       for the activity.                         AC500

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

ACV-OUTPUT-MEASURE     Signed 15.2                               AC10.1  AC500
Element: Adj 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                                            AC500

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  BR02.3
Element: Bill Wbs Code

ACV-LOCATION-NAME      Alpha 15                                  AC10.1
Element: Destination

ACV-DIVISION           Alpha 15                                  AC10.1
Element: 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
                                                                 AC113   AC12.1
                                                                 AC120   AC121
                                                                 AC123   AC127
                                                                 AC13.1  AC13.2
                                                                 AC13.3  AC13.4
                                                                 AC13.7  AC13.8
                                                                 AC130   AC131
                                                                 ...

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

ACVSET3   COMPANY       KeyChange                                AC12.1
          ACTIVITY

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

ACVSET6   OBJ-ID                                                 AC01.1  AC105
                                                                 AC112   AC113
                                                                 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
                                                                 ...

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