This article will help you learn about the fields available in the Business Unit view, the field types, descriptions and how the fields are calculated
Key Topics
List as bullet points the key topics outlined in this article
View Definition
This view is linked to the [drp.order_business_unit] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.
| Field Name | Field Type | Description | Source / Calculation |
| Business Channel | Dimension | From the Daasity UI (Direct to Consumer or Business to Business) | business_channel |
| Business Unit | Dimension | Value entered in the Daasity UI | business_unit |
| Sales Channel | Dimension | Sales Channel based on Shopify App ID | sales_channel |
| Source Name | Dimension | The name of the integration, as named by Daasity | source |
| Store Country | Dimension | Country entered in the Daasity UI for the Integration | store_country |
| Store Integration Name | Dimension | The Name from the Location otherwise the name from the Daasity UI | store_integration_name |
| Store Name | Dimension | Location Name otherwise the Store Type from the Daasity UI (eCommerce, Wholesale, Retail, Amazon, Marketplace, Manual Orders) | store_name |
| Store Type | Dimension | Type selected in the Daasity UI for the Integration | store_type |
Explores
This view is part of the following explores:
- Order & Order Line Revenue
Transformation Code
This view is a Daasity derived table generated by the following code:
- [2710_OST_BAS_order_business_unit.sql]