# View: royalty_accounting_qa_abacus_fact_sales_distro

**View Name:** royalty_accounting_qa_abacus_fact_sales_distro
**Table Source:** `ROYALTY_ACCOUNTING.QA.VW_ABACUS_FACT_SALES_DISTRO_V3`
**File Path:** `views/royalty_accounting_qa_abacus_fact_sales_distro.view.lkml`

## Overview

- **File Size:** 23701 bytes
- **Lines of Code:** 804
- **Dimensions:** 40
- **Measures:** 47
- **Dimension Groups:** 2
- **Filters:** 0

## Comments & Notes

- derived_table: {
- FROM royalty_accounting.qa.abacus_fact_sales_unified_dbt
- where record_type='abacus';;

## Dimensions

| Name | Type |
|------|------|
| `sales_file_id` | number |
| `batch_id` | string |
| `SH_Exchange_Rate` | number |
| `SH_Unit_Price_USD` | number |
| `statement_period_id` | number |
| `account_id` | number |
| `contract_id` | number |
| `account_payee_currency` | string |
| `sale_currency_code` | string |
| `accounting_period_id` | number |
| `country_id` | number |
| `ISRC` | string |
| `track_id` | number |
| `cd_id` | number |
| `store_id` | number |
| `video_id` | string |
| `UPC` | string |
| `statement_id` | number |
| `transaction_type` | string |
| `transaction_subtype` | string |
| `label_id` | number |
| `unique_detail_id` | number |
| `txn_id` | number |
| `accounting_run_id` | number |
| `accounting_run_name` | string |
| `royalty_rate` | number |
| `unit_price_sale_currency` | number |
| `unit_price_payee_currency` | number |
| `run_controller_id` | number |
| `contract_term_id` | number |
| `contract_term_condition_id` | number |
| `project_id` | number |
| `artist_id` | number |
| `track_unique_id` | number |
| `current_batch_id` | string |
| `new_allocation` | yesno |
| `activity_period_id` | number |
| `unit_price_sale_currency_fp` | number |
| `unit_price_payee_currency_fp` | number |
| `MECHANICAL_DEDUCTION_ADMIN_TYPE` | string |

## Measures

| Name | Type |
|------|------|
| `SH_Gross_Revenue_USD` | sum |
| `quantity` | sum |
| `phys_ppd_usd` | sum |
| `unique_detail_id_count_distinct` | count_distinct |
| `MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY` | sum |
| `MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY_usd` | sum |
| `PUBLISHER_ADMIN_FEE_SALE_CURRENCY` | sum |
| `PUBLISHER_ADMIN_FEE_SALE_CURRENCY_usd` | sum |
| `gross_revenue_sale_currency` | sum |
| `gross_revenue_sale_currency_usd` | sum |
| `withholding_tax_sale_currency` | sum |
| `withholding_tax_sale_currency_usd` | sum |
| `gross_revenue_after_withholding_tax_sale_currency` | sum |
| `gross_revenue_after_withholding_tax_sale_currency_usd` | sum |
| `net_share_sale_currency` | sum |
| `net_share_sale_currency_usd` | sum |
| `distribution_fee_sale_currency` | sum |
| `distribution_fee_sale_currency_usd` | sum |
| `distribution_fee_payee_currency` | sum |
| `MECHANICAL_DEDUCTION_AMOUNT_PAYEE_CURRENCY` | sum |
| `admin_fee_payee_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 |
| `MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY_fp` | sum |
| `MECHANICAL_DEDUCTION_AMOUNT_SALE_CURRENCY_usd_fp` | sum |
| `PUBLISHER_ADMIN_FEE_SALE_CURRENCY_fp` | sum |
| `PUBLISHER_ADMIN_FEE_SALE_CURRENCY_usd_fp` | sum |
| `gross_revenue_sale_currency_fp` | sum |
| `gross_revenue_sale_currency_usd_fp` | sum |
| `withholding_tax_sale_currency_fp` | sum |
| `withholding_tax_sale_currency_usd_fp` | sum |
| `gross_revenue_after_withholding_tax_sale_currency_fp` | sum |
| `gross_revenue_after_withholding_tax_sale_currency_usd_fp` | sum |
| `net_share_sale_currency_fp` | sum |
| `net_share_sale_currency_usd_fp` | sum |
| `distribution_fee_sale_currency_fp` | sum |
| `distribution_fee_sale_currency_usd_fp` | sum |
| `distribution_fee_payee_currency_fp` | sum |
| `MECHANICAL_DEDUCTION_AMOUNT_PAYEE_CURRENCY_fp` | sum |
| `gross_revenue_payee_currency_fp` | sum |
| `withholding_tax_payee_currency_fp` | sum |
| `gross_revenue_after_withholding_tax_Payee_currency_fp` | sum |
| `net_share_payee_currency_fp` | sum |
| `publisher_admin_fee_payee_currency` | sum |
| `mechanical_deduction_amount_payee_currency` | sum |

## Dimension Groups

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

## Derived Table

```sql
#   sql:
  #       SELECT *
  #       FROM royalty_accounting.qa.abacus_fact_sales_unified_dbt
  #       where record_type='abacus';;
  #
```