# View: int_dbt_prod_monthly_comparison_report

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

## Overview

- **File Size:** 6802 bytes
- **Lines of Code:** 265
- **Dimensions:** 13
- **Measures:** 19
- **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 |
| `accounting_run_id` | number |
| `contract_id` | number |
| `contract_name` | string |
| `contract_type` | string |
| `accounting_run_status` | string |
| `gross_rev_change_flag` | string |
| `storename` | string |
| `transaction_description` | string |

## Measures

| Name | Type |
|------|------|
| `opening_bal` | sum |
| `gross_revenue_payee_currency` | sum |
| `distribution_fee_payee_currency` | sum |
| `net_revenue_payee_currency` | sum |
| `applied_adjustments_adjustment_amount` | sum |
| `reserve_taken` | sum |
| `reserve_released` | sum |
| `est_payable_client_revenue` | sum |
| `previous_month_net_revenue` | sum |
| `previous_month_gross_revenue` | sum |
| `mechanical_deduction_admin_fee_total` | sum |
| `mechanical_deduction_total` | sum |
| `gross_rev_diff` | sum |
| `net_rev_diff` | sum |
| `gross_rev_diff_perc` | sum |
| `gross_diff_store` | sum |
| `gross_diff_trans` | sum |
| `store_contribution_to_change` | sum |
| `trans_contribution_to_change` | sum |

## Dimension Groups

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