view: facts_prod_staging_raw_membran { sql_table_name: facts.prod.staging_raw_membran;; dimension: ARTIST { type: string sql: ${TABLE}.ARTIST ;; label: "Artist" } dimension: BARCODE { type: string sql: ${TABLE}.BARCODE ;; label: "Barcode" } dimension: CATALOG_NO { type: string sql: ${TABLE}.CATALOG_NO ;; label: "Catalog Number" } dimension: DOWNLOAD_DATE { type: date sql: ${TABLE}.DOWNLOAD_DATE ;; label: "Download Date" } dimension: EXTERNAL_DISTRIBUTION_STOCK { type: number sql: ${TABLE}.EXTERNAL_DISTRIBUTION_STOCK ;; label: "External Distribution Stock" } dimension: FILENAME { type: string sql: ${TABLE}.FILENAME ;; label: "Filename" } dimension: LABEL { type: string sql: ${TABLE}.LABEL ;; label: "Label" } dimension: NET_SALES_CURRENT_MINUS_10_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_10_MONTH ;; label: "Net Sales Current Minus 10 Month" } dimension: NET_SALES_CURRENT_MINUS_11_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_11_MONTH ;; label: "Net Sales Current Minus 11 Month" } dimension: NET_SALES_CURRENT_MINUS_1_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_1_MONTH ;; label: "Net Sales Current Minus 1 Month" } dimension: NET_SALES_CURRENT_MINUS_2_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_2_MONTH ;; label: "Net Sales Current Minus 2 Month" } dimension: NET_SALES_CURRENT_MINUS_3_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_3_MONTH ;; label: "Net Sales Current Minus 3 Month" } dimension: NET_SALES_CURRENT_MINUS_4_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_4_MONTH ;; label: "Net Sales Current Minus 4 Month" } dimension: NET_SALES_CURRENT_MINUS_5_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_5_MONTH ;; label: "Net Sales Current Minus 5 Month" } dimension: NET_SALES_CURRENT_MINUS_6_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_6_MONTH ;; label: "Net Sales Current Minus 6 Month" } dimension: NET_SALES_CURRENT_MINUS_7_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_7_MONTH ;; label: "Net Sales Current Minus 7 Month" } dimension: NET_SALES_CURRENT_MINUS_8_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_8_MONTH ;; label: "Net Sales Current Minus 8 Month" } dimension: NET_SALES_CURRENT_MINUS_9_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MINUS_9_MONTH ;; label: "Net Sales Current Minus 9 Month" } dimension: NET_SALES_CURRENT_MONTH { type: number sql: ${TABLE}.NET_SALES_CURRENT_MONTH ;; label: "Net Sales Current Month" } dimension: ORCHARD_LABEL_ID { type: string sql: ${TABLE}.ORCHARD_LABEL_ID ;; label: "Orchard Label ID" } dimension: OWNER { type: string sql: ${TABLE}.OWNER ;; label: "Owner" } dimension: PPD { type: number sql: ${TABLE}.PPD ;; label: "PPD" } dimension: PRICE_CODE { type: string sql: ${TABLE}.PRICE_CODE ;; label: "Price Code" } dimension: PRODUCT { type: string sql: ${TABLE}.PRODUCT ;; label: "Product" } dimension: QTY_ON_PURCH_ORDER { type: number sql: ${TABLE}.QTY_ON_PURCH_ORDER ;; label: "Quantity on Purchase Order" } dimension: QTY_ON_SALES_ORDER { type: number sql: ${TABLE}.QTY_ON_SALES_ORDER ;; label: "Quantity on Sales Order" } dimension: QTY_OUTGOING_TRANSFER { type: number sql: ${TABLE}.QTY_OUTGOING_TRANSFER ;; label: "Quantity Outgoing Transfer" } dimension: RELEASE_DATE { type: date sql: ${TABLE}.RELEASE_DATE ;; label: "Release Date" } dimension: ROW_ID { type: number sql: ${TABLE}.ROW_ID ;; label: "Row ID" } dimension: SET_CONTENT { type: number sql: ${TABLE}.SET_CONTENT ;; label: "Set Content" } dimension: STATUS { type: string sql: ${TABLE}.STATUS ;; label: "Status" } dimension: STOCK_MEMBRAN { type: number sql: ${TABLE}.STOCK_MEMBRAN ;; label: "Stock Membran" } dimension: STOCK_REFURBISCH { type: number sql: ${TABLE}.STOCK_REFURBISCH ;; label: "Stock Refurbisch" } dimension: STOCK_SCRAP { type: number sql: ${TABLE}.STOCK_SCRAP ;; label: "Stock Scrap" } dimension: TERRITORY_RESTRICTIONS { type: string sql: ${TABLE}.TERRITORY_RESTRICTIONS ;; label: "Territory Restrictions" } dimension: TITLE { type: string sql: ${TABLE}.TITLE ;; label: "Title" } dimension: TOTAL_NET_SALES { type: number sql: ${TABLE}.TOTAL_NET_SALES ;; label: "Total Net Sales" } dimension: TOTAL_NET_SALES_PREV_YEAR { type: number sql: ${TABLE}.TOTAL_NET_SALES_PREV_YEAR ;; label: "Total Net Sales Previous Year" } dimension: TOTAL_NET_SALES_THIS_YEAR { type: number sql: ${TABLE}.TOTAL_NET_SALES_THIS_YEAR ;; label: "Total Net Sales This Year" } dimension: TOTAL_STOCK { type: number sql: ${TABLE}.TOTAL_STOCK ;; label: "Total Stock" } }