MSC_HVGOP_REPROMISE_DEMANDS
This table holds the orders which are collected and will be repromised by GOP.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_HVGOP_REPROMISE_DEMANDS_PK |
SALES_ORDER_LINE_ID, SR_INSTANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SALES_ORDER_LINE_ID | VARCHAR2 | 400 | Yes | This column holds the value of the Sales order line identifier. | |
| SPLIT_LINE_ID | VARCHAR2 | 300 | This column holds the value of the identifier for the split suggested by GOP. | ||
| PARENT_FULFILLMENT_LINE | VARCHAR2 | 400 | This column holds the value of the Parent fulfillment line number/identifier of the fulfillment line. | ||
| ROOT_FULFILLMENT_LINE | VARCHAR2 | 400 | This column holds the value of the Root fulfillment line of the sales order demand for ATO/CTO items. | ||
| SALES_ORDER_NUMBER | VARCHAR2 | 240 | This column holds the value of the Sales order number. | ||
| SO_LINE_NUM | VARCHAR2 | 150 | This column holds the value of the Sales order line number of the sales order demand. | ||
| SR_INSTANCE_ID | NUMBER | Yes | This column holds the value of the Source system from where the demand is originated. | ||
| CONFIGURED_ITEM_ID | NUMBER | This column holds the value of the Unique identifier of the configured item. | |||
| INVENTORY_ITEM_ID | NUMBER | Yes | This column holds the value of the Inventory Item Identifier. | ||
| ORGANIZATION_ID | NUMBER | Yes | This column holds the value of the organization ID of the source order. | ||
| ITEM_TYPE_CODE | VARCHAR2 | 30 | This column holds the value whether this is a model/option class/standard item etc. VALID VALUES : MODEL, OPTION_CLASS ,STANDARD Will be populated only for TOE interfaced to DOO. | ||
| ITEM_SUB_TYPE_CODE | VARCHAR2 | 30 | This column holds the sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC). | ||
| SCHEDULE_SHIP_DATE | TIMESTAMP | Yes | This column holds the value of the Schedule ship date on the sales order demand. | ||
| ORDERED_QUANTITY | NUMBER | This column holds the value of the Quantity of an ordered good or service. | |||
| ORDERED_UOM | VARCHAR2 | 25 | This column holds the value of the UOM for ordered quantity. | ||
| 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. | ||
| ALLOCATION_NODE1_ID | NUMBER | Unique Identifier for Allocation attribute value id1 | |||
| ALLOCATION_NODE2_ID | NUMBER | Unique Identifier for Allocation attribute value id2 | |||
| ALLOCATION_NODE3_ID | NUMBER | Unique Identifier for Allocation attribute value id3 | |||
| USING_REQUIREMENT_QUANTITY | NUMBER | Demand quantity that is required in the primary unit of measure. | |||
| CUSTOMER_ID | NUMBER | 18 | This column stores unique partner identifier for customer. | ||
| CUSTOMER_SITE_ID | NUMBER | 18 | This column stores unique identifier for customer site. | ||
| CARRIER_ID | NUMBER | 18 | This column stores unique identifier for the carrier. | ||
| SERVICE_LEVEL | NUMBER | 18 | This column stores service level specified in the shipping method. | ||
| MODE_OF_TRANSPORT | NUMBER | 18 | This column stores type of transportation used to ship the product, such as truck, air or boat. | ||
| 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. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| MRSL_DAYS | NUMBER | This column indicates the Minimum Remaining Shelf Life Days of the demand. | |||
| MRSL_ANCHOR_TYPE | NUMBER | 2 | This column indicates the Minimum Remaining Shelf Life Anchor Type. It Can be Arrival(1) Or Ship(2). | ||
| MRSL_SSD_DAYS | NUMBER | This column indicates the Minimum Remaining Shelf Life Days of the demand with reference to schedule ship date computed by order promising for sales orders. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_HVGOP_REPROMISE_DEMANDS_N1 | Non Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, ITEM_TYPE_CODE |
| MSC_HVGOP_REPROMISE_DEMANDS_N2 | Non Unique | FUSION_TS_TX_IDX | ROOT_FULFILLMENT_LINE, ITEM_TYPE_CODE |
| MSC_HVGOP_REPROMISE_DEMANDS_U1 | Unique | FUSION_TS_TX_IDX | SALES_ORDER_LINE_ID, SR_INSTANCE_ID |