CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

FinancialProjectPlansResourceAssignmentsPlanningAmounts

The Planning Amounts resource is used to view a financial project plan resource assignment amounts.

Columns

Name Type Description
FinancialProjectPlansPlanVersionId [KEY] Long Identifier of the financial project plan version.
ResourceassignmentsPlanningElementId [KEY] Long Identifier of the resource assignment on the financial project plan version.
PlanLineId [KEY] Long Identifier of the summary level planning amounts for a resource assignment in the financial project plan.
PlannedQuantity Decimal Measure of the effort planned for in the financial project plan resource assignment, expressed in hours.
ITDActualQuantity Decimal Actual effort for the financial project plan resource assignment from the start of the project till the current date, expressed in hours.
BaselineQuantity Decimal Measure of the effort planned for the resource assignment in the baseline financial project plan version, expressed in hours.
Currency String Code that identifies the planning currency on the financial project plan resource assignment.
RawCost Decimal Planned cost for the financial project plan resource assignment in planning currency that corresponds to the work performed.
ITDActualRawCost Decimal Actual cost incurred for the financial project plan resource assignment in planning currency that corresponds to the work performed from the start date of the project till the current date.
BaselineRawCost Decimal Planned cost for the project in planning currency in the baseline financial project plan version that corresponds to the work performed.
BurdenedCost Decimal Total planned cost for the financial project plan resource assignment in planning currency that includes both raw and burden costs.
ITDActualBurdenedCost Decimal Actual cost incurred for the financial project plan resource assignment, including raw and burden costs, in planning currency from the start date of the project till the current date.
BaselineBurdenedCost Decimal Total planned cost for the baseline financial project plan resource assignment, including raw and burden costs, in planning currency.
EffectiveRawCostRate Decimal Cost rate that is used to calculate amounts for a financial project plan resource assignment. Quantity multiplied by the effective raw cost rate gives the raw cost amounts.
StandardRawCostRate Decimal Rate derived from the rate schedule for calculating the planned raw cost for the financial project plan resource assignment.
EffectiveBurdenedCostRate Decimal Cost rate that is used to calculate amounts for a financial project plan resource assignment. Quantity multiplied by the effective burdened cost rate gives the burdened cost amounts.
StandardBurdenedCostRate Decimal Average rate derived from the rate schedule for calculating the planned burdened cost for the financial project plan resource assignment.
RawCostInProjectCurrency Decimal Planned cost for the financial project plan resource assignment in project currency that corresponds to the work performed.
ITDActualRawCostInProjectCurrency Decimal Actual cost incurred for the financial project plan resource assignment in project currency that corresponds to the work performed from the start date of the project till the current date.
BaselineRawCostInProjectCurrency Decimal Planned cost for the baseline financial project plan resource assignment in project currency that corresponds to the work performed.
BurdenedCostInProjectCurrency Decimal Total planned cost for the financial project plan resource assignment in project currency that includes both raw and burden costs.
ITDActualBurdenedCostInProjectCurrency Decimal Actual cost incurred for the financial project plan resource assignment, including raw and burden costs, in project currency from the start date of the project till the current date.
BaselineBurdenedCostInProjectCurrency Decimal Total planned cost for the baseline financial project plan resource assignment, including raw and burden costs, in project currency.
RawCostInProjectLedgerCurrency Decimal Planned cost for the financial project plan resource assignment in project ledger currency that corresponds to the work performed.
ITDActualRawCostInProjectLedgerCurrency Decimal Actual cost incurred for the financial project plan resource assignment in project ledger currency that corresponds to the work performed from the start date of the project till the current date.
BaselineRawCostInProjectLedgerCurrency Decimal Planned cost for the baseline financial project plan resource assignment in project ledger currency that corresponds to the work performed.
BurdenedCostInProjectLedgerCurrency Decimal Total planned cost for the financial project plan resource assignment in project ledger currency that includes both raw and burden costs.
ITDActualBurdenedCostInProjectLedgerCurrency Decimal Actual cost incurred for the financial project plan resource assignment, including raw and burden costs, in project ledger currency from the start date of the project till the current date.
BaselineBurdenedCostInProjectLedgerCurrency Decimal Total planned cost for the financial project plan resource assignment, including raw and burden costs, in project ledger currency in the baseline financial project plan version.
ManualSpreadFlag Bool Indicates if the periodic planning is modified and retained for the plan line on date changes.
BaselineCurrency String Currency of the rendered baseline amounts.
Finder String finder
PlanVersionId Long planversionid

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