| 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 | CONDT | Condition changes | varbinary | 1 | 0 | | | | |
| 6 | TYPEN | Entity type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | ENTIT | Social insurance entity ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | PABRP | Payroll Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | DYSRL | Cumulated worked days | decimal | 7 | 2 | | | | |
| 13 | BTBAS | Social Insurance basis | decimal | 15 | 2 | | | | |
| 14 | BTBAL | Social Insurance basis full salary | decimal | 15 | 2 | | | | |
| 15 | DYLNR | Social Insurance days unpaid leave | decimal | 7 | 2 | | | | |
| 16 | BTLNR | Social Insurance base for unpaid leave | decimal | 15 | 2 | | | | |
| 17 | DYSWO | Worked days Self-assessment | decimal | 7 | 2 | | | | |
| 18 | BTIBC | Contribution basic income (IBC) | decimal | 15 | 2 | | | | |
| 19 | BTPER | Employee contribution | decimal | 15 | 2 | | | | |
| 20 | BTBUK | Employer contribution | decimal | 15 | 2 | | | | |
| 21 | BTVAP | Employee contribution leave adv. | decimal | 15 | 2 | | | | |
| 22 | BTFSP | Solidarity fund contribution, employee | decimal | 15 | 2 | | | | |
| 23 | BTFSB | Solidarity fund contribution, employer | decimal | 15 | 2 | | | | |
| 24 | BTVAF | Leave adv. solidarity fund employee | decimal | 15 | 2 | | | | |
| 25 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | PERCB | Percentage Employer contribution | decimal | 7 | 4 | | | | |
| 27 | PERCP | Percentage Employee contribution | decimal | 7 | 4 | | | | |
| 28 | BTUPC | UPC value | decimal | 15 | 2 | | | | |
| 29 | BTFSS | Solidarity fund contribution - Solidarity | decimal | 15 | 2 | | | | |
| 30 | BTSUB | Contribution to solidarity fund - Subsistence | decimal | 15 | 2 | | | | |
| 31 | PERSB | Percentage Subsistence subaccount | decimal | 7 | 4 | | | | |
| 32 | PERFS | Percentage Solidarity subaccount | decimal | 7 | 4 | | | | |
| 33 | PEASB | Additional percentage Subsistence | decimal | 7 | 4 | | | | |
| 34 | BTASP | Additional contribution - Employee's subsistence | decimal | 15 | 2 | | | | |
| 35 | BTASB | Additional contribution - Employer subsistence | decimal | 15 | 2 | | | | |
