| 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 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | SEQNO | Key Field Sequence Number for SFP Data Records | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | KENID | Identifier of Record | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | RZNSK | Data Center Number of Social Fund (R) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | RZNAG | Data Center Number for Company for Social Fund (R) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BNRSK | Company Number at a Social Fund - Construction Industry | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | NUS01 | Unused Numeric Field - Length 7 | nvarchar | 7 | 0 | | | | Allow NULL? |
| 11 | NUS02 | Version Number Component | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | RZDAT | Creation Date of Data Medium | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | VERNR | Version of Data Medium Exchange | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | FNAME | Name of Company for Social Fund | nvarchar | 22 | 0 | | | | Allow NULL? |
| 15 | ZVKAN | Employee Number at a Construction Social Insurance Fund | nvarchar | 13 | 0 | | | | Allow NULL? |
| 16 | SKPNR | Personnel Number for Notifications in SFP | nvarchar | 13 | 0 | | | | Allow NULL? |
| 17 | MSCHL | Notification Key for Data Record ANMEL | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | BEGDA | Start of Notification Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | ENDDA | End of Notification Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | ANGRP | Employee Group for Data Record ANMEL | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | NACHN | Last Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 22 | VORNA | First Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 23 | GBDAT | Date of Birth | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | GBORT | Birthplace | nvarchar | 30 | 0 | | | | Allow NULL? |
| 25 | STRAS | House Number and Street | nvarchar | 30 | 0 | | | | Allow NULL? |
| 26 | ORT01 | City | nvarchar | 25 | 0 | | | | Allow NULL? |
| 27 | LAND1 | Country Indicator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | EMAIL | E-mail Address | nvarchar | 50 | 0 | | | | Allow NULL? |
| 29 | GESCH | Gender Key | char | 1 | 0 | | | | Allow NULL? |
| 30 | WOSTD | Weekly Working Time for Social Fund Procedure | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | NATIO | Nationality | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | SPRSL | Language of Communication | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | BANKL | Bank Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | BANKN | Bank Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | EMFTX | Payee Text | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | BANKS | Bank Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | HEFTA | Book Request for Data Record ANMEL | char | 1 | 0 | | | | Allow NULL? |
| 38 | NUS03 | Field of length 16 | nvarchar | 16 | 0 | | | | Allow NULL? |
| 39 | PSTLZ | Postal Code | nvarchar | 7 | 0 | | | | Allow NULL? |
| 40 | BANKA | Foreign Bank Details | nvarchar | 35 | 0 | | | | Allow NULL? |
| 41 | BANKI | Bank Account Holder | nvarchar | 30 | 0 | | | | Allow NULL? |
| 42 | NUS04 | 3-Byte field | nvarchar | 3 | 0 | | | | Allow NULL? |
| 43 | NUS05 | Character field, 8 characters long | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | TSCHL | Occupational Code | nvarchar | 9 | 0 | | | | Allow NULL? |
| 45 | IBAN | IBAN | nvarchar | 34 | 0 | | | | Allow NULL? |
| 46 | BIC | BIC | nvarchar | 11 | 0 | | | | Allow NULL? |
