| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RC_ST | Payroll Results: Taxes (Switzerland) | 8 | KANTO | Canton Indicator | nvarchar | 2 | 0 | | |
2 | T5C1O_EX | Cantons/Municipalities/Postcodes | 5 | KANTO | Canton Indicator | nvarchar | 2 | 0 | | |
3 | T5C1S | Withholding Tax Rates (CH) | 2 | KANTO | Canton Indicator | nvarchar | 2 | 0 | | |
4 | T5C1T | Texts for Withholding Tax | 3 | KANTO | Canton Indicator | nvarchar | 2 | 0 | | |
5 | T5C1Y | Fee for Withholding Tax | 2 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
6 | T5C2Q | Payroll Unit WHT Return As of ELM 4.0 | 5 | KANTO | ELM 4.0 WHT: Tax Canton (Payroll Unit WHT ELM) | nvarchar | 2 | 0 | | |
7 | T5C72 | Withholding tax calculation fee | 3 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
8 | T5CSW | HR-CH: Work Center ELM 4.0 | 17 | KANTO | ELM (Work Center): Place of Work Canton | nvarchar | 2 | 0 | | |
TOPSwitzerland |
9 | PA0038 | HR Master Record: Infotype 0038 (Fiscal Data CH) | 24 | KANTO | Canton Indicator | nvarchar | 2 | 0 | | |
10 | T5C10 | FAK Contributions (CH) | 2 | KANTO | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
11 | T5C11 | Training Bonuses | 2 | KANTO | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
12 | T5C12 | Bonus Paid After Birth of Child | 2 | KANTO | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
13 | T5C1M | Family-Related Bonuses | 2 | KANTO | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
14 | T5C1O | Cantons/Municipalities (CH) | 2 | KANTO | Canton Indicator | nvarchar | 2 | 0 | | |
15 | T5C2B | Withholding Tax Bases | 2 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
16 | T5C2C | Withholding Tax Liability | 2 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
17 | T5C2D | Withholding Tax Calculation | 2 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
18 | T5C2E | Special Table 13th Monthly Wages | 2 | KANTO | Canton Indicator | nvarchar | 2 | 0 | | |
19 | T5C2F | Tax Cantons | 2 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
20 | T5C2G | Texts for Withholding Tax | 3 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
21 | T5C2H | WhT Tax Records | 2 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
22 | T5C2H_EXT | WTx Rates (Basis as of 100,000) | 2 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
23 | T5C2I | WhT Accounting Number | 4 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
24 | T5C2K | WhT Table Structure | 2 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
25 | T5C2L | Withholding tax - payroll number | 3 | KANTO | Tax canton | nvarchar | 2 | 0 | | |
26 | T5C4A | Municipality | 4 | KANTO | Canton Indicator | nvarchar | 2 | 0 | | |