| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RD_ST | Payroll Result: Tax (G) | 42 | FZAMT | Tax Office Number (D) | nvarchar | 4 | 0 | | |
TOPAustria |
2 | T5A0A | ER Assgmt Unit for Authorities | 5 | FZAMT | Tax office number | nvarchar | 4 | 0 | | |
3 | T5A2F | Tax Offices (A) | 2 | FZAMT | Tax office number | nvarchar | 4 | 0 | | |
TOPCompany Pension Scheme Germany |
4 | PA0746 | HR Master Record for Infotype 0746 | 26 | FZAMT | Tax Office Responsible | nvarchar | 40 | 0 | | |
TOPGermany |
5 | PA0012 | HR Master Record: Infotype 0012 (Fiscal Data - Germany) | 24 | FZAMT | Tax Office Number (D) | nvarchar | 4 | 0 | | |
6 | PA0512 | HR Master Record Infotype 0512 | 26 | FZAMT | Tax Office Number (D) | nvarchar | 4 | 0 | | |
7 | T5D0P | Plant/Personnel Subarea (D) | 13 | FZAMT | Tax Office Number (D) | nvarchar | 4 | 0 | | |
8 | T5D2A | Tax Offices (D) | 1 | FZAMT | Tax Office Number (D) | nvarchar | 4 | 0 | | |
TOPRussia |
9 | PA0291 | HR Master Record: Infotype 0291 - Taxes CIS | 24 | FZAMT | Tax office number (D) (obsolete) | nvarchar | 4 | 0 | | |
TOPSouth Africa |
10 | PA0149 | HR Master Record Infotype 0149 (Tax Data South Africa) | 24 | FZAMT | Tax Revenue Office Code | nvarchar | 4 | 0 | | |
11 | T5W2A | (Old) Tax Revenue Offices (South Africa) | 3 | FZAMT | Tax Revenue Office Code | nvarchar | 4 | 0 | | |
12 | T5W2P | South African Revenue Service Offices | 2 | FZAMT | Tax Revenue Office Code | nvarchar | 4 | 0 | | |
TOPTax |
13 | P01T_LST | ETStmt: General Employment Tax Data | 45 | FZAMT | ETStmt: Tax Office Number (Germany) | nvarchar | 4 | 0 | | |