ODBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ProjectBudgetsPlanningOptionsExportOptions

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

Columns

Name Type Description
ProjectBudgetsPlanVersionId [KEY] Long Identifier of the project budget version.
PlanningoptionsPlanningOptionId [KEY] Long Unique identifier of the summary level planning option in the project budget version.
ExportOptionId [KEY] Long Identifier of the project budget 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.
PlanningCurrency String Currency used for planning in the budget line. This value is always set to true and the attribute is exported.
PlanningResource String Resource used for financial planning in budgets. This value is always set to true and the attribute is exported.
ResourceClass String Resource class associated with the budget line. This value is always set to true and the attribute is exported.
SpreadCurve String Spread curve associated with the budget 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 is not 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 is not 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 is not selected for export.
TotalMarginInProjectCurrency String Total margin in the project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute is not selected for export.
TotalMarginInProjectLedgerCurrency String Total margin in the project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute is not selected for export.
MarginPercentage String Margin expressed as a percentage. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute is not selected for export.
TotalBurdenedCostInProjectCurrency String Total 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 is not selected for export.
TotalBurdenedCostInProjectLedgerCurrency String Total 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 is not 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 is not selected for export.
ProjectCurrencyConversionCostDate String Date that is 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 means that the attribute is not selected for export.
ProjectCurrencyConversionCostDateType String Date type that is 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 is not 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 is not 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 is not selected for export.
ProjectLedgerCurrencyConversionCostDate String Date that is 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 is not selected for export.
ProjectLedgerCurrencyConversionCostDateType String Date type that is 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 is not 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 is not selected for export.
TotalRawCostInProjectCurrency String Total raw costs that are directly attributable to the work performed in the current budget, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N indicates that the attribute is not selected for export.
TotalRawCostInProjectLedgerCurrency String Total raw costs that are directly attributable to the work performed, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not 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 means that the attribute is not selected for export.
ProjectCurrencyConversionRevenueDate String Date that is 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 means that the attribute is not selected for export.
ProjectCurrencyConversionRevenueDateType String Date type that is 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 means that the attribute is not 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 means that the attribute is not 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 means that the attribute is not selected for export.
ProjectLedgerCurrencyConversionRevenueDate String Date that is 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 means that the attribute is not selected for export.
ProjectLedgerCurrencyConversionRevenueDateType String Date type that is 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 means that the attribute is not 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 means that the attribute is not selected for export.
TotalRevenueInProjectCurrency String Total planned revenue that is associated with the accounting period or a financial plan line in the budget, denoted in project currency. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not selected for export.
TotalRevenueInProjectLedgerCurrency String Total planned revenue that is associated with the accounting period or a financial plan line in the budget, denoted in project ledger currency. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not 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 means that the attribute is not 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 means that the attribute is not selected for export.
TotalBurdenedCost String Total burdened costs incurred on the project. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not 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 means that the attribute is not selected for export.
TotalRawCost String Total cost directly attributable to the work performed. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not selected for export.
TotalQuantity String Total quantity of resource effort that is required to complete a task or project, including labor and equipment. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not selected for export.
TotalMargin String Total margin (difference between revenue and cost) in a project. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not 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 means that the attribute is not selected for export.
TotalRevenue String Total planned revenue that is associated with the accounting period or a plan line in the budget. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not selected for export.
ToDate String End date of the budget line. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not 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 means that the attribute is not selected for export.
FromDate String From date of the budget line. A value of Y indicates that the attribute is selected for export. A value of N means that the attribute is not 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 means that the attribute is not selected for export.
FinancialPlanType String financialplantype
Finder String finder
PlanVersionId Long planversionid
ProjectId Long projectid

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