WorkCentersWorkCenterResourceWorkCenterResourceShift
WorkCentersWorkCenterResourceWorkCenterResourceShift
Columns
Name | Type | Description |
WorkCentersWorkCenterId [KEY] | Long | WorkCentersWorkCenterId of WorkCentersWorkCenterResourceWorkCenterResourceShift |
WorkcenterresourceResourceId [KEY] | Long | WorkcenterresourceResourceId of WorkCentersWorkCenterResourceWorkCenterResourceShift |
WorkcenterresourceWorkCenterId [KEY] | Long | WorkcenterresourceWorkCenterId of WorkCentersWorkCenterResourceWorkCenterResourceShift |
WorkCenterId [KEY] | Long | WorkCenterId of WorkCentersWorkCenterResourceWorkCenterResourceShift |
PlantCalendarId | Long | PlantCalendarId of WorkCentersWorkCenterResourceWorkCenterResourceShift |
ShiftId [KEY] | Long | ShiftId of WorkCentersWorkCenterResourceWorkCenterResourceShift |
ShiftName | String | ShiftName of WorkCentersWorkCenterResourceWorkCenterResourceShift |
StartTime | String | StartTime of WorkCentersWorkCenterResourceWorkCenterResourceShift |
Duration | String | Duration of WorkCentersWorkCenterResourceWorkCenterResourceShift |
AssignedUnits | Double | AssignedUnits of WorkCentersWorkCenterResourceWorkCenterResourceShift |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
ChangedDate | Date | ChangedDate |
ResourceId | Long | ResourceId |
SubinventoryName | String | SubinventoryName |
Finder | String | finder |