Customer Claim

This table shows the table from which fields are retrieved for the dimension:

Table	Description
tscmm100	Customer Claim

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Approval Date	tscmm100.apdt
Approval Percentage	tscmm100.aper
Cancel Date	tscmm100.cndt
Cancel Reason	tscmm100.cnre
Claim Origin	tscmm100.corg
Claim Origin Filter	tscmm100.corg
Claim Origin Sort	tscmm100.corg
Company	tscmm100.compnr
Creation Date	tscmm100.crtm
Currency	tscmm100.ccur
Customer Claim	tscmm100.ccno
Customer Claim Desc	tscmm100.desc
Customer Claim ID Desc	tscmm100.ccno + tscmm100.desc
Failure Date	tscmm100.fldt
Installation Group	tscmm100.clst
Item	tscmm100.item
Latest Finish Date	tscmm100.lftm
Line of Business	tscmm100.cbrn
Measured Value	tscmm100.mvln
Measurement Type	tscmm100.cmea
Original Order System	tscmm100.oosy
Original Order System Filter	tscmm100.oosy
Original Order System Sort	tscmm100.oosy
Partially Approved	tscmm100.papr
Partially Approved Filter	tscmm100.papr
Partially Approved Sort	tscmm100.papr
Planned Delivery Date	tscmm100.pdtm
Problem	tscmm100.cprl
Project	tscmm100.cprj
Project Activity	tscmm100.pcac
Project Element	tscmm100.cspa
Project Peg Origin Filter	tscmm100.cpor
Project Peg Origin Sort	tscmm100.cpor
Rejected Reason	tscmm100.rjre
Rejection Date	tscmm100.rjdt
Sales Type	tscmm100.styp
Serial Number	tscmm100.sern
Service Office	tscmm100.cwoc
Service Type	tscmm100.cstp
Solution	tscmm100.cstn
Status	tscmm100.stat
Status Filter	tscmm100.stat
Status Sort	tscmm100.stat
Unknown	1 for null records, else 0
Deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields