id Booking Audit Logs
Booking ID
string audit_log_id Booking Audit Logs
Audit Log ID
integer user_id Booking Audit Logs
User ID
string user_contact_id Booking Audit Logs
User Contact ID
string admin_user_id Booking Audit Logs
Admin User ID
string booking_status_id Booking Audit Logs
Booking Status ID
integer user_debtor_number_technical_id Booking Audit Logs
User Debtor Number Technical ID
integer start_date Booking Audit Logs
Booking Start Date
datetime paymentprovider_status_last_modified Booking Audit Logs
Payment Provider Status Last Modified
datetime date_added Booking Audit Logs
Booking Date Added
datetime date_last_modified Booking Audit Logs
Booking Date Last Modified
datetime audit_log_date_added Booking Audit Logs
Audit Log Date Added
datetime user_date_added Booking Audit Logs
User Date Added
datetime user_date_last_modified Booking Audit Logs
User Date Last Modified
datetime user_date_registration_approved Booking Audit Logs
User Date Registration Approved
datetime user_password_last_modified Booking Audit Logs
User Password Last Modified
datetime user_contact_date_added Booking Audit Logs
User Contact Date Added
datetime user_contact_date_last_modified Booking Audit Logs
User Contact Date Last Modified
datetime admin_user_date_lastmodified Booking Audit Logs
Admin User Date Last Modified (Legacy)
datetime admin_user_date_last_modified Booking Audit Logs
Admin User Date Last Modified
datetime type Booking Audit Logs
Booking Type
string paymentmethod Booking Audit Logs
Payment Method
string paymentprovider Booking Audit Logs
Payment Provider
string paymentprovider_status Booking Audit Logs
Payment Provider Status
string remarks Booking Audit Logs
Booking Remarks
string external_remarks Booking Audit Logs
Booking External Remarks
string booking_purchase_order_code Booking Audit Logs
Booking Purchase Order Code
string booking_display_name Booking Audit Logs
Booking Display Name
string booking_number Booking Audit Logs
Booking Number
string preferred_locale Booking Audit Logs
Preferred Locale
string booking_status_label Booking Audit Logs
Booking Status Label
string booking_status_display_name Booking Audit Logs
Booking Status Display Name
string user_company Booking Audit Logs
User Company
string user_firstname Booking Audit Logs sensible
User First Name
string user_name Booking Audit Logs sensible
User Last Name
string user_full_name Booking Audit Logs sensible
User Full Name
string user_username Booking Audit Logs sensible
User Username
string user_email Booking Audit Logs sensible
User Email
string user_address Booking Audit Logs sensible
User Address
string user_zipcode Booking Audit Logs sensible
User Zipcode
string user_city Booking Audit Logs
User City
string user_country Booking Audit Logs
User Country
string user_telephone_country Booking Audit Logs
User Telephone Country
string user_telephone Booking Audit Logs sensible
User Telephone
string user_registration_source Booking Audit Logs
User Registration Source
string user_company_attn_invoice Booking Audit Logs
User Company Attn Invoice
string user_description Booking Audit Logs
User Description
string user_attn_invoice Booking Audit Logs
User Attn Invoice
string user_address_invoice Booking Audit Logs sensible
User Invoice Address
string user_zipcode_invoice Booking Audit Logs sensible
User Invoice Zipcode
string user_city_invoice Booking Audit Logs
User Invoice City
string user_country_invoice Booking Audit Logs
User Invoice Country
string user_invoice_mail Booking Audit Logs sensible
User Invoice Email
string user_invoice_send_method Booking Audit Logs
User Invoice Send Method
string user_peppol_address_scheme Booking Audit Logs
User Peppol Address Scheme
string user_peppol_address Booking Audit Logs
User Peppol Address
string user_taxnumber Booking Audit Logs
User Tax Number
string user_debtor_number Booking Audit Logs
User Debtor Number
string user_override_purchase_order_code Booking Audit Logs
User Override Purchase Order Code
string user_remarks Booking Audit Logs
User Remarks
string user_password_policy_version Booking Audit Logs
User Password Policy Version
string user_preferred_email_locale Booking Audit Logs
User Preferred Email Locale
string user_freefield_1 Booking Audit Logs
User Free Field 1
string user_freefield_2 Booking Audit Logs
User Free Field 2
string user_freefield_3 Booking Audit Logs
User Free Field 3
string user_freefield_4 Booking Audit Logs
User Free Field 4
string user_freefield_5 Booking Audit Logs
User Free Field 5
string user_freefield_6 Booking Audit Logs
User Free Field 6
string user_freefield_7 Booking Audit Logs
User Free Field 7
string user_freefield_8 Booking Audit Logs
User Free Field 8
string user_freefield_9 Booking Audit Logs
User Free Field 9
string user_freefield_10 Booking Audit Logs
User Free Field 10
string user_contact_email Booking Audit Logs sensible
User Contact Email
string user_contact_firstname Booking Audit Logs sensible
User Contact First Name
string user_contact_name_prefix Booking Audit Logs
User Contact Name Prefix
string user_contact_name Booking Audit Logs sensible
User Contact Last Name
string user_contact_telephone_country Booking Audit Logs
User Contact Telephone Country
string user_contact_telephone_number Booking Audit Logs sensible
User Contact Telephone Number
string user_contact_remarks Booking Audit Logs
User Contact Remarks
string user_contact_registration_source Booking Audit Logs
User Contact Registration Source
string admin_user_username Booking Audit Logs
Admin User Username
string admin_user_firstname Booking Audit Logs
Admin User First Name
string admin_user_name Booking Audit Logs
Admin User Last Name
string admin_user_phone_number Booking Audit Logs
Admin User Phone Number
string admin_user_phone_number_country Booking Audit Logs
Admin User Phone Number Country
string admin_user_locale Booking Audit Logs
Admin User Locale
string admin_user_preferred_planboard_view Booking Audit Logs
Admin User Preferred Planboard View
string admin_user_preferred_planboard_company Booking Audit Logs
Admin User Preferred Planboard Company
string admin_user_preferred_planboard_location Booking Audit Logs
Admin User Preferred Planboard Location
string admin_user_preferred_planboard_court_type Booking Audit Logs
Admin User Preferred Planboard Court Type
string admin_user_preferred_planboard_activity Booking Audit Logs
Admin User Preferred Planboard Activity
string admin_user_preferred_planboard_display Booking Audit Logs
Admin User Preferred Planboard Display
string admin_user_preferred_planboard_layout Booking Audit Logs
Admin User Preferred Planboard Layout
string admin_user_preferred_planboard_booking_icons Booking Audit Logs
Admin User Preferred Planboard Booking Icons
string admin_user_visible_allbookings_columns Booking Audit Logs
Admin User Visible All Bookings Columns
string booking_status Booking Audit Logs
Booking Status
integer user_registration_status Booking Audit Logs
User Registration Status
integer user_invoice_paymentcondition_days Booking Audit Logs
User Invoice Payment Condition Days
integer admin_user_level Booking Audit Logs
Admin User Level
integer exclude_from_narrowcasting Booking Audit Logs
Exclude From Narrowcasting
boolean booking_status_visible Booking Audit Logs
Booking Status Visible
boolean booking_status_sticky Booking Audit Logs
Booking Status Sticky
boolean user_archived Booking Audit Logs
User Archived
boolean user_pass_changeable Booking Audit Logs
User Password Changeable
boolean user_newsletter_subscription Booking Audit Logs
User Newsletter Subscription
boolean user_access_code_reminder_subscription Booking Audit Logs
User Access Code Reminder Subscription
boolean user_exclude_bookings_from_narrowcasting Booking Audit Logs
User Exclude Bookings From Narrowcasting
boolean user_is_deleted Booking Audit Logs
User Is Deleted
boolean user_contact_archived Booking Audit Logs
User Contact Archived
boolean admin_user_is_supervisor Booking Audit Logs
Admin User Is Supervisor
boolean admin_user_display_new_admin_layout Booking Audit Logs
Admin User Display New Admin Layout
boolean admin_user_sidebar_minified_view Booking Audit Logs
Admin User Sidebar Minified View
boolean admin_user_venueroo_notice_dismissed Booking Audit Logs
Admin User Venueroo Notice Dismissed
boolean admin_user_aqqo_information_sent Booking Audit Logs
Admin User Aqqo Information Sent
boolean admin_user_aqqo_notification_read Booking Audit Logs
Admin User Aqqo Notification Read
boolean admin_user_is_deleted Booking Audit Logs
Admin User Is Deleted
boolean label Booking Statuses
Label
string display_name Booking Statuses
Display Name
string visible Booking Statuses
Visible
boolean sticky Booking Statuses
Sticky
boolean id Booking Subbookings
Booking ID
string subbooking_id Booking Subbookings
Subbooking ID
string user_id Booking Subbookings
User ID
string user_contact_id Booking Subbookings
User Contact ID
string admin_user_id Booking Subbookings
Admin User ID
string court_room_setup_id Booking Subbookings
Court Room Setup ID
integer user_debtor_number_technical_id Booking Subbookings
User Debtor Number Technical ID
integer start_date Booking Subbookings
Booking Start Date
datetime paymentprovider_status_last_modified Booking Subbookings
Payment Provider Status Last Modified
datetime date_added Booking Subbookings
Booking Date Added
datetime date_last_modified Booking Subbookings
Booking Date Last Modified
datetime subbooking_date Booking Subbookings
Subbooking Date
datetime subbooking_start_datetime_utc Booking Subbookings
Subbooking Start Datetime UTC
datetime subbooking_start_datetime Booking Subbookings
Subbooking Start Datetime
datetime subbooking_end_datetime_utc Booking Subbookings
Subbooking End Datetime UTC
datetime subbooking_end_datetime Booking Subbookings
Subbooking End Datetime
datetime subbooking_option_expiration_datetime_utc Booking Subbookings
Subbooking Option Expiration Datetime UTC
datetime subbooking_date_added Booking Subbookings
Subbooking Date Added
datetime subbooking_date_last_modified Booking Subbookings
Subbooking Date Last Modified
datetime user_date_added Booking Subbookings
User Date Added
datetime user_date_last_modified Booking Subbookings
User Date Last Modified
datetime user_date_registration_approved Booking Subbookings
User Date Registration Approved
datetime user_password_last_modified Booking Subbookings
User Password Last Modified
datetime user_contact_date_added Booking Subbookings
User Contact Date Added
datetime user_contact_date_last_modified Booking Subbookings
User Contact Date Last Modified
datetime admin_user_date_lastmodified Booking Subbookings
Admin User Date Last Modified (Legacy)
datetime admin_user_date_last_modified Booking Subbookings
Admin User Date Last Modified
datetime type Booking Subbookings
Booking Type
string paymentmethod Booking Subbookings
Payment Method
string paymentprovider Booking Subbookings
Payment Provider
string paymentprovider_status Booking Subbookings
Payment Provider Status
string remarks Booking Subbookings
Booking Remarks
string external_remarks Booking Subbookings
Booking External Remarks
string booking_purchase_order_code Booking Subbookings
Booking Purchase Order Code
string booking_display_name Booking Subbookings
Booking Display Name
string booking_number Booking Subbookings
Booking Number
string preferred_locale Booking Subbookings
Preferred Locale
string subbooking_starttime Booking Subbookings
Subbooking Start Time
string subbooking_endtime Booking Subbookings
Subbooking End Time
string subbooking_activity_display_name Booking Subbookings
Subbooking Activity Display Name
string subbooking_purchase_order_code Booking Subbookings
Subbooking Purchase Order Code
string subbooking_remarks Booking Subbookings
Subbooking Remarks
string subbooking_external_remarks Booking Subbookings
Subbooking External Remarks
string subbooking_display_name Booking Subbookings
Subbooking Display Name
string subbooking_creation_source Booking Subbookings
Subbooking Creation Source
string court_display_name Booking Subbookings
Court Display Name
string subbooking_external_court_display_name Booking Subbookings
Subbooking External Court Display Name
string subbooking_freefield_1 Booking Subbookings
Subbooking Free Field 1
string subbooking_freefield_2 Booking Subbookings
Subbooking Free Field 2
string subbooking_freefield_3 Booking Subbookings
Subbooking Free Field 3
string subbooking_freefield_4 Booking Subbookings
Subbooking Free Field 4
string subbooking_freefield_5 Booking Subbookings
Subbooking Free Field 5
string subbooking_freefield_6 Booking Subbookings
Subbooking Free Field 6
string subbooking_freefield_7 Booking Subbookings
Subbooking Free Field 7
string subbooking_freefield_8 Booking Subbookings
Subbooking Free Field 8
string subbooking_freefield_9 Booking Subbookings
Subbooking Free Field 9
string subbooking_freefield_10 Booking Subbookings
Subbooking Free Field 10
string user_company Booking Subbookings
User Company
string user_firstname Booking Subbookings sensible
User First Name
string user_name Booking Subbookings sensible
User Last Name
string user_full_name Booking Subbookings sensible
User Full Name
string user_username Booking Subbookings sensible
User Username
string user_email Booking Subbookings sensible
User Email
string user_address Booking Subbookings sensible
User Address
string user_zipcode Booking Subbookings sensible
User Zipcode
string user_city Booking Subbookings
User City
string user_country Booking Subbookings
User Country
string user_telephone_country Booking Subbookings
User Telephone Country
string user_telephone Booking Subbookings sensible
User Telephone
string user_registration_source Booking Subbookings
User Registration Source
string user_company_attn_invoice Booking Subbookings
User Company Attn Invoice
string user_description Booking Subbookings
User Description
string user_attn_invoice Booking Subbookings
User Attn Invoice
string user_address_invoice Booking Subbookings sensible
User Invoice Address
string user_zipcode_invoice Booking Subbookings sensible
User Invoice Zipcode
string user_city_invoice Booking Subbookings
User Invoice City
string user_country_invoice Booking Subbookings
User Invoice Country
string user_invoice_mail Booking Subbookings sensible
User Invoice Email
string user_invoice_send_method Booking Subbookings
User Invoice Send Method
string user_peppol_address_scheme Booking Subbookings
User Peppol Address Scheme
string user_peppol_address Booking Subbookings
User Peppol Address
string user_taxnumber Booking Subbookings
User Tax Number
string user_debtor_number Booking Subbookings
User Debtor Number
string user_override_purchase_order_code Booking Subbookings
User Override Purchase Order Code
string user_remarks Booking Subbookings
User Remarks
string user_password_policy_version Booking Subbookings
User Password Policy Version
string user_preferred_email_locale Booking Subbookings
User Preferred Email Locale
string user_freefield_1 Booking Subbookings
User Free Field 1
string user_freefield_2 Booking Subbookings
User Free Field 2
string user_freefield_3 Booking Subbookings
User Free Field 3
string user_freefield_4 Booking Subbookings
User Free Field 4
string user_freefield_5 Booking Subbookings
User Free Field 5
string user_freefield_6 Booking Subbookings
User Free Field 6
string user_freefield_7 Booking Subbookings
User Free Field 7
string user_freefield_8 Booking Subbookings
User Free Field 8
string user_freefield_9 Booking Subbookings
User Free Field 9
string user_freefield_10 Booking Subbookings
User Free Field 10
string user_contact_email Booking Subbookings sensible
User Contact Email
string user_contact_firstname Booking Subbookings sensible
User Contact First Name
string user_contact_name_prefix Booking Subbookings
User Contact Name Prefix
string user_contact_name Booking Subbookings sensible
User Contact Last Name
string user_contact_telephone_country Booking Subbookings
User Contact Telephone Country
string user_contact_telephone_number Booking Subbookings sensible
User Contact Telephone Number
string user_contact_remarks Booking Subbookings
User Contact Remarks
string user_contact_registration_source Booking Subbookings
User Contact Registration Source
string admin_user_username Booking Subbookings
Admin User Username
string admin_user_firstname Booking Subbookings
Admin User First Name
string admin_user_name Booking Subbookings
Admin User Last Name
string admin_user_phone_number Booking Subbookings
Admin User Phone Number
string admin_user_phone_number_country Booking Subbookings
Admin User Phone Number Country
string admin_user_locale Booking Subbookings
Admin User Locale
string admin_user_preferred_planboard_view Booking Subbookings
Admin User Preferred Planboard View
string admin_user_preferred_planboard_company Booking Subbookings
Admin User Preferred Planboard Company
string admin_user_preferred_planboard_location Booking Subbookings
Admin User Preferred Planboard Location
string admin_user_preferred_planboard_court_type Booking Subbookings
Admin User Preferred Planboard Court Type
string admin_user_preferred_planboard_activity Booking Subbookings
Admin User Preferred Planboard Activity
string admin_user_preferred_planboard_display Booking Subbookings
Admin User Preferred Planboard Display
string admin_user_preferred_planboard_layout Booking Subbookings
Admin User Preferred Planboard Layout
string admin_user_preferred_planboard_booking_icons Booking Subbookings
Admin User Preferred Planboard Booking Icons
string admin_user_visible_allbookings_columns Booking Subbookings
Admin User Visible All Bookings Columns
string booking_status Booking Subbookings
Booking Status
integer court_start_slot Booking Subbookings
Court Start Slot
integer court_number_of_slots Booking Subbookings
Court Number of Slots
integer subbooking_participants Booking Subbookings
Subbooking Participants
integer subbooking_sort_order Booking Subbookings
Subbooking Sort Order
integer subbooking_costs Booking Subbookings
Subbooking Costs
float subbooking_price_incl_vat Booking Subbookings
Subbooking Price Incl VAT
float subbooking_price_excl_vat Booking Subbookings
Subbooking Price Excl VAT
float subbooking_price_vat Booking Subbookings
Subbooking Price VAT
float user_registration_status Booking Subbookings
User Registration Status
integer user_invoice_paymentcondition_days Booking Subbookings
User Invoice Payment Condition Days
integer admin_user_level Booking Subbookings
Admin User Level
integer exclude_from_narrowcasting Booking Subbookings
Exclude From Narrowcasting
boolean subbooking_exclusive Booking Subbookings
Subbooking Exclusive
boolean subbooking_is_manual_price Booking Subbookings
Subbooking Is Manual Price
boolean subbooking_is_manually_overwritten Booking Subbookings
Subbooking Is Manually Overwritten
boolean subbooking_is_locked Booking Subbookings
Subbooking Is Locked
boolean user_archived Booking Subbookings
User Archived
boolean user_pass_changeable Booking Subbookings
User Password Changeable
boolean user_newsletter_subscription Booking Subbookings
User Newsletter Subscription
boolean user_access_code_reminder_subscription Booking Subbookings
User Access Code Reminder Subscription
boolean user_exclude_bookings_from_narrowcasting Booking Subbookings
User Exclude Bookings From Narrowcasting
boolean user_is_deleted Booking Subbookings
User Is Deleted
boolean user_contact_archived Booking Subbookings
User Contact Archived
boolean admin_user_is_supervisor Booking Subbookings
Admin User Is Supervisor
boolean admin_user_display_new_admin_layout Booking Subbookings
Admin User Display New Admin Layout
boolean admin_user_sidebar_minified_view Booking Subbookings
Admin User Sidebar Minified View
boolean admin_user_venueroo_notice_dismissed Booking Subbookings
Admin User Venueroo Notice Dismissed
boolean admin_user_aqqo_information_sent Booking Subbookings
Admin User Aqqo Information Sent
boolean admin_user_aqqo_notification_read Booking Subbookings
Admin User Aqqo Notification Read
boolean admin_user_is_deleted Booking Subbookings
Admin User Is Deleted
boolean user_contact_id Bookings
User Contact ID
string admin_user_id Bookings
Admin User ID
string user_debtor_number_technical_id Bookings
User Debtor Number Technical ID
integer start_date Bookings
Start Date
datetime paymentprovider_status_last_modified Bookings
Payment Provider Status Last Modified
datetime date_added Bookings
Date Added
datetime date_last_modified Bookings
Date Last Modified
datetime user_date_added Bookings
User Date Added
datetime user_date_last_modified Bookings
User Date Last Modified
datetime user_date_registration_approved Bookings
User Date Registration Approved
datetime user_password_last_modified Bookings
User Password Last Modified
datetime user_contact_date_added Bookings
User Contact Date Added
datetime user_contact_date_last_modified Bookings
User Contact Date Last Modified
datetime admin_user_date_lastmodified Bookings
Admin User Date Last Modified (Legacy)
datetime admin_user_date_last_modified Bookings
Admin User Date Last Modified
datetime paymentmethod Bookings
Payment Method
string paymentprovider Bookings
Payment Provider
string paymentprovider_status Bookings
Payment Provider Status
string external_remarks Bookings
External Remarks
string booking_purchase_order_code Bookings
Booking Purchase Order Code
string booking_display_name Bookings
Booking Display Name
string booking_number Bookings
Booking Number
string preferred_locale Bookings
Preferred Locale
string user_company Bookings
User Company
string user_firstname Bookings sensible
User First Name
string user_name Bookings sensible
User Last Name
string user_full_name Bookings sensible
User Full Name
string user_username Bookings sensible
User Username
string user_email Bookings sensible
User Email
string user_address Bookings sensible
User Address
string user_zipcode Bookings sensible
User Zipcode
string user_city Bookings
User City
string user_country Bookings
User Country
string user_telephone_country Bookings
User Telephone Country
string user_telephone Bookings sensible
User Telephone
string user_registration_source Bookings
User Registration Source
string user_company_attn_invoice Bookings
User Company Attn Invoice
string user_description Bookings
User Description
string user_attn_invoice Bookings
User Attn Invoice
string user_address_invoice Bookings sensible
User Invoice Address
string user_zipcode_invoice Bookings sensible
User Invoice Zipcode
string user_city_invoice Bookings
User Invoice City
string user_country_invoice Bookings
User Invoice Country
string user_invoice_mail Bookings sensible
User Invoice Email
string user_invoice_send_method Bookings
User Invoice Send Method
string user_peppol_address_scheme Bookings
User Peppol Address Scheme
string user_peppol_address Bookings
User Peppol Address
string user_taxnumber Bookings
User Tax Number
string user_debtor_number Bookings
User Debtor Number
string user_override_purchase_order_code Bookings
User Override Purchase Order Code
string user_remarks Bookings
User Remarks
string user_password_policy_version Bookings
User Password Policy Version
string user_preferred_email_locale Bookings
User Preferred Email Locale
string user_freefield_1 Bookings
User Free Field 1
string user_freefield_2 Bookings
User Free Field 2
string user_freefield_3 Bookings
User Free Field 3
string user_freefield_4 Bookings
User Free Field 4
string user_freefield_5 Bookings
User Free Field 5
string user_freefield_6 Bookings
User Free Field 6
string user_freefield_7 Bookings
User Free Field 7
string user_freefield_8 Bookings
User Free Field 8
string user_freefield_9 Bookings
User Free Field 9
string user_freefield_10 Bookings
User Free Field 10
string user_contact_email Bookings sensible
User Contact Email
string user_contact_firstname Bookings sensible
User Contact First Name
string user_contact_name_prefix Bookings
User Contact Name Prefix
string user_contact_name Bookings sensible
User Contact Last Name
string user_contact_telephone_country Bookings
User Contact Telephone Country
string user_contact_telephone_number Bookings sensible
User Contact Telephone Number
string user_contact_remarks Bookings
User Contact Remarks
string user_contact_registration_source Bookings
User Contact Registration Source
string admin_user_username Bookings
Admin User Username
string admin_user_firstname Bookings
Admin User First Name
string admin_user_name Bookings
Admin User Last Name
string admin_user_phone_number Bookings
Admin User Phone Number
string admin_user_phone_number_country Bookings
Admin User Phone Number Country
string admin_user_locale Bookings
Admin User Locale
string admin_user_preferred_planboard_view Bookings
Admin User Preferred Planboard View
string admin_user_preferred_planboard_company Bookings
Admin User Preferred Planboard Company
string admin_user_preferred_planboard_location Bookings
Admin User Preferred Planboard Location
string admin_user_preferred_planboard_court_type Bookings
Admin User Preferred Planboard Court Type
string admin_user_preferred_planboard_activity Bookings
Admin User Preferred Planboard Activity
string admin_user_preferred_planboard_display Bookings
Admin User Preferred Planboard Display
string admin_user_preferred_planboard_layout Bookings
Admin User Preferred Planboard Layout
string admin_user_preferred_planboard_booking_icons Bookings
Admin User Preferred Planboard Booking Icons
string admin_user_visible_allbookings_columns Bookings
Admin User Visible All Bookings Columns
string booking_status Bookings
Booking Status
integer user_registration_status Bookings
User Registration Status
integer user_invoice_paymentcondition_days Bookings
User Invoice Payment Condition Days
integer admin_user_level Bookings
Admin User Level
integer exclude_from_narrowcasting Bookings
Exclude From Narrowcasting
boolean user_archived Bookings
User Archived
boolean user_pass_changeable Bookings
User Password Changeable
boolean user_newsletter_subscription Bookings
User Newsletter Subscription
boolean user_access_code_reminder_subscription Bookings
User Access Code Reminder Subscription
boolean user_exclude_bookings_from_narrowcasting Bookings
User Exclude Bookings From Narrowcasting
boolean user_is_deleted Bookings
User Is Deleted
boolean user_contact_archived Bookings
User Contact Archived
boolean admin_user_is_supervisor Bookings
Admin User Is Supervisor
boolean admin_user_display_new_admin_layout Bookings
Admin User Display New Admin Layout
boolean admin_user_sidebar_minified_view Bookings
Admin User Sidebar Minified View
boolean admin_user_venueroo_notice_dismissed Bookings
Admin User Venueroo Notice Dismissed
boolean admin_user_aqqo_information_sent Bookings
Admin User Aqqo Information Sent
boolean admin_user_aqqo_notification_read Bookings
Admin User Aqqo Notification Read
boolean admin_user_is_deleted Bookings
Admin User Is Deleted
boolean location_id Companies
Location ID
string location_mail_sender_id Companies
Location Mail Sender ID
integer date_added Companies
Date Added
datetime date_last_modified Companies
Date Last Modified
datetime location_date_added Companies
Location Date Added
datetime location_date_last_modified Companies
Location Date Last Modified
datetime attn Companies sensible
Attention
string vat_code Companies
VAT Code
string kvk_number Companies
KVK Number
string iban_number Companies sensible
IBAN Number
string invoice_contact_phone Companies sensible
Invoice Contact Phone
string invoice_contact_phone_country Companies
Invoice Contact Phone Country
string invoice_contact_email Companies sensible
Invoice Contact Email
string invoice_contact_copy_email Companies sensible
Invoice Contact Copy Email
string invoice_number_prefix Companies
Invoice Number Prefix
string location_name Companies
Location Name
string location_name_nl_NL Companies
Location Name (nl-NL)
string location_name_en_US Companies
Location Name (en-US)
string location_name_de_DE Companies
Location Name (de-DE)
string location_name_fy_NL Companies
Location Name (fy-NL)
string location_name_fr_FR Companies
Location Name (fr-FR)
string location_description Companies
Location Description
string location_description_nl_NL Companies
Location Description (nl-NL)
string location_description_en_US Companies
Location Description (en-US)
string location_description_de_DE Companies
Location Description (de-DE)
string location_description_fy_NL Companies
Location Description (fy-NL)
string location_description_fr_FR Companies
Location Description (fr-FR)
string location_court_alias Companies
Location Court Alias
string location_court_alias_plural Companies
Location Court Alias (Plural)
string location_address Companies
Location Address
string location_zipcode Companies
Location Zip Code
string location_city Companies
Location City
string location_country Companies
Location Country
string location_phone_number Companies sensible
Location Phone Number
string location_phone_number_country Companies
Location Phone Number Country
string location_booking_notification_email Companies sensible
Location Booking Notification Email
string location_divergent_iban_number Companies sensible
Location Divergent IBAN Number
string location_holiday_country Companies
Location Holiday Country
string location_holiday_region Companies
Location Holiday Region
string location_pos_turnover_date_interval Companies
Location POS Turnover Date Interval
string latitude Companies
Latitude
float longitude Companies
Longitude
float invoice_number_leading_zeros Companies
Invoice Number Leading Zeros
integer invoice_start_counter Companies
Invoice Start Counter
integer invoice_payment_condition_days Companies
Invoice Payment Condition Days
integer sort_order Companies
Sort Order
integer location_latitude Companies
Location Latitude
float location_longitude Companies
Location Longitude
float location_sort_order Companies
Location Sort Order
integer invoice_restart_number_annually Companies
Invoice Restart Number Annually
boolean is_deleted Companies
Is Deleted
boolean location_is_deleted Companies
Location Is Deleted
boolean date_added Court Groups
Date Added
datetime date_last_modified Court Groups
Date Last Modified
datetime court_group_display_name Court Groups
Display Name
string court_group_aggregated_for_booking_process Court Groups
Aggregated For Booking Process
boolean court_group_aggregated_for_price_settings Court Groups
Aggregated For Price Settings
boolean court_group_participants_enabled Court Groups
Participants Enabled
boolean court_group_aggregated_for_admin_booking_process Court Groups
Aggregated For Admin Booking Process
boolean court_group_court_tile_enabled Court Groups
Court Tile Enabled
boolean date_added Court Types
Date Added
datetime date_last_modified Court Types
Date Last Modified
datetime display_name Court Types
Display Name
string court_alias Court Types
Court Alias
string court_alias_plural Court Types
Court Alias Plural
string sort_order Court Types
Sort Order
integer location_id Courts
Location ID
string court_group_id Courts
Court Group ID
integer location_mail_sender_id Courts
Location Mail Sender ID
integer date_added Courts
Date Added
datetime date_last_modified Courts
Date Last Modified
datetime location_date_added Courts
Location Date Added
datetime location_date_last_modified Courts
Location Date Last Modified
datetime court_group_date_added Courts
Court Group Date Added
datetime court_group_date_last_modified Courts
Court Group Date Last Modified
datetime court_description Courts
Court Description
string court_group_description Courts
Court Group Description
string document_template_court_group_description Courts
Document Template Court Group Description
string booking_starting_minute Courts
Booking Starting Minute
string freefield_1 Courts
Free Field 1
string freefield_2 Courts
Free Field 2
string freefield_3 Courts
Free Field 3
string freefield_4 Courts
Free Field 4
string freefield_5 Courts
Free Field 5
string freefield_6 Courts
Free Field 6
string freefield_7 Courts
Free Field 7
string freefield_8 Courts
Free Field 8
string freefield_9 Courts
Free Field 9
string freefield_10 Courts
Free Field 10
string location_name Courts
Location Name
string location_name_nl_NL Courts
Location Name (nl-NL)
string location_name_en_US Courts
Location Name (en-US)
string location_name_de_DE Courts
Location Name (de-DE)
string location_name_fy_NL Courts
Location Name (fy-NL)
string location_name_fr_FR Courts
Location Name (fr-FR)
string location_description Courts
Location Description
string location_description_nl_NL Courts
Location Description (nl-NL)
string location_description_en_US Courts
Location Description (en-US)
string location_description_de_DE Courts
Location Description (de-DE)
string location_description_fy_NL Courts
Location Description (fy-NL)
string location_description_fr_FR Courts
Location Description (fr-FR)
string location_court_alias Courts
Location Court Alias
string location_court_alias_plural Courts
Location Court Alias (Plural)
string location_address Courts
Location Address
string location_zipcode Courts
Location Zip Code
string location_city Courts
Location City
string location_country Courts
Location Country
string location_phone_number Courts sensible
Location Phone Number
string location_phone_number_country Courts
Location Phone Number Country
string location_booking_notification_email Courts sensible
Location Booking Notification Email
string location_divergent_iban_number Courts sensible
Location Divergent IBAN Number
string location_holiday_country Courts
Location Holiday Country
string location_holiday_region Courts
Location Holiday Region
string location_pos_turnover_date_interval Courts
Location POS Turnover Date Interval
string court_group_display_name Courts
Court Group Display Name
string minimum_time_per_booking Courts
Minimum Time Per Booking
integer minimum_time_per_booking_calculated Courts
Minimum Time Per Booking (Calculated)
integer minimum_additional_time_per_booking Courts
Minimum Additional Time Per Booking
integer minimum_additional_time_per_booking_calculated Courts
Minimum Additional Time Per Booking (Calculated)
integer maximum_time_per_booking Courts
Maximum Time Per Booking
integer maximum_time_per_booking_calculated Courts
Maximum Time Per Booking (Calculated)
integer blocked_minutes_after_booking Courts
Blocked Minutes After Booking
integer min_co_user_required Courts
Min Co-User Required
integer warning_capacity Courts
Warning Capacity
integer max_capacity Courts
Max Capacity
integer location_latitude Courts
Location Latitude
float location_longitude Courts
Location Longitude
float location_sort_order Courts
Location Sort Order
integer 12_12_slots_configurable Courts
Slots Configurable (12/12)
boolean 6_12_slots_configurable Courts
Slots Configurable (6/12)
boolean 4_12_slots_configurable Courts
Slots Configurable (4/12)
boolean 3_12_slots_configurable Courts
Slots Configurable (3/12)
boolean 2_12_slots_configurable Courts
Slots Configurable (2/12)
boolean 1_12_slots_configurable Courts
Slots Configurable (1/12)
boolean time_restrictions_backend_enabled Courts
Time Restrictions Backend Enabled
boolean co_user_selectable Courts
Co-User Selectable
boolean strict_court_schedule_handling Courts
Strict Court Schedule Handling
boolean force_adjacent_bookings Courts
Force Adjacent Bookings
boolean allow_bookings_over_multiple_days Courts
Allow Bookings Over Multiple Days
boolean capacity_based_court Courts
Capacity Based Court
boolean is_deleted Courts
Is Deleted
boolean location_is_deleted Courts
Location Is Deleted
boolean court_group_aggregated_for_booking_process Courts
Court Group Aggregated For Booking Process
boolean court_group_aggregated_for_price_settings Courts
Court Group Aggregated For Price Settings
boolean court_group_participants_enabled Courts
Court Group Participants Enabled
boolean court_group_aggregated_for_admin_booking_process Courts
Court Group Aggregated For Admin Booking Process
boolean court_group_court_tile_enabled Courts
Court Group Court Tile Enabled
boolean category Export Partners
Category
string level Export Partners
Level
string export_type Export Partners
Export Type
string auth_type Export Partners
Auth Type
string tech_classname Export Partners
Tech Class Name
string enabled Export Partners
Enabled
boolean court_id Locations
Court ID
string company_id Locations
Company ID
string mail_sender_id Locations
Mail Sender ID
integer date_added Locations
Date Added
datetime date_last_modified Locations
Date Last Modified
datetime company_date_added Locations
Company Date Added
datetime company_date_last_modified Locations
Company Date Last Modified
datetime court_date_added Locations
Court Date Added
datetime court_date_last_modified Locations
Court Date Last Modified
datetime name_nl_NL Locations
Name (nl-NL)
string name_en_US Locations
Name (en-US)
string name_de_DE Locations
Name (de-DE)
string name_fy_NL Locations
Name (fy-NL)
string name_fr_FR Locations
Name (fr-FR)
string description Locations
Description
string description_nl_NL Locations
Description (nl-NL)
string description_en_US Locations
Description (en-US)
string description_de_DE Locations
Description (de-DE)
string description_fy_NL Locations
Description (fy-NL)
string description_fr_FR Locations
Description (fr-FR)
string court_alias Locations
Court Alias
string court_alias_plural Locations
Court Alias (Plural)
string phone_number Locations sensible
Phone Number
string phone_number_country Locations
Phone Number Country
string booking_notification_email Locations sensible
Booking Notification Email
string divergent_iban_number Locations sensible
Divergent IBAN Number
string holiday_country Locations
Holiday Country
string holiday_region Locations
Holiday Region
string pos_turnover_date_interval Locations
POS Turnover Date Interval
string company_name Locations
Company Name
string company_attn Locations sensible
Company Attention
string company_address Locations
Company Address
string company_zipcode Locations
Company Zip Code
string company_city Locations
Company City
string company_country Locations
Company Country
string company_vat_code Locations
Company VAT Code
string company_kvk_number Locations
Company KVK Number
string company_iban_number Locations sensible
Company IBAN Number
string company_invoice_contact_phone Locations sensible
Company Invoice Contact Phone
string company_invoice_contact_phone_country Locations
Company Invoice Contact Phone Country
string company_invoice_contact_email Locations sensible
Company Invoice Contact Email
string company_invoice_contact_copy_email Locations sensible
Company Invoice Contact Copy Email
string company_invoice_number_prefix Locations
Company Invoice Number Prefix
string court_name Locations
Court Name
string court_description Locations
Court Description
string court_group_description Locations
Court Group Description
string court_document_template_court_group_description Locations
Court Document Template Group Description
string court_level Locations
Court Level
string court_booking_starting_minute Locations
Court Booking Starting Minute
string court_freefield_1 Locations
Court Free Field 1
string court_freefield_2 Locations
Court Free Field 2
string court_freefield_3 Locations
Court Free Field 3
string court_freefield_4 Locations
Court Free Field 4
string court_freefield_5 Locations
Court Free Field 5
string court_freefield_6 Locations
Court Free Field 6
string court_freefield_7 Locations
Court Free Field 7
string court_freefield_8 Locations
Court Free Field 8
string court_freefield_9 Locations
Court Free Field 9
string court_freefield_10 Locations
Court Free Field 10
string latitude Locations
Latitude
float longitude Locations
Longitude
float sort_order Locations
Sort Order
integer company_latitude Locations
Company Latitude
float company_longitude Locations
Company Longitude
float company_invoice_number_leading_zeros Locations
Company Invoice Number Leading Zeros
integer company_invoice_start_counter Locations
Company Invoice Start Counter
integer company_invoice_payment_condition_days Locations
Company Invoice Payment Condition Days
integer company_sort_order Locations
Company Sort Order
integer court_number Locations
Court Number
integer court_minimum_time_per_booking Locations
Court Minimum Time Per Booking
integer court_minimum_time_per_booking_calculated Locations
Court Minimum Time Per Booking (Calculated)
integer court_minimum_additional_time_per_booking Locations
Court Minimum Additional Time Per Booking
integer court_minimum_additional_time_per_booking_calculated Locations
Court Minimum Additional Time Per Booking (Calculated)
integer court_maximum_time_per_booking Locations
Court Maximum Time Per Booking
integer court_maximum_time_per_booking_calculated Locations
Court Maximum Time Per Booking (Calculated)
integer court_blocked_minutes_after_booking Locations
Court Blocked Minutes After Booking
integer court_min_co_user_required Locations
Court Min Co-User Required
integer court_warning_capacity Locations
Court Warning Capacity
integer court_max_capacity Locations
Court Max Capacity
integer is_deleted Locations
Is Deleted
boolean company_invoice_restart_number_annually Locations
Company Invoice Restart Number Annually
boolean company_is_deleted Locations
Company Is Deleted
boolean court_internal Locations
Court Internal
boolean court_divisible Locations
Court Divisible
boolean court_12_12_slots_configurable Locations
Court Slots Configurable (12/12)
boolean court_6_12_slots_configurable Locations
Court Slots Configurable (6/12)
boolean court_4_12_slots_configurable Locations
Court Slots Configurable (4/12)
boolean court_3_12_slots_configurable Locations
Court Slots Configurable (3/12)
boolean court_2_12_slots_configurable Locations
Court Slots Configurable (2/12)
boolean court_1_12_slots_configurable Locations
Court Slots Configurable (1/12)
boolean court_time_restrictions_backend_enabled Locations
Court Time Restrictions Backend Enabled
boolean court_co_user_selectable Locations
Court Co-User Selectable
boolean court_strict_court_schedule_handling Locations
Court Strict Schedule Handling
boolean court_force_adjacent_bookings Locations
Court Force Adjacent Bookings
boolean court_allow_bookings_over_multiple_days Locations
Court Allow Bookings Over Multiple Days
boolean court_capacity_based_court Locations
Court Capacity Based
boolean court_is_deleted Locations
Court Is Deleted
boolean court_id Opening Hour Courts
Court ID
string row_id Opening Hour Courts
Row ID
integer date_added Opening Hour Courts
Date Added
datetime date_last_modified Opening Hour Courts
Date Last Modified
datetime court_date_added Opening Hour Courts
Court Date Added
datetime court_date_last_modified Opening Hour Courts
Court Date Last Modified
datetime row_date_added Opening Hour Courts
Row Date Added
datetime row_date_last_modified Opening Hour Courts
Row Date Last Modified
datetime display_name_nl_NL Opening Hour Courts
Display Name (nl-NL)
string display_name_en_US Opening Hour Courts
Display Name (en-US)
string display_name_de_DE Opening Hour Courts
Display Name (de-DE)
string display_name_fy_NL Opening Hour Courts
Display Name (fy-NL)
string name Opening Hour Courts
Name
string court_description Opening Hour Courts
Court Description
string court_group_description Opening Hour Courts
Court Group Description
string document_template_court_group_description Opening Hour Courts
Document Template Court Group Description
string level Opening Hour Courts
Level
string booking_starting_minute Opening Hour Courts
Booking Starting Minute
string freefield_1 Opening Hour Courts
Free Field 1
string freefield_2 Opening Hour Courts
Free Field 2
string freefield_3 Opening Hour Courts
Free Field 3
string freefield_4 Opening Hour Courts
Free Field 4
string freefield_5 Opening Hour Courts
Free Field 5
string freefield_6 Opening Hour Courts
Free Field 6
string freefield_7 Opening Hour Courts
Free Field 7
string freefield_8 Opening Hour Courts
Free Field 8
string freefield_9 Opening Hour Courts
Free Field 9
string freefield_10 Opening Hour Courts
Free Field 10
string row_dayname Opening Hour Courts
Row Day Name
string row_user_opening_time Opening Hour Courts
Row User Opening Time
string row_user_closing_time Opening Hour Courts
Row User Closing Time
string row_admin_user_opening_time Opening Hour Courts
Row Admin User Opening Time
string row_admin_user_closing_time Opening Hour Courts
Row Admin User Closing Time
string number Opening Hour Courts
Number
integer minimum_time_per_booking Opening Hour Courts
Minimum Time Per Booking
integer minimum_time_per_booking_calculated Opening Hour Courts
Minimum Time Per Booking (Calculated)
integer minimum_additional_time_per_booking Opening Hour Courts
Minimum Additional Time Per Booking
integer minimum_additional_time_per_booking_calculated Opening Hour Courts
Minimum Additional Time Per Booking (Calculated)
integer maximum_time_per_booking Opening Hour Courts
Maximum Time Per Booking
integer maximum_time_per_booking_calculated Opening Hour Courts
Maximum Time Per Booking (Calculated)
integer blocked_minutes_after_booking Opening Hour Courts
Blocked Minutes After Booking
integer min_co_user_required Opening Hour Courts
Min Co-User Required
integer warning_capacity Opening Hour Courts
Warning Capacity
integer max_capacity Opening Hour Courts
Max Capacity
integer row_day Opening Hour Courts
Row Day
integer internal Opening Hour Courts
Internal
boolean divisible Opening Hour Courts
Divisible
boolean 12_12_slots_configurable Opening Hour Courts
Slots Configurable (12/12)
boolean 6_12_slots_configurable Opening Hour Courts
Slots Configurable (6/12)
boolean 4_12_slots_configurable Opening Hour Courts
Slots Configurable (4/12)
boolean 3_12_slots_configurable Opening Hour Courts
Slots Configurable (3/12)
boolean 2_12_slots_configurable Opening Hour Courts
Slots Configurable (2/12)
boolean 1_12_slots_configurable Opening Hour Courts
Slots Configurable (1/12)
boolean time_restrictions_backend_enabled Opening Hour Courts
Time Restrictions Backend Enabled
boolean co_user_selectable Opening Hour Courts
Co-User Selectable
boolean strict_court_schedule_handling Opening Hour Courts
Strict Court Schedule Handling
boolean force_adjacent_bookings Opening Hour Courts
Force Adjacent Bookings
boolean allow_bookings_over_multiple_days Opening Hour Courts
Allow Bookings Over Multiple Days
boolean capacity_based_court Opening Hour Courts
Capacity Based Court
boolean is_deleted Opening Hour Courts
Is Deleted
boolean row_user_closed Opening Hour Courts
Row User Closed
boolean row_admin_user_closed Opening Hour Courts
Row Admin User Closed
boolean date_added Opening Hour Rows
Date Added
datetime date_last_modified Opening Hour Rows
Date Last Modified
datetime dayname Opening Hour Rows
Day Name
string user_opening_time Opening Hour Rows
User Opening Time
string user_closing_time Opening Hour Rows
User Closing Time
string admin_user_opening_time Opening Hour Rows
Admin User Opening Time
string admin_user_closing_time Opening Hour Rows
Admin User Closing Time
string user_closed Opening Hour Rows
User Closed
boolean admin_user_closed Opening Hour Rows
Admin User Closed
boolean row_id Opening Hours
Row ID
integer date_added Opening Hours
Date Added
datetime date_last_modified Opening Hours
Date Last Modified
datetime row_date_added Opening Hours
Row Date Added
datetime row_date_last_modified Opening Hours
Row Date Last Modified
datetime display_name_nl_NL Opening Hours
Display Name (nl-NL)
string display_name_en_US Opening Hours
Display Name (en-US)
string display_name_de_DE Opening Hours
Display Name (de-DE)
string display_name_fy_NL Opening Hours
Display Name (fy-NL)
string row_dayname Opening Hours
Row Day Name
string row_user_opening_time Opening Hours
Row User Opening Time
string row_user_closing_time Opening Hours
Row User Closing Time
string row_admin_user_opening_time Opening Hours
Row Admin User Opening Time
string row_admin_user_closing_time Opening Hours
Row Admin User Closing Time
string row_day Opening Hours
Row Day
integer row_user_closed Opening Hours
Row User Closed
boolean row_admin_user_closed Opening Hours
Row Admin User Closed
boolean date_added Price Keys
Date Added
datetime date_last_modified Price Keys
Date Last Modified
datetime display_name Price Keys
Display Name
string default_value Price Keys
Default Value
integer preference Price Keys
Preference
integer is_deleted Price Keys
Is Deleted
boolean price_key_id Prices
Price Key ID
integer vatcode_id Prices
Vatcode ID
integer start_date Prices
Start Date
datetime date_added Prices
Date Added
datetime date_last_modified Prices
Date Last Modified
datetime price_key_date_added Prices
Price Key Date Added
datetime price_key_date_last_modified Prices
Price Key Date Last Modified
datetime vatcode_date_added Prices
Vatcode Date Added
datetime vatcode_date_last_modified Prices
Vatcode Date Last Modified
datetime court_date_added Prices
Court Date Added
datetime court_date_last_modified Prices
Court Date Last Modified
datetime price_key_display_name Prices
Price Key Display Name
string vatcode_display_name Prices
Vatcode Display Name
string vatcode_display_name_short Prices
Vatcode Display Name Short
string vatcode_country_code_iso2 Prices
Vatcode Country Code
string vatcode_vat_report_code Prices
Vatcode VAT Report Code
string court_name Prices
Court Name
string court_description Prices
Court Description
string court_group_description Prices
Court Group Description
string court_document_template_court_group_description Prices
Court Document Template Group Description
string court_level Prices
Court Level
string court_booking_starting_minute Prices
Court Booking Starting Minute
string court_freefield_1 Prices
Court Free Field 1
string court_freefield_2 Prices
Court Free Field 2
string court_freefield_3 Prices
Court Free Field 3
string court_freefield_4 Prices
Court Free Field 4
string court_freefield_5 Prices
Court Free Field 5
string court_freefield_6 Prices
Court Free Field 6
string court_freefield_7 Prices
Court Free Field 7
string court_freefield_8 Prices
Court Free Field 8
string court_freefield_9 Prices
Court Free Field 9
string court_freefield_10 Prices
Court Free Field 10
string price_key_default_value Prices
Price Key Default Value
integer price_key_preference Prices
Price Key Preference
integer court_number Prices
Court Number
integer court_minimum_time_per_booking Prices
Court Minimum Time Per Booking
integer court_minimum_time_per_booking_calculated Prices
Court Minimum Time Per Booking (Calculated)
integer court_minimum_additional_time_per_booking Prices
Court Minimum Additional Time Per Booking
integer court_minimum_additional_time_per_booking_calculated Prices
Court Minimum Additional Time Per Booking (Calculated)
integer court_maximum_time_per_booking Prices
Court Maximum Time Per Booking
integer court_maximum_time_per_booking_calculated Prices
Court Maximum Time Per Booking (Calculated)
integer court_blocked_minutes_after_booking Prices
Court Blocked Minutes After Booking
integer court_min_co_user_required Prices
Court Min Co-User Required
integer court_warning_capacity Prices
Court Warning Capacity
integer court_max_capacity Prices
Court Max Capacity
integer price_key_is_deleted Prices
Price Key Is Deleted
boolean vatcode_is_deleted Prices
Vatcode Is Deleted
boolean court_internal Prices
Court Internal
boolean court_divisible Prices
Court Divisible
boolean court_12_12_slots_configurable Prices
Court 12/12 Slots Configurable
boolean court_6_12_slots_configurable Prices
Court 6/12 Slots Configurable
boolean court_4_12_slots_configurable Prices
Court 4/12 Slots Configurable
boolean court_3_12_slots_configurable Prices
Court 3/12 Slots Configurable
boolean court_2_12_slots_configurable Prices
Court 2/12 Slots Configurable
boolean court_1_12_slots_configurable Prices
Court 1/12 Slots Configurable
boolean court_time_restrictions_backend_enabled Prices
Court Time Restrictions Backend Enabled
boolean court_co_user_selectable Prices
Court Co-User Selectable
boolean court_strict_court_schedule_handling Prices
Court Strict Schedule Handling
boolean court_force_adjacent_bookings Prices
Court Force Adjacent Bookings
boolean court_allow_bookings_over_multiple_days Prices
Court Allow Bookings Over Multiple Days
boolean court_capacity_based_court Prices
Court Capacity Based
boolean court_is_deleted Prices
Court Is Deleted
boolean product_id Product Orders
Product ID
integer subbooking_id Product Orders
Subbooking ID
string vatcode_id Product Orders
Vatcode ID
integer subbooking_court_room_setup_id Product Orders
Subbooking Court Room Setup ID
integer book_date Product Orders
Book Date
datetime date_added Product Orders
Date Added
datetime date_last_modified Product Orders
Date Last Modified
datetime product_date_added Product Orders
Product Date Added
datetime product_date_last_modified Product Orders
Product Date Last Modified
datetime vatcode_date_added Product Orders
Vatcode Date Added
datetime vatcode_date_last_modified Product Orders
Vatcode Date Last Modified
datetime subbooking_date Product Orders
Subbooking Date
datetime subbooking_start_datetime_utc Product Orders
Subbooking Start Datetime (UTC)
datetime subbooking_start_datetime Product Orders
Subbooking Start Datetime
datetime subbooking_end_datetime_utc Product Orders
Subbooking End Datetime (UTC)
datetime subbooking_end_datetime Product Orders
Subbooking End Datetime
datetime subbooking_option_expiration_datetime_utc Product Orders
Subbooking Option Expiration Datetime (UTC)
datetime subbooking_date_added Product Orders
Subbooking Date Added
datetime subbooking_date_last_modified Product Orders
Subbooking Date Last Modified
datetime product_name Product Orders
Product Name
string custom_product_description Product Orders
Custom Product Description
string internal_note Product Orders
Internal Note
string product_price_configuration Product Orders
Product Price Configuration
string book_starttime Product Orders
Book Start Time
string book_endtime Product Orders
Book End Time
string vat_configuration Product Orders
VAT Configuration
string product_name_html Product Orders
Product Name (HTML)
string product_name_nl_NL Product Orders
Product Name (nl-NL)
string product_name_en_US Product Orders
Product Name (en-US)
string product_name_de_DE Product Orders
Product Name (de-DE)
string product_name_fy_NL Product Orders
Product Name (fy-NL)
string product_name_fr_FR Product Orders
Product Name (fr-FR)
string per_piece_name Product Orders
Per Piece Name
string per_piece_name_nl_NL Product Orders
Per Piece Name (nl-NL)
string per_piece_name_en_US Product Orders
Per Piece Name (en-US)
string per_piece_name_de_DE Product Orders
Per Piece Name (de-DE)
string per_piece_name_fy_NL Product Orders
Per Piece Name (fy-NL)
string per_piece_name_fr_FR Product Orders
Per Piece Name (fr-FR)
string product_description Product Orders
Product Description
string product_description_nl_NL Product Orders
Product Description (nl-NL)
string product_description_en_US Product Orders
Product Description (en-US)
string product_description_de_DE Product Orders
Product Description (de-DE)
string product_description_fy_NL Product Orders
Product Description (fy-NL)
string product_description_fr_FR Product Orders
Product Description (fr-FR)
string document_template_product_description Product Orders
Document Template Product Description
string product_level Product Orders
Product Level
string product_quantity_configuration_type Product Orders
Product Quantity Configuration Type
string product_select_options Product Orders
Product Select Options
string product_freefield_1 Product Orders
Product Free Field 1
string product_freefield_2 Product Orders
Product Free Field 2
string product_freefield_3 Product Orders
Product Free Field 3
string product_freefield_4 Product Orders
Product Free Field 4
string product_freefield_5 Product Orders
Product Free Field 5
string product_freefield_6 Product Orders
Product Free Field 6
string product_freefield_7 Product Orders
Product Free Field 7
string product_freefield_8 Product Orders
Product Free Field 8
string product_freefield_9 Product Orders
Product Free Field 9
string product_freefield_10 Product Orders
Product Free Field 10
string vatcode_display_name Product Orders
Vatcode Display Name
string vatcode_display_name_short Product Orders
Vatcode Display Name Short
string vatcode_country_code_iso2 Product Orders
Vatcode Country Code (ISO2)
string vatcode_vat_report_code Product Orders
Vatcode VAT Report Code
string subbooking_starttime Product Orders
Subbooking Start Time
string subbooking_endtime Product Orders
Subbooking End Time
string subbooking_activity_display_name Product Orders
Subbooking Activity Display Name
string subbooking_purchase_order_code Product Orders
Subbooking Purchase Order Code
string subbooking_remarks Product Orders
Subbooking Remarks
string subbooking_external_remarks Product Orders
Subbooking External Remarks
string subbooking_display_name Product Orders
Subbooking Display Name
string subbooking_creation_source Product Orders
Subbooking Creation Source
string subbooking_court_display_name Product Orders
Subbooking Court Display Name
string subbooking_external_court_display_name Product Orders
Subbooking External Court Display Name
string subbooking_freefield_1 Product Orders
Subbooking Free Field 1
string subbooking_freefield_2 Product Orders
Subbooking Free Field 2
string subbooking_freefield_3 Product Orders
Subbooking Free Field 3
string subbooking_freefield_4 Product Orders
Subbooking Free Field 4
string subbooking_freefield_5 Product Orders
Subbooking Free Field 5
string subbooking_freefield_6 Product Orders
Subbooking Free Field 6
string subbooking_freefield_7 Product Orders
Subbooking Free Field 7
string subbooking_freefield_8 Product Orders
Subbooking Free Field 8
string subbooking_freefield_9 Product Orders
Subbooking Free Field 9
string subbooking_freefield_10 Product Orders
Subbooking Free Field 10
string product_quantity Product Orders
Product Quantity
integer unit_price Product Orders
Unit Price
integer unit_price_excl_vat Product Orders
Unit Price (Excl. VAT)
float unit_price_incl_vat Product Orders
Unit Price (Incl. VAT)
float product_price Product Orders
Product Price
integer product_price_excl_vat Product Orders
Product Price (Excl. VAT)
float product_price_incl_vat Product Orders
Product Price (Incl. VAT)
float total_price Product Orders
Total Price
integer total_price_excl_vat Product Orders
Total Price (Excl. VAT)
float total_price_incl_vat Product Orders
Total Price (Incl. VAT)
float sort_order Product Orders
Sort Order
integer product_price_per_hour_excl_vat Product Orders
Product Price Per Hour (Excl. VAT)
float product_price_per_hour_incl_vat Product Orders
Product Price Per Hour (Incl. VAT)
float max_calculated_product_price_per_hour_excl_vat Product Orders
Max Calculated Price Per Hour (Excl. VAT)
float max_calculated_product_price_per_hour_incl_vat Product Orders
Max Calculated Price Per Hour (Incl. VAT)
float product_number_in_stock Product Orders
Product Number In Stock
integer product_inventory_limit Product Orders
Product Inventory Limit
integer product_max_amount Product Orders
Product Max Amount
integer product_bookable_from_length Product Orders
Product Bookable From Length
integer product_bookable_till_length Product Orders
Product Bookable Till Length
integer subbooking_court_start_slot Product Orders
Subbooking Court Start Slot
integer subbooking_court_number_of_slots Product Orders
Subbooking Court Number of Slots
integer subbooking_participants Product Orders
Subbooking Participants
integer subbooking_sort_order Product Orders
Subbooking Sort Order
integer subbooking_costs Product Orders
Subbooking Costs
float subbooking_price_incl_vat Product Orders
Subbooking Price (Incl. VAT)
float subbooking_price_excl_vat Product Orders
Subbooking Price (Excl. VAT)
float subbooking_price_vat Product Orders
Subbooking Price VAT
float product_default_amount_selected Product Orders
Product Default Amount Selected
string is_manual_entry Product Orders
Is Manual Entry
boolean is_manual_price Product Orders
Is Manual Price
boolean product_internal Product Orders
Product Internal
boolean product_is_required Product Orders
Product Is Required
boolean product_price_per_hour_active Product Orders
Product Price Per Hour Active
boolean product_display_on_invoice Product Orders
Product Display On Invoice
boolean product_display_on_booking_confirmation Product Orders
Product Display On Booking Confirmation
boolean product_display_on_quotation Product Orders
Product Display On Quotation
boolean product_display_on_printlist Product Orders
Product Display On Printlist
boolean product_is_deleted Product Orders
Product Is Deleted
boolean vatcode_is_deleted Product Orders
Vatcode Is Deleted
boolean subbooking_exclusive Product Orders
Subbooking Exclusive
boolean subbooking_is_manual_price Product Orders
Subbooking Is Manual Price
boolean subbooking_is_manually_overwritten Product Orders
Subbooking Is Manually Overwritten
boolean subbooking_is_locked Product Orders
Subbooking Is Locked
boolean usergroup_id Product Usergroups
Usergroup ID
integer date_added Product Usergroups
Date Added
datetime date_last_modified Product Usergroups
Date Last Modified
datetime usergroup_date_added Product Usergroups
Usergroup Date Added
datetime usergroup_date_last_modified Product Usergroups
Usergroup Date Last Modified
datetime product_name Product Usergroups
Product Name
string product_name_nl_NL Product Usergroups
Product Name (nl-NL)
string product_name_en_US Product Usergroups
Product Name (en-US)
string product_name_de_DE Product Usergroups
Product Name (de-DE)
string product_name_fy_NL Product Usergroups
Product Name (fy-NL)
string product_name_fr_FR Product Usergroups
Product Name (fr-FR)
string per_piece_name Product Usergroups
Per Piece Name
string per_piece_name_nl_NL Product Usergroups
Per Piece Name (nl-NL)
string per_piece_name_en_US Product Usergroups
Per Piece Name (en-US)
string per_piece_name_de_DE Product Usergroups
Per Piece Name (de-DE)
string per_piece_name_fy_NL Product Usergroups
Per Piece Name (fy-NL)
string per_piece_name_fr_FR Product Usergroups
Per Piece Name (fr-FR)
string product_description Product Usergroups
Product Description
string product_description_nl_NL Product Usergroups
Product Description (nl-NL)
string product_description_en_US Product Usergroups
Product Description (en-US)
string product_description_de_DE Product Usergroups
Product Description (de-DE)
string product_description_fy_NL Product Usergroups
Product Description (fy-NL)
string product_description_fr_FR Product Usergroups
Product Description (fr-FR)
string document_template_product_description Product Usergroups
Document Template Product Description
string level Product Usergroups
Level
string product_quantity_configuration_type Product Usergroups
Product Quantity Configuration Type
string product_select_options Product Usergroups
Product Select Options
string vat_configuration Product Usergroups
VAT Configuration
string freefield_1 Product Usergroups
Free Field 1
string freefield_2 Product Usergroups
Free Field 2
string freefield_3 Product Usergroups
Free Field 3
string freefield_4 Product Usergroups
Free Field 4
string freefield_5 Product Usergroups
Free Field 5
string freefield_6 Product Usergroups
Free Field 6
string freefield_7 Product Usergroups
Free Field 7
string freefield_8 Product Usergroups
Free Field 8
string freefield_9 Product Usergroups
Free Field 9
string freefield_10 Product Usergroups
Free Field 10
string usergroup_display_name Product Usergroups
Usergroup Display Name
string default_amount_selected Product Usergroups
Default Amount Selected
float product_price Product Usergroups
Product Price
integer product_price_excl_vat Product Usergroups
Product Price (Excl. VAT)
float product_price_incl_vat Product Usergroups
Product Price (Incl. VAT)
float product_price_per_hour_excl_vat Product Usergroups
Product Price Per Hour (Excl. VAT)
float product_price_per_hour_incl_vat Product Usergroups
Product Price Per Hour (Incl. VAT)
float max_calculated_product_price_per_hour_excl_vat Product Usergroups
Max Calculated Price Per Hour (Excl. VAT)
float max_calculated_product_price_per_hour_incl_vat Product Usergroups
Max Calculated Price Per Hour (Incl. VAT)
float product_number_in_stock Product Usergroups
Product Number In Stock
integer inventory_limit Product Usergroups
Inventory Limit
integer max_amount Product Usergroups
Max Amount
integer bookable_from_length Product Usergroups
Bookable From Length
integer bookable_till_length Product Usergroups
Bookable Till Length
integer sort_order Product Usergroups
Sort Order
integer internal Product Usergroups
Internal
boolean is_required Product Usergroups
Is Required
boolean product_price_per_hour_active Product Usergroups
Product Price Per Hour Active
boolean product_display_on_invoice Product Usergroups
Display On Invoice
boolean product_display_on_booking_confirmation Product Usergroups
Display On Booking Confirmation
boolean product_display_on_quotation Product Usergroups
Display On Quotation
boolean product_display_on_printlist Product Usergroups
Display On Printlist
boolean is_deleted Product Usergroups
Is Deleted
boolean date_added Products
Date Added
datetime date_last_modified Products
Date Last Modified
datetime product_name Products
Product Name
string product_name_nl_NL Products
Product Name (nl-NL)
string product_name_en_US Products
Product Name (en-US)
string product_name_de_DE Products
Product Name (de-DE)
string product_name_fy_NL Products
Product Name (fy-NL)
string product_name_fr_FR Products
Product Name (fr-FR)
string per_piece_name Products
Per Piece Name
string per_piece_name_nl_NL Products
Per Piece Name (nl-NL)
string per_piece_name_en_US Products
Per Piece Name (en-US)
string per_piece_name_de_DE Products
Per Piece Name (de-DE)
string per_piece_name_fy_NL Products
Per Piece Name (fy-NL)
string per_piece_name_fr_FR Products
Per Piece Name (fr-FR)
string product_description Products
Product Description
string product_description_nl_NL Products
Product Description (nl-NL)
string product_description_en_US Products
Product Description (en-US)
string product_description_de_DE Products
Product Description (de-DE)
string product_description_fy_NL Products
Product Description (fy-NL)
string product_description_fr_FR Products
Product Description (fr-FR)
string document_template_product_description Products
Document Template Product Description
string product_quantity_configuration_type Products
Product Quantity Configuration Type
string product_select_options Products
Product Select Options
string vat_configuration Products
VAT Configuration
string freefield_1 Products
Free Field 1
string freefield_2 Products
Free Field 2
string freefield_3 Products
Free Field 3
string freefield_4 Products
Free Field 4
string freefield_5 Products
Free Field 5
string freefield_6 Products
Free Field 6
string freefield_7 Products
Free Field 7
string freefield_8 Products
Free Field 8
string freefield_9 Products
Free Field 9
string freefield_10 Products
Free Field 10
string default_amount_selected Products
Default Amount Selected
float product_price Products
Product Price
integer product_price_excl_vat Products
Product Price (Excl. VAT)
float product_price_incl_vat Products
Product Price (Incl. VAT)
float product_price_per_hour_excl_vat Products
Product Price Per Hour (Excl. VAT)
float product_price_per_hour_incl_vat Products
Product Price Per Hour (Incl. VAT)
float max_calculated_product_price_per_hour_excl_vat Products
Max Calculated Price Per Hour (Excl. VAT)
float max_calculated_product_price_per_hour_incl_vat Products
Max Calculated Price Per Hour (Incl. VAT)
float product_number_in_stock Products
Product Number In Stock
integer inventory_limit Products
Inventory Limit
integer max_amount Products
Max Amount
integer bookable_from_length Products
Bookable From Length
integer bookable_till_length Products
Bookable Till Length
integer sort_order Products
Sort Order
integer is_required Products
Is Required
boolean product_price_per_hour_active Products
Product Price Per Hour Active
boolean product_display_on_invoice Products
Display On Invoice
boolean product_display_on_booking_confirmation Products
Display On Booking Confirmation
boolean product_display_on_quotation Products
Display On Quotation
boolean product_display_on_printlist Products
Display On Printlist
boolean is_deleted Products
Is Deleted
boolean id Subbooking Audit Logs
Subbooking ID
string audit_log_id Subbooking Audit Logs
Audit Log ID
integer booking_id Subbooking Audit Logs
Booking ID
string booking_status Subbooking Audit Logs
Booking Status
integer court_room_setup_id Subbooking Audit Logs
Court Room Setup ID
integer audit_log_original_id Subbooking Audit Logs
Audit Log Original ID
integer audit_log_new_id Subbooking Audit Logs
Audit Log New ID
integer date Subbooking Audit Logs
Date
datetime start_datetime_utc Subbooking Audit Logs
Start Datetime UTC
datetime start_datetime Subbooking Audit Logs
Start Datetime
datetime end_datetime_utc Subbooking Audit Logs
End Datetime UTC
datetime end_datetime Subbooking Audit Logs
End Datetime
datetime option_expiration_datetime_utc Subbooking Audit Logs
Option Expiration Datetime UTC
datetime date_added Subbooking Audit Logs
Subbooking Date Added
datetime date_last_modified Subbooking Audit Logs
Subbooking Date Last Modified
datetime audit_log_date_added Subbooking Audit Logs
Audit Log Date Added
datetime booking_startdate Subbooking Audit Logs
Booking Start Date
datetime booking_paymentprovider_status_last_modified Subbooking Audit Logs
Booking Payment Provider Status Last Modified
datetime booking_date_added Subbooking Audit Logs
Booking Date Added
datetime booking_date_last_modified Subbooking Audit Logs
Booking Date Last Modified
datetime starttime Subbooking Audit Logs
Start Time
string endtime Subbooking Audit Logs
End Time
string activity_display_name Subbooking Audit Logs
Activity Display Name
string purchase_order_code Subbooking Audit Logs
Purchase Order Code
string subbooking_remarks Subbooking Audit Logs
Subbooking Remarks
string subbooking_external_remarks Subbooking Audit Logs
Subbooking External Remarks
string subbooking_display_name Subbooking Audit Logs
Subbooking Display Name
string creation_source Subbooking Audit Logs
Creation Source
string court_display_name Subbooking Audit Logs
Court Display Name
string external_court_display_name Subbooking Audit Logs
External Court Display Name
string freefield_1 Subbooking Audit Logs
Free Field 1
string freefield_2 Subbooking Audit Logs
Free Field 2
string freefield_3 Subbooking Audit Logs
Free Field 3
string freefield_4 Subbooking Audit Logs
Free Field 4
string freefield_5 Subbooking Audit Logs
Free Field 5
string freefield_6 Subbooking Audit Logs
Free Field 6
string freefield_7 Subbooking Audit Logs
Free Field 7
string freefield_8 Subbooking Audit Logs
Free Field 8
string freefield_9 Subbooking Audit Logs
Free Field 9
string freefield_10 Subbooking Audit Logs
Free Field 10
string audit_log_severity Subbooking Audit Logs
Audit Log Severity
string audit_log_usergroups Subbooking Audit Logs
Audit Log Usergroups
string audit_log_admin_roles Subbooking Audit Logs
Audit Log Admin Roles
string audit_log_original_value Subbooking Audit Logs
Audit Log Original Value
string audit_log_new_value Subbooking Audit Logs
Audit Log New Value
string booking_type Subbooking Audit Logs
Booking Type
string booking_paymentmethod Subbooking Audit Logs
Booking Payment Method
string booking_paymentprovider Subbooking Audit Logs
Booking Payment Provider
string booking_paymentprovider_status Subbooking Audit Logs
Booking Payment Provider Status
string booking_remarks Subbooking Audit Logs
Booking Remarks
string booking_external_remarks Subbooking Audit Logs
Booking External Remarks
string booking_purchase_order_code Subbooking Audit Logs
Booking Purchase Order Code
string booking_display_name Subbooking Audit Logs
Booking Display Name
string booking_number Subbooking Audit Logs
Booking Number
string booking_preferred_locale Subbooking Audit Logs
Booking Preferred Locale
string court_start_slot Subbooking Audit Logs
Court Start Slot
integer court_number_of_slots Subbooking Audit Logs
Court Number of Slots
integer participants Subbooking Audit Logs
Participants
integer sort_order Subbooking Audit Logs
Sort Order
integer costs Subbooking Audit Logs
Costs
float price_incl_vat Subbooking Audit Logs
Price Incl. VAT
float price_excl_vat Subbooking Audit Logs
Price Excl. VAT
float price_vat Subbooking Audit Logs
Price VAT
float exclusive Subbooking Audit Logs
Exclusive
boolean is_manual_price Subbooking Audit Logs
Is Manual Price
boolean is_manually_overwritten Subbooking Audit Logs
Is Manually Overwritten
boolean is_locked Subbooking Audit Logs
Is Locked
boolean booking_exclude_from_narrowcasting Subbooking Audit Logs
Booking Exclude From Narrowcasting
boolean booking_id Subbookings
Booking ID
string court_id Subbookings
Court ID
string vatcode_id Subbookings
VAT Code ID
integer pricekey_id Subbookings
Price Key ID
integer status_id Subbookings
Status ID
integer booking_status Subbookings
Booking Status
integer court_room_setup_id Subbookings
Court Room Setup ID
integer start_datetime_utc Subbookings
Start Datetime UTC
datetime start_datetime Subbookings
Start Datetime
datetime end_datetime_utc Subbookings
End Datetime UTC
datetime end_datetime Subbookings
End Datetime
datetime option_expiration_datetime_utc Subbookings
Option Expiration Datetime UTC
datetime date_added Subbookings
Date Added
datetime date_last_modified Subbookings
Date Last Modified
datetime booking_startdate Subbookings
Booking Start Date
datetime booking_paymentprovider_status_last_modified Subbookings
Booking Payment Provider Status Last Modified
datetime booking_date_added Subbookings
Booking Date Added
datetime booking_date_last_modified Subbookings
Booking Date Last Modified
datetime court_date_added Subbookings
Court Date Added
datetime court_date_last_modified Subbookings
Court Date Last Modified
datetime vatcode_date_added Subbookings
VAT Code Date Added
datetime vatcode_date_last_modified Subbookings
VAT Code Date Last Modified
datetime pricekey_date_added Subbookings
Price Key Date Added
datetime pricekey_date_last_modified Subbookings
Price Key Date Last Modified
datetime starttime Subbookings
Start Time
string endtime Subbookings
End Time
string activity_display_name Subbookings
Activity Display Name
string purchase_order_code Subbookings
Purchase Order Code
string subbooking_remarks Subbookings
Subbooking Remarks
string subbooking_external_remarks Subbookings
Subbooking External Remarks
string subbooking_display_name Subbookings
Subbooking Display Name
string creation_source Subbookings
Creation Source
string court_display_name Subbookings
Court Display Name
string external_court_display_name Subbookings
External Court Display Name
string freefield_1 Subbookings
Free Field 1
string freefield_2 Subbookings
Free Field 2
string freefield_3 Subbookings
Free Field 3
string freefield_4 Subbookings
Free Field 4
string freefield_5 Subbookings
Free Field 5
string freefield_6 Subbookings
Free Field 6
string freefield_7 Subbookings
Free Field 7
string freefield_8 Subbookings
Free Field 8
string freefield_9 Subbookings
Free Field 9
string freefield_10 Subbookings
Free Field 10
string booking_type Subbookings
Booking Type
string booking_paymentmethod Subbookings
Booking Payment Method
string booking_paymentprovider Subbookings
Booking Payment Provider
string booking_paymentprovider_status Subbookings
Booking Payment Provider Status
string booking_remarks Subbookings
Booking Remarks
string booking_external_remarks Subbookings
Booking External Remarks
string booking_purchase_order_code Subbookings
Booking Purchase Order Code
string booking_display_name Subbookings
Booking Display Name
string booking_number Subbookings
Booking Number
string booking_preferred_locale Subbookings
Booking Preferred Locale
string court_name Subbookings
Court Name
string court_level Subbookings
Court Level
string court_court_description Subbookings
Court Description
string court_court_group_description Subbookings
Court Group Description
string court_document_template_court_group_description Subbookings
Court Document Template Group Description
string court_booking_starting_minute Subbookings
Court Booking Starting Minute
string court_freefield_1 Subbookings
Court Free Field 1
string court_freefield_2 Subbookings
Court Free Field 2
string court_freefield_3 Subbookings
Court Free Field 3
string court_freefield_4 Subbookings
Court Free Field 4
string court_freefield_5 Subbookings
Court Free Field 5
string court_freefield_6 Subbookings
Court Free Field 6
string court_freefield_7 Subbookings
Court Free Field 7
string court_freefield_8 Subbookings
Court Free Field 8
string court_freefield_9 Subbookings
Court Free Field 9
string court_freefield_10 Subbookings
Court Free Field 10
string vatcode_display_name Subbookings
VAT Code Display Name
string vatcode_display_name_short Subbookings
VAT Code Display Name Short
string vatcode_country_code_iso2 Subbookings
VAT Code Country Code
string vatcode_vat_report_code Subbookings
VAT Report Code
string pricekey_display_name Subbookings
Price Key Display Name
string status_label Subbookings
Status Label
string status_display_name Subbookings
Status Display Name
string court_start_slot Subbookings
Court Start Slot
integer court_number_of_slots Subbookings
Court Number of Slots
integer participants Subbookings
Participants
integer sort_order Subbookings
Sort Order
integer price_incl_vat Subbookings
Price Incl. VAT
float price_excl_vat Subbookings
Price Excl. VAT
float price_vat Subbookings
Price VAT
float court_number Subbookings
Court Number
integer court_minimum_time_per_booking Subbookings
Court Minimum Time Per Booking
integer court_minimum_time_per_booking_calculated Subbookings
Court Minimum Time Per Booking (Calculated)
integer court_minimum_additional_time_per_booking Subbookings
Court Minimum Additional Time Per Booking
integer court_minimum_additional_time_per_booking_calculated Subbookings
Court Minimum Additional Time Per Booking (Calculated)
integer court_maximum_time_per_booking Subbookings
Court Maximum Time Per Booking
integer court_maximum_time_per_booking_calculated Subbookings
Court Maximum Time Per Booking (Calculated)
integer court_blocked_minutes_after_booking Subbookings
Court Blocked Minutes After Booking
integer court_min_co_user_required Subbookings
Court Min Co-User Required
integer court_warning_capacity Subbookings
Court Warning Capacity
integer court_max_capacity Subbookings
Court Max Capacity
integer pricekey_default_value Subbookings
Price Key Default Value
integer pricekey_preference Subbookings
Price Key Preference
integer exclusive Subbookings
Exclusive
boolean is_manual_price Subbookings
Is Manual Price
boolean is_manually_overwritten Subbookings
Is Manually Overwritten
boolean is_locked Subbookings
Is Locked
boolean booking_exclude_from_narrowcasting Subbookings
Booking Exclude From Narrowcasting
boolean court_internal Subbookings
Court Internal
boolean court_divisible Subbookings
Court Divisible
boolean court_12_12_slots_configurable Subbookings
Court 12/12 Slots Configurable
boolean court_6_12_slots_configurable Subbookings
Court 6/12 Slots Configurable
boolean court_4_12_slots_configurable Subbookings
Court 4/12 Slots Configurable
boolean court_3_12_slots_configurable Subbookings
Court 3/12 Slots Configurable
boolean court_2_12_slots_configurable Subbookings
Court 2/12 Slots Configurable
boolean court_1_12_slots_configurable Subbookings
Court 1/12 Slots Configurable
boolean court_time_restrictions_backend_enabled Subbookings
Court Time Restrictions Backend Enabled
boolean court_co_user_selectable Subbookings
Court Co-User Selectable
boolean court_strict_court_schedule_handling Subbookings
Court Strict Schedule Handling
boolean court_force_adjacent_bookings Subbookings
Court Force Adjacent Bookings
boolean court_allow_bookings_over_multiple_days Subbookings
Court Allow Bookings Over Multiple Days
boolean court_capacity_based_court Subbookings
Court Capacity Based
boolean court_is_deleted Subbookings
Court Is Deleted
boolean vatcode_is_deleted Subbookings
VAT Code Is Deleted
boolean pricekey_is_deleted Subbookings
Price Key Is Deleted
boolean status_visible Subbookings
Status Visible
boolean status_sticky Subbookings
Status Sticky
boolean audit_log_id User Audit Logs
Audit Log ID
integer usergroup_id User Audit Logs
Usergroup ID
integer debtor_number_technical_id User Audit Logs
Debtor Number Technical ID
integer audit_log_original_id User Audit Logs
Audit Log Original ID
integer audit_log_new_id User Audit Logs
Audit Log New ID
integer date_registration_approved User Audit Logs
Date Registration Approved
datetime password_last_modified User Audit Logs
Password Last Modified
datetime date_added User Audit Logs
Date Added
datetime date_last_modified User Audit Logs
Date Last Modified
datetime audit_log_date_added User Audit Logs
Audit Log Date Added
datetime company User Audit Logs
Company
string firstname User Audit Logs sensible
First Name
string name User Audit Logs sensible
Last Name
string full_name User Audit Logs sensible
Full Name
string username User Audit Logs sensible
Username
string email User Audit Logs sensible
Email
string address User Audit Logs sensible
Address
string zipcode User Audit Logs sensible
Zipcode
string country User Audit Logs
Country
string telephone_country User Audit Logs
Telephone Country
string telephone User Audit Logs sensible
Telephone
string registration_source User Audit Logs
Registration Source
string company_attn_invoice User Audit Logs
Company Attn Invoice
string description User Audit Logs
Description
string preferred_email_locale User Audit Logs
Preferred Email Locale
string attn_invoice User Audit Logs
Attn Invoice
string address_invoice User Audit Logs sensible
Invoice Address
string zipcode_invoice User Audit Logs sensible
Invoice Zipcode
string city_invoice User Audit Logs
Invoice City
string country_invoice User Audit Logs
Invoice Country
string invoice_mail User Audit Logs sensible
Invoice Email
string invoice_send_method User Audit Logs
Invoice Send Method
string peppol_address_scheme User Audit Logs
Peppol Address Scheme
string peppol_address User Audit Logs
Peppol Address
string taxnumber User Audit Logs
Tax Number
string debtor_number User Audit Logs
Debtor Number
string override_purchase_order_code User Audit Logs
Override Purchase Order Code
string remarks User Audit Logs
Remarks
string password_policy_version User Audit Logs
Password Policy Version
string freefield_1 User Audit Logs
Free Field 1
string freefield_2 User Audit Logs
Free Field 2
string freefield_3 User Audit Logs
Free Field 3
string freefield_4 User Audit Logs
Free Field 4
string freefield_5 User Audit Logs
Free Field 5
string freefield_6 User Audit Logs
Free Field 6
string freefield_7 User Audit Logs
Free Field 7
string freefield_8 User Audit Logs
Free Field 8
string freefield_9 User Audit Logs
Free Field 9
string freefield_10 User Audit Logs
Free Field 10
string audit_log_severity User Audit Logs
Audit Log Severity
string audit_log_usergroups User Audit Logs
Audit Log Usergroups
string audit_log_admin_roles User Audit Logs
Audit Log Admin Roles
string audit_log_original_value User Audit Logs
Audit Log Original Value
string audit_log_new_value User Audit Logs
Audit Log New Value
string registration_status User Audit Logs
Registration Status
integer invoice_paymentcondition_days User Audit Logs
Invoice Payment Condition Days
integer archived User Audit Logs
Archived
boolean pass_changeable User Audit Logs
Password Changeable
boolean newsletter_subscription User Audit Logs
Newsletter Subscription
boolean access_code_reminder_subscription User Audit Logs
Access Code Reminder Subscription
boolean exclude_bookings_from_narrowcasting User Audit Logs
Exclude Bookings From Narrowcasting
boolean is_deleted User Audit Logs
Is Deleted
boolean date_added User Contacts
Date Added
datetime date_last_modified User Contacts
Date Last Modified
datetime email User Contacts sensible
Email
string firstname User Contacts sensible
First Name
string name_prefix User Contacts
Name Prefix
string name User Contacts sensible
Last Name
string telephone_country User Contacts
Telephone Country
string telephone_number User Contacts sensible
Telephone Number
string remarks User Contacts
Remarks
string registration_source User Contacts
Registration Source
string archived User Contacts
Archived
boolean id Usergroup Court Groups
ID
integer court_group_id Usergroup Court Groups
Court Group ID
integer price_key_id Usergroup Court Groups
Price Key ID
integer date_added Usergroup Court Groups
Date Added
datetime date_last_modified Usergroup Court Groups
Date Last Modified
datetime price_key_date_added Usergroup Court Groups
Price Key Date Added
datetime price_key_date_last_modified Usergroup Court Groups
Price Key Date Last Modified
datetime court_group_date_added Usergroup Court Groups
Court Group Date Added
datetime court_group_date_last_modified Usergroup Court Groups
Court Group Date Last Modified
datetime usergroup_display_name Usergroup Court Groups
Usergroup Display Name
string price_key_display_name Usergroup Court Groups
Price Key Display Name
string court_group_display_name Usergroup Court Groups
Court Group Display Name
string price_key_default_value Usergroup Court Groups
Price Key Default Value
integer price_key_preference Usergroup Court Groups
Price Key Preference
integer price_key_is_deleted Usergroup Court Groups
Price Key Is Deleted
boolean court_group_aggregated_for_booking_process Usergroup Court Groups
Court Group Aggregated For Booking Process
boolean court_group_aggregated_for_price_settings Usergroup Court Groups
Court Group Aggregated For Price Settings
boolean court_group_participants_enabled Usergroup Court Groups
Court Group Participants Enabled
boolean court_group_aggregated_for_admin_booking_process Usergroup Court Groups
Court Group Aggregated For Admin Booking Process
boolean court_group_court_tile_enabled Usergroup Court Groups
Court Group Court Tile Enabled
boolean court_id Usergroup Courts
Court ID
string price_key_id Usergroup Courts
Price Key ID
integer date_added Usergroup Courts
Date Added
datetime date_last_modified Usergroup Courts
Date Last Modified
datetime price_key_date_added Usergroup Courts
Price Key Date Added
datetime price_key_date_last_modified Usergroup Courts
Price Key Date Last Modified
datetime court_date_added Usergroup Courts
Court Date Added
datetime court_date_last_modified Usergroup Courts
Court Date Last Modified
datetime usergroup_display_name Usergroup Courts
Usergroup Display Name
string price_key_display_name Usergroup Courts
Price Key Display Name
string court_name Usergroup Courts
Court Name
string court_description Usergroup Courts
Court Description
string court_group_description Usergroup Courts
Court Group Description
string court_document_template_court_group_description Usergroup Courts
Court Document Template Group Description
string court_level Usergroup Courts
Court Level
string court_booking_starting_minute Usergroup Courts
Court Booking Starting Minute
string court_freefield_1 Usergroup Courts
Court Free Field 1
string court_freefield_2 Usergroup Courts
Court Free Field 2
string court_freefield_3 Usergroup Courts
Court Free Field 3
string court_freefield_4 Usergroup Courts
Court Free Field 4
string court_freefield_5 Usergroup Courts
Court Free Field 5
string court_freefield_6 Usergroup Courts
Court Free Field 6
string court_freefield_7 Usergroup Courts
Court Free Field 7
string court_freefield_8 Usergroup Courts
Court Free Field 8
string court_freefield_9 Usergroup Courts
Court Free Field 9
string court_freefield_10 Usergroup Courts
Court Free Field 10
string price_key_default_value Usergroup Courts
Price Key Default Value
integer price_key_preference Usergroup Courts
Price Key Preference
integer court_number Usergroup Courts
Court Number
integer court_minimum_time_per_booking Usergroup Courts
Court Minimum Time Per Booking
integer court_minimum_time_per_booking_calculated Usergroup Courts
Court Minimum Time Per Booking (Calculated)
integer court_minimum_additional_time_per_booking Usergroup Courts
Court Minimum Additional Time Per Booking
integer court_minimum_additional_time_per_booking_calculated Usergroup Courts
Court Minimum Additional Time Per Booking (Calculated)
integer court_maximum_time_per_booking Usergroup Courts
Court Maximum Time Per Booking
integer court_maximum_time_per_booking_calculated Usergroup Courts
Court Maximum Time Per Booking (Calculated)
integer court_blocked_minutes_after_booking Usergroup Courts
Court Blocked Minutes After Booking
integer court_min_co_user_required Usergroup Courts
Court Min Co-User Required
integer court_warning_capacity Usergroup Courts
Court Warning Capacity
integer court_max_capacity Usergroup Courts
Court Max Capacity
integer price_key_is_deleted Usergroup Courts
Price Key Is Deleted
boolean court_internal Usergroup Courts
Court Internal
boolean court_divisible Usergroup Courts
Court Divisible
boolean court_12_12_slots_configurable Usergroup Courts
Court 12/12 Slots Configurable
boolean court_6_12_slots_configurable Usergroup Courts
Court 6/12 Slots Configurable
boolean court_4_12_slots_configurable Usergroup Courts
Court 4/12 Slots Configurable
boolean court_3_12_slots_configurable Usergroup Courts
Court 3/12 Slots Configurable
boolean court_2_12_slots_configurable Usergroup Courts
Court 2/12 Slots Configurable
boolean court_1_12_slots_configurable Usergroup Courts
Court 1/12 Slots Configurable
boolean court_time_restrictions_backend_enabled Usergroup Courts
Court Time Restrictions Backend Enabled
boolean court_co_user_selectable Usergroup Courts
Court Co-User Selectable
boolean court_strict_court_schedule_handling Usergroup Courts
Court Strict Schedule Handling
boolean court_force_adjacent_bookings Usergroup Courts
Court Force Adjacent Bookings
boolean court_allow_bookings_over_multiple_days Usergroup Courts
Court Allow Bookings Over Multiple Days
boolean court_capacity_based_court Usergroup Courts
Court Capacity Based
boolean court_is_deleted Usergroup Courts
Court Is Deleted
boolean user_id Usergroup Users
User ID
string price_key_id Usergroup Users
Price Key ID
integer date_added Usergroup Users
Date Added
datetime date_last_modified Usergroup Users
Date Last Modified
datetime price_key_date_added Usergroup Users
Price Key Date Added
datetime price_key_date_last_modified Usergroup Users
Price Key Date Last Modified
datetime user_date_added Usergroup Users
User Date Added
datetime user_date_last_modified Usergroup Users
User Date Last Modified
datetime user_date_registration_approved Usergroup Users
User Date Registration Approved
datetime user_password_last_modified Usergroup Users
User Password Last Modified
datetime usergroup_display_name Usergroup Users
Usergroup Display Name
string price_key_display_name Usergroup Users
Price Key Display Name
string user_company Usergroup Users
User Company
string user_firstname Usergroup Users sensible
User First Name
string user_name Usergroup Users sensible
User Last Name
string user_full_name Usergroup Users sensible
User Full Name
string user_username Usergroup Users sensible
User Username
string user_email Usergroup Users sensible
User Email
string user_address Usergroup Users sensible
User Address
string user_zipcode Usergroup Users sensible
User Zipcode
string user_city Usergroup Users
User City
string user_country Usergroup Users
User Country
string user_telephone_country Usergroup Users
User Telephone Country
string user_telephone Usergroup Users sensible
User Telephone
string user_registration_source Usergroup Users
User Registration Source
string user_company_attn_invoice Usergroup Users
User Company Attn Invoice
string user_description Usergroup Users
User Description
string user_attn_invoice Usergroup Users
User Attn Invoice
string user_address_invoice Usergroup Users sensible
User Invoice Address
string user_zipcode_invoice Usergroup Users sensible
User Invoice Zipcode
string user_city_invoice Usergroup Users
User Invoice City
string user_country_invoice Usergroup Users
User Invoice Country
string user_invoice_mail Usergroup Users sensible
User Invoice Email
string user_invoice_send_method Usergroup Users
User Invoice Send Method
string user_peppol_address_scheme Usergroup Users
User Peppol Address Scheme
string user_peppol_address Usergroup Users
User Peppol Address
string user_taxnumber Usergroup Users
User Tax Number
string user_debtor_number Usergroup Users
User Debtor Number
string user_override_purchase_order_code Usergroup Users
User Override Purchase Order Code
string user_remarks Usergroup Users
User Remarks
string user_password_policy_version Usergroup Users
User Password Policy Version
string user_preferred_email_locale Usergroup Users
User Preferred Email Locale
string user_freefield_1 Usergroup Users
User Free Field 1
string user_freefield_2 Usergroup Users
User Free Field 2
string user_freefield_3 Usergroup Users
User Free Field 3
string user_freefield_4 Usergroup Users
User Free Field 4
string user_freefield_5 Usergroup Users
User Free Field 5
string user_freefield_6 Usergroup Users
User Free Field 6
string user_freefield_7 Usergroup Users
User Free Field 7
string user_freefield_8 Usergroup Users
User Free Field 8
string user_freefield_9 Usergroup Users
User Free Field 9
string user_freefield_10 Usergroup Users
User Free Field 10
string price_key_default_value Usergroup Users
Price Key Default Value
integer price_key_preference Usergroup Users
Price Key Preference
integer user_registration_status Usergroup Users
User Registration Status
integer user_invoice_paymentcondition_days Usergroup Users
User Invoice Payment Condition Days
integer user_debtor_number_technical_id Usergroup Users
User Debtor Number Technical ID
integer price_key_is_deleted Usergroup Users
Price Key Is Deleted
boolean user_archived Usergroup Users
User Archived
boolean user_pass_changeable Usergroup Users
User Password Changeable
boolean user_newsletter_subscription Usergroup Users
User Newsletter Subscription
boolean user_access_code_reminder_subscription Usergroup Users
User Access Code Reminder Subscription
boolean user_exclude_bookings_from_narrowcasting Usergroup Users
User Exclude Bookings From Narrowcasting
boolean user_is_deleted Usergroup Users
User Is Deleted
boolean price_key_id Usergroups
Price Key ID
integer date_added Usergroups
Date Added
datetime date_last_modified Usergroups
Date Last Modified
datetime price_key_date_added Usergroups
Price Key Date Added
datetime price_key_date_last_modified Usergroups
Price Key Date Last Modified
datetime usergroup_display_name Usergroups
Usergroup Display Name
string price_key_display_name Usergroups
Price Key Display Name
string price_key_default_value Usergroups
Price Key Default Value
integer price_key_preference Usergroups
Price Key Preference
integer price_key_is_deleted Usergroups
Price Key Is Deleted
boolean usergroup_id Users
Usergroup ID
integer debtor_number_technical_id Users
Debtor Number Technical ID
integer date_registration_approved Users
Date Registration Approved
datetime password_last_modified Users
Password Last Modified
datetime date_added Users
Date Added
datetime date_last_modified Users
Date Last Modified
datetime usergroup_date_added Users
Usergroup Date Added
datetime usergroup_date_last_modified Users
Usergroup Date Last Modified
datetime firstname Users sensible
First Name
string name Users sensible
Last Name
string full_name Users sensible
Full Name
string username Users sensible
Username
string address Users sensible
Address
string zipcode Users sensible
Zipcode
string telephone_country Users
Telephone Country
string telephone Users sensible
Telephone
string registration_source Users
Registration Source
string company_attn_invoice Users
Company Attn Invoice
string description Users
Description
string preferred_email_locale Users
Preferred Email Locale
string attn_invoice Users
Attn Invoice
string address_invoice Users sensible
Invoice Address
string zipcode_invoice Users sensible
Invoice Zipcode
string city_invoice Users
Invoice City
string country_invoice Users
Invoice Country
string invoice_mail Users sensible
Invoice Email
string invoice_send_method Users
Invoice Send Method
string peppol_address_scheme Users
Peppol Address Scheme
string peppol_address Users
Peppol Address
string debtor_number Users
Debtor Number
string override_purchase_order_code Users
Override Purchase Order Code
string password_policy_version Users
Password Policy Version
string freefield_1 Users
Free Field 1
string freefield_2 Users
Free Field 2
string freefield_3 Users
Free Field 3
string freefield_4 Users
Free Field 4
string freefield_5 Users
Free Field 5
string freefield_6 Users
Free Field 6
string freefield_7 Users
Free Field 7
string freefield_8 Users
Free Field 8
string freefield_9 Users
Free Field 9
string freefield_10 Users
Free Field 10
string usergroup_display_name Users
Usergroup Display Name
string registration_status Users
Registration Status
integer invoice_paymentcondition_days Users
Invoice Payment Condition Days
integer pass_changeable Users
Password Changeable
boolean newsletter_subscription Users
Newsletter Subscription
boolean access_code_reminder_subscription Users
Access Code Reminder Subscription
boolean exclude_bookings_from_narrowcasting Users
Exclude Bookings From Narrowcasting
boolean is_deleted Users
Is Deleted
boolean date_added Vatcodes
Date Added
datetime date_last_modified Vatcodes
Date Last Modified
datetime display_name Vatcodes
Display Name
string display_name_short Vatcodes
Display Name Short
string country_code_iso2 Vatcodes
Country Code ISO2
string vat_report_code Vatcodes
VAT Report Code
string is_deleted Vatcodes
Is Deleted
boolean