Tbl Cashier Cashout

view: tbl_cashier_cashout {
  sql_table_name: cashier.tbl_cashier_cashout ;;

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

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

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

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

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

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

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

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

  dimension: c_exchange_snap_shot_id {
    type: int
    sql: ${TABLE}.c_exchange_snap_shot_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_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_paid_amount {
    type: number
    sql: ${TABLE}.c_paid_amount ;;
  }

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

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

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

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

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

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

  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_txn_to_ecr_rate {
    type: number
    sql: ${TABLE}.c_txn_to_ecr_rate ;;
  }

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

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

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

  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 ;;
  }

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

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

  measure: count {
    type: count
  }
}

- view: tbl_cashier_cashout
  sql_table_name: cashier.tbl_cashier_cashout
  fields:
  - dimension: c_amount_in_ecr_ccy
    type: number
    sql: ${TABLE}.c_amount_in_ecr_ccy
  - dimension: c_card_id
    type: int
    sql: ${TABLE}.c_card_id
  - dimension: c_comments
    sql: ${TABLE}.c_comments
  - dimension: c_confirmed_option
    sql: ${TABLE}.c_confirmed_option
  - dimension: c_created_by
    sql: ${TABLE}.c_created_by
  - dimension: c_currency
    sql: ${TABLE}.c_currency
  - dimension: c_ecr_ccy
    sql: ${TABLE}.c_ecr_ccy
  - dimension: c_ecr_id
    type: int
    sql: ${TABLE}.c_ecr_id
  - dimension: c_exchange_snap_shot_id
    type: int
    sql: ${TABLE}.c_exchange_snap_shot_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_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_paid_amount
    type: number
    sql: ${TABLE}.c_paid_amount
  - dimension: c_partner_id
    sql: ${TABLE}.c_partner_id
  - dimension: c_preferred_option
    sql: ${TABLE}.c_preferred_option
  - dimension: c_processor_comments
    sql: ${TABLE}.c_processor_comments
  - dimension: c_processor_ref_id1
    sql: ${TABLE}.c_processor_ref_id1
  - dimension: c_processor_ref_id2
    sql: ${TABLE}.c_processor_ref_id2
  - dimension: c_reversed_amount
    type: number
    sql: ${TABLE}.c_reversed_amount
  - 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_txn_to_ecr_rate
    type: number
    sql: ${TABLE}.c_txn_to_ecr_rate
  - dimension: c_updated_by
    sql: ${TABLE}.c_updated_by
  - dimension: c_vrfn_by
    sql: ${TABLE}.c_vrfn_by
  - dimension: c_vrfn_comments
    sql: ${TABLE}.c_vrfn_comments
  - 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
  - dimension_group: c_vrfn
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.c_vrfn_time
  - measure: c_inhouse_amount
    type: sum
    sql: ${TABLE}.c_inhouse_amount/100
  - measure: count
    type: count