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.

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
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
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
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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ACVSET1ACTIVITYPrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC03.2, AC03.3, AC03.4 +22 more (list truncated in source)
ACVSET2ACTIVITY-GRP, ACTIVITYKeyChangeAC00.1, AC01.1, AC10.1, AC10.5, AC105, AC110, AC112, AC113 +22 more (list truncated in source)
ACVSET3COMPANY, ACTIVITYKeyChangeAC12.1
ACVSET4ACTIVITY-GRP, LEVEL-DEPTH, VAR-LEVELS*, ACTIVITYKeyChangeAC01.1, AC10.1, AC560
ACVSET6OBJ-IDAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)
ACVSET7PARENT-ACTV, ACTIVITYKeyChange—
ACVSET8ACTIVITY-GRP, VAR-LEVELSKeyChange, SubsetWhere (VAR-LEVELS != Spaces)AC01.1, AC10.1, AC10.5, AC11.1, AC110, AC112, AC113, AC12.1 +22 more (list truncated in source)

Relations

One to one (18) — lookups and parents

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

One to many (91) — child tables

RelationTableRulesConditionField map
AcacctcatxACACCTCATXACV-ACTIVITY-GRP → AXX-ACTIVITY-GRP, ACV-ACTIVITY → AXX-ACTIVITY, → AXX-ACCT-CATEGORY
Acacctcatxset2ACACCTCATXACV-ACTIVITY-GRP → AXX-ACTIVITY-GRP, → AXX-ACCT-CATEGORY, → AXX-ACTIVITY
AcacresrtxACACRESRTXACV-ACTIVITY-GRP → CRX-ACTIVITY-GRP, ACV-ACTIVITY → CRX-ACTIVITY, → CRX-RESOURCE-TYPE, → CRX-RESOURCE-CODE, → CRX-COMPANY, → CRX-EFFECTIVE-DATE
Acacresrtx GrpACACRESRTXACV-ACTIVITY-GRP → CRX-ACTIVITY-GRP, Spaces → CRX-ACTIVITY, → CRX-RESOURCE-TYPE, → CRX-RESOURCE-CODE, → CRX-COMPANY, → CRX-EFFECTIVE-DATE
AcactmxvalACACTMXVALACV-OBJ-ID → AJV-OBJ-ID, → AJV-MATRIX-CAT
AcactmxvdtACACTMXVDTACV-OBJ-ID → MXD-OBJ-ID, → MXD-MATRIX-CAT, → MXD-EFFECTIVE-DATE
AcaddassgnACADDASSGNACV-ACTIVITY → AAS-ACTIVITY, → AAS-ADDRESS-CODE
AcamcodeACAMCODEACV-ACTIVITY → MCD-ACTIVITY, → MCD-ACCT-CATEGORY
Acamcode 1ACAMCODEACV-ACTIVITY → MCD-ACTIVITY, → MCD-ACCT-CATEGORY
AcasnroleACASNROLEACV-ACTIVITY-GRP → ALE-ACTIVITY-GRP, ACV-ACTIVITY → ALE-ACTIVITY, → ALE-RESOURCE-TYPE, → ALE-COMPANY, → ALE-RESOURCE-CODE, → ALE-ROLE
AcassignACASSIGNACV-ACTIVITY-GRP → AAN-ACTIVITY-GRP, ACV-ACTIVITY → AAN-ACTIVITY, → AAN-COMPANY, → AAN-RESOURCE-TYPE, → AAN-RESOURCE-CODE
AcauditACAUDITACV-ACTIVITY → AUD-ACTIVITY, → AUD-PROCESS-DATE, → AUD-PROCESS-TIME, → AUD-COPY-FR-AG, → AUD-COPY-TO-AG, → AUD-REORG-OR-COPY
AcbillxACBILLXACV-ACTIVITY → AIX-ACTIVITY, → AIX-SUM-ACCT-CAT, → AIX-CTR-CAT-GRP, → AIX-ACCT-CATEGORY
AcblratexACBLRATEXACV-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
AcbrdnblrxACBRDNBLRXACV-ACTIVITY → BRX-ACTIVITY, → BRX-BURDEN-CD, → BRX-BURDEN-TYPE, → BRX-POOL-NBR, → BRX-EFFECTIVE-DATE
AcbrdndtlACBRDNDTLACV-ACTIVITY-GRP → BRD-ACTIVITY-GRP, ACV-ACTIVITY → BRD-ACTIVITY, → BRD-ACCT-CATEGORY, → BRD-BURDEN-CD, → BRD-POOL-NBR
AcbudhdrACBUDHDRACV-ACTIVITY-GRP → BDH-ACTIVITY-GRP, ACV-ACTIVITY → BDH-ACTIVITY, → BDH-BUDGET-NBR
AccatsumACCATSUMACV-STRUCTURE → SRS-STRUCTURE, → SRS-SUM-ACCT-CAT
AccatsumxACCATSUMXACV-STRUCTURE → SRX-STRUCTURE, → SRX-ACCT-CATEGORY
AcceilingxACCEILINGXACV-ACTIVITY → CEX-ACTIVITY, → CEX-ACCT-CATEGORY, → CEX-SUM-ACCT-CAT, → CEX-CTR-CAT-GRP, → CEX-MATRIX-CAT, → CEX-MX-VALUE
Acchgord AllACCHGORDERACV-ACTIVITY-GRP → CHO-ACTIVITY-GRP, ACV-ACTIVITY → CHO-ACTIVITY, → CHO-BUDGET-NBR, → CHO-CHG-ORDER-NBR
AcchgorderACCHGORDERACV-ACTIVITY-GRP → CHO-ACTIVITY-GRP, ACV-ACTIVITY → CHO-ACTIVITY, ACV-ACTIVE-BUD → CHO-BUDGET-NBR, → CHO-CHG-ORDER-NBR
AccntractxACCNTRACTXACV-ACTIVITY → CNX-ACTIVITY, → CNX-CONTRACT
AccommitACCOMMITACV-ACTIVITY-GRP → MIT-ACTIVITY-GRP, ACV-ACTIVITY → MIT-ACTIVITY, → MIT-ACCT-CATEGORY, → MIT-FISCAL-YEAR, → MIT-PERIOD, → MIT-SYSTEM, → MIT-COMPANY, → MIT-CURRENCY-CODE
AcconsolACCONSOLACV-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 AllbudACCUAMTACV-ACTIVITY-GRP → ACU-ACTIVITY-GRP, ACV-ACTIVITY → ACU-ACTIVITY, → ACU-CURRENCY-CODE, → ACU-BUDGET-NBR, → ACU-ACCT-CATEGORY, → ACU-FISCAL-YEAR
AcglacctACGLACCTACV-ACTIVITY-GRP → AGA-ACTIVITY-GRP, ACV-ACTIVITY → AGA-ACTIVITY, → AGA-ACCT-CATEGORY, → AGA-SEQ-NUMBER
Acglacct AllACGLACCTACV-ACTIVITY-GRP → AGA-ACTIVITY-GRP, Spaces → AGA-ACTIVITY, → AGA-ACCT-CATEGORY, → AGA-SEQ-NUMBER
AcglconslACGLCONSLACV-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
AcglmastACGLMASTACV-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
AcgltotrevACGLTOTREVACV-ACTIVITY → GRV-ACTIVITY, → GRV-ACCT-CATEGORY, → GRV-COMPANY, → GRV-ACCT-UNIT
AchistoryACHISTORYACV-ACTIVITY → HST-ACTIVITY, → HST-FIELD-ID, → HST-DATE-STAMP, → HST-SEQ-NBR
AcmasterACMASTERACV-ACTIVITY-GRP → MST-ACTIVITY-GRP, ACV-ACTIVITY → MST-ACTIVITY, → MST-ACCT-CATEGORY, → MST-FISCAL-YEAR
AcmilestnACMILESTNACV-ACTIVITY → MLS-ACTIVITY, → MLS-MILESTONE-CAT
AcmilestnxACMILESTNXACV-ACTIVITY → MLX-ACTIVITY, → MLX-MILESTONE-CAT, → MLX-MILESTONE
AcperccmplACPERCCMPLACV-ACTIVITY → PEC-ACTIVITY, → PEC-RECORD-TYPE, → PEC-BUDGET-TYPE, → PEC-DATE
AcpercmplxACPERCMPLXACV-ACTIVITY → PEX-ACTIVITY, → PEX-RECORD-TYPE, → PEX-BUDGET-TYPE, → PEX-ACCT-CATEGORY, → PEX-DATE
AcprdperfACPRDPERFACV-ACTIVITY-GRP → PFM-ACTIVITY-GRP, ACV-ACTIVITY → PFM-ACTIVITY, → PFM-SYSTEM, → PFM-SEQ-NUMBER
AcreshistACRESHISTACV-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
AcretainACRETAINACV-ACTIVITY → RET-ACTIVITY, → RET-RETAIN-ID
AcretngACRETNGACV-ACTIVITY → RTG-ACTIVITY, → RTG-SUM-ACCT-CAT, → RTG-CTR-CAT-GRP, → RTG-ACCT-CATEGORY
Actotbal BaseACTOTBALACV-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 Cur1ACTOTBALACV-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 Cur2ACTOTBALACV-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 CommitACTRANSACV-ACTIVITY-GRP → ATN-ACTIVITY-GRP, ACV-ACTIVITY → ATN-ACTIVITY, → ATN-ACCT-CATEGORY, → ATN-POSTING-DATE, → ATN-OBJ-ID
Actrans ErrorACTRANSACV-ACTIVITY-GRP → ATN-ACTIVITY-GRP, ACV-ACTIVITY → ATN-ACTIVITY, → ATN-ACCT-CATEGORY, → ATN-POSTING-DATE, → ATN-OBJ-ID
Actrans HistACTRANSACV-ACTIVITY → ATN-ACTIVITY, → ATN-ACCT-CATEGORY, → ATN-FISCAL-YEAR, → ATN-PERIOD, → ATN-OBJ-ID
Actrans PostedACTRANSACV-ACTIVITY → ATN-ACTIVITY, → ATN-ACCT-CATEGORY, → ATN-FISCAL-YEAR, → ATN-PERIOD, → ATN-OBJ-ID
Actrans ReleasACTRANSACV-ACTIVITY-GRP → ATN-ACTIVITY-GRP, ACV-ACTIVITY → ATN-ACTIVITY, → ATN-ACCT-CATEGORY, → ATN-POSTING-DATE, → ATN-OBJ-ID
Acu Act CurrACCUAMTACV-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 1ACCUAMTACV-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 2ACCUAMTACV-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
AcvhistbegdtACHISTORYACV-ACTIVITY → HST-ACTIVITY, 14 → HST-FIELD-ID, → HST-DATE-STAMP, → HST-SEQ-NBR
AcvhistenddtACHISTORYACV-ACTIVITY → HST-ACTIVITY, 15 → HST-FIELD-ID, → HST-DATE-STAMP, → HST-SEQ-NBR
AracpivotARACPIVOTACV-ACTIVITY → CCP-ACTIVITY, → CCP-DUE-DATE, → CCP-TRANS-TYPE, → CCP-BATCH-NBR, → CCP-TRANSACTION, → CCP-PAYMENT-SEQ, → CCP-COMPANY
Atnset4ACTRANSACV-ACTIVITY → ATN-ACTIVITY, → ATN-ACCT-CATEGORY, → ATN-FISCAL-YEAR, → ATN-PERIOD, → ATN-OBJ-ID
BillableACTRANSACV-ACTIVITY → ATN-ACTIVITY, → ATN-ACCT-CATEGORY, → ATN-TRAN-CURRENCY, → ATN-UNIT-MEASURE, → ATN-MATRIX-CAT, → ATN-MX-VALUE, → ATN-POSTING-DATE, → ATN-OBJ-ID
ChildrenACACTIVITYACV-ACTIVITY → ACV-PARENT-ACTV, → ACV-ACTIVITY
Csl Bud BaseACCONSOLACV-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 1ACCONSOLACV-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 2ACCONSOLACV-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 Cur1ACCONSOLACV-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 Cur2ACCONSOLACV-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
GmcostshrGMCOSTSHRACV-ACTIVITY → GMO-ACTIVITY, → GMO-CS-ACTIVITY
Gmcostshr PostGMCOSTSHRACV-ACTIVITY → GMO-CS-ACTIVITY, → GMO-ACTIVITY
GmdelivGMDELIVACV-ACTIVITY → GLV-ACTIVITY, → GLV-DELIV-CODE-DE
GmlabdistxGMLABDISTXACV-ACTIVITY → GMA-ACTIVITY, → GMA-ACCT-CATEGORY, → GMA-COMPANY, → GMA-ACCT-UNIT, → GMA-ACCOUNT, → GMA-EFFECT-DATE, → GMA-GML-OBJ-ID, → GMA-OBJ-ID
Gmpginc PostGMPGMINCACV-ACTIVITY → GMQ-PI-ACTIVITY, → GMQ-ACTIVITY
GmpgmincGMPGMINCACV-ACTIVITY → GMQ-ACTIVITY, → GMQ-PI-ACTIVITY
GmprotocolGMPROTOCOLACV-ACTIVITY → GMM-ACTIVITY, → GMM-PROT-CODE-PC, → GMM-PROTOCOL-NBR, → GMM-EXPIRE-DATE
GmretdistxGMRETDISTXACV-ACTIVITY → GMH-ACTIVITY, → GMH-ACCT-CATEGORY, → GMH-COMPANY, → GMH-ACCT-UNIT, → GMH-ACCOUNT, → GMH-SUB-ACCOUNT, → GMH-GMI-OBJ-ID, → GMH-OBJ-ID
GmtranefrtGMTRANEFRTACV-ACTIVITY → GEF-ACTIVITY, → GEF-ACCT-CATEGORY, → GEF-OBJ-ID
HistastasgnACRESHISTACV-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
HistastroleACRESHISTACV-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
HistempasgnACRESHISTACV-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
HistemproleACRESHISTACV-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
HisteqpasgnACRESHISTACV-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
HisteqproleACRESHISTACV-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
HistperasgnACRESHISTACV-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
HistperroleACRESHISTACV-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
HistvenasgnACRESHISTACV-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
HistvenroleACRESHISTACV-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 AccommitACCOMMITACV-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 BaseACTOTBALACV-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 Cur1ACTOTBALACV-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 Cur2ACTOTBALACV-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 BaseACTOTBALACV-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 Cur1ACTOTBALACV-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 Cur2ACTOTBALACV-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)