JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

WorkCentersWorkCenterResource

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

Columns

Name Type Description
WorkCentersWorkCenterId [KEY] Long WorkCentersWorkCenterId of WorkCentersWorkCenterResource
ResourceId [KEY] Long 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
ResourceType String ResourceType of WorkCentersWorkCenterResource
WorkCenterId [KEY] Long WorkCenterId of WorkCentersWorkCenterResource
ResourceQuantity Decimal 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 Decimal Percent of time that is available to perform the task.
EfficiencyPercentage Decimal Percent of time that the work center resource requires to finish the task.
ChangedDate Date ChangedDate of WorkCentersWorkCenterResource
Finder String Finder of WorkCentersWorkCenterResource
SubinventoryName String SubinventoryName of WorkCentersWorkCenterResource

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