| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) | 24 | FIXING_DATE | System Date of Commodity Price Adjustment | nvarchar | 8 | 0 | | |
TOPBack Office |
2 | TRFT_BUSTRANS | Treasury: TRF Business Transaction | 12 | FIXING_DATE | CFM: Fixing Date | nvarchar | 8 | 0 | | |
3 | TRFT_MAN_POST | Manual Posting | 17 | FIXING_DATE | CFM: Fixing Date | nvarchar | 8 | 0 | | |
4 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 51 | FIXING_DATE | CFM: Fixing Date | nvarchar | 8 | 0 | | |
5 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 51 | FIXING_DATE | CFM: Fixing Date | nvarchar | 8 | 0 | | |
TOPBank Customer Accounts |
6 | BKKTERM | Term Agreement for Fixed-Term Deposit and Installmt Savings | 24 | FIXING_DATE | Condition Fixing Date for Fixed-Term Deposit Account | nvarchar | 8 | 0 | | |
TOPTransaction Management |
7 | TCHT_HD_BEWEG_CY | SFGDT Commodity Flows Table | 6 | FIXING_DATE | Interest rate fixing date | nvarchar | 8 | 0 | | |
8 | TRCPAT | TR: Commodity Price Adjustment-Registration and Fixing | 21 | FIXING_DATE | System Date of Commodity Price Adjustment | nvarchar | 8 | 0 | | |
9 | TRIAT | Treasury: Int.Rate Adjust. - Registration and Int.Rate Adj. | 12 | FIXING_DATE | System Date of Interest Rate Adjustment | nvarchar | 8 | 0 | | |
10 | TRSPAT | TR: Security Price Adjustment - Registration and Fixing | 15 | FIXING_DATE | System Date of Security Price Adjustment | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
11 | TCORT_CODCPA | Deal: Commodity Price Adjustment | 20 | FIXING_DATE | System Date of Commodity Price Adjustment | nvarchar | 8 | 0 | | |
12 | TCORT_CODMD | Deal: Main Data | 163 | FIXING_DATE | Fixing date | nvarchar | 8 | 0 | | |
13 | TCORT_CODSRA | Deal: Security Rate Adjustment | 19 | FIXING_DATE | System Date of Security Price Adjustment | nvarchar | 8 | 0 | | |