# View: dt_contract_term_condition_denormalized_uat

**View Name:** dt_contract_term_condition_denormalized_uat
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Uat_Royalty_Accounting_Royalty_Accounting, Royalty_Accounting, Royalty_Accounting.Uat, Uat.Vw_Denorm_Contract_Term_Condition_Countries + 3 more`
**File Path:** `views/dt_contract_term_condition_denormalized_uat.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.uat_royalty_accounting_royalty_accounting.contract_term_condition ctc
      left join royalty_Accounting.uat.vw_denorm_contract_term_condition_transaction_types tt on tt.contract_term_condition_id = ctc.contract_term_condition_id
      left join royalty_Accounting.uat.vw_denorm_contract_term_condition_countries c on c.contract_term_condition_id = ctc.contract_term_condition_id
      left join royalty_Accounting.uat.vw_denorm_contract_term_condition_stores s on s.contract_term_condition_id = ctc.contract_term_condition_id
    ;;
```