| 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 | Number of Claim | nvarchar | 17 | 0 | CHAR | (N' ') | No | ICLCLAIM | ICL_CLAIM | Allow NULL? |
| 4 | DIPLIT_ID | Distribution Plan Item ID | nvarchar | 32 | 0 | CHAR | (N' ') | No | ICLDIPL | ICL_MI_DIPLIT_ID | Allow NULL? |
| 5 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | DEC | ((0)) | No | | ICL_CHANGEUTC1 | |
| 6 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | ICL_CHANGEDBY | Allow NULL? |
| 7 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_RECSTATUS | Allow NULL? |
| 8 | SUBOBJECT | Claim Subobject | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | ICL_SUBOBJECT | Allow NULL? |
| 9 | DIPL_ID | Distribution Plan ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | ICLDIPL | ICL_MI_DIPL_ID | Allow NULL? |
| 10 | DIPLIT_NUM | Number of a Distribution Plan Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ICL_MI_DIPLIT_NUM | Allow NULL? |
| 11 | PARTTY | Participation Type in Multiple Insurance | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TICL286 | ICL_MI_PARTTY | Allow NULL? |
| 12 | SETTY | Settlement Type in Multiple Insurance | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TICL287 | ICL_MI_SETTY | Allow NULL? |
| 13 | X_OWN_SHARE | Flag for Share of Own Insurance in Multiple Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_MI_X_OWN_SHARE | Allow NULL? |
| 14 | SHARE_PRC | Share of Participant in Multiple Insurance (Percentage) | decimal | 5 | 2 | DEC | ((0)) | Yes | | ICL_MI_SHARE_PRC | |
| 15 | SHARE_AMT | Share of Participant in Multiple Insurance (Absolute) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ICL_MI_SHARE_AMT | |
| 16 | REF | Reference | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ICL_MI_REF | Allow NULL? |
| 17 | REPID | Coinsurance Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ICL_REPID | Allow NULL? |
