{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-09-26","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":26,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1276","block_room_bookings":[{"confirmation_number":"SJ12617653652","room_stay_from":"2021-09-20","room_stay_to":"2021-09-30","bundle_room":"0","product_id":"1276"}],"bundle_block_count":"1262,1263,1267,1268,1302,1303,1309,1310,1304,1305,1291,1711,1307,1308,1269,1270,1311,1312,1260,1261,1271,1272","bundle_block_bookings":[{"confirmation_number":"SJB12641765398","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12682852709","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12690009414","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12610490552","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12646700743","room_stay_from":"2021-09-26","room_stay_to":"2021-10-02","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12613018926","room_stay_from":"2021-09-26","room_stay_to":"2021-10-02","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12629562732","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12693918652","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12629112873","room_stay_from":"2021-09-25","room_stay_to":"2021-10-01","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12642988834","room_stay_from":"2021-09-26","room_stay_to":"2021-09-29","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12656936018","room_stay_from":"2021-09-26","room_stay_to":"2021-09-29","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12642468120","room_stay_from":"2021-09-26","room_stay_to":"2021-10-01","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12670231935","room_stay_from":"2021-09-26","room_stay_to":"2021-09-28","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12683105360","room_stay_from":"2021-09-26","room_stay_to":"2021-09-28","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12682974695","room_stay_from":"2021-09-26","room_stay_to":"2021-09-29","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12643528913","room_stay_from":"2021-09-26","room_stay_to":"2021-09-27","bundle_room":"1","product_id":"1324"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3257818","reservation_id":"115984","confirmation_number":"SJ12698615870","room_stay_from":"2021-09-26","room_stay_to":"2021-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"232.47,232.47,232.47,232.47,232.47,282.87","nightly_discount":"0,0,0,0,0,0","subtotal":"1445.22","grand_total":"1625.87","paid_amount":"1625.87","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-2539108359","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":"122791","customer_id":"122791","source_of_creation":"Booking.com","reservation_created_date":"2021-05-27 14:37:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"287.14","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"232.47","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":"5314502","reservation_id":"123216","confirmation_number":"SJ12688108875","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"186.48,121.68","nightly_discount":"0,0","subtotal":"308.16","grand_total":"346.68","paid_amount":"346.68","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-3193590020","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":"130924","customer_id":"130924","source_of_creation":"Booking.com","reservation_created_date":"2021-09-17 21:51:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"64.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"121.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":"5314660","reservation_id":"118900","confirmation_number":"SJ12683409513","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.08,168.08,114.08","nightly_discount":"0,0,0","subtotal":"450.24","grand_total":"506.52","paid_amount":"506.52","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2187748117","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":"125991","customer_id":"125991","source_of_creation":"Booking.com","reservation_created_date":"2021-07-08 00:57:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"94.53","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"114.08","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":"5315120","reservation_id":"120216","confirmation_number":"SJ12658473700","room_stay_from":"2021-09-25","room_stay_to":"2021-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,195.30,195.30,195.30,195.30,195.30,251.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1479.10","grand_total":"1663.99","paid_amount":"1663.99","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3865278715","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":"127477","customer_id":"127477","source_of_creation":"Booking.com","reservation_created_date":"2021-07-27 19:27:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"297.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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":"5317601","reservation_id":"123605","confirmation_number":"SJ12650412289","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.57,120.89,120.89","nightly_discount":"0,0,0","subtotal":"417.35","grand_total":"469.52","paid_amount":"469.52","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2682566773","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":"131337","customer_id":"131337","source_of_creation":"Booking.com","reservation_created_date":"2021-09-24 18:54:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"88.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"120.89","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":"5318442","reservation_id":"123410","confirmation_number":"SJ12681045218","room_stay_from":"2021-09-24","room_stay_to":"2021-09-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.98","nightly_discount":"0","subtotal":"198.98","grand_total":"223.85","paid_amount":"223.85","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-3112120958","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":"131132","customer_id":"131132","source_of_creation":"Booking.com","reservation_created_date":"2021-09-21 15:02:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"40.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"198.98","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":"5318541","reservation_id":"117433","confirmation_number":"SJ12632095354","room_stay_from":"2021-10-17","room_stay_to":"2021-10-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.50,177.80,177.80,177.80,177.80,265.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1167.20","grand_total":"1313.10","paid_amount":"200.03","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2122684685","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":"131444","customer_id":"131444","source_of_creation":"Booking.com","reservation_created_date":"2021-06-16 20:09:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"146.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"both dates 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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3266857","reservation_id":"117167","confirmation_number":"SJ12673949211","room_stay_from":"2021-09-26","room_stay_to":"2021-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"118.30,118.30,118.30,118.30,118.30","nightly_discount":"0,0,0,0,0","subtotal":"591.50","grand_total":"665.44","paid_amount":"665.44","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1784821618","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":"124110","customer_id":"124110","source_of_creation":"Expedia","reservation_created_date":"2021-06-13 17:26:21","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","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":"118.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":"5314699","reservation_id":"123245","confirmation_number":"SJ12638263172","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.44,161.84,161.84,111.44","nightly_discount":"0,0,0,0","subtotal":"546.56","grand_total":"614.88","paid_amount":"614.88","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1831589654","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":"130951","customer_id":"130951","source_of_creation":"Expedia","reservation_created_date":"2021-09-18 13:55:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"111.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":"5316209","reservation_id":"123384","confirmation_number":"SJ12639619071","room_stay_from":"2021-09-26","room_stay_to":"2021-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"71.12,71.12,71.12,71.12,71.12","nightly_discount":"0,0,0,0,0","subtotal":"355.60","grand_total":"400.05","paid_amount":"400.05","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1832678488","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":"131104","customer_id":"131104","source_of_creation":"Expedia","reservation_created_date":"2021-09-21 00:25:40","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":"71.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":"5316464","reservation_id":"123445","confirmation_number":"SJ12648642263","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.96,127.36","nightly_discount":"0,0","subtotal":"312.32","grand_total":"351.36","paid_amount":"351.36","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1833134052","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":"131175","customer_id":"131175","source_of_creation":"Expedia","reservation_created_date":"2021-09-21 23:05:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"127.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5317867","reservation_id":"122958","confirmation_number":"SJ12633178183","room_stay_from":"2021-09-26","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.20","nightly_discount":"0","subtotal":"107.20","grand_total":"120.60","paid_amount":"120.60","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1829095461","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":"130628","customer_id":"130628","source_of_creation":"Expedia","reservation_created_date":"2021-09-13 04:55:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"107.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3202497","reservation_id":"108238","confirmation_number":"SJ12693546087","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"171.94,193.50,193.50,171.94","nightly_discount":"0,0,0,0","subtotal":"730.88","grand_total":"822.24","paid_amount":"822.24","room_type_id":"320","product_id":"1321","siteminder_id":"GAM-R2341254488","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":"114706","customer_id":"114706","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-22 02:54:12","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":null,"sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"171.94","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":"5311134","reservation_id":"122795","confirmation_number":"SJ12678075742","room_stay_from":"2021-09-26","room_stay_to":"2021-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"96.48,96.48,96.48,96.48,96.48","nightly_discount":"0,0,0,0,0","subtotal":"482.40","grand_total":"542.70","paid_amount":"542.70","room_type_id":"413","product_id":"1269","siteminder_id":"GAM-R2793703935","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":"130452","customer_id":"130452","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-09 16:17:11","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"96.48","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":"5315490","reservation_id":"123318","confirmation_number":"SJ12688344303","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.02,178.02,122.58","nightly_discount":"0,0,0","subtotal":"478.62","grand_total":"538.45","paid_amount":"538.45","room_type_id":"319","product_id":"1288","siteminder_id":"GAM-R2815870066","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":"131032","customer_id":"131032","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-19 19:41:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"122.58","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":"5318416","reservation_id":"123008","confirmation_number":"SJ12637070569","room_stay_from":"2021-09-24","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.16,161.16,96.48,96.48","nightly_discount":"0,0,0,0","subtotal":"515.28","grand_total":"579.69","paid_amount":"579.69","room_type_id":"319","product_id":"1291","siteminder_id":"GAM-R2804350421","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":"129179","customer_id":"129179","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-14 15:09:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"96.48","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":"5318426","reservation_id":"123632","confirmation_number":"SJ12683468827","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.90,114.92,114.92","nightly_discount":"0,0,0","subtotal":"396.74","grand_total":"446.34","paid_amount":"446.34","room_type_id":"412","product_id":"1866","siteminder_id":"GAM-R2827984133","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":"131372","customer_id":"131372","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-25 04:17:08","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":"126","group_rooms":null,"currentDayPrice":"114.92","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5317623","reservation_id":"123440","confirmation_number":"SJ12660620688","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.66,237.66,233.45","nightly_discount":"0.00,0.00,0.00","subtotal":"708.77","grand_total":"821.37","paid_amount":"821.37","room_type_id":"319","product_id":"1942","siteminder_id":"ABB-HM9FMXK3JH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"712.98","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131171","customer_id":"131171","source_of_creation":"Airbnb","reservation_created_date":"2021-09-21 22:18:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"20.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"233.45","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":"5317802","reservation_id":"119106","confirmation_number":"SJ12661778281","room_stay_from":"2021-09-24","room_stay_to":"2021-09-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.52,179.52,179.52,179.52,179.52,173.06","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1070.66","grand_total":"1240.75","paid_amount":"1240.75","room_type_id":"319","product_id":"1301","siteminder_id":"ABB-HMCR9RXFQX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1077.12","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126224","customer_id":"126224","source_of_creation":"Airbnb","reservation_created_date":"2021-07-11 14:27:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"31.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.52","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":"5317853","reservation_id":"119277","confirmation_number":"SJ12610151860","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.52,179.52,176.29","nightly_discount":"0.00,0.00,0.00","subtotal":"535.33","grand_total":"620.37","paid_amount":"620.37","room_type_id":"413","product_id":"1266","siteminder_id":"ABB-HMJBAYRP2Y","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"538.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126407","customer_id":"126407","source_of_creation":"Airbnb","reservation_created_date":"2021-07-13 22:39:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"15.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.52","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":"5318455","reservation_id":"123638","confirmation_number":"SJ12688303508","room_stay_from":"2021-09-26","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"7","room_stay_child_count":"1","nightly_price":"315.00,319.74","nightly_discount":"0.00,0.00","subtotal":"634.74","grand_total":"758.51","paid_amount":"758.51","room_type_id":"320","product_id":"1332","siteminder_id":"ABB-HMMYTTDNMM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"639.48","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131378","customer_id":"131378","source_of_creation":"Airbnb","reservation_created_date":"2021-09-25 13:44:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"23.22","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"315.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":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3230491","reservation_id":"112433","confirmation_number":"SJ12637780160","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"269.25,239.25,239.25","nightly_discount":"0.00,0.00,0.00","subtotal":"747.75","grand_total":"841.22","paid_amount":"841.22","room_type_id":"320","product_id":"1322","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":"119005","customer_id":"119005","source_of_creation":"FE","reservation_created_date":"2021-04-08 12:48:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1267,1268","currentDayPrice":"239.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":"5311102","reservation_id":"115080","confirmation_number":"SJ12612511198","room_stay_from":"2021-09-26","room_stay_to":"2021-09-29","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"239.25,239.25,239.25","nightly_discount":"0.00,0.00,0.00","subtotal":"717.75","grand_total":"807.47","paid_amount":"807.47","room_type_id":"320","product_id":"1330","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":"121788","customer_id":"121788","source_of_creation":"FE","reservation_created_date":"2021-05-12 17:01:25","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"239.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"5313332","reservation_id":"123053","confirmation_number":"SJ12618258892","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"220.15,143.65","nightly_discount":"0.00,0.00","subtotal":"363.80","grand_total":"409.28","paid_amount":"409.28","room_type_id":"413","product_id":"1273","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":"130730","customer_id":"130730","source_of_creation":"PMS","reservation_created_date":"2021-09-15 00:51:05","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":"0","group_rooms":null,"currentDayPrice":"143.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5314072","reservation_id":"123087","confirmation_number":"SJ12611538183","room_stay_from":"2021-09-20","room_stay_to":"2021-09-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,149.25,149.25,149.25,216.75,216.75,149.25,149.25,149.25","nightly_discount":"14.93,14.93,14.93,14.93,21.68,21.68,14.93,14.93,14.93","subtotal":"1478.25","grand_total":"1496.68","paid_amount":"1496.68","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88476","customer_id":"88476","source_of_creation":"PMS","reservation_created_date":"2021-09-15 17:00:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"149.25","currentDayDiscount":"14.93","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318435","reservation_id":"123676","confirmation_number":"SJ12666615043","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.20,101.60","nightly_discount":"0.00,0.00","subtotal":"256.80","grand_total":"288.90","paid_amount":"288.90","room_type_id":"412","product_id":"1297","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":"131437","customer_id":"131437","source_of_creation":"PMS","reservation_created_date":"2021-09-26 04:25:29","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"Reservation created with partial past date","deltaChange":"155.20","currentDayPrice":"101.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318751","reservation_id":"123687","confirmation_number":"SJ12628522960","room_stay_from":"2021-09-26","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.65","nightly_discount":"0.00","subtotal":"143.65","grand_total":"161.60","paid_amount":"0.00","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131449","customer_id":"131449","source_of_creation":"PMS","reservation_created_date":"2021-09-26 15:49:37","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","currentDayPrice":"143.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5303072","reservation_id":"117567","confirmation_number":"SJ12625971188","room_stay_from":"2021-09-24","room_stay_to":"2021-10-01","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":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-18 20:52:27","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","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":"5303116","reservation_id":"117955","confirmation_number":"SJ12666348140","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"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-06-24 02:32:17","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.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":"5303246","reservation_id":"119942","confirmation_number":"SJ12649827785","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","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":"319","product_id":"1943","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-07-23 23:48:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"5303310","reservation_id":"119943","confirmation_number":"SJ12617887920","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","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":"319","product_id":"1309","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-07-23 23:49:57","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":"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":"5303322","reservation_id":"119949","confirmation_number":"SJ12663023087","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"319","product_id":"1305","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-07-24 00:52:44","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":"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":"5303350","reservation_id":"119960","confirmation_number":"SJ12618528685","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"319","product_id":"1304","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-07-24 02:24:32","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":"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":"5309871","reservation_id":"119530","confirmation_number":"SJ12676964991","room_stay_from":"2021-09-24","room_stay_to":"2021-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.85,112.85,112.85,112.85,112.85,112.85,112.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"790.00","grand_total":"790.00","paid_amount":"0.00","room_type_id":"319","product_id":"1711","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-07-17 19:14:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"112.85","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":"5316179","reservation_id":"118626","confirmation_number":"SJ12622419940","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"319","product_id":"1314","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-07-03 21:41:30","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":"","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":"5318658","reservation_id":"112333","confirmation_number":"SJ12667692490","room_stay_from":"2021-09-26","room_stay_to":"2021-09-29","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":"159.38","room_type_id":"318","product_id":"1289","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-04-07 15:24:27","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":"","sub_hotel_id":"0","currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318761","reservation_id":"122764","confirmation_number":"SJ12648315512","room_stay_from":"2021-09-26","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.85,97.85,97.85,97.85,97.85,97.85,97.85","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"684.95","grand_total":"684.95","paid_amount":"0.00","room_type_id":"412","product_id":"1315","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-09-09 00:41:35","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":"0","currentDayPrice":"97.85","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5313333","reservation_id":"123053","confirmation_number":"SJ12665963598","room_confirmation_number":"SJ12618258892","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"130730","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-09-15 00:51:05","reservation_modified_date_time":"2021-09-15 00:51:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130730","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5317910","reservation_id":"123638","confirmation_number":"SJ12666764155","room_confirmation_number":"SJ12688303508","room_stay_from":"2021-09-26","room_stay_to":"2021-09-28","room_stay_status":"Active","nightly_price":"75,75","nightly_discount":"0.00,0.00","subtotal":"150.00","grand_total":"150.90","paid_amount":"150.90","product_id":"1777","service_quantity":"1","customer_traveller_id":"131378","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-09-25 13:44:09","reservation_modified_date_time":"2021-09-25 13:44:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131378","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3202498","reservation_id":"108238","confirmation_number":"SJ12675137606","room_confirmation_number":"SJ12693546087","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","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":"114706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 02:54:12","reservation_modified_date_time":"2021-02-22 02:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114706","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":"3230492","reservation_id":"112433","confirmation_number":"SJ12624568313","room_confirmation_number":"SJ12637780160","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"119005","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 12:48:11","reservation_modified_date_time":"2021-04-08 12:48:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119005","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":"3257819","reservation_id":"115984","confirmation_number":"SJ12632197606","room_confirmation_number":"SJ12698615870","room_stay_from":"2021-09-26","room_stay_to":"2021-10-02","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":"122791","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 14:37:07","reservation_modified_date_time":"2021-05-27 14:37:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122791","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":"3266856","reservation_id":"117167","confirmation_number":"SJ12675659308","room_confirmation_number":"SJ12673949211","room_stay_from":"2021-09-26","room_stay_to":"2021-10-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"124110","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-13 17:26:21","reservation_modified_date_time":"2021-06-13 17:26:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124110","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":"5303071","reservation_id":"117567","confirmation_number":"SJ12693902418","room_confirmation_number":"SJ12625971188","room_stay_from":"2021-09-24","room_stay_to":"2021-10-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124528","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-18 20:52:27","reservation_modified_date_time":"2021-08-25 19:06: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":"5303115","reservation_id":"117955","confirmation_number":"SJ12690784852","room_confirmation_number":"SJ12666348140","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 02:32:17","reservation_modified_date_time":"2021-08-25 19:06:18","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":"5303245","reservation_id":"119942","confirmation_number":"SJ12650132281","room_confirmation_number":"SJ12649827785","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","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":"127169","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-23 23:48:06","reservation_modified_date_time":"2021-08-25 19:06:20","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":"5303309","reservation_id":"119943","confirmation_number":"SJ12647800860","room_confirmation_number":"SJ12617887920","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","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":"127170","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-23 23:49:57","reservation_modified_date_time":"2021-08-25 19:06:21","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":"5303321","reservation_id":"119949","confirmation_number":"SJ12635971910","room_confirmation_number":"SJ12663023087","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"127175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-24 00:52:44","reservation_modified_date_time":"2021-08-25 19:06:21","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":"5303349","reservation_id":"119960","confirmation_number":"SJ12626932755","room_confirmation_number":"SJ12618528685","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"127188","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-24 02:24:32","reservation_modified_date_time":"2021-08-25 19:06:22","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":"5309873","reservation_id":"119530","confirmation_number":"SJ12668010275","room_confirmation_number":"SJ12676964991","room_stay_from":"2021-09-24","room_stay_to":"2021-10-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126688","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 19:14:47","reservation_modified_date_time":"2021-09-07 13:15:54","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":"5311105","reservation_id":"115080","confirmation_number":"SJ12695170646","room_confirmation_number":"SJ12612511198","room_stay_from":"2021-09-26","room_stay_to":"2021-09-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"121788","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-12 17:01:25","reservation_modified_date_time":"2021-09-09 14:49:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121788","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":"5311135","reservation_id":"122795","confirmation_number":"SJ12650703606","room_confirmation_number":"SJ12678075742","room_stay_from":"2021-09-26","room_stay_to":"2021-10-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"130452","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-09 16:17:11","reservation_modified_date_time":"2021-09-09 16:17:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130452","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":"5313334","reservation_id":"123053","confirmation_number":"SJ12636002667","room_confirmation_number":"SJ12618258892","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","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":"130730","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-15 00:51:05","reservation_modified_date_time":"2021-09-15 00:51:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130730","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":"5313578","reservation_id":"123087","confirmation_number":"SJ12698774683","room_confirmation_number":"SJ12611538183","room_stay_from":"2021-09-20","room_stay_to":"2021-09-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"88476","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-15 17:00:38","reservation_modified_date_time":"2021-09-15 17:00:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88476","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":"5314503","reservation_id":"123216","confirmation_number":"SJ12622479787","room_confirmation_number":"SJ12688108875","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","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":"130924","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-17 21:51:09","reservation_modified_date_time":"2021-09-17 21:51:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130924","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":"5314661","reservation_id":"118900","confirmation_number":"SJ12633505878","room_confirmation_number":"SJ12683409513","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","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":"125991","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-08 00:57:11","reservation_modified_date_time":"2021-09-18 13:20:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125991","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":"5314700","reservation_id":"123245","confirmation_number":"SJ12688255585","room_confirmation_number":"SJ12638263172","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","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":"130951","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-18 13:55:08","reservation_modified_date_time":"2021-09-18 13:55:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130951","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":"5315121","reservation_id":"120216","confirmation_number":"SJ12697285107","room_confirmation_number":"SJ12658473700","room_stay_from":"2021-09-25","room_stay_to":"2021-10-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"127477","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-27 19:27:10","reservation_modified_date_time":"2021-09-19 14:12:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127477","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":"5315491","reservation_id":"123318","confirmation_number":"SJ12620449769","room_confirmation_number":"SJ12688344303","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","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":"131032","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-19 19:41:08","reservation_modified_date_time":"2021-09-19 19:41:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131032","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":"5316180","reservation_id":"118626","confirmation_number":"SJ12672681959","room_confirmation_number":"SJ12622419940","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"125704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-03 21:41:30","reservation_modified_date_time":"2021-09-21 13:22:40","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":"5316208","reservation_id":"123384","confirmation_number":"SJ12643726910","room_confirmation_number":"SJ12639619071","room_stay_from":"2021-09-26","room_stay_to":"2021-10-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"131104","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-21 00:25:40","reservation_modified_date_time":"2021-09-21 13:37:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131104","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":"5316465","reservation_id":"123445","confirmation_number":"SJ12687740346","room_confirmation_number":"SJ12648642263","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","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":"131175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-21 23:05:06","reservation_modified_date_time":"2021-09-21 23:05:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131175","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":"5317602","reservation_id":"123605","confirmation_number":"SJ12696021685","room_confirmation_number":"SJ12650412289","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"131337","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-24 18:54:08","reservation_modified_date_time":"2021-09-24 18:54:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131337","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":"5317624","reservation_id":"123440","confirmation_number":"SJ12677304537","room_confirmation_number":"SJ12660620688","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","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":"131171","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-21 22:18:08","reservation_modified_date_time":"2021-09-24 19:40:28","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131171","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":"5317803","reservation_id":"119106","confirmation_number":"SJ12647364902","room_confirmation_number":"SJ12661778281","room_stay_from":"2021-09-24","room_stay_to":"2021-09-30","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126224","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-11 14:27:32","reservation_modified_date_time":"2021-09-25 00:16:50","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126224","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":"5317854","reservation_id":"119277","confirmation_number":"SJ12691062752","room_confirmation_number":"SJ12610151860","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","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":"126407","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-13 22:39:07","reservation_modified_date_time":"2021-09-25 12:44:32","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126407","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":"5317868","reservation_id":"122958","confirmation_number":"SJ12646397493","room_confirmation_number":"SJ12633178183","room_stay_from":"2021-09-26","room_stay_to":"2021-09-27","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":"130628","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-13 04:55:07","reservation_modified_date_time":"2021-09-25 12:59:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130628","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":"5318419","reservation_id":"123008","confirmation_number":"SJ12622581525","room_confirmation_number":"SJ12637070569","room_stay_from":"2021-09-24","room_stay_to":"2021-09-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"129179","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-14 15:09:07","reservation_modified_date_time":"2021-09-26 01:37:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129179","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":"5318427","reservation_id":"123632","confirmation_number":"SJ12663865043","room_confirmation_number":"SJ12683468827","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"131372","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-25 04:17:08","reservation_modified_date_time":"2021-09-26 02:01:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131372","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":"5318436","reservation_id":"123676","confirmation_number":"SJ12624098988","room_confirmation_number":"SJ12666615043","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","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":"131437","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-26 04:25:29","reservation_modified_date_time":"2021-09-26 04:25:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131437","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"Reservation created with partial past date","deltaChange":"25.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318458","reservation_id":"123638","confirmation_number":"SJ12636583434","room_confirmation_number":"SJ12688303508","room_stay_from":"2021-09-26","room_stay_to":"2021-09-28","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":"131378","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-25 13:44:09","reservation_modified_date_time":"2021-09-26 12:22:34","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131378","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"5318659","reservation_id":"112333","confirmation_number":"SJ12646363574","room_confirmation_number":"SJ12667692490","room_stay_from":"2021-09-26","room_stay_to":"2021-09-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118902","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 15:24:27","reservation_modified_date_time":"2021-09-26 17:31:31","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":"5318756","reservation_id":"123687","confirmation_number":"SJ12694890105","room_confirmation_number":"SJ12628522960","room_stay_from":"2021-09-26","room_stay_to":"2021-09-27","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"131449","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-26 15:49:37","reservation_modified_date_time":"2021-09-26 19:11:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131449","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":"5318762","reservation_id":"122764","confirmation_number":"SJ12665102667","room_confirmation_number":"SJ12648315512","room_stay_from":"2021-09-26","room_stay_to":"2021-10-03","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":"130422","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-09 00:41:35","reservation_modified_date_time":"2021-09-26 19:14:11","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":"5318443","reservation_id":"123410","confirmation_number":"SJ12676342682","room_confirmation_number":"SJ12681045218","room_stay_from":"2021-09-24","room_stay_to":"2021-09-25","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":"131132","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-21 15:02:11","reservation_modified_date_time":"2021-09-26 04:50:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131132","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"25.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":"5318542","reservation_id":"117433","confirmation_number":"SJ12618177194","room_confirmation_number":"SJ12632095354","room_stay_from":"2021-10-17","room_stay_to":"2021-10-23","room_stay_status":"Active","nightly_price":"25.00,25,25,25,25,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":"131444","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 20:09:10","reservation_modified_date_time":"2021-09-26 15:18:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131444","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"both dates 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":[{"room_stay_id":"5318763","reservation_id":"112333","confirmation_number":"SJ12624127961","room_confirmation_number":"SJ12667692490","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"0.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-26 19:19:05","reservation_modified_date_time":"2021-09-26 19:19:05","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"118902","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-09-26","sub_hotel_id":"0","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}