Service Warranty Transaction

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

Table	Description
tsctm501	Warranty Transactions

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Company	tsctm501_compnr
Coverage Type	tsctm501.cctp
Drillback to LN	‘LN’
Installation Group	tsctm501.clst
Item	tsctm501.item
Order	tsctm501.orno
Order Detail Line	tsctm501.cvln
Order Line	tsctm501.pono
Order Type	tsctm501.ortp
Order Type Filter	tsctm501.ortp
Order Type Sort	tsctm501.ortp
Serial Number	tsctm501.sern
Service Type	tsctm501.cstp
Unknown	1 for null records, else 0
Warranty Transaction Line	tsctm501.seqn
Warranty Type	tsctm501.wrtp
Warranty Type Filter	tsctm501.wrtp
Warranty Type Sort	tsctm501.wrtp
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields