| 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 | PENSP | Tax split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | PENSK | Pension Indicator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | PENNR | Pension Fund Registration Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 10 | PENKD | Contribution Ind. | char | 1 | 0 | | | | Allow NULL? |
| 11 | PENPC | Part-Time Percentage for Pensions | decimal | 6 | 3 | | | | |
| 12 | REPER | Representing Legal Person | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | HERBR | Retroactive Accounting Ind. | char | 1 | 0 | | | | Allow NULL? |
| 14 | AFWPG | Different Pensionable Salary | decimal | 9 | 2 | | | | |
| 15 | AFWWG | Different Employer Contribution | decimal | 9 | 2 | | | | |
| 16 | AFWWN | Different Employee Contribution | decimal | 9 | 2 | | | | |
| 17 | AFWPP_WG | Different ER Contribution Percentage | decimal | 7 | 4 | | | | |
| 18 | AFWPP_WN | Different EE Contribution Percentage | decimal | 7 | 4 | | | | |
| 19 | TVAPG | Periodicity for Different Pensionable Salary | char | 1 | 0 | | | | Allow NULL? |