# daily_revenues

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

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 |