# View: product_store_effective_price_code

**View Name:** product_store_effective_price_code
**Table Source:** `orchard_app_reporting_v2.prod_ows_pricing_pricing.PRODUCT_STORE_EFFECTIVE_PRICE_CODE`
**File Path:** `product_store_effective_price_code.view.lkml`

## Overview

- **File Size:** 28045 bytes
- **Lines of Code:** 680
- **Dimensions:** 13
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

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

## Dimensions

| Name | Type |
|------|------|
| `product_store_effective_price_code_id` | number |
| `product_id` | number |
| `store_id` | number |
| `price_code` | string |
| `price_code_for_hmv` | string |
| `hmv_net_price` | string |
| `hmv_retail_price` | string |
| `created_date` | string |
| `created_by` | string |
| `updated_date` | string |
| `updated_by` | string |
| `store_pricing_tier_name` | string |
| `price_code_mapping` | string |