Order Item Attributes View

The Order Item Attributes view provides dimensions and measures for the extensible attributes associated with the Order Item data model.

The measures calculated by this view are:

Name Measure Type Description
Count Count Count of all order item attribute records.

The dimensions included in this view are:

Name Data Type Description
Attribute Name String The user-supplied name of the attribute.
Attribute Type String Will be "Shopper Entered" if the attribute value was entered by a shopper or "Predefined."
Attribute Value Data Type String The data type of the source product property, typically of type Bool, DateTime, Number, or String.
Attribute Value String Value of the attribute represented as a string. Will never be null.
Shopper Entered Attribute Value String Value of the attribute entered by the shopper represented as a string. May be null if attribute value is not entered by shopper.
Attribute Value (Boolean) Yes/No Value of the attribute if value data type is Boolean. Will be null if value data type is not Boolean.
Attribute Value (Datetime) Datetime Value of the attribute if value data type is Datetime. Will be null if value data type is not Datetime.
Attribute Value (Double) Number Value of the attribute if value data type is Double. Will be null if value data type is not Double.
Attribute Value (Number) Number Value of the attribute if value data type is Number. Will be null if value data type is not Number.
Attribute Value (String) String Value of the attribute if value data type is String. Will be null if value data type is not String.
Catalog ID Number Unique identifier for the product catalog to which the ordered product belongs.
Fully Qualified Attribute Code String Unique identifier for the attribute to which the product belongs.
Line ID Number The line identifier assigned to the order item.
Order ID String Internal unique identifier of the order.
Order Item Created Date Datetime The timestamp of the date and time that the order item attribute was created.
Order Item ID String Internal unique identifier of the order item.
Order Item Updated Date Datetime The timestamp of the date and time that the order item attribute was last updated.
Product Code String The unique user-defined identifier for a product.
Product Name String The user-supplied name of the product.
Shopper Entered Attribute Value (Boolean) Yes/No Value of the shopper entered attribute if value data type is Boolean. Will be null if value data type is not Boolean.
Shopper Entered Attribute Value (Datetime) Datetime Value of the shopper entered attribute if value data type is Datetime. Will be null if value data type is not Datetime.
Shopper Entered Attribute Value (Double) Number Value of the shopper entered attribute if value data type is Double. Will be null if value data type is not Double.
Shopper Entered Attribute Value (Number) Number Value of the shopper entered attribute if value data type is Number. Will be null if value data type is not Number.
Shopper Entered Attribute Value (String) String Value of the shopper entered attribute if value data type is String. Will be null if value data type is not String.
Site ID Number Unique identifier for the site. This ID is used at all levels of a store and catalog to associate objects to a site.
Site Name String The human readable name for the site associated with the Site ID.