daily_revenues
Per-day revenue breakdown for bookings, scoped to client workspaces by the unit’s current workspace. Superseded (obsolete) rows and rows with a non-finite accommodation_fare_gbp are excluded. Amounts are double precision.
| Column | Description |
|---|---|
id |
Unique identifier for the daily revenue row |
booking_id |
Identifier for the booking the revenue belongs to |
date |
Stay date the revenue is attributed to |
postcode |
Unit postcode when the row was last generated |
property |
Unit code when the row was last generated |
property_type |
Unit category (property type) when the row was last generated |
made_obsolete_at |
Always NULL in this view; superseded rows are excluded |
created_at |
Timestamp indicating when the row was created |
updated_at |
Timestamp indicating when the row was last updated |
platform |
Booking platform / channel |
revenue_type |
Type of revenue the row represents |
accommodation_fare |
Accommodation fare for the date, in the booking currency |
accommodation_fare_including_cleaning |
Accommodation fare including cleaning fee, in the booking currency |
lavanda_mgmt_fee |
Management fee for the date, in the booking currency |
lavanda_cleaning_fee |
Cleaning fee for the date, in the booking currency |
owner_income |
Owner income for the date, in the booking currency |
property_id |
Identifier for the unit |
lavanda_total |
Total fees for the date, in the booking currency |
check_in |
Booking check-in date |
charge_id |
Legacy, not populated for current revenue rows. Identifier of the related charge, if any |
amount |
Legacy, not populated for current revenue rows. Revenue amount, in the booking currency |
description |
Legacy, not populated for current revenue rows. Free-text description of the revenue row |
organisation |
Legacy, not populated for current revenue rows. Organisation name on the revenue date |
property_cluster |
Legacy, not populated for current revenue rows. Unit cluster on the revenue date |
postal_town |
Unit postal town when the row was last generated |
agent_fee |
Agent fee for the date |
lhg_fee |
LHG fee for the date |
operator_id_on_date |
Identifier of the operator responsible for the unit on the revenue date |
platform_fee_amount |
Platform (channel) fee for the date, in the booking currency |
platform_fee_amount_gbp |
Platform (channel) fee for the date, in GBP |
accommodation_fare_gbp |
Accommodation fare for the date, in GBP |
accommodation_fare_including_cleaning_gbp |
Accommodation fare including cleaning fee, in GBP |
lavanda_mgmt_fee_gbp |
Management fee for the date, in GBP |
lavanda_cleaning_fee_gbp |
Cleaning fee for the date, in GBP |
owner_income_gbp |
Owner income for the date, in GBP |
lavanda_total_gbp |
Total fees for the date, in GBP |
currency_code |
ISO 4217 currency code of the non-GBP amounts |
cancellation_fee |
Cancellation fee for the date, in the booking currency |
cancellation_fee_gbp |
Cancellation fee for the date, in GBP |
management_fee |
Management fee for the date, in the booking currency |
management_fee_gbp |
Management fee for the date, in GBP |
platform_payment_charge_amount |
Platform payment charge for the date, in the booking currency |
platform_payment_charge_amount_gbp |
Platform payment charge for the date, in GBP |
timestamp |
Date when the table was last synchronized |