1. Tables and Views for SCM
  2. MSC_FULL_PEGGING

MSC_FULL_PEGGING

This table represents the pegging from supply to demands.

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.
MRSL_PEG_SUGG_SHIP_DATE DATE Demand's pegging level suggested ship date related to demand's due date if Supply is on or earlier to demand due date.
MRSL_PEG_PLANNED_ARRIVAL_DATE DATE Demand's pegging level planned arrival date related to demand's planned arrival date if supply is on or earlier to demand due date.
MRSL_PEG_REM_SHELF_LIFE_DATE DATE Pegging Suggested Ship Date or Pegging Planned Arrival Date based on the sum of Minimum Remaining Shelf Life Days demand anchor date and Minimum Remaining Shelf Life Days.
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