view: awal_awal_finance_rpd_nr_usage_extract {
  sql_table_name: AWAL.AWAL_FINANCE.RPD_NR_USAGE_EXTRACT ;;

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

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

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

  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: EXPLOITATION_FORMAT {
    type: string
    sql: ${TABLE}.EXPLOITATION_FORMAT ;;
  }

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

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

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

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

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

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

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

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

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

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

  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_REPORTING {
    type: string
    sql: ${TABLE}.RIGHT_TYPE_REPORTING ;;
  }

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

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

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

  dimension_group: ROYALTY_PERIOD_START_MONTH {
    label: "Royalty Period Start Month"
    type: time
    sql: ${TABLE}.ROYALTY_PERIOD_START_MONTH ;;
    timeframes: [
      date,
      month,
      month_num,
      month_name,
      quarter,
      quarter_of_year,
      year,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year
    ]
}

    dimension_group: ROYALTY_PERIOD_END_MONTH {
      label: "Royalty Period End Month"
      type: time
      sql: ${TABLE}.ROYALTY_PERIOD_END_MONTH ;;
      timeframes: [
        date,
        month,
        month_num,
        month_name,
        quarter,
        quarter_of_year,
        year,
        fiscal_month_num,
        fiscal_quarter,
        fiscal_quarter_of_year,
        fiscal_year
      ]

 }

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

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

  measure: ROY_PAY_FIN_USD_CHAIN_SOURCE_AMOUNT {
    type: sum
    sql: ${TABLE}.ROY_PAY_FIN_USD_CHAIN_SOURCE_AMOUNT ;;
    value_format: "$#,##0.00"
  }

  measure: ROY_PAY_FIN_USD_CHAIN_RECEIVED_AMOUNT {
    type: sum
    sql: ${TABLE}.ROY_PAY_FIN_USD_CHAIN_RECEIVED_AMOUNT ;;
    value_format: "$#,##0.00"
  }

  measure: ROY_PAY_FIN_ACC_CHAIN_SOURCE_AMOUNT {
    type: sum
    sql: ${TABLE}.ROY_PAY_FIN_ACC_CHAIN_SOURCE_AMOUNT ;;
    value_format: "#,##0.00"
  }

  measure: ROY_PAY_FIN_ACC_CHAIN_RECEIVED_AMOUNT {
    type: sum
    sql: ${TABLE}.ROY_PAY_FIN_ACC_CHAIN_RECEIVED_AMOUNT ;;
    value_format: "#,##0.00"
  }

  measure: ROY_PAY_FIN_GBP_CHAIN_SOURCE_AMOUNT {
    type: sum
    sql: ${TABLE}.ROY_PAY_FIN_GBP_CHAIN_SOURCE_AMOUNT ;;
    value_format: "#,##0.00"
  }

  measure: ROY_PAY_FIN_GBP_CHAIN_RECEIVED_AMOUNT {
    type: sum
    sql: ${TABLE}.ROY_PAY_FIN_GBP_CHAIN_RECEIVED_AMOUNT ;;
    value_format: "#,##0.00"
  }

}