| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TRCCT_TRANS | Currency Changeover Transaction | 12 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
TOPBack Office |
2 | TRST_CLASPOS | Treasury: Class position in Securities Account | 4 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
3 | TRST_RECON_RCE | Treasury: External Securities Account Statement | 4 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
4 | TRST_SECACC_BANK | Payment Details for Securities Account | 3 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
TOPInformation System |
5 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 15 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
TOPRegulatory reporting for insurance companies |
6 | ISSRPREFLOW | ISSR: Basistabelle/Bewegungstabelle | 13 | SECURITY_ACCOUNT | Deposito | nvarchar | 10 | 0 | | |
TOPTransaction Management |
7 | THXT_MD_PV | market data present value | 8 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
TOPTransaction Manager |
8 | BCKTCAT_FLOW | BACKUP: Flow Table of Capital Actions | 7 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
9 | BCKTERT_FLOW | BACKUP: Flow Table for Executable Rights | 7 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
10 | DIFT_POS_IDENT | Persistent Flow Selectors | 12 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
11 | FDC1 | Cash Management Shadow table | 11 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
12 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 7 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
13 | IDCFM_FRAM_DICRI | Assignment of Alternative Position Management Procedure | 10 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
14 | IDCFM_FRIM_DATA | Impairment Main Data | 5 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
15 | IDCFM_FRIM_DEXP | Impairment: BAdI Example Values: Expected & Expert Values | 5 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
16 | IDCFM_RF_POSEC | Tax Security Account | 4 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
17 | MIGC_COM_VALCLS | Derive General Valuation Class for Migration to CFM 1.0 | 4 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
18 | POGT_POS_GUARD | Lock Objects | 26 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
19 | SLDT_FLOW | Subledger Distributor Transactions | 15 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
20 | TCAT_FLOW | Flow Table of the Corporate Actions | 10 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
21 | TCORT_CODMD | Deal: Main Data | 66 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
22 | TERT_FLOW | Flow Table for Rights that can be Exercised | 10 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
23 | TERT_TRANSACTION | Business Transaction: Exercise of Rights | 5 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
24 | TPM_MIG_LOT_MIXD | CFM: (Mig) ID Nos. by Coll. Pos. Man -> Corrspnd. PA by Lot | 4 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
25 | TRCT_FLOW | Table of business transactions flows | 9 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
26 | TRDTT_DATA_ADMIN | Legacy Data Transfer Admin. Entries Business Transactions | 7 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
27 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 6 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
28 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 7 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
29 | TRDTT_POS_ADMIN | Legacy Data Transfer Admin. Entries Subledger Positions | 6 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
30 | TRDTT_POS_SEC | Position Information for Securities | 6 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
31 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 7 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
32 | TRDT_FLOW | Persistent distributor flows | 13 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
33 | TRGC_PM_PROC_ASS | Assignment of Position Management Procedure | 10 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
34 | TRGT_MIGPS_SEC | Assignment of PS Account Assignments to Securities Positions | 4 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
35 | TRGT_MIGR_PMP | Conversion: Assign to Parallel Position Mangmnt Procedures | 4 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
36 | TRLIT_AD_MIGRATE | Accrual/Deferral: Log Data of Migration to EP 2: | 6 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
37 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 14 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
38 | TRQT_INIT_LOT | (obsolete) | 4 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
39 | TWSPV | Security Prices for Special Valuation | 3 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
TOPTransfer to Financial Accounting |
40 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 6 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
41 | TRACT_QUEUE | Resubmission for Reversal | 9 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
42 | TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions | 9 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
43 | TRLT_INIT_TRANS | List of Initializing Business Transactions | 7 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
44 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 9 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
45 | VALT_SP_VAL_SEC | Security Prices and NPV for Special Valuation | 5 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |