{"hotel_id":"121","sub_hotel_id":0,"room_type":"hotel","date":"2019-09-27","total_rooms_exist":15,"departureCount":2,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"9","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3009640","reservation_id":"82490","confirmation_number":"VV12115224386","room_stay_from":"2019-09-22","room_stay_to":"2019-10-03","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"96.68,96.68,96.68,96.68,96.68,96.68,96.68,96.68,96.68,96.68,96.68","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0","subtotal":"1063.48","grand_total":"1201.73","paid_amount":"1201.73","room_type_id":"271","product_id":"846","siteminder_id":"BDC-2399455068","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90100","customer_id":"90100","source_of_creation":"Booking.com","reservation_created_date":"2019-08-11 21:53:11","canceled_nights_data":"","product_name":"The Floridian 4A","ota_service_fee_amount":"0","commision_charges":"159.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.68","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017718","reservation_id":"83807","confirmation_number":"VV12152292662","room_stay_from":"2019-09-26","room_stay_to":"2019-10-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.56,126.56,126.56,126.56,126.56","nightly_discount":"0,0,0,0,0","subtotal":"632.80","grand_total":"715.07","paid_amount":"715.07","room_type_id":"278","product_id":"853","siteminder_id":"BDC-3600584053","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91147","customer_id":"91147","source_of_creation":"Booking.com","reservation_created_date":"2019-09-09 02:27:06","canceled_nights_data":"","product_name":"South Beach R1","ota_service_fee_amount":"0","commision_charges":"94.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021174","reservation_id":"75071","confirmation_number":"VV12193894106","room_stay_from":"2019-09-20","room_stay_to":"2019-09-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.67,99.67,99.67,99.67,99.67,99.67,99.67,99.67","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"797.36","grand_total":"901.02","paid_amount":"901.02","room_type_id":"272","product_id":"847","siteminder_id":"BDC-2458343386","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85202","customer_id":"85202","source_of_creation":"Booking.com","reservation_created_date":"2019-04-21 07:37:10","canceled_nights_data":"","product_name":"Italian 1","ota_service_fee_amount":"0","commision_charges":"119.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.67","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021199","reservation_id":"83281","confirmation_number":"VV12111153742","room_stay_from":"2019-09-27","room_stay_to":"2019-09-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.97,87.97","nightly_discount":"0,0","subtotal":"175.94","grand_total":"198.82","paid_amount":"198.82","room_type_id":"276","product_id":"851","siteminder_id":"BDC-3776380165","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90663","customer_id":"90663","source_of_creation":"Booking.com","reservation_created_date":"2019-08-27 12:07:10","canceled_nights_data":"","product_name":"Miami Classic 8A","ota_service_fee_amount":"0","commision_charges":"26.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.97","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022678","reservation_id":"84712","confirmation_number":"VV12120989283","room_stay_from":"2019-09-27","room_stay_to":"2019-09-28","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"100.77","nightly_discount":"0","subtotal":"100.77","grand_total":"113.87","paid_amount":"113.87","room_type_id":"265","product_id":"840","siteminder_id":"BDC-3663115185","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92029","customer_id":"92029","source_of_creation":"Booking.com","reservation_created_date":"2019-09-26 11:06:11","canceled_nights_data":"","product_name":"French Country 7A","ota_service_fee_amount":"0","commision_charges":"15.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.77","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3002141","reservation_id":"81256","confirmation_number":"VV12170652428","room_stay_from":"2019-09-27","room_stay_to":"2019-09-30","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.42,107.42,107.42","nightly_discount":"0,0,0","subtotal":"322.26","grand_total":"364.16","paid_amount":"109.25","room_type_id":"271","product_id":"846","siteminder_id":"BDC-3996303129","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89273","customer_id":"89273","source_of_creation":"Booking.com","reservation_created_date":"2019-07-23 12:14:10","service_canceled_date_time":"2019-07-25 09:26:05","canceled_nights_data":"","product_name":"The Floridian 4A","ota_service_fee_amount":"0","commision_charges":"48.34","deltaChange":"109.25","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3017215","reservation_id":"83743","confirmation_number":"VV12126292082","room_stay_from":"2019-09-27","room_stay_to":"2019-09-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.36,127.36","nightly_discount":"0,0","subtotal":"254.72","grand_total":"287.83","paid_amount":"287.83","room_type_id":"269","product_id":"844","siteminder_id":"EXP-1337908658","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91109","customer_id":"91109","source_of_creation":"Expedia","reservation_created_date":"2019-09-07 19:22:10","canceled_nights_data":"","product_name":"Capri R2","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"127.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2989364","reservation_id":"78891","confirmation_number":"VV12123564738","room_stay_from":"2019-09-26","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1264.00","grand_total":"1428.32","paid_amount":"1428.32","room_type_id":"275","product_id":"850","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"13071","customer_id":"13071","source_of_creation":"PMS","reservation_created_date":"2019-06-18 13:40:53","canceled_nights_data":"","product_name":"Miami Classic 8","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"158.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"},{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3012061","reservation_id":"82912","confirmation_number":"VV12115048541","room_stay_from":"2019-09-27","room_stay_to":"2019-10-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.92,133.92,133.92,133.92","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"535.68","grand_total":"605.32","paid_amount":"605.32","room_type_id":"270","product_id":"845","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"22809","customer_id":"22809","source_of_creation":"PMS","reservation_created_date":"2019-08-19 14:40:01","canceled_nights_data":"","product_name":"The Floridian 4","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.92","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"},{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3020606","reservation_id":"84303","confirmation_number":"VV12190208977","room_stay_from":"2019-09-27","room_stay_to":"2019-09-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"268","product_id":"843","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91781","customer_id":"91781","source_of_creation":"PMS","reservation_created_date":"2019-09-18 14:19:53","canceled_nights_data":"","product_name":"Belize R5","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"},{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}