| 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 | CNTR1 | SI split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | REGOF | Regular / Off-cycle | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | ETYPE | Employee type | char | 1 | 0 | | | | Allow NULL? |
| 10 | MUNCO | Municipality of work | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | TAX | Tax calculation for EE type | char | 1 | 0 | | | | Allow NULL? |
| 12 | DEDPE | Personal tax deduction factor | decimal | 5 | 3 | | | | |
| 13 | DEDFA | Tax deduction factor | decimal | 5 | 3 | | | | |
| 14 | FCTTX | Factor for tax calculation | decimal | 5 | 3 | | | | |
| 15 | EEPEC | EE - Pension Calculation | char | 1 | 0 | | | | Allow NULL? |
| 16 | EEPEI | EE Pension Increase to LL | char | 1 | 0 | | | | Allow NULL? |
| 17 | ERPEC | ER Pension Calculation | char | 1 | 0 | | | | Allow NULL? |
| 18 | ERPEI | ER Pension Increase to LL | char | 1 | 0 | | | | Allow NULL? |
| 19 | ERHEC | ER Health Calculation | char | 1 | 0 | | | | Allow NULL? |
| 20 | ERHEI | ER Health Increase to LL | char | 1 | 0 | | | | Allow NULL? |
| 21 | ERHDC | ER Health insurance Detached EEs | char | 1 | 0 | | | | Allow NULL? |
| 22 | EREMC | ER Employment Claculation | char | 1 | 0 | | | | Allow NULL? |
| 23 | EREMI | ER Employment Increase to LL | char | 1 | 0 | | | | Allow NULL? |
| 24 | ERINC | ER Injury Calculation | char | 1 | 0 | | | | Allow NULL? |
| 25 | ERINI | ER Injury Increase to LL | char | 1 | 0 | | | | Allow NULL? |
| 26 | ERTAC | ER Trip Abroad Calculation | char | 1 | 0 | | | | Allow NULL? |
| 27 | SILEV | Social insurance level type | char | 1 | 0 | | | | Allow NULL? |
| 28 | KATEG | Benefical category | char | 1 | 0 | | | | Allow NULL? |
| 29 | MUNCL | Municipality Code HR | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | NHTYP | Newly-Hired employee type / Novozaposleni | char | 1 | 0 | | | | Allow NULL? |
| 31 | DRREZ | Country of residence | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | NOSTX | No surtax | char | 1 | 0 | | | | Allow NULL? |
