# View: dt_us_physical_product_view_with_release_grid

**View Name:** dt_us_physical_product_view_with_release_grid
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_US_PHYSICAL_PRODUCT_VIEW_WITH_RELEASE_GRID`
**File Path:** `dt_us_physical_product_view_with_release_grid.view.lkml`

## Overview

- **File Size:** 10349 bytes
- **Lines of Code:** 478
- **Dimensions:** 40
- **Measures:** 30
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: select *
- from sony_internal.prod.us_physical_product_view us

## Dimensions

| Name | Type |
|------|------|
| `suggested_retail_price` | number |
| `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 |
| `upc_ean` | 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 |
| `inventory_category_cd` | 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` | date |
| `gras_status` | string |

## Measures

| Name | Type |
|------|------|
| `open_orders` | sum |
| `backorders` | sum |
| `day1_s` | sum |
| `5day_s` | sum |
| `5day_r` | sum |
| `5_day_s` | sum |
| `5_day_r` | sum |
| `mtd_s` | sum |
| `3MS_ships` | sum |
| `mtd_r` | sum |
| `m_td_s` | sum |
| `m_td_r` | sum |
| `cytd_s` | sum |
| `cytd_r` | sum |
| `c_ytd_s` | sum |
| `c_ytd_r` | sum |
| `12MS_ships` | sum |
| `rtd_s` | sum |
| `rtd_r` | sum |
| `r_td_s` | sum |
| `r_td_r` | sum |
| `on_hand` | sum |
| `available` | sum |
| `purchase_orders` | sum |
| `potential` | sum |
| `returns_in_process` | sum |
| `on_hold` | sum |
| `inventory_ratio` | number |
| `12m_overstock` | sum |
| `24m_overstock` | sum |

## Derived Table

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