WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
Contains descriptive flexfields for resources, providing detailed resource attributes used in operations.
Columns
Name | Type | 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 | 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 | Indicates whether the resource is part of a contract manufacturing process. This flag helps track custom attributes related to outsourced production workflows. |
DueDays | Int | 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 | Indicates whether the resource requirement is firm planned, meaning it is locked and not subject to rescheduling or changes. |
InventoryItemId | Long | The unique identifier for the inventory item associated with the resource. This identifier helps link custom attributes to material tracking and usage. |
ItemNumber | String | The specific item number assigned to the resource or material. This number ensures proper traceability in inventory and production processes. |
LastUpdateDate | Datetime | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | An alternate reference identifier for the source header. This identifier ensures compatibility with external systems or legacy applications. |
SourceLineReferenceId | Long | 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 | An alternate reference identifier for the source line. This identifier supports integration with external systems and historical tracking. |
SourceSystemId | Long | 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 | The allowable tolerance for variations in resource usage or operational parameters. Custom attributes might define acceptable limits or special handling instructions. |
WoProjectNumber | String | The project number associated with the work order operation resource. This number links custom attributes to broader project tracking and reporting. |
WorkAreaId | Long | 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 | The unique identifier for the work center where the resource is used. Custom attributes might define specific work center requirements or constraints. |
WorkOrderId | Long | 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 | The user-friendly work-order number associated with this resource DFF entry. This number helps reference and retrieve custom attributes easily. |
WorkOrderStatusId | Long | 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 | 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. |