| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | | | | Allow NULL? |
| 3 | CLAIM | Policy Snapshot for Claim | nvarchar | 17 | 0 | | | | Allow NULL? |
| 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | INSUREDOBJ | Insured Vehicle | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | | | | |
| 7 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | | | | Allow NULL? |
| 9 | PROPMAKE | Make of Insured Object | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | PROPMODEL | Insured Object Model | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | MODELTY | Category of Insured Object | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | | | | Allow NULL? |
| 13 | PLATECOUNTRY | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | PLATEREGION | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | PLATENO | License Plate Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | CONSTYEAR | Construction Year of Insured Vehicle | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | CAPACITY | Engine Capacity of Insured Vehicle | decimal | 4 | 0 | | | | |
| 18 | CAPUNIT | Unit for Cubic Capacity | nvarchar | 3 | 0 | | | | Allow NULL? |