1. Tables and Views for SCM
  2. MSC_MS_DATA_KEY_CUS_AGGR

MSC_MS_DATA_KEY_CUS_AGGR

This table is used for Processing the 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_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 Status
SR_INSTANCE_ID NUMBER Yes Source Instance Indentifier Active
PLAN_ID NUMBER Yes Unique Id for the Plan Active
MEASURE_ID NUMBER Yes Unique Identifier of the measure Active
PRD_LVL_ID NUMBER Unique Identifier of the Product level Active
PRD_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the product level member Active
ORG_LVL_ID NUMBER Unique Identifier of the organization level Active
ORG_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the of the organization level member Active
CUS_LVL_ID NUMBER Unique Identifier of the customer level Active
CUS_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the customer level member Active
SUP_LVL_ID NUMBER Unique Identifier of the supplier level Active
SUP_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the supplier level member Active
DCS_LVL_ID NUMBER Unique Identifier of the demand class level Active
DCS_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the demand class level member Active
TIM_LVL_ID NUMBER Unique Identifier of the time level Active
TIM_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the time member Active
ORD_LVL_ID NUMBER Unique Identifier of the order type level Active
ORD_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the order type member Active
EXP_LVL_ID NUMBER Unique Identifier of the eception type level Active
EXP_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the exception type member Active
CTO_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the configure to order member name Active
RES_LVL_ID NUMBER Unique Identifier of the resource level Active
RES_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the resource member Active
FCM_LVL_ID NUMBER Unique Identifier of the decomposition level Active
FCM_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the decomposition level member Active
CLG_LVL_ID NUMBER Unique Identifier of the CLG level Active
CLG_LVL_MEMBER_ID NUMBER Yes Unique indeitifier of the CLG level member name Active
SOR_LVL_ID NUMBER Unique Identifier of the Sales Organization level Active
SOR_LVL_MEMBER_ID NUMBER Yes Unique Identifier of the Sales Organization level member Active
ORDER_TYPE_FLAG NUMBER 1 Column to identify the order type Active
MEASURE_TYPE NUMBER Yes column to identify the measure type Active
UOM VARCHAR2 50 Unit of Measure Active
VALUE_NUMBER NUMBER Value number quantity for the measure Active
CURRENCY VARCHAR2 5 Currency of the value number Active
VALUE_DATE DATE Value date of the measure Active
VALUE_TEXT VARCHAR2 100 Value text of the measure Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REFRESH_NUMBER NUMBER 18 Yes Refresh number of the collection load process Active
DELETED_FLAG NUMBER Flag to denote if the record is deleted or not Active
NK_ZONE_CUS_LVL_MEMBER_ID NUMBER Yes unique indentifier of the non key zone customer site Active

Indexes

Index Uniqueness Tablespace Columns Status
MSC_MS_DATA_KEY_CUS_AGGR_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