iDempiere Product Master Substitute
The Substitute tab defines alternative products that can replace a component in a BOM.
- It helps ensure production continuity when a preferred component is unavailable.
- You can specify validity dates, priority, and quantity ratio for substitution.
- Useful in flexible manufacturing and supply chain management.
| Field Name | Description | Column Name DataType Reference Type AD_Column_ID |
| Tenant | Identifies the client/tenant owning the data. | * AD_Client_ID * numeric(10) * Table Direct * 1436 |
| Organization | Indicates the organization within the client. | * AD_Org_ID * numeric(10) * Table Direct * 1437 |
| Product | The main product/component for which substitutes are defined. | * M_Product_ID * numeric(10) * Search * 1782 |
| Name | Name of the substitute product entry. | * Name * character varying(60) * String * 1443 |
| Description | Optional notes or explanation about the substitute. | * Description * character varying(255) * String * 10920 |
| Active | Indicates whether the substitute record is active. | * IsActive * character(1) * Yes-No * 1438 |
| Substitute | The actual product that can replace the original component in the BOM. | * Substitute_ID * numeric(10) * Search * 1783 |