[Home] [Help] [Dependency Information]
Object Name: | FTE_SHIPMENT_STATUS_HEADERS# |
---|---|
Object Type: | VIEW |
Owner: | FTE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_ID | NUMBER | |||
DELIVERY_LEG_ID | NUMBER | |||
MESSAGE_TYPE | VARCHAR2 | (10) | ||
SHIPMENT_STATUS_ID | NUMBER | Yes | ||
CARRIER_NAME | VARCHAR2 | (30) | ||
GENERATION_DATE | DATE | |||
STATUS | VARCHAR2 | (15) | ||
TRACKING_ID | VARCHAR2 | (30) | ||
TRACKING_ID_TYPE | VARCHAR2 | (50) | ||
BILL_OF_LADING | VARCHAR2 | (60) | ||
CARRIER_SERVICE_LEVEL | VARCHAR2 | (15) | ||
CONTAINER_ID | NUMBER | |||
CONTAINER_SEAL | VARCHAR2 | (30) | ||
ARRIVAL_DATE | DATE | |||
RECEIVED_DATE | DATE | |||
DELIVERY_SCHEDULED_DATE | DATE | |||
DEPARTURE_DATE | DATE | |||
ESTIMATED_ARRIVAL_DATE | DATE | |||
ESTIMATED_DEPARTURE_DATE | DATE | |||
BEGIN_LOADING_DATE | DATE | |||
END_LOADING_DATE | DATE | |||
PROMISED_SHIPMENT_DATE | DATE | |||
PROMISED_DELIVERY_DATE | DATE | |||
SHIPPED_DATE | DATE | |||
EXPECTED_SHIPMENT_DATE | DATE | |||
BEGIN_UNLOADING_DATE | DATE | |||
END_UNLOADING_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (2000) | ||
FREIGHT_CLASS | VARCHAR2 | (10) | ||
HAZARDOUS_MATERIAL | VARCHAR2 | (30) | ||
LOAD_POINT | VARCHAR2 | (60) | ||
NOTES1 | VARCHAR2 | (2000) | ||
NOTES2 | VARCHAR2 | (2000) | ||
NOTES3 | VARCHAR2 | (2000) | ||
NOTES4 | VARCHAR2 | (2000) | ||
NOTES5 | VARCHAR2 | (2000) | ||
NOTES6 | VARCHAR2 | (2000) | ||
NOTES7 | VARCHAR2 | (2000) | ||
NOTES8 | VARCHAR2 | (2000) | ||
NOTES9 | VARCHAR2 | (2000) | ||
SHIP_UNIT_QUANTITY | NUMBER | |||
SHIP_UNIT_UOM | VARCHAR2 | (30) | ||
VOLUME | NUMBER | |||
VOLUME_UOM | VARCHAR2 | (30) | ||
WEIGHT | NUMBER | |||
WEIGHT_UOM | VARCHAR2 | (30) | ||
ROUTE_ID | VARCHAR2 | (30) | ||
ROUTE_TYPE | VARCHAR2 | (15) | ||
SHIP_NOTES | VARCHAR2 | (2000) | ||
SHIPPER_NUMBER | NUMBER | |||
SHIP_POINT | VARCHAR2 | (60) | ||
SPECIAL_HANDLING | VARCHAR2 | (2000) | ||
STOP_NUMBER | NUMBER | |||
SHIPPING_METHOD | VARCHAR2 | (15) | ||
SHIP_FROM_PARTNER | NUMBER | |||
SHIP_TO_PARTNER | NUMBER | |||
CARRIER_PARTNER | NUMBER | |||
BILL_TO_PARTNER | NUMBER | |||
NOTIFY_PARTNER | NUMBER | |||
HOLD_AT_PARTNER | NUMBER | |||
RETURN_TO_PARTNER | NUMBER | |||
MARK_FOR_PARTNER | NUMBER | |||
IMPORTER_PARTNER | NUMBER | |||
EXPORTER_PARTNER | NUMBER | |||
DELIVERY_DETAIL_ID | NUMBER | |||
LICENSE_PLATE_NUMBER | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REASON_CODE | VARCHAR2 | (2000) | ||
TRANSACTION_ID | NUMBER | |||
ACTIVITY_ID | NUMBER | |||
VEHICLE_NUMBER | VARCHAR2 | (35) | ||
OPERATOR | VARCHAR2 | (150) | ||
CARRIER_REF_NUMBER | VARCHAR2 | (30) | ||
WF_ITEM_KEY | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_ID
, DELIVERY_LEG_ID
, MESSAGE_TYPE
, SHIPMENT_STATUS_ID
, CARRIER_NAME
, GENERATION_DATE
, STATUS
, TRACKING_ID
, TRACKING_ID_TYPE
, BILL_OF_LADING
, CARRIER_SERVICE_LEVEL
, CONTAINER_ID
, CONTAINER_SEAL
, ARRIVAL_DATE
, RECEIVED_DATE
, DELIVERY_SCHEDULED_DATE
, DEPARTURE_DATE
, ESTIMATED_ARRIVAL_DATE
, ESTIMATED_DEPARTURE_DATE
, BEGIN_LOADING_DATE
, END_LOADING_DATE
, PROMISED_SHIPMENT_DATE
, PROMISED_DELIVERY_DATE
, SHIPPED_DATE
, EXPECTED_SHIPMENT_DATE
, BEGIN_UNLOADING_DATE
, END_UNLOADING_DATE
, DESCRIPTION
, FREIGHT_CLASS
, HAZARDOUS_MATERIAL
, LOAD_POINT
, NOTES1
, NOTES2
, NOTES3
, NOTES4
, NOTES5
, NOTES6
, NOTES7
, NOTES8
, NOTES9
, SHIP_UNIT_QUANTITY
, SHIP_UNIT_UOM
, VOLUME
, VOLUME_UOM
, WEIGHT
, WEIGHT_UOM
, ROUTE_ID
, ROUTE_TYPE
, SHIP_NOTES
, SHIPPER_NUMBER
, SHIP_POINT
, SPECIAL_HANDLING
, STOP_NUMBER
, SHIPPING_METHOD
, SHIP_FROM_PARTNER
, SHIP_TO_PARTNER
, CARRIER_PARTNER
, BILL_TO_PARTNER
, NOTIFY_PARTNER
, HOLD_AT_PARTNER
, RETURN_TO_PARTNER
, MARK_FOR_PARTNER
, IMPORTER_PARTNER
, EXPORTER_PARTNER
, DELIVERY_DETAIL_ID
, LICENSE_PLATE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REASON_CODE
, TRANSACTION_ID
, ACTIVITY_ID
, VEHICLE_NUMBER
, OPERATOR
, CARRIER_REF_NUMBER
, WF_ITEM_KEY
FROM FTE.FTE_SHIPMENT_STATUS_HEADERS#;
|
|
|