# View: dt_mgm_physical_price_code

**View Name:** dt_mgm_physical_price_code
**Table Source:** `Derived from: Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Ows_Pricing_Pricing, Prod_Ows_Pricing_Pricing.Product_Store_Effective_Price_Code`
**File Path:** `dt_mgm_physical_price_code.view.lkml`

## Overview

- **File Size:** 24616 bytes
- **Lines of Code:** 600
- **Dimensions:** 5
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- 1' Then  '1317.09'
- 2' Then  '245.04'
- 3' Then  '91.89'

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `store_name` | string |
| `store_pricing_tier_name` | string |
| `price_code` | number |
| `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;;
```