Service Contract Change Number
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tsctm320 | Contract Changes |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Change Effective Date | tsctm320.chdt |
| Change Period | tsctm320.nrpe |
| Change Period Unit | tsctm320.peru |
| Change Period Unit Filter | tsctm320.peru |
| Change Period Unit Sort | tsctm320.peru |
| Company | tsctm320_compnr |
| Company Desc | tcemm170.desc |
| Contract Change Type | tsctm320.actn |
| Contract Change Type Filter | tsctm320.actn |
| Contract Change Type Sort | tsctm320.actn |
| Creation Time | tsctm320.crtm |
| Effective Date | tsctm320.efdt |
| Expiry Date | tsctm320.exdt |
| Latest Change Number | 1 latest, else 0 |
| Origin Contract Change Number | tsctm320.ochn |
| Service Contract Change Number | tsctm320.cchn |
| Service Contract Change Number Desc | tsctm320.desc |
| Service Contract Change Number ID Desc | tsctm320.cchn + tsctm320.desc |
| Status | tsctm320.stat |
| Status Filter | tsctm320.stat |
| Status Sort | tsctm320.stat |
| Term | tsctm320.term |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |