| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | AUSWP | Evaluation Period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | ANLAR | Investment Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | AINSL | Key for Investment Institution | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | MRELE | Event Relevant for Notification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | METYP | Notification Type | char | 1 | 0 | | | | Allow NULL? |
| 8 | SEQMR | Seq. No. for Identical Events Relevant for Notif., ZVE-PBS | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | SEQSA | Sequence Number for Identical Record Types, ZVE-PBS | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | UEREV | Transfer Relevance of a Record, ZVE-PBS | char | 1 | 0 | | | | Allow NULL? |
| 11 | MTATB | Reason for Notification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | ABBEG | Start of Period, ZVE-PBS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | ABEND | End of Period, ZVE-PBS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | EINZA | Payer (DATUEV-ZVE) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | VSMKM | Insurance Feature, DATUEV-ZVE | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | STMKM | Taxing Feature, DATUEV-ZVE | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | ZPERI | Payment Period of Contributions, ZVE-PBS | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | PFENT | Remuneration Liable to SP Contributions/I BAT Excess | decimal | 9 | 2 | | | | |
| 20 | BETRG | Contribution | decimal | 9 | 2 | | | | |
| 21 | ANZKI | Number of Children for Parental Leave Entitlement | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | ZUFLJ | Year of Remuneration Accrual | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | GRDNZ | Reason for Retroactive Payment, ZVE-PBS | char | 1 | 0 | | | | Allow NULL? |
| 24 | NRABV | Number of Additional Work Relationship (for VBL Only) | char | 1 | 0 | | | | Allow NULL? |