| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SCHUID | School Identification Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | NAME_E | Name of School in English | nvarchar | 60 | 0 | | | | Allow NULL? |
| 6 | NAME_A | Name of School in Arabic | nvarchar | 60 | 0 | | | | Allow NULL? |
| 7 | ELEG | Indicate whether School allowance is applicable | char | 1 | 0 | | | | Allow NULL? |
| 8 | PER1 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | AMT1 | Payment Amount | decimal | 13 | 2 | | | | |
| 10 | PER2 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | AMT2 | Payment Amount | decimal | 13 | 2 | | | | |
| 12 | PER3 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | AMT3 | Payment Amount | decimal | 13 | 2 | | | | |
| 14 | PER4 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | AMT4 | Payment Amount | decimal | 13 | 2 | | | | |
| 16 | PER5 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | AMT5 | Payment Amount | decimal | 13 | 2 | | | | |
| 18 | PER6 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | AMT6 | Payment Amount | decimal | 13 | 2 | | | | |
| 20 | PER7 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | AMT7 | Payment Amount | decimal | 13 | 2 | | | | |
| 22 | PER8 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | AMT8 | Payment Amount | decimal | 13 | 2 | | | | |
| 24 | PER9 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | AMT9 | Payment Amount | decimal | 13 | 2 | | | | |
| 26 | PER10 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | AMT10 | Payment Amount | decimal | 13 | 2 | | | | |
| 28 | PER11 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | AMT11 | Payment Amount | decimal | 13 | 2 | | | | |
| 30 | PER12 | School Allowance payment Schedule Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | AMT12 | Payment Amount | decimal | 13 | 2 | | | | |
| 32 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |