[Home] [Help] [Dependency Information]
Object Name: | WSH_OTM_DLV_OBJ |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
TRANSACTION_CODE | VARCHAR2 | (3) | |
DELIVERY_ID | NUMBER |
|
|
NAME | VARCHAR2 | (30) | |
FREIGHT_TERMS | VARCHAR2 | (30) | |
FOB_CODE | VARCHAR2 | (30) | |
CARRIER_ID | VARCHAR2 | (30) | |
SERVICE_LEVEL | VARCHAR2 | (30) | |
MODE_OF_TRANSPORT | VARCHAR2 | (30) | |
INITIAL_PICKUP_LOCATION_ID | VARCHAR2 | (30) | |
ULTIMATE_DROPOFF_LOCATION_ID | VARCHAR2 | (30) | |
EARLIEST_PICKUP_DATE | DATE |
|
|
LATEST_PICKUP_DATE | DATE |
|
|
EARLIEST_DROPOFF_DATE | DATE |
|
|
LATEST_DROPOFF_DATE | DATE |
|
|
GROSS_WEIGHT | NUMBER |
|
|
WEIGHT_UOM_CODE | VARCHAR2 | (150) | |
VOLUME | NUMBER |
|
|
VOLUME_UOM_CODE | VARCHAR2 | (150) | |
NET_WEIGHT | NUMBER |
|
|
REVISION | NUMBER |
|
|
REASON_OF_TRANSPORT | VARCHAR2 | (30) | |
DESCRIPTION | VARCHAR2 | (30) | |
ADDITIONAL_SHIPMENT_INFO | VARCHAR2 | (500) | |
ROUTING_INSTRUCTIONS | VARCHAR2 | (120) | |
TOTAL_ITEM_COUNT | NUMBER |
|
|
REVISION_QLFR | VARCHAR2 | (20) | |
REASON_OF_TRANSPORT_QLFR | VARCHAR2 | (20) | |
DESCRIPTION_QLFR | VARCHAR2 | (20) | |
ADDITIONAL_SHIPMENT_INFO_QLFR | VARCHAR2 | (20) | |
ROUTING_INSTRUCTIONS_QLFR | VARCHAR2 | (20) | |
RL_DETAILS | WSH_OTM_DET_TAB |
|
|
LPN | WSH_OTM_LPN_TAB |
|
|
|
|