| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) | 25 | FIXING_TIME | System Time of Commodity Price Adjustment | nvarchar | 6 | 0 | | |
TOPBack Office |
2 | TRFT_BUSTRANS | Treasury: TRF Business Transaction | 13 | FIXING_TIME | CFM: Fixing Time | nvarchar | 6 | 0 | | |
3 | TRFT_MAN_POST | Manual Posting | 18 | FIXING_TIME | CFM: Fixing Time | nvarchar | 6 | 0 | | |
4 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 52 | FIXING_TIME | CFM: Fixing Time | nvarchar | 6 | 0 | | |
5 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 52 | FIXING_TIME | CFM: Fixing Time | nvarchar | 6 | 0 | | |
TOPBasic Market Data |
6 | /BA1/TF4_REFRATE | Reference Interest Rates: Attributes | 16 | FIXING_TIME | Interest Rate Fixed At (UTC) | nvarchar | 6 | 0 | | |
TOPTransaction Management |
7 | TRCPAT | TR: Commodity Price Adjustment-Registration and Fixing | 22 | FIXING_TIME | System Time of Commodity Price Adjustment | nvarchar | 6 | 0 | | |
8 | TRIAT | Treasury: Int.Rate Adjust. - Registration and Int.Rate Adj. | 13 | FIXING_TIME | System Time of Interest Rate Adjustment | nvarchar | 6 | 0 | | |
9 | TRSPAT | TR: Security Price Adjustment - Registration and Fixing | 16 | FIXING_TIME | System Time of Security Price Adjustment | nvarchar | 6 | 0 | | |
TOPTransaction Manager |
10 | TCORT_CODCPA | Deal: Commodity Price Adjustment | 21 | FIXING_TIME | System Time of Commodity Price Adjustment | nvarchar | 6 | 0 | | |
11 | TCORT_CODSRA | Deal: Security Rate Adjustment | 20 | FIXING_TIME | System Time of Security Price Adjustment | nvarchar | 6 | 0 | | |