MSC_ITEM_UPDATES

This contains columns for which values are calculated by the Supply Planning engine. Having a separate table allows faster updates for the engine.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MSC_ITEM_UPDATES_PK	PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Unique Id of the plan which is associated to the planning cycle
INVENTORY_ITEM_ID	NUMBER		18	Yes	This column indicates the identifier of the inventory item.
ORGANIZATION_ID	NUMBER		18	Yes	Organization identifier of the organization owning the plan
PLANNING_TIME_FENCE_DATE	DATE				This column indicates that the planning time fence date
SAFETY_STOCK_PERCENT	NUMBER				This column indicates that the safety stock percent
SAFETY_STOCK_QUANTITY	NUMBER				This column indicates that the safety stock quantity
USE_UP_DATE	DATE				This column indicates the use up date for the item.
PLANNED_SS_TYPE	NUMBER		1		This column Indicates the Planned Safety Stock Type
SS_ADJUSTED_FLAG	NUMBER		1		This column indicates the item has updated value in 'Adjusted Safety Stock' measure. 1 (Yes), 2 or Null (No).
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.
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.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_ITEM_UPDATES_U1	Unique	Default	PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID