MSC_BM_EXT_CONSUMP

Details

Name	Columns
MSC_BM_EXT_CONSUMP_EVENT_PK	TRANSACTION_ID, BM_RUN_ID

Name	Datatype	Length	Not-null	Comments
BM_RUN_ID	NUMBER		Yes	Field is identifier for a Backlog Management Run
SUPPLY_EVENT_ID	NUMBER		Yes	Field is the identifier for the supply event
DEMAND_ID	NUMBER		Yes	Field is the unique identifier for demand
TIME_PERIOD	NUMBER			Field indicates the time period for the external consumption event
QUANTITY	NUMBER			Field indicates the quantity for the external consumption event
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.
INVENTORY_KEY	VARCHAR2	80	Yes	Field indicates the inventory key for the consumption event
TRANSACTION_ID	NUMBER		Yes	Field is unique identifier for consumption event for a Backlog Management run
EXPIRATION_DATE	DATE			Stores the lot expiration date generated for the consumption event. Run Plan / Simulation uses this value to determine whether the supply is eligible for consumption.
LOT_SUPPLY_DETAILS	CLOB			Stores lot-level supply details associated with the consumption event. This should be populated by the previous ESS run or Refresh and Plan run when the selected alternate requires lot and subinventory details.

Index	Uniqueness	Tablespace	Columns	Status
MSC_BM_EXT_CONSUMP_EVENT_U1	Unique	Default	TRANSACTION_ID, BM_RUN_ID
MSC_BM_EXT_CONSUMP_EVENT_U2	Unique	Default	TRANSACTION_ID	Obsolete
MSC_BM_EXT_CONS_EVENT_N1	Non Unique	Default	BM_RUN_ID, DEMAND_ID, INVENTORY_KEY
MSC_BM_EXT_CONS_EVENT_N2	Non Unique	Default	BM_RUN_ID, SUPPLY_EVENT_ID, INVENTORY_KEY