| 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_PABRJ | Payroll Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | DCT_PABRP | Payroll Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | DCT_CLTYP | Type of cluster | char | 1 | 0 | | | | Allow NULL? |
| 6 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | LDATE | Logical Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | BEGTM | Start time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 9 | ENDTM | End time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | BGCOD | Attendance/absence reason for begin entry | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | EGCOD | Attendance/absence reason for end entry | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | BTERM | Terminal ID of start entry | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | ETERM | Terminal ID of end entry | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | BSART | Time event pair start | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | ESART | Time event pair end | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | STAT1 | Status from pair formation | char | 1 | 0 | | | | Allow NULL? |
| 17 | STAT2 | Status from time evaluation | char | 1 | 0 | | | | Allow NULL? |
| 18 | COGOS | Attendance or absence status in pair formation | char | 1 | 0 | | | | Allow NULL? |
| 19 | AESTA | Change status | char | 1 | 0 | | | | Allow NULL? |
| 20 | BUSER | Multi-purpose field for begin entry | nvarchar | 20 | 0 | | | | Allow NULL? |
| 21 | EUSER | Multi-purpose field for end entry | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | BPDSN | Sequential number for PDC messages | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | EPDSN | Sequential number for PDC messages | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | START_BEF_ZERO | Start Before 00:00 | char | 1 | 0 | | | | Allow NULL? |