vr_Reservation

Updated November 27, 2025 14:45

Field Name	Field Description	Data Type	FK Join
AcceptedBy	Accepted By	nvarchar
AcceptedDate	Accepted Date	datetime
AcceptedReason	Accepted Reason	nvarchar
AcceptedRejectedBy	Rejected By	nvarchar
AcceptedRejectedCancellationDate	Rejected Cancellation Date	datetime
AcceptedRejectedDate	Rejected Date	datetime
AcceptorId	User Id	int	vr_users
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
ArchiveEventId	Archive Event Id	int
Authorized	Indicates if this record is Authorized	bit
AuthorizedSignature	Authorized Signature	nvarchar
CancelDate	Cancel Date	datetime
City	City	nvarchar
Comments	Comments	nvarchar
ContactPerson	Contact Person	nvarchar
Country	Country	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Date	Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Destination	Destination	nvarchar
DriverId	Driver Id	int	vr_Requestor
DriverName	Driver Name	nvarchar
Email	Email	nvarchar
EndDate	End Date	datetime
EventCode	Event Code	nvarchar
EventId	Event Id	int	vr_Event
EventName	Event Name	nvarchar
FaxNumber	Fax Number	nvarchar
FilterCalendar	Indicates if this record filters calendar	bit
Id	Reservation Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Reservation Number	int
Organization	Organization	nvarchar
PaymentOption	Payment Option	smallint
PhoneNumber	Phone Number	nvarchar
RejectedBy	Rejected By	nvarchar
RejectedDate	Rejected Date	datetime
RejectedReason	Rejected Reason	nvarchar
RejectorId	Rejector Id	int	vr_users
RentalId	Rental Id	int
RentalNumber	Rental Number	int
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
ReservationSubTypeCode	Reservation Sub Type Code	nvarchar
ReservationSubTypeDescription	Reservation Sub Type Description	nvarchar
ReservationSubTypeId	Reservation Sub Type Id	int
ReservationTypeCode	Reservation Type Code	nvarchar
ReservationTypeDescription	Reservation Type Description	nvarchar
ReservationTypeId	Reservation Type Id	int
StartDate	Start Date	datetime
State	State	nvarchar
Status	Status	varchar
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
Zip	Zip Code	nvarchar

Articles in this section