# View: KNR_Ownership_Run_Delivered_Societies

**View Name:** KNR_Ownership_Run_Delivered_Societies
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_Relations.Customer_Master_Master, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Dim_Transactiontype + 3 more`
**File Path:** `views/KNR_Ownership_Run_Delivered_Societies.view.lkml`

## Overview

- **File Size:** 1260 bytes
- **Lines of Code:** 42
- **Dimensions:** 3
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Batch_ID` | string |
| `Store_ID` | string |
| `Store_Name` | string |

## Measures

| Name | Type |
|------|------|
| `Sum_Total_USD` | sum |
| `Sum_Total_WHT` | sum |

## Derived Table

```sql
sql:
    select
    dist.batch_id,
    dist.store_id,
    st.customer_name,
    round(sum(dist.TOTAL_USD),5) total_usd,
    round(sum(dist.WITHHOLDING_TAX_USD),5) wht_usd
    from royalty_accounting.prod.stmt_db_sales_distro dist
    join orchard_app_reporting_v2.art_relations_prod_art_relations.country cn on cn.id=dist.country_id
     join orchard_app_reporting_v2.art_relations_prod_art_relations.customer_master_master st on st.customer_master_master_id = dist.store_id
    LEFT JOIN FACTS.PROD.DIM_TRANSACTIONTYPE DTT ON dtt.transactiontypeabbr =dist.transaction_type
    where dtt.transactiontypeabbr in ('RC','EH','PX','CC','CX','ER','RW','MA','MD','PA','PV','RR','PP','RL','SL','TV','UP','UN','NC')
    group by 1,2,3
          ;;
```