Tbl Real Fund Txn

view: tbl_real_fund_txn {
  sql_table_name: fund.tbl_real_fund_txn ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: c_current_balance {
    type: sum
    sql: ${TABLE}.c_current_balance ;;
  }

  measure: c_prev_balance {
    type: sum
    sql: ${TABLE}.c_prev_balance ;;
  }

  measure: count {
    type: count
    drill_fields: [c_agent_name]
  }

  measure: c_eod_balance {
    type: sum
    sql: IFNULL(${TABLE}.c_amount_in_ecr_ccy,0)*${tbl_real_fund_txn_type_mst.c_ecr_pl} ;;
  }
}

- view: tbl_real_fund_txn
  sql_table_name: fund.tbl_real_fund_txn
  fields:
  - dimension: c_agent_name
    sql: ${TABLE}.c_agent_name
  - dimension: c_cancel_txn_id
    type: int
    sql: ${TABLE}.c_cancel_txn_id
  - dimension: c_channel
    sql: ${TABLE}.c_channel
  - dimension: c_comments
    sql: ${TABLE}.c_comments
  - dimension: c_ecr_ccy
    sql: ${TABLE}.c_ecr_ccy
  - dimension: c_ecr_id
    type: int
    sql: ${TABLE}.c_ecr_id
  - dimension: c_error_code
    sql: ${TABLE}.c_error_code
  - dimension: c_error_desc
    sql: ${TABLE}.c_error_desc
  - dimension: c_game_type
    type: int
    sql: ${TABLE}.c_game_type
  - dimension: c_id
    type: int
    sql: ${TABLE}.c_id
  - dimension: c_initiator_ref_id
    sql: ${TABLE}.c_initiator_ref_id
  - dimension: c_label_id
    sql: ${TABLE}.c_label_id
  - dimension: c_op_type
    sql: ${TABLE}.c_op_type
  - dimension: c_os_browser_type
    sql: ${TABLE}.c_os_browser_type
  - dimension: c_partner_id
    sql: ${TABLE}.c_partner_id
  - dimension: c_product_id
    sql: ${TABLE}.c_product_id
  - dimension: c_session_id
    type: int
    sql: ${TABLE}.c_session_id
  - dimension: c_sub_channel
    sql: ${TABLE}.c_sub_channel
  - dimension: c_sub_funds_order
    sql: ${TABLE}.c_sub_funds_order
  - dimension: c_sub_product_id
    sql: ${TABLE}.c_sub_product_id
  - dimension: c_txn_id
    type: int
    sql: ${TABLE}.c_txn_id
  - dimension: c_txn_status
    sql: ${TABLE}.c_txn_status
  - dimension: c_txn_type
    type: int
    sql: ${TABLE}.c_txn_type
  - dimension: c_updated_by
    sql: ${TABLE}.c_updated_by
  - dimension_group: c_start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.c_start_time
  - dimension_group: c_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.c_updated_time
  - measure: c_amount_in_ecr_ccy
    type: sum
    sql: ${TABLE}.c_amount_in_ecr_ccy/100
  - measure: c_current_balance
    type: sum
    sql: ${TABLE}.c_current_balance
  - measure: c_prev_balance
    type: sum
    sql: ${TABLE}.c_prev_balance
  - measure: count
    type: count
    drill_fields:
    - c_agent_name
  - measure: c_eod_balance
    type: sum
    sql: IFNULL(${TABLE}.c_amount_in_ecr_ccy,0)*${tbl_real_fund_txn_type_mst.c_ecr_pl}