| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TRCPAT2 | TR: Commodity Price Adjustment-Registration and Fixing (DCS) | 5 | CASHFLOW_ID | Cash Flow ID | nvarchar | 4 | 0 | | |
TOPTransaction Management |
2 | TRCPAT | TR: Commodity Price Adjustment-Registration and Fixing | 4 | CASHFLOW_ID | Cash Flow ID | nvarchar | 4 | 0 | | |
3 | TRIAT | Treasury: Int.Rate Adjust. - Registration and Int.Rate Adj. | 4 | CASHFLOW_ID | Cash flow ID | nvarchar | 4 | 0 | | |
4 | TRSPAT | TR: Security Price Adjustment - Registration and Fixing | 4 | CASHFLOW_ID | Cash flow ID | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
5 | FTR_AVG_ASGN | Assign one flow to many adjustments for average | 8 | CASHFLOW_ID | Cash Flow ID | nvarchar | 4 | 0 | | |
6 | TCORT_CODCPA | Deal: Commodity Price Adjustment | 8 | CASHFLOW_ID | Cash Flow ID | nvarchar | 4 | 0 | | |
7 | TCORT_CODIA | Deal: Interest Rate Adjustment | 8 | CASHFLOW_ID | Cash flow ID | nvarchar | 4 | 0 | | |
8 | TCORT_CODSRA | Deal: Security Rate Adjustment | 8 | CASHFLOW_ID | Cash flow ID | nvarchar | 4 | 0 | | |