MSC_INV_PA_OVERRIDES

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MSC_INV_PA_OVERRIDES_PK	POLICY_SET_ID, PLAN_ID, INVENTORY_ITEM_ID, LOCATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
POLICY_SET_ID	NUMBER		18	Yes	POLICY_SET_ID Sequence generated primary key
PLAN_ID	NUMBER		18	Yes	PLAN_ID Foreign key to the MSC_PLAN_DEFINITIONS table for Plan specific data, -1 for non-plan specific data
INVENTORY_ITEM_ID	NUMBER		18	Yes	Foreign key to MSC_SYSTEM_ITEMS table
LOCATION_ID	NUMBER		18	Yes	Org/Subinventory name. Should display Subinventory only when ‘Sub-Inventory level granularity’ is enabled for the ‘Segment Group’.
POLICY_TYPE	NUMBER			Yes	Default is set to "Min-Max planning" . The other values must be "Fixed Order Calendar", "ROP-OQ" ("Re-Order Point - Order Quantity") and "ROP-EOQ" ("Re-Order Point - economic Order Quantity")
POLICY_UOM	NUMBER		4	Yes	defines the uom of the values that will be calculated 1 - Units (Default), 2 - Days
SS_OVERRIDE	NUMBER				Safety Stock Override - Only integer none zero values allowed.
MIN_OVERRIDE	NUMBER				Min Quantity Override - Only integer none zero values allowed. If SS Override is defined then a check should be done to ensure Min Quantity Override > SS Override.
MAX_OVERRIDE	NUMBER				Max Quantity Override - Only integer none zero values allowed. Have a check to ensure Max Quantity Override > Min Quantity Override > SS Override. Should be editable only when Policy type is ‘Min-Max Planning’.
EOQ_OVERRIDE	NUMBER				EOQ Override - Only integer none zero values allowed. Should be editable only when Policy type is ‘ROP-EOQ’.
ORDER_QTY_OVERRIDE	NUMBER				Order Quantity Override - Only integer none zero values allowed. Should be editable only when Policy type is ‘ROP-OQ’.
ROP_OVERRIDE	NUMBER				Only integer none zero values allowed. Should be editable only when Policy type is ROP-OQ or ROP-EOQ.
PAR_LEVEL_OVERRIDE	NUMBER				PAR Level Override - Available for editing when PAR Replenishment policy type is selected. Fields can be null. Zero is not allowed.
PAR_MAX_OVERRIDE	NUMBER				PAR Max Override - Available for editing when PAR Replenishment policy type is selected. Fields can be null. Zero is not allowed.
ORDERING_CALENDAR	VARCHAR2	22			Only editable and mandatory when the Policy type is Fixed Order Calendar. This calendar governs on days when replenishment orders can be placed.
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.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
REFRESH_NUMBER	NUMBER				Refresh identifier to indicate the source system.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_INV_PA_OVERRIDES_U1	Unique	Default	POLICY_SET_ID, PLAN_ID, INVENTORY_ITEM_ID, LOCATION_ID