Default and hidden fields

Not all fields in the Catalogs tool views are displayed by default. This page lists all of the database fields that can be displayed in a properties view in the Catalogs tool, and if they are displayed by default.

Properties views

Field View Default
Code Sales Catalog Yes
Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Attribute Dictionary Attribute Yes
Name Sales Catalog Yes
Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Attribute Dictionary Attribute Yes
Administrative description Sales Catalog No
UniqueID Attribute Dictionary Attribute Yes
Type Attribute Dictionary Attribute Yes
Description Attribute Dictionary Attribute Yes
Secondary description Attribute Dictionary Attribute Yes
Short description Sales Catalog Yes
Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Long description Sales Catalog Yes
Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Keyword Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Additional description 1 Product No
SKU No
Bundle or Kit No
Dynamic Kit No
Additional description 2 Product No
SKU No
Bundle or Kit No
Dynamic Kit No
Manufacturer part number Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Manufacturer Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Parent category (master catalog) Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Recurring order item Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
For purchase Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
On special Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
SKU No
Bundle or Kit No
Dynamic Kit No
Announcement date Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Withdrawal date Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Availability date Product No
SKU No
Bundle or Kit No
Dynamic Kit No
Last date to order Product No
SKU No
Bundle or Kit No
Dynamic Kit No
End of service date Product No
SKU No
Bundle or Kit No
Dynamic Kit No
Discontinued date Product No
SKU No
Bundle or Kit No
Dynamic Kit No
Track inventory Product No
Kit No
Dynamic Kit No
Allow back order Product No (ATP store only)
Kit No (ATP store only)
Dynamic Kit
Force back order Product No (ATP store only)
Kit No (ATP store only)
Dynamic Kit
Returns not required for refund Product No (ATP store only)
Kit No (ATP store only)
Dynamic Kit
Returns and refunds not allowed Product No (ATP store only)
Kit No (ATP store only)
Dynamic Kit
Fulfill separately Product No (ATP store only)
Kit No (ATP store only)
Dynamic Kit
Smallest measured amount used for inventory allocation Product No
Kit No
Dynamic Kit No
Unit of measure Product No
Kit No
Dynamic Kit No
Attribute Dictionary Attribute Yes
Display to customers Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Thumbnail image Sales Catalog Yes
Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Full image Sales Catalog Yes
Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
List Price Product Yes
SKU Yes
Kit Yes
Dynamic Kit No (Cannot be displayed. Price is the sum of component prices.)
Offer Price Product Yes
SKU Yes
Kit Yes
Dynamic Kit No (Cannot be displayed. Price is the sum of component prices.)
URL Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit
Field 1 Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Attribute Dictionary Attribute Yes
Field 2 Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Attribute Dictionary Attribute Yes
Field 3 Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Attribute Dictionary Attribute Yes
Field 4 Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Attribute Dictionary Attribute Yes
Field 5 Product Yes
SKU Yes
Bundle or Kit Yes
Dynamic Kit Yes
Attribute Dictionary Attribute Yes
Note Attribute Dictionary Attribute Yes
Description Field 1 Attribute Dictionary Attribute Yes
Group Name Attribute Dictionary Attribute Yes
Associated Keyword Attribute Dictionary Attribute Yes
Displayable Attribute Dictionary Attribute Yes
Comparable Attribute Dictionary Attribute Yes
Searchable Attribute Dictionary Attribute Yes
Value Attribute Dictionary Attribute Yes
Default value Attribute Dictionary Attribute Yes
Value field1 Attribute Dictionary Attribute Yes
Value field2 Attribute Dictionary Attribute Yes
Value field3 Attribute Dictionary Attribute Yes
Value description field 1 Attribute Dictionary Attribute Yes
Value description field 2 Attribute Dictionary Attribute Yes
Value description field 3 Attribute Dictionary Attribute Yes
Image path 1 Attribute Dictionary Attribute Yes
Image path 2 Attribute Dictionary Attribute Yes
The following table lists all the fields that are available for display in Catalogs tool tables and list views, and if they are displayed by default. Fields that are available for display, can be hidden in the Management Center user interface. To display hidden fields in a table or List view, right-click a column heading; then click Configure Columns in the context menu and select the fields to display.

Tables

Field Table Default
Sequence
  • Descriptive attributes
  • Merchandising associations
  • Attribute Dictionary Attribute
  • Yes
  • Yes
  • Yes
Unique ID
  • Attribute Dictionary Attribute
  • Merchandising associations
  • Yes
  • No
Type
  • Attribute Dictionary Attribute
  • Merchandising associations
  • Yes
  • Yes
Name
  • Descriptive attributes
  • Defining attributes
  • Attribute Dictionary Attribute
  • Merchandising associations
  • Yes
  • Yes
  • Yes
  • No
Data Type
  • Descriptive attributes
  • Defining attributes
  • Attribute Dictionary Attribute
  • Yes
  • Yes
  • Yes
Value
  • Descriptive attributes
  • Attribute Dictionary Attribute
  • Yes
  • Yes
Default Value
  • Attribute Dictionary Attribute
  • Yes
Image Path 1
  • Descriptive attributes
  • Attribute Dictionary Attribute
  • No
  • Yes
Image Path 2
  • Descriptive attributes
  • Attribute Dictionary Attribute
  • No
  • Yes
Unit of measure
  • Descriptive attributes
  • Attribute Dictionary Attribute
  • No
  • Yes
Description
  • Defining attributes
  • Attribute Dictionary Attribute
  • Yes
  • Yes
Secondary Descriptions
  • Attribute Dictionary Attribute
  • Yes
Note
  • Attribute Dictionary Attribute
  • Yes
Group Name
  • Attribute Dictionary Attribute
  • Yes
Associated Keyword
  • Attribute Dictionary Attribute
  • Yes
Displayable
  • Attribute Dictionary Attribute
  • Yes
Searchable
  • Attribute Dictionary Attribute
  • Yes
Comparable
  • Attribute Dictionary Attribute
  • Yes
Value Field 1
  • Attribute Dictionary Attribute
  • Yes
Value Field 2
  • Attribute Dictionary Attribute
  • Yes
Value Field 3
  • Attribute Dictionary Attribute
  • Yes
Relationship Field 1
  • Attribute Dictionary Attribute
  • Yes
Relationship Field 2
  • Attribute Dictionary Attribute
  • Yes
Relationship Field 3
  • Attribute Dictionary Attribute
  • Yes
Value Description Field 1
  • Attribute Dictionary Attribute
  • Yes
Value Description Field 2
  • Attribute Dictionary Attribute
  • Yes
Value Description Field 3
  • Attribute Dictionary Attribute
  • Yes
Code
  • Merchandising associations
  • Attribute Dictionary Attribute
  • Yes
  • Yes
Association
  • Merchandising associations
  • Yes
Quantity
  • Merchandising associations
  • Yes
Semantic
  • Merchandising associations
  • No
Date
  • Merchandising associations
  • No
Qualifier
  • Offer price
  • No
Offer Description
  • Offer price
  • No

List views

Note: Fields in the Catalogs tool list views can have the same title, however, the usage of the field can differ and is based on the object it is associated with. For example, in the attribute dictionary-attributes list view the field Name is used for the attribute name, while in the catalog entries list view the field Name is used for the catalog entry part number, not the name of catalog entry.
Field View
Unique ID
  • Categories List
  • Catalog Entries List
  • SKU List
  • Attribute Dictionary Attributes List
Owner ID
  • Categories List
  • Catalog Entries List
  • SKU List
Sequence
  • Categories List
  • Catalog Entries List
  • SKU List
  • Attribute Dictionary Attributes List
Code
  • Categories List
  • Catalog Entries List
  • SKU List
  • Attribute Dictionary Attribute List
Thumbnail
  • Categories List
  • Catalog Entries List
  • SKU List
Thumbnail Path
  • Categories List
  • Catalog Entries List
  • SKU List
Full Image
  • Categories List
  • Catalog Entries List
  • SKU List
Full Image Path
  • Categories List
  • Catalog Entries List
  • SKU List
Display to Customers
  • Categories List
  • Catalog Entries List
  • SKU List
Short Description
  • Categories List
  • Catalog Entries List
  • SKU List
Type
  • Categories List
  • Catalog Entries List
  • SKU List
  • Attribute Dictionary Attributes List
Buyable
Note: This column displays as For purchase in the properties view for catalog entries.
  • Catalog Entries List
  • SKU List
Manufacturer Part Number
  • Catalog Entries List
  • SKU List
Manufacturer Name
  • Catalog Entries List
  • SKU List
Name
  • Categories List
  • Catalog Entries List
  • SKU List
  • Attribute Dictionary Attributes List
Long Description
  • Catalog Entries List
  • SKU List
Parent Category
  • Catalog Entries List
  • SKU List
Parent Catalog
  • Catalog Entries List
  • SKU List
Keyword
  • Catalog Entries List
  • SKU List
List Price
  • Catalog Entries List
  • SKU List
Currency
  • Catalog Entries List
  • SKU List
On Special
  • Catalog Entries List
  • SKU List
Announcement Date
  • Catalog Entries List
  • SKU List
Withdrawal Date
  • Catalog Entries List
  • SKU List
Field 1
  • Catalog Entries List
  • SKU List
Field 2
  • Catalog Entries List
  • SKU List
Field 3
  • Catalog Entries List
  • SKU List
Field 4
  • Catalog Entries List
  • SKU List
Field 5
  • Catalog Entries List
  • SKU List
Last Order Date
  • SKU List
End of Service Date
  • SKU List
Discontinued Date
  • SKU List
URL
  • Catalog Entries List
  • SKU List
Availability Date
  • SKU List
Data Type
  • Attribute Dictionary Attribute
Displayable
  • Attribute Dictionary Attribute
Searchable
  • Attribute Dictionary Attribute
Comparable
  • Attribute Dictionary Attribute
Description
  • Attribute Dictionary Attribute
Secondary Description
  • Attribute Dictionary Attribute
Unit of Measure
  • Attribute Dictionary Attribute
Note
  • Attribute Dictionary Attribute
Associated Keyword
  • Attribute Dictionary Attribute