view: KNR_Ownership_Run_Delivered_Societies {
  derived_table: {
    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
          ;;
  }

  dimension: Batch_ID {
    type:  string
    sql: ${TABLE}.batch_id ;;
  }
  dimension: Store_ID {
    type:  string
    sql: ${TABLE}.Store_id ;;
  }
  dimension: Store_Name {
    type:  string
    sql: ${TABLE}.customer_name ;;
  }
  measure: Sum_Total_USD {
    type: sum
    sql: ${TABLE}.total_usd ;;
    value_format: "#,##0.00"
  }

  measure: Sum_Total_WHT {
    type: sum
    sql: ${TABLE}.wht_usd ;;
    value_format: "#,##0.00"
  }
}