[Home] [Help] [Dependency Information]
Object Name: | FTE_LANE_REC |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
LANE_ID | NUMBER |
|
|
LANE_NUMBER | VARCHAR2 | (30) | |
ORIGIN_ID | NUMBER |
|
|
DESTINATION_ID | NUMBER |
|
|
CARRIER_ID | NUMBER |
|
|
MODE_OF_TRANSPORT_CODE | VARCHAR2 | (30) | |
COMM_FC_CLASS_CODE | VARCHAR2 | (30) | |
COMMODITY_CATG_ID | NUMBER |
|
|
SERVICE_CODE | VARCHAR2 | (30) | |
SCHEDULES_FLAG_CODE | VARCHAR2 | (1) | |
RATE_CHART_ID | NUMBER |
|
|
BASIS | VARCHAR2 | (30) | |
TRANSIT_TIME | NUMBER |
|
|
TRANSIT_TIME_UOM | VARCHAR2 | (10) | |
DISTANCE | NUMBER |
|
|
DISTANCE_UOM | VARCHAR2 | (3) | |
CARRIER_NAME | VARCHAR2 | (80) | |
MODE_OF_TRANSPORT | VARCHAR2 | (80) | |
COMMODITY | VARCHAR2 | (80) | |
SERVICE | VARCHAR2 | (80) | |
SCHEDULES_FLAG | VARCHAR2 | (10) | |
PORT_OF_LOADING | VARCHAR2 | (240) | |
PORT_OF_DISCHARGE | VARCHAR2 | (240) | |
RATE_CHART_NAME | VARCHAR2 | (240) | |
OWNER_ID | NUMBER |
|
|
SPECIAL_HANDLING | VARCHAR2 | (2000) | |
ADDL_INSTR | VARCHAR2 | (2000) | |
COMMODITY_FLAG | VARCHAR2 | (1) | |
SERVICE_FLAG | VARCHAR2 | (1) | |
RATE_CHART_VIEW_FLAG | VARCHAR2 | (1) | |
EFFECTIVE_DATE | DATE |
|
|
EXPIRY_DATE | DATE |
|
|
ORIGIN_REGION_TYPE | NUMBER |
|
|
DEST_REGION_TYPE | NUMBER |
|
|
TARIFF_NAME | VARCHAR2 | (80) | |
LANE_TYPE | VARCHAR2 | (80) |
|
|
|