ODBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ProjectPlanningRbsElements

The Elements resource is used to view and create resources in a planning resource breakdown structure.

Columns

Name Type Description
ProjectPlanningRbsRbsPrjAssignmentId [KEY] Long Unique identifier of the assignment of the resource breakdown structure version to the project.
DisabledFlag Bool Indicates if the resource is disabled for use in planning.
EventTypeId Long Unique identifier of the event type. If the format has Event Type, then you must enter a value for either this attribute or Event Type but not both while creating a resource element.
EventTypeName String Name of the event type. If the format has Event Type, then you must enter a value for either this attribute or Event Type ID but not both while creating a resource element.
ExpenditureCategoryId Long Unique identifier of the expenditure category. If the format has Expenditure Category, then you must enter a value for either this attribute or Expenditure Category but not both while creating a resource element.
ExpenditureCategoryName String Name of the expenditure category. If the format has Expenditure Category, then you must enter a value for either this attribute or Expenditure Category ID but not both while creating a resource element.
ExpenditureTypeId Long Unique identifier of the expenditure type. If the format has Expenditure Type, then you must enter a value for either this attribute or Expenditure Type but not both while creating a resource element.
ExpenditureTypeName String Name of the expenditure type. If the format has Expenditure Type, then you must enter a value for either this attribute or Expenditure Type ID but not both while creating a resource element.
FormatId Long Unique identifier of the resource format. You must enter a value for either this attribute or Format but not both while creating a resource element.
FormatName String Name of the resource format. You must enter a value for either this attribute or Format ID but not both while creating a resource element.
InventoryItemId Long Unique identifier of the inventory item. If the format has Inventory Item, then you must enter a value for either this attribute or Inventory Item Number but not both while creating a resource element.
InventoryItemNumber String Number assigned to the inventory item. If the format has Inventory Item, then you must enter a value for either this attribute or Inventory Item ID but not both while creating a resource element.
ItemCategoryCode String Code of the item category. If the format has Item Category, then you must enter a value for only one from among this attribute, Item Category ID, and Item Category but not all three or a combination of them while creating a resource element.
ItemCategoryId Long Unique identifier of the item category. If the format has Item Category, then you must enter a value for only one from among this attribute, Item Category Code, and Item Category but not all three or a combination of them while creating a resource element.
ItemCategoryName String Name of the item category. If the format has Item Category, then you must enter a value for only one from among this attribute, Item Category ID, and Item Category Code but not all three or a combination of them while creating a resource element.
JobCode String Code of the job. If the format has Job, then you must enter a value for only one from among this attribute, Job ID, and Job but not all three or a combination of them while creating a resource element.
JobId Long Unique identifier of the job. If the format has Job, then you must enter a value for only one from among this attribute, Job Code, and Job but not all three or a combination of them while creating a resource element.
JobName String Name of the job. If the format has Job, then you must enter a value for only one from among this attribute, Job ID, and Job Code but not all three or a combination of them while creating a resource element.
NonlaborResourceId Long Unique identifier of the nonlabor resource. If the format has Project Nonlabor Resource, then you must enter a value for either this attribute or Nonlabor Resource but not both while creating a resource element.
NonlaborResourceName String Name of the nonlabor resource. If the format has Project Nonlabor Resource, then you must enter a value for either this attribute or Nonlabor Resource ID but not both while creating a resource element.
OrganizationId Long Unique identifier of the organization. If the format has Organization, then you must enter a value for either this attribute or Organization but not both while creating a resource element.
OrganizationName String Name of the organization. If the format has Organization, then you must enter a value for either this attribute or Organization ID but not both while creating a resource element.
PersonEmail String Email of the person. If the format has Named Person, then you must enter a value for only one from among this attribute, Person ID, and Person but not all three or a combination of them while creating a resource element.
PersonId Long Unique identifier of the person. If the format has Named Person, then you must enter a value for only one from among this attribute, Person Email, and Person but not all three or a combination of them while creating a resource element.
PersonName String Name of the person. If the format has Named Person, then you must enter a value for only one from among this attribute, Person ID, and Person Email but not all three or a combination of them while creating a resource element.
PersonType String Type of the person. If the format has System Person Type, then you must enter a value for either this attribute or Person Type Code but not both while creating a resource element.
PersonTypeCode String Code of the person type. If the format has System Person Type, then you must enter a value for either this attribute or Person Type but not both while creating a resource element.
ProjectRoleId Long Unique identifier of the project role. If the format has Project Role, then you must pass a value for Project Role ID or Project Role Name but not both values while creating a resource element.
ProjectRoleName String Name of the project role. If the format has Project Role, then you must pass a value for Project Role ID or Project Role Name but not both values while creating a resource element.
ResourceClassId Long Unique identifier of the resource class. You must enter a value for either this attribute or Resource Class but not both while creating a resource element.
ResourceClassName String Name of the resource class. You must enter a value for either this attribute or Resource Class ID but not both while creating a resource element.
ResourceElementId [KEY] Long Unique identifier of the resource breakdown structure element.
RevenueCategoryCode String Code of the revenue category. If the format has Revenue Category, then you must enter a value for either this attribute or Revenue Category but not both while creating a resource element.
RevenueCategoryName String Name of the revenue category. If the format has Revenue Category, then you must enter a value for either this attribute or Revenue Category ID but not both while creating a resource element.
SpreadCurveId Long Unique identifier of the spread curve. If you want to specify the spread curve, then you must enter a value for either this attribute or Spread Curve but not both while creating a resource element.
SpreadCurveName String Name of the spread curve. If you want to specify the spread curve, then you must enter a value for either this attribute or Spread Curve ID but not both while creating a resource element.
SupplierId Long Unique identifier of the supplier. If the format has Supplier, then you must enter a value for only one from among this attribute, Supplier Number, and Supplier but not all three or a combination of them while creating a resource element.
SupplierName String Name of the supplier. If the format has Supplier, then you must enter a value for only one from among this attribute, Supplier ID, and Supplier Number but not all three or a combination of them while creating a resource element.
SupplierNumber String Number assigned to the supplier. If the format has Supplier, then you must enter a value for only one from among this attribute, Supplier ID, and Supplier but not all three or a combination of them while creating a resource element.
UnitOfMeasure String Name of the default unit of measure of costing or planning transactions.
UnitOfMeasureCode String Code of the default unit of measure of costing or planning transactions.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.
ResourceName String User defined short name for the resource breakdown structure element.
Finder String finder
RbsPrjAssignmentId Long rbsprjassignmentid

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