[Home] [Help] [Dependency Information]
Object Name: | FTE_BULKLOAD_FILE# |
---|---|
Object Type: | VIEW |
Owner: | FTE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAD_ID | NUMBER | |||
SCAC | VARCHAR2 | (10) | ||
ORIGIN_LOW | VARCHAR2 | (10) | ||
ORIGIN_HIGH | VARCHAR2 | (10) | ||
DEST_LOW | VARCHAR2 | (10) | ||
DEST_HIGH | VARCHAR2 | (10) | ||
CLASS | VARCHAR2 | (10) | ||
MIN_CHARGE1 | VARCHAR2 | (10) | ||
L5C | NUMBER | |||
M5C | NUMBER | |||
M1M | NUMBER | |||
M2M | NUMBER | |||
M5M | NUMBER | |||
M10M | NUMBER | |||
M20M | NUMBER | |||
M30M | NUMBER | |||
M40M | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
OUTBOUND_FLAG | VARCHAR2 | (1) | ||
MILEAGE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LOAD_ID
, SCAC
, ORIGIN_LOW
, ORIGIN_HIGH
, DEST_LOW
, DEST_HIGH
, CLASS
, MIN_CHARGE1
, L5C
, M5C
, M1M
, M2M
, M5M
, M10M
, M20M
, M30M
, M40M
, EFFECTIVE_DATE
, OUTBOUND_FLAG
, MILEAGE
FROM FTE.FTE_BULKLOAD_FILE#;
|
|
|