| 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 | * | MANDT | Allow NULL? |
| 2 | CLAIM | Number of Claim | nvarchar | 17 | 0 | CHAR | (N' ') | No | * | ICL_CLAIM | Allow NULL? |
| 3 | LB | Left Bottom Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | NUMC | (N'0') | No | | /GSINS/PIC_LEFT_BOTTOM | Allow NULL? |
| 4 | LT | Left Top Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | NUMC | (N'0') | No | | /GSINS/PIC_LEFT_TOP | Allow NULL? |
| 5 | MB | Left Middle Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | NUMC | (N'0') | No | | /GSINS/PIC_MIDDLE_BOTTOM | Allow NULL? |
| 6 | MT | Middle Top Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | NUMC | (N'0') | No | | /GSINS/PIC_MIDDLE_TOP | Allow NULL? |
| 7 | RB | Right Bottom Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | NUMC | (N'0') | No | | /GSINS/PIC_RIGHT_BOTTOM | Allow NULL? |
| 8 | RT | Right Top Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | NUMC | (N'0') | No | | /GSINS/PIC_RIGHT_TOP | 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 | PLATENO | License Plate Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ICL_LICENSE | Allow NULL? |
| 12 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ICL_VIN | Allow NULL? |
