ProcessWorkOrdersProcessWorkOrderMaterialMaterialDFF
Enables detailed tracking of input materials with customizable descriptive flexfields for enhanced operational insights.
Columns
| Name | Type | 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 | 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 | 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 | 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 | 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 | 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 | A structured identifier for the inventory item associated with the work order. This identifier is used for tracking, procurement, and inventory control. |
| LastUpdateDate | Datetime | 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 | 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 | 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 | 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 | 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 | The unique identifier linking the work order material to a serialized product This identifier supports traceability, warranty claims, and regulatory compliance. |
| ResourceId | Long | The unique identifier for the resource assigned to the work order material, such as the machinery, tools, or personnel required for production. |
| SerialNumber | String | 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 | 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 | 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 | 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 | An alternative reference identifier for the source document line associated with the work order material. This identifier facilitates external integrations and reconciliation. |
| SourceSystemId | Long | 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 | 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 | The project number associated with the work order material. This number enables project-based tracking and cost allocation within the production process. |
| WorkAreaId | Long | 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 | 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 | 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 | 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 | 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 | The specific task number associated with the work order. This number links material usage to individual steps in the manufacturing or maintenance workflow. |