Attributes

Attributes can be defined as characteristics of system entities. For example, CPU Speed and Ram Size can be defined as computer attributes.

The Sterling Selling and Fulfillment Foundation supports the following attributes:

Attributes with valid values

The Sterling Selling and Fulfillment Foundation enables you to define attributes with the following data types:

Derived attributes

Derived attributes are attributes that represent a specific aspect of another attribute. You can define multiple derived attributes for an attribute and assign these derived attributes to different categories. For example, you can define two derived attributes called Dimension Range and associate them with the Dimension attributes in the TVs and Computers category. When an online customer searches for TVs, the system calculates the dimension range for each TV, based on the TV's dimensions, and displays the TVs in the appropriate ranges. Online customers can locate 32-inch TVs in the 32-35 inch range and 40-inch TVs in the 40-50 inch range.

Note: You assign attributes and derived attributes to categories but cannot assign values to derived attributes.
Only the decimal and integer data type is supported as a valid value for derived attributes.

Attributes by reference

Attribute management allows you to dynamically create and assign attributes without extending database tables. However, in some cases, you may want to use attributes that reference database fields, such as the yfs_item table. In this case, the assigned values of the attribute are extracted from the corresponding field in the database table. For example, if an attribute called Lead Time refers to the Lead Time field in the yfs_item table, the value for the item attribute information is taken from the Lead Time field in the yfs_item table.