view: awal_salesforce_opportunities {
  sql_table_name: BUSINESS_SYSTEMS_SALESFORCE_DATA.AWAL.OPPORTUNITY ;;

  dimension: id {
    view_label: "Opportunity"
    label: "Opportunity ID"
    type: string
    sql: ${TABLE}.id ;;
  }

  dimension: name {
    view_label: "Opportunity"
    label: "Opportunity Name"
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: is_migrated_c {
    view_label: "Opportunity"
    label: "Migrated"
    type: string
    sql: ${TABLE}.is_migrated_c ;;
  }

  dimension: record_type_name {
    view_label: "Opportunity"
    label: "Record Type"
    type: string
    sql: ${TABLE}.record_type_name ;;
  }

  dimension: migrated_from_opportunity_c {
    view_label: "Opportunity"
    label: "Migrated From ID"
    type: string
    sql: ${TABLE}.migrated_from_opportunity_c ;;
  }

  dimension: artist_or_label_name_c {
    view_label: "Opportunity"
    label: "Artist or Label Name"
    type: string
    sql: ${TABLE}.artist_or_label_name_c ;;
  }

  dimension: deal_type_masters_c {
    view_label: "Opportunity"
    label: "Deal Type"
    type: string
    sql: ${TABLE}.deal_type_masters_c ;;
  }

  dimension: EXISTING_AGREEMENTS_ABACUSACCOUNT_ID_C {
    view_label: "Current Clients"
    label: "Account ID (Existing Agrs)"
    type: string
    sql: ${TABLE}.EXISTING_AGREEMENTS_ABACUSACCOUNT_ID_C ;;
  }

  dimension: existing_agreements_c {
    view_label: "Current Clients"
    label: "Existing Agreements"
    type: string
    sql: ${TABLE}.existing_agreements_c ;;
  }

  dimension: RELATIONSHIP_TO_EXISTING_AGREEMENTS_C {
    view_label: "Current Clients"
    label: "Existing Agr Relationship"
    type: string
    sql: ${TABLE}.RELATIONSHIP_TO_EXISTING_AGREEMENTS_C ;;
  }

  dimension: EXISTING_AGREEMENTS_DETAILS_C {
    view_label: "Current Clients"
    label: "Existing Agr Details"
    type: string
    sql: ${TABLE}.EXISTING_AGREEMENTS_DETAILS_C ;;
  }

  dimension: CROSSED_WITH_PRIOR_AGREEMENTS_C {
    view_label: "Current Clients"
    label: "Crossed with Prior Agr"
    type: string
    sql: ${TABLE}.CROSSED_WITH_PRIOR_AGREEMENTS_C ;;
  }

  dimension: stage_name {
    view_label: "Opportunity"
    label: "Opportunity Stage"
    type: string
    sql: ${TABLE}.stage_name ;;
  }

  dimension: lead_deal_maker_c {
    view_label: "Opportunity"
    label: "Lead Dealmaker"
    type: string
    sql: ${TABLE}.lead_deal_maker_c ;;
  }

  dimension: other_deal_makers_c {
    view_label: "Opportunity"
    label: "Other Dealmaker(s)"
    type: string
    sql: ${TABLE}.other_deal_makers_c ;;
  }

  dimension: deal_lawyer_c {
    view_label: "Opportunity"
    label: "AWAL BA"
    type: string
    sql: ${TABLE}.deal_lawyer_c ;;
  }

  dimension: deal_lost_to_c {
    view_label: "Opportunity"
    label: "Deal Lost To"
    type: string
    sql: ${TABLE}.deal_lost_to_c ;;
  }

  dimension: LICENSE_PERIOD_IN_YEARS_C {
    view_label: "Opportunity"
    label: "License Period"
    type: string
    sql: ${TABLE}.LICENSE_PERIOD_IN_YEARS_C ;;
  }

  dimension: scope_of_deal_c {
    view_label: "Opportunity"
    label: "Scope of Deal"
    type: string
    sql: ${TABLE}.scope_of_deal_c ;;
  }

  dimension: client_type_c {
    view_label: "Opportunity"
    label: "Client Type"
    type: string
    sql: ${TABLE}.client_type_c ;;
  }

  dimension: client_service_tier_c {
    view_label: "Opportunity"
    label: "Client Service Tier"
    type: string
    sql: ${TABLE}.client_service_tier_c ;;
  }

  dimension: opportunity_currency_c {
    view_label: "Currency"
    label: "Currency"
    type: string
    sql: ${TABLE}.opportunity_currency_c ;;
  }

  measure: exchange_rate_c {
    view_label: "Currency"
    label: "Exchange Rate"
    type: sum
    sql: ${TABLE}.exchange_rate_c ;;
  }

  dimension: primary_genre_c {
    view_label: "Artist Details"
    label: "Primary Genre"
    type: string
    sql: ${TABLE}.primary_genre_c ;;
  }

  dimension: artist_gender_c {
    view_label: "Artist Details"
    label: "Gender"
    type: string
    sql: ${TABLE}.artist_gender_c ;;
  }

  dimension: artist_ethnicity_race_c {
    view_label: "Artist Details"
    label: "Ethnicity or Race"
    type: string
    sql: ${TABLE}.artist_ethnicity_race_c ;;
  }

  dimension: CURRENT_LABEL_DISTRIBUTION_PARTNER_C {
    view_label: "Artist Details"
    label: "Current Label Partner"
    type: string
    sql: ${TABLE}.CURRENT_LABEL_DISTRIBUTION_PARTNER_C ;;
  }

  dimension: client_lawyer_c {
    view_label: "Artist Details"
    label: "Client Lawyer"
    type: string
    sql: ${TABLE}.client_lawyer_c ;;
  }

  dimension: LAWYER_FIRM_C {
    view_label: "Artist Details"
    label: "Client Lawyer Firm"
    type: string
    sql: ${TABLE}.LAWYER_FIRM_C ;;
  }

  dimension: lawyer_email_address_C {
    view_label: "Artist Details"
    label: "Client Lawyer Firm"
    type: string
    sql: ${TABLE}.lawyer_email_address_C ;;
  }

  dimension: country_c {
    view_label: "Country"
    label: "Country"
    type: string
    sql: ${TABLE}.country_c ;;
  }

  dimension: contracting_party_country_c {
    view_label: "Country"
    label: "Contracting Country"
    type: string
    sql: ${TABLE}.contracting_party_country_c ;;
  }

  dimension: manager_country_c {
    view_label: "Country"
    label: "Manager Country"
    type: string
    sql: ${TABLE}.manager_country_c ;;
  }

  dimension: smereferral_c {
    view_label: "Referrals"
    label: "SME Referral"
    type: string
    sql: ${TABLE}.smereferral_c ;;
  }

  dimension: smepartner_c {
    view_label: "Referrals"
    label: "SME Partner"
    type: string
    sql: ${TABLE}.smepartner_c ;;
  }

  dimension: marketing_fund_admin_by_c {
    view_label: "Funding"
    label: "Marketing Admin"
    type: string
    sql: ${TABLE}.marketing_fund_admin_by_c ;;
  }

  measure: MARKETING_FUND_COMMITTED_C {
    view_label: "Funding"
    label: "Marketing Fund"
    type: sum
    sql: ${TABLE}.MARKETING_FUND_COMMITTED_C ;;
    value_format: "#,##0.00"
  }

  measure: MARKETING_FUND_COMMITTED_USD {
    view_label: "Funding"
    label: "Marketing Fund USD"
    type: sum
    sql: ${TABLE}.MARKETING_FUND_COMMITTED_C / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  measure: ADVANCE_ON_SIGNING_C {
    view_label: "Funding"
    label: "Advance on Signing"
    type: sum
    sql: ${TABLE}.ADVANCE_ON_SIGNING_C ;;
    value_format: "#,##0.00"
  }

  measure: ADVANCE_ON_SIGNING_C_USD {
    view_label: "Funding"
    label: "Advance on Signing USD"
    type: sum
    sql: ${TABLE}.ADVANCE_ON_SIGNING_C / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  measure: OTHER_COMMITTED_ADVANCES_C {
    view_label: "Funding"
    label: "Other Advances"
    type: sum
    sql: ${TABLE}.OTHER_COMMITTED_ADVANCES_C ;;
    value_format: "#,##0.00"
  }

  measure: OTHER_COMMITTED_ADVANCES_USD {
    view_label: "Funding"
    label: "Other Advances USD"
    type: sum
    sql: ${TABLE}.OTHER_COMMITTED_ADVANCES_C / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  measure: RECORDING_FUND_C {
    view_label: "Funding"
    label: "Recording Fund"
    type: sum
    sql: ${TABLE}.RECORDING_FUND_C ;;
    value_format: "#,##0.00"
  }

  measure: RECORDING_FUND_USD {
    view_label: "Funding"
    label: "Recording Fund USD"
    type: sum
    sql: ${TABLE}.RECORDING_FUND_C / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  measure: tour_funding_c {
    view_label: "Funding"
    label: "Tour Support"
    type: sum
    sql: ${TABLE}.tour_funding_c ;;
    value_format: "#,##0.00"
  }

  measure: tour_funding_USD {
    view_label: "Funding"
    label: "Tour Support USD"
    type: sum
    sql: ${TABLE}.tour_funding_c / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  measure: non_recoupable_funding_c {
    view_label: "Funding"
    label: "Non-Recoupable"
    type: sum
    sql: ${TABLE}.non_recoupable_funding_c ;;
    value_format: "#,##0.00"
  }

  measure: non_recoupable_funding_USD {
    view_label: "Funding"
    label: "Non-Recoupable USD"
    type: sum
    sql: ${TABLE}.non_recoupable_funding_c / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  measure: legal_fees_contribution_c {
    view_label: "Funding"
    label: "Legal Fees"
    type: sum
    sql: ${TABLE}.legal_fees_contribution_c ;;
    value_format: "#,##0.00"
  }

  measure: legal_fees_contribution_USD {
    view_label: "Funding"
    label: "Legal Fees USD"
    type: sum
    sql: ${TABLE}.legal_fees_contribution_c / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  dimension: has_contingent_funding_c {
    view_label: "Funding"
    label: "Contingent"
    type: string
    sql: ${TABLE}.has_contingent_funding_c ;;
  }

  measure: contingent_funding_c {
    view_label: "Funding"
    label: "Contingent Funding"
    type: sum
    sql: ${TABLE}.contingent_funding_c ;;
    value_format: "#,##0.00"
  }

  measure: contingent_funding_USD {
    view_label: "Funding"
    label: "Contingent Funding USD"
    type: sum
    sql: ${TABLE}.contingent_funding_c / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  dimension: awalrevenue_share_c {
    view_label: "Funding"
    label: "AWAL Share"
    type: string
    sql: ${TABLE}.awalrevenue_share_c ;;
  }

  dimension_group: signed_date_c {
    view_label: "Dates"
    label: "Signed Date"
    type: time
    sql: ${TABLE}.signed_date_c ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date]
  }

  dimension_group: close_date {
    view_label: "Dates"
    label: "Est. Close Date"
    type: time
    sql: ${TABLE}.close_date ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date]
  }

  dimension_group: estimated_delivery_c {
    view_label: "Dates"
    label: "Est Delivery Date"
    type: time
    sql: ${TABLE}.estimated_delivery_c ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date]
  }

  dimension_group: EST_RELEASE_TIMING_DATE_ESTIMATE_C {
    view_label: "Dates"
    label: "Est Release Date"
    type: time
    sql: ${TABLE}.EST_RELEASE_TIMING_DATE_ESTIMATE_C ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date]
  }

  measure: ESTIMATED_REVENUE_3_YR_C {
    view_label: "Revenue"
    label: "3 Yr Est Revenue"
    type: sum
    sql: ${TABLE}.ESTIMATED_REVENUE_3_YR_C ;;
    value_format: "#,##0.00"
  }

  measure: ESTIMATED_REVENUE_3_YR_USD {
    view_label: "Revenue"
    label: "3 Yr Est Revenue_USD"
    type: sum
    sql: ${TABLE}.ESTIMATED_REVENUE_3_YR_C / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  measure: ESTIMATED_REVENUE_BASE_CASE_C {
    view_label: "Revenue"
    label: "Life of Deal Est Revenue"
    type: sum
    sql: ${TABLE}.ESTIMATED_REVENUE_BASE_CASE_C ;;
    value_format: "#,##0.00"
  }

  measure: estimated_revenue_base_case_USD {
    view_label: "Revenue"
    label: "Life of Deal Est Revenue USD"
    type: sum
    sql: ${TABLE}.ESTIMATED_REVENUE_BASE_CASE_C / ${TABLE}.exchange_rate_c;;
    value_format: "$#,##0.00"
  }

  dimension: uplift_creative_c {
    view_label: "Revenue"
    label: "Creative Uplift"
    type: string
    sql: ${TABLE}.uplift_creative_c ;;
  }

  dimension: UPLIFT_CREATIVE_ASSUMPTION_C {
    view_label: "Revenue"
    label: "Creative Uplift Assumption"
    type: string
    sql: ${TABLE}.UPLIFT_CREATIVE_ASSUMPTION_C ;;
  }

  dimension: IRR_C {
    view_label: "Revenue"
    label: "IRR"
    type: string
    sql: ${TABLE}.IRR_C ;;
  }

  dimension: TIME_TO_RECOUP_YRS_C {
    view_label: "Revenue"
    label: "Time to Recoup"
    type: string
    sql: ${TABLE}.TIME_TO_RECOUP_YRS_C ;;
  }

}