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
AC108 AC131 AC18.1 AC18.2 AC18.3 AC18.4
AC18.5 AC195 AC37.1 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC42.3 AC46.1 AC46.2 AC52.1
AC520 AC54.1 AC540 AC581 AC69.1 AC71.1
AC98.1 AC98.2 ACAC.1 ACSB.1 AP125 AP126
AP131 AP170 AP178 AP190 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP520 AP95.3 API1.1 API2.1 BN150
BN66.1 BR00.1 BR00.2 BR00.3 BR123 BR124
BR21.1 BR40.1 BR40.3 BR40.4 BR41.1 BR41.4
BR42.1 BR420 BR43.1 BR45.1 BR46.1 BR46.2
BR46.3 BR46.4 BR49.1 BR51.1 BR51.2 BR515
BR516 BR52.1 BR52.2 BR52.4 BR52.5 BR53.1
BR53.2 BR55.1 BR56.1 BR70.1 BR70.2 BRIP.1
CB10.1 CB15.1 CB15.2 CB150 CB180 CB191
CB20.1 CB30.1 CB45.1 CB46.1 CB500 CB543
CB544 CB55.1 CB554 CB57.1 CB80.1 CB82.1
CX05.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.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 GL70.1
GL70.2 GL70.3 GL70.5 GL70.6 GL75.1 GL76.1
GL90.3 GL93.2 RW50.1 PR521 DR100 IC140
IC66.1 IC83.1 EX175 EX542 EX545 EXI2.1
EXI4.1 IFEB.1 IFGT.1 IFUC.1 MX202 MX223
LP130 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA65.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PA182 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO135 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO222 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POD0.1
POI3.1 POID.1 POIF.1 POIG.1 POII.1 POIJ.1
POIK.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 ZP530 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQD0.1 RQIF.1
TA147 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
ZW130 AC01.1 AC02.1 AC06.1 AC06.2 AC07.1
AC08.3 AC105 AC11.1 AC13.1 AC13.2 AC13.3
AC13.4 AC13.7 AC13.8 AC19.1 AC21.1 AC21.2
AC21.3 AC21.4 AC21.5 AC22.1 AC227 AC25.1
AC27.1 AC29.1 AC34.1 AC35.1 AC36.1 AC47.1
AC47.2 AC502 AC51.1 AC510 AC55.1 AC60.1
AC60.2 AC61.1 AC65.1 AC65.2 AC704 AC81.1
AC82.1 AC82.2 AC82.3 AC881 AC96.1 AC96.4
AC96.5 ACBA.1 ACCL.1 ACDL.1 ACDM.2 ACDM.9
ACSR.1 ACVW.1 SE10.1 AM18.2 AP237 BR01.1
BR01.2 BR03.1 BR03.2 BR03.3 BR04.1 BR05.1
BR05.2 BR05.3 BR05.4 BR05.5 BR06.1 BR12.2
BR13.1 BR14.1 BR15.2 BR18.1 BR18.2 BR18.3
BR206 BR22.1 BR254 BR54.1 BR54.2 BR54.3
BR54.4 BR570 BR65.1 BR65.2 BR65.3 BR90.1
BR96.1 GL50.4 HCHP.1 HACV.1 ML50.4 SN02.1
SNAC.1


UPDATED BY
AC00.1 AC10.1 AC10.5 AC10.6 AC110 AC112
AC113 AC12.1 AC120 AC121 AC123 AC127
AC128 AC130 AC135 AC145 AC147 AC160
AC165 AC169 AC190 AC191 AC196 AC197
AC198 AC20.4 AC20.5 AC20.7 AC200 AC203
AC206 AC207 AC210 AC213 AC218 AC220
AC225 AC240 AC246 AC247 AC256 AC261
AC265 AC290 AC295 AC297 AC298 AC30.3
AC300 AC310 AC311 AC32.1 AC346 AC400
AC401 AC410 AC412 AC420 AC421 AC440
AC45.1 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC50.1 AC500 AC527
AC56.1 AC560 AC580 AC583 AC90.1 AC90.2
AC90.4 AC90.6 AC90.8 AC92.1 AC92.2 AC92.4
AC92.6 AC93.1 AC93.2 AC93.3 AC93.4 AC93.5
AC94.1 AC94.2 AC94.4 AC94.6 AC95.1 AC95.2
AC95.4 AC95.6 AC97.1 AC97.2 AC97.4 AC97.6
ACDR.1 SE90.1 AP211 ARLL.1 BR02.1 BR10.1
BR10.9 BR120 BR121 BR122 BR130 BR131
BR140 BR142 BR145 BR151 BR152 BR153
BR154 BR155 BR156 BR157 BR165 BR19.1
BR19.2 BR190 BR20.9 BR200 BR202 BR204
BR205 BR210 BR212 BR215 BR220 BR245
BR251 BR252 BR253 BR265 BR300 BR400
BR405 BR422 BR430 BR44.1 BR450 BR521
BR530 BR580 GL299 MX123 MX500 HS36.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 AC110
AC197 AC198
AC500 AC540
AC90.2 AC90.4
AC90.6 AC90.8
AC95.2
ACV-DESCRIPTION
Element: Activity Description
Alpha 30 (Lower Case)
This is the activity description.
AC10.1 AC110
AC145 AC197
AC198 AC500
ACV-ACTIVITY-GRP
Element: Activity Group
Alpha 15
This is the activity group for the activity.
AC10.1 AC110
AC120 AC500
AC90.2 AC90.4
AC90.6 AC90.8
AC95.2
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.
BR10.1 BR10.9
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 AC110
AC113 AC500
AC540
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC500
ACV-CURRENCY-CODE
Element: Currency Code
Alpha 5
This is the company currency code.
AC10.1 AC110
AC197 AC198
AC500
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 AC110
AC112 AC12.1
AC500
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 AC110
AC120 AC500
AC90.2 AC90.4
AC90.6 AC90.8
AC95.2
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 AC110
AC120 AC197
AC198 AC500
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 AC110
AC500
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 AC110
AC113 AC500
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).
AC110 AC127
AC20.7
ACV-LONG-DESC
Element: Long Description
Alpha 60 (Lower Case)
Occurs 4 Times
This is the long description of the activity.
AC10.1 AC110
AC500
ACV-ESTIMATE
Element: Estimate
Signed 18.2
This is a budget estimate for the activity. This estimate is informational only.
AC10.1 AC110
AC500
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 AC110
AC197 AC198
AC500
ACV-PARENT-ACTV
Element: Parent Actv
Alpha 15
The parent activity field contains the activity name of the member parent.
AC10.1 AC110
AC120 AC500
ACV-ACTIVITY-ND
Activity Curr Nbr
of Decimals
Numeric 1
This is the number of decimal positions defined for the activity currency.
AC10.1 AC110
AC145 AC197
AC198 AC500
ACV-HIGH-PST-DATE
Element: Highest Posting 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
Element: Balance Amount
Signed 18.2
This is the amount balance for the life-to-date activity actuals amount.
AC110 AC300
ACDR.1
ACV-BALANCE-UNIT
Element: Units Balance
Signed 17.2
This is the unit balance for the activity actuals.
AC110 AC300
ACDR.1
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 AC110
AC120 AC197
AC198 AC500
ACV-SECURITY-CD
Element: Security Cd
Numeric 4
This field contains the security code for the activity.
AC00.1 AC10.1
AC110 AC120
AC500
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 AC500
ACV-OUTPUT-DESC
Element: Output Desc
Alpha 30
This is the output description.
AC10.1 AC500
ACV-SEGMENT-FLAG
Element: Segment Flag
Alpha 1
Indicates whether user analysis values (SL segment) have been populated for the distribution line.
AC10.1 AC110
AC500
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 AC500
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 AC110
AC120
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
ACV-FRNG-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
AC10.1 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC500
ACV-BILL-REV-FLAG
Element: Bill Rev Flag
Alpha 1

Y = Yes
N = No
AC10.1 AC120
BR120 BR122
BR130 BR140
BR521 BR530
ACV-BACKOUT-STATUS
Element: Backout Status
Alpha 1

Y = Yes
N = No
AC10.1 AC10.5
AC120 BR140
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 AC110
AC120 AC500
ACV-POSTING-FLAG
Element: Posting Flag
Alpha 1

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

1 = No Edit
2 = Period Edit
3 = Annual Edit
4 = Total Edit
AC10.1 AC110
AC113 AC500
ACV-BUDGET-LEVEL
Element: 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
Element: Bud Tolerance
Signed 5.2
AC10.1 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
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 AC110
AC113 AC500
ACV-DATE-CREATED
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AC10.1 AC110
AC500


ACACTIVITY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACVSET1 ACTIVITY
...
AC01.1 AC02.1
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC03.7
AC06.1 AC06.2
AC07.1 AC08.3
AC10.1 AC10.2
AC10.3 AC10.5
AC10.6 AC105
AC108 AC11.1
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC127
AC128 AC13.1
ACVSET2 ACTIVITY-GRP
ACTIVITY
KeyChange
...
AC00.1 AC01.1
AC10.1 AC10.5
AC105 AC110
AC112 AC113
AC12.1 AC120
AC121 AC123
AC128 AC13.3
AC130 AC135
AC145 AC147
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC20.5 AC20.8
AC200 AC203
ACVSET3 COMPANY
ACTIVITY
KeyChange
AC12.1
ACVSET4 ACTIVITY-GRP
LEVEL-DEPTH
VAR-LEVELS*
ACTIVITY
KeyChange
AC01.1 AC10.1
AC560
ACVSET6 OBJ-ID
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.2 AC13.3
AC13.4 AC130
AC135 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC203
ACVSET7 PARENT-ACTV
ACTIVITY
KeyChange
ACVSET8 ACTIVITY-GRP
VAR-LEVELS
KeyChange, Subset
Where(VAR-LEVELS !=Spaces)
...
AC01.1 AC10.1
AC10.5 AC11.1
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC128
AC130 AC135
AC145 AC147
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC203


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
Acbrdnblrx ACBRDNBLRX
ACV-ACTIVITY->BRX-ACTIVITY
  BRX-BURDEN-CD
  BRX-BURDEN-TYPE
  BRX-POOL-NBR
  BRX-EFFECTIVE-DATE
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
Acglconsl ACGLCONSL
ACV-ACTIVITY-GRP->GCO-ACTIVITY-GRP
ACV-ACTIVITY->GCO-ACTIVITY
  GCO-ACCT-CATEGORY
  GCO-COMPANY
  GCO-ACCT-UNIT
  GCO-RESOURCE-TYPE
  GCO-RESOURCE-COMP
  GCO-RESOURCE-CODE
  GCO-FISCAL-YEAR
Acglmast ACGLMAST
ACV-ACTIVITY-GRP->GMT-ACTIVITY-GRP
ACV-ACTIVITY->GMT-ACTIVITY
  GMT-ACCT-CATEGORY
  GMT-COMPANY
  GMT-ACCT-UNIT
  GMT-FISCAL-YEAR
  GMT-RESOURCE-TYPE
  GMT-RESOURCE-COMP
  GMT-RESOURCE-CODE
Acgltotrev ACGLTOTREV
ACV-ACTIVITY->GRV-ACTIVITY
  GRV-ACCT-CATEGORY
  GRV-COMPANY
  GRV-ACCT-UNIT
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
Acretain ACRETAIN
ACV-ACTIVITY->RET-ACTIVITY
  RET-RETAIN-ID
Acretng ACRETNG
ACV-ACTIVITY->RTG-ACTIVITY
  RTG-SUM-ACCT-CAT
  RTG-CTR-CAT-GRP
  RTG-ACCT-CATEGORY
Actotbal Base ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-ACTIVITY
AGP-CURRENCY-CODE->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Actotbal Cur1 ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-ACTIVITY
AGP-CURR-CODE-1->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Actotbal Cur2 ACTOTBAL
ACV-ACTIVITY-GRP->TOT-ACTIVITY-GRP
ACV-ACTIVITY->TOT-ACTIVITY
AGP-CURR-CODE-2->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Actrans Commit ACTRANS
ACV-ACTIVITY-GRP->ATN-ACTIVITY-GRP
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-POSTING-DATE
  ATN-OBJ-ID
Actrans Error ACTRANS
ACV-ACTIVITY-GRP->ATN-ACTIVITY-GRP
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-POSTING-DATE
  ATN-OBJ-ID
Actrans Hist ACTRANS
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-FISCAL-YEAR
  ATN-PERIOD
  ATN-OBJ-ID
Actrans Posted ACTRANS
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-FISCAL-YEAR
  ATN-PERIOD
  ATN-OBJ-ID
Actrans Releas ACTRANS
ACV-ACTIVITY-GRP->ATN-ACTIVITY-GRP
ACV-ACTIVITY->ATN-ACTIVITY
  ATN-ACCT-CATEGORY
  ATN-POSTING-DATE
  ATN-OBJ-ID
Acu Act Curr ACCUAMT
ACV-ACTIVITY-GRP->ACU-ACTIVITY-GRP
ACV-ACTIVITY->ACU-ACTIVITY
ACV-CURRENCY-CODE->ACU-CURRENCY-CODE
Zeroes->ACU-BUDGET-NBR
  ACU-FISCAL-YEAR
  ACU-ACCT-CATEGORY
Acu Rpt Curr 1 ACCUAMT
ACV-ACTIVITY-GRP->ACU-ACTIVITY-GRP
ACV-ACTIVITY->ACU-ACTIVITY
AGP-CURR-CODE-1->ACU-CURRENCY-CODE
Zeroes->ACU-BUDGET-NBR
  ACU-FISCAL-YEAR
  ACU-ACCT-CATEGORY
Acu Rpt Curr 2 ACCUAMT
ACV-ACTIVITY-GRP->ACU-ACTIVITY-GRP
ACV-ACTIVITY->ACU-ACTIVITY
AGP-CURR-CODE-2->ACU-CURRENCY-CODE
Zeroes->ACU-BUDGET-NBR
  ACU-FISCAL-YEAR
  ACU-ACCT-CATEGORY
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: Thu Jun 09 11:03:47 2016

Home
Contact Us



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