# View: orch_app_qa_royalty_accounting_contract_reserve

**View Name:** orch_app_qa_royalty_accounting_contract_reserve
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Qa_Royalty_Accounting_Royalty_Accounting, Qa_Royalty_Accounting_Royalty_Accounting.Contract_Reserve`
**File Path:** `views/orch_app_qa_royalty_accounting_contract_reserve.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `contract_reserve_id` | number |
| `installments_in_months` | string |
| `reserve_release_offset_in_months` | string |
| `created_at` | date_time |
| `last_modified` | date_time |
| `contract_id` | number |
| `deleted_by` | string |
| `last_modified_by` | string |
| `reserve_rate` | string |
| `release_schedule` | number |
| `created_by` | string |
| `deleted_at` | date_time |

## Derived Table

```sql
sql:
      select
          created_at,
          contract_id,
          contract_reserve_id,
          installments_in_months,
          reserve_release_offset_in_months,
          created_by,
          last_modified_by,
          last_modified,
          reserve_rate,
          release_schedule,
          _fivetran_deleted,
          _fivetran_synced,
          deleted_by,
          deleted_at
      from
          orchard_app_reporting_v2.qa_royalty_accounting_royalty_accounting.contract_reserve
      where
          deleted_at is null
          and deleted_by is null;;
```