{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-07","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":13,"holdBlockRooms":{"hold_room_count":"1277","hold_room_bookings":[{"confirmation_number":"SJ12630287910","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","bundle_room":"0"}],"block_room_count":"1301,1923,1313,1920,1943,1314,1922,1921,1919,1918,1262,1270","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":"SJ12673593636","room_stay_from":"2019-11-09","room_stay_to":"2019-11-20","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"}],"bundle_block_count":"1260,1261,1309,1310,1267,1268,1271,1272","bundle_block_bookings":[{"confirmation_number":"SJB12682320902","room_stay_from":"2020-01-07","room_stay_to":"2020-01-08","bundle_room":"1"},{"confirmation_number":"SJB12647173215","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","bundle_room":"1"},{"confirmation_number":"SJB12627170961","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","bundle_room":"1"},{"confirmation_number":"SJB12611155243","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3054693","reservation_id":"89411","confirmation_number":"SJ12627293243","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.15,135.15","nightly_discount":"0,0","subtotal":"270.30","grand_total":"304.09","paid_amount":"304.09","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3992453163","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":"95385","customer_id":"95385","source_of_creation":"Booking.com","reservation_created_date":"2020-01-05 20:55:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"56.76","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.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":"3052764","reservation_id":"88947","confirmation_number":"SJ12693498453","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.15,135.15,135.15","nightly_discount":"0,0,0","subtotal":"405.45","grand_total":"456.13","paid_amount":"456.13","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3677562479","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":"95030","customer_id":"95030","source_of_creation":"Booking.com","reservation_created_date":"2019-12-30 00:18:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"85.14","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.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":"3054475","reservation_id":"89363","confirmation_number":"SJ12633293904","room_stay_from":"2020-01-07","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.95,135.95,135.95,236.83","nightly_discount":"0,0,0,0","subtotal":"644.68","grand_total":"725.26","paid_amount":"725.26","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3749023576","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":"95347","customer_id":"95347","source_of_creation":"Booking.com","reservation_created_date":"2020-01-05 00:38:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"135.38","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.95","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3054385","reservation_id":"89385","confirmation_number":"SJ12692944471","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.84,120.84","nightly_discount":"0,0","subtotal":"241.68","grand_total":"271.89","paid_amount":"271.89","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1617640045","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":"95365","customer_id":"95365","source_of_creation":"Expedia","reservation_created_date":"2020-01-05 13:27:08","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":"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":"3054696","reservation_id":"89440","confirmation_number":"SJ12636070828","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.84,120.84","nightly_discount":"0,0","subtotal":"241.68","grand_total":"271.89","paid_amount":"271.89","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1617930581","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":"95404","customer_id":"95404","source_of_creation":"Expedia","reservation_created_date":"2020-01-06 01:27:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","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":"3054107","reservation_id":"89012","confirmation_number":"SJ12610602332","room_stay_from":"2020-01-04","room_stay_to":"2020-01-09","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"178.94,102.71,102.71,102.71,102.71","nightly_discount":"0,0,0,0,0","subtotal":"589.78","grand_total":"663.50","paid_amount":"663.50","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1615239602","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":"95091","customer_id":"95091","source_of_creation":"Expedia","reservation_created_date":"2019-12-31 16:07: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":"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":"3054493","reservation_id":"89401","confirmation_number":"SJ12615404278","room_stay_from":"2020-01-07","room_stay_to":"2020-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,102.71","nightly_discount":"0,0","subtotal":"205.42","grand_total":"231.10","paid_amount":"231.10","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1617765745","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":"95382","customer_id":"95382","source_of_creation":"Expedia","reservation_created_date":"2020-01-05 19:12:06","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":"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":"3054876","reservation_id":"89468","confirmation_number":"SJ12690539560","room_stay_from":"2020-01-07","room_stay_to":"2020-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,102.71","nightly_discount":"0,0","subtotal":"205.42","grand_total":"231.10","paid_amount":"231.10","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1391767923","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":"95446","customer_id":"95446","source_of_creation":"Expedia","reservation_created_date":"2020-01-06 20:53:10","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":"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":"3055155","reservation_id":"89075","confirmation_number":"SJ12647023122","room_stay_from":"2020-01-05","room_stay_to":"2020-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,102.71,102.71,102.71","nightly_discount":"0,0,0,0","subtotal":"410.84","grand_total":"462.19","paid_amount":"462.19","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1615695948","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":"95134","customer_id":"95134","source_of_creation":"Expedia","reservation_created_date":"2020-01-01 18:57:08","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","changedComment":"To date changed","deltaChange":"0.00","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":"3049064","reservation_id":"88513","confirmation_number":"SJ12649029680","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.48,114.48,114.48","nightly_discount":"0,0,0","subtotal":"343.44","grand_total":"386.37","paid_amount":"386.37","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1610716726","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":"94717","customer_id":"94717","source_of_creation":"Expedia","reservation_created_date":"2019-12-21 13:22:08","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":"114.48","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":"3054590","reservation_id":"89426","confirmation_number":"SJ12673953258","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,102.71,102.71","nightly_discount":"0,0,0","subtotal":"308.13","grand_total":"346.65","paid_amount":"346.65","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1617854747","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":"95392","customer_id":"95392","source_of_creation":"Expedia","reservation_created_date":"2020-01-05 22:32:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","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":"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":"3055002","reservation_id":"89299","confirmation_number":"SJ12666095809","room_stay_from":"2020-01-04","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.39,102.71,102.71","nightly_discount":"0.00,0.00,0.00","subtotal":"359.81","grand_total":"404.79","paid_amount":"404.79","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1617032226","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":"95301","customer_id":"95301","source_of_creation":"Expedia","reservation_created_date":"2020-01-04 03:17:08","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","changedComment":"Nightly price or discount changed","deltaChange":"-177.19","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3054721","reservation_id":"89449","confirmation_number":"SJ12653691431","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1942","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":"93822","customer_id":"93822","source_of_creation":"PMS","reservation_created_date":"2020-01-06 14:14:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3050234","reservation_id":"88681","confirmation_number":"SJ12641420568","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94172","customer_id":"94172","source_of_creation":"PMS","reservation_created_date":"2019-12-25 16:06:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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"}]}],"pms_non_taxable":[{"room_stay_id":"3040208","reservation_id":"82209","confirmation_number":"SJ12641800269","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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-08-07 21:25:33","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":"3053955","reservation_id":"86396","confirmation_number":"SJ12618645465","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2019-10-29 01:50:52","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":"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":"3054387","reservation_id":"88781","confirmation_number":"SJ12636937722","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"1276","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":"74796","customer_id":"74796","source_of_creation":"PMS","reservation_created_date":"2019-12-27 17:21:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","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":"3074309","reservation_id":"82191","confirmation_number":"SJ12620845683","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"127.41,127.41,127.40","nightly_discount":"0.00,0.00,0.00","subtotal":"382.22","grand_total":"430.00","paid_amount":"430.00","room_type_id":"413","product_id":"1265","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-08-07 18:41:30","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":"127.40","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":[{"room_stay_id":"3055624","reservation_id":"89234","confirmation_number":"SJ12698230410","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.14,222.14,222.14,222.14,222.14,222.14,222.14","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1554.98","grand_total":"1554.98","paid_amount":"0.00","room_type_id":"319","product_id":"1287","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-01-03 17:08:46","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":"222.14","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"}]}],"extra_person_taxable":[{"room_stay_id":"3074284","reservation_id":"82191","confirmation_number":"SJ12687778805","room_confirmation_number":"SJ12620845683","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"74459","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-08-07 18:41:30","reservation_modified_date_time":"2020-02-25 23:03:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3054386","reservation_id":"89385","confirmation_number":"SJ12682547842","room_confirmation_number":"SJ12692944471","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","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":"95365","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-05 13:27:08","reservation_modified_date_time":"2020-01-05 13:27:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95365","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":"3054695","reservation_id":"89411","confirmation_number":"SJ12629772878","room_confirmation_number":"SJ12627293243","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","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":"95385","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-05 20:55:05","reservation_modified_date_time":"2020-01-05 20:55:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95385","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":"3054698","reservation_id":"89440","confirmation_number":"SJ12618977170","room_confirmation_number":"SJ12636070828","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","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":"95404","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-06 01:27:10","reservation_modified_date_time":"2020-01-06 01:27:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95404","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":"3054722","reservation_id":"89449","confirmation_number":"SJ12625725604","room_confirmation_number":"SJ12653691431","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","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":"93822","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-06 14:14:37","reservation_modified_date_time":"2020-01-06 14:14:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93822","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":"3074310","reservation_id":"82191","confirmation_number":"SJ12657202706","room_confirmation_number":"SJ12620845683","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","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":"95416","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-07 18:41:30","reservation_modified_date_time":"2020-02-25 23:04:07","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":"3054108","reservation_id":"89012","confirmation_number":"SJ12664918440","room_confirmation_number":"SJ12610602332","room_stay_from":"2020-01-04","room_stay_to":"2020-01-09","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":"95091","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-31 16:07:09","reservation_modified_date_time":"2019-12-31 16:07:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95091","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":"3054494","reservation_id":"89401","confirmation_number":"SJ12618866591","room_confirmation_number":"SJ12615404278","room_stay_from":"2020-01-07","room_stay_to":"2020-01-09","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":"95382","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-05 19:12:06","reservation_modified_date_time":"2020-01-05 19:12:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95382","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":"3054877","reservation_id":"89468","confirmation_number":"SJ12613363563","room_confirmation_number":"SJ12690539560","room_stay_from":"2020-01-07","room_stay_to":"2020-01-09","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":"95446","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-06 20:53:10","reservation_modified_date_time":"2020-01-06 20:53:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95446","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":"3055157","reservation_id":"89075","confirmation_number":"SJ12617524930","room_confirmation_number":"SJ12647023122","room_stay_from":"2020-01-05","room_stay_to":"2020-01-09","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":"95134","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-01 18:57:08","reservation_modified_date_time":"2020-01-01 18:57:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95134","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":"3049065","reservation_id":"88513","confirmation_number":"SJ12643237409","room_confirmation_number":"SJ12649029680","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","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":"94717","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-21 13:22:08","reservation_modified_date_time":"2019-12-21 13:22:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94717","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":"3050235","reservation_id":"88681","confirmation_number":"SJ12693216846","room_confirmation_number":"SJ12641420568","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"94854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-25 16:06:13","reservation_modified_date_time":"2019-12-25 16:06:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94172","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":"3052766","reservation_id":"88947","confirmation_number":"SJ12683115384","room_confirmation_number":"SJ12693498453","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","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":"95030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-30 00:18:12","reservation_modified_date_time":"2019-12-30 00:18:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95030","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":"3054591","reservation_id":"89426","confirmation_number":"SJ12636071960","room_confirmation_number":"SJ12673953258","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","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":"95392","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-05 22:32:08","reservation_modified_date_time":"2020-01-05 22:32:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95392","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":"3040209","reservation_id":"82209","confirmation_number":"SJ12661407005","room_confirmation_number":"SJ12641800269","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"89945","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-07 21:25:33","reservation_modified_date_time":"2019-08-07 21:25:33","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":"3053956","reservation_id":"86396","confirmation_number":"SJ12692216439","room_confirmation_number":"SJ12618645465","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"93158","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-29 01:50:52","reservation_modified_date_time":"2019-10-29 01:50:52","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","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":"3054042","reservation_id":"89234","confirmation_number":"SJ12650543293","room_confirmation_number":"SJ12698230410","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"95259","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-03 17:08:46","reservation_modified_date_time":"2020-01-04 18:55:43","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3054388","reservation_id":"88781","confirmation_number":"SJ12639105693","room_confirmation_number":"SJ12636937722","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"94934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-27 17:21:37","reservation_modified_date_time":"2019-12-27 17:21:37","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74796","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":"3054476","reservation_id":"89363","confirmation_number":"SJ12646876387","room_confirmation_number":"SJ12633293904","room_stay_from":"2020-01-07","room_stay_to":"2020-01-11","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":"95347","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-05 00:38:06","reservation_modified_date_time":"2020-01-05 00:38:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95347","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":"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}