view: awal_awal_finance_fpa_pr_neighboringrights {
  sql_table_name: AWAL.AWAL_FINANCE.FPA_PR_NEIGHBOURINGRIGHTS;;

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

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

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

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

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

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

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

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

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

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

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

  dimension: TASK_SERVICE_LEVEL {
    type: number
    sql: ${TABLE}.TASK_SERVICE_LEVEL ;;
  }

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

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

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

  dimension: stat_year {
    type: number
    sql: ${TABLE}.stat_year;;
  }

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

  dimension: stat_month {
    type: string
    sql: ${TABLE}.stat_mnth;;
  }

  dimension: fiscal_year {
    type: number
    sql: ${TABLE}.fiscal_year;;
  }

  dimension: fiscal_year_sony {
    type: number
    sql: ${TABLE}.fiscal_year_sony;;
  }

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

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

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


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

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

  dimension: ROYALTY_ADJUSTMENT_PAYMENT {
    type: number
    sql: ${TABLE}.ROYALTY_ADJUSTMENT_PAYMENT;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  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 {
    type: sum
    sql: ${TABLE}.USDHIST_REVENUE ;;
    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_DIR_COLL_FEE {
    type: sum
    sql: ${TABLE}.USDHIST_DIR_COLL_FEE ;;
    value_format: "#,##0"
  }

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

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

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

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

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

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

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

}