Service dimensions

Dimension Level Key Column01 Level_Key Column02 till Level Key Column05
Customer Claim tscmm100.logical_company +'*'+ tscmm100.ccno Empty
Customer Claim Line tscmm110.logical_company +'*'+ tscmm110.ccno +'*'+ tscmm110.lino Empty
Service and Order Relation tsmdm400. logical_company +'*'+ tsmdm400.orig +'*'+ tsmdm400.orno +'*'+ tsmdm400.apln +'*'+ tsmdm400.cotp_kw +'*'+ tsmdm400.csln +'*'+ tsmdm400.mtyp_kw +'*'+ tsmdm400.seqn Empty
Service Call tsclm100.logical_company +'*'+ tsclm100.ccll Empty
Service Configuration Line tsctm110.logical_company +'*'+ tsctm110.term +'*'+ tsctm110.cfln Empty
Service Contract Change Number tsctm320.logical_company +'*'+ tsctm320.csco +'*'+ tsctm320.cchn Empty
Service Contract tsctm300.logical_company +'*'+ tsctm300.csco Empty
Service Contract Quote tsctm200.logical_company +'*'+ tsctm200.ccqu Empty
Service Coverage Term tsctm120.logical_company +'*'+ tsctm120.cfln +'*'+ tsctm120.term +'*'+ _tsctm120.cctp +'*'+ tsctm120.cotp_kw +'*'+ tsctm120.nrbt Empty
Service Coverage Term Line tsctm131.logical_company +'*'+ tsctm131.cfln +'*'+ tsctm131.term] +'*'+ tsctm131.cctp +'*'+ tsctm131.cotp_kw +'*'+ tsctm131.nrbt +'*'+ tsctm131.cseq Empty
Service Depot Repair tsmsc100.logical_company +'* + tsmsc100.cmso Empty
Service Depot Repair Item Line tscmm100.logical_company +'*'+ tscmm110.ccno +'*'+ tscmm110.lino Empty
Service Failure Analysis tsclm410.logical_company +'*'+ tsclm410.orig +'*'+ tsclm410.orno +'*'+ tsclm410.acln +'*'+ tsclm410.lino +'*'+ tsclm410.seqn +'*'+ tsclm410.ccll +'*'+ VARCHAR([LN_tsclm410.date]) +'*'+ VARCHAR([LN_tsclm410.hidt]) Empty
Service Order Activity tssoc210.logical_company +'*'+ tssoc210.orno +'*'+ tssoc210.acln Empty
Service Order tssoc200.logical_company +'*'+ tssoc200.orno Empty
Service Probability Analysis

tsclm350.logical_company +'*'+ tsclm350.orig_kw +'*'+ tsclm350.orno +'*'+ tsclm350.acln +'*'+ tsclm350.ccll +'*'+ tsclm350.hidt

 Empty
Service Quote Cost Line tsepp120.logical_company +'*'+ tsepp120.orno +'*'+ tsepp120.revn +'*'+ tsepp120.csln +'*'+ tsepp120.cltn Empty
Service Quote tsepp100.logical_company] +'*'+ tsepp100.orno +'*'+ tsepp100.revn Empty
Service Quote Line tsepp110.logical_company +'*'+ tsepp110.orno +'*'+ tsepp110.revn +'*'+ tsepp110.pono +'*'+ tsepp110.altn Empty
Service Reason tcmcs005.logical_company +'*'+ tcmcs005.cdis Empty
Service Rental Equipment Calendar tscfg262.logical_company +'*'+ tscfg262.item +'*'+ tscfg262.sern +'*'+ tscfg262.stdt +'*'+ tscfg262.occu Empty
Service Serialized Item tscfg200.logical_company +'*'+ IIF(tscfg200.item IS NULL ,tscfg200.sern, tscfg200.item +'*'+ tscfg200.sern) Empty
Service Task tsmdm015.logical_company +'*'+ tsmdm015.ctsk Empty
Service Warranty tsctm500.logical_company +'*'+ tsctm500.gwte Empty
Service Warranty Transaction tsctm501.v_logical_company +'*'+ tsctm501.wrty +'*'+ tsctm501.item +'*'+ tsctm501.sern +'*'+ VARCHAR (tsctm501.trtm) +'*'+ tsctm501.seqn Empty
Supplier Claim tscmm200.logical_company +'*'+ tscmm200.scno Empty
Supplier Claim Line tscmm210.logical_company +'*'+ tscmm210.scno +'*'+ tscmm210.lino Empty
Work Order Activity tssoc210.logical_company +'*'+ tssoc210.orno +'*'+ tssoc210.acln Empty
Work Order tswcs200.logical_company +'*'+ tswcs200.orno Empty