Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

ProductionResources

The Production Resources resource manages production resources that a manufacturing plant uses. A production resource can include labor, equipment, and tools that you allocate to a work center. You can categorize a production resource as Labor or Equipment.

Columns

Name Type Description
OrganizationId Long Value that uniquely identifies the inventory organization. It's 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's 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.
ResourceTypeMeaning String ResourceTypeMeaning of ProductionResources
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 don't consider these costs. The default value is false.
InactiveDate Date Date when the resource becomes inactive. If the date isn't 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.
AutomationEquipmentFlag Bool Contains one of the following values: true or false. If true, then the equipment performs operations automatically. If false, then the equipment requires manual intervention to perform an operation. The default value is false.
AssetItemId Long AssetItemId of ProductionResources
AssetItemNumber String AssetItemNumber of ProductionResources
AssetNumber String AssetNumber of ProductionResources
ChangedDate Date ChangedDate of ProductionResources
EquipmentIdentifier String EquipmentIdentifier of ProductionResources
EquipmentInstanceId Long EquipmentInstanceId of ProductionResources
Finder String Finder of ProductionResources
FirstName String FirstName of ProductionResources
LaborIdentifier String LaborIdentifier of ProductionResources
LaborInstanceId Long LaborInstanceId of ProductionResources
LastName String LastName of ProductionResources
MiddleName String MiddleName of ProductionResources
PartyId Long PartyId of ProductionResources
PersonName String PersonName of ProductionResources
PersonType String PersonType of ProductionResources
PrimaryWorkCenterCode String PrimaryWorkCenterCode of ProductionResources
PrimaryWorkCenterId Long PrimaryWorkCenterId of ProductionResources
WorkCenterId Long WorkCenterId of ProductionResources

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