view: orch_app_ar_royalty_accounting_contract_term_uat {
 sql_table_name: ORCHARD_APP_REPORTING_V2.UAT_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_TERM ;;

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

  dimension: term_type {
    type: string
    sql: ${TABLE}.term_type ;;
  }

  dimension: contract_id {
    type: number
    sql: ${TABLE}.contract_id ;;
  }

  dimension: attachments {
    type: string
    sql: ${TABLE}.attachments ;;
  }

  dimension: is_base_term {
    type: yesno
    sql: ${TABLE}.is_base_term='TRUE' ;;
  }

  dimension: contract_term_name {
    type: string
    sql: ${TABLE}.contract_term_name ;;
  }

  dimension: attachment_relations {
    type: string
    sql: ${TABLE}.attachment_relations ;;
  }

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

  dimension: created_at {
    type: date_time
    sql: ${TABLE}.created_at ;;
  }

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

  dimension: last_modified {
    type: date_time
    sql: ${TABLE}.last_modified ;;
  }

  dimension: deleted_by {
    type: string
    sql: ${TABLE}.deleted_by ;;
  }

  dimension: deleted_at {
    type: date_time
    sql: ${TABLE}.deleted_at ;;
  }
}