MSC_ST_SHIP_HIST_INT

This is the Staging table to collective store the Booking history from DOO and the logistics table before processing them.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Not-null Comments
ITEM_NAME VARCHAR2 300 Column to store the ITEM_NAME
ORIGINAL_ITEM_NAME VARCHAR2 300 Column to store the ORIGINAL_ITEM_NAME
ORGANIZATION_CODE VARCHAR2 100 Column to store the ORGANIZATION_CODE
CUS_LVL_MEMBER_NAME VARCHAR2 360 Column to store the CUS_LVL_MEMBER_NAME
CUS_SITE_LVL_MEMBER_NAME VARCHAR2 360 Column to store the CUS_SITE_LVL_MEMBER_NAME
SHIPPED_DATE DATE Column to store the SHIPPED_DATE
REQUESTED_DATE DATE Column to store the REQUESTED_DATE
PROMISED_DATE DATE PColumn to store the ROMISED_DATE
SCHEDULED_DATE DATE Column to store SCHEDULED_DATE
PERSON_NAME VARCHAR2 360 Column to store the PERSON_NAME
ORDER_TYPE_CODE VARCHAR2 50 Column to store the ORDER_TYPE_CODE
DEMAND_CLASS_CODE VARCHAR2 250 Column to store the DEMAND_CLASS_CODE
ORDER_TYPE_FLAG VARCHAR2 30 Column to store the ORDER_TYPE_FLAG
VALUE_NUMBER_QUANTITY NUMBER Column to store the VALUE_NUMBER_QUANTITY
VALUE_NUMBER_AMOUNT NUMBER Column to store the VALUE_NUMBER_AMOUNT
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.