# View: cdsus_product

**View Name:** cdsus_product
**Table Source:** `sony_internal.prod.cdsus_product`
**File Path:** `cdsus_product.view.lkml`

## Overview

- **File Size:** 15059 bytes
- **Lines of Code:** 784
- **Dimensions:** 122
- **Measures:** 1
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `oa_different_than_cdsus` | string |
| `oa_different_than_cdsus_name` | string |
| `article_no` | string |
| `company_cd` | string |
| `catlg_core_id` | string |
| `configuration_cd` | string |
| `configuration_group_cd` | string |
| `inventory_category_cd` | string |
| `catlg_pfix_id` | string |
| `label_cd` | string |
| `label_group_cd` | string |
| `product_line_cd` | string |
| `product_line_group_cd` | string |
| `sub_product_line_cd` | string |
| `upc_cd` | string |
| `box_set_in` | string |
| `units_per_set_qt` | number |
| `hlc_cd` | string |
| `mfg_size_cd` | string |
| `sales_service_discount_cd` | string |
| `explicit_lyrics_in` | string |
| `repertoire_cd` | string |
| `repertoire_group_cd` | string |
| `sub_repertoire_cd` | string |
| `sub_type_cd` | string |
| `type_cd` | string |
| `family_no` | string |
| `sub_label_cd` | string |
| `selection_id` | string |
| `selection_short_nm` | string |
| `selection_long_nm` | string |
| `seasonal_cd` | string |
| `artist_id` | number |
| `artist_nm` | string |
| `release_week_no` | number |
| `current_release_dt` | date |
| `original_release_dt` | date |
| `series_cd` | number |
| `digest_loose_pr` | number |
| `digest_bulk_pr` | string |
| `reporting_pfix_id` | string |
| `primary_pfix_in` | string |
| `catalog_in` | string |
| `group_cd` | string |
| `status_cd` | string |
| `last_credit_dt` | date |
| `alternate_catlg_id` | string |
| `active_in` | string |
| `cutout_dt` | date |
| `std_carton_pack_qt` | number |
| `artist_short_nm` | string |
| `returns_allowed_in` | string |
| `operational_hold_in` | string |
| `imprint_cd` | string |
| `pfix_id` | string |
| `exclusive_product_in` | string |
| `global_article_no` | string |
| `key_chart_in` | string |
| `tray_cd` | string |
| `sp_pack_cd` | string |
| `order_hold_in` | string |
| `sell_down_in` | string |
| `symbol_cd` | string |
| `gds_sub_product_line_cd` | string |
| `rollup_no` | string |
| `primary_altno_in` | string |
| `loose_charge_in` | string |
| `sap_map_cd` | string |
| `gas_prefix` | string |
| `gas_core_id` | string |
| `pref_vendor_loc` | string |
| `super_ref_no` | string |
| `album_tie_in` | string |
| `project_id` | string |
| `primary_sref_in` | string |
| `hits_in` | string |
| `special_item_in` | string |
| `odd_size_in` | string |
| `gas_affiliate` | string |
| `sony_bmg_item_in` | string |
| `license_type_cd` | string |
| `lsas_in` | string |
| `sap_ledger_cd` | string |
| `sap_company_cd` | string |
| `samis_country_cd` | string |
| `business_unit_cd` | string |
| `price_category_cd` | string |
| `royalty_in_cd` | string |
| `value_add_cd` | string |
| `copy_protect_cd` | string |
| `create_dt` | date |
| `last_modified_dt` | date |
| `gds_alternate_catlg_id` | string |
| `sap_profit_center` | string |
| `billing_parent_no` | string |
| `raas_no` | string |
| `fin_label_cd` | string |
| `fin_label_profit_cd` | string |
| `fin_label_parent_cd` | string |
| `strategic_pnl_cd` | string |
| `fin_label_corp_rollup_cd` | string |
| `packaging_cd` | string |
| `pegasus_dt` | date |
| `pegasus_time` | number |
| `pegasus_flag` | string |
| `dod_flag` | string |
| `cpsia_flag` | string |
| `client_nm` | string |
| `expiration_dt` | date |
| `sap_material_no` | string |
| `red_catalog_flag` | string |
| `red_price_cd` | string |
| `red_label_cd` | string |
| `gras_product_nm` | string |
| `gras_artist_nm` | string |
| `gras_artist_id` | string |
| `gras_configuration_cd` | string |
| `gras_configuration_nm` | string |
| `orchard_genre_nm` | string |
| `orchard_sub_genre_nm` | string |
| `orchard_product_type` | string |
| `orchard_format` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Dimension Groups

| Name | Type |
|------|------|
| `in_store_dt` | time |