{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-20","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":11,"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-07-25","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1271,1272,1307,1308,1262,1263,1311,1312,1267,1268,1269,1270","bundle_block_bookings":[{"confirmation_number":"SJB12612849645","room_stay_from":"2020-07-19","room_stay_to":"2020-07-21","bundle_room":"1"},{"confirmation_number":"SJB12657120649","room_stay_from":"2020-07-19","room_stay_to":"2020-07-21","bundle_room":"1"},{"confirmation_number":"SJB12650791016","room_stay_from":"2020-07-18","room_stay_to":"2020-07-21","bundle_room":"1"},{"confirmation_number":"SJB12631795255","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","bundle_room":"1"},{"confirmation_number":"SJB12645599732","room_stay_from":"2020-07-20","room_stay_to":"2020-07-22","bundle_room":"1"},{"confirmation_number":"SJB12658964183","room_stay_from":"2020-07-19","room_stay_to":"2020-07-23","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3116746","reservation_id":"97815","confirmation_number":"SJ12645121327","room_stay_from":"2020-07-18","room_stay_to":"2020-07-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"276.80,194.40,194.40","nightly_discount":"0,0,0","subtotal":"665.60","grand_total":"748.80","paid_amount":"748.80","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3419525183","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":"103888","customer_id":"103888","source_of_creation":"Booking.com","reservation_created_date":"2020-07-16 14:56:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"133.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"194.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116824","reservation_id":"97759","confirmation_number":"SJ12619035689","room_stay_from":"2020-07-18","room_stay_to":"2020-07-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"246.8,164.4,164.4","nightly_discount":"0,0,0","subtotal":"575.60","grand_total":"647.55","paid_amount":"647.55","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3297425994","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103832","customer_id":"103832","source_of_creation":"Booking.com","reservation_created_date":"2020-07-14 17:04:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"144.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"164.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117648","reservation_id":"97675","confirmation_number":"SJ12644992286","room_stay_from":"2020-07-19","room_stay_to":"2020-07-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.40,138.40","nightly_discount":"0,0","subtotal":"276.80","grand_total":"311.40","paid_amount":"311.40","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-2505864553","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":"103750","customer_id":"103750","source_of_creation":"Booking.com","reservation_created_date":"2020-07-11 22:40:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"58.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116713","reservation_id":"95818","confirmation_number":"SJ12674482855","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"149.2,149.2,122,122,93.2","nightly_discount":"0,0,0,0,0","subtotal":"635.60","grand_total":"715.05","paid_amount":"715.05","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-2549320888","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101975","customer_id":"101975","source_of_creation":"Booking.com","reservation_created_date":"2020-06-02 18:44:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"181.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3116277","reservation_id":"95219","confirmation_number":"SJ12664576909","room_stay_from":"2020-07-17","room_stay_to":"2020-07-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.20,155.20,134.40,134.40,134.40,134.40","nightly_discount":"0,0,0,0,0,0","subtotal":"848.00","grand_total":"954.00","paid_amount":"954.00","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1665273433","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":"101401","customer_id":"101401","source_of_creation":"Expedia","reservation_created_date":"2020-05-22 00:22:11","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":"134.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116717","reservation_id":"97806","confirmation_number":"SJ12682290535","room_stay_from":"2020-07-18","room_stay_to":"2020-07-23","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"205.44,139.52,139.52,139.52,139.52","nightly_discount":"0,0,0,0,0","subtotal":"763.52","grand_total":"858.96","paid_amount":"858.96","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1679905036","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":"103878","customer_id":"103878","source_of_creation":"Expedia","reservation_created_date":"2020-07-16 01:18:08","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":"139.52","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":"3117461","reservation_id":"95005","confirmation_number":"SJ12696624914","room_stay_from":"2020-07-17","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.36,95.36,82.56,82.56,82.56,82.56,82.56,95.36","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"698.88","grand_total":"786.24","paid_amount":"786.24","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1664737254","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":"101198","customer_id":"101198","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 00:37:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.56","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":"3114765","reservation_id":"96202","confirmation_number":"SJ12639689933","room_stay_from":"2020-07-15","room_stay_to":"2020-07-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00,290.00,290.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"1480.00","grand_total":"1665.00","paid_amount":"1665.00","room_type_id":"412","product_id":"1866","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":"102324","customer_id":"102324","source_of_creation":"FE","reservation_created_date":"2020-06-10 00:33:25","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.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":"3115854","reservation_id":"96510","confirmation_number":"SJ12643103333","room_stay_from":"2020-07-19","room_stay_to":"2020-07-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.90,174.90","nightly_discount":"0.00,0.00","subtotal":"349.80","grand_total":"393.53","paid_amount":"393.53","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"97901","customer_id":"97901","source_of_creation":"FE","reservation_created_date":"2020-06-14 22:16:48","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":"174.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3112999","reservation_id":"96085","confirmation_number":"SJ12661380581","room_stay_from":"2020-07-18","room_stay_to":"2020-07-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.44,174.89,174.89,145.76","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"698.98","grand_total":"786.35","paid_amount":"786.35","room_type_id":"319","product_id":"1915","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":"102209","customer_id":"102209","source_of_creation":"FE","reservation_created_date":"2020-06-08 02:14:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117895","reservation_id":"95157","confirmation_number":"SJ12679746112","room_stay_from":"2020-07-20","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.55,122.55,142.55,142.55,142.55","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"672.75","grand_total":"756.85","paid_amount":"756.85","room_type_id":"413","product_id":"1268","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":"86804","customer_id":"86804","source_of_creation":"FE","reservation_created_date":"2020-05-20 21:36:34","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":"122.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":"3117900","reservation_id":"97918","confirmation_number":"SJ12616153263","room_stay_from":"2020-07-20","room_stay_to":"2020-07-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.12","nightly_discount":"0.00","subtotal":"159.12","grand_total":"179.01","paid_amount":"179.01","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":"103991","customer_id":"103991","source_of_creation":"PMS","reservation_created_date":"2020-07-18 19:11:55","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":"159.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118184","reservation_id":"97988","confirmation_number":"SJ12656858715","room_stay_from":"2020-07-20","room_stay_to":"2020-07-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.12","nightly_discount":"0.00","subtotal":"125.12","grand_total":"140.76","paid_amount":"140.76","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104056","customer_id":"104056","source_of_creation":"PMS","reservation_created_date":"2020-07-20 21:31:56","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118037","reservation_id":"97241","confirmation_number":"SJ12622696882","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"290.00,290.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"1255.00","grand_total":"1411.88","paid_amount":"1158.75","room_type_id":"319","product_id":"1917","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":"103342","customer_id":"103342","source_of_creation":"PMS","reservation_created_date":"2020-06-30 14:42:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"225.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":"3118128","reservation_id":"96038","confirmation_number":"SJ12629265738","room_stay_from":"2020-07-20","room_stay_to":"2020-07-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"178.50,178.50,178.50","nightly_discount":"19.38,19.38,19.38","subtotal":"535.50","grand_total":"537.03","paid_amount":"537.03","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":"99511","customer_id":"99511","source_of_creation":"PMS","reservation_created_date":"2020-06-07 14:34:20","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":"178.50","currentDayDiscount":"19.38","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118136","reservation_id":"97343","confirmation_number":"SJ12628885770","room_stay_from":"2020-07-20","room_stay_to":"2020-07-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.50,178.50,178.50","nightly_discount":"19.38,19.38,19.38","subtotal":"535.50","grand_total":"537.03","paid_amount":"537.03","room_type_id":"319","product_id":"1286","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":"99511","customer_id":"99511","source_of_creation":"PMS","reservation_created_date":"2020-07-03 16:40:41","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":"178.50","currentDayDiscount":"19.38","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113861","reservation_id":"97543","confirmation_number":"SJ12612018357","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00,111.75,111.75,111.75,111.75,111.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"988.75","grand_total":"1112.35","paid_amount":"1112.35","room_type_id":"413","product_id":"1271","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":"103616","customer_id":"103616","source_of_creation":"PMS","reservation_created_date":"2020-07-08 18:07:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3116730","reservation_id":"97429","confirmation_number":"SJ12665901478","room_stay_from":"2020-07-18","room_stay_to":"2020-07-25","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":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-07-06 01:13:22","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":[],"negotiated_non_taxable":[{"room_stay_id":"3109865","reservation_id":"97090","confirmation_number":"SJ12623685175","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"1756","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-26 00:13:36","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":"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":"3109867","reservation_id":"97091","confirmation_number":"SJ12693369595","room_stay_from":"2020-07-19","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"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-26 00:16:16","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":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3112155","reservation_id":"96853","confirmation_number":"SJ12673840595","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-20 02:23:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3117939","reservation_id":"95462","confirmation_number":"SJ12693797268","room_stay_from":"2020-07-16","room_stay_to":"2020-07-20","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,156.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"319","product_id":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 14:08:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"78.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116819","reservation_id":"97467","confirmation_number":"SJ12660043218","room_stay_from":"2020-07-18","room_stay_to":"2020-07-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"0.00","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-07-07 00:03:57","service_canceled_date_time":"2020-07-20 15:26:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"0.00","deltaChange":-156.66,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3116825","reservation_id":"97759","confirmation_number":"SJ12626268163","room_confirmation_number":"SJ12619035689","room_stay_from":"2020-07-18","room_stay_to":"2020-07-21","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"103832","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-17 02:57:28","reservation_modified_date_time":"2020-07-17 02:57:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103832","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116715","reservation_id":"95818","confirmation_number":"SJ12654664350","room_confirmation_number":"SJ12674482855","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","room_stay_status":"Active","nightly_price":"50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"101975","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-17 01:07:03","reservation_modified_date_time":"2020-07-17 01:07:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101975","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3114766","reservation_id":"96202","confirmation_number":"SJ12693155639","room_confirmation_number":"SJ12639689933","room_stay_from":"2020-07-15","room_stay_to":"2020-07-21","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":"102324","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 00:33:25","reservation_modified_date_time":"2020-07-11 16:00:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102324","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":"3115856","reservation_id":"96510","confirmation_number":"SJ12624985609","room_confirmation_number":"SJ12643103333","room_stay_from":"2020-07-19","room_stay_to":"2020-07-21","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":"97901","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-14 22:16:48","reservation_modified_date_time":"2020-07-14 12:06:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97901","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":"3116747","reservation_id":"97815","confirmation_number":"SJ12685390529","room_confirmation_number":"SJ12645121327","room_stay_from":"2020-07-18","room_stay_to":"2020-07-21","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":"103888","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 14:56:06","reservation_modified_date_time":"2020-07-17 01:44:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103888","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":"3116826","reservation_id":"97759","confirmation_number":"SJ12644593656","room_confirmation_number":"SJ12619035689","room_stay_from":"2020-07-18","room_stay_to":"2020-07-21","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":"103832","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-14 17:04:09","reservation_modified_date_time":"2020-07-17 02:57:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103832","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117649","reservation_id":"97675","confirmation_number":"SJ12636789224","room_confirmation_number":"SJ12644992286","room_stay_from":"2020-07-19","room_stay_to":"2020-07-21","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":"103750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-11 22:40:07","reservation_modified_date_time":"2020-07-19 01:37:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103750","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":"3117901","reservation_id":"97918","confirmation_number":"SJ12688697658","room_confirmation_number":"SJ12616153263","room_stay_from":"2020-07-20","room_stay_to":"2020-07-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"103991","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 19:11:55","reservation_modified_date_time":"2020-07-20 00:26:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103991","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":"3113000","reservation_id":"96085","confirmation_number":"SJ12668349350","room_confirmation_number":"SJ12661380581","room_stay_from":"2020-07-18","room_stay_to":"2020-07-22","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":"102209","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 02:14:30","reservation_modified_date_time":"2020-07-06 01:10:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102209","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":"3116716","reservation_id":"95818","confirmation_number":"SJ12685564347","room_confirmation_number":"SJ12674482855","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","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":"101975","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 18:44:12","reservation_modified_date_time":"2020-07-17 01:07:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101975","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.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":"3118038","reservation_id":"97241","confirmation_number":"SJ12646842239","room_confirmation_number":"SJ12622696882","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"103342","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 14:42:13","reservation_modified_date_time":"2020-07-20 15:42:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103342","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":"3116279","reservation_id":"95219","confirmation_number":"SJ12653974752","room_confirmation_number":"SJ12664576909","room_stay_from":"2020-07-17","room_stay_to":"2020-07-23","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":"101401","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-22 00:22:11","reservation_modified_date_time":"2020-07-15 22:00:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101401","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":"3116718","reservation_id":"97806","confirmation_number":"SJ12626230046","room_confirmation_number":"SJ12682290535","room_stay_from":"2020-07-18","room_stay_to":"2020-07-23","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":"103878","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 01:18:08","reservation_modified_date_time":"2020-07-17 01:07:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103878","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":"3118138","reservation_id":"97343","confirmation_number":"SJ12642071786","room_confirmation_number":"SJ12628885770","room_stay_from":"2020-07-20","room_stay_to":"2020-07-23","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":"103427","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-03 16:40:41","reservation_modified_date_time":"2020-07-20 19:54:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99511","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109866","reservation_id":"97090","confirmation_number":"SJ12699029325","room_confirmation_number":"SJ12623685175","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"103210","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 00:13:36","reservation_modified_date_time":"2020-06-26 00:13:36","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109868","reservation_id":"97091","confirmation_number":"SJ12659687426","room_confirmation_number":"SJ12693369595","room_stay_from":"2020-07-19","room_stay_to":"2020-07-24","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":"103211","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 00:16:16","reservation_modified_date_time":"2020-06-26 00:16:16","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":"3112156","reservation_id":"96853","confirmation_number":"SJ12647401310","room_confirmation_number":"SJ12673840595","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"102982","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 02:23:05","reservation_modified_date_time":"2020-07-03 16:33:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113863","reservation_id":"97543","confirmation_number":"SJ12672171083","room_confirmation_number":"SJ12612018357","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"103616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-08 18:07:25","reservation_modified_date_time":"2020-07-08 18:17:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103616","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":"3116732","reservation_id":"97429","confirmation_number":"SJ12625155325","room_confirmation_number":"SJ12665901478","room_stay_from":"2020-07-18","room_stay_to":"2020-07-25","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":"103516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-06 01:13:22","reservation_modified_date_time":"2020-07-17 01:41:31","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":"3117460","reservation_id":"95005","confirmation_number":"SJ12630760262","room_confirmation_number":"SJ12696624914","room_stay_from":"2020-07-17","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102619","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 00:37:09","reservation_modified_date_time":"2020-07-18 17:35:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101198","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":"3117897","reservation_id":"95157","confirmation_number":"SJ12623063876","room_confirmation_number":"SJ12679746112","room_stay_from":"2020-07-20","room_stay_to":"2020-07-25","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":"86804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 21:36:34","reservation_modified_date_time":"2020-07-20 00:25:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86804","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":"3117941","reservation_id":"95462","confirmation_number":"SJ12681396066","room_confirmation_number":"SJ12693797268","room_stay_from":"2020-07-16","room_stay_to":"2020-07-20","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101655","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 14:08:34","reservation_modified_date_time":"2020-07-20 13:41:44","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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"}]},{"room_stay_id":"3116821","reservation_id":"97467","confirmation_number":"SJ12646285029","room_confirmation_number":"SJ12660043218","room_stay_from":"2020-07-18","room_stay_to":"2020-07-21","room_stay_status":"Canceled","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-07 00:03:57","reservation_modified_date_time":"2020-07-17 02:56:41","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"103554","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-07-20 15:26:17","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-50,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[{"room_stay_id":"3117943","reservation_id":"95462","confirmation_number":"SJ12610817488","room_confirmation_number":"SJ12693797268","room_stay_from":"2020-07-20","room_stay_to":"2020-07-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Daily Resort","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-20 13:42:32","reservation_modified_date_time":"2020-07-20 13:42:32","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"82465","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"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"}]}],"bar_taxable":[{"room_stay_id":"3117923","reservation_id":"97970","confirmation_number":"SJ12648892265","room_confirmation_number":"SJ12635112978","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-20 13:26:12","reservation_modified_date_time":"2020-07-20 13:26:12","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3117948","reservation_id":"97972","confirmation_number":"SJ12624139180","room_confirmation_number":"SJ12676708761","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-20 13:57:39","reservation_modified_date_time":"2020-07-20 13:57:39","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}