| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RB_CI | Payroll Result: Complementary Indemnity- CI (BE) | 20 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
2 | P2RB_SV | Social Insurance payroll Belgium | 53 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
3 | P2RB_SVEVL | Payroll Results: DMFA Social Insurance table for Evaluation | 10 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
4 | T5B0B | Text Table SI Categories Employers (B) | 3 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
5 | T5BVY | Base Rates for SI Contributions | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
TOPBelgium |
6 | PA0100 | HR Master Record: Infotype 0100 (SI B) | 27 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
7 | PA3270 | HR Master Record: Infotype 3270 | 34 | RSZCA | Employer Class | nvarchar | 3 | 0 | | |
8 | T5B02 | SI Categories Employers (B) | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
9 | T5BCISIC | Complementary Indemnity: Social Insurance Contributions | 3 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
10 | T5BD3 | Additional Social Insurance Contributions (obsolete) | 3 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
11 | T5BDA | Additional Social Insurance Contributions | 3 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
12 | T5BS3 | Employee information except reductions ( level 3 ) | 4 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
13 | T5BS4 | Employee remuneration and absence information ( level 4) | 4 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
14 | T5BSR | Reductions for an employee reported on level 3 | 4 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
15 | T5BV1 | SI rate by contribution part | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
16 | T5BV2 | Percentages SI-part per category employer/employee | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
17 | T5BV3 | Total SI per employer/employee category | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
18 | T5BV4 | Factory shutdown fundraising (FFE/FSO) | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
19 | T5BV5 | Rate for existance insurance fund | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
20 | T5BV7 | Rates for wage moderation | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
21 | T5BVT | Logic of the social security payments | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
22 | T5BVU | Logic of the social security reductions | 2 | RSZCA | Employer Class (SI Employer Category) (00036) | nvarchar | 3 | 0 | | |
23 | T5BVV | Level/block sequence of the social insurance declaration | 7 | RSZCA | SI category employer sequence | nvarchar | 3 | 0 | | |