FTE Tables (64)
FTE - Transportation Execution — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
FTE_BULKLOAD_DATA |
12 | This table is used to store data related to download and upload for the Bulkload processing. |
FTE_BULKLOAD_FILE |
20 | This table is used to store data related to download LTL files. |
FTE_DELIVERY_PROOF |
29 | Proof of Delivery Message |
FTE_ESTIMATE_RATES_DEL_TEMP |
3 | |
FTE_FACILITY_CARRIERS |
12 | Stores the data for the association between a Facility location and a Carrier. |
FTE_FAILURE_REASONS |
11 | This table is used to store failure reasons for FPA |
FTE_FREIGHT_COSTS_TEMP |
59 | Stores temporary data for rating estimates |
FTE_FREIGHT_ESTIMATE_TEMP |
18 | |
FTE_INTERFACE_LANES |
13 | Interface table for Lanes. |
FTE_INTERFACE_ZONES |
9 | Interface table for Zones. |
FTE_INVOICE_HEADERS |
55 | Table to store invoice header information |
FTE_INVOICE_HISTORY |
12 | Table to store invoice history information |
FTE_INVOICE_LINES |
30 | Table to store invoice line information |
FTE_LANES |
40 | Stores services catalog lane descriptions. |
FTE_LANE_COMMODITIES |
9 | Stores commodity information for each lane |
FTE_LANE_EQUIPMENTS |
8 | Stores equipment information for each lane |
FTE_LANE_GROUPS |
26 | Stores header information regarding a group of lanes |
FTE_LANE_GROUP_COMPONENTS |
9 | Details table that holds the lane components of a lane group |
FTE_LANE_RATE_CHARTS |
9 | Association between lane and rate charts |
FTE_LANE_SERVICES |
8 | Stores service information for each lane |
FTE_LANE_VEHICLES |
17 | Stores the Vehicle associated to Lanes and Lane Groups |
FTE_LOCATION_MILEAGES |
16 | This table is used to store the distance and transit times between two locations (origin and destination), where the locations are identifie |
FTE_LOCATION_PARAMETERS |
92 | Stores Facility definition and it's parameters. |
FTE_MESSAGE_ADDRESS |
46 | Stores Addresses listed in tracking messages |
FTE_MESSAGE_CONTACT |
38 | This stores the contact portion of the showshipstatus message |
FTE_MESSAGE_LOCATION |
24 | Stores all the locations mentioned in a shipstatus message |
FTE_MESSAGE_PARTNER |
33 | This table stores all the partners listed in the Shipstatus message |
FTE_MILE_ATTRIBUTES |
19 | The table is used to store the attributes that make up the columns (origin, destination and return) in the download file. E.g. 'CITY', 'STAT |
FTE_MILE_COLUMN_ATTRIBUTES |
21 | This table is used to store the attribute data used for the relevant columns in the download/upload file. |
FTE_MILE_DOWNLOAD_FILES |
17 | 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 th |
FTE_MILE_DOWNLOAD_LINES |
13 | 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 |
FTE_MILE_TEMPLATES |
12 | 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 loadin |
FTE_MILE_TEMPLATE_COLUMNS |
17 | This table is used to store the column data that is used to format the download/upload file. |
FTE_MOVES |
32 | |
FTE_MOVES_INTERFACE |
34 | |
FTE_PRC_PARAMETERS |
20 | Stores pricing parameters |
FTE_PRC_PARAMETER_DEFAULTS |
21 | Stores default values for pricing parameters |
FTE_PTRK_EVENTS |
9 | Table to store tracking events |
FTE_PTRK_PAGES |
16 | Table to store tracking header information |
FTE_PTRK_PARAMS |
12 | Table to store tracking parameter information |
FTE_PTRK_SOURCES |
16 | Table to store tracking type information |
FTE_SCHEDULES |
30 | Stores schedule information for each lane. This is the main catalog entity for schedules |
FTE_SEL_ATTRIBUTES |
14 | This table holds all attribute definitions. Each attribute is linked to an object defined in FTE_SEL_OBJECTS, E.g. an object could be 'Carr |
FTE_SEL_ATTRIBUTES_TMP |
4 | This table provides a temporary storage for input attributes and values that may be used to query the specified object, e.g. 'carrier_select |
FTE_SEL_GROUPS |
29 | This table is used define groups which are used to consolidate rules to an entity such as a customer, customer site , shipping organization |
FTE_SEL_GROUP_ASSIGNMENTS |
11 | this table provides the method to assign entities such as customer, customer site, shipping organization, etc... to a group or groups. The |
FTE_SEL_GROUP_ATTRIBUTES |
11 | This table provides the method of associating individual attributes defined in FTE_SEL_ATTRIBUTES for a specific object to a group also assi |
FTE_SEL_OBJECTS |
8 | This table holds object definitions that may use the selection tables and for retrieval of certain information, e.g. defining an object suc |
FTE_SEL_RESULTS |
10 | This table holds the result header information. Result attributes and values are stored in the FTE_SEL_RESULTS table. A result may have one |
FTE_SEL_RESULT_ASSIGNMENTS |
8 | This table provides the method of assigning multiple results to multiple rules. |
FTE_SEL_RESULT_ATTRIBUTES |
9 | This table holds attributes and attribute values for specific results. Each result attribute must be assigned to a result. |
FTE_SEL_RULES |
15 | this table holds header level rule information, such as rule id and name. The attributes (or restrictions) that make up the rule are defined |
FTE_SEL_RULE_RESTRICTIONS |
16 | 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 orde |
FTE_SHIPMENT_STATUS_DETAILS |
16 | Holds the Detail element of the ShipStatus message |
FTE_SHIPMENT_STATUS_EXCEPTIONS |
13 | This table holds the Exception portion of the ShowShipment message |
FTE_SHIPMENT_STATUS_HEADERS |
78 | This table holds the Main body of the ShowShipment message |
FTE_TARIFF_CARRIERS |
12 | |
FTE_TENDER_SNAPSHOT |
16 | Stores the snapshot of trip stops while tendering |
FTE_TRIPS |
31 | This table is use to store transporation trip information |
FTE_TRIP_MOVES |
29 | |
FTE_TRIP_MOVES_INTERFACE |
33 | |
FTE_VEHICLE_FEATURES |
8 | stores additional vehicle features of the Vehicle Type. One Vehicle Type can have more than one rows. |
FTE_VEHICLE_TYPES |
25 | stores the attributes of Vehicle Type. Inventory Item related attributes are saved in MTL_SYSTEM_ITEMS |
FTE_WSH_TRIPS |
28 | This table records many-to-many association between transportation trips and trip segments. |