# View: dt_proper_physical_price_code

**View Name:** dt_proper_physical_price_code
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_PROPER_PHYSICAL_PRICE_CODE`
**File Path:** `dt_proper_physical_price_code.view.lkml`

## Overview

- **File Size:** 24949 bytes
- **Lines of Code:** 609
- **Dimensions:** 6
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: select product_id as release_id,
- 'Proper Music Distribution' as store_name,

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `store_name` | string |
| `store_pricing_tier_name` | string |
| `price_code` | number |
| `price_code_string` | number |
| `price_code_mapping` | string |

## Derived Table

```sql
#   sql: select product_id as release_id,
  #   'Proper Music Distribution' as store_name,
  #   store_pricing_tier_name,
  #   price_code
  #   from ORCHARD_APP_REPORTING_V2.PROD_OWS_PRICING_PRICING.PRODUCT_STORE_EFFECTIVE_PRICE_CODE
  #   where store_id = 696;;
  #
```