MSC_FULL_PEGGING

Details

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

Primary Key

Name	Columns
MSC_FULL_PEGGING_PK	PLAN_ID, PEGGING_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
PEGGING_ID	NUMBER		18	Yes	Id of the pegging row, part of the unique key	Active
SUPPLY_TYPE	NUMBER				Type of order from which the material originates
INVENTORY_ITEM_ID	NUMBER		18	Yes	Item Id of the material pegged from this supply to the demand	Active
ORGANIZATION_ID	NUMBER		18	Yes	Organization Id of the material pegged from this supply to this demand	Active
PLAN_ID	NUMBER		18	Yes	Plan in which the pegging takes place	Active
PREV_PEGGING_ID	NUMBER		18		Reference to previous level's pegging identifier	Active
END_PEGGING_ID	NUMBER		18		Reference to end pegging node identifier	Active
TRANSACTION_ID	NUMBER		18		Id of the supply order from which the material originates	Active
DISPOSITION_ID	NUMBER		18		Disposition Id of the supply assembly order receiving the material	Active
DEMAND_ID	NUMBER		18		Id of the demand receiving the material	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
DEST_TRANSACTION_ID	NUMBER		18		Transaction Id of the supply assembly order receiving the material, ie. transaction id of prev_pegging_id pegging.	Active
ALLOCATED_QUANTITY	NUMBER				Quantity of material from this supply allocated to this demand	Active
SUPPLY_DATE	DATE				Date of the supply when the material is available
DEMAND_DATE	DATE				Date of the demand when the material is due
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.
PEGGING_TYPE	NUMBER		9		lookup msc_reservation_type 1 Reservation 2 Recommendation
DEMAND_QUANTITY	NUMBER				Quantity of the demand denormalized in this table. Historically demand_id: -1 is excess demand (i.e. where the engine pegs excess) -3 is negative on-hand
NET_SEQ_NUM	NUMBER		9		netting sequence number for pegging supplies.
LATEST_START_DATE_PEG_SUP	DATE				Latest Start Date for Pegged Supply=Downstream supply's Need_by_date - current supply's lead time
SLACK_DAYS	NUMBER		9		Slack days = Earliest start date - Latest start date pegged supply, will only populate when it is greater than 0
MOST_CRITICAL_PATH	NUMBER		9		A boolean flag to the pegging entries to indicate if it's on the most critical path (largest slack), 1 -yes 2 -no
ITEM_STRUCTURE_LEVEL	NUMBER		9		Number of supplies between current supply to the end item supply. (For end pegging the value is zero)
RELEASE_STATUS	NUMBER		9		Release status for the pegged supply. Only applicable for On Hand supplies.
CAPACITY_SLACK_DAYS	NUMBER		9		Days between latest start date of the pegged supply and constrained earliest start date.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MSC_FULL_PEGGING_N1	Non Unique	Default	PLAN_ID, PREV_PEGGING_ID	Active
MSC_FULL_PEGGING_N2	Non Unique	Default	PLAN_ID, DEMAND_ID, ORGANIZATION_ID	Active
MSC_FULL_PEGGING_N3	Non Unique	Default	PLAN_ID, TRANSACTION_ID, ORGANIZATION_ID	Active
MSC_FULL_PEGGING_N4	Non Unique	Default	PLAN_ID, END_PEGGING_ID	Active
MSC_FULL_PEGGING_N5	Non Unique	Default	PLAN_ID, DEST_TRANSACTION_ID, TRANSACTION_ID	Active
MSC_FULL_PEGGING_N6	Non Unique	Default	PLAN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID	Active
MSC_FULL_PEGGING_N7	Non Unique	Default	PLAN_ID, DEMAND_ID, DEST_TRANSACTION_ID	Active
MSC_FULL_PEGGING_U1	Unique	Default	PLAN_ID, PEGGING_ID	Active