[Home] [Help] [Dependency Information]
Object Name: | WSH_DEL_LEGS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_LEG_INTERFACE_ID | NUMBER | Yes | ||
DELIVERY_LEG_ID | NUMBER | |||
DELIVERY_ID | NUMBER | |||
DELIVERY_INTERFACE_ID | NUMBER | Yes | ||
PROGRAM_UPDATE_DATE | DATE | |||
SEQUENCE_NUMBER | NUMBER | |||
LOADING_ORDER_FLAG | VARCHAR2 | (2) | ||
PICK_UP_STOP_ID | NUMBER | |||
PICK_UP_STOP_INTERFACE_ID | NUMBER | Yes | ||
DROP_OFF_STOP_ID | NUMBER | |||
DROP_OFF_STOP_INTERFACE_ID | NUMBER | Yes | ||
GROSS_WEIGHT | NUMBER | |||
NET_WEIGHT | NUMBER | |||
WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
VOLUME | NUMBER | |||
VOLUME_UOM_CODE | VARCHAR2 | (3) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
INTERFACE_ACTION_CODE | VARCHAR2 | (30) | ||
LOCK_FLAG | NUMBER | |||
PROCESS_FLAG | NUMBER | |||
PROCESS_MODE | NUMBER | |||
DELETE_FLAG | NUMBER | |||
PROCESS_STATUS_FLAG | NUMBER | |||
AETC_NUMBER | VARCHAR2 | (30) | ||
BILL_FREIGHT_TO | VARCHAR2 | (1000) | ||
BOOKING_NUMBER | VARCHAR2 | (30) | ||
BOOKING_OFFICE | VARCHAR2 | (50) | ||
CARRIER_DATE | DATE | |||
CARRIER_EXPORT_REF | VARCHAR2 | (30) | ||
CARRIER_HM_BY | VARCHAR2 | (150) | ||
CARRIER_HM_DATE | DATE | |||
CARRIER_SIGNED_BY | VARCHAR2 | (150) | ||
DOC_DATE_ISSUED | DATE | |||
DOC_ISSUE_OFFICE | VARCHAR2 | (150) | ||
DOC_ISSUED_BY | VARCHAR2 | (150) | ||
DOC_NOTIFY_PARTY | VARCHAR2 | (30) | ||
EXPECTED_POD_DATE | DATE | |||
POD_BY | VARCHAR2 | (150) | ||
POD_DATE | DATE | |||
POD_FLAG | VARCHAR2 | (1) | ||
PORT_OF_DISCHARGE | VARCHAR2 | (150) | ||
PORT_OF_LOADING | VARCHAR2 | (150) | ||
REQUEST_ID | NUMBER | |||
SERVICE_CONTRACT | VARCHAR2 | (30) | ||
SHIPPER_DATE | DATE | |||
SHIPPER_EXPORT_REF | VARCHAR2 | (30) | ||
SHIPPER_HM_BY | VARCHAR2 | (150) | ||
SHIPPER_HM_DATE | DATE | |||
SHIPPER_PHONE | VARCHAR2 | (20) | ||
SHIPPER_SIGNED_BY | VARCHAR2 | (150) | ||
SHIPPER_TITLE | VARCHAR2 | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_LEG_INTERFACE_ID
, DELIVERY_LEG_ID
, DELIVERY_ID
, DELIVERY_INTERFACE_ID
, PROGRAM_UPDATE_DATE
, SEQUENCE_NUMBER
, LOADING_ORDER_FLAG
, PICK_UP_STOP_ID
, PICK_UP_STOP_INTERFACE_ID
, DROP_OFF_STOP_ID
, DROP_OFF_STOP_INTERFACE_ID
, GROSS_WEIGHT
, NET_WEIGHT
, WEIGHT_UOM_CODE
, VOLUME
, VOLUME_UOM_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, INTERFACE_ACTION_CODE
, LOCK_FLAG
, PROCESS_FLAG
, PROCESS_MODE
, DELETE_FLAG
, PROCESS_STATUS_FLAG
, AETC_NUMBER
, BILL_FREIGHT_TO
, BOOKING_NUMBER
, BOOKING_OFFICE
, CARRIER_DATE
, CARRIER_EXPORT_REF
, CARRIER_HM_BY
, CARRIER_HM_DATE
, CARRIER_SIGNED_BY
, DOC_DATE_ISSUED
, DOC_ISSUE_OFFICE
, DOC_ISSUED_BY
, DOC_NOTIFY_PARTY
, EXPECTED_POD_DATE
, POD_BY
, POD_DATE
, POD_FLAG
, PORT_OF_DISCHARGE
, PORT_OF_LOADING
, REQUEST_ID
, SERVICE_CONTRACT
, SHIPPER_DATE
, SHIPPER_EXPORT_REF
, SHIPPER_HM_BY
, SHIPPER_HM_DATE
, SHIPPER_PHONE
, SHIPPER_SIGNED_BY
, SHIPPER_TITLE
FROM WSH.WSH_DEL_LEGS_INTERFACE#;
|
|
|