Lawson Insight Technical Documentation


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
AC127     AC13.1    AC13.2    AC13.3    AC13.4    AC130
AC14.1    AC15.1    AC15.2    AC15.4    AC16.1    AC16.2
AC16.3    AC16.4    AC16.5    AC160     AC165     AC176
AC191     AC196     AC203     AC206     AC207     AC21.1
AC21.2    AC21.3    AC210     AC214     AC215     AC216
AC22.1    AC220     AC225     AC240     AC25.1    AC256
AC265     AC27.1    AC29.1    AC290     AC295     AC297
AC30.1    AC30.2    AC30.3    AC30.4    AC32.1    AC40.1
AC400     AC401     AC41.1    AC410     AC412     AC415
AC416     AC42.1    AC420     AC421     AC440     AC45.1
AC45.2    AC450     AC460     AC470     AC471     AC472
AC473     AC480     AC490     AC50.1    AC51.1    AC510
AC52.1    AC520     AC530     AC54.1    AC540     AC55.1
AC65.1    AC65.2    AC70.1    AC70.3    AC70.4    AC700
AC79.1    AC87.1    AC90.1    AC90.2    AC94.1    AC94.2
AC94.3    AC94.4    AC94.5    AC94.6    AC95.1    AC95.2
AC952     AC96.1    AC97.1    AC97.2    ACAC.1    ACBA.1
ACDL.1    AM18.2    AP125     AP126     AP170     AP193
AP225     AP226     AP25.1    AP25.2    AP26.1    AP30.2
AP30.4    AP32.2    AP520     AP95.3    AP952     AP960
AP961     AP981     AR115     AR124     AR190     AR20.1
AR21.1    AR21.2    AR21.3    AR24.1    AR29.2    AR30.1
AR30.2    AR30.4    AR42.1    AR42.2    AR42.7    AR43.1
AR560     AR570     AR575     AR580     BL120     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    BL940     BN150     CB10.1
CB180     CB191     CB20.1    CB30.1    CB80.1    CB952
CB980     EE135     EE35.1    EE35.2    EE520     GL199
GL50.4    GL90.3    GL951     HCAC.1    HACV.1    DR100
IC130     IC141     IC142     IC83.1    IFGT.1    MX123
IN20.1    MA40.1    MA41.4    MA41.6    MA43.3    MA43.4
MA520     MA530     MA540     OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE113     OE114
OE129     OE14.4    OE15.1    OE15.2    OE15.3    OE15.4
OE15.5    OE15.7    OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE510     OE810
OE830     OE920     OE950     PO100     PO135     PO180
PO20.1    PO21.1    PO21.2    PO21.3    PO21.5    PO21.6
PO22.1    PO22.2    PO22.3    PO25.1    PO25.2    PO25.4
PO26.1    PO28.6    PO30.1    PO31.1    PO32.1    PO33.1
PO34.1    PO35.1    PO530     PO821     PO990     PR128
PR131     PR132     PR134     PR136     PR137     PR140
PR150     PR195     PR199     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    PR530     PR80.1    PR82.1    PR85.1    PRSA.1
UK102     UK330     RQ10.1    RQ10.2    RQ10.3    RQ11.1
RQ12.1    RQ13.1    RQ20.1    RQ20.3    RQ20.4    RQ35.1
RQ500     RQ990     UK120     WH130     WH132     WH190
WH20.2    WH20.7    WH30.1    WH30.2    WH30.3    WH31.1
WH31.2    WH31.3    WH32.1    WH32.2    WH32.3    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     AC02.1
ACVW.1

UPDATED BY

AC00.1    AC10.1    AC110     AC112     AC115     AC12.1
AC120     AC170     AC190     AC20.6    AC300     AC310
AC500     AC580     AC701     AC730     AC80.1    AC800
AC950     AC951     AC980

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ACV-ACTIVITY         Alpha 15                                    AC10.1  AC110
Activity             Activities are the processes or             AC500   AC540
                     procedures that produce work. Cost          AC730   AC80.1
                     objects (products, services, customers,     AC950   AC951
                     and so on) are the reasons for
                     performing the activity. Activities and
                     cost object activities are used
                     synonymously in the Lawson Activity
                     Management system. Direct costs are
                     posted to activities, and indirect costs
                     are allocated to activities based on
                     activity drivers.

                     Activities are grouped or organized by
                     activity levels. There are two types of
                     activities: posting allowed and summary
                     only. Use posting level activities to
                     budget and maintain all posted
                     transactions. Summary activities or
                     macro activities combine information and
                     balances from lower level activities for
                     reporting and inquiries.

ACV-DESCRIPTION      Alpha 30  (Lower Case)                      AC10.1  AC110
Activity Description This is the activity description.           AC500   AC730
                                                                 AC80.1  AC950
                                                                 AC951

ACV-ACTIVITY-GRP     Alpha 15                                    AC10.1  AC110
Activity Group       This is the activity group for the          AC120   AC500
                     activity.                                   AC730   AC950
                                                                 AC951

ACV-COMPANY          Numeric 4                                   AC10.1  AC110
Company              This field defines the responsible          AC500   AC540
                     company number for the activity. The        AC730   AC950
                     responsible company is defined in the       AC951
                     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   AC730
                     activity. The accounting unit is a          AC950
                     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   AC730
                     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   AC730
                     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   AC730
                     activity. Account categories are            AC950
                     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.          AC500   AC730
                                                                 AC950

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   AC730
                     define various parameters relating to       AC950
                     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   AC500
                     organizes activities into a reporting       AC730   AC950
                     hierarchy. Level names are defined for
                     an activity group and should be able to
                     be used across all activities in an
                     activity group. Levels facilitate rollup
                     or consolidation of budgets, costs, and
                     revenues from activities at lower levels
                     to macro activities at a higher level
                     within the hierarchy.

                     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   AC500
Display              numbering scheme that allows detail to      AC730   AC950
                     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   AC730
                     activity. The activity date range must      AC950
                     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   AC730
                     activity. The activity date range must      AC950
                     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   AC20.6
Active Budget        This is the budget number for the           AC310   AC730
                     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 Occurs 4 Times                     AC10.1  AC110
Long Description     This is the long description of the         AC500   AC730
                     activity.                                   AC950

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

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

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

ACV-HIGH-PST-DATE    Numeric 8  (yyyymmdd)                       AC110   AC120
Highest Posting Date This is the latest posting date for         AC190   AC500
                     transactions posted to the activity.        AC580   AC730
                                                                 AC950   AC980

ACV-RELEASED         Alpha 1                                     AC701   AC950
Released             This is the change order status for
                     activity change orders. The activity can
                     have only one unreleased change order at
                     a time.
                     Y = Released
                     N = Not Released

ACV-BALANCE-AMOUNT   Signed 17.2                                 AC110   AC120
Balance Amount       This is the amount balance for the          AC190   AC300
                     life-to-date activity actuals amount.       AC580   AC730
                                                                 AC980

ACV-BALANCE-UNIT     Signed 17.2                                 AC110   AC120
Units Balance        This is the unit balance for the            AC190   AC300
                     activity actuals.                           AC580   AC730
                                                                 AC980

ACV-BALANCE-HOURS    Signed 17.2                                 AC110   AC120
Hours Balance        This is the hours balance for the           AC190   AC300
                     activity actuals.                           AC580   AC980

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            AC500   AC730
                     activity is billable. Use Yes (Y) for       AC950
                     billable. Use No (N) for nonbillable.
                     Y = Billable
                     N = Non-billable

ACV-CONTRACT-AMT     Signed 15.2                                 AC10.1  AC110
Contract Amount      This is the contract amount defined for     AC500   AC950
                     the activity. You can define contract
                     amount in AC10.1 (Activity).

ACV-TOTAL-COST       Signed 15.2                                 AC110   AC115
Total Cost           This is the total unbilled balance.         AC170   AC300
                                                                 AC500   AC80.1
                                                                 AC800   AC980

ACV-TOTAL-BILLED     Signed 15.2                                 AC110   AC115
Total Billed         This is the total life-to-date amount       AC300   AC500
                     billed for the activity.

ACV-TOTAL-BILLABLE   Signed 15.2                                 AC110   AC115
Total Billable       This is the total life-to-date amount       AC170   AC300
                     billable for this activity.                 AC500   AC80.1
                                                                 AC800   AC980

ACV-TOTAL-REVENUE    Signed 15.2                                 AC110   AC170
Total Revenue        This is the total life-to-date revenue      AC300   AC500
                     recognized for this activity.

ACV-TOTAL-LOSS       Signed 15.2                                 AC110   AC170
Total Loss           This is the total life-to-date loss for     AC300   AC500
                     this activity.

ACV-SECURITY         Derived
Security             This field derives security information
                     for the activity.

ACV-POSTING          Derived
Posting              This field indicates whether the
                     activity is a posting-level activity.
                     Use Yes for posting, No for summary.

ACV-GL-ONLY          Derived
Gl Only              This field indicates whether the
                     activity posts to the general ledger
                     only or to Activity Management and the
                     general ledger.

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

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

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

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

                         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
                                                                 AC115   AC12.1
                                                                 AC120   AC121
                                                                 AC123   AC127
                                                                 AC13.1  AC13.2
                                                                 AC13.3  AC13.4
                                                                 AC130   AC14.1
                                                                 AC15.1  AC15.2
                                                                 ...

ACVSET2   ACTIVITY-GRP  KeyChange                                AC00.1  AC01.1
          ACTIVITY                                               AC06.1  AC112
                                                                 AC115   AC12.1
                                                                 AC120   AC121
                                                                 AC160   AC165
                                                                 AC170   AC191
                                                                 AC196   AC20.4
                                                                 AC20.7  AC210
                                                                 AC214   AC215
                                                                 AC216   AC240
                                                                 AC265   AC290
                                                                 AC295   AC297
                                                                 AC300   AC310
                                                                 AC401   AC412
                                                                 AC415   AC416
                                                                 ...

ACVSET3   COMPANY       KeyChange                                AC12.1
          ACTIVITY

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

ACVSET6   OBJ-ID                                                 AC105   AC110
                                                                 AC112   AC115
                                                                 AC120   AC121
                                                                 AC123   AC127
                                                                 AC13.2  AC13.3
                                                                 AC13.4  AC130
                                                                 AC14.1  AC160
                                                                 AC165   AC170
                                                                 AC190   AC191
                                                                 AC196   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC203
                                                                 AC206   AC207
                                                                 AC210   AC214
                                                                 AC215   AC216
                                                                 ...

ACVSET8   ACTIVITY-GRP  KeyChange, Subset                        AC10.1  AC10.5
          VAR-LEVELS    Where (VAR-LEVELS != Spaces )            AC115   AC120
                                                                 AC121   AC123
                                                                 AC127   AC165
                                                                 AC170   AC190
                                                                 AC191   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.6
                                                                 AC210   AC22.1
                                                                 AC310   AC412
                                                                 AC450   AC472
                                                                 AC50.1  AC500
                                                                 AC580   AC65.1
                                                                 AC701   AC79.1
                                                                 AC800   AC980
                                                                 ...

                         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

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

Aclevel        ACLEVEL      Required

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

Acrevenue      ACREVENUE    Not Required

                            ACV-ACTIVITY         -> ARV-ACTIVITY

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

                         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

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 Mngr  ACASSIGN

                            ACV-ACTIVITY-GRP     -> AAN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> AAN-ACTIVITY
                                                    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

Acbudhdr       ACBUDHDR

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

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

Accomments     ACCOMMENTS

                            ACV-ACTIVITY-GRP     -> CMN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> CMN-ACTIVITY
                                                    CMN-COMMENT-TYP
                                                    CMN-SEQ-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         -> CSL-ACTIVITY
                            Zeroes               -> CSL-BUDGET-NBR
                                                    CSL-ACCT-CATEGORY
                                                    CSL-FISCAL-YEAR

Acconsol Bdgt  ACCONSOL

                            ACV-ACTIVITY         -> CSL-ACTIVITY
                                                    CSL-BUDGET-NBR
                                                    CSL-ACCT-CATEGORY
                                                    CSL-FISCAL-YEAR

Acctlgrphd     ACCTLGRPHD

                            ACV-ACTIVITY         -> CGH-ACTIVITY
                                                    CGH-TRANS-TYPE
                                                    CGH-CONTROL-GROUP

Accuamt        ACCUAMT

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

Accuamt Allbud ACCUAMT

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

Accuamt Budget ACCUAMT

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

Accustomer     ACCUSTOMER

                            ACV-ACTIVITY         -> CMR-ACTIVITY
                                                    CMR-CUSTOMER

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

Acgltotrev     ACGLTOTREV

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

Aclevel Set2   ACLEVEL

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

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-ACCT-CATEGORY

Acmilestnx     ACMILESTNX

                            ACV-ACTIVITY         -> MLX-ACTIVITY
                                                    MLX-ACCT-CATEGORY
                                                    MLX-MILESTONE

Acperccmpl     ACPERCCMPL

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

Acpercmplx     ACPERCMPLX

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

Actrans Commit ACTRANS

                            ACV-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            1                    -> ATN-STATUS
                            ACV-ACTIVITY         -> ATN-ACTIVITY
                                                    ATN-ACCT-CATEGORY
                                                    ATN-OBJ-ID
                                                    ATN-CONTROL-GROUP
                                                    ATN-SEQUENCE-NBR

Actrans Error  ACTRANS

                            ACV-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            1                    -> ATN-STATUS
                            ACV-ACTIVITY         -> ATN-ACTIVITY
                                                    ATN-ACCT-CATEGORY
                                                    ATN-OBJ-ID
                                                    ATN-CONTROL-GROUP
                                                    ATN-SEQUENCE-NBR

Actrans Hist   ACTRANS

                            ACV-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            9                    -> ATN-STATUS
                            ACV-ACTIVITY         -> ATN-ACTIVITY
                                                    ATN-ACCT-CATEGORY
                                                    ATN-OBJ-ID
                                                    ATN-CONTROL-GROUP
                                                    ATN-SEQUENCE-NBR

Actrans Posted ACTRANS

                            ACV-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            9                    -> ATN-STATUS
                            ACV-ACTIVITY         -> ATN-ACTIVITY
                                                    ATN-ACCT-CATEGORY
                                                    ATN-OBJ-ID
                                                    ATN-CONTROL-GROUP
                                                    ATN-SEQUENCE-NBR

Actrans Releas ACTRANS

                            ACV-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            1                    -> ATN-STATUS
                            ACV-ACTIVITY         -> ATN-ACTIVITY
                                                    ATN-ACCT-CATEGORY
                                                    ATN-OBJ-ID
                                                    ATN-CONTROL-GROUP
                                                    ATN-SEQUENCE-NBR

Atnset4        ACTRANS

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

Bill Unearned  ACTRANS

                            ACV-ACTIVITY-GRP     -> ATN-ACTIVITY-GRP
                            ACV-ACTIVITY         -> ATN-ACTIVITY
                                                    ATN-ACCT-CATEGORY
                                                    ATN-COMPANY
                                                    ATN-ACCT-UNIT
                                                    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

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

Earned Unbilld ACTRANS

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

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

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