| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5C2Q | Payroll Unit WHT Return As of ELM 4.0 | 6 | ABRNR | ELM 4.0 WHT: Payroll Number (Payroll Unit WHT ELM) | nvarchar | 20 | 0 | | |
TOPOverhead Cost Orders |
2 | AUAK | Document Header for Settlement | 21 | ABRNR | Sequential settlement number | smallint | 5 | 0 | | |
3 | COBRA | Settlement Rule for Order Settlement | 16 | ABRNR | Sequential settlement number | smallint | 5 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
4 | /BEV3/CHSIMADMIN | Reset Simulation: Data for Admin. Process | 3 | ABRNR | Settlement Number | nvarchar | 10 | 0 | | |
5 | /BEV3/CHSIMSTKFH | CH Settlement Statistics Header Data - History | 9 | ABRNR | Settlement Number | nvarchar | 10 | 0 | | |
6 | /BEV3/CHSIMSTK_F | CH - Silulation Statistics Header Data | 7 | ABRNR | Settlement Number | nvarchar | 10 | 0 | | |
7 | /BEV3/CHSIMSTK_V | CH - Simulation statistics of premature DA conditions | 9 | ABRNR | Settlement Number | nvarchar | 10 | 0 | | |
8 | /BEV3/CHTMPSTK_F | CH - Temporary Statistics Header Data | 7 | ABRNR | Settlement Number | nvarchar | 10 | 0 | | |
9 | /BEV3/CHTMPSTK_V | CH - temporary statistics of premature DA termination | 9 | ABRNR | Settlement Number | nvarchar | 10 | 0 | | |
10 | /BEV3/CHTRMSTK_V | CH-settlement statistics of premature DA conditions | 9 | ABRNR | Settlement Number | nvarchar | 10 | 0 | | |
TOPSwitzerland |
11 | T5C2I | WhT Accounting Number | 5 | ABRNR | Accounting number | nvarchar | 20 | 0 | | |
12 | T5C2L | Withholding tax - payroll number | 4 | ABRNR | Accounting number | nvarchar | 20 | 0 | | |
13 | T5C2P_ABRNR | Employer Data for WHT Accounting Geneva | 2 | ABRNR | Accounting number | nvarchar | 20 | 0 | | |