1. User Guide
  2. Overview of ALM BI Dashboards and Reports
  3. ALM Report Details
  4. Balance Sheet Account Detail in Consolidated Currency

8.7.22 Balance Sheet Account Detail in Consolidated Currency

Table 8-12 Balance Sheet Account Detail in Consolidated Currency

Report Name(s) Balance Sheet Account Detail Base Currency, Balance Sheet Account Detail Cons Currency
Description The report displays Current Book Balance, Current Par Balance, Market Value, Current Net Rate, YTM, and Modified Duration.
Dashboards Prompts

Prompt Balance Sheet Process

  • Process

Prompt Balance Sheet Date Currency

  • As of Date
  • Currency
Report Criteria

Productdim,

ifnull("Master Results"."Cur Book Balance",0.00), ifnull("Master Results"."Cur Par Balance",0.00), ifnull("Master Results"."Market Value",0.00), ifnull("Master Results"."Option Market Value (711)",0.00), "Master Results"."Cur Net Rate W", "Master Results"."Ytm W", "Master Results"."Modified Duration W", 'Amount in ' || "Currency"."Cons Currency", case when "Product"."Product Name Level19"='Total Liabilities + Capital' then 2 when "Product"."Product Name Level19"= 'Total Assets' then 1 when "Product"."Product Name Level19"='Off Balance Sheet Total' then 3 end
Conditions "Process Scenario"."Scenario Num" = 1,"Master Results"."Result Type Code" = 0
Compound Layout

Tittle

Table