WorkCentersWorkCenterResource
WorkCentersWorkCenterResource
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 |
| WorkCenterId [KEY] | Long | WorkCenterId of WorkCentersWorkCenterResource |
| ResourceQuantity | Double | 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 | Double | Percent of time that is available to perform the task. |
| EfficiencyPercentage | Double | Percent of time that the work center resource requires to finish the task. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ChangedDate | Date | ChangedDate |
| SubinventoryName | String | SubinventoryName |
| Finder | String | finder |