ACACTIVITY

Activity

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.

REFERENCED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC03.7
ACAC.1 ACSB.1 ACSR.1 AM18.2 AP125 AP126
AP131 AP170 AP178 AP190 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP237 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP520 AP95.3 API1.1 API2.1
BN150 BN66.1 CB10.1 CB15.1 CB15.2 CB150
CB180 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 CB80.1
CB82.1 EE11.1 EE135 EE20.3 EE35.1 EE35.2
EE520 GL146 GL165 GL170 GL197 GL199
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL50.4 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 GL90.3 GL93.2 RW50.1 HCHP.1
PR521 EX175 EX542 EX545 EXI2.1 EXI4.1
IFEB.1 IFGT.1 IFUC.1 LP130 LP140 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PA182 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POIF.1
POIG.1 POII.1 POIJ.1 PR128 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR140
PR189 PR195 PR197 PR29.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR38.1 PR45.1 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 PR85.1 PR89.1
UK102 UK330 UK560 TA147 MX202 MX223


UPDATED BY
AC00.1 AC10.1 AC10.5 AC10.6 AC200 AC210
ACVW.1 AP211 GL299 HACV.1 MX123 MX500
HS36.1 SN02.1 SNAC.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACV-ACTIVITY
Element: Activity
Alpha 15
Activities 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
ACV-DESCRIPTION
Element: Activity Description
Alpha 30 (Lower Case)
This is the activity description.
AC10.1
ACV-ACTIVITY-GRP
Element: Activity Group
Alpha 15
This is the activity group for the activity.
AC10.1
ACV-CONTRACT
Element: Contract
Alpha 15
If 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.
ACV-COMPANY
Element: Company
Numeric 4
This 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
ACV-ACCT-UNIT
Element: Accounting Unit
Alpha 15
This 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
ACV-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AC10.1
ACV-SUB-ACCT
Element: Subaccount
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AC10.1
ACV-ACCT-CATEGORY
Element: Account Category
Alpha 5
This 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
ACV-CURRENCY-CODE
Element: Currency Code
Alpha 5
This is the company currency code.
AC10.1
ACV-USR-STATUS
Element: Status
Alpha 2
This 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
ACV-VAR-LEVELS
Element: Variable Levels
Alpha 30
Levels 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
ACV-VAR-LEVEL-DISP
Variable Level
Display
Alpha 34
This 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
ACV-BEGIN-DATE
Element: 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
ACV-END-DATE
Element: 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
ACV-ACTIVE-BUD
Element: Active Budget
Numeric 3
This 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).
ACV-LONG-DESC
Element: Long Description
Alpha 60 (Lower Case)
Occurs 4 Times
This is the long description of the activity.
AC10.1
ACV-ESTIMATE
Element: Estimate
Signed 18.2
This is a budget estimate for the activity. This estimate is informational only.
AC10.1
ACV-OBJ-ID
Element: Activity Object ID
Numeric 12
This 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
ACV-PARENT-ACTV
Element: Parent Actv
Alpha 15
The parent activity field contains the activity name of the member parent.
AC10.1
ACV-ACTIVITY-ND
Activity Curr Nbr
of Decimals
Numeric 1
This is the number of decimal positions defined for the activity currency.
AC10.1
ACV-HIGH-PST-DATE
Element: Highest Posting Date
Numeric 8 (yyyymmdd)
This is the latest posting date for transactions posted to the activity.
ACV-BALANCE-AMOUNT
Element: Balance Amount
Signed 18.2
This is the amount balance for the life-to-date activity actuals amount.
ACV-BALANCE-UNIT
Element: Units Balance
Signed 17.2
This is the unit balance for the activity actuals.
ACV-SHORT-DESC
Element: Short Description
Derived
This is the short description of the activity.
ACV-BILLABLE-FLAG
Element: Billable Flag
Alpha 1
This 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
ACV-SECURITY-CD
Element: Security Cd
Numeric 4
This field contains the security code for the activity.
AC00.1 AC10.1
ACV-POST-OR-GLONLY
Element: Post Or Glonly
Derived
ACV-OUTPUT-MEASURE
Element: Intl Amt
Signed 18.2
This is the output measurement.
AC10.1
ACV-OUTPUT-DESC
Element: Output Desc
Alpha 30
This is the output description.
AC10.1
ACV-SEGMENT-FLAG
Element: Segment Flag
Alpha 1
Indicates whether user analysis values (SL segment) have been populated for the distribution line.
AC10.1
ACV-GRP-CURR-CODE1
Element: Grp Curr Code1
Derived
ACV-GRP-CURR-CODE2
Element: Grp Curr Code2
Derived
ACV-ACT-SEG-BLOCK
Element: Act Seg Block
Derived
ACV-BILL-WBS-CODE
Element: Bill Wbs Code
Alpha 3
AC10.1
ACV-LOCATION-NAME
Element: Location Name
Alpha 15
A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.
AC10.1
ACV-DIVISION
Element: Division
Alpha 15
A user-defined division which is used for reporting assets.
AC10.1
ACV-POP-FLAG
Element: Pop Flag
Alpha 1
Period 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
ACV-AWARD-FLAG
Element: Award Flag
Alpha 1
Flag 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
ACV-EFFORT-FLAG
Element: Effort Flag
Alpha 1
Flag 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
ACV-SALARY-CAP-FL
Element: Salary Cap Fl
Alpha 1
This 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
ACV-FRNG-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
AC10.1
ACV-FRNG-ACCT-CAT
Element: Frng Acct Cat
Alpha 5
A 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
ACV-FRNG-ACCOUNT
Element: Frng Account
Numeric 6
A 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
ACV-FRNG-SUB-ACCT
Element: Frng Sub Acct
Numeric 4
A 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
ACV-SALARY-CAP-AMT
Element: Intl Amt
Signed 18.2
Salary cap amount for the activity. It is assummed to be in the activity currency.
ACV-STRUCTURE
Element: Structure
Alpha 15
The name of the category structure. This represents the category structure assigned to the activity.
AC10.1
ACV-BILL-REV-FLAG
Element: Bill Rev Flag
Alpha 1

Y = Yes
N = No
AC10.1
ACV-BACKOUT-STATUS
Element: Backout Status
Alpha 1

Y = Yes
N = No
AC10.1 AC10.5
ACV-PAR-ACT-STRCT
Element: Parent Actv
Alpha 15 Occurs 4 Times
This field will contain the parent of the Activity at each variable level in the Activity Groups hierarchy.
AC10.1
ACV-POSTING-FLAG
Element: Posting Flag
Alpha 1

P = Posting
S = Summary
C = Contract
AC10.1
ACV-LEVEL-DEPTH
Element: Level Depth
Numeric 1
The number of variable levels pertaining to this record.
AC10.1
ACV-LEVEL-DETAIL
Element: Level Detail
Numeric 15 Occurs 5 Times
AC10.1
ACV-BUDGET-EDIT
Element: Budget Edit
Alpha 1

1 = No Edit
2 = Period Edit
3 = Annual Edit
4 = Total Edit
AC10.1
ACV-BUDGET-LEVEL
Element: Budget Level
Alpha 1

1 = Activity-Acct Cat
3 = Activity
4 = Activity-Summary Account Cat
5 = Contract Funding
AC10.1
ACV-BUD-TOLERANCE
Element: Bud Tolerance
Signed 5.2
AC10.1
ACV-SCHEDULE
Element: Schedule
Alpha 9
Stores 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
ACV-CURRENT-CAP
Element: Flag
Alpha 1
Determines 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
ACV-CAP-ACTIVITY
Element: Activity
Alpha 15
Identifies 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
ACV-CAP-ACCT-CAT
Element: Acct Category
Alpha 5
Valid 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
ACV-CAP-COMPANY
Element: Company
Numeric 4
Identifies 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
ACV-CAP-ACCT-UNIT
Element: Acct Unit
Alpha 15
Identifies 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
ACV-CAP-ACCOUNT
Element: Account
Numeric 6
Identifies 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
ACV-CAP-SUB-ACCT
Element: Sub Acct
Numeric 4
Identified 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
ACV-CAP-SEG-FLAG
Element: Segment Flag
Alpha 1
Identifies 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
ACV-DATE-CREATED
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AC10.1


ACACTIVITY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACVSET1 ACTIVITY
...
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC03.7
AC10.1 AC10.2
AC10.3 AC10.5
AC10.6 AC200
AC210 ACAC.1
ACSB.1 ACSR.1
ACVW.1 AM18.2
AP125 AP126
AP131 AP170
AP178 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
ACVSET2 ACTIVITY-GRP
ACTIVITY
KeyChange
...
AC00.1 AC10.1
AC10.5 AC200
AC210 ACAC.1
ACVW.1 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP211
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
ACVSET3 COMPANY
ACTIVITY
KeyChange
ACVSET4 ACTIVITY-GRP
LEVEL-DEPTH
VAR-LEVELS*
ACTIVITY
KeyChange
AC10.1
ACVSET6 OBJ-ID
AC200 AC210
ACVW.1 AP211
GL299 MX123
MX202 MX223
MX500 SN02.1
SNAC.1
ACVSET7 PARENT-ACTV
ACTIVITY
KeyChange
ACVSET8 ACTIVITY-GRP
VAR-LEVELS
KeyChange, Subset
Where(VAR-LEVELS !=Spaces)
...
AC10.1 AC10.5
AC200 AC210
ACAC.1 ACVW.1
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP211 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 CB10.1


ACACTIVITY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
ACV-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
ACV-ACTIVITY-GRP->AGP-ACTIVITY-GRP
Acactseg ACACTSEG Not Required
ACV-OBJ-ID->CSG-OBJ-ID
Acaddlcntr ACADDLCNTR Not Required
ACV-ACTIVITY-GRP->ADN-ACTIVITY-GRP
CNT-CONTRACT->ADN-CONTRACT
Acbill ACBILL Not Required
ACV-ACTIVITY->ACI-ACTIVITY
Acbudhdr Set1 ACBUDHDR Not Required
Valid When ACV-ACTIVE-BUD !=Zeroes
ACV-ACTIVITY-GRP->BDH-ACTIVITY-GRP
ACV-ACTIVITY->BDH-ACTIVITY
ACV-ACTIVE-BUD->BDH-BUDGET-NBR
Accntract ACCNTRACT Not Required
ACV-CONTRACT->CNT-CONTRACT
Accustomer ACCUSTOMER Not Required
CNT-COMPANY->CMR-COMPANY
CNT-CUSTOMER->CMR-CUSTOMER
CNT-AC-CUSTOMER-ID->CMR-AC-CUSTOMER-ID
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
Gmaward GMAWARD Not Required
ACV-ACTIVITY->GMG-ACTIVITY
Gmsalcap GMSALCAP Not Required
ACV-SCHEDULE->GMC-SCHEDULE
ACV-CURRENCY-CODE->GMC-CURRENCY-CODE
Object Id OBJID Not Required
"ACTVY"->OBI-OBJ-TYPE
Parent ACACTIVITY Not Required
ACV-PARENT-ACTV->ACV-ACTIVITY
Structure STRUCTURE Required
ACV-STRUCTURE->SRE-STRUCTURE


ACACTIVITY FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcatx ACACCTCATX
ACV-ACTIVITY-GRP->AXX-ACTIVITY-GRP
ACV-ACTIVITY->AXX-ACTIVITY
  AXX-ACCT-CATEGORY
Acacctcatxset2 ACACCTCATX
ACV-ACTIVITY-GRP->AXX-ACTIVITY-GRP
  AXX-ACCT-CATEGORY
  AXX-ACTIVITY
Acacresrtx ACACRESRTX
ACV-ACTIVITY-GRP->CRX-ACTIVITY-GRP
ACV-ACTIVITY->CRX-ACTIVITY
  CRX-RESOURCE-TYPE
  CRX-RESOURCE-CODE
  CRX-COMPANY
  CRX-EFFECTIVE-DATE
Acacresrtx Grp ACACRESRTX
ACV-ACTIVITY-GRP->CRX-ACTIVITY-GRP
Spaces->CRX-ACTIVITY
  CRX-RESOURCE-TYPE
  CRX-RESOURCE-CODE
  CRX-COMPANY
  CRX-EFFECTIVE-DATE
Acactmxval ACACTMXVAL
ACV-OBJ-ID->AJV-OBJ-ID
  AJV-MATRIX-CAT
Acactmxvdt ACACTMXVDT
ACV-OBJ-ID->MXD-OBJ-ID
  MXD-MATRIX-CAT
  MXD-EFFECTIVE-DATE
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
Acasnrole ACASNROLE
ACV-ACTIVITY-GRP->ALE-ACTIVITY-GRP
ACV-ACTIVITY->ALE-ACTIVITY
  ALE-RESOURCE-TYPE
  ALE-COMPANY
  ALE-RESOURCE-CODE
  ALE-ROLE
Acassign ACASSIGN
ACV-ACTIVITY-GRP->AAN-ACTIVITY-GRP
ACV-ACTIVITY->AAN-ACTIVITY
  AAN-COMPANY
  AAN-RESOURCE-TYPE
  AAN-RESOURCE-CODE
Acaudit ACAUDIT
ACV-ACTIVITY->AUD-ACTIVITY
  AUD-PROCESS-DATE
  AUD-PROCESS-TIME
  AUD-COPY-FR-AG
  AUD-COPY-TO-AG
  AUD-REORG-OR-COPY
Acbillx ACBILLX
ACV-ACTIVITY->AIX-ACTIVITY
  AIX-SUM-ACCT-CAT
  AIX-CTR-CAT-GRP
  AIX-ACCT-CATEGORY
Acblratex ACBLRATEX
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
Acbrdndtl ACBRDNDTL
ACV-ACTIVITY-GRP->BRD-ACTIVITY-GRP
ACV-ACTIVITY->BRD-ACTIVITY
  BRD-ACCT-CATEGORY
  BRD-BURDEN-CD
  BRD-POOL-NBR
Acbudhdr ACBUDHDR
ACV-ACTIVITY-GRP->BDH-ACTIVITY-GRP
ACV-ACTIVITY->BDH-ACTIVITY
  BDH-BUDGET-NBR
Accatsum ACCATSUM
ACV-STRUCTURE->SRS-STRUCTURE
  SRS-SUM-ACCT-CAT
Accatsumx ACCATSUMX
ACV-STRUCTURE->SRX-STRUCTURE
  SRX-ACCT-CATEGORY
Acceilingx ACCEILINGX
ACV-ACTIVITY->CEX-ACTIVITY
  CEX-ACCT-CATEGORY
  CEX-SUM-ACCT-CAT
  CEX-CTR-CAT-GRP
  CEX-MATRIX-CAT
  CEX-MX-VALUE
Acchgord All ACCHGORDER
ACV-ACTIVITY-GRP->CHO-ACTIVITY-GRP
ACV-ACTIVITY->CHO-ACTIVITY
  CHO-BUDGET-NBR
  CHO-CHG-ORDER-NBR
Acchgorder ACCHGORDER
ACV-ACTIVITY-GRP->CHO-ACTIVITY-GRP
ACV-ACTIVITY->CHO-ACTIVITY
ACV-ACTIVE-BUD->CHO-BUDGET-NBR
  CHO-CHG-ORDER-NBR
Accntractx ACCNTRACTX
ACV-ACTIVITY->CNX-ACTIVITY
  CNX-CONTRACT
Accommit ACCOMMIT
ACV-ACTIVITY-GRP->MIT-ACTIVITY-GRP
ACV-ACTIVITY->MIT-ACTIVITY
  MIT-ACCT-CATEGORY
  MIT-FISCAL-YEAR
  MIT-PERIOD
  MIT-SYSTEM
  MIT-COMPANY
  MIT-CURRENCY-CODE
Acconsol ACCONSOL
ACV-ACTIVITY-GRP->CSL-ACTIVITY-GRP
ACV-ACTIVITY->CSL-ACTIVITY
AGP-CURRENCY-CODE->CSL-CURRENCY-CODE
Zeroes->CSL-BUDGET-NBR
  CSL-ACCT-CATEGORY
  CSL-FISCAL-YEAR
Accuamt Allbud ACCUAMT
ACV-ACTIVITY-GRP->ACU-ACTIVITY-GRP
ACV-ACTIVITY->ACU-ACTIVITY
  ACU-CURRENCY-CODE
  ACU-BUDGET-NBR
  ACU-ACCT-CATEGORY
  ACU-FISCAL-YEAR
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
Achistory ACHISTORY
ACV-ACTIVITY->HST-ACTIVITY
  HST-FIELD-ID
  HST-DATE-STAMP
  HST-SEQ-NBR
Acmaster ACMASTER
ACV-ACTIVITY-GRP->MST-ACTIVITY-GRP
ACV-ACTIVITY->MST-ACTIVITY
  MST-ACCT-CATEGORY
  MST-FISCAL-YEAR
Acmilestn ACMILESTN
ACV-ACTIVITY->MLS-ACTIVITY
  MLS-MILESTONE-CAT
Acmilestnx ACMILESTNX
ACV-ACTIVITY->MLX-ACTIVITY
  MLX-MILESTONE-CAT
  MLX-MILESTONE
Acperccmpl ACPERCCMPL
ACV-ACTIVITY->PEC-ACTIVITY
  PEC-RECORD-TYPE
  PEC-BUDGET-TYPE
  PEC-DATE
Acpercmplx ACPERCMPLX
ACV-ACTIVITY->PEX-ACTIVITY
  PEX-RECORD-TYPE
  PEX-BUDGET-TYPE
  PEX-ACCT-CATEGORY
  PEX-DATE
Acprdperf ACPRDPERF
ACV-ACTIVITY-GRP->PFM-ACTIVITY-GRP
ACV-ACTIVITY->PFM-ACTIVITY
  PFM-SYSTEM
  PFM-SEQ-NUMBER
Acreshist ACRESHIST
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
Actotbal Base ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-ACTIVITY
AGP-CURRENCY-CODE->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Actotbal Cur1 ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-ACTIVITY
AGP-CURR-CODE-1->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Actotbal Cur2 ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-ACTIVITY
AGP-CURR-CODE-2->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Actrans Commit ACTRANS
ACV-ACTIVITY-GRP->ATN-ACTIVITY-GRP
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-POSTING-DATE
  ATN-OBJ-ID
Actrans Error ACTRANS
ACV-ACTIVITY-GRP->ATN-ACTIVITY-GRP
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-POSTING-DATE
  ATN-OBJ-ID
Actrans Hist ACTRANS
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-FISCAL-YEAR
  ATN-PERIOD
  ATN-OBJ-ID
Actrans Posted ACTRANS
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-FISCAL-YEAR
  ATN-PERIOD
  ATN-OBJ-ID
Actrans Releas ACTRANS
ACV-ACTIVITY-GRP->ATN-ACTIVITY-GRP
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-POSTING-DATE
  ATN-OBJ-ID
Acu Act Curr ACCUAMT
ACV-ACTIVITY-GRP->ACU-ACTIVITY-GRP
ACV-ACTIVITY->ACU-ACTIVITY
ACV-CURRENCY-CODE->ACU-CURRENCY-CODE
Zeroes->ACU-BUDGET-NBR
  ACU-FISCAL-YEAR
  ACU-ACCT-CATEGORY
Acu Rpt Curr 1 ACCUAMT
ACV-ACTIVITY-GRP->ACU-ACTIVITY-GRP
ACV-ACTIVITY->ACU-ACTIVITY
AGP-CURR-CODE-1->ACU-CURRENCY-CODE
Zeroes->ACU-BUDGET-NBR
  ACU-FISCAL-YEAR
  ACU-ACCT-CATEGORY
Acu Rpt Curr 2 ACCUAMT
ACV-ACTIVITY-GRP->ACU-ACTIVITY-GRP
ACV-ACTIVITY->ACU-ACTIVITY
AGP-CURR-CODE-2->ACU-CURRENCY-CODE
Zeroes->ACU-BUDGET-NBR
  ACU-FISCAL-YEAR
  ACU-ACCT-CATEGORY
Acvhistbegdt ACHISTORY
ACV-ACTIVITY->HST-ACTIVITY
14->HST-FIELD-ID
  HST-DATE-STAMP
  HST-SEQ-NBR
Acvhistenddt ACHISTORY
ACV-ACTIVITY->HST-ACTIVITY
15->HST-FIELD-ID
  HST-DATE-STAMP
  HST-SEQ-NBR
Aracpivot ARACPIVOT
ACV-ACTIVITY->CCP-ACTIVITY
  CCP-DUE-DATE
  CCP-TRANS-TYPE
  CCP-BATCH-NBR
  CCP-TRANSACTION
  CCP-PAYMENT-SEQ
  CCP-COMPANY
Atnset4 ACTRANS
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-FISCAL-YEAR
  ATN-PERIOD
  ATN-OBJ-ID
Billable ACTRANS
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-TRAN-CURRENCY
  ATN-UNIT-MEASURE
  ATN-MATRIX-CAT
  ATN-MX-VALUE
  ATN-POSTING-DATE
  ATN-OBJ-ID
Children ACACTIVITY
ACV-ACTIVITY->ACV-PARENT-ACTV
  ACV-ACTIVITY
Csl Bud Base ACCONSOL
ACV-ACTIVITY-GRP->CSL-ACTIVITY-GRP
ACV-ACTIVITY->CSL-ACTIVITY
AGP-CURRENCY-CODE->CSL-CURRENCY-CODE
  CSL-BUDGET-NBR
  CSL-ACCT-CATEGORY
  CSL-FISCAL-YEAR
Csl Bud Rpt 1 ACCONSOL
ACV-ACTIVITY-GRP->CSL-ACTIVITY-GRP
ACV-ACTIVITY->CSL-ACTIVITY
AGP-CURR-CODE-1->CSL-CURRENCY-CODE
  CSL-BUDGET-NBR
  CSL-ACCT-CATEGORY
  CSL-FISCAL-YEAR
Csl Bud Rpt 2 ACCONSOL
ACV-ACTIVITY-GRP->CSL-ACTIVITY-GRP
ACV-ACTIVITY->CSL-ACTIVITY
AGP-CURR-CODE-2->CSL-CURRENCY-CODE
  CSL-BUDGET-NBR
  CSL-ACCT-CATEGORY
  CSL-FISCAL-YEAR
Csl Cur1 ACCONSOL
ACV-ACTIVITY-GRP->CSL-ACTIVITY-GRP
ACV-ACTIVITY->CSL-ACTIVITY
AGP-CURR-CODE-1->CSL-CURRENCY-CODE
Zeroes->CSL-BUDGET-NBR
  CSL-ACCT-CATEGORY
  CSL-FISCAL-YEAR
Csl Cur2 ACCONSOL
ACV-ACTIVITY-GRP->CSL-ACTIVITY-GRP
ACV-ACTIVITY->CSL-ACTIVITY
AGP-CURR-CODE-2->CSL-CURRENCY-CODE
Zeroes->CSL-BUDGET-NBR
  CSL-ACCT-CATEGORY
  CSL-FISCAL-YEAR
Gmcostshr GMCOSTSHR
ACV-ACTIVITY->GMO-ACTIVITY
  GMO-CS-ACTIVITY
Gmcostshr Post GMCOSTSHR
ACV-ACTIVITY->GMO-CS-ACTIVITY
  GMO-ACTIVITY
Gmdeliv GMDELIV
ACV-ACTIVITY->GLV-ACTIVITY
  GLV-DELIV-CODE-DE
Gmlabdistx GMLABDISTX
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 Post GMPGMINC
ACV-ACTIVITY->GMQ-PI-ACTIVITY
  GMQ-ACTIVITY
Gmpgminc GMPGMINC
ACV-ACTIVITY->GMQ-ACTIVITY
  GMQ-PI-ACTIVITY
Gmprotocol GMPROTOCOL
ACV-ACTIVITY->GMM-ACTIVITY
  GMM-PROT-CODE-PC
  GMM-PROTOCOL-NBR
  GMM-EXPIRE-DATE
Gmretdistx GMRETDISTX
ACV-ACTIVITY->GMH-ACTIVITY
  GMH-ACCT-CATEGORY
  GMH-COMPANY
  GMH-ACCT-UNIT
  GMH-ACCOUNT
  GMH-SUB-ACCOUNT
  GMH-GMI-OBJ-ID
  GMH-OBJ-ID
Gmtranefrt GMTRANEFRT
ACV-ACTIVITY->GEF-ACTIVITY
  GEF-ACCT-CATEGORY
  GEF-OBJ-ID
Histastasgn ACRESHIST
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
Histastrole ACRESHIST
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
Histempasgn ACRESHIST
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
Histemprole ACRESHIST
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
Histeqpasgn ACRESHIST
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
Histeqprole ACRESHIST
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
Histperasgn ACRESHIST
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
Histperrole ACRESHIST
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
Histvenasgn ACRESHIST
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
Histvenrole ACRESHIST
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 List MXLISTMBR
"ACTVY"->MLM-OBJ-TYPE
ACV-OBJ-ID->MLM-OBJ-ID
  MLM-MATRIX-LIST
Mxlisthdr MXLISTHDR
"ACTVY"->MLH-OBJ-TYPE
  MLH-MATRIX-LIST
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
Tot Child Base ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-PARENT-ACTV
AGP-CURRENCY-CODE->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
  TOT-ACTIVITY
Tot Child Cur1 ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-PARENT-ACTV
AGP-CURR-CODE-1->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
  TOT-ACTIVITY
Tot Child Cur2 ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-PARENT-ACTV
AGP-CURR-CODE-2->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
  TOT-ACTIVITY
Tot Parnt Base ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-PARENT-ACTV->TOT-ACTIVITY
AGP-CURRENCY-CODE->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Tot Parnt Cur1 ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-PARENT-ACTV->TOT-ACTIVITY
AGP-CURR-CODE-1->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Tot Parnt Cur2 ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-PARENT-ACTV->TOT-ACTIVITY
AGP-CURR-CODE-2->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR


File created: Wed Jun 08 20:46:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.