| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNV_40305_ANLA_B | Assets with semantically changing account determination | 7 | ANLAR | Asset types | nvarchar | 5 | 0 | | |
| 2 | HRPAYDEPBS_D_DNZ | Dest. Rep. Data: Suppl.Pens. "Business Complete" Information | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 3 | PDPBSZVADM_R | SPI Confirmation: Administration Table | 5 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| TOPBasic Functions |
| 4 | ANAR | Asset Types | 2 | ANLAR | Technical asset number | nvarchar | 8 | 0 | | |
| 5 | ANAT | Asset type text | 3 | ANLAR | Asset types | nvarchar | 5 | 0 | | |
| 6 | ANGA | Asset catalog general data | 7 | ANLAR | Asset types | nvarchar | 5 | 0 | | |
| 7 | ANLA | Asset Master Record Segment | 7 | ANLAR | Asset types | nvarchar | 5 | 0 | | |
| TOPCapital Investments |
| 8 | ANIA | Depr. simulation for invest. projects | 7 | ANLAR | Asset types | nvarchar | 5 | 0 | | |
| TOPGarnishmentCession |
| 9 | T5DRC | AVmG (BVV): Assignment Pay Scale to Contract Model | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| TOPGermany |
| 10 | PA0699 | Personnel Master Record Infotype 0699 | 24 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 11 | T5DR1 | AVmG: Investment Types | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 12 | T5DR2 | AVmG: Modules | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 13 | T5DR3 | AVmG: Contract Models | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 14 | T5DR4 | AVmG: Specifications of Modules | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 15 | T5DR5 | AVmG: Instances of Contract Models | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 16 | T5DR6 | AVmG: Processing Routines | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 17 | T5DR8 | AVmG: Processing Types | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 18 | T5DR9 | AVmG: Conversion Wage Type Groups | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 19 | T5DRA | AVmG: Assignment of Wage Types to Conversion Groups | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 20 | T5DRB | AVmG: Investment Institute | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 21 | T5DRD | AVmG: Permitted Modules for Contract Models | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 22 | T5DRU | AVmG: Texts for Conversion Wage Type Groups | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 23 | T5DRW | AVmG: Texts for Processing Routines | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 24 | T5DRX | AVmG: Texts for Contract Models | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 25 | T5DRY | AVmG: Texts for Modules | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 26 | T5DRZ | AVmG: Texts for Investment Types | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| TOPPublic Sector |
| 27 | PDPBSZVABM | Dereg. from Compulsory Insurance (Record Type 40), ZVE-PBS | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 28 | PDPBSZVABS | Periods (Record Type 60), ZVE-PBS | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 29 | PDPBSZVADM | Administration Table for ZVE-PBS Notification Procedure | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 30 | PDPBSZVADR | Address (Record Type 81), ZVE-PBS | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 31 | PDPBSZVANM | Reg. for Compulsory Insurance (Record Type 30), ZVE-PBS | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 32 | PDPBSZVDCARRIERS | ZVE-PBS Notification Procedure for Data Medium Admin. | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 33 | PDPBSZVDIF | Difference (Record Type 70), ZVE-PBS | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 34 | PDPBSZVLOG | Log Table for ZVE-PBS Notification Procedure | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 35 | PDPBSZVMDCARRS | Grouped Data Medium Administration, SP Reporting | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 36 | PDPBSZVNAM | Name (Record Type 80), ZVE-PBS | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 37 | PDPBSZVSUM | Totals Record (Record Type 90), SPI | 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 38 | T5D5I | Assgmt: Contract Model -> Ins. Feature for Voluntary Ins. | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 39 | T5DPBSZVAB | Temporal Validity of Deregistration Reasons | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 40 | T5DPBSZVABT | Valid Deregistration Reasons: Texts | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 41 | T5DPBSZVAG | Employer-Specific Settings | 7 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 42 | T5DPBSZVAV | Ring-Fencing of Supplementary Pension Institute | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 43 | T5DPBSZVAVT | Ring-Fencing of Supplementary Pension Institute | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 44 | T5DPBSZVPZ | Percentages and Contract Models | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 45 | T5DPBSZVPZT | Percentages and Contract Models: Text | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 46 | T5DPBSZVRZ | Data Center Information | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 47 | T5DPBSZVRZT | Data Center Information: Text | 3 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
| 48 | T5DPBSZVZVE | Supplementary Pension Institute | 2 | ANLAR | Investment Type | nvarchar | 4 | 0 | | |
