View source | View content page | Page history | Printable version   

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:

Values tab:

Subset tab:

Subset value tab:

Brand

Window where brands are defined.

Header tab:

Product

Header tab:


Characteristics tab:

Tab where characteristics assigned to the product are defined.

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.

Purchase Order

Processes

Create Variants

This process generates all the variants of a Generic Product.

POS Changes

Reports

Utility classes

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Product_Variants_and_Characteristics/Technical_Documentation"

This page has been accessed 2,997 times. This page was last modified on 16 April 2013, at 11:07. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.