# View: fact_sales

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

## Overview

- **File Size:** 19062 bytes
- **Lines of Code:** 837
- **Dimensions:** 45
- **Measures:** 27
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- measure: count {
- type: count
- drill_fields: [detail*]

## Dimensions

| Name | Type |
|------|------|
| `artistid` | number |
| `statement_detail_id` | number |
| `accountingperiodid` | number |
| `activityperiodid` | number |
| `labelid` | number |
| `storeid` | number |
| `genreid` | number |
| `releaseid` | number |
| `trackid` | number |
| `countryid` | number |
| `transactiontypeid` | number |
| `catalogid` | number |
| `isrcid` | number |
| `imprintid` | number |
| `gross_revenue_usd_int` | number |
| `unit_price` | number |
| `net_revenue_usd_int` | number |
| `split_rate` | number |
| `partner_share` | number |
| `retail_price` | number |
| `subaccountid` | number |
| `datecreated` | string |
| `original_currency_id` | number |
| `fx_spread_fee` | number |
| `payout_currency_id` | number |
| `activity_fx_rate` | number |
| `fx_adjusted_exchange_rate` | number |
| `fx_gross_revenue_dimension` | number |
| `fx_net_receipt_revenue_dimension` | number |
| `accountingyear` | number |
| `accountingquarter` | number |
| `accountingmonth` | number |
| `activityyear` | number |
| `activityquarter` | number |
| `activitymonth` | number |
| `original_price` | number |
| `discount` | number |
| `actual_price` | number |
| `release_months_since_release` | number |
| `label_months_prior_to_deletion` | number |
| `release_months_prior_to_deletion` | number |
| `label_local_transaction` | string |
| `normalize_release_months` | number |
| `sme_transaction_types` | string |
| `sme_affiliate_territory_groupings` | string |

## Measures

| Name | Type |
|------|------|
| `gross_revenue_usd` | sum |
| `units` | sum |
| `actual_price_calc` | sum |
| `actual_net_revenue_usd` | sum |
| `adjusted_gross_revenus_usd` | sum |
| `distribution_fees_usd` | sum |
| `dpd_publishing_usd` | sum |
| `net_revenue_usd` | sum |
| `orchard_gross_margin_usd` | sum |
| `oms_fees_usd` | sum |
| `ringtone_publishing_usd` | sum |
| `fx_gross_revenue` | sum |
| `fx_orchard_gross_marginr` | sum |
| `fx_actual_net_revenue` | sum |
| `fx_adjusted_gross_revenue` | sum |
| `fx_distribution_fees` | sum |
| `fx_dpd_publishing` | sum |
| `fx_net_revenue` | sum |
| `fx_net_revenue_minus_fees` | sum |
| `fx_oms_fees` | sum |
| `fx_ringtone_publishing` | sum |
| `cloud_publishing_usd` | sum |
| `fx_cloud_publishing` | sum |
| `original_price_measure` | sum |
| `discount_measure` | sum |
| `actual_price_measure` | sum |
| `fx_sum_publishing` | sum |