| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | J_1BNFVEHICLE | Nota Fiscal: Vehicle Details | 22 | VIN | VIN Condition | nvarchar | 1 | 0 | | |
| TOPClaims Management |
| 2 | ICLITEMAU | Damaged Vehicle | 11 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | | |
| 3 | ICLNOLDOAU | Notice of Loss: Damaged Vehicle | 16 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | | |
| 4 | ICLPOLOAU | Insured Vehicle | 12 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | | |
| 5 | ICSITEMAU | Damaged Vehicle | 11 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | | |
| 6 | ICSPOLOAU | Insured Vehicle | 12 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | | |
| TOPFinancial Services Localization |
| 7 | /GSINS/DAMAGES | Contains descriptions of damages | 12 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | | |
