Sales Order Lineitems

view: sales_order_lineitems {
  sql_table_name: sales_order_lineitems_table ;;

  dimension: alacrate {
    type: number
    sql: ${TABLE}.alacrate ;;
  }

  dimension: analysis {
    sql: ${TABLE}.analysis ;;
  }

  dimension: desc_ {
    sql: ${TABLE}.desc_ ;;
  }

  dimension: disc {
    type: number
    sql: ${TABLE}.disc ;;
  }

  dimension: disc1 {
    type: number
    sql: ${TABLE}.disc1 ;;
  }

  dimension: disc2 {
    type: number
    sql: ${TABLE}.disc2 ;;
  }

  dimension: discrte {
    type: number
    sql: ${TABLE}.discrte ;;
  }

  dimension: discrte1 {
    type: number
    sql: ${TABLE}.discrte1 ;;
  }

  dimension: discrte2 {
    type: number
    sql: ${TABLE}.discrte2 ;;
  }

  dimension: disctyp {
    type: number
    sql: ${TABLE}.disctyp ;;
  }

  dimension: disctyp1 {
    type: number
    sql: ${TABLE}.disctyp1 ;;
  }

  dimension: disctyp2 {
    type: number
    sql: ${TABLE}.disctyp2 ;;
  }

  dimension: entry {
    type: number
    sql: ${TABLE}.entry ;;
  }

  dimension: exciserte {
    type: number
    sql: ${TABLE}.exciserte ;;
  }

  dimension: freightamt {
    type: number
    sql: ${TABLE}.freightamt ;;
  }

  dimension: glover {
    sql: ${TABLE}.glover ;;
  }

  dimension: gstexm {
    sql: ${TABLE}.gstexm ;;
  }

  dimension: gstsupply {
    type: number
    sql: ${TABLE}.gstsupply ;;
  }

  dimension: haccpref {
    sql: ${TABLE}.haccpref ;;
  }

  dimension: ila {
    sql: ${TABLE}.ila ;;
  }

  dimension: itemcode {
    sql: ${TABLE}.itemcode ;;
  }

  dimension: iva {
    sql: ${TABLE}.iva ;;
  }

  dimension: linetype {
    type: number
    sql: ${TABLE}.linetype ;;
  }

  dimension: location {
    sql: ${TABLE}.location ;;
  }

  dimension: nonstock {
    sql: ${TABLE}.nonstock ;;
  }

  dimension: order_ {
    type: number
    sql: ${TABLE}.order_ ;;
  }

  dimension: pickorder {
    sql: ${TABLE}.pickorder ;;
  }

  dimension: price {
    type: number
    sql: ${TABLE}.price ;;
  }

  dimension: project {
    sql: ${TABLE}.project ;;
  }

  dimension: qtybkd {
    type: number
    sql: ${TABLE}.qtybkd ;;
  }

  dimension: qtyord {
    type: number
    sql: ${TABLE}.qtyord ;;
  }

  dimension: qtysup {
    type: number
    sql: ${TABLE}.qtysup ;;
  }

  dimension: reason {
    sql: ${TABLE}.reason ;;
  }

  dimension: rec_id {
    type: int
    sql: ${TABLE}.rec_id ;;
  }

  dimension: recnbr {
    type: number
    sql: ${TABLE}.recnbr ;;
  }

  dimension: salestax {
    type: number
    sql: ${TABLE}.salestax ;;
  }

  dimension: special {
    sql: ${TABLE}.special ;;
  }

  dimension: tolocn {
    sql: ${TABLE}.tolocn ;;
  }

  dimension: unit {
    sql: ${TABLE}.unit ;;
  }

  dimension: unitcost {
    type: number
    sql: ${TABLE}.unitcost ;;
  }

  dimension: wetclaim {
    sql: ${TABLE}.wetclaim ;;
  }

  dimension: wetpay {
    type: number
    sql: ${TABLE}.wetpay ;;
  }

  dimension: winebatch {
    sql: ${TABLE}.winebatch ;;
  }

  measure: count {
    type: count
  }
}

- view: sales_order_lineitems
  sql_table_name: sales_order_lineitems_table
  fields:
  - dimension: alacrate
    type: number
    sql: ${TABLE}.alacrate
  - dimension: analysis
    sql: ${TABLE}.analysis
  - dimension: desc_
    sql: ${TABLE}.desc_
  - dimension: disc
    type: number
    sql: ${TABLE}.disc
  - dimension: disc1
    type: number
    sql: ${TABLE}.disc1
  - dimension: disc2
    type: number
    sql: ${TABLE}.disc2
  - dimension: discrte
    type: number
    sql: ${TABLE}.discrte
  - dimension: discrte1
    type: number
    sql: ${TABLE}.discrte1
  - dimension: discrte2
    type: number
    sql: ${TABLE}.discrte2
  - dimension: disctyp
    type: number
    sql: ${TABLE}.disctyp
  - dimension: disctyp1
    type: number
    sql: ${TABLE}.disctyp1
  - dimension: disctyp2
    type: number
    sql: ${TABLE}.disctyp2
  - dimension: entry
    type: number
    sql: ${TABLE}.entry
  - dimension: exciserte
    type: number
    sql: ${TABLE}.exciserte
  - dimension: freightamt
    type: number
    sql: ${TABLE}.freightamt
  - dimension: glover
    sql: ${TABLE}.glover
  - dimension: gstexm
    sql: ${TABLE}.gstexm
  - dimension: gstsupply
    type: number
    sql: ${TABLE}.gstsupply
  - dimension: haccpref
    sql: ${TABLE}.haccpref
  - dimension: ila
    sql: ${TABLE}.ila
  - dimension: itemcode
    sql: ${TABLE}.itemcode
  - dimension: iva
    sql: ${TABLE}.iva
  - dimension: linetype
    type: number
    sql: ${TABLE}.linetype
  - dimension: location
    sql: ${TABLE}.location
  - dimension: nonstock
    sql: ${TABLE}.nonstock
  - dimension: order_
    type: number
    sql: ${TABLE}.order_
  - dimension: pickorder
    sql: ${TABLE}.pickorder
  - dimension: price
    type: number
    sql: ${TABLE}.price
  - dimension: project
    sql: ${TABLE}.project
  - dimension: qtybkd
    type: number
    sql: ${TABLE}.qtybkd
  - dimension: qtyord
    type: number
    sql: ${TABLE}.qtyord
  - dimension: qtysup
    type: number
    sql: ${TABLE}.qtysup
  - dimension: reason
    sql: ${TABLE}.reason
  - dimension: rec_id
    type: int
    sql: ${TABLE}.rec_id
  - dimension: recnbr
    type: number
    sql: ${TABLE}.recnbr
  - dimension: salestax
    type: number
    sql: ${TABLE}.salestax
  - dimension: special
    sql: ${TABLE}.special
  - dimension: tolocn
    sql: ${TABLE}.tolocn
  - dimension: unit
    sql: ${TABLE}.unit
  - dimension: unitcost
    type: number
    sql: ${TABLE}.unitcost
  - dimension: wetclaim
    sql: ${TABLE}.wetclaim
  - dimension: wetpay
    type: number
    sql: ${TABLE}.wetpay
  - dimension: winebatch
    sql: ${TABLE}.winebatch
  - measure: count
    type: count