MSC_HVGOP_IAP
Table data used to store all inventory keys.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_HVGOP_IAP_PK |
INVENTORY_KEY |
Columns
| Name | Datatype | Length | Not-null | Comments | Status |
|---|---|---|---|---|---|
| INVENTORY_KEY | VARCHAR2 | 150 | Yes | Field is used to indicate the inventory key | |
| LATEST_UPDATE | TIMESTAMP | Last update date of the inventory | |||
| 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. | ||
| ATP_RULE_ID | NUMBER | Identifies the ATP rule to which inventory key belongs | |||
| ATP_ASSIGNMENT_TYPE | NUMBER | Identifies the assignment type for atp rule | |||
| LAST_SUPDEM_NETCHANGE_COLL | DATE | Indicates when last net change collection modified supply/demand for respective item/org. This column is populated by collection flow and is used to determine whether aggregated supply and demand cache is stale or not. Null value indicates that cache needs to be recomputed. | Obsolete | ||
| LATEST_ATP_RULE_UPDATE | DATE | Indicates the time when order promising solver cached atp rule for respective item/org. This column is populated during order promising flow and is used to determine whether ATP rule cache is stale or not. Null value indicates that record was never cached. | |||
| LATEST_DEPENDENCY_UPDATE | DATE | Indicates the time when order promising solver cached dependency for respective item/org. This column is populated during order promising flow and is used to determine whether dependency cache is stale or not. Null value indicates that record was never cached. | |||
| SOURCING_RULE_ID | NUMBER | Sourcing rule that is applicable for given inventory key from the hierarchy 6 - Item-Instance-Organization,12 - Item,5 - Category-Instance-Organization,11 - Category,4 - Instance-Org,10 - Global | |||
| SOURCING_ASSIGNMENT_TYPE | NUMBER | Identifies the local sourcing assignment type | |||
| BOR_ID | NUMBER | Bill of Resource that is assigned for given inventory key. | |||
| LAST_SUP_NETCHANGE_COLL | DATE | Indicates when last net change collection modified supply for respective item/org. This column is populated by collection flow and is used to determine whether aggregated supply and demand cache is stale or not. Null value indicates that cache needs to be recomputed. | |||
| LAST_DEM_NETCHANGE_COLL | DATE | Indicates when last net change collection modified demand for respective item/org. This column is populated by collection flow and is used to determine whether aggregated supply and demand cache is stale or not. Null value indicates that cache needs to be recomputed. | |||
| LAST_SUPCAP_SUP_NETCHANGE_COLL | TIMESTAMP | Last date for supplier capacity net change collection will be considered as supply , this column will be used for rebaseline calculation. | |||
| LAST_SUPCAP_DEM_NETCHANGE_COLL | TIMESTAMP | Last date for PO/PR net change collection will be considered as demand , this column will be used for rebaseline calculation. | |||
| LATEST_BOR_DEPENDENCY_UPDATE | DATE | Indicates the time when order promising solver cached BOR dependency for respective item/org.This column is populated during order promising flow and is used to determine whether BOR dependency cache is stale or not.Null value indicates that record was never cached. | |||
| LAST_RES_SUP_NETCHANGE_COLL | TIMESTAMP | Indicates when last net change collection modified resource availability for respective resource. This column is populated by collection flow and is used to determine whether aggregated resource supply is stale or not. Null value indicates that cache needs to be recomputed. | |||
| LAST_RES_DEM_NETCHANGE_COLL | TIMESTAMP | Indicates when last net change collection modified resource requirement for respective resource. This column is populated by collection flow and is used to determine whether aggregated resource demand is stale or not. Null value indicates that cache needs to be recomputed. | |||
| LAST_ALLOC_QTY_UPDATE | TIMESTAMP | Indicates when last manual allocation quantity changed for respective item/org. This column is populated by HVGOP flow and is used to determine whether Manual allocation quantity is stale or not. Null value indicates that cache needs to be recomputed. | |||
| ALLOC_RULE_ID | NUMBER | Identifies the Allocation rule to which inventory key belongs | |||
| ALLOC_SPECIFICATION | NUMBER | Allocation specification can be either 1 - Number 2 - Ratio 3 - Percentage | |||
| REPROMISE_START_TIME | TIMESTAMP | Indicates start time of the repromise service call. | |||
| REPROMISE_END_TIME | TIMESTAMP | Indicates end time of the repromise service call. | |||
| SOURCING_CATEGORY_ID | NUMBER | Identifies the sourcing assignment category_id to which item belongs. | |||
| ATP_ALLOC_CATEGORY_ID | NUMBER | Identifies the atp/allocation category_id to which item belongs. | |||
| MAX_LOT_HOLD_DATE | DATE | Stores the maximum hold date across the lots. | |||
| LAST_PROMISING_ACTIVITY_TIME | TIMESTAMP | Identifies the last time the item/org was updated by Promising Requests only and not repromise ess job. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_HVGOP_IAP_U1 | Unique | FUSION_TS_TX_DATA | INVENTORY_KEY |