| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | CHAR | (N' ') | No | | ICL_ACTIVE | Allow NULL? |
| 3 | CLAIM | Policy Snapshot for Claim | nvarchar | 17 | 0 | CHAR | (N' ') | No | ICLCLAIM | ICL_CLAIM1 | Allow NULL? |
| 4 | POLVNR | Counter of Contract Version | nvarchar | 2 | 0 | NUMC | (N'00') | No | ICLPOL | ICL_POLVCNTR | Allow NULL? |
| 5 | INSUREDOBJ | Insured Vehicle | nvarchar | 4 | 0 | NUMC | (N'0000') | No | ICLPOLO | ICL_IVEHICLE | Allow NULL? |
| 6 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | DEC | ((0)) | Yes | | ICL_CHANGEUTC1 | |
| 7 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | ICL_CHANGEDBY | Allow NULL? |
| 8 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_RECSTATUS | Allow NULL? |
| 9 | PROPMAKE | Make of Insured Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ICLPROPMA | ICL_IOBMA | Allow NULL? |
| 10 | PROPMODEL | Insured Object Model | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ICLPROPMO | ICL_IOBMODEL | Allow NULL? |
| 11 | MODELTY | Category of Insured Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ICLPROPTY | ICL_IOBTY | Allow NULL? |
| 12 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ICL_VIN | Allow NULL? |
| 13 | PLATECOUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 14 | PLATEREGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 15 | PLATENO | License Plate Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ICL_LICENSE | Allow NULL? |
| 16 | CONSTYEAR | Construction Year of Insured Vehicle | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ICL_CONSTYEAR | Allow NULL? |
| 17 | CAPACITY | Engine Capacity of Insured Vehicle | decimal | 4 | 0 | QUAN | ((0)) | Yes | | ICL_CAPACITY | |
| 18 | CAPUNIT | Unit for Cubic Capacity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ICL_CAPUNIT | Allow NULL? |
