| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TLRT_THM_RES_POS | Threshold Result Position Data | 4 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
2 | TRCCT_TRANS | Currency Changeover Transaction | 13 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
3 | TREAT_STATEM_ITM | Clearing Account Statement Detail | 9 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
TOPBack Office |
4 | TRFT_MAN_POST | Manual Posting | 15 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
TOPInformation System |
5 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 12 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
TOPTransaction Management |
6 | FTR_TIER_LEVEL | Tier Level | 3 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
7 | THXT_MD_PV | market data present value | 5 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
8 | VTBCSPREAD | Credit Spread per OTC Transaction | 3 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
9 | VTB_ASGN_RELAT | FTR Assignment Management: Assignment Object | 7 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
TOPTransaction Manager |
10 | DIFT_POS_IDENT | Persistent Flow Selectors | 21 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
11 | FDC1 | Cash Management Shadow table | 14 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
12 | POGT_POS_GUARD | Lock Objects | 35 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
13 | SLDT_FLOW | Subledger Distributor Transactions | 20 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
14 | SLDT_TRANSACTION | Subledger Distributor Business Transactions | 25 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
15 | TCORT_CODCO | Deal: Conditions | 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
16 | TCORT_CODCOFO | Deal: Condition's Formula | 6 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
17 | TCORT_CODCPA | Deal: Commodity Price Adjustment | 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
18 | TCORT_CODFL | Deal: Flows | 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
19 | TCORT_CODIA | Deal: Interest Rate Adjustment | 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
20 | TCORT_CODMD | Deal: Main Data | 4 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
21 | TCORT_CODPI | Deal: Payment Information | 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
22 | TCORT_CODSRA | Deal: Security Rate Adjustment | 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
23 | TCORT_CODUL | Deal: Underlying | 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
24 | TCORT_CODUL2 | Deal: 2nd Underlying | 6 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
25 | TCORT_CODUL2FL | Deal: 2nd Underlying's Flows | 7 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
26 | TCORT_CODULCO | Deal : Underlying's Conditions | 6 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
27 | TCORT_CODULCOFO | Deal: Underlying's Formula | 7 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
28 | TCORT_CODULFL | Deal: Underlying Flows | 6 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | |
29 | THAHRT_EFF_HEAD | Effectiveness test result header | 5 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
30 | TRDTT_DATA_ADMIN | Legacy Data Transfer Admin. Entries Business Transactions | 9 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
31 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 26 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
32 | TRDTT_POS_ADMIN | Legacy Data Transfer Admin. Entries Subledger Positions | 8 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
33 | TRDTT_VADATA_FUT | Valuation-Area-Dependent Data for Futures | 21 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
34 | TRDTT_VADATA_OTC | Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. | 6 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
35 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 66 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
36 | TRDTT_VAD_FUTSUB | Valuation Area-Dependent Data for Futures with Subpositions | 17 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
37 | TRDTT_VAD_SECSUB | Valuation Area-Dependent Data for Securities w. Subpositions | 53 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
38 | TRDT_FLOW | Persistent distributor flows | 18 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
39 | TRDT_TRDBUSTRANS | Treasury: Persistent distributor business transaction | 26 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
40 | TRGT_KEY_ASSGN | Table for Persistent Class CL_KEY_ASSIGNMENT_TRG | 4 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
41 | TRGT_MIGPS_OTC | Assignment of PS Account Assignments to Transactions | 3 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
42 | TRLIT_AD_MIGRATE | Accrual/Deferral: Log Data of Migration to EP 2: | 4 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
43 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 39 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
44 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 26 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
45 | VWKMPO | Corporate actions (items) | 18 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
TOPTransfer to Financial Accounting |
46 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 12 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
47 | TRACT_DOCUMENT | Treasury: Accounting Adaptor Document | 26 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
48 | TRACT_QUEUE | Resubmission for Reversal | 12 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |
TOPTreasury and Risk Management |
49 | TREAT_FHA_DIFF | Treasury: TREA Differentiation for Deal Position | 4 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | |