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. |