MSC_BM_RUN_ALLOC_MEASURES
Output table which stores data from Backlog Management engine outputs and measures for allocation
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
MSC_BM_RUN_ALLOC_MEASURES_PK |
BM_RUN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, RESOURCE_ID, ATTRIBUTE_ID, ATTRIBUTE_VALUE_ID, BUCKET_DATE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
BM_RUN_ID | NUMBER | Yes | Field indicates unique identifier for a Backlog Run. | ||
INVENTORY_ITEM_ID | NUMBER | Yes | Field indicates unique identifier for an Inventory Item | ||
ORGANIZATION_ID | NUMBER | Yes | Field indicates unique identifier for Organization | ||
RESOURCE_ID | NUMBER | Yes | Field indicates unique identifier for Resource | ||
ATTRIBUTE_ID | NUMBER | Yes | Field indicates identifier for Attribute of the Allocation Node | ||
ATTRIBUTE_VALUE_ID | NUMBER | Yes | Field indicates Attribute Value identifier for Allocation Node | ||
LEVEL1_ATTRIBUTE_VALUE_ID | NUMBER | Yes | Field indicates Attribute Value identifier for the Level1 for Allocation Node | ||
LEVEL2_ATTRIBUTE_VALUE_ID | NUMBER | Yes | Field indicates Attribute Value identifier for the Level2 for Allocation Node | ||
LEVEL3_ATTRIBUTE_VALUE_ID | NUMBER | Yes | Field indicates Attribute Value identifier for the Level3 for Allocation Node | ||
BUCKET_DATE | DATE | Yes | Field indicates start date of bucket | ||
ALLOC_SUP | NUMBER | Field indicates total allocated supply for the bucket and the allocation node | |||
CONSUM_SUP | NUMBER | Field indicates total consumed supply for the bucket and the allocation node | |||
AVAIL_SUP | NUMBER | Field indicates total available supply after consumption for the bucket and the allocation node | |||
CUML_AVAIL_SUP | NUMBER | Field indicates total available supply after consumption for Allocation Node | |||
GROSS_SUP | NUMBER | Field indicates the Total Supply for the bucket. Shipped history quantity is included in bucket 1 | |||
GROSS_ALLOC | NUMBER | Field indicates the Total Allocated Supply for the bucket. Shipped history quantity is included in bucket 1 | |||
ALLOC_CHILD | NUMBER | Field indicates total allocated supply for the bucket and the child nodes | |||
GROSS_CONSUM | NUMBER | Field indicates total consumed supply for the bucket and the allocation nodes | |||
GROSS_AVAIL | NUMBER | Field indicates total available supply for the bucket and the allocation nodes | |||
GROSS_CUML_AVAIL | NUMBER | Field indicates total available supply for till the bucket (cumulative) and the allocation nodes | |||
ALLOC_STEAL | NUMBER | Field indicates the total allocated supply stealing. | |||
GROSS_ALLOC_STEAL | NUMBER | Field indicates the Sum of Stolen Allocation for the specific node plus all child nodes | |||
AVAIL_STEAL | NUMBER | Field indicates the quantity available for stealing at the node for bucket | |||
AVAIL_STEAL_PROTECT | NUMBER | Field indicates the quantity of supply which protected from stealing at the node for bucket | |||
NET_WEEK_SUP | NUMBER | Field indicates the total supply available per bucket for item-organization combination irrespective of allocation node | |||
ALLOC_USER_DEF | NUMBER | Field indicates the Allocation specified at an Allocation Node per bucket | |||
ALLOC_ADJUST | NUMBER | Field indicates the allocation adjustment which reduce or increase the available allocation for the node per bucket | |||
ADJUST_AVAIL | NUMBER | Field indicates the adjusted availability after accounting for allocation adjustment per bucket per node | |||
CONSUM_HISTORY | NUMBER | Field indicates the Completed Sales Order Quantities for the bucket and the allocation node | |||
GROSS_CONSUM_HISTORY | NUMBER | Field indicates the Gross Consumed Supply by shipped orders. | |||
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. | ||
REFRESH_NUMBER | NUMBER | 18 | Refresh identifier populated by the collection program |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
MSC_BM_RUN_ALLOC_MEASURES_U1 | Unique | Default | BM_RUN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, RESOURCE_ID, ATTRIBUTE_ID, ATTRIBUTE_VALUE_ID, BUCKET_DATE |