Service Contract Quote
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tccom100 | Business Partners |
| tcmcs010 | Countries |
| tsctm200 | Contract Quotes |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Company | tsctm200_compnr |
| Configuration Type | Fixed Price, if service configuration line has Fixed Sales
Prices = Yes Time and Material, if service configuration line has Time and Material Sales Prices = Yes Coverage, if service configuration line has Coverage Terms = Yes Else, Other. |
| Contract Renewal | tsctm200.cryn |
| Contract Renewal Filter | tsctm200.cryn |
| Contract Renewal Sort | tsctm200.cryn |
| Contract Type | tsctm200.ctpc |
| Country | tsctm200.ccty |
| Country Desc | tcmcs010.dsca |
| Drillback to LN | ‘LN’ |
| Effective Date of Current Contract | tsctm200.cedt |
| First Invoice Reference | tsctm200.refa |
| Indexation Interval | tsctm200.innp |
| Indexation Period Unit | tsctm200.inpu |
| Indexation Period Unit Filter | tsctm200.inpu |
| Indexation Period Unit Sort | tsctm200.inpu |
| Indexation Start Date | tsctm200.indt |
| Line of Business | tsctm200.cbrn |
| No of Periods of Quote Duration | tsctm200.nrpe |
| Original Service Contract | tsctm200.csco |
| Overtime Allowed | tsctm200.ovyn |
| Overtime Allowed Filter | tsctm200.ovyn |
| Overtime Allowed Sort | tsctm200.ovyn |
| Pay-by BP | tsctm200.pfbp |
| Pay-by BP Name | tccom100.nama |
| Period Unit of Quote Duration | tsctm200.peru |
| Period Unit of Quote Duration Filter | tsctm200.peru |
| Period Unit of Quote Duration Sort | tsctm200.peru |
| Probability Percentage | tsctm200.supe |
| Processed Service Contract | tsctm200.psrc |
| Provision | tsctm200.prov |
| Renewal Period | tsctm200.crnp |
| Renewal Period Unit | tsctm200.crpu |
| Renewal Period Unit Filter | tsctm200.crpu |
| Renewal Period Unit Sort | tsctm200.crpu |
| Second Invoice Reference | tsctm200.refb |
| Service Contract Quote | tsctm200.ccqu |
| Service Contract Quote Desc | tsctm200.desc |
| Service Contract Quote ID Desc | tsctm200.ccqu + tsctm200.desc |
| Status | tsctm200.squo |
| Status Filter | tsctm200.squo |
| Status Sort | tsctm200.squo |
| Term | tsctm200.term |
| 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 tsctm200.ofad.