| 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 | LANSP | Tax split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | CCOBT | Open-Ended / Fixed-Term Contract Indicator | char | 1 | 0 | | | | Allow NULL? |
| 9 | CFIZZ | Flexibility and Security Phase Categorization Code/Obsolete | char | 1 | 0 | | | | Allow NULL? |
| 10 | IREAP | Regular Work Arrangement Indication | char | 1 | 0 | | | | Allow NULL? |
| 11 | CIINV | Incidental Income Reduction Code | char | 1 | 0 | | | | Allow NULL? |
| 12 | IAOUK | Benefit Supplement Indication | char | 1 | 0 | | | | Allow NULL? |
| 13 | CAARD | Work Relationship Type Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | CAOCL | Collective Agreement Indicator on Wage Return | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | AANVU | Number of Remunerated Hours | decimal | 5 | 0 | | | | |
| 16 | CREIF | Code with Reason for End of Flexiworker Income Relationship | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | VERWE | Presumed End Date of the Unpaid Leave | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | VANGN | Code Welfare Claimant | char | 1 | 0 | | | | Allow NULL? |
| 19 | CFIFZ | Flexibility and Security Phase Categorization Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | CIVPL | Insurance Obligation Influence Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | INDDA | Entry Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | UITDA | Leaving Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | CDAGH | Contribution Reduction Code | char | 1 | 0 | | | | Allow NULL? |
| 24 | CRGBA | Reason for No Addition to Taxable Income for Car Code | char | 1 | 0 | | | | Allow NULL? |
| 25 | NUMIV | IR Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | BEGLL | Begin Date Life-Course Savings Withdrawal | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | ENDLL | End Date Life-Course Savings Withdrawal | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | RATLT | Ratio Green/ White Tax Tables Normal Pay | decimal | 8 | 7 | | | | |
| 29 | RATLB | Ratio Green/ White Tax Tables Special Pay | decimal | 8 | 7 | | | | |
| 30 | TAXGR | Wage Tax Green Table | decimal | 15 | 2 | | | | |
| 31 | ZVWIS | ZVW Income Relationship Split | char | 1 | 0 | | | | Allow NULL? |
| 32 | ZVWIR | ZVW Income Relationship Ratio | decimal | 8 | 7 | | | | |
| 33 | DUMMY | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 34 | IRSBD | Begin Date Split IR | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | IRSED | End Date Split IR | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | IRSTP | Income Relationship Split Type | char | 1 | 0 | | | | Allow NULL? |
| 37 | RATLC | Ratio Total Table and Special Pay | decimal | 8 | 7 | | | | |
