billing_periods
Billing periods associated with bookings, tracking cost/fee breakdowns per period.
| Column | Description |
|---|---|
id |
Unique identifier for the billing period |
booking_id |
Identifier for the booking associated with the billing period |
accommodation_cents |
Cost of accommodation in cents |
currency |
Currency code for the billing period |
from_date |
Start date of the billing period |
to_date |
End date of the billing period |
created_at |
Timestamp indicating when the billing period was created |
updated_at |
Timestamp indicating when the billing period was last updated |
additional_fees |
Additional fees in JSON format (default: “{}”) |
cleaning_fee_cents |
Cleaning fee in cents |
cancellation_fee_cents |
Cancellation fee in cents |
base_rate_cents |
Base rent in cents |
discarded_at |
Timestamp indicating when the billing period was discarded |
timestamp |
Date when the table was last synchronized |