MSC_HVGOP_ALLOC_REPORT_DATA
This is an interface table between GOP engine and Supply Allocation Report/Allocation workbench user interface. GOP engine flushes the data in this table , so that UI can display it to a user.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_HVGOP_ALLOC_REPORT_DATA_PK |
INVENTORY_ITEM_ID, ORGANIZATION_ID, NODE_ID, BUCKET_DATE |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| QUERY_ID | NUMBER | Unique identifier for each Allocation report query to be passed to GOP engine by UI, so that UI can fetch all rows with this QUERY_ID and display it to the user. | ||
| INVENTORY_ITEM_ID | NUMBER | Yes | Unique Identifier for inventory item. | |
| ORGANIZATION_ID | NUMBER | Yes | Unique Identifier for Organization. | |
| ATTRIBUTE_ID | NUMBER | Unique Identifier for Allocation Attribute level. | ||
| NODE_ID | NUMBER | Yes | Value that uniquely identifies the allocation node. | |
| ATTRIBUTE1_VALUE_ID | NUMBER | Attribute that represents Level 1 Allocation node. | ||
| ATTRIBUTE2_VALUE_ID | NUMBER | Attribute that represents Level 2 Allocation node. | ||
| ATTRIBUTE3_VALUE_ID | NUMBER | Attribute that represents Level 3 Allocation node. | ||
| BUCKET_DATE | DATE | Yes | A date identifier that indicates the date of Supply/Demand. | |
| ALLOC_QTY | NUMBER | Supply allocated to a node based on the Allocation rule setup. | ||
| CONSUMED_QTY | NUMBER | Allocated supply consumed at a node (does not include consumption through stealing from other nodes). | ||
| AVAILABLE_QTY | NUMBER | Allocation available at the specific node (Allocated Less Consumed). | ||
| CUM_AVAIL_QTY | NUMBER | Allocation cumulatively available at the specific node across weeks. | ||
| GROSS_ALLOC_QTY | NUMBER | Supply allocated to the parent node and all its children. | ||
| CHILD_ALLOC_QTY | NUMBER | A number that represents Allocation to child nodes. | ||
| GROSS_CONSUM_QTY | NUMBER | Allocation consumed at the parent node and all its child nodes. | ||
| GROSS_AVAIL_QTY | NUMBER | Allocation available for the parent and all its children. | ||
| GROSS_CUM_AVAIL_QTY | NUMBER | Allocation cumulatively available at the parent node and all its children. | ||
| ALLOC_QTY_TO_STEAL | NUMBER | Allocated supply for the node less supply represented by "Stealing Protection". | ||
| GROSS_ALLOC_STEAL | NUMBER | Aggregate supply quantity donated or stolen for the node and all its children. | ||
| STOLEN_QTY | NUMBER | value representing the supply donated to other. | ||
| TOTAL_WEEKLY_SUPPLY_QTY | NUMBER | Per week, the Total Weekly Supply will be populated, without reference to any Allocation Node - this represents the total weekly supply for the Item-Org in that week. | ||
| 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_HVGOP_ALLOC_REPORT_DATA_U1 | Unique | Default | INVENTORY_ITEM_ID, ORGANIZATION_ID, NODE_ID, BUCKET_DATE |