Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The CatalogAttributes table contains information about the attributes for a catalog property in the Catalog System. The following table describes the columns in the CatalogAttributes table. The CatalogAttributes table will have additional columns for the attributes that you define for a catalog property.
The following table describes the columns in the CatalogAttributes table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
PropertyName |
nvarchar(100) |
no |
The name of the property. This is a primary key. |
DataType |
smallint |
no |
The data type of the property. |
u_DefaultValue |
ntext |
yes |
The default string value for non-multilingual properties. |
i_DefaultValue |
bigint |
yes |
The default value for properties of the Integer and BigInteger data types. |
dt_DefaultValue |
datetime |
yes |
The default value for properties of the DateTime data type. |
cy_DefaultValue |
money |
yes |
The default value for properties of the Currency data type. |
f_DefaultValue |
bit |
yes |
The default value for properties of the Boolean data type. |
fp_DefaultValue |
float |
yes |
The default value for properties of the Float data type. |
i_MinValue |
bigint |
yes |
The minimum value that can be defined for properties of the Integer and BigInteger data type. |
i_MaxValue |
bigint |
yes |
The maximum value that can be defined for properties of the Integer and BigInteger data type. |
dt_MinValue |
datetime |
yes |
The minimum value that can be defined for properties of the Datetime data type. |
dt_MaxValue |
datetime |
yes |
The maximum value that can be defined for properties of the Datetime data type. |
fp_MinValue |
float |
yes |
The minimum value that can be defined for properties of the Float data type. |
fp_MaxValue |
float |
yes |
The maximum value that can be defined for properties of the Float data type. |
IsFreeTextSearchable |
bit |
yes |
Specifies whether the property is free-text searchable. |
IncludeInSpecSearch |
bit |
yes |
Specifies whether the property is included in results that are returned from specification searches. |
MinLength |
int |
yes |
The minimum length of a String data type. |
MaxLength |
int |
yes |
The maximum length of a String data type. |
cy_MinValue |
money |
yes |
The minimum value that can be defined for properties of the Currency data type. |
cy_MaxValue |
money |
yes |
The maximum value that can be defined for properties of the Currency data type. |
TimeStamp |
timestamp |
no |
The timestamp on the property. |
DisplayOnSite |
bit |
yes |
Specifies whether this property should be displayed on the Web site. |
DisplayName |
ntext |
yes |
The display name of the property. |
AssignAll |
bit |
yes |
Specifies whether this property should automatically be applied to all product definitions. |
ExportToDW |
bit |
yes |
Specifies whether this property should be exported to the Data Warehouse. |
DisplayInProductsList |
bit |
yes |
Specifies whether this product is displayed in the products list. |
LanguageSensitive |
bit |
no |
Specifies if this property is language-sensitive. |
IsRequired |
bit |
no |
Specifies is this property is required. |
Currency |
nvarchar(10) |
yes |
The currency to use. |
BuiltIn |
bit |
no |
Specifies whether this is a built-in property. |
DisplayAsBase |
bit |
no |
Specifies whether this property should appear in the Base Properties tab in the Catalog Manager. |
DisplayName_de-DE |
nvarchar(128) |
yes |
The language-sensitive display name. |
u_DefaultValue_de-DE |
ntext |
yes |
The language-sensitive default value for properties of the String type. .gif "Note") Note:
This table will contain a similar column for each language that you add.
|
DisplayName_en-US |
nvarchar(128) |
yes |
The language-sensitive display name. Note:
This table will contain a similar column for each language that you add.
|
u_DefaultValue_ en-US |
ntext |
yes |
The language-sensitive default value for properties of the String type. |
DisplayName_fr-FR |
nvarchar(128) |
yes |
The language-sensitive display name. |
u_DefaultValue_ fr-FR |
ntext |
yes |
The language-sensitive default value for properties of the String type. |
DisplayName_ja-JP |
nvarchar(128) |
yes |
The language-sensitive display name. |
u_DefaultValue_ ja-JP |
ntext |
yes |
The language-sensitive default value for properties of the String type. |