This section contains the following topics:
About the CA PPM Investment Financials Universe
Use the CA PPM Investment Financials universe to create informal documents and crystal reports. This universe addresses the needs of the financial groups. Work in process, chargebacks, cost plans, benefit plans, budget plans, and unposted financial transactions are easily reported against fiscal periods.
Use the following attributes when querying financial OBS information:
Displays the path to the OBS.
Displays the name for the OBS type.
Displays the first level in the OBS.
Displays the second level in the OBS.
Displays the third level in the OBS.
Displays the fourth level in the OBS.
Displays the fifth level in the OBS.
Displays the sixth level in the OBS.
Displays the seventh level in the OBS.
Displays the eighth level in the OBS.
Displays the ninth level in the OBS.
Displays the tenth level in the OBS.
Defines the OBS ID used in filtering and returning of descendants.
Use the following attributes when querying chargeback invoice information:
Displays the chargeback invoice number.
Displays the chargeback invoice date.
Displays the approval status for the chargeback invoice.
Displays the fiscal period for the chargeback invoice.
Displays the financial department associated with the chargeback invoice.
Indicates if the chargeback invoice is consolidated.
Indicates if the chargeback invoice is submitted and locked.
Displays the resource name that generated the chargeback invoice.
Displays the date the chargeback invoice was last updated.
Displays the resource name that last updated the chargeback invoice.
Displays the external source ID for the transaction associated with chargeback invoice. For example, the ID indicates if the transaction is imported from CA Clarity PPM timesheets or created manually.
Displays the external ID for the transaction for the chargeback invoice.
Use the following attributes when querying chargeback invoice details:
Displays the transaction date associated with the chargeback invoice.
Displays the chargeback GL account number for the transaction.
Displays the account description for the chargeback GL account for the transaction.
Displays the main account ID for the chargeback GL account.
Displays the sub account ID for the chargeback GL account.
Displays the account class for the chargeback GL account.
Displays the account type for the chargeback GL account.
Indicates if the chargeback GL account is a capital expense account.
Indicates if the chargeback GL account is a capital expense account.
Indicates if the chargeback GL account is an overhead.
Displays the entity associated with the chargeback invoice.
Displays the resource name associated with the chargeback invoice.
Displays the resource ID associated with the chargeback invoice.
Displays the charge code associated with the chargeback invoice.
Displays the input type associated with the chargeback invoice.
Displays the home currency code associated with the chargeback invoice.
Displays the billing currency code associated with the chargeback invoice.
Displays the transaction quantity associated with the chargeback invoice.
Displays the transaction amount in the home currency.
Displays the transaction amount in the billing currency.
Use the following attributes when querying investment information for financials:
Displays the identification code for an investment.
Displays the company name associated with the investment.
Displays a description of the investment.
Displays the financial location for the investment used to associate to transactions.
Displays the financial entity associated with the investment.
Displays the financial department associated with the investment.
Displays the financial status for the investment.
Example: If the investment is financially open, then the financial status is "Open".
Displays the name of the affiliated investment.
Displays the investment type.
Defines the work-in-process (WIP) class. The WIP class indicates the transaction category for the company.
Displays the investment class used to categorize company-related projects.
Displays the batch cycle for the investment. The batch cycle is the period over which data is accumulated before it is consolidated in a batch process.
Displays the bill to company name for the investment.
Displays the process stage for the investment.
Displays the financial goal for the investment.
Displays the billing currency code for the investment.
Displays the start date.
Displays the finish date.
Displays the baseline start date of an investment.
Displays the baseline finish date of the investment.
Indicates the status.
Stoplight values:
Displays comments on the investment status.
Indicates if the expenses for the investment are billable.
Indicates if the investment is financially active.
Indicates if the investment is flagged as a template.
Indicates if the investment is flagged as a program.
Indicates if a resource can enter time against the investment.
Displays the charge code associated with the investment for transactions.
Displays the partition associated with the investment.
Displays the labor transaction cost matrix associated with the investment.
Displays the labor transaction cost matrix associated with the investment.
Displays the material transaction cost matrix associated with the investment.
Displays the material transaction rate matrix associated with the investment.
Displays the equipment transaction cost matrix associated with the investment.
Displays the equipment transaction rate matrix associated with the investment.
Use the following attributes when querying the work breakdown structure (WBS):
Displays the unique identifier for the task.
Displays the task name.
Displays the task status.
Displays the task level in the WBS.
Displays the WBS record type for the task.
Values: Milestone, Task, Phase, and Activity
Displays the WBS sequence number for the task.
Displays the start date.
Displays the finish date.
Displays the baseline start date for the task.
Displays the baseline finish date for the task.
Indicates this task as a key task. Displays Yes if the task is a key task and No if it is not.
Displays the percent complete value for the task.
Displays the charge code associated with the task.
Displays the task category.
Use the following attributes when querying cost plans:
Displays the name of the cost plan.
Displays the unique ID for the cost plan.
Displays the plan revision number.
Displays the plan description.
Displays the fiscal period type for the cost plan.
Displays the start period of the fiscal time period of the plan.
Displays the end period of the fiscal time period of the plan.
Displays how cost plan data is grouped by transaction classes, roles, or charge codes.
Displays the sub-grouping of cost plan data.
Displays the approval status of the cost plan.
Indicates if the cost plan is the plan of record.
Displays the date the cost plan was last updated.
Displays the resource name that last updated the cost plan.
Use the following attributes to query cost plan details:
Displays the charge code associated with the cost plan detail.
Displays the general ledger account number to which credits are posted. The GL account number is a combination of the main account and sub account codes used to categorize accounts.
Displays the entity associated with the cost plan detail.
Displays the GL account description.
Displays the main account ID code of the GL account.
Displays the sub account ID code of the GL account.
Displays the GL account class.
Example: Balance Sheet, Profit and Loss
Displays the GL account type.
Values: Asset, Liability, Income, Expense
Indicates if the GL account is used for capital expense.
Indicates if the GL account is used for noncash expense.
Indicates if the GL account is used to charge any costs to designated departments.
Displays the resource role associated with the cost plan detail.
Displays the transaction class that categorizes the transaction types.
Displays the first custom value for the cost plan detail.
Displays the second custom value for the cost plan detail.
Displays the fiscal period name associated with the cost plan detail.
Displays the cost plan detail value as a percentage.
Use the following attributes to query cost plan measures:
Displays the quantity associated with the cost plan detail for the duration of the fiscal period date range.
Displays the cost associated with the cost plan detail for the duration of the fiscal period date range.
Displays the revenue associated with the cost plan detail for the duration of the fiscal period date range.
Use the following attributes to query benefit plans:
Displays the name of the benefit plan.
Displays the unique identification of the benefit plan.
Displays the benefit plan revision number.
Displays the description of the benefit plan.
Defines the type of fiscal time period associated with the benefit plan.
Example: Weekly, Monthly, Quarterly, Annually
Displays the start period of the fiscal time period.
Displays the end period of the fiscal time period.
Displays the benefit plan status.
Displays the date the benefit plan was last updated.
Displays the resource name that last updated the benefit plan.
Use the following attributes to query benefit plan details:
Displays the specific benefit detail for the benefit plan.
Displays the fiscal time period name associated with benefit plan.
Displays the percentage of benefit associated with the benefit plan detail.
Use the following attributes to query benefit plan measures:
Displays the planned benefit amount associated with the benefit plan.
Displays the actual benefit amount associated with the benefit plan.
Use the following attributes for querying budget plans:
Displays the name of the budget plan.
Displays the ID of the budget plan.
Displays the budget plan revision number.
Displays the budget plan description.
Displays the fiscal time period type associated with the budget plan.
Displays the start period of the fiscal time period of the plan.
Displays the end period of the fiscal time period of the plan.
Displays how budget plan data is grouped by transaction classes, roles, or charge codes.
Displays how budget plan data is sub-grouped.
Displays the approval status of the budget plan.
Indicates if the budget plan is the plan of record.
Displays the date when the budget plan was last updated.
Displays the resource name that last updated the budget plan.
Use the following attributes to query budget plan details:
Displays the charge code associated with budget plan detail.
Displays the general ledger account number to which credits are posted. The GL account number is a combination of the main account and sub account codes used to categorize accounts.
Displays the entity associated with the budget plan detail.
Displays the GL account description.
Displays the main account ID code of the GL account.
Displays the sub account ID code of the GL account.
Displays the GL account class.
Example: Balance Sheet, Profit and Loss
Displays the GL account type.
Values: Asset, Liability, Income, Expense
Indicates if the GL account is used for capital expense.
Indicates if the GL account is used for noncash expense.
Indicates if the GL account is used to charge any costs to designated departments.
Displays the resources role associated with the budget plan detail.
Displays the transaction class that categorizes the transaction types.
Displays the first custom value for the budget plan detail.
Displays the second custom value for the budget plan detail.
Displays the fiscal period name associated with the benefit plan detail.
Displays the percentage of the budget associated with the budget detail.
Use the following attributes to query budget plan measures:
Displays the quantity associated with the budget plan detail for the duration of the fiscal period date range.
Displays the cost associated with the budget plan detail for the duration of the fiscal period date range.
Displays the revenue associated with the budget plan detail for the duration of the fiscal period date range.
Use the following attributes to query WIP adjustments for transactions:
Displays the source for the WIP adjustment.
Values: XOG, CA Clarity PPM Timesheet, Other Voucher, Unknown
Displays the transaction type.
Values: Labor, Expense, Material, Equipment, Adjustment, Unknown
Displays the batch number associated with the transaction.
Displays the entry date for the transaction entry.
Displays the date when the transaction was last updated.
Displays the external batch ID for the transaction.
Displays the external ID for the transaction.
Displays the financial location for the transaction.
Displays the chargeable department for the transaction.
Displays the entity associated with the transaction.
Displays the date of the transaction.
Indicates if the transaction represents costs you can bill to a customer or charge back internally to a department.
Displays the WIP adjustment status for the transaction.
Values: No Adjustment, No Pending Approval, Adjusted, Reversed, Updated, Process by Billing, Approval Pending, Unknown
Displays any additional information about the transaction or adjustments to the transaction.
Displays the invoice number associated with the transaction.
Displays the home location of the resource associated with the transaction.
Displays the home department of the resource associated with the transaction.
Displays the investment type associated with the WIP adjustment.
Displays the company class for the transaction.
Displays the investment class for the transaction.
Displays the transaction class for the transaction.
Displays the resource class for the transaction.
Displays the WIP class for the transaction.
Indicates if the WIP adjustments are posted to GL accounts.
Displays the GL period associated with the GL account.
Displays the group number for the WIP adjustment.
Displays the transaction description.
Values: Reverse Transaction, Reverse Original
Indicates if the WIP adjustment must be deleted.
Displays the WIP adjustment type.
Values: Reverse, Transfer
Displays the voucher number for the WIP adjustment.
Displays the PO number for the WIP adjustment.
Displays the company name associated with the WIP adjustment.
Displays the resource name that last updated the WIP adjustment.
Displays the resource name associated with the WIP adjustment.
Displays the vendor name associated with the WIP adjustment.
Displays the task name associated with the WIP adjustment.
Displays the resource role associated with the WIP adjustment.
Displays the resource name to allocate the transaction costs to.
Displays the document type associated with the WIP adjustment.
Displays the charge code associated with the transaction.
Displays the input type code associated with the transaction.
Displays the first custom time entry value for the transaction.
Displays the second custom time entry value for the transaction.
Displays the expense type associated with the transaction.
Values: Capital Expense, Depreciation, Unknown
Displays the home currency code associated with the transaction cost.
Displays the home currency code associated with the transaction rate.
Displays the billing currency code associated with the transaction cost.
Displays the billing currency code associated with the transaction rate.
Use the following attributes to query WIP adjustment measures:
Displays the quantity associated with the WIP adjustment.
Displays the amount for the burden markup in home currency.
Displays the amount for the overhead markup in home currency.
Displays the actual cost rate for the transaction in home currency.
Displays the standard cost rate for the transaction in home currency.
Displays the total cost amount for the transaction in home currency.
Displays the standard billing rate for the transaction in home currency.
Displays the total billing amount for the transaction in home currency.
Displays the remaining amount for the transaction in home currency.
Displays the amount for the burden markup in billing currency.
Displays the amount for the overhead markup in billing currency.
Displays the actual cost rate for the transaction in billing currency.
Displays the standard cost rate for the transaction in billing currency.
Displays the amount for the burden markup in billing currency.
Displays the total cost amount for the transaction in billing currency.
Displays the standard billing rate for the transaction in billing currency.
Displays the total billing amount for the transaction in billing currency.
Displays the remaining amount for the transaction in billing currency.
Use the following attributes to query WIP adjustment measures:
Displays the source for the WIP transaction.
Values: XOG, CA Clarity PPM Timesheet, Other Voucher, Unknown
Displays the transaction type.
Values: Labor, Expense, Material, Equipment, Adjustment, Unknown
Displays the batch number associated with the transaction.
Displays the entry date for the transaction entry.
Displays the date when the transaction was last updated.
Displays the external batch ID for the transaction.
Displays the external ID for the transaction.
Displays the financial location for the transaction.
Displays the location ID for the financial location.
Displays the chargeable department for the transaction.
Displays the financial entity associated with the transaction.
Displays the date of the transaction.
Indicates if the transaction represents costs you can bill to a customer or charge back internally to a department.
Displays any additional information about the transaction or adjustments to the transaction.
Displays the invoice number associated with the transaction.
Displays the home location of the resource associated with the transaction.
Displays the home department of the resource associated with the transaction.
Displays the investment type associated with the transaction.
Displays the company class for the transaction.
Displays the investment class for the transaction.
Displays the transaction class for the transaction.
Displays the transaction class for the transaction.
Displays the WIP class for the transaction.
Displays the company name associated with the transaction.
Displays the date when the transaction was last updated.
Displays the resource name associated with the transaction.
Displays the external ID for the transaction.
Displays the external source ID for the transaction.
Displays the task name associated with the transaction.
Displays the financial location of the project associated with the transaction.
Displays the financial department associated with the project.
Displays the resource role associated with the transaction.
Displays the charge code associated with the transaction.
Displays the input type code associated with the transaction.
Displays the first custom time entry value for the transaction.
Displays the second custom time entry value for the transaction.
Displays the expense type associated with the transaction.
Values: Capital Expense, Depreciation, Unknown
Displays the home currency code associated with the transaction cost.
Displays the home currency code associated with the transaction rate.
Displays the billing currency code associated with the transaction cost.
Displays the billing currency code associated with the transaction rate.
Use the following attributes to query pending WIP transaction accounts payable information:
Displays the voucher number associated with the transaction AP.
Displays the PO number associated with the transaction AP.
Displays the vendor name associated with the transaction AP.
Displays the resource name to allocate the transaction costs to.
Displays the ID for the resource name.
Displays the voucher number associated with the transaction AP.
Use the following attributes to query pending WIP transaction measures:
Displays the quantity associated with the WIP transaction.
Displays the amount for the burden markup in home currency.
Displays the amount for the overhead markup in home currency.
Displays the actual cost rate for the transaction in home currency.
Displays the standard cost rate for the transaction in home currency.
Displays the total cost amount for the transaction in home currency.
Displays the standard billing rate for the transaction in home currency.
Displays the total billing amount for the transaction in home currency.
Displays the remaining amount for the transaction in home currency.
Displays the amount for the burden markup in billing currency.
Displays the amount for the overhead markup in billing currency.
Displays the actual cost rate for the transaction in billing currency.
Displays the standard cost rate for the transaction in billing currency.
Displays the total cost amount for the transaction in billing currency.
Displays the standard billing rate for the transaction in billing currency.
Displays the total billing amount for the transaction in billing currency.
Displays the remaining amount for the transaction in billing currency.
Use the following attributes to query WIP transactions:
Displays the source for the WIP transaction.
Values: XOG, Clarity Timesheet, Expense Voucher, Other Voucher, and Unknown
Displays the transaction type.
Values: Labor, Expense, Material, Equipment, Adjustment, and Unknown
Displays the batch number associated with the WIP transaction.
Displays the entry date for the transaction entry.
Displays the date when the transaction was last updated.
Indicates if the WIP transaction is in error.
Displays the home location of the resource associated with the transaction.
Displays the financial department associated with the transaction.
Displays the financial entity associated with the transaction.
Displays the transaction date.
Indicates if the transaction represents costs you can bill to a customer or chargeback internally to a department.
Displays the WIP status for the transaction.
Values: No Adjustment, No Pending Approval, Adjusted, Reversed, Updated, Process by Billing, Approval Pending, Unknown
Displays any additional information about the WIP transaction.
Displays the invoice number associated with the WIP transaction.
Displays the home location of the resource associated with the transaction.
Displays the home department of the resource associated with the transaction.
Displays the investment type associated with the WIP transaction.
Displays the company class for the transaction.
Displays the investment class used to categorize company-related projects.
Displays the transaction class that categorizes the transaction types.
Displays the resource class for the WIP transaction.
Displays the WIP class for the WIP transaction.
Indicates if the WIP transactions are posted to GL accounts.
Displays the GL period associated with the GL account.
Displays the company name associated with the WIP transaction.
Displays the resource name associated with the WIP transaction.
Displays the external ID for the transaction.
Displays the external source ID for the transaction. For example, the ID indicates if the transaction is imported from CA Clarity PPM timesheets or created manually.
Displays the task name associated with the WIP transaction.
Displays the financial location of the investment associated with the WIP transaction.
Displays the financial department associated with the investment.
Displays the resource role associated with the WIP adjustment.
Indicates if the WIP transaction was exported using XOG.
Displays the date when the WIP transaction was exported.
Displays the charge code associated with the WIP transaction
Displays the input type code associated with the WIP transaction.
Displays the first custom time entry value for the WIP transaction.
Displays the second custom time entry value for the WIP transaction.
Displays the expense type associated with the WIP transaction.
Values: Capital Expense, Depreciation, Unknown
Indicates if the WIP transaction is on hold.
Displays the start date of the fiscal period associated with the WIP transaction.
Displays the end date of the fiscal period associated with the WIP transaction.
Displays the home currency code associated with the transaction cost.
Displays the home currency code associated with the transaction rate.
Displays billing currency code associated with the transaction cost.
Displays the billing currency code associated with the transaction rate.
Use the following attributes to query WIP transactions accounts payable information:
Displays the voucher number for the WIP transaction.
Displays the PO number for the WIP transaction.
Displays the vendor name associated with the WIP transaction.
Displays the resource name to allocate the transaction costs to.
Displays the document type associated with the WIP transaction.
Displays the date when the WIP transaction was last updated.
Displays the resource name that last updated the WIP transaction.
Use the following attributes to query WIP transaction measures:
Displays the transaction quantity.
Displays the amount for the burden markup in home currency.
Displays the amount for the overhead markup in home currency.
Displays the actual cost rate for the transaction in home currency.
Displays the standard cost rate for the transaction in home currency.
Displays the total cost amount for the transaction in home currency.
Displays the standard billing rate for the transaction in home currency.
Displays the total billing amount for the transaction in home currency.
Displays the remaining amount for the transaction in home currency.
Displays the amount for the burden markup in billing currency.
Displays the amount for the burden markup in billing currency.
Displays the amount for the overhead markup in billing currency.
Displays the actual cost rate for the transaction in billing currency.
Displays the standard cost rate for the transaction in billing currency.
Displays the total cost amount for the transaction in billing currency.
Displays the standard billing rate for the transaction in billing currency.
Displays the total billing amount for the transaction in billing currency.
Displays the remaining amount for the transaction in billing currency.
Use the following attributes to query debit and credit rules:
Displays the unique code used to classify the rule for that investment.
Displays the entity associated with the rule.
Displays the financial location associated with the rule.
Displays the financial department associated with the rule.
Displays the resource class associated with the rule.
Displays the charge code associated with the rule.
Displays the first custom value associated with the rule.
Displays the second custom value associated with the rule.
Displays the transaction class associated with the rule.
Displays the input type code associated with the rule.
Indicates if the rule is available for chargebacks.
Values: Active, Inactive, On Hold
Indicates whether to charge any remaining costs to overhead.
Indicates if the rule is a debit or credit rule.
Indicates the chargeback type associated with the debit rule.
Values: Standard, Investment
Displays the date when the chargeback associated with the rule was last updated.
Displays the resource that last updated the chargeback associated with the rule.
Use the following attributes to query WIP transaction measures:
Displays the chargeback GL account number for the debit rule.
Displays the entity associated with the debit rule.
Displays the account description for the chargeback GL account for the debit rule.
Displays the main account ID for the chargeback GL account.
Displays the sub account ID for the chargeback GL account.
Displays the account class for the chargeback GL account.
Displays the account type for the chargeback GL account.
Indicates if the GL account is used for capital expense.
Indicates if the GL account is used for noncash expense.
Indicates if the GL account is used to charge any costs to designated departments.
Displays the financial department associated with the debit rule detail.
Displays the date when the debit rule detail was last updated.
Displays the resource that last updated the debit rule detail.
Displays the debit rule detail value as a percentage.
Displays the start date of the fiscal period associated with the debit rule detail.
Displays the end date of the fiscal period associated with the debit rule detail.
Use the following attributes to query chargeback options:
Indicates the chargeback type.
Values: Standard, Investment
Indicates the bill expense type.
Values: Capital Expense, Depreciation
Use the following attributes to query chargeback transactions:
Displays the GL account number for the chargeback transaction.
Displays the account description for the chargeback GL account.
Displays the main account ID for the chargeback GL account.
Displays the sub account ID for the chargeback GL account.
Displays the account class for the chargeback GL account.
Displays the account type for the chargeback GL account.
Indicates if the GL account is used for capital expense.
Indicates if the GL account is used for noncash expense.
Indicates if the GL account is used to charge any costs to designated departments.
Displays the transaction date associated with the chargeback.
Displays the invoice number associated with the chargeback transaction.
Displays the entity associated with the chargeback transaction.
Displays the financial department associated with the chargeback transaction.
Displays the resource name associated with the chargeback transaction.
Displays the task name associated with the chargeback transaction.
Displays the charge code associated with the chargeback transaction.
Displays the input type code associated with the chargeback transaction.
Indicates if the transaction represents costs you can bill to a customer or charge back internally to a department.
Displays the external ID for the chargeback transaction.
Displays the external source ID for the chargeback transaction.
Indicates if the transaction was created manually through the UI or through a job (for example, from timesheets)
Displays the date when the chargeback transaction was last updated.
Displays the resource that last updated the chargeback transaction.
Displays the home currency code associated with the chargeback transaction.
Displays the home currency code associated with the chargeback transaction.
Displays the transaction quantity.
Displays the GL amount in home currency.
Displays the GL amount in billing currency.
Use the following attributes to query chargeback credits:
Displays the chargeback GL account number for the chargeback credit.
Displays the account description for the chargeback GL account.
Displays the main account ID for the chargeback GL account.
Displays the sub account ID for the chargeback GL account.
Displays the account class for the chargeback GL account.
Displays the account type for the chargeback GL account.
Indicates if the GL account is used for capital expense.
Indicates if the GL account is used for noncash expense.
Indicates if the GL account is used to charge any costs to designated departments.
Displays the financial department associated with the chargeback credit.
Displays the home currency code associated with the chargeback credit.
Displays the billing currency code associated with the chargeback credit.
Displays the transaction quantity associated with the chargeback credit.
Displays the GL amount in the home currency.
Displays tge GL amount in the billing currency.
Use the following attributes when querying security condition information:
Displays the project view rights.
| Copyright © 2010 CA. All rights reserved. | Email CA Technologies about this topic |