# View: facts_prod_fact_sales

**View Name:** facts_prod_fact_sales
**Table Source:** `royalty_accounting.prod.workstation_fact_sales_unified_dbt`
**File Path:** `facts_prod_fact_sales.view.lkml`

## Overview

- **File Size:** 25643 bytes
- **Lines of Code:** 709
- **Dimensions:** 25
- **Measures:** 33
- **Dimension Groups:** 1
- **Filters:** 1

## Comments & Notes

- timeframes: [
- day_of_year
- Territory vs ROW fields

## Dimensions

| Name | Type |
|------|------|
| `statement_detail_id_accountingperiod_id` | number |
| `statement_detail_id` | number |
| `accounting_period_id` | number |
| `activity_period_id` | number |
| `release_months_since_release` | number |
| `store_id` | number |
| `country_id` | number |
| `is_local_revenue_label` | yesno |
| `is_local_revenue_artist` | yesno |
| `transaction_type_id` | number |
| `label_id` | number |
| `artist_id` | number |
| `release_id` | number |
| `track_id` | number |
| `genre_id` | number |
| `catalog_id` | number |
| `isrc_id` | number |
| `imprint_id` | number |
| `subaccount_id` | number |
| `original_currency_id` | number |
| `payout_currency_id` | number |
| `activity_fx_rate` | number |
| `fx_adjusted_exchange_rate` | number |
| `catalog_type` | string |
| `catalog_buckets` | string |

## Measures

| Name | Type |
|------|------|
| `units` | sum |
| `units_label_store_breakout` | sum |
| `units_breakdown_country_revenue_in_territory` | sum |
| `units_breakdown_country_revenue_not_in_territory` | sum |
| `consumption_units_track` | sum |
| `consumption_units_album` | sum |
| `gross_revenue_usd` | sum |
| `revenue_breakdown_country_revenue_in_territory` | sum |
| `revenue_breakdown_country_revenue_not_in_territory` | sum |
| `adjusted_gross_revenue_usd` | sum |
| `net_revenue_usd` | sum |
| `revenue_breakdown_country_net_revenue_in_territory` | sum |
| `revenue_breakdown_country_net_revenue_not_in_territory` | sum |
| `actual_net_usd` | sum |
| `gross_revenue_fx` | sum |
| `net_revenue_fx` | sum |
| `adjusted_gross_revenue_fx` | sum |
| `actual_net_fx` | sum |
| `dpd_publishing_USD` | sum |
| `cloud_publishing_USD` | sum |
| `oms_fees_USD` | sum |
| `ringtone_publishing_USD` | sum |
| `dpd_publishing_FX` | sum |
| `cloud_publishing_FX` | sum |
| `oms_fees_FX` | sum |
| `ringtone_publishing_FX` | sum |
| `publishing_fee_FX` | number |
| `publishing_fee_USD` | number |
| `FX_spread_fee` | sum |
| `distribution_fee` | sum |
| `fx_distribution_fee` | sum |
| `actual_price` | sum |
| `unit_price` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `Current` | time |

## Filters

- `include_territory_filter`