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

TABLE: FTE.FTE_INVOICE_HEADERS

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


Table to store invoice header information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_INVOICE_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_NUMBER
FTE_INVOICE_HEADERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_REF
FTE_INVOICE_HEADERS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOL
FTE_INVOICE_HEADERS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCARRIER_ID
Columns
Name Datatype Length Mandatory Comments
BILL_OF_LADING_ESTIMATE NUMBER

Bill of lading estimate
INVOICE_HEADER_ID NUMBER
Yes Invoice header id
BILL_NUMBER VARCHAR2 (30) Yes Bill number
BILL_STATUS VARCHAR2 (30) Yes Bill status
BILL_DATE DATE
Yes Bill date
BILL_TYPE VARCHAR2 (30)
Bill type
BILL_REF VARCHAR2 (30)
Bill reference number
BOL VARCHAR2 (30)
Bill of lading number
PICKUP_DATE DATE

Pickup date
PICKUP_LOCATION_ID NUMBER

Pickup location id
PICKUP_LOC_ADDRLINE VARCHAR2 (1000)
Pickup location address line
PICKUP_LOC_CITY VARCHAR2 (120)
Pickup location city
PICKUP_LOC_STATE VARCHAR2 (120)
Pickup location state
PICKUP_LOC_COUNTRY VARCHAR2 (120)
Pickup location country
PICKUP_LOC_POSTALCODE VARCHAR2 (60)
Pickup location postal code
DROPOFF_DATE DATE

Dropoff date
DROPOFF_LOCATION_ID NUMBER

Dropoff location id
DROPOFF_LOC_ADDRLINE VARCHAR2 (1000)
Dropoff location address line
DROPOFF_LOC_CITY VARCHAR2 (120)
Dropoff location city
DROPOFF_LOC_STATE VARCHAR2 (120)
Dropoff location state
DROPOFF_LOC_COUNTRY VARCHAR2 (120)
Dropoff location country
DROPOFF_LOC_POSTALCODE VARCHAR2 (60)
Dropoff location postal code
SCAC_CODE VARCHAR2 (4)
Scac code
CARRIER_ID NUMBER

Carrier id
SUPPLIER_ID NUMBER

Supplier id
SUPPLIER_SITE_ID NUMBER

Supplier site id
MODE_OF_TRANSPORT VARCHAR2 (30)
Mode of transport
VEHICLE_TYPE VARCHAR2 (30)
Vehicle type
LOADED_DISTANCE_UOM VARCHAR2 (30)
Loaded distance uom
LOADED_DISTANCE NUMBER

Loaded distance
UNLOADED_DISTANCE_UOM VARCHAR2 (30)
Unloaded distance uom
UNLOADED_DISTANCE NUMBER

Unloaded distance
BILLED_TIME_UOM VARCHAR2 (30)
Billed time uom
BILLED_TIME NUMBER

Billed time
TOTAL_AMOUNT NUMBER

Total amount
APPROVED_AMOUNT NUMBER

Approved amount
CURRENCY_CODE VARCHAR2 (15)
Currency code
REMARKS VARCHAR2 (1000)
Remarks
EDIT_AUDIT_DETAIL VARCHAR2 (1)
Edit audit page flag
EDIT_BILL VARCHAR2 (1)
Edit bill flag
SOURCE VARCHAR2 (30)
Source
CREATED_BY NUMBER
Yes Standard who columns
CREATION_DATE DATE
Yes Standard who columns
LAST_UPDATED_BY NUMBER
Yes Standard who columns
LAST_UPDATE_DATE DATE
Yes Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
ORG_ID NUMBER

Organization id
DISTRIBUTION_ACCOUNT_ID NUMBER

Distribution account id
REQUEST_ID NUMBER

Request id
PROGRAM_APPLICATION_ID NUMBER

Standard columns for concurrent program
PROGRAM_ID NUMBER

Standard columns for concurrent program
PROGRAM_UPDATE_DATE DATE

Standard columns for concurrent program
CARRIER_NAME VARCHAR2 (240)
Carrier name
DROPOFF_LOCATION VARCHAR2 (240)
Dropoff location
PICKUP_LOCATION VARCHAR2 (240)
Pickup location
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BILL_OF_LADING_ESTIMATE
,      INVOICE_HEADER_ID
,      BILL_NUMBER
,      BILL_STATUS
,      BILL_DATE
,      BILL_TYPE
,      BILL_REF
,      BOL
,      PICKUP_DATE
,      PICKUP_LOCATION_ID
,      PICKUP_LOC_ADDRLINE
,      PICKUP_LOC_CITY
,      PICKUP_LOC_STATE
,      PICKUP_LOC_COUNTRY
,      PICKUP_LOC_POSTALCODE
,      DROPOFF_DATE
,      DROPOFF_LOCATION_ID
,      DROPOFF_LOC_ADDRLINE
,      DROPOFF_LOC_CITY
,      DROPOFF_LOC_STATE
,      DROPOFF_LOC_COUNTRY
,      DROPOFF_LOC_POSTALCODE
,      SCAC_CODE
,      CARRIER_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      MODE_OF_TRANSPORT
,      VEHICLE_TYPE
,      LOADED_DISTANCE_UOM
,      LOADED_DISTANCE
,      UNLOADED_DISTANCE_UOM
,      UNLOADED_DISTANCE
,      BILLED_TIME_UOM
,      BILLED_TIME
,      TOTAL_AMOUNT
,      APPROVED_AMOUNT
,      CURRENCY_CODE
,      REMARKS
,      EDIT_AUDIT_DETAIL
,      EDIT_BILL
,      SOURCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      DISTRIBUTION_ACCOUNT_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CARRIER_NAME
,      DROPOFF_LOCATION
,      PICKUP_LOCATION
FROM FTE.FTE_INVOICE_HEADERS;

Dependencies

[top of page]

FTE.FTE_INVOICE_HEADERS does not reference any database object

FTE.FTE_INVOICE_HEADERS is referenced by following:

SchemaFTE
ViewFTE_INVOICE_HEADERS#