{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-01-29","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":9,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1266,1943,1942,1866","block_room_bookings":[{"confirmation_number":"SJ12675626829","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","bundle_room":"0","product_id":"1266"},{"confirmation_number":"SJ12619647475","room_stay_from":"2021-01-29","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1943"},{"confirmation_number":"SJ12639783523","room_stay_from":"2021-01-29","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1942"},{"confirmation_number":"SJ12676856509","room_stay_from":"2021-01-27","room_stay_to":"2021-02-20","bundle_room":"0","product_id":"1866"}],"bundle_block_count":"1269,1270,1262,1263,1304,1305,1311,1312,1309,1310,1302,1303,1267,1268,1260,1261,1271,1272,1307,1308,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12610296440","room_stay_from":"2021-01-25","room_stay_to":"2021-01-30","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12633503710","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12659444685","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12642270551","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12652063001","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12686198911","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12650937037","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12694637269","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12667940903","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12671700851","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12635251733","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12686204044","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12633555495","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12670937179","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12665854964","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12627921756","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12630206913","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12669290977","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","bundle_room":"0","product_id":"1711"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3187486","reservation_id":"106449","confirmation_number":"SJ12622204518","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.67","nightly_discount":"0","subtotal":"157.67","grand_total":"177.38","paid_amount":"177.38","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2724990210","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":"112855","customer_id":"112855","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 23:02:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"32.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"157.67","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":"3187149","reservation_id":"105767","confirmation_number":"SJ12617841072","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.08,172.08","nightly_discount":"0,0","subtotal":"344.16","grand_total":"387.18","paid_amount":"387.18","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-3423015825","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":"112166","customer_id":"112166","source_of_creation":"Booking.com","reservation_created_date":"2021-01-21 01:13:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"70.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"172.08","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":"3187543","reservation_id":"106454","confirmation_number":"SJ12661583013","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.83,167.83","nightly_discount":"0,0","subtotal":"335.66","grand_total":"377.61","paid_amount":"377.61","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3542310881","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":"112862","customer_id":"112862","source_of_creation":"Booking.com","reservation_created_date":"2021-01-30 00:16:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"69.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"167.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3173659","reservation_id":"104668","confirmation_number":"SJ12645433113","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"226.17,251.37,251.37,226.17","nightly_discount":"0,0,0,0","subtotal":"955.08","grand_total":"1074.46","paid_amount":"1074.46","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-2126735624","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":"111021","customer_id":"111021","source_of_creation":"Booking.com","reservation_created_date":"2021-01-03 22:21:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"189.91","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"251.37","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":"3181540","reservation_id":"104135","confirmation_number":"SJ12618726434","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.08,168.08,141.08","nightly_discount":"0,0,0","subtotal":"477.24","grand_total":"536.89","paid_amount":"536.89","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3715422262","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":"110469","customer_id":"110469","source_of_creation":"Booking.com","reservation_created_date":"2020-12-23 04:07:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"99.40","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"168.08","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":"3183593","reservation_id":"105419","confirmation_number":"SJ12637544509","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.33,161.33,120.83","nightly_discount":"0,0,0","subtotal":"443.49","grand_total":"498.92","paid_amount":"498.92","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-3075123232","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":"111821","customer_id":"111821","source_of_creation":"Booking.com","reservation_created_date":"2021-01-16 01:25:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"93.33","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"161.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":"3186900","reservation_id":"106400","confirmation_number":"SJ12670142022","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.19,145.19,108.75","nightly_discount":"0,0,0","subtotal":"399.13","grand_total":"449.02","paid_amount":"449.02","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3542347369","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":"112797","customer_id":"112797","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 08:46:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"145.19","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":"3183468","reservation_id":"105315","confirmation_number":"SJ12659686367","room_stay_from":"2021-01-23","room_stay_to":"2021-02-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.86,129.84,129.84,129.84,129.84,129.84,163.86,163.86,129.84,158.19,158.19,158.19,158.19,180.87","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2084.25","grand_total":"2344.78","paid_amount":"2344.78","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2111298720","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":"111703","customer_id":"111703","source_of_creation":"Booking.com","reservation_created_date":"2021-01-14 05:12:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","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":"163.86","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":"3180930","reservation_id":"105186","confirmation_number":"SJ12611283912","room_stay_from":"2021-01-17","room_stay_to":"2021-02-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"101.49,101.49,101.49,101.49,101.49,146.85,146.85,101.49,101.49,101.49,101.49,101.49,146.85,146.85,101.49,141.18,141.18,141.18,141.18,163.86,163.86","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2596.23","grand_total":"2920.76","paid_amount":"2920.76","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2941467212","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":"111980","customer_id":"111980","source_of_creation":"Booking.com","reservation_created_date":"2021-01-11 19:43:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"561.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"146.85","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":"3187144","reservation_id":"106235","confirmation_number":"SJ12649518668","room_stay_from":"2021-03-28","room_stay_to":"2021-03-31","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"211.95,211.95,211.95","nightly_discount":"0,0,0","subtotal":"635.85","grand_total":"715.33","paid_amount":"247.28","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2862944932","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":"112643","customer_id":"112643","source_of_creation":"Booking.com","reservation_created_date":"2021-01-27 04:37:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"127.95","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3183108","reservation_id":"105919","confirmation_number":"SJ12656747722","room_stay_from":"2021-01-27","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.25,134.25,179.25","nightly_discount":"0,0,0","subtotal":"447.75","grand_total":"503.72","paid_amount":"503.72","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1732109473","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":"112336","customer_id":"112336","source_of_creation":"Expedia","reservation_created_date":"2021-01-23 07:16:12","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","group_rooms":null,"currentDayPrice":"179.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":"3184701","reservation_id":"106097","confirmation_number":"SJ12638531304","room_stay_from":"2021-01-26","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.04,131.04,131.04,164.64","nightly_discount":"0,0,0,0","subtotal":"557.76","grand_total":"627.48","paid_amount":"627.48","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1732682528","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":"112518","customer_id":"112518","source_of_creation":"Expedia","reservation_created_date":"2021-01-25 20:46:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","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":"164.64","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":"3186167","reservation_id":"106243","confirmation_number":"SJ12673072513","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"162.52","nightly_discount":"0","subtotal":"162.52","grand_total":"182.84","paid_amount":"182.84","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1733133444","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":"112653","customer_id":"112653","source_of_creation":"Expedia","reservation_created_date":"2021-01-27 15:26:11","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":"126","group_rooms":null,"currentDayPrice":"162.52","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":"3183652","reservation_id":"105994","confirmation_number":"SJ12669975325","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.20,191.20","nightly_discount":"0,0","subtotal":"382.40","grand_total":"430.20","paid_amount":"430.20","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1732394350","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":"112417","customer_id":"112417","source_of_creation":"Expedia","reservation_created_date":"2021-01-24 17:56:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"191.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":"3186620","reservation_id":"106359","confirmation_number":"SJ12662195303","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"152.96,152.96","nightly_discount":"0,0","subtotal":"305.92","grand_total":"344.16","paid_amount":"344.16","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1733506039","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":"112754","customer_id":"112754","source_of_creation":"Expedia","reservation_created_date":"2021-01-28 23:06:11","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":"152.96","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":"3187037","reservation_id":"106404","confirmation_number":"SJ12619751421","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"3","nightly_price":"280.96,280.96","nightly_discount":"0,0","subtotal":"561.92","grand_total":"632.16","paid_amount":"632.16","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1733650075","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":"112801","customer_id":"112801","source_of_creation":"Expedia","reservation_created_date":"2021-01-29 14:01:31","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","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","currentDayPrice":"280.96","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":"3187045","reservation_id":"106403","confirmation_number":"SJ12678581891","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"280.96,280.96","nightly_discount":"0,0","subtotal":"561.92","grand_total":"632.16","paid_amount":"632.16","room_type_id":"320","product_id":"1910","siteminder_id":"EXP-1733650074","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":"112800","customer_id":"112800","source_of_creation":"Expedia","reservation_created_date":"2021-01-29 14:01:13","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","currentDayPrice":"280.96","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":"3187515","reservation_id":"105992","confirmation_number":"SJ12679773256","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"152.96,152.96","nightly_discount":"0.00,0.00","subtotal":"305.92","grand_total":"344.16","paid_amount":"344.16","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1732388778","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":"112415","customer_id":"112415","source_of_creation":"Expedia","reservation_created_date":"2021-01-24 17:31:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","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":"152.96","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":"3187435","reservation_id":"106372","confirmation_number":"SJ12686082311","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,216.75,216.75,211.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"831.50","grand_total":"935.44","paid_amount":"210.10","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1733526574","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":"112848","customer_id":"112769","source_of_creation":"Expedia","reservation_created_date":"2021-01-29 00:31:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","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":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3187566","reservation_id":"105497","confirmation_number":"SJ12624670176","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.02,138.02,103.37","nightly_discount":"0,0,0","subtotal":"379.41","grand_total":"426.84","paid_amount":"426.84","room_type_id":"413","product_id":"1264","siteminder_id":"GAM-R2285561416","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":"111912","customer_id":"111912","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-17 07:48:18","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":"126","currentDayPrice":"138.02","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":"3184094","reservation_id":"104556","confirmation_number":"SJ12649447319","room_stay_from":"2021-01-25","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.10,199.10,199.10,199.10,193.13","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"989.53","grand_total":"1146.73","paid_amount":"1146.73","room_type_id":"413","product_id":"1270","siteminder_id":"ABB-HMS3KE5KFB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"995.50","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110908","customer_id":"110908","source_of_creation":"Airbnb","reservation_created_date":"2021-01-02 02:02:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"29.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"193.13","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":"3187012","reservation_id":"105494","confirmation_number":"SJ12673605206","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"2","nightly_price":"405.94","nightly_discount":"0.00","subtotal":"405.94","grand_total":"474.25","paid_amount":"474.25","room_type_id":"320","product_id":"1328","siteminder_id":"ABB-HMBYAXYJBM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"408.50","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111909","customer_id":"111909","source_of_creation":"Airbnb","reservation_created_date":"2021-01-17 05:10:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"12.75","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"405.94","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":"3187059","reservation_id":"106204","confirmation_number":"SJ12692199972","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"244.20","nightly_discount":"0.00","subtotal":"244.20","grand_total":"284.88","paid_amount":"284.88","room_type_id":"319","product_id":"1318","siteminder_id":"ABB-HM2QFP49QY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"257.05","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112613","customer_id":"112613","source_of_creation":"Airbnb","reservation_created_date":"2021-01-26 23:30:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"7.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"244.20","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":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3186198","reservation_id":"105964","confirmation_number":"SJ12665391664","room_stay_from":"2021-01-28","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.38,200.94,200.94","nightly_discount":"0.00,0.00,0.00","subtotal":"599.26","grand_total":"694.46","paid_amount":"694.46","room_type_id":"413","product_id":"1269","siteminder_id":"ABB-HMBH44ETXD","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"602.82","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112391","customer_id":"112391","source_of_creation":"Airbnb","reservation_created_date":"2021-01-24 01:47:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"17.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"200.94","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":"3187421","reservation_id":"106445","confirmation_number":"SJ12616312398","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.84,243.90","nightly_discount":"0.00,0.00","subtotal":"490.74","grand_total":"568.70","paid_amount":"568.70","room_type_id":"319","product_id":"1306","siteminder_id":"ABB-HMMQD4F95R","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"493.68","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112844","customer_id":"112844","source_of_creation":"Airbnb","reservation_created_date":"2021-01-29 21:06:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"14.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"246.84","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":"3186215","reservation_id":"105774","confirmation_number":"SJ12639200483","room_stay_from":"2021-01-28","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.57,195.43,195.43,195.43,195.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"971.29","grand_total":"1125.60","paid_amount":"1125.60","room_type_id":"413","product_id":"1273","siteminder_id":"ABB-HMAE4N5YW2","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"977.15","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112176","customer_id":"112176","source_of_creation":"Airbnb","reservation_created_date":"2021-01-21 03:44:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"28.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.43","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":"3187367","reservation_id":"106144","confirmation_number":"SJ12691502482","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00","nightly_discount":"0","subtotal":"119.00","grand_total":"133.88","paid_amount":"133.88","room_type_id":"319","product_id":"1275","siteminder_id":"HWR-303122292","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":"112556","customer_id":"112556","source_of_creation":"Hotwire","reservation_created_date":"2021-01-26 04:08:11","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":"126","currentDayPrice":"119.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":"3184724","reservation_id":"106114","confirmation_number":"SJ12648527422","room_stay_from":"2021-01-28","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,119.00,119.00","nightly_discount":"0,0,0","subtotal":"337.00","grand_total":"379.13","paid_amount":"379.13","room_type_id":"319","product_id":"1277","siteminder_id":"HWR-303158459","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":"112531","customer_id":"112531","source_of_creation":"Hotwire","reservation_created_date":"2021-01-25 23:45:18","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":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"119.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":"3186223","reservation_id":"106078","confirmation_number":"SJ12661757700","room_stay_from":"2021-01-26","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.25,134.25,134.25,203.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"605.75","grand_total":"681.47","paid_amount":"681.47","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":"112498","customer_id":"112498","source_of_creation":"FE","reservation_created_date":"2021-01-25 17:30:36","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":"203.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":"3186171","reservation_id":"103441","confirmation_number":"SJ12696304737","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.65,228.65","nightly_discount":"0.00,0.00","subtotal":"457.30","grand_total":"514.47","paid_amount":"514.47","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109637","customer_id":"109637","source_of_creation":"FE","reservation_created_date":"2020-12-03 18:53:56","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":"0","group_rooms":null,"currentDayPrice":"228.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":"3187501","reservation_id":"105966","confirmation_number":"SJ12646151427","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"330.65,330.65","nightly_discount":"0.00,0.00","subtotal":"661.30","grand_total":"743.97","paid_amount":"743.97","room_type_id":"320","product_id":"1320","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":"112393","customer_id":"112393","source_of_creation":"FE","reservation_created_date":"2021-01-24 02:24:15","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","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","currentDayPrice":"330.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":"3177360","reservation_id":"105143","confirmation_number":"SJ12696016197","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"171.75,216.75,216.75,171.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"777.00","grand_total":"874.13","paid_amount":"874.13","room_type_id":"319","product_id":"1286","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":"111524","customer_id":"111524","source_of_creation":"FE","reservation_created_date":"2021-01-10 23:26:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"216.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":"3182820","reservation_id":"105141","confirmation_number":"SJ12658862308","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"171.75,216.75,216.75,171.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"777.00","grand_total":"874.13","paid_amount":"874.13","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111521","customer_id":"111521","source_of_creation":"FE","reservation_created_date":"2021-01-10 22:50:09","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":"0","group_rooms":null,"currentDayPrice":"216.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3187017","reservation_id":"106257","confirmation_number":"SJ12647761850","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"330.65","nightly_discount":"0.00","subtotal":"330.65","grand_total":"371.98","paid_amount":"371.98","room_type_id":"320","product_id":"1322","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":"112667","customer_id":"112667","source_of_creation":"PMS","reservation_created_date":"2021-01-27 18:27:15","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","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","currentDayPrice":"330.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":"3183952","reservation_id":"105535","confirmation_number":"SJ12675185206","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"291.75,291.75,246.75,246.75","nightly_discount":"14.59,14.59,12.34,12.34","subtotal":"1077.00","grand_total":"1151.04","paid_amount":"1151.04","room_type_id":"320","product_id":"1714","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":"111951","customer_id":"111951","source_of_creation":"PMS","reservation_created_date":"2021-01-18 00:03:39","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":"AAA","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"291.75","currentDayDiscount":"14.59","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":"3184911","reservation_id":"106167","confirmation_number":"SJ12681963616","room_stay_from":"2021-01-28","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.65,228.65,228.65,177.65,220.15","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1032.75","grand_total":"1161.85","paid_amount":"1161.85","room_type_id":"319","product_id":"1319","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":"112575","customer_id":"112575","source_of_creation":"PMS","reservation_created_date":"2021-01-26 16:25:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"228.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":"3186449","reservation_id":"106340","confirmation_number":"SJ12612921347","room_stay_from":"2021-01-29","room_stay_to":"2021-02-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.00,157.00,157.00,157.00,157.00,157.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"942.00","grand_total":"1059.75","paid_amount":"1059.75","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110829","customer_id":"110829","source_of_creation":"PMS","reservation_created_date":"2021-01-28 18:39:59","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":"0","group_rooms":null,"currentDayPrice":"157.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3163252","reservation_id":"102277","confirmation_number":"SJ12651178974","room_stay_from":"2021-01-24","room_stay_to":"2021-01-31","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":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-11-04 02:05:35","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":null,"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":"3183971","reservation_id":"99179","confirmation_number":"SJ12698263511","room_stay_from":"2021-01-27","room_stay_to":"2021-02-01","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":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-17 19:30:23","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":"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":"3181195","reservation_id":"105599","confirmation_number":"SJ12614459366","room_stay_from":"2021-01-29","room_stay_to":"2021-02-05","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:32:42","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":"3187015","reservation_id":"105494","confirmation_number":"SJ12677260662","room_confirmation_number":"SJ12673605206","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.15","paid_amount":"25.15","product_id":"1777","service_quantity":"1","customer_traveller_id":"111909","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-01-29 14:33:18","reservation_modified_date_time":"2021-01-29 14:33:18","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111909","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","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":"3187517","reservation_id":"105992","confirmation_number":"SJ12613081320","room_confirmation_number":"SJ12679773256","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"112415","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-01-30 00:47:06","reservation_modified_date_time":"2021-01-30 00:47:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112415","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3183109","reservation_id":"105919","confirmation_number":"SJ12695773841","room_confirmation_number":"SJ12656747722","room_stay_from":"2021-01-27","room_stay_to":"2021-01-30","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":"112336","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-23 07:16:12","reservation_modified_date_time":"2021-01-23 07:16:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112336","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":"3184096","reservation_id":"104556","confirmation_number":"SJ12670447026","room_confirmation_number":"SJ12649447319","room_stay_from":"2021-01-25","room_stay_to":"2021-01-30","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110908","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 02:02:12","reservation_modified_date_time":"2021-01-25 14:43:38","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110908","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":"3184702","reservation_id":"106097","confirmation_number":"SJ12674510389","room_confirmation_number":"SJ12638531304","room_stay_from":"2021-01-26","room_stay_to":"2021-01-30","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":"112518","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 20:46:11","reservation_modified_date_time":"2021-01-26 12:47:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112518","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":"3186168","reservation_id":"106243","confirmation_number":"SJ12691655335","room_confirmation_number":"SJ12673072513","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","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":"112653","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 15:26:11","reservation_modified_date_time":"2021-01-28 11:56:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112653","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":"3186225","reservation_id":"106078","confirmation_number":"SJ12667508021","room_confirmation_number":"SJ12661757700","room_stay_from":"2021-01-26","room_stay_to":"2021-01-30","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":"112498","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 17:30:36","reservation_modified_date_time":"2021-01-28 14:23:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112498","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":"3187016","reservation_id":"105494","confirmation_number":"SJ12650129431","room_confirmation_number":"SJ12673605206","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","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":"111909","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 05:10:11","reservation_modified_date_time":"2021-01-29 14:33:18","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111909","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3187020","reservation_id":"106257","confirmation_number":"SJ12649752805","room_confirmation_number":"SJ12647761850","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","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":"112667","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 18:27:15","reservation_modified_date_time":"2021-01-29 14:35:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112667","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":"3187060","reservation_id":"106204","confirmation_number":"SJ12658857063","room_confirmation_number":"SJ12692199972","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","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":"112613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 23:30:07","reservation_modified_date_time":"2021-01-29 14:47:12","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112613","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":"3187368","reservation_id":"106144","confirmation_number":"SJ12675735335","room_confirmation_number":"SJ12691502482","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","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":"112556","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 04:08:11","reservation_modified_date_time":"2021-01-29 20:43:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112556","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":"3187487","reservation_id":"106449","confirmation_number":"SJ12623910081","room_confirmation_number":"SJ12622204518","room_stay_from":"2021-01-29","room_stay_to":"2021-01-30","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":"112855","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 23:02:07","reservation_modified_date_time":"2021-01-30 00:17:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112855","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":"3163253","reservation_id":"102277","confirmation_number":"SJ12622032835","room_confirmation_number":"SJ12651178974","room_stay_from":"2021-01-24","room_stay_to":"2021-01-31","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":"108441","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-04 02:05:35","reservation_modified_date_time":"2020-12-08 21:48:03","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":"3183653","reservation_id":"105994","confirmation_number":"SJ12659680241","room_confirmation_number":"SJ12669975325","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"112417","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 17:56:07","reservation_modified_date_time":"2021-01-24 17:56:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112417","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":"3184723","reservation_id":"106114","confirmation_number":"SJ12681254363","room_confirmation_number":"SJ12648527422","room_stay_from":"2021-01-28","room_stay_to":"2021-01-31","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":"112531","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 23:45:18","reservation_modified_date_time":"2021-01-26 13:32:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112531","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":"3186172","reservation_id":"103441","confirmation_number":"SJ12631482532","room_confirmation_number":"SJ12696304737","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"109637","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-03 18:53:56","reservation_modified_date_time":"2021-01-28 11:56:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109637","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":"3186200","reservation_id":"105964","confirmation_number":"SJ12642296040","room_confirmation_number":"SJ12665391664","room_stay_from":"2021-01-28","room_stay_to":"2021-01-31","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":"112391","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 01:47:09","reservation_modified_date_time":"2021-01-28 14:09:56","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112391","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":"3186619","reservation_id":"106359","confirmation_number":"SJ12623299451","room_confirmation_number":"SJ12662195303","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"112754","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 23:06:11","reservation_modified_date_time":"2021-01-28 23:45:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112754","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":"3187036","reservation_id":"106404","confirmation_number":"SJ12648745104","room_confirmation_number":"SJ12619751421","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"112801","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:01:31","reservation_modified_date_time":"2021-01-29 14:32:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112801","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":"3187044","reservation_id":"106403","confirmation_number":"SJ12639485725","room_confirmation_number":"SJ12678581891","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"112800","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:01:13","reservation_modified_date_time":"2021-01-29 14:32:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112800","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":"3187148","reservation_id":"105767","confirmation_number":"SJ12673921327","room_confirmation_number":"SJ12617841072","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"112166","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 01:13:10","reservation_modified_date_time":"2021-01-29 17:01:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112166","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":"3187422","reservation_id":"106445","confirmation_number":"SJ12665338120","room_confirmation_number":"SJ12616312398","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"112844","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 21:06:10","reservation_modified_date_time":"2021-01-29 21:22:36","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112844","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":"3187504","reservation_id":"105966","confirmation_number":"SJ12616276166","room_confirmation_number":"SJ12646151427","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"112393","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 02:24:15","reservation_modified_date_time":"2021-01-30 00:31:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112393","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":"3187518","reservation_id":"105992","confirmation_number":"SJ12673675894","room_confirmation_number":"SJ12679773256","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","room_stay_status":"Active","nightly_price":"25,25","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":"112415","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 17:31:07","reservation_modified_date_time":"2021-01-30 00:47:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112415","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":"3187544","reservation_id":"106454","confirmation_number":"SJ12665023636","room_confirmation_number":"SJ12661583013","room_stay_from":"2021-01-29","room_stay_to":"2021-01-31","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":"112862","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 00:16:11","reservation_modified_date_time":"2021-01-30 01:24:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112862","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":"3173660","reservation_id":"104668","confirmation_number":"SJ12629488256","room_confirmation_number":"SJ12645433113","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","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":"111021","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-03 22:21:11","reservation_modified_date_time":"2021-01-03 22:21:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111021","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":"3177361","reservation_id":"105143","confirmation_number":"SJ12691932828","room_confirmation_number":"SJ12696016197","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","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":"111524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-10 23:26:10","reservation_modified_date_time":"2021-01-10 23:26:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111524","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":"3181541","reservation_id":"104135","confirmation_number":"SJ12670761191","room_confirmation_number":"SJ12618726434","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","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":"110469","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-23 04:07:09","reservation_modified_date_time":"2021-01-19 22:16:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110469","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":"3182821","reservation_id":"105141","confirmation_number":"SJ12659296282","room_confirmation_number":"SJ12658862308","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","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":"111521","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-10 22:50:09","reservation_modified_date_time":"2021-01-22 20:09:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111521","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":"3183594","reservation_id":"105419","confirmation_number":"SJ12629985078","room_confirmation_number":"SJ12637544509","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","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":"111821","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 01:25:10","reservation_modified_date_time":"2021-01-24 16:41:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111821","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":"3183951","reservation_id":"105535","confirmation_number":"SJ12695398128","room_confirmation_number":"SJ12675185206","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","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":"111951","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 00:03:39","reservation_modified_date_time":"2021-01-25 00:46:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111951","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":"3183972","reservation_id":"99179","confirmation_number":"SJ12614865477","room_confirmation_number":"SJ12698263511","room_stay_from":"2021-01-27","room_stay_to":"2021-02-01","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":"105158","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 19:30:23","reservation_modified_date_time":"2021-01-25 02:46:49","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":"3186899","reservation_id":"106400","confirmation_number":"SJ12638040227","room_confirmation_number":"SJ12670142022","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","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":"112797","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 08:46:14","reservation_modified_date_time":"2021-01-29 13:06:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112797","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":"3187567","reservation_id":"105497","confirmation_number":"SJ12685957941","room_confirmation_number":"SJ12624670176","room_stay_from":"2021-01-29","room_stay_to":"2021-02-01","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":"111912","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 07:48:18","reservation_modified_date_time":"2021-01-30 01:48:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111912","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":"3184912","reservation_id":"106167","confirmation_number":"SJ12676813202","room_confirmation_number":"SJ12681963616","room_stay_from":"2021-01-28","room_stay_to":"2021-02-02","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":"112575","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 16:25:20","reservation_modified_date_time":"2021-01-26 16:25:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112575","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":"3186216","reservation_id":"105774","confirmation_number":"SJ12648813031","room_confirmation_number":"SJ12639200483","room_stay_from":"2021-01-28","room_stay_to":"2021-02-02","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112176","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 03:44:11","reservation_modified_date_time":"2021-01-28 14:12:03","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112176","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":"3186450","reservation_id":"106340","confirmation_number":"SJ12680333916","room_confirmation_number":"SJ12612921347","room_stay_from":"2021-01-29","room_stay_to":"2021-02-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"25.00,25.00,25.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"110829","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 18:39:59","reservation_modified_date_time":"2021-01-28 18:39:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110829","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"25.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":"3181196","reservation_id":"105599","confirmation_number":"SJ12680900258","room_confirmation_number":"SJ12614459366","room_stay_from":"2021-01-29","room_stay_to":"2021-02-05","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":"112020","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 02:32:42","reservation_modified_date_time":"2021-01-19 02:32:42","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":"3183469","reservation_id":"105315","confirmation_number":"SJ12676831990","room_confirmation_number":"SJ12659686367","room_stay_from":"2021-01-23","room_stay_to":"2021-02-06","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":"111703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 05:12:22","reservation_modified_date_time":"2021-01-24 01:25:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111703","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":"3180931","reservation_id":"105186","confirmation_number":"SJ12691123842","room_confirmation_number":"SJ12611283912","room_stay_from":"2021-01-17","room_stay_to":"2021-02-07","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25","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","subtotal":"525.00","grand_total":"590.63","paid_amount":"590.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"111980","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 19:43:02","reservation_modified_date_time":"2021-01-18 16:40:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111980","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":"3187145","reservation_id":"106235","confirmation_number":"SJ12697823572","room_confirmation_number":"SJ12649518668","room_stay_from":"2021-03-28","room_stay_to":"2021-03-31","room_stay_status":"Active","nightly_price":"25,25,25","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":"112643","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 04:37:10","reservation_modified_date_time":"2021-01-29 16:59:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112643","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":"3187436","reservation_id":"106372","confirmation_number":"SJ12629074452","room_confirmation_number":"SJ12686082311","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","room_stay_status":"Active","nightly_price":"25,25,25,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":"112848","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 00:31:12","reservation_modified_date_time":"2021-01-29 22:24:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112769","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3187539","reservation_id":"106456","confirmation_number":"SJ12624882692","room_confirmation_number":"SJ12624751894","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.99","grand_total":"9.30","paid_amount":"9.30","product_id":"1904","service_quantity":"2","product_name":"Key Lime Soap","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-30 01:19:23","reservation_modified_date_time":"2021-01-30 01:19:23","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":"1.32","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"9.98","currentDayDiscount":"1.32","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3187540","reservation_id":"106456","confirmation_number":"SJ12653895526","room_confirmation_number":"SJ12624751894","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"26.05","paid_amount":"26.05","product_id":"1659","service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-30 01:19:23","reservation_modified_date_time":"2021-01-30 01:19:23","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":"3.68","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"27.91","currentDayDiscount":"3.68","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":[]}}