# View: royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period

**View Name:** royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period
**Table Source:** `ROYALTY_ACCOUNTING_REPORTING.PROD.VW_ABACUS_UNALLOCATED_SALES_NR_STATEMENT_PERIOD`
**File Path:** `views/royalty_accounting_prod_vw_abacus_unallocated_sales_nr_statement_period.view.lkml`

## Overview

- **File Size:** 4580 bytes
- **Lines of Code:** 189
- **Dimensions:** 20
- **Measures:** 3
- **Dimension Groups:** 2
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `STATEMENT_PERIOD_ID` | number |
| `UNIQUE_DETAIL_ID` | number |
| `SALES_FILES_BATCH_ID_LIST` | string |
| `ACCOUNTING_PERIOD_LIST` | string |
| `NEW_UNALLOCATION` | yesno |
| `EARLIEST_STMT_DB_SALES_NR_TXN_ID` | number |
| `EARLIEST_SALES_FILE_ID` | number |
| `EARLIEST_BATCH_ID` | string |
| `STATEMENT_ID` | number |
| `STORE_ID` | number |
| `SUBDISTRIBUTOR` | string |
| `SALE_CURRENCY_CODE` | string |
| `SALE_CURRENCY_CODE_ID` | number |
| `SALE_ACTIVITY_RATE` | number |
| `COUNTRY_ID` | number |
| `TRANSACTION_TYPE` | string |
| `TRANSACTION_TYPE_ID` | number |
| `TRANSACTION_SUBTYPE_ID` | number |
| `ISRC` | string |
| `UNIT_PRICE_USD` | number |

## Measures

| Name | Type |
|------|------|
| `QUANTITY` | sum |
| `GROSS_REVENUE_USD` | sum |
| `WITHHOLDING_TAX_USD` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `START_DATE` | time |
| `TRANSACTION_DATE` | time |