# View: int_dbt_prod_awal_agr_nr_model

**View Name:** int_dbt_prod_awal_agr_nr_model
**Table Source:** `AWAL.AWAL_FINANCE.AWAL_GROUP_AGR_NR`
**File Path:** `int_dbt_prod_awal_agr_nr_model.view.lkml`

## Overview

- **File Size:** 4522 bytes
- **Lines of Code:** 236
- **Dimensions:** 22
- **Measures:** 8
- **Dimension Groups:** 3
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `agreement_id` | string |
| `description_of_rights` | string |
| `agreement_currency` | string |
| `accounting_period` | string |
| `client_ip_id` | number |
| `client_created_quarter` | date |
| `client_name` | string |
| `acquirer_id` | string |
| `acquirer_name` | string |
| `artist_name` | string |
| `agreement_created_quarter` | date |
| `agreement_max_end_date` | date |
| `salesforce_opportunity_id` | string |
| `salesforce_opportunity_name` | string |
| `Physical` | string |
| `true_false` | number |
| `administered_by` | string |
| `deal_maker` | string |
| `primary_owner` | string |
| `secondary_owner` | string |
| `kls_product_manager` | string |
| `cross_recoup_details` | string |

## Measures

| Name | Type |
|------|------|
| `advance` | sum |
| `marketing_fund` | sum |
| `total_advance` | sum |
| `adjustment` | sum |
| `mech_phy_shared_wht` | sum |
| `override` | sum |
| `balance` | sum |
| `avg_commission_rate` | average |

## Dimension Groups

| Name | Type |
|------|------|
| `client_created_date` | time |
| `agreement_created_date` | time |
| `agreement_signed_date` | time |

