This cube dimension represents service contract line information and
is based on the IFS Applications dimension DIM_SERVICE_CONTRACT_LINE. All cubes that refers to
this dimension will have the attributes and hierarchies as described below.
Attribute |
Hierarchy |
Description |
Service Contract |
NO |
The service contract id (CONTRACT_ID) |
Service Contract Connection Type |
NO |
The connection type (CONNECTION_TYPE) |
Service Contract Coordinator |
NO |
The name of the contract coordinator (CORRDINATOR_NAME) |
Service Contract Currency |
NO |
Contract currency code (CURRENCY_CODE) |
Service Contract Customer |
NO |
Customer name (CUSTOMER_NAME) |
Service Contract Fixed Catalog |
NO |
Defined as the fixed catalog description
(FIXED_CATALOG_DESC) |
Service Contract Invoice Catalog |
NO |
Defined as the invoice catalog description
(INVOICE_CATALOG_DESC) |
Service Contract Invoice Rule |
NO |
Defined as the invoice rule description
(INVOICE_RULE_DESC) |
Service Contract Invoice Type |
NO |
Invoice type (client value) |
Service Contract Line |
NO |
Key. Defined as CONTRACT_ID + ' - ' + CODE + ' - ' +
DESCRIPTION. CODE represents the line number. |
Service Contract Manager |
NO |
The name of the contract manager. (
CONTRACT_MANAGER_NAME) |
Service Contract Name |
NO |
The contract name (CONTRACT_NAME) |
Service Contract Type |
NO |
Defines as the contract type description
(CONTRACT_TYPE_DESC) |
Service Contract Work Type |
NO |
Defined as the contract work type description
(WORK_TYPE_DESC) |