WorkOrdersWorkOrderMaterialWorkOrderOperationSubstituteMaterial
Tracks substitute materials used in place of primary materials during work order operations for flexibility and efficiency.
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | The unique identifier for the work order associated with this substitute material record. This identifier links the substitute material to the correct work order for traceability. |
| WorkordermaterialWorkOrderOperationMaterialId [KEY] | Long | The unique identifier for the material associated with a specific operation in the work order. This identifier ensures traceability of materials used in manufacturing operations. |
| OrganizationId | Long | The identifier for the organization or business unit responsible for the work order. This identifier helps distinguish work orders across multiple organizations or production facilities. |
| OrganizationCode | String | The code representing the organization or business unit. This code provides a user-friendly reference for organizational identification. |
| InventoryItemId | Long | The unique identifier for the inventory item associated with the substitute material. This identifier links the material to inventory records for tracking purposes. |
| ItemNumber | String | The specific item number assigned to the material. This number serves as a unique reference across procurement, inventory, and production systems. |
| WorkOrderOperationMaterialId | Long | The identifier for the material within the specific operation of a work order. This identifier links substitute materials to the correct operation step. |
| WorkOrderOperationSubstituteMaterialId [KEY] | Long | The unique identifier for the substitute material within the operation. This identifier ensures precise tracking of alternative materials used in place of the original material. |
| Priority | Decimal | The priority assigned to the substitute material, indicating its order of preference when multiple substitutes are available. |
| InverseQuantity | Decimal | The quantity of the substitute material required to replace one unit of the original material, allowing for accurate material substitutions in production. |
| QuantityPERProduct | Decimal | The quantity of the substitute material required per unit of the finished product, ensuring accurate material planning. |
| RequiredQuantity | Decimal | The total quantity of the substitute material required to meet production needs, based on planned or active work orders. |
| SubstituteFlag | Bool | A flag indicating whether the material is a substitute for another. This flag is used to identify alternative materials in production planning. |
| UOMCode | String | The unit-of-measure code for the substitute material (for example, 'EA' for each or 'KG' for kilograms). This code ensures consistent quantity tracking. |
| UnitOfMeasure | String | The full description of the unit of measure for the substitute material, providing clarity in production and inventory management. |
| CreatedBy | String | The username or identifier of the individual who created this substitute material record. This name aids in audit and traceability. |
| CreationDate | Datetime | The date and time when this substitute material record was created, supporting compliance and data integrity. |
| LastUpdateDate | Datetime | The date and time when this record was last updated. These metrics ensure the accuracy of the substitute material data over time. |
| LastUpdatedBy | String | The username or identifier of the individual who last updated this substitute material record, aiding in accountability. |
| OnhandQuantity | Decimal | The current quantity of the substitute material available on hand in inventory, ensuring sufficient stock for production needs. |
| AvailableToTransact | Decimal | The quantity of the substitute material available for transactions, such as work-order allocation or transfers. |
| Description | String | A detailed description of the substitute material, providing context for its use or characteristics in the production process. |
| BackToBackFlag | String | A flag indicating whether the substitute material is linked to a back-to-back order. This flag aligns the substitute material with specific supply chain processes. |
| ContractMfgFlag | String | A flag indicating whether the substitute material is used in contract manufacturing. This flag supports tracking of outsourced production activities. |
| DueDays | Int | The number of days until the substitute material is required for production or delivery. This metric supports scheduling and timely availability. |
| Finder | String | A search key or identifier used to quickly locate the substitute material record within the system. |
| FirmPlannedFlag | String | A flag indicating whether the use of the substitute material is firm-planned, meaning it has been confirmed and is not subject to change. |
| MaterialItemId | Long | The unique identifier for the material item being substituted. This identifier ensures the original and substitute materials are properly linked. |
| PlannedCompletionDate | Datetime | The planned completion date for the work order operation involving the substitute material. This metric ensures alignment with production schedules. |
| PlannedStartDate | Datetime | The planned start date for executing the work order operation involving the substitute material. This metric helps align production schedules and ensures that resources are available when needed. |
| ProductSerialId | Long | The unique serial number identifier for the product associated with the substitute material. This serial number ensures traceability for serialized products throughout the production and supply chain process. |
| ResourceId | Long | The unique identifier for the resource (for example,'machine', 'tool', or 'personnel') allocated to the operation involving the substitute material. This identifier supports resource tracking and efficient allocation. |
| SerialNumber | String | The serial number assigned to the substitute material or product, enabling detailed tracking and compliance with quality assurance requirements. |
| SourceHeaderReferenceId | Long | The reference identifier for the source document header, such as a sales order or project plan, from which the work order and substitute material originated. This identifierensures alignment with the original demand. |
| SourceHeaderRefId | Long | An alternate reference identifier for the source header, often used to ensure compatibility with legacy systems or external integrations. |
| SourceLineReferenceId | Long | The reference identifier for the specific line item in the source document (e.g., a sales order line) associated with the substitute material. This identifier ties the material back to its originating demand line. |
| SourceLineRefId | Long | An alternate reference for the source line identifier, often included for compatibility with external or legacy systems. |
| SourceSystemId | Long | The identifier for the external system from which this work order and substitute material data originated. This identifier supports integration and traceability across systems. |
| Tolerance | Int | The allowable tolerance for deviations in the use or specifications of the substitute material. This metric ensures compliance with quality standards without causing delays or rework. |
| WoProjectNumber | String | The project number associated with the work order operation involving the substitute material. This number connects the work order to broader project management processes, aiding in cost tracking and resource alignment. |
| WorkAreaId | Long | The identifier for the specific work area where the operation involving the substitute material is being executed, such as a designated assembly line or production zone. |
| WorkCenterId | Long | The identifier for the work center responsible for the operation involving the substitute material. Work centers group resources into units to facilitate production management and efficiency. |
| WorkOrderId | Long | The unique identifier for the work order associated with the substitute material. This identifier connects all relevant material and operations to the overarching production job for traceability. |
| WorkOrderNumber | String | The user-friendly number assigned to the work order, often used in reports, production schedules, and worker instructions to reference the specific work order. |
| WorkOrderStatusId | Long | The identifier for the current status of the work order (for example, 'planned', 'in-progress', 'completed'). This identifier supports real-time tracking and production workflow monitoring. |
| WoTaskNumber | String | The specific task number within the work order related to the operation involving the substitute material. This task supports detailed task-level tracking and management in the production process. |