MSC_MS_DATA_KEY_CUS_AGGR_BK
This table is used to take backup of aggregation of history for the non key customer zone site records
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_MS_DATA_KEY_CUS_AGGR_BK_PK |
PLAN_ID, MEASURE_ID, PRD_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, NK_ZONE_CUS_LVL_MEMBER_ID, SUP_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, TIM_LVL_MEMBER_ID, ORD_LVL_MEMBER_ID, EXP_LVL_MEMBER_ID, CTO_LVL_MEMBER_ID, RES_LVL_MEMBER_ID, FCM_LVL_MEMBER_ID, CLG_LVL_MEMBER_ID, SOR_LVL_MEMBER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SR_INSTANCE_ID | NUMBER | Yes | Source instance identifier from which the row was collected. | ||
| PLAN_ID | NUMBER | Yes | Identifier of the plan to which the data belongs to. | ||
| MEASURE_ID | NUMBER | Yes | Identifier of the measure to which data belongs to. | ||
| PRD_LVL_ID | NUMBER | Level identifier of the Product dimension member. | |||
| PRD_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Product dimension member. | ||
| ORG_LVL_ID | NUMBER | Level identifier of the Organization dimension member. | |||
| ORG_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Organization dimension member. | ||
| CUS_LVL_ID | NUMBER | Level identifier of the Customer dimension member. | |||
| CUS_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Customer dimension member. | ||
| SUP_LVL_ID | NUMBER | Level identifier of the Supplier dimension member. | |||
| SUP_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Supplier dimension member. | ||
| DCS_LVL_ID | NUMBER | Level identifier of the Demand Class dimension. | |||
| DCS_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Demand Class dimension member. | ||
| TIM_LVL_ID | NUMBER | Level identifier of the Time dimension member. | |||
| TIM_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Time dimension member. | ||
| ORD_LVL_ID | NUMBER | Level identifier of the Order Type dimension member. | |||
| ORD_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Order Type dimension member. | ||
| EXP_LVL_ID | NUMBER | Level identifier of the Exception Type dimension. | |||
| EXP_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Exception Type dimension member. | ||
| CTO_LVL_MEMBER_ID | NUMBER | Yes | Unique Identifier of the configure to order member name | ||
| RES_LVL_ID | NUMBER | Level identifier of the Resource Type dimension. | |||
| RES_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Resource type dimension member. | ||
| FCM_LVL_ID | NUMBER | Level identifier of the Demand Forecast Method dimension. | |||
| FCM_LVL_MEMBER_ID | NUMBER | Yes | Level identifier of the Demand Forecast Method dimension. | ||
| CLG_LVL_ID | NUMBER | Level identifier of the Decomposition Group dimension. | |||
| CLG_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Decomposition group dimension member. | ||
| SOR_LVL_ID | NUMBER | Level identifier of the Sales Representative level member. | |||
| SOR_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Sales Representative dimension member. | ||
| ORDER_TYPE_FLAG | NUMBER | 1 | Flag to indicate whether the order is Internal, External, Transfer Order, Internal Sales Order or others. | ||
| MEASURE_TYPE | NUMBER | Yes | Numerical value to denote the Type of the measure. The valid values are 1 - Forecast Measures, 2 - Shipments History, 3 - Bookings History, 4 - Causal Factors. | ||
| UOM | VARCHAR2 | 50 | UOM code of the item and organization combination used in the measure data record. | ||
| VALUE_NUMBER | NUMBER | The quantity of the measure being uploaded. This column applies to number, currency and percentage type measures only. | |||
| CURRENCY | VARCHAR2 | 5 | Currency code of the organization used in the measure data record. | ||
| VALUE_DATE | DATE | The date value for the measure being uploaded. This column applies to date type measures only. | |||
| VALUE_TEXT | VARCHAR2 | 100 | The text value for the measure being uploaded. This column applies to text type measures only. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REFRESH_NUMBER | NUMBER | 18 | Yes | Cycle identifier of Collections that inserted or last updated the row. | |
| DELETED_FLAG | NUMBER | A numberical flag to denote whether the record should be deleted from ODS by collections. The valid values are 1 - True, 2-False. | |||
| NK_ZONE_CUS_LVL_MEMBER_ID | NUMBER | Yes | unique indentifier of the non key zone customer site |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_MS_DATA_KEY_CUS_AGGR_BK_U1 | Unique | FUSION_TS_TX_IDX | PLAN_ID, MEASURE_ID, PRD_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, NK_ZONE_CUS_LVL_MEMBER_ID, SUP_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, TIM_LVL_MEMBER_ID, ORD_LVL_MEMBER_ID, EXP_LVL_MEMBER_ID, CTO_LVL_MEMBER_ID, RES_LVL_MEMBER_ID, FCM_LVL_MEMBER_ID, CLG_LVL_MEMBER_ID, SOR_LVL_MEMBER_ID | Active |