Lawson Insight Technical Documentation |
|
ACACTIVITY
ACACTIVITY FILE
Activity
This file contains activity set-up and definition information from AC10.1
(Activity). Activities identify the actual tasks that make up an activity.
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
AC01.1 AC02.1 AC03.2 AC03.3 AC03.4 AC03.5
AC03.6 AC03.7 AC06.1 AC06.2 AC07.1 AC08.3
AC105 AC108 AC11.1 AC121 AC123 AC128
AC13.1 AC13.2 AC13.3 AC13.4 AC13.7 AC13.8
AC130 AC131 AC135 AC145 AC160 AC165
AC169 AC18.1 AC18.2 AC18.3 AC18.4 AC18.5
AC19.1 AC191 AC197 AC198 AC200 AC203
AC206 AC207 AC21.1 AC21.2 AC21.3 AC21.4
AC210 AC213 AC218 AC22.1 AC220 AC225
AC227 AC240 AC246 AC25.1 AC256 AC261
AC265 AC27.1 AC29.1 AC290 AC295 AC298
AC30.1 AC30.2 AC30.3 AC30.4 AC32.1 AC34.1
AC346 AC35.1 AC36.1 AC37.1 AC40.1 AC40.4
AC400 AC401 AC41.1 AC41.4 AC410 AC412
AC42.1 AC42.3 AC420 AC421 AC440 AC45.1
AC45.4 AC46.1 AC46.2 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC50.1
AC50.2 AC502 AC51.1 AC510 AC52.1 AC520
AC527 AC54.1 AC540 AC55.1 AC56.1 AC560
AC580 AC581 AC583 AC60.1 AC60.2 AC61.1
AC65.1 AC65.2 AC69.1 AC704 AC71.1 AC81.1
AC881 AC90.1 AC90.2 AC90.4 AC90.6 AC90.8
AC92.1 AC92.2 AC92.4 AC92.6 AC93.1 AC93.4
AC93.5 AC93.2 AC93.3 AC94.1 AC94.2 AC94.4
AC94.6 AC95.1 AC95.2 AC95.4 AC95.6 AC96.1
AC96.4 AC98.1 AC98.2 ACAC.1 ACBA.1 ACCL.1
ACDL.1 ACDM.2 ACDM.9 ACSB.1 ACSR.1 ACVW.1
SE10.1 SE90.1 AM18.2 AP125 AP126 AP131
AP170 AP178 AP190 AP193 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP211
AP23.1 AP237 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP520 AP95.3 API1.1 API2.1
AR115 AR124 AR129 AR130 AR131 AR135
AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR237
AR239 AR24.1 AR250 AR251 AR257 AR27.2
AR29.1 AR29.2 AR293 AR296 AR30.1 AR30.5
AR30.8 AR32.1 AR33.1 AR33.2 AR33.3 AR33.6
AR34.1 AR35.1 AR36.1 AR38.5 AR39.1 AR39.2
AR39.3 AR39.4 AR42.1 AR42.2 AR42.7 AR43.1
AR48.3 AR502 AR503 AR55.1 AR560 AR570
AR575 AR580 AR800 AR91.1 ARLL.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 BN150
BN66.1 BR00.1 BR00.2 BR00.3 BR01.1 BR01.2
BR02.1 BR02.2 BR02.3 BR03.1 BR03.2 BR03.3
BR04.1 BR05.1 BR05.2 BR05.3 BR05.4 BR05.5
BR06.1 BR12.2 BR121 BR123 BR124 BR13.1
BR131 BR14.1 BR142 BR145 BR15.2 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR18.1 BR18.2 BR18.3 BR19.1 BR19.2
BR190 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR20.6 BR20.7 BR20.9 BR200 BR202 BR204
BR205 BR206 BR21.1 BR210 BR212 BR215
BR22.1 BR220 BR245 BR251 BR252 BR253
BR254 BR265 BR300 BR40.1 BR40.3 BR40.4
BR400 BR405 BR41.1 BR41.4 BR42.1 BR420
BR422 BR43.1 BR430 BR44.1 BR45.1 BR450
BR46.1 BR46.2 BR46.3 BR46.4 BR51.1 BR51.2
BR515 BR516 BR52.1 BR52.2 BR52.4 BR52.5
BR53.1 BR53.2 BR54.1 BR54.2 BR54.3 BR54.4
BR55.1 BR56.1 BR570 BR580 BR65.1 BR65.2
BR65.3 BR70.1 BR70.2 BR90.1 BR96.1 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 CB80.1 CB82.1 CXCP.1
EE135 EE20.3 EE35.1 EE35.2 EE520 ET175
ET530 ET540 ET542 ETI2.1 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
HCHP.1 HACV.1 IFGT.1 MX123 MX500 LP130
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA65.1 MA66.2 MA66.3
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 PO150 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 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 POCP.1
POD0.1 POI3.1 POID.1 POIF.1 POIG.1 POII.1
POIJ.1 HS36.1 PR128 PR130 PR131 PR132
PR134 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 PR80.1 PR82.1
PR85.1 PR89.1 UK102 UK330 UK560 PW90.1
PWI2.1 RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQD0.1 RQIF.1 SB15.1 SN02.1
SNAC.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 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
ET700 MX202 MX223
UPDATED BY
AC00.1 AC10.1 AC10.5 AC10.6 AC110 AC112
AC113 AC12.1 AC120 AC127 AC190 AC20.7
AC300 AC310 AC500 ACDR.1 BR10.1 BR10.9
BR120 BR122 BR130 BR140 BR521 BR530
PW110 PW510 SB515
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACV-ACTIVITY Alpha 15 AC10.1 AC110
Element: Activity Activities are the processes or AC197 AC198
procedures that produce work. Cost AC500 AC540
objects (products, services, customers, AC90.2 AC90.4
and so on) are the reasons for AC90.6 AC90.8
performing the activity. Activities and AC95.2 ET540
cost object activities are used PW110 PW510
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.
ACV-DESCRIPTION Alpha 30 (Lower Case) AC10.1 AC110
Element: Activity DescrThis is the activity description. AC145 AC197
AC198 AC500
PW110 PW510
ACV-ACTIVITY-GRP Alpha 15 AC10.1 AC110
Element: Activity GroupThis is the activity group for the AC120 AC500
activity. AC90.2 AC90.4
AC90.6 AC90.8
AC95.2 PW110
PW510
ACV-CONTRACT Alpha 15 BR10.1 BR10.9
Element: Contract If this Activity is a Contract type, and PW110
is idetified in BR0 as the 'Contract
Activity', th name of the related
Contrct will be updated to this field.
ACV-COMPANY Numeric 4 AC10.1 AC110
Element: Company This field defines the responsible AC113 AC500
company number for the activity. The AC540 PW110
responsible company is defined in the PW510
General Ledger system. The responsible
company determines the activity
currency.
ACV-ACCT-UNIT Alpha 15 AC10.1 AC110
Element: Accounting UniThis is an accounting unit for the AC113 AC500
activity. The accounting unit is a PW110 PW510
shorthand notation representing a
location or variable level. The
accounting unit must be defined in the
General Ledger Names file as a posting
accounting unit.
ACV-ACCOUNT Numeric 6 AC10.1 AC110
Element: Account This field along with the accounting AC113 AC500
unit and subaccount make up the location PW110 PW510
(account) where amounts and other
account information is stored.
ACV-SUB-ACCT Numeric 4 AC10.1 AC110
Element: Subaccount This field contains the subaccount from AC113 AC500
your general ledger chart of accounts PW110 PW510
that was charged with the amount carried
on this record.
ACV-ACCT-CATEGORY Alpha 5 AC10.1 AC110
Element: Account CategoThis is an account category for the AC500 PW110
activity. Account categories are PW510
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 .
ACV-CURRENCY-CODE Alpha 5 AC10.1 AC110
Element: Currency Code This is the company currency code. AC197 AC198
AC500 PW110
PW510
ACV-USR-STATUS Alpha 2 AC10.1 AC110
Element: Status This is a user-defined code indicating AC112 AC12.1
the status of the activity. You can AC500 PW110
define various parameters relating to PW510
the status in AC02.1 (Status), including
whether an activity allows posting,
billing, revenue recognition, budgeting,
capitalization, or purging. This field
is required for activities assigned to
Activity Management activity groups. It
is not required for GL-only activities.
ACV-VAR-LEVELS Alpha 30 AC10.1 AC110
Element: Variable LevelLevels define an addressing system that AC120 AC500
organizes activities into a reporting AC90.2 AC90.4
hierarchy. Level names are defined for AC90.6 AC90.8
an activity group and should be able to AC95.2 PW110
be used across all activities in an PW510
activity group. Levels facilitate rollup
or consolidation of budgets, costs, and
revenues from activities at lower levels
to macro activities at a higher level
within the hierarchy.
Up to 15 characters can be used to name
a single level. The number of characters
used to name all levels can total 30.
ACV-VAR-LEVEL-DISP Alpha 34 AC10.1 AC110
Variable Level This field shows the hierarchical AC120 AC197
Display numbering scheme that allows detail to AC198 AC500
be aggregated or "rolled-up" in PW110 PW510
summarized form. Five levels are
available in the Activity Management
system.
ACV-BEGIN-DATE Numeric 8 (yyyymmdd) AC10.1 AC110
Element: Begin Date This is the beginning date for the AC500 PW110
activity. The activity date range must PW510
be within the date range for the
activity group. If you leave this field
blank, the activity group begin date
defaults.
ACV-END-DATE Numeric 8 (yyyymmdd) AC10.1 AC110
Element: End Date This is the ending date for the AC113 AC500
activity. The activity date range must PW110 PW510
be within the date range for the
activity group. If you leave this field
blank, the activity group begin date
defaults.
ACV-ACTIVE-BUD Numeric 3 AC110 AC127
Element: Active Budget This is the budget number for the AC20.7 AC310
activity group active budget. The active SB515
budget is the default budget used for
inquiries and reporting and in
calculating percentage of completion for
AC65.1 (Account Category Percent of
Completion).
ACV-LONG-DESC Alpha 60 (Lower Case) AC10.1 AC110
Element: Long DescriptiOccurs 4 Times AC500 PW110
This is the long description of the PW510
activity.
ACV-ESTIMATE Signed 18.2 AC10.1 AC110
Element: Estimate This is a budget estimate for the AC500
activity. This estimate is informational
only.
ACV-OBJ-ID Numeric 12 AC10.1 AC110
Element: Activity ObjecThis field defines the activity. The AC197 AC198
object ID is used with activity AC500 PW110
attributes. Attribute matrix files are PW510
keyed by object ID. The value in this
field is unique and generated by the
system.
ACV-PARENT-ACTV Alpha 15 AC10.1 AC110
Element: Parent Actv The parent activity field contains the AC120 AC500
activity name of the member parent. PW110 PW510
ACV-ACTIVITY-ND Numeric 1 AC10.1 AC110
Activity Curr Nbr This is the number of decimal positions AC145 AC197
of Decimals defined for the activity currency. AC198 AC500
PW110 PW510
ACV-HIGH-PST-DATE Numeric 8 (yyyymmdd) AC110 AC190
Element: Highest PostinThis is the latest posting date for AC300 AC500
transactions posted to the activity. ACDR.1 PW110
PW510
ACV-BALANCE-AMOUNT Signed 18.2 AC110 AC300
Element: Balance AmountThis is the amount balance for the ACDR.1
life-to-date activity actuals amount.
ACV-BALANCE-UNIT Signed 17.2 AC110 AC300
Element: Units Balance This is the unit balance for the ACDR.1
activity actuals.
ACV-SHORT-DESC Derived
Element: Short DescriptThis is the short description of the
activity.
ACV-BILLABLE-FLAG Alpha 1 AC10.1 AC110
Element: Billable Flag This field indicates whether the AC197 AC198
activity is billable. Use Yes (Y) for AC500 PW110
billable. Use No (N) for nonbillable. PW510
Y = Yes
N = No
H = Hold
ACV-SECURITY-CD Numeric 4 AC00.1 AC10.1
Element: Security Cd This field contains the security code AC110 AC120
for the activity. AC500 PW110
PW510
ACV-POST-OR-GLONLY Derived
Element: Post Or Glonly
ACV-OUTPUT-MEASURE Signed 18.2 AC10.1 AC500
Element: Intl Amt This is the output measurement.
ACV-OUTPUT-DESC Alpha 30 AC10.1 AC500
Element: Output Desc This is the output description.
ACV-SEGMENT-FLAG Alpha 1 AC10.1 AC110
Element: Segment Flag Indicates whether user analysis values AC500 PW110
(SL segment) have been populated for the PW510
distribution line.
ACV-GRP-CURR-CODE1 Derived
Element: Grp Curr Code1
ACV-GRP-CURR-CODE2 Derived
Element: Grp Curr Code2
ACV-ACT-SEG-BLOCK Derived
Element: Act Seg Block
ACV-BILL-WBS-CODE Alpha 3 AC10.1 AC500
Element: Bill Wbs Code
ACV-LOCATION-NAME Alpha 15 AC10.1
Element: Location Name A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
ACV-DIVISION Alpha 15 AC10.1
Element: Division A user-defined division which is used
for reporting assets.
ACV-POP-FLAG Alpha 1 AC10.6 AC110
Element: Pop Flag Period of Performance flag. If records AC120
are added into the ACPRDPERF file for
the related activity, the flag will be
updated to Y.
N = No
Y = Yes
ACV-AWARD-FLAG Alpha 1 AC10.1 AC110
Element: Award Flag Flag to indicate whether this activity AC113 AC500
is an award for the GM system or a
posting level activity within an award.
Y = Yes
N = No
ACV-EFFORT-FLAG Alpha 1 AC10.1 AC110
Element: Effort Flag Flag to indicate whether this activity AC113 AC500
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
ACV-SALARY-CAP-FL Alpha 1 AC10.1 AC110
Element: Salary Cap Fl This flag indicates whether the salary AC113 AC500
cap applies to this grant/project. The
actual salary cap amount is stored on
the GMSALCAP record.
Y = Yes
N = No
ACV-FRNG-RATE Signed 14.7 AC10.1 AC110
Element: Curr Rate The currency rate. AC113 AC500
ACV-FRNG-ACCT-CAT Alpha 5 AC10.1 AC110
Element: Frng Acct Cat A default post-to fringe account AC113 AC500
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.
ACV-FRNG-ACCOUNT Numeric 6 AC10.1 AC110
Element: Frng Account A default post-to fringe account that AC113 AC500
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.
ACV-FRNG-SUB-ACCT Numeric 4 AC10.1 AC110
Element: Frng Sub Acct A default post-to fringe sub account AC113 AC500
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.
ACV-SALARY-CAP-AMT Signed 18.2
Element: Intl Amt Salary cap amount for the activity. It
is assummed to be in the activity
currency.
ACV-STRUCTURE Alpha 15 AC10.1 AC110
Element: Structure The name of the category structure. AC500 PW110
This represents the category structure PW510
assigned to the activity.
ACV-BILL-REV-FLAG Alpha 1 AC10.1 AC120
Element: Bill Rev Flag Y = Yes BR120 BR122
N = No BR130 BR140
BR521 BR530
ACV-BACKOUT-STATUS Alpha 1 AC10.1 AC10.5
Element: Backout StatusY = Yes AC120 BR140
N = No
ACV-PAR-ACT-STRCT Alpha 15 Occurs 4 Times AC10.1 AC110
Element: Parent Actv This field will contain the parent of AC120 AC500
the Activity at each variable level in PW110 PW510
the Activity Groups hierarchy.
ACV-POSTING-FLAG Alpha 1 AC10.1 AC110
Element: Posting Flag P = Posting AC500 PW110
S = Summary PW510
C = Contract
ACV-LEVEL-DEPTH Numeric 1 AC10.1 AC110
Element: Level Depth The number of variable levels AC120 AC500
pertaining PW110 PW510
to this record.
ACV-LEVEL-DETAIL Numeric 15 Occurs 5 Times AC10.1 AC110
Element: Level Detail AC120 AC500
PW110 PW510
ACV-BUDGET-EDIT Alpha 1 AC10.1 AC110
Element: Budget Edit 1 = No Edit AC113 AC500
2 = Period Edit
3 = Annual Edit
4 = Total Edit
ACV-BUDGET-LEVEL Alpha 1 AC10.1 AC110
Element: Budget Level 1 = Activity-Acct Cat AC113 AC500
3 = Activity
4 = Activity-Summary Account Cat
ACV-BUD-TOLERANCE Signed 5.2 AC10.1 AC110
Element: Bud Tolerance AC113 AC500
ACV-SCHEDULE Alpha 9 AC10.1 AC110
Element: Schedule Stores the applicable salary cap AC113 AC500
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.
ACV-CURRENT-CAP Alpha 1 AC10.1 AC110
Element: Flag Determines which salary cap amount is AC113 AC500
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
ACV-CAP-ACTIVITY Alpha 15 AC10.1 AC110
Element: Activity Identifies the activity to charge with AC113 AC500
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.
ACV-CAP-ACCT-CAT Alpha 5 AC10.1 AC110
Element: Acct Category Valid only if an activity is selected. AC113 AC500
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.
ACV-CAP-COMPANY Numeric 4 AC10.1 AC110
Element: Company Identifies the GL company to charge with AC113 AC500
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.
ACV-CAP-ACCT-UNIT Alpha 15 AC10.1 AC110
Element: Acct Unit Identifies the accounting unit to charge AC113 AC500
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.
ACV-CAP-ACCOUNT Numeric 6 AC10.1 AC110
Element: Account Identifies the account to charge with AC113 AC500
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.
ACV-CAP-SUB-ACCT Numeric 4 AC10.1 AC110
Element: Sub Acct Identified the subaccount to cahrge with AC113 AC500
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.
ACV-CAP-SEG-FLAG Alpha 1 AC10.1 AC110
Element: Segment Flag Identifies the user analysis (if any) to AC113 AC500
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.
ACV-DATE-CREATED Numeric 8 (yyyymmdd)
Element: Date This field displays the system date
when this was created.
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 KeyChange AC00.1 AC01.1
ACTIVITY AC10.1 AC10.5
AC105 AC110
AC112 AC113
AC12.1 AC120
AC121 AC123
AC128 AC13.3
AC130 AC135
AC145 AC160
AC165 AC169
AC190 AC191
AC197 AC198
AC20.5 AC20.8
AC200 AC203
AC206 AC207
...
ACVSET3 COMPANY KeyChange AC12.1
ACTIVITY
ACVSET4 ACTIVITY-GRP KeyChange AC01.1 AC10.1
LEVEL-DEPTH AC560 PW90.1
VAR-LEVELS* PWI2.1
ACTIVITY
ACVSET6 OBJ-ID AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.2 AC13.3
AC13.4 AC130
AC135 AC145
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC203
AC206 AC207
...
ACVSET7 PARENT-ACTV KeyChange
ACTIVITY
ACVSET8 ACTIVITY-GRP KeyChange, Subset AC01.1 AC10.1
VAR-LEVELS Where (VAR-LEVELS != Spaces ) AC10.5 AC11.1
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC128
AC135 AC145
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
...
ACACTIVITY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
ACV-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
ACV-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactseg ACACTSEG Not Required
ACV-OBJ-ID -> CSG-OBJ-ID
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 RELATED
NAME 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
Acblactv ACBLACTV
ACV-ACTIVITY -> BLA-ACTIVITY
BLA-ACCT-CATEGORY
BLA-CTR-CAT-GRP
BLA-SUM-ACCT-CAT
BLA-BILL-ACTIVITY
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
|