invoice_line_item.view.lkml

view: invoice_line_item {
  sql_table_name: xero.invoice_line_item ;;

  dimension: account_code {
    type: string
    sql: ${TABLE}.account_code ;;
  }

  dimension: description {
    type: string
    sql: ${TABLE}.description ;;
  }

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

  dimension: invoice_id {
    type: string
    # hidden: yes
    sql: ${TABLE}.invoice_id ;;
  }

  dimension: item_code {
    type: string
    sql: ${TABLE}.item_code ;;
  }

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

  dimension: line_item_id {
    type: string
    sql: ${TABLE}.line_item_id ;;
  }

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

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

  dimension: tax_type {
    type: string
    sql: ${TABLE}.tax_type ;;
  }

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

  dimension: validation_errors {
    type: string
    sql: ${TABLE}.validation_errors ;;
  }

  measure: count {
    type: count
    drill_fields: [invoice.invoice_id]
  }
}