# View: dt_mechanical_clients

**View Name:** dt_mechanical_clients
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_MECHANICAL_CLIENTS`
**File Path:** `dt_mechanical_clients.view.lkml`

## Overview

- **File Size:** 653 bytes
- **Lines of Code:** 25
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: select vc.vendor_id, oms_type, cont_start
- from royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract vc

## Dimensions

| Name | Type |
|------|------|
| `vendor_id` | number |
| `mechanical_client` | yesno |

## Derived Table

```sql
#     sql: select vc.vendor_id, oms_type, cont_start
# from royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract vc
# inner join intelligence.dbt_prod.active_vendor_contracts avc on avc.vendor_contract_id = vc.id
# group by 1,2,3 ;;
#
```