# View: vw_abacus_fact_sales_nr

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

## Overview

- **File Size:** 8793 bytes
- **Lines of Code:** 340
- **Dimensions:** 21
- **Measures:** 12
- **Dimension Groups:** 2
- **Filters:** 0

## Comments & Notes

- USD Conversion

## Dimensions

| Name | Type |
|------|------|
| `statement_period_id` | number |
| `account_id` | number |
| `contract_id` | number |
| `contract_term_condition_id` | number |
| `account_payee_currency` | string |
| `sale_currency_code` | string |
| `accounting_period_id` | number |
| `ISRC` | string |
| `country_id` | number |
| `store_id` | number |
| `transaction_type` | string |
| `transaction_subtype_description` | string |
| `contributor_id` | string |
| `contributor_name` | string |
| `sound_recording_id` | string |
| `sound_recording_name` | string |
| `txn_id` | number |
| `accounting_run_id` | number |
| `royalty_rate` | number |
| `unit_price_sale_currency` | number |
| `unit_price_payee_currency` | number |

## Measures

| Name | Type |
|------|------|
| `gross_revenue_sale_currency` | sum |
| `withholding_tax_sale_currency` | sum |
| `gross_revenue_after_withholding_tax_sale_currency` | sum |
| `net_share_sale_currency` | sum |
| `gross_revenue_payee_currency` | sum |
| `withholding_tax_payee_currency` | sum |
| `gross_revenue_after_withholding_tax_Payee_currency` | sum |
| `net_share_payee_currency` | sum |
| `gross_revenue_usd_currency` | sum |
| `withholding_tax_usd_currency` | sum |
| `gross_revenue_after_withholding_tax_usd_currency` | sum |
| `net_share_usd_currency` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `start_date` | time |
| `end_date` | time |