{"hotel_id":"121","sub_hotel_id":0,"room_type":"hotel","date":"2019-04-10","total_rooms_exist":15,"departureCount":0,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"5","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"129746","reservation_id":"50576","confirmation_number":"VV12114371819","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.00,198.00,198.00,198.00","nightly_discount":"0,0,0,0","subtotal":"792.00","grand_total":"894.96","paid_amount":"894.96","room_type_id":"270","product_id":"845","siteminder_id":"BDC-2074716042","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":"71952","customer_id":"71952","source_of_creation":"Booking.com","reservation_created_date":"2018-07-07 16:14:36","canceled_nights_data":"","product_name":"The Floridian 4","ota_service_fee_amount":"0","commision_charges":"118.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"198.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":"2930996","reservation_id":"59469","confirmation_number":"VV12166596275","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.00,148.00","nightly_discount":"0,0","subtotal":"296.00","grand_total":"334.48","paid_amount":"334.48","room_type_id":"268","product_id":"843","siteminder_id":"BDC-1063053924","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":"76540","customer_id":"76540","source_of_creation":"Booking.com","reservation_created_date":"2018-11-02 01:19:10","canceled_nights_data":"","product_name":"Belize R5","ota_service_fee_amount":"0","commision_charges":"44.40","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"148.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":"2937554","reservation_id":"69839","confirmation_number":"VV12180585074","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.22,139.22","nightly_discount":"0,0","subtotal":"278.44","grand_total":"314.64","paid_amount":"314.64","room_type_id":"276","product_id":"851","siteminder_id":"BDC-1191271634","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":"82089","customer_id":"82089","source_of_creation":"Booking.com","reservation_created_date":"2019-02-19 22:52:12","canceled_nights_data":"","product_name":"Miami Classic 8A","ota_service_fee_amount":"0","commision_charges":"41.77","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.22","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":"2943405","reservation_id":"70434","confirmation_number":"VV12181150730","room_stay_from":"2019-04-09","room_stay_to":"2019-04-12","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":"272","product_id":"847","siteminder_id":"BDC-1510843804","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":"82400","customer_id":"82400","source_of_creation":"Booking.com","reservation_created_date":"2019-02-27 08:26:10","canceled_nights_data":"","product_name":"Italian 1","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":"2949040","reservation_id":"71926","confirmation_number":"VV12152875596","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"147.97,147.97","nightly_discount":"0,0","subtotal":"295.94","grand_total":"334.42","paid_amount":"334.42","room_type_id":"264","product_id":"839","siteminder_id":"BDC-1340825720","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":"83229","customer_id":"83229","source_of_creation":"Booking.com","reservation_created_date":"2019-03-14 13:32:10","canceled_nights_data":"","product_name":"French Country 7","ota_service_fee_amount":"0","commision_charges":"44.39","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":"2963315","reservation_id":"74279","confirmation_number":"VV12117592534","room_stay_from":"2019-04-10","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.22","nightly_discount":"0","subtotal":"139.22","grand_total":"157.32","paid_amount":"157.32","room_type_id":"265","product_id":"840","siteminder_id":"BDC-3211173116","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":"84748","customer_id":"84748","source_of_creation":"Booking.com","reservation_created_date":"2019-04-08 02:20:10","canceled_nights_data":"","product_name":"French Country 7A","ota_service_fee_amount":"0","commision_charges":"20.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.22","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":[],"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":[{"room_stay_id":"2963744","reservation_id":"74377","confirmation_number":"VV12145334984","room_stay_from":"2019-04-09","room_stay_to":"2019-04-15","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"189.04,189.04,189.04,189.04,189.04,189.04","nightly_discount":"0,0,0,0,0,0","subtotal":"1134.24","grand_total":"1516.45","paid_amount":"1516.42","room_type_id":"269","product_id":"844","siteminder_id":"ABB-HMAJPCHJNE","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"1134.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84826","customer_id":"84826","source_of_creation":"Airbnb","reservation_created_date":"2019-04-09 17:07:09","canceled_nights_data":"","product_name":"Capri R2","ota_service_fee_amount":"175.33","commision_charges":"38.79","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"189.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2890811","reservation_id":"61411","confirmation_number":"VV12180552917","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,119.00","nightly_discount":"0.00,0.00","subtotal":"268.00","grand_total":"302.84","paid_amount":"302.84","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":"77438","customer_id":"77438","source_of_creation":"FE","reservation_created_date":"2018-11-28 20:57:49","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":"149.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":"2938341","reservation_id":"61413","confirmation_number":"VV12186323895","room_stay_from":"2019-04-10","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00","nightly_discount":"0.00","subtotal":"149.00","grand_total":"168.37","paid_amount":"168.37","room_type_id":"273","product_id":"848","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":"77440","customer_id":"77440","source_of_creation":"FE","reservation_created_date":"2018-11-28 21:20:32","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":"149.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":"2946077","reservation_id":"71364","confirmation_number":"VV12171589107","room_stay_from":"2019-04-10","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.58","nightly_discount":"0.00","subtotal":"114.58","grand_total":"129.47","paid_amount":"129.47","room_type_id":"267","product_id":"842","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":"82933","customer_id":"82933","source_of_creation":"FE","reservation_created_date":"2019-03-08 21:59:42","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":"114.58","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":"2956040","reservation_id":"73113","confirmation_number":"VV12180538003","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.94,130.94,130.94","nightly_discount":"0.00,0.00,0.00","subtotal":"392.82","grand_total":"443.89","paid_amount":"443.89","room_type_id":"266","product_id":"841","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":"84034","customer_id":"84034","source_of_creation":"FE","reservation_created_date":"2019-03-25 16:38:04","canceled_nights_data":"","product_name":"Island Delight 3","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.94","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":"2963651","reservation_id":"69966","confirmation_number":"VV12167189214","room_stay_from":"2019-04-10","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.94,130.94,183.33","nightly_discount":"0.00,0.00,0.00","subtotal":"445.21","grand_total":"503.08","paid_amount":"503.08","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":"82159","customer_id":"82159","source_of_creation":"FE","reservation_created_date":"2019-02-21 17:02:09","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":"130.94","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":[{"room_stay_id":"2885202","reservation_id":"60208","confirmation_number":"VV12114212417","room_stay_from":"2019-04-10","room_stay_to":"2019-04-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.00","nightly_discount":"0.00","subtotal":"116.00","grand_total":"131.08","paid_amount":"129.92","room_type_id":"265","product_id":"840","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":"76983","customer_id":"76983","source_of_creation":"FE","reservation_created_date":"2018-11-12 19:57:26","service_canceled_date_time":"2019-02-28 22:31:18","canceled_nights_data":"","product_name":"French Country 7A","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"129.92","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"2942514","reservation_id":"62142","confirmation_number":"VV12189834444","room_stay_from":"2019-04-10","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00","nightly_discount":"0.00","subtotal":"128.00","grand_total":"144.64","paid_amount":"144.64","room_type_id":"271","product_id":"846","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":"77966","customer_id":"77966","source_of_creation":"PMS","reservation_created_date":"2018-12-04 14:27:31","canceled_nights_data":"","product_name":"The Floridian 4A","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.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":"2963977","reservation_id":"57044","confirmation_number":"VV12171332524","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"259.00,259.00,259.00,360.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1137.00","grand_total":"1284.81","paid_amount":"1284.81","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":"12536","customer_id":"12536","source_of_creation":"PMS","reservation_created_date":"2018-09-24 17:05:41","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":"259.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":[{"room_stay_id":"2963745","reservation_id":"74377","confirmation_number":"VV12174859612","room_confirmation_number":"VV12145334984","room_stay_from":"2019-04-09","room_stay_to":"2019-04-15","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"120.00","paid_amount":"120.00","product_id":"1784","service_quantity":"1","customer_traveller_id":"84826","product_attribute_values":"extra_person#&#20.00","reservation_created_date":"2019-04-09 17:07:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84826","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}