| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T047F | Sorting of dunning letters | 2 | SAART | Record type 1=Master record 2=Items | nvarchar | 1 | 0 | | |
TOPGermany |
2 | TZ28T_UMS | Umsetzungstab Texte Gesetzesänderung BAV 2002 | 4 | SAART | Anlageart gemäß den Rechnungslegungsvorschriften | nvarchar | 6 | 0 | | |
3 | TZFUND | Zuordnung Gattung Fonds zur Zuführungsart BAV | 2 | SAART | Anlageart gemäß den Rechnungslegungsvorschriften | nvarchar | 6 | 0 | | |
4 | VZBAVV_AEND | variable BAV-Stammdaten - alte Zuführungsart | 23 | SAART | Anlageart gemäß den Rechnungslegungsvorschriften | nvarchar | 6 | 0 | | |
5 | VZBAVV_BCK | variable BAV-Stammdaten - alte Zuführungsart | 23 | SAART | Anlageart gemäß den Rechnungslegungsvorschriften | nvarchar | 6 | 0 | | |
TOPInformation System |
6 | DKKOP | Balance Audit Trail | 7 | SAART | Record Type for Accumulated Balance Audit Trail | nvarchar | 1 | 0 | | |
7 | DKKOS | Balance Audit Trail | 7 | SAART | Record Type for Accumulated Balance Audit Trail | nvarchar | 1 | 0 | | |
8 | DKOKS | Open Item Account Balance Audit Trail Master Record | 6 | SAART | Record Type for Accumulated Balance Audit Trail | nvarchar | 1 | 0 | | |
9 | DSKOP | Balance Audit Trail | 7 | SAART | Record Type for Accumulated Balance Audit Trail | nvarchar | 1 | 0 | | |
10 | DSKOS | Balance Audit Trail | 7 | SAART | Record Type for Accumulated Balance Audit Trail | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
11 | TNHCO | Basic Settings HCO | 10 | SAART | IS-H: Order Type for Collective Orders | nvarchar | 4 | 0 | | |
TOPPersonnel Management |
12 | /BKC/S21_RXTAB | C&T! - Description of cluster tables | 6 | SAART | Directory Record Type or Read Data for Pens.Stmt in PCL2(DB) | nvarchar | 2 | 0 | | |
TOPPublic Sector |
13 | T5D5E | Supplementary Pension Public Sector: Table of Notfctn Reason | 5 | SAART | Reason for Notification | nvarchar | 2 | 0 | | |
14 | T5D7SUM | Definition of Assignment of Statistics Rows to Totals Row | 2 | SAART | KHST: Record Type | nvarchar | 1 | 0 | | |
TOPRegulatory reporting for insurance companies |
15 | TISR1 | Asset Type According to Regulatory Accounting Requirements | 2 | SAART | Asset Type According to Regulatory Accounting Requirements | nvarchar | 6 | 0 | | |
TOPTreasury |
16 | TZ28 | Asset Type According to Regulatory Accounting Requirements | 3 | SAART | Asset Type According to Regulatory Accounting Requirements | nvarchar | 6 | 0 | | |
17 | TZ28T | Asset Type in acc. with Reg.Acctng Requirements / Text | 4 | SAART | Asset Type According to Regulatory Accounting Requirements | nvarchar | 6 | 0 | | |
18 | TZ39B | Relationship table indicator R5/97 append. 10 for prod. cat. | 2 | SAART | Asset Type According to Regulatory Accounting Requirements | nvarchar | 6 | 0 | | |
19 | TZ40 | Customizing regulatory reporting field control for contract | 8 | SAART | Asset Type According to Regulatory Accounting Requirements | nvarchar | 6 | 0 | | |
20 | VZBAVV | Variable BAV Master Data | 23 | SAART | Asset Type According to Regulatory Accounting Requirements | nvarchar | 6 | 0 | | |