| 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 | V0TYP | Variable assignment type | char | 1 | 0 | | | | Allow NULL? |
| 6 | V0ZNR | Variable assignment number | varbinary | 1 | 0 | | | | |
| 7 | OBJPS | Object Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | FANAM | Last Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | FAVOR | First Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 10 | FASEX | Gender Key | char | 1 | 0 | | | | Allow NULL? |
| 11 | FGBDT | Date of Birth | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | SVNUM | SI ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | SVKNR | Personal tax number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 14 | ADOKD | Tax settlement code | char | 1 | 0 | | | | Allow NULL? |
| 15 | STAT7 | Family status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | ANYNA | Last Name | nvarchar | 25 | 0 | | | | Allow NULL? |
| 17 | ANYVO | First Name | nvarchar | 25 | 0 | | | | Allow NULL? |
| 18 | ESMNY | SI accounting - date type 1 event | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | DATM1 | SI accounting - time | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | ESMN1 | SI accounting - Date type 2 events | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | DATM2 | SI accounting - from | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | DATM3 | SI accounting - to | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | NY3MH | SI accounting - income over 3-month minimum pension | char | 1 | 0 | | | | Allow NULL? |
| 24 | ALLPT | SI accounting - child condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | DATM4 | SI accounting - date of medical examination | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | IGENC | Nurturing benefit direct entry | char | 1 | 0 | | | | Allow NULL? |
| 27 | KORCS | Nurturing benefit direct entry - value | decimal | 9 | 2 | | | | |
| 28 | GYSOR | SI number of children, GYES criterion | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | CSPMH | SI accounting - child benefit prolonged | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | ALAPK | SI accounting - basis quota | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | EGYAK | SI accounting - basis quota for single parent | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | ATHAK | SI accounting - carry forward quota | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | ATHEK | SI accounting - carry forward quota for single | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | ANYKE | SI accounting - employee's quota | nvarchar | 3 | 0 | | | | Allow NULL? |
| 35 | APAKE | SI accounting - spouse's quota | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | MARAK | SI accounting - rest of basis quota | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | MAREK | SI accounting - rest of single quota | nvarchar | 3 | 0 | | | | Allow NULL? |
