vrpt_TravelTrip

Updated February 04, 2026 15:49

Field Name	Field Description	Data Type	FK Join
Id	Travel Trip Id	int
proj_number	Project Number	nvarchar
travelclass_code	Travel Class Code	nvarchar
traveltrp_30Char1	Travel Trip 30 Character 1	nvarchar
traveltrp_30Char2	Travel Trip 30 Character 2	nvarchar
traveltrp_30Char3	Travel Trip 30 Character 3	nvarchar
traveltrp_address1	Address 1	nvarchar
traveltrp_address2	Address 2	nvarchar
traveltrp_city	City	nvarchar
traveltrp_comment	Comment	nvarchar
traveltrp_completionDate	Completion Date	datetime
traveltrp_conference	Indicates if the travel trip is for a conference	bit
traveltrp_country	Country	nvarchar
traveltrp_createdDate	Record Creation Date	datetime
traveltrp_creator_fk	User Id (Record Creator)	int	vr_users
traveltrp_deploymentDate	Deployment Date	datetime
traveltrp_description	Description	nvarchar
traveltrp_destination	Destination	nvarchar
traveltrp_endDate	End Date	datetime
traveltrp_estCompletionDate	Estimated Completion Date	datetime
traveltrp_modifiedDate	Last Modified Date	datetime
traveltrp_modifier_fk	User Id (Record Modifier)	int	vr_users
traveltrp_Number	Travel Trip Number	nvarchar
traveltrp_official	Indicates if the travel trip record is official	bit
traveltrp_pk	Travel Trip Id	int
traveltrp_prepStartDate	Prep Start Date	datetime
traveltrp_reference	Reference	nvarchar
traveltrp_startDate	Start Date	datetime
traveltrp_state	State	nvarchar
traveltrp_travelclass_fk	Travel Class Id	int
traveltrp_tript_fk	Travel Trip Type Id	int	vrpt_travelTripType
traveltrp_zip	Zip	nvarchar
tript_code	Code	nvarchar
tript_pk	Travel Trip Type Id	int	vrpt_travelTripType
tripts_code	Travel Trip Sub Type Code	nvarchar
tripts_pk	Travel Trip Sub Type Id	int

Articles in this section