JDBC Driver for Oracle SCM

Build 22.0.8462

WorkCentersWorkCenterResource

The Work Center Resources resource manages work center resources that the work center uses.

Columns

Name Type Description
WorkCentersWorkCenterId String WorkCentersWorkCenterId of WorkCentersWorkCenterResource
ResourceId String Value that uniquely identifies the work center resource. It is a primary key that the application generates when it creates a work center resource.
ResourceName String Name of the work center resource.
ResourceDescription String ResourceDescription of WorkCentersWorkCenterResource
ResourceCode String ResourceCode of WorkCentersWorkCenterResource
WorkCenterId String WorkCenterId of WorkCentersWorkCenterResource
ResourceQuantity String Number of work center resources assigned to this work center.
Available24HoursFlag Bool Contains one of the following values: true or false. If true, then the work center resource is available 24 hours each day. If false, then the work center resource is not available 24 hours each day. A work center resource that is not available 24 hours each day is available only during the shifts that you assign to this work center resource. A work center resource is available in shifts only if this attribute is set to false. The default value is true.
CheckCtpFlag Bool Contains one of the following values: true or false. If true, then Oracle Global Order Promising Cloud considers the capacity of this work center resource during order promising. If false, then Global Order Promising does not consider this capacity. If this attribute is set to false, then the capable-to-promise (CTP) check does not consider the capacity of this work center resource. The default value is false.
UtilizationPercentage String Percent of time that is available to perform the task.
EfficiencyPercentage String Percent of time that the work center resource requires to finish the task.

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