Projects:Product Variants and Characteristics/Technical Documentation

Contents 1 Introduction 2 Tables 2.1 New table M_Characteristic 2.2 New table M_Ch_Value 2.3 New table M_Product_Ch 2.4 New table M_Product_Ch_Value 2.5 New table M_Product_Ch_Conf 2.6 New table M_Brand 2.7 Modified table M_Product 2.8 New table M_Ch_Subset 2.9 New table M_Ch_Subset_Value 3 Windows 3.1 Product Characteristics 3.2 Brand 3.3 Product 3.4 Purchase Order 4 Processes 4.1 Create Variants 5 POS Changes 6 Reports 7 Utility classes

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:
  1. the search key of the generic product with
  2. the code of the value define in the configuration tab, when all the possible values of a characteristic has one, and
  3. 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.

POS Changes

Reports

Utility classes