[Home] [Help] [Dependency Information]
Object Name: | FTE_SCHEDULE_REC |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
SCHEDULE_ID | NUMBER |
|
|
LANE_ID | NUMBER |
|
|
LANE_NUMBER | VARCHAR2 | (30) | |
DEPARTURE_DATE | DATE |
|
|
ARRIVAL_DATE | DATE |
|
|
DEPARTURE_TIME | VARCHAR2 | (10) | |
ARRIVAL_TIME | VARCHAR2 | (10) | |
ARR_TIME_W_IND | VARCHAR2 | (20) | |
FREQUENCY_TYPE_CODE | VARCHAR2 | (10) | |
FREQUENCY_TYPE | VARCHAR2 | (80) | |
FREQUENCY | VARCHAR2 | (10) | |
ARRIVAL_DATE_INDICATOR | VARCHAR2 | (10) | |
FREQUENCY_ARRIVAL | VARCHAR2 | (30) | |
TRANSIT_TIME | NUMBER |
|
|
TRANSIT_TIME_UOM | VARCHAR2 | (10) | |
EFFECTIVE_DATE | DATE |
|
|
EXPIRY_DATE | DATE |
|
|
PORT_OF_LOADING | VARCHAR2 | (240) | |
PORT_OF_DISCHARGE | VARCHAR2 | (240) | |
ORIGIN_ID | NUMBER |
|
|
DESTINATION_ID | NUMBER |
|
|
MODE_OF_TRANSPORT | VARCHAR2 | (80) | |
CARRIER_ID | NUMBER |
|
|
CARRIER_NAME | VARCHAR2 | (360) | |
VESSEL_TYPE | VARCHAR2 | (100) | |
VESSEL_NAME | VARCHAR2 | (30) | |
VOYAGE_NUMBER | VARCHAR2 | (30) | |
MODE_OF_TRANSPORT_CODE | VARCHAR2 | (30) | |
SERVICE_CODE | VARCHAR2 | (30) | |
SERVICE | VARCHAR2 | (80) | |
ACTIVE_FLAG | VARCHAR2 | (10) |
|
|
|