WorkOrdersWorkOrderOperation
WorkOrdersWorkOrderOperation
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperation |
| OrganizationId | Long | OrganizationId of WorkOrdersWorkOrderOperation |
| WorkOrderId | Long | Value that uniquely identifies the work order. It is a primary key that the application generates when it creates the work order. |
| WorkOrderNumber | String | WorkOrderNumber of WorkOrdersWorkOrderOperation |
| WorkOrderOperationId [KEY] | Long | WorkOrderOperationId of WorkOrdersWorkOrderOperation |
| OperationSequenceNumber | Double | Sequence to use when performing the work order operations. |
| OperationName | String | Name of the operation. |
| OperationDescription | String | Description of the operation. |
| OperationType | String | Type of operation. It includes one of the following values. IN_HOUSE: the organization that owns the work order performs the operation. SUPPLIER: a supplier performs the operation. |
| OperationTypeDescription | String | OperationTypeDescription of WorkOrdersWorkOrderOperation |
| StandardOperationId | Long | Value that uniquely identifies the standard operation that the work order references. It is a primary key that the application generates when it creates the standard operation. |
| StandardOperationCode | String | Abbreviation that identifies the standard operation. |
| StandardOperationName | String | StandardOperationName of WorkOrdersWorkOrderOperation |
| WorkAreaId | Long | WorkAreaId of WorkOrdersWorkOrderOperation |
| WorkAreaCode | String | WorkAreaCode of WorkOrdersWorkOrderOperation |
| WorkAreaName | String | WorkAreaName of WorkOrdersWorkOrderOperation |
| WorkAreaDescription | String | WorkAreaDescription of WorkOrdersWorkOrderOperation |
| WorkCenterId | Long | Value that uniquely identifies the work center. It is a primary key that the application generates when it creates the work center. |
| WorkCenterCode | String | Abbreviation that identifies the work center. |
| WorkCenterName | String | WorkCenterName of WorkOrdersWorkOrderOperation |
| WorkCenterDescription | String | WorkCenterDescription of WorkOrdersWorkOrderOperation |
| OSPItemId | Long | Value that uniquely identifies outside processing (OSP) item. It is a primary key that the application generates when it creates an item. |
| OSPItemNumber | String | Number that identifies outside processing (OSP) item. |
| OSPItemDescription | String | OSPItemDescription of WorkOrdersWorkOrderOperation |
| SupplierId | Long | Value that uniquely identifies outside processing (OSP) supplier. It is a primary key that the application generates when it creates a supplier. |
| SupplierName | String | Name of the outside processing (OSP) supplier. |
| SupplierSiteId | Long | Value that uniquely identifies supplier site. It is a primary key that the application generates when it creates a site of a supplier. |
| SupplierSiteCode | String | Abbreviation that identifies the supplier site. |
| SupplierSiteDescription | String | SupplierSiteDescription of WorkOrdersWorkOrderOperation |
| FixedLeadTime | Double | Lead time to perform this outside processing (OSP) operation independent of the quantity of the OSP item. |
| VariableLeadTime | Double | Lead time to perform this outside processing (OSP) operation for each unit of the OSP item. |
| LeadTimeUOM | String | Abbreviation that identifies the unit of measure that the lead time uses. |
| LeadTimeUnitOfMeasure | String | LeadTimeUnitOfMeasure of WorkOrdersWorkOrderOperation |
| CountPointOperationFlag | Bool | Contains one of the following values: true or false. If true, then this operation is a count point operation. If an operation is a count point operation, then you have to manually complete it. If false, then this operation isn't a count point operation. The last operation in a work order should always be a count point operation. This attribute doesn't have a default value. |
| AutoTransactFlag | Bool | Contains one of the following values: true or false. If true, the operation is automatically reported and both resources and materials are automatically charged based on the supply type or the charge type setups. If false, then the operation isn't automatically reported. The count point attribute and the automatically transact attribute are mutually exclusive. You must make sure that each of these attributes do not both contain true. If count point and automatically transact each contain false, then the operation is optional. You can manually report component usage and resource usage for an optional operation. This attribute doesn't have a default value. |
| ResequenceFlag | Bool | Contains one of the following values: true or false. If true, then the work order has resequence operations. If false, then the work order doesn't have resequence operations. This attribute is associated with a feature that requires an opt in. |
| ExecutionSequence | Double | ExecutionSequence of WorkOrdersWorkOrderOperation |
| PORequestedQuantity | Double | PORequestedQuantity of WorkOrdersWorkOrderOperation |
| POApprovedQuantity | Double | POApprovedQuantity of WorkOrdersWorkOrderOperation |
| OverReceiptQuantity | Double | OverReceiptQuantity of WorkOrdersWorkOrderOperation |
| InProcessQuantity | Double | InProcessQuantity of WorkOrdersWorkOrderOperation |
| ReceivedQuantity | Double | ReceivedQuantity of WorkOrdersWorkOrderOperation |
| ShippedQuantity | Double | ShippedQuantity of WorkOrdersWorkOrderOperation |
| ReadyQuantity | Double | ReadyQuantity of WorkOrdersWorkOrderOperation |
| CompletedQuantity | Double | CompletedQuantity of WorkOrdersWorkOrderOperation |
| ScrappedQuantity | Double | ScrappedQuantity of WorkOrdersWorkOrderOperation |
| RejectedQuantity | Double | RejectedQuantity of WorkOrdersWorkOrderOperation |
| UnitOfMeasure | String | UnitOfMeasure of WorkOrdersWorkOrderOperation |
| PlannedStartDate | Datetime | Planned date and time to start the operation. The scheduling application sets this date. The planned start date must not occur before the start date of the work order or after the finish date of the work order. This attribute is required. |
| PlannedCompletionDate | Datetime | Planned date and time to finish the operation. The scheduling application sets this date. The planned completion date must not occur before the start date of the work order or after the finish date of the work order. This attribute is required. |
| ActualStartDate | Datetime | ActualStartDate of WorkOrdersWorkOrderOperation |
| ActualCompletionDate | Datetime | ActualCompletionDate of WorkOrdersWorkOrderOperation |
| DelayStatus | Int | DelayStatus of WorkOrdersWorkOrderOperation |
| MaterialsCount | Int | MaterialsCount of WorkOrdersWorkOrderOperation |
| ResourcesCount | Int | ResourcesCount of WorkOrdersWorkOrderOperation |
| SerialTrackingFlag | Bool | SerialTrackingFlag of WorkOrdersWorkOrderOperation |
| ShippingDocumentsFlag | Bool | Contains one of the following values: true or false. If true, then create shipping documents for this outside processing (OSP) operation. If false, then do not create these shipping documents. This attribute doesn't have a default value. |
| CreatedBy | String | CreatedBy of WorkOrdersWorkOrderOperation |
| CreationDate | Datetime | CreationDate of WorkOrdersWorkOrderOperation |
| LastUpdateDate | Datetime | LastUpdateDate of WorkOrdersWorkOrderOperation |
| LastUpdatedBy | String | LastUpdatedBy of WorkOrdersWorkOrderOperation |
| AdditionalMaterialAtManualIssue | String | Value that controls whether a production operator can issue more than the required quantity while manually reporting material issues. You can issue more than the required quantity without any hindrance, or prevent the material issue in case of additional material issue. |
| OperationCompletionWithOpenExceptions | String | Value that controls whether operation completion is allowed when open exceptions exist for an operation. You can complete an operation without any hindrance, allow with a warning, or prevent operation completion. |
| OperationCompletionWithUnderIssue | String | Value that controls whether operation completion is allowed when less than the required quantity of material is issued. You can complete an operation without any hindrance, allow with a warning, or prevent operation completion. |
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 |