| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FTBB_YC_REF_ENT | Attributes of Reference Entity | 5 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
2 | TRCCT_TRANS | Currency Changeover Transaction | 11 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
3 | TREAT_FUT_DIFF | Treasury: TREA Differentiation for Deal Position | 4 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
TOPBack Office |
4 | TRET_POOL | Additional Pool Data for Fund | 7 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
5 | TRET_SEC_POOL | Additional Pool Data for Security | 2 | SECURITY_ID | Investment Pool ID Number | nvarchar | 13 | 0 | | |
6 | TRFT_MATCH_TRANS | Treasury: Matching Process Business Transaction | 8 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
7 | TRST_CLASPOS | Treasury: Class position in Securities Account | 5 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
8 | TRST_NOM_CORR | Treasury: Nominal Adjustment | 5 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
9 | TRST_RECON_POS | Reconciliation Positions | 4 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
10 | TRST_SECACCTRANS | Treasury: Securities Account Transfer | 8 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
TOPInformation System |
11 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 10 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
TOPProvisions for Awards |
12 | ACE_SOP_SCRT_SEC | Hypothetical Security Price Performance for Simulation | 3 | SECURITY_ID | Security Identification Number | nvarchar | 13 | 0 | | |
TOPTransaction Management |
13 | THXT_MD_PV | market data present value | 7 | SECURITY_ID | Treasury ID number | nvarchar | 13 | 0 | | |
14 | THXT_MD_SEC | market data securities price | 3 | SECURITY_ID | Treasury ID number | nvarchar | 13 | 0 | | |
TOPTransaction Manager |
15 | /TRMKR/SEC_DATA | FWZZ Master Data Additional Fields | 2 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
16 | BCKTCAT_FLOW | BACKUP: Flow Table of Capital Actions | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
17 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
18 | DIFT_POS_IDENT | Persistent Flow Selectors | 13 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
19 | FDC1 | Cash Management Shadow table | 12 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
20 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
21 | IDCFM_FRIM_DATA | Impairment Main Data | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
22 | IDCFM_FRIM_DEXP | Impairment: BAdI Example Values: Expected & Expert Values | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
23 | MIGC_COM_VALCLS | Derive General Valuation Class for Migration to CFM 1.0 | 3 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
24 | POGT_POS_GUARD | Lock Objects | 27 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
25 | RDPT_FACTOR2 | Treasury: Drawing Factor | 2 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
26 | RDPT_FACTOR_HDR2 | Treasury: Drawing Factors Header | 2 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
27 | RDPT_SET | Quantity of Redemption Schedules | 3 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
28 | SLDT_FLOW | Subledger Distributor Transactions | 14 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
29 | TCAT_FLOW | Flow Table of the Corporate Actions | 9 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
30 | TCORT_CODMD | Deal: Main Data | 67 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
31 | TCORT_COSAFL | Security Account Transfer: Flows | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
32 | TCORT_COSAPO | Security Account Transfer: Positions | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
33 | TCORT_SI_DERIVE | Settlement Instructions: Derivation table | 7 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
34 | TERT_FLOW | Flow Table for Rights that can be Exercised | 9 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
35 | TERT_TRANSACTION | Business Transaction: Exercise of Rights | 4 | SECURITY_ID | ID number of exercised securities right | nvarchar | 13 | 0 | | |
36 | TPM_MIG_LOT_MIXD | CFM: (Mig) ID Nos. by Coll. Pos. Man -> Corrspnd. PA by Lot | 5 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
37 | TRCT_FLOW | Table of business transactions flows | 10 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
38 | TRDTT_DATA_ADMIN | Legacy Data Transfer Admin. Entries Business Transactions | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
39 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 5 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
40 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
41 | TRDTT_POS_ADMIN | Legacy Data Transfer Admin. Entries Subledger Positions | 5 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
42 | TRDTT_POS_SEC | Position Information for Securities | 5 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
43 | TRDTT_VADATA_FUT | Valuation-Area-Dependent Data for Futures | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
44 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
45 | TRDT_FLOW | Persistent distributor flows | 12 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
46 | TRGT_MIGPS_SEC | Assignment of PS Account Assignments to Securities Positions | 3 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
47 | TRGT_MIGR_PMP | Conversion: Assign to Parallel Position Mangmnt Procedures | 3 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
48 | TRLIT_AD_MIGRATE | Accrual/Deferral: Log Data of Migration to EP 2: | 5 | SECURITY_ID | Contract Number | nvarchar | 13 | 0 | | |
49 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 13 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
50 | TWSPV | Security Prices for Special Valuation | 4 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
51 | VWPCSPREAD | Credit Spread per Security | 2 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
TOPTransfer to Financial Accounting |
52 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 7 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
53 | TRACT_QUEUE | Resubmission for Reversal | 8 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
54 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
55 | TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions | 7 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
56 | TRLT_INIT_TRANS | List of Initializing Business Transactions | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
57 | TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
58 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 7 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |
59 | VALT_SP_VAL_SEC | Security Prices and NPV for Special Valuation | 6 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | |