# View: awal_awal_finance_fpa_pr_revenue

**View Name:** awal_awal_finance_fpa_pr_revenue
**Table Source:** `AWAL.AWAL_FINANCE.FPA_PR_AWAL`
**File Path:** `awal_awal_finance_fpa_pr_revenue.view.lkml`

## Overview

- **File Size:** 10710 bytes
- **Lines of Code:** 395
- **Dimensions:** 41
- **Measures:** 17
- **Dimension Groups:** 2
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `awal_client_segment` | string |
| `awal_client_tier` | string |
| `label_service_agreement_type` | string |
| `agreement_id` | string |
| `agreement_is_novated` | string |
| `recrd_artist_name` | string |
| `artist_name` | string |
| `fund_or_not` | string |
| `client_rights` | string |
| `agreement_is_terminated` | string |
| `agreement_terminated_date` | date |
| `outgoing_agreement_type` | string |
| `acquirer_id` | string |
| `acquirer` | string |
| `assignor_id` | string |
| `assignor` | string |
| `client_ip_type` | string |
| `stat_year` | date |
| `stat_q_date` | date |
| `stat_q` | string |
| `stat_month` | string |
| `stat_month_FY` | string |
| `bankreceipt_cur` | string |
| `royalty_adjustment_payment` | number |
| `salesforce_opportunity_id` | string |
| `salesforce_opportunity_name` | string |
| `fund_group_name` | string |
| `rt_desc` | string |
| `rt_id` | string |
| `rt_type_code` | string |
| `rt_reporting` | string |
| `rt_groups` | string |
| `territory_desc` | string |
| `territory_id` | string |
| `source_id` | string |
| `source_name` | string |
| `source_name_group` | string |
| `source_name_group_other` | string |
| `territory_desc_group` | string |
| `revenue_source_name` | string |
| `revenue_source_id` | string |

## Measures

| Name | Type |
|------|------|
| `USDHIST_SOURCE` | sum |
| `USDHIST_RCVD` | sum |
| `USDHIST_REVENUE` | sum |
| `USDHIST_REVENUE_C` | sum |
| `USDHIST_CLIENT` | sum |
| `USDHIST_CLIENT_C` | sum |
| `USDHIST_MARGIN` | sum |
| `USDHIST_DIR_COLL_FEE` | sum |
| `awal_perc` | number |
| `ACCTCUR_SOURCE` | sum |
| `ACCTCUR_RECEIVED` | sum |
| `ACCTCUR_REVENUE` | sum |
| `ACCTCUR_REVENUE_C` | sum |
| `ACCTCUR_CLIENT` | sum |
| `ACCTCUR_CLIENT_C` | sum |
| `ACCTCUR_MARGIN` | sum |
| `ACCTCUR_DIR_COLL_FEE` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `stat_mnth_date` | time |
| `agreement_signed_date` | time |

