# View: dt_contracts_and_accounts_with_double_booking

**View Name:** dt_contracts_and_accounts_with_double_booking
**Table Source:** `Derived from: Prod.Vw_Abacus_Fact_Sales_Distro_V2, Royalty_Accounting, Royalty_Accounting.Prod`
**File Path:** `views/dt_contracts_and_accounts_with_double_booking.view.lkml`

## Overview

- **File Size:** 2039 bytes
- **Lines of Code:** 79
- **Dimensions:** 7
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `run_controller_id` | number |
| `account_id` | number |
| `contract_id` | number |
| `store_ids` | string |
| `transaction_types` | string |
| `transaction_count` | number |
| `gross_revenue_payee_currency` | number |

## Derived Table

```sql
sql:
    select
      run_controller_id,
      f.account_id,
      f.contract_id,
      listagg(distinct store_id,',') as store_ids,
      listagg(distinct transaction_type, ',') as transaction_types,
      count(*) as transaction_count,
      sum(f.gross_revenue_payee_currency) as gross_revenue_payee_currency
    from royalty_accounting.prod.vw_abacus_fact_sales_distro_v2 f
        join (SELECT
        unique_detail_id,
        count(*)
        FROM ROYALTY_ACCOUNTING.PROD.VW_ABACUS_FACT_SALES_DISTRO_V2  AS vw_abacus_fact_sales_distro
        WHERE  statement_period_id = {% parameter statement_period_id %
```