| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PTYPN | Policy Type Number - Health Insurance | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | VSGES | Insurance companies | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | PONUM | Policy Number - OMAN | nvarchar | 15 | 0 | | | | Allow NULL? |
| 7 | MIAMT | Insured Amount for Male | decimal | 13 | 2 | | | | |
| 8 | MPAMT | Insurance Premium Amount for Male | decimal | 13 | 2 | | | | |
| 9 | FIAMT | Insured Amount for Unmarried Female | decimal | 13 | 2 | | | | |
| 10 | FPAMT | Insurance Premium Amount for Unmarried Female | decimal | 13 | 2 | | | | |
| 11 | MFIAT | Insured Amount for Married Female | decimal | 13 | 2 | | | | |
| 12 | MFPAT | Insurance Premium Amount for Married Female | decimal | 13 | 2 | | | | |
| 13 | NELSP | Number of Eligible Spouses | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | NELCH | Number of Eligible Children | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | MCIAT | Insured Amount for Son | decimal | 13 | 2 | | | | |
| 16 | MCIPA | Insurance Premium Amount for Son | decimal | 13 | 2 | | | | |
| 17 | FCIAT | Insured Amount for Daughter | decimal | 13 | 2 | | | | |
| 18 | FCIPA | Insurance Premium for Daughter | decimal | 13 | 2 | | | | |
| 19 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |