This cube dimension represents condition codes and is based on the IFS Applications dimension DIM_PURCHASE_CHARGE_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Hierarchy | Description |
| Purchase Charge Type | YES | Key. Built as CONTRACT + ' - ' + CODE + ' - ' + DESCRIPTION |
| Purchase Charge Code | NO | Represents the CODE of the dimension, i.e. the charge type code. |
| Purchase Charge Descr | NO | Represents the DESCRIPTION of a charge type. |
| Purchase Charge Distributed by | NO | The method of distributing the charge, i.e. per amount, per weight etc. Underlying column DISTRIBUTE_CHARGE_BY_DESC. |
| Purchase Charge Group | YES | Represents the charge group. |
| Purchase Charge Site | NO | The code of the site being charged. |
| Cube Name |
| PROCUREMENT |
| BI Access View | BI Component | Recommended Source Type |
| DIM_PURCHASE_CHARGE_TYPE_BI | PURCDI | On Line |
| ETL Step | File Name of SSIS Package | Table Name |
| E - Stage | 1.1.050 Load IFSAppl_DIM_PURCHASE_CHARGE_TYPE_BI.dtsx | IFSAppl_DIM_PURCHASE_CHARGE_TYPE |
| T - DW | 2.1.050 Load Dw_DIM_PURCHASE_CHARGE_TYPE.dtsx | Dw_DIM_PURCHASE_CHARGE_TYPE |
| L - DM | 3.1.050 Load Dm_DIM_PURCHASE_CHARGE_TYPE.dtsx | Dm_DIM_PURCHASE_CHARGE_TYPE |