7.3.6.1 Multiple Attribute Average Balance Computation

Average Balance Computation PMF pipeline requires following Execution Parameters.

Parameter	Description
FIC_MIS_DATE	Business date for processing in YYYY-MM-DD format
EXECUTION_MODE	SINGLE_DAY or FULL_MONTH
DATA_SOURCE	Source system identifier
PRODUCT_PROCESSOR	Product Processor(s) included in execution
ABC_INPUT_FIELD	List of Source and Target Business Term mappings

Example Input JSON for list of Source and Target Business Term mappings

{
  "FIC_MIS_DATE": "2026-01-07",
  "DATA_SOURCE": "OTH",
  "PRODUCT_PROCESSOR": "LOANCONTRACTS,BORROWINGS",
  "ABC_INPUT_FIELD": [
    {
      "PRODUCT_PROCESSOR": "LOANCONTRACTS",
      "SOURCE_BUSINESS_TERM": "End of Period Balance",
      "TARGET_BUSINESS_TERM": "Average Balance Month Till Date"
    },
    {
      "PRODUCT_PROCESSOR": "LOANCONTRACTS",
      "SOURCE_BUSINESS_TERM": "End Of Period Book Balance",
      "TARGET_BUSINESS_TERM": "Average End Of Period Book Balance Month Till Date"
    },
    {
      "PRODUCT_PROCESSOR": "BORROWINGS",
      "SOURCE_BUSINESS_TERM": "End Of Period Principal Balance",
      "TARGET_BUSINESS_TERM": "Average End Of Period Principal Balance Month Till Date"
    }
  ]
}

Supported Source Business Terms

Any Business Term of type Monetary Amount for respective Product Processor – it gets validated during execution.

Note:

Each Source Business Term must be mapped independently to a unique Target Business Term. Target Business Terms are predefined and cannot be modified.

Supported Output Business Terms

Currently, following average balance attributes are supported.

Target Business Terms
Average Balance Month Till Date
Average Net Book Balance Month Till Date
Average End Of Period Book Balance Month Till Date
Average Acquired Gross Contractual Amount Month Till Date
Average Gross Book Balance Month Till Date
Average End Of Period Interest Amount Month Till Date
Average End Of Period Principal Balance Month Till Date
Average Lease Residual Unearned Income Month Till Date
Average Lease Unearned Income Month Till Date
Average Net Unearned Income Month Till Date
Average Residual Amount Month Till Date
Average Unearned Income Month Till Date

Supported Product Processors

Entity Name	Product Processor Code
Annuity Contracts	ANNUITYCONTRACTS
Bills Contracts	BILLCONTRACTS
Borrowings	BORROWINGS
Cards	CARDS
Commitment Contracts	COMMITMENTCONTRACTS
Correspondent Accounts	CORRESPONDENTACCOUNTS
Credit Derivatives	CREDITDERIVATIVES
CASA	CASA
Futures Contracts	FUTURESCONTRACTS
Investments	INVESTMENTS
Letter of Credit Contracts	LETTEROFCREDITCONTRACTS
Leases Contracts	LEASESCONTRACTS
Loan Contracts	LOANCONTRACTS
Merchant Cards	MERCHANTCARDS
Custodial Accounts	CUSTODIALACCOUNTS
Trusts	TRUSTS
Overdraft Accounts	OVERDRAFTACCOUNTS
Option Contracts	OPTIONCONTRACTS
Prepaid Cards	PREPAIDCARDS
Repo Contracts	REPOCONTRACTS
Term Deposit Contracts	TERMDEPOSITCONTRACTS

Note:

Product processor for the corresponding entity should be used as parameter for execution of this component.