recapitulate

Total room in hotel (before deducted from OOI)

REVENUE_CALC_TYPE = 1 basis, individual bookings. Room only but still GROSS: included meals and rate inclusions are removed, service charge and tax are NOT. Source: SUM(sp_rate_schedule_breakdown.room). For the service/tax-free figure see individual_revenue_room_net.

REVENUE_CALC_TYPE = 1 basis, group bookings. See individual_revenue.

REVENUE_CALC_TYPE = 1 basis, day-use rooms. Written from the day-use breakdown in sp_get_recapitulate since V20260918.10.4; every row written before that is 0 because the breakdown it read was filtered to in-house guests, who a day-use guest is not by end-day.

REVENUE_CALC_TYPE = 0 basis, individual bookings. Full nightly rate, GROSS: includes the meals/inclusions priced into the rate AND service charge AND tax. Source: SUM(sp_rate_schedule_breakdown.rate_amount) = SUM(registration_rates.room_rate). “_total” here means “the whole rate”, NOT “individual + group” – for that see total_revenue_rate_gross.

REVENUE_CALC_TYPE = 0 basis, group bookings. See individual_revenue_total.

REVENUE_CALC_TYPE = 0 basis, day-use rooms. See day_used_revenue.

REVENUE_CALC_TYPE = 2 basis, individual bookings. Room only and NET: every itemizer on the room-charge department (service, tax, local tax, surcharge) is removed. Source: SUM(sp_rate_schedule_breakdown.room_net) = SUM of the BASE_PRICE entries that sp_post_transaction freezes into transactions.itemizers, so it reconciles with itemizer_summary. NULL means the backfill has not reached this date; readers use COALESCE(individual_revenue_room_net, individual_revenue), i.e. they degrade to the type-1 basis rather than reporting zero. Backfill with sp_backfill_revenue_room_net(). “NET” here means net of service/tax – NOT “net of void” (the meaning of the *_net_amt / *_net_qty columns in sp_trial_balance and rpc.insight_daily_summary), and NOT the legacy Fromas desktop “Net Revenue”, which meant the full rate (type 0).

REVENUE_CALC_TYPE = 2 basis, group bookings. See individual_revenue_room_net.

REVENUE_CALC_TYPE = 2 basis, day-use rooms. See individual_revenue_room_net.

REVENUE_CALC_TYPE = 0 basis for the whole day: individual + group + day use, all on the Gross Rate basis (room, meals and inclusions). Day use was added in V20260918.10.4; before that the three total_revenue_* columns covered overnight rooms only.

REVENUE_CALC_TYPE = 1 basis for the whole day: individual + group + day use, all on the Gross Room basis (room only, service and tax still included).

REVENUE_CALC_TYPE = 2 basis for the whole day: individual + group + day use, all on the Net Room basis. Each bucket degrades to its type-1 column when the net figure was never derived, so a non-zero value here does not prove the row holds net figures – test individual_revenue_room_net IS NULL for that.