D.10 Selecting Rows from Detail Tables
When reading a column from a detailed table (an Instrument table or a Transaction Summary table), the allocation engine decides whether or not it needs to translate a value based on the column's Column Property characteristic.
- If a column's Column Property is Balance, then the value is translated to the Functional Currency.
- If a column's Column Property is anything OTHER than Balance, then the value is NOT translated (that is, the value has no currency-specific basis).
For detail level columns, OFSAA Infrastructure supports the following Column Properties:
Table D-1 Column Properties in Transaction Summary Table
| Property | Description |
|---|---|
| BALANCE | Monetary balance |
| CHAR | Fixed-length alpha-numeric data |
| CODE | Defined Alpha or Numeric Code Value |
| CODE_NUM | Undefined Numeric Code Value |
| DATE | Date value |
| FLAG | True/False value |
| FREQ | A recurring period |
| LEAF | Leaf column |
| IDENTITY | Reserved |
| ID_NUMBER | Reserved |
| MULT | Multiplier |
| NUMBER | Numeric Value |
| NUMERIC | Numeric Value |
| RATE | Interest rate |
| TERM | Non-recurring period |
| VARCHAR2 | Variable-length alpha-numeric value |
| PCT | Percent |
| DEFAULT | Default Datatype |
You may execute the following query to see the Column Property for any column in an Instrument or Transaction Summary table:
SELECT TABLE_NAME,
COLUMN_NAME,
A.REV_DATA_TYPE_CD,
B.REV_DATA_TYPE,
B.DESCRIPTION
FROM REV_TAB_COLUMNS A, FSI_DATA_TYPE_DESC B
WHERE TABLE_NAME = <Insert table name here>
AND A.REV_DATA_TYPE_CD = B.REV_DATA_TYPE_CD
ORDER BY 1, 3, 2;