{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-01","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,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":28,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942,1262,1943","block_room_bookings":[{"confirmation_number":"SJ12622180244","room_stay_from":"2020-02-29","room_stay_to":"2020-03-09","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-03-27","bundle_room":"0"}],"bundle_block_count":"1267,1268,1269,1270,1311,1312,1307,1308,1304,1305,1262,1263,1271,1272,1309,1310,1260,1261","bundle_block_bookings":[{"confirmation_number":"SJB12687450791","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","bundle_room":"1"},{"confirmation_number":"SJB12652721664","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","bundle_room":"1"},{"confirmation_number":"SJB12697953544","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","bundle_room":"1"},{"confirmation_number":"SJB12675733452","room_stay_from":"2020-02-29","room_stay_to":"2020-03-02","bundle_room":"1"},{"confirmation_number":"SJB12690552611","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","bundle_room":"1"},{"confirmation_number":"SJB12657689389","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","bundle_room":"1"},{"confirmation_number":"SJB12682051540","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","bundle_room":"1"},{"confirmation_number":"SJB12683586347","room_stay_from":"2020-02-29","room_stay_to":"2020-03-03","bundle_room":"1"},{"confirmation_number":"SJB12671735907","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3068812","reservation_id":"91779","confirmation_number":"SJ12679370654","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129,210,210,129","nightly_discount":"0,0,0,0","subtotal":"678.00","grand_total":"762.75","paid_amount":"762.75","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3282462393","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97924","customer_id":"97924","source_of_creation":"Booking.com","reservation_created_date":"2020-02-11 13:21:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"178.29","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"129","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":"3072717","reservation_id":"90704","confirmation_number":"SJ12693727088","room_stay_from":"2020-02-29","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"143.5,111.1","nightly_discount":"0,0","subtotal":"254.60","grand_total":"286.43","paid_amount":"286.43","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3239197535","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96787","customer_id":"96787","source_of_creation":"Booking.com","reservation_created_date":"2020-01-27 19:27:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"73.95","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"111.1","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":"3075828","reservation_id":"91438","confirmation_number":"SJ12621517484","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"210,210,129","nightly_discount":"0,0,0","subtotal":"549.00","grand_total":"617.63","paid_amount":"617.63","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-3052583306","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98881","customer_id":"98881","source_of_creation":"Booking.com","reservation_created_date":"2020-02-06 19:26:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"70.50","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"129","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":"3076911","reservation_id":"91426","confirmation_number":"SJ12675457814","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"154","nightly_discount":"0","subtotal":"154.00","grand_total":"173.25","paid_amount":"173.25","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2487401878","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98979","customer_id":"98979","source_of_creation":"Booking.com","reservation_created_date":"2020-02-06 18:15:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"37.28","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"154","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":"3076941","reservation_id":"91826","confirmation_number":"SJ12643694528","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"154","nightly_discount":"0","subtotal":"154.00","grand_total":"173.25","paid_amount":"173.25","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2840981076","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98984","customer_id":"98984","source_of_creation":"Booking.com","reservation_created_date":"2020-02-12 01:00:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"37.28","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"154","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":"3077031","reservation_id":"92856","confirmation_number":"SJ12697419094","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"154","nightly_discount":"0","subtotal":"154.00","grand_total":"173.25","paid_amount":"173.25","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3509205064","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99008","customer_id":"99008","source_of_creation":"Booking.com","reservation_created_date":"2020-03-02 04:23:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"36.72","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"154","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":"3076543","reservation_id":"92713","confirmation_number":"SJ12652897423","room_stay_from":"2020-02-29","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,210.00,210.00","nightly_discount":"0,0,0","subtotal":"630.00","grand_total":"708.75","paid_amount":"708.75","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-2464167536","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":"98858","customer_id":"98858","source_of_creation":"Booking.com","reservation_created_date":"2020-02-28 14:18:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"84.60","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"210.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":"3076913","reservation_id":"91180","confirmation_number":"SJ12642333985","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.10,161.10","nightly_discount":"0,0","subtotal":"322.20","grand_total":"362.48","paid_amount":"362.48","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3141451923","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":"98980","customer_id":"98980","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 23:27:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"68.12","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"161.10","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":"3076944","reservation_id":"91741","confirmation_number":"SJ12692808909","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"111.1,111.1","nightly_discount":"0,0","subtotal":"222.20","grand_total":"249.98","paid_amount":"249.98","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3544231269","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98985","customer_id":"98985","source_of_creation":"Booking.com","reservation_created_date":"2020-02-10 20:39:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"68.12","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"111.1","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":"3076964","reservation_id":"91442","confirmation_number":"SJ12695173338","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3231631146","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":"98989","customer_id":"98989","source_of_creation":"Booking.com","reservation_created_date":"2020-02-06 19:58:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"86.26","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"211.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076994","reservation_id":"91575","confirmation_number":"SJ12633661809","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"111.1,111.1","nightly_discount":"0,0","subtotal":"222.20","grand_total":"249.98","paid_amount":"249.98","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-2370573104","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98995","customer_id":"98995","source_of_creation":"Booking.com","reservation_created_date":"2020-02-08 16:19:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"68.12","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"111.1","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":"3069170","reservation_id":"91859","confirmation_number":"SJ12645272510","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1640341016","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":"98007","customer_id":"98007","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 16:44:10","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","currentDayPrice":"143.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":"3073159","reservation_id":"91774","confirmation_number":"SJ12617520566","room_stay_from":"2020-02-26","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,215.28,215.28,169.20","nightly_discount":"0,0,0,0,0","subtotal":"938.16","grand_total":"1055.43","paid_amount":"1055.43","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1639387006","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":"97919","customer_id":"97919","source_of_creation":"Expedia","reservation_created_date":"2020-02-11 04:19:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.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":"3075412","reservation_id":"92335","confirmation_number":"SJ12663088048","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"176.6,194.6,194.6,176.6","nightly_discount":"0,0,0,0","subtotal":"742.40","grand_total":"835.20","paid_amount":"835.20","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1646252802","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"125.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98514","customer_id":"98514","source_of_creation":"Expedia","reservation_created_date":"2020-02-21 23:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"148.48","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"176.6","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":"3075830","reservation_id":"91680","confirmation_number":"SJ12677024239","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.10,269.10,211.50","nightly_discount":"0,0,0","subtotal":"749.70","grand_total":"843.42","paid_amount":"843.42","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1638584283","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":"98882","customer_id":"98882","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 23:43:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"211.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076863","reservation_id":"91145","confirmation_number":"SJ12671344916","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1634237517","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":"97271","customer_id":"97271","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 18:38:07","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","currentDayPrice":"143.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":"3066424","reservation_id":"91398","confirmation_number":"SJ12670459178","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20","nightly_discount":"0,0","subtotal":"338.40","grand_total":"380.70","paid_amount":"380.70","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1636322857","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":"97526","customer_id":"97526","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 01:48:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.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":"3070550","reservation_id":"92070","confirmation_number":"SJ12611935356","room_stay_from":"2020-02-27","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,201.60,201.60,183.60,183.60","nightly_discount":"0,0,0,0,0","subtotal":"954.00","grand_total":"1073.25","paid_amount":"1073.25","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1642949322","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":"98245","customer_id":"98245","source_of_creation":"Expedia","reservation_created_date":"2020-02-16 22:54:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"183.60","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":"3062774","reservation_id":"90798","confirmation_number":"SJ12694518161","room_stay_from":"2020-03-01","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20","nightly_discount":"0,0,0","subtotal":"429.60","grand_total":"483.30","paid_amount":"483.30","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1631400107","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":"96883","customer_id":"96883","source_of_creation":"Expedia","reservation_created_date":"2020-01-28 19:28:10","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","currentDayPrice":"143.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":"3073322","reservation_id":"92418","confirmation_number":"SJ12615042752","room_stay_from":"2020-02-28","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,201.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0,0","subtotal":"954.00","grand_total":"1073.25","paid_amount":"1073.25","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1647034004","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":"98593","customer_id":"98593","source_of_creation":"Expedia","reservation_created_date":"2020-02-23 14:53:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"183.60","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":"3076110","reservation_id":"92752","confirmation_number":"SJ12663054518","room_stay_from":"2020-02-29","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0","subtotal":"752.40","grand_total":"846.45","paid_amount":"846.45","room_type_id":"319","product_id":"1307","siteminder_id":"EXP-1650665381","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":"98899","customer_id":"98899","source_of_creation":"Expedia","reservation_created_date":"2020-02-29 14:34:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"183.60","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":"3076551","reservation_id":"91070","confirmation_number":"SJ12655555333","room_stay_from":"2020-02-29","room_stay_to":"2020-03-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00,211.50,211.50,211.50,211.50","nightly_discount":"0,0,0,0,0","subtotal":"1080.00","grand_total":"1215.00","paid_amount":"1215.00","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1633766207","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":"97183","customer_id":"97183","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 18:53:10","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","currentDayPrice":"211.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3055197","reservation_id":"86752","confirmation_number":"SJ12617303084","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.80,230.40,230.40,230.40,230.40,230.40,272.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1697.60","grand_total":"1909.80","paid_amount":"1909.80","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1375501820","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":"93421","customer_id":"93421","source_of_creation":"Expedia","reservation_created_date":"2019-11-06 16:30:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"230.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":"3076697","reservation_id":"92142","confirmation_number":"SJ12621983225","room_stay_from":"2020-02-27","room_stay_to":"2020-03-01","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.50,252.00,481.50","nightly_discount":"0.00,0.00,0.00","subtotal":"963.00","grand_total":"1083.38","paid_amount":"1083.38","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1644066216","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":"98321","customer_id":"98321","source_of_creation":"Expedia","reservation_created_date":"2020-02-18 16:54:17","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","changedComment":"To date changed","deltaChange":"229.50","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3076480","reservation_id":"92797","confirmation_number":"SJ12675364055","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00","nightly_discount":"0.00","subtotal":"210.00","grand_total":"236.25","paid_amount":"236.25","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98945","customer_id":"98945","source_of_creation":"PMS","reservation_created_date":"2020-02-29 23:09:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"210.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":"3076975","reservation_id":"92840","confirmation_number":"SJ12692261635","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","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":"98990","customer_id":"98990","source_of_creation":"PMS","reservation_created_date":"2020-03-01 23:23:10","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","currentDayPrice":"179.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":"3076977","reservation_id":"92841","confirmation_number":"SJ12670020181","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98991","customer_id":"98991","source_of_creation":"PMS","reservation_created_date":"2020-03-01 23:44:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"179.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":"3076500","reservation_id":"90408","confirmation_number":"SJ12696514497","room_stay_from":"2020-02-26","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,215.00,215.00,179.00,179.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1146.00","grand_total":"1289.25","paid_amount":"1317.37","room_type_id":"319","product_id":"1304","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96459","customer_id":"96459","source_of_creation":"PMS","reservation_created_date":"2020-01-23 02:02:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"179.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":"3076564","reservation_id":"92800","confirmation_number":"SJ12662228850","room_stay_from":"2020-02-29","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00","subtotal":"790.00","grand_total":"888.75","paid_amount":"888.75","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98952","customer_id":"98952","source_of_creation":"PMS","reservation_created_date":"2020-03-01 01:16:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"255.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":"3074593","reservation_id":"92590","confirmation_number":"SJ12659490433","room_stay_from":"2020-02-22","room_stay_to":"2020-03-06","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"413","product_id":"1261","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":"74162","customer_id":"74162","source_of_creation":"PMS","reservation_created_date":"2020-02-26 13:36:23","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","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":"3076791","reservation_id":"90827","confirmation_number":"SJ12697439638","room_stay_from":"2020-03-01","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00,179.00,179.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"895.00","grand_total":"1006.88","paid_amount":"1006.88","room_type_id":"413","product_id":"1273","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":"96915","customer_id":"96915","source_of_creation":"PMS","reservation_created_date":"2020-01-28 23:36:26","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"179.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3063607","reservation_id":"90536","confirmation_number":"SJ12678284131","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.71,160.71,160.71,160.71,160.72,160.72,160.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1125.00","grand_total":"1125.00","paid_amount":"0.00","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-01-25 01:27:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"160.71","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":"3060583","reservation_id":"90092","confirmation_number":"SJ12692020381","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2020-01-16 20:24:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068639","reservation_id":"91759","confirmation_number":"SJ12612193407","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-11 01:00:18","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","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068643","reservation_id":"91761","confirmation_number":"SJ12683533919","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-11 01:04:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3074364","reservation_id":"86398","confirmation_number":"SJ12650609805","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.62,127.62,127.62,127.62,127.62,127.62,127.62","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"893.34","grand_total":"1005.01","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-10-29 02:20:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"127.62","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":[],"extra_person_taxable":[{"room_stay_id":"3068813","reservation_id":"91779","confirmation_number":"SJ12673620778","room_confirmation_number":"SJ12679370654","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"97924","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-11 13:21:10","reservation_modified_date_time":"2020-02-11 13:21:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97924","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3072718","reservation_id":"90704","confirmation_number":"SJ12644751940","room_confirmation_number":"SJ12693727088","room_stay_from":"2020-02-29","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"96787","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-22 15:00:07","reservation_modified_date_time":"2020-02-22 15:00:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96787","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075414","reservation_id":"92335","confirmation_number":"SJ12661694783","room_confirmation_number":"SJ12663088048","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"98514","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-27 20:25:10","reservation_modified_date_time":"2020-02-27 20:25:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98514","canceled_nights_data":"","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":"3075826","reservation_id":"91438","confirmation_number":"SJ12660674012","room_confirmation_number":"SJ12621517484","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"98881","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-06 19:29:16","reservation_modified_date_time":"2020-02-28 22:11:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98881","canceled_nights_data":"","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"}]},{"room_stay_id":"3076909","reservation_id":"91426","confirmation_number":"SJ12621141520","room_confirmation_number":"SJ12675457814","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"98979","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-01 21:11:10","reservation_modified_date_time":"2020-03-01 21:21:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98979","canceled_nights_data":"","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":"3076939","reservation_id":"91826","confirmation_number":"SJ12611676093","room_confirmation_number":"SJ12643694528","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"98984","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-12 01:00:09","reservation_modified_date_time":"2020-03-01 22:38:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98984","canceled_nights_data":"","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":"3077032","reservation_id":"92856","confirmation_number":"SJ12625077863","room_confirmation_number":"SJ12697419094","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"99008","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-03-02 04:23:08","reservation_modified_date_time":"2020-03-02 04:23:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99008","canceled_nights_data":"","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":"3076942","reservation_id":"91741","confirmation_number":"SJ12680605427","room_confirmation_number":"SJ12692808909","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"98985","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-10 20:39:11","reservation_modified_date_time":"2020-03-01 22:41:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98985","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076992","reservation_id":"91575","confirmation_number":"SJ12693231830","room_confirmation_number":"SJ12633661809","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"98995","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-08 16:19:10","reservation_modified_date_time":"2020-03-02 01:29:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98995","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3068814","reservation_id":"91779","confirmation_number":"SJ12651409879","room_confirmation_number":"SJ12679370654","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","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":"97924","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 13:21:10","reservation_modified_date_time":"2020-02-11 13:21:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97924","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3069171","reservation_id":"91859","confirmation_number":"SJ12664859247","room_confirmation_number":"SJ12645272510","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","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":"98007","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 16:44:10","reservation_modified_date_time":"2020-02-12 16:44:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98007","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3072719","reservation_id":"90704","confirmation_number":"SJ12635563221","room_confirmation_number":"SJ12693727088","room_stay_from":"2020-02-29","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"28.12,28.12","nightly_discount":"0.00,0.00","subtotal":"56.24","grand_total":"63.27","paid_amount":"63.27","product_id":"1776","service_quantity":"1","customer_traveller_id":"96787","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-01-27 19:27:07","reservation_modified_date_time":"2020-02-22 15:00:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96787","canceled_nights_data":"","currentDayPrice":"28.12","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":"3073160","reservation_id":"91774","confirmation_number":"SJ12634953237","room_confirmation_number":"SJ12617520566","room_stay_from":"2020-02-26","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"97919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 04:19:09","reservation_modified_date_time":"2020-02-23 13:30:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97919","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075415","reservation_id":"92335","confirmation_number":"SJ12660192795","room_confirmation_number":"SJ12663088048","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","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":"98514","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 23:13:10","reservation_modified_date_time":"2020-02-27 20:25:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98514","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075827","reservation_id":"91438","confirmation_number":"SJ12627545762","room_confirmation_number":"SJ12621517484","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98881","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 19:26:07","reservation_modified_date_time":"2020-02-28 22:11:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98881","canceled_nights_data":"","currentDayPrice":"25.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":"3075829","reservation_id":"91680","confirmation_number":"SJ12690952019","room_confirmation_number":"SJ12677024239","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 23:43:07","reservation_modified_date_time":"2020-02-28 22:12:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98882","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076481","reservation_id":"92797","confirmation_number":"SJ12661304549","room_confirmation_number":"SJ12675364055","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","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":"98946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-29 23:09:52","reservation_modified_date_time":"2020-02-29 23:11:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98945","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076864","reservation_id":"91145","confirmation_number":"SJ12625944876","room_confirmation_number":"SJ12671344916","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","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":"97271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 18:38:07","reservation_modified_date_time":"2020-03-01 20:05:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97271","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076910","reservation_id":"91426","confirmation_number":"SJ12695038854","room_confirmation_number":"SJ12675457814","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","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":"98979","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 18:15:10","reservation_modified_date_time":"2020-03-01 21:21:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98979","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076940","reservation_id":"91826","confirmation_number":"SJ12627040619","room_confirmation_number":"SJ12643694528","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","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":"98984","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 01:00:09","reservation_modified_date_time":"2020-03-01 22:38:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98984","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076976","reservation_id":"92840","confirmation_number":"SJ12659649787","room_confirmation_number":"SJ12692261635","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","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":"98990","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 23:23:10","reservation_modified_date_time":"2020-03-01 23:23:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98990","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076978","reservation_id":"92841","confirmation_number":"SJ12655514448","room_confirmation_number":"SJ12670020181","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","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":"98991","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 23:44:58","reservation_modified_date_time":"2020-03-01 23:44:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98991","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077033","reservation_id":"92856","confirmation_number":"SJ12648453743","room_confirmation_number":"SJ12697419094","room_stay_from":"2020-03-01","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"28.12","nightly_discount":"0.00","subtotal":"28.12","grand_total":"31.64","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99008","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-03-02 04:23:08","reservation_modified_date_time":"2020-03-02 04:23:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99008","canceled_nights_data":"","currentDayPrice":"28.12","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":"3066425","reservation_id":"91398","confirmation_number":"SJ12652746593","room_confirmation_number":"SJ12670459178","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","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":"97526","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 01:48:10","reservation_modified_date_time":"2020-02-06 01:48:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97526","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070551","reservation_id":"92070","confirmation_number":"SJ12679160450","room_confirmation_number":"SJ12611935356","room_stay_from":"2020-02-27","room_stay_to":"2020-03-03","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":"98245","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-16 22:54:08","reservation_modified_date_time":"2020-02-16 22:54:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98245","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076502","reservation_id":"90408","confirmation_number":"SJ12623104211","room_confirmation_number":"SJ12696514497","room_stay_from":"2020-02-26","room_stay_to":"2020-03-03","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,25.00,0.00,0.00","subtotal":"150.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"96459","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 02:02:11","reservation_modified_date_time":"2020-03-01 00:01:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96459","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076544","reservation_id":"92713","confirmation_number":"SJ12672220156","room_confirmation_number":"SJ12652897423","room_stay_from":"2020-02-29","room_stay_to":"2020-03-03","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":"98858","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 14:18:11","reservation_modified_date_time":"2020-03-01 00:43:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98858","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076563","reservation_id":"92800","confirmation_number":"SJ12659839504","room_confirmation_number":"SJ12662228850","room_stay_from":"2020-02-29","room_stay_to":"2020-03-03","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":"98952","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 01:16:20","reservation_modified_date_time":"2020-03-01 01:29:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98952","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076912","reservation_id":"91180","confirmation_number":"SJ12635190629","room_confirmation_number":"SJ12642333985","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","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":"98980","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 23:27:09","reservation_modified_date_time":"2020-03-01 21:31:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98980","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076943","reservation_id":"91741","confirmation_number":"SJ12693789208","room_confirmation_number":"SJ12692808909","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","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":"98985","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-10 20:39:11","reservation_modified_date_time":"2020-03-01 22:41:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98985","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076963","reservation_id":"91442","confirmation_number":"SJ12638887830","room_confirmation_number":"SJ12695173338","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","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":"98989","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 19:58:08","reservation_modified_date_time":"2020-03-01 23:06:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98989","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076993","reservation_id":"91575","confirmation_number":"SJ12679647081","room_confirmation_number":"SJ12633661809","room_stay_from":"2020-03-01","room_stay_to":"2020-03-03","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":"98995","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 16:19:10","reservation_modified_date_time":"2020-03-02 01:29:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98995","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3062775","reservation_id":"90798","confirmation_number":"SJ12699435082","room_confirmation_number":"SJ12694518161","room_stay_from":"2020-03-01","room_stay_to":"2020-03-04","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":"96883","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 19:28:10","reservation_modified_date_time":"2020-01-28 19:28:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96883","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073323","reservation_id":"92418","confirmation_number":"SJ12643420486","room_confirmation_number":"SJ12615042752","room_stay_from":"2020-02-28","room_stay_to":"2020-03-04","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":"98593","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-23 14:53:06","reservation_modified_date_time":"2020-02-23 14:53:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98593","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076112","reservation_id":"92752","confirmation_number":"SJ12681944020","room_confirmation_number":"SJ12663054518","room_stay_from":"2020-02-29","room_stay_to":"2020-03-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98899","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-29 14:34:11","reservation_modified_date_time":"2020-02-29 15:14:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98899","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076553","reservation_id":"91070","confirmation_number":"SJ12682490106","room_confirmation_number":"SJ12655555333","room_stay_from":"2020-02-29","room_stay_to":"2020-03-05","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":"97183","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 18:53:10","reservation_modified_date_time":"2020-03-01 01:00:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97183","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063608","reservation_id":"90536","confirmation_number":"SJ12691035339","room_confirmation_number":"SJ12678284131","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","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":"96598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 01:27:28","reservation_modified_date_time":"2020-01-30 17:52:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074363","reservation_id":"86398","confirmation_number":"SJ12663775501","room_confirmation_number":"SJ12650609805","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","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":"95414","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-29 02:20:04","reservation_modified_date_time":"2020-02-25 23:12:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074594","reservation_id":"92590","confirmation_number":"SJ12696987483","room_confirmation_number":"SJ12659490433","room_stay_from":"2020-02-22","room_stay_to":"2020-03-06","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 13:36:23","reservation_modified_date_time":"2020-02-26 14:14:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74162","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076792","reservation_id":"90827","confirmation_number":"SJ12658880324","room_confirmation_number":"SJ12697439638","room_stay_from":"2020-03-01","room_stay_to":"2020-03-06","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":"96915","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 23:36:26","reservation_modified_date_time":"2020-03-01 17:54:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96915","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"3055199","reservation_id":"86752","confirmation_number":"SJ12661253646","room_confirmation_number":"SJ12617303084","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"93421","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-06 16:30:10","reservation_modified_date_time":"2019-11-06 16:30:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93421","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3060584","reservation_id":"90092","confirmation_number":"SJ12690545263","room_confirmation_number":"SJ12692020381","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"96124","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-16 20:24:40","reservation_modified_date_time":"2020-01-16 20:24:40","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068640","reservation_id":"91759","confirmation_number":"SJ12618322882","room_confirmation_number":"SJ12612193407","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"96904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 01:00:18","reservation_modified_date_time":"2020-02-11 01:00:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068644","reservation_id":"91761","confirmation_number":"SJ12647559783","room_confirmation_number":"SJ12683533919","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"97903","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 01:04:41","reservation_modified_date_time":"2020-02-11 01:04:41","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076698","reservation_id":"92142","confirmation_number":"SJ12638326094","room_confirmation_number":"SJ12621983225","room_stay_from":"2020-02-27","room_stay_to":"2020-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98321","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-18 16:54:17","reservation_modified_date_time":"2020-03-01 15:27:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98321","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3076680","reservation_id":"92142","confirmation_number":"SJ12650327616","room_confirmation_number":"SJ12621983225","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.12","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-01 15:25:37","reservation_modified_date_time":"2020-03-01 15:25:37","customer_id":"98321","parentCustTravId":"98321","customer_traveller_id":"98321","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076615","reservation_id":"92808","confirmation_number":"SJ12683032666","room_confirmation_number":"SJ12686087595","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"29.99","grand_total":"32.24","paid_amount":"32.24","product_id":null,"service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-01 14:03:00","reservation_modified_date_time":"2020-03-01 14:03:00","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,"currentDayPrice":"29.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3076726","reservation_id":"92815","confirmation_number":"SJ12690377763","room_confirmation_number":"SJ12690709070","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.88","paid_amount":"26.88","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-01 16:11:34","reservation_modified_date_time":"2020-03-01 16:11:34","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,"currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3076859","reservation_id":"92827","confirmation_number":"SJ12699522045","room_confirmation_number":"SJ12637211607","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":null,"service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-01 20:01:13","reservation_modified_date_time":"2020-03-01 20:01:13","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,"currentDayPrice":"2.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}