# View: vendor_contract_snowflake

**View Name:** vendor_contract_snowflake
**Table Source:** `Derived from: Prod.Vw_Dim_Abacus_Ar_Vendor_Contract, Royalty_Accounting_Reporting, Royalty_Accounting_Reporting.Prod`
**File Path:** `vendor_contract_snowflake.view.lkml`

## Overview

- **File Size:** 12370 bytes
- **Lines of Code:** 471
- **Dimensions:** 72
- **Measures:** 2
- **Dimension Groups:** 3
- **Filters:** 0

## Comments & Notes

- FANNED OUT ON TERRITORY CARVE-OUTS
- hidden: yes
- hidden: yes

## Dimensions

| Name | Type |
|------|------|
| `parent_vendor_contract_id` | number |
| `advance_payment` | number |
| `number_of_months_before_payout` | string |
| `number_of_installments` | string |
| `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 |
| `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 |
| `RESERVE_RATE` | string |
| `rollover_length_in_months` | number |
| `royalty_collection_commission` | number |
| `royalty_collection_territory` | string |
| `show_credit_card` | string |
| `special_product_carve_out` | string |
| `special_product_split` | number |
| `sx_royalty_collection_commission` | number |
| `sync_admin_commission` | string |
| `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 |
| `physical_track_publishing_type` | string |
| `CONTRACT_TERMS` | string |
| `collections_eligible` | yesno |

## Measures

| Name | Type |
|------|------|
| `count_labels` | count_distinct |
| `count` | count |

## Dimension Groups

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

## Derived Table

```sql
sql:  select
    vc.ID,  vc.VENDOR_ID, vc.CONT_START,  vc.lifecycle_term_end,  vc.CONT_VERSION,  vc.EXCLUSIVE, vc.ORCHREP_NAME,  vc.CARVE_OUT, vc.QUALIFICATION_LEVEL, vc.DMS_CARVE_OUT, vc.DMS_MASTER_CARVE_OUT,  vc.ENCODING_FEES_CAP_BACK_CTLG, vc.ENCODING_FEES_CAP_NEW_RELEASE, vc.DIGITAL_SPLIT, vc.PHYSICAL_SPLIT,  vc.CONTRACT_TYPE, vc.RELEASE_TERM,  vc.ADVANCE_PAYMENT, vc.ADVANCE_RECOUPABLE_PERCENTAGE, vc.DIG_DISTRIBUTION_TYPE, vc.POSSIBLE_TRACK_RESTRICTIONS, vc.OMS_TYPE,  vc.OMS_FEE_PERCENTAGE,  vc.NEGOTIATED_CHANGES,  vc.NEGOTIATED_CHANGE_COMMENTS,  vc.CONTRACT_COMPLETE, vc.SIGNATURE_DATE,  vc.MARKETING_RESTRICTIONS,  vc.ORCHARD_ASSIGNMENT_RIGHT_RESTRICTION,  vc.CURRENCY_ID, vc.THIRD_PARTY_RESPONSIBILITY,  vc.THIRD_PARTY_RESPONSIBILITY_DETAIL, vc.POSSIBLE_TRACK_RESTRICTION_DETAIL, vc.IS_AMENDMENT,  vc.EXTEND_UNTIL_RECOUPED, vc.SYNC_ADMIN_TERRITORY,  vc.SYNC_ADMIN_COMMISSION, vc.SYNC_ADMIN_TYPE_OF_DEAL, vc.ROYALTY_COLLECTION_TERRITORY,  vc.ROYALTY_COLLECTION_COMMISSION, vc.PUBLISHING_ADMIN_COMMISSION, vc.PUBLISHING_ADMIN_TERRITORY,  vc.PUBLISHING_ADMIN_LIMIT_GRANT_OF_RIGHTS,  vc.PUBLISHING_ADMIN_MISC_PROVISIONS,  vc.PARENT_VENDOR_CONTRACT_ID, vc.VENDOR_TYPE, vc.VENDOR_PROPOSED_TERM_ID, vc.SYNC_ADMIN_RESPONSE_TIME,  vc.RINGTONE_PUBLISHING_TYPE,  vc.PHYSICAL_TRACK_PUBLISHING_TYPE,  vc.UNLIMITED_ROLL,  vc.ROLLOVER_LENGTH_IN_MONTHS, vc.CAN_TERMINATE, vc.YOUTUBE_COMPOSITION_CLAUSE,  vc.SX_ROYALTY_COLLECTION_COMMISSION,  vc.TOPSPIN_RATE,  vc.TOPSPIN_RATE_TERRITORY,  vc.NOTICE_REQUIRED_IN_DAYS, vc.TERM_CONTINUES_UNTIL_RECOUPED, vc.BRAND_SPLIT, vc.OTHER_RIGHTS_OPTION, vc.OTHER_RIGHTS_TEXT, vc.SPECIAL_PRODUCT_SPLIT, vc.SPECIAL_PRODUCT_CARVE_OUT, vc.PAYMENT_INTERVAL,  vc.PAY_AFTER, vc.SHOW_CREDIT_CARD,  vc.OPT_OUT, vc.APPLY_FX_SPREAD, vc.RESERVE_RATE,  vc.NUMBER_OF_MONTHS_BEFORE_PAYOUT,  vc.NUMBER_OF_INSTALLMENTS,  vc.CONTRACT_TERMS,
          try_to_number(f.value::string) as territory_carve_out
          FROM royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor_contract vc,
          lateral flatten(input=>split(territory_carve_out, ','))  f
    ;;
```