Daysum

view: daysum {
  sql_table_name: DAYSUM ;;

  dimension: pfxrecnum {
    type: int
    primary_key: yes
    sql: ${TABLE}.PFXRECNUM ;;
  }

  dimension: area {
    sql: ${TABLE}.AREA ;;
  }

  dimension: buy_phones008 {
    type: number
    sql: ${TABLE}.BUY_PHONES008 ;;
  }

  dimension: buy_phones011 {
    type: number
    sql: ${TABLE}.BUY_PHONES011 ;;
  }

  dimension: buy_trx007 {
    type: number
    sql: ${TABLE}.BUY_TRX007 ;;
  }

  dimension: buycost {
    type: number
    sql: ${TABLE}.BUYCOST ;;
  }

  dimension: buystorecredit {
    sql: ${TABLE}.BUYSTORECREDIT ;;
  }

  dimension: cahsinfrombank {
    type: number
    sql: ${TABLE}.CAHSINFROMBANK ;;
  }

  dimension: cashbuys {
    type: number
    sql: ${TABLE}.CASHBUYS ;;
  }

  dimension: cashclose {
    type: number
    sql: ${TABLE}.CASHCLOSE ;;
  }

  dimension: cashopen {
    type: number
    sql: ${TABLE}.CASHOPEN ;;
  }

  dimension: cashopenvar {
    type: number
    sql: ${TABLE}.CASHOPENVAR ;;
  }

  dimension: cashoutfrombank {
    type: number
    sql: ${TABLE}.CASHOUTFROMBANK ;;
  }

  dimension: cashpettynet {
    type: number
    sql: ${TABLE}.CASHPETTYNET ;;
  }

  dimension: cashsales {
    type: number
    sql: ${TABLE}.CASHSALES ;;
  }

  dimension: cashvariance {
    type: number
    sql: ${TABLE}.CASHVARIANCE ;;
  }

  dimension: ccdvariance {
    type: number
    sql: ${TABLE}.CCDVARIANCE ;;
  }

  dimension: closenotes {
    sql: ${TABLE}.CLOSENOTES ;;
  }

  dimension: district {
    sql: ${TABLE}.DISTRICT ;;
  }

  dimension: employeeopen {
    sql: ${TABLE}.EMPLOYEEOPEN ;;
  }

  dimension: opennotes {
    sql: ${TABLE}.OPENNOTES ;;
  }

  dimension: paymentamex {
    type: number
    sql: ${TABLE}.PAYMENTAMEX ;;
  }

  dimension: paymentcash {
    type: number
    sql: ${TABLE}.PAYMENTCASH ;;
  }

  dimension: paymentdebit {
    type: number
    sql: ${TABLE}.PAYMENTDEBIT ;;
  }

  dimension: paymentmc {
    type: number
    sql: ${TABLE}.PAYMENTMC ;;
  }

  dimension: paymentstorecredit {
    type: number
    sql: ${TABLE}.PAYMENTSTORECREDIT ;;
  }

  dimension: paymentvisa {
    type: number
    sql: ${TABLE}.PAYMENTVISA ;;
  }

  dimension: region {
    sql: ${TABLE}.REGION ;;
  }

  dimension: sell_apple021 {
    type: number
    sql: ${TABLE}.SELL_APPLE021 ;;
  }

  dimension: sell_phones019 {
    type: number
    sql: ${TABLE}.SELL_PHONES019 ;;
  }

  dimension: sell_phones020 {
    type: number
    sql: ${TABLE}.SELL_PHONES020 ;;
  }

  dimension: sell_trx012 {
    type: number
    sql: ${TABLE}.SELL_TRX012 ;;
  }

  dimension: sellcost {
    type: number
    sql: ${TABLE}.SELLCOST ;;
  }

  dimension: sellnet {
    type: number
    sql: ${TABLE}.SELLNET ;;
  }

  dimension: sellnontax {
    type: number
    sql: ${TABLE}.SELLNONTAX ;;
  }

  dimension: sellretail {
    type: number
    sql: ${TABLE}.SELLRETAIL ;;
  }

  dimension: sellreturn {
    type: number
    sql: ${TABLE}.SELLRETURN ;;
  }

  dimension: selltaxrcd {
    type: number
    sql: ${TABLE}.SELLTAXRCD ;;
  }

  dimension: storecode {
    sql: ${TABLE}.STORECODE ;;
  }

  dimension_group: date {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DATE002 ;;
  }

  measure: count {
    type: count
  }
}

- view: daysum
  sql_table_name: DAYSUM
  fields:
  - dimension: pfxrecnum
    type: int
    primary_key: true
    sql: ${TABLE}.PFXRECNUM
  - dimension: area
    sql: ${TABLE}.AREA
  - dimension: buy_phones008
    type: number
    sql: ${TABLE}.BUY_PHONES008
  - dimension: buy_phones011
    type: number
    sql: ${TABLE}.BUY_PHONES011
  - dimension: buy_trx007
    type: number
    sql: ${TABLE}.BUY_TRX007
  - dimension: buycost
    type: number
    sql: ${TABLE}.BUYCOST
  - dimension: buystorecredit
    sql: ${TABLE}.BUYSTORECREDIT
  - dimension: cahsinfrombank
    type: number
    sql: ${TABLE}.CAHSINFROMBANK
  - dimension: cashbuys
    type: number
    sql: ${TABLE}.CASHBUYS
  - dimension: cashclose
    type: number
    sql: ${TABLE}.CASHCLOSE
  - dimension: cashopen
    type: number
    sql: ${TABLE}.CASHOPEN
  - dimension: cashopenvar
    type: number
    sql: ${TABLE}.CASHOPENVAR
  - dimension: cashoutfrombank
    type: number
    sql: ${TABLE}.CASHOUTFROMBANK
  - dimension: cashpettynet
    type: number
    sql: ${TABLE}.CASHPETTYNET
  - dimension: cashsales
    type: number
    sql: ${TABLE}.CASHSALES
  - dimension: cashvariance
    type: number
    sql: ${TABLE}.CASHVARIANCE
  - dimension: ccdvariance
    type: number
    sql: ${TABLE}.CCDVARIANCE
  - dimension: closenotes
    sql: ${TABLE}.CLOSENOTES
  - dimension: district
    sql: ${TABLE}.DISTRICT
  - dimension: employeeopen
    sql: ${TABLE}.EMPLOYEEOPEN
  - dimension: opennotes
    sql: ${TABLE}.OPENNOTES
  - dimension: paymentamex
    type: number
    sql: ${TABLE}.PAYMENTAMEX
  - dimension: paymentcash
    type: number
    sql: ${TABLE}.PAYMENTCASH
  - dimension: paymentdebit
    type: number
    sql: ${TABLE}.PAYMENTDEBIT
  - dimension: paymentmc
    type: number
    sql: ${TABLE}.PAYMENTMC
  - dimension: paymentstorecredit
    type: number
    sql: ${TABLE}.PAYMENTSTORECREDIT
  - dimension: paymentvisa
    type: number
    sql: ${TABLE}.PAYMENTVISA
  - dimension: region
    sql: ${TABLE}.REGION
  - dimension: sell_apple021
    type: number
    sql: ${TABLE}.SELL_APPLE021
  - dimension: sell_phones019
    type: number
    sql: ${TABLE}.SELL_PHONES019
  - dimension: sell_phones020
    type: number
    sql: ${TABLE}.SELL_PHONES020
  - dimension: sell_trx012
    type: number
    sql: ${TABLE}.SELL_TRX012
  - dimension: sellcost
    type: number
    sql: ${TABLE}.SELLCOST
  - dimension: sellnet
    type: number
    sql: ${TABLE}.SELLNET
  - dimension: sellnontax
    type: number
    sql: ${TABLE}.SELLNONTAX
  - dimension: sellretail
    type: number
    sql: ${TABLE}.SELLRETAIL
  - dimension: sellreturn
    type: number
    sql: ${TABLE}.SELLRETURN
  - dimension: selltaxrcd
    type: number
    sql: ${TABLE}.SELLTAXRCD
  - dimension: storecode
    sql: ${TABLE}.STORECODE
  - dimension_group: date
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DATE002
  - measure: count
    type: count