# View: royalty_prod_stmt_db_sales_distro

**View Name:** royalty_prod_stmt_db_sales_distro
**Table Source:** `ROYALTY_ACCOUNTING.PROD.STMT_DB_SALES_DISTRO`
**File Path:** `views/royalty_prod_stmt_db_sales_distro.view.lkml`

## Overview

- **File Size:** 3103 bytes
- **Lines of Code:** 175
- **Dimensions:** 25
- **Measures:** 7
- **Dimension Groups:** 2
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `txn_id` | number |
| `unique_detail_id` | number |
| `sales_file_id` | number |
| `batch_id` | string |
| `statement_id` | number |
| `store_id` | number |
| `subdistributor` | string |
| `sale_currency_code` | string |
| `sale_currency_code_id` | number |
| `activity_rate` | number |
| `country_id` | number |
| `configuration` | string |
| `transaction_type` | string |
| `transaction_type_id` | number |
| `transaction_subtype_id` | number |
| `label_id` | number |
| `upc` | number |
| `cd` | number |
| `track_id` | number |
| `isrc` | string |
| `track_name` | string |
| `video_id` | string |
| `quantity` | number |
| `is_excluded_from_sap` | yesno |
| `actual_statement_number` | string |

## Measures

| Name | Type |
|------|------|
| `unit_price_usd` | sum |
| `total_usd` | sum |
| `withholding_tax_usd` | sum |
| `retail_price_usd` | sum |
| `original_price_usd` | sum |
| `discount_usd` | sum |
| `phys_ppd_usd` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `start_date` | time |
| `transaction_date` | time |