Open Trip Expense Line Inquiry (OTLT)

Open Trip Expense Line Inquiry (OTLT) displays all expense lines for trips, scheduled or completed, by document. Information entered on the line level of a Travel Authorization (TE) or Expense Voucher (TP) appears in this table. This includes the accounting distribution, appropriation unit, and expended amounts. It includes expense details such as type, date incurred, and amount. Expenses displayed for TE documents are estimated expenses. Those displayed for TP documents are actual expenses.

The Open Trip Header Inquiries (OTH1, OTH2 and OTH3) display trip information, advance details, and Per Diem expenses respectively. Open Traveler Expense Line Inquiry (OTLX) displays a portion of the expense lines of Travel Authorizations (TE) and Expense Vouchers (TP) by traveler and date, while Open Trip Expense Line Inquiry (OTLT) displays all accounting and expense details for each line of a specific TP or TE. Lines are added to this table when a Travel Authorization (TE) or Expense Voucher (TP) is accepted by MARS, and lines are changed when modifications are submitted on these documents.

  •  
  •  

Traveler ID

Key field. Enter the employee identification number or vendor code that identifies the traveler.

Transaction ID

Key field. Enter the transaction code and number of the Travel Authorization (TE) or Expense Voucher (TP) document.

Line Number

Display only. This field identifies the line number of the Travel Authorization (TE) or Expense Voucher (TP).
Expense Details

Estimate Amount

Display Only. The amount of the estimate for this line on the TE is displayed.

Expense Type

Display only. This field identifies the code given to the particular expense type.

Expense Type Description

Display only. The long name description of the particular expense type.

Expense Amount

Display Only. The amount of the expense for this line on the TP is displayed.

Date

Display only. This field identifies the date the expense was incurred.

Rate/Cap

Display only. This field displays either the mileage rate or expense cap depending upon the expense type selected. Both mileage rate and expense cap are inferred from Travel Policy (TVPL) and the related Rate Schedule (RTSC) table.

Billed Amount

Display only. This field displays the billed amount.

Location

Display only. This field identifies the location code where the expense was incurred by the traveler.

Expense Status

Display only. This field the expense status. Default is [Not Available for Disbursement].

Payment Method

Display only. Indicates whether the expense was/is internally billed or paid out of the traveler's pocket.

Desc

Display only. This field identifies information about this expense.

Internal Bill Status

Display Only. This field indicates whether an IIT has been processed to close internally billed expense lines. Valid values are Billed [B], Unbilled [U], and No bill needed [N].

IIT Number

Display Only. This field contains the IIT transaction number that is used to close internally billed expense lines.

Budget FY

Display only. This field identifies the fiscal year in which the trip is made.
Account Details

Fund, Agency, Org/Sub, Appr Unit, Activity, Function, Object/Sub, Job Number, Project/Sub/Phase, Reporting Category, Termini

Display only. These fields identify the accounting distribution charged for the expenditure for the trip.
Mileage Details

Origin

Display only. Required if expense type is P (POV Mileage). The destination code of the of the starting location for the POV Mileage expense. This will be edited against DEST.

Origin Description

Display only. This field is inferred from the Destination Functionality (DEST) table based on the value of the Origin Code.

Trip

Display only. This field required if expense type is P (POV Mileage). This value is the actual mileage between the origin and destination on the expense line.

Explanation (in necessary)

Display only. Free text explanation of the origin is displayed.

Vicinity

Display only. Entered by the user, this value is the mileage incurred while driving in the vicinity of a destination.

Destination

Display only. Required if expense type is P (POV Mileage). The destination code of the ending location for POV Mileage. This will be edited against DEST.

Destination Description

Display only. This field is inferred from the Destination Functionality (DEST) table based on the value of the Destination Code.

Explanation (if necessary)

Optional. Free text explanation of the destination may be entered if necessary.

Total

Display only. This field identifies the sum of the Trip and Vicinity mileages of this expense line calculated by the system.

Explanation (if necessary)

Optional. Free text explanation of the destination may be entered if necessary.

Calculated

Display only. This field identifies the official mileage between two destinations inferred from the Point-to-Point (PTOP) table.