| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Portfolio and Project Management | ||||||||||
| 1 | INM_GEN_SETTINGS | Table for General Settings for integration with RPM | 6 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||
| Transaction Manager | ||||||||||
| 2 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 167 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||
| 3 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 92 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||
| 4 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 91 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||
| 5 | VTBFHAPO | Transaction Flow | 167 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||
| 6 | VTBFHAPO_MIGR | Migrated Financial Flows | 167 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||
| 7 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 167 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||
| 8 | VTBFINKO | Transaction Condition | 92 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||
| 9 | VTIFINKO | Underlying transaction conditions | 91 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | ||