| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | VIBDARNUMRANGE | Number Range | 9 | RANGETO | Last number | nvarchar | 13 | 0 | | |
| TOPClaims Management |
| 2 | ICLCCEVENT | Claim Bundle | 17 | RANGETO | Event Period: Date To | nvarchar | 8 | 0 | | |
| 3 | ICLCCEVENTR | Claim Bundle - Region - Assignment | 11 | RANGETO | Event Period: Date To | nvarchar | 8 | 0 | | |
| 4 | ICLCCEVENTZ | Claim Bundle - Postal Code - Assignment | 9 | RANGETO | Event Period: Date To | nvarchar | 8 | 0 | | |
| 5 | ICLEBULKSBR | Coll.Subro/Recovery Settlement | 12 | RANGETO | Payment Assignment: Date To | nvarchar | 8 | 0 | | |
| 6 | ICL_NEG | Negotiation | 13 | RANGETO | Upper Limit of Target Settlement Range | decimal | 15 | 2 | | |
| 7 | ICL_NEGS | Negotiation (Shadow Table) | 13 | RANGETO | Upper Limit of Target Settlement Range | decimal | 15 | 2 | | |
| 8 | ICSCCEVENT | Shadow Table Claim Bundle | 17 | RANGETO | Event Period: Date To | nvarchar | 8 | 0 | | |
| 9 | ICSCCEVENTR | Claim Bundle - Region - Assignment | 11 | RANGETO | Event Period: Date To | nvarchar | 8 | 0 | | |
| 10 | ICSCCEVENTZ | Claim Bundle - Postal Code - Assignment | 9 | RANGETO | Event Period: Date To | nvarchar | 8 | 0 | | |
| 11 | ICSEBULKSBR | Shadow Table Collective Subrogation/Recovery Settlement | 12 | RANGETO | Payment Assignment: Date To | nvarchar | 8 | 0 | | |
