JDBC Driver for Oracle SCM

Build 22.0.8462

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 String 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] String 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 String 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462