Service Contract
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tccom130 | Addresses |
| tccom139 | Cities by Country |
| tcemm100 | Time Zones |
| tcmcs010 | Countries |
| tcmcs143 | States/Provinces |
| tsctm300 | Service Contracts |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Cancel Date | tsctm300.cadt |
| Cancel Reason | tsctm300.cdis |
| City | tccom130.ccit |
| City Desc | tccom139.dsca |
| Company | tsctm300_compnr |
| Contract Effective Date | tsctm300.efdt |
| Contract Expiry Date | tsctm300.exdt |
| Contract Renewal | tsctm300.cryn |
| Contract Renewal Filter | tsctm300.cryn |
| Contract Renewal Sort | tsctm300.cryn |
| Contract Status | tsctm300.scon |
| Contract Status Filter | tsctm300.scon |
| Contract Status Sort | tsctm300.scon |
| Contract Type | tsctm300.ctpc |
| Country | tsctm300.ccty |
| Country Desc | tcmcs010.dsca |
| Creation Date | tsctm300.crdt |
| Drillback to LN | ‘LN’ |
| EU Member State | tcmcs010.meec |
| EU Member State Filter | tcmcs010.meec |
| EU Member State Sort | tcmcs010.meec |
| Financial Company | tcmcs065.comp for tsctm300.cwoc |
| Financial Company Desc | tcemm170.desc for tsctm300.cwoc |
| First Invoice Reference | tsctm300.refa |
| GPS Latitude | tccom130.glat |
| GPS Location | Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Service Contract Desc. |
| GPS Longitude | tccom130.glon |
| Internal Sales Rep | tsctm300.emno |
| Internal Sales Rep Name | tccom001.nama |
| Invoice-to BP | tsctm300.itbp |
| Invoice to BP Name | tccom100.nama |
| ISO Country Code Alpha-2 | tcmcs010.ict2 |
| Line of Business | tsctm300.cbrn |
| Marked for Expiry | tsctm300.mexp |
| Marked for Expiry Filter | tsctm300.mexp |
| Marked for Expiry Sort | tsctm300.mexp |
| Pay-by Address | tsctm300.pfad |
| Pay-by BP | tsctm300.pfbp |
| Pay by BP Name | tccom100.nama |
| Penalty | tsctm300.icpn |
| Period Unit | tsctm300.inpu |
| Period Unit Filter | tsctm300.inpu |
| Period Unit Sort | tsctm300.inpu |
| Project | tsctm300.cprj |
| Project Activity | tsctm300.pcac |
| Project Desc | tcmcs052.dsca |
| Project Element | tsctm300.cspa |
| Provision | tsctm300.prov |
| Recognize Revenue per Configuration | tsctm300.rccg |
| Recognize Revenue per Configuration Filter | tsctm300.rccg |
| Recognize Revenue per Configuration Sort | tsctm300.rccg |
| Renewal Period | tsctm300.crnp |
| Revenue Recognition Based on | tsctm300.rvmd |
| Revenue Recognition Based on Filter | tsctm300.rvmd |
| Revenue Recognition Based on Sort | tsctm300.rvmd |
| Sales Type | tsctm300.styp |
| Second Invoice Reference | tsctm300.refb |
| Service Contract | tsctm300.csco |
| Service Contract Currency | tsctm300.ccur |
| Service Contract Desc | tsctm300.desc |
| Service Contract ID Desc | tsctm300.csco + tsctm300.desc |
| Service Office | tsctm300.cwoc |
| Service Office Desc | tcmcs065.dsca |
| Service Reason Desc | tsctm300.cdis + tcmcs005.dsca |
| Sold-to BP | tsctm300.ofbp |
| Sold to BP Name | tccom100.nama |
| State/Province | tcmcs143.dsca |
| State Province Desc | tccom130.cste |
| Time Zone | tcemm100.timz |
| Time Zone Code | tccom130.timz |
| Time Zone Desc | tccom130.dsca |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |
Address fields are included for tsctm300.ofad.