ICSITEMEQ - Damaged Item

Damaged Item information is stored in SAP table ICSITEMEQ.
It is part of development package ICL_CDC in software component FS-CM. This development package consists of objects that can be grouped under "FS-CM: Data Capture".

Fields for table ICSITEMEQ

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6T000
ACTIVETable entry is active (A) or in suspense (S)XICL_ACTIVECHAR2
CLAIMNumber of ClaimXICL_CLAIMCHAR34ICLCLAIM
DAMAGEDOBJDamaged ItemXICL_DAMOBJEQNUMC8ICLDAMOBJ
CHANGETIMEChanged: Date + TimeXICL_CHANGEUTC1DEC8
.INCLUDEICL_INCL_VER60
CHANGEDBYChanged ByICL_CHANGEDBYCHAR24USR02
DELETEDDatabase Line Status (Original, Changed, Deleted)ICL_RECSTATUSCHAR2
.INCLUDEICS_ITEMEQ0
MAKEMake of Insured ObjectICL_IOBMACHAR8ICLPROPMA
MODELInsured Object ModelICL_IOBMODELCHAR8ICLPROPMO
CONSTYEARConstruction Year of (Home Contents) ItemICL_PEQUIP02NUMC8
SERIALNOSerial Number of (Home Contents) ItemICL_PEQUIP01CHAR24
LOCATIONLocation where damaged object can be seenICL_SCIAUADRCHAR20ADRC
LOSSTYPEScope of LossICL_ITEMAULTCHAR2TICL101
PROPUSEUse at Time of Loss/ClaimICL_IOBUSELCHAR4TICL303
XDAMAGEDFlag: Damaged?ICL_ITEMES01CHAR2
XRECOVEREDFlag: Stolen Object Recovered?ICL_ITEMWA02CHAR2
XPVENDORFlag: Willing to Use Preferred Vendor?ICL_ITEMAU05CHAR2
XSTOLENFlag: Stolen?ICL_ITEMPP01CHAR2
XRENTALFlag: Rental?ICL_ITEMPP02CHAR2
OPERABLEHome Contents/Object Operable?ICL_ITEMEQ01CHAR2
ESTREPAIRDATEEstimated Repair DateICL_ITEMEQ02DATS16
ACTREPAIRDATEActual Repair DateICL_ITEMEQ03DATS16
WHENSEENNote on InspectionICL_ITEMEQ04CHAR50
XTOTDAMAGEFlag: Total LossICL_ITEMAU11CHAR2
.INCLUDEICS_ITEMSALVEQ0
XOWNERRETFlag: Retained by Owner?ICL_SALVOWNRETCHAR2
EVALDATEEvaluation Date for SalvageICL_SALVEVALDTDATS16
DETERMDATEDate: Damaged Objected Determined as SalvageICL_SALVDETRDTDATS16
ESTACVSalvage: Average Salvage PotentialICL_SALVESTACVCURR8
SALVVALUESalvage Value as Amount of MoneyICL_SALVVALUECURR8
CURRCurrency of Actual Cash ValueICL_ACVCURRCUKY10TCURC
HISTRATEHistory Rate in PercentICL_HISTRATEIDEC3
ASSIGNDATESalvage: Date Assigned to Salvage CompanyICL_ASSIGNDTDATS16
RETRVDATESalvage: Arrival Date at Salvage YardICL_RETRVDTDATS16
SETTLEDATESalvage: Settlement DateICL_SETTLEMENTDTDATS16
SOLDDATEDate Salvage Item SoldICL_SALVSOLDDDATS16
TITLERECVDate on Which Insurer Received TitleICL_TITLTOINSDATS16
NOTENote on SalvageICL_SALVAGE_NOTECHAR100
SEL_LOCATIONLocation of Damaged ObjectICL_INSPLOCCHAR2
Privacy Policy