# View: royalty_accounting_uat_vw_dim_abacus_contract

**View Name:** royalty_accounting_uat_vw_dim_abacus_contract
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Uat_Royalty_Accounting_Royalty_Accounting, Royalty_Accounting, Royalty_Accounting.Uat, Uat.Vw_Dim_Abacus_Contract + 1 more`
**File Path:** `views/royalty_accounting_uat_vw_dim_abacus_contract.view.lkml`

## Overview

- **File Size:** 6004 bytes
- **Lines of Code:** 292
- **Dimensions:** 43
- **Measures:** 0
- **Dimension Groups:** 2
- **Filters:** 0

## Comments & Notes

- hidden: yes
- hidden: yes

## Dimensions

| Name | Type |
|------|------|
| `contract_id` | number |
| `reference_sap_profit_center_id` | number |
| `contract_name` | string |
| `contract_type` | string |
| `run_controller_id` | number |
| `run_controller_name` | string |
| `is_primary_for_calc` | yesno |
| `company_code` | string |
| `profit_center` | string |
| `signing_entity_legal_name` | string |
| `company_registration_number` | string |
| `signing_entity_address` | string |
| `signing_entity_vat_number` | number |
| `sax_agreement_id` | string |
| `account_id` | number |
| `business_group` | string |
| `current_balance` | number |
| `abacus_contract_url` | string |
| `general_note` | string |
| `summary_note` | string |
| `created_by` | string |
| `created_at` | date_time |
| `last_modified_by` | string |
| `last_modified` | date_time |
| `usa_mech_rights` | string |
| `usa_mech_type` | string |
| `usa_mech_admin_type` | string |
| `usa_mech_admin_fee` | string |
| `can_mech_rights` | string |
| `can_mech_type` | string |
| `can_mech_admin_type` | string |
| `can_mech_admin_fee` | string |
| `row_mech_rights` | string |
| `row_mech_type` | string |
| `row_mech_admin_type` | string |
| `row_mech_admin_fee` | string |
| `is_excluded_from_accounting_run` | string |
| `contract_flowthrough_id` | string |
| `reference_flowthrough_calculation_id` | string |
| `flowthrough_rate` | string |
| `flowthrough_status` | string |
| `recoupment_cap` | string |
| `has_automatic_shutoff` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `term_start` | time |
| `term_end` | time |

## Derived Table

```sql
sql:
      select
          dac.*,
          lifecycle_term_end,
          lifecycle_term_start
      from
          ROYALTY_ACCOUNTING.UAT.VW_DIM_ABACUS_CONTRACT dac
          left join ORCHARD_APP_REPORTING_V2.UAT_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING.CONTRACT_LIFECYCLE cl ON cl.contract_id = dac.contract_id
      where
          cl.deleted_at is null;;
```