Representation of the effect of the block for every block_id/date combination. The forecasted price of the blocks (block_prices) are recalculated daily!
|id||INTEGER||Unique identifier across the entire Clock PMS+ ecosystem*|
|account_id||INTEGER||Identification of the account owning the record. Reference to accounts table*|
|created_at||TIMESTAMP||Time created (Date and time in UTC)*|
|updated_at||TIMESTAMP||Time lastly updated (Date and time in UTC)*|
|block_id||INTEGER||Unique ID of the block the record is associated with. Reference to blocks table*|
|date||DATE||Date the record us related with(YYYY-MM-DD)*|
|expire_date||DATE||Date when the block for the date will expire(YYYY-MM-DD)|
|room_count||INTEGER||Number of rooms blocked for the date*|
|void_status||STRING||Status of the block for the date (active, optional or canceled)*|
|block_prices.revenue_group||STRING||The revenue group of the expected revenue from the block for the date**|
|block_prices.currency||STRING||The currency for the expected revenue from the block for the date**|
|block_prices.net_value_cents||INTEGER||Net value of the expected revenue from the block for the date**|
|block_prices.gross_value_cents||INTEGER||Gross value of the expected revenue from the block for the date**|
* Field will have value for every record
** One block_days record may have forecasted block_prices with different revenue_groups depending on the used rate configuration!