# View: int_dbt_prod_awal_groups_agr_recordings_model

**View Name:** int_dbt_prod_awal_groups_agr_recordings_model
**Table Source:** `AWAL.AWAL_FINANCE.AWAL_GROUP_AGR_RECORDINGS`
**File Path:** `int_dbt_prod_awal_groups_agr_recordings_model.view.lkml`

## Overview

- **File Size:** 3952 bytes
- **Lines of Code:** 216
- **Dimensions:** 33
- **Measures:** 9
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `AGREEMENT_ID` | string |
| `AGREEMENT_CURRENCY` | string |
| `DESCRIPTION_OF_RIGHTS` | string |
| `ACCOUNTING_PERIOD` | string |
| `TIER` | string |
| `LABEL_SERVICE_AGREEMENT_TYPE` | string |
| `CLIENT_IP_ID` | string |
| `CLIENT_CREATED_DATE` | date |
| `CLIENT_CRTD_FISCAL_Q` | string |
| `CLIENT_CRTD_FISCAL_Q_SONY` | string |
| `CLIENT_NAME` | string |
| `CLIENT_SEGMENT` | string |
| `ACQUIRER_ID` | string |
| `ACQUIRER_NAME` | string |
| `ARTIST_NAME` | string |
| `AGREEMENT_CREATED_DATE` | date |
| `AGREEMENT_SIGNED_DATE` | date |
| `AGR_SIGNED_CRTD_FISCAL_Q` | string |
| `AGR_SIGNED_CRTD_FISCAL_Q_SONY` | string |
| `AGREEMENT_MAX_END_DATE` | date |
| `SALESFORCE_OPPORTUNITY_ID` | string |
| `SALESFORCE_OPPORTUNITY_NAME` | string |
| `TERMINATED_DATE` | date |
| `PHYSICAL_YN` | string |
| `DIGITAL_YN` | string |
| `TRUE_FALSE` | string |
| `ADMINISTERED_BY` | string |
| `DEAL_MAKER` | string |
| `PRIMARY_OWNER` | string |
| `SECONDARY_OWNER` | string |
| `KLS_PRODUCT_MANAGER` | string |
| `CROSS_RECOUP_DETAILS` | string |
| `AVG_COMISSION_RATE` | number |

## Measures

| Name | Type |
|------|------|
| `PAID_ADVANCE` | sum |
| `CONTINGENT_ADVANCE` | sum |
| `MARKETING_FUND` | sum |
| `TOTAL_ADVANCES` | sum |
| `ADJUSTMENT` | sum |
| `TRANSFER` | sum |
| `MECH_PHY_SHARED_WHT` | sum |
| `OVERRIDE` | sum |
| `BALANCE` | sum |