| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ICLBPCLAIM | Archived ICLPARTOCC Entries per Business Partner | 5 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
2 | ICLCCEVENTCO | Multiple Contract Handling - Contract Overview | 5 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
3 | ICL_MC_INC_COVT | Mapping of Incident-Specific Fields to Subclaim Type | 3 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
4 | ICSCCEVENTCO | Bearbeitung mehrerer Verträge - Vertragsübersicht | 5 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
5 | TICL501 | Cross LOB: Assignment of Contract-LOB to Claim-LOB | 3 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
TOPClaims Management |
6 | ICLCLAIM | Claim | 19 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
7 | ICLITEMEQ | Damaged Item | 13 | LOSSTYPE | Scope of Loss | nvarchar | 1 | 0 | | |
8 | ICLITEMRE | Damaged Real Estate | 13 | LOSSTYPE | Scope of Loss | nvarchar | 1 | 0 | | |
9 | ICLNOL | Notice of Loss | 9 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
10 | ICL_CCDLOCK | Maintenance: Collection Lock Reasons for Automatic Creation | 2 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
11 | ICSCLAIM | Claim | 19 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
12 | ICSITEMEQ | Damaged Item | 13 | LOSSTYPE | Scope of Loss | nvarchar | 1 | 0 | | |
13 | ICSITEMRE | Damaged Real Estate | 13 | LOSSTYPE | Scope of Loss | nvarchar | 1 | 0 | | |
14 | TICL002 | Subtypes of Claim Bundle Types | 11 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
15 | TICL060 | Incident Type of a Claim | 2 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
16 | TICL060T | Incident Type of a Claim - Text | 3 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
17 | TICL062 | Policy Product - Internal Claim Type - Determination | 5 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
18 | TICL101 | Scope of Loss | 3 | LOSSTYPE | Scope of Loss | nvarchar | 1 | 0 | | |
19 | TICL101T | Scope of Claim Text | 4 | LOSSTYPE | Scope of Loss | nvarchar | 1 | 0 | | |
20 | TICL205 | Incident Type of a Claim | 2 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
21 | TICL205T | Incident Type of Claim - Text | 3 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |
22 | TICL208 | Notice of Loss Category: Permitted Fault | 2 | LOSSTYPE | Incident Type of a Claim | nvarchar | 4 | 0 | | |