| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5C0P | HR CH: Personnel Subarea Supplements | 12 | ABREINHEIT | Enterprise (ELM) | nvarchar | 8 | 0 | | |
2 | T5C2Q | Payroll Unit WHT Return As of ELM 4.0 | 2 | ABREINHEIT | Payroll Unit: Withholding Tax Return As of ELM 4.0 | nvarchar | 8 | 0 | | |
3 | T5C2QT | Payroll Unit WHT Return As of ELM 4.0 - Texts | 3 | ABREINHEIT | Payroll Unit: Withholding Tax Return As of ELM 4.0 | nvarchar | 8 | 0 | | |
4 | T5C72 | Withholding tax calculation fee | 2 | ABREINHEIT | Payroll Unit - Withholding Tax | nvarchar | 8 | 0 | | |
5 | T5CSW | HR-CH: Work Center ELM 4.0 | 2 | ABREINHEIT | HR-CH: Payroll Unit Work Center ELM | nvarchar | 8 | 0 | | |
6 | T5CSWT | HR-CH: Work Center ELM 4.0 | 3 | ABREINHEIT | HR-CH: Payroll Unit Work Center ELM | nvarchar | 8 | 0 | | |
TOPSwitzerland |
7 | T5C2L | Withholding tax - payroll number | 2 | ABREINHEIT | Payroll Unit - Withholding Tax | nvarchar | 8 | 0 | | |
8 | T5C2M | Payroll unit - withholding tax | 2 | ABREINHEIT | Payroll Unit - Withholding Tax | nvarchar | 8 | 0 | | |
9 | T5C2MT | Payroll unit: Withholding tax texts | 3 | ABREINHEIT | Payroll Unit - Withholding Tax | nvarchar | 8 | 0 | | |
10 | T5C2N | Payroll unit - wage statement | 2 | ABREINHEIT | Payroll unit - wage statement | nvarchar | 8 | 0 | | |
11 | T5C2NB | Remarks for Payroll Unit Wage Statement | 3 | ABREINHEIT | Payroll unit - wage statement | nvarchar | 8 | 0 | | |
12 | T5C2NT | Payroll unit - wage statement texts | 3 | ABREINHEIT | Payroll unit - wage statement | nvarchar | 8 | 0 | | |
13 | T5C51 | ELM: Grouping Payroll Units for Enterprise | 2 | ABREINHEIT | HR-CH: Payroll unit | nvarchar | 8 | 0 | | |
14 | T5CS9 | HR-CH: Payroll unit - AHV/UI | 2 | ABREINHEIT | HR-CH: Payroll unit - AHV/UI | nvarchar | 8 | 0 | | |
15 | T5CS9T | HR-CH: Payroll unit - AHV/UI | 3 | ABREINHEIT | HR-CH: Payroll unit - AHV/UI | nvarchar | 8 | 0 | | |
16 | T5CSA | HR-CH: Payroll unit UVG | 2 | ABREINHEIT | HR-CH: Payroll unit UVG | nvarchar | 8 | 0 | | |
17 | T5CSAT | HR-CH: Payroll unit UVG | 3 | ABREINHEIT | HR-CH: Payroll unit UVG | nvarchar | 8 | 0 | | |
18 | T5CSB | HR-CH: Payroll unit: Social Funds | 2 | ABREINHEIT | HR-CH: Payroll unit: Social Funds | nvarchar | 8 | 0 | | |
19 | T5CSBT | HR-CH: Payroll unit: Social Funds | 3 | ABREINHEIT | HR-CH: Payroll unit: Social Funds | nvarchar | 8 | 0 | | |
20 | T5CSC | HR-CH: Payroll Unit: Voluntary Accident Insurance | 2 | ABREINHEIT | HR-CH: Payroll unit: Voluntary Insurance | nvarchar | 8 | 0 | | |
21 | T5CSCT | HR-CH: Payroll Unit: Voluntary Accident Insurance | 3 | ABREINHEIT | HR-CH: Payroll unit: Voluntary Insurance | nvarchar | 8 | 0 | | |
22 | T5CSD | HR-CH: Payroll Unit - Sickness Indemnity Insurance | 2 | ABREINHEIT | HR-CH: Payroll unit - Sickness indemnity insurance | nvarchar | 8 | 0 | | |
23 | T5CSDT | HR-CH: Payroll Unit - Sickness Indemnity Insurance | 3 | ABREINHEIT | HR-CH: Payroll unit - Sickness indemnity insurance | nvarchar | 8 | 0 | | |
24 | T5CSE | HR-CH: Payroll unit: NBU additional insurance | 2 | ABREINHEIT | HR-CH: Payroll unit: NBU additional insurance | nvarchar | 8 | 0 | | |
25 | T5CSET | HR-CH: Payroll unit: NBU additional insurance | 3 | ABREINHEIT | HR-CH: Payroll unit: NBU additional insurance | nvarchar | 8 | 0 | | |
26 | T5CSF | HR-CH: Payroll Unit - ASM | 2 | ABREINHEIT | HR-CH: Payroll unit - ASM | nvarchar | 8 | 0 | | |
27 | T5CSFT | HR-CH: Payroll Unit - ASM | 3 | ABREINHEIT | HR-CH: Payroll unit - ASM | nvarchar | 8 | 0 | | |
28 | T5CSG | HR-CH: Payroll Unit BFS | 2 | ABREINHEIT | HR-CH: Payroll unit BFS | nvarchar | 8 | 0 | | |
29 | T5CSGT | HR-CH: Payroll Unit BFS Text | 3 | ABREINHEIT | HR-CH: Payroll unit BFS | nvarchar | 8 | 0 | | |
30 | T5CSJ | Payroll Units for the Employer Statement | 2 | ABREINHEIT | Payroll Unit Employer Statement | nvarchar | 8 | 0 | | |
31 | T5CSJT | HR-CH; Payroll Unit AGBE | 3 | ABREINHEIT | Payroll Unit Employer Statement | nvarchar | 8 | 0 | | |
32 | T5CSK | HR-CH: PAyroll Unit Compensation Fund VD | 2 | ABREINHEIT | HR-CH: Payroll Unit Compensation Fund VD | nvarchar | 8 | 0 | | |
33 | T5CSKT | HR-CH: Payroll Unit Compensation Fund VD | 3 | ABREINHEIT | HR-CH: Payroll Unit Compensation Fund VD | nvarchar | 8 | 0 | | |
34 | T5CSL | Value Table Enterprises for ELM | 2 | ABREINHEIT | Enterprise (ELM) | nvarchar | 8 | 0 | | |
35 | T5CSLT | Text for Value Table Enterprises for ELM | 3 | ABREINHEIT | Enterprise (ELM) | nvarchar | 8 | 0 | | |
36 | T5CSM | HR-CH: Payroll Unit BVG ELM | 2 | ABREINHEIT | HR-CH: Payroll Unit BVG | nvarchar | 8 | 0 | | |
37 | T5CSMT | HR-CH: Payroll Unit BVG ELM | 3 | ABREINHEIT | HR-CH: Payroll Unit BVG | nvarchar | 8 | 0 | | |
38 | T5CSX | HR-CH: Payroll unit: Customer insurance 1 | 2 | ABREINHEIT | HR-CH: Payroll unit: Customer insurance 1 | nvarchar | 8 | 0 | | |
39 | T5CSXT | HR-CH: Payroll unit: Customer insurance 1 | 3 | ABREINHEIT | HR-CH: Payroll unit: Customer insurance 1 | nvarchar | 8 | 0 | | |
40 | T5CSY | HR-CH: Payroll unit: Customer insurance 2 | 2 | ABREINHEIT | HR-CH: Payroll unit: Customer insurance 2 | nvarchar | 8 | 0 | | |
41 | T5CSYT | HR-CH: Payroll unit: Customer insurance 2 | 3 | ABREINHEIT | HR-CH: Payroll unit: Customer insurance 2 | nvarchar | 8 | 0 | | |
42 | T5CSZ | HR-CH: Payroll unit: Customer insurance 3 | 2 | ABREINHEIT | HR-CH: Payroll unit: Customer insurance 3 | nvarchar | 8 | 0 | | |
43 | T5CSZT | HR-CH: Payroll unit: Customer insurance 3 | 3 | ABREINHEIT | HR-CH: Payroll unit: Customer insurance 3 | nvarchar | 8 | 0 | | |
44 | T5CZ1 | HR-CH: Payroll Unit: Family-Related Bonuses | 2 | ABREINHEIT | HR-CH: Payroll unit: Family-related bonuses | nvarchar | 8 | 0 | | |
45 | T5CZ1T | HR-CH: Payroll Unit: Family-Related Bonuses | 3 | ABREINHEIT | HR-CH: Payroll unit: Family-related bonuses | nvarchar | 8 | 0 | | |