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.
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.
|
|
ACV-DESCRIPTION Element: Activity Description | Alpha 30 (Lower Case) This is the activity description.
|
|
ACV-ACTIVITY-GRP Element: Activity Group | Alpha 15 This is the activity group for the
activity.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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 .
|
|
ACV-CURRENCY-CODE Element: Currency Code | Alpha 5 This is the company currency code.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
ACV-ESTIMATE Element: Estimate | Signed 18.2 This is a budget estimate for the
activity. This estimate is informational
only.
|
|
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.
|
|
ACV-PARENT-ACTV Element: Parent Actv | Alpha 15 The parent activity field contains the
activity name of the member parent.
|
|
ACV-ACTIVITY-ND Activity Curr Nbr of Decimals | Numeric 1 This is the number of decimal positions
defined for the activity currency.
|
|
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 |
|
ACV-SECURITY-CD Element: Security Cd | Numeric 4 This field contains the security code
for the activity.
|
|
ACV-POST-OR-GLONLY Element: Post Or Glonly | Derived
|
|
ACV-OUTPUT-MEASURE Element: Intl Amt | Signed 18.2 This is the output measurement.
|
|
ACV-OUTPUT-DESC Element: Output Desc | Alpha 30 This is the output description.
|
|
ACV-SEGMENT-FLAG Element: Segment Flag | Alpha 1 Indicates whether user analysis values
(SL segment) have been populated for the
distribution line.
|
|
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
|
|
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.
|
|
ACV-DIVISION Element: Division | Alpha 15 A user-defined division which is used
for reporting assets.
|
|
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 |
|
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 |
|
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 |
|
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 |
|
ACV-FRNG-RATE Element: Curr Rate | Signed 14.7 The currency rate.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
ACV-BILL-REV-FLAG Element: Bill Rev Flag | Alpha 1
Y = Yes N = No |
|
ACV-BACKOUT-STATUS Element: Backout Status | Alpha 1
Y = Yes N = No |
|
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.
|
|
ACV-POSTING-FLAG Element: Posting Flag | Alpha 1
P = Posting S = Summary C = Contract |
|
ACV-LEVEL-DEPTH Element: Level Depth | Numeric 1 The number of variable levels
pertaining
to this record.
|
|
ACV-LEVEL-DETAIL Element: Level Detail | Numeric 15 Occurs 5 Times
|
|
ACV-BUDGET-EDIT Element: Budget Edit | Alpha 1
1 = No Edit 2 = Period Edit 3 = Annual Edit 4 = Total Edit |
|
ACV-BUDGET-LEVEL Element: Budget Level | Alpha 1
1 = Activity-Acct Cat 3 = Activity 4 = Activity-Summary Account Cat 5 = Contract Funding |
|
ACV-BUD-TOLERANCE Element: Bud Tolerance | Signed 5.2
|
|
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.
|
|
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 |
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
ACV-DATE-CREATED Element: Date | Numeric 8 (yyyymmdd) This field displays the system date
when this was created.
|
|
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 |
|