| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TICON | Main contract key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | MODAL | A/R contract category | char | 1 | 0 | | | | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | DAECC | Discount in company contribution to non-industrial risks (%) | decimal | 8 | 4 | | | | |
| 7 | DAEAE | Company contribution for IA and ID (%) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | DATCC | Discount in employee contribution to NIR (1/10,000) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | NODEC | Number of Royal Decree | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | FEDEC | Date of legal regulation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | NODER | Number of derived Royal Decree | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | FEDER | Date of derived Royal Decree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DURMO | Duration of allowance/reduction | decimal | 3 | 0 | | | | |
| 14 | UNIMO | Time unit for duration | char | 1 | 0 | | | | Allow NULL? |
| 15 | TIPO | Contract type | char | 1 | 0 | | | | Allow NULL? |
| 16 | JORN | Type of working day in contract | char | 1 | 0 | | | | Allow NULL? |
| 17 | DESMP | Contribution type for Unemployment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | CLCON | Contract Key for Social Insurance | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | CLCO2 | Contract key (part-time) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | IMETO | Selection field (checkbox) | char | 1 | 0 | | | | Allow NULL? |
| 21 | ITPRE | Selection field (checkbox) | char | 1 | 0 | | | | Allow NULL? |
| 22 | AZUBI | Contract category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | CLCOI | Contract key according to INEM | nvarchar | 3 | 0 | | | | Allow NULL? |
