view: stmt_db_period_id {
   sql_table_name: period_id ;;
  label: "Delivery"

  dimension: period_id {
    type: number
    hidden: yes
    sql: ${TABLE}.period_id ;;
    description: "Accounting period ID in which these sales were delivered to the labels. Will not be available if the sales has not yet been paid to labels."
  }

  dimension: booking_year {
    type: number
    value_format: "0"
    hidden: yes
    sql: ${TABLE}.booking_year ;;
    description: "Accounting booking year."
  }

  dimension: booking_quarter {
    type: number
    value_format: "0"
    hidden: yes
    sql: ${TABLE}.booking_quarter ;;
    description: "Accounting booking quarter."
  }

  dimension: booking_month {
    type: number
    value_format: "0"
    hidden: yes
    sql: ${TABLE}.booking_month ;;
    description: "Accounting booking month."
  }

  dimension: delivery_date {
    type: date_month
    label: "Delivery Month"
    hidden: yes
    sql: ${TABLE}.delivery_date ;;
    description: "Month in which the statement is posted to Workstation."
  }

  dimension: statement_date {
    label: "Statement Period"
    type: date
    sql: ${TABLE}.statement_date ;;
    #hidden: yes
    description: "Corresponds to Workstation Statement Periods, displayed as the last day of the month. Accounting period name in which these sales were delivered to the labels. Will not be available if the sales have not yet been paid to labels."
  }

  dimension_group: statement_date {
   label: "Statement Date"
    type: time
    timeframes: [month_name,year]
    convert_tz: no
    sql: ${TABLE}.statement_date ;;
    hidden: yes
    description: "Corresponds to Workstation Statement Periods. Accounting period name in which these sales were delivered to the labels. Will not be available if the sales have not yet been paid to labels."
  }

  dimension: statement_name {
    label: "Statement Period Name"
    type: string
    sql: concat(${statement_date_month_name}, " ", ${statement_date_year}) ;;
    description: "Corresponds to Workstation Statement Periods. Accounting period name in which these sales were delivered to the labels. Will not be available if the sales have not yet been paid to labels."
  }

  dimension: activity_date {
    type: date_month
    label: "Activity Month"
    hidden: yes
    sql: ${TABLE}.primary_activity_date ;;
    description: "Primary activity date contained in this Statement Period."
  }

  filter: statement_name_filter {
    type: date
  }
}