{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-21","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,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":13,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942,1943","block_room_bookings":[{"confirmation_number":"SJ12622180244","room_stay_from":"2020-03-03","room_stay_to":"2020-04-01","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-04-01","bundle_room":"0"}],"bundle_block_count":"1304,1305,1271,1272,1309,1310","bundle_block_bookings":[{"confirmation_number":"SJB12665210706","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","bundle_room":"1"},{"confirmation_number":"SJB12677507394","room_stay_from":"2020-03-17","room_stay_to":"2020-03-22","bundle_room":"1"},{"confirmation_number":"SJB12682487744","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3084252","reservation_id":"90733","confirmation_number":"SJ12673589289","room_stay_from":"2020-07-09","room_stay_to":"2020-07-12","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"120.4,125.2,125.2","nightly_discount":"0,0,0","subtotal":"370.80","grand_total":"417.15","paid_amount":"145.13","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-2234192116","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":"96814","customer_id":"96814","source_of_creation":"Booking.com","reservation_created_date":"2020-01-28 01:01:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"108.93","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":[{"room_stay_id":"3081938","reservation_id":"93174","confirmation_number":"SJ12621607829","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","room_stay_status":"Canceled","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"245.00","nightly_discount":"0.00","subtotal":"245.00","grand_total":"275.63","paid_amount":"275.63","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-3092166035","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":"99371","customer_id":"99371","source_of_creation":"Booking.com","reservation_created_date":"2020-03-10 02:41:08","service_canceled_date_time":"2020-03-20 16:17:04","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"48.60","deltaChange":"275.63","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3083836","reservation_id":"92696","confirmation_number":"SJ12691828985","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"219.60,237.60,237.60","nightly_discount":"0,0,0","subtotal":"694.80","grand_total":"781.65","paid_amount":"781.65","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1649835412","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":"98842","customer_id":"98842","source_of_creation":"Expedia","reservation_created_date":"2020-02-28 00:23:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"237.60","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":"3084190","reservation_id":"93386","confirmation_number":"SJ12684603802","room_stay_from":"2020-03-17","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"168.00,168.00,168.00,196.00,196.00","nightly_discount":"0,0,0,0,0","subtotal":"896.00","grand_total":"1008.00","paid_amount":"1386.00","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1657946966","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":"99600","customer_id":"99600","source_of_creation":"Expedia","reservation_created_date":"2020-03-15 19:52:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"196.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":"3084217","reservation_id":"92719","confirmation_number":"SJ12674860314","room_stay_from":"2020-03-17","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,201.60,201.60","nightly_discount":"0,0,0,0,0","subtotal":"954.00","grand_total":"1073.25","paid_amount":"1279.80","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1650199577","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":"98864","customer_id":"98864","source_of_creation":"Expedia","reservation_created_date":"2020-02-28 16:54:10","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"201.60","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":"3084264","reservation_id":"92928","confirmation_number":"SJ12610722039","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"193.68,193.68,387.35","nightly_discount":"0.00,0.00,0.00","subtotal":"774.71","grand_total":"871.55","paid_amount":"871.55","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1652553862","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":"99092","customer_id":"99092","source_of_creation":"Expedia","reservation_created_date":"2020-03-04 00:39:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"387.35","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"}]}],"exp_non_taxable":[{"room_stay_id":"3080283","reservation_id":"92847","confirmation_number":"SJ12688155463","room_stay_from":"2020-03-21","room_stay_to":"2020-03-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,255.00,255.00,255.00","nightly_discount":"0,0,0,0","subtotal":"1045.00","grand_total":"1175.63","paid_amount":"315.00","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1651438696","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":"98999","customer_id":"98999","source_of_creation":"Expedia","reservation_created_date":"2020-03-02 02:19:06","service_canceled_date_time":"2020-03-20 14:47:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"315.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[{"room_stay_id":"3084240","reservation_id":"93087","confirmation_number":"SJ12614938204","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.73","nightly_discount":"0","subtotal":"162.73","grand_total":"183.07","paid_amount":"345.49","room_type_id":"319","product_id":"1913","siteminder_id":"HTN-122366180-3DPQFN","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":"99283","customer_id":"99283","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-08 00:30:08","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"162.73","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"}]}],"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":[{"room_stay_id":"3080022","reservation_id":"87036","confirmation_number":"SJ12694538702","room_stay_from":"2020-03-21","room_stay_to":"2020-03-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"384.00","room_type_id":"319","product_id":"1306","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":"93629","customer_id":"93629","source_of_creation":"FE","reservation_created_date":"2019-11-12 03:04:05","service_canceled_date_time":"2020-03-15 15:34:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3073019","reservation_id":"92386","confirmation_number":"SJ12644473183","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"255.00,280.00,280.00","nightly_discount":"0.00,0.00,0.00","subtotal":"815.00","grand_total":"916.88","paid_amount":"916.88","room_type_id":"319","product_id":"1915","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":"98562","customer_id":"98562","source_of_creation":"PMS","reservation_created_date":"2020-02-22 22:11:38","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":"280.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":"3083458","reservation_id":"93493","confirmation_number":"SJ12662751573","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"196.00","nightly_discount":"0.00","subtotal":"196.00","grand_total":"220.50","paid_amount":"220.50","room_type_id":"319","product_id":"1277","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":"99718","customer_id":"99718","source_of_creation":"PMS","reservation_created_date":"2020-03-18 16:44:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"196.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":"3084248","reservation_id":"93267","confirmation_number":"SJ12661656443","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.34,133.33","nightly_discount":"0.00,0.00","subtotal":"266.67","grand_total":"300.00","paid_amount":"300.00","room_type_id":"412","product_id":"1316","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":"99477","customer_id":"99477","source_of_creation":"PMS","reservation_created_date":"2020-03-13 00:08:42","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.33","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":"3082358","reservation_id":"92871","confirmation_number":"SJ12623092937","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","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,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1314","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":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-03-02 19:24:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","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":[{"room_stay_id":"3084472","reservation_id":"93083","confirmation_number":"SJ12627088262","room_stay_from":"2020-04-05","room_stay_to":"2020-04-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.30,99.30,99.30,99.30,99.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"496.50","grand_total":"496.50","paid_amount":"0.00","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-03-07 23:56:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3073020","reservation_id":"92386","confirmation_number":"SJ12613085154","room_confirmation_number":"SJ12644473183","room_stay_from":"2020-03-19","room_stay_to":"2020-03-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98561","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 22:11:39","reservation_modified_date_time":"2020-02-22 22:11:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98562","canceled_nights_data":"","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":"3082359","reservation_id":"92871","confirmation_number":"SJ12692980193","room_confirmation_number":"SJ12623092937","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,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,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99023","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 19:24:10","reservation_modified_date_time":"2020-03-16 11:22:49","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","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":"3083459","reservation_id":"93493","confirmation_number":"SJ12619880541","room_confirmation_number":"SJ12662751573","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","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":"99718","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-18 16:44:09","reservation_modified_date_time":"2020-03-18 16:44:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99718","canceled_nights_data":"","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":"3083835","reservation_id":"92696","confirmation_number":"SJ12671837798","room_confirmation_number":"SJ12691828985","room_stay_from":"2020-03-19","room_stay_to":"2020-03-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98860","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 00:23:06","reservation_modified_date_time":"2020-03-19 20:02:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98842","canceled_nights_data":"","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":"3084192","reservation_id":"93386","confirmation_number":"SJ12684854886","room_confirmation_number":"SJ12684603802","room_stay_from":"2020-03-17","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"99600","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-15 19:52:10","reservation_modified_date_time":"2020-03-21 14:06:02","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99600","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.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":"3084218","reservation_id":"92719","confirmation_number":"SJ12650735115","room_confirmation_number":"SJ12674860314","room_stay_from":"2020-03-17","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"98864","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 16:54:10","reservation_modified_date_time":"2020-03-21 14:13:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98864","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"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":"3084241","reservation_id":"93087","confirmation_number":"SJ12689363065","room_confirmation_number":"SJ12614938204","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99283","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-08 00:30:08","reservation_modified_date_time":"2020-03-21 14:39:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99283","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"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":"3084249","reservation_id":"93267","confirmation_number":"SJ12662904573","room_confirmation_number":"SJ12661656443","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99477","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 00:08:42","reservation_modified_date_time":"2020-03-21 14:50:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99477","canceled_nights_data":"","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":"3084266","reservation_id":"92928","confirmation_number":"SJ12649591910","room_confirmation_number":"SJ12610722039","room_stay_from":"2020-03-19","room_stay_to":"2020-03-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"99092","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-04 00:39:06","reservation_modified_date_time":"2020-03-21 15:26:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99092","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"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":"3084256","reservation_id":"90733","confirmation_number":"SJ12684053480","room_confirmation_number":"SJ12673589289","room_stay_from":"2020-07-09","room_stay_to":"2020-07-12","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":"96814","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 01:01:10","reservation_modified_date_time":"2020-03-21 15:25:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96814","canceled_nights_data":"","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":"3084473","reservation_id":"93083","confirmation_number":"SJ12668735651","room_confirmation_number":"SJ12627088262","room_stay_from":"2020-04-05","room_stay_to":"2020-04-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99279","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-07 23:56:24","reservation_modified_date_time":"2020-03-22 00:47:14","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3084263","reservation_id":"92928","confirmation_number":"SJ12664891051","room_confirmation_number":"SJ12610722039","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":"28.13","paid_amount":"28.13","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 15:25:58","reservation_modified_date_time":"2020-03-21 15:25:58","customer_id":"99092","parentCustTravId":"99092","customer_traveller_id":"99092","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3084458","reservation_id":"93267","confirmation_number":"SJ12628128889","room_confirmation_number":"SJ12661656443","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":"53.76","paid_amount":"53.76","product_id":"1654","service_quantity":"2","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 21:05:38","reservation_modified_date_time":"2020-03-21 21:05:38","customer_id":"99477","parentCustTravId":"99477","customer_traveller_id":"99477","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":"50.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":[{"room_stay_id":"3084408","reservation_id":"93559","confirmation_number":"SJ12646935191","room_confirmation_number":"SJ12657300352","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"3","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 18:49:00","reservation_modified_date_time":"2020-03-21 18:49:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"11.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}