TripDetails
Retrive details of an existing trip.
Columns
| Name | Type | References | |
| TripId [KEY] | Long |
Trips.Id | |
| TripName | String | ||
| TripNumber | String | ||
| Status | String | ||
| SubStatus | String | ||
| Description | String | ||
| ActiveTravelModes | String | ||
| AirTravelItinerary | String | ||
| AirTravelOption | String | ||
| AirTravelOptionStatus | String | ||
| ApprovalName | String | ||
| ApprovalPath | String | ||
| ApproverDepartmentName | String | ||
| ApproverEmail | String | ||
| ApproverEmployeeNo | String | ||
| ApproverId | String | ||
| ApproverName | String | ||
| ApproverPhotoUrl | String | ||
| ApproverZuid | String | ||
| Attendees | String | ||
| BcyBudgetAmount | Double | ||
| BookingSummary | String | ||
| BudgetAmount | Double | ||
| BudgetBcyAmount | Double | ||
| BudgetCurrencyCode | String | ||
| BudgetCurrencyId | String | ||
| BudgetExchangeRate | Double | ||
| BudgetPricePrecision | Integer | ||
| BudgetAmount | Double | ||
| BudgetId | String | ||
| BusTravelItinerary | String | ||
| BusTravelOption | String | ||
| BusTravelOptionStatus | String | ||
| BusinessPurpose | String | ||
| CanCancel | Boolean | ||
| CanCreateTransactions | Boolean | ||
| CanOtherTravelersAssociateReport | Boolean | ||
| CanSelectOptions | Boolean | ||
| CanUploadTickets | Boolean | ||
| CarRentalItinerary | String | ||
| CarRentalOption | String | ||
| CarRentalOptionStatus | String | ||
| ClosedDate | String | ||
| ClosedTime | String | ||
| Comments | String | ||
| CreatedByEmail | String | ||
| CreatedByEmployeeNo | String | ||
| CreatedById | String | ||
| CreatedByName | String | ||
| CreatedByZuid | String | ||
| CreatedDate | Date | ||
| CreatedTime | Datetime | ||
| CreatorPhotoUrl | String | ||
| CurrencyCode | String | ||
| CurrencyId | String | ||
| CustomFields | String | ||
| CustomerId | String | ||
| CustomerName | String | ||
| DepartmentId | String | ||
| DepartmentName | String | ||
| Departure | String | ||
| DestinationCity | String | ||
| DestinationCountry | String | ||
| DestinationCountryCode | String | ||
| DestinationState | String | ||
| Documents | String | ||
| EmployeeNumber | String | ||
| EndDate | Date | ||
| ExchangeRate | Double | ||
| FerryOptionStatus | String | ||
| FerryTravelItinerary | String | ||
| FerryTravelOption | String | ||
| FromSource | String | ||
| HotelReservationItinerary | String | ||
| HotelReservationOption | String | ||
| HotelReservationOptionStatus | String | ||
| IsArchived | Boolean | ||
| IsBillable | Boolean | ||
| IsInternational | Boolean | ||
| IsRoundTrip | Boolean | ||
| IsSharedTrip | Boolean | ||
| IsVisaRequired | Boolean | ||
| Itineraries | String | ||
| LastModifiedTime | Datetime | ||
| LastSubmittedDate | Date | ||
| LineItems | String | ||
| MealPreference | String | ||
| NextApproverEmail | String | ||
| NextApproverId | String | ||
| NextApproverName | String | ||
| NextApproverZuid | String | ||
| NoteToApprover | String | ||
| Notes | String | ||
| OtherItinerary | String | ||
| OtherItineraryOptionStatus | String | ||
| OtherOption | String | ||
| OtherTravellers | String | ||
| PolicyCurrencyCode | String | ||
| PolicyCurrencyId | String | ||
| PolicyDisplayName | String | ||
| PolicyId | String | ||
| PolicyName | String | ||
| PreviousApproverDepartmentName | String | ||
| PreviousApproverEmployeeNo | String | ||
| PreviousApproverId | String | ||
| PreviousApproverName | String | ||
| PreviousApproverZuid | String | ||
| PricePrecision | Integer | ||
| ProjectId | String | ||
| ProjectName | String | ||
| SeatPreference | String | ||
| StartDate | Date | ||
| SubmittedBy | Long | ||
| SubmittedDate | Date | ||
| SubmittedToDepartmentName | String | ||
| SubmittedToEmail | String | ||
| SubmittedToEmployeeNo | String | ||
| SubmittedToId | String | ||
| SubmittedToName | String | ||
| SubmittedToPhotoUrl | String | ||
| SubmittedToZuid | String | ||
| SubmitterDepartmentName | String | ||
| SubmitterEmail | String | ||
| SubmitterEmployeeNo | String | ||
| SubmitterHrUrl | String | ||
| SubmitterName | String | ||
| SubmitterPhotoUrl | String | ||
| TrainTravelItinerary | String | ||
| TrainTravelOption | String | ||
| TrainTravelOptionStatus | String | ||
| TravelDetailsReferenceNumberLabel | String | ||
| TravelDetailsReferenceNumberValue | String | ||
| TravelDocumentsCount | Integer | ||
| TravelType | String | ||
| TripStatuses | String | ||
| TripType | String | ||
| UserDepartmentName | String | ||
| UserEmail | String | ||
| UserEmployeeNo | String | ||
| UserHrUrl | String | ||
| UserId | String | ||
| UserName | String | ||
| UserPhotoUrl | String | ||
| UserZuid | String | ||
| Zuid | String |