# View: dt_revenue_by_contract

**View Name:** dt_revenue_by_contract
**Table Source:** `royalty_accounting_reporting.prod.vw_abacus_balances_looker_v2`
**File Path:** `views/dt_revenue_by_contract.view.lkml`

## Overview

- **File Size:** 4447 bytes
- **Lines of Code:** 189
- **Dimensions:** 7
- **Measures:** 17
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `statement_period_id` | number |
| `account_id` | number |
| `account_name` | string |
| `contract_id` | number |
| `contract_name` | string |
| `account_payee_currency` | string |
| `run_controller_id` | number |

## Measures

| Name | Type |
|------|------|
| `opening_bal` | sum |
| `gross_revenue` | sum |
| `dist_fee` | sum |
| `net_revenue` | sum |
| `applied_adjustments` | sum |
| `reserves_taken` | sum |
| `reserves_released` | sum |
| `vat_amount` | sum |
| `payment` | sum |
| `payment_returned` | sum |
| `advance` | sum |
| `est_closing_bal` | sum |
| `ledger_bal` | sum |
| `delta` | sum |
| `payable_amount` | sum |
| `mechanical_deduction_admin_fee_total` | sum |
| `mechanical_deduction_total` | sum |