Tbl Cashier Deposit

view: tbl_cashier_deposit {
  sql_table_name: cashier.tbl_cashier_deposit ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }

  measure: unq_count_ecr {
    type: count_distinct
    drill_fields: [c_ecr_id, tbl_ecr.c_email_id]
    sql: c_ecr_id ;;
  }

  measure: cb_amount {
    type: sum
    sql: ${TABLE}.c_cb_amount/100 ;;
  }

  measure: initial_amount {
    type: sum
    sql: ${TABLE}.c_initial_amount/100 ;;
  }

  measure: confirmed_amount {
    type: sum
    sql: ${TABLE}.c_confirmed_amount/100 ;;
  }

  measure: credited_amount {
    type: sum
    drill_fields: [c_ecr_id, c_credited_amount, c_update]
    sql: ${TABLE}.c_credited_amount/100 ;;
  }
}

- view: tbl_cashier_deposit
  sql_table_name: cashier.tbl_cashier_deposit
  fields:
  - dimension: c_bonus_code
    sql: ${TABLE}.c_bonus_code
  - dimension: c_cb_amount
    type: number
    sql: ${TABLE}.c_cb_amount
  - dimension: c_cb_amount_in_ecr_ccy
    type: number
    sql: ${TABLE}.c_cb_amount_in_ecr_ccy
  - dimension: c_cb_ref_id
    sql: ${TABLE}.c_cb_ref_id
  - dimension: c_comments
    sql: ${TABLE}.c_comments
  - dimension: c_confirmed_amount
    type: number
    sql: ${TABLE}.c_confirmed_amount
  - dimension: c_created_by
    sql: ${TABLE}.c_created_by
  - dimension: c_credited_amount
    type: number
    sql: ${TABLE}.c_credited_amount
  - dimension: c_credited_amount_in_ecr_ccy
    type: number
    sql: ${TABLE}.c_credited_amount_in_ecr_ccy
  - dimension: c_currency
    sql: ${TABLE}.c_currency
  - dimension: c_ecr_currency
    sql: ${TABLE}.c_ecr_currency
  - dimension: c_ecr_id
    type: int
    sql: ${TABLE}.c_ecr_id
  - dimension: c_external_error_code
    sql: ${TABLE}.c_external_error_code
  - dimension: c_external_error_comments
    sql: ${TABLE}.c_external_error_comments
  - dimension: c_inhouse_amount
    type: number
    sql: ${TABLE}.c_inhouse_amount
  - dimension: c_inhouse_currency
    sql: ${TABLE}.c_inhouse_currency
  - dimension: c_initial_amount
    type: number
    sql: ${TABLE}.c_initial_amount
  - dimension: c_instrument_id
    type: int
    sql: ${TABLE}.c_instrument_id
  - dimension: c_internal_error_code
    sql: ${TABLE}.c_internal_error_code
  - dimension: c_label_id
    sql: ${TABLE}.c_label_id
  - dimension: c_option
    sql: ${TABLE}.c_option
  - dimension: c_partner_id
    sql: ${TABLE}.c_partner_id
  - dimension: c_processor_ref_id
    sql: ${TABLE}.c_processor_ref_id
  - dimension: c_txn_id
    type: int
    sql: ${TABLE}.c_txn_id
  - dimension: c_txn_kind
    sql: ${TABLE}.c_txn_kind
  - dimension: c_txn_status
    sql: ${TABLE}.c_txn_status
  - dimension: c_unconfirmed_amount
    type: number
    sql: ${TABLE}.c_unconfirmed_amount
  - dimension: c_updated_by
    sql: ${TABLE}.c_updated_by
  - dimension: c_wallet_ref_id
    sql: ${TABLE}.c_wallet_ref_id
  - dimension_group: c_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.c_created_time
  - dimension_group: c_update
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.c_update_time
  - measure: count
    type: count
  - measure: unq_count_ecr
    type: count_distinct
    drill_fields:
    - c_ecr_id
    - tbl_ecr.c_email_id
    sql: c_ecr_id
  - measure: cb_amount
    type: sum
    sql: ${TABLE}.c_cb_amount/100
  - measure: initial_amount
    type: sum
    sql: ${TABLE}.c_initial_amount/100
  - measure: confirmed_amount
    type: sum
    sql: ${TABLE}.c_confirmed_amount/100
  - measure: credited_amount
    type: sum
    drill_fields:
    - c_ecr_id
    - c_credited_amount
    - c_update
    sql: ${TABLE}.c_credited_amount/100