Model: Maintenance - Specifications for Dimension Table: SERVICE CONTRACT

On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: SERVICE CONTRACT.

This model dimension represents service contract line information and is based on the IFS Cloud dimension DIM_SERVICE_CONTRACT_LINE. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Service Contract LineKey. Defined as CONTRACT_ID + ' - ' + CODE + ' - ' + DESCRIPTION. CODE represents the line number.
Service Contract Invoice CatalogDefined as the invoice catalog description (INVOICE_CATALOG_DESC)
Service Contract Work TypeDefined as the contract work type description (WORK_TYPE_DESC)
Service Contract Invoice RuleDefined as the invoice rule description (INVOICE_RULE_DESC)
Service ContractThe service contract id (CONTRACT_ID)
Service Contract NameThe contract name (CONTRACT_NAME)
Service Contract TypeDefines as the contract type description (CONTRACT_TYPE_DESC)
Service Contract CoordinatorThe name of the contract coordinator (CORRDINATOR_NAME)
Service Contract ManagerThe name of the contract manager. ( CONTRACT_MANAGER_NAME)
Service Contract CustomerCustomer name (CUSTOMER_NAME)
Service Contract CurrencyContract currency code (CURRENCY_CODE)
Service Contract Connection TypeThe connection type (CONNECTION_TYPE)
Service Contract Invoice TypeInvoice type (client value)
Service Contract Fixed CatalogDefined as the fixed catalog description (FIXED_CATALOG_DESC)

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
SERVICE CONTRACTDIM_SERVICE_CONTRACT_LINE_BIDIM_SERVICE_CONTRACT_LINEOn Line