DBA Data[Home] [Help] [Dependency Information]

TABLE: FTE.FTE_BULKLOAD_FILE

Object Details
Object Name: FTE_BULKLOAD_FILE
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_BULKLOAD_FILE
Subobject Name:
Status: VALID


This table is used to store data related to download LTL files.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOAD_ID NUMBER

Load Identifier of the Uploading Process
SCAC VARCHAR2 (10)
SCAC COde of the Carrier
ORIGIN_LOW VARCHAR2 (10)
Postal Code From for Origin
ORIGIN_HIGH VARCHAR2 (10)
Postal Code To for Origin
DEST_LOW VARCHAR2 (10)
Postal Code From for Destination
DEST_HIGH VARCHAR2 (10)
Postal Code To for Destination
CLASS VARCHAR2 (10)
Freight Class Value
MIN_CHARGE1 VARCHAR2 (10)
Minimun Charge Value
L5C NUMBER

Price Break Value Less Then 500
M5C NUMBER

Price Break Value Less Then 1000 and more then 500
M1M NUMBER

Price Break Value more then 1000
M2M NUMBER

Price Break Value more then 2000
M5M NUMBER

Price Break Value more then 5000
M10M NUMBER

Price Break Value more then 10000
M20M NUMBER

Price Break Value more then 20000
M30M NUMBER

Price Break Value more then 30000
M40M NUMBER

Price Break Value more then 40000
EFFECTIVE_DATE DATE

Effective Date
OUTBOUND_FLAG VARCHAR2 (1)
Outbound flag
MILEAGE NUMBER

Mileage
Query Text

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;

Dependencies

[top of page]

FTE.FTE_BULKLOAD_FILE does not reference any database object

FTE.FTE_BULKLOAD_FILE is referenced by following:

SchemaAPPS
SynonymFTE_BULKLOAD_FILE