Skip to content

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