{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-05-15","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":25,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1267,1268,1291,1711,1304,1305,1269,1270,1307,1308,1309,1310,1311,1312,1271,1272,1302,1303,1260,1261,1262,1263","bundle_block_bookings":[{"confirmation_number":"SJB12628633553","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12616315889","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12686514665","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12671390461","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12672226125","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","bundle_room":"1","product_id":"1323"},{"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":"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":"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":"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"}]},"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":"230.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":"306.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":"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":"331.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":"3216735","reservation_id":"110307","confirmation_number":"SJ12656247442","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"284.25,336.75,336.75","nightly_discount":"0,0,0","subtotal":"957.75","grand_total":"1077.47","paid_amount":"1077.47","room_type_id":"320","product_id":"1714","siteminder_id":"BDC-3287596995","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":"116824","customer_id":"116824","source_of_creation":"Booking.com","reservation_created_date":"2021-03-14 21:58:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"185.90","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"336.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":"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":"299.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":"3237532","reservation_id":"113399","confirmation_number":"SJ12686557219","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.68","nightly_discount":"0","subtotal":"251.68","grand_total":"283.14","paid_amount":"283.14","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3828776166","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":"119984","customer_id":"119984","source_of_creation":"Booking.com","reservation_created_date":"2021-04-19 17:42:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"49.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.68","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":"183.71","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":"3239668","reservation_id":"113254","confirmation_number":"SJ12618159509","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","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":"1916","siteminder_id":"BDC-3012373042","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":"119845","customer_id":"119845","source_of_creation":"Booking.com","reservation_created_date":"2021-04-17 20:43:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"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":"336.65","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":"118418","customer_id":"118418","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":"299.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":"314.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":"3251287","reservation_id":"115148","confirmation_number":"SJ12655903208","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"293.76","nightly_discount":"0","subtotal":"293.76","grand_total":"330.48","paid_amount":"330.48","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-2576870580","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":"121854","customer_id":"121854","source_of_creation":"Booking.com","reservation_created_date":"2021-05-13 16:59:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"57.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"293.76","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":"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":"268.76","currentDayDiscount":"13.44","productIsTaxExempt":false,"taxes":[{"tax_id":"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","currentDayPrice":"287.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":"304.39","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":"116859","customer_id":"116859","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","currentDayPrice":"270.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"188.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":"3227731","reservation_id":"112052","confirmation_number":"SJ12673169718","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,299.25,299.25","nightly_discount":"0,0,0","subtotal":"845.25","grand_total":"950.90","paid_amount":"950.90","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1755580140","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":"118620","customer_id":"118620","source_of_creation":"Expedia","reservation_created_date":"2021-04-04 01:32:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","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":"299.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":"3228813","reservation_id":"111911","confirmation_number":"SJ12692016517","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.20,295.20","nightly_discount":"0,0","subtotal":"590.40","grand_total":"664.20","paid_amount":"664.20","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1755101143","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":"118479","customer_id":"118479","source_of_creation":"Expedia","reservation_created_date":"2021-04-02 17:52:19","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"295.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":"3234717","reservation_id":"113033","confirmation_number":"SJ12674814631","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,343.20","nightly_discount":"0,0","subtotal":"686.40","grand_total":"772.20","paid_amount":"772.20","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1759871591","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":"119615","customer_id":"119615","source_of_creation":"Expedia","reservation_created_date":"2021-04-15 14:03:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.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":"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":"257.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":"3240825","reservation_id":"112028","confirmation_number":"SJ12692787342","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,299.25,299.25","nightly_discount":"0,0,0","subtotal":"845.25","grand_total":"950.90","paid_amount":"950.90","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1755530797","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":"118598","customer_id":"118598","source_of_creation":"Expedia","reservation_created_date":"2021-04-03 22:42:08","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":"126","group_rooms":null,"currentDayPrice":"299.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":"3241141","reservation_id":"106058","confirmation_number":"SJ12620089396","room_stay_from":"2021-05-12","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"142.24,142.24,181.44,181.44","nightly_discount":"0,0,0,0","subtotal":"647.36","grand_total":"728.28","paid_amount":"728.28","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1732600200","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":"112479","customer_id":"112479","source_of_creation":"Expedia","reservation_created_date":"2021-01-25 15:06:12","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":"181.44","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":"220.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248408","reservation_id":"114778","confirmation_number":"SJ12699658641","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"244.12","nightly_discount":"0","subtotal":"244.12","grand_total":"274.64","paid_amount":"274.64","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1768597052","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":"121504","customer_id":"121504","source_of_creation":"Expedia","reservation_created_date":"2021-05-08 16:45:09","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"244.12","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":"3249679","reservation_id":"114646","confirmation_number":"SJ12623717598","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.40","nightly_discount":"0","subtotal":"230.40","grand_total":"259.20","paid_amount":"259.20","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1767806619","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":"121342","customer_id":"121342","source_of_creation":"Expedia","reservation_created_date":"2021-05-06 15:41:09","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":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.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":"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":"269.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":"229.76","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","currentDayPrice":"319.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":"3252432","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":"318","product_id":"1282","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 (Accessible) 306","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","currentDayPrice":"229.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3250511","reservation_id":"112675","confirmation_number":"SJ12626291074","room_stay_from":"2021-05-12","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.32,327.17,327.17,327.17","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1300.83","grand_total":"1507.48","paid_amount":"1507.48","room_type_id":"413","product_id":"1266","siteminder_id":"ABB-HMPKFEHTRD","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1308.68","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119264","customer_id":"119264","source_of_creation":"Airbnb","reservation_created_date":"2021-04-11 15:34:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"38.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"327.17","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":"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":"3251273","reservation_id":"104894","confirmation_number":"SJ12660650589","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.43,225.42,225.42","nightly_discount":"0.00,0.00,0.00","subtotal":"672.27","grand_total":"779.06","paid_amount":"779.06","room_type_id":"413","product_id":"1264","siteminder_id":"ABB-HMF3TRFKJY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"676.26","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111248","customer_id":"111248","source_of_creation":"Airbnb","reservation_created_date":"2021-01-06 21:56:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"19.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"225.42","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.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3251284","reservation_id":"110904","confirmation_number":"SJ12649433285","room_stay_from":"2021-05-13","room_stay_to":"2021-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"268.00,274.17,274.38,274.38","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1090.93","grand_total":"1264.25","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","group_rooms":null,"currentDayPrice":"274.38","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":"3251688","reservation_id":"112584","confirmation_number":"SJ12677565163","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"361.79,366.18","nightly_discount":"0.00,0.00","subtotal":"727.97","grand_total":"843.61","paid_amount":"843.61","room_type_id":"319","product_id":"1313","siteminder_id":"ABB-HMCJZSTTFW","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"732.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119162","customer_id":"119162","source_of_creation":"Airbnb","reservation_created_date":"2021-04-10 12:34:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"21.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"366.18","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":"3252011","reservation_id":"111997","confirmation_number":"SJ12637651502","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"361.98,366.68","nightly_discount":"0.00,0.00","subtotal":"728.66","grand_total":"852.06","paid_amount":"852.06","room_type_id":"319","product_id":"1288","siteminder_id":"ABB-HMXBWNDSP8","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"733.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118567","customer_id":"118567","source_of_creation":"Airbnb","reservation_created_date":"2021-04-03 19:01:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"23.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"366.68","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":"3252090","reservation_id":"114712","confirmation_number":"SJ12666469343","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"353.21","nightly_discount":"0.00","subtotal":"353.21","grand_total":"413.14","paid_amount":"413.14","room_type_id":"319","product_id":"1310","siteminder_id":"ABB-HMY2E8NRXH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"355.46","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121422","customer_id":"121422","source_of_creation":"Airbnb","reservation_created_date":"2021-05-07 16:32:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"11.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"353.21","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.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3221219","reservation_id":"106988","confirmation_number":"SJ12620082849","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,201.75,201.75","nightly_discount":"0.00,0.00,0.00","subtotal":"552.75","grand_total":"621.85","paid_amount":"621.85","room_type_id":"319","product_id":"1304","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113425","customer_id":"113425","source_of_creation":"FE","reservation_created_date":"2021-02-05 22:03:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"201.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"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.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252054","reservation_id":"115256","confirmation_number":"SJ12661236100","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"326.40","nightly_discount":"0.00","subtotal":"326.40","grand_total":"367.20","paid_amount":"367.20","room_type_id":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99785","customer_id":"99785","source_of_creation":"PMS","reservation_created_date":"2021-05-15 12:25:06","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","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":"326.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3252052","reservation_id":"111116","confirmation_number":"SJ12655149228","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":"161.70,161.70","nightly_discount":"0.00,0.00","subtotal":"323.40","grand_total":"363.83","paid_amount":"545.74","room_type_id":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120493","customer_id":"74927","source_of_creation":"PMS","reservation_created_date":"2021-03-23 20:39:16","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","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":"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":"3252305","reservation_id":"113835","confirmation_number":"SJ12648359312","room_stay_from":"2021-05-21","room_stay_to":"2021-05-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15,305.15","nightly_discount":"0.00,0","subtotal":"610.30","grand_total":"686.59","paid_amount":"343.29","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120461","customer_id":"120461","source_of_creation":"PMS","reservation_created_date":"2021-04-25 13:19:53","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":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"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":"3220592","reservation_id":"110991","confirmation_number":"SJ12646719325","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-22 18:46:52","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","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":"3227720","reservation_id":"106670","confirmation_number":"SJ12628527753","room_stay_from":"2021-05-10","room_stay_to":"2021-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"520.02","grand_total":"520.02","paid_amount":"168.75","room_type_id":"413","product_id":"1265","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-01 22:44:36","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3241049","reservation_id":"108599","confirmation_number":"SJ12618660528","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"319","product_id":"1275","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 01:48:30","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":"","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":"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":"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":"3251877","reservation_id":"110533","confirmation_number":"SJ12666860339","room_stay_from":"2021-05-14","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,87.00,87.00","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"609.00","grand_total":"609.00","paid_amount":"0.00","room_type_id":"319","product_id":"1286","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 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":"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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3247904","reservation_id":"114712","confirmation_number":"SJ12632477934","room_confirmation_number":"SJ12666469343","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.15","paid_amount":"25.15","product_id":"1777","service_quantity":"1","customer_traveller_id":"121422","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-05-07 16:32:10","reservation_modified_date_time":"2021-05-07 16:32:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121422","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.59","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3252012","reservation_id":"111997","confirmation_number":"SJ12668032746","room_confirmation_number":"SJ12637651502","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"50.30","paid_amount":"50.30","product_id":"1777","service_quantity":"1","customer_traveller_id":"118567","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-05-15 00:59:31","reservation_modified_date_time":"2021-05-15 00:59:31","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118567","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25","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":"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":"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":"3216738","reservation_id":"110307","confirmation_number":"SJ12649593177","room_confirmation_number":"SJ12656247442","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"116824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-14 21:58:13","reservation_modified_date_time":"2021-03-16 19:23:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116824","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":"3220593","reservation_id":"110991","confirmation_number":"SJ12634404166","room_confirmation_number":"SJ12646719325","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"117529","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 18:46:52","reservation_modified_date_time":"2021-03-22 18:46:52","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":"3221221","reservation_id":"106988","confirmation_number":"SJ12654137578","room_confirmation_number":"SJ12620082849","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"113425","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 22:03:29","reservation_modified_date_time":"2021-03-23 20:34:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113425","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":"3227721","reservation_id":"106670","confirmation_number":"SJ12655217024","room_confirmation_number":"SJ12628527753","room_stay_from":"2021-05-10","room_stay_to":"2021-05-16","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":"113089","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 22:44:36","reservation_modified_date_time":"2021-04-04 15:03:26","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":"3227730","reservation_id":"112052","confirmation_number":"SJ12637555559","room_confirmation_number":"SJ12673169718","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"118620","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 01:32:31","reservation_modified_date_time":"2021-04-04 01:32:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118620","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":"3228814","reservation_id":"111911","confirmation_number":"SJ12682494741","room_confirmation_number":"SJ12692016517","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","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":"118479","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-02 17:52:19","reservation_modified_date_time":"2021-04-06 01:45:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118479","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":"3234718","reservation_id":"113033","confirmation_number":"SJ12638884697","room_confirmation_number":"SJ12674814631","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","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":"119615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 14:03:11","reservation_modified_date_time":"2021-04-15 14:03:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119615","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":"3237533","reservation_id":"113399","confirmation_number":"SJ12627256720","room_confirmation_number":"SJ12686557219","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","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":"119984","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 17:42:10","reservation_modified_date_time":"2021-04-19 17:42:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119984","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":"3239669","reservation_id":"113254","confirmation_number":"SJ12677761566","room_confirmation_number":"SJ12618159509","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","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":"119845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 20:43:14","reservation_modified_date_time":"2021-04-22 14:21:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119845","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":"3240826","reservation_id":"112028","confirmation_number":"SJ12696614014","room_confirmation_number":"SJ12692787342","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"118598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 22:42:08","reservation_modified_date_time":"2021-04-24 15:17:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118598","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":"3241050","reservation_id":"108599","confirmation_number":"SJ12638722220","room_confirmation_number":"SJ12618660528","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"115037","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:48:30","reservation_modified_date_time":"2021-04-24 17:32:56","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":"3241142","reservation_id":"106058","confirmation_number":"SJ12659701789","room_confirmation_number":"SJ12620089396","room_stay_from":"2021-05-12","room_stay_to":"2021-05-16","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":"112479","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 15:06:12","reservation_modified_date_time":"2021-04-24 18:03:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112479","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":"3248409","reservation_id":"114778","confirmation_number":"SJ12656301079","room_confirmation_number":"SJ12699658641","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","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":"121504","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-08 16:45:09","reservation_modified_date_time":"2021-05-08 16:45:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121504","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":"3249680","reservation_id":"114646","confirmation_number":"SJ12675650672","room_confirmation_number":"SJ12623717598","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","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":"121342","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-06 15:41:09","reservation_modified_date_time":"2021-05-11 00:33:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121342","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":"3250512","reservation_id":"112675","confirmation_number":"SJ12623419304","room_confirmation_number":"SJ12626291074","room_stay_from":"2021-05-12","room_stay_to":"2021-05-16","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"119264","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-11 15:34:14","reservation_modified_date_time":"2021-05-12 16:40:11","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119264","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":"3251274","reservation_id":"104894","confirmation_number":"SJ12672888697","room_confirmation_number":"SJ12660650589","room_stay_from":"2021-05-13","room_stay_to":"2021-05-16","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":"111248","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 21:56:11","reservation_modified_date_time":"2021-05-13 16:25:01","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111248","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":"3251288","reservation_id":"115148","confirmation_number":"SJ12687186581","room_confirmation_number":"SJ12655903208","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","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":"121854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-13 16:59:08","reservation_modified_date_time":"2021-05-13 16:59:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121854","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":"3251689","reservation_id":"112584","confirmation_number":"SJ12684261015","room_confirmation_number":"SJ12677565163","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","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":"119162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 12:34:09","reservation_modified_date_time":"2021-05-14 14:24:38","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119162","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":"3251691","reservation_id":"111997","confirmation_number":"SJ12695167671","room_confirmation_number":"SJ12637651502","room_stay_from":"2021-05-14","room_stay_to":"2021-05-16","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":"118567","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 19:01:09","reservation_modified_date_time":"2021-05-14 14:32:44","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118567","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3252055","reservation_id":"115256","confirmation_number":"SJ12638566755","room_confirmation_number":"SJ12661236100","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","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":"99785","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-15 12:25:06","reservation_modified_date_time":"2021-05-15 12:25:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99785","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":"3252091","reservation_id":"114712","confirmation_number":"SJ12640028688","room_confirmation_number":"SJ12666469343","room_stay_from":"2021-05-15","room_stay_to":"2021-05-16","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":"121422","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-07 16:32:10","reservation_modified_date_time":"2021-05-15 13:41:24","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121422","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"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":"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":"3251285","reservation_id":"110904","confirmation_number":"SJ12677914217","room_confirmation_number":"SJ12649433285","room_stay_from":"2021-05-13","room_stay_to":"2021-05-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"117429","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 19:20:15","reservation_modified_date_time":"2021-05-13 16:33:20","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","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":"3252433","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-15 22:17:19","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":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"118418","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":"118418","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":"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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116859","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":"116859","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":"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":"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":"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","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"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":"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":"3251878","reservation_id":"110533","confirmation_number":"SJ12638113074","room_confirmation_number":"SJ12666860339","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":"117045","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 17:57:01","reservation_modified_date_time":"2021-05-14 20:27:19","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":"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":"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":"3252053","reservation_id":"111116","confirmation_number":"SJ12681611713","room_confirmation_number":"SJ12655149228","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":"120493","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 20:39:16","reservation_modified_date_time":"2021-05-15 12:20:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74927","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"}]},{"room_stay_id":"3252306","reservation_id":"113835","confirmation_number":"SJ12673052624","room_confirmation_number":"SJ12648359312","room_stay_from":"2021-05-21","room_stay_to":"2021-05-23","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120461","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-25 13:19:53","reservation_modified_date_time":"2021-05-15 17:28:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120461","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From 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":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}