ICLITEMAU

Damaged Vehicle | #transactional | Component: Claims Management

🔑 Keys (4)
💰 Amounts (4)
∑ Quantities (4)
📅 Dates (18)
☰ Categorical (21)
Other (15)
🔗 Relations (16)

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 vehicle

Column Name	Description
💲 Currency of Value at Conclusion of Policy (PCVCURR):
PCV	Value of Object at Contract Conclusion
💲 Currency of Actual Cash Value (CURR):
SALVVALUE	Salvage Value as Amount of Money
ESTACV	Salvage: Average Salvage Potential
DAILYRATE	Salvage: Daily Standing Charges at Salvage Yard

Column Name	Description
📏 Unit for Cubic Capacity (CAPUNIT):
CAPACITY	Engine Capacity of Insured Vehicle
📏 Unit for mileage (MILEAGEUNIT):
MILEAGE	Mileage
📏 Tread Unit (TREADUNIT):
TREADF	Tread of Front Tires
TREADR	Tread of Rear Tires

Column Name	Description
FIRSTREG	Date of First Registration
INSPDATE	Inspection Date
RECOVERDATE	Recovery Date of Object
OWNERCHANGE	Last Change of Vehicle Owner: Date
EVALDATE	Evaluation Date for Salvage
DETERMDATE	Date: Damaged Objected Determined as Salvage
DATEATRPR	Salvage: Arrival Date at Repair Shop
RPTDTOCB	Date Reported to Police
SOLDDATE	Date Salvage Item Sold
ASSIGNDATE	Salvage: Date Assigned to Salvage Company
RETRVDATE	Salvage: Arrival Date at Salvage Yard
SETTLEDATE	Salvage: Settlement Date
TITLETOSALV	Date on Which Title Was Transferred to Salvor
TITLEFMSALV	Date on Which Title Was Received by Salvor
TITLETOSTATE	Date: Title Sent To State
TITLEFMSTATE	Date on Which Title Received by State
TITLERECV	Date on Which Insurer Received Title
CERTFICATEDT	Salvage: Certificate Date

Column Name	Description
ACTIVE	Table entry is active (A) or in suspense (S)	Show values
DELETED	Database Line Status (Original, Changed, Deleted)	Show values
GEAR	Gear Type	Show values
XTHIRDPARTY	Flag: Liability?	Show values
LEASING	Flag: Paid/Leased/Security Certificate	Show values
XPERM	Flag: Driving with permission?	Show values
XDAM	Flag: Object Damaged?	Show values
XVEHICIT	Flag: Vehicle Cited?	Show values
XDRIVCIT	Flag: Driver Cited?	Show values
XPVENDOR	Flag: Willing to Use Preferred Vendor?	Show values
XPARKED	Vehicle Was Parked When Loss Occurred	Show values
XPRE	Flag: Preexisting Damage?	Show values
DRIVABLE	Damaged Vehicle Is Not Roadworthy	Show values
OWPHREL	Relationship between Owner and PH	Show values
XTOTDAMAGE	Flag: Total Loss	Show values
XSTOLEN	Flag: Stolen?	Show values
XRECOVERED	Flag: Stolen Object Recovered?	Show values
MONTH_FROM	Month From Which Seasonal License Plate Issued	Show values
MONTH_TO	Month up to Which Seasonal License Plate Issued	Show values
XOWNERRET	Flag: Retained by Owner?	Show values
SEL_LOCATION	Location of Damaged Object	Show values

Column Name	Description	Domain name
CHANGETIME	Changed: Date + Time	ICL_TIMESTAMP
VIN	Vehicle Identification Number	CHAR17
PLATENO	License Plate Number	CHAR12
CONSTYEAR	Construction Year of Insured Vehicle	BU_YEAR
COLOR	Color	CHAR10
WHENSEEN	Note on Inspection	TEXT15
GENERALINSP	Next Mandatory Technical Inspection	ICL_INSPECTION
HISTRATE	History Rate in Percent	ICL_PERCENT
STOCKNUM	Salvage: Stock Number	ICL_SALVSTOCK
YARDLOC	Salvage: Salvage Yard Location	ICL_SALVYARDLOC
REFNO	External Reference Number	ICL_SCLITEMREF
PDREF	Reference to Purchasing Document	ICL_PDREF_DOMAIN
PDPOS	Reference to Item Number in Purchasing Document	ICL_PDPOS
REF_LOCCAT	Reference Location for External Services	ICL_EXTSVCS_REFCAT
PTYPE	Transaction Type in Procurement Process	ICL_PTYPE

Master Data Relations	Join Conditions
Unit for Cubic Capacity	`ICLITEMAU.CLIENT == T006.MANDT` `ICLITEMAU.CAPUNIT == T006.MSEHI`
Changed By	`ICLITEMAU.CLIENT == USR02.MANDT` `ICLITEMAU.CHANGEDBY == USR02.BNAME`
Client	`ICLITEMAU.CLIENT == T000.MANDT`
Currency of Actual Cash Value	`ICLITEMAU.CLIENT == TCURC.MANDT` `ICLITEMAU.CURR == TCURC.WAERS`
Location where damaged object can be seen Location where damaged object can be seen ? ?	`ICLITEMAU.CLIENT == ADRC.CLIENT` `ICLITEMAU.LOCATION == ADRC.ADDRNUMBER` `ICLITEMAU.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `ICLITEMAU.[column in domain "AD_NATION"] == ADRC.NATION`
Unit for mileage	`ICLITEMAU.CLIENT == T006.MANDT` `ICLITEMAU.MILEAGEUNIT == T006.MSEHI`
Category of Insured Object ? Insured Object Model Make of Insured Object Category of Insured Object	`ICLITEMAU.CLIENT == ICLPROPTY.CLIENT` `ICLITEMAU.[column in domain "ICL_IOBCAT"] == ICLPROPTY.PROPCAT` `ICLITEMAU.PROPMODEL == ICLPROPTY.PROPMODEL` `ICLITEMAU.PROPMAKE == ICLPROPTY.PROPMAKE` `ICLITEMAU.MODELTY == ICLPROPTY.MODELTY`
Currency of Value at Conclusion of Policy	`ICLITEMAU.CLIENT == TCURC.MANDT` `ICLITEMAU.PCVCURR == TCURC.WAERS`
Country/Region Key Country/Region Key Client	`ICLITEMAU.PLATECOUNTRY == T005.LAND1` `ICLITEMAU.CLIENT == T005.MANDT`
Region (State, Province, County) Country/Region Key Region (State, Province, County)	`ICLITEMAU.CLIENT == T005S.MANDT` `ICLITEMAU.PLATECOUNTRY == T005S.LAND1` `ICLITEMAU.PLATEREGION == T005S.BLAND`
Insured Object Model ? Insured Object Model Client Make of Insured Object	`ICLITEMAU.[column in domain "ICL_IOBCAT"] == ICLPROPMO.PROPCAT` `ICLITEMAU.PROPMODEL == ICLPROPMO.PROPMODEL` `ICLITEMAU.CLIENT == ICLPROPMO.CLIENT` `ICLITEMAU.PROPMAKE == ICLPROPMO.PROPMAKE`
Purpose of Trip Purpose of Trip ? Client	`ICLITEMAU.PURPTRIP == TICL303.PROPUSE` `ICLITEMAU.[column in domain "ICL_IOBCAT"] == TICL303.PROPCAT` `ICLITEMAU.CLIENT == TICL303.CLIENT`
Tread Unit	`ICLITEMAU.CLIENT == T006.MANDT` `ICLITEMAU.TREADUNIT == T006.MSEHI`

Other Relations \| to Master Data Relations ↑	Join Conditions
Make of Insured Object ? Make of Insured Object Client	`ICLITEMAU.[column in domain "ICL_IOBCAT"] == ICLPROPMA.PROPCAT` `ICLITEMAU.PROPMAKE == ICLPROPMA.PROPMAKE` `ICLITEMAU.CLIENT == ICLPROPMA.CLIENT`