| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SIFTY | Statutory Social Insurance Fund Type | nvarchar | 15 | 0 | | | | Allow NULL? |
| 3 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | SEECP | SI Contribution Percentage of Employees | decimal | 7 | 2 | | | | |
| 7 | HOMFU | Home Fund for Qatar Social Insurance | char | 1 | 0 | | | | Allow NULL? |
| 8 | SERCP | SI Contribution Percentage of Employer | decimal | 7 | 2 | | | | |
| 9 | MINCC | Statutory Minimum SI Calculation Base | decimal | 13 | 2 | | | | |
| 10 | MINDB | Minimum Limit Delta Value Contribution Option | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | MAXCC | Statutory Maximum SI Calculation Base | decimal | 13 | 2 | | | | |
| 12 | MAXDB | Maximum Limit Delta Value Contribution Option | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | BANKL | Bank Keys | nvarchar | 15 | 0 | | | | Allow NULL? |
| 15 | BANKN | Bank account number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 16 | REAGE | Check for Retirement Age | char | 1 | 0 | | | | Allow NULL? |
| 17 | RAMAL | Retirement Age of Male Employees | decimal | 3 | 0 | | | | |
| 18 | RAFEM | Retirement Age of Female Employees | decimal | 3 | 0 | | | | |
| 19 | REPER | Recalculation Period | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | CONMD | Contribution Method | char | 1 | 0 | | | | Allow NULL? |
| 21 | SMHSA | Simulate Housing Allowance | char | 1 | 0 | | | | Allow NULL? |
| 22 | SMHRT | Simulate Housing Allowance Rate | decimal | 7 | 2 | | | | |
| 23 | TAUPL | Total Allowance Upper Limit | char | 1 | 0 | | | | Allow NULL? |
| 24 | TAURT | Total Allowance Upper Limit Rate | decimal | 7 | 2 | | | | |
| 25 | SGART | Wage Type for Housing Allowance | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | | | Allow NULL? |