DispatchListWorkOrderOperations
DispatchListWorkOrderOperations
Columns
| Name | Type | Description |
| OrganizationId | Long | OrganizationId of DispatchListWorkOrderOperations |
| OrganizationCode | String | OrganizationCode of DispatchListWorkOrderOperations |
| OrganizationName | String | OrganizationName of DispatchListWorkOrderOperations |
| WorkAreaId | Long | WorkAreaId of DispatchListWorkOrderOperations |
| WorkAreaCode | String | WorkAreaCode of DispatchListWorkOrderOperations |
| WorkAreaName | String | WorkAreaName of DispatchListWorkOrderOperations |
| WorkCenterId | Long | WorkCenterId of DispatchListWorkOrderOperations |
| WorkCenterCode | String | WorkCenterCode of DispatchListWorkOrderOperations |
| WorkCenterName | String | WorkCenterName of DispatchListWorkOrderOperations |
| WorkCenterDescription | String | WorkCenterDescription of DispatchListWorkOrderOperations |
| WorkOrderId | Long | WorkOrderId of DispatchListWorkOrderOperations |
| WorkOrderNumber | String | WorkOrderNumber of DispatchListWorkOrderOperations |
| WorkOrderDescription | String | WorkOrderDescription of DispatchListWorkOrderOperations |
| InventoryItemId | Long | InventoryItemId of DispatchListWorkOrderOperations |
| ItemNumber | String | ItemNumber of DispatchListWorkOrderOperations |
| ItemDescription | String | ItemDescription of DispatchListWorkOrderOperations |
| OperationId [KEY] | Long | OperationId of DispatchListWorkOrderOperations |
| OperationSequenceNumber | Double | OperationSequenceNumber of DispatchListWorkOrderOperations |
| OperationName | String | OperationName of DispatchListWorkOrderOperations |
| OperationDescription | String | OperationDescription of DispatchListWorkOrderOperations |
| DispatchState [KEY] | String | DispatchState of DispatchListWorkOrderOperations |
| Quantity | Double | Quantity of DispatchListWorkOrderOperations |
| UnitOfMeasure | String | UnitOfMeasure of DispatchListWorkOrderOperations |
| PlannedStartDate | Datetime | PlannedStartDate of DispatchListWorkOrderOperations |
| PlannedCompletionDate | Datetime | PlannedCompletionDate of DispatchListWorkOrderOperations |
| WorkOrderPriority | Double | WorkOrderPriority of DispatchListWorkOrderOperations |
| PurchaseOrderId | Long | PurchaseOrderId of DispatchListWorkOrderOperations |
| PurchaseOrder | String | PurchaseOrder of DispatchListWorkOrderOperations |
| PurchaseOrderLineId | Long | PurchaseOrderLineId of DispatchListWorkOrderOperations |
| PurchaseOrderLine | Double | PurchaseOrderLine of DispatchListWorkOrderOperations |
| CustomerId | Double | CustomerId of DispatchListWorkOrderOperations |
| CustomerName | String | CustomerName of DispatchListWorkOrderOperations |
| OperationStartStopStatusCode | Long | OperationStartStopStatusCode of DispatchListWorkOrderOperations |
| OperationStartStopStatus | String | OperationStartStopStatus of DispatchListWorkOrderOperations |
| WorkMethodCode | String | WorkMethodCode of DispatchListWorkOrderOperations |
| ProcessName | String | ProcessName of DispatchListWorkOrderOperations |
| ProjectId | Long | ProjectId of DispatchListWorkOrderOperations |
| ProjectNumber | String | ProjectNumber of DispatchListWorkOrderOperations |
| TaskId | Long | TaskId of DispatchListWorkOrderOperations |
| TaskNumber | String | TaskNumber of DispatchListWorkOrderOperations |
| ExecutionSequence | Double | ExecutionSequence of DispatchListWorkOrderOperations |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SerialNumber | String | SerialNumber |
| Finder | String | finder |