Service Coverage Term
This table shows the table from which fields are retrieved for the dimension:
Table | Description |
---|---|
tsctm120 | Coverage Terms |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Company | tsctm120_compnr |
Cost Covering Method | tsctm120.ccov |
Cost Covering Method Filter | tsctm120.ccov |
Cost Covering Method Sort | tsctm120.ccov |
Coverage Line | tsctm120.nrbt |
Coverage Line Type | tsctm120.cvtp |
Coverage Line Type Filter | tsctm120.cvtp |
Coverage Line Type Sort | tsctm120.cvtp |
Coverage Percentage | tsctm120.disc |
Coverage Type | tsctm120.cctp |
End Date | tsctm120.endt |
Number of Periods | tsctm120.nrpe |
Period Unit | tsctm120.peru |
Period Unit Filter | tsctm120.peru |
Period Unit Sort | tsctm120.peru |
Service Coverage Term | tsctm120.cfln +'*' + tsctm120.term + '*' + tsctm120.cctp + *' + tsctm120.cotp + '*' tsctm120.nrbt |
Service Coverage Term Desc | tsctm120.desc |
Service Coverage Term ID Desc | tsctm120.term + tsctm120.desc |
Start Date | tsctm120.stdt |
Term | tsctm120.term |
Unknown | 1 for null records, else 0 |
deleted | 1 if deleted in LN, else 0 |
Customer Defined Fields | Standard list of fields |