[Home] [Help] [Dependency Information]
Object Name: | WSH_OTM_TRIP_OBJ |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
SHIPMENT_XID | VARCHAR2 | (200) | |
SHIPMENT_NAME | VARCHAR2 | (2000) | |
SHIPMENT_REFNUM | VARCHAR2 | (200) | |
TRANSACTION_CODE | VARCHAR2 | (10) | |
SERVICE_PROVIDER_XID | VARCHAR2 | (200) | |
CONTACT_XID | VARCHAR2 | (200) | |
TRANSPORT_MODE_XID | VARCHAR2 | (200) | |
RATE_SERVICE_XID | VARCHAR2 | (200) | |
WEIGHT_UOM_XID | VARCHAR2 | (200) | |
VOLUME | NUMBER |
|
|
VOLUME_UOM_XID | VARCHAR2 | (200) | |
SHIPUNIT_COUNT | NUMBER |
|
|
PAYMENT_CODE_XID | VARCHAR2 | (200) | |
STOP_COUNT | NUMBER |
|
|
RELEASE_COUNT | NUMBER |
|
|
VOYAGE_XID | VARCHAR2 | (200) | |
VESSEL_XID | VARCHAR2 | (200) | |
EQUIPMENT_XID | VARCHAR2 | (200) | |
EQUIPMENT_INITIAL | VARCHAR2 | (200) | |
EQUIPMENT_NUMBER | VARCHAR2 | (200) | |
EQUIPMENT_TYPE_XID | VARCHAR2 | (200) | |
EQUIPMENT_GROUP_XID | VARCHAR2 | (200) | |
TP_PLAN_NAME | VARCHAR2 | (200) | |
EQUIPMENT_SEAL | VARCHAR2 | (30) | |
MASTER_BOL_NUMBER | VARCHAR2 | (50) | |
PLANNED_FLAG | VARCHAR2 | (1) | |
ROUTING_INSTRUCTIONS | VARCHAR2 | (2000) | |
GROSS_WEIGHT | NUMBER |
|
|
NET_WEIGHT | NUMBER |
|
|
BOOKING_NUMBER | VARCHAR2 | (30) | |
ESTIMATED_COST | VARCHAR2 | (200) | |
TRIP_ID | NUMBER |
|
|
IGNORE_FOR_PLANNING | VARCHAR2 | (1) | |
OPERATOR | VARCHAR2 | (150) | |
MANUAL_FREIGHT_COSTS | NUMBER |
|
|
CURRENCY_CODE | VARCHAR2 | (15) | |
PACKED_ITEM_COUNT | NUMBER |
|
|
TRIP_ID_QLFR | VARCHAR2 | (20) | |
MBOL_NUMBER_QLFR | VARCHAR2 | (30) | |
PLANNED_TRIP_QLFR | VARCHAR2 | (30) | |
MANUAL_FREIGHT_COSTS_QLFR | VARCHAR2 | (30) | |
MAN_FREIGHT_COST_CUR_QLFR | VARCHAR2 | (30) | |
OPERATOR_QLFR | VARCHAR2 | (30) | |
ROUTING_INSTR_QLFR | VARCHAR2 | (30) | |
SHIPMENT_STOPS | WSH_OTM_STOP_TAB |
|
|
SHIPMENT_SHIP_UNITS | WSH_OTM_SHIP_UNIT_TAB |
|
|
SHIPMENT_DELIVERIES | WSH_OTM_DLV_TAB |
|
|
SHIPMENT_RELEASES | WSH_OTM_RELEASE_TAB |
|
|
LPNS | WSH_OTM_LPN_TAB |
|
|
STOP_LOCATIONS | WSH_OTM_STOPLOCTZ_TAB |
|
|
|
|