Service Configuration Line

This table shows the table from which fields are retrieved for the dimension:

Table Description
tsctm110 Configuration Lines

This table shows the attribute mapping for the dimension:

Attribute Mapping
Company tsctm110_compnr
Configuration Line Type tsctm110.cltp
Configuration Line Type Filter tsctm110.cltp
Configuration Line Type Sort tsctm110.cltp
Configuration Type
  • Fixed Price, if Fixed Sales Prices = Yes
  • Time and Material, if Time and Material Sales Prices = Yes
  • Coverage, if Coverage Terms = Yes
  • Else, Other
Conformance Reporting tsctm110.cncd
Contract Discount Date tsctm110.cddt
Coverage Terms tsctm110.ctrm
Coverage Terms Filter tsctm110.ctrm
Coverage Terms Sort tsctm110.ctrm
Coverage Type tsctm110.cctp
Effective Date tsctm110.efdt
Expiry Date tsctm110.exdt
Fixed Sales Prices tsctm110.fxpr
Fixed Sales Prices Filter tsctm110.fxpr
Fixed Sales Prices Sort tsctm110.fxpr
Installation Group tsctm110.clst
Installation Group Desc tsbsc100.desc
Marked for Expiry tsctm110.mexp
Marked for Expiry Filter tsctm110.mexp
Marked for Expiry Sort tsctm110.mexp
Number of Activities tsctm110.nrac
Number of Items tsctm110.nitm
Number of Periods tsctm110.nrpe
Originating Contract Line tsctm110.cnln
Originating Detail Line tsctm110.sdno
Originating Order tsctm110.srno
Originating Order Line tsctm110.spno
Originating Order Type tsctm110.ortp
Originating Order Type Filter tsctm110.ortp
Originating Order Type Sort tsctm110.ortp
Period Unit tsctm110.peru
Period Unit Calculated Price tsctm110.cpru
Period Unit Calculated Price Filter tsctm110.cpru
Period Unit Calculated Price Sort tsctm110.cpru
Period Unit Filter tsctm110.peru
Period Unit Sort tsctm110.peru
Project Activity tsctm110.pcac
Project Element tsctm110.cspa
Reference Activity tsctm110.crac
Run Identification tsctm110.cgru
Serial Number tsctm110.sern
Service Configuration Line tsctm110.cfln
Term tsctm110.term
Time and Material Sales Prices tsctm110.tmpr
Time and Material Sales Prices Filter tsctm110.tmpr
Time and Material Sales Prices Sort tsctm110.tmpr
Unknown 1 for null records, else 0
deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields