Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ContractProjectandTaskBillRateOverrides

The Contract Project and Task Bill Rate Overrides resource is used to view project task rate overrides defined at the contract bill plan or revenue plan level.

Columns

Name Type Description
RateOverrideId [KEY] Long The unique identifier of the rate override.
ContractId Long Identifier of the contract to which the rate override belongs.
ContractNumber String Number of the contract to which the rate override belongs.
ContractType String Name of the type of contract to which the rate override belongs.
BillPlanId Long Identifier of the plan to which the rate override belongs.
BillPlanName String Name of the bill plan to which the rate override belongs.
PlanType String Name of the type of plan to which the rate override belongs. You must enter either Bill Plan or Revenue Plan.
ContractLineId Long Identifier of the contract line to which the rate override belongs.
ContractLineNumber String Number of the contract line to which the rate override belongs.
ContractLineName String Name of the contract line to which the rate override belongs.
ProjectId Long Identifier of the project to which the rate override belongs.
ProjectNumber String Number of the project to which the rate override belongs.
ProjectName String Name of the project to which the rate override belongs.
TaskId Long Identifier of the task to which the rate override belongs.
TaskNumber String Number of the task to which the rate override belongs.
TaskName String Name of the task to which the rate override belongs.
PersonId Long Identifier of the person to which the rate override belongs.
PersonNumber String Number of the person to which the rate override belongs.
PersonName String Name of the person to which the rate override belongs.
PersonEmail String Email of the person to which the rate override belongs.
ProjectRoleId Long Identifier of the project role to which the rate override belongs.
ProjectRoleName String Name of the project role to which the rate override belongs.
JobId Long Identifier of the job to which the rate override belongs.
JobCode String Code of the job to which the rate override belongs.
JobName String Name of the job to which the rate override belongs.
ExpenditureTypeId Long Identifier of the expenditure type to which the rate override belongs.
ExpenditureTypeName String Name of the expenditure type to which the rate override belongs.
Rate Decimal The rate assigned to the rate override.
CurrencyCode String Currency code associated with the rate override.
CurrencyName String Currency name associated with the rate override.
FromDate Date Date from which the rate override is effective. The date format is YYYY-MM-DD.
ToDate Date Date after which the rate override is no longer effective. The date format is YYYY-MM-DD.
RateOverrideReasonCode String The reason code for changing the rate override.
RateOverrideReason String The reason for changing the rate override. Enter a valid meaning of the lookup code for the Discount Reason lookup type.
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

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