WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
Contains descriptive flexfields for resources, providing detailed resource attributes used in operations.
Columns
| Name | Type | SupportedFinders | Description |
| WorkOrdersWorkOrderId [KEY] | Long | The unique identifier for the work order associated with this resource descriptive flexfield (DFF) entry. This identifier identifier ensures proper tracking of custom attributes for work order resources. | |
| WorkorderoperationWorkOrderOperationId [KEY] | Long | The unique identifier for the work order operation linked to this resource DFF entry. This identifier connects custom attributes to a specific operation step. | |
| WorkorderoperationresourceWorkOrderOperationResourceId [KEY] | Long | The unique identifier for the work order operation resource to which this DFF entry is linked. This identifier ensures traceability of custom attributes to resources used in production. | |
| WoOperationResourceId [KEY] | Long | The unique identifier for the resource used in the work order operation. This primary key is system-generated and ensures data integrity in resource tracking. | |
| _FLEX_Context | String | The descriptive flexfield (DFF) context name that defines the custom attributes or segments available for work order operation resources. | |
| _FLEX_Context_DisplayValue | String | The display value of the descriptive flexfield (DFF) context for work order operation resources. This field provides a user-friendly name for the applied context. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether this resource is part of a back-to-back order process, where demand directly triggers a supply response to maintain operational efficiency. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the resource is part of a contract manufacturing process. This flag helps track custom attributes related to outsourced production workflows. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | The number of days remaining until the planned completion of the work order operation resource. This metric supports scheduling and tracking of resource readiness. |
| Finder | String | A search key or identifier used to quickly locate specific work order operation resource DFF entries in the system. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the resource requirement is firm planned, meaning it is locked and not subject to rescheduling or changes. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the inventory item associated with the resource. This identifier helps link custom attributes to material tracking and usage. |
| ItemNumber | String | WorkOrderB2BCM | The specific item number assigned to the resource or material. This number ensures proper traceability in inventory and production processes. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The date and time when this resource DFF entry was last updated. These metrics ensure visibility into recent changes and supports audit tracking. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the material linked to this work order operation resource. This identifier ensures traceability of materials and their associated custom attributes. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The identifier for the organization or business unit responsible for the work order operation resource DFF entry. This identifier supports multi-organization tracking. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The planned date and time for completing the work order operation resource. Custom attributes might define specific milestones or requirements for resource completion. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned date and time for starting the work order operation resource. Custom attributes might define specific constraints or requirements for resource activation. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier for the serialized product associated with the work order operation resource. This identifier helps track serialized materials used in production. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource (for example, 'machine', 'tool', or 'labor') used in the work order operation. This identifier connects custom attributes to resource usage. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number assigned to the resource or product associated with this operation. This serial number supports traceability and compliance in serialized inventory tracking. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The reference identifier linking this work order operation resource DFF entry to the source document's header, such as a purchase order or project plan. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate reference identifier for the source header. This identifier ensures compatibility with external systems or legacy applications. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The reference identifier linking this resource DFF entry to a specific line item in the source document, such as a purchase-order line. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate reference identifier for the source line. This identifier supports integration with external systems and historical tracking. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The identifier for the external system from which this work order operation resource DFF data originates. This identifier ensures proper synchronization across platforms. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowable tolerance for variations in resource usage or operational parameters. Custom attributes might define acceptable limits or special handling instructions. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with the work order operation resource. This number links custom attributes to broader project 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 operation resource. This identifier ensures proper tracking of resource-related custom attributes by location. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center where the resource is used. Custom attributes might define specific work center requirements or constraints. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The unique identifier for the work order associated with this resource DFF entry. This identifier links all custom attributes to the overarching production job. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | The user-friendly work-order number associated with this resource DFF entry. This number helps reference and retrieve custom attributes easily. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The identifier for the current status of the work order (for example, 'Planned,' 'In Progress,' or 'Completed'). Custom attributes might provide additional status-related details. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The specific task number within the work order operation to which this resource DFF entry is linked. This number enables task-level tracking of custom attributes. |