| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | STATU | | char | 1 | 0 | | | | Allow NULL? |
| 4 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | JVKOD | | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | MUSSZ | Employer's sequence number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | JVBEG | | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | JVEND | | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | JOBID | Program run identification | nvarchar | 14 | 0 | | | | Allow NULL? |
| 10 | STRNR | Personal tax number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 11 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | UNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | MUKOD | Employer ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | SZHTH | Company seat/site | char | 1 | 0 | | | | Allow NULL? |
| 16 | ADOSZ | Employer's tax number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 17 | ADOAZ | Employer's tax ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | NEV | Employer's name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 19 | ORSZ | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | IRSZM | Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | HELYS | City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 22 | KERLT | District | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | KZNEV | Public place text | nvarchar | 60 | 0 | | | | Allow NULL? |
| 24 | KZJEL | Public place specification | nvarchar | 20 | 0 | | | | Allow NULL? |
| 25 | HAZSZ | House number or cadastral survey number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 26 | EPULT | Building | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | LEPCS | Staircase | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | EMELT | Floor | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | AJTO | Door | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | INSTA | Institution's statistical code | nvarchar | 17 | 0 | | | | Allow NULL? |
| 31 | ISKEV | Year of school entry | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | ANZKL | Duration of training course | decimal | 3 | 0 | | | | |
| 33 | ANZEH | Time/Measurement Unit Text | nvarchar | 20 | 0 | | | | Allow NULL? |
| 34 | KAPNE | Contact person's name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 35 | KAPTE | Contact person's phone number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 36 | KAPMA | Contact person's e-mail address | nvarchar | 30 | 0 | | | | Allow NULL? |
| 37 | SZFNE | Line manager's name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 38 | SZFTE | Line manager's phone number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 39 | SZFMA | Line manager's e-mail address | nvarchar | 30 | 0 | | | | Allow NULL? |
| 40 | SZFTSZ | Personnel number of professional responsible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | OSSZEG | Amount | decimal | 13 | 2 | | | | |
| 42 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
