# View: KNR_Ownership_Run_CheckSums

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

## Overview

- **File Size:** 645 bytes
- **Lines of Code:** 34
- **Dimensions:** 2
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Batch_ID` | string |
| `Row_Count` | string |

## Measures

| Name | Type |
|------|------|
| `Total_USD` | sum |
| `ABACUS_Total` | sum |

## Derived Table

```sql
sql:

 select batch_id,
count(*) count,
sum(total_usd) Total_USD,
sum(quantity * unit_price_usd) ABACUS_Total
from ROYALTY_ACCOUNTING.PROD.STMT_DB_SALES_DISTRO_STAGING
group by batch_id
    ;;
```