{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-13","total_rooms_exist":"1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1281,1282,1286,1287,1288,1289,1291,1293,1294,1296,1297,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1318,1319,1711,1756,1866,1913,1915,1916,1917,1918,1919,1920,1921,1922,1923,1942,1943","departureCount":22,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1301,1923,1307,1313,1282,1920,1943,1314,1922,1921,1919,1918,1262,1270,1311","block_room_bookings":[{"confirmation_number":"SJ12699845061","room_stay_from":"2020-01-03","room_stay_to":"2020-01-04","bundle_room":"0"},{"confirmation_number":"SJ12693730510","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12673769738","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","bundle_room":"0"},{"confirmation_number":"SJ12673593636","room_stay_from":"2019-11-09","room_stay_to":"2019-11-20","bundle_room":"0"},{"confirmation_number":"SJ12666838067","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","bundle_room":"0"},{"confirmation_number":"SJ12665324838","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12665140393","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12657221101","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12648030950","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12638549225","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632903645","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12613532835","room_stay_from":"2019-12-18","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12612096947","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","bundle_room":"0"}],"bundle_block_count":"1267,1268,1304,1305,1291,1711,1309,1310,1302,1303,1260,1261","bundle_block_bookings":[{"confirmation_number":"SJB12682076818","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","bundle_room":"1"},{"confirmation_number":"SJB12654667429","room_stay_from":"2020-01-13","room_stay_to":"2020-01-20","bundle_room":"1"},{"confirmation_number":"SJB12647078127","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","bundle_room":"1"},{"confirmation_number":"SJB12640506320","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","bundle_room":"1"},{"confirmation_number":"SJB12628027550","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","bundle_room":"1"},{"confirmation_number":"SJB12619948889","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3057097","reservation_id":"89820","confirmation_number":"SJ12685082986","room_stay_from":"2020-01-12","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.15,118.15","nightly_discount":"0,0","subtotal":"236.30","grand_total":"265.84","paid_amount":"265.84","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2400794507","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":"95968","customer_id":"95968","source_of_creation":"Booking.com","reservation_created_date":"2020-01-12 19:02:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"61.43","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"118.15","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":"3057591","reservation_id":"89906","confirmation_number":"SJ12664213476","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.10","nightly_discount":"0","subtotal":"125.10","grand_total":"140.74","paid_amount":"140.74","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3659202177","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":"95924","customer_id":"95924","source_of_creation":"Booking.com","reservation_created_date":"2020-01-13 21:26:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"32.18","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"125.10","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":"3057330","reservation_id":"89496","confirmation_number":"SJ12642875634","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.15,118.15","nightly_discount":"0,0","subtotal":"236.30","grand_total":"265.84","paid_amount":"265.84","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-3516816718","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":"95478","customer_id":"95478","source_of_creation":"Booking.com","reservation_created_date":"2020-01-07 13:43:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"61.43","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"118.15","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":"3057492","reservation_id":"89660","confirmation_number":"SJ12681399916","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"153.09,153.09","nightly_discount":"0,0","subtotal":"306.18","grand_total":"344.45","paid_amount":"344.45","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-3351009341","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95644","customer_id":"95644","source_of_creation":"Booking.com","reservation_created_date":"2020-01-09 21:27:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"143.71","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"153.09","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":"3057497","reservation_id":"89660","confirmation_number":"SJ12653989801","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"132.84,132.84","nightly_discount":"0,0","subtotal":"265.68","grand_total":"298.89","paid_amount":"298.89","room_type_id":"319","product_id":"1310","siteminder_id":"BDC-3351009341","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95644","customer_id":"95644","source_of_creation":"Booking.com","reservation_created_date":"2020-01-09 21:27:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"143.71","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"132.84","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":"3053910","reservation_id":"82681","confirmation_number":"SJ12678429053","room_stay_from":"2020-01-05","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.00,256.00,256.00,256.00,256.00,277.00,277.00,256.00,256.00,256.00,256.00,256.00,277.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"3391.00","grand_total":"3814.88","paid_amount":"3814.88","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-3546252125","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":"90250","customer_id":"90250","source_of_creation":"Booking.com","reservation_created_date":"2019-08-15 14:53:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"610.38","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"256.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":"3057458","reservation_id":"89826","confirmation_number":"SJ12641559509","room_stay_from":"2020-01-13","room_stay_to":"2020-01-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.15,118.15,118.15,118.15,228.65,228.65,186.15","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1116.05","grand_total":"1255.55","paid_amount":"1255.55","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3717387009","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":"95939","customer_id":"95939","source_of_creation":"Booking.com","reservation_created_date":"2020-01-12 19:31:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"91.90","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"118.15","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":"3041412","reservation_id":"87311","confirmation_number":"SJ12694886066","room_stay_from":"2020-01-10","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.80,212.80,187.20,187.20","nightly_discount":"0,0,0,0","subtotal":"800.00","grand_total":"900.00","paid_amount":"900.00","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1600401387","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":"93866","customer_id":"93866","source_of_creation":"Expedia","reservation_created_date":"2019-11-19 03:58:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"187.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":"3055161","reservation_id":"89538","confirmation_number":"SJ12667774548","room_stay_from":"2020-01-12","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"89.79,89.79","nightly_discount":"0,0","subtotal":"179.58","grand_total":"202.03","paid_amount":"202.03","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1619086354","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":"95519","customer_id":"95519","source_of_creation":"Expedia","reservation_created_date":"2020-01-08 00:28:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"89.79","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":"3057552","reservation_id":"89892","confirmation_number":"SJ12665403633","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"105.94","nightly_discount":"0","subtotal":"105.94","grand_total":"119.19","paid_amount":"119.19","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1622281448","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":"95907","customer_id":"95907","source_of_creation":"Expedia","reservation_created_date":"2020-01-13 18:50:11","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","currentDayPrice":"105.94","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":"3057585","reservation_id":"89899","confirmation_number":"SJ12699346381","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"89.79","nightly_discount":"0","subtotal":"89.79","grand_total":"101.01","paid_amount":"101.01","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1622346030","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":"95916","customer_id":"95916","source_of_creation":"Expedia","reservation_created_date":"2020-01-13 20:38:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"89.79","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":"3057614","reservation_id":"89761","confirmation_number":"SJ12631808820","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"89.79","nightly_discount":"0.00","subtotal":"89.79","grand_total":"101.01","paid_amount":"101.01","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1621212462","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":"95775","customer_id":"95775","source_of_creation":"Expedia","reservation_created_date":"2020-01-11 18:48:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"89.79","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":"3057650","reservation_id":"89916","confirmation_number":"SJ12611059664","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.79","nightly_discount":"0","subtotal":"89.79","grand_total":"101.01","paid_amount":"101.01","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1622430856","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":"95936","customer_id":"95936","source_of_creation":"Expedia","reservation_created_date":"2020-01-13 23:08:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"89.79","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":"3052768","reservation_id":"88904","confirmation_number":"SJ12688867530","room_stay_from":"2020-01-10","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.16,202.16,120.84,120.84,120.84","nightly_discount":"0,0,0,0,0","subtotal":"766.84","grand_total":"862.69","paid_amount":"862.69","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1614274675","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":"95018","customer_id":"95018","source_of_creation":"Expedia","reservation_created_date":"2019-12-29 17:42:06","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","currentDayPrice":"120.84","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":"3053274","reservation_id":"89187","confirmation_number":"SJ12691990249","room_stay_from":"2020-01-04","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.39,102.71,102.71,102.71,102.71,102.71,178.94,178.94,102.71,102.71,102.71","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0","subtotal":"1333.95","grand_total":"1500.70","paid_amount":"1500.70","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1616419412","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":"95220","customer_id":"95220","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 01:27:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"102.71","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":"3056339","reservation_id":"70943","confirmation_number":"SJ12674412504","room_stay_from":"2020-01-10","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.80,212.80,187.20,187.20,187.20","nightly_discount":"0,0,0,0,0","subtotal":"987.20","grand_total":"1110.60","paid_amount":"1110.60","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1210146331","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":"82689","customer_id":"82689","source_of_creation":"Expedia","reservation_created_date":"2019-03-04 21:59:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"187.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":"3056901","reservation_id":"89786","confirmation_number":"SJ12627778905","room_stay_from":"2020-01-12","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.79,89.79,89.79","nightly_discount":"0,0,0","subtotal":"269.37","grand_total":"303.04","paid_amount":"303.04","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1621292879","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":"95805","customer_id":"95805","source_of_creation":"Expedia","reservation_created_date":"2020-01-11 23:48:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"89.79","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":"3057332","reservation_id":"88535","confirmation_number":"SJ12622755484","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"143.10,143.10","nightly_discount":"0,0","subtotal":"286.20","grand_total":"321.98","paid_amount":"321.98","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1610967015","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":"94735","customer_id":"94735","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 01:47:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"143.10","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":"3057341","reservation_id":"89805","confirmation_number":"SJ12698698036","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.15,118.15","nightly_discount":"0,0","subtotal":"236.30","grand_total":"265.84","paid_amount":"265.84","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1621608969","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":"95820","customer_id":"95820","source_of_creation":"Expedia","reservation_created_date":"2020-01-12 15:23:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"118.15","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":"3057343","reservation_id":"89816","confirmation_number":"SJ12681559621","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.15,118.15","nightly_discount":"0,0","subtotal":"236.30","grand_total":"265.84","paid_amount":"265.84","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1621676283","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":"95829","customer_id":"95829","source_of_creation":"Expedia","reservation_created_date":"2020-01-12 17:53:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"118.15","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":"3057365","reservation_id":"89834","confirmation_number":"SJ12655002669","room_stay_from":"2020-01-12","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.79,109.10,109.10","nightly_discount":"0.00,0.00,0.00","subtotal":"307.99","grand_total":"346.49","paid_amount":"346.49","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1621754431","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":"95850","customer_id":"95850","source_of_creation":"Expedia","reservation_created_date":"2020-01-12 20:38:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"109.10","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":"3057660","reservation_id":"89811","confirmation_number":"SJ12632620787","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"89.79,89.79","nightly_discount":"0.00,0.00","subtotal":"179.58","grand_total":"202.03","paid_amount":"202.03","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1621653026","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":"95825","customer_id":"95825","source_of_creation":"Expedia","reservation_created_date":"2020-01-12 17:03:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"89.79","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":"3055178","reservation_id":"89545","confirmation_number":"SJ12637950108","room_stay_from":"2020-01-12","room_stay_to":"2020-01-16","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"89.79,89.79,89.79,89.79","nightly_discount":"0,0,0,0","subtotal":"359.16","grand_total":"404.06","paid_amount":"404.06","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1619151883","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":"95527","customer_id":"95527","source_of_creation":"Expedia","reservation_created_date":"2020-01-08 02:48:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"89.79","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":"3057440","reservation_id":"88571","confirmation_number":"SJ12626846477","room_stay_from":"2020-01-12","room_stay_to":"2020-01-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.20,127.20,127.20,127.20","nightly_discount":"0,0,0,0","subtotal":"508.80","grand_total":"572.40","paid_amount":"572.40","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1611302377","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":"94768","customer_id":"94768","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 23:02:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"127.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":"3059520","reservation_id":"89903","confirmation_number":"SJ12653390569","room_stay_from":"2020-01-13","room_stay_to":"2020-01-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"236.30,118.15,118.15","nightly_discount":"0.00,0.00,0.00","subtotal":"472.60","grand_total":"531.68","paid_amount":"531.68","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1622350969","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":"95920","customer_id":"95920","source_of_creation":"Expedia","reservation_created_date":"2020-01-13 20:48:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"236.30","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":"3057371","reservation_id":"89645","confirmation_number":"SJ12677749408","room_stay_from":"2020-01-13","room_stay_to":"2020-01-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.79,89.79,89.79,89.79,173.77,173.77","nightly_discount":"0,0,0,0,0,0","subtotal":"706.70","grand_total":"795.04","paid_amount":"795.04","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1620060029","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":"95631","customer_id":"95631","source_of_creation":"Expedia","reservation_created_date":"2020-01-09 17:15:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"89.79","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":[{"room_stay_id":"3052524","reservation_id":"89052","confirmation_number":"SJ12694266876","room_stay_from":"2020-01-13","room_stay_to":"2020-01-18","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,102.71,102.71,102.71,171.84","nightly_discount":"0,0,0,0,0","subtotal":"582.68","grand_total":"655.51","paid_amount":"655.51","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1615484009","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":"95112","customer_id":"95112","source_of_creation":"Expedia","reservation_created_date":"2020-01-01 03:42:09","service_canceled_date_time":"2020-01-05 20:37:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"655.51","changedComment":"reservation is canceled but amt paid","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"}]}],"htn_taxable":[{"room_stay_id":"3056922","reservation_id":"89794","confirmation_number":"SJ12638333767","room_stay_from":"2020-01-12","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.32,92.32","nightly_discount":"0,0","subtotal":"184.64","grand_total":"207.72","paid_amount":"207.72","room_type_id":"319","product_id":"1274","siteminder_id":"HTN-115039651-TL6RXM","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":"95813","customer_id":"95813","source_of_creation":"HotelTonight","reservation_created_date":"2020-01-12 04:27:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"92.32","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":[{"room_stay_id":"3055207","reservation_id":"89548","confirmation_number":"SJ12610907600","room_stay_from":"2020-01-12","room_stay_to":"2020-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"695.00","grand_total":"781.88","paid_amount":"781.88","room_type_id":"319","product_id":"1287","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":"95529","customer_id":"95529","source_of_creation":"FE","reservation_created_date":"2020-01-08 03:45:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"139.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3057489","reservation_id":"89886","confirmation_number":"SJ12642702529","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.15","nightly_discount":"0.00","subtotal":"118.15","grand_total":"132.92","paid_amount":"132.92","room_type_id":"413","product_id":"1261","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":"95900","customer_id":"95900","source_of_creation":"PMS","reservation_created_date":"2020-01-13 17:57:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"118.15","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":"3057628","reservation_id":"89914","confirmation_number":"SJ12647273477","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.94","nightly_discount":"0.00","subtotal":"105.94","grand_total":"119.19","paid_amount":"119.19","room_type_id":"319","product_id":"1291","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":"95907","customer_id":"95907","source_of_creation":"PMS","reservation_created_date":"2020-01-13 22:44:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"105.94","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":"3057698","reservation_id":"89934","confirmation_number":"SJ12644074442","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"118.00","nightly_discount":"0.00","subtotal":"118.00","grand_total":"132.75","paid_amount":"132.75","room_type_id":"413","product_id":"1264","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":"95955","customer_id":"95955","source_of_creation":"PMS","reservation_created_date":"2020-01-14 02:58:35","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"118.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":"3056087","reservation_id":"88649","confirmation_number":"SJ12644793988","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00","nightly_discount":"0.00,0.00","subtotal":"298.00","grand_total":"335.25","paid_amount":"335.25","room_type_id":"412","product_id":"1315","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":"94833","customer_id":"94833","source_of_creation":"PMS","reservation_created_date":"2019-12-24 17:11:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"149.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":"3057328","reservation_id":"89807","confirmation_number":"SJ12636737456","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"139.00,139.00","nightly_discount":"0.00,0.00","subtotal":"278.00","grand_total":"312.75","paid_amount":"312.75","room_type_id":"412","product_id":"1866","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":"74942","customer_id":"74942","source_of_creation":"PMS","reservation_created_date":"2020-01-12 15:59:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"139.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":"3059000","reservation_id":"88945","confirmation_number":"SJ12680019277","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"446.99,149.00","nightly_discount":"0.00,0.00","subtotal":"595.99","grand_total":"670.49","paid_amount":"670.49","room_type_id":"319","product_id":"1305","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":"95028","customer_id":"95028","source_of_creation":"PMS","reservation_created_date":"2019-12-29 23:55:40","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","currentDayPrice":"446.99","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":"3040210","reservation_id":"85660","confirmation_number":"SJ12612274877","room_stay_from":"2020-01-11","room_stay_to":"2020-01-18","room_stay_status":"Closed","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":"1756","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":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-10-14 22:16:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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"}]},{"room_stay_id":"3054886","reservation_id":"88594","confirmation_number":"SJ12679013890","room_stay_from":"2020-01-11","room_stay_to":"2020-01-18","room_stay_status":"Closed","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":"1278","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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-23 13:43:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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"}]},{"room_stay_id":"3055135","reservation_id":"89529","confirmation_number":"SJ12647931336","room_stay_from":"2020-01-11","room_stay_to":"2020-01-25","room_stay_status":"Closed","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,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,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":"1277","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":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-01-07 23:17:21","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","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":[{"room_stay_id":"3074343","reservation_id":"79275","confirmation_number":"SJ12653133236","room_stay_from":"2020-01-11","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.62,127.62,127.62,127.62,127.62,127.62,127.61","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"893.33","grand_total":"1005.00","paid_amount":"1005.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":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-06-20 15:30:14","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","currentDayPrice":"127.62","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"}]}],"negotiated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3057616","reservation_id":"89761","confirmation_number":"SJ12646039330","room_confirmation_number":"SJ12631808820","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"95775","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-13 22:10:52","reservation_modified_date_time":"2020-01-13 22:10:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95775","canceled_nights_data":"","currentDayPrice":"25","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":"3057699","reservation_id":"89934","confirmation_number":"SJ12692977619","room_confirmation_number":"SJ12644074442","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95955","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-14 02:58:35","reservation_modified_date_time":"2020-01-14 02:58:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95955","canceled_nights_data":"","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":"3041413","reservation_id":"87311","confirmation_number":"SJ12696450252","room_confirmation_number":"SJ12694886066","room_stay_from":"2020-01-10","room_stay_to":"2020-01-14","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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"93866","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-19 03:58:07","reservation_modified_date_time":"2019-11-19 03:58:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93866","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":"3055162","reservation_id":"89538","confirmation_number":"SJ12651960859","room_confirmation_number":"SJ12667774548","room_stay_from":"2020-01-12","room_stay_to":"2020-01-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":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"95519","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 00:28:08","reservation_modified_date_time":"2020-01-08 00:28:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95519","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":"3056923","reservation_id":"89794","confirmation_number":"SJ12694662931","room_confirmation_number":"SJ12638333767","room_stay_from":"2020-01-12","room_stay_to":"2020-01-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":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"95813","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-12 04:27:08","reservation_modified_date_time":"2020-01-12 04:27:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95813","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":"3057098","reservation_id":"89820","confirmation_number":"SJ12661114232","room_confirmation_number":"SJ12685082986","room_stay_from":"2020-01-12","room_stay_to":"2020-01-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":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"95968","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-12 19:02:10","reservation_modified_date_time":"2020-01-12 19:02:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95968","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":"3057490","reservation_id":"89886","confirmation_number":"SJ12697846553","room_confirmation_number":"SJ12642702529","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 17:57:30","reservation_modified_date_time":"2020-01-13 17:57:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95900","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":"3057554","reservation_id":"89892","confirmation_number":"SJ12699548489","room_confirmation_number":"SJ12665403633","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95907","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 18:50:11","reservation_modified_date_time":"2020-01-13 18:50:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95907","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":"3057586","reservation_id":"89899","confirmation_number":"SJ12627540522","room_confirmation_number":"SJ12699346381","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95916","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 20:38:07","reservation_modified_date_time":"2020-01-13 20:38:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95916","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":"3057592","reservation_id":"89906","confirmation_number":"SJ12693465947","room_confirmation_number":"SJ12664213476","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95924","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 21:26:10","reservation_modified_date_time":"2020-01-13 21:26:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95924","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":"3057617","reservation_id":"89761","confirmation_number":"SJ12663191803","room_confirmation_number":"SJ12631808820","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95775","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-11 18:48:08","reservation_modified_date_time":"2020-01-13 22:10:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95775","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":"3057629","reservation_id":"89914","confirmation_number":"SJ12679247790","room_confirmation_number":"SJ12647273477","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95907","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 22:44:32","reservation_modified_date_time":"2020-01-13 22:44:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95907","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":"3057652","reservation_id":"89916","confirmation_number":"SJ12670793364","room_confirmation_number":"SJ12611059664","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95936","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 23:08:10","reservation_modified_date_time":"2020-01-13 23:08:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95936","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":"3057700","reservation_id":"89934","confirmation_number":"SJ12645193285","room_confirmation_number":"SJ12644074442","room_stay_from":"2020-01-13","room_stay_to":"2020-01-14","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":"95955","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-14 02:58:35","reservation_modified_date_time":"2020-01-14 02:58:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95955","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":"3052769","reservation_id":"88904","confirmation_number":"SJ12683470112","room_confirmation_number":"SJ12688867530","room_stay_from":"2020-01-10","room_stay_to":"2020-01-15","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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"95018","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-29 17:42:06","reservation_modified_date_time":"2019-12-29 17:42:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95018","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":"3053275","reservation_id":"89187","confirmation_number":"SJ12654474834","room_confirmation_number":"SJ12691990249","room_stay_from":"2020-01-04","room_stay_to":"2020-01-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,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,0.00,0.00,0.00,0.00","subtotal":"275.00","grand_total":"309.38","paid_amount":"309.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"95220","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-03 01:27:05","reservation_modified_date_time":"2020-01-03 01:27:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95220","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":"3056088","reservation_id":"88649","confirmation_number":"SJ12636906464","room_confirmation_number":"SJ12644793988","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"94833","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-24 17:11:05","reservation_modified_date_time":"2019-12-24 17:11:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94833","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":"3056340","reservation_id":"70943","confirmation_number":"SJ12696711867","room_confirmation_number":"SJ12674412504","room_stay_from":"2020-01-10","room_stay_to":"2020-01-15","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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"82689","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-04 21:59:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82689","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":"3056902","reservation_id":"89786","confirmation_number":"SJ12614731551","room_confirmation_number":"SJ12627778905","room_stay_from":"2020-01-12","room_stay_to":"2020-01-15","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":"95805","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-11 23:48:10","reservation_modified_date_time":"2020-01-11 23:48:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95805","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":"3057329","reservation_id":"89807","confirmation_number":"SJ12634507505","room_confirmation_number":"SJ12636737456","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"74942","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-12 15:59:54","reservation_modified_date_time":"2020-01-12 15:59:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74942","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":"3057331","reservation_id":"89496","confirmation_number":"SJ12616559681","room_confirmation_number":"SJ12642875634","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"95478","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-07 13:43:12","reservation_modified_date_time":"2020-01-07 13:43:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95478","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":"3057333","reservation_id":"88535","confirmation_number":"SJ12678898953","room_confirmation_number":"SJ12622755484","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"94735","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-22 01:47:11","reservation_modified_date_time":"2019-12-22 01:47:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94735","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":"3057342","reservation_id":"89805","confirmation_number":"SJ12688516270","room_confirmation_number":"SJ12698698036","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"95820","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-12 15:23:09","reservation_modified_date_time":"2020-01-12 15:23:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95820","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":"3057344","reservation_id":"89816","confirmation_number":"SJ12625737762","room_confirmation_number":"SJ12681559621","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"95829","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-12 17:53:09","reservation_modified_date_time":"2020-01-12 17:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95829","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":"3057366","reservation_id":"89834","confirmation_number":"SJ12681371377","room_confirmation_number":"SJ12655002669","room_stay_from":"2020-01-12","room_stay_to":"2020-01-15","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":"95850","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-12 20:38:10","reservation_modified_date_time":"2020-01-13 13:03:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95850","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":"3057496","reservation_id":"89660","confirmation_number":"SJ12629270851","room_confirmation_number":"SJ12681399916","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"95644","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-09 21:27:08","reservation_modified_date_time":"2020-01-09 21:27:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95644","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":"3057499","reservation_id":"89660","confirmation_number":"SJ12693499146","room_confirmation_number":"SJ12653989801","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"95644","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-09 21:27:12","reservation_modified_date_time":"2020-01-09 21:27:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95644","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":"3057662","reservation_id":"89811","confirmation_number":"SJ12610450305","room_confirmation_number":"SJ12632620787","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"95825","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-12 17:03:07","reservation_modified_date_time":"2020-01-13 23:58:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95825","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":"3059001","reservation_id":"88945","confirmation_number":"SJ12635830659","room_confirmation_number":"SJ12680019277","room_stay_from":"2020-01-13","room_stay_to":"2020-01-15","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":"95028","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-29 23:55:40","reservation_modified_date_time":"2020-01-18 01:02:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95028","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":"3055179","reservation_id":"89545","confirmation_number":"SJ12633155921","room_confirmation_number":"SJ12637950108","room_stay_from":"2020-01-12","room_stay_to":"2020-01-16","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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"95527","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 02:48:05","reservation_modified_date_time":"2020-01-08 02:48:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95527","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":"3057443","reservation_id":"88571","confirmation_number":"SJ12686658220","room_confirmation_number":"SJ12626846477","room_stay_from":"2020-01-12","room_stay_to":"2020-01-16","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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"94768","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-22 23:02:09","reservation_modified_date_time":"2019-12-22 23:02:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94768","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":"3059521","reservation_id":"89903","confirmation_number":"SJ12684179071","room_confirmation_number":"SJ12653390569","room_stay_from":"2020-01-13","room_stay_to":"2020-01-16","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":"95920","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 20:48:11","reservation_modified_date_time":"2020-01-18 22:46:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95920","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":"3055208","reservation_id":"89548","confirmation_number":"SJ12653970421","room_confirmation_number":"SJ12610907600","room_stay_from":"2020-01-12","room_stay_to":"2020-01-17","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.62","paid_amount":"140.62","product_id":"1776","service_quantity":"1","customer_traveller_id":"95529","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 03:45:47","reservation_modified_date_time":"2020-01-08 03:45:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95529","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":"3040211","reservation_id":"85660","confirmation_number":"SJ12627471883","room_confirmation_number":"SJ12612274877","room_stay_from":"2020-01-11","room_stay_to":"2020-01-18","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":"92695","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-14 22:16:07","reservation_modified_date_time":"2019-10-14 22:16:07","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","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":"3053911","reservation_id":"82681","confirmation_number":"SJ12667680396","room_confirmation_number":"SJ12678429053","room_stay_from":"2020-01-05","room_stay_to":"2020-01-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,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,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"365.63","paid_amount":"365.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"90250","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-15 14:53:11","reservation_modified_date_time":"2019-08-15 14:53:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90250","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":"3054887","reservation_id":"88594","confirmation_number":"SJ12639698098","room_confirmation_number":"SJ12679013890","room_stay_from":"2020-01-11","room_stay_to":"2020-01-18","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":"94787","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-23 13:43:04","reservation_modified_date_time":"2019-12-23 13:43:04","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3074344","reservation_id":"79275","confirmation_number":"SJ12699698505","room_confirmation_number":"SJ12653133236","room_stay_from":"2020-01-11","room_stay_to":"2020-01-18","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":"87928","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-06-20 15:30:14","reservation_modified_date_time":"2020-02-25 23:12:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","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":"3057372","reservation_id":"89645","confirmation_number":"SJ12624544720","room_confirmation_number":"SJ12677749408","room_stay_from":"2020-01-13","room_stay_to":"2020-01-19","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":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"95631","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-09 17:15:09","reservation_modified_date_time":"2020-01-09 17:15:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95631","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":"3057460","reservation_id":"89826","confirmation_number":"SJ12668409740","room_confirmation_number":"SJ12641559509","room_stay_from":"2020-01-13","room_stay_to":"2020-01-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"95939","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-12 19:31:10","reservation_modified_date_time":"2020-01-12 19:31:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95939","canceled_nights_data":"","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":"3055136","reservation_id":"89529","confirmation_number":"SJ12667614614","room_confirmation_number":"SJ12647931336","room_stay_from":"2020-01-11","room_stay_to":"2020-01-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,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,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":"94788","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-07 23:17:21","reservation_modified_date_time":"2020-01-07 23:17:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3057635","reservation_id":"89915","confirmation_number":"SJ12693434367","room_confirmation_number":"SJ12679543552","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":"86.00","paid_amount":"86.00","product_id":null,"service_quantity":"2","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-13 23:05:17","reservation_modified_date_time":"2020-01-13 23:05:17","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3057647","reservation_id":"89917","confirmation_number":"SJ12631857428","room_confirmation_number":"SJ12625024869","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":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-13 23:10:12","reservation_modified_date_time":"2020-01-13 23:10:12","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"40.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":"3057655","reservation_id":"89886","confirmation_number":"SJ12681076181","room_confirmation_number":"SJ12642702529","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":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-13 23:44:11","reservation_modified_date_time":"2020-01-13 23:44:11","customer_id":"95900","parentCustTravId":"95900","customer_traveller_id":"95900","static_pos_type":"drinks","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":"3.72","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":[]}}