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