ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
Identifies and manages substitute materials used during work order operations, ensuring flexibility in material sourcing.
Columns
| Name | Type | SupportedFinders | 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 | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | 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 | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | 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 | WorkOrderB2BCM | 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 | WorkOrderByModifiedDate | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | 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 | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the substitute material is associated with contract manufacturing, where production is outsourced to an external supplier or partner. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the substitute material or its allocation is firm planned, preventing changes by planning or scheduling processes. |
| MaterialItemId | Long | WorkOrderByComponent | 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 | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The planned date and time for completing the operation or work order using the substitute material. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned date and time for starting the operation or work order that requires the substitute material. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier for the product serial number associated with the substitute material. This identifier enables serialized tracking of the substituted items. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource (for example, personnel or equipment) associated with the operation where the substitute material is used. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number of the substitute material or product, enabling precise tracking and traceability for serialized items in the work order. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | 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 | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate unique identifier for the source header associated with the substitute material record, providing additional linkage to its origin. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | 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 | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate unique identifier for the source line reference associated with the substitute material record, offering additional traceability. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | 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 | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | 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 | FindByProjectNumberTaskNumber | The project number associated with the work order and substitute material. This number links the substitution to project-specific tasks or deliverables. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | 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 | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | 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 | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | 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 | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | 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 | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | 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 | FindByProjectNumberTaskNumber | The task number within the work order associated with the substitute material, enabling task-level tracking and management of substitutions. |