public-data-docs

Table: BRANCHES

Description:

Represents operational branches or locations within the Wunder platform. Each branch entry defines business context, configurations, and localized operational behaviors, including payments, visibility, time zones, and user interface preferences. Every rental and vehicle belongs to a branch; use for slicing metrics by operator unit, brand, or geo.

🔑 Primary Key

id

Field Name	Data Type	Description
id	NUMBER	Unique identifier for the branch.
dtype	NUMBER	Discriminator column used to identify subtypes of branches, if any.
code	TEXT	Internal or external code assigned to the branch.
name	TEXT	Display name of the branch.
business_area	GEOMETRY	Geographic area defining the branch’s business/operating region.
position	GEOMETRY	Geolocation or spatial data (e.g., coordinates).
state	NUMBER	Status/state code of the branch (0 => IN_PREPARATION. 1 => OPERATIONAL. 2 => MAINTENANCE. 3 => HIBERNATION. 4 => OUT_OF_BUSINESS).
state_name	TEXT	String label for state.
terms_and_conditions	NUMBER	Reference to terms and conditions document or agreement.
time_zone_id	TEXT	Time zone identifier (e.g., “Europe/Berlin”).
reserve_amount_on_cc	NUMBER	Amount reserved on credit card when booking from this branch.
tax_percentage	NUMBER	Tax rate applied to transactions in this branch.
billable_branch_id	NUMBER	ID of the branch responsible for billing (if different).
parent_id	NUMBER	Parent branch ID for hierarchical relationships.
sepa_handling_fee_net	NUMBER	Handling fee (net) for SEPA payments.
ui_settings	VARIANT	Configuration settings for UI elements (e.g., branding or visibility toggles).
visibility	NUMBER	Controls the visibility level of the branch in user-facing systems (0 => PUBLIC. 1 => PRIVATE).
visibility_name	TEXT	String label for visibility.
map_overlay_prohibited	TEXT	Defines prohibited areas in maps.
map_overlay_prohibited_color	TEXT	Color code for map overlay prohibited zones.
map_overlay_warning	TEXT	Warning overlay geometry or reference.
map_overlay_warning_color	TEXT	Color used for warning zones on the map.
contact_info	VARIANT	Structured contact information. Sample Value: { “address”: { “city”: “”, “country”: “”, “postcode”: “”, “street”: “” }, “billingInformation”: { “currencySymbol”: null, “iban”: null, “legalName”: “”, “logoBase64”: “”, “registrationNumber”: “”, “vatNumber”: “” }, “customFields”: null, “email”: “”, “locationGuidelines”: null, “phone”: “”, “publicName”: null, “websiteUrl”: “” }
types	NUMBER	Branch classification or type code, bitmap-encoded as an EnumSet (1 => Supports a free floating fleet. 2 => Supports a fleet stationed at different locations. 4 => Supports Rentals. 8 => Supports bookings in defined time slots. 16 => Supports bookings at free floating times. 32 => Type used for organizing the branches structure). Values combine via bitwise OR.
access_code	TEXT	Access code for entry or identification at the branch.
app_properties	VARIANT	App-specific custom properties for the branch. Sample Value: { “branchImage”: “”, “stationImage”: “”, “stationImage.active”: “”, “stationImage.noFilterMatch”: “”, “stationImage.selected”: “” }
dashboard_properties	VARIANT	Admin dashboard configurations for the branch. Sample Value: { “branchImage”: “”, “branchImage.checksum”: “” }
opening_information	VARIANT	Operating hours or special opening data. Sample Value: { “openingTimeEntries”: [ { “day”: “MONDAY”, “prettyString”: “”, “slotNumber”: 1, “state”: “OPEN”, “time”: [ 5, 0 ] } ] }
currency	TEXT	Currency used in this branch.
fallback	BOOLEAN	Indicates if this branch serves as a fallback for others.
merchant_account_override	TEXT	Optional override for merchant payment account.
referee_voucherable_id	NUMBER	Voucher reference for referees.
referrer_voucherable_id	NUMBER	Voucher reference for referrers (those referring others).
signup_voucherable_id	NUMBER	Voucher used during signup at this branch.
created_at	TIMESTAMP_TZ	Timestamp when the branch was created.
updated_at	TIMESTAMP_TZ	Timestamp when the branch was last updated.
created_by	NUMBER	ID of the user or process that created this record.
updated_by	NUMBER	ID of the user or process that last updated this record.
pgs_configuration_id	TEXT	Foreign key to payment gateway system configuration.
scale	NUMBER	Relative size or operational scale of the branch.
type	NUMBER	Defines operational type/category of the branch (0 => LOCATION. 1 => CATEGORY).
type_name	TEXT	String label for type.
operation_mode	NUMBER	Indicates how the branch operates (0 => ON_DEMAND. 1 => BOOKING. 2 => BOOKING_TIMESLOT).
operation_mode_name	TEXT	String label for operation_mode.
description	TEXT	Descriptive text or notes about the branch.
_snowflake_inserted_at	TIMESTAMP_NTZ	System timestamp when the record was inserted into Snowflake.
_snowflake_updated_at	TIMESTAMP_NTZ	System timestamp when the record was last updated in Snowflake.
_snowflake_deleted	BOOLEAN	True if the record was deleted in the source.