# View: dt_abacus_royaltyshare_mechanical_deduction

**View Name:** dt_abacus_royaltyshare_mechanical_deduction
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Accounting_Royalty_Accounting, Prod.Abacus_Fact_Sales_Unified_Dbt, Prod.Currency_Exchange_Rates, Prod_Royalty_Accounting_Royalty_Accounting.Contract_Mechanical_Deduction + 2 more`
**File Path:** `views/dt_abacus_royaltyshare_mechanical_deduction.view.lkml`

## Overview

- **File Size:** 3554 bytes
- **Lines of Code:** 152
- **Dimensions:** 22
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `accounting_period_id` | string |
| `statement_period_id` | string |
| `store_id` | string |
| `mechanical_type` | string |
| `territory` | string |
| `account_id` | string |
| `transaction_date` | date_time |
| `transaction_type` | string |
| `contract_id` | string |
| `sale_currency_code` | string |
| `upc` | string |
| `artist_id` | string |
| `quantity` | string |
| `batch_id` | string |
| `country_id` | string |
| `isrc` | string |
| `unit_price_usd` | string |
| `unit_price_sale_currency` | string |
| `contract_mechanical_deduction_id` | number |
| `phys_ppd_gbp` | string |
| `unique_detail_id` | string |
| `txn_id` | string |

## Derived Table

```sql
sql:
        select
            dist.accounting_period_id,
            dist.store_id,
            dist.sale_currency_code,
            dist.transaction_date,
            dist.transaction_type,
            dist.account_id,
            dist.contract_id,
            dist.artist_id,
            dist.upc,
            dist.quantity,
            dist.batch_id,
            dist.country_id,
            dist.isrc,
            dist.unit_price_usd,
            dist.unit_price_sale_currency,
            dist.statement_period_id,
            cmd.contract_mechanical_deduction_id,
            cmd.territory,
            cmd.mechanical_type,
            dist.unique_detail_id,
            dist.txn_id,
            phys_ppd_usd * cer.exchange_rate as phys_ppd_gbp
        from
            royalty_accounting.prod.abacus_fact_sales_unified_dbt dist
            JOIN orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract_mechanical_deduction cmd on cmd.contract_id = dist.contract_id
            LEFT JOIN facts.prod.currency_exchange_rates cer ON cer.period_id = dist.statement_period_id
            and currency_from_id = 170
            and currency_to_id = 50
        WHERE
            territory in ('ROW', 'CAN')
            and transaction_type IN ('PS', 'OP', 'TP', 'RE', 'OR', 'TR')
            and cmd.deleted_at is NULL and cmd.deleted_by is NULL;;
```