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.
| Attribute | Description (where applicable) |
| Service Contract | The service contract id (CONTRACT_ID) |
| Service Contract Connection Type | The connection type (CONNECTION_TYPE) |
| Service Contract Coordinator | The name of the contract coordinator (CORRDINATOR_NAME) |
| Service Contract Currency | Contract currency code (CURRENCY_CODE) |
| Service Contract Customer | Customer name (CUSTOMER_NAME) |
| Service Contract Fixed Catalog | Defined as the fixed catalog description (FIXED_CATALOG_DESC) |
| Service Contract Invoice Catalog | Defined as the invoice catalog description (INVOICE_CATALOG_DESC) |
| Service Contract Invoice Rule | Defined as the invoice rule description (INVOICE_RULE_DESC) |
| Service Contract Invoice Type | Invoice type (client value) |
| Service Contract Line | Key. Defined as CONTRACT_ID + ' - ' + CODE + ' - ' + DESCRIPTION. CODE represents the line number. |
| Service Contract Manager | The name of the contract manager. ( CONTRACT_MANAGER_NAME) |
| Service Contract Name | The contract name (CONTRACT_NAME) |
| Service Contract Type | Defines as the contract type description (CONTRACT_TYPE_DESC) |
| Service Contract Work Type | Defined as the contract work type description (WORK_TYPE_DESC) |
| Model Name |
| Maintenance |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| SERVICE CONTRACT | DIM_SERVICE_CONTRACT_LINE_TM | DIM_SERVICE_CONTRACT_LINE_BI | DIM_SERVICE_CONTRACT_LINE | On Line |