ProcessWorkOrdersProjectDetailsDFF
Customizes project costing attributes for work orders using descriptive flexfields, supporting advanced project tracking.
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier for the process work order, linking it to the project details for reporting and tracking purposes. | |
| WorkOrderId [KEY] | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The primary key generated by the application to uniquely identify the work order. This key is essential for linking project details and is part of an opt-in feature. |
| _FLEX_Context | String | The descriptive flexfield context name associated with the work order project details, allowing for customization and context-specific attributes. | |
| _FLEX_Context_DisplayValue | String | A human-readable display value of the descriptive flexfield context for work order project details, enabling better user interpretation. This attribute requires opt-in. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether the work order is part of a back-to-back manufacturing or fulfillment process, directly tied to customer demand. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | A flag that specifies if the work order involves contract manufacturing, where production is outsourced to external suppliers. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | The number of days remaining until the work order is due for completion, assisting in production scheduling and deadline tracking. |
| Finder | String | A utility field used to locate or identify specific work order project details within the system. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the work order is firmly planned, signaling its readiness for execution or inclusion in the production schedule. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the inventory item associated with the work order, linking project details to inventory management. |
| ItemNumber | String | WorkOrderB2BCM | The unique number or code assigned to the inventory item, used to identify the product or material associated with the work order. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The timestamp of the most recent update to the work order project details, ensuring that the latest information is reflected in the system. |
| MaterialItemId | Long | WorkOrderByComponent | The identifier for the material item associated with the work order, allowing for accurate tracking of material usage. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The unique identifier for the organization responsible for managing the work order, aiding in organizational-level analysis and reporting. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The scheduled date and time for completing the work order, providing a timeline for project delivery. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The scheduled date and time for starting the work order, essential for resource allocation and project scheduling. |
| ProductSerialId | Long | WorkOrderBySerial | The identifier for the serialized product being manufactured, ensuring traceability and quality control. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource (for example, 'tool', 'machine', or 'labor') used in the work order, tying it to project-specific details. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number of the resource or product associated with the work order, enabling detailed tracking and management. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The reference identifier for the source header (for example, 'sales order') linked to the work order, ensuring traceability across related documents. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate reference for the source header, providing flexibility for integrations with external systems. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The reference identifier for the specific line in the source document (for example, 'sales-order line'), enabling detailed tracking of dependencies. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate reference for the source line, supporting integration and reconciliation with external systems. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The identifier for the external system generating or managing the work order, facilitating accurate data synchronization and traceability. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | Specifies the allowable tolerance for variations in resource usage or production quality, ensuring adherence to project standards. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with the work order, linking it to broader project tracking and 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, aiding in 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 machine group or production unit) managing the work order operation, ensuring clarity in operations. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | The unique number assigned to the work order for easy identification and tracking in the system. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The unique identifier for the current status of the work order, providing an accurate view of its progress within the workflow. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The specific task number associated with the work order, breaking down the work into manageable and traceable steps. |