view: orch_app_ar_subaccount {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.subaccount ;;
  suggestions:no

  dimension: city {
    type: string
    sql: ${TABLE}.city ;;
    hidden: yes
  }

  dimension: commission_override {
    description: "Override the deafault split rate which was set for all the subaccount by the label"
    type: number
    sql: ${TABLE}.commission_override ;;
  }

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

  dimension: created_date {
    type: date
    sql: ${TABLE}.date_created ;;
  }

  dimension: date_deleted {
    type: date_time
    sql: ${TABLE}.date_deleted ;;
    hidden: yes
  }

  dimension: is_deleted {
    label: "is Deleted"
    type: yesno
    sql: ${TABLE}.date_deleted is not null;;
    hidden: yes
  }

  dimension: description {
    type: string
    sql: ${TABLE}.description ;;
    hidden: yes
  }

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

  dimension: last_updated {
    type: date_time
    sql: ${TABLE}.last_updated ;;
    hidden: yes
  }

  dimension: myspace_url {
    type: string
    sql: ${TABLE}.myspace_url ;;
    hidden: yes
  }

  dimension: other_state {
    type: string
    sql: ${TABLE}.other_state ;;
    hidden: yes
  }

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

  dimension: subaccount_id {
    description: "Unique ID for a subaccount under a label"
    type: number
    sql: ${TABLE}.subaccount_id ;;
  }

  dimension: subaccount_name {
    description: "Name of the subaccount"
    type: string
    sql: ${TABLE}.subaccount_name ;;
  }

  dimension: split_type {
    description: "This is the split of revenue between label and subaccoubnt. Indicating whether this is taken from gross or net"
    type: string
    sql: ${TABLE}.subaccount_split_type ;;
  }

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

  dimension: website_url {
    type: string
    sql: ${TABLE}.website_url ;;
    hidden: yes
  }

  measure: count_subaccounts {
    label: "Number of Subaccounts"
    type: count_distinct
    sql: ${subaccount_id} ;;
  }
}