# View: vendor_contract_snowflake_original

**View Name:** vendor_contract_snowflake_original
**Table Source:** `royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract`
**File Path:** `vendor_contract_snowflake_original.view.lkml`

## Overview

- **File Size:** 11739 bytes
- **Lines of Code:** 484
- **Dimensions:** 74
- **Measures:** 2
- **Dimension Groups:** 3
- **Filters:** 0

## Comments & Notes

- hidden: yes
- this is the same as sync_admin_commission except with percent formating
- hidden: yes

## Dimensions

| Name | Type |
|------|------|
| `parent_vendor_contract_id` | number |
| `service_type_id` | number |
| `reserve_rate` | number |
| `NUMBER_OF_MONTHS_BEFORE_PAYOUT` | number |
| `NUMBER_OF_INSTALLMENTS` | number |
| `CONTRACT_TERMS` | string |
| `advance_payment` | number |
| `advance_recoupable_percentage` | number |
| `apply_fx_spread` | string |
| `brand_split` | number |
| `can_terminate` | string |
| `carve_out` | string |
| `cont_version` | string |
| `contract_complete` | string |
| `contract_type` | string |
| `currency_id` | number |
| `dig_distribution_type` | string |
| `digital_split` | number |
| `dms_carve_out` | string |
| `dms_master_carve_out` | string |
| `encoding_fees_cap_back_ctlg` | number |
| `encoding_fees_cap_new_release` | number |
| `exclusive` | string |
| `extend_until_recouped` | string |
| `id` | number |
| `is_amendment` | string |
| `marketing_restrictions` | string |
| `negotiated_change_comments` | string |
| `negotiated_changes` | string |
| `notice_required_in_days` | number |
| `oms_fee_percentage` | number |
| `oms_type` | string |
| `opt_out` | string |
| `orchard_assignment_right_restriction` | string |
| `orchrep_name` | number |
| `other_rights_option` | string |
| `other_rights_text` | string |
| `pay_after` | string |
| `payment_interval` | string |
| `physical_split` | number |
| `physical_track_publishing_type` | string |
| `possible_track_restriction_detail` | string |
| `possible_track_restrictions` | string |
| `publishing_admin_commission` | number |
| `publishing_admin_limit_grant_of_rights` | string |
| `publishing_admin_misc_provisions` | string |
| `publishing_admin_territory` | string |
| `qualification_level` | string |
| `release_term` | number |
| `ringtone_publishing_type` | string |
| `rollover_length_in_months` | number |
| `royalty_collection_commission` | number |
| `royalty_collection_territory` | string |
| `is_performance_rights` | yesno |
| `show_credit_card` | string |
| `special_product_carve_out` | string |
| `special_product_split` | number |
| `sx_royalty_collection_commission` | number |
| `sync_admin_commission` | number |
| `sync_admin_commission_pct` | number |
| `sync_admin_response_time` | number |
| `sync_admin_territory` | string |
| `sync_admin_type_of_deal` | string |
| `term_continues_until_recouped` | string |
| `territory_carve_out` | string |
| `third_party_responsibility` | string |
| `third_party_responsibility_detail` | string |
| `topspin_rate` | number |
| `topspin_rate_territory` | string |
| `unlimited_roll` | string |
| `vendor_id` | number |
| `vendor_proposed_term_id` | number |
| `vendor_type` | string |
| `youtube_composition_clause` | string |

## Measures

| Name | Type |
|------|------|
| `count_vendor_id` | count_distinct |
| `count` | count |

## Dimension Groups

| Name | Type |
|------|------|
| `cont_end` | time |
| `cont_start` | time |
| `signature` | time |