iDempiere Product Master Related
The Related tab defines products that are linked or commonly used together.
- Useful for upselling, cross-selling, or suggesting complementary items.
- Helps improve customer experience in web stores and sales orders.
- Can include accessories, alternatives, or bundled items.
Tab Name: Related (AD_Tab_ID=630)
Table Name : M_RelatedProduct (AD_Table_ID=662)
| Field Name | Description | Column Name DataType Reference Type AD_Column_ID |
| Tenant | Client or legal entity that owns the data. | * AD_Client_ID * numeric(10) * Table Direct * 10862 |
| Organization | Sub-unit of the tenant, such as a branch or department. | * AD_Org_ID * numeric(10) * Table Direct * 10859 |
| Product | The main product being related to another. | * M_Product_ID * numeric(10) * Search * 10857 |
| Name | Name of the product relationship entry. | * Name * character varying(60) * String * 10861 |
| Description | Additional details about the related product entry. | * Description * character varying(255) * Text * 10856 |
| Active | Indicates if the related product entry is active. | * IsActive * character(1) * Yes-No * 10854 |
| Related Product Type | Defines the type of relation (e.g., accessory, alternative, bundled). | * RelatedProductType * character(1) * List * 10853 |
| Related Product | The product that is linked or related to the main product. | * RelatedProduct_ID * numeric(10) * Search * 10852 |