vr_Event

Updated November 24, 2025 16:03

Field Name	Field Description	Data Type	FK Join
110AMP	110 Amp	decimal
110Outlets	110 Outlets	int
110VRequired	110 V Required	bit
220AMP	220 Amp	decimal
220Outlets	220 Outlets	int
220VRequired	220 V Required	bit
AcceptedBy	Accepted By	nvarchar
AcceptedDate	Accepted Date	datetime
AcceptedReason	Accepted Reason	nvarchar
AcceptorId	User Id	int	vr_users
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Active	Indicates if the Record is Active or Not	bit
AlcoholCost	Alcohol Cost	decimal
AttendantRequired	Attendant Required	bit
BarSetupRequired	Bar Setup Required	bit
BartenderQuantity	Bartender Quantity	int
BartenderRequired	Bartender Required	bit
BeerType	Beer Type	nvarchar
BeerWineRequested	Beer Wine Requested	bit
BudVaseRequired	Bud Vase Required	bit
BuffetCenterPieceRequired	Buffet Center Piece Required	bit
CancelDate	Cancel Date	datetime
ChalkBoardQuantity	Chalk Board Quantity	int
ChalkBoardRequired	Chalk Board Required	bit
ChinaRequired	China Required	bit
ClothRectangleTableQuantity	Cloth Rectangle Table Quantity	int
ClothRoundTableQuantity	Cloth Round Table Quantity	int
CoatRacksQuantity	Coat Racks Quantity	int
CoatRacksRequired	Coat Racks Required	bit
Code	Event Code	nvarchar
Comment	Comments	nvarchar
Convertable	Convertable	bit
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Event Description	nvarchar
DesiredTemperature	Desired Temperature	decimal
EmailAddress	Email Address	nvarchar
EndDate	End Date	datetime
EstimateAttendees	Estimate Attendees	int
EstimatedFoodTotalCost	Estimated Food Total Cost	decimal
EstimatedTotalCost	Estimated Total Cost	decimal
EstimateServings	Estimate Servings	int
EventCode	Event Code	nvarchar
EventId	Event Id	int
EventSubTypeCode	Event SubType Code	nvarchar
EventSubTypeDescription	Event SubType Description	nvarchar
EventSubTypeId	Event SubType Id	int
EventTypeCode	Event Type Code	nvarchar
EventTypeDescription	Event Type Description	nvarchar
EventTypeDisplayColor	Event Type Display Color	nvarchar
EventTypeId	Event Type Id	int	vr_eventType
ExtensionCordRequired	Extension Cord Required	bit
FacilityCost	Facility Cost	decimal
FilterCalendar	Filter Calendar	bit
FlowerPreference	Flower Preference	nvarchar
FoodCaterer	Food Caterer	nvarchar
FoodCost	Food Cost	decimal
FoodInternal	Indicates if the Event is using internal food	bit
FoodRequirement	Food Requirement	nvarchar
FoodServiceDate	Food Service Date	datetime
FoodServiceType	Food Service Type	smallint
FoodSetupDate	Food Setup Date	datetime
HundredAMP	Hundred AMP	decimal
HundredTenOutlets	Hundred Ten Outlets	int
HundredVRequired	Indicates if the Event requires 110 volt	bit
Id	Event Id	int
IsTemplate	Indicates if the Event is a Template	bit
LinenChinaCost	Linen China Cost	decimal
LinenRequired	Linen Required	bit
LinenType	Linen Type	nvarchar
MealServiceType	Meal Service Type	smallint
MediaCost	Media Cost	decimal
MenuRequirement	Menu Requirement	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Event Name	nvarchar
PaperService	Paper Service	bit
PodiumBasketRequired	Podium Basket Required	bit
PrimaryContact	Primary Contact	nvarchar
PrimaryContactFax	Primary Contact Fax	nvarchar
PrimaryContactPhone	Primary Contact Phone	nvarchar
ProjectId	Project Id	int	vr_project
ProjectNumber	Project Number	nvarchar
PurchaseTableCloth	Purchase Table Cloth	bit
RedWine	Red Wine	bit
RejectedBy	Rejected By	nvarchar
RejectedDate	Rejected Date	datetime
RejectedReason	Rejected Reason	nvarchar
RejectorId	User Id (Rejector)	int	vr_users
RequestorEmail	Requestor Email	nvarchar
RequestorFax	Requestor Fax	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
ReservationId	Reservation Id	int	vr_Reservation
ReservationNumber	Reservation Number	int
SecondaryContact	Secondary Contact	nvarchar
SecondaryContactFax	Secondary Contact Fax	nvarchar
SecondaryContactPhone	Secondary Contact Phone	nvarchar
SecurityCost	Security Cost	decimal
SecurityRequired	Security Required	bit
ServingCost	Serving Cost	decimal
SetupHours	Setup Hours	decimal
StaffCost	Staff Cost	decimal
StartDate	Start Date	datetime
State	State	varchar
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
TableCenterPieceRequired	Table Center Piece Required	bit
TableOtherRequirement	Table Other Requirement	nvarchar
TableRectangleQuantity	Table Rectangle Quantity	int
TableRectangleRequired	Table Rectangle Required	bit
TableRoundQuantity	Table Round Quantity	int
TableRoundRequired	Table Round Required	bit
TotalBudget	Total Budget	decimal
TwoTwentyAMP	Two Twenty AMP	decimal
TwoTwentyOutlets	Two Twenty Outlets	int
TwoTwentyVRequired	Indicates if the Event requires 220 volt	bit
WaiterQuantity	Waiter Quantity	int
WaiterRequired	Waiter Required	bit
WhiteWine	White Wine	bit
WineType	Wine Type	nvarchar

Articles in this section