The following describes each of the columns in the Transaction Business View table.
The Transaction Business View table columns
| Column Name | Type | Description |
| customer_hub_id | TEXT | Unique Hub customer ID. |
| order_hub_id | TEXT | Unique Hub order ID/event ID. |
| order_id | TEXT | Customer order ID. |
| order_date | TIMESTAMP | Order date. |
| order_payment_method | TEXT | Payment method. |
| order_shipping_method | TEXT | Shipping method. |
| order_total | DOUBLE | Total order value. |
| order_revenue | DOUBLE | Order revenue. |
| order_shipping | DOUBLE | Shipping cost. |
| order_tax | DOUBLE | Tax cost. |
| order_discount | DOUBLE | Discount value. |
| order_currency | TEXT | Currency type. |
| order_exchange_rate | DOUBLE | Order exchange rate. |
| generated_line_id | INT | Order line IDs, generated by Hub. |
| order_line_id | TEXT | Line item ID. |
| order_line_type | TEXT | Line type: Sale or return. |
| order_line_quantity | BIGINT | Number of items. |
| order_line_subtotal | DOUBLE | Order line item value. |
| order_line_discount | DOUBLE | Order line item discount. |
| order_line_tax | DOUBLE | Tax cost for the line item. |
| order_line_coupon | TEXT | Coupon value for the line item. |
| product_id | TEXT | Product ID. |
| product_sku | TEXT | SKU number. |
| product_name | TEXT | Product name. |
| product_price | DOUBLE | Product price. |
| unique_line_id | TEXT | Unique Hub order line ID/event ID. |
| kpi_clv_ref_id | BIGINT | Identifies when the CLV algorithm ran. |
| kpi_clv_predicted_cluster | TEXT | Predicted customer CLV cluster value at the time of the event. |
| kpi_clv_churn_prob | DOUBLE | Customer churn probability value at the time of the event. |
| kpi_clv_current_cluster | TEXT | Customer CLV cluster value at the time of the event. |
| kpi_clv_predicted_expense | DOUBLE | Predicted customer expenditure value at the time of the event. |
| kpi_engagement_fixed_ref_id | BIGINT | Identifies when the fixed email engagement algorithm ran. |
| kpi_engagement_fixed_cluster | TEXT | Customer fixed email engagement cluster value at the time of the event. |
| kpi_engagement_moving_average_ref_id | BIGINT | Identifies when the moving average email engagement algorithm ran. |
| kpi_engagement_moving_average_cluster | TEXT | Customer moving average email engagement cluster value at the time of the event. |
Previous page: Digital table| Next page: Analytics Getting Started Guide