view: orch_app_ar_product_territory_split {
 sql_table_name: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_TERRITORY_SPLIT ;;

dimension: PRODUCT_TERRITORY_SPLIT_ID {
  type: number
  sql: ${TABLE}.PRODUCT_TERRITORY_SPLIT_ID ;;
  primary_key: yes
  hidden: yes
}

  dimension: vendor_id {
    type: number
    sql: ${TABLE}.vendor_id ;;
    hidden: yes
  }

  dimension: product_id {
    type: number
    sql: ${TABLE}.product_id ;;
    hidden: yes
  }

  dimension: country_id {
    type: number
    sql: ${TABLE}.country_id ;;
    hidden: yes
  }

  dimension: split_rate {
    label: "Product Territory Split Rate"
    type: number
    sql: ROUND(1-${TABLE}.split_rate,2) ;;
    value_format: "0%"
  }

}