view: stmt_db_pl_storelist {
  # # You can specify the table name if it's different from the view name:
  sql_table_name: pl_storelist ;;
  #
  dimension: list_id {
    view_label: "PL"
    description: "List ID"
    type: number
    hidden: yes
    primary_key: yes
    sql: ${TABLE}.list_id ;;
  }

  dimension: cmm_id {
    view_label: "PL"
    type: number
    hidden: yes
    sql: ${TABLE}.cmm_id ;;
  }

  dimension: list_name {
    view_label: "PL"
    label: "List Name"
    description: "Usually the store name, but corresponds more to the division of files for ingestion tracking."
    type: string
    sql: ${TABLE}.store_name ;;
  }

  dimension: dfs_flag {
    view_label: "PL"
    label: "DFS"
    description: "Download from site or FTP, Yes/No"
    type: string
    sql: ${TABLE}.dfs_flag ;;
  }

  dimension: partner {
    view_label: "PL"
    label: "Processing Method"
    description: "'sh' or blank for manual"
    type: string
    sql: ${TABLE}.partner ;;
  }

  dimension: processor {
    view_label: "PL"
    label: "Processor"
    description: "Team member who typically handles this DSP/config"
    type: string
    #hidden: yes
    sql: ${TABLE}.processor ;;
  }

  dimension: global_note {
    view_label: "PL"
    label: "Note"
    description: "Current Note(s) for DSP/config"
    type: string
    #hidden: yes
    sql: ${TABLE}.global_note ;;
  }

  dimension: frequency {
    view_label: "PL"
    label: "Frequency"
    description: "Expected frequency of reporting for this DSP/report."
    type: string
    #hidden: yes
    sql: ${TABLE}.frequency ;;
  }

  dimension: category_id {
    view_label: "PL"
    label: "category_id"
    #  description: ""
    type: number
    hidden: yes
    sql: ${TABLE}.category_id ;;
  }

  dimension: company {
    view_label: "PL"
    label: "Company"
  #  description: ""
    type: string
    sql: ${TABLE}.company ;;
  }
}