Unifier - Generic Cost Sheet / Primavera - Generic Cost Sheet
Description: Use this subject area to analyze cost-related activities for a generic cost sheet. You can capture and view cost transaction information based on a timescale, such as quarterly or yearly.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From |
|---|---|---|---|---|---|
| Cost Code | General - (Cost Code) | General - (Cost Code) | |||
| Cost Code | General - (Cost Code) | Status | Dimension | Status | Dim_W_CM_HIERARCHY_D_CMHier.CM_STATUS |
| Cost Code | General - (Cost Code) | Code | Dimension | Code | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE |
| Cost Code | General - (Cost Code) | Name | Dimension | Name | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME |
| Cost Code | Hierarchy - (Cost Code) | Hierarchy - (Cost Code) | |||
| Cost Code | Hierarchy - (Cost Code) | Code Level 1 | Dimension | The cost code at the first level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV1 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 10 | Dimension | The cost code at the tenth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV10 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 2 | Dimension | The cost code at the second level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV2 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 3 | Dimension | The cost code at the third level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV3 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 4 | Dimension | The cost code at the fourth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV4 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 5 | Dimension | The cost code at the fifth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV5 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 6 | Dimension | The cost code at the sixth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV6 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 7 | Dimension | The cost code at the seventh level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV7 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 8 | Dimension | The cost code at the eighth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV8 |
| Cost Code | Hierarchy - (Cost Code) | Code Level 9 | Dimension | The cost code at the nineth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_CODE_LV9 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 1 | Dimension | The cost code name at the first level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV1 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 10 | Dimension | The cost code name at the tenth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV10 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 2 | Dimension | The cost code name at the second level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV2 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 3 | Dimension | The cost code name at the third level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV3 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 4 | Dimension | The cost code name at the fourth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV4 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 5 | Dimension | The cost code name at the fifth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV5 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 6 | Dimension | The cost code name at the sixth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV6 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 7 | Dimension | The cost code name at the seventh level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV7 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 8 | Dimension | The cost code name at the eighth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV8 |
| Cost Code | Hierarchy - (Cost Code) | Name Level 9 | Dimension | The cost code name at the ninth level of detail | Dim_W_CM_HIERARCHY_D_CMHier.CM_NAME_LV9 |
| Cost Code | Hierarchy - (Cost Code) | Root Level Code | Dimension | The root cost code in the cost code hierarchy | Dim_W_CM_HIERARCHY_D_CMHier.ROOT_LEVEL_CODE |
| Cost Code | Hierarchy - (Cost Code) | Root Level Name | Dimension | The root cost code name in the cost code hierarchy | Dim_W_CM_HIERARCHY_D_CMHier.ROOT_LEVEL_NAME |
| Cost Code | Segment - (Cost Code) | Code Segment | |||
| Cost Code | Segment - (Cost Code) | Segment 1 | Dimension | Segment 1 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG1_CODE |
| Cost Code | Segment - (Cost Code) | Segment 10 | Dimension | Segment 10 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG10_CODE |
| Cost Code | Segment - (Cost Code) | Segment 2 | Dimension | Segment 2 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG2_CODE |
| Cost Code | Segment - (Cost Code) | Segment 3 | Dimension | Segment 3 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG3_CODE |
| Cost Code | Segment - (Cost Code) | Segment 4 | Dimension | Segment 4 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG4_CODE |
| Cost Code | Segment - (Cost Code) | Segment 5 | Dimension | Segment 5 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG5_CODE |
| Cost Code | Segment - (Cost Code) | Segment 6 | Dimension | Segment 6 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG6_CODE |
| Cost Code | Segment - (Cost Code) | Segment 7 | Dimension | Segment 7 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG7_CODE |
| Cost Code | Segment - (Cost Code) | Segment 8 | Dimension | Segment 8 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG8_CODE |
| Cost Code | Segment - (Cost Code) | Segment 9 | Dimension | Segment 9 of the cost code | Dim_W_CM_HIERARCHY_D_CMHier.CM_SEG9_CODE |
| Cost Manager Sheet Folder | |||||
| Cost Manager Sheet | General - (Cost Manager Sheet) | General - (Cost Manager Sheet) | |||
| Cost Manager Sheet | General - (Cost Manager Sheet) | Prefix | Dimension | Prefix | Dim_W_CM_SHEET_D_CM_Sheet.CM_PREFIX |
| Cost Manager Sheet | General - (Cost Manager Sheet) | Title | Dimension | Title | Dim_W_CM_SHEET_D_CM_Sheet.SHEET_TITLE |