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. |