coll_settlement_analysis

Edit Execute Back to List
Basic Information
Name:
coll_settlement_analysis
Description:
Detailed analysis of settlement cases
Source Table:
evolved_records
Status:
Active
Visibility:
Public
Tags:
category_collections settlement_analysis
Query Configuration
Dimensions:
  • coll_installment_type
  • coll_bom_bck_club
Metrics:
  • * () → settlement_count
  • coll_total_due () → total_due_amount
  • raw_data.settlement_amount () → settlement_amount
  • coll_settlement_discount () → avg_discount
  • coll_settlement_percentage () → avg_settlement_percentage
  • coll_commission_base_amount () → commission_base_total
Filters:
  • summary_data.category_code = COLLECTIONS
  • coll_special_case_type = SETTLEMENT
Recent Executions

No execution history available.

© SimSol Technologies and Services Private Limited