Table of Contents

Table Gen_Product_Dimensions

Entity

Entity: General.Products.ProductDimensions

Contains convertion ratios between the supported measument categories for each product. Does not contain a record for the default category of the products, for which the convertion ratio is defined as equal to 1. Entity: Gen_Product_Dimensions

Owner Tables Hierarchy

Summary

Name Type Description
Convert_To_Base_Divisor decimal(9, 3) This was intended to be the divisor, but due to a historical bug actually contains the multiplier of the convertion ratio from the non-base measurement category to the base measurement category. This should be automatically calculated by the system.
Convert_To_Base_Multiplier decimal(9, 3) This was intended to be the multiplier, but due to a historical bug actually contains the divisor of the convertion ratio from the non-base measurement category to the base measurement category. This should be automatically calculated by the system.
Dest_Quantity decimal(9, 3) Quantity in some of the base units, that equals Source_Quantity
Dest_Quantity_Unit_Id uniqueidentifier The measurement unit of Dest_Quantity. Should be one of the units of the base measurement category of the product
Measurement_Category_Id uniqueidentifier Readonly The measurement category of Source Quantity Unit. For each product, only one conversion ratio can be specified for a measurement category.
Product_Dimension_Id uniqueidentifier PK
Product_Id uniqueidentifier The product for which we specify conversion ratios
Row_Version timestamp
Source_Quantity decimal(9, 3) The quantity in the non-base unit
Source_Quantity_Unit_Id uniqueidentifier The non-base measurement unit for which we specify convertion ratio

Columns

Convert_To_Base_Divisor

This was intended to be the divisor, but due to a historical bug actually contains the multiplier of the convertion ratio from the non-base measurement category to the base measurement category. This should be automatically calculated by the system.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(9, 3)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Convert_To_Base_Multiplier

This was intended to be the multiplier, but due to a historical bug actually contains the divisor of the convertion ratio from the non-base measurement category to the base measurement category. This should be automatically calculated by the system.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(9, 3)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Dest_Quantity

Quantity in some of the base units, that equals Source_Quantity

Property Value
Auto Complete no
Data Filter no
Default Value 1
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(9, 3)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Dest_Quantity_Unit_Id

The measurement unit of Dest_Quantity. Should be one of the units of the base measurement category of the product

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Measurement_Units
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Dest_Quantity_Unit_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Measurement_Category_Id

The measurement category of Source Quantity Unit. For each product, only one conversion ratio can be specified for a measurement category.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
Referenced Table Gen_Measurement_Categories
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible no

Measurement_Category_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Product_Dimension_Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Product_Dimension_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Product_Id

The product for which we specify conversion ratios

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Products
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Product_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Source_Quantity

The quantity in the non-base unit

Property Value
Auto Complete no
Data Filter no
Default Value 1
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(9, 3)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Source_Quantity_Unit_Id

The non-base measurement unit for which we specify convertion ratio

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 1
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Measurement_Units
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Source_Quantity_Unit_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Suggest improvement to this page