# View: dt_abacus_us_mech_deduction_by_contract_qa

**View Name:** dt_abacus_us_mech_deduction_by_contract_qa
**Table Source:** `Derived from: Qa.Accounting_Run_Results_Distro_Mech, Qa.Contract_Transaction_Distro, Qa.Snapshot_Contract_Mechanical_Deduction, Qa.Snapshot_Mechanical_Transaction, Royalty_Accounting + 1 more`
**File Path:** `views/dt_abacus_us_mech_deduction_by_contract_qa.view.lkml`

## Overview

- **File Size:** 3086 bytes
- **Lines of Code:** 93
- **Dimensions:** 7
- **Measures:** 4
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `contract_id` | string |
| `accounting_run_id` | string |
| `statement_period_id` | string |
| `mechanical_type` | string |
| `admin_type` | string |
| `admin_fee` | string |
| `territory` | string |

## Measures

| Name | Type |
|------|------|
| `mechanical_deduction_label_share_payee_currency` | sum |
| `mechanical_deduction_admin_fee_total` | sum |
| `mechanical_royalty_amount_payee_currency` | sum |
| `mechanical_business_share_payee_currency` | sum |

## Derived Table

```sql
sql:
      SELECT
          cmd.contract_id,
          cmd.accounting_run_id,
          mtxn.statement_period_id,
          cmd.mechanical_type,
          cmd.admin_type,
          cmd.admin_fee,
          cmd.territory,
          sum(arrm.mechanical_deduction_amount_payee_currency) as mechanical_deduction_label_share_payee_currency,
          sum(arrm.mechanical_royalty_amount_payee_currency) AS mechanical_royalty_amount_payee_currency,
          sum(arrm.mechanical_royalty_amount_payee_currency) - sum(arrm.mechanical_deduction_amount_payee_currency) AS mechanical_business_share_payee_currency,
          SUM(
              IFNULL(arrm.PUBLISHER_ADMIN_FEE_PAYEE_CURRENCY, 0)
          ) AS mechanical_deduction_admin_fee_total
      FROM
          ROYALTY_ACCOUNTING.QA.ACCOUNTING_RUN_RESULTS_DISTRO_MECH AS arrm
          INNER JOIN ROYALTY_ACCOUNTING.QA.CONTRACT_TRANSACTION_DISTRO AS ctd ON arrm.CONTRACT_TXN_ID = ctd.CONTRACT_TXN_ID
          INNER JOIN ROYALTY_ACCOUNTING.QA.SNAPSHOT_CONTRACT_MECHANICAL_DEDUCTION AS cmd ON ctd.CONTRACT_ID = cmd.CONTRACT_ID
          AND ctd.accounting_run_id = cmd.ACCOUNTING_RUN_ID
          AND arrm.contract_mechanical_deduction_id=cmd.contract_mechanical_deduction_id
          INNER JOIN ROYALTY_ACCOUNTING.QA.SNAPSHOT_MECHANICAL_TRANSACTION AS mtxn ON arrm.MECHANICAL_TRANSACTION_ID = mtxn.MECHANICAL_TRANSACTION_ID
      WHERE cmd.territory = 'USA'
      GROUP BY 1,2,3,4,5,6,7;;
```