view: orch_app_royalty_account_tax_info {
 sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.ACCOUNT_TAX_INFO ;;

  dimension_group: last_modified {
    type: time
    timeframes: [raw, date]
    sql: ${TABLE}.LAST_MODIFIED ;;
  }

  dimension: account_id {
    type: number
    sql: ${TABLE}.ACCOUNT_ID ;;
  }

  dimension: account_tax_info_id {
    type: number
    sql: ${TABLE}.ACCOUNT_TAX_INFO_ID ;;
  }

  dimension_group: created_at {
    type: time
    timeframes: [raw, date]
    sql: ${TABLE}.CREATED_AT ;;
  }

  dimension: created_by {
    type: string
    sql: ${TABLE}.CREATED_BY ;;
  }

  dimension: country_of_tax_residence {
    type: string
    sql: ${TABLE}.COUNTRY_OF_TAX_RESIDENCE ;;
  }

  dimension: last_modified_by {
    type: string
    sql: ${TABLE}.LAST_MODIFIED_BY ;;
  }

  dimension: fivetran_deleted {
    type: yesno
    sql: ${TABLE}._FIVETRAN_DELETED ;;
  }

  dimension_group: fivetran_synced {
    type: time
    timeframes: [raw]
    sql: ${TABLE}._FIVETRAN_SYNCED ;;
  }

  dimension: is_vat {
    type: yesno
    sql: ${TABLE}.IS_VAT ;;
  }

  dimension: is_sba_signed {
    type: yesno
    sql: ${TABLE}.IS_SBA_SIGNED ;;
  }

  dimension: is_vat_exempt {
    type: yesno
    sql: ${TABLE}.IS_VAT_EXEMPT ;;
  }

  dimension: is_tax_treaty_claimed {
    type: yesno
    sql: ${TABLE}.IS_TAX_TREATY_CLAIMED ;;
  }

  dimension: tax_employment_type {
    type: string
    sql: ${TABLE}.TAX_EMPLOYMENT_TYPE ;;
  }

  dimension: is_wht_applicable {
    type: yesno
    sql: ${TABLE}.IS_WHT_APPLICABLE ;;
  }

  dimension: is_resident_of_spanish_islands {
    type: yesno
    sql: ${TABLE}.IS_RESIDENT_OF_SPANISH_ISLANDS ;;
  }

  dimension: certificate_of_residence_expiration_date {
    type: date
    sql: ${TABLE}.CERTIFICATE_OF_RESIDENCE_EXPIRATION_DATE ;;
  }

  dimension: wht_rate_override {
    type: number
    sql: ${TABLE}.WHT_RATE_OVERRIDE ;;
  }
}