MSC_BM_EXPIRY_SUPPLY_DETAILS
This table stores the remaining or unused lot supply after the Backlog Plan run is completed.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_BM_EXPIRY_SUP_DTLS_PK |
BM_RUN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, SUPPLY_SCHEDULE_DATE, EXPIRATION_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BM_RUN_ID | NUMBER | 18 | Yes | Backlog Management run identifier. Associates the unused supply details with a specific Backlog Plan run. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Inventory organization identifier for the remaining or unused supply record. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item identifier for the remaining or unused supply record. | |
| SUPPLY_SCHEDULE_DATE | DATE | Yes | Scheduled supply date for the remaining supply after the Backlog Plan run is completed. | ||
| EXPIRATION_DATE | DATE | Yes | Lot expiration date generated for the remaining or unused supply. Run Plan / Simulation uses this value to determine whether the supply is still eligible. | ||
| CUMULATIVE_SUPPLY_QTY | NUMBER | Stores the cumulative remaining supply quantity for the item, organization, supply schedule date, and expiration date bucket. | |||
| LOT_SUPPLY_DETAILS | CLOB | Stores lot-level details for the remaining or unused supply after plan completion. This should be populated by the previous ESS run or Refresh and Plan run when the selected alternate requires lot and subinventory details. | |||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_BM_EXPIRY_SUP_DTLS_U1 | Unique | Default | BM_RUN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, SUPPLY_SCHEDULE_DATE, EXPIRATION_DATE |