8.7.95 Detail Cash Flows
Table 8-90 Detail Cash Flows
Report Name | Audit - Detail Cash Flows |
---|---|
Description | This report displays the results from the detail cash flow - audit table. |
Dashboards Prompts |
Prompt - Process Cash Flow 1
Prompt - Process Cash Flow
|
Report Criteria |
Process Scenario."Process Name" Process Cash Flows Master."Id Number" Product."Product Leaf Name" Process Cash Flows Master."Cashflow Date" Process Cash Flows Details."End Balance" Process Cash Flows Details."Ending Gross Rate"/"Process Cash Flows Details"."End Balance"*100 Process Cash Flows Details."Ending Net Rate"/"Process Cash Flows Details"."End Balance"*100 Process Cash Flows Details."Ending Transfer Rate"/"Process Cash Flows Details"."End Balance"*100 Process Cash Flows Details."Prepay Runoff - Positive" Process Cash Flows Details."Payment Runoff - Positive" Process Cash Flows Details."Maturity Runoff - Positive" Process Cash Flows Details."Total Runoff - Positive" Process Cash Flows Details."Total Runoff Gross Rate"/"Process Cash Flows Details"."Total Runoff - Positive"*100 Process Cash Flows Details."Total Runoff Net Rate"/"Process Cash Flows Details"."Total Runoff - Positive"*100 Process Cash Flows Details."Total Runoff Transfer Rate"/"Process Cash Flows Details"."Total Runoff - Positive"*100 Process Cash Flows Details."Repricing Balance" Process Cash Flows Details."Before Repricing Gross Rate"/"Process Cash Flows Details"."Repricing Balance"*100 Process Cash Flows Details."After Repricing Gross Rate" Process Cash Flows Details."Before Repricing Net Rate"/"Process Cash Flows Details"."Repricing Balance"*100 Process Cash Flows Details."After Repricing Net Rate"/"Process Cash Flows Details"."Repricing Balance"*100 Process Cash Flows Details."Fully Indexed Gross Rate"/"Process Cash Flows Details"."Repricing Balance"*100 Process Cash Flows Details."Fully Indexed Net Rate"/"Process Cash Flows Details"."Repricing Balance"*100 Process Cash Flows Details."Interest Cash Flow" Process Cash Flows Details."Interest Cash Flow Gross" Process Cash Flows Details."Discount Rate" Process Cash Flows Details."Annual Prepayment Rate"/"Process Cash Flows Details"."Balance Before Prepay"*100 Process Cash Flows Details."Balance Before Prepay" Process Cash Flows Details."Market Value" Process Cash Flows Details.Duration/"Process Cash Flows Details"."Market Value" "Process Cash Flows Details"."Inflation Adjustment to Interest (179)" "Process Cash Flows Details"."Inflation Adjustment to Principal (178)" "Process Cash Flows Details"."Index Factor (194)" |
Conditions | < None > |
Compound Layout |
Title Pivot Table |