# View: dt_contract_term_condition_denormalized

**View Name:** dt_contract_term_condition_denormalized
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Royalty_Accounting_Royalty_Accounting, Prod.Vw_Denorm_Contract_Term_Condition_Countries, Prod.Vw_Denorm_Contract_Term_Condition_Stores, Prod.Vw_Denorm_Contract_Term_Condition_Transaction_Types + 3 more`
**File Path:** `views/dt_contract_term_condition_denormalized.view.lkml`

## Overview

- **File Size:** 2083 bytes
- **Lines of Code:** 90
- **Dimensions:** 16
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `contract_term_condition_id` | number |
| `priority` | string |
| `contract_term_id` | number |
| `conditions` | string |
| `term_rate` | number |
| `contract_term_condition_name` | string |
| `created_by` | string |
| `created_at` | date_time |
| `last_modified_by` | string |
| `last_modified` | date_time |
| `deleted_by` | string |
| `deleted_at` | date_time |
| `store_id` | string |
| `country_code` | string |
| `country_id` | number |
| `transaction_type_id` | number |

## Derived Table

```sql
sql:
      select * from orchard_app_reporting_v2.prod_royalty_accounting_royalty_accounting.contract_term_condition ctc
      left join royalty_Accounting.prod.vw_denorm_contract_term_condition_transaction_types tt on tt.contract_term_condition_id = ctc.contract_term_condition_id
      left join royalty_Accounting.prod.vw_denorm_contract_term_condition_countries c on c.contract_term_condition_id = ctc.contract_term_condition_id
      left join royalty_Accounting.prod.vw_denorm_contract_term_condition_stores s on s.contract_term_condition_id = ctc.contract_term_condition_id
    ;;
```