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 Line Key. Defined as CONTRACT_ID + ' - ' + CODE + ' - ' + DESCRIPTION. CODE represents the line number.
Service Contract Invoice Catalog Defined as the invoice catalog description (INVOICE_CATALOG_DESC)
Service Contract Work Type Defined as the contract work type description (WORK_TYPE_DESC)
Service Contract Invoice Rule Defined as the invoice rule description (INVOICE_RULE_DESC)
Service Contract The service contract id (CONTRACT_ID)
Service Contract Name The contract name (CONTRACT_NAME)
Service Contract Type Defines as the contract type description (CONTRACT_TYPE_DESC)
Service Contract Coordinator The name of the contract coordinator (CORRDINATOR_NAME)
Service Contract Manager The name of the contract manager. ( CONTRACT_MANAGER_NAME)
Service Contract Customer Customer name (CUSTOMER_NAME)
Service Contract Currency Contract currency code (CURRENCY_CODE)
Service Contract Connection Type The connection type (CONNECTION_TYPE)
Service Contract Invoice Type Invoice type (client value)
Service Contract Fixed Catalog Defined 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 CONTRACT DIM_SERVICE_CONTRACT_LINE_BI DIM_SERVICE_CONTRACT_LINE On Line