view: orch_app_ar_royalty_accounting_contract_term_condition_uat {
  sql_table_name: ORCHARD_APP_REPORTING_V2.UAT_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_TERM_CONDITION ;;

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

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

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

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

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

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

  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 ;;
  }
}