{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-10","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":8,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"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":"1271,1272,1267,1268,1307,1308,1311,1312,1309,1310,1260,1261,1291,1711,1304,1305,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12680311682","room_stay_from":"2020-01-10","room_stay_to":"2020-01-11","bundle_room":"1"},{"confirmation_number":"SJB12675494724","room_stay_from":"2020-01-10","room_stay_to":"2020-01-11","bundle_room":"1"},{"confirmation_number":"SJB12673357575","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","bundle_room":"1"},{"confirmation_number":"SJB12658334368","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","bundle_room":"1"},{"confirmation_number":"SJB12653798111","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","bundle_room":"1"},{"confirmation_number":"SJB12647323315","room_stay_from":"2020-01-10","room_stay_to":"2020-01-11","bundle_room":"1"},{"confirmation_number":"SJB12628595471","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","bundle_room":"1"},{"confirmation_number":"SJB12618681534","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","bundle_room":"1"},{"confirmation_number":"SJB12613256231","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"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":"236.83","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":"277.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":"3056486","reservation_id":"89625","confirmation_number":"SJ12635995766","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,173.77","nightly_discount":"0.00,0.00","subtotal":"276.48","grand_total":"311.04","paid_amount":"311.04","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1392044994","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":"95615","customer_id":"95615","source_of_creation":"Expedia","reservation_created_date":"2020-01-09 12:08: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":"173.77","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":"3056512","reservation_id":"88615","confirmation_number":"SJ12664884787","room_stay_from":"2020-01-10","room_stay_to":"2020-01-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.61,199.61","nightly_discount":"0,0","subtotal":"399.22","grand_total":"449.12","paid_amount":"449.12","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1611658276","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":"94807","customer_id":"94807","source_of_creation":"Expedia","reservation_created_date":"2019-12-23 19:22:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"87.63","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"199.61","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":"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":"212.80","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":"202.16","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":"178.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":"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":"212.80","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":"3056042","reservation_id":"84273","confirmation_number":"SJ12681427677","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"401.63","paid_amount":"401.63","room_type_id":"319","product_id":"1302","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 22:25:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"119.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"}]},{"room_stay_id":"3037428","reservation_id":"87017","confirmation_number":"SJ12614181418","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"413","product_id":"1267","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-11-11 22:17:12","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":"119.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":"3037437","reservation_id":"87017","confirmation_number":"SJ12645068350","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"413","product_id":"1268","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-11-11 22:17:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"119.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":"3037446","reservation_id":"87017","confirmation_number":"SJ12673176810","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"413","product_id":"1271","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-11-11 22:17:12","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":"119.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":"3037455","reservation_id":"87017","confirmation_number":"SJ12698750086","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"413","product_id":"1272","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-11-11 22:17:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"119.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":"3039296","reservation_id":"84267","confirmation_number":"SJ12639421952","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1311","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 21:22:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"119.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":"3039315","reservation_id":"84267","confirmation_number":"SJ12635863450","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1309","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 21:22:52","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":"119.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":"3039336","reservation_id":"84271","confirmation_number":"SJ12677236328","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1306","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 22:35:12","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":"119.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":"3042348","reservation_id":"84267","confirmation_number":"SJ12689249754","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1310","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 21:22:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"119.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":"3049672","reservation_id":"87250","confirmation_number":"SJ12674050194","room_stay_from":"2020-01-09","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"476.00","grand_total":"476.00","paid_amount":"476.00","room_type_id":"319","product_id":"1711","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-11-17 18:05:10","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":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3056045","reservation_id":"84273","confirmation_number":"SJ12651425304","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1303","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 22:23:43","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":"119.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":"3056047","reservation_id":"84271","confirmation_number":"SJ12695390594","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1304","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 22:17:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"119.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":"3056051","reservation_id":"84271","confirmation_number":"SJ12640465317","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 22:37:34","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":"119.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":"3056053","reservation_id":"84267","confirmation_number":"SJ12664708409","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1307","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 21:22:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"119.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":"3056056","reservation_id":"84267","confirmation_number":"SJ12662906312","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1308","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 21:22:52","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":"119.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":"3056060","reservation_id":"84280","confirmation_number":"SJ12627383400","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"357.00","paid_amount":"357.00","room_type_id":"319","product_id":"1288","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 23:46:31","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":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"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":"3056487","reservation_id":"89625","confirmation_number":"SJ12681287556","room_confirmation_number":"SJ12635995766","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","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":"95615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-09 12:08:10","reservation_modified_date_time":"2020-01-11 00:14:02","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95615","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":"3056514","reservation_id":"88615","confirmation_number":"SJ12653261802","room_confirmation_number":"SJ12664884787","room_stay_from":"2020-01-10","room_stay_to":"2020-01-12","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":"94807","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-23 19:22:07","reservation_modified_date_time":"2019-12-23 19:22:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94807","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":"3037430","reservation_id":"87017","confirmation_number":"SJ12642546539","room_confirmation_number":"SJ12614181418","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"93612","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-11 22:17:12","reservation_modified_date_time":"2019-11-11 22:18:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3037439","reservation_id":"87017","confirmation_number":"SJ12636513757","room_confirmation_number":"SJ12645068350","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"93612","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-11 22:17:12","reservation_modified_date_time":"2019-11-11 22:19:02","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3037448","reservation_id":"87017","confirmation_number":"SJ12672200711","room_confirmation_number":"SJ12673176810","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"93612","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-11 22:17:12","reservation_modified_date_time":"2019-11-11 22:19:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3037457","reservation_id":"87017","confirmation_number":"SJ12665070621","room_confirmation_number":"SJ12698750086","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"93612","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-11 22:17:12","reservation_modified_date_time":"2019-11-11 22:19:37","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3039298","reservation_id":"84267","confirmation_number":"SJ12659965378","room_confirmation_number":"SJ12639421952","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 21:22:52","reservation_modified_date_time":"2019-11-17 17:44:37","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3039316","reservation_id":"84267","confirmation_number":"SJ12629737387","room_confirmation_number":"SJ12635863450","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 21:22:52","reservation_modified_date_time":"2019-11-17 17:45:52","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3039337","reservation_id":"84271","confirmation_number":"SJ12615341810","room_confirmation_number":"SJ12677236328","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91751","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 22:35:12","reservation_modified_date_time":"2019-11-17 17:47:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3042350","reservation_id":"84267","confirmation_number":"SJ12621435158","room_confirmation_number":"SJ12689249754","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 21:22:52","reservation_modified_date_time":"2019-11-17 17:37:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3049674","reservation_id":"87250","confirmation_number":"SJ12673735084","room_confirmation_number":"SJ12674050194","room_stay_from":"2020-01-09","room_stay_to":"2020-01-13","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":"93811","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-17 18:05:10","reservation_modified_date_time":"2019-11-17 18:05:10","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3056044","reservation_id":"84273","confirmation_number":"SJ12625612692","room_confirmation_number":"SJ12681427677","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91753","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 22:25:11","reservation_modified_date_time":"2020-01-09 14:03:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91749","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":"3056046","reservation_id":"84273","confirmation_number":"SJ12689526017","room_confirmation_number":"SJ12651425304","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91753","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 22:23:43","reservation_modified_date_time":"2019-11-17 17:56:04","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3056050","reservation_id":"84271","confirmation_number":"SJ12688430233","room_confirmation_number":"SJ12695390594","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91751","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 22:17:19","reservation_modified_date_time":"2019-11-17 17:47:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3056052","reservation_id":"84271","confirmation_number":"SJ12643566389","room_confirmation_number":"SJ12640465317","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91751","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 22:37:34","reservation_modified_date_time":"2019-11-17 17:49:04","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3056055","reservation_id":"84267","confirmation_number":"SJ12693894230","room_confirmation_number":"SJ12664708409","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 21:22:52","reservation_modified_date_time":"2019-11-17 17:45:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3056057","reservation_id":"84267","confirmation_number":"SJ12698764043","room_confirmation_number":"SJ12662906312","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 21:22:52","reservation_modified_date_time":"2019-11-17 17:44:59","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"3056061","reservation_id":"84280","confirmation_number":"SJ12683642504","room_confirmation_number":"SJ12627383400","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","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":"1776","service_quantity":"1","customer_traveller_id":"91760","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-17 23:46:31","reservation_modified_date_time":"2019-11-17 17:46:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","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":"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":"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":"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":"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":[]}}