Bncollege Invoice Detail

view: bncollege_invoice_detail {
  sql_table_name: ${TABLE}.invoice_detail ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: term {
    label: "ACADEMIC TERM"
  }

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

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

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

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

  measure: count {
    type: count
  }
}

- view: bncollege_invoice_detail
  sql_table_name: ${TABLE}.invoice_detail
  fields:
  - dimension: ajb_card_type
    sql: ${TABLE}.ajb_card_type
  - dimension: card_last_four_digit
    sql: ${TABLE}.card_last_four_digit
  - dimension: card_type
    sql: ${TABLE}.card_type
  - dimension: city
    sql: ${TABLE}.city
  - dimension: customer_phone_number
    sql: ${TABLE}.customer_phone_number
  - dimension: dbr_no
    sql: ${TABLE}.dbr_no
  - dimension: drivers_license_number
    sql: ${TABLE}.drivers_license_number
  - dimension: drivers_license_state
    sql: ${TABLE}.drivers_license_state
  - dimension: due_date
    sql: ${TABLE}.due_date
  - dimension: email_address
    sql: ${TABLE}.email_address
  - dimension: failed_txn_date
    sql: ${TABLE}.failed_txn_date
  - dimension: fees_status
    sql: ${TABLE}.fees_status
  - dimension: first_retry_date
    sql: ${TABLE}.first_retry_date
  - dimension: first_retry_response
    sql: ${TABLE}.first_retry_response
  - dimension: firstname
    sql: ${TABLE}.firstname
  - dimension: fourth_retry_date
    sql: ${TABLE}.fourth_retry_date
  - dimension: fourth_retry_response
    sql: ${TABLE}.fourth_retry_response
  - dimension: ivt_no
    sql: ${TABLE}.ivt_no
  - dimension: last_update_date
    sql: ${TABLE}.last_update_date
  - dimension: lastname
    sql: ${TABLE}.lastname
  - dimension: nonreplacementpenaltydue
    sql: ${TABLE}.nonreplacementpenaltydue
  - dimension: order_fulfilled_date
    sql: ${TABLE}.order_fulfilled_date
  - dimension: orders_id
    sql: ${TABLE}.orders_id
  - dimension: payment_failure_reason
    sql: ${TABLE}.payment_failure_reason
  - dimension: rental_id
    sql: ${TABLE}.rental_id
  - dimension: rental_price
    sql: ${TABLE}.rental_price
  - dimension: rental_title
    sql: ${TABLE}.rental_title
  - dimension: replacement_fees_due
    sql: ${TABLE}.replacement_fees_due
  - dimension: retry_flag
    sql: ${TABLE}.retry_flag
  - dimension: returnstatus
    sql: ${TABLE}.returnstatus
  - dimension: sales_tax_due
    sql: ${TABLE}.sales_tax_due
  - dimension: second_retry_date
    sql: ${TABLE}.second_retry_date
  - dimension: second_retry_response
    sql: ${TABLE}.second_retry_response
  - dimension: sent_to_agency
    sql: ${TABLE}.sent_to_agency
  - dimension: shipto_addrress
    sql: ${TABLE}.shipto_addrress
  - dimension: shipto_name
    sql: ${TABLE}.shipto_name
  - dimension: state
    sql: ${TABLE}.state
  - dimension: store_name
    sql: ${TABLE}.store_name
  - dimension: store_nbr
    sql: ${TABLE}.store_nbr
  - dimension: street_address
    sql: ${TABLE}.street_address
  - dimension: term_code
    sql: ${TABLE}.term_code
  - dimension: term
    label: ACADEMIC TERM
  - dimension: third_retry_date
    sql: ${TABLE}.third_retry_date
  - dimension: third_retry_response
    sql: ${TABLE}.third_retry_response
  - dimension: total_due
    sql: ${TABLE}.total_due
  - dimension: zipcode
    sql: ${TABLE}.zipcode
  - measure: count
    type: count