{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-02-24","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":10,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1921,1304,1305,1943,1286,1915,1288,1297","block_room_bookings":[{"confirmation_number":"SJ12698132693","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1921"},{"confirmation_number":"SJ12665077438","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJ12662944193","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1943"},{"confirmation_number":"SJ12676777901","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1286"},{"confirmation_number":"SJ12616644644","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1915"},{"confirmation_number":"SJ12618518113","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1288"},{"confirmation_number":"SJ12680392580","room_stay_from":"2021-02-18","room_stay_to":"2021-02-28","bundle_room":"0","product_id":"1297"}],"bundle_block_count":"1291,1711,1309,1310,1271,1272,1311,1312,1307,1308,1304,1305,1267,1268,1269,1270,1260,1261,1262,1263,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12657578174","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12664365860","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12613666290","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12662390463","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12681415744","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12666901296","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12634496058","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12654035203","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12639807593","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12630055834","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12629776051","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12686255054","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12671736056","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12697477345","room_stay_from":"2021-02-23","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12616993937","room_stay_from":"2021-02-23","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12671983593","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12612334921","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12662873179","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3192731","reservation_id":"105778","confirmation_number":"SJ12643903300","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.26,151.26,151.26","nightly_discount":"0,0,0","subtotal":"453.78","grand_total":"510.50","paid_amount":"510.50","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2471178951","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":"112180","customer_id":"112180","source_of_creation":"Booking.com","reservation_created_date":"2021-01-21 06:30:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"95.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"151.26","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":"3201094","reservation_id":"108050","confirmation_number":"SJ12626593000","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"242.33,242.33,242.33","nightly_discount":"0,0,0","subtotal":"726.99","grand_total":"817.86","paid_amount":"817.86","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-3352818358","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":"114517","customer_id":"114517","source_of_creation":"Booking.com","reservation_created_date":"2021-02-19 18:12:36","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","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"242.33","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":"3194885","reservation_id":"104679","confirmation_number":"SJ12636630959","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,174.30,174.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2513680211","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":"111033","customer_id":"111033","source_of_creation":"Booking.com","reservation_created_date":"2021-01-04 00:53:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"143.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","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":"3179464","reservation_id":"104587","confirmation_number":"SJ12686301450","room_stay_from":"2021-02-19","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.30,202.30,174.30,174.30,174.30,174.30,174.30,202.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1478.40","grand_total":"1663.20","paid_amount":"1663.20","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2331247034","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":"114516","customer_id":"110936","source_of_creation":"Booking.com","reservation_created_date":"2021-01-02 18:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"302.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","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":"3184971","reservation_id":"106179","confirmation_number":"SJ12615389852","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.67,194.67,175.77,175.77,175.77,200.97","nightly_discount":"0,0,0,0,0,0","subtotal":"1117.62","grand_total":"1257.32","paid_amount":"1257.32","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2126163221","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":"112586","customer_id":"112586","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 18:01:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"228.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"175.77","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":"3200914","reservation_id":"106188","confirmation_number":"SJ12640825161","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"238.77,194.67,194.67,175.77,175.77,175.77,200.97","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1356.39","grand_total":"1525.94","paid_amount":"1525.94","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3239349705","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":"112595","customer_id":"112595","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 19:37:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"275.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"175.77","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":"3203653","reservation_id":"106362","confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,188.37,188.37,163.17,163.17,163.17","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1192.59","grand_total":"1341.66","paid_amount":"183.57","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2673763646","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":"112757","customer_id":"112757","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 23:36:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"246.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3203076","reservation_id":"108313","confirmation_number":"SJ12680972985","room_stay_from":"2021-02-23","room_stay_to":"2021-02-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.20,287.20","nightly_discount":"0,0","subtotal":"574.40","grand_total":"646.20","paid_amount":"323.10","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3909718508","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":"114769","customer_id":"114769","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 22:14:13","service_canceled_date_time":"2021-02-24 15:50:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"112.39","reservation_status_type":"room_dates_changed","total_paid_amount":"323.10","sub_hotel_id":"126","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3180456","reservation_id":"105515","confirmation_number":"SJ12650920347","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.44,223.44,223.44,223.44","nightly_discount":"0,0,0,0","subtotal":"893.76","grand_total":"1005.48","paid_amount":"1005.48","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1730698443","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":"111930","customer_id":"111930","source_of_creation":"Expedia","reservation_created_date":"2021-01-17 18:41:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"223.44","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":"3181138","reservation_id":"105583","confirmation_number":"SJ12657879374","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1731006446","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":"112004","customer_id":"112004","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 23:11:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.30","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":"3184756","reservation_id":"105947","confirmation_number":"SJ12696208084","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"271.32","nightly_discount":"0","subtotal":"271.32","grand_total":"305.24","paid_amount":"305.24","room_type_id":"320","product_id":"1910","siteminder_id":"EXP-1732204888","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":"112367","customer_id":"112367","source_of_creation":"Expedia","reservation_created_date":"2021-01-23 19:56:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"271.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3184773","reservation_id":"106060","confirmation_number":"SJ12657448160","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,299.25","nightly_discount":"0,0,0","subtotal":"897.75","grand_total":"1009.97","paid_amount":"1009.97","room_type_id":"320","product_id":"1324","siteminder_id":"EXP-1732603819","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":"112480","customer_id":"112480","source_of_creation":"Expedia","reservation_created_date":"2021-01-25 15:21:21","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"299.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3191344","reservation_id":"106859","confirmation_number":"SJ12631859348","room_stay_from":"2021-02-20","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.24,215.04,215.04,215.04,215.04","nightly_discount":"0,0,0,0,0","subtotal":"1086.40","grand_total":"1222.20","paid_amount":"1222.20","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1735109301","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":"113289","customer_id":"113289","source_of_creation":"Expedia","reservation_created_date":"2021-02-04 01:35:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.04","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":"3192502","reservation_id":"105584","confirmation_number":"SJ12613428247","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,174.30,174.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1731007797","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":"112005","customer_id":"112005","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 23:16:18","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","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","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":"3192728","reservation_id":"104790","confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"128.44,128.44,128.44,128.44","nightly_discount":"0,0,0,0","subtotal":"513.76","grand_total":"577.98","paid_amount":"577.98","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1727743016","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111137","customer_id":"111137","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 18:01:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"128.44","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":"3203987","reservation_id":"108498","confirmation_number":"SJ12699776249","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.20","nightly_discount":"0","subtotal":"215.20","grand_total":"242.10","paid_amount":"242.10","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1741327390","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":"114942","customer_id":"114942","source_of_creation":"Expedia","reservation_created_date":"2021-02-25 01:38:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"215.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3176699","reservation_id":"104843","confirmation_number":"SJ12684726620","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44,139.44","nightly_discount":"0,0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1727876153","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":"111193","customer_id":"111193","source_of_creation":"Expedia","reservation_created_date":"2021-01-06 03:56:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"139.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","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":"3181206","reservation_id":"105308","confirmation_number":"SJ12644139433","room_stay_from":"2021-02-20","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,156.24,156.24,156.24,156.24,156.24","nightly_discount":"0,0,0,0,0,0","subtotal":"993.44","grand_total":"1117.62","paid_amount":"1117.62","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1729820159","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":"111696","customer_id":"111696","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 03:16:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"156.24","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":"3183966","reservation_id":"106038","confirmation_number":"SJ12656697395","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.24,170.24,170.24,170.24,170.24,170.24,192.64","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1270.08","grand_total":"1428.84","paid_amount":"1428.84","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1732504814","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":"112465","customer_id":"112465","source_of_creation":"Expedia","reservation_created_date":"2021-01-25 02:27:07","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"170.24","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":"3190748","reservation_id":"106769","confirmation_number":"SJ12635013549","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,201.04,201.04,201.04,201.04,201.04,184.24","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1401.68","grand_total":"1576.89","paid_amount":"1576.89","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1734776504","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":"113191","customer_id":"113191","source_of_creation":"Expedia","reservation_created_date":"2021-02-02 21:56:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.04","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":"3200911","reservation_id":"105363","confirmation_number":"SJ12669033208","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44,139.44,161.84","nightly_discount":"0,0,0,0,0,0","subtotal":"859.04","grand_total":"966.42","paid_amount":"966.42","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1730104359","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":"111754","customer_id":"111754","source_of_creation":"Expedia","reservation_created_date":"2021-01-15 04:56:29","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","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":"3201226","reservation_id":"105309","confirmation_number":"SJ12614372867","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30,195.30,223.30,223.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1423.10","grand_total":"1600.99","paid_amount":"1600.99","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1729820610","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":"111697","customer_id":"111697","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 03:16:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.30","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":"3174677","reservation_id":"104119","confirmation_number":"SJ12640591791","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,167.44,167.44,167.44,167.44,184.24,184.24,167.44,171.92,171.92,171.92,171.92,188.72,188.72","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2438.24","grand_total":"2743.02","paid_amount":"2743.02","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1724692080","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":"110451","customer_id":"110451","source_of_creation":"Expedia","reservation_created_date":"2020-12-22 19:01:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"167.44","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":"3203769","reservation_id":"107594","confirmation_number":"SJ12664202117","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"134.40,176.40,176.40","nightly_discount":"0,0,0","subtotal":"487.20","grand_total":"548.10","paid_amount":"0.00","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1738072686","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":"114051","customer_id":"114051","source_of_creation":"Expedia","reservation_created_date":"2021-02-14 16:12:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204014","reservation_id":"107374","confirmation_number":"SJ12621644014","room_stay_from":"2021-02-28","room_stay_to":"2021-03-04","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,145.04,145.04,145.04","nightly_discount":"0,0,0,0","subtotal":"574.56","grand_total":"646.38","paid_amount":"0.00","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1737284729","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":"113830","customer_id":"113830","source_of_creation":"Expedia","reservation_created_date":"2021-02-11 22:07:22","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","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3203981","reservation_id":"108421","confirmation_number":"SJ12681928017","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.46","nightly_discount":"0.00","subtotal":"156.46","grand_total":"176.01","paid_amount":"176.01","room_type_id":"413","product_id":"1265","siteminder_id":"HTN-153286420-T77GD9","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":"114875","customer_id":"114875","source_of_creation":"HotelTonight","reservation_created_date":"2021-02-24 00:34:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"156.46","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3203375","reservation_id":"108400","confirmation_number":"SJ12665755143","room_stay_from":"2021-02-23","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.14,221.14","nightly_discount":"0,0","subtotal":"442.28","grand_total":"497.56","paid_amount":"497.56","room_type_id":"319","product_id":"1277","siteminder_id":"GAM-R2344010330","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":"114851","customer_id":"114851","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-23 19:21:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"221.14","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":"3203565","reservation_id":"108441","confirmation_number":"SJ12684223936","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.97","nightly_discount":"0","subtotal":"234.97","grand_total":"264.34","paid_amount":"264.34","room_type_id":"318","product_id":"1289","siteminder_id":"GAM-R2345308622","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":"114893","customer_id":"114893","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-24 13:21:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"234.97","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":"3184649","reservation_id":"106127","confirmation_number":"SJ12669887556","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.38,153.38","nightly_discount":"0,0","subtotal":"306.76","grand_total":"345.11","paid_amount":"345.11","room_type_id":"413","product_id":"1273","siteminder_id":"GAM-R2297027240","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":"112543","customer_id":"112543","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-26 02:19:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"153.38","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3202551","reservation_id":"105150","confirmation_number":"SJ12687256596","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.48,228.48,228.48,223.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"908.44","grand_total":"1052.76","paid_amount":"1052.76","room_type_id":"413","product_id":"1268","siteminder_id":"ABB-HMQKHR3ACY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"913.92","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111533","customer_id":"111533","source_of_creation":"Airbnb","reservation_created_date":"2021-01-11 03:09:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"26.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"228.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3203311","reservation_id":"105433","confirmation_number":"SJ12664244391","room_stay_from":"2021-02-23","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"366.18,366.18,359.70","nightly_discount":"0.00,0.00,0.00","subtotal":"1092.06","grand_total":"1265.53","paid_amount":"1265.53","room_type_id":"320","product_id":"1320","siteminder_id":"ABB-HMM3SH5JJP","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1098.54","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111839","customer_id":"111839","source_of_creation":"Airbnb","reservation_created_date":"2021-01-16 04:02:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"32.31","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1260,1261","currentDayPrice":"366.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3203733","reservation_id":"106413","confirmation_number":"SJ12622756284","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"274.38,274.38,274.38,267.79","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1090.93","grand_total":"1264.25","paid_amount":"1264.25","room_type_id":"318","product_id":"1281","siteminder_id":"ABB-HMRHFJAB5Q","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1097.52","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112809","customer_id":"112809","source_of_creation":"Airbnb","reservation_created_date":"2021-01-29 14:43:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"32.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"274.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3189282","reservation_id":"106001","confirmation_number":"SJ12656355183","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0,0,0","subtotal":"297.00","grand_total":"334.13","paid_amount":"334.13","room_type_id":"319","product_id":"1312","siteminder_id":"HWR-303121198","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":"112424","customer_id":"112424","source_of_creation":"Hotwire","reservation_created_date":"2021-01-24 19:37:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203453","reservation_id":"108224","confirmation_number":"SJ12697406614","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00","nightly_discount":"0","subtotal":"199.00","grand_total":"223.88","paid_amount":"223.88","room_type_id":"319","product_id":"1293","siteminder_id":"HWR-303248770","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":"114688","customer_id":"114688","source_of_creation":"Hotwire","reservation_created_date":"2021-02-21 23:57:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"199.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201238","reservation_id":"105326","confirmation_number":"SJ12622881704","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0,0","subtotal":"198.00","grand_total":"222.75","paid_amount":"222.75","room_type_id":"319","product_id":"1287","siteminder_id":"HWR-303119362","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":"111714","customer_id":"111714","source_of_creation":"Hotwire","reservation_created_date":"2021-01-14 18:00:07","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","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"99.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3203786","reservation_id":"107656","confirmation_number":"SJ12637248317","room_stay_from":"2021-02-23","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.00,288.00","nightly_discount":"30.00,30.00","subtotal":"576.00","grand_total":"580.50","paid_amount":"580.50","room_type_id":"319","product_id":"1313","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":"114114","customer_id":"114114","source_of_creation":"FE","reservation_created_date":"2021-02-15 05:35:44","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"288.00","currentDayDiscount":"30.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":"3203578","reservation_id":"106800","confirmation_number":"SJ12698761438","room_stay_from":"2021-02-20","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.25,269.25,1323.73","nightly_discount":"0.00,0.00,0.00","subtotal":"1877.23","grand_total":"2111.88","paid_amount":"2111.88","room_type_id":"318","product_id":"1282","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":"113224","customer_id":"113224","source_of_creation":"FE","reservation_created_date":"2021-02-03 03:00:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"785.23","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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3179754","reservation_id":"105032","confirmation_number":"SJ12630447918","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"230.47,230.47,230.47","nightly_discount":"0.00,0.00,0.00","subtotal":"691.41","grand_total":"777.84","paid_amount":"777.84","room_type_id":"319","product_id":"1318","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":"111402","customer_id":"111402","source_of_creation":"PMS","reservation_created_date":"2021-01-08 23:10:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"230.47","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":"3181777","reservation_id":"105481","confirmation_number":"SJ12642034519","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,186.75,186.75,186.75,186.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"933.75","grand_total":"1050.47","paid_amount":"1050.47","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"111896","customer_id":"111896","source_of_creation":"PMS","reservation_created_date":"2021-01-16 23:23:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"186.75","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":"3189104","reservation_id":"105218","confirmation_number":"SJ12663846226","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"139.25,299.25,299.25,299.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1037.00","grand_total":"1166.63","paid_amount":"1166.63","room_type_id":"320","product_id":"1323","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":"111580","customer_id":"111580","source_of_creation":"PMS","reservation_created_date":"2021-01-12 14:49:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1269,1270","currentDayPrice":"299.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199260","reservation_id":"107804","confirmation_number":"SJ12680777526","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15,305.15,305.15,322.15","nightly_discount":"15.25,15.25,15.25,16.10","subtotal":"1237.60","grand_total":"1322.72","paid_amount":"1322.72","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"114260","customer_id":"114260","source_of_creation":"PMS","reservation_created_date":"2021-02-16 16:22:57","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","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"305.15","currentDayDiscount":"15.25","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":"3177487","reservation_id":"104655","confirmation_number":"SJ12645800618","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.65,211.65,245.65,245.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"914.60","grand_total":"1028.93","paid_amount":"1028.93","room_type_id":"413","product_id":"1263","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":"111009","customer_id":"111009","source_of_creation":"PMS","reservation_created_date":"2021-01-03 20:02:48","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"211.65","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":"3190726","reservation_id":"103654","confirmation_number":"SJ12650839404","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.65,211.65,245.65,245.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"914.60","grand_total":"1028.93","paid_amount":"1028.93","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109903","customer_id":"109903","source_of_creation":"PMS","reservation_created_date":"2020-12-09 20:35:37","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"211.65","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":"3189341","reservation_id":"106562","confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101703","customer_id":"101703","source_of_creation":"PMS","reservation_created_date":"2021-01-31 18:54: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","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3200997","reservation_id":"105427","confirmation_number":"SJ12621975795","room_stay_from":"2021-02-19","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.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":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-01-16 02:43:22","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","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"178.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":"3197141","reservation_id":"106999","confirmation_number":"SJ12640521255","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.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":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-05 23:59:52","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","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"178.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":"3175939","reservation_id":"104910","confirmation_number":"SJ12659738538","room_stay_from":"2021-02-23","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"319","product_id":"1274","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":"2021-01-07 00:38:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.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":"3181214","reservation_id":"105605","confirmation_number":"SJ12628104872","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","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":"2021-01-19 02:53:46","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","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3192729","reservation_id":"104790","confirmation_number":"SJ12629250989","room_confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"111137","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-05 23:54:12","reservation_modified_date_time":"2021-02-05 23:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111137","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3179755","reservation_id":"105032","confirmation_number":"SJ12639922507","room_confirmation_number":"SJ12630447918","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"111402","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-08 23:10:10","reservation_modified_date_time":"2021-01-16 15:38:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111402","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3180457","reservation_id":"105515","confirmation_number":"SJ12696203551","room_confirmation_number":"SJ12650920347","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"111930","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 18:41:08","reservation_modified_date_time":"2021-01-17 18:41:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111930","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3181139","reservation_id":"105583","confirmation_number":"SJ12617101576","room_confirmation_number":"SJ12657879374","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"112004","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:11:08","reservation_modified_date_time":"2021-01-18 23:59:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112004","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3184759","reservation_id":"105947","confirmation_number":"SJ12686062880","room_confirmation_number":"SJ12696208084","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"112367","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-23 19:56:11","reservation_modified_date_time":"2021-01-26 14:03:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112367","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3184776","reservation_id":"106060","confirmation_number":"SJ12648516344","room_confirmation_number":"SJ12657448160","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"112480","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 15:21:21","reservation_modified_date_time":"2021-01-26 14:04:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112480","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3189285","reservation_id":"106001","confirmation_number":"SJ12680582912","room_confirmation_number":"SJ12656355183","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"112424","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 19:37:20","reservation_modified_date_time":"2021-02-01 18:21:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112424","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3191345","reservation_id":"106859","confirmation_number":"SJ12615472133","room_confirmation_number":"SJ12631859348","room_stay_from":"2021-02-20","room_stay_to":"2021-02-25","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":"113289","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 01:35:07","reservation_modified_date_time":"2021-02-04 01:35:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3192503","reservation_id":"105584","confirmation_number":"SJ12617347483","room_confirmation_number":"SJ12613428247","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"112005","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:16:18","reservation_modified_date_time":"2021-02-05 21:43:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112005","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3192730","reservation_id":"104790","confirmation_number":"SJ12629944003","room_confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"111137","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 18:01:08","reservation_modified_date_time":"2021-02-05 23:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111137","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","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":"3192732","reservation_id":"105778","confirmation_number":"SJ12629002064","room_confirmation_number":"SJ12643903300","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"112180","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 06:30:13","reservation_modified_date_time":"2021-02-05 23:54:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112180","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3201093","reservation_id":"108050","confirmation_number":"SJ12651596278","room_confirmation_number":"SJ12626593000","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"114517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-19 18:12:36","reservation_modified_date_time":"2021-02-19 20:08:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114517","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3203376","reservation_id":"108400","confirmation_number":"SJ12644094818","room_confirmation_number":"SJ12665755143","room_stay_from":"2021-02-23","room_stay_to":"2021-02-25","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":"114851","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 19:21:07","reservation_modified_date_time":"2021-02-23 19:21:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114851","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3203454","reservation_id":"108224","confirmation_number":"SJ12616374482","room_confirmation_number":"SJ12697406614","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"114688","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 23:57:07","reservation_modified_date_time":"2021-02-23 23:15:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114688","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3203566","reservation_id":"108441","confirmation_number":"SJ12610398924","room_confirmation_number":"SJ12684223936","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"114893","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 13:21:07","reservation_modified_date_time":"2021-02-24 13:21:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114893","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3203787","reservation_id":"107656","confirmation_number":"SJ12632654565","room_confirmation_number":"SJ12637248317","room_stay_from":"2021-02-23","room_stay_to":"2021-02-25","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":"114114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 05:35:44","reservation_modified_date_time":"2021-02-24 18:08:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114114","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"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":"3203982","reservation_id":"108421","confirmation_number":"SJ12617071273","room_confirmation_number":"SJ12681928017","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114875","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 00:34:06","reservation_modified_date_time":"2021-02-25 01:00:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114875","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3203988","reservation_id":"108498","confirmation_number":"SJ12644182944","room_confirmation_number":"SJ12699776249","room_stay_from":"2021-02-24","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"114942","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 01:38:12","reservation_modified_date_time":"2021-02-25 01:38:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114942","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3176701","reservation_id":"104843","confirmation_number":"SJ12693309515","room_confirmation_number":"SJ12684726620","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"111193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 03:56:12","reservation_modified_date_time":"2021-01-09 17:01:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111193","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181207","reservation_id":"105308","confirmation_number":"SJ12681754001","room_confirmation_number":"SJ12644139433","room_stay_from":"2021-02-20","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"111696","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 03:16:11","reservation_modified_date_time":"2021-01-19 02:49:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111696","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3181779","reservation_id":"105481","confirmation_number":"SJ12644308877","room_confirmation_number":"SJ12642034519","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","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":"111896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 23:23:32","reservation_modified_date_time":"2021-01-20 16:02:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111896","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3184650","reservation_id":"106127","confirmation_number":"SJ12664995330","room_confirmation_number":"SJ12669887556","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","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":"112543","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 02:19:07","reservation_modified_date_time":"2021-01-26 02:19:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112543","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3189107","reservation_id":"105218","confirmation_number":"SJ12693939092","room_confirmation_number":"SJ12663846226","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","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":"111580","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-12 14:49:13","reservation_modified_date_time":"2021-02-01 15:13:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111580","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3194886","reservation_id":"104679","confirmation_number":"SJ12624597771","room_confirmation_number":"SJ12636630959","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25,25,25,25","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":"111033","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-04 00:53:08","reservation_modified_date_time":"2021-02-09 18:44:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111033","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199262","reservation_id":"107804","confirmation_number":"SJ12675909966","room_confirmation_number":"SJ12680777526","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","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":"114260","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 16:22:57","reservation_modified_date_time":"2021-02-16 19:53:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114260","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3200998","reservation_id":"105427","confirmation_number":"SJ12660982518","room_confirmation_number":"SJ12621975795","room_stay_from":"2021-02-19","room_stay_to":"2021-02-26","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":"111831","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 02:43:22","reservation_modified_date_time":"2021-02-19 17:05:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"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":"3201239","reservation_id":"105326","confirmation_number":"SJ12692900827","room_confirmation_number":"SJ12622881704","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","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":"111714","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 18:00:07","reservation_modified_date_time":"2021-02-20 00:27:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111714","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3202552","reservation_id":"105150","confirmation_number":"SJ12652347574","room_confirmation_number":"SJ12687256596","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","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":"111533","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 03:09:07","reservation_modified_date_time":"2021-02-22 13:35:14","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111533","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3203314","reservation_id":"105433","confirmation_number":"SJ12684354044","room_confirmation_number":"SJ12664244391","room_stay_from":"2021-02-23","room_stay_to":"2021-02-26","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":"111839","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 04:02:09","reservation_modified_date_time":"2021-02-23 15:42:51","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111839","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3179465","reservation_id":"104587","confirmation_number":"SJ12610374391","room_confirmation_number":"SJ12686301450","room_stay_from":"2021-02-19","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"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","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 18:01:07","reservation_modified_date_time":"2021-01-15 21:59:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3183967","reservation_id":"106038","confirmation_number":"SJ12681308912","room_confirmation_number":"SJ12656697395","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"112465","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 02:27:07","reservation_modified_date_time":"2021-01-25 02:27:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3184972","reservation_id":"106179","confirmation_number":"SJ12692312293","room_confirmation_number":"SJ12615389852","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"112586","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 18:01:08","reservation_modified_date_time":"2021-01-26 18:01:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112586","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3190747","reservation_id":"106769","confirmation_number":"SJ12644796727","room_confirmation_number":"SJ12635013549","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"113191","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:56:31","reservation_modified_date_time":"2021-02-02 22:45:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113191","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3197142","reservation_id":"106999","confirmation_number":"SJ12610375317","room_confirmation_number":"SJ12640521255","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"113438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 23:59:52","reservation_modified_date_time":"2021-02-13 04:17:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"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":"3200912","reservation_id":"105363","confirmation_number":"SJ12689363160","room_confirmation_number":"SJ12669033208","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"111754","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 04:56:29","reservation_modified_date_time":"2021-02-19 14:24:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111754","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3200915","reservation_id":"106188","confirmation_number":"SJ12672572211","room_confirmation_number":"SJ12640825161","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","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":"112595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 19:37:08","reservation_modified_date_time":"2021-02-19 14:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112595","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3175940","reservation_id":"104910","confirmation_number":"SJ12637893694","room_confirmation_number":"SJ12659738538","room_stay_from":"2021-02-23","room_stay_to":"2021-02-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111264","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 00:38:17","reservation_modified_date_time":"2021-01-08 01:52:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3177488","reservation_id":"104655","confirmation_number":"SJ12625670286","room_confirmation_number":"SJ12645800618","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","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":"111009","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-03 20:02:48","reservation_modified_date_time":"2021-01-11 15:49:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111009","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3181215","reservation_id":"105605","confirmation_number":"SJ12644459719","room_confirmation_number":"SJ12628104872","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 02:53:46","reservation_modified_date_time":"2021-01-19 02:53:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3190728","reservation_id":"103654","confirmation_number":"SJ12627689976","room_confirmation_number":"SJ12650839404","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","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":"109903","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-09 20:35:37","reservation_modified_date_time":"2021-02-02 22:45:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109903","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3201230","reservation_id":"105309","confirmation_number":"SJ12665982658","room_confirmation_number":"SJ12614372867","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","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":"111697","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 03:16:15","reservation_modified_date_time":"2021-02-20 00:23:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111697","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3203734","reservation_id":"106413","confirmation_number":"SJ12611889072","room_confirmation_number":"SJ12622756284","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","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":"112809","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:43:05","reservation_modified_date_time":"2021-02-24 16:47:49","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112809","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3174680","reservation_id":"104119","confirmation_number":"SJ12691944516","room_confirmation_number":"SJ12640591791","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","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,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,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"110451","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 19:01:07","reservation_modified_date_time":"2021-01-05 20:56:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110451","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3189342","reservation_id":"106562","confirmation_number":"SJ12674501286","room_confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"101703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:54:06","reservation_modified_date_time":"2021-02-01 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101703","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"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":"3203579","reservation_id":"106800","confirmation_number":"SJ12617782738","room_confirmation_number":"SJ12698761438","room_stay_from":"2021-02-20","room_stay_to":"2021-02-23","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":"113224","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 03:00:11","reservation_modified_date_time":"2021-02-24 14:17:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113224","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"-25.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203654","reservation_id":"106362","confirmation_number":"SJ12667638930","room_confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112757","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 23:36:12","reservation_modified_date_time":"2021-02-24 15:20:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112757","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203768","reservation_id":"107594","confirmation_number":"SJ12680734960","room_confirmation_number":"SJ12664202117","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114051","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 16:12:22","reservation_modified_date_time":"2021-02-24 18:02:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114051","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204015","reservation_id":"107374","confirmation_number":"SJ12646257823","room_confirmation_number":"SJ12621644014","room_stay_from":"2021-02-28","room_stay_to":"2021-03-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113830","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 22:07:22","reservation_modified_date_time":"2021-02-25 01:58:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113830","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203077","reservation_id":"108313","confirmation_number":"SJ12622690370","room_confirmation_number":"SJ12680972985","room_stay_from":"2021-02-23","room_stay_to":"2021-02-25","room_stay_status":"Canceled","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-22 22:14:13","reservation_modified_date_time":"2021-02-22 23:06:57","customer_id":"114769","parentCustTravId":"114769","customer_traveller_id":"114769","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-02-24 15:24:00","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2021-02-23","sub_hotel_id":"126","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3203577","reservation_id":"106800","confirmation_number":"SJ12660883040","room_confirmation_number":"SJ12698761438","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"112.52","paid_amount":"112.52","product_id":"1869","service_quantity":"4","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-24 14:17:32","reservation_modified_date_time":"2021-02-24 14:17:32","customer_id":"113224","parentCustTravId":"113224","customer_traveller_id":"113224","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-02-20","sub_hotel_id":"0","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203568","reservation_id":"108442","confirmation_number":"SJ12680923727","room_confirmation_number":"SJ12658914083","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-24 13:34:25","reservation_modified_date_time":"2021-02-24 13:34:25","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3203824","reservation_id":"108471","confirmation_number":"SJ12637844161","room_confirmation_number":"SJ12685121448","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":"1660","service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-24 19:31:30","reservation_modified_date_time":"2021-02-24 19:31:30","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"2.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3204076","reservation_id":"108504","confirmation_number":"SJ12644427611","room_confirmation_number":"SJ12665253318","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":"1660","service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-25 02:26:09","reservation_modified_date_time":"2021-02-25 02:26:09","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"2.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}