vw_functions

A row represents a function, including details of the event, room, venue, attendance, and flash report. Functions can be multi-day — if you want a row for each day, use vw_functions_by_day.

Column	Type	Description
function_id	varchar(64)	Primary Key: System Id of the function
event_id	varchar(64)	Id of the event
event_is_active	tinyint	Is the event active? (Not canceled or lost)
name	varchar(1024)	Name of the function
date	datetime	Date of the function
start_time	datetime	Start time of the function
end_time	datetime	End time of the function
start_date_time	datetime	Start date/time
end_date_time	datetime	End date/time
is_all_day	tinyint	Is the function all day?
number_of_hours	decimal	Length of the function in hours
room_setup	varchar(1024)	Setup of the room
agreed_attendance	int	Agreed attendance of the function
guaranteed_attendance	int	Guaranteed attendance of the function
expected_attendance	int	Expected attendance of the function
show_on_calendar	tinyint	Is the function shown on the calendar?
is_performance	tinyint	Is this a live entertainment performance function?
is_invoiced	tinyint	Is this item already invoiced?
is_event_wide	tinyint	Is this an event-wide function?
is_planning	int	Is it in a planning state?
is_ready	int	Is it in a ready state?
is_canceled	int	Is it canceled?
status_id	int	Id of the status for this function
status_name	varchar(255)	Name of the status for this function
function_type_id	varchar(64)	Id of the type for this function
function_type_name	varchar(512)	Name of the type for this function
room_id	varchar(64)	Id of the room
room_name	varchar(1024)	Name of the room
venue_id	varchar(64)	Id of the venue
venue_name	varchar(1024)	Name of the venue
event_name	varchar(1024)	Name of the event
event_type_id	varchar(64)	Id of the event type
event_type_name	varchar(1024)	Type of event
event_type_master_event_type	int	Master type of event
event_type_is_exhibitor_ordering	tinyint	Does this event type allow exhibitor ordering?
event_type_is_hospitality_ordering	tinyint	Is this a event type for hospitality ordering?
event_type_is_live_entertainment	tinyint	Is this a event type for live entertainment?
event_unique_number	varchar(1024)	Unique number of the event
event_booked_on	datetime	Date the event was booked on
event_created_by_id	varchar(64)	Id of the staff member who created the event
event_created_by_name	varchar(512)	Name of the staff member who created the event
event_created_by_email	varchar(512)	Email address of the staff member who created the event
event_is_tentative	tinyint	Is the event tentative?
event_is_definite	tinyint	Is the event definite?
event_is_prospect	tinyint	Is the event a prospect?
series_id	varchar(64)	Id of the series that it is part of
series_name	varchar(1024)	Name of the series that it is part of
account_id	varchar(64)	Id of the account that it belongs to
account_name	varchar(1024)	Name of the account that it belongs to
event_order_unique_ids	mediumtext	Ids of all event order unique numbers. Comma separated.