| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5F1A | ORGA1 | Allow NULL? |
| 3 | COTIS | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5F1B | COTIS | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 6 | ASSCO | Assessment Basis | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | T5F1G | ASSC1 | Allow NULL? |
| 7 | FBTAN | Fixed amount for employee | decimal | 6 | 2 | CURR | ((0)) | Yes | | FBTAN | |
| 8 | PRANA | Rate of employee contributions level A (%) | decimal | 5 | 3 | DEC | ((0)) | Yes | | PRANA | |
| 9 | PRANB | Rate of employee contributions level B (%) | decimal | 5 | 3 | DEC | ((0)) | Yes | | PRANB | |
| 10 | PRANC | Rate of employee contributions level C (%) | decimal | 5 | 3 | DEC | ((0)) | Yes | | PRANC | |
| 11 | FBTAG | Employer part fixed amount | decimal | 6 | 2 | CURR | ((0)) | Yes | | FBTAG | |
| 12 | PRAGA | Rate of employer contributions level A (%) | decimal | 5 | 3 | DEC | ((0)) | Yes | | PRAGA | |
| 13 | PRAGB | Rate of employer contributions level B (%) | decimal | 5 | 3 | DEC | ((0)) | Yes | | PRAGB | |
| 14 | PRAGC | Rate of employer contributions level C (%) | decimal | 5 | 3 | DEC | ((0)) | Yes | | PRAGC | |
| 15 | LAGSA | Wage Type for Employer - Level A | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LAGSA | Allow NULL? |
| 16 | LAGSB | Wage Type for Employer - Level B | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LAGSB | Allow NULL? |
| 17 | LAGSC | Wage Type for Employer - Level C | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LAGSC | Allow NULL? |
| 18 | LAGBT | Wage Type for Fixed Amount | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LAGBT | Allow NULL? |
| 19 | LANSA | Wage Type for Employee - Level A | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LANSA | Allow NULL? |
| 20 | LANSB | Wage Type for Employee - Level B | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LANSB | Allow NULL? |
| 21 | LANSC | Wage Type for Employee - Level C | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LANSC | Allow NULL? |
| 22 | LANBT | Wage Type for Fixed Amount | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LANBT | Allow NULL? |
| 23 | CTMOD | Contribution type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T5F1C2 | P06_CTMOD | Allow NULL? |
| 24 | COND | Condition type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5F1C5 | P06_COND | Allow NULL? |
| 25 | CRULE | Rule type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5F1C8 | P06_RULE | Allow NULL? |
| 26 | SPECI | Outside contribution module | char | 1 | 0 | CHAR | (N' ') | No | | P06_CALCUL_PARTIC_COTIS | Allow NULL? |
| 27 | CINAC | Contributions calculation indicator for unemployed employees | char | 1 | 0 | CHAR | (N' ') | No | | P06_CALCUL_IF_INACTIVE | Allow NULL? |
| 28 | ASMOD | Contribution attributes for pension/insurance contract | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5F1O | P06_ASMOD | Allow NULL? |
| 29 | THGRP | Grouping indicator for contributions with a common platform | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P06_THGRP | Allow NULL? |
| 30 | IPMOD | Modifier for calculation parameters | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1C10 | P06_IPMOD | Allow NULL? |
