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 | ||
| DEMAND_QUANTITY | NUMBER | Field indicates the demand quantity for that item, allocated node, bucket . | |||
| DEMAND_QUANTITY_ONTIME | NUMBER | Field indicates the demand quantity that is met on time for that item, allocated node, bucket . | |||
| PLAN_FILL_PERCENT | NUMBER | Field indicates planned fill rate percentage for that item, allocated node, bucket . | |||
| SCHEDULE_FILL_PERCENT | NUMBER | Field indicates the scheduled fill rate percentage for that item, allocated node, bucket . | |||
| SCHEDULE_ONTIME_PERCENT | NUMBER | Field indicates scheduled on time percentage for that item, allocated node, bucket . | |||
| REVENUE | NUMBER | Field indicates the demand revenue for that item, allocated node, bucket . | |||
| REVENUE_PLAN_ONTIME | NUMBER | Field indicates revenue generated for on time planned order for that item, allocated node, bucket . | |||
| REVENUE_SCH_ONTIME | NUMBER | Field indicates the revenue genearted for on time scedhuled orders for that item, allocated node, bucket . | |||
| PLAN_ONTIME_PERCENT | NUMBER | Field indicates planned on time percentage for that item, allocated node, bucket. |
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 |