1. Cash Flow Engine Reference Guide
  2. Consolidation of Results
  3. Two Approaches to Consolidating Results
  4. Columns in the Result Detail Table
  5. Result Detail: Dimension Columns (Group-By)

4.3.1.1 Result Detail: Dimension Columns (Group-By)

Table 4-1 Dimension Columns of Result Detail table

Column Description
ALM Product Dimension Your ALM product (or Chart of Accounts) dimension as specified in Application Preferences
Common Chart of Account dimension Your Common Chart of Account dimension
Organization Unit dimension If results are consolidated to the entity level, this may be irrelevant
ISO Currency Code Currency in which results are held
Financial Element The dimension that gives meaning to the row of data in the table - for example, are the numbers in bucket_001-bucket _240 referring to ending balance, ending rate, average balance, and so on.
Scenario Number Results are stored by scenario number
Start Date Index Start Date 0 = Cash Flow Information and > = 1 are used for Gap results, Market Value results, and Dynamic Start Dates
Result Type Code Code describing the source of the record, current position, new business, or formula results. This column may be omitted in the group by statement if you do not want to maintain this distinction in your consolidated results.