API Data Provider - Online Help

Trips

List all existing trips.

Columns

Name Type References
Id [KEY] Long
TripName String
TripNumber String
Status String
SubStatus String
Description String
ApprovedDate Date
ApproverEmail String
ApproverEmployeeNo String
ApproverId String
ApproverName String
ApproverPhotoUrl String
ApproverZuid String
BcyBudgetAmount Double
BudgetAmount Double
BusinessPurpose String
CanOtherTravelersAssociateReport Boolean
CreatedByEmail String
CreatedById String
CreatedByName String
CreatedDate Date
CreatedTime Datetime
CreatorEmployeeNo String
CreatorPhotoUrl String
CurrencyCode String
CurrencyId String
CustomFields String
CustomerId String
CustomerName String
DepartmentId String
DepartmentName String
Departure String
DestinationCity String
DestinationCountry String
DestinationState String
EmployeeNumber String
StartDate Date
EndDate Date
ExchangeRate Double
IsArchived Boolean
IsBillable Boolean
IsInternational Boolean
IsRoundTrip Boolean
IsVisaRequired Boolean
LastModifiedTime Datetime
LastSubmittedDate Date
MealPreference String
Notes String
PolicyDisplayName String
PolicyId String
PolicyName String
PricePrecision Integer
ProjectId String
ProjectName String
ReportsCount Integer
SeatPreference String
SubmittedBy Long
SubmittedDate Date
SubmittedToDepartmentName String
SubmittedToEmail String
SubmittedToEmployeeNo String
SubmittedToId String
SubmittedToName String
SubmitterDepartmentName String
SubmitterEmail String
SubmitterEmployeeNo String
SubmitterName String
SubmitterPhotoUrl String
SubmitterZuid String
UserCustomFields String
UserEmail String
UserId String
UserName String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060.0