| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBack Office |
1 | TRET_ENDOWMENT | Additional Fund/Grant Data for Endowments | 6 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
2 | TRST_NOM_CORR | Treasury: Nominal Adjustment | 6 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
3 | DFMCA_BRF860 | BRF: Check Relationship | 13 | SEC_ACCOUNT | BRF: Expression | nvarchar | 20 | 0 | | |
4 | DFMCA_BRF870 | BRF: Create/Update Relationship | 13 | SEC_ACCOUNT | BRF: Expression | nvarchar | 20 | 0 | | |
5 | DFMCA_COREL | Data Table for Relationship | 8 | SEC_ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
TOPRegulatory reporting for insurance companies |
6 | ISSRFLDEO | Object table 1 | 19 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
7 | ISSR_BASI_RG | Registrierungseintrag | 10 | SEC_ACCOUNT | Depot | nvarchar | 10 | 0 | | |
8 | ISSR_BASI_RGDONE | Erledigter Registrierungseintrag | 10 | SEC_ACCOUNT | Depot | nvarchar | 10 | 0 | | |
9 | ISSR_RPI_MFT | ISSR: Feste und variable Daten Meldewesen | 9 | SEC_ACCOUNT | Depot | nvarchar | 10 | 0 | | |
10 | ISSR_RPI_MFT_BCK | ISSR: Feste und variable Daten Meldewesen als Backuptabelle | 10 | SEC_ACCOUNT | Depot | nvarchar | 10 | 0 | | |
11 | TISSR_CHA_MD_PRO | Protokoll bei Stammdatenänderung | 17 | SEC_ACCOUNT | Depot | nvarchar | 10 | 0 | | |
TOPTransaction Manager |
12 | TCORT_COSA | Security Account Transfer: Main Data | 4 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
13 | TCORT_COSAFL | Security Account Transfer: Flows | 5 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
14 | TCORT_EXT_ASSIGN | Assignments of Profiles & BP groups to external recipients | 11 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
15 | TCORT_INT_ASSIGN | Assignments of Profiles & BP groups to internal recipients | 11 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
16 | TCORT_SAT_ACTVT | Correspondence Security account transfer activity assignment | 5 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
17 | TCORT_SAT_ALLBPG | (Obsolete) Allowed BP Groups for SAT Corresp. activities | 5 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
18 | TRGC_TAX | CFM: Derivation Rules for Tax Flows | 5 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
19 | TRXT_WT_ASSIGN | TRM Withholding Tax Information Assignment | 7 | SEC_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |