ICSITEMEQ

Damaged Item | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM FK Number of Claim
DAMAGEDOBJ FK Damaged Item
CHANGETIME Changed: Date + Time
Column Name Description
💲 Currency of Actual Cash Value (CURR):
ESTACV Salvage: Average Salvage Potential
SALVVALUE Salvage Value as Amount of Money
Column Name Description
Column Name Description
ESTREPAIRDATE Estimated Repair Date
ACTREPAIRDATE Actual Repair Date
EVALDATE Evaluation Date for Salvage
DETERMDATE Date: Damaged Objected Determined as Salvage
ASSIGNDATE Salvage: Date Assigned to Salvage Company
RETRVDATE Salvage: Arrival Date at Salvage Yard
SETTLEDATE Salvage: Settlement Date
SOLDDATE Date Salvage Item Sold
TITLERECV Date on Which Insurer Received Title
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
XDAMAGED Flag: Damaged? Show values
XRECOVERED Flag: Stolen Object Recovered? Show values
XPVENDOR Flag: Willing to Use Preferred Vendor? Show values
XSTOLEN Flag: Stolen? Show values
XRENTAL Flag: Rental? Show values
OPERABLE Home Contents/Object Operable? Show values
XTOTDAMAGE Flag: Total Loss Show values
XOWNERRET Flag: Retained by Owner? Show values
SEL_LOCATION Location of Damaged Object Show values
Column Name Description Domain name
CONSTYEAR Construction Year of (Home Contents) Item BU_YEAR
SERIALNO Serial Number of (Home Contents) Item ICL_PEQUIP01
WHENSEEN Note on Inspection TEXT25
HISTRATE History Rate in Percent ICL_PERCENT
NOTE Note on Salvage TEXT50
Master Data Relations Join Conditions
Changed By
  • ICSITEMEQ.CLIENT == USR02.MANDT
  • ICSITEMEQ.CHANGEDBY == USR02.BNAME
Client ICSITEMEQ.CLIENT == T000.MANDT
Currency of Actual Cash Value
  • ICSITEMEQ.CLIENT == TCURC.MANDT
  • ICSITEMEQ.CURR == TCURC.WAERS
Location where damaged object can be seen
  • Location where damaged object can be seen
  • ?
  • ?
  • ICSITEMEQ.CLIENT == ADRC.CLIENT
  • ICSITEMEQ.LOCATION == ADRC.ADDRNUMBER
  • ICSITEMEQ.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ICSITEMEQ.[column in domain "AD_NATION"] == ADRC.NATION
Scope of Loss
  • Scope of Loss
  • Client
  • ?
  • ICSITEMEQ.LOSSTYPE == TICL101.LOSSTYPE
  • ICSITEMEQ.CLIENT == TICL101.CLIENT
  • ICSITEMEQ.[column in domain "ICL_DAMCAT"] == TICL101.DAMCAT
Insured Object Model
  • ?
  • Insured Object Model
  • Client
  • Make of Insured Object
Use at Time of Loss/Claim
  • Use at Time of Loss/Claim
  • ?
  • Client
  • ICSITEMEQ.PROPUSE == TICL303.PROPUSE
  • ICSITEMEQ.[column in domain "ICL_IOBCAT"] == TICL303.PROPCAT
  • ICSITEMEQ.CLIENT == TICL303.CLIENT
Other Relations | to Master Data Relations ↑ Join Conditions
Make of Insured Object
  • ?
  • Make of Insured Object
  • Client
  • ICSITEMEQ.[column in domain "ICL_IOBCAT"] == ICLPROPMA.PROPCAT
  • ICSITEMEQ.MAKE == ICLPROPMA.PROPMAKE
  • ICSITEMEQ.CLIENT == ICLPROPMA.CLIENT