view: historic_gis_acc_ccy {
  sql_table_name: INTELLIGENCE.DBT_PROD_KNR.HISTORIC_GENERATED_INCOME_SUMMARY_ACCOUNT_CURRENCY ;;

  dimension: AGR_ID {
    type:  string
    sql: ${TABLE}.AGR_ID ;;
    required_fields: [AGR_ID]
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension_group: Payment_Date {
    type: time
    timeframes: [date, month, quarter, year]
    sql: ${TABLE}.Payment_Date ;;
  }

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

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

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

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

  dimension: Commission_rate {
    type: number
    sql: ${TABLE}.Commission_rate;;
    value_format: "0.00"
  }

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

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

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

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

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