| 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 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | STYPE | Statistics type (DK) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | STYNO | Indicator: Inclusion in DA/DS statistics (DK) | char | 1 | 0 | | | | Allow NULL? |
| 9 | BOLIG | Indicator: Free telephone (DK) | char | 1 | 0 | | | | Allow NULL? |
| 10 | KSOM2 | Free accommodation | char | 1 | 0 | | | | Allow NULL? |
| 11 | WCOD1 | Official DA job key (DK) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | WCOD2 | Official DA job key (DK) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | WCOD3 | Official DA job key (DK) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | BEGW1 | DA/DS start date of work function code (DK) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | BEGW2 | DA/DS start date of work function code (DK) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | BEGW3 | DA/DS start date of work function code (DK) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | ECOD1 | Official DA training key (DK) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | ECOD2 | Official DA training key (DK) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | ECOD3 | Official DA training key (DK) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | ENDD1 | End date of training Denmark | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | ENDD2 | End date of training Denmark | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | ENDD3 | End date of training Denmark | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | KSOM1 | Wage period relevant for DA/DS statistics (DK) | char | 1 | 0 | | | | Allow NULL? |
| 24 | DAIN1 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 25 | DAIN2 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 26 | DAIN3 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 27 | DAIN4 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 28 | DAIN5 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 29 | DAIN6 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 30 | DAIN7 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 31 | DAIN8 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 32 | DAIN9 | PBS FORM 20A1 REC 7 lines 24 for DA/DS statistics | char | 1 | 0 | | | | Allow NULL? |
| 33 | ARBS2 | Work center code for DA statistics DK | nvarchar | 5 | 0 | | | | Allow NULL? |
| 34 | ARBS3 | Work center code for DS statistics DK | nvarchar | 5 | 0 | | | | Allow NULL? |
| 35 | WOSTD | Hours per week | decimal | 5 | 2 | | | | |
| 36 | COL23 | DA/DS code for contract type, FORM20A1 rec.7 col.23 (DK) | char | 1 | 0 | | | | Allow NULL? |
| 37 | COL43 | DA agreement code, FORM 20A1 rec.7 col 43-47 (DK) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 38 | DAFER | DA/DS codes for leave management FORM20A rec. 4 col. 18 (DK) | char | 1 | 0 | | | | Allow NULL? |
