| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GUID | Notification (Internal ID) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | KDNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | MIPFORDBG | Notification Obligation Key | nvarchar | 35 | 0 | | | | Allow NULL? |
| 5 | LEMN | Feature for Benefit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | DTERSTUR | Time Original Data Record Was Created | nvarchar | 23 | 0 | | | | Allow NULL? |
| 7 | DTERSTAKT | Time Current Data Record Was Created | nvarchar | 23 | 0 | | | | Allow NULL? |
| 8 | MMMELD | Feature for Notification | char | 1 | 0 | | | | Allow NULL? |
| 9 | TESTMERKER | Test Marker | char | 1 | 0 | | | | Allow NULL? |
| 10 | CSV_GRUND | Transfer Reason for Notification via CSV File | char | 1 | 0 | | | | Allow NULL? |
| 11 | MIPFBEZ | Name of Notification Party | nvarchar | 90 | 0 | | | | Allow NULL? |
| 12 | MIPFANNAME | Name of Contact Person | nvarchar | 50 | 0 | | | | Allow NULL? |
| 13 | MIPFANTEL | Telephone Number of Contact Person | nvarchar | 30 | 0 | | | | Allow NULL? |
| 14 | MIPFANDURCHWAHL | Contact Person: Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | MIPFANMAIL | Contact Person's E-Mail Address | nvarchar | 241 | 0 | | | | Allow NULL? |
| 16 | MIPFSTR | Street | nvarchar | 72 | 0 | | | | Allow NULL? |
| 17 | MIPFHAUSNR | House Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | MIPFHAUSNRZU | House Number Letter/Additional Digits | nvarchar | 20 | 0 | | | | Allow NULL? |
| 19 | MIPFADRESSERG | Address Supplement | nvarchar | 46 | 0 | | | | Allow NULL? |
| 20 | MIPFORT | City | nvarchar | 72 | 0 | | | | Allow NULL? |
| 21 | MIPFSTAATID | Country Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | MIPFPLZ | Postal Code | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | IDNR | Tax Identification Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 24 | NNAME | Family Name | nvarchar | 45 | 0 | | | | Allow NULL? |
| 25 | VWORT | Name Prefix | nvarchar | 20 | 0 | | | | Allow NULL? |
| 26 | NAMZU | Name Affixes | nvarchar | 20 | 0 | | | | Allow NULL? |
| 27 | TITEL | Title | nvarchar | 20 | 0 | | | | Allow NULL? |
| 28 | VNAME | First Name | nvarchar | 35 | 0 | | | | Allow NULL? |
| 29 | GEBDT | Date of Birth | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | STERBDT | Death Date | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | AUSLDSTR | Street | nvarchar | 72 | 0 | | | | Allow NULL? |
| 32 | AUSLDHAUSNR | House Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | AUSLDHAUSNRZU | House Number Letter/Additional Digits | nvarchar | 20 | 0 | | | | Allow NULL? |
| 34 | AUSLDADRESSERG | Address Supplement | nvarchar | 46 | 0 | | | | Allow NULL? |
| 35 | AUSLDORT | City | nvarchar | 72 | 0 | | | | Allow NULL? |
| 36 | AUSLDSTAATID | Country Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | AUSLDPLZ | Postal Code | nvarchar | 12 | 0 | | | | Allow NULL? |
| 38 | STAATAN | Country Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | LEWKZ | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | LEJAHR | Year of Inflow/Outflow of Benefit | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | LEAPBTR | Adjustment Amount | decimal | 9 | 2 | | | | |
| 42 | LEBEGINN | Start of Benefits | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | LEENDE | End of Benefits | nvarchar | 10 | 0 | | | | Allow NULL? |
