| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | HRPY_RGDIR | CDSEQ | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | HRDCT_ROWID | Allow NULL? |
| 5 | LANSP | Tax split | varbinary | 1 | 0 | RAW | | Yes | | PRSPL | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 8 | CCOBT | Open-Ended / Fixed-Term Contract Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_CCOBT | Allow NULL? |
| 9 | CFIZZ | Flexibility and Security Phase Categorization Code/Obsolete | char | 1 | 0 | CHAR | (N' ') | Yes | * | P05_CFIZZ | Allow NULL? |
| 10 | IREAP | Regular Work Arrangement Indication | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_IREAP | Allow NULL? |
| 11 | CIINV | Incidental Income Reduction Code | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_CIINV | Allow NULL? |
| 12 | IAOUK | Benefit Supplement Indication | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_IAOUK | Allow NULL? |
| 13 | CAARD | Work Relationship Type Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | P05_CAARD | Allow NULL? |
| 14 | CAOCL | Collective Agreement Indicator on Wage Return | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | P05_CAOCL | Allow NULL? |
| 15 | AANVU | Number of Remunerated Hours | decimal | 5 | 0 | DEC | ((0)) | Yes | | P05_AANVU | |
| 16 | CREIF | Code with Reason for End of Flexiworker Income Relationship | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P05_CREIF | Allow NULL? |
| 17 | VERWE | Presumed End Date of the Unpaid Leave | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P05_VERWE | Allow NULL? |
| 18 | VANGN | Code Welfare Claimant | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_VANGN | Allow NULL? |
| 19 | CFIFZ | Flexibility and Security Phase Categorization Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | P05_CFIFZ | Allow NULL? |
| 20 | CIVPL | Insurance Obligation Influence Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | P05_CIVPL | Allow NULL? |
| 21 | INDDA | Entry Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P05_INDDA | Allow NULL? |
| 22 | UITDA | Leaving Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P05_UITDA | Allow NULL? |
| 23 | CDAGH | Contribution Reduction Code | char | 1 | 0 | CHAR | (N' ') | Yes | | P05T_CDAGH | Allow NULL? |
| 24 | CRGBA | Reason for No Addition to Taxable Income for Car Code | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_CRGBA | Allow NULL? |
| 25 | NUMIV | IR Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P05_NUMIV | Allow NULL? |
| 26 | BEGLL | Begin Date Life-Course Savings Withdrawal | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P05_BEGLL | Allow NULL? |
| 27 | ENDLL | End Date Life-Course Savings Withdrawal | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P05_ENDLL | Allow NULL? |
| 28 | RATLT | Ratio Green/ White Tax Tables Normal Pay | decimal | 8 | 7 | DEC | ((0)) | Yes | | P05_RATLT | |
| 29 | RATLB | Ratio Green/ White Tax Tables Special Pay | decimal | 8 | 7 | DEC | ((0)) | Yes | | P05_RATLB | |
| 30 | TAXGR | Wage Tax Green Table | decimal | 15 | 2 | CURR | ((0)) | Yes | | P05_TAXGR | |
| 31 | ZVWIS | ZVW Income Relationship Split | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_ZVWIS | Allow NULL? |
| 32 | ZVWIR | ZVW Income Relationship Ratio | decimal | 8 | 7 | DEC | ((0)) | Yes | | P05_ZVWIR | |
| 33 | DUMMY | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 34 | IRSBD | Begin Date Split IR | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P05_IRSBD | Allow NULL? |
| 35 | IRSED | End Date Split IR | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P05_IRSED | Allow NULL? |
| 36 | IRSTP | Income Relationship Split Type | char | 1 | 0 | CHAR | (N' ') | Yes | | P05T_IRSPLIT_TYPE | Allow NULL? |
| 37 | RATLC | Ratio Total Table and Special Pay | decimal | 8 | 7 | DEC | ((0)) | Yes | | P05_RATLC | |
