# View: physical_eu

**View Name:** physical_eu
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `physical_eu.view.lkml`

## Overview

- **File Size:** 10115 bytes
- **Lines of Code:** 339
- **Dimensions:** 30
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | number |
| `datetime_ingested` | date_time |
| `label_id` | string |
| `owner` | string |
| `product_code` | string |
| `product_type` | string |
| `units` | number |
| `upc` | string |
| `artist_name` | string |
| `release_name` | string |
| `warehouse_id` | string |
| `warehouse_is_supply_chain` | yesno |
| `warehouse_name` | string |
| `manufactured_internally` | yesno |
| `date_deleted` | date |
| `is_deleted` | yesno |
| `stock_on_hand` | number |
| `stock_faulty` | number |
| `stock_external` | number |
| `stock_allocated` | number |
| `stock_backorders` | number |
| `stock_inbound` | number |
| `stock_total` | number |
| `sales_total` | number |
| `sales_this_month` | number |
| `sales_last_month` | number |
| `sales_this_year` | number |
| `sales_last_year` | number |
| `price_uk` | number |
| `territory_restrictions` | string |

## Derived Table

```sql
sql:

    WITH max_ingestion_time_membran AS (
        SELECT MAX(TO_DATE(membran.INGESTION_TIME)) AS max_date
        FROM ${facts_prod_staging_raw_membran.SQL_TABLE_NAME
```