view: int_dbt_prod_spatial_audio_delivery_history_search {
  sql_table_name: INTELLIGENCE.DBT_PROD.SPATIAL_AUDIO_DELIVERY_HISTORY_SEARCH ;;

  dimension_group: preorder_date {
    view_label: "Release"
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.preorder_date ;;
  }

  dimension_group: sale_start_date {
    view_label: "Release"
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.sale_start_date ;;
  }

  dimension_group: date_delivered {
    view_label: "Spatial Audio" #Labels changed to surface this data under spatial audio in accounting model
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.date_delivered ;;
  }

  dimension: upc {
    view_label: "Spatial Audio"
    label: "UPC"
    type: string
    sql: ${TABLE}.upc ;;
  }

  dimension: name {
    view_label: "Artist"
    label: "Artist Name"
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: release_name {
    view_label: "Release"
    label: "Release Name"
    type: string
    sql: ${TABLE}.release_name ;;
  }

  dimension: vendor_id {
    view_label: "Vendor"
    label: "Vendor ID"
    type: number
    sql: ${TABLE}.vendor_id ;;
    value_format: "0"
  }

  dimension: vendor_name {
    view_label: "Vendor"
    label: "Vendor Name"
    type: string
    sql: ${TABLE}.vendor_name ;;
  }

  dimension: label {
    view_label: "Imprint"
    label: "Imprint Name"
    type: string
    sql: ${TABLE}.label ;;
  }

  dimension: full_name {
    view_label: "Label"
    label: "Label Manager"
    type: string
    sql: ${TABLE}.full_name ;;
  }

  dimension: priority {
    view_label: "Release"
    label: "Priority"
    type: string
    sql: ${TABLE}.priority;;
  }


  dimension: store_id {
    view_label: "Store"
    type: number
    sql: ${TABLE}.customer_master_master_id ;;
    value_format: "0"
  }

  dimension: store_name {
    view_label: "Spatial Audio"
    type: string
    sql: ${TABLE}.customer_name ;;
  }





  }