MSC_HVGOP_LATEST_DEMANDS

This table stores fulfillment lines that came in during sales order collection was running. This table is populate during order promising for respective item/orgs

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
msc_hvgop_latest_demands_PK	FULFILLMENT_LINE_ID, SPLIT_LINE_ID

Columns

Name	Datatype	Length	Not-null	Comments
FULFILLMENT_LINE_ID	VARCHAR2	400	Yes	Unique Identifier for a fulfillment line. It should be same as MSC_DEMANDS.SALES_ORDER_LINE_ID
SPLIT_LINE_ID	VARCHAR2	400	Yes	Generated identifier for split suggested by GOP. For no split, default value of -1
INVENTORY_KEY	VARCHAR2	150	Yes	Inventory (Item@Org) unique identifier
DEMAND_QUANTITY	NUMBER		Yes	Available demand quantity. Valid value is non-negative
DEMAND_DATE	DATE		Yes	The column indicates when sales order demand can be shipped
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.
CONFIG_INVENTORY_KEY	VARCHAR2	32		Inventory (Item@Org) unique identifier of Config item.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_HVGOP_LATEST_DEMANDS_N1	Non Unique	Default	INVENTORY_KEY
msc_hvgop_latest_demands_U1	Unique	Default	FULFILLMENT_LINE_ID, SPLIT_LINE_ID