Payments

view: payments {
  sql_table_name: company_orders_production.payments ;;

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

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

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

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

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

  dimension: dollar_total {
    type: number
    value_format: "$#,##0.00"
    sql: ${TABLE}.dollar_total ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  measure: sum_dollar_total {
    description: "This is the sum of dollar total."
    type: sum
    value_format: "[>=1000000]$0.00,,\"M\";[>=1000]$0.00,\"K\";$0.00"
    drill_fields: [accounts.id, accounts.name, sum_dollar_total]
    sql: ${dollar_total} ;;
  }

  measure: running_dollar_total {
    description: "This is a running total of dollar total."
    type: running_total
    value_format: "[>=1000000]$0.00,,\"M\";[>=1000]$0.00,\"K\";$0.00"
    sql: ${sum_dollar_total} ;;
  }
}

- view: payments
  sql_table_name: company_orders_production.payments
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: cash_amount_paid
    type: int
    sql: ${TABLE}.cash_amount_paid
  - dimension: cash_bill_to
    sql: ${TABLE}.cash_bill_to
  - dimension: cash_terms
    sql: ${TABLE}.cash_terms
  - dimension: credit_card_id
    type: int
    sql: ${TABLE}.credit_card_id
  - dimension: dollar_total
    type: number
    value_format: '$#,##0.00'
    sql: ${TABLE}.dollar_total
  - dimension: invoice_number
    sql: ${TABLE}.invoice_number
  - dimension: lock_version
    type: int
    sql: ${TABLE}.lock_version
  - dimension: notes
    sql: ${TABLE}.notes
  - dimension: order_id
    type: int
    sql: ${TABLE}.order_id
  - dimension: paypal_express_payer_id
    sql: ${TABLE}.paypal_express_payer_id
  - dimension: paypal_express_token
    sql: ${TABLE}.paypal_express_token
  - dimension: paypal_transaction_id
    sql: ${TABLE}.paypal_transaction_id
  - dimension: phone
    sql: ${TABLE}.phone
  - dimension: prepaid_credit_dollar_value
    type: number
    sql: ${TABLE}.prepaid_credit_dollar_value
  - dimension: prepaid_credit_id
    type: int
    sql: ${TABLE}.prepaid_credit_id
  - dimension: prepaid_credit_original_value
    type: number
    sql: ${TABLE}.prepaid_credit_original_value
  - dimension: prepaid_credit_value_spent
    type: number
    sql: ${TABLE}.prepaid_credit_value_spent
  - dimension: session_id
    type: int
    sql: ${TABLE}.session_id
  - dimension: state
    sql: ${TABLE}.state
  - dimension: subscription_id
    type: int
    sql: ${TABLE}.subscription_id
  - dimension: tester_payment_tester_id
    type: int
    sql: ${TABLE}.tester_payment_tester_id
  - dimension: type
    sql: ${TABLE}.type
  - dimension_group: cash_paid
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.cash_paid_at
  - dimension_group: completed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed_at
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: tester_pay
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.tester_pay_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail*
  - measure: sum_dollar_total
    type: sum
    description: This is the sum of dollar total.
    value_format: '[>=1000000]$0.00,,"M";[>=1000]$0.00,"K";$0.00'
    drill_fields:
    - accounts.id
    - accounts.name
    - sum_dollar_total
    sql: ${dollar_total}
  - measure: running_dollar_total
    type: running_total
    description: This is a running total of dollar total.
    value_format: '[>=1000000]$0.00,,"M";[>=1000]$0.00,"K";$0.00'
    sql: ${sum_dollar_total}