WorkOrders
WorkOrders
Columns
| Name | Type | Description |
| OrganizationId | Long | Value that uniquely identifies the inventory organization that's enabled for manufacturing. It is a primary key of the inventory organization. |
| OrganizationCode | String | Abbreviation that identifies the inventory organization that's enabled for manufacturing. |
| OrganizationName | String | OrganizationName of WorkOrders |
| WorkOrderId [KEY] | 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 | Number that identifies the work order. This number is unique in the manufacturing organization. The user can manually assign the number when the user creates the work order, or can allow the application to create a unique number from the numbering scheme defined by these plant parameters: Work Order Prefix or Work Order Starting Number. |
| WorkOrderDescription | String | Description of the work order. |
| WorkMethodId | Long | WorkMethodId of WorkOrders |
| WorkOrderType | String | Type of work order that the user selected when creating the work order. |
| WorkOrderTypeDescription | String | WorkOrderTypeDescription of WorkOrders |
| WorkOrderSubType | String | Description of the work being performed. Values include Standard Production, Prototyping, or Repair. |
| WorkOrderSubTypeDescription | String | WorkOrderSubTypeDescription of WorkOrders |
| InventoryItemId | Long | Value that uniquely identifies the item, product, or assembly in the inventory organization. |
| ItemNumber | String | Number that identifies the item, which is an output of the work order. |
| Description | String | Description of WorkOrders |
| ItemRevision | String | ItemRevision of WorkOrders |
| ItemStructureName | String | ItemStructureName of WorkOrders |
| TransformFromItemId | Long | Value that uniquely identifies the item that transforms to the inventory item on this work order. |
| TransformFromItemNumber | String | Number that uniquely identifies the item that the user defines for the item that's to be transformed. |
| WorkDefinitionAsOfDate | Datetime | As-of date that the work definition uses to determine the work definition version. |
| WorkDefinitionId | Long | Value that uniquely identifies the work definition. |
| WorkDefinitionCode | String | Abbreviation that identifies the work definition. |
| WorkDefinitionVersionId | Long | WorkDefinitionVersionId of WorkOrders |
| WorkDefinitionVersionNumber | String | WorkDefinitionVersionNumber of WorkOrders |
| WorkDefinitionName | String | WorkDefinitionName of WorkOrders |
| WorkOrderPriority | Double | Priority to use when determining when to run the work order in relation to other work orders. |
| WorkOrderStatusId | Long | Value that uniquely identifies the work order status. A list of all the valid work order statuses can be retrieved using the workOrderStatuses resource. |
| WorkOrderStatusName | String | WorkOrderStatusName of WorkOrders |
| WorkOrderStatusCode | String | Abbreviation that identifies the work order status. A list of all the valid work order statuses can be retrieved using the workOrderStatuses resource. |
| WorkOrderSystemStatusCode | String | WorkOrderSystemStatusCode of WorkOrders |
| SchedulingMethod | String | Scheduling method that the application uses to schedule the work order. The default value is DEFAULT_SCHEDULING. |
| PlannedStartQuantity | Double | Planned production quantity for the work order. |
| CompletedQuantity | Double | CompletedQuantity of WorkOrders |
| ScrappedQuantity | Double | ScrappedQuantity of WorkOrders |
| RejectedQuantity | Double | RejectedQuantity of WorkOrders |
| NettableSupplyQuantityOverride | Double | Quantity that the planning system uses as supply from the work order. |
| UOMCode | String | UOMCode of WorkOrders |
| UnitOfMeasure | String | UnitOfMeasure of WorkOrders |
| FirmPlannedFlag | Bool | Contains one of the following values: true or false. If true, then planning doesn't consider the work order when rescheduling or re-planning. If false, then planning can suggest rescheduling and re-planning recommendations with respect to the work order. The default value is false. |
| PlannedStartDate | Datetime | Scheduled date and time when the work order starts. |
| PlannedCompletionDate | Datetime | Scheduled date and time when the work order completes. |
| ActualStartDate | Datetime | ActualStartDate of WorkOrders |
| ActualCompletionDate | Datetime | ActualCompletionDate of WorkOrders |
| ReleasedDate | Datetime | Date when the work order is released. |
| ClosedDate | Datetime | Date when the work order is closed. |
| CanceledDate | Datetime | CanceledDate of WorkOrders |
| DelayStatus | Int | DelayStatus of WorkOrders |
| WorkOrderDate | Datetime | WorkOrderDate of WorkOrders |
| CanceledReason | String | Reason for canceling the work order. |
| OvercomplToleranceType | String | Tolerance type for completing more work than the work order quantity requires. |
| OvercomplToleranceValue | Double | Percent or quantity to allow the finished work to exceed the work order quantity. |
| OvercomplToleranceTypeDescription | String | OvercomplToleranceTypeDescription of WorkOrders |
| UndercomplToleranceType | String | Tolerance type for completing less work than the work order quantity requires. This attribute is associated with a feature that requires opt in. |
| UndercomplToleranceValue | Double | Percent or quantity to allow the finished work to succeed the work order quantity. This attribute is associated with a feature that requires opt in. |
| UndercomplToleranceTypeDescription | String | UndercomplToleranceTypeDescription of WorkOrders |
| UnderCompletedFlag | Bool | UnderCompletedFlag of WorkOrders |
| SupplyType | String | Default supply type to use for the work order components. |
| SupplyTypeDescription | String | SupplyTypeDescription of WorkOrders |
| CompletionSubinventoryCode | String | Completion subinventory to use, by default, when considering the work order for product completion. |
| CompletionLocatorId | Long | Value that uniquely identifies the locator. It is a primary key that the application generates when it creates the locator. |
| CompletionLocator | String | Completion locator to use, by default, when considering the work order for product completion. |
| SerialTrackingFlag | Bool | Contains one of the following values: true or false. If true, then serial tracking is enforced for the work order. If false, then serial tracking isn't enforced. The default value depends on the work definition that the work order references. The default value is false. |
| PreassignLotFlag | Bool | Contains one of the following values: true or false. If true, then one or more lot numbers can be preassigned to a product in the work order. If false, then preassigned lot numbers cannot be associated with a work order. The value of this attribute is copied from the work definition and doesn't have a default value. This attribute is associated with a feature that requires opt in. |
| BackToBackFlag | Bool | BackToBackFlag of WorkOrders |
| ContractMfgFlag | Bool | ContractMfgFlag of WorkOrders |
| ResequenceFlag | Bool | ResequenceFlag of WorkOrders |
| OrchestrationCode | String | OrchestrationCode of WorkOrders |
| InterfaceSourceCode | String | InterfaceSourceCode of WorkOrders |
| ScoSupplyOrderId | Long | ScoSupplyOrderId of WorkOrders |
| CmPOHeaderId | Long | CmPOHeaderId of WorkOrders |
| CmPOLineId | Long | CmPOLineId of WorkOrders |
| CmPOLineLocId | Long | CmPOLineLocId of WorkOrders |
| OrderLessFlag | Bool | OrderLessFlag of WorkOrders |
| SourceSystemType | String | Type of source system. Values include INTERNAL or EXTERNAL. |
| SourceSystemId | Long | Value that uniquely identifies the source system. |
| SourceHeaderReference | String | SourceHeaderReference of WorkOrders |
| SourceHeaderReferenceId | Long | SourceHeaderReferenceId of WorkOrders |
| SourceLineReference | String | SourceLineReference of WorkOrders |
| SourceLineReferenceId | Long | SourceLineReferenceId of WorkOrders |
| ProjectNumber | String | ProjectNumber of WorkOrders |
| TaskNumber | String | TaskNumber of WorkOrders |
| CreationDate | Datetime | CreationDate of WorkOrders |
| LastUpdateDate | Datetime | LastUpdateDate of WorkOrders |
| CreatedBy | String | CreatedBy of WorkOrders |
| LastUpdatedBy | String | LastUpdatedBy of WorkOrders |
| ExplosionFlag | Bool | Contains one of the following values: true or false. If true, then the application creates work order operations, operation materials, and operation resources from the work definition on the work order header. If false, then the application doesn't create these operations, materials, or resources from the work definition. The default value is false. |
| WorkMethodCode | String | WorkMethodCode of WorkOrders |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DueDays | Int | DueDays |
| MaterialItemId | Long | MaterialItemId |
| ProductSerialId | Long | ProductSerialId |
| ResourceId | Long | ResourceId |
| SerialNumber | String | SerialNumber |
| SourceHeaderRefId | Long | SourceHeaderRefId |
| SourceLineRefId | Long | SourceLineRefId |
| Tolerance | Int | Tolerance |
| WoProjectNumber | String | WoProjectNumber |
| WoTaskNumber | String | WoTaskNumber |
| WorkAreaId | Long | WorkAreaId |
| WorkCenterId | Long | WorkCenterId |
| Finder | String | finder |