ACACTIVITY – Activity

System
Activity Management (AC)
Prefix
ACV
Primary key
ACTIVITY
Fields
66
Updated by
136 programs
Referenced by
548 programs

ACACTIVITY is the Activity table in Lawson Activity Management (prefix ACV). It is indexed by ACTIVITY (ACVSET1); alternate indexes: ACVSET2, ACVSET3, ACVSET4, ACVSET6, ACVSET7 and ACVSET8. It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTSEG, ACACTVTBOD, ACADDLCNTR, ACBILL, ACBUDHDR, ACCNTRACT and 10 more and 1:M to ACACCTCATX, ACACRESRTX, ACACTMXVAL, ACACTMXVDT, ACADDASSGN, ACAMCODE, ACASNROLE, ACASSIGN and 41 more. It is updated by AC00.1, AC10.1, AC10.5, AC10.6, AC110, AC112, AC113, AC12.1 and 128 more and referenced by AC01.1, AC02.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7 and 540 more. The table has 66 fields, 7 indexes and 109 documented relations.

About ACACTIVITY

This file contains activity set-up and definition information from AC10.1 (Activity). Activities identify the actual tasks that make up an activity. Project and Activity Accounting stores data such as activity group, responsible company, date ranges, status, long description, levels and location. This information is used to collect and report on costs and revenues. You must set up an activity before you can create activity budgets and post transactions. An activity's level number configuration relates it to other activities in a hierarchy for consolidating, or rolling up, data on certain forms and reports. Transactions in Project and Activity Accounting are posted to activities. Journal entries destined for activity posting are entered in the General Ledger or a subledger with an entry in the Activity and Account Category fields on the transaction line.

Fields (66)

Column = COBOL field name without the ACV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ACV-ACTIVITY PK
ACTIVITY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in Project Accounting. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: posting allowed and summary only. Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.AC10.1, AC110, AC197, AC198, AC500, AC540, AC90.2, AC90.4 +3 more
#ACV-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the activity description.AC10.1, AC110, AC145, AC197, AC198, AC500
#ACV-ACTIVITY-GRP SET2 SET4 SET8
ACTIVITY_GRP
Alpha 15This is the activity group for the activity.AC10.1, AC110, AC120, AC500, AC90.2, AC90.4, AC90.6, AC90.8 +1 more
#ACV-CONTRACT
CONTRACT
Alpha 15If this Activity is a Contract type, and is idetified in BR0 as the 'Contract Activity', th name of the related Contrct will be updated to this field.BR10.1, BR10.9
#ACV-COMPANY SET3
COMPANY
Numeric 4This field defines the responsible company number for the activity. The responsible company is defined in the General Ledger system. The responsible company determines the activity currency.AC10.1, AC110, AC113, AC500, AC540
#ACV-ACCT-UNIT
ACCT_UNIT
Alpha 15This is an accounting unit for the 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.AC10.1, AC110, AC113, AC500
#ACV-ACCOUNT
ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AC10.1, AC110, AC113, AC500
#ACV-SUB-ACCT
SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AC10.1, AC110, AC113, AC500
#ACV-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5This is an account category for the activity. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Project Accounting. All transactions are posted to an account category within an activity. Using AC07.1 (Account Assignment), you can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) to the transactions posted to an account category .AC10.1, AC110, AC500
#ACV-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This is the company currency code.AC10.1, AC110, AC197, AC198, AC500
#ACV-USR-STATUS
USR_STATUS
Alpha 2This is a user-defined code indicating the status of the activity. You can 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.AC10.1, AC110, AC112, AC12.1, AC500
#ACV-VAR-LEVELS SET4 SET8
VAR_LEVELS
Alpha 30Levels define an addressing system that organizes activities into a reporting hierarchy. Level names are defined for an activity group and should be able to be used across all activities in an activity group. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to macro activities at a higher level within the hierarchy. Up to 15 characters can be used to name a single level. The number of characters used to name all levels can total 30.AC10.1, AC110, AC120, AC500, AC90.2, AC90.4, AC90.6, AC90.8 +1 more
#ACV-VAR-LEVEL-DISP
VAR_LEVEL_DISP
Alpha 34This field shows the hierarchical numbering scheme that allows detail to be aggregated or "rolled-up" in summarized form. Five levels are available in the Activity Management system.AC10.1, AC110, AC120, AC197, AC198, AC500
#ACV-BEGIN-DATE
BEGIN_DATE
Numeric 8 (yyyymmdd)This is the beginning date for the 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.AC10.1, AC110, AC500
#ACV-END-DATE
END_DATE
Numeric 8 (yyyymmdd)This is the ending date for the 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.AC10.1, AC110, AC113, AC500
#ACV-ACTIVE-BUD
ACTIVE_BUD
Numeric 3This is the budget number for the 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).AC110, AC127, AC20.7
#ACV-LONG-DESC
LONG_DESC
Alpha 60 (Lower Case)Occurs 4 Times This is the long description of the activity.AC10.1, AC110, AC500
#ACV-ESTIMATE
ESTIMATE
Signed 18.2This is a budget estimate for the activity. This estimate is informational only.AC10.1, AC110, AC500
#ACV-OBJ-ID SET6
OBJ_ID
Numeric 12This field defines the activity. The 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.AC10.1, AC110, AC197, AC198, AC500
#ACV-PARENT-ACTV SET7
PARENT_ACTV
Alpha 15The parent activity field contains the activity name of the member parent.AC10.1, AC110, AC120, AC500
#ACV-ACTIVITY-ND
ACTIVITY_ND
Numeric 1This is the number of decimal positions defined for the activity currency.AC10.1, AC110, AC145, AC197, AC198, AC500
#ACV-HIGH-PST-DATE
HIGH_PST_DATE
Numeric 8 (yyyymmdd)This is the latest posting date for transactions posted to the activity.AC110, AC190, AC300, AC500, ACDR.1
#ACV-BALANCE-AMOUNT
BALANCE_AMOUNT
Signed 18.2This is the amount balance for the life-to-date activity actuals amount.AC110, AC300, ACDR.1
#ACV-BALANCE-UNIT
BALANCE_UNIT
Signed 17.2This is the unit balance for the activity actuals.AC110, AC300, ACDR.1
#ACV-SHORT-DESC
SHORT_DESC
DerivedThis is the short description of the activity.—
#ACV-BILLABLE-FLAG
BILLABLE_FLAG
Alpha 1This field indicates whether the activity is billable. Use Yes (Y) for billable. Use No (N) for nonbillable.
  • Y Yes
  • N No
  • H Hold
AC10.1, AC110, AC120, AC197, AC198, AC500
#ACV-SECURITY-CD
SECURITY_CD
Numeric 4This field contains the security code for the activity.AC00.1, AC10.1, AC110, AC120, AC500
#ACV-POST-OR-GLONLY
POST_OR_GLONLY
Derived——
#ACV-OUTPUT-MEASURE
OUTPUT_MEASURE
Signed 18.2This is the output measurement.AC10.1, AC500
#ACV-OUTPUT-DESC
OUTPUT_DESC
Alpha 30This is the output description.AC10.1, AC500
#ACV-SEGMENT-FLAG
SEGMENT_FLAG
Alpha 1Indicates whether user analysis values (SL segment) have been populated for the distribution line.AC10.1, AC110, AC500
#ACV-GRP-CURR-CODE1
GRP_CURR_CODE1
Derived——
#ACV-GRP-CURR-CODE2
GRP_CURR_CODE2
Derived——
#ACV-ACT-SEG-BLOCK
ACT_SEG_BLOCK
Derived——
#ACV-BILL-WBS-CODE
BILL_WBS_CODE
Alpha 3—AC10.1, AC500
#ACV-LOCATION-NAME
LOCATION_NAME
Alpha 15A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.AC10.1
#ACV-DIVISION
DIVISION
Alpha 15A user-defined division which is used for reporting assets.AC10.1
#ACV-POP-FLAG
POP_FLAG
Alpha 1Period of Performance flag. If records are added into the ACPRDPERF file for the related activity, the flag will be updated to Y.
  • N No
  • Y Yes
AC10.6, AC110, AC120
#ACV-AWARD-FLAG
AWARD_FLAG
Alpha 1Flag to indicate whether this activity is an award for the GM system or a posting level activity within an award.
  • Y Yes
  • N No
AC10.1, AC110, AC113, AC500
#ACV-EFFORT-FLAG
EFFORT_FLAG
Alpha 1Flag to indicate whether this activity is subject to effort reporting, and if it is, whether it prints in the sponsored or non-sponsored section of the report for effort reporting.
  • Y Yes
  • N No
AC10.1, AC110, AC113, AC500
#ACV-SALARY-CAP-FL
SALARY_CAP_FL
Alpha 1This flag indicates whether the salary cap applies to this grant/project. The actual salary cap amount is stored on the GMSALCAP record.
  • Y Yes
  • N No
AC10.1, AC110, AC113, AC500
#ACV-FRNG-RATE
FRNG_RATE
Signed 14.7The currency rate.AC10.1, AC110, AC113, AC500
#ACV-FRNG-ACCT-CAT
FRNG_ACCT_CAT
Alpha 5A default post-to fringe account category that can be used by GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the rate, post-to account and account category information from the activity or employee.AC10.1, AC110, AC113, AC500
#ACV-FRNG-ACCOUNT
FRNG_ACCOUNT
Numeric 6A default post-to fringe account that can be used by the GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the fringe rate, post-to account and account category information from the activity or employee.AC10.1, AC110, AC113, AC500
#ACV-FRNG-SUB-ACCT
FRNG_SUB_ACCT
Numeric 4A default post-to fringe sub account that can be used by the GM110 program to create commitments for fringe amounts. There is a parameter choice on the GM110 program that allows the user to default the fringe rate, post-to account and account category information from the activity or employee.AC10.1, AC110, AC113, AC500
#ACV-SALARY-CAP-AMT
SALARY_CAP_AMT
Signed 18.2Salary cap amount for the activity. It is assummed to be in the activity currency.—
#ACV-STRUCTURE
STRUCTURE
Alpha 15The name of the category structure. This represents the category structure assigned to the activity.AC10.1, AC110, AC500
#ACV-BILL-REV-FLAG
BILL_REV_FLAG
Alpha 1—
  • Y Yes
  • N No
AC10.1, AC120, BR120, BR122, BR130, BR140, BR521, BR530
#ACV-BACKOUT-STATUS
BACKOUT_STATUS
Alpha 1—
  • Y Yes
  • N No
AC10.1, AC10.5, AC120, BR140
#ACV-PAR-ACT-STRCT
PAR_ACT_STRCT
Alpha 15 Occurs 4 Times ×4This field will contain the parent of the Activity at each variable level in the Activity Groups hierarchy.AC10.1, AC110, AC120, AC500
#ACV-POSTING-FLAG
POSTING_FLAG
Alpha 1—
  • P Posting
  • S Summary
  • C Contract
AC10.1, AC110, AC500
#ACV-LEVEL-DEPTH SET4
LEVEL_DEPTH
Numeric 1The number of variable levels pertaining to this record.AC10.1, AC110, AC120, AC500
#ACV-LEVEL-DETAIL
LEVEL_DETAIL
Numeric 15 Occurs 5 Times ×5—AC10.1, AC110, AC120, AC500
#ACV-BUDGET-EDIT
BUDGET_EDIT
Alpha 1—
  • 1 No Edit
  • 2 Period Edit
  • 3 Annual Edit
  • 4 Total Edit
AC10.1, AC110, AC113, AC500
#ACV-BUDGET-LEVEL
BUDGET_LEVEL
Alpha 1—
  • 1 Activity-Acct Cat
  • 3 Activity
  • 4 Activity-Summary Account Cat
  • 5 Contract Funding
AC10.1, AC110, AC113, AC500
#ACV-BUD-TOLERANCE
BUD_TOLERANCE
Signed 5.2—AC10.1, AC110, AC113, AC500
#ACV-SCHEDULE
SCHEDULE
Alpha 9Stores the applicable salary cap schedule when the grant activity is subject to a salary cap. Only one schedule can exist per grant activity (the grant structure requires one activity per funding source and salary caps are driven by funding sources). Valid only if ACV-SALARY-CAP-FL is set to Y.AC10.1, AC110, AC113, AC500
#ACV-CURRENT-CAP
CURRENT_CAP
Alpha 1Determines which salary cap amount is used to determine salary cap overage on labor distribution templates and reports. Y indicates that the most current active salary cap amount in the schedule is used. N or blank (the default) indicates that the salary cap amount in effect in the schedule on the activity start date is used.
  • Y Yes
  • N No
AC10.1, AC110, AC113, AC500
#ACV-CAP-ACTIVITY
CAP_ACTIVITY
Alpha 15Identifies the activity to charge with the salary cap overage on the labor distribution template. When a salary cap overage occurs, a new template line is created with the GL account and activity (if any) to which the overage should be charged. If this field is blank, salary cap overages are not charged to any activity or account categories.AC10.1, AC110, AC113, AC500
#ACV-CAP-ACCT-CAT
CAP_ACCT_CAT
Alpha 5Valid only if an activity is selected. Identifies the account category to charge with the salary cap overage on the labor distribution template. When a salary cap overage occurs, a new template line is created with the GL account and activity/account category (if any) to which the overage should be charged. If the account category field is blank and the activity field is populated, the overage is charged to the account category on the labor distribution template line from which the overage is initiated. If the activity field is not populated, the account category field cannot be populated. Overage is not charged to AC.AC10.1, AC110, AC113, AC500
#ACV-CAP-COMPANY
CAP_COMPANY
Numeric 4Identifies the GL company to charge with the salary cap overage on the labor distribution template. When a salary cap overage occurs, a new template line is created with the GL account and activity (if any) to which the overage should be charged. If the company field is blank, the overage is charged to the GL company on the labor distribution template line from which the overage is initiated.AC10.1, AC110, AC113, AC500
#ACV-CAP-ACCT-UNIT
CAP_ACCT_UNIT
Alpha 15Identifies the accounting unit to charge with the salary cap overage on the labor distribution template. When a salary cap overage occurs, a new template line is created with the GL account and activity (if any) to which the overage should be charged. If the Accounting Unit field is blank, overage is charged to the accounting unit on the labor distribution template line from which the overage is initiated.AC10.1, AC110, AC113, AC500
#ACV-CAP-ACCOUNT
CAP_ACCOUNT
Numeric 6Identifies the account to charge with the salary cap overage on the labor distribution template. When a salary cap overage occurs, a new template line is created with the GL account and activity (if any) to which the overage should be charged. If the Account field is blank, overage is charged to the account on the labor distribution template line from whcih the overage is initiated.AC10.1, AC110, AC113, AC500
#ACV-CAP-SUB-ACCT
CAP_SUB_ACCT
Numeric 4Identified the subaccount to cahrge with the salary cap overage on the labor distribution template. When a salary cap overage occurs, a new template line is created with the GL account and activity (if any) to which the overage should be charged. If the Subaccount field is blank, the overage is charged to the subaccount (if any) on the labor distribution template line from which the overage is initiated.AC10.1, AC110, AC113, AC500
#ACV-CAP-SEG-FLAG
CAP_SEG_FLAG
Alpha 1Identifies the user analysis (if any) to charge with the salary cap overage on the labor distribution template. When a salary cap overage occurs, a new template line is created with GL account, activity (if any) and user analysis (if any) to which the overage should be charged. If this field is blank, overage is charged to the user analysis (if any) on the labor distribution template line from which the overage is initiated.AC10.1, AC110, AC113, AC500
#ACV-DATE-CREATED
DATE_CREATED
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AC10.1, AC110, AC500

Indexes (7)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ACVSET1
  1. ACTIVITY
PrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC03.2, AC03.3, AC03.4 +22 more (list truncated in source)
ACVSET2
  1. ACTIVITY-GRP
  2. ACTIVITY
KeyChangeAC00.1, AC01.1, AC10.1, AC10.5, AC105, AC110, AC112, AC113 +22 more (list truncated in source)
ACVSET3
  1. COMPANY
  2. ACTIVITY
KeyChangeAC12.1
ACVSET4
  1. ACTIVITY-GRP
  2. LEVEL-DEPTH
  3. VAR-LEVELS ↓
  4. ACTIVITY
KeyChangeAC01.1, AC10.1, AC560
ACVSET6
  1. OBJ-ID
AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
ACVSET7
  1. PARENT-ACTV
  2. ACTIVITY
KeyChange—
ACVSET8
  1. ACTIVITY-GRP
  2. VAR-LEVELS
KeyChange, SubsetWhere (VAR-LEVELS != Spaces)AC01.1, AC10.1, AC10.5, AC11.1, AC110, AC112, AC113, AC12.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTGRPACACTSEGACACTVTBODACADDLCNTRACBILLACBUDHDRACCNTRACTACCUSTOMERACSTATUSCUCODESGLNAMESGLSYSTEMGMAWARD+4 more belowACACCTCATXACACRESRTXACACTMXVALACACTMXVDTACADDASSGNACAMCODEACASNROLEACASSIGNACAUDITACBILLXACBLRATEXACBRDNBLRXACBRDNDTLACBUDHDR+35 more belowACACTIVITY

One to one (18) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot Required
ACV-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
ACV-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactsegACACTSEGNot Required
ACV-OBJ-ID→CSG-OBJ-ID
AcactvtbodACACTVTBODNot Required, Delete Cascades
ACV-ACTIVITY→YAB-ACTIVITY
AcaddlcntrACADDLCNTRNot Required
ACV-ACTIVITY-GRP→ADN-ACTIVITY-GRP
CNT-CONTRACT→ADN-CONTRACT
AcbillACBILLNot Required
ACV-ACTIVITY→ACI-ACTIVITY
Acbudhdr Set1ACBUDHDRNot RequiredValid When ACV-ACTIVE-BUD != Zeroes
ACV-ACTIVITY-GRP→BDH-ACTIVITY-GRP
ACV-ACTIVITY→BDH-ACTIVITY
ACV-ACTIVE-BUD→BDH-BUDGET-NBR
AccntractACCNTRACTNot Required
ACV-CONTRACT→CNT-CONTRACT
AccustomerACCUSTOMERNot Required
CNT-COMPANY→CMR-COMPANY
CNT-CUSTOMER→CMR-CUSTOMER
CNT-AC-CUSTOMER-ID→CMR-AC-CUSTOMER-ID
AcstatusACSTATUSRequired
ACV-USR-STATUS→STS-USR-STATUS
CucodesCUCODESRequired
ACV-CURRENCY-CODE→CUC-CURRENCY-CODE
GlnamesGLNAMESNot Required
ACV-COMPANY→GLN-COMPANY
ACV-ACCT-UNIT→GLN-ACCT-UNIT
GlsystemGLSYSTEMRequired
ACV-COMPANY→GLS-COMPANY
GmawardGMAWARDNot Required
ACV-ACTIVITY→GMG-ACTIVITY
GmsalcapGMSALCAPNot Required
ACV-SCHEDULE→GMC-SCHEDULE
ACV-CURRENCY-CODE→GMC-CURRENCY-CODE
Object IdOBJIDNot Required
"ACTVY"→OBI-OBJ-TYPE
ParentACACTIVITYNot Required
ACV-PARENT-ACTV→ACV-ACTIVITY
StructureSTRUCTURERequired
ACV-STRUCTURE→SRE-STRUCTURE

One to many (91) — child tables

RelationTableRulesConditionField map
AcacctcatxACACCTCATX
ACV-ACTIVITY-GRP→AXX-ACTIVITY-GRP
ACV-ACTIVITY→AXX-ACTIVITY
—→AXX-ACCT-CATEGORY
Acacctcatxset2ACACCTCATX
ACV-ACTIVITY-GRP→AXX-ACTIVITY-GRP
—→AXX-ACCT-CATEGORY
—→AXX-ACTIVITY
AcacresrtxACACRESRTX
ACV-ACTIVITY-GRP→CRX-ACTIVITY-GRP
ACV-ACTIVITY→CRX-ACTIVITY
—→CRX-RESOURCE-TYPE
—→CRX-RESOURCE-CODE
—→CRX-COMPANY
—→CRX-EFFECTIVE-DATE
Acacresrtx GrpACACRESRTX
ACV-ACTIVITY-GRP→CRX-ACTIVITY-GRP
Spaces→CRX-ACTIVITY
—→CRX-RESOURCE-TYPE
—→CRX-RESOURCE-CODE
—→CRX-COMPANY
—→CRX-EFFECTIVE-DATE
AcactmxvalACACTMXVAL
ACV-OBJ-ID→AJV-OBJ-ID
—→AJV-MATRIX-CAT
AcactmxvdtACACTMXVDT
ACV-OBJ-ID→MXD-OBJ-ID
—→MXD-MATRIX-CAT
—→MXD-EFFECTIVE-DATE
AcaddassgnACADDASSGN
ACV-ACTIVITY→AAS-ACTIVITY
—→AAS-ADDRESS-CODE
AcamcodeACAMCODE
ACV-ACTIVITY→MCD-ACTIVITY
—→MCD-ACCT-CATEGORY
Acamcode 1ACAMCODE
ACV-ACTIVITY→MCD-ACTIVITY
—→MCD-ACCT-CATEGORY
AcasnroleACASNROLE
ACV-ACTIVITY-GRP→ALE-ACTIVITY-GRP
ACV-ACTIVITY→ALE-ACTIVITY
—→ALE-RESOURCE-TYPE
—→ALE-COMPANY
—→ALE-RESOURCE-CODE
—→ALE-ROLE
AcassignACASSIGN
ACV-ACTIVITY-GRP→AAN-ACTIVITY-GRP
ACV-ACTIVITY→AAN-ACTIVITY
—→AAN-COMPANY
—→AAN-RESOURCE-TYPE
—→AAN-RESOURCE-CODE
AcauditACAUDIT
ACV-ACTIVITY→AUD-ACTIVITY
—→AUD-PROCESS-DATE
—→AUD-PROCESS-TIME
—→AUD-COPY-FR-AG
—→AUD-COPY-TO-AG
—→AUD-REORG-OR-COPY
AcbillxACBILLX
ACV-ACTIVITY→AIX-ACTIVITY
—→AIX-SUM-ACCT-CAT
—→AIX-CTR-CAT-GRP
—→AIX-ACCT-CATEGORY
AcblratexACBLRATEX
ACV-ACTIVITY→ALX-ACTIVITY
—→ALX-SUM-ACCT-CAT
—→ALX-CTR-CAT-GRP
—→ALX-ACCT-CATEGORY
—→ALX-SOURCE-CODE
—→ALX-MATRIX-CAT
—→ALX-EFFECTIVE-DT
—→ALX-MX-VALUE
AcbrdnblrxACBRDNBLRX
ACV-ACTIVITY→BRX-ACTIVITY
—→BRX-BURDEN-CD
—→BRX-BURDEN-TYPE
—→BRX-POOL-NBR
—→BRX-EFFECTIVE-DATE
AcbrdndtlACBRDNDTL
ACV-ACTIVITY-GRP→BRD-ACTIVITY-GRP
ACV-ACTIVITY→BRD-ACTIVITY
—→BRD-ACCT-CATEGORY
—→BRD-BURDEN-CD
—→BRD-POOL-NBR
AcbudhdrACBUDHDR
ACV-ACTIVITY-GRP→BDH-ACTIVITY-GRP
ACV-ACTIVITY→BDH-ACTIVITY
—→BDH-BUDGET-NBR
AccatsumACCATSUM
ACV-STRUCTURE→SRS-STRUCTURE
—→SRS-SUM-ACCT-CAT
AccatsumxACCATSUMX
ACV-STRUCTURE→SRX-STRUCTURE
—→SRX-ACCT-CATEGORY
AcceilingxACCEILINGX
ACV-ACTIVITY→CEX-ACTIVITY
—→CEX-ACCT-CATEGORY
—→CEX-SUM-ACCT-CAT
—→CEX-CTR-CAT-GRP
—→CEX-MATRIX-CAT
—→CEX-MX-VALUE
Acchgord AllACCHGORDER
ACV-ACTIVITY-GRP→CHO-ACTIVITY-GRP
ACV-ACTIVITY→CHO-ACTIVITY
—→CHO-BUDGET-NBR
—→CHO-CHG-ORDER-NBR
AcchgorderACCHGORDER
ACV-ACTIVITY-GRP→CHO-ACTIVITY-GRP
ACV-ACTIVITY→CHO-ACTIVITY
ACV-ACTIVE-BUD→CHO-BUDGET-NBR
—→CHO-CHG-ORDER-NBR
AccntractxACCNTRACTX
ACV-ACTIVITY→CNX-ACTIVITY
—→CNX-CONTRACT
AccommitACCOMMIT
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
AcconsolACCONSOL
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 AllbudACCUAMT
ACV-ACTIVITY-GRP→ACU-ACTIVITY-GRP
ACV-ACTIVITY→ACU-ACTIVITY
—→ACU-CURRENCY-CODE
—→ACU-BUDGET-NBR
—→ACU-ACCT-CATEGORY
—→ACU-FISCAL-YEAR
AcglacctACGLACCT
ACV-ACTIVITY-GRP→AGA-ACTIVITY-GRP
ACV-ACTIVITY→AGA-ACTIVITY
—→AGA-ACCT-CATEGORY
—→AGA-SEQ-NUMBER
Acglacct AllACGLACCT
ACV-ACTIVITY-GRP→AGA-ACTIVITY-GRP
Spaces→AGA-ACTIVITY
—→AGA-ACCT-CATEGORY
—→AGA-SEQ-NUMBER
AcglconslACGLCONSL
ACV-ACTIVITY-GRP→GCO-ACTIVITY-GRP
ACV-ACTIVITY→GCO-ACTIVITY
—→GCO-ACCT-CATEGORY
—→GCO-COMPANY
—→GCO-ACCT-UNIT
—→GCO-RESOURCE-TYPE
—→GCO-RESOURCE-COMP
—→GCO-RESOURCE-CODE
—→GCO-FISCAL-YEAR
AcglmastACGLMAST
ACV-ACTIVITY-GRP→GMT-ACTIVITY-GRP
ACV-ACTIVITY→GMT-ACTIVITY
—→GMT-ACCT-CATEGORY
—→GMT-COMPANY
—→GMT-ACCT-UNIT
—→GMT-FISCAL-YEAR
—→GMT-RESOURCE-TYPE
—→GMT-RESOURCE-COMP
—→GMT-RESOURCE-CODE
AcgltotrevACGLTOTREV
ACV-ACTIVITY→GRV-ACTIVITY
—→GRV-ACCT-CATEGORY
—→GRV-COMPANY
—→GRV-ACCT-UNIT
AchistoryACHISTORY
ACV-ACTIVITY→HST-ACTIVITY
—→HST-FIELD-ID
—→HST-DATE-STAMP
—→HST-SEQ-NBR
AcmasterACMASTER
ACV-ACTIVITY-GRP→MST-ACTIVITY-GRP
ACV-ACTIVITY→MST-ACTIVITY
—→MST-ACCT-CATEGORY
—→MST-FISCAL-YEAR
AcmilestnACMILESTN
ACV-ACTIVITY→MLS-ACTIVITY
—→MLS-MILESTONE-CAT
AcmilestnxACMILESTNX
ACV-ACTIVITY→MLX-ACTIVITY
—→MLX-MILESTONE-CAT
—→MLX-MILESTONE
AcperccmplACPERCCMPL
ACV-ACTIVITY→PEC-ACTIVITY
—→PEC-RECORD-TYPE
—→PEC-BUDGET-TYPE
—→PEC-DATE
AcpercmplxACPERCMPLX
ACV-ACTIVITY→PEX-ACTIVITY
—→PEX-RECORD-TYPE
—→PEX-BUDGET-TYPE
—→PEX-ACCT-CATEGORY
—→PEX-DATE
AcprdperfACPRDPERF
ACV-ACTIVITY-GRP→PFM-ACTIVITY-GRP
ACV-ACTIVITY→PFM-ACTIVITY
—→PFM-SYSTEM
—→PFM-SEQ-NUMBER
AcreshistACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
—→RSH-RESOURCE-TYPE
—→RSH-RESOURCE-CODE
—→RSH-COMPANY
—→RSH-ROLE
—→RSH-FIELD-ID
—→RSH-SEQ-NUMBER
AcretainACRETAIN
ACV-ACTIVITY→RET-ACTIVITY
—→RET-RETAIN-ID
AcretngACRETNG
ACV-ACTIVITY→RTG-ACTIVITY
—→RTG-SUM-ACCT-CAT
—→RTG-CTR-CAT-GRP
—→RTG-ACCT-CATEGORY
Actotbal BaseACTOTBAL
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 Cur1ACTOTBAL
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 Cur2ACTOTBAL
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 CommitACTRANS
ACV-ACTIVITY-GRP→ATN-ACTIVITY-GRP
ACV-ACTIVITY→ATN-ACTIVITY
—→ATN-ACCT-CATEGORY
—→ATN-POSTING-DATE
—→ATN-OBJ-ID
Actrans ErrorACTRANS
ACV-ACTIVITY-GRP→ATN-ACTIVITY-GRP
ACV-ACTIVITY→ATN-ACTIVITY
—→ATN-ACCT-CATEGORY
—→ATN-POSTING-DATE
—→ATN-OBJ-ID
Actrans HistACTRANS
ACV-ACTIVITY→ATN-ACTIVITY
—→ATN-ACCT-CATEGORY
—→ATN-FISCAL-YEAR
—→ATN-PERIOD
—→ATN-OBJ-ID
Actrans PostedACTRANS
ACV-ACTIVITY→ATN-ACTIVITY
—→ATN-ACCT-CATEGORY
—→ATN-FISCAL-YEAR
—→ATN-PERIOD
—→ATN-OBJ-ID
Actrans ReleasACTRANS
ACV-ACTIVITY-GRP→ATN-ACTIVITY-GRP
ACV-ACTIVITY→ATN-ACTIVITY
—→ATN-ACCT-CATEGORY
—→ATN-POSTING-DATE
—→ATN-OBJ-ID
Acu Act CurrACCUAMT
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 1ACCUAMT
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 2ACCUAMT
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
AcvhistbegdtACHISTORY
ACV-ACTIVITY→HST-ACTIVITY
14→HST-FIELD-ID
—→HST-DATE-STAMP
—→HST-SEQ-NBR
AcvhistenddtACHISTORY
ACV-ACTIVITY→HST-ACTIVITY
15→HST-FIELD-ID
—→HST-DATE-STAMP
—→HST-SEQ-NBR
AracpivotARACPIVOT
ACV-ACTIVITY→CCP-ACTIVITY
—→CCP-DUE-DATE
—→CCP-TRANS-TYPE
—→CCP-BATCH-NBR
—→CCP-TRANSACTION
—→CCP-PAYMENT-SEQ
—→CCP-COMPANY
Atnset4ACTRANS
ACV-ACTIVITY→ATN-ACTIVITY
—→ATN-ACCT-CATEGORY
—→ATN-FISCAL-YEAR
—→ATN-PERIOD
—→ATN-OBJ-ID
BillableACTRANS
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
ChildrenACACTIVITY
ACV-ACTIVITY→ACV-PARENT-ACTV
—→ACV-ACTIVITY
Csl Bud BaseACCONSOL
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 1ACCONSOL
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 2ACCONSOL
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 Cur1ACCONSOL
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 Cur2ACCONSOL
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
GmcostshrGMCOSTSHR
ACV-ACTIVITY→GMO-ACTIVITY
—→GMO-CS-ACTIVITY
Gmcostshr PostGMCOSTSHR
ACV-ACTIVITY→GMO-CS-ACTIVITY
—→GMO-ACTIVITY
GmdelivGMDELIV
ACV-ACTIVITY→GLV-ACTIVITY
—→GLV-DELIV-CODE-DE
GmlabdistxGMLABDISTX
ACV-ACTIVITY→GMA-ACTIVITY
—→GMA-ACCT-CATEGORY
—→GMA-COMPANY
—→GMA-ACCT-UNIT
—→GMA-ACCOUNT
—→GMA-EFFECT-DATE
—→GMA-GML-OBJ-ID
—→GMA-OBJ-ID
Gmpginc PostGMPGMINC
ACV-ACTIVITY→GMQ-PI-ACTIVITY
—→GMQ-ACTIVITY
GmpgmincGMPGMINC
ACV-ACTIVITY→GMQ-ACTIVITY
—→GMQ-PI-ACTIVITY
GmprotocolGMPROTOCOL
ACV-ACTIVITY→GMM-ACTIVITY
—→GMM-PROT-CODE-PC
—→GMM-PROTOCOL-NBR
—→GMM-EXPIRE-DATE
GmretdistxGMRETDISTX
ACV-ACTIVITY→GMH-ACTIVITY
—→GMH-ACCT-CATEGORY
—→GMH-COMPANY
—→GMH-ACCT-UNIT
—→GMH-ACCOUNT
—→GMH-SUB-ACCOUNT
—→GMH-GMI-OBJ-ID
—→GMH-OBJ-ID
GmtranefrtGMTRANEFRT
ACV-ACTIVITY→GEF-ACTIVITY
—→GEF-ACCT-CATEGORY
—→GEF-OBJ-ID
HistastasgnACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"A"→RSH-RESOURCE-TYPE
440→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HistastroleACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"A"→RSH-RESOURCE-TYPE
441→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HistempasgnACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"E"→RSH-RESOURCE-TYPE
420→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HistemproleACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"E"→RSH-RESOURCE-TYPE
421→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HisteqpasgnACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"Q"→RSH-RESOURCE-TYPE
450→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HisteqproleACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"Q"→RSH-RESOURCE-TYPE
451→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HistperasgnACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"P"→RSH-RESOURCE-TYPE
410→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HistperroleACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"P"→RSH-RESOURCE-TYPE
411→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HistvenasgnACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"V"→RSH-RESOURCE-TYPE
430→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
HistvenroleACRESHIST
ACV-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ACV-ACTIVITY→RSH-ACTIVITY
"V"→RSH-RESOURCE-TYPE
431→RSH-FIELD-ID
—→RSH-COMPANY
—→RSH-RESOURCE-CODE
—→RSH-SEQ-NUMBER
Member In ListMXLISTMBR
"ACTVY"→MLM-OBJ-TYPE
ACV-OBJ-ID→MLM-OBJ-ID
—→MLM-MATRIX-LIST
MxlisthdrMXLISTHDR
"ACTVY"→MLH-OBJ-TYPE
—→MLH-MATRIX-LIST
Pr AccommitACCOMMIT
ACV-ACTIVITY-GRP→MIT-ACTIVITY-GRP
ACV-ACTIVITY→MIT-ACTIVITY
"PR"→MIT-SYSTEM
—→MIT-COMPANY
—→MIT-CURRENCY-CODE
—→MIT-ACCT-CATEGORY
—→MIT-FISCAL-YEAR
—→MIT-PERIOD
Tot Child BaseACTOTBAL
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 Cur1ACTOTBAL
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 Cur2ACTOTBAL
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 BaseACTOTBAL
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 Cur1ACTOTBAL
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 Cur2ACTOTBAL
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

Programs

Updated by (136)

Referenced by (548)