Projects:Product Variants and Characteristics/Technical Documentation
Contents |
Introduction
In this document all developments to be done within this project are described.
Tables
Relation of new tables and columns. Common columns as primary key, ad_client, createdby are not included.
New table M_Characteristic
Table where available characteristics are stored.
Columnname | Name | Type | Description |
Name | Name | nvarchar2(60) | Name of the characteristic |
Ch_Type | Type | varchar2(60) List values: List, Text' | |
Description | Description | nvarchar2(2000) |
New table M_Ch_Value
Columnname | Name | Type | Description |
Name | Name | nvarchar2(60) | Name of the characteristic |
M_Characteristic_ID | Characteristic | varchar2(32) | Parent key |
IsSummary | Summary | Char(1) Y/N | |
SKCode | Code | nvarchar2(10) | Code to use in the Search Key of the variant products |
SeqNo | Sequence Number | number |
New table M_Product_Ch
Columnname | Name | Type | Description |
M_Product_ID | Product | varchar2(32) | Parent key |
M_Characteristic_ID | Characteristic | varchar2(32) | |
M_Ch_Value_ID | Characteristic Value | varchar2(32) | Only summary values of the selected characteristic |
M_Ch_Subset_ID | Characteristic Subset | varchar2(32) | Subsets of the selected characteristic |
SeqNo | Sequence Number | Number |
New table M_Product_Ch_Value
Columnname | Name | Type | Description |
M_Product_ID | Product | varchar2(32) | Parent key |
M_Characteristic_ID | Characteristic | varchar2(32) | Parent key |
M_Ch_Value_ID | Characteristic Value | varchar2(32) | |
Value | Value | nvarchar2(60) |
New table M_Product_Ch_Conf
Columnname | Name | Type | Description |
M_Product_Ch_ID | varchar2(32) | Parent key | |
M_Ch_Value_ID | Characteristic Value | varchar2(32) | |
SKCode | Code | nvarchar2(10) |
New table M_Brand
Columnname | Name | Type | Description |
Name | Name | nvarchar2(60) | Name of the characteristic |
Description | Description | nvarchar2(2000) |
Modified table M_Product
Columnname | Name | Type | Description |
IsGeneric | Generic | Char(1) Y/N | |
M_Generic_Product_ID | Generic Product | varchar2(32) | FK to M_Product of type Generic |
M_Brand_ID | Brand | varchar2(32) | |
CreateVariants | Create Variants | char(1) | Button for the Create Variants Process |
New table M_Ch_Subset
Columnname | Name | Type | Description |
M_Characteristic_ID | Characteristic | varchar2(32) | Parent key |
Name | Name | nvarchar2(60) | Name of the subset |
Description | Description | nvarchar2(2000) |
New table M_Ch_Subset_Value
Columnname | Name | Type | Description |
M_Ch_Subset_ID | Characteristic Subset | varchar2(32) | Parent key |
M_Ch_Value_ID | Characteristic Value | varchar2(32) | Parent key |
SKCode | Code | nvarchar2(10) | Code to use in the Search Key of the variant products |
SeqNo | Sequence Naumber | number |
Windows
Product Characteristics
Window where characteristics are defined.
Header tab:
- Table:M_Characteristic
Values tab:
- Table:M_Ch_Value
- Child of header
- Tree enabled
Subset tab:
- Table: M_Ch_Subset
- Child of header
Subset value tab:
- Table: M_Ch_Subset_Value
- Child of subset
Brand
Window where brands are defined.
Header tab:
- Table:M_Brand
Product
Header tab:
- New field Generic product, only visible for not generic products.
- New flag Is Generic
- New field Brand, only visible for not generic products.
- Button on generic products to generate variants automatically based on defined characteristics.
- Button to assign values to a product
Characteristics tab:
Tab where characteristics assigned to the product are defined.
- Table: M_Product_Ch
- Child of Header
Configuration tab:
Tab visible on generic products. All possible values of a characteristic are shown. They can be deactivated so the variant creation process ignores them.
- Table: M_Product_Ch_Conf
- Child of Characteristics
- Visible for generic products.
Purchase Order
Processes
Create Variants
This process generates all the variants of a Generic Product.
- It's launched from the Generic Product.
- The Generic product must have at least one variant characteristic.
- It copies all the properties of the Generic Product including name, prices, product category,...
- Each variant characteristic has its possible values in the child tab Characteristic Configuration.
- The process only considers active values.
- The search key of the variant product is build concatenating:
- the search key of the generic product with
- the code of the value define in the configuration tab, when all the possible values of a characteristic has one, and
- a sequential number.
- If the characteristic is Defines Price and a value has a Unit Price defined the default sale price of the new variant is updated.