8.7.20 Detail Cash Flow or Activity in Consolidated Currency
Table 8-11 Detail Cash Flow or Activity in Consolidated Currency
| Report Name(s) | Detail Cash Flow Activity in Base Currency Detail Cash Flow Activity in Consolidated Currency |
|---|---|
| Description | Reporting against detail cash flow or Audit results, across time buckets. |
| Dashboards Prompts |
Prompt Financial Results 01
Prompt Financial Results with Product Leaf
|
| Report Criteria |
Calendar -ALM Results.As-of-Date Process Scenario.Process Name Process Scenario.Scenario Name Time Bucket.Start Date Time Bucket.End Date Standard Cash Flow Results.Beginning Balance (60) Standard Cash Flow Results"."Beginning Net Rate (80) Standard Cash Flow Results"."Reprice Balance (250) Standard Cash Flow Results"."Before Reprice Net Rate (280) Standard Cash Flow Results"."After Reprice Net Rate (290) Standard Cash Flow Results.Payment Runoff - Positive (190)+Standard Cash Flow Results.Maturity Runoff - Negative (197) Standard Cash Flow Results"."Maturity Runoff - Positive (195)"+"Standard Cash Flow Results"."Maturity Runoff - Negative (197) "Standard Cash Flow Results"."Prepay Runoff - Positive (180)"+"Standard Cash Flow Results"."Prepay Runoff - Negative (182)" Standard Cash Flow Results."Annual Prepay Rate (510)" ifnull("Standard Cash Flow Results"."Total Runoff - Positive (210)" , 0) + ifnull("Standard Cash Flow Results"."Total Runoff - Negative (212)" , 0) "Standard Cash Flow Results"."Total Runoff Net Rate (230)" "Standard Cash Flow Results"."Interest Cash Flow (430)" "Standard Cash Flow Results"."Interest Credited (480)" "Standard Cash Flow Results"."Total Runoff - Positive (210)"+"Standard Cash Flow Results"."Total Runoff - Negative (212)"+"Standard Cash Flow Results"."Interest Cash Flow (430)"+"Standard Cash Flow Results"."Interest Credited (480)" "Standard Cash Flow Results"."Interest Accrued (440)" "Standard Cash Flow Results"."Deferred Runoff (540)" "Standard Cash Flow Results"."New Add Balance (340)" "Standard Cash Flow Results"."New Add Net Rate (360)" "Standard Cash Flow Results"."Roll Add Balance (380)" "Standard Cash Flow Results"."Roll Add Net Rate (400)" "Standard Cash Flow Results"."New Add Balance (340)"+"Standard Cash Flow Results"."Roll Add Balance (380)" "Standard Cash Flow Results"."End Balance (100)" "Standard Cash Flow Results"."Ending Net Rate (120)" "Standard Cash Flow Results"."Fully Indexed Net Rate (330)" "Standard Cash Flow Results"."Average Balance (140)" "Standard Cash Flow Results"."Avg Net Rate (160)" "Standard Cash Flow Results"."Warm (500)" "Standard Cash Flow Results"."Interest Accrued Net (441)" "Standard Cash Flow Results"."Non Interest Expense (457)" "Standard Cash Flow Results"."Balance Before Prepay (515)" Currency.Currency Cd |
| Conditions | BOTTOMN("Time Buckets"."End Date",12) <= 12 |
| Compound Layout | Title Pivot Table |