| 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 | FORNR | Number of Evaluation in Social Fund Procedure - Const. Ind. | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | SEQNO | Sequence Number 2 Places | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | ZVKAS | Social Fund | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | BNRSK | Company Number at a Social Fund - Construction Industry | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | RZNUM | Data Center Number for Construction Industry Social Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | RZDAT | Creation Date of Data Medium | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | SEQN2 | Sequence Number 2 Places | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | MODIF | Modification Status for Evaluation Records SFP Construction | char | 1 | 0 | | | | Allow NULL? |
| 12 | STATS | Utilization Status for Evaluation Records SFP Construction | char | 1 | 0 | | | | Allow NULL? |
| 13 | STORN | Cancellation Status for Evaluation Records SFP Construction | char | 1 | 0 | | | | Allow NULL? |
| 14 | ERROR | Error Status for Evaluation Records SFP Construction | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | ZVKAN | Employee Number at a Construction Social Insurance Fund | nvarchar | 13 | 0 | | | | Allow NULL? |
| 17 | BAUTY | Employee Subgroup Grouping for Construction Pay | char | 1 | 0 | | | | Allow NULL? |
| 18 | WERKS | Personnel Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | BTRTL | Personnel Subarea | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | SBMOD | Administrator Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | SACHA | Payroll Administrator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | ANAME | Edited Name (Sortable) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 23 | XDATA | Data Packet for Evaluation Data Record SFP Construction | nvarchar | 240 | 0 | | | | Allow NULL? |