| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RD_ST | Payroll Result: Tax (G) | 41 | GMDNR | Municipality Number (D) | nvarchar | 8 | 0 | | |
2 | T5A2G_NEW | Municipality Code and Municipality Status | 3 | GMDNR | Municipality Number | nvarchar | 5 | 0 | | |
TOPAustria |
3 | T5A0P | Personnel Area/Subarea AT | 6 | GMDNR | Municipality Number | nvarchar | 5 | 0 | | |
4 | T5A2G | Municipalities | 2 | GMDNR | Municipality Number | nvarchar | 5 | 0 | | |
5 | T5A2G_AD | Assignment of Addresses to Municipalities | 6 | GMDNR | Municipality Number | nvarchar | 5 | 0 | | |
6 | T5A9M | Multiple Assignment for Municipal Tax | 3 | GMDNR | Municipality Number | nvarchar | 5 | 0 | | |
TOPGermany |
7 | P01T_AGS | Assignment of Postal Code to Municipality Key | 3 | GMDNR | Municipality Number (D) | nvarchar | 8 | 0 | | |
8 | PA0012 | HR Master Record: Infotype 0012 (Fiscal Data - Germany) | 25 | GMDNR | Municipality Number (D) | nvarchar | 8 | 0 | | |
9 | T5D0P | Plant/Personnel Subarea (D) | 10 | GMDNR | Municipality Number (D) | nvarchar | 8 | 0 | | |
10 | T5D2B | Municipality Key (D) | 1 | GMDNR | Municipality Number (D) | nvarchar | 8 | 0 | | |
TOPTax |
11 | P01T_LST | ETStmt: General Employment Tax Data | 13 | GMDNR | ETStmt: General Municipality Key | nvarchar | 8 | 0 | | |