{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-04","total_rooms_exist":"1281,1282,1289,1274,1275,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":8,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1264,1307,1943,1305","block_room_bookings":[{"confirmation_number":"SJ12637517785","room_stay_from":"2020-07-03","room_stay_to":"2020-07-08","bundle_room":"0"},{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-07","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"},{"confirmation_number":"SJ12612307368","room_stay_from":"2020-06-29","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1269,1270,1271,1272,1311,1312,1262,1263,1267,1268,1260,1261,1291,1711,1309,1310,1302,1303,1304,1305,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12644339714","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12655915245","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12660798417","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12662269070","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12657141702","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","bundle_room":"1"},{"confirmation_number":"SJB12660037514","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","bundle_room":"1"},{"confirmation_number":"SJB12642303387","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","bundle_room":"1"},{"confirmation_number":"SJB12677069384","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","bundle_room":"0"},{"confirmation_number":"SJB12666372824","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","bundle_room":"0"},{"confirmation_number":"SJB12647804168","room_stay_from":"2020-07-04","room_stay_to":"2020-07-07","bundle_room":"1"},{"confirmation_number":"SJB12616638718","room_stay_from":"2020-06-29","room_stay_to":"2020-07-13","bundle_room":"1"},{"confirmation_number":"SJB12647698945","room_stay_from":"2020-06-29","room_stay_to":"2020-07-28","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3083253","reservation_id":"93480","confirmation_number":"SJ12643889829","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"199,179,259,259","nightly_discount":"0,0,0,0","subtotal":"896.00","grand_total":"1008.00","paid_amount":"1008.00","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2985554637","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":"99706","customer_id":"99706","source_of_creation":"Booking.com","reservation_created_date":"2020-03-18 02:22:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"197.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"259","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":"3110696","reservation_id":"97196","confirmation_number":"SJ12635438453","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"358.40,358.40","nightly_discount":"0,0","subtotal":"716.80","grand_total":"806.40","paid_amount":"806.40","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3759789891","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":"103297","customer_id":"103297","source_of_creation":"Booking.com","reservation_created_date":"2020-06-28 20:02:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"138.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"358.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":"3111089","reservation_id":"97050","confirmation_number":"SJ12693051696","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,307.20","nightly_discount":"0,0","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2526995150","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":"103170","customer_id":"103170","source_of_creation":"Booking.com","reservation_created_date":"2020-06-25 00:06:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"122.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"307.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":"3111158","reservation_id":"97079","confirmation_number":"SJ12699145726","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,320.80,320.80","nightly_discount":"0,0,0","subtotal":"962.40","grand_total":"1082.70","paid_amount":"1082.70","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3308784239","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":"103200","customer_id":"103200","source_of_creation":"Booking.com","reservation_created_date":"2020-06-25 22:00:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"186.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"320.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":"3111163","reservation_id":"97205","confirmation_number":"SJ12614842282","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"358.40,358.40","nightly_discount":"0,0","subtotal":"716.80","grand_total":"806.40","paid_amount":"806.40","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-2344145997","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":"103307","customer_id":"103307","source_of_creation":"Booking.com","reservation_created_date":"2020-06-29 00:33:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"138.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"358.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":"3111692","reservation_id":"97098","confirmation_number":"SJ12684370690","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"340.80,340.80,340.80","nightly_discount":"0.00,0.00,0.00","subtotal":"1022.40","grand_total":"1150.20","paid_amount":"1150.20","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3975647963","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":"103218","customer_id":"103218","source_of_creation":"Booking.com","reservation_created_date":"2020-06-26 02:55:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"98.77","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"340.80","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":"3111823","reservation_id":"95925","confirmation_number":"SJ12670257455","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.20,336.80,336.80","nightly_discount":"0,0,0","subtotal":"868.80","grand_total":"977.40","paid_amount":"977.40","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2789570535","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":"102069","customer_id":"102069","source_of_creation":"Booking.com","reservation_created_date":"2020-06-05 00:58:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"169.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"336.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":"3112213","reservation_id":"97339","confirmation_number":"SJ12646909661","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,320.80","nightly_discount":"0,0","subtotal":"641.60","grand_total":"721.80","paid_amount":"721.80","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-3821410290","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":"103424","customer_id":"103424","source_of_creation":"Booking.com","reservation_created_date":"2020-07-03 15:20:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"62.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"320.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":"3112611","reservation_id":"97394","confirmation_number":"SJ12662026437","room_stay_from":"2020-07-04","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"315.8","nightly_discount":"0","subtotal":"315.80","grand_total":"355.28","paid_amount":"355.28","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3082083317","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":"103481","customer_id":"103481","source_of_creation":"Booking.com","reservation_created_date":"2020-07-04 21:33:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"65.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"315.8","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":"3103075","reservation_id":"96016","confirmation_number":"SJ12670455624","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"312.4,312.4,153.2","nightly_discount":"0,0,0","subtotal":"778.00","grand_total":"875.25","paid_amount":"875.25","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3861001962","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":"102149","customer_id":"102149","source_of_creation":"Booking.com","reservation_created_date":"2020-06-06 21:59:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"180.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"312.4","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":"3111154","reservation_id":"97240","confirmation_number":"SJ12611861826","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"288.72,241.92","nightly_discount":"0,0","subtotal":"530.64","grand_total":"596.97","paid_amount":"596.97","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2968004607","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":"103341","customer_id":"103341","source_of_creation":"Booking.com","reservation_created_date":"2020-06-30 14:38:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"104.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"288.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111414","reservation_id":"97249","confirmation_number":"SJ12630744264","room_stay_from":"2020-07-02","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,320.80,268.80,268.80","nightly_discount":"0,0,0,0","subtotal":"1179.20","grand_total":"1326.60","paid_amount":"1326.60","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3716259504","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":"103348","customer_id":"103348","source_of_creation":"Booking.com","reservation_created_date":"2020-06-30 18:45:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"177.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"268.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":"3112490","reservation_id":"97215","confirmation_number":"SJ12622700880","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"629.50,577.70","nightly_discount":"0.00,0.00","subtotal":"1207.20","grand_total":"1358.10","paid_amount":"1358.10","room_type_id":"320","product_id":"1910","siteminder_id":"BDC-3715545155","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103319","customer_id":"103319","source_of_creation":"Booking.com","reservation_created_date":"2020-06-29 14:36:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"226.30","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"629.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":"3110327","reservation_id":"94934","confirmation_number":"SJ12651943191","room_stay_from":"2020-07-04","room_stay_to":"2020-07-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,103.20,103.20","nightly_discount":"0,0,0","subtotal":"325.60","grand_total":"366.30","paid_amount":"366.30","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-3908288638","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":"92463","customer_id":"92463","source_of_creation":"Booking.com","reservation_created_date":"2020-05-18 02:14:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"72.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.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":"3111196","reservation_id":"95309","confirmation_number":"SJ12615497878","room_stay_from":"2020-07-03","room_stay_to":"2020-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"297.60,297.60,297.60,270.40,237.60,237.60,237.60","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1876.00","grand_total":"2110.50","paid_amount":"2110.50","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3069669247","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":"101497","customer_id":"101497","source_of_creation":"Booking.com","reservation_created_date":"2020-05-23 23:26:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"369.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"297.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3095499","reservation_id":"95126","confirmation_number":"SJ12627321751","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"139.20,139.20","nightly_discount":"0,0","subtotal":"278.40","grand_total":"313.20","paid_amount":"313.20","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1665007581","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":"101310","customer_id":"101310","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 15:56:08","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":"","currentDayPrice":"139.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":"3108036","reservation_id":"94933","confirmation_number":"SJ12665223625","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,103.20,119.20,119.20","nightly_discount":"0,0,0,0","subtotal":"444.80","grand_total":"500.40","paid_amount":"500.40","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1664579921","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":"101125","customer_id":"101125","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 02:12:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.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":"3110857","reservation_id":"95079","confirmation_number":"SJ12682756926","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56,95.36,95.36","nightly_discount":"0,0,0","subtotal":"273.28","grand_total":"307.44","paid_amount":"307.44","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1664900801","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":"101262","customer_id":"101262","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 23:21:08","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":"","currentDayPrice":"95.36","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":"3111832","reservation_id":"97300","confirmation_number":"SJ12675601843","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"335.8,335.8","nightly_discount":"0,0","subtotal":"671.60","grand_total":"755.55","paid_amount":"755.55","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1675913578","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103388","customer_id":"103388","source_of_creation":"Expedia","reservation_created_date":"2020-07-02 15:49:07","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":"","currentDayPrice":"335.8","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":"3111844","reservation_id":"97302","confirmation_number":"SJ12678380545","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.20,267.20","nightly_discount":"0,0","subtotal":"534.40","grand_total":"601.20","paid_amount":"601.20","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1675916393","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":"103389","customer_id":"103389","source_of_creation":"Expedia","reservation_created_date":"2020-07-02 15:59:09","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":"","currentDayPrice":"267.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":"3112215","reservation_id":"97080","confirmation_number":"SJ12661335718","room_stay_from":"2020-07-04","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.64","nightly_discount":"0","subtotal":"256.64","grand_total":"288.72","paid_amount":"288.72","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1673943125","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":"103202","customer_id":"103202","source_of_creation":"Expedia","reservation_created_date":"2020-06-25 22:53:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"256.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":"3112237","reservation_id":"95123","confirmation_number":"SJ12675573985","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"139.20,139.20","nightly_discount":"0,0","subtotal":"278.40","grand_total":"313.20","paid_amount":"313.20","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1665004138","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":"101307","customer_id":"101307","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 15:32:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.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":"3112288","reservation_id":"95125","confirmation_number":"SJ12686545684","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"139.20,139.20","nightly_discount":"0,0","subtotal":"278.40","grand_total":"313.20","paid_amount":"313.20","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1665007446","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":"101309","customer_id":"101309","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 15:52:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.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":"3093080","reservation_id":"94698","confirmation_number":"SJ12668445244","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.20,151.20,215.20,215.20,151.20","nightly_discount":"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":"EXP-1663752372","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":"100898","customer_id":"100898","source_of_creation":"Expedia","reservation_created_date":"2020-05-12 13:31:13","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":"","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":"3108034","reservation_id":"94697","confirmation_number":"SJ12644261210","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.20,151.20,215.20,215.20,151.20","nightly_discount":"0,0,0,0,0","subtotal":"884.00","grand_total":"994.50","paid_amount":"994.50","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1663752600","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":"100897","customer_id":"100897","source_of_creation":"Expedia","reservation_created_date":"2020-05-12 13:31:08","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":"","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":"3109917","reservation_id":"97102","confirmation_number":"SJ12624140200","room_stay_from":"2020-07-03","room_stay_to":"2020-07-07","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"285.2,285.2,233.2,233.2","nightly_discount":"0,0,0,0","subtotal":"1036.80","grand_total":"1166.40","paid_amount":"1166.40","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1674092968","collect_which":"channel_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":"103222","customer_id":"103222","source_of_creation":"Expedia","reservation_created_date":"2020-06-26 12:52:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"285.2","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":[{"room_stay_id":"3111745","reservation_id":"97289","confirmation_number":"SJ12671479455","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00","nightly_discount":"0.00,0.00","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","room_type_id":"318","product_id":"1282","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103381","customer_id":"103381","source_of_creation":"FE","reservation_created_date":"2020-07-02 01:24:14","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":"","currentDayPrice":"314.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":"3112378","reservation_id":"97317","confirmation_number":"SJ12662534602","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"349.00,349.00,254.80","nightly_discount":"0.00,0.00,0.00","subtotal":"952.80","grand_total":"1071.90","paid_amount":"1071.90","room_type_id":"411","product_id":"1296","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":"103398","customer_id":"103398","source_of_creation":"FE","reservation_created_date":"2020-07-02 20:13:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"349.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":"3111084","reservation_id":"96458","confirmation_number":"SJ12689515637","room_stay_from":"2020-07-03","room_stay_to":"2020-07-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"411.07,411.07,274.97,240.91,190.45,190.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1718.92","grand_total":"1933.79","paid_amount":"1933.79","room_type_id":"413","product_id":"1262","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":"102567","customer_id":"102567","source_of_creation":"FE","reservation_created_date":"2020-06-13 22:34:59","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":"","currentDayPrice":"411.07","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":"3111254","reservation_id":"97255","confirmation_number":"SJ12643263177","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00","nightly_discount":"0.00,0.00","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","room_type_id":"319","product_id":"1274","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":"103355","customer_id":"103355","source_of_creation":"PMS","reservation_created_date":"2020-06-30 23:31:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"314.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":"3111358","reservation_id":"97048","confirmation_number":"SJ12653334111","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00","nightly_discount":"31.40,31.40","subtotal":"628.00","grand_total":"635.85","paid_amount":"635.85","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103168","customer_id":"103168","source_of_creation":"PMS","reservation_created_date":"2020-06-24 21:45:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"314.00","currentDayDiscount":"31.40","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111677","reservation_id":"97288","confirmation_number":"SJ12665815266","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"278.75,278.75,278.75","nightly_discount":"0.00,0.00,0.00","subtotal":"836.25","grand_total":"940.78","paid_amount":"940.78","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":"103379","customer_id":"103379","source_of_creation":"PMS","reservation_created_date":"2020-07-02 00:12:38","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":"","currentDayPrice":"278.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":"3112235","reservation_id":"97226","confirmation_number":"SJ12647154240","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.00,301.00","nightly_discount":"0.00,0.00","subtotal":"602.00","grand_total":"677.25","paid_amount":"677.25","room_type_id":"319","product_id":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103328","customer_id":"103328","source_of_creation":"PMS","reservation_created_date":"2020-06-29 19:47:04","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":"","currentDayPrice":"301.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":"3112286","reservation_id":"97255","confirmation_number":"SJ12650790614","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00","nightly_discount":"0.00,0.00","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","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":"103355","customer_id":"103355","source_of_creation":"PMS","reservation_created_date":"2020-06-30 23:31:58","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":"","currentDayPrice":"314.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":"3111804","reservation_id":"97018","confirmation_number":"SJ12626792344","room_stay_from":"2020-07-02","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.15,344.60,344.60,189.05","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1076.40","grand_total":"1210.95","paid_amount":"1210.95","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":"103194","customer_id":"103194","source_of_creation":"PMS","reservation_created_date":"2020-06-24 00:24:18","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":"","currentDayPrice":"344.60","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":"3112210","reservation_id":"96943","confirmation_number":"SJ12638886185","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"342.18,198.16","nightly_discount":"0.00,0.00","subtotal":"540.34","grand_total":"607.89","paid_amount":"607.89","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":"103067","customer_id":"103067","source_of_creation":"PMS","reservation_created_date":"2020-06-22 18:00:39","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":"","currentDayPrice":"342.18","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":"3112291","reservation_id":"95861","confirmation_number":"SJ12689745534","room_stay_from":"2020-07-01","room_stay_to":"2020-07-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.74,175.65,262.59,262.59,175.65,175.65,138.85","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1343.72","grand_total":"1511.69","paid_amount":"1511.69","room_type_id":"413","product_id":"1263","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102017","customer_id":"102017","source_of_creation":"PMS","reservation_created_date":"2020-06-03 17:20:31","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":"","currentDayPrice":"262.59","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":"3112382","reservation_id":"96447","confirmation_number":"SJ12629074751","room_stay_from":"2020-07-03","room_stay_to":"2020-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"303.30,303.30,202.88,202.88,160.38,160.38,160.38","nightly_discount":"30.33,30.33,20.28,20.28,16.03,16.03,16.03","subtotal":"1493.50","grand_total":"1512.21","paid_amount":"1315.34","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"102558","customer_id":"102558","source_of_creation":"PMS","reservation_created_date":"2020-06-13 20:39:15","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"303.30","currentDayDiscount":"30.33","productIsTaxExempt":false,"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":"3109070","reservation_id":"96547","confirmation_number":"SJ12681847899","room_stay_from":"2020-06-28","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.58,103.57,103.57,103.57,103.57,103.57,103.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:34:58","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":"","currentDayPrice":"103.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":"3112555","reservation_id":"96195","confirmation_number":"SJ12629837504","room_stay_from":"2020-07-04","room_stay_to":"2020-07-11","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":"1756","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-06-09 23:39:12","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":"","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":"3111328","reservation_id":"95407","confirmation_number":"SJ12682763247","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"475.00","grand_total":"534.38","paid_amount":"140.63","room_type_id":"319","product_id":"1291","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":"2020-05-26 13:51: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":"","currentDayPrice":"95.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":"3106329","reservation_id":"96660","confirmation_number":"SJ12621284119","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 22:19:35","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.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":"3110854","reservation_id":"96779","confirmation_number":"SJ12617605836","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-18 16:56:33","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":"","currentDayPrice":"78.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":"3111193","reservation_id":"96843","confirmation_number":"SJ12675320412","room_stay_from":"2020-06-30","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"319","product_id":"1303","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-06-20 01:40:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.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":"3102481","reservation_id":"95468","confirmation_number":"SJ12622106885","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"413","product_id":"1270","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-27 14:39:28","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":"","currentDayPrice":"78.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":"3106325","reservation_id":"95467","confirmation_number":"SJ12687341443","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1288","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-27 14:37:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.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":"3106331","reservation_id":"96661","confirmation_number":"SJ12657170184","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 22:21:32","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":"","currentDayPrice":"78.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":"3106340","reservation_id":"96663","confirmation_number":"SJ12636567735","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1942","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-06-16 22:24:34","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":"","currentDayPrice":"78.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":"3105960","reservation_id":"96578","confirmation_number":"SJ12675266876","room_stay_from":"2020-07-03","room_stay_to":"2020-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.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":"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-06-16 00:38:49","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":"","currentDayPrice":"77.86","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":"3112561","reservation_id":"96579","confirmation_number":"SJ12629962709","room_stay_from":"2020-07-04","room_stay_to":"2020-07-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"412","product_id":"1294","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-06-16 00:41:36","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":"","currentDayPrice":"77.86","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":"3111326","reservation_id":"96662","confirmation_number":"SJ12639210405","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"0.00","room_type_id":"412","product_id":"1294","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-06-16 22:22:56","service_canceled_date_time":"2020-07-04 19:47:46","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"0.00","deltaChange":-78.33,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3083254","reservation_id":"93480","confirmation_number":"SJ12668923833","room_confirmation_number":"SJ12643889829","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","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":"99706","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-03-18 02:22:08","reservation_modified_date_time":"2020-03-18 02:22:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99706","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","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":"3111833","reservation_id":"97300","confirmation_number":"SJ12628003989","room_confirmation_number":"SJ12675601843","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"103388","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-07-02 15:49:07","reservation_modified_date_time":"2020-07-02 15:49:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103388","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","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":"3112612","reservation_id":"97394","confirmation_number":"SJ12691237393","room_confirmation_number":"SJ12662026437","room_stay_from":"2020-07-04","room_stay_to":"2020-07-05","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":"103481","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-07-04 21:33:06","reservation_modified_date_time":"2020-07-04 21:33:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103481","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","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":"3103077","reservation_id":"96016","confirmation_number":"SJ12692297765","room_confirmation_number":"SJ12670455624","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"102149","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-06-08 22:32:04","reservation_modified_date_time":"2020-06-08 22:32:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102149","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","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":"3109918","reservation_id":"97102","confirmation_number":"SJ12673984927","room_confirmation_number":"SJ12624140200","room_stay_from":"2020-07-03","room_stay_to":"2020-07-07","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":"103222","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-06-26 12:52:04","reservation_modified_date_time":"2020-06-26 12:52:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","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":"3083255","reservation_id":"93480","confirmation_number":"SJ12623720848","room_confirmation_number":"SJ12643889829","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","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":"99706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-18 02:22:08","reservation_modified_date_time":"2020-03-18 02:22:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99706","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3095500","reservation_id":"95126","confirmation_number":"SJ12623083136","room_confirmation_number":"SJ12627321751","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"101310","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 15:56:08","reservation_modified_date_time":"2020-05-20 15:56:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101310","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3106330","reservation_id":"96660","confirmation_number":"SJ12661682979","room_confirmation_number":"SJ12621284119","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"102777","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 22:19:35","reservation_modified_date_time":"2020-06-16 22:19:35","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3108037","reservation_id":"94933","confirmation_number":"SJ12624389390","room_confirmation_number":"SJ12665223625","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","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":"101125","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 02:12:10","reservation_modified_date_time":"2020-06-20 20:55:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101125","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3109069","reservation_id":"96547","confirmation_number":"SJ12638809064","room_confirmation_number":"SJ12681847899","room_stay_from":"2020-06-28","room_stay_to":"2020-07-05","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":"102653","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:34:58","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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":"3110697","reservation_id":"97196","confirmation_number":"SJ12693677284","room_confirmation_number":"SJ12635438453","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103297","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-28 20:02:07","reservation_modified_date_time":"2020-06-28 20:02:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103297","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3110856","reservation_id":"96779","confirmation_number":"SJ12659570641","room_confirmation_number":"SJ12617605836","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"102892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 16:56:33","reservation_modified_date_time":"2020-06-29 11:54:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3110858","reservation_id":"95079","confirmation_number":"SJ12667788710","room_confirmation_number":"SJ12682756926","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"101262","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 23:21:08","reservation_modified_date_time":"2020-06-29 11:55:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101262","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111090","reservation_id":"97050","confirmation_number":"SJ12699748636","room_confirmation_number":"SJ12693051696","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103170","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 00:06:08","reservation_modified_date_time":"2020-06-29 23:29:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103170","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111159","reservation_id":"97079","confirmation_number":"SJ12622866940","room_confirmation_number":"SJ12699145726","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"103200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 22:00:09","reservation_modified_date_time":"2020-06-30 14:41:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103200","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111164","reservation_id":"97205","confirmation_number":"SJ12622251533","room_confirmation_number":"SJ12614842282","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103307","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-29 00:33:10","reservation_modified_date_time":"2020-06-30 14:44:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103307","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111195","reservation_id":"96843","confirmation_number":"SJ12678560523","room_confirmation_number":"SJ12675320412","room_stay_from":"2020-06-30","room_stay_to":"2020-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102970","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 01:40:20","reservation_modified_date_time":"2020-06-30 16:53:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111255","reservation_id":"97255","confirmation_number":"SJ12616824491","room_confirmation_number":"SJ12643263177","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103355","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 23:31:58","reservation_modified_date_time":"2020-06-30 23:31:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103355","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111359","reservation_id":"97048","confirmation_number":"SJ12659114105","room_confirmation_number":"SJ12653334111","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103168","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-24 21:45:06","reservation_modified_date_time":"2020-07-01 12:35:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103168","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111678","reservation_id":"97288","confirmation_number":"SJ12659669220","room_confirmation_number":"SJ12665815266","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"103379","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 00:12:38","reservation_modified_date_time":"2020-07-02 00:12:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103379","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111693","reservation_id":"97098","confirmation_number":"SJ12615455121","room_confirmation_number":"SJ12684370690","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"103218","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 02:55:15","reservation_modified_date_time":"2020-07-02 00:45:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103218","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111746","reservation_id":"97289","confirmation_number":"SJ12631433395","room_confirmation_number":"SJ12671479455","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103381","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 01:24:14","reservation_modified_date_time":"2020-07-02 01:24:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103381","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111825","reservation_id":"95925","confirmation_number":"SJ12661014794","room_confirmation_number":"SJ12670257455","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"102069","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-05 00:58:10","reservation_modified_date_time":"2020-07-02 15:03:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102069","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111834","reservation_id":"97300","confirmation_number":"SJ12672051729","room_confirmation_number":"SJ12675601843","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 15:49:07","reservation_modified_date_time":"2020-07-02 15:49:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103388","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3111845","reservation_id":"97302","confirmation_number":"SJ12660772747","room_confirmation_number":"SJ12678380545","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103389","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 15:59:09","reservation_modified_date_time":"2020-07-02 15:59:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103389","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112165","reservation_id":"96038","confirmation_number":"SJ12632184179","room_confirmation_number":"SJ12629265738","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"99511","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-07 14:34:20","reservation_modified_date_time":"2020-07-03 16:36:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99511","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112214","reservation_id":"97339","confirmation_number":"SJ12696995656","room_confirmation_number":"SJ12646909661","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103424","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-03 15:20:07","reservation_modified_date_time":"2020-07-03 17:36:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103424","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3112216","reservation_id":"97080","confirmation_number":"SJ12642718088","room_confirmation_number":"SJ12661335718","room_stay_from":"2020-07-04","room_stay_to":"2020-07-05","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":"103202","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 22:53:07","reservation_modified_date_time":"2020-07-03 17:37:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103202","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112236","reservation_id":"97226","confirmation_number":"SJ12653348305","room_confirmation_number":"SJ12647154240","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103328","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-29 19:47:04","reservation_modified_date_time":"2020-07-03 19:09:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103328","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112238","reservation_id":"95123","confirmation_number":"SJ12637356234","room_confirmation_number":"SJ12675573985","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"101307","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 15:32:08","reservation_modified_date_time":"2020-07-03 19:09:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101307","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112287","reservation_id":"97255","confirmation_number":"SJ12642332590","room_confirmation_number":"SJ12650790614","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103355","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 23:31:58","reservation_modified_date_time":"2020-07-03 21:32:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103355","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112289","reservation_id":"95125","confirmation_number":"SJ12668367531","room_confirmation_number":"SJ12686545684","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"101309","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 15:52:10","reservation_modified_date_time":"2020-07-03 21:32:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101309","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112613","reservation_id":"97394","confirmation_number":"SJ12612286479","room_confirmation_number":"SJ12662026437","room_stay_from":"2020-07-04","room_stay_to":"2020-07-05","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":"103481","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-04 21:33:06","reservation_modified_date_time":"2020-07-04 21:33:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103481","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3093081","reservation_id":"94698","confirmation_number":"SJ12613175805","room_confirmation_number":"SJ12668445244","room_stay_from":"2020-07-01","room_stay_to":"2020-07-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":"100898","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-12 13:31:13","reservation_modified_date_time":"2020-05-12 13:31:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100898","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3102483","reservation_id":"95468","confirmation_number":"SJ12655391966","room_confirmation_number":"SJ12622106885","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"101660","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 14:39:28","reservation_modified_date_time":"2020-06-07 14:38:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3103078","reservation_id":"96016","confirmation_number":"SJ12621157566","room_confirmation_number":"SJ12670455624","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"102149","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-06 21:59:08","reservation_modified_date_time":"2020-06-08 22:32:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102149","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3106326","reservation_id":"95467","confirmation_number":"SJ12663044568","room_confirmation_number":"SJ12687341443","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"101659","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 14:37:42","reservation_modified_date_time":"2020-06-16 22:18:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3106332","reservation_id":"96661","confirmation_number":"SJ12639990778","room_confirmation_number":"SJ12657170184","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"102778","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 22:21:32","reservation_modified_date_time":"2020-06-16 22:21:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3106341","reservation_id":"96663","confirmation_number":"SJ12632570870","room_confirmation_number":"SJ12636567735","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"102780","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 22:24:34","reservation_modified_date_time":"2020-06-16 22:24:34","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3108035","reservation_id":"94697","confirmation_number":"SJ12647935426","room_confirmation_number":"SJ12644261210","room_stay_from":"2020-07-01","room_stay_to":"2020-07-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":"100897","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-12 13:31:08","reservation_modified_date_time":"2020-06-20 20:55:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100897","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111155","reservation_id":"97240","confirmation_number":"SJ12668454874","room_confirmation_number":"SJ12611861826","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","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":"103341","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 14:38:10","reservation_modified_date_time":"2020-06-30 14:38:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103341","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111330","reservation_id":"95407","confirmation_number":"SJ12688279570","room_confirmation_number":"SJ12682763247","room_stay_from":"2020-07-01","room_stay_to":"2020-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101601","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 13:51:12","reservation_modified_date_time":"2020-07-01 11:28:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111415","reservation_id":"97249","confirmation_number":"SJ12690121356","room_confirmation_number":"SJ12630744264","room_stay_from":"2020-07-02","room_stay_to":"2020-07-06","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":"103348","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 18:45:06","reservation_modified_date_time":"2020-07-01 15:18:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103348","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111805","reservation_id":"97018","confirmation_number":"SJ12654790135","room_confirmation_number":"SJ12626792344","room_stay_from":"2020-07-02","room_stay_to":"2020-07-06","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":"103194","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-24 00:24:18","reservation_modified_date_time":"2020-07-02 14:48:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103194","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112212","reservation_id":"96943","confirmation_number":"SJ12658319864","room_confirmation_number":"SJ12638886185","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","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":"103067","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 18:00:39","reservation_modified_date_time":"2020-07-03 17:35:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103067","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112379","reservation_id":"97317","confirmation_number":"SJ12610175338","room_confirmation_number":"SJ12662534602","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"103398","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 20:13:07","reservation_modified_date_time":"2020-07-04 13:57:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103398","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3112493","reservation_id":"97215","confirmation_number":"SJ12665575978","room_confirmation_number":"SJ12622700880","room_stay_from":"2020-07-04","room_stay_to":"2020-07-06","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":"103319","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-29 14:36:10","reservation_modified_date_time":"2020-07-04 17:37:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103319","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3109919","reservation_id":"97102","confirmation_number":"SJ12667318095","room_confirmation_number":"SJ12624140200","room_stay_from":"2020-07-03","room_stay_to":"2020-07-07","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":"103222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 12:52:04","reservation_modified_date_time":"2020-06-26 12:52:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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":"3110328","reservation_id":"94934","confirmation_number":"SJ12616761913","room_confirmation_number":"SJ12651943191","room_stay_from":"2020-07-04","room_stay_to":"2020-07-07","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":"92463","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 02:14:05","reservation_modified_date_time":"2020-06-27 18:41:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92463","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112292","reservation_id":"95861","confirmation_number":"SJ12672656665","room_confirmation_number":"SJ12689745534","room_stay_from":"2020-07-01","room_stay_to":"2020-07-08","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":"102017","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 17:20:31","reservation_modified_date_time":"2020-07-03 22:04:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102017","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111086","reservation_id":"96458","confirmation_number":"SJ12669061423","room_confirmation_number":"SJ12689515637","room_stay_from":"2020-07-03","room_stay_to":"2020-07-09","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":"102567","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 22:34:59","reservation_modified_date_time":"2020-06-29 23:21:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102567","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3105961","reservation_id":"96578","confirmation_number":"SJ12697433762","room_confirmation_number":"SJ12675266876","room_stay_from":"2020-07-03","room_stay_to":"2020-07-10","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":"102691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 00:38:49","reservation_modified_date_time":"2020-06-16 00:38:49","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111197","reservation_id":"95309","confirmation_number":"SJ12650316874","room_confirmation_number":"SJ12615497878","room_stay_from":"2020-07-03","room_stay_to":"2020-07-10","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":"101497","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-23 23:26:09","reservation_modified_date_time":"2020-06-30 16:54:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101497","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3112383","reservation_id":"96447","confirmation_number":"SJ12662818514","room_confirmation_number":"SJ12629074751","room_stay_from":"2020-07-03","room_stay_to":"2020-07-10","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":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"102558","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 20:39:15","reservation_modified_date_time":"2020-07-04 14:15:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102558","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3112556","reservation_id":"96195","confirmation_number":"SJ12694913266","room_confirmation_number":"SJ12629837504","room_stay_from":"2020-07-04","room_stay_to":"2020-07-11","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":"102317","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 23:39:12","reservation_modified_date_time":"2020-07-04 19:32:29","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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":"3112562","reservation_id":"96579","confirmation_number":"SJ12615428400","room_confirmation_number":"SJ12629962709","room_stay_from":"2020-07-04","room_stay_to":"2020-07-11","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":"102692","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 00:41:36","reservation_modified_date_time":"2020-07-04 19:48:36","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3111327","reservation_id":"96662","confirmation_number":"SJ12690556036","room_confirmation_number":"SJ12639210405","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Canceled","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-16 22:22:56","reservation_modified_date_time":"2020-07-01 11:26:10","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"102779","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-07-04 19:47:46","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3112521","reservation_id":"97378","confirmation_number":"SJ12632401131","room_confirmation_number":"SJ12688544339","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"3","product_name":"Koozie","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-04 18:52:04","reservation_modified_date_time":"2020-07-04 18:52:04","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":"5.58","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":[{"room_stay_id":"3112381","reservation_id":"97364","confirmation_number":"SJ12684619573","room_confirmation_number":"SJ12680844393","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":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-04 14:04:02","reservation_modified_date_time":"2020-07-04 14:04:02","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"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":"3112522","reservation_id":"97378","confirmation_number":"SJ12622133782","room_confirmation_number":"SJ12688544339","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":"24.00","paid_amount":"24.00","product_id":null,"service_quantity":"6","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-04 18:52:04","reservation_modified_date_time":"2020-07-04 18:52:04","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"22.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3112581","reservation_id":"97386","confirmation_number":"SJ12627710333","room_confirmation_number":"SJ12688971122","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":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"4","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-04 20:25:43","reservation_modified_date_time":"2020-07-04 20:25:43","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3112591","reservation_id":"97390","confirmation_number":"SJ12625373914","room_confirmation_number":"SJ12676221011","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":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-04 20:47:16","reservation_modified_date_time":"2020-07-04 20:47:16","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"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":"3112638","reservation_id":"97399","confirmation_number":"SJ12648737039","room_confirmation_number":"SJ12619865316","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":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-05 00:18:47","reservation_modified_date_time":"2020-07-05 00:18:47","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}