# View: ca_physical_product_view_with_release_grid

**View Name:** ca_physical_product_view_with_release_grid
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Release_Grid, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Ca_Physical_Product_View, Sony_Internal + 1 more`
**File Path:** `ca_physical_product_view_with_release_grid.view.lkml`

## Overview

- **File Size:** 8647 bytes
- **Lines of Code:** 489
- **Dimensions:** 39
- **Measures:** 32
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- dimension: suggested_retail_price {
- type: number
- label: "Suggested Retail Price"

## Dimensions

| Name | Type |
|------|------|
| `wholesale_price` | number |
| `orchard_price_code` | string |
| `orchard_price` | string |
| `artist` | string |
| `product_name` | string |
| `label_name` | string |
| `label_code` | string |
| `sub_label` | string |
| `genre` | string |
| `sub_genre` | string |
| `product_code` | string |
| `upcean` | string |
| `release_date` | date |
| `product_type` | string |
| `format` | string |
| `units_per_set` | number |
| `display_configuration` | string |
| `product_status_code` | string |
| `product_status` | string |
| `cutout_date` | date |
| `returns_disposition` | string |
| `returns_disposition_override` | string |
| `returnability` | string |
| `exclusive` | string |
| `gras_prod_no` | string |
| `profit_code` | string |
| `article_no` | string |
| `fin_label_cd` | string |
| `fin_label_profit_center` | string |
| `profit_center` | string |
| `sap_company_cd` | string |
| `vendor_id` | number |
| `subacct_id` | number |
| `release_id` | number |
| `upc` | number |
| `grid` | string |
| `product_no` | string |
| `create_time` | string |
| `gras_status` | string |

## Measures

| Name | Type |
|------|------|
| `open_orders` | sum |
| `backorders` | sum |
| `5_day_s_1` | sum |
| `5_day_r_1` | sum |
| `5_day_s_2` | sum |
| `5_day_sus` | sum |
| `5_day_r` | sum |
| `5_day_rus` | sum |
| `mtds_1` | sum |
| `mtdr_1` | sum |
| `mtds` | sum |
| `mtdsus` | sum |
| `mtdr` | sum |
| `mtdrus` | sum |
| `cytds_1` | sum |
| `cytdr_1` | sum |
| `cytds` | sum |
| `cytdsus` | sum |
| `cytdr` | sum |
| `cytdrus` | sum |
| `rtds_1` | sum |
| `rtdr_1` | sum |
| `rtds` | sum |
| `rtdsus_1` | sum |
| `rtdr` | sum |
| `rtdrus` | sum |
| `on_hand` | sum |
| `available` | sum |
| `purchase_orders` | sum |
| `potential` | sum |
| `returns_in_process` | sum |
| `on_hold` | sum |

## Derived Table

```sql
sql: select *
      from sony_internal.prod.ca_physical_product_view ca
       inner join orchard_app_reporting_v2.art_relations_prod_art_relations.release_grid rg
            on ca.gras_prod_no = rg.product_no
       ;;
```