ODBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ProjectTemplatesTasks

The Task resource is used to view and create a project task. Tasks are units of project work assigned or performed as part of the duties of a resource. Tasks can be a portion of project work to be performed within a defined period by a specific resource or multiple resources.

Columns

Name Type Description
ProjectTemplatesProjectTemplateId [KEY] Long Unique identifier of the project template.
AllowCapitalInterestFlag Bool Indicates the task is enabled for capitalization of interest amounts.
AllowCrossChargeTransactionsFlag Bool Indicates that the project will allow cross-charge transactions from other business units.
BillableFlag Bool Indicates transactions charged to that task can be billed to customers.
BurdenSchedule String Name of the burden schedule associated to the task.
BurdenScheduleId Long Unique identifier of the burden schedule associated to the task.
BurdenScheduleFixedDate Date A specific date used to determine the right set of burden multipliers for the task.
CapitalizableFlag Bool Indicates the capitalizable status of a task. Transactions charged to that task can be set up as business assets in the books of account instead of treated as expenses.
CapitalizeInterestStopDate Date The date where capitalized interest will stop accruing.
ChargeableFlag Bool Chargeable task checkbox indicator
CriticalFlag Bool A task that must be completed on schedule or it will impact the finish date of the entire project.
CrossChargeLaborFlag Bool Indicator to show that the project allows processing of cross-charge transactions between business units for labor transactions. Valid values are true and false.
CrossChargeNonLaborFlag Bool Indicates whether nonlabor transactions are eligible for cross-charging when the task allows cross-charge transactions from other business units. If true, then nonlabor transactions are eligible for cross-charge processing. If false, they're not. The default value for a summary task is derived from the project. The default value for a subtask is derived from the corresponding value of the parent task.
ExternalParentTaskId String Unique identifier of the parent project task that is created in the third-party application.
ExternalTaskId String Unique identifier of the project task that is created in the third-party application.
LowestLevelTask String Indicates the task is at the lowest level.
LaborTpSchedule String Name of the transfer price schedule that associates transfer price rules with pairs of provider and receiver organizations for labor transactions. Enter a value for either this attribute or Labor Transfer
LaborTpScheduleId Long Unique identifier of the labor transfer price schedule. Enter a value for either this attribute or Labor Transfer Price Schedule but not both.
LaborTpFixedDate Date A specific date used to determine a price on a transfer price schedule for labor transactions.
MilestoneFlag Bool Indicates the project milestone during which the task must be completed.
NlTransferPriceSchedule String Name of the transfer price schedule that associates transfer price rules with pairs of provider and receiver organizations for nonlabor transactions. Enter a value for either this attribute or Nonlabor
NlTransferPriceScheduleId Long Unique Identifier of the nonlabor transfer price schedule. Enter a value for either this attribute or Nonlabor Transfer Price Schedule but not both.
NlTransferPriceFixedDate Date A specific date used to determine a price on a transfer price schedule for nonlabor transactions.
ParentTaskId Long Identifier of the parent task of the task.
PartySiteId Long The customer address or location of where the work for a project is being performed.
PercentCompleteCalculationMethodCode String The means of calculating physical percent complete. For example, you can calculate physical percent complete for a lowest task based on cost, effort, or manual entry.
ProgressETCMethodCode String The method used to calculate estimate-to-complete values in project progress. For example, calculation methods are remaining plan and manual entry.
ReceiveProjectInvoiceFlag Bool Indicates if a task can receive invoices from other projects.
RetirementCostFlag Bool The cost of the removal of an asset, equipment, property, or resource from service after its useful life, or following its sale.
ServiceType String A classification of the service or activity associated with a task.
ServiceTypeCode String A classification of the service or activity associated with a task.
SourceApplication String The third-party application from which the task is imported.
SourceReference String The identifier of the task in the external system where it was originally entered.
TaskDescription String Text description of the project task that is being created.
TaskFinishDate Date Scheduled end date of the project task.
TaskId Long Unique identifier of the project task.
TaskLevel Int Indicates level of the task in the WBS.
TaskManagerEmail String Email of the person who is assigned as task manager to the task.
TaskManagerName String The resource who manages the task.
TaskManagerPersonId Long Unique identifier of the person who leads the project task and who has the authority and responsibility for meeting the task objectives.
TaskName String Name of the task. A task is subdivision of project work.
TaskNumber String Number of a task.
TaskOrganizationId Long Unique identifier of the task organization.
TaskOrganizationName String Name of the organization that owns the task.
TaskSequence Long Position of the project task in a hierarchical arrangement.
TaskStartDate Date Scheduled start date of the project task.
TransactionCompletionDate Date Date after which transactions won't be accepted by the task.
TransactionStartDate Date Date before which transactions won't be accepted by the task.
TopTaskId Long Identifier of the top task to which the task rolls up. If the task is a top task, the identifier of the top task is same as the identifier of the task.
WorkType String A classification of the work associated with a task. You can use work types to categorize and group tasks for processing purposes.
WorkTypeId Long A classification of the work associated with a task. You can use work types to categorize and group tasks for processing purposes.
CreationDate Datetime The date when the record was created.
CreatedBy String The user who created the record.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.
Finder String finder
ProjectTemplateId Long projecttemplateid

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