{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-02-28","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":27,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1262,1943","block_room_bookings":[{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-03-27","bundle_room":"0"}],"bundle_block_count":"1271,1272,1267,1268,1291,1711,1260,1261,1262,1263,1309,1310,1304,1305,1307,1308,1302,1303,1269,1270,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12660089953","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","bundle_room":"1"},{"confirmation_number":"SJB12676063772","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","bundle_room":"1"},{"confirmation_number":"SJB12655215942","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","bundle_room":"1"},{"confirmation_number":"SJB12647300278","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","bundle_room":"1"},{"confirmation_number":"SJB12628312424","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","bundle_room":"1"},{"confirmation_number":"SJB12668268137","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","bundle_room":"1"},{"confirmation_number":"SJB12698459700","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","bundle_room":"1"},{"confirmation_number":"SJB12641585412","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","bundle_room":"1"},{"confirmation_number":"SJB12627538000","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","bundle_room":"1"},{"confirmation_number":"SJB12623416584","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","bundle_room":"1"},{"confirmation_number":"SJB12697953544","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3062714","reservation_id":"90777","confirmation_number":"SJ12685300574","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"179.00,215.00","nightly_discount":"0,0","subtotal":"394.00","grand_total":"443.25","paid_amount":"443.25","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3184743274","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":"96858","customer_id":"96858","source_of_creation":"Booking.com","reservation_created_date":"2020-01-28 14:34:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"81.04","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"215.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":"3068099","reservation_id":"91684","confirmation_number":"SJ12625336093","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"210","nightly_discount":"0","subtotal":"210.00","grand_total":"236.25","paid_amount":"236.25","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-2949784920","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":"97826","customer_id":"97826","source_of_creation":"Booking.com","reservation_created_date":"2020-02-10 00:11:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"51.86","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"210","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":"3074845","reservation_id":"91640","confirmation_number":"SJ12611624414","room_stay_from":"2020-02-26","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50,269.10","nightly_discount":"0,0,0","subtotal":"692.10","grand_total":"778.62","paid_amount":"778.62","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2708793755","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":"97777","customer_id":"97777","source_of_creation":"Booking.com","reservation_created_date":"2020-02-09 15:41:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"139.76","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"269.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075446","reservation_id":"92544","confirmation_number":"SJ12617213344","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"272,325","nightly_discount":"0,0","subtotal":"597.00","grand_total":"671.63","paid_amount":"671.63","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-2867016838","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":"98705","customer_id":"98705","source_of_creation":"Booking.com","reservation_created_date":"2020-02-25 16:27:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"125.46","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"325","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":"3075803","reservation_id":"90517","confirmation_number":"SJ12641430381","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"215.00","nightly_discount":"0","subtotal":"215.00","grand_total":"241.88","paid_amount":"241.88","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2219253649","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":"98876","customer_id":"98876","source_of_creation":"Booking.com","reservation_created_date":"2020-01-24 18:38:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"43.76","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"215.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":"3074390","reservation_id":"92568","confirmation_number":"SJ12681624716","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,280.00","nightly_discount":"0,0","subtotal":"560.00","grand_total":"630.00","paid_amount":"630.00","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-2651781836","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":"98733","customer_id":"98733","source_of_creation":"Booking.com","reservation_created_date":"2020-02-26 00:24:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"109.80","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"280.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":"3074860","reservation_id":"91110","confirmation_number":"SJ12622685488","room_stay_from":"2020-02-26","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50,234.00,234.00","nightly_discount":"0,0,0,0","subtotal":"891.00","grand_total":"1002.38","paid_amount":"1002.38","room_type_id":"319","product_id":"1293","siteminder_id":"BDC-2561526155","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":"97237","customer_id":"97237","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 07:59:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"180.63","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"234.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":"3075554","reservation_id":"92699","confirmation_number":"SJ12673721532","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"252.00,252.00","nightly_discount":"0,0","subtotal":"504.00","grand_total":"567.00","paid_amount":"567.00","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-2935937660","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":"98844","customer_id":"98844","source_of_creation":"Booking.com","reservation_created_date":"2020-02-28 01:44:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"99.72","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"252.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":"3075750","reservation_id":"92722","confirmation_number":"SJ12655026693","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,280.00","nightly_discount":"0,0","subtotal":"560.00","grand_total":"630.00","paid_amount":"630.00","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-2935921840","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":"98868","customer_id":"98868","source_of_creation":"Booking.com","reservation_created_date":"2020-02-28 18:09:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"109.80","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"280.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":"3075792","reservation_id":"92177","confirmation_number":"SJ12612864396","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,280.00","nightly_discount":"0,0","subtotal":"560.00","grand_total":"630.00","paid_amount":"630.00","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-3313025195","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":"98873","customer_id":"98873","source_of_creation":"Booking.com","reservation_created_date":"2020-02-19 01:32:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"110.92","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"280.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":"3075807","reservation_id":"91205","confirmation_number":"SJ12620965245","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00","nightly_discount":"0,0","subtotal":"430.00","grand_total":"483.75","paid_amount":"483.75","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-3918614062","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":"98877","customer_id":"98877","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 14:02:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"87.52","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"215.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":"3068812","reservation_id":"91779","confirmation_number":"SJ12679370654","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129,210,210,129","nightly_discount":"0,0,0,0","subtotal":"678.00","grand_total":"762.75","paid_amount":"762.75","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3282462393","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97924","customer_id":"97924","source_of_creation":"Booking.com","reservation_created_date":"2020-02-11 13:21:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"178.29","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"210","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075828","reservation_id":"91438","confirmation_number":"SJ12621517484","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"210,210,129","nightly_discount":"0,0,0","subtotal":"549.00","grand_total":"617.63","paid_amount":"617.63","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-3052583306","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98881","customer_id":"98881","source_of_creation":"Booking.com","reservation_created_date":"2020-02-06 19:26:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"70.50","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"210","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":"3062271","reservation_id":"90688","confirmation_number":"SJ12699667839","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00","nightly_discount":"0","subtotal":"172.00","grand_total":"193.50","paid_amount":"193.50","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1630667343","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":"96770","customer_id":"96770","source_of_creation":"Expedia","reservation_created_date":"2020-01-27 16:48:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"172.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":"3067663","reservation_id":"91631","confirmation_number":"SJ12643298100","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"234.00,234.00,234.00,291.60","nightly_discount":"0,0,0,0","subtotal":"993.60","grand_total":"1117.80","paid_amount":"1117.80","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1638151316","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":"97768","customer_id":"97768","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 04:03:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"291.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068057","reservation_id":"91677","confirmation_number":"SJ12670479840","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.00","nightly_discount":"0","subtotal":"208.00","grand_total":"234.00","paid_amount":"234.00","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1638568776","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":"97819","customer_id":"97819","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 23:13:09","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","currentDayPrice":"208.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":"3071104","reservation_id":"89022","confirmation_number":"SJ12673020053","room_stay_from":"2020-02-23","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.40,230.40,230.40,230.40,230.40,272.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1424.80","grand_total":"1602.90","paid_amount":"1602.90","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1615324196","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":"95099","customer_id":"95099","source_of_creation":"Expedia","reservation_created_date":"2019-12-31 19:42:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"272.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":"3071964","reservation_id":"92267","confirmation_number":"SJ12614637836","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,224.00","nightly_discount":"0,0,0,0","subtotal":"836.00","grand_total":"940.50","paid_amount":"940.50","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1645469216","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":"98447","customer_id":"98447","source_of_creation":"Expedia","reservation_created_date":"2020-02-20 19:08:07","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","currentDayPrice":"224.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":"3073813","reservation_id":"91986","confirmation_number":"SJ12654742970","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,201.60","nightly_discount":"0,0,0,0","subtotal":"752.40","grand_total":"846.45","paid_amount":"846.45","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1641811532","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":"98139","customer_id":"98139","source_of_creation":"Expedia","reservation_created_date":"2020-02-14 21:39:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073941","reservation_id":"92538","confirmation_number":"SJ12685638661","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,201.60","nightly_discount":"0,0","subtotal":"385.20","grand_total":"433.35","paid_amount":"433.35","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1648246780","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":"98700","customer_id":"98700","source_of_creation":"Expedia","reservation_created_date":"2020-02-25 14:08:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074827","reservation_id":"92355","confirmation_number":"SJ12638273038","room_stay_from":"2020-02-26","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"183.60,183.60,201.60","nightly_discount":"0,0,0","subtotal":"568.80","grand_total":"639.90","paid_amount":"639.90","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1646550347","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":"98535","customer_id":"98535","source_of_creation":"Expedia","reservation_created_date":"2020-02-22 15:13:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075281","reservation_id":"92671","confirmation_number":"SJ12643928518","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60","nightly_discount":"0","subtotal":"201.60","grand_total":"226.80","paid_amount":"226.80","room_type_id":"319","product_id":"1307","siteminder_id":"EXP-1649644915","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":"98820","customer_id":"98820","source_of_creation":"Expedia","reservation_created_date":"2020-02-27 18:23:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075423","reservation_id":"92581","confirmation_number":"SJ12612140835","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"176.6,194.6","nightly_discount":"0,0","subtotal":"371.20","grand_total":"417.60","paid_amount":"417.60","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1648651561","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98743","customer_id":"98743","source_of_creation":"Expedia","reservation_created_date":"2020-02-26 02:43:09","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","currentDayPrice":"194.6","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075455","reservation_id":"91296","confirmation_number":"SJ12619080028","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"180.2,226.28","nightly_discount":"0,0","subtotal":"406.48","grand_total":"457.29","paid_amount":"457.29","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1635438843","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97419","customer_id":"97419","source_of_creation":"Expedia","reservation_created_date":"2020-02-04 18:29:08","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","currentDayPrice":"226.28","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":"3075542","reservation_id":"92361","confirmation_number":"SJ12613626347","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"227.00,227.00,227.00,227.00,280.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1188.00","grand_total":"1336.50","paid_amount":"1336.50","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1646607602","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":"98840","customer_id":"98840","source_of_creation":"Expedia","reservation_created_date":"2020-02-22 17:18:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"280.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075613","reservation_id":"92709","confirmation_number":"SJ12639735570","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60","nightly_discount":"0","subtotal":"201.60","grand_total":"226.80","paid_amount":"226.80","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1650086668","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":"98854","customer_id":"98854","source_of_creation":"Expedia","reservation_created_date":"2020-02-28 12:44:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075759","reservation_id":"92665","confirmation_number":"SJ12612781879","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60","nightly_discount":"0","subtotal":"201.60","grand_total":"226.80","paid_amount":"226.80","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1649592625","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":"98814","customer_id":"98814","source_of_creation":"Expedia","reservation_created_date":"2020-02-27 16:48:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075907","reservation_id":"90670","confirmation_number":"SJ12628875181","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00","nightly_discount":"0","subtotal":"215.00","grand_total":"241.88","paid_amount":"241.88","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1630330595","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":"98885","customer_id":"98885","source_of_creation":"Expedia","reservation_created_date":"2020-01-27 02:39:38","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","currentDayPrice":"215.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":"3061336","reservation_id":"90512","confirmation_number":"SJ12675162876","room_stay_from":"2020-02-27","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,215.00,215.00","nightly_discount":"0,0,0","subtotal":"609.00","grand_total":"685.13","paid_amount":"685.13","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1629074242","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":"96566","customer_id":"96566","source_of_creation":"Expedia","reservation_created_date":"2020-01-24 17:53:12","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","currentDayPrice":"215.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":"3064279","reservation_id":"91053","confirmation_number":"SJ12626647459","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"173.2,173.2","nightly_discount":"0,0","subtotal":"346.40","grand_total":"389.70","paid_amount":"389.70","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1633691232","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97163","customer_id":"97163","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 16:08:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"173.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"}]},{"room_stay_id":"3066599","reservation_id":"90660","confirmation_number":"SJ12639602596","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00,172.00","nightly_discount":"0,0","subtotal":"344.00","grand_total":"387.00","paid_amount":"387.00","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1630237708","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":"96742","customer_id":"96742","source_of_creation":"Expedia","reservation_created_date":"2020-01-26 22:13:09","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","currentDayPrice":"172.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":"3073925","reservation_id":"92025","confirmation_number":"SJ12625320732","room_stay_from":"2020-02-27","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.50,252.00,252.00","nightly_discount":"0,0,0","subtotal":"733.50","grand_total":"825.19","paid_amount":"825.19","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1642511826","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":"98193","customer_id":"98193","source_of_creation":"Expedia","reservation_created_date":"2020-02-16 02:49:10","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","currentDayPrice":"252.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":"3073991","reservation_id":"92543","confirmation_number":"SJ12672227174","room_stay_from":"2020-02-27","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"183.60,201.60,201.60","nightly_discount":"0,0,0","subtotal":"586.80","grand_total":"660.15","paid_amount":"660.15","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1648312794","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":"98703","customer_id":"98703","source_of_creation":"Expedia","reservation_created_date":"2020-02-25 16:13:10","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","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074591","reservation_id":"92473","confirmation_number":"SJ12654691376","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,201.60","nightly_discount":"0,0","subtotal":"403.20","grand_total":"453.60","paid_amount":"453.60","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1647431982","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":"98638","customer_id":"98638","source_of_creation":"Expedia","reservation_created_date":"2020-02-24 05:23:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075611","reservation_id":"92651","confirmation_number":"SJ12654659239","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,201.60","nightly_discount":"0,0","subtotal":"403.20","grand_total":"453.60","paid_amount":"453.60","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1649515871","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":"98802","customer_id":"98802","source_of_creation":"Expedia","reservation_created_date":"2020-02-27 14:29:06","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","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075966","reservation_id":"90665","confirmation_number":"SJ12614958721","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00,172.00","nightly_discount":"0,0","subtotal":"344.00","grand_total":"387.00","paid_amount":"387.00","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1630289074","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":"96748","customer_id":"96748","source_of_creation":"Expedia","reservation_created_date":"2020-01-27 02:39:19","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","currentDayPrice":"172.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":"3073159","reservation_id":"91774","confirmation_number":"SJ12617520566","room_stay_from":"2020-02-26","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,215.28,215.28,169.20","nightly_discount":"0,0,0,0,0","subtotal":"938.16","grand_total":"1055.43","paid_amount":"1055.43","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1639387006","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97919","customer_id":"97919","source_of_creation":"Expedia","reservation_created_date":"2020-02-11 04:19:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"215.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075412","reservation_id":"92335","confirmation_number":"SJ12663088048","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"176.6,194.6,194.6,176.6","nightly_discount":"0,0,0,0","subtotal":"742.40","grand_total":"835.20","paid_amount":"835.20","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1646252802","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"125.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98514","customer_id":"98514","source_of_creation":"Expedia","reservation_created_date":"2020-02-21 23:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"148.48","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"194.6","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075416","reservation_id":"92142","confirmation_number":"SJ12621983225","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.50,252.00,252.00,229.50","nightly_discount":"0,0,0,0","subtotal":"963.00","grand_total":"1083.38","paid_amount":"1083.38","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1644066216","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98321","customer_id":"98321","source_of_creation":"Expedia","reservation_created_date":"2020-02-18 16:54:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"252.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":"3075830","reservation_id":"91680","confirmation_number":"SJ12677024239","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.10,269.10,211.50","nightly_discount":"0,0,0","subtotal":"749.70","grand_total":"843.42","paid_amount":"843.42","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1638584283","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98882","customer_id":"98882","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 23:43:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"269.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070550","reservation_id":"92070","confirmation_number":"SJ12611935356","room_stay_from":"2020-02-27","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,201.60,201.60,183.60,183.60","nightly_discount":"0,0,0,0,0","subtotal":"954.00","grand_total":"1073.25","paid_amount":"1073.25","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1642949322","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98245","customer_id":"98245","source_of_creation":"Expedia","reservation_created_date":"2020-02-16 22:54:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073322","reservation_id":"92418","confirmation_number":"SJ12615042752","room_stay_from":"2020-02-28","room_stay_to":"2020-03-04","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,201.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0,0","subtotal":"954.00","grand_total":"1073.25","paid_amount":"1073.25","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1647034004","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98593","customer_id":"98593","source_of_creation":"Expedia","reservation_created_date":"2020-02-23 14:53:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075652","reservation_id":"90372","confirmation_number":"SJ12668936401","room_stay_from":"2020-02-27","room_stay_to":"2020-02-28","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.19","nightly_discount":"0.00","subtotal":"315.19","grand_total":"354.59","paid_amount":"354.59","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1627837302","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":"96420","customer_id":"96420","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 19:18:06","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","changedComment":"To date changed","deltaChange":"171.99","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3065326","reservation_id":"90504","confirmation_number":"SJ12666616447","room_stay_from":"2020-02-25","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00,215.00,215.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"967.00","grand_total":"1087.88","paid_amount":"1087.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":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96559","customer_id":"96559","source_of_creation":"FE","reservation_created_date":"2020-01-24 16:34:20","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","currentDayPrice":"215.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3067280","reservation_id":"91513","confirmation_number":"SJ12679558493","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00,235.00,235.00,299.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1239.00","grand_total":"1393.88","paid_amount":"1393.88","room_type_id":"319","product_id":"1291","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":"97706","customer_id":"97706","source_of_creation":"PMS","reservation_created_date":"2020-02-07 20:25:32","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","currentDayPrice":"299.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":"3074841","reservation_id":"92503","confirmation_number":"SJ12691850314","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00","nightly_discount":"0.00","subtotal":"280.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"319","product_id":"1942","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":"98668","customer_id":"98668","source_of_creation":"PMS","reservation_created_date":"2020-02-24 21:25:04","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","currentDayPrice":"280.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075506","reservation_id":"92690","confirmation_number":"SJ12639994767","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","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":"98835","customer_id":"98835","source_of_creation":"PMS","reservation_created_date":"2020-02-27 22:27:28","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","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":"3075572","reservation_id":"92526","confirmation_number":"SJ12614448266","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.50,229.50,229.50,252.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"940.50","grand_total":"1058.07","paid_amount":"1058.07","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":"98721","customer_id":"98721","source_of_creation":"PMS","reservation_created_date":"2020-02-25 01:34:47","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","currentDayPrice":"252.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":"3075973","reservation_id":"92745","confirmation_number":"SJ12692543162","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.00,260.00","nightly_discount":"0.00,0.00","subtotal":"520.00","grand_total":"585.00","paid_amount":"292.50","room_type_id":"319","product_id":"1303","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":"98891","customer_id":"98891","source_of_creation":"PMS","reservation_created_date":"2020-02-29 01:19:59","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","currentDayPrice":"260.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":"3074838","reservation_id":"90408","confirmation_number":"SJ12696514497","room_stay_from":"2020-02-26","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,215.00,215.00,179.00,179.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1146.00","grand_total":"1289.25","paid_amount":"1289.25","room_type_id":"319","product_id":"1304","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96459","customer_id":"96459","source_of_creation":"PMS","reservation_created_date":"2020-01-23 02:02:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"215.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074593","reservation_id":"92590","confirmation_number":"SJ12659490433","room_stay_from":"2020-02-22","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74162","customer_id":"74162","source_of_creation":"PMS","reservation_created_date":"2020-02-26 13:36:23","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3065767","reservation_id":"91252","confirmation_number":"SJ12634124984","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-03 22:47:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065772","reservation_id":"91254","confirmation_number":"SJ12685477866","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","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":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-03 22:49:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063607","reservation_id":"90536","confirmation_number":"SJ12678284131","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.71,160.71,160.71,160.71,160.72,160.72,160.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1125.00","grand_total":"1125.00","paid_amount":"0.00","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-01-25 01:27:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"160.71","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075643","reservation_id":"85093","confirmation_number":"SJ12676066667","room_stay_from":"2020-02-22","room_stay_to":"2020-02-28","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-10-04 03:14:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3074364","reservation_id":"86398","confirmation_number":"SJ12650609805","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.62,127.62,127.62,127.62,127.62,127.62,127.62","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"893.34","grand_total":"1005.01","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-10-29 02:20:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"127.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075727","reservation_id":"87385","confirmation_number":"SJ12657508666","room_stay_from":"2020-02-05","room_stay_to":"2020-02-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"893.33,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":"893.33","grand_total":"1005.00","paid_amount":"196.88","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-11-21 18:46:43","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","changedComment":"Nightly price or discount changed","deltaChange":"893.33","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3068100","reservation_id":"91684","confirmation_number":"SJ12635128816","room_confirmation_number":"SJ12625336093","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"97826","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-10 00:11:06","reservation_modified_date_time":"2020-02-10 00:11:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97826","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075424","reservation_id":"92581","confirmation_number":"SJ12665982759","room_confirmation_number":"SJ12612140835","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"98743","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-27 20:27:55","reservation_modified_date_time":"2020-02-27 20:27:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98743","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075447","reservation_id":"92544","confirmation_number":"SJ12664090930","room_confirmation_number":"SJ12617213344","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","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":"98705","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-27 21:30:07","reservation_modified_date_time":"2020-02-27 21:30:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98705","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075456","reservation_id":"91296","confirmation_number":"SJ12691620356","room_confirmation_number":"SJ12619080028","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","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":"97419","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-27 22:00:15","reservation_modified_date_time":"2020-02-27 22:00:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97419","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075543","reservation_id":"92361","confirmation_number":"SJ12680223579","room_confirmation_number":"SJ12613626347","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,25.00","subtotal":"125.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"98840","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-28 00:20:38","reservation_modified_date_time":"2020-02-28 00:21:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98840","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3064280","reservation_id":"91053","confirmation_number":"SJ12622488051","room_confirmation_number":"SJ12626647459","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"97163","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-01 16:08:09","reservation_modified_date_time":"2020-02-01 16:08:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97163","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068813","reservation_id":"91779","confirmation_number":"SJ12673620778","room_confirmation_number":"SJ12679370654","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"97924","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-11 13:21:10","reservation_modified_date_time":"2020-02-11 13:21:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97924","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075414","reservation_id":"92335","confirmation_number":"SJ12661694783","room_confirmation_number":"SJ12663088048","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"98514","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-27 20:25:10","reservation_modified_date_time":"2020-02-27 20:25:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98514","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075826","reservation_id":"91438","confirmation_number":"SJ12660674012","room_confirmation_number":"SJ12621517484","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"98881","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-06 19:29:16","reservation_modified_date_time":"2020-02-28 22:11:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98881","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3062272","reservation_id":"90688","confirmation_number":"SJ12626405775","room_confirmation_number":"SJ12699667839","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","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":"96770","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 16:48:07","reservation_modified_date_time":"2020-01-27 16:48:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96770","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3062715","reservation_id":"90777","confirmation_number":"SJ12693538723","room_confirmation_number":"SJ12685300574","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"96858","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 14:34:13","reservation_modified_date_time":"2020-01-28 15:49:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96858","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065768","reservation_id":"91252","confirmation_number":"SJ12630668745","room_confirmation_number":"SJ12634124984","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","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":"97377","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 22:47:41","reservation_modified_date_time":"2020-02-03 22:47:41","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065773","reservation_id":"91254","confirmation_number":"SJ12658795644","room_confirmation_number":"SJ12685477866","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","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":"97378","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 22:49:34","reservation_modified_date_time":"2020-02-03 22:49:34","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067279","reservation_id":"91513","confirmation_number":"SJ12685929720","room_confirmation_number":"SJ12679558493","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"97706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 20:25:32","reservation_modified_date_time":"2020-02-08 15:52:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97706","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067664","reservation_id":"91631","confirmation_number":"SJ12640230789","room_confirmation_number":"SJ12643298100","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"97768","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 04:03:08","reservation_modified_date_time":"2020-02-09 04:03:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97768","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068058","reservation_id":"91677","confirmation_number":"SJ12637789094","room_confirmation_number":"SJ12670479840","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","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":"97819","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 23:13:09","reservation_modified_date_time":"2020-02-09 23:13:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97819","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068101","reservation_id":"91684","confirmation_number":"SJ12696561579","room_confirmation_number":"SJ12625336093","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97826","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-10 00:11:06","reservation_modified_date_time":"2020-02-10 00:11:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97826","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3071107","reservation_id":"89022","confirmation_number":"SJ12690601709","room_confirmation_number":"SJ12673020053","room_stay_from":"2020-02-23","room_stay_to":"2020-02-29","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":"95099","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-31 19:42:09","reservation_modified_date_time":"2020-02-18 18:21:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95099","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3071965","reservation_id":"92267","confirmation_number":"SJ12695320090","room_confirmation_number":"SJ12614637836","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98447","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-20 19:08:07","reservation_modified_date_time":"2020-02-20 19:08:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98447","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073816","reservation_id":"91986","confirmation_number":"SJ12671684546","room_confirmation_number":"SJ12654742970","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98139","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 21:39:06","reservation_modified_date_time":"2020-02-24 23:32:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98139","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073942","reservation_id":"92538","confirmation_number":"SJ12652183666","room_confirmation_number":"SJ12685638661","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"98700","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 14:08:09","reservation_modified_date_time":"2020-02-25 14:08:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98700","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074828","reservation_id":"92355","confirmation_number":"SJ12660192428","room_confirmation_number":"SJ12638273038","room_stay_from":"2020-02-26","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98535","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 15:13:06","reservation_modified_date_time":"2020-02-26 21:36:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98535","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074842","reservation_id":"92503","confirmation_number":"SJ12650042566","room_confirmation_number":"SJ12691850314","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","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":"98668","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 21:25:04","reservation_modified_date_time":"2020-02-26 21:48:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98668","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074846","reservation_id":"91640","confirmation_number":"SJ12650434578","room_confirmation_number":"SJ12611624414","room_stay_from":"2020-02-26","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"97777","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 15:41:11","reservation_modified_date_time":"2020-02-26 21:49:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97777","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075282","reservation_id":"92671","confirmation_number":"SJ12664280147","room_confirmation_number":"SJ12643928518","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","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":"98820","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 18:23:08","reservation_modified_date_time":"2020-02-27 18:23:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98820","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075425","reservation_id":"92581","confirmation_number":"SJ12621099332","room_confirmation_number":"SJ12612140835","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","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":"98743","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 02:43:09","reservation_modified_date_time":"2020-02-27 20:27:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98743","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075448","reservation_id":"92544","confirmation_number":"SJ12663830120","room_confirmation_number":"SJ12617213344","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"98705","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 16:27:07","reservation_modified_date_time":"2020-02-27 21:30:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98705","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075457","reservation_id":"91296","confirmation_number":"SJ12636921096","room_confirmation_number":"SJ12619080028","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"97419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 18:29:09","reservation_modified_date_time":"2020-02-27 22:00:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97419","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075507","reservation_id":"92690","confirmation_number":"SJ12611098543","room_confirmation_number":"SJ12639994767","room_stay_from":"2020-02-27","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98835","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 22:27:28","reservation_modified_date_time":"2020-02-27 22:27:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98835","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075544","reservation_id":"92361","confirmation_number":"SJ12678318120","room_confirmation_number":"SJ12613626347","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"98840","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 17:18:08","reservation_modified_date_time":"2020-02-28 00:21:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98840","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075573","reservation_id":"92526","confirmation_number":"SJ12669569200","room_confirmation_number":"SJ12614448266","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 01:34:47","reservation_modified_date_time":"2020-02-28 02:02:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98721","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075614","reservation_id":"92709","confirmation_number":"SJ12623085888","room_confirmation_number":"SJ12639735570","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","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":"98854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 12:44:11","reservation_modified_date_time":"2020-02-28 12:44:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98854","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075760","reservation_id":"92665","confirmation_number":"SJ12669720760","room_confirmation_number":"SJ12612781879","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","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":"98814","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 16:48:09","reservation_modified_date_time":"2020-02-28 18:28:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98814","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075802","reservation_id":"90517","confirmation_number":"SJ12684204610","room_confirmation_number":"SJ12641430381","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","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":"98876","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 18:38:10","reservation_modified_date_time":"2020-02-28 20:23:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98876","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075906","reservation_id":"90670","confirmation_number":"SJ12651762066","room_confirmation_number":"SJ12628875181","room_stay_from":"2020-02-28","room_stay_to":"2020-02-29","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":"98885","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 02:39:38","reservation_modified_date_time":"2020-02-28 22:54:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98885","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3061337","reservation_id":"90512","confirmation_number":"SJ12678704719","room_confirmation_number":"SJ12675162876","room_stay_from":"2020-02-27","room_stay_to":"2020-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"96566","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 17:53:12","reservation_modified_date_time":"2020-01-24 17:53:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96566","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3064281","reservation_id":"91053","confirmation_number":"SJ12662287995","room_confirmation_number":"SJ12626647459","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"97163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 16:08:09","reservation_modified_date_time":"2020-02-01 16:08:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97163","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065327","reservation_id":"90504","confirmation_number":"SJ12611143624","room_confirmation_number":"SJ12666616447","room_stay_from":"2020-02-25","room_stay_to":"2020-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"96559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 16:34:20","reservation_modified_date_time":"2020-02-02 22:40:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96559","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3066600","reservation_id":"90660","confirmation_number":"SJ12624367873","room_confirmation_number":"SJ12639602596","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"96742","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 22:13:09","reservation_modified_date_time":"2020-02-06 19:29:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96742","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073927","reservation_id":"92025","confirmation_number":"SJ12618209814","room_confirmation_number":"SJ12625320732","room_stay_from":"2020-02-27","room_stay_to":"2020-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-16 02:49:10","reservation_modified_date_time":"2020-02-25 13:01:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98193","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073992","reservation_id":"92543","confirmation_number":"SJ12648330393","room_confirmation_number":"SJ12672227174","room_stay_from":"2020-02-27","room_stay_to":"2020-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 16:13:10","reservation_modified_date_time":"2020-02-25 16:13:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98703","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074391","reservation_id":"92568","confirmation_number":"SJ12674573970","room_confirmation_number":"SJ12681624716","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"98733","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 00:24:11","reservation_modified_date_time":"2020-02-26 00:24:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98733","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074592","reservation_id":"92473","confirmation_number":"SJ12619552290","room_confirmation_number":"SJ12654691376","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"98638","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 05:23:09","reservation_modified_date_time":"2020-02-26 14:13:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98638","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074861","reservation_id":"91110","confirmation_number":"SJ12691320822","room_confirmation_number":"SJ12622685488","room_stay_from":"2020-02-26","room_stay_to":"2020-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"97237","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 07:59:10","reservation_modified_date_time":"2020-02-26 22:13:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97237","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075555","reservation_id":"92699","confirmation_number":"SJ12644066171","room_confirmation_number":"SJ12673721532","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"98844","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 01:44:10","reservation_modified_date_time":"2020-02-28 01:44:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98844","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075612","reservation_id":"92651","confirmation_number":"SJ12678318200","room_confirmation_number":"SJ12654659239","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"98802","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 14:29:07","reservation_modified_date_time":"2020-02-28 12:19:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98802","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075751","reservation_id":"92722","confirmation_number":"SJ12618115723","room_confirmation_number":"SJ12655026693","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"98868","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 18:09:11","reservation_modified_date_time":"2020-02-28 18:19:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98868","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075791","reservation_id":"92177","confirmation_number":"SJ12663225116","room_confirmation_number":"SJ12612864396","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"98873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-19 01:32:11","reservation_modified_date_time":"2020-02-28 19:39:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98873","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075806","reservation_id":"91205","confirmation_number":"SJ12683428925","room_confirmation_number":"SJ12620965245","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"98877","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 14:02:11","reservation_modified_date_time":"2020-02-28 21:12:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98877","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075968","reservation_id":"90665","confirmation_number":"SJ12643415432","room_confirmation_number":"SJ12614958721","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","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":"96748","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 02:39:19","reservation_modified_date_time":"2020-02-29 00:14:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96748","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075974","reservation_id":"92745","confirmation_number":"SJ12687130621","room_confirmation_number":"SJ12692543162","room_stay_from":"2020-02-28","room_stay_to":"2020-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98891","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-29 01:19:59","reservation_modified_date_time":"2020-02-29 01:22:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98891","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068814","reservation_id":"91779","confirmation_number":"SJ12651409879","room_confirmation_number":"SJ12679370654","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"97924","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 13:21:10","reservation_modified_date_time":"2020-02-11 13:21:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97924","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073160","reservation_id":"91774","confirmation_number":"SJ12634953237","room_confirmation_number":"SJ12617520566","room_stay_from":"2020-02-26","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"97919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 04:19:09","reservation_modified_date_time":"2020-02-23 13:30:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97919","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075415","reservation_id":"92335","confirmation_number":"SJ12660192795","room_confirmation_number":"SJ12663088048","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98514","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 23:13:10","reservation_modified_date_time":"2020-02-27 20:25:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98514","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075419","reservation_id":"92142","confirmation_number":"SJ12638326094","room_confirmation_number":"SJ12621983225","room_stay_from":"2020-02-27","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98321","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-18 16:54:17","reservation_modified_date_time":"2020-02-27 20:25:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98321","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075827","reservation_id":"91438","confirmation_number":"SJ12627545762","room_confirmation_number":"SJ12621517484","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98881","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 19:26:07","reservation_modified_date_time":"2020-02-28 22:11:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98881","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075829","reservation_id":"91680","confirmation_number":"SJ12690952019","room_confirmation_number":"SJ12677024239","room_stay_from":"2020-02-28","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 23:43:07","reservation_modified_date_time":"2020-02-28 22:12:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98882","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070551","reservation_id":"92070","confirmation_number":"SJ12679160450","room_confirmation_number":"SJ12611935356","room_stay_from":"2020-02-27","room_stay_to":"2020-03-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"98245","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-16 22:54:08","reservation_modified_date_time":"2020-02-16 22:54:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98245","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074840","reservation_id":"90408","confirmation_number":"SJ12623104211","room_confirmation_number":"SJ12696514497","room_stay_from":"2020-02-26","room_stay_to":"2020-03-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,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":"96459","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 02:02:11","reservation_modified_date_time":"2020-02-26 21:40:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96459","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073323","reservation_id":"92418","confirmation_number":"SJ12643420486","room_confirmation_number":"SJ12615042752","room_stay_from":"2020-02-28","room_stay_to":"2020-03-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98593","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-23 14:53:06","reservation_modified_date_time":"2020-02-23 14:53:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98593","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063608","reservation_id":"90536","confirmation_number":"SJ12691035339","room_confirmation_number":"SJ12678284131","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 01:27:28","reservation_modified_date_time":"2020-01-30 17:52:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074363","reservation_id":"86398","confirmation_number":"SJ12663775501","room_confirmation_number":"SJ12650609805","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"95414","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-29 02:20:04","reservation_modified_date_time":"2020-02-25 23:12:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074594","reservation_id":"92590","confirmation_number":"SJ12696987483","room_confirmation_number":"SJ12659490433","room_stay_from":"2020-02-22","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 13:36:23","reservation_modified_date_time":"2020-02-26 14:14:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74162","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075644","reservation_id":"85093","confirmation_number":"SJ12647530071","room_confirmation_number":"SJ12676066667","room_stay_from":"2020-02-22","room_stay_to":"2020-02-28","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"92326","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-04 03:14:53","reservation_modified_date_time":"2020-02-28 13:49:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075653","reservation_id":"90372","confirmation_number":"SJ12624875930","room_confirmation_number":"SJ12668936401","room_stay_from":"2020-02-27","room_stay_to":"2020-02-28","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"96420","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 19:18:06","reservation_modified_date_time":"2020-02-28 14:09:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96420","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3075649","reservation_id":"90372","confirmation_number":"SJ12661067832","room_confirmation_number":"SJ12668936401","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-28 14:09:29","reservation_modified_date_time":"2020-02-28 14:09:29","customer_id":"96420","parentCustTravId":"96420","customer_traveller_id":"96420","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075679","reservation_id":"92716","confirmation_number":"SJ12623229317","room_confirmation_number":"SJ12622524770","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.95","grand_total":"22.52","paid_amount":"22.52","product_id":null,"service_quantity":"1","product_name":"Salt Scrub of the Keys","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-28 14:54:27","reservation_modified_date_time":"2020-02-28 14:54:27","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":"20.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3075965","reservation_id":"92744","confirmation_number":"SJ12680009490","room_confirmation_number":"SJ12699900038","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.88","paid_amount":"26.88","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-29 00:06:54","reservation_modified_date_time":"2020-02-29 00:06:54","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3075813","reservation_id":"92733","confirmation_number":"SJ12686819068","room_confirmation_number":"SJ12631185791","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"25.00","paid_amount":"25.00","product_id":null,"service_quantity":"1","product_name":"Guest Check #91059","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-28 21:26:03","reservation_modified_date_time":"2020-02-28 21:26:03","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3075822","reservation_id":"92734","confirmation_number":"SJ12690628846","room_confirmation_number":"SJ12640912776","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"71.00","grand_total":"71.00","paid_amount":"71.00","product_id":null,"service_quantity":"1","product_name":"Guest Check #91060","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-28 21:49:19","reservation_modified_date_time":"2020-02-28 21:49:19","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":"71.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3075901","reservation_id":"92736","confirmation_number":"SJ12654860182","room_confirmation_number":"SJ12623896656","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"25.00","paid_amount":"25.00","product_id":null,"service_quantity":"1","product_name":"Guest check # 91070","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-28 22:38:10","reservation_modified_date_time":"2020-02-28 22:38:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3075903","reservation_id":"92737","confirmation_number":"SJ12638279882","room_confirmation_number":"SJ12624719711","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"50.00","paid_amount":"50.00","product_id":null,"service_quantity":"1","product_name":"Guest check #91066","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-28 22:42:19","reservation_modified_date_time":"2020-02-28 22:42:19","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3075905","reservation_id":"92738","confirmation_number":"SJ12610237149","room_confirmation_number":"SJ12660387744","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"20.00","paid_amount":"20.00","product_id":null,"service_quantity":"1","product_name":"Guest check # 91071","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-28 22:43:10","reservation_modified_date_time":"2020-02-28 22:43:10","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":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}