| 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 | INTYP | Insurance type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | INNUM | Insurance number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 9 | CONAR | Contribution area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | CONBR | Industry | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | CONGR | Contribution group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | CONLV | Contribution level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | PBYER | Who pays | char | 1 | 0 | | | | Allow NULL? |
| 14 | EEWGE | Wage Type of Employee Base | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | EERAT | Employee contribution rate | decimal | 8 | 3 | | | | |
| 16 | EECON | Employee contribution constant | decimal | 13 | 2 | | | | |
| 17 | ECCUR | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | EELOW | Employee contribution base low limit | decimal | 13 | 2 | | | | |
| 19 | EELCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | EEHIG | Employee contribution base high limit | decimal | 13 | 2 | | | | |
| 21 | EEHCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | ERWGE | Wage Type of Employer Base | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | ERRAT | Employer contribution rate | decimal | 8 | 3 | | | | |
| 24 | ERCON | Employer contribution additional amount | decimal | 13 | 2 | | | | |
| 25 | RCCUR | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | ERLOW | Employer contribution base low limit | decimal | 13 | 2 | | | | |
| 27 | ERLCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | ERHIG | Employer contribution base high limit | decimal | 13 | 2 | | | | |
| 29 | ERHCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 30 | PITAX | Pre/post tax indicator | char | 1 | 0 | | | | Allow NULL? |
| 31 | EEBSR | Employee contribution base rounding indicator | char | 1 | 0 | | | | Allow NULL? |
| 32 | EECOR | Employee contribution amount rounding indicator | char | 1 | 0 | | | | Allow NULL? |
| 33 | ERBSR | Employer contribution base rounding indicator | char | 1 | 0 | | | | Allow NULL? |
| 34 | ERCOR | Employer contribution amount rounding indicator | char | 1 | 0 | | | | Allow NULL? |
| 35 | CFRQC | Contribution Frequency | char | 1 | 0 | | | | Allow NULL? |
| 36 | FCMTH | First Contribution Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | PRORU | Proration Rule | char | 1 | 0 | | | | Allow NULL? |
| 38 | EEBSE | Employee Contribution Base Amount | decimal | 13 | 2 | | | | |
| 39 | EEBCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | ERBSE | Employer Contribution Base Amount | decimal | 13 | 2 | | | | |
| 41 | ERBCU | Contribution base currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 42 | MOSEL | Month Selection | nvarchar | 12 | 0 | | | | Allow NULL? |
