ProcessWorkOrdersProcessWorkOrderResourceResourceInstanceResourceInstanceDFF
Offers detailed customization for resource instances using descriptive flexfields, improving instance-specific insights.
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier assigned to each process work order, used to link it to related operations, resources, and other process steps in the system. | |
| ProcessworkorderresourceWorkOrderOperationResourceId [KEY] | Long | An identifier representing the specific resource operation within a process work order, enabling detailed tracking of the resource's role in the operation. | |
| ResourceinstanceWorkOrderOperationResourceInstanceId [KEY] | Long | Represents a unique instance of a resource involved in the execution of a specific work order operation, allowing precise monitoring of resource usage. | |
| WoOpResourceInstanceId [KEY] | Long | A primary key generated by the system to uniquely identify an output of a specific work order operation resource instance, ensuring database consistency and traceability. | |
| _FLEX_Context | String | The descriptive flexfield (DFF) context name associated with this resource instance, allowing customization and storage of additional context-specific attributes. | |
| _FLEX_Context_DisplayValue | String | A human-readable display value of the descriptive flexfield context for this resource instance, aiding users in understanding its specific purpose. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether the work order is part of a back-to-back manufacturing or fulfillment process, linking production directly to customer demand. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | A flag denoting whether the work order involves contract manufacturing, where external suppliers or manufacturers are engaged for production. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | Specifies the number of days remaining until the work order is due to be completed, helping with scheduling and planning. |
| Finder | String | A utility field that assists in quickly locating or identifying specific work order resource instances within the system. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the work order is firmly planned, preventing changes and signaling readiness for execution or scheduling. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the inventory item linked to this work order, connecting production activities to inventory management. |
| ItemNumber | String | WorkOrderB2BCM | The unique number or code assigned to the inventory item, used to identify the product being manufactured or utilized in the work order. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The timestamp of the most recent update to this work order resource instance, providing a record of changes and ensuring up-to-date information. |
| MaterialItemId | Long | WorkOrderByComponent | The identifier for the material item used or consumed in this work order operation, allowing material tracking and management. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The unique identifier for the organization responsible for executing or managing the work order, facilitating organizational-level reporting and planning. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The scheduled date and time for completing the work order, critical for ensuring timely delivery and customer satisfaction. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The scheduled date and time for beginning the work order operation, aiding in resource allocation and production scheduling. |
| ProductSerialId | Long | WorkOrderBySerial | The identifier for the serialized product being manufactured in this work order, ensuring traceability and quality control. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource (for example, 'machine', 'labor', or 'tool') used in the work order operation, linking it to the broader production process. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number associated with the product or resource, used for tracking and identifying specific instances during the work order process. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The reference identifier linking the work order to its originating header (for example, 'sales order' or 'project header'), ensuring accurate traceability. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate reference to the source header, providing a redundant or cross-referenced link for integration with external systems. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The reference identifier linking the work order to a specific line in the source document (for example, 'sales-order line'), enabling detailed traceability. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | The alternate reference to the source line, providing flexibility for integrations or data reconciliation. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The identifier representing the external system that generated or manages the work order, aiding in integration and data flow between systems. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | Specifies the allowable tolerance for deviations in production or resource usage during the work order execution. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with the work order, linking it to broader project management or costing structures. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The unique identifier for the work area (for example, 'production floor' or 'department') where the work order is executed, helping with resource allocation and reporting. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The identifier for the work center (for example, a specific production unit or machine group) responsible for the operation, ensuring operational clarity. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The unique identifier for the work order itself, serving as a central reference for all related operations, resources, and outputs. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | The number assigned to the work order for easy identification and tracking in the system. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The identifier representing the current status of the work order (for example, 'pending', 'in progress', 'completed'), enabling status-based reporting. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The specific task number within the work order, breaking down the work into manageable and traceable steps. |