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. |