ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
Identifies and manages substitute materials used during work order operations, ensuring flexibility in material sourcing.
Columns
| Name | Type | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order to the substitute materials, enabling tracking of replacement materials used in production. |
| ProcessworkordermaterialWorkOrderOperationMaterialId [KEY] | Long | The unique identifier for the specific material in the work order operation that requires a substitute material. This identifier ensures accurate linkage between the original and replacement materials. |
| OrganizationId | Long | The unique identifier for the organization where the substitution is applied. Organizations typically represent manufacturing plants or warehouses. |
| OrganizationCode | String | The code representing the organization where the substitution is applied, enabling quick identification of the facility. |
| InventoryItemId | Long | The unique identifier for the inventory item that serves as the substitute material. This identifier is critical for tracking substitute materials in inventory systems. |
| ItemNumber | String | The unique number assigned to the substitute material item, used for easy reference and identification. |
| WorkOrderOperationMaterialId | Long | The unique identifier for the original material associated with the work order operation. This identifier links the substitute material to its original counterpart. |
| WorkOrderOperationSubstituteMaterialId [KEY] | Long | The unique identifier for the substitute material used in the operation. This identifier tracks the replacement material separately for traceability. |
| Priority | Decimal | Specifies the priority level for using the substitute material. Higher priority indicates preference over other substitutes. |
| InverseQuantity | Decimal | Represents the inverse ratio of the substitute material required compared to the original material. For example, if 2 units of the substitute replace 1 unit of the original, this value is 0.5. |
| QuantityPERProduct | Decimal | Specifies the quantity of the substitute material required per unit of finished product. This value ensures proper material planning and allocation. |
| RequiredQuantity | Decimal | The total quantity of the substitute material required for the work order operation. This value helps in accurate planning and inventory management. |
| SubstituteFlag | Bool | Indicates whether substitution is enabled for the material. A value of 'true' means substitution is allowed for the original material. |
| UOMCode | String | The unit of measure (UOM) code for the substitute material, such as 'EA' (Each) or 'KG' (Kilogram). |
| UnitOfMeasure | String | The full name of the unit of measure for the substitute material, providing additional clarity for the UOM code. |
| CreatedBy | String | The name or identifier of the user who created the substitute material record. This identifier supports audit tracking. |
| CreationDate | Datetime | The date and time when the substitute material record was created. This value provides a historical reference for the substitution. |
| LastUpdateDate | Datetime | The date and time when the substitute material record was last updated. This value helps track changes and updates. |
| LastUpdatedBy | String | The name or identifier of the user who last updated the substitute material record. This value ensures accountability for changes. |
| BackToBackFlag | String | Indicates whether the substitute material is part of a back-to-back manufacturing process, where materials are directly linked to specific customer demand. |
| ContractMfgFlag | String | Indicates whether the substitute material is associated with contract manufacturing, where production is outsourced to an external supplier or partner. |
| DueDays | Int | The number of days remaining until the substitute material is required for the operation or work order. |
| Finder | String | Represents the search mechanism or criteria used to locate the substitute material record within the system. |
| FirmPlannedFlag | String | Indicates whether the substitute material or its allocation is firm planned, preventing changes by planning or scheduling processes. |
| MaterialItemId | Long | The unique identifier for the original material item being substituted. This identifier links the substitute material to the original material for accurate tracking. |
| PlannedCompletionDate | Datetime | The planned date and time for completing the operation or work order using the substitute material. |
| PlannedStartDate | Datetime | The planned date and time for starting the operation or work order that requires the substitute material. |
| ProductSerialId | Long | The unique identifier for the product serial number associated with the substitute material. This identifier enables serialized tracking of the substituted items. |
| ResourceId | Long | The unique identifier for the resource (for example, personnel or equipment) associated with the operation where the substitute material is used. |
| SerialNumber | String | The serial number of the substitute material or product, enabling precise tracking and traceability for serialized items in the work order. |
| SourceHeaderReferenceId | Long | The unique identifier for the source header that links the substitute material record to its originating transaction, such as a purchase order or production request. |
| SourceHeaderRefId | Long | An alternate unique identifier for the source header associated with the substitute material record, providing additional linkage to its origin. |
| SourceLineReferenceId | Long | The unique identifier for the source line that links the substitute material record to a specific line item in the originating document, such as a purchase-order line. |
| SourceLineRefId | Long | An alternate unique identifier for the source line reference associated with the substitute material record, offering additional traceability. |
| SourceSystemId | Long | The unique identifier for the source system that provided the data related to the substitute material. This is useful for identifying materials originating from external systems or integrations. |
| Tolerance | Int | The allowable tolerance level for the substitute material, such as acceptable variances in quantity or specifications. Helps ensure that substitutes meet quality or production standards. |
| WoProjectNumber | String | The project number associated with the work order and substitute material. This number links the substitution to project-specific tasks or deliverables. |
| WorkAreaId | Long | The unique identifier for the work area where the substitute material is used. A work area groups resources and activities within a manufacturing facility. |
| WorkCenterId | Long | The unique identifier for the work center where the substitute material is applied in the operation. Tracks material usage at a specific location. |
| WorkOrderId | Long | The unique identifier for the work order associated with the substitute material. This identifier links the substitution to a specific production or maintenance job. |
| WorkOrderNumber | String | The unique number assigned to the work order associated with the substitute material. This number aids in tracking substitutions within the broader production process. |
| WorkOrderStatusId | Long | The unique identifier for the current status of the work order associated with the substitute material, such as 'Open,' 'In Progress,' or 'Completed.' |
| WoTaskNumber | String | The task number within the work order associated with the substitute material, enabling task-level tracking and management of substitutions. |