{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-27","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":16,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1318,1282,1289,1287,1314,1319,1273,1270,1268","block_room_bookings":[{"confirmation_number":"SJ12657772694","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1318"},{"confirmation_number":"SJ12630389083","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1282"},{"confirmation_number":"SJ12637698736","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12666663420","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1287"},{"confirmation_number":"SJ12679116410","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1314"},{"confirmation_number":"SJ12666008395","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1319"},{"confirmation_number":"SJ12661860635","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1273"},{"confirmation_number":"SJ12645350414","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJ12698723704","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1268"}],"bundle_block_count":"1260,1261,1271,1272,1307,1308,1304,1305,1309,1310,1267,1268,1302,1303,1269,1270,1311,1312,1291,1711,1262,1263","bundle_block_bookings":[{"confirmation_number":"SJB12635983904","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12629102554","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12659006669","room_stay_from":"2021-04-26","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12699732504","room_stay_from":"2021-04-26","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12678118969","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12653142466","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12680442640","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12637624506","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12632531273","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12622815533","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12629218277","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12638971007","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12621303825","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12641851691","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12645352720","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","bundle_room":"1","product_id":"1321"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3208707","reservation_id":"109305","confirmation_number":"SJ12623826679","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.15","nightly_discount":"0","subtotal":"220.15","grand_total":"247.67","paid_amount":"247.67","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-2408432532","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":"115773","customer_id":"115773","source_of_creation":"Booking.com","reservation_created_date":"2021-03-04 08:45:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"44.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"220.15","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211731","reservation_id":"109741","confirmation_number":"SJ12618000220","room_stay_from":"2021-04-26","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"303.20,303.20","nightly_discount":"0,0","subtotal":"606.40","grand_total":"682.20","paid_amount":"682.20","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-3476339658","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":"116231","customer_id":"116231","source_of_creation":"Booking.com","reservation_created_date":"2021-03-08 02:10:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"118.15","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"303.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":"3242392","reservation_id":"113545","confirmation_number":"SJ12651407069","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.74","nightly_discount":"0","subtotal":"228.74","grand_total":"257.34","paid_amount":"257.34","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-2372994455","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":"120142","customer_id":"120142","source_of_creation":"Booking.com","reservation_created_date":"2021-04-21 17:30:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"45.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"228.74","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":"3242394","reservation_id":"113857","confirmation_number":"SJ12621124138","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.15","nightly_discount":"0","subtotal":"237.15","grand_total":"266.80","paid_amount":"266.80","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3562661254","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":"120480","customer_id":"120480","source_of_creation":"Booking.com","reservation_created_date":"2021-04-25 17:11:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"47.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"237.15","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186984","reservation_id":"106408","confirmation_number":"SJ12622282653","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.30,160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"829.50","grand_total":"933.19","paid_amount":"933.19","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3167840611","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":"112805","customer_id":"112805","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 14:25:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"171.81","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203653","reservation_id":"106362","confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,188.37,188.37,163.17,163.17,163.17","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1192.59","grand_total":"1341.66","paid_amount":"1341.66","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2673763646","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112757","customer_id":"112757","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 23:36:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"246.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.17","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":"3229813","reservation_id":"109832","confirmation_number":"SJ12639370317","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.85,146.85,146.85,146.85,146.85","nightly_discount":"0,0,0,0,0","subtotal":"734.25","grand_total":"826.03","paid_amount":"826.03","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-3548480543","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":"116323","customer_id":"116323","source_of_creation":"Booking.com","reservation_created_date":"2021-03-09 04:45:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"154.66","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":"3239140","reservation_id":"113558","confirmation_number":"SJ12693394160","room_stay_from":"2021-04-26","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75","nightly_discount":"0,0,0,0","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3583016466","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":"120159","customer_id":"120159","source_of_creation":"Booking.com","reservation_created_date":"2021-04-21 19:27:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"195.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","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":"3241860","reservation_id":"111648","confirmation_number":"SJ12673975702","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,209.30,209.30,209.30","nightly_discount":"0,0,0,0,0","subtotal":"1046.50","grand_total":"1177.32","paid_amount":"1177.32","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-2349742095","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":"118206","customer_id":"118206","source_of_creation":"Booking.com","reservation_created_date":"2021-03-30 00:49:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"210.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3206543","reservation_id":"108625","confirmation_number":"SJ12656346023","room_stay_from":"2021-04-26","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30,230.30,230.30,160.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1402.10","grand_total":"1577.37","paid_amount":"1577.37","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2712943488","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":"115064","customer_id":"115064","source_of_creation":"Booking.com","reservation_created_date":"2021-02-26 04:07:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"283.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242654","reservation_id":"113955","confirmation_number":"SJ12626329168","room_stay_from":"2021-04-29","room_stay_to":"2021-05-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.71,236.31,236.31","nightly_discount":"0,0,0","subtotal":"660.33","grand_total":"742.87","paid_amount":"0.00","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-3981938105","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":"120588","customer_id":"120588","source_of_creation":"Booking.com","reservation_created_date":"2021-04-26 22:25:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3220547","reservation_id":"109853","confirmation_number":"SJ12657862971","room_stay_from":"2021-04-24","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"296.80,198.80,198.80,198.80","nightly_discount":"0,0,0,0","subtotal":"893.20","grand_total":"1004.85","paid_amount":"1004.85","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1745625422","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":"116342","customer_id":"116342","source_of_creation":"Expedia","reservation_created_date":"2021-03-09 16:02:13","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":"198.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227230","reservation_id":"108960","confirmation_number":"SJ12692685827","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.65","nightly_discount":"0","subtotal":"194.65","grand_total":"218.98","paid_amount":"218.98","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1742869185","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":"115422","customer_id":"115422","source_of_creation":"Expedia","reservation_created_date":"2021-03-01 21:17:11","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":"194.65","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":"3238765","reservation_id":"113535","confirmation_number":"SJ12632030464","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"1","nightly_price":"339.32","nightly_discount":"0","subtotal":"339.32","grand_total":"381.74","paid_amount":"381.74","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1762132684","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120129","customer_id":"120129","source_of_creation":"Expedia","reservation_created_date":"2021-04-21 15:54:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"339.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240821","reservation_id":"111798","confirmation_number":"SJ12646026602","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.36,210.56,210.56","nightly_discount":"0,0,0","subtotal":"676.48","grand_total":"761.04","paid_amount":"761.04","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1754428884","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":"120388","customer_id":"118355","source_of_creation":"Expedia","reservation_created_date":"2021-03-31 23:23:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"210.56","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":"3242424","reservation_id":"113965","confirmation_number":"SJ12698410857","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"325.72","nightly_discount":"0","subtotal":"325.72","grand_total":"366.44","paid_amount":"366.44","room_type_id":"320","product_id":"1910","siteminder_id":"EXP-1764126062","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120597","customer_id":"120597","source_of_creation":"Expedia","reservation_created_date":"2021-04-27 01:00:12","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":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"325.72","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":"3209466","reservation_id":"109473","confirmation_number":"SJ12699179345","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"216.30,216.30,216.30,216.30,216.30","nightly_discount":"0,0,0,0,0","subtotal":"1081.50","grand_total":"1216.69","paid_amount":"1216.69","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1744192042","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":"115940","customer_id":"115940","source_of_creation":"Expedia","reservation_created_date":"2021-03-05 12:42:13","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"216.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3230533","reservation_id":"111873","confirmation_number":"SJ12697609684","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"265.50,265.50,265.50","nightly_discount":"0,0,0","subtotal":"796.50","grand_total":"896.07","paid_amount":"896.07","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1754894500","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":"118438","customer_id":"118438","source_of_creation":"Expedia","reservation_created_date":"2021-04-02 02:12:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","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":"265.50","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":"3231564","reservation_id":"112555","confirmation_number":"SJ12636763405","room_stay_from":"2021-04-26","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.40,212.40,212.40,212.40","nightly_discount":"0,0,0,0","subtotal":"849.60","grand_total":"955.80","paid_amount":"955.80","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1757776355","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":"119133","customer_id":"119133","source_of_creation":"Expedia","reservation_created_date":"2021-04-09 21:39:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"212.40","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":"3241866","reservation_id":"109340","confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"191.3,191.3,191.3,191.3,191.3","nightly_discount":"0,0,0,0,0","subtotal":"956.50","grand_total":"1076.07","paid_amount":"1076.07","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1743861784","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"125.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115805","customer_id":"115805","source_of_creation":"Expedia","reservation_created_date":"2021-03-04 15:32:11","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":"126","group_rooms":null,"currentDayPrice":"191.3","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":"3242389","reservation_id":"113661","confirmation_number":"SJ12677564323","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.40,179.40,179.40","nightly_discount":"0,0,0","subtotal":"538.20","grand_total":"605.48","paid_amount":"605.48","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1762666865","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":"120264","customer_id":"120264","source_of_creation":"Expedia","reservation_created_date":"2021-04-22 22:39:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.40","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":"3242502","reservation_id":"110586","confirmation_number":"SJ12640207675","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.40,161.40,161.40","nightly_discount":"0,0,0","subtotal":"484.20","grand_total":"544.73","paid_amount":"544.73","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1748887689","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":"117100","customer_id":"117100","source_of_creation":"Expedia","reservation_created_date":"2021-03-17 23:37:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"161.40","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":"3242589","reservation_id":"113944","confirmation_number":"SJ12658196968","room_stay_from":"2021-05-22","room_stay_to":"2021-05-24","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.76,191.36","nightly_discount":"0,0","subtotal":"421.12","grand_total":"473.76","paid_amount":"0.00","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1764022689","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":"120578","customer_id":"120578","source_of_creation":"Expedia","reservation_created_date":"2021-04-26 20:14:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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":"3242665","reservation_id":"113961","confirmation_number":"SJ12657030125","room_stay_from":"2021-07-08","room_stay_to":"2021-07-12","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"125.44,203.84,203.84,153.44","nightly_discount":"0,0,0,0","subtotal":"686.56","grand_total":"772.38","paid_amount":"0.00","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1764095788","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":"120594","customer_id":"120594","source_of_creation":"Expedia","reservation_created_date":"2021-04-26 23:40:22","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","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":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3242065","reservation_id":"112618","confirmation_number":"SJ12646441932","room_stay_from":"2021-04-26","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"329.46,325.51","nightly_discount":"0.00,0.00","subtotal":"654.97","grand_total":"759.02","paid_amount":"759.02","room_type_id":"319","product_id":"1942","siteminder_id":"ABB-HMM3ZHM4M5","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"658.92","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119200","customer_id":"119200","source_of_creation":"Airbnb","reservation_created_date":"2021-04-10 18:22:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"19.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"325.51","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":"3241629","reservation_id":"112594","confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"294.56,302.42,302.42,302.42","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1201.82","grand_total":"1408.04","paid_amount":"1408.04","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HMAEN8DJMB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"1209.68","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119174","customer_id":"119174","source_of_creation":"Airbnb","reservation_created_date":"2021-04-10 14:42:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"38.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"302.42","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":"3242070","reservation_id":"112585","confirmation_number":"SJ12628396272","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.92,301.92,296.49","nightly_discount":"0.00,0.00,0.00","subtotal":"900.33","grand_total":"1043.36","paid_amount":"1043.36","room_type_id":"319","product_id":"1311","siteminder_id":"ABB-HM83KCJEJX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"905.76","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119163","customer_id":"119163","source_of_creation":"Airbnb","reservation_created_date":"2021-04-10 12:38:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"26.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"301.92","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":"3242476","reservation_id":"111489","confirmation_number":"SJ12615590142","room_stay_from":"2021-04-27","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.92,298.30","nightly_discount":"0.00,0.00","subtotal":"600.22","grand_total":"695.57","paid_amount":"695.57","room_type_id":"319","product_id":"1306","siteminder_id":"ABB-HMZJHW3YXR","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"603.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118054","customer_id":"118054","source_of_creation":"Airbnb","reservation_created_date":"2021-03-28 02:54:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"17.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"301.92","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":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3241826","reservation_id":"113656","confirmation_number":"SJ12633417059","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75","nightly_discount":"12.34,12.34,12.34","subtotal":"740.25","grand_total":"791.13","paid_amount":"791.13","room_type_id":"319","product_id":"1293","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":"120256","customer_id":"120256","source_of_creation":"FE","reservation_created_date":"2021-04-22 21:32:50","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"12.34","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3230996","reservation_id":"112477","confirmation_number":"SJ12640020586","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"319","product_id":"1301","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":"119036","customer_id":"119036","source_of_creation":"FE","reservation_created_date":"2021-04-08 23:27:41","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":"0","group_rooms":null,"currentDayPrice":"246.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":"3241265","reservation_id":"111377","confirmation_number":"SJ12635010341","room_stay_from":"2021-04-24","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"321.75,246.75,246.75,246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1555.50","grand_total":"1749.94","paid_amount":"1749.94","room_type_id":"319","product_id":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117921","customer_id":"117921","source_of_creation":"FE","reservation_created_date":"2021-03-26 20:48:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.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":"3242505","reservation_id":"113985","confirmation_number":"SJ12696072125","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.15","nightly_discount":"0.00","subtotal":"237.15","grand_total":"266.80","paid_amount":"266.80","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120615","customer_id":"120615","source_of_creation":"PMS","reservation_created_date":"2021-04-27 13:28:46","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"237.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3195031","reservation_id":"107250","confirmation_number":"SJ12660712041","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"322.15,322.15,322.15","nightly_discount":"0.00,0.00,0.00","subtotal":"966.45","grand_total":"1087.25","paid_amount":"1087.25","room_type_id":"320","product_id":"1328","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":"113713","customer_id":"113713","source_of_creation":"PMS","reservation_created_date":"2021-02-09 22:32:52","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1302,1303","currentDayPrice":"322.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242885","reservation_id":"114042","confirmation_number":"SJ12668068893","room_stay_from":"2021-04-27","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"262.65,262.65","nightly_discount":"0.00,0.00","subtotal":"525.30","grand_total":"590.97","paid_amount":"295.48","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":"120677","customer_id":"120677","source_of_creation":"PMS","reservation_created_date":"2021-04-28 01:43:22","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","currentDayPrice":"262.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":"3242377","reservation_id":"113940","confirmation_number":"SJ12674279879","room_stay_from":"2021-04-26","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"262.65,262.65,262.65,262.65","nightly_discount":"0.00,0.00,0,0","subtotal":"1050.60","grand_total":"1181.93","paid_amount":"1181.93","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":"119882","customer_id":"119882","source_of_creation":"PMS","reservation_created_date":"2021-04-26 20:00:52","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":"262.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":"3242487","reservation_id":"111181","confirmation_number":"SJ12691024614","room_stay_from":"2021-06-10","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,160.00,160.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"640.00","grand_total":"720.00","paid_amount":"720.00","room_type_id":"412","product_id":"1921","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":"120493","customer_id":"120612","source_of_creation":"PMS","reservation_created_date":"2021-03-24 15:33:30","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":"0","changedComment":"From 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"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3206452","reservation_id":"105915","confirmation_number":"SJ12675456963","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00","subtotal":"417.00","grand_total":"469.13","paid_amount":"84.38","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2021-01-23 03:41:59","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3162577","reservation_id":"103547","confirmation_number":"SJ12676618165","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"168.76","room_type_id":"413","product_id":"1260","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-12-06 22:32:44","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","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":"86.67","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":"3181589","reservation_id":"105687","confirmation_number":"SJ12615222602","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1261","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-20 00:06:26","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":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3197807","reservation_id":"107394","confirmation_number":"SJ12626812437","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1272","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-02-12 01:22:15","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3196163","reservation_id":"107397","confirmation_number":"SJ12676286863","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1269","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-02-12 01:32:29","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","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":"86.67","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":"3204806","reservation_id":"108591","confirmation_number":"SJ12653667920","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.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-02-26 01:25:32","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":"87.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":"3215882","reservation_id":"108592","confirmation_number":"SJ12694732411","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1916","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-02-26 01:27:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"3240871","reservation_id":"106660","confirmation_number":"SJ12621428969","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","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":"2021-02-01 22:10:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3242384","reservation_id":"107404","confirmation_number":"SJ12647584589","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1711","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-02-12 02:29:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3242387","reservation_id":"106661","confirmation_number":"SJ12647750567","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1262","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-02-01 22:13:04","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3185832","reservation_id":"95536","confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"869.99","grand_total":"869.99","paid_amount":"281.25","room_type_id":"413","product_id":"1265","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-05-28 14:11:36","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.14","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229909","reservation_id":"95534","confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1219.96","grand_total":"1219.96","paid_amount":"393.75","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-05-28 14:06:38","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.14","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242810","reservation_id":"103377","confirmation_number":"SJ12675912418","room_stay_from":"2021-03-21","room_stay_to":"2021-03-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,113.00,113.00,113.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"795.00","grand_total":"795.00","paid_amount":"196.88","room_type_id":"413","product_id":"1264","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-12-02 00:53:55","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"Nightly price or discount changed","deltaChange":"-3.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3238766","reservation_id":"113535","confirmation_number":"SJ12684186335","room_confirmation_number":"SJ12632030464","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"120129","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-21 15:54:11","reservation_modified_date_time":"2021-04-21 15:54:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120129","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242425","reservation_id":"113965","confirmation_number":"SJ12689170551","room_confirmation_number":"SJ12698410857","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"120597","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-27 01:00:12","reservation_modified_date_time":"2021-04-27 01:00:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120597","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"50","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":"3239135","reservation_id":"112594","confirmation_number":"SJ12671345290","room_confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"100.60","paid_amount":"100.60","product_id":"1777","service_quantity":"1","customer_traveller_id":"119174","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-21 20:31:51","reservation_modified_date_time":"2021-04-21 20:31:51","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119174","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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":"3241867","reservation_id":"109340","confirmation_number":"SJ12652298870","room_confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1777","service_quantity":"1","customer_traveller_id":"115805","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-25 19:29:35","reservation_modified_date_time":"2021-04-25 19:29:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3162578","reservation_id":"103547","confirmation_number":"SJ12659212250","room_confirmation_number":"SJ12676618165","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109780","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 22:32:44","reservation_modified_date_time":"2020-12-06 22:32:44","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":"3181590","reservation_id":"105687","confirmation_number":"SJ12616678092","room_confirmation_number":"SJ12615222602","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109780","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 00:06:26","reservation_modified_date_time":"2021-01-20 00:06:26","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":"3197809","reservation_id":"107394","confirmation_number":"SJ12620981836","room_confirmation_number":"SJ12626812437","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113851","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 01:22:15","reservation_modified_date_time":"2021-02-14 11:20: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":"3208708","reservation_id":"109305","confirmation_number":"SJ12670703088","room_confirmation_number":"SJ12623826679","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","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":"115773","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 08:45:07","reservation_modified_date_time":"2021-03-04 08:45:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115773","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":"3211732","reservation_id":"109741","confirmation_number":"SJ12615848397","room_confirmation_number":"SJ12618000220","room_stay_from":"2021-04-26","room_stay_to":"2021-04-28","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":"116231","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-08 02:10:11","reservation_modified_date_time":"2021-03-08 02:10:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116231","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":"3220548","reservation_id":"109853","confirmation_number":"SJ12643952456","room_confirmation_number":"SJ12657862971","room_stay_from":"2021-04-24","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"116342","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 16:02:13","reservation_modified_date_time":"2021-03-22 17:26:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116342","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":"3227231","reservation_id":"108960","confirmation_number":"SJ12685830454","room_confirmation_number":"SJ12692685827","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","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":"115422","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 21:17:11","reservation_modified_date_time":"2021-04-03 18:42:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115422","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":"3238767","reservation_id":"113535","confirmation_number":"SJ12639481955","room_confirmation_number":"SJ12632030464","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","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":"120129","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 15:54:11","reservation_modified_date_time":"2021-04-21 15:54:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120129","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3240822","reservation_id":"111798","confirmation_number":"SJ12667185752","room_confirmation_number":"SJ12646026602","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25,25,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":"120388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 23:23:10","reservation_modified_date_time":"2021-04-24 15:17:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118355","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":"3241828","reservation_id":"113656","confirmation_number":"SJ12676989983","room_confirmation_number":"SJ12633417059","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","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":"120256","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 21:32:50","reservation_modified_date_time":"2021-04-25 18:45:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120256","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":"3242066","reservation_id":"112618","confirmation_number":"SJ12666049015","room_confirmation_number":"SJ12646441932","room_stay_from":"2021-04-26","room_stay_to":"2021-04-28","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":"119200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 18:22:10","reservation_modified_date_time":"2021-04-26 13:21:44","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119200","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":"3242393","reservation_id":"113545","confirmation_number":"SJ12675974831","room_confirmation_number":"SJ12651407069","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","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":"120142","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 17:30:12","reservation_modified_date_time":"2021-04-26 23:08:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120142","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":"3242395","reservation_id":"113857","confirmation_number":"SJ12649328737","room_confirmation_number":"SJ12621124138","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","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":"120480","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-25 17:11:06","reservation_modified_date_time":"2021-04-26 23:09:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120480","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":"3242426","reservation_id":"113965","confirmation_number":"SJ12673260012","room_confirmation_number":"SJ12698410857","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","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":"120597","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-27 01:00:12","reservation_modified_date_time":"2021-04-27 01:00:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120597","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3242506","reservation_id":"113985","confirmation_number":"SJ12683982371","room_confirmation_number":"SJ12696072125","room_stay_from":"2021-04-27","room_stay_to":"2021-04-28","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":"120615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-27 13:28:46","reservation_modified_date_time":"2021-04-27 13:28:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120615","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":"3186985","reservation_id":"106408","confirmation_number":"SJ12676184823","room_confirmation_number":"SJ12622282653","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","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":"112805","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:25:06","reservation_modified_date_time":"2021-01-29 14:25:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112805","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":"3195032","reservation_id":"107250","confirmation_number":"SJ12615377366","room_confirmation_number":"SJ12660712041","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","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":"113713","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 22:32:52","reservation_modified_date_time":"2021-02-09 22:32:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113713","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":"3196164","reservation_id":"107397","confirmation_number":"SJ12639808354","room_confirmation_number":"SJ12676286863","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 01:32:29","reservation_modified_date_time":"2021-02-12 01:32:29","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":"3206454","reservation_id":"105915","confirmation_number":"SJ12655626972","room_confirmation_number":"SJ12675456963","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112332","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-23 03:41:59","reservation_modified_date_time":"2021-02-28 23:44:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","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":"3230997","reservation_id":"112477","confirmation_number":"SJ12612977296","room_confirmation_number":"SJ12640020586","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","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":"119036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 23:27:41","reservation_modified_date_time":"2021-04-08 23:27:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119036","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":"3241630","reservation_id":"112594","confirmation_number":"SJ12631670970","room_confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119174","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 14:42:10","reservation_modified_date_time":"2021-04-25 12:27:04","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119174","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3242072","reservation_id":"112585","confirmation_number":"SJ12645823436","room_confirmation_number":"SJ12628396272","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","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":"119163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 12:38:08","reservation_modified_date_time":"2021-04-26 13:22:55","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119163","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":"3242477","reservation_id":"111489","confirmation_number":"SJ12650713479","room_confirmation_number":"SJ12615590142","room_stay_from":"2021-04-27","room_stay_to":"2021-04-29","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":"118054","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 02:54:10","reservation_modified_date_time":"2021-04-27 11:45:52","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118054","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":"3242886","reservation_id":"114042","confirmation_number":"SJ12686222120","room_confirmation_number":"SJ12668068893","room_stay_from":"2021-04-27","room_stay_to":"2021-04-29","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120677","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 01:43:22","reservation_modified_date_time":"2021-04-28 01:43:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120677","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":"3203654","reservation_id":"106362","confirmation_number":"SJ12667638930","room_confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"112757","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 23:36:12","reservation_modified_date_time":"2021-02-24 15:20:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112757","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3204807","reservation_id":"108591","confirmation_number":"SJ12659138449","room_confirmation_number":"SJ12653667920","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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":"115029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:25:32","reservation_modified_date_time":"2021-02-26 01:25:32","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":"3209467","reservation_id":"109473","confirmation_number":"SJ12645666649","room_confirmation_number":"SJ12699179345","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"115940","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 12:42:13","reservation_modified_date_time":"2021-03-05 12:42:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115940","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":"3215883","reservation_id":"108592","confirmation_number":"SJ12639140046","room_confirmation_number":"SJ12694732411","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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":"115030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:27:18","reservation_modified_date_time":"2021-03-15 01:48:25","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":"3229816","reservation_id":"109832","confirmation_number":"SJ12683788974","room_confirmation_number":"SJ12639370317","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"116323","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 04:45:11","reservation_modified_date_time":"2021-04-07 17:27:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116323","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":"3230534","reservation_id":"111873","confirmation_number":"SJ12668329767","room_confirmation_number":"SJ12697609684","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"118438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-02 02:12:07","reservation_modified_date_time":"2021-04-08 13:31:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118438","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":"3231565","reservation_id":"112555","confirmation_number":"SJ12653080678","room_confirmation_number":"SJ12636763405","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"119133","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-09 21:39:10","reservation_modified_date_time":"2021-04-09 21:39:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119133","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":"3239141","reservation_id":"113558","confirmation_number":"SJ12627838522","room_confirmation_number":"SJ12693394160","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"120159","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 19:27:08","reservation_modified_date_time":"2021-04-21 20:32:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120159","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":"3240872","reservation_id":"106660","confirmation_number":"SJ12674140097","room_confirmation_number":"SJ12621428969","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113078","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 22:10:59","reservation_modified_date_time":"2021-04-24 15:42: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":"3241266","reservation_id":"111377","confirmation_number":"SJ12656905055","room_confirmation_number":"SJ12635010341","room_stay_from":"2021-04-24","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"117921","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 20:48:05","reservation_modified_date_time":"2021-04-24 19:27:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117921","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":"3241862","reservation_id":"111648","confirmation_number":"SJ12622373879","room_confirmation_number":"SJ12673975702","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"118206","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 00:49:07","reservation_modified_date_time":"2021-04-25 19:29:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118206","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":"3241868","reservation_id":"109340","confirmation_number":"SJ12638988346","room_confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"115805","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 15:32:11","reservation_modified_date_time":"2021-04-25 19:29:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.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":"3242378","reservation_id":"113940","confirmation_number":"SJ12656528036","room_confirmation_number":"SJ12674279879","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"119882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 20:00:52","reservation_modified_date_time":"2021-04-26 23:00:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119882","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":"3242386","reservation_id":"107404","confirmation_number":"SJ12640827007","room_confirmation_number":"SJ12647584589","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113860","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 02:29:33","reservation_modified_date_time":"2021-04-26 23:07:00","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":"3242388","reservation_id":"106661","confirmation_number":"SJ12635704579","room_confirmation_number":"SJ12647750567","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 22:13:04","reservation_modified_date_time":"2021-04-26 23:07:33","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":"3242391","reservation_id":"113661","confirmation_number":"SJ12636411720","room_confirmation_number":"SJ12677564323","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"120264","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 22:39:09","reservation_modified_date_time":"2021-04-26 23:08:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120264","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":"3242503","reservation_id":"110586","confirmation_number":"SJ12650275426","room_confirmation_number":"SJ12640207675","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"117100","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 23:37:07","reservation_modified_date_time":"2021-04-27 13:25:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117100","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":"3185833","reservation_id":"95536","confirmation_number":"SJ12671781895","room_confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:11:36","reservation_modified_date_time":"2021-01-27 21:49:53","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":"3206544","reservation_id":"108625","confirmation_number":"SJ12655239094","room_confirmation_number":"SJ12656346023","room_stay_from":"2021-04-26","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"115064","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 04:07:10","reservation_modified_date_time":"2021-03-01 01:53:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115064","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":"3229910","reservation_id":"95534","confirmation_number":"SJ12670678562","room_confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:06:38","reservation_modified_date_time":"2021-04-07 18:29:47","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":"3242486","reservation_id":"111181","confirmation_number":"SJ12615676897","room_confirmation_number":"SJ12691024614","room_stay_from":"2021-06-10","room_stay_to":"2021-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"10.00,10.00,10.00,10.00","subtotal":"100.00","grand_total":"67.50","paid_amount":"67.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"120493","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 15:33:30","reservation_modified_date_time":"2021-04-27 12:48:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120612","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From 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":"3242588","reservation_id":"113944","confirmation_number":"SJ12642959381","room_confirmation_number":"SJ12658196968","room_stay_from":"2021-05-22","room_stay_to":"2021-05-24","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120578","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 20:14:24","reservation_modified_date_time":"2021-04-27 16:37:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120578","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":"3242653","reservation_id":"113955","confirmation_number":"SJ12655118051","room_confirmation_number":"SJ12626329168","room_stay_from":"2021-04-29","room_stay_to":"2021-05-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120588","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 22:25:27","reservation_modified_date_time":"2021-04-27 18:16:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120588","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":"3242664","reservation_id":"113961","confirmation_number":"SJ12618373391","room_confirmation_number":"SJ12657030125","room_stay_from":"2021-07-08","room_stay_to":"2021-07-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120594","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 23:40:22","reservation_modified_date_time":"2021-04-27 18:18:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120594","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":"3242827","reservation_id":"114030","confirmation_number":"SJ12629302289","room_confirmation_number":"SJ12649413678","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"2.00","paid_amount":"2.00","product_id":"1660","service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-27 22:55:06","reservation_modified_date_time":"2021-04-27 22:55:06","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}