Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - FTE Tables and Views

TABLE - FTE.FTE_BULKLOAD_DATA
TABLE - FTE.FTE_BULKLOAD_FILE
TABLE - FTE.FTE_DELIVERY_PROOF
TABLE - FTE.FTE_ESTIMATE_RATES_DEL_TEMP
TABLE - FTE.FTE_FACILITY_CARRIERS
TABLE - FTE.FTE_FAILURE_REASONS
TABLE - FTE.FTE_FREIGHT_COSTS_TEMP
TABLE - FTE.FTE_FREIGHT_ESTIMATE_TEMP
TABLE - FTE.FTE_INTERFACE_LANES
TABLE - FTE.FTE_INTERFACE_ZONES
TABLE - FTE.FTE_INVOICE_HEADERS
TABLE - FTE.FTE_INVOICE_HISTORY
TABLE - FTE.FTE_INVOICE_LINES
TABLE - FTE.FTE_LANES
TABLE - FTE.FTE_LANE_COMMODITIES
TABLE - FTE.FTE_LANE_EQUIPMENTS
TABLE - FTE.FTE_LANE_GROUPS
TABLE - FTE.FTE_LANE_GROUP_COMPONENTS
TABLE - FTE.FTE_LANE_RATE_CHARTS
TABLE - FTE.FTE_LANE_SERVICES
TABLE - FTE.FTE_LANE_VEHICLES
TABLE - FTE.FTE_LOCATION_MILEAGES
TABLE - FTE.FTE_LOCATION_PARAMETERS
TABLE - FTE.FTE_MESSAGE_ADDRESS
TABLE - FTE.FTE_MESSAGE_CONTACT
TABLE - FTE.FTE_MESSAGE_LOCATION
TABLE - FTE.FTE_MESSAGE_PARTNER
TABLE - FTE.FTE_MILE_ATTRIBUTES
TABLE - FTE.FTE_MILE_COLUMN_ATTRIBUTES
TABLE - FTE.FTE_MILE_DOWNLOAD_FILES
TABLE - FTE.FTE_MILE_DOWNLOAD_LINES
TABLE - FTE.FTE_MILE_TEMPLATES
TABLE - FTE.FTE_MILE_TEMPLATE_COLUMNS
TABLE - FTE.FTE_MOVES
TABLE - FTE.FTE_MOVES_INTERFACE
TABLE - FTE.FTE_PRC_PARAMETERS
TABLE - FTE.FTE_PRC_PARAMETER_DEFAULTS
TABLE - FTE.FTE_PTRK_EVENTS
TABLE - FTE.FTE_PTRK_PAGES
TABLE - FTE.FTE_PTRK_PARAMS
TABLE - FTE.FTE_PTRK_SOURCES
TABLE - FTE.FTE_SCHEDULES
TABLE - FTE.FTE_SEL_ATTRIBUTES
TABLE - FTE.FTE_SEL_ATTRIBUTES_TMP
TABLE - FTE.FTE_SEL_GROUPS
TABLE - FTE.FTE_SEL_GROUP_ASSIGNMENTS
TABLE - FTE.FTE_SEL_GROUP_ATTRIBUTES
TABLE - FTE.FTE_SEL_OBJECTS
TABLE - FTE.FTE_SEL_RESULTS
TABLE - FTE.FTE_SEL_RESULT_ASSIGNMENTS
TABLE - FTE.FTE_SEL_RESULT_ATTRIBUTES
TABLE - FTE.FTE_SEL_RULES
TABLE - FTE.FTE_SEL_RULE_RESTRICTIONS
TABLE - FTE.FTE_SHIPMENT_STATUS_DETAILS
TABLE - FTE.FTE_SHIPMENT_STATUS_EXCEPTIONS
TABLE - FTE.FTE_SHIPMENT_STATUS_HEADERS
TABLE - FTE.FTE_TARIFF_CARRIERS
TABLE - FTE.FTE_TENDER_SNAPSHOT
TABLE - FTE.FTE_TRIPS
TABLE - FTE.FTE_TRIP_MOVES
TABLE - FTE.FTE_TRIP_MOVES_INTERFACE
TABLE - FTE.FTE_VEHICLE_FEATURES
TABLE - FTE.FTE_VEHICLE_TYPES
TABLE - FTE.FTE_WSH_TRIPS
VIEW - APPS.FTE_PRC_LANE_COMP_UI_V
VIEW - APPS.FTE_PRC_VIEW_PRICE_UI_V
VIEW - APPS.FTE_PTRK_TOKENS_V

Table: FTE_BULKLOAD_DATA

Description: This table is used to store data related to download and upload for the Bulkload processing.
Primary Key: FTE_BULKLOAD_DATA_PK
  1. LOAD_ID
Comments

This table is used to store data related to download and upload for the Bulkload processing.

Indexes
Index Type Tablespace Column
SYS_IL0000194331C00007$$ UNIQUE APPS_TS_INTERFACE
FTE_BULKLOAD_DATA_U1 NONUNIQUE APPS_TS_INTERFACE LOAD_ID
Columns
Name Datatype Length Mandatory Comments
LOAD_ID NUMBER
Y Load Identifier
LOAD_TYPE VARCHAR2 (20) Y Type of Bulkload processing
FILE_TYPE VARCHAR2 (10) Y Type of File, which is to be upload or download
FILE_NAME VARCHAR2 (200)
Name of the File, which is to be upload or download
FILE_SIZE NUMBER

File Size
REQUEST_ID NUMBER

Std Who Column
CONTENT BLOB (4000)
Content of the File
CREATED_BY NUMBER
Y Std Who Column
CREATION_DATE DATE
Y Std Who Column
LAST_UPDATED_BY NUMBER
Y Std Who Column
LAST_UPDATE_DATE DATE
Y Std Who Column
LAST_UPDATE_LOGIN NUMBER

Std Who Column

[top of page]

FTE.FTE_BULKLOAD_DATA does not reference any database object

FTE.FTE_BULKLOAD_DATA is referenced by following:

FTE
VIEW - FTE_BULKLOAD_DATA#

[top of page]

Table: FTE_BULKLOAD_FILE

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

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

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

[top of page]

FTE.FTE_BULKLOAD_FILE does not reference any database object

FTE.FTE_BULKLOAD_FILE is referenced by following:

FTE
VIEW - FTE_BULKLOAD_FILE#

[top of page]

Table: FTE_DELIVERY_PROOF

Description: Proof of Delivery Message
Primary Key: FTE_DELIVERY_PROOF_PK
  1. ID
Comments

This table holds the POD portion of the ShowShipment message

Indexes
Index Type Tablespace Column
FTE_DELIVERY_PROOF_U1 UNIQUE APPS_TS_TX_IDX ID
FTE_DELIVERY_PROOF_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y Primary Key
RECEIVED_DATE DATE

Received Date
NAME1 VARCHAR2 (50)
SHIP_UNIT_QUANTITY NUMBER

Ship Unit Quantity
SHIP_UNIT_UOM VARCHAR2 (30)
Ship Unit Unit of Measure
NOTES1 VARCHAR2 (2000)
Notes
NOTES2 VARCHAR2 (2000)
Notes
NOTES3 VARCHAR2 (2000)
Notes
NOTES4 VARCHAR2 (2000)
Notes
NOTES5 VARCHAR2 (2000)
Notes
NOTES6 VARCHAR2 (2000)
Notes
NOTES7 VARCHAR2 (2000)
Notes
NOTES8 VARCHAR2 (2000)
Notes
NOTES9 VARCHAR2 (2000)
Notes
SHIP_UNIT_SEQ NUMBER

Ship Unit Sequence Number
SHIP_UNIT_TOTAL NUMBER

Ship Unit Total (highest sequence number)
CREATED_BY NUMBER

Created by
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
TRANSACTION_ID NUMBER

Transaction ID FK reference to Shipment Status Headers table
TRACKING_ID VARCHAR2 (30)
Tracking Id used in message
TRACKING_ID_TYPE VARCHAR2 (50)
Tracking Id Type
CONSIGNEE_NAME VARCHAR2 (50)
Name of recipient
STATUS VARCHAR2 (20)
Status of the Delivered Shipment
SHIPMENT_WEIGHT NUMBER

Weight of the Shipment
SHIPMENT_VOLUME NUMBER

Volume of the Shipment
LOCATION VARCHAR2 (500)
Location where Shipment was received by the Consignee

[top of page]

FTE.FTE_DELIVERY_PROOF does not reference any database object

FTE.FTE_DELIVERY_PROOF is referenced by following:

FTE
VIEW - FTE_DELIVERY_PROOF#

[top of page]

Table: FTE_ESTIMATE_RATES_DEL_TEMP

Description:
Comments
Primary Key: FTE_ESTIMATE_RATES_DEL_TEMP_U1
  1. DELIVERY_ID
Indexes
Index Type Tablespace Column
FTE_ESTIMATE_RATES_DEL_TEMP_U1 UNIQUE DELIVERY_ID
Columns
Name Datatype Length Mandatory Comments
DELIVERY_ID NUMBER
Y
RATE_AVAILABLE_FLAG VARCHAR2 (1)
MATCHING_FLAG VARCHAR2 (1)

[top of page]

FTE.FTE_ESTIMATE_RATES_DEL_TEMP does not reference any database object

FTE.FTE_ESTIMATE_RATES_DEL_TEMP is referenced by following:

APPS
SYNONYM - FTE_ESTIMATE_RATES_DEL_TEMP

[top of page]

Table: FTE_FACILITY_CARRIERS

Description: Stores the data for the association between a Facility location and a Carrier.
Comments

Stores the data for the association between a Facility location and a Carrier.

Indexes
Index Type Tablespace Column
FTE_FACILITY_CARRIERS_U1 UNIQUE APPS_TS_TX_IDX LOCATION_ID
CARRIER_ID
Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER
Y Location Identifier
CARRIER_ID NUMBER
Y Carrier Identifier
USAGE_TYPE VARCHAR2 (30) Y Usage Type of the Facility for the specified carrier. Current default value is "Drop Trailer"
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
PROGRAM_APPLICATION_ID NUMBER

Standard WHO Column
PROGRAM_ID NUMBER

Standard WHO Column
PROGRAM_UPDATE_DATE DATE

Standard WHO Column
REQUEST_ID NUMBER

Standard WHO Column

[top of page]

FTE.FTE_FACILITY_CARRIERS does not reference any database object

FTE.FTE_FACILITY_CARRIERS is referenced by following:

FTE
VIEW - FTE_FACILITY_CARRIERS#

[top of page]

Table: FTE_FAILURE_REASONS

Description: This table is used to store failure reasons for FPA
Primary Key: FTE_FAILUER_REASONS_PK
  1. INVOICE_REJECT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_FAILURE_REASONS.PARENT_ID %
FTE_FAILURE_REASONS.PARENT_ID FTE_INVOICE_LINES
Comments

This table is used to store failure reasons for FPA

Indexes
Index Type Tablespace Column
FTE_FAILURE_REASONS_U1 UNIQUE APPS_TS_TX_IDX INVOICE_REJECT_ID
FTE_FAILURE_REASONS_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_ID
FTE_FAILURE_REASONS_N2 NONUNIQUE APPS_TS_TX_IDX BOL
Columns
Name Datatype Length Mandatory Comments
INVOICE_REJECT_ID NUMBER
Y Invoice Reject Id
PARENT_NAME VARCHAR2 (30) Y Store the table name
PARENT_ID NUMBER
Y Store the id for the parent name
BOL VARCHAR2 (30)
Bill of lading number
FAILURE_TYPE VARCHAR2 (30)
Failure type
FAILURE_REASON VARCHAR2 (30)
Failure reason
CREATED_BY NUMBER
Y Standard who columns
CREATION_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns

[top of page]

FTE.FTE_FAILURE_REASONS does not reference any database object

FTE.FTE_FAILURE_REASONS is referenced by following:

FTE
VIEW - FTE_FAILURE_REASONS#

[top of page]

Table: FTE_FREIGHT_COSTS_TEMP

Description: Stores temporary data for rating estimates
Primary Key: FTE_FREIGHT_COSTS_TEMP_PK1
  1. FREIGHT_COST_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_FREIGHT_COSTS_TEMP_U1 UNIQUE APPS_TS_TX_IDX COMPARISON_REQUEST_ID
FREIGHT_COST_ID
FTE_FREIGHT_COSTS_TEMP_N1 NONUNIQUE APPS_TS_TX_IDX DELIVERY_ID
FTE_FREIGHT_COSTS_TEMP_N2 NONUNIQUE APPS_TS_TX_IDX DELIVERY_DETAIL_ID
FTE_FREIGHT_COSTS_TEMP_N3 NONUNIQUE APPS_TS_TX_IDX LANE_ID
FTE_FREIGHT_COSTS_TEMP_N4 NONUNIQUE APPS_TS_TX_IDX SCHEDULE_ID
FTE_FREIGHT_COSTS_TEMP_N5 NONUNIQUE APPS_TS_TX_IDX VEHICLE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
FREIGHT_COST_ID NUMBER
Y primary key
FREIGHT_COST_TYPE_ID NUMBER
Y FK to WSH_FREIGHT_COST_TYPES
UNIT_AMOUNT NUMBER

unit_amount
CALCULATION_METHOD VARCHAR2 (15)
calculation method
UOM VARCHAR2 (15)
unit of measure
QUANTITY NUMBER

quantity
TOTAL_AMOUNT NUMBER

total amount
CURRENCY_CODE VARCHAR2 (15)
currency code
CONVERSION_DATE DATE

conversion date
CONVERSION_RATE NUMBER

conversion rate
CONVERSION_TYPE_CODE VARCHAR2 (30)
conversion type code
TRIP_ID NUMBER

trip id
STOP_ID NUMBER

stop id
DELIVERY_ID NUMBER

delivery id
DELIVERY_LEG_ID NUMBER

delivery leg id
DELIVERY_DETAIL_ID NUMBER

delivery detail id
ATTRIBUTE_CATEGORY VARCHAR2 (30)
flexfield attribute category
ATTRIBUTE1 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE2 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE3 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE4 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE5 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE6 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE7 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE8 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE9 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE10 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE11 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE12 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE13 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE14 VARCHAR2 (150)
flexfield attribute
ATTRIBUTE15 VARCHAR2 (150)
flexfield attribute
CREATION_DATE DATE
Y creation_date
CREATED_BY NUMBER
Y created by
LAST_UPDATE_DATE DATE
Y last update date
LAST_UPDATED_BY NUMBER
Y last updated by
LAST_UPDATE_LOGIN NUMBER

last update login
PROGRAM_APPLICATION_ID NUMBER

program application id
PROGRAM_ID NUMBER

program id
PROGRAM_UPDATE_DATE DATE

program update date
REQUEST_ID NUMBER

request id
FREIGHT_CODE VARCHAR2 (30)
freight code
LINE_TYPE_CODE VARCHAR2 (30)
identifies type of cost
PRICING_LIST_HEADER_ID NUMBER

FK to QP_LIST_HEADERS_B
PRICING_LIST_LINE_ID NUMBER

FK to QP_LIST_LINES
APPLIED_TO_CHARGE_ID NUMBER

FK to FTE_FREIGHT_COSTS_TEMP
CHARGE_UNIT_VALUE NUMBER

charge unit value
CHARGE_SOURCE_CODE VARCHAR2 (30)
charge source code
ESTIMATED_FLAG VARCHAR2 (1)
identifies an estimate row
COMPARISON_REQUEST_ID NUMBER
Y handle to a comparison request
LANE_ID NUMBER

FK to FTE_LANES
SCHEDULE_ID NUMBER

FK to FTE_SCHEDULES
MOVED_TO_MAIN_FLAG VARCHAR2 (1)
indicates if row has been copied to main table
SERVICE_TYPE_CODE VARCHAR2 (30)
service type
COMMODITY_CATEGORY_ID NUMBER

Identifier in MTL_CATEGORIES to store the commodity classification
VEHICLE_TYPE_ID NUMBER

BILLABLE_QUANTITY NUMBER

BILLABLE_UOM VARCHAR2 (15)
BILLABLE_BASIS VARCHAR2 (30)

[top of page]

FTE.FTE_FREIGHT_COSTS_TEMP does not reference any database object

FTE.FTE_FREIGHT_COSTS_TEMP is referenced by following:

FTE
VIEW - FTE_FREIGHT_COSTS_TEMP#

[top of page]

Table: FTE_FREIGHT_ESTIMATE_TEMP

Description:
Comments
Primary Key: FTE_FREIGHT_ESTIMATE_TEMP_U1
  1. RATE_TEMP_ID
Indexes
Index Type Tablespace Column
FTE_FREIGHT_ESTIMATE_TEMP_U1 UNIQUE RATE_TEMP_ID
Columns
Name Datatype Length Mandatory Comments
RATE_TEMP_ID NUMBER
Y
CARRIER VARCHAR2 (360)
MODE_OF_TRANSPORT VARCHAR2 (80)
SERVICE_LEVEL VARCHAR2 (80)
VEHICLE_TYPE VARCHAR2 (80)
ESTIMATED_RATE NUMBER

BASE_PRICE NUMBER

ACCESSORIAL_CHARGES NUMBER

MARKUP_DISCOUNT_TYPE VARCHAR2 (1)
MARKUP_DISCOUNT_VALUE NUMBER

CURRENCY_CODE VARCHAR2 (15)
EST_TRANSIT_TIME NUMBER

TIME_FEASIBLE_FLAG VARCHAR2 (1)
CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

FTE.FTE_FREIGHT_ESTIMATE_TEMP does not reference any database object

FTE.FTE_FREIGHT_ESTIMATE_TEMP is referenced by following:

APPS
SYNONYM - FTE_FREIGHT_ESTIMATE_TEMP

[top of page]

Table: FTE_INTERFACE_LANES

Description: Interface table for Lanes.
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_INTERFACE_LANES_N1 NONUNIQUE APPS_TS_INTERFACE HASH_VALUE
Columns
Name Datatype Length Mandatory Comments
ORIGIN_NAME VARCHAR2 (25)
Origin Name
DEST_NAME VARCHAR2 (25)
Destination Name
RATE_CHART_STRING VARCHAR2 (4000)
Concatenation of price breaks value
RATE_CHART_NAME VARCHAR2 (40)
Rate Chart Name
HASH_VALUE NUMBER

Hash Value for RATE_CHART_STRING
CLASS_STRING VARCHAR2 (200)
Concatenatin (comma delimited) of Freight Class values
MIN_CHARGE1 VARCHAR2 (10)
Minimun Charge Value
LOAD_ID NUMBER

Load ID of the uploading process
ORIGIN_ID NUMBER

Origin ID associated with Origin Name
DEST_ID NUMBER

Dest ID associated with Destination Name
OWNER_ID NUMBER

Owner ID of the Lane
PROCESS_ID NUMBER

Foreign key from QP_INTERFACE_LIST_HEADERS
GROUP_PROCESS_ID NUMBER

Group process id into multiple parallel process

[top of page]

FTE.FTE_INTERFACE_LANES does not reference any database object

FTE.FTE_INTERFACE_LANES is referenced by following:

FTE
VIEW - FTE_INTERFACE_LANES#

[top of page]

Table: FTE_INTERFACE_ZONES

Description: Interface table for Zones.
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_INTERFACE_ZONES_N1 NONUNIQUE APPS_TS_INTERFACE HASH_VALUE
Columns
Name Datatype Length Mandatory Comments
ZONE_NAME VARCHAR2 (25)
Zone Name
POSTAL_CODE_FROM VARCHAR2 (15)
Postal Code from
POSTAL_CODE_TO VARCHAR2 (15)
Postal Code To
POSTAL_CODE_STRING VARCHAR2 (4000)
Concatenation of Postal Code ranges
LOAD_ID NUMBER

Origin ID associated with Origin Name
HASH_VALUE NUMBER

Hash Value for POSTAL_CODE_STRING
ZONE_ID NUMBER

Zone ID of Zone Name
OWNER_ID NUMBER

Owner ID of the Zone
ROW_NUMBER NUMBER

ROw Number

[top of page]

FTE.FTE_INTERFACE_ZONES does not reference any database object

FTE.FTE_INTERFACE_ZONES is referenced by following:

FTE
VIEW - FTE_INTERFACE_ZONES#

[top of page]

Table: FTE_INVOICE_HEADERS

Description: Table to store invoice header information
Primary Key: FTE_INVOICE_HEADERS_PK
  1. INVOICE_HEADER_ID
Comments

Table to store invoice header information

Indexes
Index Type Tablespace Column
FTE_INVOICE_HEADERS_N1 NONUNIQUE APPS_TS_TX_IDX BILL_NUMBER
FTE_INVOICE_HEADERS_N2 NONUNIQUE APPS_TS_TX_IDX BILL_REF
FTE_INVOICE_HEADERS_N3 NONUNIQUE APPS_TS_TX_IDX BOL
FTE_INVOICE_HEADERS_N4 NONUNIQUE APPS_TS_TX_IDX CARRIER_ID
Columns
Name Datatype Length Mandatory Comments
BILL_OF_LADING_ESTIMATE NUMBER

Bill of lading estimate
INVOICE_HEADER_ID NUMBER
Y Invoice header id
BILL_NUMBER VARCHAR2 (30) Y Bill number
BILL_STATUS VARCHAR2 (30) Y Bill status
BILL_DATE DATE
Y 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
Y Standard who columns
CREATION_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y 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

[top of page]

FTE.FTE_INVOICE_HEADERS does not reference any database object

FTE.FTE_INVOICE_HEADERS is referenced by following:

FTE
VIEW - FTE_INVOICE_HEADERS#

[top of page]

Table: FTE_INVOICE_HISTORY

Description: Table to store invoice history information
Primary Key: FTE_INVOICE_HISTORY_PK
  1. INVOICE_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_INVOICE_HISTORY.PARENT_ID %
FTE_INVOICE_HISTORY.PARENT_ID %
Comments

Table to store invoice history information

Indexes
Index Type Tablespace Column
FTE_INVOICE_HISTORY_U1 UNIQUE APPS_TS_TX_IDX INVOICE_HISTORY_ID
FTE_INVOICE_HISTORY_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_ID
FTE_INVOICE_HISTORY_N2 NONUNIQUE APPS_TS_TX_IDX PARENT_NAME
FTE_INVOICE_HISTORY_N3 NONUNIQUE APPS_TS_TX_IDX BOL
Columns
Name Datatype Length Mandatory Comments
INVOICE_HISTORY_ID NUMBER
Y Invoice History id
PARENT_ID NUMBER
Y Id refer back to the table defined in parent name column
PARENT_NAME VARCHAR2 (30) Y Table name for history
BOL VARCHAR2 (30)
Bill of lading number
ACTION VARCHAR2 (30)
Action taken
RESULT VARCHAR2 (30)
Action result
DISCREPANCY_CODE VARCHAR2 (30)
Discrepancy Code
CREATED_BY NUMBER
Y Standard who columns
CREATION_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE

Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns

[top of page]

FTE.FTE_INVOICE_HISTORY does not reference any database object

FTE.FTE_INVOICE_HISTORY is referenced by following:

FTE
VIEW - FTE_INVOICE_HISTORY#

[top of page]

Table: FTE_INVOICE_LINES

Description: Table to store invoice line information
Primary Key: FTE_INVOICE_LINES_PK
  1. INVOICE_LINE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_FAILURE_REASONS.PARENT_ID FTE_INVOICE_LINES
Comments

Table to store invoice line information

Indexes
Index Type Tablespace Column
FTE_INVOICE_LINES_U1 UNIQUE APPS_TS_TX_IDX INVOICE_LINE_ID
FTE_INVOICE_LINES_N1 NONUNIQUE APPS_TS_TX_IDX INVOICE_HEADER_ID
FTE_INVOICE_LINES_N2 NONUNIQUE APPS_TS_TX_IDX INVOICE_LINE_NUM
FTE_INVOICE_LINES_N3 NONUNIQUE APPS_TS_TX_IDX INVOICE_LINE_TYPE
Columns
Name Datatype Length Mandatory Comments
INVOICE_LINE_ID NUMBER
Y Invoice line id
INVOICE_HEADER_ID NUMBER
Y Invoice header id
INVOICE_LINE_NUM VARCHAR2 (30)
Invoice line number
INVOICE_LINE_TYPE VARCHAR2 (30)
Invoice line type
LADING_QUANTITY NUMBER

Lading quantity
LADING_UNIT VARCHAR2 (30)
Lading unit
DESCRIPTION VARCHAR2 (1000)
Description
FREIGHT_CLASS VARCHAR2 (30)
Freight class
TOTAL_WEIGHT NUMBER

Total weight
WEIGHT_UOM VARCHAR2 (30)
Weight uom
TOTAL_VOLUME NUMBER

Total volume
VOLUME_UOM VARCHAR2 (30)
Volume uom
RATE_AMOUNT NUMBER

Rate amount
RATE_TYPE VARCHAR2 (30)
Rate type
DISCOUNT_UOM VARCHAR2 (30)
Discount uom
DISCOUNT_AMOUNT NUMBER

Discount amount
DISCOUNT_TYPE VARCHAR2 (30)
Discount type
DISCOUNT_DISC VARCHAR2 (1000)
Discount description
SURCHARGE_UOM VARCHAR2 (30)
Surcharge uom
SURCHARGE_AMOUNT NUMBER

Surcharge amount
SURCHARGE_TYPE VARCHAR2 (30)
Surcharge type
SURCHARGE_DISC VARCHAR2 (1000)
Surcharge description
APPROVED_AMOUNT NUMBER

Approved amount on line level
CREATED_BY NUMBER
Y Standard who columns
CREATION_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
RATE_BASIS VARCHAR2 (50)
Rate basis
RATE_BASIS_UOM VARCHAR2 (50)
Rate basis uom

[top of page]

FTE.FTE_INVOICE_LINES does not reference any database object

FTE.FTE_INVOICE_LINES is referenced by following:

FTE
VIEW - FTE_INVOICE_LINES#

[top of page]

Table: FTE_LANES

Description: Stores services catalog lane descriptions.
Primary Key: FTE_LANES_PK
  1. LANE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANES.DESTINATION_ID WSH_REGIONS
FTE_LANES.ORIGIN_ID WSH_REGIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SCHEDULES.LANE_ID FTE_LANES
FTE_LANE_COMMODITIES.LANE_ID FTE_LANES
FTE_LANE_EQUIPMENTS.LANE_ID FTE_LANES
FTE_LANE_GROUP_COMPONENTS.LANE_ID FTE_LANES
FTE_LANE_RATE_CHARTS.LANE_ID FTE_LANES
FTE_LANE_SERVICES.LANE_ID FTE_LANES
FTE_LOAD_CHARGES.LANE_ID FTE_LANES
FTE_LOAD_SCHEDULES.LANE_ID FTE_LANES
FTE_PRC_PARAMETERS.LANE_ID FTE_LANES
Comments

FTE_LANES stores services catalog lane descriptions.. Lanes have primary columns of Origin, Destination, Mode of transport, and Carrier and store descriptors for commodities, equipments and services. Each lane is assigned a Lane Number unique for a given Carrier.

Indexes
Index Type Tablespace Column
FTE_LANES_U1 UNIQUE APPS_TS_TX_IDX LANE_ID
FTE_LANES_N1 NONUNIQUE APPS_TS_TX_IDX ORIGIN_ID
DESTINATION_ID
FTE_LANES_U2 NONUNIQUE APPS_TS_TX_IDX CARRIER_ID
LANE_NUMBER
Columns
Name Datatype Length Mandatory Comments
LANE_ID NUMBER
Y Primary Key
LANE_NUMBER VARCHAR2 (30)
Reference to the lane
OWNER_ID NUMBER
Y Ownership Identifier of the Lane
CARRIER_ID NUMBER
Y Foreign key for carrier
ORIGIN_ID NUMBER
Y Foreign key for WSH_REGIONS for origin
DESTINATION_ID NUMBER
Y Foreign key for WSH_REGIONS for destination
MODE_OF_TRANSPORTATION_CODE VARCHAR2 (30)
Codes for mode of transportatin column
PORT_OF_DISCHARGE VARCHAR2 (240)
Port of discharge
PORT_OF_LOADING VARCHAR2 (240)
Port of loading
TRANSIT_TIME NUMBER

Number of hour or days between departure and arrival
TRANSIT_TIME_UOM VARCHAR2 (3)
Unit of measure of Transit Time
SPECIAL_HANDLING VARCHAR2 (2000)
Special handling
ADDITIONAL_INSTRUCTIONS VARCHAR2 (2000)
Additional Instructions
COMMODITY_DETAIL_FLAG VARCHAR2 (1)
Commodity Detail Flag for internal use
EQUIPMENT_DETAIL_FLAG VARCHAR2 (1)
Equipment Detail Flag for internal use
SERVICE_DETAIL_FLAG VARCHAR2 (1)
Service Detail Flag for internal use
COMM_FC_CLASS_CODE VARCHAR2 (30)
Commodity or Freight Classification Code
COMMODITY_CATG_ID NUMBER

Commodity Category Identifier
EQUIPMENT_TYPE_CODE VARCHAR2 (30)
Equipment Type Code
SERVICE_TYPE_CODE VARCHAR2 (30)
Service Type Code
DISTANCE NUMBER

Distance between origin and destination
DISTANCE_UOM VARCHAR2 (3)
Unit of measure for distance column
SCHEDULES_FLAG VARCHAR2 (1)
Flag. Value Y :If the lane has schedules
PRICELIST_ID NUMBER

Foreign key for price tables
PRICELIST_VIEW_FLAG VARCHAR2 (1)
Price List View flag for internal use only
BASIS VARCHAR2 (30)
Basis for commodity. Define a price basis on lane level.
EFFECTIVE_DATE DATE

Start Date of the Lane
EXPIRY_DATE DATE

End Date of the Lane
EDITABLE_FLAG VARCHAR2 (1)
Editable Flag for the internal use only
REQUEST_ID NUMBER

Who column
PROGRAM_APPLICATION_ID NUMBER

Who column
PROGRAM_ID NUMBER

Who column
PROGRAM_UPDATE_DATE DATE

Who column
CREATED_BY NUMBER
Y Who column
CREATION_DATE DATE
Y Who column
LAST_UPDATED_BY NUMBER
Y Who column
LAST_UPDATE_DATE DATE
Y Who column
LAST_UPDATE_LOGIN NUMBER

Who column
LANE_TYPE VARCHAR2 (60)
lane type for internal use only
TARIFF_NAME VARCHAR2 (60)
Tariff Name for LTL Services only

[top of page]

FTE.FTE_LANES does not reference any database object

FTE.FTE_LANES is referenced by following:

FTE
VIEW - FTE_LANES#

[top of page]

Table: FTE_LANE_COMMODITIES

Description: Stores commodity information for each lane
Primary Key: FTE_LANE_COMMODITIES_PK
  1. LANE_COMMODITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_COMMODITIES.LANE_ID FTE_LANES
FTE_LANE_COMMODITIES.COMMODITY_CATG_ID MTL_CATEGORIES_B
Comments

FTE_LANE_COMMODITIES stores commodities that are supported for transportation on a given lane. Commodity Type and Commodity Code are obtained from Meaning and Lookup Code for commodities lookup type FTE_COMMODITIES stored in FND_LOOKUPS. Price basis(Weight, Volume, or Container) is also stored for each commodity in this table.

Indexes
Index Type Tablespace Column
FTE_LANE_COMMODITIES_N1 NONUNIQUE APPS_TS_TX_IDX LANE_ID
Columns
Name Datatype Length Mandatory Comments
LANE_COMMODITY_ID NUMBER
Y Lane Commodity Identifier
LANE_ID NUMBER
Y Foreign key for FTE_LANES
BASIS VARCHAR2 (30)
Basis for commodity. Define a price basis on commodity level.
COMMODITY_CATG_ID NUMBER
Y Commodity Category Identifier
CREATED_BY NUMBER
Y Who column
CREATION_DATE DATE
Y Who column
LAST_UPDATED_BY NUMBER
Y Who column
LAST_UPDATE_DATE DATE
Y Who column
LAST_UPDATE_LOGIN NUMBER

Who column

[top of page]

FTE.FTE_LANE_COMMODITIES does not reference any database object

FTE.FTE_LANE_COMMODITIES is referenced by following:

FTE
VIEW - FTE_LANE_COMMODITIES#

[top of page]

Table: FTE_LANE_EQUIPMENTS

Description: Stores equipment information for each lane
Primary Key: FTE_LANE_EQUIPMENTS_PK
  1. LANE_EQUIPMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_EQUIPMENTS.LANE_ID FTE_LANES
Comments

FTE_LANE_EQUIPMENTS stores the equipment types supported on a given lane. Equipment Type and Equipment Code are obtained from Meaning and Lookup Code for equipments lookup type FTE_EQUIPMENTS stored in FND_LOOKUPS.

Indexes
Index Type Tablespace Column
FTE_LANE_EQUIPMENTS_U1 UNIQUE APPS_TS_TX_IDX EQUIPMENT_CODE
LANE_ID
FTE_LANE_EQUIPMENTS_N1 NONUNIQUE APPS_TS_TX_IDX LANE_ID
Columns
Name Datatype Length Mandatory Comments
LANE_EQUIPMENT_ID NUMBER
Y Lane Equipment Identifier
LANE_ID NUMBER
Y Foreign key for FTE_LANES
EQUIPMENT_CODE VARCHAR2 (30) Y Code of equipment
CREATED_BY NUMBER
Y Who column
CREATION_DATE DATE
Y Who column
LAST_UPDATED_BY NUMBER
Y Who column
LAST_UPDATE_DATE DATE
Y Who column
LAST_UPDATE_LOGIN NUMBER

Who column

[top of page]

FTE.FTE_LANE_EQUIPMENTS does not reference any database object

FTE.FTE_LANE_EQUIPMENTS is referenced by following:

FTE
VIEW - FTE_LANE_EQUIPMENTS#

[top of page]

Table: FTE_LANE_GROUPS

Description: Stores header information regarding a group of lanes
Primary Key: FTE_LANE_GROUPS_PK
  1. LANE_GROUP_ID
Comments

Stores header information regarding a group of lanes

Indexes
Index Type Tablespace Column
FTE_LANE_GROUPS_U1 UNIQUE APPS_TS_TX_IDX LANE_GROUP_ID
FTE_LANE_GROUPS_U2 UNIQUE APPS_TS_TX_IDX NAME
FTE_LANE_GROUPS_N1 NONUNIQUE APPS_TS_TX_IDX CARRIER_ID
FTE_LANE_GROUPS_N2 NONUNIQUE APPS_TS_TX_IDX MODE_OF_TRANSPORT_CODE
Columns
Name Datatype Length Mandatory Comments
LANE_GROUP_ID NUMBER
Y Primary key for FTE_LANE_GROUPS
NAME VARCHAR2 (80) Y Name of the lane group
CARRIER_ID NUMBER
Y Id of carrier for the lane group, carrier_id references wsh_carriers
MODE_OF_TRANSPORT_CODE VARCHAR2 (30) Y Mode of transport code for lane group from fnd_lookup_values with lookup_type = 'WSH_MODE_OF_TRANSPORT'
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Context column for FTE_LANE_GROUPS descriptiave flexfields
ATTRIBUTE1 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE2 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE3 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE4 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE5 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE6 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE7 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE8 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE9 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE10 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE11 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE12 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE13 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE14 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
ATTRIBUTE15 VARCHAR2 (150)
Attribute column for FTE_LANE_GROUPS descriptive flexfields
CREATED_BY NUMBER
Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
DESCRIPTION VARCHAR2 (240)
Description of lane group

[top of page]

FTE.FTE_LANE_GROUPS does not reference any database object

FTE.FTE_LANE_GROUPS is referenced by following:

FTE
VIEW - FTE_LANE_GROUPS#

[top of page]

Table: FTE_LANE_GROUP_COMPONENTS

Description: Details table that holds the lane components of a lane group
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_GROUP_COMPONENTS.LANE_ID FTE_LANES
FTE_LANE_GROUP_COMPONENTS.LANE_GROUP_ID %
Comments

Details table that holds the lane components of a lane group

Indexes
Index Type Tablespace Column
FTE_LANE_GROUP_COMPONENTS_N1 NONUNIQUE APPS_TS_TX_IDX LANE_GROUP_ID
FTE_LANE_GROUP_COMPONENTS_N2 NONUNIQUE APPS_TS_TX_IDX LANE_ID
FTE_LANE_GROUP_COMPONENTS_N3 NONUNIQUE APPS_TS_TX_IDX DESTINATION_ID
ORIGIN_ID
Columns
Name Datatype Length Mandatory Comments
LANE_GROUP_ID NUMBER
Y LANE_GROUP_ID references FTE_LANE_GROUPS which indicates which lane group this lane belongs to
LANE_ID NUMBER
Y LANE_ID references FTE_LANES, indicates the lane that belongs to the lane group
ORIGIN_ID NUMBER

Origin ID of the lane
DESTINATION_ID NUMBER

Destination ID of the lane
CREATED_BY NUMBER
Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column

[top of page]

FTE.FTE_LANE_GROUP_COMPONENTS does not reference any database object

FTE.FTE_LANE_GROUP_COMPONENTS is referenced by following:

FTE
VIEW - FTE_LANE_GROUP_COMPONENTS#

[top of page]

Table: FTE_LANE_RATE_CHARTS

Description: Association between lane and rate charts
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_RATE_CHARTS.LANE_ID FTE_LANES
FTE_LANE_RATE_CHARTS.LIST_HEADER_ID QP_LIST_HEADERS_B
Comments

Association between lane and rate charts

Indexes
Index Type Tablespace Column
FTE_LANE_RATE_CHARTS_N1 NONUNIQUE APPS_TS_TX_IDX LANE_ID
FTE_LANE_RATE_CHARTS_N2 NONUNIQUE APPS_TS_TX_IDX LIST_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
LANE_ID NUMBER
Y Foreign key to FTE_LANES
LIST_HEADER_ID NUMBER
Y Foreign key to QP_LIST_HEADERS_B
END_DATE_ACTIVE DATE

Effective end date for rate chart
START_DATE_ACTIVE DATE

Effective start date for rate chart
CREATED_BY NUMBER
Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column

[top of page]

FTE.FTE_LANE_RATE_CHARTS does not reference any database object

FTE.FTE_LANE_RATE_CHARTS is referenced by following:

FTE
VIEW - FTE_LANE_RATE_CHARTS#

[top of page]

Table: FTE_LANE_SERVICES

Description: Stores service information for each lane
Primary Key: FTE_LANE_SERVICES_PK
  1. LANE_SERVICE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LANE_SERVICES.LANE_ID FTE_LANES
Comments

FTE_LANE_SERVICES stores service types supported on a given lane.. Service Type and Service Code are obtained from Meaning and Lookup Code for services lookup type FTE_SERVICES stored in FND_LOOKUPS.

Indexes
Index Type Tablespace Column
FTE_LANE_SERVICES_U1 UNIQUE APPS_TS_TX_IDX LANE_ID
SERVICE_CODE
Columns
Name Datatype Length Mandatory Comments
LANE_SERVICE_ID NUMBER
Y Lane Service Identifier
LANE_ID NUMBER
Y Foreign key for FTE_LANES
SERVICE_CODE VARCHAR2 (30) Y Code of service type
CREATED_BY NUMBER
Y Who column
CREATION_DATE DATE
Y Who column
LAST_UPDATED_BY NUMBER
Y Who column
LAST_UPDATE_DATE DATE
Y Who column
LAST_UPDATE_LOGIN NUMBER

Who column

[top of page]

FTE.FTE_LANE_SERVICES does not reference any database object

FTE.FTE_LANE_SERVICES is referenced by following:

FTE
VIEW - FTE_LANE_SERVICES#

[top of page]

Table: FTE_LANE_VEHICLES

Description: Stores the Vehicle associated to Lanes and Lane Groups
Comments

Stores the Vehicle associated to Lanes and Lane Groups

Indexes
Index Type Tablespace Column
FTE_LANE_VEHICLES_U1 UNIQUE APPS_TS_TX_IDX LANE_VEHICLE_ID
FTE_LANE_VEHICLES_N1 NONUNIQUE APPS_TS_TX_IDX LANE_ID
FTE_LANE_VEHICLES_N2 NONUNIQUE APPS_TS_TX_IDX LANE_GROUP_ID
FTE_LANE_VEHICLES_N3 NONUNIQUE APPS_TS_TX_IDX ORIGIN_ID
DESTINATION_ID
Columns
Name Datatype Length Mandatory Comments
LANE_VEHICLE_ID NUMBER
Y Primary Key of the Lane Vehicles
LANE_ID NUMBER

Stores Associated Lane
LANE_GROUP_ID NUMBER

Stores Associated Lane Group
VEHICLE_TYPE_ID NUMBER
Y Stores the Vehicle
QUANTITY NUMBER
Y Stores Quantity
FREQUENCY_UOM VARCHAR2 (10)
Frequency UOM
EFFECTIVE_START_DATE DATE
Y Stores effective start date
EFFECTIVE_END_DATE DATE

Stores Effective end Date
ORIGIN_ID NUMBER

ORIGIN_ID of LANE : added for query performance
DESTINATION_ID NUMBER

DESTINATION_ID of LANE : added for query performance
CARRIER_ID NUMBER

CARRIER_ID of LANE : added for query performance
MODE_OF_TRANSPORT_CODE VARCHAR2 (30)
MODE_OF_TRANSPORT_CODE of LANE : added for query performance
CREATION_DATE DATE

Standard WHO Column
CREATED_BY NUMBER

Standard WHO Column
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column

[top of page]

FTE.FTE_LANE_VEHICLES does not reference any database object

FTE.FTE_LANE_VEHICLES is referenced by following:

FTE
VIEW - FTE_LANE_VEHICLES#

[top of page]

Table: FTE_LOCATION_MILEAGES

Description: This table is used to store the distance and transit times between two locations (origin and destination), where the locations are identified as regions. The primary key for the table is origin_id - destination_id.
Primary Key: FTE_LOCATION_MILEAGES_PK1
  1. ORIGIN_ID
  2. DESTINATION_ID
Comments

This table is used to store the distance and transit times between two locations (origin and destination), where the locations are identified as regions. The primary key for the table is origin_id - destination_id.

Columns
Name Datatype Length Mandatory Comments
ORIGIN_ID NUMBER
Y identifier for the origin region
DESTINATION_ID NUMBER
Y Identifier for the destination region
IDENTIFIER_TYPE VARCHAR2 (30) Y Determines the region level that the distance between the origin and destination is at. Derived from a site level profile option. Values are 'ZIP' and 'CITYSTATE'
DISTANCE NUMBER

Distance between the origin and destination
DISTANCE_UOM VARCHAR2 (3)
Unit of measure for the distance, e.g. Miles or kilometers
TRANSIT_TIME NUMBER

Time to travel between the origin and destination
TRANSIT_TIME_UOM VARCHAR2 (3)
Unit of measure for the transit time, e.g. Minutes, Hours
CREATION_DATE DATE
Y Standard who columns
CREATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
PROGRAM_APPLICATION_ID NUMBER

Standard who columns
PROGRAM_ID NUMBER

Standard who columns
PROGRAM_UPDATE_DATE DATE

Standard who columns
REQUEST_ID NUMBER

Standard who columns

[top of page]

FTE.FTE_LOCATION_MILEAGES does not reference any database object

FTE.FTE_LOCATION_MILEAGES is referenced by following:

FTE
VIEW - FTE_LOCATION_MILEAGES#

[top of page]

Table: FTE_LOCATION_PARAMETERS

Description: Stores Facility definition and it's parameters.
Primary Key: FTE_LOCATION_PARAMETERS_PK
  1. FACILITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_LOCATION_PARAMETERS.FACILITY_CONTACT_ID HZ_PARTIES
Comments

Stores Facility definition and it's parameters.

Indexes
Index Type Tablespace Column
FTE_LOCATION_PARAMETERS_U1 UNIQUE APPS_TS_TX_IDX FACILITY_ID
FTE_LOCATION_PARAMETERS_U2 UNIQUE APPS_TS_TX_IDX LOCATION_ID
FTE_LOCATION_PARAMETERS_U3 UNIQUE APPS_TS_TX_IDX FACILITY_CODE
Columns
Name Datatype Length Mandatory Comments
FACILITY_ID NUMBER
Y Primary Key of the Table
FACILITY_CODE VARCHAR2 (60) Y Unique Facility Identifier
LOCATION_ID NUMBER
Y Foreign Key to WSH_LOCATIONS.wsh_location_id
DESCRIPTION VARCHAR2 (250)
Optional User Description
CONSOLIDATION_ALLOWED VARCHAR2 (1)
Consolidation Activity Allowed : Yes / No
DECONSOLIDATION_ALLOWED VARCHAR2 (1)
Deconsolidation Activity Allowed : Yes / No
CROSSDOCKING_ALLOWED VARCHAR2 (1)
Cross-docking Activity Allowed : Yes / No
PARCEL_LTL_CONSOLIDATION VARCHAR2 (1)
Parcel to LTL Consolidation Allowed : Yes / No
PARCEL_TL_CONSOLIDATION VARCHAR2 (1)
Parcel to TL Consolidation Allowed : Yes / No
LTL_TL_CONSOLIDATION VARCHAR2 (1)
LTL to TL Consolidation Allowed : Yes / No
LTL_LTL_CONSOLIDATION VARCHAR2 (1)
LTL to LTL Consolidation Allowed : Yes / No
LTL_PARCEL_DECONSOLIDATION VARCHAR2 (1)
LTL to Parcel Deconsolidation Allowed : Yes / No
TL_PARCEL_DECONSOLIDATION VARCHAR2 (1)
TL to Parcel Deconsolidation Allowed : Yes / No
TL_LTL_DECONSOLIDATION VARCHAR2 (1)
TL to LTL Deconsolidation Allowed : Yes / No
LTL_LTL_DECONSOLIDATION VARCHAR2 (1)
LTL to LTL Deconsolidation Allowed : Yes / No
PARCEL_INBOUND_CROSSDOCKING VARCHAR2 (1)
Inbound Cross-docking allowed for Parcel : Yes / No
LTL_INBOUND_CROSSDOCKING VARCHAR2 (1)
Inbound Cross-docking allowed for LTL : Yes / No
TL_INBOUND_CROSSDOCKING VARCHAR2 (1)
Inbound Cross-docking allowed for TL : Yes / No
PARCEL_OUTBOUND_CROSSDOCKING VARCHAR2 (1)
Outbound Cross-docking allowed for Parcel : Yes / No
LTL_OUTBOUND_CROSSDOCKING VARCHAR2 (1)
Outbound Cross-docking allowed for LTL : Yes / No
TL_OUTBOUND_CROSSDOCKING VARCHAR2 (1)
Outbound Cross-docking allowed for TL : Yes / No
STORAGE_FACILITY VARCHAR2 (1)
Flag to Indicate whether this is only a Trans shipment Facility : Applicable to Carrier Facility only
CARRIER_DROP_TRAILER_ALLOWED VARCHAR2 (1)
CARRIER_OWNED_HAUL VARCHAR2 (30)
Whether the Carrier performs Line haul or Local haul in case of consolidation/deconsolidation - Applicable to Carrier facility only
NUM_DOCKS NUMBER

Total number of docks at the facility
NUM_SHIPPING_DOCKS NUMBER

Total number of shipping docks at the facility
NUM_RECEIVING_DOCKS NUMBER

Total number of Receiving docks at the facility
NUM_PARKING_SPOTS NUMBER

Total number of Parking spots at the facility
HANDLING_CAPACITY NUMBER

Facility handling capacity as throughput
DOCK_HANDLING_RATE NUMBER

HANDLING_UNIT VARCHAR2 (30)
Handling Unit of Measure
WEIGHT_UOM VARCHAR2 (30)
VOLUME_UOM VARCHAR2 (30)
TIME_UOM VARCHAR2 (3)
FLOW_THROUGH_TIME NUMBER

Flowthrough time between loading zone and unloading zone at the facility
LOADING_TIME NUMBER

UNLOADING_TIME NUMBER

NON_ADJACENT_LOADING VARCHAR2 (1)
Whether loading can be done adjacent to the vehicle
NON_ADJACENT_UNLOADING VARCHAR2 (1)
Whetherun loading can be done adjacent to the vehicle
PRIVATE_RESIDENCE VARCHAR2 (1) Y Private Residence Indicator : Yes / No
MAXIMUM_VEHICLE_HEIGHT NUMBER

Maximum Allowed Vehicle Height
MAXIMUM_VEHICLE_WIDTH NUMBER

Maximum Allowed Vehicle Width
MAXIMUM_VEHICLE_LENGTH NUMBER

Maximum Allowed Vehicle Length
DIMENSIONAL_UOM VARCHAR2 (3)
Dimension Unit of Measure for Vehicle Dimensions
LOAD_UNLOAD_PROTOCOL VARCHAR2 (30) Y Facility Charge Protocol : Facility / Carrier / Joint
EQUIPMENT_REQ_CODE1 VARCHAR2 (30)
EQUIPMENT_REQ_CODE2 VARCHAR2 (30)
EQUIPMENT_REQ_CODE3 VARCHAR2 (30)
EQUIPMENT_REQ_CODE4 VARCHAR2 (30)
MODIFIER_LIST NUMBER

Facility Ratechart Id : Foreign Key to QP_LIST_HEADERS_B.LIST_HEADER_ID
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE2 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE3 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE4 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE5 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE6 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE7 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE8 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE9 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE10 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE11 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE12 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE13 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE14 VARCHAR2 (150)
Flexfield Attribute Columns
ATTRIBUTE15 VARCHAR2 (150)
Flexfield Attribute Columns
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
PROGRAM_APPLICATION_ID NUMBER

Standard WHO Column
PROGRAM_ID NUMBER

Standard WHO Column
PROGRAM_UPDATE_DATE DATE

Standard WHO Column
REQUEST_ID NUMBER

Standard WHO Column
EFFECTIVE_DATE_FROM DATE
Y Effecitivity Start Date
EFFECTIVE_DATE_TO DATE

Effecitivity End Date
FLOW_THROUGH_TIME_UOM VARCHAR2 (3)
Flowthrough time unit of measure
HANDLE_STACKED_PALLETS VARCHAR2 (1)
Whether the Facility can handle stacked pallets - Yes / No
NONPALLETIZED_LOADING_RATE NUMBER

Non Palletized Loading Rate
NONPALLETIZED_UNLOADING_RATE NUMBER

Non Palletized Unloading Rate
NONPALLETIZED_HANDLING_UOM VARCHAR2 (30)
Non Palletized Loading/Unloading Handling Unit of Measure
NONPALLETIZED_HANDLING_TYPE VARCHAR2 (30)
Non Palletized Loading/Unloading Handling Unit Type
PALLETIZED_LOADING_RATE NUMBER

Palletized Loading Rate
PALLETIZED_UNLOADING_RATE NUMBER

Palletized Unloading Rate
PALLETIZED_HANDLING_UOM VARCHAR2 (30)
Palletized Loading/Unloading Handling Unit of Measure
PALLETIZED_HANDLING_TYPE VARCHAR2 (30)
Palletized Loading/Unloading Handling Unit Type
LOAD_UNLOAD_TIME_UOM VARCHAR2 (3)
Loading/Unloading Time Unit of Measure
HANDLING_CAPACITY_TIME_UOM VARCHAR2 (3)
Handling capacity time unit of measure
HANDLING_CAPACITY_TYPE VARCHAR2 (30)
Handling capacity unit type : WEIGHT / VOLUME / PIECE / PALLET
INCLUDE_MILEAGE_FLAG VARCHAR2 (1)
Include in Mileage Calculation - Yes / No
FACILITY_CONTACT_ID NUMBER

Facility Contact Id - Foreign Key to HZ_PARTIES.PARTY_ID

[top of page]

FTE.FTE_LOCATION_PARAMETERS does not reference any database object

FTE.FTE_LOCATION_PARAMETERS is referenced by following:

FTE
VIEW - FTE_LOCATION_PARAMETERS#

[top of page]

Table: FTE_MESSAGE_ADDRESS

Description: Stores Addresses listed in tracking messages
Primary Key: FTE_MESSAGE_ADDRESS_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MESSAGE_ADDRESS.ADDRESS_TO_ID FTE_MESSAGE_PARTNER
Comments

Stores Addresses listed in tracking messages

Indexes
Index Type Tablespace Column
FTE_MESSAGE_ADDRESS_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y PK
ADDR_LINE1 VARCHAR2 (50)
Address Line
ADDR_LINE2 VARCHAR2 (50)
Address Line
ADDR_LINE3 VARCHAR2 (50)
Address Line
ADDR_LINE4 VARCHAR2 (50)
Address Line
ADDR_LINE5 VARCHAR2 (50)
Address Line
ADDR_LINE6 VARCHAR2 (50)
Address Line
ADDR_LINE7 VARCHAR2 (50)
Address Line
ADDR_LINE8 VARCHAR2 (50)
Address Line
ADDR_LINE9 VARCHAR2 (50)
Address Line
ADDR_TYPE VARCHAR2 (30)
Address Type
ADDR_CITY VARCHAR2 (50)
City
ADDR_COUNTY VARCHAR2 (50)
County
ADDR_COUNTRY VARCHAR2 (50)
Country
ADDR_DESCRIPTION VARCHAR2 (1000)
Description
ADDR_POSTAL_CODE VARCHAR2 (10)
Postal or ZIP code
ADDR_REGION VARCHAR2 (50)
Region
ADDR_STATE VARCHAR2 (50)
State or Province
ADDR_TAX_JURISDICTION VARCHAR2 (50)
Tax Jurisdiction
ADDR_URL VARCHAR2 (60)
URL
FAX1 VARCHAR2 (30)
Fax Number
FAX2 VARCHAR2 (30)
Fax Number
FAX3 VARCHAR2 (30)
Fax Number
FAX4 VARCHAR2 (30)
Fax Number
FAX5 VARCHAR2 (30)
Fax Number
FAX6 VARCHAR2 (30)
Fax Number
FAX7 VARCHAR2 (30)
Fax Number
FAX8 VARCHAR2 (30)
Fax Number
FAX9 VARCHAR2 (30)
Fax Number
TELEPHONE1 VARCHAR2 (30)
Telephone
TELEPHONE2 VARCHAR2 (30)
Telephone
TELEPHONE3 VARCHAR2 (30)
Telephone
TELEPHONE4 VARCHAR2 (30)
Telephone
TELEPHONE5 VARCHAR2 (30)
Telephone
TELEPHONE6 VARCHAR2 (30)
Telephone
TELEPHONE7 VARCHAR2 (30)
Telephone
TELEPHONE8 VARCHAR2 (30)
Telephone
TELEPHONE9 VARCHAR2 (30)
Telephone
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
TRANSACTION_ID NUMBER

FK to Transaction ID in headers table
ADDRESS_TO_TABLE VARCHAR2 (30)
Table this Address belongs to
ADDRESS_TO_ID NUMBER
Y Primary key on foreign table record this address belongs to

[top of page]

FTE.FTE_MESSAGE_ADDRESS does not reference any database object

FTE.FTE_MESSAGE_ADDRESS is referenced by following:

FTE
VIEW - FTE_MESSAGE_ADDRESS#

[top of page]

Table: FTE_MESSAGE_CONTACT

Description: This stores the contact portion of the showshipstatus message
Primary Key: FTE_MESSAGE_CONTACT_PK
  1. CONTACT_ID
Comments

This stores the contact portion of the showshipstatus message

Indexes
Index Type Tablespace Column
FTE_MESSAGE_CONTACT_U1 UNIQUE APPS_TS_TX_IDX CONTACT_ID
FTE_MESSAGE_CONTACT_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
CONTACT_ID NUMBER
Y Primary Key
PARTNER_ID NUMBER

FK to Partners
NAME1 VARCHAR2 (50)
Name
NAME2 VARCHAR2 (50)
Name
NAME3 VARCHAR2 (50)
Name
NAME4 VARCHAR2 (50)
Name
NAME5 VARCHAR2 (50)
name
NAME6 VARCHAR2 (50)
Name
NAME7 VARCHAR2 (50)
Name
NAME8 VARCHAR2 (50)
Name
NAME9 VARCHAR2 (50)
Name
CONTACT_TYPE VARCHAR2 (30)
Contact Type
DESCRIPTION VARCHAR2 (100)
Description
EMAIL VARCHAR2 (50)
Email Address
FAX1 VARCHAR2 (30)
Fax
FAX2 VARCHAR2 (30)
Fax
FAX3 VARCHAR2 (30)
Fax
FAX4 VARCHAR2 (30)
Fax
FAX5 VARCHAR2 (30)
Fax
FAX6 VARCHAR2 (30)
Fax
FAX7 VARCHAR2 (30)
Fax
FAX8 VARCHAR2 (30)
Fax
FAX9 VARCHAR2 (30)
Fax
TELEPHONE1 VARCHAR2 (30)
Telephone
TELEPHONE2 VARCHAR2 (30)
Telephone
TELEPHONE3 VARCHAR2 (30)
Telephone
TELEPHONE4 VARCHAR2 (30)
Telephone
TELEPHONE5 VARCHAR2 (30)
Telephone
TELEPHONE6 VARCHAR2 (30)
Telephone
TELEPHONE7 VARCHAR2 (30)
Telephone
TELEPHONE8 VARCHAR2 (30)
Telephone
TELEPHONE9 VARCHAR2 (30)
Telephone
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
TRANSACTION_ID NUMBER

FK reference to Transaction id in headers Table

[top of page]

FTE.FTE_MESSAGE_CONTACT does not reference any database object

FTE.FTE_MESSAGE_CONTACT is referenced by following:

FTE
VIEW - FTE_MESSAGE_CONTACT#

[top of page]

Table: FTE_MESSAGE_LOCATION

Description: Stores all the locations mentioned in a shipstatus message
Primary Key: FTE_MESSAGE_LOCATION_PK
  1. ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MESSAGE_LOCATION.LOCATION_TO_ID FTE_SHIPMENT_STATUS_DETAILS
Comments

Stores all the locations mentioned in a shipstatus message

Indexes
Index Type Tablespace Column
FTE_MESSAGE_LOCATION_U1 UNIQUE APPS_TS_TX_IDX ID
FTE_MESSAGE_LOCATION_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y Primary Key
DESCRIPTION VARCHAR2 (60)
Description
GEOCOORDINATES VARCHAR2 (60)
Geocoordinates
GEOCOORDINATES_TYPE VARCHAR2 (60)
Geocoordinates Type
LOCATION_ID VARCHAR2 (60)
Location Id
LOCATION_ID_TYPE VARCHAR2 (60)
Location ID Type
SITELEVEL1 VARCHAR2 (30)
Site Level
SITELEVEL2 VARCHAR2 (30)
Site Level
SITELEVEL3 VARCHAR2 (30)
Site Level
SITELEVEL4 VARCHAR2 (30)
Site Level
SITELEVEL5 VARCHAR2 (30)
Site Level
SITELEVEL6 VARCHAR2 (30)
Site Level
SITELEVEL7 VARCHAR2 (30)
Site Level
SITELEVEL8 VARCHAR2 (30)
Site Level
SITELEVEL9 VARCHAR2 (30)
Site Level
ADDRESS_ID NUMBER

Address ID FK to Address table
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
TRANSACTION_ID NUMBER

FK to Transaction ID on headers table
LOCATION_TO_TABLE VARCHAR2 (30)
Which table does this location belong to?
LOCATION_TO_ID NUMBER
Y The PK of the record on the table this location belongs to

[top of page]

FTE.FTE_MESSAGE_LOCATION does not reference any database object

FTE.FTE_MESSAGE_LOCATION is referenced by following:

FTE
VIEW - FTE_MESSAGE_LOCATION#

[top of page]

Table: FTE_MESSAGE_PARTNER

Description: This table stores all the partners listed in the Shipstatus message
Primary Key: FTE_MESSAGE_PARTNER_PK
  1. ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MESSAGE_ADDRESS.ADDRESS_TO_ID FTE_MESSAGE_PARTNER
Comments

This table stores all the partners listed in the Shipstatus message

Indexes
Index Type Tablespace Column
FTE_MESSAGE_PARTNER_U1 UNIQUE APPS_TS_TX_IDX ID
FTE_MESSAGE_PARTNER_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y Primary Key
NAME1 VARCHAR2 (50)
Name
NAME2 VARCHAR2 (50)
Name
NAME3 VARCHAR2 (50)
Name
NAME4 VARCHAR2 (50)
Name
NAME5 VARCHAR2 (50)
Name
NAME6 VARCHAR2 (50)
Name
NAME7 VARCHAR2 (50)
Name
NAME8 VARCHAR2 (50)
Name
NAME9 VARCHAR2 (50)
Name
ONETIME VARCHAR2 (50)
One time use
PARTNER_ID NUMBER

Partner ID
PARTNER_TYPE VARCHAR2 (15)
Partner Type
ACTIVE VARCHAR2 (1)
is this partner Active?
CURRENCY VARCHAR2 (10)
Partner's preferred Currency
DESCRIPTION VARCHAR2 (1000)
Description
DUNS_NUMBER VARCHAR2 (30)
DUNS number
GL_ENTITIES VARCHAR2 (30)
GL Entities
PARENT_ID NUMBER

Parent ID
PARTNER_ID_X VARCHAR2 (30)
Partner ID X
PARTNER_RATING VARCHAR2 (30)
Partner Rating
PARTNER_ROLE VARCHAR2 (30)
Partner Role
PAYMENT_METHOD VARCHAR2 (30)
Payment Method
TAX_EXEMPT VARCHAR2 (1)
Tax Exempt flag
TAX_ID VARCHAR2 (30)
Tax ID
TERM_ID VARCHAR2 (30)
Term ID
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
SHIPPER_ACCOUNT_NUMBER VARCHAR2 (30)
Shipper Account Number
TRANSACTION_ID NUMBER
Y FK reference to headers table

[top of page]

FTE.FTE_MESSAGE_PARTNER does not reference any database object

FTE.FTE_MESSAGE_PARTNER is referenced by following:

FTE
VIEW - FTE_MESSAGE_PARTNER#

[top of page]

Table: FTE_MILE_ATTRIBUTES

Description: The table is used to store the attributes that make up the columns (origin, destination and return) in the download file. E.g. 'CITY', 'STATE', etc... The data in this table is seeded and is not updateable by the user.
Primary Key: FTE_MILE_ATTRIBUTES_PK1
  1. ATTRIBUTE_ID
Comments

This table is used to store the attributes that make up the columns (origin, destination and return) in the download file. E.g. 'CITY', 'STATE', etc... The data in this table is seeded and is not updateable by the user.

Indexes
Index Type Tablespace Column
FTE_MILE_ATTRIBUTES_U1 UNIQUE APPS_TS_SEED CODE
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_ID NUMBER
Y Primary key for the table - system generated
CODE VARCHAR2 (30) Y Code identifier for the attribute
NAME VARCHAR2 (30) Y Name of the attribute
DESCRIPTION VARCHAR2 (240)
Description of the attribute
MAX_ATTRIBUTE_LENGTH NUMBER

Maximum length of the attributes associated database column.
DOWNLOAD_UPLOAD_FLAG VARCHAR2 (1)
Indicates if the attribute is to be used for 'D'ownload only, 'U'pload only or 'B'oth
DELIMITER_YN_FLAG VARCHAR2 (1)
Indicates if the attribute is used as a delimiter
ORIGIN_DEST_RETURN_FLAG VARCHAR2 (1)
Indicates if the attribute is an 'O'rigin attribute only, 'D'estination attribute only or 'B'oth or is a 'R'eturn attribute i.e. value is calculated externally
DEFAULT_UOM VARCHAR2 (3)
Default Unit of Measure Code for the attribute
DEFAULT_COLUMN_POSITION NUMBER

Default position of the attribute in the relative column - will be used if the user does not enter new attribute column positions in the UI
CREATION_DATE DATE
Y Standard who columns
CREATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
PROGRAM_APPLICATION_ID NUMBER

Standard who columns
PROGRAM_ID NUMBER

Standard who columns
PROGRAM_UPDATE_DATE DATE

Standard who columns
REQUEST_ID NUMBER

Standard who columns

[top of page]

FTE.FTE_MILE_ATTRIBUTES does not reference any database object

FTE.FTE_MILE_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_MILE_ATTRIBUTES#

[top of page]

Table: FTE_MILE_COLUMN_ATTRIBUTES

Description: This table is used to store the attribute data used for the relevant columns in the download/upload file.
Primary Key: FTE_MILE_COLUMN_ATTRIBUTES_PK1
  1. COLUMN_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MILE_COLUMN_ATTRIBUTES.COLUMN_ID FTE_MILE_TEMPLATE_COLUMNS
Comments

This table is used to store the attribute data used for the relevant columns in the download/upload file.

Indexes
Index Type Tablespace Column
FTE_MILE_COLUMN_ATTRIBUTES_N1 NONUNIQUE APPS_TS_TX_IDX COLUMN_ID
FTE_MILE_COLUMN_ATTRIBUTES_N2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
COLUMN_ATTRIBUTE_ID NUMBER
Y Primary Key for the table - System Generated
COLUMN_ID NUMBER
Y Foreign Key to FTE_MILE_TEMPLATE_COLUMNS - identifies the column the attribute is assigned to
ATTRIBUTE_ID NUMBER

Foreign key to FTE_MILE_ATTRIBUTES. Identifier for the attribute
CODE VARCHAR2 (30)
Code of the attribute
ATTRIBUTE_DELIMITER VARCHAR2 (1)
Delimiter used after the attribute. E.g. a delimiter of ',' (comma) would give a layout like ,. This is only used for two or more attributes in a column
SPACE_PADDING NUMBER

not used
RETURN_FORMAT VARCHAR2 (10)
Format code for the returniong attributes. E.g. the transit time may be returned in Hours:Minutes format, the distance may be returned in miles or kilometers
DB_UOM VARCHAR2 (3)
The Unit of Measure in which to store the return attributes in the database.
ENABLED_FLAG VARCHAR2 (1)
Indicates if the attribute has been selected for use or not
SEQUENCE_ID NUMBER

Indicates the position of the attribute in the column
LENGTH NUMBER

The length of the attribute in the column
DB_LENGTH NUMBER

The length of the attributes' associated database column
CREATION_DATE DATE
Y Standard who columns
CREATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
PROGRAM_APPLICATION_ID NUMBER

Standard who columns
PROGRAM_ID NUMBER

Standard who columns
PROGRAM_UPDATE_DATE DATE

Standard who columns
REQUEST_ID NUMBER

Standard who columns

[top of page]

FTE.FTE_MILE_COLUMN_ATTRIBUTES does not reference any database object

FTE.FTE_MILE_COLUMN_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_MILE_COLUMN_ATTRIBUTES#

[top of page]

Table: FTE_MILE_DOWNLOAD_FILES

Description: This table is used to store the information of the file created for download. When uploading a file, this table will be checked to ensure that the file is valid and then to get the formatting data from the related template that was used to
Primary Key: FTE_MILE_DOWNLOAD_FILES_PK1
  1. DOWNLOAD_FILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MILE_DOWNLOAD_FILES.TEMPLATE_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MILE_DOWNLOAD_LINES.DOWNLOAD_FILE_ID FTE_MILE_DOWNLOAD_FILES
Comments

This table is used to store the information of the file created for download. When uploading a file, this table will be checked to ensure that the file is valid and then to get the formatting data from the related template that was used to create the file so that the file can be parsed correctly. This table is also used to check when deleting or updating a template that may be currently in use for download or upload.

Indexes
Index Type Tablespace Column
FTE_MILE_DOWNLOAD_FILES_U1 UNIQUE APPS_TS_TX_IDX FILE_NAME
FTE_MILE_DOWNLOAD_FILES_N1 NONUNIQUE APPS_TS_TX_IDX TEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
DOWNLOAD_FILE_ID NUMBER
Y Primary Key for the table - Syatem Generated
FILE_NAME VARCHAR2 (8) Y Unique name for the upload/download file. The file name is of the format: DLF<5_digit_generated_number> E.g. DLF00012
DOWNLOAD_FILE_EXTENSION VARCHAR2 (3) Y User defined extension for the download file. If none given the default provided by the system is '.in'
TEMPLATE_ID NUMBER
Y Foreign Key to FTE_MILE_TEMPLATES - identifies the template that was used to create the file
UPLOAD_ID NUMBER

Batch Id for the upload process - populated after upload is successful
DOWNLOAD_DATE DATE

Timestamp when the file was created
UPLOAD_DATE DATE

Timestamp when the file was uploaded
IDENTIFIER_TYPE VARCHAR2 (30)
Region level identifier for the data that was downloaded, E.g. 'CITYSTATE', 'ZIP'
CREATION_DATE DATE
Y Standard who columns
CREATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
PROGRAM_APPLICATION_ID NUMBER

Standard who columns
PROGRAM_ID NUMBER

Standard who columns
PROGRAM_UPDATE_DATE DATE

Standard who columns
REQUEST_ID NUMBER

Standard who columns

[top of page]

FTE.FTE_MILE_DOWNLOAD_FILES does not reference any database object

FTE.FTE_MILE_DOWNLOAD_FILES is referenced by following:

FTE
VIEW - FTE_MILE_DOWNLOAD_FILES#

[top of page]

Table: FTE_MILE_DOWNLOAD_LINES

Description: This table is used to store the contents of the download file. When the file is uploaded to the database the file is parsed and each related line from the file is read from the table and the origin and destination id pairs along with the di
Primary Key: FTE_MILE_DOWNLOAD_LINES_PK1
  1. DOWNLOAD_FILE_ID
  2. LINE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MILE_DOWNLOAD_LINES.DOWNLOAD_FILE_ID FTE_MILE_DOWNLOAD_FILES
Comments

This table is used to store the contents of the download file. When the file is uploaded to the database the file is parsed and each related line from the file is read from the table and the origin and destination id pairs along with the distance and transit times from the file are loaded into the FTE_LOCATION_MILEAGES table. Once the upload is complete the data is deleted from this table.

Indexes
Index Type Tablespace Column
FTE_MILE_DOWNLOAD_LINES_N1 NONUNIQUE APPS_TS_TX_IDX ORIGIN_ID
FTE_MILE_DOWNLOAD_LINES_N2 NONUNIQUE APPS_TS_TX_IDX DESTINATION_ID
Columns
Name Datatype Length Mandatory Comments
DOWNLOAD_FILE_ID NUMBER
Y Foreign Key to FTE_MILE_DOWNLOAD_FILES identifying the line with a file
LINE_NUMBER NUMBER
Y The line number in the file that this record is associated with
ORIGIN_ID NUMBER
Y identifier of the origin
DESTINATION_ID NUMBER
Y identifier of the destination
CREATION_DATE DATE
Y Standard who columns
CREATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
PROGRAM_APPLICATION_ID NUMBER

Standard who columns
PROGRAM_ID NUMBER

Standard who columns
PROGRAM_UPDATE_DATE DATE

Standard who columns
REQUEST_ID NUMBER

Standard who columns

[top of page]

FTE.FTE_MILE_DOWNLOAD_LINES does not reference any database object

FTE.FTE_MILE_DOWNLOAD_LINES is referenced by following:

FTE
VIEW - FTE_MILE_DOWNLOAD_LINES#

[top of page]

Table: FTE_MILE_TEMPLATES

Description: This table is used to store the template header information that is used to format the file for download and read the upload file for loading the file data into the database.
Primary Key: FTE_MILE_TEMPLATES_PK1
  1. TEMPLATE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MILE_TEMPLATE_COLUMNS.TEMPLATE_ID FTE_MILE_TEMPLATES
Comments

This table is used to store the template header information that is used to format the file for download and read the upload file for loading the file data into the database.

Indexes
Index Type Tablespace Column
FTE_MILE_TEMPLATES_U1 UNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Y Primary key for the table - system generated
NAME VARCHAR2 (30) Y User defined name of the template. This must be unique
DESCRIPTION VARCHAR2 (240)
User defined description of the template
CREATION_DATE DATE
Y Standard who columns
CREATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
PROGRAM_APPLICATION_ID NUMBER

Standard who columns
PROGRAM_ID NUMBER

Standard who columns
PROGRAM_UPDATE_DATE DATE

Standard who columns
REQUEST_ID NUMBER

Standard who columns

[top of page]

FTE.FTE_MILE_TEMPLATES does not reference any database object

FTE.FTE_MILE_TEMPLATES is referenced by following:

FTE
VIEW - FTE_MILE_TEMPLATES#

[top of page]

Table: FTE_MILE_TEMPLATE_COLUMNS

Description: This table is used to store the column data that is used to format the download/upload file.
Primary Key: FTE_MILE_TEMPLATE_COLUMNS_PK1
  1. COLUMN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_MILE_TEMPLATE_COLUMNS.TEMPLATE_ID FTE_MILE_TEMPLATES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MILE_COLUMN_ATTRIBUTES.COLUMN_ID FTE_MILE_TEMPLATE_COLUMNS
Comments

This table is used to store the column data that is used to format the download/upload file.

Indexes
Index Type Tablespace Column
FTE_MILE_TEMPLATE_COLUMNS_N1 NONUNIQUE APPS_TS_TX_IDX TEMPLATE_ID
FTE_MILE_TEMPLATE_COLUMNS_N2 NONUNIQUE APPS_TS_TX_IDX COLUMN_TYPE
Columns
Name Datatype Length Mandatory Comments
COLUMN_ID NUMBER
Y Primary key for the table - system generated
COLUMN_TYPE VARCHAR2 (30) Y Type of column usage - 'O'rigin, 'D'estination, 'RD' - Return Distance, 'RT' Return Time
START_POSITION NUMBER

Starting position for the column in the file. E.g. '1' would indicate that the column starts at position 1 in the download file
LENGTH NUMBER

The length of the column in the download/upload file
COLUMN_DELIMITER VARCHAR2 (1)
Delimiter used after the column, E.g. a delimiter of ',' (comma) for the origin column gives a layout like: ,
TEMPLATE_ID NUMBER
Y Foreign Key to FTE_MILE_TEMPLATES identifying the template that the column is assigned to.
CREATION_DATE DATE
Y Standard who columns
CREATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
PROGRAM_APPLICATION_ID NUMBER

Standard who columns
PROGRAM_ID NUMBER

Standard who columns
PROGRAM_UPDATE_DATE DATE

Standard who columns
REQUEST_ID NUMBER

Standard who columns
SEQUENCE_ID NUMBER

Sequence Id of the column
COLUMN_SEQUENCE NUMBER

Numeric value of the column sequence

[top of page]

FTE.FTE_MILE_TEMPLATE_COLUMNS does not reference any database object

FTE.FTE_MILE_TEMPLATE_COLUMNS is referenced by following:

FTE
VIEW - FTE_MILE_TEMPLATE_COLUMNS#

[top of page]

Table: FTE_MOVES

Description:
Primary Key: FTE_MOVES_PK
  1. MOVE_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_MOVES_PK UNIQUE APPS_TS_TX_IDX MOVE_ID
Columns
Name Datatype Length Mandatory Comments
MOVE_ID NUMBER
Y Primary key
MOVE_TYPE_CODE VARCHAR2 (30) Y Move type
LANE_ID NUMBER

Lane Id of the continuous move.
SERVICE_LEVEL VARCHAR2 (30)
Service level for the continuous move
PLANNED_FLAG VARCHAR2 (1) Y Firm level
TP_PLAN_NAME VARCHAR2 (10)
Plan name from which this continuous move is relased from Transportation Planning
CM_TRIP_NUMBER NUMBER

Continuous move trip number in Transportation Planning
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
REQUEST_ID NUMBER

Enhanced Who column
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

FTE.FTE_MOVES does not reference any database object

FTE.FTE_MOVES is referenced by following:

FTE
VIEW - FTE_MOVES#

[top of page]

Table: FTE_MOVES_INTERFACE

Description:
Primary Key: FTE_MOVES_INTERFACE_PK
  1. MOVE_INTERFACE_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_MOVES_INTERFACE_PK UNIQUE APPS_TS_INTERFACE MOVE_INTERFACE_ID
Columns
Name Datatype Length Mandatory Comments
MOVE_INTERFACE_ID NUMBER
Y
MOVE_ID NUMBER

MOVE_TYPE_CODE VARCHAR2 (30)
LANE_ID NUMBER

SERVICE_LEVEL VARCHAR2 (30)
PLANNED_FLAG VARCHAR2 (1)
TP_PLAN_NAME VARCHAR2 (10)
CM_TRIP_NUMBER NUMBER

CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
REQUEST_ID NUMBER

Enhanced Who column
INTERFACE_ACTION_CODE VARCHAR2 (30)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

FTE.FTE_MOVES_INTERFACE does not reference any database object

FTE.FTE_MOVES_INTERFACE is referenced by following:

FTE
VIEW - FTE_MOVES_INTERFACE#

[top of page]

Table: FTE_PRC_PARAMETERS

Description: Stores pricing parameters
Primary Key: FTE_PRC_PARAMETERS_PK
  1. PARAMETER_INSTANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_PRC_PARAMETERS.LANE_ID FTE_LANES
FTE_PRC_PARAMETERS.LIST_HEADER_ID QP_LIST_HEADERS_B
FTE_PRC_PARAMETERS.PARAMETER_ID FTE_PRC_PARAMETER_DEFAULTS
Comments

FTE_PRC_PARAMETERS is used to store parameters used in rating. Parameters can be stored at various levels.

Indexes
Index Type Tablespace Column
FTE_PRC_PARAMETERS_U1 UNIQUE APPS_TS_TX_IDX PARAMETER_INSTANCE_ID
FTE_PRC_PARAMETERS_N1 NONUNIQUE APPS_TS_TX_IDX LANE_ID
PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
PARAMETER_INSTANCE_ID NUMBER
Y Primary Key
CARRIER_ID NUMBER

Carrier Id
LANE_ID NUMBER

Lane Id
SERVICE_TYPE VARCHAR2 (30)
Service Type
PARAMETER_ID NUMBER
Y Foriegn key to FTE_PRC_PARAMETER_DEFAULTS
VALUE_FROM VARCHAR2 (240)
Value from
VALUE_TO VARCHAR2 (240)
Value to
UOM_CLASS VARCHAR2 (240)
Uom Class
UOM_CODE VARCHAR2 (240)
Uom code
CURRENCY_CODE VARCHAR2 (30)
Currency code
CREATION_DATE DATE
Y Creation date
CREATED_BY NUMBER
Y Created by
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATED_BY NUMBER
Y last updated by
LAST_UPDATE_LOGIN NUMBER

last update login
PROGRAM_APPLICATION_ID NUMBER

program application id
PROGRAM_ID NUMBER

program id
PROGRAM_UPDATE_DATE DATE

program update date
REQUEST_ID NUMBER

request id
LIST_HEADER_ID NUMBER

Foreign key to QP_LIST_HEADERS_B

[top of page]

FTE.FTE_PRC_PARAMETERS does not reference any database object

FTE.FTE_PRC_PARAMETERS is referenced by following:

FTE
VIEW - FTE_PRC_PARAMETERS#

[top of page]

Table: FTE_PRC_PARAMETER_DEFAULTS

Description: Stores default values for pricing parameters
Primary Key: FTE_PRC_PARAMETER_DEFAULTS_PK
  1. PARAMETER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_PRC_PARAMETERS.PARAMETER_ID FTE_PRC_PARAMETER_DEFAULTS
Comments

FTE_PRC_PARAMETER_DEFAULTS stores valid parameter names and default values for parameters.

Indexes
Index Type Tablespace Column
FTE_PRC_PARAMETER_DEFAULTS_U1 UNIQUE APPS_TS_SEED PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER
Y Primary key
PARAMETER_TYPE VARCHAR2 (30) Y Parameter type
LANE_FUNCTION VARCHAR2 (30) Y Lane function
PARAMETER_SUB_TYPE VARCHAR2 (30) Y parameter sub type
PARAMETER_NAME VARCHAR2 (30) Y parameter name
PARAMETER_DATATYPE VARCHAR2 (30) Y parameter data type
DEFAULT_VALUE_FROM VARCHAR2 (240)
default low value
DEFAULT_VALUE_TO VARCHAR2 (240)
default high value
DEFAULT_UOM_CLASS VARCHAR2 (240)
default uom class
DEFAULT_UOM_CODE VARCHAR2 (240)
default uom code
DEFAULT_CURRENCY_CODE VARCHAR2 (30)
default currency
USER_OVERRIDE_ALLOWED VARCHAR2 (1) Y specifies if user is allowed to override default values
CREATION_DATE DATE
Y creation date
CREATED_BY NUMBER
Y created by
LAST_UPDATE_DATE DATE
Y last update date
LAST_UPDATED_BY NUMBER
Y last updated by
LAST_UPDATE_LOGIN NUMBER

last update login
PROGRAM_APPLICATION_ID NUMBER

program application id
PROGRAM_ID NUMBER

program id
PROGRAM_UPDATE_DATE DATE

program update date
REQUEST_ID NUMBER

request id

[top of page]

FTE.FTE_PRC_PARAMETER_DEFAULTS does not reference any database object

FTE.FTE_PRC_PARAMETER_DEFAULTS is referenced by following:

FTE
VIEW - FTE_PRC_PARAMETER_DEFAULTS#

[top of page]

Table: FTE_PTRK_EVENTS

Description: Table to store tracking events
Comments

Table to store tracking events

Indexes
Index Type Tablespace Column
FTE_PTRK_EVENTS_U1 UNIQUE APPS_TS_TX_IDX BUSINESS_CONCEPT_ID
OWNER_APPLICATION_ID
FTE_PTRK_EVENTS_N1 NONUNIQUE APPS_TS_TX_IDX PAGE_GRANULARITY
Columns
Name Datatype Length Mandatory Comments
OWNER_APPLICATION_ID NUMBER (15) Y Owner application id
BUSINESS_CONCEPT_ID NUMBER (15) Y Business concept id
BUSINESS_CONCEPT VARCHAR2 (50)
Business concept
PAGE_GRANULARITY VARCHAR2 (50)
Page granularity
CREATED_BY NUMBER
Y Standard who columns
CREATION_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns

[top of page]

FTE.FTE_PTRK_EVENTS does not reference any database object

FTE.FTE_PTRK_EVENTS is referenced by following:

FTE
VIEW - FTE_PTRK_EVENTS#

[top of page]

Table: FTE_PTRK_PAGES

Description: Table to store tracking header information
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_PTRK_PAGES.CARRIER_PARTY_ID HZ_PARTIES
Comments

Table to store tracking header information

Indexes
Index Type Tablespace Column
FTE_PTRK_PAGES_U1 UNIQUE APPS_TS_TX_IDX PAGE_ID
FTE_PTRK_PAGES_N1 NONUNIQUE APPS_TS_TX_IDX CARRIER_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
PAGE_ID NUMBER (15) Y Page id
OWNER_APPLICATION_ID NUMBER (15) Y Owner application id
ORGANIZATIONS VARCHAR2 (2000)
Organization names
CARRIER_PARTY_ID NUMBER (15) Y Carrier id populated based on carrier_id in wsh_carriers
BASE_URL VARCHAR2 (200) Y Base Url
REQUEST_METHOD VARCHAR2 (4) Y Request method
STATUS VARCHAR2 (20)
Status of progress
NAME VARCHAR2 (30)
Page name
DESCRIPTION VARCHAR2 (200)
Page description
BUSINESS_CONCEPTS VARCHAR2 (1000)
Business concept
GRANULARITY VARCHAR2 (20)
Granularity
CREATED_BY NUMBER
Y Standard who columns
CREATION_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns

[top of page]

FTE.FTE_PTRK_PAGES does not reference any database object

FTE.FTE_PTRK_PAGES is referenced by following:

FTE
VIEW - FTE_PTRK_PAGES#

[top of page]

Table: FTE_PTRK_PARAMS

Description: Table to store tracking parameter information
Comments

Table to store tracking parameter information

Indexes
Index Type Tablespace Column
FTE_PTRK_PARAMS_U1 UNIQUE APPS_TS_TX_IDX PARAM_ID
FTE_PTRK_PARAMS_N1 NONUNIQUE APPS_TS_TX_IDX SEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
PAGE_ID NUMBER (15) Y Page id
PARAM_ID NUMBER (15) Y Parameter id
PARAM_NAME VARCHAR2 (30)
Parameter name
STATIC_VALUE VARCHAR2 (50)
Static value
TOKEN_ID NUMBER (15)
Token id
SEQUENCE_NUMBER NUMBER (15)
Sequence number
FLAG VARCHAR2 (1)
Indication flag
CREATED_BY NUMBER
Y Standard who columns
CREATION_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns

[top of page]

FTE.FTE_PTRK_PARAMS does not reference any database object

FTE.FTE_PTRK_PARAMS is referenced by following:

FTE
VIEW - FTE_PTRK_PARAMS#

[top of page]

Table: FTE_PTRK_SOURCES

Description: Table to store tracking type information
Comments

Table to store tracking type information

Indexes
Index Type Tablespace Column
FTE_PTRK_SOURCES_U1 UNIQUE APPS_TS_TX_IDX OWNER_APPLICATION_ID
TOKEN_ID
Columns
Name Datatype Length Mandatory Comments
OWNER_APPLICATION_ID NUMBER (15) Y Owner application id
TOKEN_ID NUMBER (15) Y Token id
TOKEN_NAME VARCHAR2 (150) Y Token name
PAGE_GRANULARITY VARCHAR2 (20) Y Page granularity
SOURCE_TABLE VARCHAR2 (50) Y Source table name
SOURCE_COLUMN VARCHAR2 (50) Y Source column name
KEY_COLUMN1 VARCHAR2 (50) Y Key column 1
KEY_COLUMN2 VARCHAR2 (50)
Key column 2
KEY_COLUMN3 VARCHAR2 (50)
Key column 3
KEY_COLUMN4 VARCHAR2 (50)
Key column 4
KEY_COLUMN5 VARCHAR2 (50)
Key column 5
CREATED_BY NUMBER
Y Standard who columns
CREATION_DATE DATE
Y Standard who columns
LAST_UPDATED_BY NUMBER
Y Standard who columns
LAST_UPDATE_DATE DATE
Y Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns

[top of page]

FTE.FTE_PTRK_SOURCES does not reference any database object

FTE.FTE_PTRK_SOURCES is referenced by following:

FTE
VIEW - FTE_PTRK_SOURCES#

[top of page]

Table: FTE_SCHEDULES

Description: Stores schedule information for each lane. This is the main catalog entity for schedules
Primary Key: FTE_SCHEDULES_PK
  1. SCHEDULES_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SCHEDULES.LANE_ID FTE_LANES
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_LOAD_SCHEDULES.ORIGINAL_SCHEDULE_ID FTE_SCHEDULES
Comments

FTE_SCHEDULES stores schedule information for each lane. Schedules define time-bound information for each lane and include departure and arrival dates and times, voyage numbers, Port of Loading, and Port of Discharge. Two types of schedules are supported in this table - date based and frequency based. Frequency based schedules have only time of day and an associated Frequency column. Schedules have a range of effectivity defined by Effective Date and Expiry Date.

Indexes
Index Type Tablespace Column
FTE_SCHEDULES_U1 UNIQUE APPS_TS_TX_IDX SCHEDULES_ID
FTE_SCHEDULES_N1 NONUNIQUE APPS_TS_TX_IDX LANE_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULES_ID NUMBER
Y Primary key
LANE_ID NUMBER
Y Foreign key for FTE_LANES
LANE_NUMBER VARCHAR2 (30)
Lane reference number
VESSEL_TYPE VARCHAR2 (100)
Vessel Type
VESSEL_NAME VARCHAR2 (30)
Vessel name
VOYAGE_NUMBER VARCHAR2 (30)
Number or name of voyage
DEPARTURE_DATE DATE

Date of departure
DEPARTURE_TIME VARCHAR2 (10)
Time of departure
ARRIVAL_DATE DATE

Date of arrival
ARRIVAL_TIME VARCHAR2 (10)
Time of arrival
ARRIVAL_DATE_INDICATOR NUMBER

Difference of ays between Departure and Arrival date. It used for frequency based schedules.
FREQUENCY_TYPE VARCHAR2 (10)
Type of Frequency of the schedule. Could be Daily, Weekly or null.
FREQUENCY NUMBER

Frequency of the schedule
FREQUENCY_ARRIVAL VARCHAR2 (30)
Arrival of Frequency
TRANSIT_TIME NUMBER

Number of hours/days between departure and arrival
TRANSIT_TIME_UOM VARCHAR2 (3)
Unit of Measure of Transit Time
PORT_OF_LOADING VARCHAR2 (240)
Port of loading
PORT_OF_DISCHARGE VARCHAR2 (240)
Port of discharge
EFFECTIVE_DATE DATE

Effective date for the schedule
EXPIRY_DATE DATE

Expiry date for the schedule
EDITABLE_FLAG VARCHAR2 (1)
Editable Flag for the internal use only
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column

[top of page]

FTE.FTE_SCHEDULES does not reference any database object

FTE.FTE_SCHEDULES is referenced by following:

FTE
VIEW - FTE_SCHEDULES#

[top of page]

Table: FTE_SEL_ATTRIBUTES

Description: This table holds all attribute definitions. Each attribute is linked to an object defined in FTE_SEL_OBJECTS, E.g. an object could be 'Carrier_selection', and by linking attributes to that object the attributes become available for use by
Primary Key: FTE_SEL_ATTRIBUTES_PK1
  1. ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_ATTRIBUTES.OBJECT_ID FTE_SEL_OBJECTS
Comments

This table holds all attribute definitions. Each attribute is linked to an object defined in FTE_SEL_OBJECTS, E.g. an object could be 'Carrier_selection', and by linking attributes to that object the attributes become available for use by that object.

Indexes
Index Type Tablespace Column
FTE_SEL_ATTRIBUTES_U1 UNIQUE APPS_TS_SEED CODE
OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_ID NUMBER
Y primary key for the table
CODE VARCHAR2 (30) Y code of the attribute
NAME VARCHAR2 (240)
name of the attribute
OBJECT_ID NUMBER
Y foreign key to FTE_SEL_OBJECTS.OBJECT_ID
DATA_TYPE VARCHAR2 (1) Y data type of the attribute, e.g. 'N'umber, 'C'haracter
RANGE_FLAG VARCHAR2 (1) Y Indicates if the attribute can be used for a range of values
SELECTION_TYPE VARCHAR2 (1) Y Indicates if the attribute is for 'I'nput, 'O'utput or 'B'oth
VISIBLE_FLAG VARCHAR2 (1)
Indicates if the attribute is visible to the user
ENABLED_FLAG VARCHAR2 (1)
Indicates if the attribute is enabled or not
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column

[top of page]

FTE.FTE_SEL_ATTRIBUTES does not reference any database object

FTE.FTE_SEL_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_SEL_ATTRIBUTES#

[top of page]

Table: FTE_SEL_ATTRIBUTES_TMP

Description: This table provides a temporary storage for input attributes and values that may be used to query the specified object, e.g. 'carrier_selection'. The attributes to be used in a single query are grouped together by the query_id value. After
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_SEL_ATTRIBUTES_TMP_N1 NONUNIQUE APPS_TS_ARCHIVE QUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Y Identifier that groups all attributes in the temp table that are used for a query execution
ATTRIBUTE_CODE VARCHAR2 (30)
Caode of the attribute to be used in the query execution
ATTRIBUTE_VALUE VARCHAR2 (240)
character value of the query attribute
ATTRIBUTE_VALUE_NUMBER NUMBER

numeric value of the query attribute

[top of page]

FTE.FTE_SEL_ATTRIBUTES_TMP does not reference any database object

FTE.FTE_SEL_ATTRIBUTES_TMP is referenced by following:

FTE
VIEW - FTE_SEL_ATTRIBUTES_TMP#

[top of page]

Table: FTE_SEL_GROUPS

Description: This table is used define groups which are used to consolidate rules to an entity such as a customer, customer site , shipping organization or shipping enterprise. The assignation of groups to entities is done via the FTE_SEL_GROUP_ASSIGNME
Primary Key: FTE_SEL_GROUPS_PK1
  1. GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_GROUPS.OBJECT_ID FTE_SEL_OBJECTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SEL_GROUP_ATTRIBUTES.GROUP_ID FTE_SEL_GROUPS
FTE_SEL_GROUP_ASSIGNMENTS.GROUP_ID FTE_SEL_GROUPS
FTE_SEL_RULES.GROUP_ID FTE_SEL_GROUPS
Comments

This table is used define groups which are used to consolidate rules to an entity such as a customer, customer site , shipping organization or shipping enterprise. The assignation of groups to entities is done via the FTE_SEL_GROUP_ASSIGNMENTS table. This table maintains header level information about the group such as name, the object associated, start and expiry dates. The assigned_flag column indicated which type of entity the group is assigned to.

Indexes
Index Type Tablespace Column
FTE_SEL_GROUPS_U1 UNIQUE APPS_TS_TX_IDX NAME
OBJECT_ID
FTE_SEL_GROUPS_U2 UNIQUE APPS_TS_TX_IDX GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Y primary key for the table
NAME VARCHAR2 (30) Y name of the group
DESCRIPTION VARCHAR2 (240)
description of the group use
OBJECT_ID NUMBER
Y object that the group belongs to. Foreign key to FTE_SEL_OBJECTS
START_DATE DATE

date the group becomes effective
END_DATE DATE

date the group becomes obsolete
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ASSIGNED_FLAG VARCHAR2 (1)
Indicates group assignment, values �N� - Not Assigned, 'O' - Organization, 'C' - Customer, 'S' - Customer Site, Null - Enterprise
GROUP_STATUS_FLAG VARCHAR2 (1)
Indicates if the group is in Draft (D) or Active (A) status
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Attribute15

[top of page]

FTE.FTE_SEL_GROUPS does not reference any database object

FTE.FTE_SEL_GROUPS is referenced by following:

FTE
VIEW - FTE_SEL_GROUPS#

[top of page]

Table: FTE_SEL_GROUP_ASSIGNMENTS

Description: this table provides the method to assign entities such as customer, customer site, shipping organization, etc... to a group or groups. The shipping enterprise group is not assigned in this table as the shipping enterprise is not defined as
Primary Key: FTE_SEL_GROUP_ASSIGNMENTS_PK1
  1. GROUP_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_GROUP_ASSIGNMENTS.GROUP_ID FTE_SEL_GROUPS
Comments

this table provides the method to assign entities such as customer, customer site, shipping organization, etc... to a group or groups. The shipping enterprise group is not assigned in this table as the shipping enterprise is not defined as an entity itself in the database. Therefore, the assigned flag in the FTE_SEL_GROUPS table with a value of 'E' would associate a group to the shipping enterprise.

Indexes
Index Type Tablespace Column
FTE_SEL_GROUP_ASSIGNMENTS_N1 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_SITE_ID
FTE_SEL_GROUP_ASSIGNMENTS_N2 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_ID
FTE_SEL_GROUP_ASSIGNMENTS_N3 NONUNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
FTE_SEL_GROUP_ASSIGNMENTS_N4 NONUNIQUE APPS_TS_TX_IDX LOCATION_ID
FTE_SEL_GROUP_ASSIGNMENTS_N5 NONUNIQUE APPS_TS_TX_IDX GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ASSIGNMENT_ID NUMBER
Y Primary key for the table
GROUP_ID NUMBER
Y Group identifier for the assignment
CUSTOMER_ID NUMBER

Customer id - populated when a group is assigned to a customer
CUSTOMER_SITE_ID NUMBER

customer site identifier - populated when a group is assigned to a customer site
ORGANIZATION_ID NUMBER

ship from organization identifier - populated when a group is assigned to an organization
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column
LOCATION_ID NUMBER

ship to location identifier for the customer site

[top of page]

FTE.FTE_SEL_GROUP_ASSIGNMENTS does not reference any database object

FTE.FTE_SEL_GROUP_ASSIGNMENTS is referenced by following:

FTE
VIEW - FTE_SEL_GROUP_ASSIGNMENTS#

[top of page]

Table: FTE_SEL_GROUP_ATTRIBUTES

Description: This table provides the method of associating individual attributes defined in FTE_SEL_ATTRIBUTES for a specific object to a group also assigned to the object. Attributes and groups must be associated with the same object in order to be abl
Primary Key: FTE_SEL_GROUP_ATTRIBUTES_PK1
  1. GROUP_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_GROUP_ATTRIBUTES.GROUP_ID FTE_SEL_GROUPS
Comments

This table provides the method of associating individual attributes defined in FTE_SEL_ATTRIBUTES for a specific object to a group also assigned to the object. Attributes and groups must be associated with the same object in order to be able to be assigned together.

Indexes
Index Type Tablespace Column
FTE_SEL_GROUP_ATTRIBUTES_N1 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
FTE_SEL_GROUP_ATTRIBUTES_N2 NONUNIQUE APPS_TS_TX_IDX GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ATTRIBUTE_ID NUMBER
Y Primary key of the table
ATTRIBUTE_ID NUMBER
Y Identifier of the attribute defined for the group Foreign Key to FTE_SEL_ATTRIBUTES
ATTRIBUTE_DEFAULT_VALUE VARCHAR2 (240)
Default value for the group attribute
ATTRIBUTE_UOM_CODE VARCHAR2 (10)
Unit of measure of the group attribute, e.g. Lbs, KG, FT3, Days, etc...
GROUP_ID NUMBER
Y Group identifier that the attribute is assigned to
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column
ATTRIBUTE_NAME VARCHAR2 (30) Y name of the attribute, denormalized

[top of page]

FTE.FTE_SEL_GROUP_ATTRIBUTES does not reference any database object

FTE.FTE_SEL_GROUP_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_SEL_GROUP_ATTRIBUTES#

[top of page]

Table: FTE_SEL_OBJECTS

Description: This table holds object definitions that may use the selection tables and for retrieval of certain information, e.g. defining an object such as 'carrier_selection' allows a rule-based data system for the specific purpose of selection of ca
Primary Key: FTE_SEL_OBJECTS_PK1
  1. OBJECT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SEL_ATTRIBUTES.OBJECT_ID FTE_SEL_OBJECTS
FTE_SEL_GROUPS.OBJECT_ID FTE_SEL_OBJECTS
Comments

This table holds object definitions that may use the selection tables and for retrieval of certain information, e.g. defining an object such as 'carrier_selection' allows a rule-based data system for the specific purpose of selection of carrier information. Defining another object allows the use of the same tables but for a different purpose - accessed via a different code line.

Indexes
Index Type Tablespace Column
FTE_SEL_OBJECTS_U1 UNIQUE APPS_TS_SEED NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER
Y primary key for the table
NAME VARCHAR2 (30) Y Name of the object
DESCRIPTION VARCHAR2 (240)
Description of the object
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column

[top of page]

FTE.FTE_SEL_OBJECTS does not reference any database object

FTE.FTE_SEL_OBJECTS is referenced by following:

FTE
VIEW - FTE_SEL_OBJECTS#

[top of page]

Table: FTE_SEL_RESULTS

Description: This table holds the result header information. Result attributes and values are stored in the FTE_SEL_RESULTS table. A result may have one or more attributes.
Primary Key: FTE_SEL_RESULTS_PK1
  1. RESULT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SEL_RESULT_ATTRIBUTES.RESULT_ID FTE_SEL_RESULTS
FTE_SEL_RESULT_ASSIGNMENTS.RESULT_ID FTE_SEL_RESULTS
Comments

This table holds the result header information. Result attributes and values are stored in the FTE_SEL_RESULTS table. A result may have one or more attributes.

Columns
Name Datatype Length Mandatory Comments
RESULT_ID NUMBER
Y Primary key for the table
NAME VARCHAR2 (30) Y Name of the result
DESCRIPTION VARCHAR2 (240)
Description of the result
ENABLED_FLAG VARCHAR2 (1)
Flag indicating if the rule is enabled (active) or not
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column
RANK NUMBER

Indicates the rank (Precedence) of the result in the result set of a rule

[top of page]

FTE.FTE_SEL_RESULTS does not reference any database object

FTE.FTE_SEL_RESULTS is referenced by following:

FTE
VIEW - FTE_SEL_RESULTS#

[top of page]

Table: FTE_SEL_RESULT_ASSIGNMENTS

Description: This table provides the method of assigning multiple results to multiple rules.
Primary Key: FTE_SEL_RESULT_ASSIGNMENTS_PK1
  1. RESULT_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_RESULT_ASSIGNMENTS.RULE_ID FTE_SEL_RULES
FTE_SEL_RESULT_ASSIGNMENTS.RESULT_ID FTE_SEL_RESULTS
Comments

This table provides the method of assigning multiple results to multiple rules.

Indexes
Index Type Tablespace Column
FTE_SEL_RESULT_ASSIGNMENTS_N1 NONUNIQUE APPS_TS_TX_IDX RULE_ID
Columns
Name Datatype Length Mandatory Comments
RESULT_ASSIGNMENT_ID NUMBER
Y Primary key of the table
RULE_ID NUMBER
Y rule that the result is associated with
RESULT_ID NUMBER
Y result that the rule is associated with
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column

[top of page]

FTE.FTE_SEL_RESULT_ASSIGNMENTS does not reference any database object

FTE.FTE_SEL_RESULT_ASSIGNMENTS is referenced by following:

FTE
VIEW - FTE_SEL_RESULT_ASSIGNMENTS#

[top of page]

Table: FTE_SEL_RESULT_ATTRIBUTES

Description: This table holds attributes and attribute values for specific results. Each result attribute must be assigned to a result.
Primary Key: FTE_SEL_RESULT_ATTRIBUTES_PK1
  1. RESULT_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_RESULT_ATTRIBUTES.RESULT_ID FTE_SEL_RESULTS
Comments

This table holds attributes and attribute values for specific results. Each result attribute must be assigned to a result.

Indexes
Index Type Tablespace Column
FTE_SEL_RESULT_ATTRIBUTES_N1 NONUNIQUE APPS_TS_TX_IDX RESULT_ID
Columns
Name Datatype Length Mandatory Comments
RESULT_ATTRIBUTE_ID NUMBER
Y Primary key for the table
RESULT_ID NUMBER
Y Result that the result attribute is associated with
ATTRIBUTE_CODE VARCHAR2 (30) Y code of the result attribute
ATTRIBUTE_VALUE VARCHAR2 (240) Y value of the result attribute
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column

[top of page]

FTE.FTE_SEL_RESULT_ATTRIBUTES does not reference any database object

FTE.FTE_SEL_RESULT_ATTRIBUTES is referenced by following:

FTE
VIEW - FTE_SEL_RESULT_ATTRIBUTES#

[top of page]

Table: FTE_SEL_RULES

Description: this table holds header level rule information, such as rule id and name. The attributes (or restrictions) that make up the rule are defined in the FTE_SEL_RULE_RESTRICTIONS table.
Primary Key: FTE_SEL_RULES_PK1
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_RULES.GROUP_ID FTE_SEL_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_SEL_RULE_RESTRICTIONS.RULE_ID FTE_SEL_RULES
FTE_SEL_RESULT_ASSIGNMENTS.RULE_ID FTE_SEL_RULES
Comments

this table holds header level rule information, such as rule id and name. The attributes (or restrictions) that make up the rule are defined in the FTE_SEL_RULE_RESTRICTIONS table.

Indexes
Index Type Tablespace Column
FTE_SEL_RULES_U1 UNIQUE APPS_TS_TX_IDX NAME
FTE_SEL_RULES_N1 NONUNIQUE APPS_TS_TX_IDX GROUP_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Y Primary key for the table
NAME VARCHAR2 (30) Y unique name of the rule
GROUP_ID NUMBER
Y group which the rule is associated with
PRECEDENCE NUMBER
Y Precedence/Rank of the rule if more than one rule has the same criteria
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column
SEQUENCE_NUMBER NUMBER

sequence number for display of rules in UI
START_DATE DATE

Effective Start Date
END_DATE DATE

Effective End Date
TYPE VARCHAR2 (30)
For carrier commitment, it's either AMOUNT of PERCENTAGE
FREQUENCY VARCHAR2 (30)
For carrier commitment, duration is saved.
UOM_CODE VARCHAR2 (30)
For carrier commitment, Weight UOM or Currency is saved.

[top of page]

FTE.FTE_SEL_RULES does not reference any database object

FTE.FTE_SEL_RULES is referenced by following:

FTE
VIEW - FTE_SEL_RULES#

[top of page]

Table: FTE_SEL_RULE_RESTRICTIONS

Description: This table holds the arrtibutes that make up a rule. Attributes are grouped by rule_id. It is this table that is queried by the code in order to find a result (defined in FTE_SEL_RESULTS). Rule restriction may be of numeric or character typ
Primary Key: FTE_SEL_RULE_RESTRICTIONS_PK1
  1. RULE_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SEL_RULE_RESTRICTIONS.RULE_ID FTE_SEL_RULES
Comments

This table holds the arrtibutes that make up a rule. Attributes are grouped by rule_id. It is this table that is queried by the code in order to find a result (defined in FTE_SEL_RESULTS). Rule restriction may be of numeric or character types and may be singular in value or a range of values. numeric ranges have a low (from) definition of greater than or equal to and a high (to) definition of less than. charater ranges have a low (from) definition of equal to and a high (to) definition of equal to. For character and numeric single values the data is in the low (from) column with the high (to) column value left as null. Whether an attribute is a single or a range is defined in the FTE_SEL_ATTRIBUTES table.

Indexes
Index Type Tablespace Column
FTE_SEL_RULE_RESTRICTIONS_N1 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_NAME
GROUP_ID
ATTRIBUTE_VALUE_FROM_NUMBER
ATTRIBUTE_VALUE_TO_NUMBER
FTE_SEL_RULE_RESTRICTIONS_N2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_NAME
GROUP_ID
ATTRIBUTE_VALUE_FROM
ATTRIBUTE_VALUE_TO
FTE_SEL_RULE_RESTRICTIONS_N3 NONUNIQUE APPS_TS_TX_IDX RULE_ID
FTE_SEL_RULE_RESTRICTIONS_N4 NONUNIQUE APPS_TS_TX_IDX GROUP_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ATTRIBUTE_ID NUMBER
Y Primary Key to identify rule attribute
RULE_ID NUMBER
Y Rule that the rule attribute is associated with. Foreign Key to FTE_SEL_RULES
ATTRIBUTE_NAME VARCHAR2 (30) Y Name of the rule attribute
ATTRIBUTE_VALUE_FROM VARCHAR2 (240)
Character From value of attribute
ATTRIBUTE_VALUE_TO VARCHAR2 (240)
Character To value of attribute
ATTRIBUTE_VALUE_FROM_NUMBER NUMBER

Number From value of attribute
ATTRIBUTE_VALUE_TO_NUMBER NUMBER

Number To value of attribute
DATA_TYPE VARCHAR2 (1)
Data type of attribute - �C� - character, �N� - number
GROUPING_NUMBER NUMBER

Stores number of attributes in the group (denormalized)
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
GROUP_ID NUMBER

denormalized group identifier that the rule attributes are associated to from fte_sel_rules
RANGE_OVERLAP_FLAG VARCHAR2 (1)
Used for range attribute. Indicates if overlap is allowed. N- No

[top of page]

FTE.FTE_SEL_RULE_RESTRICTIONS does not reference any database object

FTE.FTE_SEL_RULE_RESTRICTIONS is referenced by following:

FTE
VIEW - FTE_SEL_RULE_RESTRICTIONS#

[top of page]

Table: FTE_SHIPMENT_STATUS_DETAILS

Description: Holds the Detail element of the ShipStatus message
Primary Key: FTE_SHIPMENT_STATUS_DETAILS_PK
  1. SHIPMENT_STATUS_DETAIL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FTE_MESSAGE_LOCATION.LOCATION_TO_ID FTE_SHIPMENT_STATUS_DETAILS
FTE_SHIPMENT_STATUS_EXCEPTIONS.DETAIL_ID FTE_SHIPMENT_STATUS_DETAILS
Comments

This table holds the shipment detail portion of the ShowShipment message

Indexes
Index Type Tablespace Column
FTE_SHIPMENT_STATUS_DETAILS_U1 UNIQUE APPS_TS_TX_IDX SHIPMENT_STATUS_DETAIL_ID
FTE_SHIP_STATUS_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
FTE_SHIP_STATUS_DETAILS_N2 NONUNIQUE APPS_TS_TX_IDX DELIVERY_LEG_ID
Columns
Name Datatype Length Mandatory Comments
SHIPMENT_STATUS_DETAIL_ID NUMBER
Y PK
DELIVERY_LEG_ID NUMBER

FK reference to delivery leg
REPORT_DATE DATE

date reported as shown in message
SHIPMENT_STATUS VARCHAR2 (20)
Status
CHANGED_STATUS_DATE DATE

Date the status last changed
DESCRIPTION VARCHAR2 (1000)
description
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
TRANSACTION_ID NUMBER

fk reference to transaction id on shipment headers table
SHIP_UNIT_SEQ NUMBER

ship unit sequence number
SHIP_UNIT_TOTAL NUMBER

ship unit total (highest sequence number)
TRACKING_ID VARCHAR2 (30)
tracking id used in message
TRACKING_ID_TYPE VARCHAR2 (50)
tracking id type

[top of page]

FTE.FTE_SHIPMENT_STATUS_DETAILS does not reference any database object

FTE.FTE_SHIPMENT_STATUS_DETAILS is referenced by following:

FTE
VIEW - FTE_SHIPMENT_STATUS_DETAILS#

[top of page]

Table: FTE_SHIPMENT_STATUS_EXCEPTIONS

Description: This table holds the Exception portion of the ShowShipment message
Primary Key: FTE_SHIPMENT_STATUS_EXCEP_PK
  1. EXCEPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FTE_SHIPMENT_STATUS_EXCEPTIONS.DETAIL_ID FTE_SHIPMENT_STATUS_DETAILS
Comments

This table holds the Exception portion of the ShowShipment message. There is a one to many relationship between FTE_SHIPMENT_STATUS_DETAILS and FTE_SHIPMENT_STATUS_EXCEPTIONS

Indexes
Index Type Tablespace Column
FTE_SHIPMENT_STATUS_EXCEPS_U1 UNIQUE APPS_TS_TX_IDX EXCEPTION_ID
FTE_SHIP_STATUS_EXCEPS_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER
Y PK
EXCEPTION_DATE DATE

Date on which the exception was reported
DETAIL_ID NUMBER
Y FK reference to owning Detail in FTE_SHIPMENT_STATUS_DETAILS
DESCRIPTION VARCHAR2 (2000)
Description
REASON_CODE VARCHAR2 (20)
Reason
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
LADING_QUANTITY NUMBER

Lading Quantity
LADING_QUANTITY_UOM VARCHAR2 (30)
Lading Quantity Unit of Measure
TRANSACTION_ID NUMBER

FK to Transaction ID in shipment status headers

[top of page]

FTE.FTE_SHIPMENT_STATUS_EXCEPTIONS does not reference any database object

FTE.FTE_SHIPMENT_STATUS_EXCEPTIONS is referenced by following:

FTE
VIEW - FTE_SHIPMENT_STATUS_EXCEPTION#

[top of page]

Table: FTE_SHIPMENT_STATUS_HEADERS

Description: This table holds the Main body of the ShowShipment message
Primary Key: FTE_SHIPMENT_STATUS_HEADERS_PK
  1. SHIPMENT_STATUS_ID
Comments

This table holds the Main Body of the ShowShipment message
This table is tied to the FTE_SHIPMENT_STATUS_DETAILS table via a synthetic many to many relationship: Each header has one or many details, although the details may be shared by more than one header. A detail is determined to belong to a header if its report date is on or before the header's generation date and the delivery leg is the same.

Indexes
Index Type Tablespace Column
FTE_SHIPMENT_STATUS_HEADERS_U1 UNIQUE APPS_TS_TX_IDX SHIPMENT_STATUS_ID
FTE_SHIP_STATUS_HEADERS_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
FTE_SHIP_STATUS_HEADERS_N2 NONUNIQUE APPS_TS_TX_IDX DELIVERY_ID
FTE_SHIP_STATUS_HEADERS_N3 NONUNIQUE APPS_TS_TX_IDX DELIVERY_LEG_ID
Columns
Name Datatype Length Mandatory Comments
DELIVERY_ID NUMBER

FK Delivery ID
DELIVERY_LEG_ID NUMBER

Delivery Leg ID. FK to delivery legs
MESSAGE_TYPE VARCHAR2 (10)
Message Type
SHIPMENT_STATUS_ID NUMBER
Y Shipment Status ID, Primary key
CARRIER_NAME VARCHAR2 (30)
Carrier Name
GENERATION_DATE DATE

date this message was generated
STATUS VARCHAR2 (15)
Shipment status
TRACKING_ID VARCHAR2 (30)
Tracking ID number
TRACKING_ID_TYPE VARCHAR2 (50)
Type of Tracking ID number
BILL_OF_LADING VARCHAR2 (60)
Bill of Lading
CARRIER_SERVICE_LEVEL VARCHAR2 (15)
Carrier Service Level
CONTAINER_ID NUMBER

Container ID
CONTAINER_SEAL VARCHAR2 (30)
Seal Code
ARRIVAL_DATE DATE

Arrival Date
RECEIVED_DATE DATE

Received Date
DELIVERY_SCHEDULED_DATE DATE

Scheduled Delivery Date
DEPARTURE_DATE DATE

Departure Date
ESTIMATED_ARRIVAL_DATE DATE

Estimated Arrival Date
ESTIMATED_DEPARTURE_DATE DATE

Estimated Departure Date
BEGIN_LOADING_DATE DATE

Date (Time) Loading began
END_LOADING_DATE DATE

Date (Time) Loading ended
PROMISED_SHIPMENT_DATE DATE

Promised Shipment Date
PROMISED_DELIVERY_DATE DATE

Promised Delivery Date
SHIPPED_DATE DATE

Shipped Date
EXPECTED_SHIPMENT_DATE DATE

Expected Shipment Date
BEGIN_UNLOADING_DATE DATE

Date (Time) Unloading began
END_UNLOADING_DATE DATE

Date (Time) unloading finished
DESCRIPTION VARCHAR2 (2000)
description
FREIGHT_CLASS VARCHAR2 (10)
freight class
HAZARDOUS_MATERIAL VARCHAR2 (30)
Hazardous material class
LOAD_POINT VARCHAR2 (60)
Loading Point
NOTES1 VARCHAR2 (2000)
notes
NOTES2 VARCHAR2 (2000)
notes
NOTES3 VARCHAR2 (2000)
notes
NOTES4 VARCHAR2 (2000)
notes
NOTES5 VARCHAR2 (2000)
notes
NOTES6 VARCHAR2 (2000)
notes
NOTES7 VARCHAR2 (2000)
notes
NOTES8 VARCHAR2 (2000)
notes
NOTES9 VARCHAR2 (2000)
notes
SHIP_UNIT_QUANTITY NUMBER

ship unit quantity
SHIP_UNIT_UOM VARCHAR2 (30)
ship unit quantity Unit of Measure
VOLUME NUMBER

volume
VOLUME_UOM VARCHAR2 (30)
volume unit of measure
WEIGHT NUMBER

weight
WEIGHT_UOM VARCHAR2 (30)
weight unit of measure
ROUTE_ID VARCHAR2 (30)
route id
ROUTE_TYPE VARCHAR2 (15)
Route Type
SHIP_NOTES VARCHAR2 (2000)
Ship Notes
SHIPPER_NUMBER NUMBER

Shipper Number
SHIP_POINT VARCHAR2 (60)
Ship Point
SPECIAL_HANDLING VARCHAR2 (2000)
Special Handling
STOP_NUMBER NUMBER

Stop Number
SHIPPING_METHOD VARCHAR2 (15)
Shipping Method
SHIP_FROM_PARTNER NUMBER

Ship From Partner FK to Partners table
SHIP_TO_PARTNER NUMBER

Ship To Partner FK to Partners table
CARRIER_PARTNER NUMBER

Carrier Partner FK to Partners table
BILL_TO_PARTNER NUMBER

Bill To Partner FK to Partners table
NOTIFY_PARTNER NUMBER

Notify Partner FK to Partners table
HOLD_AT_PARTNER NUMBER

Hold at Partner FK to Partners table
RETURN_TO_PARTNER NUMBER

Return To Partner FK to Partners table
MARK_FOR_PARTNER NUMBER

Mark For Partner FK to Partners table
IMPORTER_PARTNER NUMBER

Importer Partner FK to Partners table
EXPORTER_PARTNER NUMBER

Exporter Partner FK to Partners table
DELIVERY_DETAIL_ID NUMBER

Delivery Detail Id
LICENSE_PLATE_NUMBER VARCHAR2 (30)
License Plate Number
CREATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
REASON_CODE VARCHAR2 (2000)
Reason Code
TRANSACTION_ID NUMBER

Transaction Id the unique identifier for this XML transaction
ACTIVITY_ID NUMBER

Activity ID
VEHICLE_NUMBER VARCHAR2 (35)
Vehicle Number
OPERATOR VARCHAR2 (150)
Operator
CARRIER_REF_NUMBER VARCHAR2 (30)
Carrier Reference Number
WF_ITEM_KEY VARCHAR2 (240)
Workflow Item Key

[top of page]

FTE.FTE_SHIPMENT_STATUS_HEADERS does not reference any database object

FTE.FTE_SHIPMENT_STATUS_HEADERS is referenced by following:

FTE
VIEW - FTE_SHIPMENT_STATUS_HEADERS#

[top of page]

Table: FTE_TARIFF_CARRIERS

Description:
Primary Key: FTE_TARIFF_CARRIERS_PK
  1. TARIFF_NAME
  2. CARRIER_ID
Comments

Captures the relationships between the LTL carrier and the tariffs associated with the carrier.

Indexes
Index Type Tablespace Column
FTE_TARIFF_CARRIERS_N1 NONUNIQUE APPS_TS_TX_IDX TARIFF_NAME
Columns
Name Datatype Length Mandatory Comments
TARIFF_NAME VARCHAR2 (100) Y Tariff Name
CARRIER_ID NUMBER
Y Foreign key for HZ_PARTIES
EFFECTIVE_DATE DATE

Tariff Effective Date
EXPIRY_DATE DATE

Tariff Expiry Date
ACTION_CODE VARCHAR2 (1)
Code for Tariff Action
NEW_EFFECTIVE_DATE DATE

Temp Effective Date
NEW_EXPIRY_DATE DATE

Temp Expiry Date
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER
Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER
Y standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column

[top of page]

FTE.FTE_TARIFF_CARRIERS does not reference any database object

FTE.FTE_TARIFF_CARRIERS is referenced by following:

FTE
VIEW - FTE_TARIFF_CARRIERS#

[top of page]

Table: FTE_TENDER_SNAPSHOT

Description: Stores the snapshot of trip stops while tendering
Comments

Stores the snapshot of trip stops while tendering

Indexes
Index Type Tablespace Column
FTE_TENDER_SNAPSHOT_U1 UNIQUE APPS_TS_TX_IDX LOAD_TENDER_NUMBER
STOP_ID
TRIP_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_VALUE VARCHAR2 (30)
Stores Session Value
LOAD_TENDER_NUMBER NUMBER
Y Stores Load Tender Number
TRIP_ID NUMBER
Y Stores Id of the trip that is getting tendered
STOP_ID NUMBER
Y Stores the stop id of which we are taking the snapshot
TOTAL_WEIGHT NUMBER

Stores total weight at the stop
WEIGHT_UOM VARCHAR2 (3)
Stores weight uom
TOTAL_VOLUME NUMBER

Stored total volume at the stop
VOLUME_UOM VARCHAR2 (3)
Stores volume uom
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER
Y Created By
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATED_BY NUMBER
Y Last updated by
LAST_UPDATE_LOGIN NUMBER

Last update login
PROGRAM_APPLICATION_ID NUMBER

Program application id
PROGRAM_ID NUMBER

Program Id
PROGRAM_UPDATE_DATE DATE

Program update date

[top of page]

FTE.FTE_TENDER_SNAPSHOT does not reference any database object

FTE.FTE_TENDER_SNAPSHOT is referenced by following:

FTE
VIEW - FTE_TENDER_SNAPSHOT#

[top of page]

Table: FTE_TRIPS

Description: This table is use to store transporation trip information
Primary Key: FTE_TRIPS_PK
  1. FTE_TRIP_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_TRIPS_U1 UNIQUE APPS_TS_TX_IDX FTE_TRIP_ID
Columns
Name Datatype Length Mandatory Comments
FTE_TRIP_ID NUMBER
Y Primary Key (Sequence : FTE_TRIPS_S)
NAME VARCHAR2 (30) Y Transportation trip name.
STATUS_CODE VARCHAR2 (30) Y Status of trip. Valid values are OP : Open, IT : In Transit, CL : Closed Based on lookup FTE_TRIP_STATUS.
PRIVATE_TRIP VARCHAR2 (1) Y Y indicates private trip and N indicates public trip.
VALIDATION_REQUIRED VARCHAR2 (1) Y Reserved for future use.
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
REQUEST_ID NUMBER

Enhanced Who column
ATTRIBUTE_CATEGORY VARCHAR2 (150)
structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ROUTE_ID NUMBER

Foreign Key to FTE_ROUTES (Optional). If not null, it suggests an instance of a route.

[top of page]

FTE.FTE_TRIPS does not reference any database object

FTE.FTE_TRIPS is referenced by following:

FTE
VIEW - FTE_TRIPS#

[top of page]

Table: FTE_TRIP_MOVES

Description:
Primary Key: FTE_TRIP_MOVES_PK
  1. TRIP_MOVE_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_TRIP_MOVES_PK UNIQUE APPS_TS_TX_IDX TRIP_MOVE_ID
FTE_TRIP_MOVES_U1 UNIQUE APPS_TS_TX_IDX MOVE_ID
TRIP_ID
FTE_TRIP_MOVES_U2 UNIQUE APPS_TS_TX_IDX MOVE_ID
SEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
TRIP_MOVE_ID NUMBER
Y
MOVE_ID NUMBER
Y
TRIP_ID NUMBER
Y
SEQUENCE_NUMBER NUMBER
Y
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
REQUEST_ID NUMBER

Enhanced Who column
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

FTE.FTE_TRIP_MOVES does not reference any database object

FTE.FTE_TRIP_MOVES is referenced by following:

FTE
VIEW - FTE_TRIP_MOVES#

[top of page]

Table: FTE_TRIP_MOVES_INTERFACE

Description:
Primary Key: FTE_TRIP_MOVES_INTERFACE_PK
  1. TRIP_MOVE_INTERFACE_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_TRIP_MOVES_INTERFACE_PK UNIQUE APPS_TS_INTERFACE TRIP_MOVE_INTERFACE_ID
FTE_TRIP_MOVES_INTERFACE_N1 NONUNIQUE APPS_TS_INTERFACE MOVE_INTERFACE_ID
FTE_TRIP_MOVES_INTERFACE_N2 NONUNIQUE APPS_TS_INTERFACE TRIP_INTERFACE_ID
Columns
Name Datatype Length Mandatory Comments
TRIP_MOVE_INTERFACE_ID NUMBER
Y
TRIP_MOVE_ID NUMBER

MOVE_INTERFACE_ID NUMBER
Y
MOVE_ID NUMBER

TRIP_INTERFACE_ID NUMBER
Y
TRIP_ID NUMBER

SEQUENCE_NUMBER NUMBER
Y
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
REQUEST_ID NUMBER

Enhanced Who column
INTERFACE_ACTION_CODE VARCHAR2 (30)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

FTE.FTE_TRIP_MOVES_INTERFACE does not reference any database object

FTE.FTE_TRIP_MOVES_INTERFACE is referenced by following:

FTE
VIEW - FTE_TRIP_MOVES_INTERFACE#

[top of page]

Table: FTE_VEHICLE_FEATURES

Description: stores additional vehicle features of the Vehicle Type. One Vehicle Type can have more than one rows.
Comments

stores additional vehicle features of the Vehicle Type. One Vehicle Type can have more than one rows.

Indexes
Index Type Tablespace Column
FTE_VEHICLE_FEATURES_PK UNIQUE APPS_TS_TX_IDX VEHICLE_TYPE_FEATURE_ID
FTE_VEHICLE_FEATURES_N1 NONUNIQUE APPS_TS_TX_IDX VEHICLE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
VEHICLE_TYPE_FEATURE_ID NUMBER
Y Primary key of the table created from the sequence FTE_VEHICLE_FEATURES_S
VEHICLE_TYPE_ID NUMBER
Y Vehicle Type Id - foreign key to FTE_VEHICLE_TYPES
VEHICLE_FEATURE_CODE VARCHAR2 (30) Y Lookup Code of the Vehicle Feature
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER
Y User Id who created the vehicle feature
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER
Y User Id who updated the vehicle feature
LAST_UPDATE_LOGIN NUMBER

Login Id who updated the vehicle feature

[top of page]

FTE.FTE_VEHICLE_FEATURES does not reference any database object

FTE.FTE_VEHICLE_FEATURES is referenced by following:

FTE
VIEW - FTE_VEHICLE_FEATURES#

[top of page]

Table: FTE_VEHICLE_TYPES

Description: stores the attributes of Vehicle Type. Inventory Item related attributes are saved in MTL_SYSTEM_ITEMS
Comments

stores the attributes of Vehicle Type. Inventory Item related attributes are saved in MTL_SYSTEM_ITEMS

Indexes
Index Type Tablespace Column
FTE_VEHICLE_TYPES_PK UNIQUE APPS_TS_TX_IDX VEHICLE_TYPE_ID
FTE_VEHICLE_TYPES_U1 UNIQUE APPS_TS_TX_IDX INVENTORY_ITEM_ID
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
VEHICLE_TYPE_ID NUMBER
Y Primary key of the table created from the sequence FTE_VEHICLE_TYPES_S
INVENTORY_ITEM_ID NUMBER
Y ID of the corresponding inventory item(MTL_SYSTEM_ITEMS)
ORGANIZATION_ID NUMBER
Y Organization ID of the corresponding inventory item(MTL_SYSTEM_ITEMS)
VEHICLE_CLASS_CODE VARCHAR2 (30)
Classification of the Vehicle Type
PALLET_FLOOR_SPACE NUMBER

Number of Pallets that can be placed on the Vehicle Floor
PALLET_STACKING_HEIGHT NUMBER

Number of Pallets that can be stacked vertically in the Vehicle
EF_VOLUME_CAP_DIRECT NUMBER

Effective Volume Capacity(Direct Move)
EF_VOLUME_CAP_POOL NUMBER

Effective Volume Capacity(Pool Move)
EF_VOLUME_CAP_ONE_STOP NUMBER

Effective Volume Capacity(One-Stop Move)
EF_VOLUME_CAP_TWO_STOP NUMBER

Effective Volume Capacity(Two-Stop Move)
EF_VOLUME_CAP_TWO_POOL NUMBER

Effective Volume Capacity(Two-Pool Move)
EF_VOLUME_CAP_THREE_POOL NUMBER

Effective Volume Capacity(Three-Pool Move)
USABLE_LENGTH NUMBER

Interior(Usable) Length
USABLE_WIDTH NUMBER

Interior(Usable) Width
USABLE_HEIGHT NUMBER

Interior(Usable) Height
SUSPENSION_TYPE_CODE VARCHAR2 (30)
Suspension Type
TEMPERATURE_CONTROL_CODE VARCHAR2 (30)
Temperature Control
NUMBER_OF_DOORS NUMBER

Total Number of Doors
DOOR_HEIGHT NUMBER

Height of the Largest Door
DOOR_WIDTH NUMBER

Width of the Largest Door
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER
Y User Id who created the vehicle type
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER
Y User Id who updated the vehicle type
LAST_UPDATE_LOGIN NUMBER

Login Id who updated the vehicle type

[top of page]

FTE.FTE_VEHICLE_TYPES does not reference any database object

FTE.FTE_VEHICLE_TYPES is referenced by following:

FTE
VIEW - FTE_VEHICLE_TYPES#

[top of page]

Table: FTE_WSH_TRIPS

Description: This table records many-to-many association between transportation trips and trip segments.
Primary Key: FTE_WSH_TRIPS_PK
  1. WSH_TRIP_ID
  2. FTE_TRIP_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FTE_WSH_TRIPS_U1 UNIQUE APPS_TS_TX_IDX FTE_TRIP_ID
WSH_TRIP_ID
Columns
Name Datatype Length Mandatory Comments
FTE_TRIP_ID NUMBER
Y Foreign Key to FTE_TRIPS.
WSH_TRIP_ID NUMBER
Y Foreign Key to WSH_TRIPS.
SEQUENCE_NUMBER NUMBER

Sequence number of trip segment within a transporation trip.
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
REQUEST_ID NUMBER

Enhanced Who column
ATTRIBUTE_CATEGORY VARCHAR2 (150)
structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

FTE.FTE_WSH_TRIPS does not reference any database object

FTE.FTE_WSH_TRIPS is referenced by following:

FTE
VIEW - FTE_WSH_TRIPS#

[top of page]

View: FTE_PRC_LANE_COMP_UI_V

Comments
View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

FTE_PRC_LANE_COMP_UI_V is the base view for the lane price comparison user interface

Columns
Name Datatype Length Mandatory Comments
ENTITY_ID VARCHAR2 (71)
entity id
PARENT_ENTITY_ID VARCHAR2 (71)
parent entity id
LANE_SCHED_ID VARCHAR2 (71)
lane or schedule id
COMPARISON_REQUEST_ID NUMBER

comparison request id
DELIVERY_ID NUMBER

delivery id
LANE_ID NUMBER

lane_id
SCHEDULE_ID NUMBER

schedule id
ENTITY_NAME VARCHAR2 (4000)
entity name
ITEM_NAME VARCHAR2 (40)
item name
SERVICE_TYPE VARCHAR2 (4000)
Service Type
CONTAINER_TYPE VARCHAR2 (4000)
container type
WEIGHT VARCHAR2 (44)
weight
VOLUME VARCHAR2 (44)
volume
PRICE VARCHAR2 (56)
price
CREATION_DATE DATE

creation date
CREATED_BY NUMBER

created by
LAST_UPDATE_DATE DATE

last update date
LAST_UPDATED_BY NUMBER

last updated by
LAST_UPDATE_LOGIN NUMBER

last update login
PROGRAM_APPLICATION_ID NUMBER

program application id
PROGRAM_ID NUMBER

program id
PROGRAM_UPDATE_DATE DATE

program update date
REQUEST_ID NUMBER

request id

[top of page]

APPS.FTE_PRC_LANE_COMP_UI_V references the following:

APPS
SYNONYM - FTE_FREIGHT_COSTS_TEMP
PACKAGE - FTE_FREIGHT_PRICING_UTIL
SYNONYM - FTE_LANES
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_FREIGHT_COST_TYPES
- MTL_SYSTEM_ITEMS_KFV

APPS.FTE_PRC_LANE_COMP_UI_V is not referenced by any database object

[top of page]

View: FTE_PRC_VIEW_PRICE_UI_V

Comments
View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

FTE_PRC_VIEW_PRICE_UI_V is used as the base view by the View Delivery Leg price ui

Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER

entity id
PARENT_ENTITY_ID NUMBER

parent entity id
DELIVERY_LEG_ID NUMBER

delivery leg id
ENTITY_NAME VARCHAR2 (4000)
entity name
ITEM_NAME VARCHAR2 (40)
item name
CONTAINER_TYPE VARCHAR2 (4000)
container type
WEIGHT VARCHAR2 (44)
weight
VOLUME VARCHAR2 (44)
volume
PRICE VARCHAR2 (56)
price
CREATION_DATE DATE

creation date
CREATED_BY NUMBER

created by
LAST_UPDATE_DATE DATE

last update date
LAST_UPDATED_BY NUMBER

lasy updated by
LAST_UPDATE_LOGIN NUMBER

last update login
PROGRAM_APPLICATION_ID NUMBER

prgram application id
PROGRAM_ID NUMBER

program id
PROGRAM_UPDATE_DATE DATE

program update date
REQUEST_ID NUMBER

request id

[top of page]

APPS.FTE_PRC_VIEW_PRICE_UI_V references the following:

APPS
PACKAGE - FTE_FREIGHT_PRICING_UTIL
SYNONYM - WSH_DELIVERY_ASSIGNMENTS
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_FREIGHT_COSTS
SYNONYM - WSH_FREIGHT_COST_TYPES
SYNONYM - WSH_NEW_DELIVERIES
- MTL_SYSTEM_ITEMS_KFV

APPS.FTE_PRC_VIEW_PRICE_UI_V is not referenced by any database object

[top of page]

View: FTE_PTRK_TOKENS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Store all the tokens for tracking

Columns
Name Datatype Length Mandatory Comments
DELIVERY_LEG_ID NUMBER
Y Delivery leg id
DESTINATION_POSTAL_CODE VARCHAR2 (60)
Destination postal code
DESTINATION_CITY VARCHAR2 (120)
Destination city
DESTINATION_STATE VARCHAR2 (120)
Destination state
DESTINATION_COUNTRY_CODE VARCHAR2 (120)
Destination country code
ORIGIN_POSTAL_CODE VARCHAR2 (60)
Origin postal code
ORIGIN_CITY VARCHAR2 (120)
Origin city
ORIGIN_STATE VARCHAR2 (120)
Origin state
ORIGIN_COUNTRY_CODE VARCHAR2 (120)
Origin country code
SHIP_FROM_DATE VARCHAR2 (19)
Ship from date
SHIP_FROM_YEAR VARCHAR2 (4)
Ship from year
SHIP_FROM_MONTH VARCHAR2 (2)
Ship from month
SHIP_FROM_DAY VARCHAR2 (2)
Ship from day
SHIP_TO_DATE VARCHAR2 (19)
Ship to date
SHIP_TO_YEAR VARCHAR2 (4)
Ship to year
SHIP_TO_MONTH VARCHAR2 (2)
Ship to month
SHIP_TO_DAY VARCHAR2 (2)
Ship to day

[top of page]

APPS.FTE_PTRK_TOKENS_V references the following:

APPS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_LOCATIONS
SYNONYM - WSH_TRIP_STOPS

APPS.FTE_PTRK_TOKENS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract