| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | CNTR1 | SI split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | AVKZ1 | Social Insurance Indicator | char | 1 | 0 | | | | Allow NULL? |
| 9 | RVKZ1 | Social Insurance Indicator | char | 1 | 0 | | | | Allow NULL? |
| 10 | KVKZ1 | Social Insurance Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | PFSFR | Insurance Company | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | PFGST | Subsidiary | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | PFDEP | Employee's Percentage of Contribution | decimal | 7 | 4 | | | | |
| 14 | PFDED | Total Percentage Contribution | decimal | 5 | 2 | | | | |
| 15 | PFFXA | Total Amount Contribution | decimal | 7 | 2 | | | | |
| 16 | MAXPF | Employer Threshold Amount | decimal | 8 | 2 | | | | |
| 17 | KVSFR | Insurance Company | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | KVGST | Subsidiary | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | KVBKL | Contribution class | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | MADEP | Employee's Percentage of Contribution | decimal | 7 | 4 | | | | |
| 21 | MADED | Total Percentage Contribution | decimal | 5 | 2 | | | | |
| 22 | MAXKV | Employer Threshold Amount | decimal | 8 | 2 | | | | |
| 23 | MAFXA | Total Amount Contribution | decimal | 7 | 2 | | | | |
| 24 | MAGAP | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 25 | MAPAC | Old version - Use P16_MAPAC instead | decimal | 5 | 2 | | | | |
| 26 | MASPC | MA Special Contribution Status | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | CSVKY | SI split | varbinary | 1 | 0 | | | | |
| 28 | ADDEP | Number of Adult Dependants | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | CHDEP | Number of Child Dependants | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | MAPAN | Medical Aid Personal Savings Account | decimal | 8 | 2 | | | | |
| 31 | AVBFG | Exempt Reason | char | 1 | 0 | | | | Allow NULL? |
| 32 | MEDEP | Number of Member Dependants | nvarchar | 2 | 0 | | | | Allow NULL? |
