# View: dt_double_booked_transactions

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

## Overview

- **File Size:** 1250 bytes
- **Lines of Code:** 50
- **Dimensions:** 4
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `unique_detail_id` | number |
| `account_ids` | string |
| `contract_ids` | string |
| `number_of_transactions` | number |

## Derived Table

```sql
sql:
      SELECT
          unique_detail_id,
          listagg(account_id, ',') as account_ids,
          listagg(contract_id, ',') as contract_ids,
          count(*) as number_of_transactions
      FROM ROYALTY_ACCOUNTING.PROD.VW_ABACUS_FACT_SALES_DISTRO_V2  AS vw_abacus_fact_sales_distro
      WHERE  statement_period_id = {% parameter statement_period_id %
```