SSIS Components for Oracle Fusion Cloud Financials

Build 25.0.9434

AwardBudgetSummaryTasksBudgetLines

The Budget Lines resource is used to view the budget lines for a task.

Columns

Name Type Description
AwardBudgetSummaryPlanVersionId [KEY] Long Identifier of the award budget version.
TasksTaskId [KEY] Long Identifier of the task which is used to create a award budget line.
RbsElementId Long Identifier of the resource used to create the award budget line.
ResourceName String The name of the resource used to create the award budget line.
TaskId Long Identifier of the task which is used to create an award budget line
TaskNumber String Number of the task which is used to create an award budget line.
TaskName String Name of the task which is used to create an award budget line.
ResourceFormat String Resource format to add resource element to the planning resource breakdown structure.
ResourceClass String A resource type that is available for use within resource format hierarchies on planning resource breakdown structure.
SpreadCurve String Spread curves distributes quantity, cost, and revenue amounts automatically across accounting or project accounting periods.
PlanningStartDate Date Award budget line start date.
PlanningEndDate Date Award budget line end date.
FundingSourceId Long Identifier of the funding source used to create the award budget line.
FundingSourceNumber String Funding Source Number used to create the award budget line.
FundingSourceName String Funding Source Name used to create the award budget line.
Quantity Decimal Measure of the effort planned for the award budget line.
Currency String Currency code for the award budget lines.
RawCostAmounts Decimal Award budget line raw cost amounts in transaction currency.
BurdenedCostAmounts Decimal Award budget line burdened cost amounts in transaction currency.
RevenueAmounts Decimal Award budget line revenue amounts in transaction currency.
EffectiveRawCostRate Decimal Effective raw cost rate for award budget line.
StandardRawCostRate Decimal Standard raw cost rate for award budget line.
EffectiveBurdenedCostRate Decimal Effective burdened cost rate for award budget line.
StandardBurdenedCostRate Decimal Standard burdened cost rate for award budget line.
EffectiveRevenueRate Decimal Effective revenue rate for award budget line.
StandardRevenueRate Decimal Standard revenue rate for award budget line.
PCRawCostAmounts Decimal Award budget line raw cost amounts in project currency.
PCBurdenedCostAmounts Decimal Award budget line burdened cost amounts in project currency.
PCRevenueAmounts Decimal Award budget line revenue amounts in project currency.
PFCRawCostAmounts Decimal Award budget line raw cost amounts in project ledger currency.
PFCBurdenedCostAmounts Decimal Award budget line burdened cost amounts in project ledger currency.
PFCRevenueAmounts Decimal Award budget line revenue amounts in project ledger currency.
TaskSequence Long Position of the task in the hierarchical arrangement.
AwardId Long awardid
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