Representation of the effect of the block for every block_id/date combination. The forecasted price of the blocks (block_prices) are recalculated daily!
Fields
| Field name | Type | Description/Notes |
| 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!