CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ProjectForecastsPlanningOptionsExportOptions

The Export Option resource is used to select the planning options attributes to export.

Columns

Name Type Description
ProjectForecastsPlanVersionId [KEY] Long Identifier of the forecast version.
PlanningoptionsPlanningOptionId [KEY] Long Identifier of the summary level planning option in the project forecast version.
ExportOptionId [KEY] Long Identifier of the project forecast version export options.
DisplayRatesAndAmountsInMultipleTransactionCurrenciesFlag Bool Indicates whether to display the currency conversion attributes and amounts in multiple transaction currencies if the plan type allows planning in multiple transaction currencies.
DisplayCommitmentsFlag Bool Indicates whether to display the external commitments present in the budget or forecast plan lines.
PlanningCurrency String Currency used for planning in the forecast line. This value is always set to true and the attribute is exported.
PlanningResource String Resource used for financial planning in the forecast line. This value is always set to true and the attribute is exported.
ResourceClass String Resource class associated with the forecast line. This value is always set to true and the attribute is exported.
SpreadCurve String Spread curve associated with the forecast line. This value is always set to true and the attribute is exported.
TaskName String Name assigned to a task. This value is always set to true and the attribute is exported.
TaskNumber String Number of the task. This value is always set to true and the attribute is exported.
BurdenedCostStandardMultiplier String Standard multiplier derived from the burden schedule for calculating burdened cost. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostStandardRate String Standard rate derived from the rate schedule for calculating the burdened cost. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
StandardRawCostRate String Rate derived from the rate schedule for calculating raw cost. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectCurrencyConversionCostRate String Cost rate used when converting the amounts to project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectCurrencyConversionCostDate String Date that's used as a cost conversion attribute for project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectCurrencyConversionCostDateType String Date type that's used as a cost conversion attribute for project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectCurrencyConversionCostRateType String The type of currency conversion rate for the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectLedgerCurrencyConversionCostRate String Cost rate used when converting the amounts to project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectLedgerCurrencyConversionCostDate String Date that's used as a cost conversion attribute for project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectLedgerCurrencyConversionCostDateType String Date type that's used as a cost conversion attribute for project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectLedgerCurrencyConversionCostRateType String The type of currency conversion rate for the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectCurrencyConversionRevenueRate String Revenue rate used when converting the amounts to project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectCurrencyConversionRevenueDate String Date that's used as a revenue conversion attribute for project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectCurrencyConversionRevenueDateType String Date type that's used as a revenue conversion attribute for project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectCurrencyConversionRevenueRateType String The type of currency conversion rate for the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectLedgerCurrencyConversionRevenueRate String Revenue rate used when converting the amounts to project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectLedgerCurrencyConversionRevenueDate String Date that's used as a revenue conversion attribute for project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectLedgerCurrencyConversionRevenueDateType String Date type that's used as a revenue conversion attribute for project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ProjectLedgerCurrencyConversionRevenueRateType String The type of currency conversion rate for the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
StandardRevenueRate String Rate derived from the rate schedule for calculating revenue. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EffectiveBurdenedCostRate String User entered rate for calculating the burdened cost. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EffectiveRawCostRate String User entered rate for calculating the raw cost. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EffectiveRevenueRate String User entered rate for calculating revenue. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ToDate String End date of the forecast line. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostEffectiveMultiplier String Multiplier used to calculate the burdened costs. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
FromDate String From date of the forecast line. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
UnitOfMeasure String Unit of measure for a resource. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualBurdenedCostAmounts String Actual burdened cost amounts incurred on the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualQuantity String Actual quantity of resource effort spent on a task or project, including labor and equipment. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualRawCostAmounts String Actual cost amounts incurred on the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostPOCommitmentsInPC String Burdened costs for purchase orders against the project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostPRCommitmentsInPC String Burdened costs for outstanding purchase requisitions against the project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostInvoiceCommitmentsInPC String Burdened costs for supplier invoices billed against the project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostPOCommitmentsInPLC String Burdened costs for purchase orders against the project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostPRInCommitmentsPLC String Burdened costs for outstanding purchase requisitions against the project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostInvoiceCommitmentsInPLC String Burdened costs for supplier invoices billed against the project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostPOCommitments String Burdened costs for purchase orders against the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostPRCommitments String Burdened costs for outstanding purchase requisitions against the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
BurdenedCostInvoiceCommitments String Costs for supplier invoices billed against the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualBurdenedCostInPC String Actual burdened costs incurred on the project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACBurdenedCostInPC String Estimate of burdened costs incurred on the project at completion, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCBurdenedCostInPC String Estimate of burdened costs to be incurred to complete the project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
TotalBurdenedCostCommitmentsInPC String Total burdened costs for all commitments such as purchase order, supplier invoices, and requisitions, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualBurdenedCostInPLC String Actual burdened costs incurred on the project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACBurdenedCostInPLC String Estimate of burdened costs incurred on the project at completion, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCBurdenedCostInPLC String Estimate of burdened costs to be incurred to complete the project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
TotalBurdenedCostCommitmentsInPLC String Total burdened costs for all commitments such as purchase order, supplier invoices, and requisitions, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACBurdenedCost String Estimate of burdened cost amounts incurred on the project at completion. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACQuantity String Estimate-at-completion quantity of resource effort spent on a task or project, including labor and equipment. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACRawCost String Estimate of cost amounts incurred on the project at completion. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCBurdenedCost String Estimate of burdened cost amounts to be incurred to complete the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCQuantity String Estimate-to-complete quantity of resource effort spent on a task or project, including labor and equipment. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCRawCost String Estimate of cost amounts to be incurred to complete the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualMargin String Difference between actual project-related costs and actual revenue amounts. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACMargin String Estimated difference between actual project-related costs and actual revenue amounts at the completion of the task or project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCMargin String Estimated difference between actual project-related costs and actual revenue amounts to complete the task or project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualMarginInPC String Difference between actual project-related costs and actual revenue amounts calculated using project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACMarginInPC String Estimated difference between project-related costs and revenue amounts at the completion of the task or project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCMarginInPC String Estimated difference between actual project-related costs and actual revenue amounts to complete the task or project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACMarginPercentage String Estimated difference between actual project-related costs and actual revenue amounts at the completion of the task or project, denoted as a percentage. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCMarginPercentage String Estimated difference between actual project-related costs and actual revenue amounts to complete the task or project, denoted as a percentage. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualMarginInPLC String Difference between actual project-related costs and actual revenue amounts calculated using project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACMarginInPLC String Estimated difference between project-related costs and revenue amounts at the completion of the task or project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCMarginInPLC String Estimated difference between actual project-related costs and actual revenue amounts to complete the task or project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualRevenueInPC String Actual revenue that's associated with the accounting period or a financial plan line in the forecast, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualRevenueInPLC String Actual revenue that's associated with the accounting period or a financial plan line in the forecast, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
QuantityPOCommitments String Planned quantity of purchase order commitments required to complete a project or task. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
QuantityPRCommitments String Planned quantity of purchase requisition commitments required to complete a project or task. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
QuantityInvoiceCommitments String Planned quantity of supplier invoice commitments required to complete a project or task. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostPOCommitmentsInPC String Purchase order costs that are directly attributable to work performed, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostPRCommitmentsInPC String Purchase requisition costs that are directly attributable to work performed, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostInvoiceCommitmentsInPC String Costs from supplier invoices that are directly attributable to work performed, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostPOCommitmentsInPLC String Purchase order costs that are directly attributable to work performed, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostPRCommitmentsInPLC String Purchase requisition costs that are directly attributable to work performed, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostInvoiceCommitmentsInPLC String Costs from supplier invoices that are directly attributable to work performed, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostPOCommitments String Purchase order costs that are directly attributable to work performed. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostPRCommitments String Purchase requisition costs that are directly attributable to work performed. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
RawCostInvoiceCommitments String Costs from supplier invoices that are directly attributable to work performed. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualRawCostInPC String Actual cost amounts incurred on the project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACRawCostInPC String Estimate of cost amounts incurred on the project at completion, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCRawCostInPC String Estimate of cost amounts to be incurred to complete the project, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
TotalRawCostCommitmentsInPC String Total commitments incurred by the project in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualRawCostInPLC String Actual cost amounts incurred on the project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACRawCostInPLC String Estimate of cost amounts incurred on the project at completion, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCRawCostInPLC String Estimate of cost amounts to be incurred to complete the project, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
TotalRawCostCommitmentsInPLC String Total commitments incurred by the project in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ActualRevenueAmounts String Actual revenue that's associated with the accounting period or a plan line in the forecast. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACRevenue String Estimate-at-completion revenue that's associated with the accounting period or a plan line in the forecast. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCRevenue String Estimate-to-complete revenue that's associated with the accounting period or a plan line in the forecast. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACRevenueInPC String Estimate-at-completion revenue that's associated with the accounting period or a financial plan line in the forecast, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCRevenueInPC String Estimate-to-complete revenue that's associated with the accounting period or a financial plan line in the forecast, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
EACRevenueInPLC String Estimate-at-completion revenue that's associated with the accounting period or a financial plan line in the forecast, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
ETCRevenueInPLC String Estimate-to-complete revenue that's associated with the accounting period or a financial plan line in the forecast, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
TotalBurdenedCostCommitments String Total burdened costs for all commitments such as purchase order, supplier invoices, and requisitions. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
TotalQuantityCommitments String Total commitments quantity required to complete a project or task. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
TotalRawCostCommitments String Total commitments incurred by the project. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute isn't selected for export.
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