{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-27","total_rooms_exist":"1281,1282,1289,1274,1275,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":12,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1307,1943","block_room_bookings":[{"confirmation_number":"SJ12676533150","room_stay_from":"2020-07-11","room_stay_to":"2020-08-05","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1309,1310,1302,1303,1291,1711,1304,1305,1307,1308,1262,1263,1311,1312,1269,1270,1260,1261,1267,1268","bundle_block_bookings":[{"confirmation_number":"SJB12680591042","room_stay_from":"2020-07-26","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12686984844","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12631240958","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12683410610","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12623036528","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12615618970","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12630929587","room_stay_from":"2020-07-21","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12641438867","room_stay_from":"2020-07-27","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12688176377","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","bundle_room":"1"},{"confirmation_number":"SJB12655547477","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12658861740","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12664803865","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12669527704","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12679187448","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3119652","reservation_id":"97585","confirmation_number":"SJ12645665642","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.20,267.20,172.80,172.80","nightly_discount":"0,0,0,0","subtotal":"880.00","grand_total":"990.00","paid_amount":"990.00","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-2162244087","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":"103661","customer_id":"103661","source_of_creation":"Booking.com","reservation_created_date":"2020-07-09 19:29:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"58.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.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":"3119939","reservation_id":"98152","confirmation_number":"SJ12642248693","room_stay_from":"2020-07-25","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.40,138.40,203.24","nightly_discount":"0.00,0.00,0.00","subtotal":"480.04","grand_total":"540.04","paid_amount":"540.04","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2449827342","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":"104229","customer_id":"104229","source_of_creation":"Booking.com","reservation_created_date":"2020-07-25 14:44:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"58.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"203.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120160","reservation_id":"95550","confirmation_number":"SJ12617408885","room_stay_from":"2020-07-26","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.80,176.80","nightly_discount":"0,0","subtotal":"353.60","grand_total":"397.80","paid_amount":"397.80","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3980284800","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":"101732","customer_id":"101732","source_of_creation":"Booking.com","reservation_created_date":"2020-05-28 17:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"72.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"176.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":"3119773","reservation_id":"98144","confirmation_number":"SJ12686327783","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00,260.80,260.80,260.80","nightly_discount":"0,0,0,0","subtotal":"982.40","grand_total":"1105.20","paid_amount":"1105.20","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3587007849","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":"104222","customer_id":"104222","source_of_creation":"Booking.com","reservation_created_date":"2020-07-25 02:37:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"194.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"200.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":"3113363","reservation_id":"93587","confirmation_number":"SJ12696472420","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"247.20,119.20,119.20,186.40,186.40,191.20,151.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1200.80","grand_total":"1350.90","paid_amount":"1350.90","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3169083708","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":"99816","customer_id":"99816","source_of_creation":"Booking.com","reservation_created_date":"2020-03-24 21:57:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"247.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120572","reservation_id":"92849","confirmation_number":"SJ12681495794","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"426.00,426.00,426.00,438.00,467.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"2183.99","grand_total":"2456.99","paid_amount":"2456.99","room_type_id":"320","product_id":"1320","siteminder_id":"BDC-2450614903","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":"99001","customer_id":"99001","source_of_creation":"Booking.com","reservation_created_date":"2020-03-02 02:38:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"415.62","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"426.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3119530","reservation_id":"91368","confirmation_number":"SJ12617390124","room_stay_from":"2020-07-25","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,184.00,166.40,166.40,166.40,171.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1097.60","grand_total":"1234.80","paid_amount":"1234.80","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1636094352","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":"97495","customer_id":"97495","source_of_creation":"Expedia","reservation_created_date":"2020-02-05 18:48:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107027","reservation_id":"96523","confirmation_number":"SJ12671312898","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"293.12,264.32,229.76,229.76,229.76,254.72","nightly_discount":"0,0,0,0,0,0","subtotal":"1501.44","grand_total":"1689.12","paid_amount":"1689.12","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1670772078","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":"102629","customer_id":"102629","source_of_creation":"Expedia","reservation_created_date":"2020-06-15 02:29:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"264.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"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":"3114178","reservation_id":"97466","confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"290.00,290.00,178.50,178.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"937.00","grand_total":"1054.13","paid_amount":"1054.13","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":"103545","customer_id":"103545","source_of_creation":"FE","reservation_created_date":"2020-07-06 23:49:00","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"178.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":"3119245","reservation_id":"97670","confirmation_number":"SJ12669827674","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.00,142.80,142.80,191.25,191.25","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"900.10","grand_total":"1012.62","paid_amount":"1012.62","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103746","customer_id":"103746","source_of_creation":"FE","reservation_created_date":"2020-07-11 20:36:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3094799","reservation_id":"94959","confirmation_number":"SJ12673001401","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"450.00,406.00,406.00,406.00,418.00,448.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2534.00","grand_total":"2850.75","paid_amount":"2850.75","room_type_id":"320","product_id":"1323","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":"101147","customer_id":"101147","source_of_creation":"FE","reservation_created_date":"2020-05-18 15:48:50","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"406.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":"3095773","reservation_id":"95175","confirmation_number":"SJ12621544590","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.55,141.55,141.55,141.55,161.55","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"727.75","grand_total":"818.72","paid_amount":"818.72","room_type_id":"412","product_id":"1315","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":"101357","customer_id":"101357","source_of_creation":"FE","reservation_created_date":"2020-05-21 04:51:04","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"141.55","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3116839","reservation_id":"97853","confirmation_number":"SJ12620030798","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"295.12,411.20,411.20,295.12,295.12","nightly_discount":"29.50,41.12,41.12,29.50,29.50","subtotal":"1707.76","grand_total":"1729.15","paid_amount":"1729.15","room_type_id":"320","product_id":"1714","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":"103919","customer_id":"103919","source_of_creation":"PMS","reservation_created_date":"2020-07-17 11:26:45","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"295.12","currentDayDiscount":"29.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118654","reservation_id":"97846","confirmation_number":"SJ12639459090","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.12,411.20,411.20,295.12,295.12","nightly_discount":"29.50,41.12,41.12,29.50,29.50","subtotal":"1707.76","grand_total":"1729.15","paid_amount":"1729.15","room_type_id":"320","product_id":"1329","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":"103914","customer_id":"103914","source_of_creation":"PMS","reservation_created_date":"2020-07-17 00:55:37","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"295.12","currentDayDiscount":"29.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120585","reservation_id":"98051","confirmation_number":"SJ12684507683","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"142.80,142.80,382.50","nightly_discount":"0.00,0.00,0.00","subtotal":"668.10","grand_total":"751.62","paid_amount":"779.75","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":"104115","customer_id":"104115","source_of_creation":"PMS","reservation_created_date":"2020-07-22 16:42:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"142.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117642","reservation_id":"97941","confirmation_number":"SJ12645743914","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.60,221.60,133.96,133.96,170.00,180.20,180.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1241.52","grand_total":"1396.71","paid_amount":"1396.71","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104009","customer_id":"104009","source_of_creation":"PMS","reservation_created_date":"2020-07-19 01:19:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119262","reservation_id":"98108","confirmation_number":"SJ12699664625","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.88,217.60,217.60,217.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"816.68","grand_total":"918.76","paid_amount":"918.76","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":"104173","customer_id":"104173","source_of_creation":"PMS","reservation_created_date":"2020-07-23 21:39:49","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"163.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120746","reservation_id":"98046","confirmation_number":"SJ12652139180","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"191.25,191.25,191.25,290.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"863.75","grand_total":"971.72","paid_amount":"971.72","room_type_id":"319","product_id":"1916","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":"104112","customer_id":"104112","source_of_creation":"PMS","reservation_created_date":"2020-07-22 16:01:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"191.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":"3105741","reservation_id":"96540","confirmation_number":"SJ12648416794","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.72,125.72,125.72,125.71,125.71,125.71,125.71","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"990.00","paid_amount":"0.00","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84637","customer_id":"84637","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:05:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107233","reservation_id":"96781","confirmation_number":"SJ12695511614","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"318.02,276.54,276.54,276.54,315.62","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1463.26","grand_total":"1646.16","paid_amount":"1646.16","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102893","customer_id":"102893","source_of_creation":"PMS","reservation_created_date":"2020-06-18 17:27:58","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"318.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120736","reservation_id":"98038","confirmation_number":"SJ12699571263","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"142.80,191.25,191.25,191.25,290.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1006.55","grand_total":"1132.37","paid_amount":"1132.37","room_type_id":"319","product_id":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104104","customer_id":"104104","source_of_creation":"PMS","reservation_created_date":"2020-07-22 14:03:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120815","reservation_id":"95305","confirmation_number":"SJ12647863510","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"159.32,159.32,184.02,184.02,185.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"872.00","grand_total":"981.00","paid_amount":"981.00","room_type_id":"413","product_id":"1266","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":"101491","customer_id":"101491","source_of_creation":"PMS","reservation_created_date":"2020-05-23 21:10:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"159.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119927","reservation_id":"97689","confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.60,133.96,133.96,180.20,180.20,180.20,277.00,277.00,144.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1728.28","grand_total":"1944.31","paid_amount":"1944.31","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103760","customer_id":"103760","source_of_creation":"PMS","reservation_created_date":"2020-07-12 12:33:42","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120518","reservation_id":"97788","confirmation_number":"SJ12613375108","room_stay_from":"2020-07-28","room_stay_to":"2020-07-31","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00","subtotal":"450.00","grand_total":"506.25","paid_amount":"337.50","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":"103859","customer_id":"103859","source_of_creation":"PMS","reservation_created_date":"2020-07-15 13:14:12","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","migrated_id":"","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"}]}],"pms_non_taxable":[{"room_stay_id":"3119413","reservation_id":"97022","confirmation_number":"SJ12690712901","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.71,125.71,125.71,125.71,125.72,125.72,125.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"880.00","paid_amount":"0.00","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-24 00:56:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.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":"3114387","reservation_id":"97118","confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-26 17:53:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3111525","reservation_id":"97282","confirmation_number":"SJ12679975597","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-07-01 21:56:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119250","reservation_id":"97199","confirmation_number":"SJ12655710304","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-28 21:44:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109026","reservation_id":"96710","confirmation_number":"SJ12674033126","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-17 16:34:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109029","reservation_id":"96711","confirmation_number":"SJ12611267945","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-17 16:40:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113312","reservation_id":"97056","confirmation_number":"SJ12614917915","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00","subtotal":"285.00","grand_total":"320.63","paid_amount":"0.00","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-25 01:43:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113327","reservation_id":"97057","confirmation_number":"SJ12642720104","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00","subtotal":"285.00","grand_total":"320.63","paid_amount":"84.38","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-25 01:46:52","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","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3105999","reservation_id":"96588","confirmation_number":"SJ12693034191","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 01:36:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106004","reservation_id":"96589","confirmation_number":"SJ12655511190","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 01:38:33","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107011","reservation_id":"96590","confirmation_number":"SJ12696030417","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 01:39:59","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107020","reservation_id":"96591","confirmation_number":"SJ12644077479","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 01:44:03","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3114180","reservation_id":"97466","confirmation_number":"SJ12616041468","room_confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"103545","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-09 17:27:30","reservation_modified_date_time":"2020-07-09 17:27:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103545","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3120747","reservation_id":"98046","confirmation_number":"SJ12690545971","room_confirmation_number":"SJ12652139180","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"104112","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-27 19:29:46","reservation_modified_date_time":"2020-07-27 19:29:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104112","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3111526","reservation_id":"97282","confirmation_number":"SJ12668606718","room_confirmation_number":"SJ12679975597","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","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":"103375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-01 21:56:09","reservation_modified_date_time":"2020-07-01 21:56:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114181","reservation_id":"97466","confirmation_number":"SJ12654219319","room_confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"103545","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-06 23:49:00","reservation_modified_date_time":"2020-07-09 17:27:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103545","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116840","reservation_id":"97853","confirmation_number":"SJ12645710375","room_confirmation_number":"SJ12620030798","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","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":"103919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-17 11:26:45","reservation_modified_date_time":"2020-07-17 11:26:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103919","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118657","reservation_id":"97846","confirmation_number":"SJ12652574952","room_confirmation_number":"SJ12639459090","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","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":"103914","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-17 00:55:37","reservation_modified_date_time":"2020-07-21 22:00:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103914","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119251","reservation_id":"97199","confirmation_number":"SJ12695091303","room_confirmation_number":"SJ12655710304","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","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":"103300","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-28 21:44:20","reservation_modified_date_time":"2020-07-23 21:06:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119655","reservation_id":"97585","confirmation_number":"SJ12636425611","room_confirmation_number":"SJ12645665642","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"103661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-09 19:29:07","reservation_modified_date_time":"2020-07-24 19:58:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103661","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119940","reservation_id":"98152","confirmation_number":"SJ12682149766","room_confirmation_number":"SJ12642248693","room_stay_from":"2020-07-25","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"104229","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 14:44:11","reservation_modified_date_time":"2020-07-25 17:49:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104229","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120161","reservation_id":"95550","confirmation_number":"SJ12692871346","room_confirmation_number":"SJ12617408885","room_stay_from":"2020-07-26","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101732","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 17:01:06","reservation_modified_date_time":"2020-07-26 12:57:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101732","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109028","reservation_id":"96710","confirmation_number":"SJ12683393251","room_confirmation_number":"SJ12674033126","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 16:34:14","reservation_modified_date_time":"2020-06-23 16:10:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109030","reservation_id":"96711","confirmation_number":"SJ12651852339","room_confirmation_number":"SJ12611267945","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 16:40:11","reservation_modified_date_time":"2020-06-23 16:11:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113314","reservation_id":"97056","confirmation_number":"SJ12685886352","room_confirmation_number":"SJ12614917915","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 01:43:50","reservation_modified_date_time":"2020-07-06 20:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113328","reservation_id":"97057","confirmation_number":"SJ12689549506","room_confirmation_number":"SJ12642720104","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 01:46:52","reservation_modified_date_time":"2020-07-06 20:42:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120586","reservation_id":"98051","confirmation_number":"SJ12659177887","room_confirmation_number":"SJ12684507683","room_stay_from":"2020-07-26","room_stay_to":"2020-07-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":"104115","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 16:42:33","reservation_modified_date_time":"2020-07-27 13:41:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104115","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119249","reservation_id":"97670","confirmation_number":"SJ12670607075","room_confirmation_number":"SJ12669827674","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"103746","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-11 20:36:37","reservation_modified_date_time":"2020-07-23 21:05:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103746","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117643","reservation_id":"97941","confirmation_number":"SJ12612551353","room_confirmation_number":"SJ12645743914","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"104009","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-19 01:19:45","reservation_modified_date_time":"2020-07-19 01:19:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104009","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119263","reservation_id":"98108","confirmation_number":"SJ12630850698","room_confirmation_number":"SJ12699664625","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","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":"104173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-23 21:39:49","reservation_modified_date_time":"2020-07-23 21:39:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104173","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119414","reservation_id":"97022","confirmation_number":"SJ12644558317","room_confirmation_number":"SJ12690712901","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","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":"103142","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-24 00:56:51","reservation_modified_date_time":"2020-07-24 12:53:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119531","reservation_id":"91368","confirmation_number":"SJ12637207607","room_confirmation_number":"SJ12617390124","room_stay_from":"2020-07-25","room_stay_to":"2020-07-31","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":"97495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-05 18:48:10","reservation_modified_date_time":"2020-07-24 17:38:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119774","reservation_id":"98144","confirmation_number":"SJ12651400914","room_confirmation_number":"SJ12686327783","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","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":"104222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 02:37:10","reservation_modified_date_time":"2020-07-25 02:37:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120748","reservation_id":"98046","confirmation_number":"SJ12629100382","room_confirmation_number":"SJ12652139180","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","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":"104112","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 16:01:32","reservation_modified_date_time":"2020-07-27 19:29:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104112","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3094800","reservation_id":"94959","confirmation_number":"SJ12649441442","room_confirmation_number":"SJ12673001401","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","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":"101147","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 15:48:50","reservation_modified_date_time":"2020-05-18 15:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101147","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3095774","reservation_id":"95175","confirmation_number":"SJ12667231092","room_confirmation_number":"SJ12621544590","room_stay_from":"2020-07-27","room_stay_to":"2020-08-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.62","paid_amount":"140.62","product_id":"1776","service_quantity":"1","customer_traveller_id":"101357","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-21 04:51:04","reservation_modified_date_time":"2020-05-21 04:51:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101357","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3105742","reservation_id":"96540","confirmation_number":"SJ12647498418","room_confirmation_number":"SJ12648416794","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:05:07","reservation_modified_date_time":"2020-06-15 15:05:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84637","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106000","reservation_id":"96588","confirmation_number":"SJ12686722107","room_confirmation_number":"SJ12693034191","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102702","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:36:52","reservation_modified_date_time":"2020-06-16 01:36:52","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106005","reservation_id":"96589","confirmation_number":"SJ12684164813","room_confirmation_number":"SJ12655511190","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:38:33","reservation_modified_date_time":"2020-06-16 01:38:33","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107028","reservation_id":"96523","confirmation_number":"SJ12620317592","room_confirmation_number":"SJ12671312898","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","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":"102629","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 02:29:09","reservation_modified_date_time":"2020-06-18 12:47:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102629","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107234","reservation_id":"96781","confirmation_number":"SJ12650398627","room_confirmation_number":"SJ12695511614","room_stay_from":"2020-07-27","room_stay_to":"2020-08-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":"102893","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 17:27:58","reservation_modified_date_time":"2020-06-18 17:30:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102893","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113367","reservation_id":"93587","confirmation_number":"SJ12637257008","room_confirmation_number":"SJ12696472420","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"99816","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-24 21:57:09","reservation_modified_date_time":"2020-07-06 20:53:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99816","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114388","reservation_id":"97118","confirmation_number":"SJ12643657961","room_confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"103236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 17:53:20","reservation_modified_date_time":"2020-07-10 01:05:11","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120575","reservation_id":"92849","confirmation_number":"SJ12694888233","room_confirmation_number":"SJ12681495794","room_stay_from":"2020-07-27","room_stay_to":"2020-08-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":"99001","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 02:38:08","reservation_modified_date_time":"2020-07-27 12:11:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99001","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120737","reservation_id":"98038","confirmation_number":"SJ12650729354","room_confirmation_number":"SJ12699571263","room_stay_from":"2020-07-27","room_stay_to":"2020-08-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":"104104","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 14:03:18","reservation_modified_date_time":"2020-07-27 19:27:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104104","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120816","reservation_id":"95305","confirmation_number":"SJ12695131965","room_confirmation_number":"SJ12647863510","room_stay_from":"2020-07-27","room_stay_to":"2020-08-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":"101491","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-23 21:10:05","reservation_modified_date_time":"2020-07-27 22:46:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101491","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107014","reservation_id":"96590","confirmation_number":"SJ12626622188","room_confirmation_number":"SJ12696030417","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","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":"102704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:39:59","reservation_modified_date_time":"2020-06-18 12:41:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107022","reservation_id":"96591","confirmation_number":"SJ12624927899","room_confirmation_number":"SJ12644077479","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","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":"102704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:44:03","reservation_modified_date_time":"2020-06-18 12:45:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119928","reservation_id":"97689","confirmation_number":"SJ12613152976","room_confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"103760","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-12 12:33:42","reservation_modified_date_time":"2020-07-25 17:33:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103760","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120517","reservation_id":"97788","confirmation_number":"SJ12630215421","room_confirmation_number":"SJ12613375108","room_stay_from":"2020-07-28","room_stay_to":"2020-07-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103859","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-15 13:14:12","reservation_modified_date_time":"2020-07-27 10:32:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103859","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3120587","reservation_id":"98051","confirmation_number":"SJ12673080091","room_confirmation_number":"SJ12684507683","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":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 13:43:39","reservation_modified_date_time":"2020-07-27 13:43:39","customer_id":"104115","parentCustTravId":"104115","customer_traveller_id":"104115","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":"3120819","reservation_id":"97941","confirmation_number":"SJ12613982176","room_confirmation_number":"SJ12645743914","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"0.00","product_id":"1659","service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 23:34:31","reservation_modified_date_time":"2020-07-27 23:34:31","customer_id":"104009","parentCustTravId":"104009","customer_traveller_id":"104009","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":"27.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3120766","reservation_id":"98253","confirmation_number":"SJ12614953554","room_confirmation_number":"SJ12660603682","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"2","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 20:42:05","reservation_modified_date_time":"2020-07-27 20:42:05","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"27.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3120806","reservation_id":"98259","confirmation_number":"SJ12699196291","room_confirmation_number":"SJ12665214502","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"60.00","paid_amount":"60.00","product_id":null,"service_quantity":"2","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 21:43:25","reservation_modified_date_time":"2020-07-27 21:43:25","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":"55.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3120807","reservation_id":"98259","confirmation_number":"SJ12645367437","room_confirmation_number":"SJ12665214502","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"2","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 21:43:25","reservation_modified_date_time":"2020-07-27 21:43:25","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":"27.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3120810","reservation_id":"98260","confirmation_number":"SJ12639194904","room_confirmation_number":"SJ12655351925","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 21:51:20","reservation_modified_date_time":"2020-07-27 21:51:20","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":"27.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3120811","reservation_id":"98260","confirmation_number":"SJ12622702675","room_confirmation_number":"SJ12655351925","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 21:51:20","reservation_modified_date_time":"2020-07-27 21:51:20","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":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3120812","reservation_id":"98260","confirmation_number":"SJ12624381201","room_confirmation_number":"SJ12655351925","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.99","grand_total":"16.08","paid_amount":"16.08","product_id":null,"service_quantity":"3","product_name":"Key Lime Soap","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 21:51:20","reservation_modified_date_time":"2020-07-27 21:51:20","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":"14.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3120644","reservation_id":"98234","confirmation_number":"SJ12620133670","room_confirmation_number":"SJ12657721671","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-27 15:03:06","reservation_modified_date_time":"2020-07-27 15:03:06","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}