| 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 | | PERNR_D | Allow NULL? |
| 3 | DCT_PABRJ | Payroll Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | PABRJ | Allow NULL? |
| 4 | DCT_PABRP | Payroll Period | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PABRP | Allow NULL? |
| 5 | DCT_CLTYP | Type of cluster | char | 1 | 0 | CHAR | (N' ') | No | | CLTYP | Allow NULL? |
| 6 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | HRDCT_ROWID | Allow NULL? |
| 7 | LDATE | Logical Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LDATE | Allow NULL? |
| 8 | BEGTM | Start time | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CTIMB | Allow NULL? |
| 9 | ENDTM | End time | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CTIME | Allow NULL? |
| 10 | BGCOD | Attendance/absence reason for begin entry | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BGCOD | Allow NULL? |
| 11 | EGCOD | Attendance/absence reason for end entry | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EGCOD | Allow NULL? |
| 12 | BTERM | Terminal ID of start entry | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BTERM | Allow NULL? |
| 13 | ETERM | Terminal ID of end entry | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ETERM | Allow NULL? |
| 14 | BSART | Time event pair start | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | BSATZA | Allow NULL? |
| 15 | ESART | Time event pair end | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ESATZA | Allow NULL? |
| 16 | STAT1 | Status from pair formation | char | 1 | 0 | CHAR | (N' ') | Yes | | PCST1 | Allow NULL? |
| 17 | STAT2 | Status from time evaluation | char | 1 | 0 | CHAR | (N' ') | Yes | | PCST2 | Allow NULL? |
| 18 | COGOS | Attendance or absence status in pair formation | char | 1 | 0 | CHAR | (N' ') | Yes | | COGOS | Allow NULL? |
| 19 | AESTA | Change status | char | 1 | 0 | CHAR | (N' ') | Yes | | AESTA | Allow NULL? |
| 20 | BUSER | Multi-purpose field for begin entry | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PDC_BUSER | Allow NULL? |
| 21 | EUSER | Multi-purpose field for end entry | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PDC_EUSER | Allow NULL? |
| 22 | BPDSN | Sequential number for PDC messages | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | PDSNR_D | Allow NULL? |
| 23 | EPDSN | Sequential number for PDC messages | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | PDSNR_D | Allow NULL? |
| 24 | START_BEF_ZERO | Start Before 00:00 | char | 1 | 0 | CHAR | (N' ') | Yes | | PTM_START_BEF_ZERO | Allow NULL? |
