WorkOrdersWorkOrderActiveOperation
WorkOrdersWorkOrderActiveOperation
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | WorkOrdersWorkOrderId of WorkOrdersWorkOrderActiveOperation |
| OrganizationId | Long | OrganizationId of WorkOrdersWorkOrderActiveOperation |
| WorkOrderId | Long | WorkOrderId of WorkOrdersWorkOrderActiveOperation |
| WorkOrderNumber | String | WorkOrderNumber of WorkOrdersWorkOrderActiveOperation |
| WorkOrderOperationId [KEY] | Long | WorkOrderOperationId of WorkOrdersWorkOrderActiveOperation |
| OperationSequenceNumber | Double | OperationSequenceNumber of WorkOrdersWorkOrderActiveOperation |
| OperationName | String | OperationName of WorkOrdersWorkOrderActiveOperation |
| OperationDescription | String | OperationDescription of WorkOrdersWorkOrderActiveOperation |
| OperationType | String | OperationType of WorkOrdersWorkOrderActiveOperation |
| OperationTypeDescription | String | OperationTypeDescription of WorkOrdersWorkOrderActiveOperation |
| StandardOperationId | Long | StandardOperationId of WorkOrdersWorkOrderActiveOperation |
| StandardOperationCode | String | StandardOperationCode of WorkOrdersWorkOrderActiveOperation |
| StandardOperationName | String | StandardOperationName of WorkOrdersWorkOrderActiveOperation |
| WorkAreaId | Long | WorkAreaId of WorkOrdersWorkOrderActiveOperation |
| WorkAreaCode | String | WorkAreaCode of WorkOrdersWorkOrderActiveOperation |
| WorkAreaName | String | WorkAreaName of WorkOrdersWorkOrderActiveOperation |
| WorkAreaDescription | String | WorkAreaDescription of WorkOrdersWorkOrderActiveOperation |
| WorkCenterId | Long | WorkCenterId of WorkOrdersWorkOrderActiveOperation |
| WorkCenterCode | String | WorkCenterCode of WorkOrdersWorkOrderActiveOperation |
| WorkCenterName | String | WorkCenterName of WorkOrdersWorkOrderActiveOperation |
| WorkCenterDescription | String | WorkCenterDescription of WorkOrdersWorkOrderActiveOperation |
| OSPItemId | Long | OSPItemId of WorkOrdersWorkOrderActiveOperation |
| OSPItemNumber | String | OSPItemNumber of WorkOrdersWorkOrderActiveOperation |
| OSPItemDescription | String | OSPItemDescription of WorkOrdersWorkOrderActiveOperation |
| SupplierId | Long | SupplierId of WorkOrdersWorkOrderActiveOperation |
| SupplierName | String | SupplierName of WorkOrdersWorkOrderActiveOperation |
| SupplierSiteId | Long | SupplierSiteId of WorkOrdersWorkOrderActiveOperation |
| SupplierSiteCode | String | SupplierSiteCode of WorkOrdersWorkOrderActiveOperation |
| SupplierSiteDescription | String | SupplierSiteDescription of WorkOrdersWorkOrderActiveOperation |
| FixedLeadTime | Double | FixedLeadTime of WorkOrdersWorkOrderActiveOperation |
| VariableLeadTime | Double | VariableLeadTime of WorkOrdersWorkOrderActiveOperation |
| LeadTimeUOM | String | LeadTimeUOM of WorkOrdersWorkOrderActiveOperation |
| LeadTimeUnitOfMeasure | String | LeadTimeUnitOfMeasure of WorkOrdersWorkOrderActiveOperation |
| CountPointOperationFlag | Bool | CountPointOperationFlag of WorkOrdersWorkOrderActiveOperation |
| AutoTransactFlag | Bool | AutoTransactFlag of WorkOrdersWorkOrderActiveOperation |
| ResequenceFlag | Bool | ResequenceFlag of WorkOrdersWorkOrderActiveOperation |
| ExecutionSequence | Double | ExecutionSequence of WorkOrdersWorkOrderActiveOperation |
| PORequestedQuantity | Double | PORequestedQuantity of WorkOrdersWorkOrderActiveOperation |
| POApprovedQuantity | Double | POApprovedQuantity of WorkOrdersWorkOrderActiveOperation |
| OverReceiptQuantity | Double | OverReceiptQuantity of WorkOrdersWorkOrderActiveOperation |
| InProcessQuantity | Double | InProcessQuantity of WorkOrdersWorkOrderActiveOperation |
| ReceivedQuantity | Double | ReceivedQuantity of WorkOrdersWorkOrderActiveOperation |
| ShippedQuantity | Double | ShippedQuantity of WorkOrdersWorkOrderActiveOperation |
| ReadyQuantity | Double | ReadyQuantity of WorkOrdersWorkOrderActiveOperation |
| CompletedQuantity | Double | CompletedQuantity of WorkOrdersWorkOrderActiveOperation |
| ScrappedQuantity | Double | ScrappedQuantity of WorkOrdersWorkOrderActiveOperation |
| RejectedQuantity | Double | RejectedQuantity of WorkOrdersWorkOrderActiveOperation |
| UnitOfMeasure | String | UnitOfMeasure of WorkOrdersWorkOrderActiveOperation |
| PlannedStartDate | Datetime | PlannedStartDate of WorkOrdersWorkOrderActiveOperation |
| PlannedCompletionDate | Datetime | PlannedCompletionDate of WorkOrdersWorkOrderActiveOperation |
| ActualStartDate | Datetime | ActualStartDate of WorkOrdersWorkOrderActiveOperation |
| ActualCompletionDate | Datetime | ActualCompletionDate of WorkOrdersWorkOrderActiveOperation |
| DelayStatus | Int | DelayStatus of WorkOrdersWorkOrderActiveOperation |
| MaterialsCount | Int | MaterialsCount of WorkOrdersWorkOrderActiveOperation |
| ResourcesCount | Int | ResourcesCount of WorkOrdersWorkOrderActiveOperation |
| SerialTrackingFlag | Bool | SerialTrackingFlag of WorkOrdersWorkOrderActiveOperation |
| ShippingDocumentsFlag | Bool | ShippingDocumentsFlag of WorkOrdersWorkOrderActiveOperation |
| CreatedBy | String | CreatedBy of WorkOrdersWorkOrderActiveOperation |
| CreationDate | Datetime | CreationDate of WorkOrdersWorkOrderActiveOperation |
| LastUpdateDate | Datetime | LastUpdateDate of WorkOrdersWorkOrderActiveOperation |
| LastUpdatedBy | String | LastUpdatedBy of WorkOrdersWorkOrderActiveOperation |
| AdditionalMaterialAtManualIssue | String | AdditionalMaterialAtManualIssue of WorkOrdersWorkOrderActiveOperation |
| OperationCompletionWithOpenExceptions | String | OperationCompletionWithOpenExceptions of WorkOrdersWorkOrderActiveOperation |
| OperationCompletionWithUnderIssue | String | OperationCompletionWithUnderIssue of WorkOrdersWorkOrderActiveOperation |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BackToBackFlag | String | BackToBackFlag |
| ContractMfgFlag | String | ContractMfgFlag |
| DueDays | Int | DueDays |
| FirmPlannedFlag | String | FirmPlannedFlag |
| InventoryItemId | Long | InventoryItemId |
| ItemNumber | String | ItemNumber |
| MaterialItemId | Long | MaterialItemId |
| ProductSerialId | Long | ProductSerialId |
| ResourceId | Long | ResourceId |
| SerialNumber | String | SerialNumber |
| SourceHeaderRefId | Long | SourceHeaderRefId |
| SourceHeaderReferenceId | Long | SourceHeaderReferenceId |
| SourceLineRefId | Long | SourceLineRefId |
| SourceLineReferenceId | Long | SourceLineReferenceId |
| SourceSystemId | Long | SourceSystemId |
| Tolerance | Int | Tolerance |
| WoProjectNumber | String | WoProjectNumber |
| WoTaskNumber | String | WoTaskNumber |
| WorkOrderStatusId | Long | WorkOrderStatusId |
| Finder | String | finder |