{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-05-16","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,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":22,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1307,1308,1269,1270,1309,1310,1311,1312,1271,1272,1267,1268,1302,1303,1304,1305,1260,1261,1262,1263,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12672571083","room_stay_from":"2021-05-13","room_stay_to":"2021-05-17","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12638516764","room_stay_from":"2021-05-13","room_stay_to":"2021-05-17","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12633239545","room_stay_from":"2021-05-16","room_stay_to":"2021-05-17","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12665658517","room_stay_from":"2021-05-14","room_stay_to":"2021-05-18","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12628889127","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12668921949","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12617471977","room_stay_from":"2021-05-14","room_stay_to":"2021-05-19","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12641929847","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12636280509","room_stay_from":"2021-05-12","room_stay_to":"2021-05-19","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12686992040","room_stay_from":"2021-05-12","room_stay_to":"2021-05-19","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12683442812","room_stay_from":"2021-05-16","room_stay_to":"2021-05-20","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12615412571","room_stay_from":"2021-05-16","room_stay_to":"2021-05-20","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12692901336","room_stay_from":"2021-05-15","room_stay_to":"2021-05-21","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12611231092","room_stay_from":"2021-05-15","room_stay_to":"2021-05-21","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12683310708","room_stay_from":"2021-05-15","room_stay_to":"2021-05-21","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12698531951","room_stay_from":"2021-05-15","room_stay_to":"2021-05-21","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12624223006","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12695012775","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","bundle_room":"0","product_id":"1711"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3211374","reservation_id":"109688","confirmation_number":"SJ12663919874","room_stay_from":"2021-05-11","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,230.30,230.30,160.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1101.80","grand_total":"1239.53","paid_amount":"1239.53","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3793816742","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":"116176","customer_id":"116176","source_of_creation":"Booking.com","reservation_created_date":"2021-03-07 19:31:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"225.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","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":"3216625","reservation_id":"110422","confirmation_number":"SJ12636948782","room_stay_from":"2021-05-15","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"3","nightly_price":"306.8,236.8,236.8,236.8,236.8,236.8","nightly_discount":"0,0,0,0,0,0","subtotal":"1490.80","grand_total":"1677.15","paid_amount":"1677.15","room_type_id":"320","product_id":"1320","siteminder_id":"BDC-2138378853","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":"116934","customer_id":"116934","source_of_creation":"Booking.com","reservation_created_date":"2021-03-16 15:15:17","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1260,1261","currentDayPrice":"236.8","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216688","reservation_id":"106519","confirmation_number":"SJ12622734716","room_stay_from":"2021-05-16","room_stay_to":"2021-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.30,139.30,139.30,139.30","nightly_discount":"0,0,0,0","subtotal":"557.20","grand_total":"626.85","paid_amount":"626.85","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3582745897","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":"112928","customer_id":"112928","source_of_creation":"Booking.com","reservation_created_date":"2021-01-30 22:40:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"118.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.30","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":"3216695","reservation_id":"110422","confirmation_number":"SJ12654705902","room_stay_from":"2021-05-15","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"5","nightly_price":"331.80,261.80,261.80,261.80,261.80,261.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1640.80","grand_total":"1845.90","paid_amount":"1845.90","room_type_id":"320","product_id":"1321","siteminder_id":"BDC-2138378853","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":"116934","customer_id":"116934","source_of_creation":"Booking.com","reservation_created_date":"2021-03-16 15:15:52","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"261.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":"3217527","reservation_id":"110556","confirmation_number":"SJ12654633480","room_stay_from":"2021-05-16","room_stay_to":"2021-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"212.06,212.06,212.06,212.06","nightly_discount":"0,0,0,0","subtotal":"848.24","grand_total":"954.27","paid_amount":"954.27","room_type_id":"320","product_id":"1329","siteminder_id":"BDC-3240787836","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":"117069","customer_id":"117069","source_of_creation":"Booking.com","reservation_created_date":"2021-03-17 19:27:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"170.68","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"212.06","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":"3228788","reservation_id":"112152","confirmation_number":"SJ12681664794","room_stay_from":"2021-05-14","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,224.25,224.25,224.25","nightly_discount":"0,0,0,0,0","subtotal":"1271.25","grand_total":"1430.15","paid_amount":"1430.15","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-2918475701","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":"118726","customer_id":"118726","source_of_creation":"Booking.com","reservation_created_date":"2021-04-05 15:02:36","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"224.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":"3237665","reservation_id":"108242","confirmation_number":"SJ12673382426","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.71,144.02,144.02","nightly_discount":"0,0,0","subtotal":"471.75","grand_total":"530.72","paid_amount":"530.72","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3090933156","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":"114710","customer_id":"114710","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 03:50:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"98.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"144.02","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":"3240835","reservation_id":"111856","confirmation_number":"SJ12625981318","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,224.25,224.25","nightly_discount":"0.00,0.00,0.00","subtotal":"747.75","grand_total":"841.22","paid_amount":"841.22","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3709800309","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":"122045","customer_id":"122045","source_of_creation":"Booking.com","reservation_created_date":"2021-04-02 00:07:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"148.09","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"224.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":"3241097","reservation_id":"113277","confirmation_number":"SJ12699326427","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"308.88,308.88","nightly_discount":"0,0","subtotal":"617.76","grand_total":"694.98","paid_amount":"694.98","room_type_id":"319","product_id":"1293","siteminder_id":"BDC-3940930762","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":"119866","customer_id":"119866","source_of_creation":"Booking.com","reservation_created_date":"2021-04-18 03:57:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"107.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"308.88","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":"3250670","reservation_id":"108699","confirmation_number":"SJ12659925711","room_stay_from":"2021-05-12","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"265.30,265.30,314.30,314.30,244.30,244.30,244.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1892.10","grand_total":"2128.62","paid_amount":"2128.62","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-2321337914","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":"115150","customer_id":"115150","source_of_creation":"Booking.com","reservation_created_date":"2021-02-27 01:23:25","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"372.05","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"244.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3251421","reservation_id":"109311","confirmation_number":"SJ12695006217","room_stay_from":"2021-05-13","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"212.06,268.76,268.76,212.06","nightly_discount":"10.60,13.44,13.44,10.60","subtotal":"961.64","grand_total":"1027.76","paid_amount":"1027.76","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-2467585823","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":"115779","customer_id":"115779","source_of_creation":"Booking.com","reservation_created_date":"2021-03-04 13:52:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"191.10","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"212.06","currentDayDiscount":"10.60","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252350","reservation_id":"112693","confirmation_number":"SJ12626017502","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.28,215.28","nightly_discount":"0,0","subtotal":"502.56","grand_total":"565.38","paid_amount":"565.38","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3178764727","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":"119281","customer_id":"119281","source_of_creation":"Booking.com","reservation_created_date":"2021-04-11 18:25:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"99.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252392","reservation_id":"110346","confirmation_number":"SJ12673890806","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"270.57,203.07,203.07","nightly_discount":"0.00,0.00,0.00","subtotal":"676.71","grand_total":"761.30","paid_amount":"761.30","room_type_id":"320","product_id":"1332","siteminder_id":"BDC-3576293607","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"300.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122043","customer_id":"122043","source_of_creation":"Booking.com","reservation_created_date":"2021-03-15 14:26:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"189.31","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"203.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252469","reservation_id":"115311","confirmation_number":"SJ12685315147","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.86,199.86,199.86","nightly_discount":"0,0,0","subtotal":"599.58","grand_total":"674.53","paid_amount":"674.53","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2661561128","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":"122024","customer_id":"122024","source_of_creation":"Booking.com","reservation_created_date":"2021-05-16 03:33:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"121.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"199.86","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":"3202430","reservation_id":"108219","confirmation_number":"SJ12632302076","room_stay_from":"2021-05-15","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.30,139.30,139.30,139.30","nightly_discount":"0,0,0,0","subtotal":"606.20","grand_total":"681.98","paid_amount":"681.98","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1740299222","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":"114683","customer_id":"114683","source_of_creation":"Expedia","reservation_created_date":"2021-02-21 23:02:11","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":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.30","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":"3207156","reservation_id":"109005","confirmation_number":"SJ12668445071","room_stay_from":"2021-05-16","room_stay_to":"2021-05-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,160.30,160.30,230.30,230.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1262.10","grand_total":"1419.87","paid_amount":"180.34","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1743032172","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":"115471","customer_id":"115471","source_of_creation":"Expedia","reservation_created_date":"2021-03-02 05:32:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","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":"3238399","reservation_id":"113256","confirmation_number":"SJ12626654144","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.40,197.40,197.40","nightly_discount":"0,0,0","subtotal":"652.20","grand_total":"733.73","paid_amount":"733.73","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1760760659","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":"119846","customer_id":"119846","source_of_creation":"Expedia","reservation_created_date":"2021-04-17 20:53:22","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"197.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":"3244145","reservation_id":"114190","confirmation_number":"SJ12689961256","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"220.4,202.8","nightly_discount":"0,0","subtotal":"423.20","grand_total":"476.10","paid_amount":"476.10","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1765371507","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":"120831","customer_id":"120831","source_of_creation":"Expedia","reservation_created_date":"2021-04-30 03:50:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"202.8","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3244150","reservation_id":"112446","confirmation_number":"SJ12673107750","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.25,224.25,224.25","nightly_discount":"0,0,0","subtotal":"672.75","grand_total":"756.85","paid_amount":"756.85","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1757259156","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":"119016","customer_id":"119016","source_of_creation":"Expedia","reservation_created_date":"2021-04-08 16:34:36","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"224.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":"3248632","reservation_id":"114802","confirmation_number":"SJ12667978614","room_stay_from":"2021-05-16","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.32","nightly_discount":"0","subtotal":"203.32","grand_total":"228.74","paid_amount":"228.74","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1768728610","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":"121541","customer_id":"121541","source_of_creation":"Expedia","reservation_created_date":"2021-05-08 23:55:08","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":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"203.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"}]},{"room_stay_id":"3248723","reservation_id":"114730","confirmation_number":"SJ12698672073","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75,269.25","nightly_discount":"0,0,0,0,0","subtotal":"1256.25","grand_total":"1413.28","paid_amount":"1413.28","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1768316958","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":"121445","customer_id":"121445","source_of_creation":"Expedia","reservation_created_date":"2021-05-07 20:35:52","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","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":"3250560","reservation_id":"113550","confirmation_number":"SJ12657300842","room_stay_from":"2021-05-15","room_stay_to":"2021-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"269.25,224.25,224.25,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1211.25","grand_total":"1362.65","paid_amount":"1362.65","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1762195399","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":"120344","customer_id":"120149","source_of_creation":"Expedia","reservation_created_date":"2021-04-21 18:54:42","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"224.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":"3251312","reservation_id":"113698","confirmation_number":"SJ12678056959","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.76,191.36","nightly_discount":"0,0","subtotal":"421.12","grand_total":"473.76","paid_amount":"473.76","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1762892972","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":"120309","customer_id":"120309","source_of_creation":"Expedia","reservation_created_date":"2021-04-23 14:54:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"84.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"191.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252348","reservation_id":"113024","confirmation_number":"SJ12651286854","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,239.20","nightly_discount":"0,0","subtotal":"558.40","grand_total":"628.20","paid_amount":"628.20","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1759763076","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":"119606","customer_id":"119606","source_of_creation":"Expedia","reservation_created_date":"2021-04-15 03:18:18","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.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":"3252662","reservation_id":"113709","confirmation_number":"SJ12681754487","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.76,191.36","nightly_discount":"0.00,0.00","subtotal":"421.12","grand_total":"473.76","paid_amount":"473.76","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1762917178","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":"120319","customer_id":"120319","source_of_creation":"Expedia","reservation_created_date":"2021-04-23 16:09:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"191.36","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252789","reservation_id":"114396","confirmation_number":"SJ12665157383","room_stay_from":"2021-06-10","room_stay_to":"2021-06-13","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.40,215.40,215.40","nightly_discount":"0,0,0","subtotal":"646.20","grand_total":"726.98","paid_amount":"0.00","room_type_id":"319","product_id":"1307","siteminder_id":"EXP-1766353162","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":"121067","customer_id":"121067","source_of_creation":"Expedia","reservation_created_date":"2021-05-03 00:05:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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":"3252845","reservation_id":"115044","confirmation_number":"SJ12646720605","room_stay_from":"2021-06-11","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"205.4,205.4,205.4","nightly_discount":"0,0,0","subtotal":"616.20","grand_total":"693.23","paid_amount":"0.00","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1769935580","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":"121759","customer_id":"121759","source_of_creation":"Expedia","reservation_created_date":"2021-05-12 01:36:36","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":"","promotion_code":"","sub_hotel_id":"126","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"}]}],"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":[{"room_stay_id":"3250516","reservation_id":"112469","confirmation_number":"SJ12612818479","room_stay_from":"2021-05-12","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"307.11,316.61,316.61,316.61,316.61","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1573.55","grand_total":"1823.52","paid_amount":"1823.52","room_type_id":"319","product_id":"1915","siteminder_id":"ABB-HMS9SNRCPK","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1583.05","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119040","customer_id":"119040","source_of_creation":"Airbnb","reservation_created_date":"2021-04-08 21:53:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"46.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"316.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3252506","reservation_id":"110006","confirmation_number":"SJ12658870057","room_stay_from":"2021-05-16","room_stay_to":"2021-05-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"180.39,182.58","nightly_discount":"0.00,0.00","subtotal":"362.97","grand_total":"420.63","paid_amount":"420.63","room_type_id":"413","product_id":"1269","siteminder_id":"ABB-HMJREBNJN9","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"365.16","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116498","customer_id":"116498","source_of_creation":"Airbnb","reservation_created_date":"2021-03-10 23:38:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"10.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"180.39","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3252514","reservation_id":"114456","confirmation_number":"SJ12683605893","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"296.57,302.92,302.92","nightly_discount":"0.00,0.00,0.00","subtotal":"902.41","grand_total":"1068.70","paid_amount":"1068.70","room_type_id":"412","product_id":"1316","siteminder_id":"ABB-HMSKR2W4TH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"908.76","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121147","customer_id":"121147","source_of_creation":"Airbnb","reservation_created_date":"2021-05-03 22:39:25","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"31.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"296.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3252530","reservation_id":"110904","confirmation_number":"SJ12649433285","room_stay_from":"2021-05-13","room_stay_to":"2021-05-15","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"268.00,274.17","nightly_discount":"0.00,0.00","subtotal":"542.17","grand_total":"715.49","paid_amount":"1264.25","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HMYPD9YQM4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1097.52","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117429","customer_id":"117429","source_of_creation":"Airbnb","reservation_created_date":"2021-03-21 19:20:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"32.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"-274.38","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3252820","reservation_id":"115279","confirmation_number":"SJ12673959994","room_stay_from":"2021-06-12","room_stay_to":"2021-06-18","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"371.79,371.79,371.79,371.79,371.79,371.79","nightly_discount":"0,0,0,0,0,0","subtotal":"2230.74","grand_total":"2583.02","paid_amount":"0.00","room_type_id":"319","product_id":"1286","siteminder_id":"ABB-HMPNCTNCXX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"2230.74","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121986","customer_id":"121986","source_of_creation":"Airbnb","reservation_created_date":"2021-05-15 17:32:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"65.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3249692","reservation_id":"112540","confirmation_number":"SJ12658769860","room_stay_from":"2021-05-14","room_stay_to":"2021-05-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"318.00,318.00,318.00,318.00","nightly_discount":"0.00,0,0,0","subtotal":"1272.00","grand_total":"1431.00","paid_amount":"1431.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":"119113","customer_id":"119113","source_of_creation":"FE","reservation_created_date":"2021-04-09 18:13:43","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"318.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":"3252735","reservation_id":"108784","confirmation_number":"SJ12693064094","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,149.25,149.25","nightly_discount":"0.00,0,0","subtotal":"447.75","grand_total":"503.72","paid_amount":"503.72","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115237","customer_id":"115237","source_of_creation":"FE","reservation_created_date":"2021-02-27 22:43:30","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":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"149.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":"3252934","reservation_id":"113053","confirmation_number":"SJ12637536460","room_stay_from":"2021-05-19","room_stay_to":"2021-05-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.00,288.00,340.50","nightly_discount":"14.40,14.40,17.03","subtotal":"916.50","grand_total":"979.50","paid_amount":"298.69","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115230","customer_id":"115230","source_of_creation":"FE","reservation_created_date":"2021-04-15 19:42:55","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3216739","reservation_id":"109927","confirmation_number":"SJ12688882459","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"261.75,261.75,261.75,261.75,261.75","nightly_discount":"13.09,13.09,13.09,13.09,13.09","subtotal":"1308.75","grand_total":"1398.72","paid_amount":"1398.72","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":"116421","customer_id":"116421","source_of_creation":"PMS","reservation_created_date":"2021-03-10 02:25:43","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":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"261.75","currentDayDiscount":"13.09","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3221948","reservation_id":"111216","confirmation_number":"SJ12612511583","room_stay_from":"2021-05-08","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00","nightly_discount":"20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40","subtotal":"2652.00","grand_total":"2685.15","paid_amount":"2685.15","room_type_id":"319","product_id":"1314","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":"102743","customer_id":"102743","source_of_creation":"PMS","reservation_created_date":"2021-03-24 23:11:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"204.00","currentDayDiscount":"20.40","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3238384","reservation_id":"109275","confirmation_number":"SJ12626088195","room_stay_from":"2021-05-15","room_stay_to":"2021-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"693.00","grand_total":"779.63","paid_amount":"196.88","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":"114227","customer_id":"114227","source_of_creation":"PMS","reservation_created_date":"2021-03-04 01:22:22","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"99.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":"3250723","reservation_id":"115093","confirmation_number":"SJ12626109971","room_stay_from":"2021-05-16","room_stay_to":"2021-05-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15,305.15","nightly_discount":"0.00,0.00","subtotal":"610.30","grand_total":"686.59","paid_amount":"686.59","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":"121802","customer_id":"121802","source_of_creation":"PMS","reservation_created_date":"2021-05-12 21:39:35","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"305.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252923","reservation_id":"115365","confirmation_number":"SJ12632136799","room_stay_from":"2021-05-16","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15","nightly_discount":"15.26","subtotal":"305.15","grand_total":"326.12","paid_amount":"326.12","room_type_id":"319","product_id":"1310","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":"122092","customer_id":"122092","source_of_creation":"PMS","reservation_created_date":"2021-05-17 00:52:34","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":"","promotion_code":"AAA","sub_hotel_id":"0","currentDayPrice":"305.15","currentDayDiscount":"15.26","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252925","reservation_id":"115367","confirmation_number":"SJ12695566868","room_stay_from":"2021-05-16","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15","nightly_discount":"15.26","subtotal":"305.15","grand_total":"326.12","paid_amount":"343.29","room_type_id":"319","product_id":"1943","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":"122092","customer_id":"122092","source_of_creation":"PMS","reservation_created_date":"2021-05-17 01:18:48","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","currentDayPrice":"305.15","currentDayDiscount":"15.26","productIsTaxExempt":false,"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":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3204848","reservation_id":"108603","confirmation_number":"SJ12630742288","room_stay_from":"2021-05-14","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"413","product_id":"1271","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":"2021-02-26 02:36:02","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"3207621","reservation_id":"109104","confirmation_number":"SJ12687353289","room_stay_from":"2021-05-14","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 07:23:28","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"3207623","reservation_id":"109105","confirmation_number":"SJ12638806408","room_stay_from":"2021-05-15","room_stay_to":"2021-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1276","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":"2021-03-03 07:24:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"3213995","reservation_id":"110063","confirmation_number":"SJ12655281674","room_stay_from":"2021-05-14","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1287","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":"2021-03-11 18:48:17","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"3230735","reservation_id":"110717","confirmation_number":"SJ12644900173","room_stay_from":"2021-05-16","room_stay_to":"2021-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"522.00","grand_total":"522.00","paid_amount":"168.75","room_type_id":"319","product_id":"1313","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":"2021-03-19 15:41: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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"3241108","reservation_id":"104917","confirmation_number":"SJ12647678366","room_stay_from":"2021-05-16","room_stay_to":"2021-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.15,87.15","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"610.00","grand_total":"610.00","paid_amount":"196.88","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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":"2021-01-07 01:01:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.14","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":"3245197","reservation_id":"104915","confirmation_number":"SJ12625106659","room_stay_from":"2021-05-13","room_stay_to":"2021-05-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0,0,0,0","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","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":"2021-01-07 00:56:32","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","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":"3245207","reservation_id":"109106","confirmation_number":"SJ12614046372","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1264","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":"2021-03-03 07:26:01","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3251872","reservation_id":"109514","confirmation_number":"SJ12678364968","room_stay_from":"2021-05-14","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.42,107.42,107.42,107.42,107.42,107.42,107.48","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"752.00","grand_total":"752.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":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-03-05 19:10:56","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"107.42","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":"3252670","reservation_id":"110533","confirmation_number":"SJ12666860339","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0,0,0,0","subtotal":"435.00","grand_total":"435.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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":"2021-03-17 17:57:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"-174.00","currentDayPrice":"87.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":"3252731","reservation_id":"110486","confirmation_number":"SJ12659866947","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 02:45:32","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"86.67","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":"3244143","reservation_id":"114190","confirmation_number":"SJ12650055652","room_confirmation_number":"SJ12689961256","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"120831","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-30 03:50:10","reservation_modified_date_time":"2021-04-30 03:50:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120831","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3249686","reservation_id":"114456","confirmation_number":"SJ12647214632","room_confirmation_number":"SJ12683605893","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"150.90","paid_amount":"150.90","product_id":"1777","service_quantity":"1","customer_traveller_id":"121147","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-05-11 00:34:05","reservation_modified_date_time":"2021-05-11 00:34:05","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121147","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3250673","reservation_id":"108699","confirmation_number":"SJ12692846097","room_confirmation_number":"SJ12659925711","room_stay_from":"2021-05-12","room_stay_to":"2021-05-19","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1777","service_quantity":"1","customer_traveller_id":"115150","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-05-12 19:44:28","reservation_modified_date_time":"2021-05-12 19:44:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115150","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3216628","reservation_id":"110422","confirmation_number":"SJ12642420478","room_confirmation_number":"SJ12636948782","room_stay_from":"2021-05-15","room_stay_to":"2021-05-21","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0,0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"116934","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-16 18:39:11","reservation_modified_date_time":"2021-03-16 18:39:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116934","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3211375","reservation_id":"109688","confirmation_number":"SJ12632346508","room_confirmation_number":"SJ12663919874","room_stay_from":"2021-05-11","room_stay_to":"2021-05-17","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":"116176","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-07 19:31:08","reservation_modified_date_time":"2021-03-07 19:31:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116176","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241098","reservation_id":"113277","confirmation_number":"SJ12656301497","room_confirmation_number":"SJ12699326427","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","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":"119866","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 03:57:09","reservation_modified_date_time":"2021-04-24 17:50:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119866","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3244144","reservation_id":"114190","confirmation_number":"SJ12674108897","room_confirmation_number":"SJ12689961256","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","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":"120831","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-30 03:50:10","reservation_modified_date_time":"2021-04-30 03:50:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120831","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3248534","reservation_id":"109311","confirmation_number":"SJ12690983632","room_confirmation_number":"SJ12695006217","room_stay_from":"2021-05-13","room_stay_to":"2021-05-17","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":"115779","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 13:52:12","reservation_modified_date_time":"2021-05-08 19:50:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115779","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3248633","reservation_id":"114802","confirmation_number":"SJ12676814214","room_confirmation_number":"SJ12667978614","room_stay_from":"2021-05-16","room_stay_to":"2021-05-17","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":"121541","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-08 23:55:08","reservation_modified_date_time":"2021-05-08 23:55:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121541","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3250517","reservation_id":"112469","confirmation_number":"SJ12689331442","room_confirmation_number":"SJ12612818479","room_stay_from":"2021-05-12","room_stay_to":"2021-05-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"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":"119040","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 21:53:19","reservation_modified_date_time":"2021-05-12 16:51:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119040","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3251313","reservation_id":"113698","confirmation_number":"SJ12669287334","room_confirmation_number":"SJ12678056959","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"120309","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 14:54:32","reservation_modified_date_time":"2021-05-13 18:31:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120309","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252349","reservation_id":"113024","confirmation_number":"SJ12632382248","room_confirmation_number":"SJ12651286854","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","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":"119606","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 03:18:18","reservation_modified_date_time":"2021-05-15 18:53:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119606","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3252351","reservation_id":"112693","confirmation_number":"SJ12645094768","room_confirmation_number":"SJ12626017502","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","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":"119281","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-11 18:25:09","reservation_modified_date_time":"2021-05-15 18:53:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119281","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3252663","reservation_id":"113709","confirmation_number":"SJ12675990324","room_confirmation_number":"SJ12681754487","room_stay_from":"2021-05-15","room_stay_to":"2021-05-17","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"25.00,0.00","subtotal":"50.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"120319","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 16:09:09","reservation_modified_date_time":"2021-05-16 18:46:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120319","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252924","reservation_id":"115365","confirmation_number":"SJ12675568677","room_confirmation_number":"SJ12632136799","room_stay_from":"2021-05-16","room_stay_to":"2021-05-17","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122092","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-17 00:52:34","reservation_modified_date_time":"2021-05-17 02:33:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122092","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252926","reservation_id":"115367","confirmation_number":"SJ12667714475","room_confirmation_number":"SJ12695566868","room_stay_from":"2021-05-16","room_stay_to":"2021-05-17","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122092","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-17 01:18:48","reservation_modified_date_time":"2021-05-17 02:33:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122092","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3237666","reservation_id":"108242","confirmation_number":"SJ12680677995","room_confirmation_number":"SJ12673382426","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","room_stay_status":"Active","nightly_price":"25,25,25","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":"114710","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 03:50:12","reservation_modified_date_time":"2021-04-19 20:22:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114710","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3238398","reservation_id":"113256","confirmation_number":"SJ12666760090","room_confirmation_number":"SJ12626654144","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","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":"119846","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 20:53:22","reservation_modified_date_time":"2021-04-21 13:15:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119846","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3240836","reservation_id":"111856","confirmation_number":"SJ12633712426","room_confirmation_number":"SJ12625981318","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","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":"122045","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-02 00:07:08","reservation_modified_date_time":"2021-04-24 15:18:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122045","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3245198","reservation_id":"104915","confirmation_number":"SJ12625179467","room_confirmation_number":"SJ12625106659","room_stay_from":"2021-05-13","room_stay_to":"2021-05-18","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":"111270","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 00:56:32","reservation_modified_date_time":"2021-05-01 20:57:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3249693","reservation_id":"112540","confirmation_number":"SJ12665715357","room_confirmation_number":"SJ12658769860","room_stay_from":"2021-05-14","room_stay_to":"2021-05-18","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":"119113","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-09 18:13:43","reservation_modified_date_time":"2021-05-11 00:34:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119113","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3250724","reservation_id":"115093","confirmation_number":"SJ12632633028","room_confirmation_number":"SJ12626109971","room_stay_from":"2021-05-16","room_stay_to":"2021-05-18","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":"121802","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-12 21:39:35","reservation_modified_date_time":"2021-05-12 21:39:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121802","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3252395","reservation_id":"110346","confirmation_number":"SJ12632953952","room_confirmation_number":"SJ12673890806","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","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":"122043","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-15 14:26:12","reservation_modified_date_time":"2021-05-15 20:11:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122043","canceled_nights_data":"","posAmt_airbnb_taxpaid":"300.00","sub_hotel_id":"126","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":"3252507","reservation_id":"110006","confirmation_number":"SJ12683999305","room_confirmation_number":"SJ12658870057","room_stay_from":"2021-05-16","room_stay_to":"2021-05-18","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116498","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 23:38:10","reservation_modified_date_time":"2021-05-16 13:14:42","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116498","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3202431","reservation_id":"108219","confirmation_number":"SJ12632101052","room_confirmation_number":"SJ12632302076","room_stay_from":"2021-05-15","room_stay_to":"2021-05-19","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":"114683","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 23:02:11","reservation_modified_date_time":"2021-02-21 23:02:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114683","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3204849","reservation_id":"108603","confirmation_number":"SJ12619861796","room_confirmation_number":"SJ12630742288","room_stay_from":"2021-05-14","room_stay_to":"2021-05-19","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":"115041","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 02:36:02","reservation_modified_date_time":"2021-02-26 02:36:02","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3207622","reservation_id":"109104","confirmation_number":"SJ12640715875","room_confirmation_number":"SJ12687353289","room_stay_from":"2021-05-14","room_stay_to":"2021-05-19","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":"115579","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 07:23:28","reservation_modified_date_time":"2021-03-03 07:23:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3228787","reservation_id":"112152","confirmation_number":"SJ12682736208","room_confirmation_number":"SJ12681664794","room_stay_from":"2021-05-14","room_stay_to":"2021-05-19","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":"118726","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-05 15:02:36","reservation_modified_date_time":"2021-04-06 01:42:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3244151","reservation_id":"112446","confirmation_number":"SJ12647528015","room_confirmation_number":"SJ12673107750","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","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":"119016","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 16:34:36","reservation_modified_date_time":"2021-04-30 11:36:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119016","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3245208","reservation_id":"109106","confirmation_number":"SJ12690991312","room_confirmation_number":"SJ12614046372","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","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":"115581","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 07:26:01","reservation_modified_date_time":"2021-05-01 21:02:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3250674","reservation_id":"108699","confirmation_number":"SJ12620550663","room_confirmation_number":"SJ12659925711","room_stay_from":"2021-05-12","room_stay_to":"2021-05-19","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":"115150","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 01:23:25","reservation_modified_date_time":"2021-05-12 19:44:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115150","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3252470","reservation_id":"115311","confirmation_number":"SJ12627349070","room_confirmation_number":"SJ12685315147","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","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":"122024","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-16 03:33:10","reservation_modified_date_time":"2021-05-16 03:33:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122024","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3252515","reservation_id":"114456","confirmation_number":"SJ12635266489","room_confirmation_number":"SJ12683605893","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","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":"121147","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-03 22:39:25","reservation_modified_date_time":"2021-05-16 13:20:43","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121147","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3252732","reservation_id":"110486","confirmation_number":"SJ12615924322","room_confirmation_number":"SJ12659866947","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","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":"116999","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 02:45:32","reservation_modified_date_time":"2021-05-16 20:08:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3252736","reservation_id":"108784","confirmation_number":"SJ12652939905","room_confirmation_number":"SJ12693064094","room_stay_from":"2021-05-16","room_stay_to":"2021-05-19","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":"115237","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 22:43:30","reservation_modified_date_time":"2021-05-16 20:09:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115237","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3216689","reservation_id":"106519","confirmation_number":"SJ12646827232","room_confirmation_number":"SJ12622734716","room_stay_from":"2021-05-16","room_stay_to":"2021-05-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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112928","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 22:40:12","reservation_modified_date_time":"2021-03-16 19:16:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112928","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3217528","reservation_id":"110556","confirmation_number":"SJ12665134387","room_confirmation_number":"SJ12654633480","room_stay_from":"2021-05-16","room_stay_to":"2021-05-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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117069","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 19:27:07","reservation_modified_date_time":"2021-03-17 19:27:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117069","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3250561","reservation_id":"113550","confirmation_number":"SJ12689773212","room_confirmation_number":"SJ12657300842","room_stay_from":"2021-05-15","room_stay_to":"2021-05-20","room_stay_status":"Active","nightly_price":"25,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":"120344","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 18:54:42","reservation_modified_date_time":"2021-05-12 17:03:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120149","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3213996","reservation_id":"110063","confirmation_number":"SJ12643921236","room_confirmation_number":"SJ12655281674","room_stay_from":"2021-05-14","room_stay_to":"2021-05-21","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":"116549","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-11 18:48:17","reservation_modified_date_time":"2021-03-11 18:48:17","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3216629","reservation_id":"110422","confirmation_number":"SJ12694944526","room_confirmation_number":"SJ12636948782","room_stay_from":"2021-05-15","room_stay_to":"2021-05-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":"116934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 15:15:17","reservation_modified_date_time":"2021-03-16 18:39:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116934","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3216698","reservation_id":"110422","confirmation_number":"SJ12691432127","room_confirmation_number":"SJ12654705902","room_stay_from":"2021-05-15","room_stay_to":"2021-05-21","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","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":"116934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 15:15:52","reservation_modified_date_time":"2021-03-16 19:18:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116934","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216742","reservation_id":"109927","confirmation_number":"SJ12623044541","room_confirmation_number":"SJ12688882459","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","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":"116421","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 02:25:43","reservation_modified_date_time":"2021-03-16 19:23:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116421","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3221949","reservation_id":"111216","confirmation_number":"SJ12699827433","room_confirmation_number":"SJ12612511583","room_stay_from":"2021-05-08","room_stay_to":"2021-05-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,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,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"365.63","paid_amount":"365.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"102743","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 23:11:28","reservation_modified_date_time":"2021-03-24 23:11:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102743","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3248722","reservation_id":"114730","confirmation_number":"SJ12665573673","room_confirmation_number":"SJ12698672073","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","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":"121445","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-07 20:35:52","reservation_modified_date_time":"2021-05-09 12:23:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121445","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3251874","reservation_id":"109514","confirmation_number":"SJ12658954647","room_confirmation_number":"SJ12678364968","room_stay_from":"2021-05-14","room_stay_to":"2021-05-21","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":"115984","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 19:10:56","reservation_modified_date_time":"2021-05-14 20:26:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252671","reservation_id":"110533","confirmation_number":"SJ12638113074","room_confirmation_number":"SJ12666860339","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","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":"117045","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 17:57:01","reservation_modified_date_time":"2021-05-16 18:49:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"-50.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3207624","reservation_id":"109105","confirmation_number":"SJ12698531777","room_confirmation_number":"SJ12638806408","room_stay_from":"2021-05-15","room_stay_to":"2021-05-22","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":"115580","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 07:24:57","reservation_modified_date_time":"2021-03-03 07:24:57","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3230736","reservation_id":"110717","confirmation_number":"SJ12637284868","room_confirmation_number":"SJ12644900173","room_stay_from":"2021-05-16","room_stay_to":"2021-05-22","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117228","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 15:41:18","reservation_modified_date_time":"2021-04-08 17:57:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3238385","reservation_id":"109275","confirmation_number":"SJ12674617044","room_confirmation_number":"SJ12626088195","room_stay_from":"2021-05-15","room_stay_to":"2021-05-22","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":"115746","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 01:22:22","reservation_modified_date_time":"2021-04-21 13:12:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114227","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3207157","reservation_id":"109005","confirmation_number":"SJ12653476041","room_confirmation_number":"SJ12668445071","room_stay_from":"2021-05-16","room_stay_to":"2021-05-23","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":"115471","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 05:32:13","reservation_modified_date_time":"2021-03-02 05:32:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115471","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241109","reservation_id":"104917","confirmation_number":"SJ12626396128","room_confirmation_number":"SJ12647678366","room_stay_from":"2021-05-16","room_stay_to":"2021-05-23","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":"111273","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 01:01:56","reservation_modified_date_time":"2021-04-24 17:54:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3252531","reservation_id":"110904","confirmation_number":"SJ12677914217","room_confirmation_number":"SJ12649433285","room_stay_from":"2021-05-13","room_stay_to":"2021-05-15","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117429","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 19:20:15","reservation_modified_date_time":"2021-05-16 14:56:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117429","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3252788","reservation_id":"114396","confirmation_number":"SJ12653538436","room_confirmation_number":"SJ12665157383","room_stay_from":"2021-06-10","room_stay_to":"2021-06-13","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":"121067","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-03 00:05:39","reservation_modified_date_time":"2021-05-16 21:13:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121067","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3252819","reservation_id":"115279","confirmation_number":"SJ12668578173","room_confirmation_number":"SJ12673959994","room_stay_from":"2021-06-12","room_stay_to":"2021-06-18","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121986","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-15 17:32:27","reservation_modified_date_time":"2021-05-16 21:17:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121986","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3252844","reservation_id":"115044","confirmation_number":"SJ12657485940","room_confirmation_number":"SJ12646720605","room_stay_from":"2021-06-11","room_stay_to":"2021-06-14","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":"121759","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-12 01:36:36","reservation_modified_date_time":"2021-05-16 21:24:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121759","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3252935","reservation_id":"113053","confirmation_number":"SJ12686657483","room_confirmation_number":"SJ12637536460","room_stay_from":"2021-05-19","room_stay_to":"2021-05-22","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":"115230","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 19:42:55","reservation_modified_date_time":"2021-05-17 03:02:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115230","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3252658","reservation_id":"99189","confirmation_number":"SJ12642262309","room_confirmation_number":"SJ12669789243","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"90.00","grand_total":"101.25","paid_amount":"0.00","product_id":"1861","service_quantity":"1","product_name":"Incidentals","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-16 18:43:14","reservation_modified_date_time":"2021-05-16 18:43:58","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"105167","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-05-10","sub_hotel_id":"0","currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"3252628","reservation_id":"115338","confirmation_number":"SJ12651122651","room_confirmation_number":"SJ12691491918","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":"1663","service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-16 18:23:03","reservation_modified_date_time":"2021-05-16 18:23:03","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3252558","reservation_id":"113277","confirmation_number":"SJ12629647816","room_confirmation_number":"SJ12699326427","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"0.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-16 15:56:09","reservation_modified_date_time":"2021-05-16 15:56:09","customer_id":"119866","parentCustTravId":"119866","customer_traveller_id":"119866","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-05-15","sub_hotel_id":"126","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}