Service Call
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tcmcs010 | Countries |
| tsbsc100 | Installation Group |
| tsclm100 | Calls |
| tsclm330 | Problems |
| tsclm335 | Solutions |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Accepted Date | tsclm100.acct |
| Activity Taken | tsclm100.actt |
| Actual Finish Date | tsclm100.pfct |
| Actual Problem | tsclm100.espr |
| Actual Problem Desc | tsclm330.desc |
| Actual Reaction Date | tsclm100.arct |
| Actual Solution | tsclm100.sltn |
| Actual Solution Desc | tsclm335.desc |
| Actual Time Left Indicator | 1 if tsclm100.atml > 0, else 0 |
| Assessment Date | tsclm100.asct |
| Bad Fix | tsclm100.bdfx |
| Bad Fix Filter | tsclm100.bdfx |
| Bad Fix Sort | tsclm100.bdfx |
| Blocked | tsclm100.blyn |
| Blocked Filter | tsclm100.blyn |
| Blocked Sort | tsclm100.blyn |
| Business Partner Priority | tsclm100.cupr |
| Call Desc | tsclm100.shpd |
| Call Group1 | tsclm100.cgrp |
| Call Group2 | tsclm100.scgr |
| Call Taker | tsclm100.user |
| Company | tsclm100_compnr |
| Country | tsclm100.ccty |
| Country Desc | tcmcs010.dsca |
| Coverage Contract | tsclm100.csco |
| Coverage Date | tsclm100.cvtm |
| Coverage Type | tsclm100.cctp |
| Creation Date | tsclm100.crdt |
| Emergency Call | tsclm100.emer |
| Emergency Call Filter | tsclm100.emer |
| Emergency Call Sort | tsclm100.emer |
| Execution Start Date | tsclm100.pect |
| Expected Problem | tsclm100.expr |
| Expected Problem Desc | tsclm330.desc |
| Expected Solution | tsclm100.exsl |
| Expected Solution Desc | tsclm335.desc |
| Follow-up Call | tsclm100.fcll |
| In Use-by Business Partner | tsclm100.ubbp |
| Installation Group | tsclm100.clst |
| Installation Group Desc | tsbsc100.desc |
| Invoicing by | tsclm100.inby |
| Invoicing by Filter | tsclm100.inby |
| Invoicing by Sort | tsclm100.inby |
| Last Unblocked Date | tsclm100.bldt |
| Latest Solution Finish Date | tsclm100.svct |
| Latest Solution Start Date | tsclm100.egct |
| Origin | tsclm100.cllo |
| Origin Filter | tsclm100.cllo |
| Origin Sort | tsclm100.cllo |
| Parent Call | tsclm100.pcll |
| Pay-by BP | tsclm100.pfbp |
| Pay by BP Name | tccom100.nama |
| Pricing Contract | tsclm100.pcon |
| Pricing Contract Change | tsclm100.pcch |
| Pricing Contract Line | tsclm100.pcln |
| Problem Priority | tsclm100.prpr |
| Project Activity | tsclm100.pcac |
| Project Element | tsclm100.cspa |
| Reaction Date | tsclm100.rtct |
| Related Field Change Order | tsclm100.rfco |
| Related Field Change Order Line | tsclm100.rfcl |
| Related Maintenance Sales Order | tsclm100.rmso |
| Related Service Order | tsclm100.rsvo |
| Related Service Order Quote | tsclm100.csqu |
| Repair Warranty | tsclm100.repr_wrty |
| Repair Warranty Filter | tsclm100.repr_wrty |
| Repair Warranty Sort | tsclm100.repr_wrty |
| Reported Date | tsclm100.rpct |
| Reported Problem | tsclm100.rprl |
| Reported Problem Desc | tsclm335.desc |
| Required Activity | tsclm100.rqct |
| Response Type | tsclm100.crtc |
| Search Item | tsclm100.citm |
| Search Item Serial Number | tsclm100.cser |
| Serialized Item Priority | tsclm100.obpr |
| Service Call | tsclm100.ccll |
| Service Call ID Desc | tsclm100.ccll+tsclm100.shpb |
| Service Item Group | tsclm100.csgr |
| Solution Date | tsclm100.slct |
| Status | tsclm100.stat |
| Status Filter | tsclm100.stat |
| Status Sort | tsclm100.stat |
| Subcontractor Agreement | tsclm100.sbct |
| Support Center Logged | tsclm100.cspc |
| Unexpected Problem Indicator | 1 if Expected Problem <> Actual Problem, else 0 |
| Unexpected Solution Indicator | 1 if Expected Solution <> Actual Solution, else 0 |
| Unknown | 1 for null records, else 0 |
| Waiting | tsclm100.wait |
| Waiting Desc | tsclm100.wtds |
| Waiting Filter | tsclm100.wait |
| Waiting Sort | tsclm100.wait |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |