view: orch_app_ar_royalty_contract {
  sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT ;;

  dimension: contract_id {
    type: number
    view_label: "Contract"
    label: "Contract ID"
    primary_key: yes
    sql: ${TABLE}.contract_id ;;
  }

  dimension: contract_type {
    type: string
    view_label: "Contract"
    label: "Contract Type"
    sql: ${TABLE}.contract_type ;;
  }

  dimension: contract_name {
    type: string
    view_label: "Contract"
    label: "Contract Name"
    sql: ${TABLE}.contract_name ;;
  }

  dimension_group: term_start {
    view_label: "Contract"
    label: "Term Start"
    type: time
    sql: ${TABLE}.term_start ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

  dimension_group: term_end {
    view_label: "Contract"
    label: "Term End"
    type: time
    sql: ${TABLE}.term_end ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

}