MSC_ITEM_SUBSTITUTES

This table stores all the Relationships between Item Substitutes for planning.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

MSC_ITEM_SUBSTITUTES_PK

PLAN_ID, SUBSTITUTE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PLAN_ID NUMBER 18 Yes This value indicates the plan identifier for the record.
SUBSTITUTE_ID NUMBER 18 Yes Substitution identifier of the item substitution relationship.
SR_INSTANCE_ID NUMBER 18 Instance Id of the destination organzation, obsolete column. Obsolete
LOWER_ITEM_ID NUMBER 18 Yes Item identifier generated by the collection program from Staging tables to ODS
HIGHER_ITEM_ID NUMBER 18 Yes Item identifier generated by the collection program from Staging tables to ODS
HIGHEST_ITEM_ID NUMBER 18 Item identifier generated by the collection program
CUSTOMER_ID NUMBER 18 Yes Unique Partner identifier generated by the collection program from Staging tables to ODS
CUSTOMER_SITE_ID NUMBER 18 Yes Unique Partnersite identifier generated by the collection program from Staging tables to ODS
EFFECTIVE_DATE DATE Effective Date of the Item Relationship
DISABLE_DATE DATE Disable Date of the Item Relationship
RELATIONSHIP_TYPE NUMBER Yes Type of Relationship between the Items
RECIPROCAL_FLAG NUMBER This value indicates the Reciprocal Flag.
SUBSTITUTION_SET VARCHAR2 50 Substitution set name used to define the Item relationship
PARTIAL_FULFILLMENT_FLAG NUMBER Yes Partial fulfillment flag indicating whether partial substitution is allowed.
RANK NUMBER This value indicates the Rank of the record.
USAGE_RATIO NUMBER Usage quantity of the substituted item.
INFERRED_FLAG NUMBER Inferred Flag setup while defining a substitution relationship.
REFRESH_NUMBER NUMBER 18 Refresh identifier populated by the collection program.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
ORGANIZATION_ID NUMBER 18 Organization identifier, foreign key to msc_parameters
PLANNING_ENABLED_FLAG NUMBER Flag to specify if the related item is enabled for planning. Valid values are 1(Yes), 2(No)
ORG_INDEPENDENT_FLAG NUMBER Indicates whether the item substitution is controlled at Master level (1) or Organization level (2)
RELATIONSHIP_DESC VARCHAR2 240 Description of Item Relationship
MASTER_ORG_ID NUMBER 18 This is the Item Master Organization identifier.
INHERITED_SUBST_FLAG NUMBER The item relationships defined at the Master Level are inherited by child organizations of the Master Organization. Values are Yes(1) or No(2).

Indexes

Index Uniqueness Tablespace Columns
MSC_ITEM_SUBSTITUTES_N1 Non Unique Default PLAN_ID, HIGHER_ITEM_ID, LOWER_ITEM_ID
MSC_ITEM_SUBSTITUTES_U1 Unique Default PLAN_ID, SUBSTITUTE_ID
MSC_ITEM_SUBSTITUTES_U2 Unique Default PLAN_ID, RELATIONSHIP_TYPE, LOWER_ITEM_ID, HIGHER_ITEM_ID, EFFECTIVE_DATE, CUSTOMER_ID, CUSTOMER_SITE_ID