view: int_awal_historical_datasets_temp_rd_awal_usage {
  sql_table_name: AWAL.AWAL_FINANCE.RD_AWAL_USAGE ;;

  dimension: COMMERCIAL_MODEL_TYPE_DESCRIPTION {
    type: string
    sql: ${TABLE}.COMMERCIAL_MODEL_TYPE_DESCRIPTION ;;
  }
  dimension: INTERESTED_PARTY_SOURCE_NAME {
    type: string
    sql: ${TABLE}.INTERESTED_PARTY_SOURCE_NAME ;;
  }
  dimension: BATCH_RECEIVER_IP_ID {
    type: string
    sql: ${TABLE}.BATCH_RECEIVER_IP_ID ;;
  }
  dimension: BATCH_RECEIVER_IP_NAME {
    type: string
    sql: ${TABLE}.BATCH_RECEIVER_IP_NAME ;;
  }
  dimension: ROYALTIES_ORIGINAL_DATA_OTHER_DATA_7 {
    type: string
    sql: ${TABLE}.ROYALTIES_ORIGINAL_DATA_OTHER_DATA_7 ;;
  }
  dimension: TERRITORY_GROUP_4 {
    type: string
    sql: ${TABLE}.TERRITORY_GROUP_4 ;;
  }
  dimension: TERRITORY_GROUP_2 {
    type: string
    sql: ${TABLE}.TERRITORY_GROUP_2 ;;
  }
  dimension: RIGHT_TYPE_DESCRIPTION {
    type: string
    sql: ${TABLE}.RIGHT_TYPE_DESCRIPTION ;;
  }
  dimension: RIGHT_TYPE_REPORTING {
    type: string
    sql: ${TABLE}.RIGHT_TYPE_REPORTING ;;
  }
  dimension: RIGHT_TYPE_GROUPS {
    type: string
    sql: ${TABLE}.RIGHT_TYPE_GROUPS ;;
  }
  dimension: MAX_PAYMENT_MONTH {
    type: date
    sql: ${TABLE}.MAX_PAYMENT_MONTH ;;
  }#date
  dimension: ROYALTY_PERIOD_START_MONTH {
    type: date
    sql: ${TABLE}.ROYALTY_PERIOD_START_MONTH ;;
  }
  dimension: ROYALTY_PERIOD_END_MONTH {
    type: date
    sql: ${TABLE}.ROYALTY_PERIOD_END_MONTH ;;
  }
  measure: ROYALTY_QUANTITY {
    type: sum
    sql: ${TABLE}.ROYALTY_QUANTITY ;;
  }
  measure: ROYALTY_FIN_USD_SOURCE_AMOUNT {
    type: sum
    sql: ${TABLE}.ROYALTY_FIN_USD_SOURCE_AMOUNT ;;
  }
  measure: ROYALTY_FIN_USD_RECEIVED_AMOUNT {
    type: sum
    sql: ${TABLE}.ROYALTY_FIN_USD_RECEIVED_AMOUNT ;;
  }

}