# View: int_dbt_prod_monthly_comparison_report_prod

**View Name:** int_dbt_prod_monthly_comparison_report_prod
**Table Source:** `intelligence.dbt_prod.monthly_comparison_report_prod`
**File Path:** `views/int_dbt_prod_monthly_comparison_report_prod.view.lkml`

## Overview

- **File Size:** 6650 bytes
- **Lines of Code:** 281
- **Dimensions:** 10
- **Measures:** 24
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `statement_period_id` | number |
| `run_controller_id` | number |
| `account_id` | number |
| `account_name` | string |
| `currency_code` | string |
| `contract_id` | number |
| `contract_name` | string |
| `contract_type` | string |
| `est_payable_diff_perc` | number |
| `change_falg` | string |

## Measures

| Name | Type |
|------|------|
| `opening_bal` | sum |
| `gross_revenue_payee_currency` | sum |
| `distribution_fee_payee_currency` | sum |
| `net_revenue_payee_currency` | sum |
| `applied_adjustments` | sum |
| `reserves_taken` | sum |
| `reserves_released` | sum |
| `payment` | sum |
| `payment_returned` | sum |
| `advance` | sum |
| `advance_return` | sum |
| `royalty_reversals` | sum |
| `royalty_corrections` | sum |
| `current_est_closing_bal` | sum |
| `previous_est_closing_bal` | sum |
| `est_payable_diff` | sum |
| `mechanical_deduction_admin_fee_total` | sum |
| `mechanical_deduction_total` | sum |
| `vat_amount_return` | sum |
| `wht_amount` | sum |
| `wht_amount_return` | sum |
| `vat_amount` | sum |
| `CUSTOM_PAYMENT` | sum |
| `Ledger_Balance` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `statement` | time |