view: int_awal_historical_datasets_temp_fpa_recoup_rev_awal {
  sql_table_name: AWAL.AWAL_FINANCE.FPA_RECOUP_REV_AWAL ;;

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

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

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

  dimension: STAT_Q_DATE {
    type: date
    sql: ${TABLE}.STAT_Q_DATE ;;
  }

  dimension_group: STAT_M_DATE {
    view_label: "DATE"
    label: "STAT_M_DATE"
    type: time
    sql: ${TABLE}.STAT_M_DATE ;;
    timeframes: [
      date,
      month,
      month_num,
      month_name,
      quarter,
      quarter_of_year,
      year,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year
    ]
  }

  measure: USDHIST_SOURCE {
    type: sum
    sql: ${TABLE}.USDHIST_SOURCE ;;
    value_format: "#,##0"
  }

  measure: USDHIST_RCVD {
    type: sum
    sql: ${TABLE}.USDHIST_RCVD ;;
    value_format: "#,##0"
  }

  measure: USDHIST_REVENUE_C {
    type: sum
    sql: ${TABLE}.USDHIST_REVENUE_C ;;
    value_format: "#,##0"
  }

  measure: USDHIST_CLIENT {
    type: sum
    sql: ${TABLE}.USDHIST_CLIENT ;;
    value_format: "#,##0"
  }

  measure: USDHIST_CLIENT_C {
    type: sum
    sql: ${TABLE}.USDHIST_CLIENT_C ;;
    value_format: "#,##0"
  }

  measure: USDHIST_MARGIN {
    type: sum
    sql: ${TABLE}.USDHIST_MARGIN ;;
    value_format: "#,##0"
  }

  measure: USDHIST_ADVANCE {
    type: sum
    sql: ${TABLE}.USDHIST_ADVANCE ;;
    value_format: "#,##0"
  }

  measure: USDHIST_RECOUPMENT_CALC {
    type: sum
    sql: ${TABLE}.USDHIST_RECOUPMENT_CALC ;;
    value_format: "#,##0"
  }

  measure: USDHIST_ADJUSTMENTS {
    type: sum
    sql: ${TABLE}.USDHIST_ADJUSTMENTS ;;
    value_format: "#,##0"
  }

  measure: USDHIST_BAL_PMTS {
    type: sum
    sql: ${TABLE}.USDHIST_BAL_PMTS ;;
    value_format: "#,##0"
  }

  measure: ACCT_CLOSING_BALANCE {
    type: sum
    sql: ${TABLE}.ACCT_CLOSING_BALANCE ;;
    value_format: "#,##0"
  }

  measure: USD_CLOSING_BALANCE {
    type: sum
    sql: ${TABLE}.USD_CLOSING_BALANCE ;;
    value_format: "#,##0"
  }


  measure: client_perc {
    label: "Client %"
    sql: sum(${TABLE}.USDHIST_CLIENT_C) / nullif(sum(${TABLE}.USDHIST_REVENUE_C),0);;
    value_format: "0.00%"
  }


}