# View: dt_abacus_balance_report

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

## Overview

- **File Size:** 8521 bytes
- **Lines of Code:** 325
- **Dimensions:** 5
- **Measures:** 36
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

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

## 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 |
| `wht_amount` | sum |
| `vat_amount_return` | sum |
| `wht_amount_return` | sum |
| `payment` | sum |
| `payment_returned` | sum |
| `advance` | sum |
| `est_closing_bal` | sum |
| `ledger_bal` | sum |
| `delta` | sum |
| `payable_amount` | sum |
| `adj_wkt_est_closing_bal` | sum |
| `approved_adjustments` | sum |
| `not_approved_adjustments` | sum |
| `payable_amount_with_pending_adj` | sum |
| `payable_amount_approved_adj_only` | sum |
| `est_closing_bal_pending_adj_only` | sum |
| `est_closing_bal_approved_adj_only` | sum |
| `mechanical_deduction_admin_fee_total` | sum |
| `mechanical_deduction_total` | sum |
| `custom_payment` | sum |
| `projected_flowthrough_applied` | sum |
| `projected_flowthrough_approved` | sum |
| `projected_flowthrough_pending` | sum |
| `est_closing_bal_w_applied_ft` | sum |
| `est_closing_bal_w_approved_ft` | sum |
| `est_closing_bal_w_pending_ft` | sum |
| `custom_payment_returned` | sum |
| `previous_flowthrough_accrued` | sum |