JDBC Driver for Oracle Fusion Cloud Financials

Build 26.0.9770

ProjectsTasksExpenseResourceAssignments

An object that includes the attributes that are used to store values while creating or updating expense resource assignments for a project task. For example, hotel expenses can be planned on a project task.

Columns

Name Type SupportedFinders Description
ProjectsProjectId [KEY] Long Unique identifier of the project.
ExpenseResourceActualAmount Decimal Column to indicate the actual expense cost amount of a specific expense resource assigned to the task.
ExpenseResourceAssignmentId [KEY] Long Unique identifier of the expense resource assignment to the project task.
ExpenseResourceId Long Identifier of the expense resource assigned to the project.
ExpenseResourcePlannedAmount Decimal Column to indicate the planned expense cost amount of a specific expense resource assigned to the task.
ExpenseResourceRemainingAmount Decimal Column to indicate the sum of remaining expense cost amounts of a specific expense resource assigned to the task.
ProjElementId Long Identifier of the task to which the expense resource is assigned.
ExpenseResourceName String Name of the expense resource assigned to the project task.
ActiveDate Date FindByProjectTeamMember, findByProjectRoleAndProjectTeamMember activedate
ClassCategory String FindProjectsByClassCategory classcategory
Finder String finder
FinishDate Date FindChargeableProjectsByPersonIdAndDateRange, findChargeableProjectsByTeamMemberAndDateRange finishdate
OwningOrganizationName String FindByOrg owningorganizationname
PartyName String FindByPartyName partyname
PersonId Long FindChargeableProjectsByTeamMemberAndDateRange, findChargeableProjectsByPersonIdAndDateRange personid
PersonName String FindByProjectTeamMember, findByProjectRoleAndProjectTeamMember personname
ProjectId Long FindByProjectId, PrimaryKey projectid
ProjectName String FindByProjectName projectname
ProjectRole String FindByProjectRoleAndProjectTeamMember projectrole
ProjectStatus String FindByProjectStatus projectstatus
SearchAttribute String FindChargeableProjectsByPersonIdAndDateRange searchattribute
SourceApplicationCode String FindBySourceApplication sourceapplicationcode
SourceProjectReference String FindBySourceApplication sourceprojectreference
StartDate Date FindChargeableProjectsByPersonIdAndDateRange, findChargeableProjectsByTeamMemberAndDateRange startdate

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770