# View: orch_app_prod_royalty_accounting_contract_mechanical_deduction

**View Name:** orch_app_prod_royalty_accounting_contract_mechanical_deduction
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Accounting_Royalty_Accounting, Prod_Royalty_Accounting_Royalty_Accounting.Contract_Mechanical_Deduction`
**File Path:** `views/orch_app_prod_royalty_accounting_contract_mechanical_deduction.view.lkml`

## Overview

- **File Size:** 1322 bytes
- **Lines of Code:** 68
- **Dimensions:** 12
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `contract_mechanical_deduction_id` | string |
| `contract_id` | string |
| `territory` | string |
| `mechanical_type` | string |
| `admin_type` | string |
| `admin_fee` | string |
| `created_at` | date_time |
| `last_modified_at` | date_time |
| `last_modified_by` | string |
| `created_by` | string |
| `deleted_by` | string |
| `deleted_at` | date_time |

## Derived Table

```sql
sql:
    select *
    from  orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract_mechanical_deduction
    WHERE deleted_at is NULL and deleted_by is NULL;;
```