# View: int_dbt_prod_abacus_fact_sales

**View Name:** int_dbt_prod_abacus_fact_sales
**Table Source:** `INTELLIGENCE.DBT_PROD.ABACUS_FACT_SALES`
**File Path:** `int_dbt_prod_abacus_fact_sales.view.lkml`

## Overview

- **File Size:** 4659 bytes
- **Lines of Code:** 214
- **Dimensions:** 14
- **Measures:** 17
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- #To be deprecated as this has been moved to abacus_looker project space

## Dimensions

| Name | Type |
|------|------|
| `txn_id` | number |
| `statement_id` | number |
| `account_id` | number |
| `account_payee_currency` | string |
| `sale_currency_code` | string |
| `accounting_period_id` | number |
| `country_id` | number |
| `store_id` | number |
| `isrc` | string |
| `upc` | number |
| `transaction_date` | date |
| `accounting_run_id` | number |
| `accounting_run_name` | string |
| `royalty_rate` | number |

## Measures

| Name | Type |
|------|------|
| `mechanical_fee_sale_currency` | sum |
| `ringtone_fee_sale_currency` | sum |
| `publishing_fee_sale_currency` | sum |
| `publishing_fee_payee_currency` | sum |
| `unit_price_sale_currency` | sum |
| `gross_revenue_sale_currency` | sum |
| `admin_fee_sale_currency` | sum |
| `adjusted_gross_sale_currency` | sum |
| `net_share_sale_currency` | sum |
| `adjusted_net_sale_currency` | sum |
| `readjusted_net_sale_currency` | sum |
| `unit_price_payee_currency` | sum |
| `gross_revenue_payee_currency` | sum |
| `adjusted_gross_payee_currency` | sum |
| `net_share_payee_currency` | sum |
| `adjusted_net_payee_currency` | sum |
| `readjusted_net_payee_currency` | sum |