[Home] [Help] [Dependency Information]
Object Name: | FTE_SEARCH_CRITERIA_REC |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
RELAX_FLAG | VARCHAR2 | (1) | |
ORIGIN_LOC_ID | NUMBER |
|
|
DESTINATION_LOC_ID | NUMBER |
|
|
ORIGIN_COUNTRY | VARCHAR2 | (30) | |
ORIGIN_STATE | VARCHAR2 | (30) | |
ORIGIN_CITY | VARCHAR2 | (30) | |
ORIGIN_ZIP | VARCHAR2 | (30) | |
DESTINATION_COUNTRY | VARCHAR2 | (30) | |
DESTINATION_STATE | VARCHAR2 | (30) | |
DESTINATION_CITY | VARCHAR2 | (30) | |
DESTINATION_ZIP | VARCHAR2 | (30) | |
MODE_OF_TRANSPORT | VARCHAR2 | (30) | |
LANE_NUMBER | VARCHAR2 | (30) | |
CARRIER_ID | NUMBER |
|
|
CARRIER_NAME | VARCHAR2 | (360) | |
COMMODITY_CATG_ID | NUMBER |
|
|
COMMODITY | VARCHAR2 | (240) | |
SERVICE_CODE | VARCHAR2 | (30) | |
SERVICE | VARCHAR2 | (80) | |
SCHEDULE_ONLY_FLAG | VARCHAR2 | (1) | |
DEP_DATE_FROM | DATE |
|
|
DEP_DATE_TO | DATE |
|
|
ARR_DATE_FROM | DATE |
|
|
ARR_DATE_TO | DATE |
|
|
LANE_IDS_STRING | VARCHAR2 | (2000) | |
DELIVERY_LEG_ID | NUMBER |
|
|
EXISTS_IN_DATABASE | VARCHAR2 | (1) | |
DELIVERY_ID | NUMBER |
|
|
SEQUENCE_NUMBER | NUMBER |
|
|
PICK_UP_STOP_ID | NUMBER |
|
|
DROP_OFF_STOP_ID | NUMBER |
|
|
PICKUPSTOP_LOCATION_ID | NUMBER |
|
|
DROPOFFSTOP_LOCATION_ID | NUMBER |
|
|
SHIP_TO_SITE_ID | NUMBER |
|
|
VEHICLE_ID | NUMBER |
|
|
EFFECTIVE_DATE | DATE |
|
|
EFFECTIVE_DATE_TYPE | VARCHAR2 | (10) | |
TARIFF_NAME | VARCHAR2 | (80) |
|
|
|