Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ProjectForecastsPlanningResourcesPlanningAmounts

The Planning Amounts resource is used to view project forecast resource assignment summary amounts.

Columns

Name Type Description
ProjectForecastsPlanVersionId [KEY] Long Identifier of the forecast version.
PlanningresourcesPlanningElementId [KEY] Long Identifier of the planning resources of the forecast version.
PlanLineId [KEY] Long Identifier of the summary level planning amounts for a plan line in the project forecast.
TotalCommittedQuantity Decimal Committed effort for the forecast version resource assignment.
ActualQuantity Decimal Actual effort for the forecast version resource assignment from the start of the project till the current date.
ETCQuantity Decimal Estimated remaining effort by the  forecast version resource assignment for completion.
EACQuantity Decimal Measure of the effort planned for in the forecast version resource assignment.
Currency String Code that identifies the planning currency on the forecast version resource assignment.
TotalCommittedRawCost Decimal Total committed cost for the forecast version resource assignment in planning currency that is directly attributable to the work performed.
ActualRawCost Decimal Actual cost incurred for the period in the forecast version resource assignment in planning currency that is directly attributable to the work performed from the start of the project till the current date.
ETCRawCost Decimal Estimated remaining cost in planning currency required for completion of the task in the period by the forecast version resource assignment that is directly attributable to the work performed.
EACRawCost Decimal Estimated cost in planning currency at the completion of the task in the period for the forecast version resource assignment that is directly attributable to the work performed.
StandardETCRawCostRate Decimal Rate derived from the rate schedule for calculating the planned raw cost for the forecast version resource assignment.
EffectiveETCRawCostRate Decimal Cost rate that is used to calculate amounts for a forecast version resource assignment. Quantity multiplied by the effective raw cost rate gives the raw cost amounts.
ActualRawCostRate Decimal Rate that is used to calculate the actual cost for the forecast version resource assignment that is directly attributable to the work performed.
EACRawCostRate Decimal Rate that is used to calculate the estimated cost at the completion of the task for the forecast version resource assignment that is directly attributable to the work performed.
TotalCommittedBurdenedCost Decimal Total committed cost for the forecast version resource assignment in planning currency that includes both raw and burden costs.
ActualBurdenedCost Decimal Actual cost incurred for the forecast version resource assignment, including raw and burden costs, in planning currency from the start of the project till the current date.
ETCBurdenedCost Decimal Estimated remaining cost in planning currency, including raw and burden costs, required for completion of the task by the forecast version resource assignment.
EACBurdenedCost Decimal Estimated cost in planning currency, including raw and burden costs, at the completion of the task for the forecast version resource assignment.
StandardETCBurdenedCostRate Decimal Average rate derived from the rate schedule for calculating the planned burdened cost for the forecast version resource assignment.
EffectiveETCBurdenedCostRate Decimal Cost rate that is used to calculate amounts for a forecast version resource assignment. Quantity multiplied by the effective burdened cost rate gives the burdened cost amounts.
ActualBurdenedCostRate Decimal Actual burdened cost rate that is used to calculate the actual cost for the forecast version resource assignment that includes both raw and burden costs.
EACBurdenedCostRate Decimal Rate that is used to calculate the actual cost for the forecast version resource assignment that includes both raw and burden costs.
RequisitionCommittedQuantity Decimal Effort for the forecast version resource assignment committed through requisitions.
PurchaseOrderCommittedQuantity Decimal Effort for the forecast version resource assignment committed through purchase orders.
SupplierInvoiceCommittedQuantity Decimal Effort for the forecast version resource assignment committed through supplier invoices.
TransferOrderCommittedQuantity Decimal Effort for the forecast version resource assignment committed through transfer orders.
RequisitionCommittedRawCost Decimal Cost for the forecast version resource assignment committed through requisitions in planning currency that is directly attributable to the work performed.
PurchaseOrderCommittedRawCost Decimal Cost for the forecast version resource assignment committed through purchase orders in planning currency that is directly attributable to the work performed.
SupplierInvoiceCommittedRawCost Decimal Cost for the forecast version resource assignment committed through supplier invoices in planning currency that is directly attributable to the work performed.
TransferOrderCommittedRawCost Decimal Cost for the forecast version resource assignment committed through transfer orders in planning currency that is directly attributable to the work performed.
RequisitionCommittedBurdenedCost Decimal Cost for the forecast version resource assignment committed through requisitions in planning currency that includes both raw and burden costs.
PurchaseOrderCommittedBurdenedCost Decimal Cost for the forecast version resource assignment committed through purchase orders in planning currency that includes both raw and burden costs.
SupplierInvoiceCommittedBurdenedCost Decimal Cost for the forecast version resource assignment committed through supplier invoices in planning currency that includes both raw and burden costs.
TransferOrderCommittedBurdenedCost Decimal Cost for the forecast version resource assignment committed through transfer orders in planning currency that includes both raw and burden costs.
TotalCommittedRawCostInProjectCurrency Decimal Total committed cost for the forecast version resource assignment in project currency that is directly attributable to the work performed.
ActualRawCostInProjectCurrency Decimal Actual cost incurred for the forecast version resource assignment in project currency that is directly attributable to the work performed from the start of the project till the current date.
ETCRawCostInProjectCurrency Decimal Estimated remaining cost in project currency required for completion of the task by the forecast version resource assignment that is directly attributable to the work performed.
EACRawCostInProjectCurrency Decimal Estimated cost in project ledger currency at the completion of the task for the forecast version resource assignment that is directly attributable to the work performed.
RequisitionCommittedRawCostInProjectCurrency Decimal Cost for the forecast version resource assignment committed through requisitions in project currency that is directly attributable to the work performed.
PurchaseOrderCommittedRawCostInProjectCurrency Decimal Cost for the forecast version resource assignment committed through purchase orders in project currency that is directly attributable to the work performed.
SupplierInvoiceCommittedRawCostinProjectCurrency Decimal Cost for the forecast version resource assignment committed through supplier invoices in project currency that is directly attributable to the work performed.
TransferOrderCommittedRawCostInProjectCurrency Decimal Cost for the forecast version resource assignment committed through transfer orders in project currency that is directly attributable to the work performed.
TotalCommittedRawCostInProjectLedgerCurrency Decimal Total committed cost for the forecast version resource assignment in project ledger currency that is directly attributable to the work performed.
ActualRawCostInProjectLedgerCurrency Decimal Actual cost incurred for the forecast version resource assignment in project ledger currency that is directly attributable to the work performed from the start of the project till the current date.
ETCRawCostInProjectLedgerCurrency Decimal Estimated remaining cost in project ledger currency required for completion of the task by the forecast version resource assignment that is directly attributable to the work performed.
EACRawCostInProjectLedgerCurrency Decimal Estimated cost in project ledger currency at the completion of the task for the forecast version resource assignment that is directly attributable to the work performed.
RequisitionCommittedRawCostInProjectLedgerCurrency Decimal Cost for the forecast version resource assignment committed through requisitions in project ledger currency that is directly attributable to the work performed.
PurchaseOrderCommittedRawCostInProjectLedgerCurrency Decimal Cost for the forecast version resource assignment committed through purchase orders in project ledger currency that is directly attributable to the work performed.
SupplierInvoiceCommittedRawCostinProjectLedgerCurrency Decimal Cost for the forecast version resource assignment committed through supplier invoices in project ledger currency that is directly attributable to the work performed.
TransferOrderCommittedRawCostInProjectLedgerCurrency Decimal Cost for the forecast version resource assignment committed through transfer orders in project ledger currency that is directly attributable to the work performed.
TotalCommittedBurdenedCostInProjectCurrency Decimal Total committed cost for the forecast version resource assignment in project currency that includes both raw and burden costs.
ActualBurdenedCostInProjectCurrency Decimal Actual cost incurred for the forecast version resource assignment, including raw and burden costs, in project currency from the start of the project till the current date.
ETCBurdenedCostInProjectCurrency Decimal Estimated remaining cost in project currency, including raw and burden costs, required for completion of the task by the forecast version resource assignment.
EACBurdenedCostInProjectCurrency Decimal Estimated cost in project currency, including raw and burden costs, at the completion of the task for the forecast version resource assignment.
RequisitionCommittedBurdenedCostInProjectCurrency Decimal Cost for the forecast version resource assignment committed through requisitions in project currency that includes both raw and burden costs.
PurchaseOrderCommittedBurdenedCostInProjectCurrency Decimal Cost for the forecast version resource assignment committed through purchase orders in project currency that includes both raw and burden costs.
SupplierInvoiceCommittedBurdenedCostinProjectCurrency Decimal Cost for the forecast version resource assignment committed through supplier invoices in project currency that includes both raw and burden costs.
TransferOrderCommittedBurdenedCostInProjectCurrency Decimal Cost for the forecast version resource assignment committed through transfer orders in project currency that includes both raw and burden costs.
TotalCommittedBurdenedCostInProjectLedgerCurrency Decimal Total committed cost for the forecast version resource assignment in project ledger currency that includes both raw and burden costs.
ActualBurdenedCostInProjectLedgerCurrency Decimal Actual cost incurred for the forecast version resource assignment, including raw and burden costs, in project ledger currency from the start of the project till the current date.
ETCBurdenedCostInProjectLedgerCurrency Decimal Estimated remaining cost in project ledger currency, including raw and burden costs, required for completion of the task by the forecast version resource assignment.
EACBurdenedCostInProjectLedgerCurrency Decimal Estimated cost in project ledger currency, including raw and burden costs, at the completion of the task for the forecast version resource assignment.
RequisitionCommittedBurdenedCostInProjectLedgerCurrency Decimal Cost for the forecast version resource assignment committed through requisitions in project ledger currency that includes both raw and burden costs.
PurchaseOrderCommittedBurdenedCostInProjectLedgerCurrency Decimal Cost for the forecast version resource assignment committed through purchase orders in project ledger currency that includes both raw and burden costs.
SupplierInvoiceCommittedBurdenedCostinProjectLedgerCurrency Decimal Cost for the forecast version resource assignment committed through supplier invoices in project ledger currency that includes both raw and burden costs.
TransferOrderCommittedBurdenedCostInProjectLedgerCurrency Decimal Cost for the forecast version resource assignment committed through transfer orders in project ledger currency that includes both raw and burden costs.
ActualRevenue Decimal Amount of revenue recognized for the forecast version resource assignment in planning currency from the inception of the project to date.
ETCRevenue Decimal Estimated remaining revenue amount in planning currency to be recognized for the forecast version resource assignment.
EACRevenue Decimal Estimated revenue amount in planning currency recognized for the forecast version resource assignment at the completion of the task.
StandardETCRevenueRate Decimal Rate derived from the rate schedule for calculating the planned revenue for the forecast version resource assignment.
EffectiveETCRevenueRate Decimal Revenue rate that is used to calculate amounts for a forecast version resource assignment. Quantity multiplied by the effective revenue rate gives the revenue.
ActualRevenueRate Decimal Rate that is used to calculate the actual revenue for the forecast version resource assignment.
EACRevenueRate Decimal Rate that is used to calculate the estimated revenue at the completion of the task for the forecast version resource assignment.
ActualRevenueInProjectCurrency Decimal Amount of revenue recognized for the forecast version resource assignment in project currency from the inception of the project to date.
ETCRevenueInProjectCurrency Decimal Estimated remaining revenue amount in project currency to be recognized for the forecast version resource assignment.
EACRevenueInProjectCurrency Decimal Estimated revenue amount in project currency recognized for the forecast version resource assignment at the completion of the task.
ActualRevenueInProjectLedgerCurrency Decimal Amount of revenue recognized for the forecast version resource assignment in project ledger currency from the inception of the project to date.
ETCRevenueInProjectLedgerCurrency Decimal Estimated remaining revenue amount in project ledger currency to be recognized for the forecast version resource assignment.
EACRevenueInProjectLedgerCurrency Decimal Estimated revenue amount in project ledger currency recognized for the forecast version resource assignment at the completion of the task.
ManualSpreadFlag Bool Indicates if the periodic planning is modified and retained for the plan line on date changes.
FinancialPlanType String financialplantype
Finder String finder
PlanVersionId Long planversionid
ProjectId String projectid

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454