Intra-Bank Fee Detail Chart

Analyzes intra-bank fee data to generate chart-ready data showing potential savings. The function compares actual charges against minimum rates to identify cost-saving opportunities across different bank services.

Technical Name: IntraBankFeeDetailChartFunc

Properties

Execution Mode: SYNC
Type: NATIVE
Category: System Functions
Function ID: 66e31772-bde2-4a8f-801d-c215b5cdc325

Input Schema

Required Parameters

Parameter	Type	Description
`data`	object	Report configuration object (MReportMaster) containing query with bank service fee data

The report query should include the following fields:

bank_service_description - Name/description of the bank service
unit_price - Unit price/rate for the service
volume - Transaction volume
total_charges - Total charges for the service
forex_rate - Foreign exchange rate (if applicable)

[Image placeholder: IntraBankFeeDetailChart function configuration panel]

Input Example

{
  "data": {
    "reportConfig": {
      "query": {
        "selectFields": [
          {
            "fieldName": "bank_service_description",
            "fieldAlias": "Service"
          },
          {
            "fieldName": "unit_price",
            "fieldAlias": "Unit Price"
          },
          {
            "fieldName": "volume",
            "fieldAlias": "Volume"
          },
          {
            "fieldName": "total_charges",
            "fieldAlias": "Total Charges"
          },
          {
            "fieldName": "forex_rate",
            "fieldAlias": "Forex Rate"
          }
        ],
        "fromClause": {
          "mobjectId": "bank-fee-mobject-uuid"
        }
      }
    }
  }
}

Output Schema

Field	Type	Description
`result`	array	Array of chart data objects, each containing service name and unit price values

Each object in the result array contains:

Service - Bank service description
val1, val2, val3, ... - Unit price values (number of columns varies based on distinct prices)

Output Example

{
  "result": [
    {
      "Service": "Wire Transfer",
      "val1": 0.25,
      "val2": 0.30,
      "val3": 0.35,
      "val4": 0
    },
    {
      "Service": "ACH Transfer",
      "val1": 0.10,
      "val2": 0.15,
      "val3": 0
    }
  ]
}

[Image placeholder: Chart visualization example]

How It Works

The function performs the following analysis:

Groups by Service: Groups fee data by bank service description
Finds Min/Max Rates: Identifies minimum and maximum unit prices for each service
Calculates Savings: Compares actual charges against charges at minimum rate:
```
savings = total_charges - (forex_rate × volume × min_rate)
```
Filters Results: Only includes services where savings > 1
Formats for Charts: Structures data with service names and unit price columns for easy charting

Use Cases

Fee Analysis Dashboard

Generate chart data for visualizing fee variations across bank services:

{
  "data": {
    "reportConfig": {
      "query": {
        "selectFields": [
          {"fieldName": "bank_service_description", "fieldAlias": "Service"},
          {"fieldName": "unit_price", "fieldAlias": "Rate"},
          {"fieldName": "volume", "fieldAlias": "Volume"},
          {"fieldName": "total_charges", "fieldAlias": "Charges"},
          {"fieldName": "forex_rate", "fieldAlias": "Forex"}
        ],
        "fromClause": {
          "mobjectId": "bank-fee-mobject-uuid"
        },
        "where": [
          {
            "field": "transaction_date",
            "operator": "greaterThanOrEquals",
            "value": "2024-01-01"
          }
        ]
      }
    }
  }
}

Cost Optimization Analysis

Identify services with the highest potential savings:

Start → FetchMData(Bank Fees) → IntraBankFeeDetailChart → Visualize → End

[Image placeholder: Workflow example]

ECR Analysis - Analyze ECR data for financial insights
Export Data to CSV - Export chart data for further analysis

Intra-Bank Fee Detail Chart

On this page