# View: awal_sax_salesforce_opportunities

**View Name:** awal_sax_salesforce_opportunities
**Table Source:** `AWAL_SAX.SALESFORCE.OPPORTUNITY`
**File Path:** `awal_sax_salesforce_opportunities.view.lkml`

## Overview

- **File Size:** 14003 bytes
- **Lines of Code:** 508
- **Dimensions:** 49
- **Measures:** 13
- **Dimension Groups:** 3
- **Filters:** 0

## Comments & Notes

- description: "Expected Advance Range"
- description: "Expected Advance Range"
- description: "Expected Advance Range"

## Dimensions

| Name | Type |
|------|------|
| `ID` | string |
| `ACCOUNTID` | string |
| `Name` | string |
| `Stage_Name` | string |
| `ADVANCE_COMMENT__C` | string |
| `ADVANCE_RANGE__C` | string |
| `ADVANCE_STRUCTURE__C` | string |
| `ARTIST_ETHNICITY_RACE__C` | string |
| `ARTIST_GENDER__C` | string |
| `ARTIST_CLIENT_LOCATION__C` | string |
| `RECORDINGS_SERVICE_TYPE__C` | string |
| `OPPORTUNITY_ID__C` | string |
| `BA_PROCESS_STATUS__C` | string |
| `CATALOG_SIZE__C` | string |
| `DEAL_CURRENCY__C` | string |
| `DEAL_ID__C` | string |
| `FINAL_BASE_CASE_IRR__C` | number |
| `HEADLINE_RATE_DIGITAL__C` | number |
| `HEADLINE_RATE_PHYSICAL__C` | number |
| `OPPORTUNITY_TYPE__C` | string |
| `MARKETING_FUND_ADMINISTRATION__C` | string |
| `MARKETING_FUND_CATEGORIES_OF_EXPENDITURE__C` | string |
| `MARKETING_FUND_PAYMENT_INSTRUCTIONS__C` | string |
| `MARKETING_FUND_PAYMENT__C` | string |
| `MARKETING_FUND__C` | string |
| `OTHER_ADVANCES__C` | string |
| `OTHER_RECOUPABLE_COSTS_DETAILS__C` | string |
| `PRIMARY_EVALUATOR__C` | string |
| `PRIMARY_GENRE__C` | string |
| `TERM_IN_YEARS__C` | string |
| `TERM_YRS__C` | string |
| `DIGITAL_RATE__C` | string |
| `AGREEMENT_TYPE__C` | string |
| `DEAL_BROKER__C` | string |
| `BA_PROCESS_STATUS_REPORTING__C` | string |
| `EXTERNALID__C` | string |
| `RELATED_OPPORTUNITY_IDS__C` | string |
| `DEAL_LAWYER__C` | string |
| `PHYSICAL_Y_N__C` | string |
| `OPTION_Y_N__C` | string |
| `INCLUDES_OPTION_S__C` | string |
| `KOBALT_HEADLINE_POST_RECOUPMENT_RATE_3__C` | number |
| `KOBALT_HEADLINE_POST_RECOUPMENT_RATE_T__C` | number |
| `KOBALT_HEADLINE_POST_RECOUPMENT_RATE_H__C` | number |
| `KOBALT_HEADLINE_PRE_RECOUPMENT_RATE_HO__C` | number |
| `KOBALT_HEADLINE_PRE_RECOUPMENT_RATE_T2__C` | number |
| `BA_AGENDA_TYPE__C` | string |
| `DEAL_TYPE_MASTERS__C` | string |
| `DEAL_TYPE_NR__C` | string |

## Measures

| Name | Type |
|------|------|
| `ADV_OFFER_C` | sum |
| `ADVANCE_AMOUNT__C` | sum |
| `ADVANCE_ON_DELIVERY__C` | sum |
| `EST_FIRST_YEAR_REV_NR__C` | sum |
| `EST_TERM_REV_BASE_CASE__C` | sum |
| `EST_TERM_REV_NR__C` | sum |
| `ESTIMATED_REVENUE_BASE_CASE__C` | sum |
| `ESTIMATED_REVENUE_HIGH_CASE_USD__C` | sum |
| `ESTIMATED_REVENUE_LOW_CASE_USD__C` | sum |
| `THREE_YEAR_NPS__C` | sum |
| `THREE_YEAR_REVENUE__C` | sum |
| `FINAL_MARKETING_FUND__C` | sum |
| `LEGAL_FEES_CONTRIBUTION_BA__C` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `close_date` | time |
| `ACTUAL_CLOSE_DATE__C` | time |
| `last_modified_date` | time |