{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-06-04","total_rooms_exist":"1281,1282,1289,1274,1275,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":3,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1307,1943,1297","block_room_bookings":[{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-01","room_stay_to":"2020-06-05","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-01","room_stay_to":"2020-06-08","bundle_room":"0"},{"confirmation_number":"SJ12640607785","room_stay_from":"2020-06-04","room_stay_to":"2020-06-09","bundle_room":"0"}],"bundle_block_count":"1307,1308,1291,1711,1302,1303,1309,1310,1304,1305,1260,1261","bundle_block_bookings":[{"confirmation_number":"SJB12687704482","room_stay_from":"2020-06-01","room_stay_to":"2020-06-05","bundle_room":"1"},{"confirmation_number":"SJB12640121637","room_stay_from":"2020-06-03","room_stay_to":"2020-06-05","bundle_room":"1"},{"confirmation_number":"SJB12624658101","room_stay_from":"2020-06-02","room_stay_to":"2020-06-05","bundle_room":"1"},{"confirmation_number":"SJB12683342769","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","bundle_room":"1"},{"confirmation_number":"SJB12687955605","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","bundle_room":"1"},{"confirmation_number":"SJB12656175986","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","bundle_room":"0"},{"confirmation_number":"SJB12696759164","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","bundle_room":"0"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3100468","reservation_id":"95046","confirmation_number":"SJ12617599447","room_stay_from":"2020-06-02","room_stay_to":"2020-06-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,103.20,103.20","nightly_discount":"0,0,0","subtotal":"309.60","grand_total":"348.30","paid_amount":"348.30","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-2902263408","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":"101233","customer_id":"101233","source_of_creation":"Booking.com","reservation_created_date":"2020-05-19 15:31:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"46.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097875","reservation_id":"95395","confirmation_number":"SJ12689105696","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"192.00,258.40,258.40","nightly_discount":"0,0,0","subtotal":"708.80","grand_total":"797.40","paid_amount":"797.40","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-3059293152","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":"101589","customer_id":"101589","source_of_creation":"Booking.com","reservation_created_date":"2020-05-25 20:58:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"141.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"192.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101159","reservation_id":"94988","confirmation_number":"SJ12635838723","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00","subtotal":"341.60","grand_total":"384.30","paid_amount":"384.30","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2196238555","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101181","customer_id":"101181","source_of_creation":"Booking.com","reservation_created_date":"2020-05-18 21:59:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"74.99","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101172","reservation_id":"95642","confirmation_number":"SJ12617466348","room_stay_from":"2020-08-02","room_stay_to":"2020-08-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"118.00,118.00,118.00,118.00","nightly_discount":"0,0,0,0","subtotal":"472.00","grand_total":"531.00","paid_amount":"138.38","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3550250188","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":"101824","customer_id":"101824","source_of_creation":"Booking.com","reservation_created_date":"2020-05-30 02:40:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"102.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101105","reservation_id":"95777","confirmation_number":"SJ12641027053","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.60,209.60,164.80","nightly_discount":"0,0,0","subtotal":"584.00","grand_total":"657.00","paid_amount":"235.80","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-2740030028","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":"101946","customer_id":"101946","source_of_creation":"Booking.com","reservation_created_date":"2020-06-01 23:12:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"118.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3100289","reservation_id":"95802","confirmation_number":"SJ12689461679","room_stay_from":"2020-06-03","room_stay_to":"2020-06-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.40,150.40","nightly_discount":"0,0","subtotal":"300.80","grand_total":"338.40","paid_amount":"338.40","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1667536934","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":"101962","customer_id":"101962","source_of_creation":"Expedia","reservation_created_date":"2020-06-02 15:22:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3096702","reservation_id":"95210","confirmation_number":"SJ12624310346","room_stay_from":"2020-06-03","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"131.8,131.8,152.6","nightly_discount":"0,0,0","subtotal":"416.20","grand_total":"468.23","paid_amount":"468.23","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1665249631","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101478","customer_id":"101478","source_of_creation":"Expedia","reservation_created_date":"2020-05-21 22:07:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.8","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3098200","reservation_id":"94966","confirmation_number":"SJ12641622681","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56,95.36,95.36","nightly_discount":"0,0,0","subtotal":"273.28","grand_total":"307.44","paid_amount":"307.44","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1664657809","collect_which":"channel_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":"101153","customer_id":"101153","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 16:42:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3099869","reservation_id":"95071","confirmation_number":"SJ12617748076","room_stay_from":"2020-06-01","room_stay_to":"2020-06-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,103.20,103.20,103.20,119.20,119.20,103.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"754.40","grand_total":"848.70","paid_amount":"848.70","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1664879527","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":"101254","customer_id":"101254","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 21:07:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101113","reservation_id":"95101","confirmation_number":"SJ12690833444","room_stay_from":"2020-06-26","room_stay_to":"2020-06-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56","nightly_discount":"0","subtotal":"82.56","grand_total":"92.88","paid_amount":"0.00","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1664941399","collect_which":"channel_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":"101282","customer_id":"101282","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 03:27:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101167","reservation_id":"92834","confirmation_number":"SJ12625658794","room_stay_from":"2020-06-26","room_stay_to":"2020-07-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.20,179.20,179.20,160.64,160.64,181.76","nightly_discount":"0,0,0,0,0,0","subtotal":"1040.64","grand_total":"1170.72","paid_amount":"0.00","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1651325724","collect_which":"channel_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":"98983","customer_id":"98983","source_of_creation":"Expedia","reservation_created_date":"2020-03-01 22:09:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"208.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101161","reservation_id":"95102","confirmation_number":"SJ12616517828","room_stay_from":"2020-06-26","room_stay_to":"2020-06-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.20","nightly_discount":"0","subtotal":"179.20","grand_total":"201.60","paid_amount":"0.00","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1664941378","collect_which":"channel_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":"101283","customer_id":"101283","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 03:27:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"35.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101214","reservation_id":"95137","confirmation_number":"SJ12632821326","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.60,185.60","nightly_discount":"0,0","subtotal":"371.20","grand_total":"417.60","paid_amount":"208.80","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1665033728","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":"101318","customer_id":"101318","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 18:47:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.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":"3101182","reservation_id":"95899","confirmation_number":"SJ12612281504","room_stay_from":"2020-06-04","room_stay_to":"2020-06-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"168.89","nightly_discount":"0.00","subtotal":"168.89","grand_total":"190.00","paid_amount":"190.00","room_type_id":"412","product_id":"1294","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":"102044","customer_id":"102044","source_of_creation":"PMS","reservation_created_date":"2020-06-04 15:07:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3100098","reservation_id":"95780","confirmation_number":"SJ12620269196","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"320.90,451.64,451.64","nightly_discount":"0.00,0.00,0.00","subtotal":"1224.18","grand_total":"1377.20","paid_amount":"1377.20","room_type_id":"320","product_id":"1320","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":"101947","customer_id":"101947","source_of_creation":"PMS","reservation_created_date":"2020-06-01 23:49:57","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"320.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3099951","reservation_id":"89559","confirmation_number":"SJ12692018262","room_stay_from":"2020-06-01","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2020-01-08 15:07:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","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":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3101183","reservation_id":"95899","confirmation_number":"SJ12636094113","room_confirmation_number":"SJ12612281504","room_stay_from":"2020-06-04","room_stay_to":"2020-06-05","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"102044","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-06-04 18:58:03","reservation_modified_date_time":"2020-06-04 18:58:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102044","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3096700","reservation_id":"95210","confirmation_number":"SJ12634928598","room_confirmation_number":"SJ12624310346","room_stay_from":"2020-06-03","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"101478","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-05-21 22:07:07","reservation_modified_date_time":"2020-05-23 18:07:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101478","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3100291","reservation_id":"95802","confirmation_number":"SJ12630097353","room_confirmation_number":"SJ12689461679","room_stay_from":"2020-06-03","room_stay_to":"2020-06-05","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101962","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 15:22:06","reservation_modified_date_time":"2020-06-02 16:30:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101962","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3100470","reservation_id":"95046","confirmation_number":"SJ12689789863","room_confirmation_number":"SJ12617599447","room_stay_from":"2020-06-02","room_stay_to":"2020-06-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"101233","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 15:31:07","reservation_modified_date_time":"2020-06-02 21:46:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101233","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101184","reservation_id":"95899","confirmation_number":"SJ12671376248","room_confirmation_number":"SJ12612281504","room_stay_from":"2020-06-04","room_stay_to":"2020-06-05","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102044","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-04 15:07:05","reservation_modified_date_time":"2020-06-04 18:58:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102044","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3096701","reservation_id":"95210","confirmation_number":"SJ12662971396","room_confirmation_number":"SJ12624310346","room_stay_from":"2020-06-03","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"101478","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-21 22:07:07","reservation_modified_date_time":"2020-05-23 18:07:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101478","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097877","reservation_id":"95395","confirmation_number":"SJ12669617653","room_confirmation_number":"SJ12689105696","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"101589","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-25 20:58:11","reservation_modified_date_time":"2020-05-27 12:03:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101589","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3098202","reservation_id":"94966","confirmation_number":"SJ12625531883","room_confirmation_number":"SJ12641622681","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"101153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 16:42:04","reservation_modified_date_time":"2020-05-27 20:06:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3099952","reservation_id":"89559","confirmation_number":"SJ12657967662","room_confirmation_number":"SJ12692018262","room_stay_from":"2020-06-01","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"95540","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 15:07:14","reservation_modified_date_time":"2020-06-01 19:26:12","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3100099","reservation_id":"95780","confirmation_number":"SJ12656771074","room_confirmation_number":"SJ12620269196","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"101947","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-01 23:49:57","reservation_modified_date_time":"2020-06-01 23:49:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101947","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101160","reservation_id":"94988","confirmation_number":"SJ12697357165","room_confirmation_number":"SJ12635838723","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"101181","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 21:59:08","reservation_modified_date_time":"2020-06-04 17:45:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101181","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3099872","reservation_id":"95071","confirmation_number":"SJ12614827490","room_confirmation_number":"SJ12617748076","room_stay_from":"2020-06-01","room_stay_to":"2020-06-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"101254","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 21:07:08","reservation_modified_date_time":"2020-06-01 17:24:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101254","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101174","reservation_id":"95642","confirmation_number":"SJ12620304011","room_confirmation_number":"SJ12617466348","room_stay_from":"2020-08-02","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-30 02:40:10","reservation_modified_date_time":"2020-06-04 18:30:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101824","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101114","reservation_id":"95101","confirmation_number":"SJ12621344604","room_confirmation_number":"SJ12690833444","room_stay_from":"2020-06-26","room_stay_to":"2020-06-27","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101282","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 03:27:10","reservation_modified_date_time":"2020-06-04 16:36:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101282","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101106","reservation_id":"95777","confirmation_number":"SJ12671256787","room_confirmation_number":"SJ12641027053","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-01 23:12:08","reservation_modified_date_time":"2020-06-04 16:22:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101946","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101169","reservation_id":"92834","confirmation_number":"SJ12677819207","room_confirmation_number":"SJ12625658794","room_stay_from":"2020-06-26","room_stay_to":"2020-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98983","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 22:09:10","reservation_modified_date_time":"2020-06-04 18:27:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98983","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101162","reservation_id":"95102","confirmation_number":"SJ12694972230","room_confirmation_number":"SJ12616517828","room_stay_from":"2020-06-26","room_stay_to":"2020-06-27","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101283","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 03:27:12","reservation_modified_date_time":"2020-06-04 17:46:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101283","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101216","reservation_id":"95137","confirmation_number":"SJ12684558454","room_confirmation_number":"SJ12632821326","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101318","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 18:47:10","reservation_modified_date_time":"2020-06-04 19:46:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101318","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3101296","reservation_id":"95395","confirmation_number":"SJ12646490913","room_confirmation_number":"SJ12689105696","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"43.00","paid_amount":"43.00","product_id":"1659","service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-04 23:28:14","reservation_modified_date_time":"2020-06-04 23:28:14","customer_id":"101589","parentCustTravId":"101589","customer_traveller_id":"101589","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3101297","reservation_id":"95395","confirmation_number":"SJ12674800036","room_confirmation_number":"SJ12689105696","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.88","paid_amount":"26.88","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-04 23:28:14","reservation_modified_date_time":"2020-06-04 23:28:14","customer_id":"101589","parentCustTravId":"101589","customer_traveller_id":"101589","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}