Table Gen_Brands
Entity
Entity: General.Brands
Contains information about product brands - name, manufacturer, logo etc. Entity: Gen_Brands (Introduced in version 27.1.2.3)
Summary
| Name | Type | Description |
|---|---|---|
| Brand_Id | uniqueidentifier PK |
Unique identifier of the record. |
| Code | nvarchar(16) |
Unique code identifying the brand. |
| IsActive | bit |
Indicates whether the brand is active. |
| Logo | varbinary |
Logo of the brand. |
| Manufacturer | nvarchar(254) |
The main manufacturer of the products under this brand. |
| Name | nvarchar(255) |
Name of the brand. |
| Notes | nvarchar(254) |
Additional information about the brand. |
| Row_Version | timestamp |
Contains information about product brands - name, manufacturer, logo etc. |
Columns
Brand_Id
Unique identifier of the record.
| 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 |
Brand_Id - Supported Filters
| Filter Type | Default | Include Nulls | Hidden by Default |
|---|---|---|---|
| Equals | NULL |
no | no |
| GreaterThanOrLessThan | None | no | yes |
Code
Unique code identifying the brand.
| 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 |
IsActive
Indicates whether the brand is active.
| Property | Value |
|---|---|
| Auto Complete | no |
| Data Filter | no |
| Default Value | True |
| 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 | bit |
| UI Memo Editor | no |
| UI Width | Medium |
| User Login | no |
| Visible | yes |
Logo
Logo of the brand.
| 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 | varbinary |
| UI Memo Editor | no |
| UI Width | Medium |
| User Login | no |
| Visible | yes |
Manufacturer
The main manufacturer of the products under this brand.
| 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 | 254 |
| 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(254) (Allows NULL) |
| UI Memo Editor | no |
| UI Width | Medium |
| User Login | no |
| Visible | yes |
Name
Name of the brand.
| 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 | 255 |
| 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(255) |
| UI Memo Editor | no |
| UI Width | Medium |
| User Login | no |
| Visible | yes |
Notes
Additional information about the brand.
| 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 | 254 |
| 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(254) (Allows NULL) |
| UI Memo Editor | no |
| UI Width | Medium |
| User Login | no |
| Visible | yes |
Row_Version
Contains information about product brands - name, manufacturer, logo etc.
| 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 |