I_InsurClmExpenseReservesInqry

Expense Reserves | view: IICLEXPNRESERVE | Extraction: Not supported | Component: Claims Management

Tables used: ICLCLAIM, ICLPOLM, ICLPAY, ICLPAYI, ICLPOL, ICLPARTOCC, ICLRESERVE, ICLSUBCL, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, TICL321, TICL055, ICL_CPROFILE_BT, ICLPOLBF, TICL160, TICL161, TICL020, TICL020T, TICL030, TICL030T, TICL004T, TICL003, BUT021_FS, TB008S, TB008U, TICL162, TICL100, TICL053, TICL005, TICL323

🔑 Keys (5)
💰 Amounts (5)
∑ Quantities
📅 Dates (2)
☰ Categorical (3)
Other (7)
🔗 Relations (14)

Column Name	Description
InsuranceClaim FK	Number of Claim
InsurClmSubclm FK	Subclaim
InsurClmRsrvType FK	Reserve Type
InsurClmReserveCurrency FK	Currency of Reserve (Transactn Crcy)
InsurClmReserveUUID	16 Byte UUID in 16 Bytes (Raw Format)

Column Name	Description
💲 Currency of Reserve (Transactn Crcy) (InsurClmReserveCurrency):
GrossReserveAmount	Expenditure per Reserve Type
InsurClmNetReserveAmount	Expenditure per Reserve Type
InsurClmOutsdngRsrvAmt	Expenditure per Reserve Type
InsurClmReservePaytAmt	null
InsurClmRsrvPendingAmount	Pending Reserve

Column Name	Description

Column Name	Description
InsurClmChangeDate	null
PostingDate	Posting Date

Column Name	Description
InsurClmLossExpnType	Losses or Expenses	Show values
InsurClmExpectationReserve	Expectation Reserve	Show values
InsurClmRsrvMethodName	Reserving Method	Show values

Column Name	Description	Domain name
InsurClmRsrvChangeTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
InsurClmRsrvPaidToDatePct	null
InsurClmRsrvMethodText	Short Text for Fixed Values	DDTEXT
InsurClmReserveChangeRsnName	Name of Claim Reserve Change Reason	TEXT25
InsurClmImageURL	null
InsurClmRsrvTypeDesc	null
InsurClmSubclmDescriptionText	null

Master Data Relations	Join Conditions
Reserve Change Reason Client Reserve Change Reason	`I_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL030.CLIENT` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECHANGERSN == TICL030.RESCHREASON`
Currency of Reserve (Transactn Crcy) Client Currency of Reserve (Transactn Crcy) Currency of Reserve (Transactn Crcy)	`I_INSURCLMEXPENSERESERVESINQRY.MANDT == TCURC.MANDT` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECURRENCYFOREDIT == TCURC.WAERS` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECURRENCY == TCURC.WAERS`
Currency of Reserve (Transactn Crcy) Client Currency of Reserve (Transactn Crcy) Currency of Reserve (Transactn Crcy)	`I_INSURCLMEXPENSERESERVESINQRY.MANDT == TCURC.MANDT` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECURRENCYFOREDIT == TCURC.WAERS` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECURRENCY == TCURC.WAERS`
Reserve Type Reserve Type Reserve Type Client	`I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVETYPEFOREDIT == TICL020.RESTYPE` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRSRVTYPE == TICL020.RESTYPE` `I_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL020.CLIENT`
Reserve Type Reserve Type Reserve Type Client	`I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVETYPEFOREDIT == TICL020.RESTYPE` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMRSRVTYPE == TICL020.RESTYPE` `I_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL020.CLIENT`
Subclaim Type Subclaim Type Client	`I_INSURCLMEXPENSERESERVESINQRY.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE` `I_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL004.CLIENT`
Internal Claim Type ? Internal Claim Type Client	`I_INSURCLMEXPENSERESERVESINQRY.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPE == TICL011.CLTYPE` `I_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL011.CLIENT`
Generation of Internal Claim Type Generation of Internal Claim Type Internal Claim Type Client	`I_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPEGENERATION == TICL011.VERSION` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPE == TICL011.CLTYPE` `I_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL011.CLIENT`
Internal Claim Type Version Generation of Internal Claim Type Internal Claim Type Client Internal Claim Type Version	`I_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPEGENERATION == TICL003.GENERAT` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPE == TICL003.CLTYPE` `I_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL003.CLIENT` `I_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPEVERS == TICL003.VERSION`