Table of Contents

Table Gen_Measurement_Units

Entity

Entity: General.Products.MeasurementUnits

Contains all measurement units, grouped in categories. Each category has one base unit (with ratio 1/1) and unlimited number of derived units with fixed ratio to the base unit. Entity: Gen_Measurement_Units

Owner Tables Hierarchy

Summary

Name Type Description
Description nvarchar(max) ML Full multi-language description of the measurement unit.
Divisor decimal(9, 3) Divisor of the relative value of the measurement unit against other units (divisor when converting to base)
Id uniqueidentifier PK Unique measurement unit Id
Is_Default_Unit bit 1 if this measurement unit is the default measurement unit within the category. There can be only one default measurement unit within a category
Measurement_Category_Id uniqueidentifier Base measurement category Id
Measurement_Unit_Code nvarchar(16) When not null, contains unique measurement unit code.
Measurement_Unit_Name nvarchar(64) ML Name of the measurement unit
Multiplier decimal(9, 3) Multiplier of the relative value of the measurement unit against other units (multiplier when converting to base)
Row_Version timestamp
System_Unit nvarchar(1) Allowed: G, H, L, N, P, V, W, T Not NULL only when this is one of the system measurement units. N=NetKG; G=GrossKG; V=VolumeL; H=HeightM; W=WidthM, L=LengthM, P=Piece, T=TimeH

Columns

Description

Full multi-language description of the measurement unit.

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 2147483647
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 nvarchar(max) (MultiLanguage) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Divisor

Divisor of the relative value of the measurement unit against other units (divisor when converting to base)

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 Short
User Login no
Visible yes

Id

Unique measurement unit 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

Id - Supported Filters

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

Is_Default_Unit

1 if this measurement unit is the default measurement unit within the category. There can be only one default measurement unit within a category

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop no
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 bit
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Is_Default_Unit - Supported Filters

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

Measurement_Category_Id

Base measurement category Id

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_Measurement_Categories
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Measurement_Category_Id - Supported Filters

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

Measurement_Unit_Code

When not null, contains unique measurement unit code.

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 16
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable yes
Summary Type None
Supports EQUALS_IN no
Type nvarchar(16) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Measurement_Unit_Code - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Like None no no

Measurement_Unit_Name

Name of the measurement unit

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 64
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 nvarchar(64) (MultiLanguage)
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Measurement_Unit_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes
Like None no no

Multiplier

Multiplier of the relative value of the measurement unit against other units (multiplier when converting to base)

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 Short
User Login no
Visible yes

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

System_Unit

Not NULL only when this is one of the system measurement units. N=NetKG; G=GrossKG; V=VolumeL; H=HeightM; W=WidthM, L=LengthM, P=Piece, T=TimeH

Property Value
Allowed Values G, H, L, N, P, V, W, T
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
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 nvarchar(1) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

System_Unit - Supported Filters

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