| 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 | PRNSP | Tax split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | DDATE | Date of Death | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | FAMST | Marital Status Key | char | 1 | 0 | | | | Allow NULL? |
| 10 | FAMDT | Valid From Date of Current Marital Status | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | FANAP | Birthname Partner | nvarchar | 40 | 0 | | | | Allow NULL? |
| 12 | NPFXP | Name Prefix Partner | nvarchar | 15 | 0 | | | | Allow NULL? |
| 13 | INITP | Initials Partner | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | INVEX | Individual exemptions | char | 1 | 0 | | | | Allow NULL? |
| 15 | NUMIR | Number Income Relationship | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | IRBEG | Start Date Income Relationship | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | IREND | End Date Income Relationship | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | IRRES | Reason for ending Income Relationship | char | 1 | 0 | | | | Allow NULL? |
| 19 | IRTYP | Type of Income Relationship | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | IPBEG | Start Date Income Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | IPEND | End Date Income Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | IPPAR | Particularization of Income Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | INKKD | Income Indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | CAOCL | Collective Agreement Indicator on Wage Return | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | OCCOD | Code Occupation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | CNTCD | Counting Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | PRDCD | Product Code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 28 | PRDVA | Product Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | PRBEG | Start date Pension/Insurance Relationship | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | VAEND | Enddate Product Variant | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | PPBEG | Start date Pension/Insurance Relationship Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | BWGTP | Type of Basis Wage | char | 1 | 0 | | | | Allow NULL? |
| 33 | AUNWK | Weekly Pay Scale Working Time in Hours | decimal | 5 | 2 | | | | |
| 34 | PRDCL | Product Code (long) | nvarchar | 20 | 0 | | | | Allow NULL? |
