Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

ProductionResources

ProductionResources

Columns

Name Type Description
OrganizationId Long Value that uniquely identifies the inventory organization. It is a primary key that the application generates when it creates an inventory organization.
OrganizationCode String Abbreviation that identifies the inventory organization.
OrganizationName String OrganizationName of ProductionResources
ResourceId [KEY] Long Value that uniquely identifies the production resource. It is a primary key that the application generates when it creates a production resource.
ResourceName String Name of the production resource.
ResourceDescription String Description of the production resource.
ResourceCode String Abbreviation that identifies the production resource.
ResourceType String Value that indicates the type of the production resource. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_TYPE.
UOMCode String Abbreviation that identifies the unit of measure. The application uses this code for scheduling and for resource charge. To use this resource for scheduling, it must be part of a valid Time UOM class.
UnitOfMeasure String UnitOfMeasure of ProductionResources
ResourceClassCode String Abbreviation that identifies the class that groups production resources. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_CLASS.
CostedFlag Bool Contains one of the following values: true or false. If true, then consider resource costs in work order costing. If false, then do not consider these costs. The default value is false.
InactiveDate Date Date when the resource becomes inactive. If date is not specified, the resource is considered active.
DefaultExpenditureTypeId Long Value that uniquely identifies the expenditure type used for project-related transaction distributions. This attribute is associated with a feature that requires opt in.
DefaultExpenditureTypeName String Name of the cost classification assigned to each expenditure item. Expenditure types are grouped into cost groups and revenue groups. This attribute is associated with a feature that requires opt in.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
AssetItemId Long AssetItemId
AssetItemNumber String AssetItemNumber
AssetNumber String AssetNumber
ChangedDate Date ChangedDate
EquipmentIdentifier String EquipmentIdentifier
EquipmentInstanceId Long EquipmentInstanceId
FirstName String FirstName
LaborIdentifier String LaborIdentifier
LaborInstanceId Long LaborInstanceId
LastName String LastName
MiddleName String MiddleName
PartyId Long PartyId
PersonName String PersonName
PersonType String PersonType
PrimaryWorkCenterCode String PrimaryWorkCenterCode
PrimaryWorkCenterId Long PrimaryWorkCenterId
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839