# View: dt_mgm_physical_price_code

**View Name:** dt_mgm_physical_price_code
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_MGM_PHYSICAL_PRICE_CODE`
**File Path:** `dt_mgm_physical_price_code.view.lkml`

## Overview

- **File Size:** 24971 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,
- 'MGM 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` | string |
| `price_code_mapping` | string |

## Derived Table

```sql
#   sql: select product_id as release_id,
  #         'MGM 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 = 737;;
  #
```