{"hotel_id":"121","sub_hotel_id":0,"room_type":"hotel","date":"2019-04-03","total_rooms_exist":15,"departureCount":3,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"7","block_room_bookings":[],"bundle_block_count":"2","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2924004","reservation_id":"67585","confirmation_number":"VV12196337823","room_stay_from":"2019-04-01","room_stay_to":"2019-04-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.97,147.97,147.97","nightly_discount":"0,0,0","subtotal":"443.91","grand_total":"501.61","paid_amount":"501.61","room_type_id":"264","product_id":"839","siteminder_id":"BDC-1398562714","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":"80778","customer_id":"80778","source_of_creation":"Booking.com","reservation_created_date":"2019-01-23 01:22:16","canceled_nights_data":"","product_name":"French Country 7","ota_service_fee_amount":"0","commision_charges":"66.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"147.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":"2930993","reservation_id":"28113","confirmation_number":"VV12115967429","room_stay_from":"2019-04-02","room_stay_to":"2019-04-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.00,145.00,145.00","nightly_discount":"0.00,0.00,0.00","subtotal":"435.00","grand_total":"491.55","paid_amount":"491.55","room_type_id":"268","product_id":"843","siteminder_id":"BDC-1683230073","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":"22213","customer_id":"22213","source_of_creation":"Booking.com","reservation_created_date":"2018-05-08 12:20:19","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":"145.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":"2960945","reservation_id":"66899","confirmation_number":"VV12132108977","room_stay_from":"2019-04-03","room_stay_to":"2019-04-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.52,134.52","nightly_discount":"0,0","subtotal":"269.04","grand_total":"304.01","paid_amount":"304.01","room_type_id":"272","product_id":"847","siteminder_id":"BDC-1298437410","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":"80339","customer_id":"80339","source_of_creation":"Booking.com","reservation_created_date":"2019-01-15 19:47:12","canceled_nights_data":"","product_name":"Italian 1","ota_service_fee_amount":"0","commision_charges":"40.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.52","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":[],"exp_taxable":[{"room_stay_id":"2885672","reservation_id":"60319","confirmation_number":"VV12145561767","room_stay_from":"2019-04-03","room_stay_to":"2019-04-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.00,155.00","nightly_discount":"0,0","subtotal":"310.00","grand_total":"350.30","paid_amount":"350.30","room_type_id":"269","product_id":"844","siteminder_id":"EXP-1148037884","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":"77050","customer_id":"77050","source_of_creation":"Expedia","reservation_created_date":"2018-11-14 17:19: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":"155.00","currentDayDiscount":"0","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":"2918465","reservation_id":"66996","confirmation_number":"VV12121869950","room_stay_from":"2019-04-01","room_stay_to":"2019-04-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.44,111.44,111.44","nightly_discount":"0,0,0","subtotal":"334.32","grand_total":"377.78","paid_amount":"377.78","room_type_id":"267","product_id":"842","siteminder_id":"EXP-1180821936","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":"80401","customer_id":"80401","source_of_creation":"Expedia","reservation_created_date":"2019-01-16 18:45:14","canceled_nights_data":"","product_name":"Island Delight 3A","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.44","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":"2934787","reservation_id":"69220","confirmation_number":"VV12155909160","room_stay_from":"2019-04-01","room_stay_to":"2019-04-05","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"129.47,129.47,129.47,129.47","nightly_discount":"0,0,0,0","subtotal":"517.88","grand_total":"585.20","paid_amount":"585.20","room_type_id":"273","product_id":"848","siteminder_id":"EXP-1196391822","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":"81754","customer_id":"81754","source_of_creation":"Expedia","reservation_created_date":"2019-02-11 20:44:10","canceled_nights_data":"","product_name":"Key West 2","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.47","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":"2941269","reservation_id":"70468","confirmation_number":"VV12116117150","room_stay_from":"2019-04-01","room_stay_to":"2019-04-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.58,122.58,122.58","nightly_discount":"0,0,0","subtotal":"367.74","grand_total":"415.54","paid_amount":"415.54","room_type_id":"265","product_id":"840","siteminder_id":"EXP-1206791358","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":"82430","customer_id":"82430","source_of_creation":"Expedia","reservation_created_date":"2019-02-27 20:39:07","canceled_nights_data":"","product_name":"French Country 7A","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.58","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":[{"room_stay_id":"131521","reservation_id":"51081","confirmation_number":"VV12189097912","room_stay_from":"2019-03-23","room_stay_to":"2019-04-04","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"322.00,322.00,322.00,322.00,322.00,322.00,322.00,322.00,322.00,179.00,179.00,179.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"3435.00","grand_total":"3881.55","paid_amount":"3881.55","room_type_id":"282","product_id":"857","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":"72223","customer_id":"72223","source_of_creation":"FE","reservation_created_date":"2018-07-15 10:31:27","canceled_nights_data":"","product_name":"Miami Classic 8+8A","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"179.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"140004","reservation_id":"53703","confirmation_number":"VV12136873983","room_stay_from":"2019-03-29","room_stay_to":"2019-04-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"840.00","grand_total":"949.20","paid_amount":"949.20","room_type_id":"278","product_id":"853","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":"73758","customer_id":"73758","source_of_creation":"PMS","reservation_created_date":"2018-08-15 14:13:12","canceled_nights_data":"","product_name":"South Beach R1","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.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":"2943518","reservation_id":"70930","confirmation_number":"VV12199306727","room_stay_from":"2019-04-01","room_stay_to":"2019-04-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.33,267.33,267.33","nightly_discount":"0.00,0.00,0.00","subtotal":"801.99","grand_total":"906.25","paid_amount":"906.25","room_type_id":"277","product_id":"852","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":"12587","customer_id":"12587","source_of_creation":"PMS","reservation_created_date":"2019-03-04 19:27:29","canceled_nights_data":"","product_name":"Santa Fe Suite 5","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"267.33","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":[]}}