WIS_KANBAN_DEMANDS_GT

This is a global temporary table that stores demand information for items included in a Kanban plan and populated by the Kanban planning engine as a part of the Kanban planning process.

Details

• Schema: FUSION

• Object owner: WIS

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
WIS_KANBAN_DEMANDS_GT_PK	KANBAN_DEMAND_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
KANBAN_DEMAND_ID	NUMBER		18	Yes	The unique identifier assigned to each demand record within the Kanban planning process. Its value is an application generated unique id.
DEMAND_ID	NUMBER		18		Identifies demand to be taken into account for planning. It's a foreign key reference to the MSC_DEMANDS table.
KANBAN_PLAN_ID	NUMBER		18	Yes	The unique identifier assigned to each Kanban plan within the system. It's a foreign key to the WIS_KANBAN_PLANS_B table.
ORGANIZATION_ID	NUMBER		18	Yes	The organization identifier represents the manufacturing plant to which this Kanban demand belongs.
INVENTORY_ITEM_ID	NUMBER		18	Yes	Represents the unique identifier of the demanded item.
SUBINVENTORY_CODE	VARCHAR2	10			Represents the name of the subinventory where the demanded item is stored or managed.
LOCATOR_ID	NUMBER		18		Represents the identifier of the locator of the demanded item.
ASSEMBLY_ITEM_ID	NUMBER		18		Represents the unique identifier of the demanding item.
DEMAND_DATE	DATE				The date on which the demand is generated within the Kanban planning process.
DEMAND_QUANTITY	NUMBER				The specific quantity as part of the Kanban demand.
UOM_CODE	VARCHAR2	3			Represents the unit of measure code for demand quantity.
KANBAN_ITEM_FLAG	VARCHAR2	1			Flag to indicate if this item is replenished using Kanbans. Valid values are Y/N.

Indexes

Index	Uniqueness	Columns
WIS_KANBAN_DEMANDS_GT_N01	Non Unique	ORGANIZATION_ID, INVENTORY_ITEM_ID
WIS_KANBAN_DEMANDS_GT_U01	Unique	KANBAN_DEMAND_ID