1. Tables and Views for SCM
  2. MSC_HVGOP_WEEKLY_ALLOC_REPORT

MSC_HVGOP_WEEKLY_ALLOC_REPORT

This table contains allocation node level weekly allocation information for items with allocation rule from system date to ITF or specified end date.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

MSC_HVGOP_WEEKLY_ALLOC_REP_PK

RECORD_ID

Columns

Name Datatype Length Precision Not-null Comments
RECORD_ID NUMBER 18 Yes Unique identifier of each record.
INSTANCE_CODE VARCHAR2 30 Yes Identifier for the source system.
ITEM_NAME VARCHAR2 300 Yes Identifies the inventory item name.
ORGANIZATION_CODE VARCHAR2 49 Yes Identifies the organization code.
ALLOCATION_NODE_1 VARCHAR2 100 Yes Identifies the first level allocation node.
ALLOCATION_NODE_2 VARCHAR2 100 Identifies the second level allocation node.
ALLOCATION_NODE_3 VARCHAR2 100 Identifies the third level allocation node.
WEEK_START_DATE DATE Yes Identifies the week start date of supply/demand, starting on Monday.
WEEK_END_DATE DATE Yes Identifies the week end date of supply/demand, ending on Sunday.
ALLOCATED_QTY NUMBER Yes Allocated quantity for the allocation node on the week of record date.
CONSUMED_QTY NUMBER Yes Consumed quantity for the allocation node on the week of record date.
NET_QTY NUMBER Yes Difference between Allocated quantity and Consumed quantity on record date.
CUM_QTY NUMBER Yes Cumulative available quantity for the allocation node on the record date.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
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.
SHIPPED_QTY NUMBER Stores the total shipped quantity at the node which includes quantity consumed at the node via inheritance and redeployment within the history range defined.

Indexes

Index Uniqueness Tablespace Columns
MSC_HVGOP_WEEKLY_ALLOC_REP_U1 Unique Default RECORD_ID