Every record & field
Pull the full Aqqo data model - invoices, transactions, payments, ledger and tax fields - not just a fixed preset, so your financial reports are never missing a line.
Aqqo
Aqqo
Finance & AccountingDataddo extracts the full Aqqo record set - invoices, transactions, payments, ledger entries - and delivers it wherever your finance team needs it: into AI tools and agents, your warehouse like Snowflake and BigQuery, BI dashboards, and back into your ERP and CRM. Blend it across entities and systems, backfill full history for audit, and keep it fresh on your schedule - all fully managed, with the data plane running where you choose. No pipelines to build, no lock-in.
YOUR FINANCE SOURCE OF TRUTH
Turn Aqqo into financial reporting your whole team trusts
Financial data is only useful when it's complete, reconciled, and current. Dataddo extracts the full Aqqo record model, governs it, and serves it to every warehouse, dashboard, AI tool, and downstream system - continuously and without manual exports.
Blend across entities & systems
Combine Aqqo with your other accounting, payment, and CRM sources so consolidated, multi-entity reporting lives in one place.
Backfill full history for audit
Load historical Aqqo data beyond the platform's export limits, so period-over-period, reconciliation, and audit trails hold up.
Model & clean before load
Normalize currencies, tax codes, and account names, and let the Data Quality Firewall stop bad rows before Aqqo data reaches your reports.
Fresh on your schedule
Incremental, scheduled syncs keep Aqqo data current - as often as hourly - without manual exports or full reloads.
Governed & auditable
Delivery alerts and quality checks catch gaps in Aqqo data early, so month-end close and dashboards never silently break.
DATASETS
What you can pull from Aqqo
The Aqqo connector provides a list of curated datasets - ready-made sets of records, fields, and metrics you can extract on a schedule. Need something specific? Any dataset can be forked and customized, or built from scratch, with our Universal Connector.
List of curated datasets
Booking IDUnique identifier of the parent booking.id
string
Audit Log IDUnique identifier of the audit log entry (one row per audit log entry).audit_log_id
integer
User IDUnique identifier of the user who made this booking.user_id
string
User Contact IDUnique identifier of the user contact associated with this booking.user_contact_id
string
Admin User IDUnique identifier of the admin user who created or manages this booking.admin_user_id
string
Booking Status IDUnique identifier of the booking status recorded in this audit log entry.booking_status_id
integer
User Debtor Number Technical IDInternal technical identifier associated with the user's debtor number.user_debtor_number_technical_id
integer
Booking Start DateDate on which the parent booking starts.start_date
datetime
Payment Provider Status Last ModifiedDate and time the payment provider status was last updated.paymentprovider_status_last_modified
datetime
Booking Date AddedDate and time the parent booking was created.date_added
datetime
Booking Date Last ModifiedDate and time the parent booking was last modified.date_last_modified
datetime
Audit Log Date AddedDate and time this audit log entry was recorded.audit_log_date_added
datetime
User Date AddedDate and time the user account was created.user_date_added
datetime
User Date Last ModifiedDate and time the user account was last modified.user_date_last_modified
datetime
User Date Registration ApprovedDate and time the user's registration was approved.user_date_registration_approved
datetime
User Password Last ModifiedDate and time the user's password was last changed.user_password_last_modified
datetime
User Contact Date AddedDate and time the user contact record was created.user_contact_date_added
datetime
User Contact Date Last ModifiedDate and time the user contact record was last modified.user_contact_date_last_modified
datetime
Admin User Date Last Modified (Legacy)Legacy field for the date and time the admin user record was last modified.admin_user_date_lastmodified
datetime
Admin User Date Last ModifiedDate and time the admin user record was last modified.admin_user_date_last_modified
datetime
Booking TypeType of the parent booking (e.g. object, activity).type
string
Payment MethodPayment method used for this booking.paymentmethod
string
Payment ProviderPayment provider used to process payment for this booking.paymentprovider
string
Payment Provider StatusCurrent status returned by the payment provider for this booking.paymentprovider_status
string
Booking RemarksInternal remarks or notes on the parent booking.remarks
string
Booking External RemarksRemarks visible to the customer for the parent booking.external_remarks
string
Booking Purchase Order CodePurchase order code associated with this booking.booking_purchase_order_code
string
Booking Display NameHuman-readable display name for this booking.booking_display_name
string
Booking NumberHuman-readable sequential reference number for this booking.booking_number
string
Preferred LocalePreferred locale used for communications related to this booking (e.g. nl_NL, en_US).preferred_locale
string
Booking Status LabelMachine-readable label of the booking status recorded in this audit log entry (e.g. confirmed).booking_status_label
string
Booking Status Display NameHuman-readable display name of the booking status recorded in this audit log entry.booking_status_display_name
string
User CompanyCompany name associated with the user who made this booking.user_company
string
User First NameFirst name of the user who made this booking.user_firstname
sensitivestring
User Last NameLast name of the user who made this booking.user_name
sensitivestring
User Full NameFull name of the user who made this booking.user_full_name
sensitivestring
User UsernameLogin username of the user who made this booking.user_username
sensitivestring
User EmailEmail address of the user who made this booking.user_email
sensitivestring
User AddressStreet address of the user who made this booking.user_address
sensitivestring
User ZipcodePostal code of the user's address.user_zipcode
sensitivestring
User CityCity of the user's address.user_city
string
User CountryCountry of the user's address.user_country
string
User Telephone CountryCountry code prefix for the user's telephone number.user_telephone_country
string
User TelephoneTelephone number of the user.user_telephone
sensitivestring
User Registration SourceChannel or source through which the user registered.user_registration_source
string
User Company Attn InvoiceAttention name on company invoices for the user.user_company_attn_invoice
string
User DescriptionInternal description or notes for the user account.user_description
string
User Attn InvoiceAttention field on invoices addressed to the user.user_attn_invoice
string
User Invoice AddressInvoice street address for the user.user_address_invoice
sensitivestring
User Invoice ZipcodePostal code of the user's invoice address.user_zipcode_invoice
sensitivestring
User Invoice CityCity of the user's invoice address.user_city_invoice
string
User Invoice CountryCountry of the user's invoice address.user_country_invoice
string
User Invoice EmailEmail address used for sending invoices to the user.user_invoice_mail
sensitivestring
User Invoice Send MethodMethod used to deliver invoices to the user (e.g. email, post).user_invoice_send_method
string
User Peppol Address SchemePeppol electronic invoicing address scheme for the user.user_peppol_address_scheme
string
User Peppol AddressPeppol electronic invoicing address for the user.user_peppol_address
string
User Tax NumberTax identification number of the user.user_taxnumber
string
User Debtor NumberDebtor number assigned to the user for accounting purposes.user_debtor_number
string
User Override Purchase Order CodePurchase order code that overrides the default for this user.user_override_purchase_order_code
string
User RemarksFree-text remarks or notes associated with the user.user_remarks
string
User Password Policy VersionVersion of the password policy currently applied to the user.user_password_policy_version
string
User Preferred Email LocalePreferred locale used for email communications sent to the user.user_preferred_email_locale
string
User Free Field 1Custom free-text field 1 for the user.user_freefield_1
string
User Free Field 2Custom free-text field 2 for the user.user_freefield_2
string
User Free Field 3Custom free-text field 3 for the user.user_freefield_3
string
User Free Field 4Custom free-text field 4 for the user.user_freefield_4
string
User Free Field 5Custom free-text field 5 for the user.user_freefield_5
string
User Free Field 6Custom free-text field 6 for the user.user_freefield_6
string
User Free Field 7Custom free-text field 7 for the user.user_freefield_7
string
User Free Field 8Custom free-text field 8 for the user.user_freefield_8
string
User Free Field 9Custom free-text field 9 for the user.user_freefield_9
string
User Free Field 10Custom free-text field 10 for the user.user_freefield_10
string
User Contact EmailEmail address of the user contact.user_contact_email
sensitivestring
User Contact First NameFirst name of the user contact.user_contact_firstname
sensitivestring
User Contact Name PrefixName prefix or title of the user contact (e.g. Mr., Mrs.).user_contact_name_prefix
string
User Contact Last NameLast name of the user contact.user_contact_name
sensitivestring
User Contact Telephone CountryCountry code prefix for the user contact's telephone number.user_contact_telephone_country
string
User Contact Telephone NumberTelephone number of the user contact.user_contact_telephone_number
sensitivestring
User Contact RemarksFree-text remarks associated with the user contact.user_contact_remarks
string
User Contact Registration SourceChannel or source through which the user contact was registered.user_contact_registration_source
string
Admin User UsernameLogin username of the admin user.admin_user_username
string
Admin User First NameFirst name of the admin user.admin_user_firstname
string
Admin User Last NameLast name of the admin user.admin_user_name
string
Admin User Phone NumberPhone number of the admin user.admin_user_phone_number
string
Admin User Phone Number CountryCountry code prefix for the admin user's phone number.admin_user_phone_number_country
string
Admin User LocalePreferred locale of the admin user (e.g. nl_NL, en_US).admin_user_locale
string
Admin User Preferred Planboard ViewPreferred view mode the admin user has set for the planboard.admin_user_preferred_planboard_view
string
Admin User Preferred Planboard CompanyCompany filter preference the admin user has set on the planboard.admin_user_preferred_planboard_company
string
Admin User Preferred Planboard LocationLocation filter preference the admin user has set on the planboard.admin_user_preferred_planboard_location
string
Admin User Preferred Planboard Court TypeCourt type filter preference the admin user has set on the planboard.admin_user_preferred_planboard_court_type
string
Admin User Preferred Planboard ActivityActivity filter preference the admin user has set on the planboard.admin_user_preferred_planboard_activity
string
Admin User Preferred Planboard DisplayDisplay mode preference the admin user has set on the planboard (e.g. extended, compact).admin_user_preferred_planboard_display
string
Admin User Preferred Planboard LayoutLayout preference the admin user has set on the planboard (e.g. default).admin_user_preferred_planboard_layout
string
Admin User Preferred Planboard Booking IconsBooking icon style preference the admin user has set on the planboard.admin_user_preferred_planboard_booking_icons
string
Admin User Visible All Bookings ColumnsColumn visibility configuration the admin user has set in the all-bookings view.admin_user_visible_allbookings_columns
string
Booking StatusCurrent status code of the parent booking (e.g. 6 = confirmed).booking_status
integer
User Registration StatusRegistration status code of the user (e.g. 0 = pending, 1 = active, 2 = approved).user_registration_status
integer
User Invoice Payment Condition DaysNumber of days allowed for invoice payment by the user.user_invoice_paymentcondition_days
integer
Admin User LevelPermission level of the admin user.admin_user_level
integer
Exclude From NarrowcastingIndicates whether this booking is excluded from narrowcasting displays.exclude_from_narrowcasting
boolean
Booking Status VisibleIndicates whether the booking status recorded in this audit log entry is visible to customers.booking_status_visible
boolean
Booking Status StickyIndicates whether the booking status recorded in this audit log entry is sticky (not automatically overridden).booking_status_sticky
boolean
User ArchivedIndicates whether the user account has been archived.user_archived
boolean
User Password ChangeableIndicates whether the user is allowed to change their password.user_pass_changeable
boolean
User Newsletter SubscriptionIndicates whether the user is subscribed to the newsletter.user_newsletter_subscription
boolean
User Access Code Reminder SubscriptionIndicates whether the user is subscribed to access code reminders.user_access_code_reminder_subscription
boolean
User Exclude Bookings From NarrowcastingIndicates whether the user's bookings are excluded from narrowcasting displays.user_exclude_bookings_from_narrowcasting
boolean
User Is DeletedIndicates whether the user account has been deleted.user_is_deleted
boolean
User Contact ArchivedIndicates whether the user contact record has been archived.user_contact_archived
boolean
Admin User Is SupervisorIndicates whether the admin user has supervisor privileges.admin_user_is_supervisor
boolean
Admin User Display New Admin LayoutIndicates whether the admin user has the new admin layout enabled.admin_user_display_new_admin_layout
boolean
Admin User Sidebar Minified ViewIndicates whether the admin user has the sidebar in minified view.admin_user_sidebar_minified_view
boolean
Admin User Venueroo Notice DismissedIndicates whether the admin user has dismissed the Venueroo notice.admin_user_venueroo_notice_dismissed
boolean
Admin User Aqqo Information SentIndicates whether Aqqo onboarding information has been sent to the admin user.admin_user_aqqo_information_sent
boolean
Admin User Aqqo Notification ReadIndicates whether the admin user has read the latest Aqqo notification.admin_user_aqqo_notification_read
boolean
Admin User Is DeletedIndicates whether the admin user account has been deleted.admin_user_is_deleted
boolean
IDUnique identifier of the booking status.id
integer
LabelInternal label key of the booking status.label
string
Display NameHuman-readable name of the booking status shown in the interface.display_name
string
VisibleIndicates whether this booking status is visible to end users.visible
boolean
StickyIndicates whether bookings in this status are pinned and cannot be moved to other statuses automatically.sticky
boolean
Booking IDUnique identifier of the parent booking.id
string
Subbooking IDUnique identifier of the subbooking (one row per subbooking).subbooking_id
string
User IDUnique identifier of the user who made this booking.user_id
string
User Contact IDUnique identifier of the user contact associated with this booking.user_contact_id
string
Admin User IDUnique identifier of the admin user who created or manages this booking.admin_user_id
string
Court Room Setup IDIdentifier of the court room setup applied to this subbooking.court_room_setup_id
integer
User Debtor Number Technical IDInternal technical identifier associated with the user's debtor number.user_debtor_number_technical_id
integer
Booking Start DateDate on which the parent booking starts.start_date
datetime
Payment Provider Status Last ModifiedDate and time the payment provider status was last updated.paymentprovider_status_last_modified
datetime
Booking Date AddedDate and time the parent booking was created.date_added
datetime
Booking Date Last ModifiedDate and time the parent booking was last modified.date_last_modified
datetime
Subbooking DateCalendar date on which this subbooking takes place.subbooking_date
datetime
Subbooking Start Datetime UTCStart date and time of the subbooking in UTC.subbooking_start_datetime_utc
datetime
Subbooking Start DatetimeStart date and time of the subbooking in the local timezone.subbooking_start_datetime
datetime
Subbooking End Datetime UTCEnd date and time of the subbooking in UTC.subbooking_end_datetime_utc
datetime
Subbooking End DatetimeEnd date and time of the subbooking in the local timezone.subbooking_end_datetime
datetime
Subbooking Option Expiration Datetime UTCDate and time at which the subbooking option expires, in UTC.subbooking_option_expiration_datetime_utc
datetime
Subbooking Date AddedDate and time the subbooking was created.subbooking_date_added
datetime
Subbooking Date Last ModifiedDate and time the subbooking was last modified.subbooking_date_last_modified
datetime
User Date AddedDate and time the user account was created.user_date_added
datetime
User Date Last ModifiedDate and time the user account was last modified.user_date_last_modified
datetime
User Date Registration ApprovedDate and time the user's registration was approved.user_date_registration_approved
datetime
User Password Last ModifiedDate and time the user's password was last changed.user_password_last_modified
datetime
User Contact Date AddedDate and time the user contact record was created.user_contact_date_added
datetime
User Contact Date Last ModifiedDate and time the user contact record was last modified.user_contact_date_last_modified
datetime
Admin User Date Last Modified (Legacy)Legacy field for the date and time the admin user record was last modified.admin_user_date_lastmodified
datetime
Admin User Date Last ModifiedDate and time the admin user record was last modified.admin_user_date_last_modified
datetime
Booking TypeType of the parent booking (e.g. object, activity).type
string
Payment MethodPayment method used for this booking.paymentmethod
string
Payment ProviderPayment provider used to process payment for this booking.paymentprovider
string
Payment Provider StatusCurrent status returned by the payment provider for this booking.paymentprovider_status
string
Booking RemarksInternal remarks or notes on the parent booking.remarks
string
Booking External RemarksRemarks visible to the customer for the parent booking.external_remarks
string
Booking Purchase Order CodePurchase order code associated with this booking.booking_purchase_order_code
string
Booking Display NameHuman-readable display name for this booking.booking_display_name
string
Booking NumberHuman-readable sequential reference number for this booking.booking_number
string
Preferred LocalePreferred locale used for communications related to this booking (e.g. nl_NL, en_US).preferred_locale
string
Subbooking Start TimeStart time of the subbooking in HH:MM:SS format.subbooking_starttime
string
Subbooking End TimeEnd time of the subbooking in HH:MM:SS format.subbooking_endtime
string
Subbooking Activity Display NameDisplay name of the activity associated with this subbooking.subbooking_activity_display_name
string
Subbooking Purchase Order CodePurchase order code specific to this subbooking.subbooking_purchase_order_code
string
Subbooking RemarksInternal remarks or notes specific to this subbooking.subbooking_remarks
string
Subbooking External RemarksRemarks visible to the customer for this subbooking.subbooking_external_remarks
string
Subbooking Display NameHuman-readable display name for this subbooking.subbooking_display_name
string
Subbooking Creation SourceChannel or source through which this subbooking was created.subbooking_creation_source
string
Court Display NameDisplay name of the court assigned to this subbooking.court_display_name
string
Subbooking External Court Display NameExternal-facing display name of the court for this subbooking.subbooking_external_court_display_name
string
Subbooking Free Field 1Custom free-text field 1 for the subbooking.subbooking_freefield_1
string
Subbooking Free Field 2Custom free-text field 2 for the subbooking.subbooking_freefield_2
string
Subbooking Free Field 3Custom free-text field 3 for the subbooking.subbooking_freefield_3
string
Subbooking Free Field 4Custom free-text field 4 for the subbooking.subbooking_freefield_4
string
Subbooking Free Field 5Custom free-text field 5 for the subbooking.subbooking_freefield_5
string
Subbooking Free Field 6Custom free-text field 6 for the subbooking.subbooking_freefield_6
string
Subbooking Free Field 7Custom free-text field 7 for the subbooking.subbooking_freefield_7
string
Subbooking Free Field 8Custom free-text field 8 for the subbooking.subbooking_freefield_8
string
Subbooking Free Field 9Custom free-text field 9 for the subbooking.subbooking_freefield_9
string
Subbooking Free Field 10Custom free-text field 10 for the subbooking.subbooking_freefield_10
string
User CompanyCompany name associated with the user who made this booking.user_company
string
User First NameFirst name of the user who made this booking.user_firstname
sensitivestring
User Last NameLast name of the user who made this booking.user_name
sensitivestring
User Full NameFull name of the user who made this booking.user_full_name
sensitivestring
User UsernameLogin username of the user who made this booking.user_username
sensitivestring
User EmailEmail address of the user who made this booking.user_email
sensitivestring
User AddressStreet address of the user who made this booking.user_address
sensitivestring
User ZipcodePostal code of the user's address.user_zipcode
sensitivestring
User CityCity of the user's address.user_city
string
User CountryCountry of the user's address.user_country
string
User Telephone CountryCountry code prefix for the user's telephone number.user_telephone_country
string
User TelephoneTelephone number of the user.user_telephone
sensitivestring
User Registration SourceChannel or source through which the user registered.user_registration_source
string
User Company Attn InvoiceAttention name on company invoices for the user.user_company_attn_invoice
string
User DescriptionInternal description or notes for the user account.user_description
string
User Attn InvoiceAttention field on invoices addressed to the user.user_attn_invoice
string
User Invoice AddressInvoice street address for the user.user_address_invoice
sensitivestring
User Invoice ZipcodePostal code of the user's invoice address.user_zipcode_invoice
sensitivestring
User Invoice CityCity of the user's invoice address.user_city_invoice
string
User Invoice CountryCountry of the user's invoice address.user_country_invoice
string
User Invoice EmailEmail address used for sending invoices to the user.user_invoice_mail
sensitivestring
User Invoice Send MethodMethod used to deliver invoices to the user (e.g. email, post).user_invoice_send_method
string
User Peppol Address SchemePeppol electronic invoicing address scheme for the user.user_peppol_address_scheme
string
User Peppol AddressPeppol electronic invoicing address for the user.user_peppol_address
string
User Tax NumberTax identification number of the user.user_taxnumber
string
User Debtor NumberDebtor number assigned to the user for accounting purposes.user_debtor_number
string
User Override Purchase Order CodePurchase order code that overrides the default for this user.user_override_purchase_order_code
string
User RemarksFree-text remarks or notes associated with the user.user_remarks
string
User Password Policy VersionVersion of the password policy currently applied to the user.user_password_policy_version
string
User Preferred Email LocalePreferred locale used for email communications sent to the user.user_preferred_email_locale
string
User Free Field 1Custom free-text field 1 for the user.user_freefield_1
string
User Free Field 2Custom free-text field 2 for the user.user_freefield_2
string
User Free Field 3Custom free-text field 3 for the user.user_freefield_3
string
User Free Field 4Custom free-text field 4 for the user.user_freefield_4
string
User Free Field 5Custom free-text field 5 for the user.user_freefield_5
string
User Free Field 6Custom free-text field 6 for the user.user_freefield_6
string
User Free Field 7Custom free-text field 7 for the user.user_freefield_7
string
User Free Field 8Custom free-text field 8 for the user.user_freefield_8
string
User Free Field 9Custom free-text field 9 for the user.user_freefield_9
string
User Free Field 10Custom free-text field 10 for the user.user_freefield_10
string
User Contact EmailEmail address of the user contact.user_contact_email
sensitivestring
User Contact First NameFirst name of the user contact.user_contact_firstname
sensitivestring
User Contact Name PrefixName prefix or title of the user contact (e.g. Mr., Mrs.).user_contact_name_prefix
string
User Contact Last NameLast name of the user contact.user_contact_name
sensitivestring
User Contact Telephone CountryCountry code prefix for the user contact's telephone number.user_contact_telephone_country
string
User Contact Telephone NumberTelephone number of the user contact.user_contact_telephone_number
sensitivestring
User Contact RemarksFree-text remarks associated with the user contact.user_contact_remarks
string
User Contact Registration SourceChannel or source through which the user contact was registered.user_contact_registration_source
string
Admin User UsernameLogin username of the admin user.admin_user_username
string
Admin User First NameFirst name of the admin user.admin_user_firstname
string
Admin User Last NameLast name of the admin user.admin_user_name
string
Admin User Phone NumberPhone number of the admin user.admin_user_phone_number
string
Admin User Phone Number CountryCountry code prefix for the admin user's phone number.admin_user_phone_number_country
string
Admin User LocalePreferred locale of the admin user (e.g. nl_NL, en_US).admin_user_locale
string
Admin User Preferred Planboard ViewPreferred view mode the admin user has set for the planboard.admin_user_preferred_planboard_view
string
Admin User Preferred Planboard CompanyCompany filter preference the admin user has set on the planboard.admin_user_preferred_planboard_company
string
Admin User Preferred Planboard LocationLocation filter preference the admin user has set on the planboard.admin_user_preferred_planboard_location
string
Admin User Preferred Planboard Court TypeCourt type filter preference the admin user has set on the planboard.admin_user_preferred_planboard_court_type
string
Admin User Preferred Planboard ActivityActivity filter preference the admin user has set on the planboard.admin_user_preferred_planboard_activity
string
Admin User Preferred Planboard DisplayDisplay mode preference the admin user has set on the planboard (e.g. extended, compact).admin_user_preferred_planboard_display
string
Admin User Preferred Planboard LayoutLayout preference the admin user has set on the planboard (e.g. default).admin_user_preferred_planboard_layout
string
Admin User Preferred Planboard Booking IconsBooking icon style preference the admin user has set on the planboard.admin_user_preferred_planboard_booking_icons
string
Admin User Visible All Bookings ColumnsColumn visibility configuration the admin user has set in the all-bookings view.admin_user_visible_allbookings_columns
string
Booking StatusStatus code of the parent booking (e.g. 6 = confirmed).booking_status
integer
Court Start SlotSlot index at which the subbooking starts on the court.court_start_slot
integer
Court Number of SlotsNumber of court slots occupied by this subbooking.court_number_of_slots
integer
Subbooking ParticipantsNumber of participants registered for this subbooking.subbooking_participants
integer
Subbooking Sort OrderSort order of this subbooking within the parent booking.subbooking_sort_order
integer
Subbooking CostsTotal cost amount for this subbooking.subbooking_costs
float
Subbooking Price Incl VATPrice of this subbooking including VAT.subbooking_price_incl_vat
float
Subbooking Price Excl VATPrice of this subbooking excluding VAT.subbooking_price_excl_vat
float
Subbooking Price VATVAT amount for this subbooking.subbooking_price_vat
float
User Registration StatusRegistration status code of the user (e.g. 0 = pending, 1 = active, 2 = approved).user_registration_status
integer
User Invoice Payment Condition DaysNumber of days allowed for invoice payment by the user.user_invoice_paymentcondition_days
integer
Admin User LevelPermission level of the admin user.admin_user_level
integer
Exclude From NarrowcastingIndicates whether this booking is excluded from narrowcasting displays.exclude_from_narrowcasting
boolean
Subbooking ExclusiveIndicates whether this subbooking has exclusive use of the court.subbooking_exclusive
boolean
Subbooking Is Manual PriceIndicates whether the price for this subbooking was set manually.subbooking_is_manual_price
boolean
Subbooking Is Manually OverwrittenIndicates whether this subbooking's data has been manually overwritten.subbooking_is_manually_overwritten
boolean
Subbooking Is LockedIndicates whether this subbooking is locked from further edits.subbooking_is_locked
boolean
User ArchivedIndicates whether the user account has been archived.user_archived
boolean
User Password ChangeableIndicates whether the user is allowed to change their password.user_pass_changeable
boolean
User Newsletter SubscriptionIndicates whether the user is subscribed to the newsletter.user_newsletter_subscription
boolean
User Access Code Reminder SubscriptionIndicates whether the user is subscribed to access code reminders.user_access_code_reminder_subscription
boolean
User Exclude Bookings From NarrowcastingIndicates whether the user's bookings are excluded from narrowcasting displays.user_exclude_bookings_from_narrowcasting
boolean
User Is DeletedIndicates whether the user account has been deleted.user_is_deleted
boolean
User Contact ArchivedIndicates whether the user contact record has been archived.user_contact_archived
boolean
Admin User Is SupervisorIndicates whether the admin user has supervisor privileges.admin_user_is_supervisor
boolean
Admin User Display New Admin LayoutIndicates whether the admin user has the new admin layout enabled.admin_user_display_new_admin_layout
boolean
Admin User Sidebar Minified ViewIndicates whether the admin user has the sidebar in minified view.admin_user_sidebar_minified_view
boolean
Admin User Venueroo Notice DismissedIndicates whether the admin user has dismissed the Venueroo notice.admin_user_venueroo_notice_dismissed
boolean
Admin User Aqqo Information SentIndicates whether Aqqo onboarding information has been sent to the admin user.admin_user_aqqo_information_sent
boolean
Admin User Aqqo Notification ReadIndicates whether the admin user has read the latest Aqqo notification.admin_user_aqqo_notification_read
boolean
Admin User Is DeletedIndicates whether the admin user account has been deleted.admin_user_is_deleted
boolean
IDUnique identifier of the booking.id
string
User IDUnique identifier of the user who made this booking.user_id
string
User Contact IDUnique identifier of the user contact associated with this booking.user_contact_id
string
Admin User IDUnique identifier of the admin user who created or manages this booking.admin_user_id
string
User Debtor Number Technical IDInternal technical identifier associated with the user's debtor number.user_debtor_number_technical_id
integer
Start DateDate on which the booking starts.start_date
datetime
Payment Provider Status Last ModifiedDate and time the payment provider status was last updated.paymentprovider_status_last_modified
datetime
Date AddedDate and time the booking was created.date_added
datetime
Date Last ModifiedDate and time the booking was last modified.date_last_modified
datetime
User Date AddedDate and time the user account was created.user_date_added
datetime
User Date Last ModifiedDate and time the user account was last modified.user_date_last_modified
datetime
User Date Registration ApprovedDate and time the user's registration was approved.user_date_registration_approved
datetime
User Password Last ModifiedDate and time the user's password was last changed.user_password_last_modified
datetime
User Contact Date AddedDate and time the user contact record was created.user_contact_date_added
datetime
User Contact Date Last ModifiedDate and time the user contact record was last modified.user_contact_date_last_modified
datetime
Admin User Date Last Modified (Legacy)Legacy field for the date and time the admin user record was last modified.admin_user_date_lastmodified
datetime
Admin User Date Last ModifiedDate and time the admin user record was last modified.admin_user_date_last_modified
datetime
TypeType of the booking (e.g. object, activity).type
string
Payment MethodPayment method used for this booking.paymentmethod
string
Payment ProviderPayment provider used to process payment for this booking.paymentprovider
string
Payment Provider StatusCurrent status returned by the payment provider for this booking.paymentprovider_status
string
RemarksInternal remarks or notes on this booking.remarks
string
External RemarksRemarks visible to the customer for this booking.external_remarks
string
Booking Purchase Order CodePurchase order code associated with this booking.booking_purchase_order_code
string
Booking Display NameHuman-readable display name for this booking.booking_display_name
string
Booking NumberHuman-readable sequential reference number for this booking.booking_number
string
Preferred LocalePreferred locale used for communications related to this booking (e.g. nl_NL, en_US).preferred_locale
string
User CompanyCompany name associated with the user who made this booking.user_company
string
User First NameFirst name of the user who made this booking.user_firstname
sensitivestring
User Last NameLast name of the user who made this booking.user_name
sensitivestring
User Full NameFull name of the user who made this booking.user_full_name
sensitivestring
User UsernameLogin username of the user who made this booking.user_username
sensitivestring
User EmailEmail address of the user who made this booking.user_email
sensitivestring
User AddressStreet address of the user who made this booking.user_address
sensitivestring
User ZipcodePostal code of the user's address.user_zipcode
sensitivestring
User CityCity of the user's address.user_city
string
User CountryCountry of the user's address.user_country
string
User Telephone CountryCountry code prefix for the user's telephone number.user_telephone_country
string
User TelephoneTelephone number of the user.user_telephone
sensitivestring
User Registration SourceChannel or source through which the user registered.user_registration_source
string
User Company Attn InvoiceAttention name on company invoices for the user.user_company_attn_invoice
string
User DescriptionInternal description or notes for the user account.user_description
string
User Attn InvoiceAttention field on invoices addressed to the user.user_attn_invoice
string
User Invoice AddressInvoice street address for the user.user_address_invoice
sensitivestring
User Invoice ZipcodePostal code of the user's invoice address.user_zipcode_invoice
sensitivestring
User Invoice CityCity of the user's invoice address.user_city_invoice
string
User Invoice CountryCountry of the user's invoice address.user_country_invoice
string
User Invoice EmailEmail address used for sending invoices to the user.user_invoice_mail
sensitivestring
User Invoice Send MethodMethod used to deliver invoices to the user (e.g. email, post).user_invoice_send_method
string
User Peppol Address SchemePeppol electronic invoicing address scheme for the user.user_peppol_address_scheme
string
User Peppol AddressPeppol electronic invoicing address for the user.user_peppol_address
string
User Tax NumberTax identification number of the user.user_taxnumber
string
User Debtor NumberDebtor number assigned to the user for accounting purposes.user_debtor_number
string
User Override Purchase Order CodePurchase order code that overrides the default for this user.user_override_purchase_order_code
string
User RemarksFree-text remarks or notes associated with the user.user_remarks
string
User Password Policy VersionVersion of the password policy currently applied to the user.user_password_policy_version
string
User Preferred Email LocalePreferred locale used for email communications sent to the user.user_preferred_email_locale
string
User Free Field 1Custom free-text field 1 for the user.user_freefield_1
string
User Free Field 2Custom free-text field 2 for the user.user_freefield_2
string
User Free Field 3Custom free-text field 3 for the user.user_freefield_3
string
User Free Field 4Custom free-text field 4 for the user.user_freefield_4
string
User Free Field 5Custom free-text field 5 for the user.user_freefield_5
string
User Free Field 6Custom free-text field 6 for the user.user_freefield_6
string
User Free Field 7Custom free-text field 7 for the user.user_freefield_7
string
User Free Field 8Custom free-text field 8 for the user.user_freefield_8
string
User Free Field 9Custom free-text field 9 for the user.user_freefield_9
string
User Free Field 10Custom free-text field 10 for the user.user_freefield_10
string
User Contact EmailEmail address of the user contact.user_contact_email
sensitivestring
User Contact First NameFirst name of the user contact.user_contact_firstname
sensitivestring
User Contact Name PrefixName prefix or title of the user contact (e.g. Mr., Mrs.).user_contact_name_prefix
string
User Contact Last NameLast name of the user contact.user_contact_name
sensitivestring
User Contact Telephone CountryCountry code prefix for the user contact's telephone number.user_contact_telephone_country
string
User Contact Telephone NumberTelephone number of the user contact.user_contact_telephone_number
sensitivestring
User Contact RemarksFree-text remarks associated with the user contact.user_contact_remarks
string
User Contact Registration SourceChannel or source through which the user contact was registered.user_contact_registration_source
string
Admin User UsernameLogin username of the admin user.admin_user_username
string
Admin User First NameFirst name of the admin user.admin_user_firstname
string
Admin User Last NameLast name of the admin user.admin_user_name
string
Admin User Phone NumberPhone number of the admin user.admin_user_phone_number
string
Admin User Phone Number CountryCountry code prefix for the admin user's phone number.admin_user_phone_number_country
string
Admin User LocalePreferred locale of the admin user (e.g. nl_NL, en_US).admin_user_locale
string
Admin User Preferred Planboard ViewPreferred view mode the admin user has set for the planboard.admin_user_preferred_planboard_view
string
Admin User Preferred Planboard CompanyCompany filter preference the admin user has set on the planboard.admin_user_preferred_planboard_company
string
Admin User Preferred Planboard LocationLocation filter preference the admin user has set on the planboard.admin_user_preferred_planboard_location
string
Admin User Preferred Planboard Court TypeCourt type filter preference the admin user has set on the planboard.admin_user_preferred_planboard_court_type
string
Admin User Preferred Planboard ActivityActivity filter preference the admin user has set on the planboard.admin_user_preferred_planboard_activity
string
Admin User Preferred Planboard DisplayDisplay mode preference the admin user has set on the planboard (e.g. extended, compact).admin_user_preferred_planboard_display
string
Admin User Preferred Planboard LayoutLayout preference the admin user has set on the planboard (e.g. default).admin_user_preferred_planboard_layout
string
Admin User Preferred Planboard Booking IconsBooking icon style preference the admin user has set on the planboard.admin_user_preferred_planboard_booking_icons
string
Admin User Visible All Bookings ColumnsColumn visibility configuration the admin user has set in the all-bookings view.admin_user_visible_allbookings_columns
string
Booking StatusStatus code of the booking (e.g. 6 = confirmed).booking_status
integer
User Registration StatusRegistration status code of the user (e.g. 0 = pending, 1 = active, 2 = approved).user_registration_status
integer
User Invoice Payment Condition DaysNumber of days allowed for invoice payment by the user.user_invoice_paymentcondition_days
integer
Admin User LevelPermission level of the admin user.admin_user_level
integer
Exclude From NarrowcastingIndicates whether this booking is excluded from narrowcasting displays.exclude_from_narrowcasting
boolean
User ArchivedIndicates whether the user account has been archived.user_archived
boolean
User Password ChangeableIndicates whether the user is allowed to change their password.user_pass_changeable
boolean
User Newsletter SubscriptionIndicates whether the user is subscribed to the newsletter.user_newsletter_subscription
boolean
User Access Code Reminder SubscriptionIndicates whether the user is subscribed to access code reminders.user_access_code_reminder_subscription
boolean
User Exclude Bookings From NarrowcastingIndicates whether the user's bookings are excluded from narrowcasting displays.user_exclude_bookings_from_narrowcasting
boolean
User Is DeletedIndicates whether the user account has been deleted.user_is_deleted
boolean
User Contact ArchivedIndicates whether the user contact record has been archived.user_contact_archived
boolean
Admin User Is SupervisorIndicates whether the admin user has supervisor privileges.admin_user_is_supervisor
boolean
Admin User Display New Admin LayoutIndicates whether the admin user has the new admin layout enabled.admin_user_display_new_admin_layout
boolean
Admin User Sidebar Minified ViewIndicates whether the admin user has the sidebar in minified view.admin_user_sidebar_minified_view
boolean
Admin User Venueroo Notice DismissedIndicates whether the admin user has dismissed the Venueroo notice.admin_user_venueroo_notice_dismissed
boolean
Admin User Aqqo Information SentIndicates whether Aqqo onboarding information has been sent to the admin user.admin_user_aqqo_information_sent
boolean
Admin User Aqqo Notification ReadIndicates whether the admin user has read the latest Aqqo notification.admin_user_aqqo_notification_read
boolean
Admin User Is DeletedIndicates whether the admin user account has been deleted.admin_user_is_deleted
boolean
IDUnique identifier of the company.id
string
Location IDUnique identifier of the location associated with this company.location_id
string
Location Mail Sender IDIdentifier of the mail sender associated with the location.location_mail_sender_id
integer
Date AddedDate and time the company was created.date_added
datetime
Date Last ModifiedDate and time the company was last modified.date_last_modified
datetime
Location Date AddedDate and time the location was created.location_date_added
datetime
Location Date Last ModifiedDate and time the location was last modified.location_date_last_modified
datetime
NameLegal or trading name of the company.name
string
AttentionContact person name for correspondence directed to this company.attn
sensitivestring
AddressStreet address of the company.address
string
Zip CodePostal code of the company.zipcode
string
CityCity of the company.city
string
CountryCountry code of the company.country
string
VAT CodeVAT registration number of the company.vat_code
string
KVK NumberDutch Chamber of Commerce (KVK) registration number.kvk_number
string
IBAN NumberBank account IBAN number of the company.iban_number
sensitivestring
Invoice Contact PhonePhone number of the invoice contact.invoice_contact_phone
sensitivestring
Invoice Contact Phone CountryCountry code associated with the invoice contact phone number.invoice_contact_phone_country
string
Invoice Contact EmailEmail address of the invoice contact.invoice_contact_email
sensitivestring
Invoice Contact Copy EmailCC email address for invoice copies.invoice_contact_copy_email
sensitivestring
Invoice Number PrefixPrefix prepended to invoice numbers (e.g. year or company code).invoice_number_prefix
string
Location NameDefault name of the location.location_name
string
Location Name (nl-NL)Name of the location in Dutch (Netherlands).location_name_nl_NL
string
Location Name (en-US)Name of the location in English (United States).location_name_en_US
string
Location Name (de-DE)Name of the location in German (Germany).location_name_de_DE
string
Location Name (fy-NL)Name of the location in Frisian (Netherlands).location_name_fy_NL
string
Location Name (fr-FR)Name of the location in French (France).location_name_fr_FR
string
Location DescriptionDefault description of the location.location_description
string
Location Description (nl-NL)Description of the location in Dutch (Netherlands).location_description_nl_NL
string
Location Description (en-US)Description of the location in English (United States).location_description_en_US
string
Location Description (de-DE)Description of the location in German (Germany).location_description_de_DE
string
Location Description (fy-NL)Description of the location in Frisian (Netherlands).location_description_fy_NL
string
Location Description (fr-FR)Description of the location in French (France).location_description_fr_FR
string
Location Court AliasAlias used for a court at this location.location_court_alias
string
Location Court Alias (Plural)Plural alias used for courts at this location.location_court_alias_plural
string
Location AddressStreet address of the location.location_address
string
Location Zip CodePostal code of the location.location_zipcode
string
Location CityCity of the location.location_city
string
Location CountryCountry code of the location.location_country
string
Location Phone NumberPhone number of the location.location_phone_number
sensitivestring
Location Phone Number CountryCountry code associated with the location phone number.location_phone_number_country
string
Location Booking Notification EmailEmail address used for booking notifications at this location.location_booking_notification_email
sensitivestring
Location Divergent IBAN NumberAlternative IBAN number used for this location.location_divergent_iban_number
sensitivestring
Location Holiday CountryCountry code used for public holiday calculations at this location.location_holiday_country
string
Location Holiday RegionRegion used for public holiday calculations at this location.location_holiday_region
string
Location POS Turnover Date IntervalInterval used to determine the POS turnover date at this location.location_pos_turnover_date_interval
string
LatitudeGeographic latitude coordinate of the company.latitude
float
LongitudeGeographic longitude coordinate of the company.longitude
float
Invoice Number Leading ZerosNumber of leading zeros applied to invoice number sequences.invoice_number_leading_zeros
integer
Invoice Start CounterStarting number for the invoice counter.invoice_start_counter
integer
Invoice Payment Condition DaysNumber of days allowed for invoice payment.invoice_payment_condition_days
integer
Sort OrderDisplay sort order of the company.sort_order
integer
Location LatitudeGeographic latitude coordinate of the location.location_latitude
float
Location LongitudeGeographic longitude coordinate of the location.location_longitude
float
Location Sort OrderDisplay sort order of the location.location_sort_order
integer
Invoice Restart Number AnnuallyIndicates whether the invoice counter resets at the start of each year.invoice_restart_number_annually
boolean
Is DeletedIndicates whether the company has been deleted.is_deleted
boolean
Location Is DeletedIndicates whether the location has been deleted.location_is_deleted
boolean
IDUnique identifier of the court group.id
integer
Date AddedDate and time the court group was created.date_added
datetime
Date Last ModifiedDate and time the court group was last modified.date_last_modified
datetime
Display NameDisplay name of the court group.court_group_display_name
string
Aggregated For Booking ProcessIndicates whether courts in this group are aggregated during the booking process.court_group_aggregated_for_booking_process
boolean
Aggregated For Price SettingsIndicates whether courts in this group are aggregated for price configuration.court_group_aggregated_for_price_settings
boolean
Participants EnabledIndicates whether participant tracking is enabled for bookings in this court group.court_group_participants_enabled
boolean
Aggregated For Admin Booking ProcessIndicates whether courts in this group are aggregated in the admin booking process.court_group_aggregated_for_admin_booking_process
boolean
Court Tile EnabledIndicates whether the court tile view is enabled for this court group.court_group_court_tile_enabled
boolean
IDUnique identifier of the court type.id
integer
Date AddedDate and time the court type was created.date_added
datetime
Date Last ModifiedDate and time the court type was last modified.date_last_modified
datetime
Display NameDisplay name of the court type.display_name
string
Court AliasSingular alias used to refer to courts of this type (e.g. Field, Lane, Table).court_alias
string
Court Alias PluralPlural alias used to refer to courts of this type (e.g. Fields, Lanes, Tables).court_alias_plural
string
Sort OrderDisplay sort order of the court type relative to other court types.sort_order
integer
IDUnique identifier of the court.id
string
Location IDUnique identifier of the location this court belongs to.location_id
string
Court Group IDUnique identifier of the court group this court belongs to.court_group_id
integer
Location Mail Sender IDIdentifier of the mail sender associated with the location.location_mail_sender_id
integer
Date AddedDate and time the court was created.date_added
datetime
Date Last ModifiedDate and time the court was last modified.date_last_modified
datetime
Location Date AddedDate and time the location was created.location_date_added
datetime
Location Date Last ModifiedDate and time the location was last modified.location_date_last_modified
datetime
Court Group Date AddedDate and time the court group was created.court_group_date_added
datetime
Court Group Date Last ModifiedDate and time the court group was last modified.court_group_date_last_modified
datetime
NameDisplay name of the court.name
string
Court DescriptionOptional description of the court.court_description
string
Court Group DescriptionDescription of the group this court belongs to.court_group_description
string
Document Template Court Group DescriptionCourt group description used in document templates.document_template_court_group_description
string
LevelAccess level required to book this court (e.g. USER, ADMIN).level
string
Booking Starting MinuteAllowed booking start times within an hour (e.g. *:00, *:30).booking_starting_minute
string
Free Field 1Custom free-text field 1.freefield_1
string
Free Field 2Custom free-text field 2.freefield_2
string
Free Field 3Custom free-text field 3.freefield_3
string
Free Field 4Custom free-text field 4.freefield_4
string
Free Field 5Custom free-text field 5.freefield_5
string
Free Field 6Custom free-text field 6.freefield_6
string
Free Field 7Custom free-text field 7.freefield_7
string
Free Field 8Custom free-text field 8.freefield_8
string
Free Field 9Custom free-text field 9.freefield_9
string
Free Field 10Custom free-text field 10.freefield_10
string
Location NameDefault name of the location this court belongs to.location_name
string
Location Name (nl-NL)Name of the location in Dutch (Netherlands).location_name_nl_NL
string
Location Name (en-US)Name of the location in English (United States).location_name_en_US
string
Location Name (de-DE)Name of the location in German (Germany).location_name_de_DE
string
Location Name (fy-NL)Name of the location in Frisian (Netherlands).location_name_fy_NL
string
Location Name (fr-FR)Name of the location in French (France).location_name_fr_FR
string
Location DescriptionDefault description of the location.location_description
string
Location Description (nl-NL)Description of the location in Dutch (Netherlands).location_description_nl_NL
string
Location Description (en-US)Description of the location in English (United States).location_description_en_US
string
Location Description (de-DE)Description of the location in German (Germany).location_description_de_DE
string
Location Description (fy-NL)Description of the location in Frisian (Netherlands).location_description_fy_NL
string
Location Description (fr-FR)Description of the location in French (France).location_description_fr_FR
string
Location Court AliasAlias used for a court at this location.location_court_alias
string
Location Court Alias (Plural)Plural alias used for courts at this location.location_court_alias_plural
string
Location AddressStreet address of the location.location_address
string
Location Zip CodePostal code of the location.location_zipcode
string
Location CityCity of the location.location_city
string
Location CountryCountry code of the location.location_country
string
Location Phone NumberPhone number of the location.location_phone_number
sensitivestring
Location Phone Number CountryCountry code associated with the location phone number.location_phone_number_country
string
Location Booking Notification EmailEmail address used for booking notifications at this location.location_booking_notification_email
sensitivestring
Location Divergent IBAN NumberAlternative IBAN number used for this location.location_divergent_iban_number
sensitivestring
Location Holiday CountryCountry code used for public holiday calculations at this location.location_holiday_country
string
Location Holiday RegionRegion used for public holiday calculations at this location.location_holiday_region
string
Location POS Turnover Date IntervalInterval used to determine the POS turnover date at this location.location_pos_turnover_date_interval
string
Court Group Display NameHuman-readable name of the court group.court_group_display_name
string
NumberNumeric identifier of the court within its location.number
integer
Minimum Time Per BookingMinimum booking duration in minutes.minimum_time_per_booking
integer
Minimum Time Per Booking (Calculated)Calculated minimum booking duration in minutes.minimum_time_per_booking_calculated
integer
Minimum Additional Time Per BookingMinimum additional time that must be booked alongside a booking, in minutes.minimum_additional_time_per_booking
integer
Minimum Additional Time Per Booking (Calculated)Calculated minimum additional booking time in minutes.minimum_additional_time_per_booking_calculated
integer
Maximum Time Per BookingMaximum booking duration in minutes (0 = unlimited).maximum_time_per_booking
integer
Maximum Time Per Booking (Calculated)Calculated maximum booking duration in minutes.maximum_time_per_booking_calculated
integer
Blocked Minutes After BookingNumber of minutes blocked after each booking ends.blocked_minutes_after_booking
integer
Min Co-User RequiredMinimum number of co-users required to make a booking.min_co_user_required
integer
Warning CapacityCapacity threshold at which a warning is triggered for this court.warning_capacity
integer
Max CapacityMaximum number of participants allowed on this court.max_capacity
integer
Location LatitudeGeographic latitude coordinate of the location.location_latitude
float
Location LongitudeGeographic longitude coordinate of the location.location_longitude
float
Location Sort OrderDisplay sort order of the location.location_sort_order
integer
InternalIndicates whether the court is restricted to internal bookings only.internal
boolean
DivisibleIndicates whether the court can be split into sub-courts.divisible
boolean
Slots Configurable (12/12)Indicates whether full-hour (12/12) slot configuration is enabled.12_12_slots_configurable
boolean
Slots Configurable (6/12)Indicates whether half-hour (6/12) slot configuration is enabled.6_12_slots_configurable
boolean
Slots Configurable (4/12)Indicates whether 4/12-hour slot configuration is enabled.4_12_slots_configurable
boolean
Slots Configurable (3/12)Indicates whether quarter-hour (3/12) slot configuration is enabled.3_12_slots_configurable
boolean
Slots Configurable (2/12)Indicates whether 2/12-hour slot configuration is enabled.2_12_slots_configurable
boolean
Slots Configurable (1/12)Indicates whether 1/12-hour slot configuration is enabled.1_12_slots_configurable
boolean
Time Restrictions Backend EnabledIndicates whether backend time restriction rules are active for this court.time_restrictions_backend_enabled
boolean
Co-User SelectableIndicates whether co-users can be selected when booking this court.co_user_selectable
boolean
Strict Court Schedule HandlingIndicates whether strict schedule enforcement is applied to this court.strict_court_schedule_handling
boolean
Force Adjacent BookingsIndicates whether bookings must be placed adjacent to existing ones.force_adjacent_bookings
boolean
Allow Bookings Over Multiple DaysIndicates whether bookings spanning multiple days are allowed.allow_bookings_over_multiple_days
boolean
Capacity Based CourtIndicates whether this court uses capacity-based booking.capacity_based_court
boolean
Is DeletedIndicates whether the court has been deleted.is_deleted
boolean
Location Is DeletedIndicates whether the location has been deleted.location_is_deleted
boolean
Court Group Aggregated For Booking ProcessIndicates whether courts in this group are aggregated in the booking process.court_group_aggregated_for_booking_process
boolean
Court Group Aggregated For Price SettingsIndicates whether courts in this group share price settings.court_group_aggregated_for_price_settings
boolean
Court Group Participants EnabledIndicates whether participant tracking is enabled for this court group.court_group_participants_enabled
boolean
Court Group Aggregated For Admin Booking ProcessIndicates whether courts in this group are aggregated in the admin booking process.court_group_aggregated_for_admin_booking_process
boolean
Court Group Court Tile EnabledIndicates whether the court tile display is enabled for this court group.court_group_court_tile_enabled
boolean
IDUnique identifier of the export partner.id
integer
NameDisplay name of the export partner (e.g. Twinfield).name
string
CategoryCategory of the export partner (e.g. accountancy).category
string
LevelScope at which the export partner operates (e.g. company, location).level
string
Export TypeFile or protocol format used for the export (e.g. xml, csv).export_type
string
Auth TypeAuthentication method required by the export partner (e.g. none, oauth).auth_type
string
Tech Class NameInternal class name of the export partner implementation.tech_classname
string
EnabledIndicates whether the export partner is enabled for the tenant.enabled
boolean
IDUnique identifier of the location.id
string
Court IDUnique identifier of the court at this location.court_id
string
Company IDUnique identifier of the company this location belongs to.company_id
string
Mail Sender IDIdentifier of the mail sender associated with this location.mail_sender_id
integer
Date AddedDate and time the location was created.date_added
datetime
Date Last ModifiedDate and time the location was last modified.date_last_modified
datetime
Company Date AddedDate and time the company was created.company_date_added
datetime
Company Date Last ModifiedDate and time the company was last modified.company_date_last_modified
datetime
Court Date AddedDate and time the court was created.court_date_added
datetime
Court Date Last ModifiedDate and time the court was last modified.court_date_last_modified
datetime
NameDefault name of the location.name
string
Name (nl-NL)Name of the location in Dutch (Netherlands).name_nl_NL
string
Name (en-US)Name of the location in English (United States).name_en_US
string
Name (de-DE)Name of the location in German (Germany).name_de_DE
string
Name (fy-NL)Name of the location in Frisian (Netherlands).name_fy_NL
string
Name (fr-FR)Name of the location in French (France).name_fr_FR
string
DescriptionDefault description of the location.description
string
Description (nl-NL)Description of the location in Dutch (Netherlands).description_nl_NL
string
Description (en-US)Description of the location in English (United States).description_en_US
string
Description (de-DE)Description of the location in German (Germany).description_de_DE
string
Description (fy-NL)Description of the location in Frisian (Netherlands).description_fy_NL
string
Description (fr-FR)Description of the location in French (France).description_fr_FR
string
Court AliasAlias used for a court at this location.court_alias
string
Court Alias (Plural)Plural alias used for courts at this location.court_alias_plural
string
AddressStreet address of the location.address
string
Zip CodePostal code of the location.zipcode
string
CityCity of the location.city
string
CountryCountry code of the location.country
string
Phone NumberPhone number of the location.phone_number
sensitivestring
Phone Number CountryCountry code associated with the phone number.phone_number_country
string
Booking Notification EmailEmail address used for booking notifications.booking_notification_email
sensitivestring
Divergent IBAN NumberAlternative IBAN number used for this location.divergent_iban_number
sensitivestring
Holiday CountryCountry code used for public holiday calculations.holiday_country
string
Holiday RegionRegion used for public holiday calculations.holiday_region
string
POS Turnover Date IntervalInterval used to determine the POS turnover date.pos_turnover_date_interval
string
Company NameLegal or trading name of the company this location belongs to.company_name
string
Company AttentionContact person name for correspondence directed to the company.company_attn
sensitivestring
Company AddressStreet address of the company.company_address
string
Company Zip CodePostal code of the company.company_zipcode
string
Company CityCity of the company.company_city
string
Company CountryCountry code of the company.company_country
string
Company VAT CodeVAT registration number of the company.company_vat_code
string
Company KVK NumberDutch Chamber of Commerce (KVK) registration number of the company.company_kvk_number
string
Company IBAN NumberBank account IBAN number of the company.company_iban_number
sensitivestring
Company Invoice Contact PhonePhone number of the company invoice contact.company_invoice_contact_phone
sensitivestring
Company Invoice Contact Phone CountryCountry code associated with the company invoice contact phone number.company_invoice_contact_phone_country
string
Company Invoice Contact EmailEmail address of the company invoice contact.company_invoice_contact_email
sensitivestring
Company Invoice Contact Copy EmailCC email address for company invoice copies.company_invoice_contact_copy_email
sensitivestring
Company Invoice Number PrefixPrefix prepended to invoice numbers for this company.company_invoice_number_prefix
string
Court NameDisplay name of the court.court_name
string
Court DescriptionOptional description of the court.court_description
string
Court Group DescriptionDescription of the group this court belongs to.court_group_description
string
Court Document Template Group DescriptionCourt group description used in document templates.court_document_template_court_group_description
string
Court LevelAccess level required to book this court (e.g. USER, ADMIN).court_level
string
Court Booking Starting MinuteAllowed booking start times within an hour (e.g. *:00, *:30).court_booking_starting_minute
string
Court Free Field 1Custom free-text field 1 for the court.court_freefield_1
string
Court Free Field 2Custom free-text field 2 for the court.court_freefield_2
string
Court Free Field 3Custom free-text field 3 for the court.court_freefield_3
string
Court Free Field 4Custom free-text field 4 for the court.court_freefield_4
string
Court Free Field 5Custom free-text field 5 for the court.court_freefield_5
string
Court Free Field 6Custom free-text field 6 for the court.court_freefield_6
string
Court Free Field 7Custom free-text field 7 for the court.court_freefield_7
string
Court Free Field 8Custom free-text field 8 for the court.court_freefield_8
string
Court Free Field 9Custom free-text field 9 for the court.court_freefield_9
string
Court Free Field 10Custom free-text field 10 for the court.court_freefield_10
string
LatitudeGeographic latitude coordinate of the location.latitude
float
LongitudeGeographic longitude coordinate of the location.longitude
float
Sort OrderDisplay sort order of the location.sort_order
integer
Company LatitudeGeographic latitude coordinate of the company.company_latitude
float
Company LongitudeGeographic longitude coordinate of the company.company_longitude
float
Company Invoice Number Leading ZerosNumber of leading zeros applied to company invoice number sequences.company_invoice_number_leading_zeros
integer
Company Invoice Start CounterStarting number for the company invoice counter.company_invoice_start_counter
integer
Company Invoice Payment Condition DaysNumber of days allowed for invoice payment at this company.company_invoice_payment_condition_days
integer
Company Sort OrderDisplay sort order of the company.company_sort_order
integer
Court NumberNumeric identifier of the court within its location.court_number
integer
Court Minimum Time Per BookingMinimum booking duration in minutes.court_minimum_time_per_booking
integer
Court Minimum Time Per Booking (Calculated)Calculated minimum booking duration in minutes.court_minimum_time_per_booking_calculated
integer
Court Minimum Additional Time Per BookingMinimum additional time that must be booked alongside a booking, in minutes.court_minimum_additional_time_per_booking
integer
Court Minimum Additional Time Per Booking (Calculated)Calculated minimum additional booking time in minutes.court_minimum_additional_time_per_booking_calculated
integer
Court Maximum Time Per BookingMaximum booking duration in minutes (0 = unlimited).court_maximum_time_per_booking
integer
Court Maximum Time Per Booking (Calculated)Calculated maximum booking duration in minutes.court_maximum_time_per_booking_calculated
integer
Court Blocked Minutes After BookingNumber of minutes blocked after each booking ends.court_blocked_minutes_after_booking
integer
Court Min Co-User RequiredMinimum number of co-users required to make a booking.court_min_co_user_required
integer
Court Warning CapacityCapacity threshold at which a warning is triggered for this court.court_warning_capacity
integer
Court Max CapacityMaximum number of participants allowed on this court.court_max_capacity
integer
Is DeletedIndicates whether the location has been deleted.is_deleted
boolean
Company Invoice Restart Number AnnuallyIndicates whether the company invoice counter resets at the start of each year.company_invoice_restart_number_annually
boolean
Company Is DeletedIndicates whether the company has been deleted.company_is_deleted
boolean
Court InternalIndicates whether the court is restricted to internal bookings only.court_internal
boolean
Court DivisibleIndicates whether the court can be split into sub-courts.court_divisible
boolean
Court Slots Configurable (12/12)Indicates whether full-hour (12/12) slot configuration is enabled.court_12_12_slots_configurable
boolean
Court Slots Configurable (6/12)Indicates whether half-hour (6/12) slot configuration is enabled.court_6_12_slots_configurable
boolean
Court Slots Configurable (4/12)Indicates whether 4/12-hour slot configuration is enabled.court_4_12_slots_configurable
boolean
Court Slots Configurable (3/12)Indicates whether quarter-hour (3/12) slot configuration is enabled.court_3_12_slots_configurable
boolean
Court Slots Configurable (2/12)Indicates whether 2/12-hour slot configuration is enabled.court_2_12_slots_configurable
boolean
Court Slots Configurable (1/12)Indicates whether 1/12-hour slot configuration is enabled.court_1_12_slots_configurable
boolean
Court Time Restrictions Backend EnabledIndicates whether backend time restriction rules are active for this court.court_time_restrictions_backend_enabled
boolean
Court Co-User SelectableIndicates whether co-users can be selected when booking this court.court_co_user_selectable
boolean
Court Strict Schedule HandlingIndicates whether strict schedule enforcement is applied to this court.court_strict_court_schedule_handling
boolean
Court Force Adjacent BookingsIndicates whether bookings must be placed adjacent to existing ones.court_force_adjacent_bookings
boolean
Court Allow Bookings Over Multiple DaysIndicates whether bookings spanning multiple days are allowed.court_allow_bookings_over_multiple_days
boolean
Court Capacity BasedIndicates whether this court uses capacity-based booking.court_capacity_based_court
boolean
Court Is DeletedIndicates whether the court has been deleted.court_is_deleted
boolean
IDUnique identifier of the opening hours configuration.id
integer
Court IDUnique identifier of the court linked to this opening hours configuration.court_id
string
Row IDUnique identifier of the opening hour row (one row per day of the week).row_id
integer
Date AddedDate and time the opening hours configuration was created.date_added
datetime
Date Last ModifiedDate and time the opening hours configuration was last modified.date_last_modified
datetime
Court Date AddedDate and time the court was created.court_date_added
datetime
Court Date Last ModifiedDate and time the court was last modified.court_date_last_modified
datetime
Row Date AddedDate and time the opening hour row was created.row_date_added
datetime
Row Date Last ModifiedDate and time the opening hour row was last modified.row_date_last_modified
datetime
Display Name (nl-NL)Display name of the opening hours configuration in Dutch (Netherlands).display_name_nl_NL
string
Display Name (en-US)Display name of the opening hours configuration in English (United States).display_name_en_US
string
Display Name (de-DE)Display name of the opening hours configuration in German (Germany).display_name_de_DE
string
Display Name (fy-NL)Display name of the opening hours configuration in Frisian (Netherlands).display_name_fy_NL
string
NameDisplay name of the court.name
string
Court DescriptionOptional description of the court.court_description
string
Court Group DescriptionDescription of the group this court belongs to.court_group_description
string
Document Template Court Group DescriptionCourt group description used in document templates.document_template_court_group_description
string
LevelAccess level required to book this court (e.g. USER, ADMIN).level
string
Booking Starting MinuteAllowed booking start times within an hour (e.g. *:00, *:30).booking_starting_minute
string
Free Field 1Custom free-text field 1.freefield_1
string
Free Field 2Custom free-text field 2.freefield_2
string
Free Field 3Custom free-text field 3.freefield_3
string
Free Field 4Custom free-text field 4.freefield_4
string
Free Field 5Custom free-text field 5.freefield_5
string
Free Field 6Custom free-text field 6.freefield_6
string
Free Field 7Custom free-text field 7.freefield_7
string
Free Field 8Custom free-text field 8.freefield_8
string
Free Field 9Custom free-text field 9.freefield_9
string
Free Field 10Custom free-text field 10.freefield_10
string
Row Day NameName of the day this opening hour row applies to (e.g. Monday, Tuesday).row_dayname
string
Row User Opening TimeOpening time for regular users on this day (HH:MM:SS).row_user_opening_time
string
Row User Closing TimeClosing time for regular users on this day (HH:MM:SS).row_user_closing_time
string
Row Admin User Opening TimeOpening time for admin users on this day (HH:MM:SS).row_admin_user_opening_time
string
Row Admin User Closing TimeClosing time for admin users on this day (HH:MM:SS).row_admin_user_closing_time
string
NumberNumeric identifier of the court within its location.number
integer
Minimum Time Per BookingMinimum booking duration in minutes.minimum_time_per_booking
integer
Minimum Time Per Booking (Calculated)Calculated minimum booking duration in minutes.minimum_time_per_booking_calculated
integer
Minimum Additional Time Per BookingMinimum additional time that must be booked alongside a booking, in minutes.minimum_additional_time_per_booking
integer
Minimum Additional Time Per Booking (Calculated)Calculated minimum additional booking time in minutes.minimum_additional_time_per_booking_calculated
integer
Maximum Time Per BookingMaximum booking duration in minutes (0 = unlimited).maximum_time_per_booking
integer
Maximum Time Per Booking (Calculated)Calculated maximum booking duration in minutes.maximum_time_per_booking_calculated
integer
Blocked Minutes After BookingNumber of minutes blocked after each booking ends.blocked_minutes_after_booking
integer
Min Co-User RequiredMinimum number of co-users required to make a booking.min_co_user_required
integer
Warning CapacityCapacity threshold at which a warning is triggered for this court.warning_capacity
integer
Max CapacityMaximum number of participants allowed on this court.max_capacity
integer
Row DayDay of the week as a number (1 = Monday, 7 = Sunday).row_day
integer
InternalIndicates whether the court is restricted to internal bookings only.internal
boolean
DivisibleIndicates whether the court can be split into sub-courts.divisible
boolean
Slots Configurable (12/12)Indicates whether full-hour (12/12) slot configuration is enabled.12_12_slots_configurable
boolean
Slots Configurable (6/12)Indicates whether half-hour (6/12) slot configuration is enabled.6_12_slots_configurable
boolean
Slots Configurable (4/12)Indicates whether 4/12-hour slot configuration is enabled.4_12_slots_configurable
boolean
Slots Configurable (3/12)Indicates whether quarter-hour (3/12) slot configuration is enabled.3_12_slots_configurable
boolean
Slots Configurable (2/12)Indicates whether 2/12-hour slot configuration is enabled.2_12_slots_configurable
boolean
Slots Configurable (1/12)Indicates whether 1/12-hour slot configuration is enabled.1_12_slots_configurable
boolean
Time Restrictions Backend EnabledIndicates whether backend time restriction rules are active for this court.time_restrictions_backend_enabled
boolean
Co-User SelectableIndicates whether co-users can be selected when booking this court.co_user_selectable
boolean
Strict Court Schedule HandlingIndicates whether strict schedule enforcement is applied to this court.strict_court_schedule_handling
boolean
Force Adjacent BookingsIndicates whether bookings must be placed adjacent to existing ones.force_adjacent_bookings
boolean
Allow Bookings Over Multiple DaysIndicates whether bookings spanning multiple days are allowed.allow_bookings_over_multiple_days
boolean
Capacity Based CourtIndicates whether this court uses capacity-based booking.capacity_based_court
boolean
Is DeletedIndicates whether the court has been deleted.is_deleted
boolean
Row User ClosedIndicates whether the venue is closed to regular users on this day.row_user_closed
boolean
Row Admin User ClosedIndicates whether the venue is closed to admin users on this day.row_admin_user_closed
boolean
IDUnique identifier of the opening hour row.id
integer
Date AddedDate and time the opening hour row was created.date_added
datetime
Date Last ModifiedDate and time the opening hour row was last modified.date_last_modified
datetime
Day NameName of the day of the week this row applies to (e.g. Monday).dayname
string
User Opening TimeTime from which end users can make bookings on this day (HH:MM:SS).user_opening_time
string
User Closing TimeTime after which end users can no longer make bookings on this day (HH:MM:SS).user_closing_time
string
Admin User Opening TimeTime from which admin users can make bookings on this day (HH:MM:SS).admin_user_opening_time
string
Admin User Closing TimeTime after which admin users can no longer make bookings on this day (HH:MM:SS).admin_user_closing_time
string
DayNumeric day of the week (1 = Monday through 7 = Sunday).day
integer
User ClosedIndicates whether the venue is closed to end-user bookings on this day.user_closed
boolean
Admin User ClosedIndicates whether the venue is closed to admin bookings on this day.admin_user_closed
boolean
IDUnique identifier of the opening hours configuration.id
integer
Row IDUnique identifier of the opening hour row (one row per day of the week).row_id
integer
Date AddedDate and time the opening hours configuration was created.date_added
datetime
Date Last ModifiedDate and time the opening hours configuration was last modified.date_last_modified
datetime
Row Date AddedDate and time the opening hour row was created.row_date_added
datetime
Row Date Last ModifiedDate and time the opening hour row was last modified.row_date_last_modified
datetime
Display Name (nl-NL)Display name of the opening hours configuration in Dutch (Netherlands).display_name_nl_NL
string
Display Name (en-US)Display name of the opening hours configuration in English (United States).display_name_en_US
string
Display Name (de-DE)Display name of the opening hours configuration in German (Germany).display_name_de_DE
string
Display Name (fy-NL)Display name of the opening hours configuration in Frisian (Netherlands).display_name_fy_NL
string
Row Day NameName of the day this opening hour row applies to (e.g. Monday, Tuesday).row_dayname
string
Row User Opening TimeOpening time for regular users on this day (HH:MM:SS).row_user_opening_time
string
Row User Closing TimeClosing time for regular users on this day (HH:MM:SS).row_user_closing_time
string
Row Admin User Opening TimeOpening time for admin users on this day (HH:MM:SS).row_admin_user_opening_time
string
Row Admin User Closing TimeClosing time for admin users on this day (HH:MM:SS).row_admin_user_closing_time
string
Row DayDay of the week as a number (1 = Monday, 7 = Sunday).row_day
integer
Row User ClosedIndicates whether the venue is closed to regular users on this day.row_user_closed
boolean
Row Admin User ClosedIndicates whether the venue is closed to admin users on this day.row_admin_user_closed
boolean
IDUnique identifier of the price key.id
integer
Date AddedDate and time the price key was created.date_added
datetime
Date Last ModifiedDate and time the price key was last modified.date_last_modified
datetime
Display NameHuman-readable name of the price key.display_name
string
Default ValueDefault numeric value associated with the price key.default_value
integer
PreferenceSort or selection preference order for this price key.preference
integer
Is DeletedIndicates whether the price key has been deleted.is_deleted
boolean
IDUnique identifier of the price record.id
integer
Price Key IDUnique identifier of the price key this record is associated with.price_key_id
integer
Vatcode IDUnique identifier of the VAT code applied to this price record.vatcode_id
integer
Court IDUnique identifier of the court this price record applies to.court_id
string
Start DateDate and time from which this price record becomes active.start_date
datetime
End DateDate and time at which this price record expires.end_date
datetime
Date AddedDate and time the price record was created.date_added
datetime
Date Last ModifiedDate and time the price record was last modified.date_last_modified
datetime
Price Key Date AddedDate and time the associated price key was created.price_key_date_added
datetime
Price Key Date Last ModifiedDate and time the associated price key was last modified.price_key_date_last_modified
datetime
Vatcode Date AddedDate and time the associated VAT code was created.vatcode_date_added
datetime
Vatcode Date Last ModifiedDate and time the associated VAT code was last modified.vatcode_date_last_modified
datetime
Court Date AddedDate and time the associated court was created.court_date_added
datetime
Court Date Last ModifiedDate and time the associated court was last modified.court_date_last_modified
datetime
Price Key Display NameHuman-readable name of the associated price key.price_key_display_name
string
Vatcode Display NameFull display name of the VAT code.vatcode_display_name
string
Vatcode Display Name ShortAbbreviated display name of the VAT code.vatcode_display_name_short
string
Vatcode Country CodeISO 3166-1 alpha-2 country code the VAT code applies to.vatcode_country_code_iso2
string
Vatcode VAT Report CodeReporting code used for the VAT code in tax declarations.vatcode_vat_report_code
string
Court NameDisplay name of the court.court_name
string
Court DescriptionDescriptive text for the court.court_description
string
Court Group DescriptionDescription of the court group this court belongs to.court_group_description
string
Court Document Template Group DescriptionCourt group description used in document templates.court_document_template_court_group_description
string
Court LevelAccess level associated with the court (e.g. USER, SYSTEM).court_level
string
Court Booking Starting MinuteAllowed booking start times for the court (e.g. *:00, *:30).court_booking_starting_minute
string
Court Free Field 1Custom free-text field 1 for the court.court_freefield_1
string
Court Free Field 2Custom free-text field 2 for the court.court_freefield_2
string
Court Free Field 3Custom free-text field 3 for the court.court_freefield_3
string
Court Free Field 4Custom free-text field 4 for the court.court_freefield_4
string
Court Free Field 5Custom free-text field 5 for the court.court_freefield_5
string
Court Free Field 6Custom free-text field 6 for the court.court_freefield_6
string
Court Free Field 7Custom free-text field 7 for the court.court_freefield_7
string
Court Free Field 8Custom free-text field 8 for the court.court_freefield_8
string
Court Free Field 9Custom free-text field 9 for the court.court_freefield_9
string
Court Free Field 10Custom free-text field 10 for the court.court_freefield_10
string
Price Key Default ValueDefault rate value of the price key.price_key_default_value
integer
Price Key PreferenceSort or selection preference order of the price key.price_key_preference
integer
Court NumberSequential number of the court.court_number
integer
Court Minimum Time Per BookingMinimum booking duration in minutes for the court.court_minimum_time_per_booking
integer
Court Minimum Time Per Booking (Calculated)Calculated minimum booking duration in minutes for the court.court_minimum_time_per_booking_calculated
integer
Court Minimum Additional Time Per BookingMinimum additional time in minutes that can be added to a booking.court_minimum_additional_time_per_booking
integer
Court Minimum Additional Time Per Booking (Calculated)Calculated minimum additional booking time in minutes.court_minimum_additional_time_per_booking_calculated
integer
Court Maximum Time Per BookingMaximum booking duration in minutes for the court.court_maximum_time_per_booking
integer
Court Maximum Time Per Booking (Calculated)Calculated maximum booking duration in minutes for the court.court_maximum_time_per_booking_calculated
integer
Court Blocked Minutes After BookingNumber of minutes the court is blocked after a booking ends.court_blocked_minutes_after_booking
integer
Court Min Co-User RequiredMinimum number of co-users required when booking the court.court_min_co_user_required
integer
Court Warning CapacityCapacity threshold at which a warning is shown for the court.court_warning_capacity
integer
Court Max CapacityMaximum number of participants allowed on the court.court_max_capacity
integer
Price Key Is DeletedIndicates whether the associated price key has been deleted.price_key_is_deleted
boolean
Vatcode Is DeletedIndicates whether the associated VAT code has been deleted.vatcode_is_deleted
boolean
Court InternalIndicates whether the court is restricted to internal use only.court_internal
boolean
Court DivisibleIndicates whether the court can be divided into smaller sections.court_divisible
boolean
Court 12/12 Slots ConfigurableIndicates whether 12/12 time slots are configurable for the court.court_12_12_slots_configurable
boolean
Court 6/12 Slots ConfigurableIndicates whether 6/12 time slots are configurable for the court.court_6_12_slots_configurable
boolean
Court 4/12 Slots ConfigurableIndicates whether 4/12 time slots are configurable for the court.court_4_12_slots_configurable
boolean
Court 3/12 Slots ConfigurableIndicates whether 3/12 time slots are configurable for the court.court_3_12_slots_configurable
boolean
Court 2/12 Slots ConfigurableIndicates whether 2/12 time slots are configurable for the court.court_2_12_slots_configurable
boolean
Court 1/12 Slots ConfigurableIndicates whether 1/12 time slots are configurable for the court.court_1_12_slots_configurable
boolean
Court Time Restrictions Backend EnabledIndicates whether backend time restrictions are enabled for the court.court_time_restrictions_backend_enabled
boolean
Court Co-User SelectableIndicates whether co-users can be selected when booking the court.court_co_user_selectable
boolean
Court Strict Schedule HandlingIndicates whether strict schedule handling is enforced for the court.court_strict_court_schedule_handling
boolean
Court Force Adjacent BookingsIndicates whether bookings must be adjacent to existing bookings on the court.court_force_adjacent_bookings
boolean
Court Allow Bookings Over Multiple DaysIndicates whether bookings spanning multiple days are allowed on the court.court_allow_bookings_over_multiple_days
boolean
Court Capacity BasedIndicates whether the court operates on a capacity-based booking model.court_capacity_based_court
boolean
Court Is DeletedIndicates whether the associated court has been deleted.court_is_deleted
boolean
IDUnique identifier of the product order.id
integer
Product IDUnique identifier of the product associated with this order.product_id
integer
Subbooking IDUnique identifier of the subbooking this product order belongs to.subbooking_id
string
Vatcode IDUnique identifier of the VAT code applied to this product order.vatcode_id
integer
Subbooking Court Room Setup IDIdentifier of the court room setup configuration for the subbooking.subbooking_court_room_setup_id
integer
Book DateDate of the subbooking this product order is attached to.book_date
datetime
Date AddedDate and time the product order was created.date_added
datetime
Date Last ModifiedDate and time the product order was last modified.date_last_modified
datetime
Product Date AddedDate and time the product was created in the catalog.product_date_added
datetime
Product Date Last ModifiedDate and time the product was last modified in the catalog.product_date_last_modified
datetime
Vatcode Date AddedDate and time the VAT code was created.vatcode_date_added
datetime
Vatcode Date Last ModifiedDate and time the VAT code was last modified.vatcode_date_last_modified
datetime
Subbooking DateCalendar date of the subbooking.subbooking_date
datetime
Subbooking Start Datetime (UTC)Start date and time of the subbooking in UTC.subbooking_start_datetime_utc
datetime
Subbooking Start DatetimeStart date and time of the subbooking in the local timezone.subbooking_start_datetime
datetime
Subbooking End Datetime (UTC)End date and time of the subbooking in UTC.subbooking_end_datetime_utc
datetime
Subbooking End DatetimeEnd date and time of the subbooking in the local timezone.subbooking_end_datetime
datetime
Subbooking Option Expiration Datetime (UTC)Date and time the subbooking option expires in UTC.subbooking_option_expiration_datetime_utc
datetime
Subbooking Date AddedDate and time the subbooking was created.subbooking_date_added
datetime
Subbooking Date Last ModifiedDate and time the subbooking was last modified.subbooking_date_last_modified
datetime
Product NameName of the product at the time the order was placed.product_name
string
Custom Product DescriptionCustom description for this product order, overriding the default product description.custom_product_description
string
Internal NoteInternal note associated with this product order.internal_note
string
Product Price ConfigurationPrice configuration identifier applied to this product order.product_price_configuration
string
Book Start TimeStart time of the booking slot this product order is associated with.book_starttime
string
Book End TimeEnd time of the booking slot this product order is associated with.book_endtime
string
VAT ConfigurationVAT configuration identifier applied to this product order.vat_configuration
string
Product Name (HTML)HTML-formatted display name of the product.product_name_html
string
Product Name (nl-NL)Product name in Dutch (Netherlands).product_name_nl_NL
string
Product Name (en-US)Product name in English (United States).product_name_en_US
string
Product Name (de-DE)Product name in German (Germany).product_name_de_DE
string
Product Name (fy-NL)Product name in Frisian (Netherlands).product_name_fy_NL
string
Product Name (fr-FR)Product name in French (France).product_name_fr_FR
string
Per Piece NameDefault label used when referring to one unit of this product.per_piece_name
string
Per Piece Name (nl-NL)Per-piece label in Dutch (Netherlands).per_piece_name_nl_NL
string
Per Piece Name (en-US)Per-piece label in English (United States).per_piece_name_en_US
string
Per Piece Name (de-DE)Per-piece label in German (Germany).per_piece_name_de_DE
string
Per Piece Name (fy-NL)Per-piece label in Frisian (Netherlands).per_piece_name_fy_NL
string
Per Piece Name (fr-FR)Per-piece label in French (France).per_piece_name_fr_FR
string
Product DescriptionDefault description of the product.product_description
string
Product Description (nl-NL)Product description in Dutch (Netherlands).product_description_nl_NL
string
Product Description (en-US)Product description in English (United States).product_description_en_US
string
Product Description (de-DE)Product description in German (Germany).product_description_de_DE
string
Product Description (fy-NL)Product description in Frisian (Netherlands).product_description_fy_NL
string
Product Description (fr-FR)Product description in French (France).product_description_fr_FR
string
Document Template Product DescriptionProduct description used in document templates.document_template_product_description
string
Product LevelAccess level associated with the product (e.g. USER, SYSTEM).product_level
string
Product Quantity Configuration TypeUI control type for selecting product quantity (e.g. checkbox, dropdown).product_quantity_configuration_type
string
Product Select OptionsAvailable selection options when the product uses a select-type quantity control.product_select_options
string
Product Free Field 1Custom free-text field 1 for the product.product_freefield_1
string
Product Free Field 2Custom free-text field 2 for the product.product_freefield_2
string
Product Free Field 3Custom free-text field 3 for the product.product_freefield_3
string
Product Free Field 4Custom free-text field 4 for the product.product_freefield_4
string
Product Free Field 5Custom free-text field 5 for the product.product_freefield_5
string
Product Free Field 6Custom free-text field 6 for the product.product_freefield_6
string
Product Free Field 7Custom free-text field 7 for the product.product_freefield_7
string
Product Free Field 8Custom free-text field 8 for the product.product_freefield_8
string
Product Free Field 9Custom free-text field 9 for the product.product_freefield_9
string
Product Free Field 10Custom free-text field 10 for the product.product_freefield_10
string
Vatcode Display NameFull display name of the VAT code.vatcode_display_name
string
Vatcode Display Name ShortShort display name of the VAT code (e.g. 21%).vatcode_display_name_short
string
Vatcode Country Code (ISO2)ISO 3166-1 alpha-2 country code the VAT code applies to.vatcode_country_code_iso2
string
Vatcode VAT Report CodeVAT report code used for tax reporting purposes.vatcode_vat_report_code
string
Subbooking Start TimeStart time of the subbooking slot (e.g. 08:30:00).subbooking_starttime
string
Subbooking End TimeEnd time of the subbooking slot (e.g. 12:30:00).subbooking_endtime
string
Subbooking Activity Display NameDisplay name of the activity associated with the subbooking.subbooking_activity_display_name
string
Subbooking Purchase Order CodePurchase order code linked to the subbooking.subbooking_purchase_order_code
string
Subbooking RemarksInternal remarks for the subbooking.subbooking_remarks
string
Subbooking External RemarksExternal-facing remarks for the subbooking.subbooking_external_remarks
string
Subbooking Display NameDisplay name of the subbooking.subbooking_display_name
string
Subbooking Creation SourceSource channel through which the subbooking was created.subbooking_creation_source
string
Subbooking Court Display NameDisplay name of the court reserved in the subbooking.subbooking_court_display_name
string
Subbooking External Court Display NameExternal-facing display name of the court reserved in the subbooking.subbooking_external_court_display_name
string
Subbooking Free Field 1Custom free-text field 1 for the subbooking.subbooking_freefield_1
string
Subbooking Free Field 2Custom free-text field 2 for the subbooking.subbooking_freefield_2
string
Subbooking Free Field 3Custom free-text field 3 for the subbooking.subbooking_freefield_3
string
Subbooking Free Field 4Custom free-text field 4 for the subbooking.subbooking_freefield_4
string
Subbooking Free Field 5Custom free-text field 5 for the subbooking.subbooking_freefield_5
string
Subbooking Free Field 6Custom free-text field 6 for the subbooking.subbooking_freefield_6
string
Subbooking Free Field 7Custom free-text field 7 for the subbooking.subbooking_freefield_7
string
Subbooking Free Field 8Custom free-text field 8 for the subbooking.subbooking_freefield_8
string
Subbooking Free Field 9Custom free-text field 9 for the subbooking.subbooking_freefield_9
string
Subbooking Free Field 10Custom free-text field 10 for the subbooking.subbooking_freefield_10
string
Product QuantityQuantity of the product ordered.product_quantity
integer
Unit PriceUnit price of the product in the smallest currency unit.unit_price
integer
Unit Price (Excl. VAT)Unit price of the product excluding VAT.unit_price_excl_vat
float
Unit Price (Incl. VAT)Unit price of the product including VAT.unit_price_incl_vat
float
Product PriceProduct price in the smallest currency unit at the time of the order.product_price
integer
Product Price (Excl. VAT)Product price excluding VAT at the time of the order.product_price_excl_vat
float
Product Price (Incl. VAT)Product price including VAT at the time of the order.product_price_incl_vat
float
Total PriceTotal price for this product order in the smallest currency unit (unit price x quantity).total_price
integer
Total Price (Excl. VAT)Total price for this product order excluding VAT.total_price_excl_vat
float
Total Price (Incl. VAT)Total price for this product order including VAT.total_price_incl_vat
float
Sort OrderDisplay sort order of this product order.sort_order
integer
Product Price Per Hour (Excl. VAT)Hourly product price excluding VAT.product_price_per_hour_excl_vat
float
Product Price Per Hour (Incl. VAT)Hourly product price including VAT.product_price_per_hour_incl_vat
float
Max Calculated Price Per Hour (Excl. VAT)Maximum calculated hourly product price excluding VAT.max_calculated_product_price_per_hour_excl_vat
float
Max Calculated Price Per Hour (Incl. VAT)Maximum calculated hourly product price including VAT.max_calculated_product_price_per_hour_incl_vat
float
Product Number In StockCurrent stock quantity of the product.product_number_in_stock
integer
Product Inventory LimitMaximum inventory quantity allowed for the product.product_inventory_limit
integer
Product Max AmountMaximum quantity a customer can select per booking for this product.product_max_amount
integer
Product Bookable From LengthMinimum booking duration in minutes for which this product is available.product_bookable_from_length
integer
Product Bookable Till LengthMaximum booking duration in minutes for which this product is available.product_bookable_till_length
integer
Subbooking Court Start SlotStarting slot number on the court schedule for the subbooking.subbooking_court_start_slot
integer
Subbooking Court Number of SlotsNumber of consecutive court slots occupied by the subbooking.subbooking_court_number_of_slots
integer
Subbooking ParticipantsNumber of participants registered for the subbooking.subbooking_participants
integer
Subbooking Sort OrderDisplay sort order of the subbooking.subbooking_sort_order
integer
Subbooking CostsTotal costs for the subbooking.subbooking_costs
float
Subbooking Price (Incl. VAT)Total price for the subbooking including VAT.subbooking_price_incl_vat
float
Subbooking Price (Excl. VAT)Total price for the subbooking excluding VAT.subbooking_price_excl_vat
float
Subbooking Price VATVAT portion of the subbooking price.subbooking_price_vat
float
Product Default Amount SelectedDefault quantity pre-selected when adding this product to a booking.product_default_amount_selected
string
Is Manual EntryIndicates whether this product order was entered manually.is_manual_entry
boolean
Is Manual PriceIndicates whether the price for this product order was set manually.is_manual_price
boolean
Product InternalIndicates whether the product is restricted to internal use only.product_internal
boolean
Product Is RequiredIndicates whether the product must be included in every booking.product_is_required
boolean
Product Price Per Hour ActiveIndicates whether hourly pricing is active for this product.product_price_per_hour_active
boolean
Product Display On InvoiceIndicates whether this product is shown on invoices.product_display_on_invoice
boolean
Product Display On Booking ConfirmationIndicates whether this product is shown on booking confirmations.product_display_on_booking_confirmation
boolean
Product Display On QuotationIndicates whether this product is shown on quotations.product_display_on_quotation
boolean
Product Display On PrintlistIndicates whether this product is shown on print lists.product_display_on_printlist
boolean
Product Is DeletedIndicates whether the product has been deleted from the catalog.product_is_deleted
boolean
Vatcode Is DeletedIndicates whether the VAT code has been deleted.vatcode_is_deleted
boolean
Subbooking ExclusiveIndicates whether the subbooking exclusively reserves the court.subbooking_exclusive
boolean
Subbooking Is Manual PriceIndicates whether the subbooking price was set manually.subbooking_is_manual_price
boolean
Subbooking Is Manually OverwrittenIndicates whether the subbooking was manually overwritten.subbooking_is_manually_overwritten
boolean
Subbooking Is LockedIndicates whether the subbooking is locked from further modifications.subbooking_is_locked
boolean
IDUnique identifier of the product.id
integer
Usergroup IDUnique identifier of the usergroup linked to this product.usergroup_id
integer
Date AddedDate and time the product was created.date_added
datetime
Date Last ModifiedDate and time the product was last modified.date_last_modified
datetime
Usergroup Date AddedDate and time the usergroup was created.usergroup_date_added
datetime
Usergroup Date Last ModifiedDate and time the usergroup was last modified.usergroup_date_last_modified
datetime
Product NameDefault name of the product.product_name
string
Product Name (nl-NL)Product name in Dutch (Netherlands).product_name_nl_NL
string
Product Name (en-US)Product name in English (United States).product_name_en_US
string
Product Name (de-DE)Product name in German (Germany).product_name_de_DE
string
Product Name (fy-NL)Product name in Frisian (Netherlands).product_name_fy_NL
string
Product Name (fr-FR)Product name in French (France).product_name_fr_FR
string
Per Piece NameDefault label used when referring to one unit of this product.per_piece_name
string
Per Piece Name (nl-NL)Per-piece label in Dutch (Netherlands).per_piece_name_nl_NL
string
Per Piece Name (en-US)Per-piece label in English (United States).per_piece_name_en_US
string
Per Piece Name (de-DE)Per-piece label in German (Germany).per_piece_name_de_DE
string
Per Piece Name (fy-NL)Per-piece label in Frisian (Netherlands).per_piece_name_fy_NL
string
Per Piece Name (fr-FR)Per-piece label in French (France).per_piece_name_fr_FR
string
Product DescriptionDefault description of the product.product_description
string
Product Description (nl-NL)Product description in Dutch (Netherlands).product_description_nl_NL
string
Product Description (en-US)Product description in English (United States).product_description_en_US
string
Product Description (de-DE)Product description in German (Germany).product_description_de_DE
string
Product Description (fy-NL)Product description in Frisian (Netherlands).product_description_fy_NL
string
Product Description (fr-FR)Product description in French (France).product_description_fr_FR
string
Document Template Product DescriptionProduct description used in document templates.document_template_product_description
string
LevelAccess level associated with this product (e.g. USER, SYSTEM).level
string
Product Quantity Configuration TypeUI control type for selecting product quantity (e.g. checkbox, dropdown).product_quantity_configuration_type
string
Product Select OptionsAvailable selection options when the product uses a select-type quantity control.product_select_options
string
VAT ConfigurationVAT configuration identifier applied to this product.vat_configuration
string
Free Field 1Custom free-text field 1.freefield_1
string
Free Field 2Custom free-text field 2.freefield_2
string
Free Field 3Custom free-text field 3.freefield_3
string
Free Field 4Custom free-text field 4.freefield_4
string
Free Field 5Custom free-text field 5.freefield_5
string
Free Field 6Custom free-text field 6.freefield_6
string
Free Field 7Custom free-text field 7.freefield_7
string
Free Field 8Custom free-text field 8.freefield_8
string
Free Field 9Custom free-text field 9.freefield_9
string
Free Field 10Custom free-text field 10.freefield_10
string
Usergroup Display NameDisplay name of the usergroup.usergroup_display_name
string
Default Amount SelectedDefault quantity pre-selected when adding this product to a booking.default_amount_selected
float
Product PriceBase price of the product in the smallest currency unit.product_price
integer
Product Price (Excl. VAT)Product price excluding VAT.product_price_excl_vat
float
Product Price (Incl. VAT)Product price including VAT.product_price_incl_vat
float
Product Price Per Hour (Excl. VAT)Hourly product price excluding VAT.product_price_per_hour_excl_vat
float
Product Price Per Hour (Incl. VAT)Hourly product price including VAT.product_price_per_hour_incl_vat
float
Max Calculated Price Per Hour (Excl. VAT)Maximum calculated hourly product price excluding VAT.max_calculated_product_price_per_hour_excl_vat
float
Max Calculated Price Per Hour (Incl. VAT)Maximum calculated hourly product price including VAT.max_calculated_product_price_per_hour_incl_vat
float
Product Number In StockCurrent stock quantity of the product.product_number_in_stock
integer
Inventory LimitMaximum inventory quantity allowed for this product.inventory_limit
integer
Max AmountMaximum quantity a customer can select per booking.max_amount
integer
Bookable From LengthMinimum booking duration in minutes for which this product is available.bookable_from_length
integer
Bookable Till LengthMaximum booking duration in minutes for which this product is available.bookable_till_length
integer
Sort OrderDisplay sort order of the product.sort_order
integer
InternalIndicates whether the product is restricted to internal use only.internal
boolean
Is RequiredIndicates whether the product must be included in every booking.is_required
boolean
Product Price Per Hour ActiveIndicates whether hourly pricing is active for this product.product_price_per_hour_active
boolean
Display On InvoiceIndicates whether this product is shown on invoices.product_display_on_invoice
boolean
Display On Booking ConfirmationIndicates whether this product is shown on booking confirmations.product_display_on_booking_confirmation
boolean
Display On QuotationIndicates whether this product is shown on quotations.product_display_on_quotation
boolean
Display On PrintlistIndicates whether this product is shown on print lists.product_display_on_printlist
boolean
Is DeletedIndicates whether the product has been deleted.is_deleted
boolean
IDUnique identifier of the product.id
integer
Date AddedDate and time the product was created.date_added
datetime
Date Last ModifiedDate and time the product was last modified.date_last_modified
datetime
Product NameDefault name of the product.product_name
string
Product Name (nl-NL)Product name in Dutch (Netherlands).product_name_nl_NL
string
Product Name (en-US)Product name in English (United States).product_name_en_US
string
Product Name (de-DE)Product name in German (Germany).product_name_de_DE
string
Product Name (fy-NL)Product name in Frisian (Netherlands).product_name_fy_NL
string
Product Name (fr-FR)Product name in French (France).product_name_fr_FR
string
Per Piece NameDefault label used when referring to one unit of this product.per_piece_name
string
Per Piece Name (nl-NL)Per-piece label in Dutch (Netherlands).per_piece_name_nl_NL
string
Per Piece Name (en-US)Per-piece label in English (United States).per_piece_name_en_US
string
Per Piece Name (de-DE)Per-piece label in German (Germany).per_piece_name_de_DE
string
Per Piece Name (fy-NL)Per-piece label in Frisian (Netherlands).per_piece_name_fy_NL
string
Per Piece Name (fr-FR)Per-piece label in French (France).per_piece_name_fr_FR
string
Product DescriptionDefault description of the product.product_description
string
Product Description (nl-NL)Product description in Dutch (Netherlands).product_description_nl_NL
string
Product Description (en-US)Product description in English (United States).product_description_en_US
string
Product Description (de-DE)Product description in German (Germany).product_description_de_DE
string
Product Description (fy-NL)Product description in Frisian (Netherlands).product_description_fy_NL
string
Product Description (fr-FR)Product description in French (France).product_description_fr_FR
string
Document Template Product DescriptionProduct description used in document templates.document_template_product_description
string
LevelAccess level associated with this product (e.g. USER, SYSTEM).level
string
Product Quantity Configuration TypeUI control type for selecting product quantity (e.g. checkbox, dropdown).product_quantity_configuration_type
string
Product Select OptionsAvailable selection options when the product uses a select-type quantity control.product_select_options
string
VAT ConfigurationVAT configuration identifier applied to this product.vat_configuration
string
Free Field 1Custom free-text field 1.freefield_1
string
Free Field 2Custom free-text field 2.freefield_2
string
Free Field 3Custom free-text field 3.freefield_3
string
Free Field 4Custom free-text field 4.freefield_4
string
Free Field 5Custom free-text field 5.freefield_5
string
Free Field 6Custom free-text field 6.freefield_6
string
Free Field 7Custom free-text field 7.freefield_7
string
Free Field 8Custom free-text field 8.freefield_8
string
Free Field 9Custom free-text field 9.freefield_9
string
Free Field 10Custom free-text field 10.freefield_10
string
Default Amount SelectedDefault quantity pre-selected when adding this product to a booking.default_amount_selected
float
Product PriceBase price of the product in the smallest currency unit.product_price
integer
Product Price (Excl. VAT)Product price excluding VAT.product_price_excl_vat
float
Product Price (Incl. VAT)Product price including VAT.product_price_incl_vat
float
Product Price Per Hour (Excl. VAT)Hourly product price excluding VAT.product_price_per_hour_excl_vat
float
Product Price Per Hour (Incl. VAT)Hourly product price including VAT.product_price_per_hour_incl_vat
float
Max Calculated Price Per Hour (Excl. VAT)Maximum calculated hourly product price excluding VAT.max_calculated_product_price_per_hour_excl_vat
float
Max Calculated Price Per Hour (Incl. VAT)Maximum calculated hourly product price including VAT.max_calculated_product_price_per_hour_incl_vat
float
Product Number In StockCurrent stock quantity of the product.product_number_in_stock
integer
Inventory LimitMaximum inventory quantity allowed for this product.inventory_limit
integer
Max AmountMaximum quantity a customer can select per booking.max_amount
integer
Bookable From LengthMinimum booking duration in minutes for which this product is available.bookable_from_length
integer
Bookable Till LengthMaximum booking duration in minutes for which this product is available.bookable_till_length
integer
Sort OrderDisplay sort order of the product.sort_order
integer
InternalIndicates whether the product is restricted to internal use only.internal
boolean
Is RequiredIndicates whether the product must be included in every booking.is_required
boolean
Product Price Per Hour ActiveIndicates whether hourly pricing is active for this product.product_price_per_hour_active
boolean
Display On InvoiceIndicates whether this product is shown on invoices.product_display_on_invoice
boolean
Display On Booking ConfirmationIndicates whether this product is shown on booking confirmations.product_display_on_booking_confirmation
boolean
Display On QuotationIndicates whether this product is shown on quotations.product_display_on_quotation
boolean
Display On PrintlistIndicates whether this product is shown on print lists.product_display_on_printlist
boolean
Is DeletedIndicates whether the product has been deleted.is_deleted
boolean
Subbooking IDUnique identifier of the subbooking this audit log entry belongs to.id
string
Audit Log IDUnique identifier of the audit log entry (one row per entry).audit_log_id
integer
Booking IDUnique identifier of the parent booking.booking_id
string
Booking StatusStatus code of the parent booking.booking_status
integer
Court Room Setup IDIdentifier of the court room setup applied to this subbooking.court_room_setup_id
integer
Audit Log Original IDID of the status or value before the change recorded in this audit log entry.audit_log_original_id
integer
Audit Log New IDID of the status or value after the change recorded in this audit log entry.audit_log_new_id
integer
DateCalendar date on which the subbooking takes place.date
datetime
Start Datetime UTCStart date and time of the subbooking in UTC.start_datetime_utc
datetime
Start DatetimeStart date and time of the subbooking in the local timezone.start_datetime
datetime
End Datetime UTCEnd date and time of the subbooking in UTC.end_datetime_utc
datetime
End DatetimeEnd date and time of the subbooking in the local timezone.end_datetime
datetime
Option Expiration Datetime UTCDate and time at which the subbooking option expires, in UTC.option_expiration_datetime_utc
datetime
Subbooking Date AddedDate and time the subbooking was created.date_added
datetime
Subbooking Date Last ModifiedDate and time the subbooking was last modified.date_last_modified
datetime
Audit Log Date AddedDate and time this audit log entry was recorded.audit_log_date_added
datetime
Booking Start DateDate on which the parent booking starts.booking_startdate
datetime
Booking Payment Provider Status Last ModifiedDate and time the payment provider status of the parent booking was last updated.booking_paymentprovider_status_last_modified
datetime
Booking Date AddedDate and time the parent booking was created.booking_date_added
datetime
Booking Date Last ModifiedDate and time the parent booking was last modified.booking_date_last_modified
datetime
Start TimeStart time of the subbooking in HH:MM:SS format.starttime
string
End TimeEnd time of the subbooking in HH:MM:SS format.endtime
string
Activity Display NameDisplay name of the activity associated with this subbooking.activity_display_name
string
Purchase Order CodePurchase order code specific to this subbooking.purchase_order_code
string
Subbooking RemarksInternal remarks or notes specific to this subbooking.subbooking_remarks
string
Subbooking External RemarksRemarks visible to the customer for this subbooking.subbooking_external_remarks
string
Subbooking Display NameHuman-readable display name for this subbooking.subbooking_display_name
string
Creation SourceChannel or source through which this subbooking was created.creation_source
string
Court Display NameDisplay name of the court assigned to this subbooking.court_display_name
string
External Court Display NameExternal-facing display name of the court for this subbooking.external_court_display_name
string
Free Field 1Custom free-text field 1 for the subbooking.freefield_1
string
Free Field 2Custom free-text field 2 for the subbooking.freefield_2
string
Free Field 3Custom free-text field 3 for the subbooking.freefield_3
string
Free Field 4Custom free-text field 4 for the subbooking.freefield_4
string
Free Field 5Custom free-text field 5 for the subbooking.freefield_5
string
Free Field 6Custom free-text field 6 for the subbooking.freefield_6
string
Free Field 7Custom free-text field 7 for the subbooking.freefield_7
string
Free Field 8Custom free-text field 8 for the subbooking.freefield_8
string
Free Field 9Custom free-text field 9 for the subbooking.freefield_9
string
Free Field 10Custom free-text field 10 for the subbooking.freefield_10
string
Audit Log SeveritySeverity level of the audit log entry (e.g. INFO, WARNING).audit_log_severity
string
Audit Log UsergroupsJSON-encoded usergroup context associated with this audit log entry.audit_log_usergroups
string
Audit Log Admin RolesJSON-encoded admin role context associated with this audit log entry.audit_log_admin_roles
string
Audit Log Original ValueValue before the change recorded in this audit log entry.audit_log_original_value
string
Audit Log New ValueValue after the change recorded in this audit log entry.audit_log_new_value
string
Booking TypeType of the parent booking (e.g. object, activity).booking_type
string
Booking Payment MethodPayment method used for the parent booking.booking_paymentmethod
string
Booking Payment ProviderPayment provider used to process payment for the parent booking.booking_paymentprovider
string
Booking Payment Provider StatusCurrent status returned by the payment provider for the parent booking.booking_paymentprovider_status
string
Booking RemarksInternal remarks or notes on the parent booking.booking_remarks
string
Booking External RemarksRemarks visible to the customer for the parent booking.booking_external_remarks
string
Booking Purchase Order CodePurchase order code associated with the parent booking.booking_purchase_order_code
string
Booking Display NameHuman-readable display name for the parent booking.booking_display_name
string
Booking NumberHuman-readable sequential reference number for the parent booking.booking_number
string
Booking Preferred LocalePreferred locale used for communications related to the parent booking (e.g. nl_NL, en_US).booking_preferred_locale
string
Court Start SlotSlot index at which the subbooking starts on the court.court_start_slot
integer
Court Number of SlotsNumber of court slots occupied by this subbooking.court_number_of_slots
integer
ParticipantsNumber of participants registered for this subbooking.participants
integer
Sort OrderSort order of this subbooking within the parent booking.sort_order
integer
CostsTotal cost amount for this subbooking.costs
float
Price Incl. VATPrice of this subbooking including VAT.price_incl_vat
float
Price Excl. VATPrice of this subbooking excluding VAT.price_excl_vat
float
Price VATVAT amount for this subbooking.price_vat
float
ExclusiveIndicates whether this subbooking has exclusive use of the court.exclusive
boolean
Is Manual PriceIndicates whether the price for this subbooking was set manually.is_manual_price
boolean
Is Manually OverwrittenIndicates whether this subbooking's data has been manually overwritten.is_manually_overwritten
boolean
Is LockedIndicates whether this subbooking is locked from further edits.is_locked
boolean
Booking Exclude From NarrowcastingIndicates whether the parent booking is excluded from narrowcasting displays.booking_exclude_from_narrowcasting
boolean
IDUnique identifier of the subbooking.id
string
Booking IDUnique identifier of the parent booking this subbooking belongs to.booking_id
string
Court IDUnique identifier of the court assigned to this subbooking.court_id
string
VAT Code IDUnique identifier of the VAT code applied to this subbooking.vatcode_id
integer
Price Key IDUnique identifier of the price key applied to this subbooking.pricekey_id
integer
Status IDUnique identifier of the current status of this subbooking.status_id
integer
Booking StatusStatus code of the parent booking.booking_status
integer
Court Room Setup IDIdentifier of the court room setup applied to this subbooking.court_room_setup_id
integer
DateCalendar date on which this subbooking takes place.date
datetime
Start Datetime UTCStart date and time of the subbooking in UTC.start_datetime_utc
datetime
Start DatetimeStart date and time of the subbooking in the local timezone.start_datetime
datetime
End Datetime UTCEnd date and time of the subbooking in UTC.end_datetime_utc
datetime
End DatetimeEnd date and time of the subbooking in the local timezone.end_datetime
datetime
Option Expiration Datetime UTCDate and time at which the subbooking option expires, in UTC.option_expiration_datetime_utc
datetime
Date AddedDate and time the subbooking was created.date_added
datetime
Date Last ModifiedDate and time the subbooking was last modified.date_last_modified
datetime
Booking Start DateDate on which the parent booking starts.booking_startdate
datetime
Booking Payment Provider Status Last ModifiedDate and time the payment provider status of the parent booking was last updated.booking_paymentprovider_status_last_modified
datetime
Booking Date AddedDate and time the parent booking was created.booking_date_added
datetime
Booking Date Last ModifiedDate and time the parent booking was last modified.booking_date_last_modified
datetime
Court Date AddedDate and time the court record was created.court_date_added
datetime
Court Date Last ModifiedDate and time the court record was last modified.court_date_last_modified
datetime
VAT Code Date AddedDate and time the VAT code record was created.vatcode_date_added
datetime
VAT Code Date Last ModifiedDate and time the VAT code record was last modified.vatcode_date_last_modified
datetime
Price Key Date AddedDate and time the price key record was created.pricekey_date_added
datetime
Price Key Date Last ModifiedDate and time the price key record was last modified.pricekey_date_last_modified
datetime
Start TimeStart time of the subbooking in HH:MM:SS format.starttime
string
End TimeEnd time of the subbooking in HH:MM:SS format.endtime
string
Activity Display NameDisplay name of the activity associated with this subbooking.activity_display_name
string
Purchase Order CodePurchase order code specific to this subbooking.purchase_order_code
string
Subbooking RemarksInternal remarks or notes specific to this subbooking.subbooking_remarks
string
Subbooking External RemarksRemarks visible to the customer for this subbooking.subbooking_external_remarks
string
Subbooking Display NameHuman-readable display name for this subbooking.subbooking_display_name
string
Creation SourceChannel or source through which this subbooking was created.creation_source
string
Court Display NameDisplay name of the court assigned to this subbooking.court_display_name
string
External Court Display NameExternal-facing display name of the court for this subbooking.external_court_display_name
string
Free Field 1Custom free-text field 1 for the subbooking.freefield_1
string
Free Field 2Custom free-text field 2 for the subbooking.freefield_2
string
Free Field 3Custom free-text field 3 for the subbooking.freefield_3
string
Free Field 4Custom free-text field 4 for the subbooking.freefield_4
string
Free Field 5Custom free-text field 5 for the subbooking.freefield_5
string
Free Field 6Custom free-text field 6 for the subbooking.freefield_6
string
Free Field 7Custom free-text field 7 for the subbooking.freefield_7
string
Free Field 8Custom free-text field 8 for the subbooking.freefield_8
string
Free Field 9Custom free-text field 9 for the subbooking.freefield_9
string
Free Field 10Custom free-text field 10 for the subbooking.freefield_10
string
Booking TypeType of the parent booking (e.g. object, activity).booking_type
string
Booking Payment MethodPayment method used for the parent booking.booking_paymentmethod
string
Booking Payment ProviderPayment provider used to process payment for the parent booking.booking_paymentprovider
string
Booking Payment Provider StatusCurrent status returned by the payment provider for the parent booking.booking_paymentprovider_status
string
Booking RemarksInternal remarks or notes on the parent booking.booking_remarks
string
Booking External RemarksRemarks visible to the customer for the parent booking.booking_external_remarks
string
Booking Purchase Order CodePurchase order code associated with the parent booking.booking_purchase_order_code
string
Booking Display NameHuman-readable display name for the parent booking.booking_display_name
string
Booking NumberHuman-readable sequential reference number for the parent booking.booking_number
string
Booking Preferred LocalePreferred locale used for communications related to the parent booking (e.g. nl_NL, en_US).booking_preferred_locale
string
Court NameName of the court assigned to this subbooking.court_name
string
Court LevelAccess level of the court (e.g. USER, ADMIN).court_level
string
Court DescriptionDescription of the court.court_court_description
string
Court Group DescriptionDescription of the court group this court belongs to.court_court_group_description
string
Court Document Template Group DescriptionCourt group description used in document templates.court_document_template_court_group_description
string
Court Booking Starting MinuteAllowed booking start minutes for the court (e.g. *:00, *:30).court_booking_starting_minute
string
Court Free Field 1Custom free-text field 1 for the court.court_freefield_1
string
Court Free Field 2Custom free-text field 2 for the court.court_freefield_2
string
Court Free Field 3Custom free-text field 3 for the court.court_freefield_3
string
Court Free Field 4Custom free-text field 4 for the court.court_freefield_4
string
Court Free Field 5Custom free-text field 5 for the court.court_freefield_5
string
Court Free Field 6Custom free-text field 6 for the court.court_freefield_6
string
Court Free Field 7Custom free-text field 7 for the court.court_freefield_7
string
Court Free Field 8Custom free-text field 8 for the court.court_freefield_8
string
Court Free Field 9Custom free-text field 9 for the court.court_freefield_9
string
Court Free Field 10Custom free-text field 10 for the court.court_freefield_10
string
VAT Code Display NameFull display name of the VAT code (e.g. Verlaagd tarief).vatcode_display_name
string
VAT Code Display Name ShortShort display name of the VAT code (e.g. 6%/9%).vatcode_display_name_short
string
VAT Code Country CodeISO 3166-1 alpha-2 country code the VAT code applies to.vatcode_country_code_iso2
string
VAT Report CodeTax authority report code for the VAT code (e.g. 1b).vatcode_vat_report_code
string
Price Key Display NameDisplay name of the price key applied to this subbooking.pricekey_display_name
string
Status LabelMachine-readable label of the subbooking status (e.g. booked, option).status_label
string
Status Display NameHuman-readable display name of the subbooking status.status_display_name
string
Court Start SlotSlot index at which the subbooking starts on the court.court_start_slot
integer
Court Number of SlotsNumber of court slots occupied by this subbooking.court_number_of_slots
integer
ParticipantsNumber of participants registered for this subbooking.participants
integer
Sort OrderSort order of this subbooking within the parent booking.sort_order
integer
CostsTotal cost amount for this subbooking.costs
float
Price Incl. VATPrice of this subbooking including VAT.price_incl_vat
float
Price Excl. VATPrice of this subbooking excluding VAT.price_excl_vat
float
Price VATVAT amount for this subbooking.price_vat
float
Court NumberSequential number identifying the court within the location.court_number
integer
Court Minimum Time Per BookingMinimum booking duration in minutes for this court.court_minimum_time_per_booking
integer
Court Minimum Time Per Booking (Calculated)Calculated effective minimum booking duration in minutes for this court.court_minimum_time_per_booking_calculated
integer
Court Minimum Additional Time Per BookingMinimum additional duration increment in minutes allowed for this court.court_minimum_additional_time_per_booking
integer
Court Minimum Additional Time Per Booking (Calculated)Calculated effective minimum additional duration increment in minutes for this court.court_minimum_additional_time_per_booking_calculated
integer
Court Maximum Time Per BookingMaximum booking duration in minutes for this court (0 = unlimited).court_maximum_time_per_booking
integer
Court Maximum Time Per Booking (Calculated)Calculated effective maximum booking duration in minutes for this court.court_maximum_time_per_booking_calculated
integer
Court Blocked Minutes After BookingNumber of minutes blocked after each booking on this court.court_blocked_minutes_after_booking
integer
Court Min Co-User RequiredMinimum number of co-users required to book this court.court_min_co_user_required
integer
Court Warning CapacityParticipant count at which a capacity warning is shown for this court.court_warning_capacity
integer
Court Max CapacityMaximum participant capacity of this court.court_max_capacity
integer
Price Key Default ValueDefault value associated with the price key.pricekey_default_value
integer
Price Key PreferencePreference ordering of the price key relative to other price keys.pricekey_preference
integer
ExclusiveIndicates whether this subbooking has exclusive use of the court.exclusive
boolean
Is Manual PriceIndicates whether the price for this subbooking was set manually.is_manual_price
boolean
Is Manually OverwrittenIndicates whether this subbooking's data has been manually overwritten.is_manually_overwritten
boolean
Is LockedIndicates whether this subbooking is locked from further edits.is_locked
boolean
Booking Exclude From NarrowcastingIndicates whether the parent booking is excluded from narrowcasting displays.booking_exclude_from_narrowcasting
boolean
Court InternalIndicates whether the court is for internal use only.court_internal
boolean
Court DivisibleIndicates whether the court can be divided into smaller sections.court_divisible
boolean
Court 12/12 Slots ConfigurableIndicates whether the court supports 12/12 slot configuration.court_12_12_slots_configurable
boolean
Court 6/12 Slots ConfigurableIndicates whether the court supports 6/12 slot configuration.court_6_12_slots_configurable
boolean
Court 4/12 Slots ConfigurableIndicates whether the court supports 4/12 slot configuration.court_4_12_slots_configurable
boolean
Court 3/12 Slots ConfigurableIndicates whether the court supports 3/12 slot configuration.court_3_12_slots_configurable
boolean
Court 2/12 Slots ConfigurableIndicates whether the court supports 2/12 slot configuration.court_2_12_slots_configurable
boolean
Court 1/12 Slots ConfigurableIndicates whether the court supports 1/12 slot configuration.court_1_12_slots_configurable
boolean
Court Time Restrictions Backend EnabledIndicates whether backend time restrictions are enabled for this court.court_time_restrictions_backend_enabled
boolean
Court Co-User SelectableIndicates whether co-users can be selected when booking this court.court_co_user_selectable
boolean
Court Strict Schedule HandlingIndicates whether strict court schedule handling is enforced for this court.court_strict_court_schedule_handling
boolean
Court Force Adjacent BookingsIndicates whether bookings on this court must be adjacent to existing ones.court_force_adjacent_bookings
boolean
Court Allow Bookings Over Multiple DaysIndicates whether bookings on this court can span multiple days.court_allow_bookings_over_multiple_days
boolean
Court Capacity BasedIndicates whether this court uses capacity-based booking.court_capacity_based_court
boolean
Court Is DeletedIndicates whether the court record has been deleted.court_is_deleted
boolean
VAT Code Is DeletedIndicates whether the VAT code record has been deleted.vatcode_is_deleted
boolean
Price Key Is DeletedIndicates whether the price key record has been deleted.pricekey_is_deleted
boolean
Status VisibleIndicates whether the subbooking status is visible to users.status_visible
boolean
Status StickyIndicates whether the subbooking status is sticky (persists through transitions).status_sticky
boolean
User IDUnique identifier of the user this audit log entry belongs to.id
string
Audit Log IDUnique identifier of the audit log entry.audit_log_id
integer
Usergroup IDUnique identifier of the usergroup this user belongs to.usergroup_id
integer
Debtor Number Technical IDInternal technical identifier associated with the user's debtor number.debtor_number_technical_id
integer
Audit Log Original IDIdentifier of the original referenced entity before the audited change.audit_log_original_id
integer
Audit Log New IDIdentifier of the new referenced entity after the audited change.audit_log_new_id
integer
Date Registration ApprovedDate and time the user's registration was approved.date_registration_approved
datetime
Password Last ModifiedDate and time the user's password was last changed.password_last_modified
datetime
Date AddedDate and time the user account was created.date_added
datetime
Date Last ModifiedDate and time the user account was last modified.date_last_modified
datetime
Audit Log Date AddedDate and time this audit log entry was recorded.audit_log_date_added
datetime
CompanyCompany name associated with the user.company
string
First NameFirst name of the user.firstname
sensitivestring
Last NameLast name of the user.name
sensitivestring
Full NameFull name of the user.full_name
sensitivestring
UsernameLogin username of the user.username
sensitivestring
EmailEmail address of the user.email
sensitivestring
AddressStreet address of the user.address
sensitivestring
ZipcodePostal code of the user's address.zipcode
sensitivestring
CityCity of the user's address.city
string
CountryCountry of the user's address.country
string
Telephone CountryCountry code prefix for the user's telephone number.telephone_country
string
TelephoneTelephone number of the user.telephone
sensitivestring
Registration SourceChannel or source through which the user registered.registration_source
string
Company Attn InvoiceAttention name on company invoices for this user.company_attn_invoice
string
DescriptionInternal description or notes for the user account.description
string
Preferred Email LocalePreferred locale used for email communications sent to the user.preferred_email_locale
string
Attn InvoiceAttention field on invoices addressed to this user.attn_invoice
string
Invoice AddressInvoice street address for the user.address_invoice
sensitivestring
Invoice ZipcodePostal code of the user's invoice address.zipcode_invoice
sensitivestring
Invoice CityCity of the user's invoice address.city_invoice
string
Invoice CountryCountry of the user's invoice address.country_invoice
string
Invoice EmailEmail address used for sending invoices to the user.invoice_mail
sensitivestring
Invoice Send MethodMethod used to deliver invoices to the user (e.g. email, post).invoice_send_method
string
Peppol Address SchemePeppol electronic invoicing address scheme for the user.peppol_address_scheme
string
Peppol AddressPeppol electronic invoicing address for the user.peppol_address
string
Tax NumberTax identification number of the user.taxnumber
string
Debtor NumberDebtor number assigned to the user for accounting purposes.debtor_number
string
Override Purchase Order CodePurchase order code that overrides the default for this user.override_purchase_order_code
string
RemarksFree-text remarks or notes associated with the user.remarks
string
Password Policy VersionVersion of the password policy currently applied to the user.password_policy_version
string
Free Field 1Custom free-text field 1 for the user.freefield_1
string
Free Field 2Custom free-text field 2 for the user.freefield_2
string
Free Field 3Custom free-text field 3 for the user.freefield_3
string
Free Field 4Custom free-text field 4 for the user.freefield_4
string
Free Field 5Custom free-text field 5 for the user.freefield_5
string
Free Field 6Custom free-text field 6 for the user.freefield_6
string
Free Field 7Custom free-text field 7 for the user.freefield_7
string
Free Field 8Custom free-text field 8 for the user.freefield_8
string
Free Field 9Custom free-text field 9 for the user.freefield_9
string
Free Field 10Custom free-text field 10 for the user.freefield_10
string
Audit Log SeveritySeverity level of the audit log entry (e.g. info, warning, error).audit_log_severity
string
Audit Log UsergroupsUsergroup context associated with the audit log entry.audit_log_usergroups
string
Audit Log Admin RolesAdmin role context associated with the audit log entry.audit_log_admin_roles
string
Audit Log Original ValueValue of the field before the audited change was made.audit_log_original_value
string
Audit Log New ValueValue of the field after the audited change was made.audit_log_new_value
string
Registration StatusRegistration status code of the user (e.g. 0 = pending, 1 = active, 2 = approved).registration_status
integer
Invoice Payment Condition DaysNumber of days allowed for invoice payment by the user.invoice_paymentcondition_days
integer
ArchivedIndicates whether the user account has been archived.archived
boolean
Password ChangeableIndicates whether the user is allowed to change their password.pass_changeable
boolean
Newsletter SubscriptionIndicates whether the user is subscribed to the newsletter.newsletter_subscription
boolean
Access Code Reminder SubscriptionIndicates whether the user is subscribed to access code reminders.access_code_reminder_subscription
boolean
Exclude Bookings From NarrowcastingIndicates whether the user's bookings are excluded from narrowcasting displays.exclude_bookings_from_narrowcasting
boolean
Is DeletedIndicates whether the user account has been deleted.is_deleted
boolean
IDUnique identifier of the user contact.id
string
Date AddedDate and time the user contact was created.date_added
datetime
Date Last ModifiedDate and time the user contact was last modified.date_last_modified
datetime
EmailEmail address of the user contact.email
sensitivestring
First NameFirst name of the user contact.firstname
sensitivestring
Name PrefixName prefix or title of the user contact (e.g. Mr, Dr).name_prefix
string
Last NameLast name of the user contact.name
sensitivestring
Telephone CountryCountry code prefix for the user contact's telephone number.telephone_country
string
Telephone NumberTelephone number of the user contact.telephone_number
sensitivestring
RemarksFree-text remarks or notes associated with the user contact.remarks
string
Registration SourceChannel or source through which the user contact was registered.registration_source
string
ArchivedIndicates whether the user contact has been archived.archived
boolean
IDUnique identifier of the usergroup.id
integer
Court Group IDUnique identifier of the court group assigned to this usergroup.court_group_id
integer
Price Key IDUnique identifier of the price key assigned to this usergroup.price_key_id
integer
Date AddedDate and time the usergroup was created.date_added
datetime
Date Last ModifiedDate and time the usergroup was last modified.date_last_modified
datetime
Price Key Date AddedDate and time the assigned price key was created.price_key_date_added
datetime
Price Key Date Last ModifiedDate and time the assigned price key was last modified.price_key_date_last_modified
datetime
Court Group Date AddedDate and time the court group was created.court_group_date_added
datetime
Court Group Date Last ModifiedDate and time the court group was last modified.court_group_date_last_modified
datetime
Usergroup Display NameHuman-readable name of the usergroup.usergroup_display_name
string
Price Key Display NameHuman-readable name of the assigned price key.price_key_display_name
string
Court Group Display NameDisplay name of the court group.court_group_display_name
string
Price Key Default ValueDefault rate value of the assigned price key.price_key_default_value
integer
Price Key PreferenceSort or selection preference order of the assigned price key.price_key_preference
integer
Price Key Is DeletedIndicates whether the assigned price key has been deleted.price_key_is_deleted
boolean
Court Group Aggregated For Booking ProcessIndicates whether the court group is aggregated in the booking process.court_group_aggregated_for_booking_process
boolean
Court Group Aggregated For Price SettingsIndicates whether the court group is aggregated for price settings.court_group_aggregated_for_price_settings
boolean
Court Group Participants EnabledIndicates whether participant tracking is enabled for the court group.court_group_participants_enabled
boolean
Court Group Aggregated For Admin Booking ProcessIndicates whether the court group is aggregated in the admin booking process.court_group_aggregated_for_admin_booking_process
boolean
Court Group Court Tile EnabledIndicates whether the court tile view is enabled for the court group.court_group_court_tile_enabled
boolean
IDUnique identifier of the usergroup.id
integer
Court IDUnique identifier of the court accessible to this usergroup.court_id
string
Price Key IDUnique identifier of the price key assigned to this usergroup.price_key_id
integer
Date AddedDate and time the usergroup was created.date_added
datetime
Date Last ModifiedDate and time the usergroup was last modified.date_last_modified
datetime
Price Key Date AddedDate and time the assigned price key was created.price_key_date_added
datetime
Price Key Date Last ModifiedDate and time the assigned price key was last modified.price_key_date_last_modified
datetime
Court Date AddedDate and time the court was created.court_date_added
datetime
Court Date Last ModifiedDate and time the court was last modified.court_date_last_modified
datetime
Usergroup Display NameHuman-readable name of the usergroup.usergroup_display_name
string
Price Key Display NameHuman-readable name of the assigned price key.price_key_display_name
string
Court NameDisplay name of the court.court_name
string
Court DescriptionDescriptive text for the court.court_description
string
Court Group DescriptionDescription of the court group this court belongs to.court_group_description
string
Court Document Template Group DescriptionCourt group description used in document templates.court_document_template_court_group_description
string
Court LevelAccess level associated with the court (e.g. USER, SYSTEM).court_level
string
Court Booking Starting MinuteAllowed booking start times for the court (e.g. *:00, *:30).court_booking_starting_minute
string
Court Free Field 1Custom free-text field 1 for the court.court_freefield_1
string
Court Free Field 2Custom free-text field 2 for the court.court_freefield_2
string
Court Free Field 3Custom free-text field 3 for the court.court_freefield_3
string
Court Free Field 4Custom free-text field 4 for the court.court_freefield_4
string
Court Free Field 5Custom free-text field 5 for the court.court_freefield_5
string
Court Free Field 6Custom free-text field 6 for the court.court_freefield_6
string
Court Free Field 7Custom free-text field 7 for the court.court_freefield_7
string
Court Free Field 8Custom free-text field 8 for the court.court_freefield_8
string
Court Free Field 9Custom free-text field 9 for the court.court_freefield_9
string
Court Free Field 10Custom free-text field 10 for the court.court_freefield_10
string
Price Key Default ValueDefault rate value of the assigned price key.price_key_default_value
integer
Price Key PreferenceSort or selection preference order of the assigned price key.price_key_preference
integer
Court NumberSequential number of the court.court_number
integer
Court Minimum Time Per BookingMinimum booking duration in minutes for the court.court_minimum_time_per_booking
integer
Court Minimum Time Per Booking (Calculated)Calculated minimum booking duration in minutes for the court.court_minimum_time_per_booking_calculated
integer
Court Minimum Additional Time Per BookingMinimum additional time in minutes that can be added to a booking.court_minimum_additional_time_per_booking
integer
Court Minimum Additional Time Per Booking (Calculated)Calculated minimum additional booking time in minutes.court_minimum_additional_time_per_booking_calculated
integer
Court Maximum Time Per BookingMaximum booking duration in minutes for the court.court_maximum_time_per_booking
integer
Court Maximum Time Per Booking (Calculated)Calculated maximum booking duration in minutes for the court.court_maximum_time_per_booking_calculated
integer
Court Blocked Minutes After BookingNumber of minutes the court is blocked after a booking ends.court_blocked_minutes_after_booking
integer
Court Min Co-User RequiredMinimum number of co-users required when booking the court.court_min_co_user_required
integer
Court Warning CapacityCapacity threshold at which a warning is shown for the court.court_warning_capacity
integer
Court Max CapacityMaximum number of participants allowed on the court.court_max_capacity
integer
Price Key Is DeletedIndicates whether the assigned price key has been deleted.price_key_is_deleted
boolean
Court InternalIndicates whether the court is restricted to internal use only.court_internal
boolean
Court DivisibleIndicates whether the court can be divided into smaller sections.court_divisible
boolean
Court 12/12 Slots ConfigurableIndicates whether 12/12 time slots are configurable for the court.court_12_12_slots_configurable
boolean
Court 6/12 Slots ConfigurableIndicates whether 6/12 time slots are configurable for the court.court_6_12_slots_configurable
boolean
Court 4/12 Slots ConfigurableIndicates whether 4/12 time slots are configurable for the court.court_4_12_slots_configurable
boolean
Court 3/12 Slots ConfigurableIndicates whether 3/12 time slots are configurable for the court.court_3_12_slots_configurable
boolean
Court 2/12 Slots ConfigurableIndicates whether 2/12 time slots are configurable for the court.court_2_12_slots_configurable
boolean
Court 1/12 Slots ConfigurableIndicates whether 1/12 time slots are configurable for the court.court_1_12_slots_configurable
boolean
Court Time Restrictions Backend EnabledIndicates whether backend time restrictions are enabled for the court.court_time_restrictions_backend_enabled
boolean
Court Co-User SelectableIndicates whether co-users can be selected when booking the court.court_co_user_selectable
boolean
Court Strict Schedule HandlingIndicates whether strict schedule handling is enforced for the court.court_strict_court_schedule_handling
boolean
Court Force Adjacent BookingsIndicates whether bookings must be adjacent to existing bookings on the court.court_force_adjacent_bookings
boolean
Court Allow Bookings Over Multiple DaysIndicates whether bookings spanning multiple days are allowed on the court.court_allow_bookings_over_multiple_days
boolean
Court Capacity BasedIndicates whether the court operates on a capacity-based booking model.court_capacity_based_court
boolean
Court Is DeletedIndicates whether the court has been deleted.court_is_deleted
boolean
IDUnique identifier of the usergroup.id
integer
User IDUnique identifier of the user belonging to this usergroup.user_id
string
Price Key IDUnique identifier of the price key assigned to this usergroup.price_key_id
integer
Date AddedDate and time the usergroup was created.date_added
datetime
Date Last ModifiedDate and time the usergroup was last modified.date_last_modified
datetime
Price Key Date AddedDate and time the assigned price key was created.price_key_date_added
datetime
Price Key Date Last ModifiedDate and time the assigned price key was last modified.price_key_date_last_modified
datetime
User Date AddedDate and time the user account was created.user_date_added
datetime
User Date Last ModifiedDate and time the user account was last modified.user_date_last_modified
datetime
User Date Registration ApprovedDate and time the user's registration was approved.user_date_registration_approved
datetime
User Password Last ModifiedDate and time the user's password was last changed.user_password_last_modified
datetime
Usergroup Display NameHuman-readable name of the usergroup.usergroup_display_name
string
Price Key Display NameHuman-readable name of the assigned price key.price_key_display_name
string
User CompanyCompany name associated with the user account.user_company
string
User First NameFirst name of the user.user_firstname
sensitivestring
User Last NameLast name of the user.user_name
sensitivestring
User Full NameFull name of the user.user_full_name
sensitivestring
User UsernameLogin username of the user.user_username
sensitivestring
User EmailEmail address of the user.user_email
sensitivestring
User AddressStreet address of the user.user_address
sensitivestring
User ZipcodePostal code of the user's address.user_zipcode
sensitivestring
User CityCity of the user's address.user_city
string
User CountryCountry of the user's address.user_country
string
User Telephone CountryCountry code prefix for the user's telephone number.user_telephone_country
string
User TelephoneTelephone number of the user.user_telephone
sensitivestring
User Registration SourceChannel or source through which the user registered.user_registration_source
string
User Company Attn InvoiceAttention name on company invoices for the user.user_company_attn_invoice
string
User DescriptionInternal description or notes for the user account.user_description
string
User Attn InvoiceAttention field on invoices addressed to the user.user_attn_invoice
string
User Invoice AddressInvoice street address for the user.user_address_invoice
sensitivestring
User Invoice ZipcodePostal code of the user's invoice address.user_zipcode_invoice
sensitivestring
User Invoice CityCity of the user's invoice address.user_city_invoice
string
User Invoice CountryCountry of the user's invoice address.user_country_invoice
string
User Invoice EmailEmail address used for sending invoices to the user.user_invoice_mail
sensitivestring
User Invoice Send MethodMethod used to deliver invoices to the user (e.g. email, post).user_invoice_send_method
string
User Peppol Address SchemePeppol electronic invoicing address scheme for the user.user_peppol_address_scheme
string
User Peppol AddressPeppol electronic invoicing address for the user.user_peppol_address
string
User Tax NumberTax identification number of the user.user_taxnumber
string
User Debtor NumberDebtor number assigned to the user for accounting purposes.user_debtor_number
string
User Override Purchase Order CodePurchase order code that overrides the default for this user.user_override_purchase_order_code
string
User RemarksFree-text remarks or notes associated with the user.user_remarks
string
User Password Policy VersionVersion of the password policy currently applied to the user.user_password_policy_version
string
User Preferred Email LocalePreferred locale used for email communications sent to the user.user_preferred_email_locale
string
User Free Field 1Custom free-text field 1 for the user.user_freefield_1
string
User Free Field 2Custom free-text field 2 for the user.user_freefield_2
string
User Free Field 3Custom free-text field 3 for the user.user_freefield_3
string
User Free Field 4Custom free-text field 4 for the user.user_freefield_4
string
User Free Field 5Custom free-text field 5 for the user.user_freefield_5
string
User Free Field 6Custom free-text field 6 for the user.user_freefield_6
string
User Free Field 7Custom free-text field 7 for the user.user_freefield_7
string
User Free Field 8Custom free-text field 8 for the user.user_freefield_8
string
User Free Field 9Custom free-text field 9 for the user.user_freefield_9
string
User Free Field 10Custom free-text field 10 for the user.user_freefield_10
string
Price Key Default ValueDefault rate value of the assigned price key.price_key_default_value
integer
Price Key PreferenceSort or selection preference order of the assigned price key.price_key_preference
integer
User Registration StatusRegistration status code of the user (e.g. 0 = pending, 1 = active, 2 = approved).user_registration_status
integer
User Invoice Payment Condition DaysNumber of days allowed for invoice payment by the user.user_invoice_paymentcondition_days
integer
User Debtor Number Technical IDInternal technical identifier associated with the user's debtor number.user_debtor_number_technical_id
integer
Price Key Is DeletedIndicates whether the assigned price key has been deleted.price_key_is_deleted
boolean
User ArchivedIndicates whether the user account has been archived.user_archived
boolean
User Password ChangeableIndicates whether the user is allowed to change their password.user_pass_changeable
boolean
User Newsletter SubscriptionIndicates whether the user is subscribed to the newsletter.user_newsletter_subscription
boolean
User Access Code Reminder SubscriptionIndicates whether the user is subscribed to access code reminders.user_access_code_reminder_subscription
boolean
User Exclude Bookings From NarrowcastingIndicates whether the user's bookings are excluded from narrowcasting displays.user_exclude_bookings_from_narrowcasting
boolean
User Is DeletedIndicates whether the user account has been deleted.user_is_deleted
boolean
IDUnique identifier of the usergroup.id
integer
Price Key IDUnique identifier of the price key assigned to this usergroup.price_key_id
integer
Date AddedDate and time the usergroup was created.date_added
datetime
Date Last ModifiedDate and time the usergroup was last modified.date_last_modified
datetime
Price Key Date AddedDate and time the assigned price key was created.price_key_date_added
datetime
Price Key Date Last ModifiedDate and time the assigned price key was last modified.price_key_date_last_modified
datetime
Usergroup Display NameHuman-readable name of the usergroup.usergroup_display_name
string
Price Key Display NameHuman-readable name of the assigned price key.price_key_display_name
string
Price Key Default ValueDefault rate value of the assigned price key.price_key_default_value
integer
Price Key PreferenceSort or selection preference order of the assigned price key.price_key_preference
integer
Price Key Is DeletedIndicates whether the assigned price key has been deleted.price_key_is_deleted
boolean
IDUnique identifier of the user.id
string
Usergroup IDUnique identifier of the usergroup this user belongs to.usergroup_id
integer
Debtor Number Technical IDInternal technical identifier associated with the user's debtor number.debtor_number_technical_id
integer
Date Registration ApprovedDate and time the user's registration was approved.date_registration_approved
datetime
Password Last ModifiedDate and time the user's password was last changed.password_last_modified
datetime
Date AddedDate and time the user account was created.date_added
datetime
Date Last ModifiedDate and time the user account was last modified.date_last_modified
datetime
Usergroup Date AddedDate and time the usergroup record was created.usergroup_date_added
datetime
Usergroup Date Last ModifiedDate and time the usergroup record was last modified.usergroup_date_last_modified
datetime
CompanyCompany name associated with the user.company
string
First NameFirst name of the user.firstname
sensitivestring
Last NameLast name of the user.name
sensitivestring
Full NameFull name of the user.full_name
sensitivestring
UsernameLogin username of the user.username
sensitivestring
EmailEmail address of the user.email
sensitivestring
AddressStreet address of the user.address
sensitivestring
ZipcodePostal code of the user's address.zipcode
sensitivestring
CityCity of the user's address.city
string
CountryCountry of the user's address.country
string
Telephone CountryCountry code prefix for the user's telephone number.telephone_country
string
TelephoneTelephone number of the user.telephone
sensitivestring
Registration SourceChannel or source through which the user registered.registration_source
string
Company Attn InvoiceAttention name on company invoices for this user.company_attn_invoice
string
DescriptionInternal description or notes for the user account.description
string
Preferred Email LocalePreferred locale used for email communications sent to the user.preferred_email_locale
string
Attn InvoiceAttention field on invoices addressed to this user.attn_invoice
string
Invoice AddressInvoice street address for the user.address_invoice
sensitivestring
Invoice ZipcodePostal code of the user's invoice address.zipcode_invoice
sensitivestring
Invoice CityCity of the user's invoice address.city_invoice
string
Invoice CountryCountry of the user's invoice address.country_invoice
string
Invoice EmailEmail address used for sending invoices to the user.invoice_mail
sensitivestring
Invoice Send MethodMethod used to deliver invoices to the user (e.g. email, post).invoice_send_method
string
Peppol Address SchemePeppol electronic invoicing address scheme for the user.peppol_address_scheme
string
Peppol AddressPeppol electronic invoicing address for the user.peppol_address
string
Tax NumberTax identification number of the user.taxnumber
string
Debtor NumberDebtor number assigned to the user for accounting purposes.debtor_number
string
Override Purchase Order CodePurchase order code that overrides the default for this user.override_purchase_order_code
string
RemarksFree-text remarks or notes associated with the user.remarks
string
Password Policy VersionVersion of the password policy currently applied to the user.password_policy_version
string
Free Field 1Custom free-text field 1 for the user.freefield_1
string
Free Field 2Custom free-text field 2 for the user.freefield_2
string
Free Field 3Custom free-text field 3 for the user.freefield_3
string
Free Field 4Custom free-text field 4 for the user.freefield_4
string
Free Field 5Custom free-text field 5 for the user.freefield_5
string
Free Field 6Custom free-text field 6 for the user.freefield_6
string
Free Field 7Custom free-text field 7 for the user.freefield_7
string
Free Field 8Custom free-text field 8 for the user.freefield_8
string
Free Field 9Custom free-text field 9 for the user.freefield_9
string
Free Field 10Custom free-text field 10 for the user.freefield_10
string
Usergroup Display NameDisplay name of the usergroup this user belongs to.usergroup_display_name
string
Registration StatusRegistration status code of the user (e.g. 0 = pending, 1 = active, 2 = approved).registration_status
integer
Invoice Payment Condition DaysNumber of days allowed for invoice payment by the user.invoice_paymentcondition_days
integer
ArchivedIndicates whether the user account has been archived.archived
boolean
Password ChangeableIndicates whether the user is allowed to change their password.pass_changeable
boolean
Newsletter SubscriptionIndicates whether the user is subscribed to the newsletter.newsletter_subscription
boolean
Access Code Reminder SubscriptionIndicates whether the user is subscribed to access code reminders.access_code_reminder_subscription
boolean
Exclude Bookings From NarrowcastingIndicates whether the user's bookings are excluded from narrowcasting displays.exclude_bookings_from_narrowcasting
boolean
Is DeletedIndicates whether the user account has been deleted.is_deleted
boolean
IDUnique identifier of the VAT code.id
integer
Date AddedDate and time the VAT code was created.date_added
datetime
Date Last ModifiedDate and time the VAT code was last modified.date_last_modified
datetime
Display NameFull display name of the VAT code.display_name
string
Display Name ShortAbbreviated display name of the VAT code.display_name_short
string
Country Code ISO2ISO 3166-1 alpha-2 country code this VAT code applies to.country_code_iso2
string
VAT Report CodeCode used to identify this VAT rate in tax reports.vat_report_code
string
Is DeletedIndicates whether the VAT code has been deleted.is_deleted
boolean
Need a dataset, metric, or attribute you don't see?
Tell us what's missing and we'll add it to the connector.
WITH VS. WITHOUT
Who carries the load when things change
Keep Aqqo data flowing to every warehouse, dashboard, and tool - and see who owns it when an API or schema changes:
| Without Dataddo |
With Dataddo
|
Outcome for you | |
|---|---|---|---|
| API or auth change | You discover the breakage and scramble to fix it. | We update the connector and restore the pipeline - often before you notice. | Syncs from Aqqo keep flowing |
| Schema drift | Columns change and pipelines break or corrupt data silently. | Detected automatically and handled by configurable rules. | Only clean Aqqo data lands in reports |
| Endpoint deprecated | You re-engineer the integration. | We own the update - the data contract holds. | Your Aqqo reporting keeps working |
| Missing connector | You build and maintain a custom integration. | We build it and maintain it, under a ~4-week SLA. | Any Aqqo record you need, on request |
| Silent degradation | You find out when a report or model run fails. | Proactive monitoring catches anomalies and delays first. | Gaps caught before month-end close |
| Debugging | You dig through logs across disconnected tools. | Run histories, payload inspection, and end-to-end lineage in one place. | Faster root-cause, fewer reporting gaps |
Data residency by design
Choose where Aqqo data is processed - same cloud, region, or sovereign
Aqqo is a cloud API, so the question isn't on-prem vs cloud - it's which region your financial data flows through. With Dataddo you run the data plane in the region you choose, so Aqqo payloads move straight to your destinations without transiting a third-party SaaS. Pin it to an EU or US region for compliance and data-residency requirements, or self-host when a downstream target lives inside your own network.
| Data Plane location | Typical data sensitivity | Why this setup |
|---|---|---|
|
Public cloud 
AWS
Microsoft Azure
Google Cloud
|
Low to moderate - general business, marketing, and product data; sources that are already cloud-native. | Fastest to stand up and scales elastically. Best when the data has no residency restriction and often already lives in the same public cloud. |
|
Regional & EU sovereign clouds
EU sovereign clouds
Regional providers
Private cloud
|
Regulated / residency-bound - PII, financial, and health data governed by GDPR or local law. | Keeps processing inside a specific jurisdiction to meet data-residency and sovereignty rules, while still running as managed infrastructure. |
|
On-premises 
Kubernetes
Red Hat OpenShift
VMware Tanzu
|
Highly sensitive / restricted - data that contractually or legally cannot leave the corporate perimeter. | Data never leaves your network. Required for air-gapped, classified, or locked-down environments; the Control Plane still manages it via metadata only. |
DATA DELIVERY
Every way to deliver Aqqo data
Financial data rarely has one home. Dataddo feeds Aqqo into AI and agents, loads it into your warehouse for financial modeling, syncs records back into ERP and CRM systems, and delivers files to storage for archival - all governed the same way.
| Transport type | What it does | Typical destinations | Typical business use cases |
|---|---|---|---|
| Data to AI & Agents | Feed Aqqo data into vector databases, LLMs, and AI agents so finance copilots can reason over your numbers. | Load Aqqo records into vector stores for retrieval-augmented finance assistants, Give AI agents and copilots governed access to live Aqqo financial data | |
| ETL / ELT to your warehouse | Load Aqqo records and metrics into your warehouse for financial and revenue analytics. | Centralize Aqqo across entities in Snowflake, BigQuery, or Redshift for consolidated reporting, Backfill Aqqo history for reconciliation and audit | |
| Sync back to ERP & CRM | Push reconciled or modeled records built from Aqqo data back into ERP, accounting, and CRM systems. | Sync modeled financial records from Aqqo into your ERP or CRM, Keep Aqqo data aligned across finance and revenue systems | |
| Files to storage & archive | Deliver raw or modeled Aqqo extracts to object storage and partners for archival and audit. | Archive raw Aqqo exports to S3, GCS, or Azure storage for retention, Send scheduled Aqqo extracts to auditors or partners over SFTP |
Claude
Snowflake
BigQuery
Amazon Redshift
PostgreSQL
NetSuite
Exact Online
Salesforce
HubSpot
Google Cloud Storage
Azure Blob Storage
SFTP
Case Studies
See what finance teams build with Dataddo
65,000 Social Media Accounts. One Platform. Zero Manual Authorizations.
Beauty & Consumer Goods
How Livesport Activates Data, Saves Engineering Resources with BigQuery and Dataddo
Entertainment
How ID&T Group Activates Data from 1M+ Festival Fans and Dozens of Social Accounts
Entertainment
How Sensire Accelerated Migration of a Proprietary On-Premise Data Infrastructure to the Cloud with Dataddo
Healthcare
How Ringside.ai Builds a Data Product Better and Faster Using Dataddo
Marketing
How Publicis Groupe Brasil Uses Dataddo's API to Scale a Data Product
Advertising
FAQ
Aqqo as a source + Dataddo, answered
Where can I send Aqqo data?
To any of Dataddo's 150+ destinations - warehouses like Snowflake and BigQuery, BI dashboards, ERP and CRM systems, object storage, and AI or vector stores - plus custom destinations on request.
Do I have to maintain the pipeline?
No. Dataddo is fully managed: we maintain the Aqqo connector, adapt to API and schema changes, and alert you if anything needs attention. There is no pipeline code for you to write or fix.
Can I consolidate Aqqo data across multiple entities?
Yes. Dataddo can pull Aqqo data from multiple accounts or entities and load it into one warehouse, blended and normalized, so consolidated and multi-entity reporting works without manual exports or spreadsheets.
What if Aqqo changes their API?
That's on us, not you. Dataddo's team proactively tracks Aqqo API and schema changes and updates the connector before they break your pipeline. Continuous monitoring watches every sync, and if anything needs attention you get an alert - so your Aqqo data keeps flowing without you touching a thing.
Which Aqqo records and fields are available?
The full Aqqo data model - invoices, transactions, payments, ledger and tax fields, not a fixed subset. If a field you need isn't exposed yet, we add it on request, usually at no extra cost.
How is my data secured?
Dataddo is SOC 2 Type II and ISO 27001 certified. Data is encrypted in transit and at rest, PII and financial data can be masked or hashed, and EU or US data residency is available. Self-host the data plane and payload data never leaves your network.
Will API rate limits be a problem?
Dataddo handles Aqqo pagination, rate limits, and retries for you, and pulls incrementally on a schedule so you stay within API quotas without impacting your accounting system.
Am I locked in?
No. Pipelines are source- and destination-agnostic - you can add or switch destinations without rebuilding, and data lands in native formats you own.