ProcessWorkOrdersProcessWorkOrderMaterialMaterialDFF
Enables detailed tracking of input materials with customizable descriptive flexfields for enhanced operational insights.
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order to its associated descriptive flexfield (DFF) attributes for materials. This identifier ensures that work order-specific custom attributes are accurately tracked and managed. | |
| ProcessworkordermaterialWorkOrderOperationMaterialId [KEY] | Long | The unique identifier for the work order operation material record within the descriptive flexfield (DFF). This field links materials to work order processes for detailed tracking and reporting. | |
| WoOperationMaterialId [KEY] | Long | A system-generated primary key uniquely identifying the material used in a work order operation. This primary key supports traceability and integration with inventory management. | |
| _FLEX_Context | String | Specifies the descriptive flexfield (DFF) context, enabling organizations to define and capture additional attributes specific to their business processes within the work order framework. | |
| _FLEX_Context_DisplayValue | String | A user-friendly display label for the descriptive flexfield (DFF) context, improving usability and making it easier to interpret custom attributes for work orders. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether the material is sourced through a back-to-back process, where customer demand directly triggers procurement or production to fulfill the order. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Specifies whether the material is managed under a contract manufacturing agreement, where external suppliers are responsible for production or assembly on behalf of the company. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | Represents the number of days remaining before the material or work order reaches its scheduled due date. This metric supports production planning and task prioritization. |
| Finder | String | A system-generated search key facilitating quick retrieval of descriptive flexfield (DFF) records for work order materials within business applications. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the material allocation in the work order is firm-planned, meaning it is locked from modifications by automated scheduling or planning processes. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier linking the material to the inventory master record. This identifier ensures accurate tracking and availability of materials in the supply chain. |
| ItemNumber | String | WorkOrderB2BCM | A structured identifier for the inventory item associated with the work order. This identifier is used for tracking, procurement, and inventory control. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The timestamp of the most recent update to the descriptive flexfield (DFF) record. This timestamp ensures auditability of changes in work order material records. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the material item recorded in the descriptive flexfield (DFF). This identifier supports detailed tracking of production components and raw materials. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The unique identifier of the organization or business unit responsible for executing the work order. This identifier ensures proper alignment of production and resource allocation. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The scheduled completion date and time for the work order or material-related task. These metrics ensure adherence to production timelines and fulfillment commitments. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The scheduled start date and time for the work order or material-related task. These metrics ensure timely allocation of resources and materials. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier linking the work order material to a serialized product This identifier supports traceability, warranty claims, and regulatory compliance. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource assigned to the work order material, such as the machinery, tools, or personnel required for production. |
| SerialNumber | String | WorkOrderBySerialNumber | A unique serial number assigned to the work order material. This serial number supports precise tracking and traceability of individual units in inventory and production. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | A reference identifier linking the descriptive flexfield (DFF) record to an external transaction such as a purchase order, inventory transfer, or sales order. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternative reference identifier for the source transaction header associated with the descriptive flexfield (DFF) record. This identifier aids in external integrations and traceability. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier linking the work order material to a specific line item in the source transaction (such as a purchase-order line, sales-order line, or inventory movement). |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternative reference identifier for the source document line associated with the work order material. This identifier facilitates external integrations and reconciliation. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The unique identifier for the external system that provided the work order material data. This identifier ensures traceability for integrations with third-party applications and legacy systems. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | Defines the permissible variance in material consumption or production for the work order. This metric allows for slight deviations in quantity or specifications during manufacturing. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with the work order material. This number enables project-based tracking and cost allocation within the production process. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The unique identifier for the work area where the work order operation is executed. This identifier defines the physical or logical zones in the manufacturing facility. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center responsible for executing the work order operation. This identifier represents a group of machines, labor, or production cells dedicated to specific tasks. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The system-generated identifier assigned to the work order. This identifier serves as the primary key for tracking production, maintenance, and resource planning. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | A structured number assigned to the work order. This number is used for managing and tracking production, maintenance, and material consumption within the business workflow. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The unique identifier representing the current status of the work order, such as 'Open', 'Released', 'Completed', or 'Canceled'. This identifier ensures visibility into production progress. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The specific task number associated with the work order. This number links material usage to individual steps in the manufacturing or maintenance workflow. |