MSS_PEGGING_RELATIONSHIPS

This is an association table that contains all the pegging relationship pairs.

Details

• Schema: FUSION

• Object owner: MSS

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSS_PEGGING_RELATIONSHIPS_PK	PLAN_ID, PEGGING_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Identifier of the Production Scheduling plan.
PEGGING_ID	NUMBER		18	Yes	Identifier of the pegging relationship (generated internally).
INVENTORY_ITEM_ID	NUMBER		18		Reference to the inventory item; foreign key to MSS_ITEMS, MSS_INVENTORY_LOTS.
LOT_NUMBER	VARCHAR2	80			Reference to the inventory lot; foreign key to MSS_INVENTORY_LOTS.
QUANTITY	NUMBER			Yes	This is the item quantity transferred between supply by and consume by records.
SUPPLY_BY_TYPE	VARCHAR2	30		Yes	Type of the supply by record: On Hand|On Hold Lot|Shortage Adjustment|Supply Event|Work Order Operation|Flow Schedule|Aggregated Flow Schedule.
SUPPLY_BY_ID	NUMBER		18		Reference to the supply by record.
SUPPLY_BY_RESOURCE_SEQ_NUMBER	NUMBER				Resource sequence number of the supply by work order operation.
CONSUME_BY_TYPE	VARCHAR2	30		Yes	Type of the consume by record: Demand Event|Work Order Operation|Flow Schedule|Aggregated Flow Schedule.
CONSUME_BY_ID	NUMBER		18	Yes	Reference to the consume by record.
CONSUME_BY_RESOURCE_SEQ_NUMBER	NUMBER				Resource sequence number of the consume by work order operation.
SUPPLY_DATE	TIMESTAMP			Yes	Availability date of the supply by record.
CONSUME_DATE	TIMESTAMP			Yes	Start date of the consume by record.
END_DEMAND_ID	NUMBER		18		Reference to the end demand; foreign key to MSS_DEMANDS.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSS_PEGGING_RELATIONSHIPS	mss_items	PLAN_ID, INVENTORY_ITEM_ID
MSS_PEGGING_RELATIONSHIPS	mss_inventory_lots	PLAN_ID, INVENTORY_ITEM_ID, LOT_NUMBER
MSS_PEGGING_RELATIONSHIPS	mss_demands	PLAN_ID, END_DEMAND_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSS_PEGGING_RELATIONSHIPS_N1	Non Unique	MSS_PEGGING_RELATIONSHIPS_N1	PLAN_ID, INVENTORY_ITEM_ID, SUPPLY_BY_TYPE, CONSUME_BY_TYPE
MSS_PEGGING_RELATIONSHIPS_U1	Unique	Default	PLAN_ID, PEGGING_ID