view: int_dbt_prod_awal_new_client_list_model {
  sql_table_name: INTELLIGENCE.DBT_PROD.AWAL_NEW_CLIENT_LIST_MODEL ;;

  dimension: AGR_ID {
    type: string
    sql: ${TABLE}.AGR_ID ;;
  }
  dimension: IP_ID {
    type: string
    sql: ${TABLE}.IP_ID ;;
  }
  dimension: ASSIGNOR {
    type: string
    sql: ${TABLE}.ASSIGNOR ;;
  }
  dimension: AQUIRER {
    type: string
    sql: ${TABLE}.AQUIRER ;;
  }
  dimension: SIGNED_Q {
    type: date
    sql: ${TABLE}.SIGNED_Q ;;
  }
  dimension: CREATED_Q {
    type: date
    sql: ${TABLE}.CREATED_Q ;;
  }
  dimension: LABEL_SERVICE_AGREEMENT_TYPE {
    type: string
    sql: ${TABLE}.LABEL_SERVICE_AGREEMENT_TYPE ;;
  }
  dimension: IS_TERMINATED {
    type: yesno
    sql: ${TABLE}.IS_TERMINATED ;;
  }

  dimension_group: TERMINATED_DATE {
    view_label: "Date"
    label: "TERMINATED_DATE"
    type: time
    sql: ${TABLE}.TERMINATED_DATE ;;
    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: DATEFROM {
    view_label: "Date"
    label: "DATEFROM"
    type: time
    sql: ${TABLE}.DATEFROM ;;
    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: DATETO {
    view_label: "Date"
    label: "DATETO"
    type: time
    sql: ${TABLE}.DATETO ;;
    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]
  }


}