WorkOrdersProjectDetailsDFF
Tracks project costing attributes for work orders using customizable descriptive flexfields.
Columns
| Name | Type | SupportedFinders | Description |
| WorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking this descriptive flexfield (DFF) record to the associated work order in the WorkOrders schema. This identifier ensures all project details are correctly tied to the relevant work order. | |
| WorkOrderId [KEY] | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The primary key uniquely identifying the work order. This primary key is system-generated when the work order is created and is associated with features that require specific opt-in, ensuring traceability and alignment with project workflows. |
| _FLEX_Context | String | The descriptive flexfield (DFF) context name for work order project details. This field categorizes custom attributes based on operational or project-specific needs, enabling flexible customization. | |
| _FLEX_Context_DisplayValue | String | User-friendly display value for the descriptive flexfield context. This value makes it easier for users to interpret the context of custom attributes associated with work orders. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether the work order is tied to a back-to-back process. This flag is critical for identifying work orders that depend on direct supply or demand alignment, such as customer-driven production. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Specifies whether the work order involves contract manufacturing. This flag helps distinguish work orders managed internally from those executed by external contractors. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | The number of days remaining until the work order is due. This metric helps prioritize work orders based on urgency, ensuring timely completion. |
| Finder | String | A utility field enabling advanced search and filtering capabilities for descriptive flexfield records linked to work orders. This field helps users quickly locate specific records based on custom attributes or other criteria. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the work order is firm planned. A firm planned work order is locked and not subject to changes from automated planning processes. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the inventory item associated with the work order. This identifier ensures that materials or products are correctly tied to the work order. |
| ItemNumber | String | WorkOrderB2BCM | The unique item number associated with the work order. This number provides a clear reference to the item being manufactured or processed. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The date and time when the work order's descriptive flexfield attributes were last updated. These metrics ensure traceability and reflects the most recent changes. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the material item required by the work order. This identifier ensures that materials are properly linked to their respective work orders for accurate tracking and planning. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The unique identifier for the organization managing the work order. This identifier ensures that project details are segmented by organizational units, supporting multi-organization workflows. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The scheduled completion date for the work order. This date is critical for tracking progress and ensuring that deadlines are met. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The scheduled start date for the work order. This date helps in aligning resources and materials to kick off the production or project on time. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier for the product serial number associated with the work order. This identifier ensures traceability of serialized products throughout the production process. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource associated with the work order (for example, 'machine', 'tool', or 'personnel'). This identifier supports resource planning and allocation. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number associated with the work order. This serial number provides detailed tracking for serialized items, especially in industries with strict traceability requirements. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier for the source header reference associated with the work order. This identifier helps in linking work orders to their originating documents or transactions. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternative identifier for the source header reference, providing flexibility in tracking and integration with external systems. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier for the source line reference associated with the work order. This identifier ensures accurate linking to specific line items from the originating document. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternative identifier for the source line reference, supporting flexible tracking of work order origins. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The unique identifier for the source system that created the work order. This identifier supports integration with external systems and ensures traceability across platforms. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowed deviation (in days) for the work order's planned completion date. This metric ensures that delays within the tolerance range are considered acceptable. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The unique project number associated with the work order. This project number ties work orders to specific projects for better tracking and reporting. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The unique identifier for the work area associated with the work order. This identifierproper segmentation of work orders by operational zones. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center where the work order is executed. This identifier helps allocate and monitor resources at the work center level. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | The unique number assigned to the work order. This number serves as a primary reference for identifying and tracking work orders in the system. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The unique identifier for the status of the work order. This field tracks whether the work order is active, completed, on hold, or canceled. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The unique task number associated with the work order. This number ensures detailed tracking of tasks within a work order for better project management. |