view: facts_prod_dim_subaccount {
  sql_table_name: facts.prod.dim_subaccount ;;

  dimension: subaccountid {
    label: "Subaccount ID"
    type: number
    sql: ${TABLE}.subaccountid ;;
    primary_key: yes
    hidden: yes
  }

  dimension: labelid {
    label: "Label ID"
    type: number
    sql: ${TABLE}.labelid ;;
    hidden: yes
  }

  dimension: subaccountname {
    label: "Subaccount Name"
    type: string
    sql: ${TABLE}.subaccountname ;;
  }

  dimension: split_type {
    type: string
    sql: ${TABLE}.subaccount_split_type ;;
  }

  dimension: commission_override {
    type: number
    sql: ${TABLE}.commissionoverride ;;
    # description: "The percentage owed to the sub-label on behalf of the D3"
  }

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