{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-02-14","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":20,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1291,1711,1304,1305,1311,1312,1260,1261,1269,1270,1271,1272,1262,1263,1307,1308,1267,1268,1302,1303,1309,1310","bundle_block_bookings":[{"confirmation_number":"SJB12693980429","room_stay_from":"2021-02-13","room_stay_to":"2021-02-15","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12630357587","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12653872140","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12610392340","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12641472790","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12657342632","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12689240355","room_stay_from":"2021-02-13","room_stay_to":"2021-02-16","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12685999197","room_stay_from":"2021-02-13","room_stay_to":"2021-02-16","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12662278013","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12642367175","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12694683303","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12626092954","room_stay_from":"2021-02-12","room_stay_to":"2021-02-20","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12692218566","room_stay_from":"2021-02-12","room_stay_to":"2021-02-20","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12680634979","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12640435189","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","bundle_room":"0","product_id":"1310"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3174790","reservation_id":"104825","confirmation_number":"SJ12641553290","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"232.20,232.20,218.70","nightly_discount":"0,0,0","subtotal":"683.10","grand_total":"768.49","paid_amount":"768.49","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-2269279999","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":"111173","customer_id":"111173","source_of_creation":"Booking.com","reservation_created_date":"2021-01-06 00:33:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"136.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"218.70","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":"3175118","reservation_id":"104869","confirmation_number":"SJ12628788655","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.75,216.75,201.75","nightly_discount":"0,0,0","subtotal":"635.25","grand_total":"714.65","paid_amount":"714.65","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-3836757890","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":"111221","customer_id":"111221","source_of_creation":"Booking.com","reservation_created_date":"2021-01-06 16:44:27","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":"126","group_rooms":null,"currentDayPrice":"201.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":"3192039","reservation_id":"106498","confirmation_number":"SJ12641170521","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"274.71","nightly_discount":"0","subtotal":"274.71","grand_total":"309.05","paid_amount":"309.05","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3192857476","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":"112907","customer_id":"112907","source_of_creation":"Booking.com","reservation_created_date":"2021-01-30 19:49:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"53.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"274.71","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181048","reservation_id":"105573","confirmation_number":"SJ12631617816","room_stay_from":"2021-02-13","room_stay_to":"2021-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.30,237.30,237.30,237.30","nightly_discount":"0,0,0,0","subtotal":"991.20","grand_total":"1115.10","paid_amount":"1115.10","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-3423038467","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":"111994","customer_id":"111994","source_of_creation":"Booking.com","reservation_created_date":"2021-01-18 21:21:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"196.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"237.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":"3194566","reservation_id":"106232","confirmation_number":"SJ12651106976","room_stay_from":"2021-02-14","room_stay_to":"2021-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"229.32,229.32,229.32,229.32","nightly_discount":"0,0,0,0","subtotal":"917.28","grand_total":"1031.94","paid_amount":"1031.94","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-3883478133","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":"112639","customer_id":"112639","source_of_creation":"Booking.com","reservation_created_date":"2021-01-27 03:41:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"183.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"229.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":"3184694","reservation_id":"106146","confirmation_number":"SJ12653125261","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"321.30,321.30,321.30,321.30,321.30","nightly_discount":"0,0,0,0,0","subtotal":"1606.50","grand_total":"1807.32","paid_amount":"1807.32","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-3816857569","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":"112559","customer_id":"112559","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 04:52:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"311.67","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"321.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":"3186819","reservation_id":"106393","confirmation_number":"SJ12690110347","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.67,194.67,194.67,194.67,194.67","nightly_discount":"0,0,0,0,0","subtotal":"973.35","grand_total":"1095.02","paid_amount":"1095.02","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-3361889721","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":"112789","customer_id":"112789","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 03:45:19","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"197.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.67","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3194668","reservation_id":"103347","confirmation_number":"SJ12673829867","room_stay_from":"2021-02-10","room_stay_to":"2021-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,202.30,202.30,188.30,174.30,174.30,174.30,174.30","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1638.70","grand_total":"1843.54","paid_amount":"1843.54","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3204904452","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":"109517","customer_id":"109517","source_of_creation":"Booking.com","reservation_created_date":"2020-12-01 16:14:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"335.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.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":"3197319","reservation_id":"105062","confirmation_number":"SJ12664604647","room_stay_from":"2021-02-12","room_stay_to":"2021-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,279.30,279.30,251.30,251.30,251.30,251.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1815.10","grand_total":"2041.99","paid_amount":"2041.99","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3820856153","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":"111437","customer_id":"111437","source_of_creation":"Booking.com","reservation_created_date":"2021-01-09 17:28:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"358.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"279.30","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":"3174590","reservation_id":"102933","confirmation_number":"SJ12652571265","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.20,215.20,199.20,199.20,199.20,199.20,231.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1474.40","grand_total":"1658.70","paid_amount":"1658.70","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3893964037","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":"109063","customer_id":"109063","source_of_creation":"Booking.com","reservation_created_date":"2020-11-21 15:18:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"296.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3198014","reservation_id":"105807","confirmation_number":"SJ12664568502","room_stay_from":"2021-05-12","room_stay_to":"2021-05-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.75,261.75,314.25","nightly_discount":"0,0,0","subtotal":"837.75","grand_total":"942.47","paid_amount":"314.10","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-3793969656","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":"112212","customer_id":"112212","source_of_creation":"Booking.com","reservation_created_date":"2021-01-21 20:50:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"164.28","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3179039","reservation_id":"105359","confirmation_number":"SJ12665602754","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.00,318.00,318.00","nightly_discount":"0,0,0","subtotal":"924.00","grand_total":"1039.50","paid_amount":"1039.50","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1730075987","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":"111750","customer_id":"111750","source_of_creation":"Expedia","reservation_created_date":"2021-01-15 02:51:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","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":"318.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185514","reservation_id":"104749","confirmation_number":"SJ12622421694","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"251.44,273.84,273.84,262.64","nightly_discount":"0,0,0,0","subtotal":"1061.76","grand_total":"1194.48","paid_amount":"1194.48","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1727603021","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":"111102","customer_id":"111102","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 01:46:12","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":"","sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"262.64","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3187615","reservation_id":"104772","confirmation_number":"SJ12662704182","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.32","nightly_discount":"0","subtotal":"203.32","grand_total":"228.74","paid_amount":"228.74","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1727717007","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":"111125","customer_id":"111125","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 15:56:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"203.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":"3196313","reservation_id":"106879","confirmation_number":"SJ12651213705","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.40,254.40,242.40","nightly_discount":"0,0,0","subtotal":"727.20","grand_total":"818.10","paid_amount":"818.10","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1735177042","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":"113311","customer_id":"113311","source_of_creation":"Expedia","reservation_created_date":"2021-02-04 06:45:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"242.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":"3196892","reservation_id":"104384","confirmation_number":"SJ12681577314","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"254.25,254.25,239.25","nightly_discount":"0.00,0.00,0.00","subtotal":"747.75","grand_total":"841.22","paid_amount":"841.22","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1726108003","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110740","customer_id":"110740","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 19:21:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.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":"3196950","reservation_id":"104389","confirmation_number":"SJ12685440999","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"204.25,204.25,189.25","nightly_discount":"0.00,0.00,0.00","subtotal":"597.75","grand_total":"672.47","paid_amount":"672.47","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1726114806","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":"110745","customer_id":"110745","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 19:51:23","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","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":"189.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":"3176771","reservation_id":"105076","confirmation_number":"SJ12680398413","room_stay_from":"2021-02-10","room_stay_to":"2021-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.24,156.24,201.04,223.44,223.44,201.04","nightly_discount":"0,0,0,0,0,0","subtotal":"1161.44","grand_total":"1306.62","paid_amount":"1306.62","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1728737440","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":"111450","customer_id":"111450","source_of_creation":"Expedia","reservation_created_date":"2021-01-09 19:21:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3173658","reservation_id":"104659","confirmation_number":"SJ12675541524","room_stay_from":"2021-02-14","room_stay_to":"2021-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"239.25,224.25,224.25","nightly_discount":"0,0,0","subtotal":"687.75","grand_total":"773.72","paid_amount":"773.72","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1727295920","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":"111012","customer_id":"111012","source_of_creation":"Expedia","reservation_created_date":"2021-01-03 20:46:28","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":"0","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3196298","reservation_id":"102037","confirmation_number":"SJ12657555655","room_stay_from":"2021-02-11","room_stay_to":"2021-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.56,268.16,268.16,210.56,210.56,191.36","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1359.36","grand_total":"1529.28","paid_amount":"1529.28","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1711824190","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":"108156","customer_id":"108156","source_of_creation":"Expedia","reservation_created_date":"2020-10-28 15:53:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","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.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":"3191366","reservation_id":"106864","confirmation_number":"SJ12637675076","room_stay_from":"2021-02-14","room_stay_to":"2021-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.44,212.24,212.24,212.24","nightly_discount":"0,0,0,0","subtotal":"860.16","grand_total":"967.68","paid_amount":"967.68","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1735131891","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":"113294","customer_id":"113294","source_of_creation":"Expedia","reservation_created_date":"2021-02-04 02:55:09","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3180215","reservation_id":"105493","confirmation_number":"SJ12626754804","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.80,254.80,254.80,254.80,254.80","nightly_discount":"0,0,0,0,0","subtotal":"1274.00","grand_total":"1433.25","paid_amount":"1433.25","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1730601445","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":"111908","customer_id":"111908","source_of_creation":"Expedia","reservation_created_date":"2021-01-17 04:06:13","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":"254.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":"3153911","reservation_id":"102511","confirmation_number":"SJ12696497632","room_stay_from":"2021-02-12","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.96,280.96,268.16,255.36,255.36,255.36,255.36,280.96","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2132.48","grand_total":"2399.04","paid_amount":"2399.04","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1715171854","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":"108675","customer_id":"108675","source_of_creation":"Expedia","reservation_created_date":"2020-11-11 01:23:10","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":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"268.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3176859","reservation_id":"105093","confirmation_number":"SJ12690112213","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,167.44,150.64,150.64,150.64,150.64,159.04","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1096.48","grand_total":"1233.54","paid_amount":"1233.54","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1728769898","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":"111471","customer_id":"111471","source_of_creation":"Expedia","reservation_created_date":"2021-01-09 22:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"167.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197151","reservation_id":"99342","confirmation_number":"SJ12634121142","room_stay_from":"2021-02-14","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,243.20,243.20,243.20,243.20,295.20","nightly_discount":"0,0,0,0,0,0","subtotal":"1511.20","grand_total":"1700.10","paid_amount":"1700.10","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1691626043","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":"105327","customer_id":"105327","source_of_creation":"Expedia","reservation_created_date":"2020-08-21 23:57:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"243.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":"3197823","reservation_id":"104822","confirmation_number":"SJ12659421932","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"273.84,262.64,251.44,251.44,251.44,251.44,273.84","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1816.08","grand_total":"2043.09","paid_amount":"2043.09","room_type_id":"320","product_id":"1910","siteminder_id":"EXP-1727817720","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":"111169","customer_id":"111169","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 23:41:06","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","currentDayPrice":"262.64","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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3196311","reservation_id":"106657","confirmation_number":"SJ12617590293","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.74","nightly_discount":"0","subtotal":"138.74","grand_total":"156.09","paid_amount":"156.09","room_type_id":"413","product_id":"1273","siteminder_id":"HTN-151121971-CHZA2E","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":"113075","customer_id":"113075","source_of_creation":"HotelTonight","reservation_created_date":"2021-02-01 21:58:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"138.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":"3196400","reservation_id":"107437","confirmation_number":"SJ12699261566","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.18","nightly_discount":"0","subtotal":"250.18","grand_total":"281.45","paid_amount":"281.45","room_type_id":"411","product_id":"1296","siteminder_id":"HTN-152107273-HZ7DLL","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":"113893","customer_id":"113893","source_of_creation":"HotelTonight","reservation_created_date":"2021-02-12 16:02:09","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":"250.18","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":"3197771","reservation_id":"107570","confirmation_number":"SJ12674851275","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.18","nightly_discount":"0","subtotal":"250.18","grand_total":"281.45","paid_amount":"281.45","room_type_id":"319","product_id":"1313","siteminder_id":"HTN-152300218-HMQMTH","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":"114029","customer_id":"114029","source_of_creation":"HotelTonight","reservation_created_date":"2021-02-14 03:04:12","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"250.18","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":"3197840","reservation_id":"107585","confirmation_number":"SJ12692238035","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.18","nightly_discount":"0","subtotal":"250.18","grand_total":"281.45","paid_amount":"281.45","room_type_id":"319","product_id":"1291","siteminder_id":"HTN-152329628-LKP4VE","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":"114043","customer_id":"114043","source_of_creation":"HotelTonight","reservation_created_date":"2021-02-14 14:54:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"250.18","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3190762","reservation_id":"104817","confirmation_number":"SJ12610956809","room_stay_from":"2021-02-12","room_stay_to":"2021-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.77,155.77,144.99,134.21","nightly_discount":"0,0,0,0","subtotal":"590.74","grand_total":"664.59","paid_amount":"664.59","room_type_id":"413","product_id":"1265","siteminder_id":"GAM-R2270329080","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":"111163","customer_id":"111163","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-05 22:56:11","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":"126","group_rooms":null,"currentDayPrice":"144.99","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3195260","reservation_id":"104529","confirmation_number":"SJ12675288265","room_stay_from":"2021-02-10","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.84,246.84,246.84,246.84,239.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1226.79","grand_total":"1421.69","paid_amount":"1421.69","room_type_id":"319","product_id":"1274","siteminder_id":"ABB-HMXAT9D4K8","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1234.20","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110876","customer_id":"110876","source_of_creation":"Airbnb","reservation_created_date":"2021-01-01 18:47:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"36.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3195839","reservation_id":"104694","confirmation_number":"SJ12623856121","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.40,251.43,251.43,251.43","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"999.69","grand_total":"1158.50","paid_amount":"1158.50","room_type_id":"319","product_id":"1288","siteminder_id":"ABB-HMHFJFMA5N","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1005.72","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111047","customer_id":"111047","source_of_creation":"Airbnb","reservation_created_date":"2021-01-04 13:35:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"29.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3197718","reservation_id":"93105","confirmation_number":"SJ12679962701","room_stay_from":"2021-02-13","room_stay_to":"2021-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.53,144.53,144.53,144.53,144.53,144.53,144.53,86.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1098.43","grand_total":"1435.17","paid_amount":"1435.17","room_type_id":"319","product_id":"1319","siteminder_id":"ABB-HMR55J9KEE","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1156.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99301","customer_id":"99301","source_of_creation":"Airbnb","reservation_created_date":"2020-03-08 15:59:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"153.77","commision_charges":"35.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"144.53","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3189416","reservation_id":"106610","confirmation_number":"SJ12644422067","room_stay_from":"2021-02-14","room_stay_to":"2021-02-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,149.00,129.00,129.00,129.00,149.00","nightly_discount":"0,0,0,0,0,0","subtotal":"884.00","grand_total":"994.50","paid_amount":"994.50","room_type_id":"413","product_id":"1267","siteminder_id":"HWR-303192669","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":"113032","customer_id":"113032","source_of_creation":"Hotwire","reservation_created_date":"2021-02-01 13:48:49","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"199.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"hwr_non_taxable":[{"room_stay_id":"3194850","reservation_id":"107140","confirmation_number":"SJ12657047071","room_stay_from":"2021-02-14","room_stay_to":"2021-02-16","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"199.00,149.00","nightly_discount":"0,0","subtotal":"348.00","grand_total":"391.50","paid_amount":"391.50","room_type_id":"412","product_id":"1294","siteminder_id":"HWR-303212574","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":"113602","customer_id":"113602","source_of_creation":"Hotwire","reservation_created_date":"2021-02-08 03:35:10","service_canceled_date_time":"2021-02-14 17:17:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"126","deltaChange":"391.50","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3189401","reservation_id":"105223","confirmation_number":"SJ12629157266","room_stay_from":"2021-02-14","room_stay_to":"2021-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"276.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00","subtotal":"770.25","grand_total":"866.53","paid_amount":"866.53","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":"111605","customer_id":"111605","source_of_creation":"FE","reservation_created_date":"2021-01-12 16:23:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"276.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":"3194562","reservation_id":"105379","confirmation_number":"SJ12643756097","room_stay_from":"2021-02-13","room_stay_to":"2021-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"299.25,299.25,269.25,269.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1137.00","grand_total":"1279.13","paid_amount":"1279.13","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111772","customer_id":"111772","source_of_creation":"FE","reservation_created_date":"2021-01-15 17:20:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"299.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3197955","reservation_id":"107602","confirmation_number":"SJ12620863110","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.04","nightly_discount":"0.00","subtotal":"131.04","grand_total":"147.42","paid_amount":"147.42","room_type_id":"412","product_id":"1294","siteminder_id":"HTN-152333439-C94Q9R","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":"114057","customer_id":"114057","source_of_creation":"PMS","reservation_created_date":"2021-02-14 17:05:31","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"131.04","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":"3198190","reservation_id":"107649","confirmation_number":"SJ12611611492","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.28","nightly_discount":"0.00","subtotal":"288.28","grand_total":"324.31","paid_amount":"324.31","room_type_id":"318","product_id":"1289","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":"114107","customer_id":"114107","source_of_creation":"PMS","reservation_created_date":"2021-02-15 02:12:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"288.28","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":"3197953","reservation_id":"107609","confirmation_number":"SJ12679029857","room_stay_from":"2021-02-14","room_stay_to":"2021-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"360.40,343.40","nightly_discount":"0.00,0.00","subtotal":"703.80","grand_total":"791.78","paid_amount":"791.78","room_type_id":"413","product_id":"1269","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":"114064","customer_id":"114064","source_of_creation":"PMS","reservation_created_date":"2021-02-14 17:27:51","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","currentDayPrice":"360.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197155","reservation_id":"107347","confirmation_number":"SJ12675529089","room_stay_from":"2021-02-13","room_stay_to":"2021-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,280.00,280.00,280.00,280.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1400.00","grand_total":"1575.00","paid_amount":"1575.00","room_type_id":"412","product_id":"1297","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":"113804","customer_id":"113804","source_of_creation":"PMS","reservation_created_date":"2021-02-11 16:23:50","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":"0","group_rooms":null,"currentDayPrice":"280.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":"3186353","reservation_id":"106338","confirmation_number":"SJ12666067522","room_stay_from":"2021-02-14","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.11,203.11,203.11,203.11,203.11,213.11","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1228.66","grand_total":"1382.24","paid_amount":"1382.24","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":"112728","customer_id":"112728","source_of_creation":"PMS","reservation_created_date":"2021-01-28 16:59:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"203.11","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189341","reservation_id":"106562","confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101703","customer_id":"101703","source_of_creation":"PMS","reservation_created_date":"2021-01-31 18:54:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3195212","reservation_id":"104483","confirmation_number":"SJ12616746915","room_stay_from":"2021-02-14","room_stay_to":"2021-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,132.55,150.00,150.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"932.55","grand_total":"1049.12","paid_amount":"0.00","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2020-12-31 19:31:27","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":"150.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":"3192041","reservation_id":"104924","confirmation_number":"SJ12663174632","room_stay_from":"2021-02-07","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,113.33,113.33,113.34","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"910.00","grand_total":"910.00","paid_amount":"225.00","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-07 01:19:48","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":"113.34","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":"3147448","reservation_id":"101755","confirmation_number":"SJ12697252966","room_stay_from":"2021-02-13","room_stay_to":"2021-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","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":"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-10-20 00:03:01","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.33","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":"3189261","reservation_id":"103865","confirmation_number":"SJ12666352371","room_stay_from":"2021-02-13","room_stay_to":"2021-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"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-16 02:20:32","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190697","reservation_id":"103376","confirmation_number":"SJ12672040273","room_stay_from":"2021-02-13","room_stay_to":"2021-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"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":"2020-12-02 00:51:10","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":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3196969","reservation_id":"104916","confirmation_number":"SJ12681820157","room_stay_from":"2021-02-12","room_stay_to":"2021-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.58","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":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-07 00:59:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.57","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":"3146782","reservation_id":"98514","confirmation_number":"SJ12695243467","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"794.99","grand_total":"794.99","paid_amount":"196.88","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-02 22:21:26","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","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":"113.57","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":"3176018","reservation_id":"102755","confirmation_number":"SJ12686818505","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.58","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":"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":"2020-11-17 01:31:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.57","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":"3183489","reservation_id":"105968","confirmation_number":"SJ12648021718","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1159.00","grand_total":"1159.00","paid_amount":"0.00","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-01-24 03:03:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"165.57","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":"3188633","reservation_id":"106559","confirmation_number":"SJ12680044581","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","paid_amount":"0.00","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-01-31 18:27:32","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":"0","group_rooms":null,"currentDayPrice":"178.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190772","reservation_id":"95527","confirmation_number":"SJ12661587211","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"794.99","grand_total":"794.99","paid_amount":"196.88","room_type_id":"413","product_id":"1263","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 13:40:02","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.57","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":"3190993","reservation_id":"104389","confirmation_number":"SJ12671209721","room_confirmation_number":"SJ12685440999","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"110745","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-03 14:29:07","reservation_modified_date_time":"2021-02-03 14:29:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110745","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3174791","reservation_id":"104825","confirmation_number":"SJ12626177762","room_confirmation_number":"SJ12641553290","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","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":"111173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 00:33:07","reservation_modified_date_time":"2021-01-06 00:33:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111173","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":"3175117","reservation_id":"104869","confirmation_number":"SJ12640129589","room_confirmation_number":"SJ12628788655","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","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":"111221","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 16:44:27","reservation_modified_date_time":"2021-01-06 17:40:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111221","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":"3179040","reservation_id":"105359","confirmation_number":"SJ12613121233","room_confirmation_number":"SJ12665602754","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","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":"111750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 02:51:08","reservation_modified_date_time":"2021-01-15 02:51:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111750","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":"3185517","reservation_id":"104749","confirmation_number":"SJ12699904679","room_confirmation_number":"SJ12622421694","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","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":"111102","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 01:46:12","reservation_modified_date_time":"2021-01-27 15:39:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111102","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":"3187616","reservation_id":"104772","confirmation_number":"SJ12650256272","room_confirmation_number":"SJ12662704182","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","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":"111125","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 15:56:10","reservation_modified_date_time":"2021-01-30 02:39:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111125","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":"3192040","reservation_id":"106498","confirmation_number":"SJ12680306849","room_confirmation_number":"SJ12641170521","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","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":"112907","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 19:49:06","reservation_modified_date_time":"2021-02-04 23:29:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112907","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":"3192042","reservation_id":"104924","confirmation_number":"SJ12666545212","room_confirmation_number":"SJ12663174632","room_stay_from":"2021-02-07","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111281","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 01:19:48","reservation_modified_date_time":"2021-02-04 23:29: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":"3195261","reservation_id":"104529","confirmation_number":"SJ12662427710","room_confirmation_number":"SJ12675288265","room_stay_from":"2021-02-10","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110876","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 18:47:07","reservation_modified_date_time":"2021-02-10 13:53:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110876","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":"3195840","reservation_id":"104694","confirmation_number":"SJ12653328895","room_confirmation_number":"SJ12623856121","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","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":"111047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-04 13:35:10","reservation_modified_date_time":"2021-02-11 14:36:34","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111047","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":"3196312","reservation_id":"106657","confirmation_number":"SJ12657423896","room_confirmation_number":"SJ12617590293","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","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":"113075","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 21:58:10","reservation_modified_date_time":"2021-02-12 15:44:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113075","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":"3196314","reservation_id":"106879","confirmation_number":"SJ12682522441","room_confirmation_number":"SJ12651213705","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","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":"113311","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 06:45:06","reservation_modified_date_time":"2021-02-12 15:45:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113311","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":"3196401","reservation_id":"107437","confirmation_number":"SJ12653479516","room_confirmation_number":"SJ12699261566","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","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":"113893","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 16:02:09","reservation_modified_date_time":"2021-02-12 16:02:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113893","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":"3196894","reservation_id":"104384","confirmation_number":"SJ12684557788","room_confirmation_number":"SJ12681577314","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"110740","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 19:21:10","reservation_modified_date_time":"2021-02-12 20:53:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110740","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3196951","reservation_id":"104389","confirmation_number":"SJ12677729522","room_confirmation_number":"SJ12685440999","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"25.00,25.00,0.00","subtotal":"75.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"110745","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 19:51:23","reservation_modified_date_time":"2021-02-12 21:37:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110745","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":"3197772","reservation_id":"107570","confirmation_number":"SJ12618560781","room_confirmation_number":"SJ12674851275","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","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":"114029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 03:04:12","reservation_modified_date_time":"2021-02-14 03:04:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114029","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":"3197841","reservation_id":"107585","confirmation_number":"SJ12673881706","room_confirmation_number":"SJ12692238035","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","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":"114043","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 14:54:12","reservation_modified_date_time":"2021-02-14 14:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114043","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":"3197957","reservation_id":"107602","confirmation_number":"SJ12631791102","room_confirmation_number":"SJ12620863110","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","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":"114057","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 17:05:31","reservation_modified_date_time":"2021-02-14 17:33:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114057","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":"3198191","reservation_id":"107649","confirmation_number":"SJ12669588007","room_confirmation_number":"SJ12611611492","room_stay_from":"2021-02-14","room_stay_to":"2021-02-15","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":"114107","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 02:12:25","reservation_modified_date_time":"2021-02-15 02:12:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114107","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":"3147449","reservation_id":"101755","confirmation_number":"SJ12696692713","room_confirmation_number":"SJ12697252966","room_stay_from":"2021-02-13","room_stay_to":"2021-02-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107851","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-20 00:03:01","reservation_modified_date_time":"2020-10-20 00:03:01","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":"3176772","reservation_id":"105076","confirmation_number":"SJ12674751634","room_confirmation_number":"SJ12680398413","room_stay_from":"2021-02-10","room_stay_to":"2021-02-16","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":"111450","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 19:21:09","reservation_modified_date_time":"2021-01-09 19:21:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111450","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":"3190765","reservation_id":"104817","confirmation_number":"SJ12652253817","room_confirmation_number":"SJ12610956809","room_stay_from":"2021-02-12","room_stay_to":"2021-02-16","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":"111163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 22:56:11","reservation_modified_date_time":"2021-02-02 22:54:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111163","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":"3197954","reservation_id":"107609","confirmation_number":"SJ12626913033","room_confirmation_number":"SJ12679029857","room_stay_from":"2021-02-14","room_stay_to":"2021-02-16","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":"114064","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 17:27:51","reservation_modified_date_time":"2021-02-14 17:33:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114064","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":"3173657","reservation_id":"104659","confirmation_number":"SJ12631155502","room_confirmation_number":"SJ12675541524","room_stay_from":"2021-02-14","room_stay_to":"2021-02-17","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":"111012","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-03 20:46:28","reservation_modified_date_time":"2021-01-03 22:16:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111012","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":"3181049","reservation_id":"105573","confirmation_number":"SJ12696232040","room_confirmation_number":"SJ12631617816","room_stay_from":"2021-02-13","room_stay_to":"2021-02-17","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":"111994","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 21:21:09","reservation_modified_date_time":"2021-01-18 21:21:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111994","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":"3189402","reservation_id":"105223","confirmation_number":"SJ12663188568","room_confirmation_number":"SJ12629157266","room_stay_from":"2021-02-14","room_stay_to":"2021-02-17","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":"111605","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-12 16:23:26","reservation_modified_date_time":"2021-02-01 19:22:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111605","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":"3194563","reservation_id":"105379","confirmation_number":"SJ12676524481","room_confirmation_number":"SJ12643756097","room_stay_from":"2021-02-13","room_stay_to":"2021-02-17","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":"111772","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 17:20:05","reservation_modified_date_time":"2021-02-09 01:54:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111772","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":"3196299","reservation_id":"102037","confirmation_number":"SJ12635837150","room_confirmation_number":"SJ12657555655","room_stay_from":"2021-02-11","room_stay_to":"2021-02-17","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":"108156","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 15:53:08","reservation_modified_date_time":"2021-02-12 15:10:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108156","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":"3189262","reservation_id":"103865","confirmation_number":"SJ12661021633","room_confirmation_number":"SJ12666352371","room_stay_from":"2021-02-13","room_stay_to":"2021-02-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110145","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-16 02:20:32","reservation_modified_date_time":"2021-02-01 18:13: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":"3190698","reservation_id":"103376","confirmation_number":"SJ12627522425","room_confirmation_number":"SJ12672040273","room_stay_from":"2021-02-13","room_stay_to":"2021-02-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109554","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-02 00:51:10","reservation_modified_date_time":"2021-02-02 22:42:23","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":"3191367","reservation_id":"106864","confirmation_number":"SJ12640296141","room_confirmation_number":"SJ12637675076","room_stay_from":"2021-02-14","room_stay_to":"2021-02-18","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":"113294","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 02:55:09","reservation_modified_date_time":"2021-02-04 02:55:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113294","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":"3194567","reservation_id":"106232","confirmation_number":"SJ12670451759","room_confirmation_number":"SJ12651106976","room_stay_from":"2021-02-14","room_stay_to":"2021-02-18","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":"112639","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 03:41:06","reservation_modified_date_time":"2021-02-09 01:55:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112639","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":"3197156","reservation_id":"107347","confirmation_number":"SJ12664927301","room_confirmation_number":"SJ12675529089","room_stay_from":"2021-02-13","room_stay_to":"2021-02-18","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":"113804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 16:23:50","reservation_modified_date_time":"2021-02-13 04:22:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113804","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":"3180216","reservation_id":"105493","confirmation_number":"SJ12651848879","room_confirmation_number":"SJ12626754804","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","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":"111908","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 04:06:13","reservation_modified_date_time":"2021-01-17 04:06:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111908","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":"3184695","reservation_id":"106146","confirmation_number":"SJ12612425234","room_confirmation_number":"SJ12653125261","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","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":"112559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 04:52:12","reservation_modified_date_time":"2021-01-26 04:52:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112559","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":"3186820","reservation_id":"106393","confirmation_number":"SJ12680825181","room_confirmation_number":"SJ12690110347","room_stay_from":"2021-02-14","room_stay_to":"2021-02-19","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":"112789","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 03:45:19","reservation_modified_date_time":"2021-01-29 03:45:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112789","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":"3194672","reservation_id":"103347","confirmation_number":"SJ12661236710","room_confirmation_number":"SJ12673829867","room_stay_from":"2021-02-10","room_stay_to":"2021-02-19","room_stay_status":"Active","nightly_price":"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","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"109517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-01 16:14:10","reservation_modified_date_time":"2021-02-09 14:47:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109517","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":"3196970","reservation_id":"104916","confirmation_number":"SJ12610341990","room_confirmation_number":"SJ12681820157","room_stay_from":"2021-02-12","room_stay_to":"2021-02-19","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":"111271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 00:59:32","reservation_modified_date_time":"2021-02-12 22:00:21","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":"3197320","reservation_id":"105062","confirmation_number":"SJ12646977340","room_confirmation_number":"SJ12664604647","room_stay_from":"2021-02-12","room_stay_to":"2021-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"111437","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 17:28:12","reservation_modified_date_time":"2021-02-13 15:54:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111437","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":"3146781","reservation_id":"98514","confirmation_number":"SJ12619493059","room_confirmation_number":"SJ12695243467","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","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":"104542","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-02 22:21:26","reservation_modified_date_time":"2020-10-17 22:06: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":"3153912","reservation_id":"102511","confirmation_number":"SJ12679640377","room_confirmation_number":"SJ12696497632","room_stay_from":"2021-02-12","room_stay_to":"2021-02-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108675","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-11 01:23:10","reservation_modified_date_time":"2020-11-11 01:23:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108675","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":"3174593","reservation_id":"102933","confirmation_number":"SJ12695918727","room_confirmation_number":"SJ12652571265","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"109063","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-21 15:18:11","reservation_modified_date_time":"2021-01-05 19:36:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109063","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":"3176020","reservation_id":"102755","confirmation_number":"SJ12686932094","room_confirmation_number":"SJ12686818505","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","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":"108897","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 01:31:17","reservation_modified_date_time":"2021-01-08 02:03:39","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":"3176860","reservation_id":"105093","confirmation_number":"SJ12697079529","room_confirmation_number":"SJ12690112213","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"111471","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 22:01:06","reservation_modified_date_time":"2021-01-09 22:01:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111471","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":"3183490","reservation_id":"105968","confirmation_number":"SJ12619108221","room_confirmation_number":"SJ12648021718","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112395","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 03:03:50","reservation_modified_date_time":"2021-01-24 03:03:50","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186354","reservation_id":"106338","confirmation_number":"SJ12665594127","room_confirmation_number":"SJ12666067522","room_stay_from":"2021-02-14","room_stay_to":"2021-02-20","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":"112728","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 16:59:14","reservation_modified_date_time":"2021-01-28 16:59:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112728","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":"3189415","reservation_id":"106610","confirmation_number":"SJ12641130327","room_confirmation_number":"SJ12644422067","room_stay_from":"2021-02-14","room_stay_to":"2021-02-20","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":"0.02","product_id":"1776","service_quantity":"1","customer_traveller_id":"113032","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 13:48:49","reservation_modified_date_time":"2021-02-01 19:23:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113032","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":"3190773","reservation_id":"95527","confirmation_number":"SJ12667262251","room_confirmation_number":"SJ12661587211","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","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":"101714","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 13:40:02","reservation_modified_date_time":"2021-02-02 22:54:54","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":"3197152","reservation_id":"99342","confirmation_number":"SJ12656907282","room_confirmation_number":"SJ12634121142","room_stay_from":"2021-02-14","room_stay_to":"2021-02-20","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":"105327","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-21 23:57:10","reservation_modified_date_time":"2021-02-13 04:21:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105327","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":"3197826","reservation_id":"104822","confirmation_number":"SJ12689891796","room_confirmation_number":"SJ12659421932","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111169","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 23:41:06","reservation_modified_date_time":"2021-02-14 13:54:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111169","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-25.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3195211","reservation_id":"104483","confirmation_number":"SJ12631236047","room_confirmation_number":"SJ12616746915","room_stay_from":"2021-02-14","room_stay_to":"2021-02-21","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":"110834","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 19:31:27","reservation_modified_date_time":"2021-02-10 11:41:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77106","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":"3197719","reservation_id":"93105","confirmation_number":"SJ12668292161","room_confirmation_number":"SJ12679962701","room_stay_from":"2021-02-13","room_stay_to":"2021-02-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99301","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-08 15:59:08","reservation_modified_date_time":"2021-02-13 23:48:34","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99301","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":"3189342","reservation_id":"106562","confirmation_number":"SJ12674501286","room_confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:54:06","reservation_modified_date_time":"2021-02-01 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101703","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3198017","reservation_id":"105807","confirmation_number":"SJ12689161279","room_confirmation_number":"SJ12664568502","room_stay_from":"2021-05-12","room_stay_to":"2021-05-15","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112212","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 20:50:13","reservation_modified_date_time":"2021-02-14 19:37:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112212","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3188636","reservation_id":"106559","confirmation_number":"SJ12617649365","room_confirmation_number":"SJ12680044581","room_stay_from":"2021-02-13","room_stay_to":"2021-02-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112977","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:27:32","reservation_modified_date_time":"2021-01-31 18:32:48","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gift_shop_taxable":[{"room_stay_id":"3198001","reservation_id":"107618","confirmation_number":"SJ12665030878","room_confirmation_number":"SJ12672420987","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-14 19:08:52","reservation_modified_date_time":"2021-02-14 19:08:52","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":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3198139","reservation_id":"107637","confirmation_number":"SJ12646662522","room_confirmation_number":"SJ12621318372","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"5.00","paid_amount":"5.00","product_id":"1660","service_quantity":"2","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-14 22:38:56","reservation_modified_date_time":"2021-02-14 22:38:56","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":"4.66","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3198171","reservation_id":"107642","confirmation_number":"SJ12620173960","room_confirmation_number":"SJ12647500153","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-14 23:35:05","reservation_modified_date_time":"2021-02-14 23:35:05","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}