| 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 | CNTR1 | 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 | NUMSS | Social insurance number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | NUMSS | Allow NULL? |
| 9 | CLESS | Verification key for the SI number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CLESS | Allow NULL? |
| 10 | TPART | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 11 | REGNO | SI contrib. model | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REGNO | Allow NULL? |
| 12 | ORG01 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 13 | COT01 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 14 | ORG02 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 15 | COT02 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 16 | ORG03 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 17 | COT03 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 18 | ORG04 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 19 | COT04 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 20 | ORG05 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 21 | COT05 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 22 | ORG06 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 23 | COT06 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 24 | ORG07 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 25 | COT07 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 26 | ORG08 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 27 | COT08 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 28 | ORG09 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 29 | COT09 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 30 | ORG10 | SI contribution funds | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ORGA1 | Allow NULL? |
| 31 | COT10 | Tax and social insurance payroll costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F1B | COTIS | Allow NULL? |
| 32 | REGSS | SI contrib. model | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REGNO | Allow NULL? |
| 33 | REGAC | SI contrib. model | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REGNO | Allow NULL? |
| 34 | REGRT | SI contrib. model | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REGNO | Allow NULL? |
| 35 | CTTYP | Contract Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CTTYP | Allow NULL? |
| 36 | MRCDD | Employment contract: Reason for recourse to a CDD | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P06_CONTRAT_MOTIF_RECOURS_CDD | Allow NULL? |
| 37 | CASPA | Employment contract: Specific case | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P06_CONTRAT_CAS_PARTICULIER | Allow NULL? |
| 38 | INBEG | Original start of contract or start of renewal | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P06_CONTRAT_DATE_INIT_DEBUT | Allow NULL? |
| 39 | INEND | Employment contract: End of contract/renewal | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P06_CONTRAT_DATE_INIT_FIN | Allow NULL? |
| 40 | PREND | Employment contract: End of contract prenotification date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P06_CONTRAT_DATE_PREAVIS_FIN | Allow NULL? |
| 41 | CATDU | Employment contract: Law on Securing emplymt - Duration cat. | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P06_CONTRAT_CATEGORIE_DUREE | Allow NULL? |
| 42 | PEEND | Employment contract: End date of trial period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P06_CONTRAT_DATE_ESSAI_FIN | Allow NULL? |
