| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | ZUSID | ZfA Identification Number of Notification | nvarchar | 18 | 0 | NUMC | (N'000000000000000000') | No | | P01P_ZFA_ZUSID_N | Allow NULL? |
| 3 | LFDNR | ZfA: Sequential Number for Notifications with Same Zusy-ID | nvarchar | 3 | 0 | NUMC | (N'000') | No | | P01P_ZFA_LFDNR_ZKNN | Allow NULL? |
| 4 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 5 | RUNDT | Run Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01P_ZFA_DATRU | Allow NULL? |
| 6 | RUNTM | Runtime | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P01P_ZFA_TIMRU | Allow NULL? |
| 7 | MMEGD | ZfA Notification Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_NOTIF | Allow NULL? |
| 8 | DATCR | Notification Creation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01P_ZFA_DATCR | Allow NULL? |
| 9 | TIMCR | Creation Time of Notification | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P01P_ZFA_TIMCR | Allow NULL? |
| 10 | DATOR | Date of Original Notification | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01P_ZFA_DATOR | Allow NULL? |
| 11 | TIMOR | Time of Original Notification | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P01P_ZFA_TIMOR | Allow NULL? |
| 12 | MMELD | Notification Feature | char | 1 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_MMELD | Allow NULL? |
| 13 | BNDUE | Company Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BTRNR | Allow NULL? |
| 14 | AKTZZ | Reference | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_AKTZ | Allow NULL? |
| 15 | USYID | ZfA Identification Number of Notification | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_ZUSID | Allow NULL? |
| 16 | RVNUM | ZfA Bonus Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_ZULNR | Allow NULL? |
| 17 | NACHN | Investor's Last Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_NACHNAME_ANLEGER | Allow NULL? |
| 18 | VORNA | First Name of Investor | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_VORNAME_ANLEGER | Allow NULL? |
| 19 | NAME2 | Name at Birth of Investor | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_GEBURTSNAME_ANLEGER | Allow NULL? |
| 20 | GBDAT | Investor's Date of Birth | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01P_ZFA_GEBURTSDATUM_ANLEGER | Allow NULL? |
| 21 | GBORT | Place of Birth of Investor | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_GEBURTSORT_ANLEGER | Allow NULL? |
| 22 | BTJHR | Cont. Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P01P_ZFA_BTJHR | Allow NULL? |
| 23 | DIENS | Notifying body is responsible | char | 1 | 0 | NUMC | (N'0') | Yes | | P01P_ZFA_DIENS | Allow NULL? |
| 24 | BEAVG | Feature BeamtVG in BZ01 Notifications | char | 1 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_BEAMTVG | Allow NULL? |
| 25 | BESOL | Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01P_ZFA_BESOL | |
| 26 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 27 | VONBE | From-Period of Salary Payment | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_VONBE | Allow NULL? |
| 28 | BISBE | To-Period of Salary Payment | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_BISBE | Allow NULL? |
| 29 | STRAS | Street and House Number | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | PAD_STRAS | Allow NULL? |
| 30 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 31 | PSTLZ | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTLZ | Allow NULL? |
| 32 | ORT01 | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PAD_ORT01 | Allow NULL? |
| 33 | GESCH | Gender Key | char | 1 | 0 | CHAR | (N' ') | Yes | | GESCH | Allow NULL? |
| 34 | NATIO | Nationality | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | NATSL | Allow NULL? |
| 35 | VORSW | Name Prefix | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | VORSW | Allow NULL? |
| 36 | VORS2 | Second Name Prefix | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | VORS2 | Allow NULL? |
| 37 | TITEL | Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TITEL | Allow NULL? |
| 38 | OZUNR | Bonus Number, Old | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_OZUNR | Allow NULL? |
| 39 | VON | From Period (5.0) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_VON | Allow NULL? |
| 40 | BIS | To-Period (5.0) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_BIS | Allow NULL? |
| 41 | SIDNR | Tax Identification Number | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | P01_SIDNR | Allow NULL? |
| 42 | TELNR | Telephone Number in ZfA Notifications | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P01P_ZFA_TELNR | Allow NULL? |
