{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-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":24,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1309,1262,1268","block_room_bookings":[{"confirmation_number":"SJ12615097604","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJ12679965160","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJ12636704330","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","bundle_room":"0","product_id":"1268"}],"bundle_block_count":"1271,1272,1311,1312,1260,1261,1309,1310,1262,1263,1304,1305,1267,1268,1291,1711,1302,1303,1269,1270,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12635491648","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12687832650","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12636915847","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12613856869","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12636819162","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12657351664","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12683570317","room_stay_from":"2021-04-15","room_stay_to":"2021-04-17","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12631803873","room_stay_from":"2021-04-15","room_stay_to":"2021-04-17","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12628012826","room_stay_from":"2021-04-12","room_stay_to":"2021-04-18","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12677111121","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12610244173","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12649373686","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12670831774","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12652487663","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12665847320","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12694671864","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12633642729","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","bundle_room":"0","product_id":"1308"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3195025","reservation_id":"107175","confirmation_number":"SJ12621575072","room_stay_from":"2021-04-06","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.30,223.30,223.30,251.30,251.30,181.30,181.30,181.30,181.30,181.30,209.30,209.30,181.30","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2678.90","grand_total":"3013.77","paid_amount":"3013.77","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2365692959","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":"113633","customer_id":"113633","source_of_creation":"Booking.com","reservation_created_date":"2021-02-08 21:14:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"540.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.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":"3197827","reservation_id":"107582","confirmation_number":"SJ12695345318","room_stay_from":"2021-04-15","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"265.88,294.68","nightly_discount":"0,0","subtotal":"560.56","grand_total":"630.63","paid_amount":"630.63","room_type_id":"320","product_id":"1329","siteminder_id":"BDC-2817384771","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114039","customer_id":"114039","source_of_creation":"Booking.com","reservation_created_date":"2021-02-14 14:06:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"118.90","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"265.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":"3199137","reservation_id":"107102","confirmation_number":"SJ12626135135","room_stay_from":"2021-04-11","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,198.80,198.80,198.80,226.80,226.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1447.60","grand_total":"1628.55","paid_amount":"1628.55","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3670850987","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":"113558","customer_id":"113558","source_of_creation":"Booking.com","reservation_created_date":"2021-02-07 19:48:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"292.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.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":"3206601","reservation_id":"108905","confirmation_number":"SJ12673437172","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,230.30,230.30,195.30","nightly_discount":"0,0,0,0","subtotal":"851.20","grand_total":"957.60","paid_amount":"957.60","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2129030528","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":"115371","customer_id":"115371","source_of_creation":"Booking.com","reservation_created_date":"2021-03-01 12:27:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"171.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"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":"3207507","reservation_id":"109069","confirmation_number":"SJ12669535701","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"265.30,265.30,265.30,265.30","nightly_discount":"0,0,0,0","subtotal":"1061.20","grand_total":"1193.85","paid_amount":"1193.85","room_type_id":"320","product_id":"1332","siteminder_id":"BDC-2800647729","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":"115539","customer_id":"115539","source_of_creation":"Booking.com","reservation_created_date":"2021-03-03 01:27:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"209.02","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"265.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":"3211800","reservation_id":"109750","confirmation_number":"SJ12626066742","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,163.17,163.17","nightly_discount":"0,0,0,0","subtotal":"652.68","grand_total":"734.26","paid_amount":"734.26","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2195896151","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":"116239","customer_id":"116239","source_of_creation":"Booking.com","reservation_created_date":"2021-03-08 06:35:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"135.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.17","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":"3217736","reservation_id":"110594","confirmation_number":"SJ12685058063","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0","subtotal":"921.20","grand_total":"1036.35","paid_amount":"1036.35","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-3947908055","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":"117107","customer_id":"117107","source_of_creation":"Booking.com","reservation_created_date":"2021-03-18 00:56:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"183.82","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":"3227885","reservation_id":"112084","confirmation_number":"SJ12622626262","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,269.25,269.25,269.25,284.25","nightly_discount":"0,0,0,0,0","subtotal":"1361.25","grand_total":"1531.40","paid_amount":"1531.40","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3385954279","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":"118647","customer_id":"118647","source_of_creation":"Booking.com","reservation_created_date":"2021-04-04 16:43:30","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":"126","group_rooms":null,"currentDayPrice":"284.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":"3227916","reservation_id":"106932","confirmation_number":"SJ12638436862","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,226.80,226.80","nightly_discount":"0,0,0,0","subtotal":"851.20","grand_total":"957.60","paid_amount":"957.60","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2955016139","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":"113369","customer_id":"113369","source_of_creation":"Booking.com","reservation_created_date":"2021-02-05 00:37:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"171.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.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":"3227930","reservation_id":"106649","confirmation_number":"SJ12693659277","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,188.30,188.30,160.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2713765928","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":"113068","customer_id":"113068","source_of_creation":"Booking.com","reservation_created_date":"2021-02-01 20:52:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"143.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.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":"3232053","reservation_id":"112619","confirmation_number":"SJ12617875910","room_stay_from":"2021-04-14","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.88,254.88","nightly_discount":"0,0","subtotal":"509.76","grand_total":"573.48","paid_amount":"573.48","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3803754508","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":"119203","customer_id":"119203","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 18:40:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"100.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"254.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":"3233225","reservation_id":"110756","confirmation_number":"SJ12690226732","room_stay_from":"2021-04-13","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.86,199.86,218.09","nightly_discount":"0,0,0","subtotal":"617.81","grand_total":"695.04","paid_amount":"695.04","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3813875517","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":"117266","customer_id":"117266","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 21:07:28","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","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":"218.09","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":"3233505","reservation_id":"109565","confirmation_number":"SJ12649136547","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.65","nightly_discount":"0","subtotal":"194.65","grand_total":"218.98","paid_amount":"218.98","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3143790434","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":"116047","customer_id":"116047","source_of_creation":"Booking.com","reservation_created_date":"2021-03-06 03:51:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"39.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.65","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":"3234766","reservation_id":"110407","confirmation_number":"SJ12621524717","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"250.4","nightly_discount":"0","subtotal":"250.40","grand_total":"281.70","paid_amount":"281.70","room_type_id":"319","product_id":"1310","siteminder_id":"BDC-2604914545","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116921","customer_id":"116921","source_of_creation":"Booking.com","reservation_created_date":"2021-03-16 03:05:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"54.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"250.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":"3235044","reservation_id":"113008","confirmation_number":"SJ12683159795","room_stay_from":"2021-04-15","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"258.2,338.2","nightly_discount":"0,0","subtotal":"596.40","grand_total":"670.95","paid_amount":"670.95","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-2503444990","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":"119592","customer_id":"119592","source_of_creation":"Booking.com","reservation_created_date":"2021-04-14 23:14: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":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"258.2","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":"3235064","reservation_id":"110690","confirmation_number":"SJ12619663607","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"190.28","nightly_discount":"0","subtotal":"190.28","grand_total":"214.06","paid_amount":"214.06","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2535613917","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117201","customer_id":"117201","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 04:40:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"47.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"190.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":"3235203","reservation_id":"106678","confirmation_number":"SJ12628966949","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.27,169.47,169.47,144.27","nightly_discount":"0,0,0,0","subtotal":"627.48","grand_total":"705.91","paid_amount":"705.91","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-2717506620","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":"113096","customer_id":"113096","source_of_creation":"Booking.com","reservation_created_date":"2021-02-01 23:20:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"130.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"144.27","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":"3235248","reservation_id":"112315","confirmation_number":"SJ12657574634","room_stay_from":"2021-04-14","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"236.88,251.28,251.28","nightly_discount":"0,0,0","subtotal":"739.44","grand_total":"831.87","paid_amount":"831.87","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3712549620","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":"118882","customer_id":"118882","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 08:52:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"96.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"251.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3203002","reservation_id":"108311","confirmation_number":"SJ12618983994","room_stay_from":"2021-04-12","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.04,145.04,145.04,145.04,167.44","nightly_discount":"0,0,0,0,0","subtotal":"747.60","grand_total":"841.05","paid_amount":"841.05","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1740580528","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":"114766","customer_id":"114766","source_of_creation":"Expedia","reservation_created_date":"2021-02-22 21:02:12","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","group_rooms":null,"currentDayPrice":"145.04","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":"3204008","reservation_id":"108431","confirmation_number":"SJ12627493216","room_stay_from":"2021-04-09","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"206.64,206.64,139.44,139.44,139.44,139.44,139.44","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1110.48","grand_total":"1249.29","paid_amount":"1249.29","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1741013178","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":"114885","customer_id":"114885","source_of_creation":"Expedia","reservation_created_date":"2021-02-24 03:07:20","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":"139.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":"3206812","reservation_id":"108935","confirmation_number":"SJ12693509082","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,300.30,300.30","nightly_discount":"0,0,0,0","subtotal":"963.20","grand_total":"1083.60","paid_amount":"1083.60","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1742805494","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":"115398","customer_id":"115398","source_of_creation":"Expedia","reservation_created_date":"2021-03-01 18:07:08","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":"181.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":"3217025","reservation_id":"110471","confirmation_number":"SJ12621894439","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0","subtotal":"1151.50","grand_total":"1295.44","paid_amount":"1295.44","room_type_id":"319","product_id":"1276","siteminder_id":"EXP-1748503498","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":"116985","customer_id":"116985","source_of_creation":"Expedia","reservation_created_date":"2021-03-17 01:22:10","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":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":"3229455","reservation_id":"105597","confirmation_number":"SJ12678088790","room_stay_from":"2021-04-13","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.24,128.24,128.24,150.64","nightly_discount":"0,0,0,0","subtotal":"535.36","grand_total":"602.28","paid_amount":"602.28","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1731051753","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":"112018","customer_id":"112018","source_of_creation":"Expedia","reservation_created_date":"2021-01-19 02:21:10","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":"128.24","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":"3233222","reservation_id":"107238","confirmation_number":"SJ12646767441","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"641.20","grand_total":"721.35","paid_amount":"721.35","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1736644067","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":"113700","customer_id":"113700","source_of_creation":"Expedia","reservation_created_date":"2021-02-09 19:40:10","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":"160.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3234181","reservation_id":"109940","confirmation_number":"SJ12656547303","room_stay_from":"2021-04-11","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.28,119.28,119.28,119.28,119.28,285.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"882.30","grand_total":"992.59","paid_amount":"992.59","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1745887271","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":"116435","customer_id":"116435","source_of_creation":"Expedia","reservation_created_date":"2021-03-10 05:02:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"119.28","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":"3234450","reservation_id":"112320","confirmation_number":"SJ12669662919","room_stay_from":"2021-04-15","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"242.56,274.56","nightly_discount":"0,0","subtotal":"517.12","grand_total":"581.76","paid_amount":"581.76","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1756792337","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":"118888","customer_id":"118888","source_of_creation":"Expedia","reservation_created_date":"2021-04-07 13:32:12","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":"126","group_rooms":null,"currentDayPrice":"242.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3234651","reservation_id":"108882","confirmation_number":"SJ12625336558","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"279.30,279.30,314.30,314.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1187.20","grand_total":"1335.60","paid_amount":"1335.60","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1742604468","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":"115347","customer_id":"115347","source_of_creation":"Expedia","reservation_created_date":"2021-03-01 00:27:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","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":"1302,1303","currentDayPrice":"279.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":"3235135","reservation_id":"108547","confirmation_number":"SJ12654179249","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,111.44","nightly_discount":"0,0","subtotal":"250.88","grand_total":"282.24","paid_amount":"0.00","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1741504428","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":"114984","customer_id":"114984","source_of_creation":"Expedia","reservation_created_date":"2021-02-25 16:27:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"50.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3190562","reservation_id":"106768","confirmation_number":"SJ12623957977","room_stay_from":"2021-04-12","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.43,123.43,123.43,123.43,144.99,144.99","nightly_discount":"0,0,0,0,0,0","subtotal":"783.70","grand_total":"881.67","paid_amount":"881.67","room_type_id":"413","product_id":"1267","siteminder_id":"GAM-R2308182920","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":"97545","customer_id":"97545","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-02 21:43:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"123.43","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":"3203933","reservation_id":"107992","confirmation_number":"SJ12675134197","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.43,123.43,123.43,123.43,123.43","nightly_discount":"0,0,0,0,0","subtotal":"617.15","grand_total":"694.30","paid_amount":"694.30","room_type_id":"413","product_id":"1272","siteminder_id":"GAM-R2335170385","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":"114459","customer_id":"114459","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-18 18:30:09","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":"126","group_rooms":null,"currentDayPrice":"123.43","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":"3215879","reservation_id":"107590","confirmation_number":"SJ12664354036","room_stay_from":"2021-04-15","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.06,165.70","nightly_discount":"0,0","subtotal":"306.76","grand_total":"345.11","paid_amount":"345.11","room_type_id":"413","product_id":"1273","siteminder_id":"GAM-R2328034607","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":"81145","customer_id":"81145","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-14 15:53:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"141.06","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3233888","reservation_id":"112902","confirmation_number":"SJ12638966592","room_stay_from":"2021-04-15","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.66,264.26","nightly_discount":"0,0","subtotal":"466.92","grand_total":"525.29","paid_amount":"525.29","room_type_id":"319","product_id":"1286","siteminder_id":"GAM-R2447932031","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":"115192","customer_id":"115192","source_of_creation":"Getaroom.com","reservation_created_date":"2021-04-13 19:11:13","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"202.66","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":"3235236","reservation_id":"112746","confirmation_number":"SJ12673305800","room_stay_from":"2021-04-14","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.66,202.66","nightly_discount":"0.00,0.00","subtotal":"405.32","grand_total":"455.99","paid_amount":"455.99","room_type_id":"319","product_id":"1293","siteminder_id":"GAM-R2444402433","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":"119342","customer_id":"119342","source_of_creation":"Getaroom.com","reservation_created_date":"2021-04-12 02:38:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"202.66","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3234850","reservation_id":"107288","confirmation_number":"SJ12668301195","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"366.00,372.01,372.30","nightly_discount":"0.00,0.00,0.00","subtotal":"1110.31","grand_total":"1286.68","paid_amount":"1286.68","room_type_id":"320","product_id":"1323","siteminder_id":"ABB-HMBYNQ55ES","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1116.90","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113750","customer_id":"113750","source_of_creation":"Airbnb","reservation_created_date":"2021-02-10 16:39:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"32.85","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"366.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.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3234860","reservation_id":"108521","confirmation_number":"SJ12646407806","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"281.50,287.12,287.12","nightly_discount":"0.00,0.00,0.00","subtotal":"855.74","grand_total":"1003.15","paid_amount":"1003.15","room_type_id":"318","product_id":"1281","siteminder_id":"ABB-HM3JA34PMS","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"861.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114961","customer_id":"114961","source_of_creation":"Airbnb","reservation_created_date":"2021-02-25 05:23:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"27.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"281.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3222595","reservation_id":"105978","confirmation_number":"SJ12693907831","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.75,216.75,216.75,231.75,261.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1143.75","grand_total":"1286.72","paid_amount":"1286.72","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112403","customer_id":"112403","source_of_creation":"FE","reservation_created_date":"2021-01-24 15:44:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"261.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":"3234483","reservation_id":"109537","confirmation_number":"SJ12655996639","room_stay_from":"2021-04-14","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.15,220.15","nightly_discount":"0.00,0.00","subtotal":"440.30","grand_total":"495.34","paid_amount":"495.34","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":"116012","customer_id":"116012","source_of_creation":"FE","reservation_created_date":"2021-03-05 22:37:47","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":"220.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235114","reservation_id":"111729","confirmation_number":"SJ12646726301","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Active","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":"338.52","room_type_id":"412","product_id":"1294","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":"118286","customer_id":"118286","source_of_creation":"FE","reservation_created_date":"2021-03-31 01:15:41","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":"0","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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3197939","reservation_id":"107606","confirmation_number":"SJ12647125638","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"322.15,356.15,356.15","nightly_discount":"0.00,0.00,0.00","subtotal":"1034.45","grand_total":"1163.75","paid_amount":"1163.75","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114061","customer_id":"114061","source_of_creation":"PMS","reservation_created_date":"2021-02-14 17:22:19","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"322.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199934","reservation_id":"107912","confirmation_number":"SJ12656060181","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"194.65,254.65,228.37,194.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"872.32","grand_total":"981.36","paid_amount":"981.36","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":"114373","customer_id":"114373","source_of_creation":"PMS","reservation_created_date":"2021-02-17 20:50:30","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":"194.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":"3203761","reservation_id":"108466","confirmation_number":"SJ12683428426","room_stay_from":"2021-04-08","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,299.25,299.25,209.25,209.25,209.25,209.25,209.25,246.75,246.75,209.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2616.75","grand_total":"2943.85","paid_amount":"2943.85","room_type_id":"319","product_id":"1306","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":"114913","customer_id":"114913","source_of_creation":"PMS","reservation_created_date":"2021-02-24 17:50:18","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":"0","group_rooms":null,"currentDayPrice":"209.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":"3207500","reservation_id":"109066","confirmation_number":"SJ12670184291","room_stay_from":"2021-04-15","room_stay_to":"2021-04-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.82,289.58,289.58,174.82,174.82","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1103.62","grand_total":"1241.57","paid_amount":"1241.57","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115536","customer_id":"115536","source_of_creation":"PMS","reservation_created_date":"2021-03-03 00:46:19","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":"174.82","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":"3212433","reservation_id":"108414","confirmation_number":"SJ12614633404","room_stay_from":"2021-04-12","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.25,209.25,209.25,209.25,246.75","nightly_discount":"10.46,10.46,10.46,10.46,12.34","subtotal":"1083.75","grand_total":"1158.27","paid_amount":"1158.27","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":"114868","customer_id":"114868","source_of_creation":"PMS","reservation_created_date":"2021-02-23 23:18:02","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.25","currentDayDiscount":"10.46","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3214174","reservation_id":"108092","confirmation_number":"SJ12681091358","room_stay_from":"2021-04-14","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,224.25,224.25,194.25,194.25","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"1031.25","grand_total":"1160.15","paid_amount":"1160.15","room_type_id":"319","product_id":"1943","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114559","customer_id":"114559","source_of_creation":"PMS","reservation_created_date":"2021-02-20 02:59:46","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":"224.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3224645","reservation_id":"111610","confirmation_number":"SJ12658811173","room_stay_from":"2021-04-14","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"326.40,343.40","nightly_discount":"0.00,0.00","subtotal":"669.80","grand_total":"753.53","paid_amount":"753.53","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":"118170","customer_id":"118170","source_of_creation":"PMS","reservation_created_date":"2021-03-29 19:01:37","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","group_rooms":null,"currentDayPrice":"343.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":"3233390","reservation_id":"109656","confirmation_number":"SJ12684671867","room_stay_from":"2021-04-14","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,194.25,321.75","nightly_discount":"0.00,0.00,0.00","subtotal":"710.25","grand_total":"799.03","paid_amount":"799.03","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116143","customer_id":"116143","source_of_creation":"PMS","reservation_created_date":"2021-03-07 14:33:26","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"194.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":"3234017","reservation_id":"112782","confirmation_number":"SJ12662726796","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,0.00,160.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"480.00","grand_total":"540.00","paid_amount":"540.00","room_type_id":"319","product_id":"1275","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":"117810","customer_id":"117810","source_of_creation":"PMS","reservation_created_date":"2021-04-12 19:38:40","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":"160.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":"3234720","reservation_id":"113019","confirmation_number":"SJ12690007147","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.15","nightly_discount":"0.00","subtotal":"254.15","grand_total":"285.92","paid_amount":"285.92","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":"119603","customer_id":"119603","source_of_creation":"PMS","reservation_created_date":"2021-04-15 02:32:25","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","currentDayPrice":"254.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235207","reservation_id":"107910","confirmation_number":"SJ12659434508","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.25,209.25,209.25,209.25","nightly_discount":"0.00,0,0,0","subtotal":"837.00","grand_total":"941.63","paid_amount":"941.63","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114373","customer_id":"114373","source_of_creation":"PMS","reservation_created_date":"2021-02-17 20:47:58","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"209.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3198674","reservation_id":"107717","confirmation_number":"SJ12646229101","room_stay_from":"2021-04-10","room_stay_to":"2021-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","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-15 21:20:23","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":"114.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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3234768","reservation_id":"110407","confirmation_number":"SJ12699572537","room_confirmation_number":"SJ12621524717","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"116921","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-15 14:38:15","reservation_modified_date_time":"2021-04-15 14:38:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116921","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3235065","reservation_id":"110690","confirmation_number":"SJ12685818539","room_confirmation_number":"SJ12619663607","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"117201","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-15 19:09:05","reservation_modified_date_time":"2021-04-15 19:09:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117201","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","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":"3197828","reservation_id":"107582","confirmation_number":"SJ12664518416","room_confirmation_number":"SJ12695345318","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"1777","service_quantity":"1","customer_traveller_id":"114039","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-02-14 14:06:13","reservation_modified_date_time":"2021-02-14 14:06:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114039","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3235045","reservation_id":"113008","confirmation_number":"SJ12646444204","room_confirmation_number":"SJ12683159795","room_stay_from":"2021-04-15","room_stay_to":"2021-04-17","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"119592","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-15 19:06:18","reservation_modified_date_time":"2021-04-15 19:06:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119592","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":"3204216","reservation_id":"108521","confirmation_number":"SJ12637613951","room_confirmation_number":"SJ12646407806","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"75.45","paid_amount":"75.45","product_id":"1777","service_quantity":"1","customer_traveller_id":"114961","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-02-25 05:23:10","reservation_modified_date_time":"2021-02-25 05:23:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114961","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","sub_hotel_id":"126","currentDayPrice":"25","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":"3203935","reservation_id":"107992","confirmation_number":"SJ12652065111","room_confirmation_number":"SJ12675134197","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","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":"114459","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-18 18:30:09","reservation_modified_date_time":"2021-02-24 22:11:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114459","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":"3204007","reservation_id":"108431","confirmation_number":"SJ12667478651","room_confirmation_number":"SJ12627493216","room_stay_from":"2021-04-09","room_stay_to":"2021-04-16","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":"114885","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 03:07:20","reservation_modified_date_time":"2021-02-24 03:07:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114885","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":"3207508","reservation_id":"109069","confirmation_number":"SJ12640716268","room_confirmation_number":"SJ12669535701","room_stay_from":"2021-04-12","room_stay_to":"2021-04-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":"115539","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 01:27:09","reservation_modified_date_time":"2021-03-03 01:27:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115539","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":"3211801","reservation_id":"109750","confirmation_number":"SJ12642546786","room_confirmation_number":"SJ12626066742","room_stay_from":"2021-04-12","room_stay_to":"2021-04-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":"116239","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-08 06:35:09","reservation_modified_date_time":"2021-03-08 06:35:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116239","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":"3217026","reservation_id":"110471","confirmation_number":"SJ12648146018","room_confirmation_number":"SJ12621894439","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","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":"116985","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 01:22:10","reservation_modified_date_time":"2021-03-17 01:22:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116985","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":"3217737","reservation_id":"110594","confirmation_number":"SJ12664777877","room_confirmation_number":"SJ12685058063","room_stay_from":"2021-04-12","room_stay_to":"2021-04-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":"117107","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 00:56:09","reservation_modified_date_time":"2021-03-18 00:56:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117107","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":"3222596","reservation_id":"105978","confirmation_number":"SJ12658989639","room_confirmation_number":"SJ12693907831","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","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":"112403","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 15:44:05","reservation_modified_date_time":"2021-03-26 11:43:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112403","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":"3224646","reservation_id":"111610","confirmation_number":"SJ12696590023","room_confirmation_number":"SJ12658811173","room_stay_from":"2021-04-14","room_stay_to":"2021-04-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":"118170","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-29 19:01:37","reservation_modified_date_time":"2021-03-29 19:01:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118170","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":"3227884","reservation_id":"112084","confirmation_number":"SJ12641575023","room_confirmation_number":"SJ12622626262","room_stay_from":"2021-04-11","room_stay_to":"2021-04-16","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"118647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 16:43:30","reservation_modified_date_time":"2021-04-04 17:40:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118647","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":"3232054","reservation_id":"112619","confirmation_number":"SJ12639255259","room_confirmation_number":"SJ12617875910","room_stay_from":"2021-04-14","room_stay_to":"2021-04-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":"119203","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 18:40:11","reservation_modified_date_time":"2021-04-10 18:40:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119203","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":"3233224","reservation_id":"107238","confirmation_number":"SJ12677929403","room_confirmation_number":"SJ12646767441","room_stay_from":"2021-04-12","room_stay_to":"2021-04-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":"113700","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 19:40:10","reservation_modified_date_time":"2021-04-12 19:44:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113700","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":"3233226","reservation_id":"110756","confirmation_number":"SJ12664795823","room_confirmation_number":"SJ12690226732","room_stay_from":"2021-04-13","room_stay_to":"2021-04-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":"117266","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 21:07:28","reservation_modified_date_time":"2021-04-12 19:44:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117266","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":"3233506","reservation_id":"109565","confirmation_number":"SJ12675378750","room_confirmation_number":"SJ12649136547","room_stay_from":"2021-04-15","room_stay_to":"2021-04-16","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":"116047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 03:51:11","reservation_modified_date_time":"2021-04-13 00:30:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116047","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":"3234018","reservation_id":"112782","confirmation_number":"SJ12621438978","room_confirmation_number":"SJ12662726796","room_stay_from":"2021-04-12","room_stay_to":"2021-04-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,25.00,0.00,0.00","subtotal":"100.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"117810","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 19:38:40","reservation_modified_date_time":"2021-04-13 21:40:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117810","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":"3234484","reservation_id":"109537","confirmation_number":"SJ12688270090","room_confirmation_number":"SJ12655996639","room_stay_from":"2021-04-14","room_stay_to":"2021-04-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":"116012","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 22:37:47","reservation_modified_date_time":"2021-04-14 19:58:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116012","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":"3234721","reservation_id":"113019","confirmation_number":"SJ12676056218","room_confirmation_number":"SJ12690007147","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"119603","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 02:32:25","reservation_modified_date_time":"2021-04-15 14:17:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119603","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":"3234769","reservation_id":"110407","confirmation_number":"SJ12654269462","room_confirmation_number":"SJ12621524717","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"116921","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 03:05:09","reservation_modified_date_time":"2021-04-15 14:38:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116921","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3235066","reservation_id":"110690","confirmation_number":"SJ12684745774","room_confirmation_number":"SJ12619663607","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"117201","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 04:40:10","reservation_modified_date_time":"2021-04-15 19:09:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117201","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3235237","reservation_id":"112746","confirmation_number":"SJ12626564678","room_confirmation_number":"SJ12673305800","room_stay_from":"2021-04-14","room_stay_to":"2021-04-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":"119342","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 02:38:13","reservation_modified_date_time":"2021-04-16 01:47:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119342","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-25.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197829","reservation_id":"107582","confirmation_number":"SJ12614402697","room_confirmation_number":"SJ12695345318","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"114039","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 14:06:13","reservation_modified_date_time":"2021-02-14 14:06:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114039","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3198675","reservation_id":"107717","confirmation_number":"SJ12699705042","room_confirmation_number":"SJ12646229101","room_stay_from":"2021-04-10","room_stay_to":"2021-04-17","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":"114163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 21:20:23","reservation_modified_date_time":"2021-02-15 21:20:23","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":"3203003","reservation_id":"108311","confirmation_number":"SJ12655645984","room_confirmation_number":"SJ12618983994","room_stay_from":"2021-04-12","room_stay_to":"2021-04-17","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":"114766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 21:02:12","reservation_modified_date_time":"2021-02-22 21:02:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114766","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":"3212434","reservation_id":"108414","confirmation_number":"SJ12699218495","room_confirmation_number":"SJ12614633404","room_stay_from":"2021-04-12","room_stay_to":"2021-04-17","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":"114868","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 23:18:02","reservation_modified_date_time":"2021-03-09 15:11:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114868","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":"3215881","reservation_id":"107590","confirmation_number":"SJ12657543057","room_confirmation_number":"SJ12664354036","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"81145","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 15:53:06","reservation_modified_date_time":"2021-03-15 01:47:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81145","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":"3229459","reservation_id":"105597","confirmation_number":"SJ12647028881","room_confirmation_number":"SJ12678088790","room_stay_from":"2021-04-13","room_stay_to":"2021-04-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":"112018","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 02:21:10","reservation_modified_date_time":"2021-04-07 13:23:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112018","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":"3233391","reservation_id":"109656","confirmation_number":"SJ12687579786","room_confirmation_number":"SJ12684671867","room_stay_from":"2021-04-14","room_stay_to":"2021-04-17","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":"116143","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-07 14:33:26","reservation_modified_date_time":"2021-04-12 22:41:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116143","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":"3233889","reservation_id":"112902","confirmation_number":"SJ12682407347","room_confirmation_number":"SJ12638966592","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"115192","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 19:11:13","reservation_modified_date_time":"2021-04-13 19:11:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115192","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":"3234182","reservation_id":"109940","confirmation_number":"SJ12684202030","room_confirmation_number":"SJ12656547303","room_stay_from":"2021-04-11","room_stay_to":"2021-04-17","room_stay_status":"Active","nightly_price":"25,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":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"116435","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 05:02:11","reservation_modified_date_time":"2021-04-14 02:07:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116435","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":"3234451","reservation_id":"112320","confirmation_number":"SJ12667534190","room_confirmation_number":"SJ12669662919","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"118888","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 13:32:12","reservation_modified_date_time":"2021-04-14 19:21:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118888","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":"3235046","reservation_id":"113008","confirmation_number":"SJ12621180654","room_confirmation_number":"SJ12683159795","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"119592","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-14 23:14:28","reservation_modified_date_time":"2021-04-15 19:06:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119592","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235249","reservation_id":"112315","confirmation_number":"SJ12623235707","room_confirmation_number":"SJ12657574634","room_stay_from":"2021-04-14","room_stay_to":"2021-04-17","room_stay_status":"Active","nightly_price":"25,25,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":"118882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 08:52:09","reservation_modified_date_time":"2021-04-16 02:15:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118882","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","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":"3190563","reservation_id":"106768","confirmation_number":"SJ12662342364","room_confirmation_number":"SJ12623957977","room_stay_from":"2021-04-12","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"97545","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:43:08","reservation_modified_date_time":"2021-02-02 21:43:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97545","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":"3197940","reservation_id":"107606","confirmation_number":"SJ12697143677","room_confirmation_number":"SJ12647125638","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"114061","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 17:22:19","reservation_modified_date_time":"2021-02-14 17:22:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114061","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":"3199138","reservation_id":"107102","confirmation_number":"SJ12627735779","room_confirmation_number":"SJ12626135135","room_stay_from":"2021-04-11","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","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":"113558","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-07 19:48:13","reservation_modified_date_time":"2021-02-16 17:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113558","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":"3206813","reservation_id":"108935","confirmation_number":"SJ12619379447","room_confirmation_number":"SJ12693509082","room_stay_from":"2021-04-14","room_stay_to":"2021-04-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":"115398","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 18:07:08","reservation_modified_date_time":"2021-03-01 18:07:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115398","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":"3227917","reservation_id":"106932","confirmation_number":"SJ12611107654","room_confirmation_number":"SJ12638436862","room_stay_from":"2021-04-14","room_stay_to":"2021-04-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":"113369","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 00:37:10","reservation_modified_date_time":"2021-04-04 17:58:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113369","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":"3234654","reservation_id":"108882","confirmation_number":"SJ12611246529","room_confirmation_number":"SJ12625336558","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25,25,25,25","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":"115347","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 00:27:11","reservation_modified_date_time":"2021-04-15 01:37:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115347","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":"3234853","reservation_id":"107288","confirmation_number":"SJ12661016529","room_confirmation_number":"SJ12668301195","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","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":"113750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-10 16:39:07","reservation_modified_date_time":"2021-04-15 15:18:58","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113750","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":"3234861","reservation_id":"108521","confirmation_number":"SJ12663182248","room_confirmation_number":"SJ12646407806","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","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":"114961","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 05:23:10","reservation_modified_date_time":"2021-04-15 15:20:31","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114961","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3195026","reservation_id":"107175","confirmation_number":"SJ12617337503","room_confirmation_number":"SJ12621575072","room_stay_from":"2021-04-06","room_stay_to":"2021-04-19","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":"113633","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-08 21:14:13","reservation_modified_date_time":"2021-02-09 22:22:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113633","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":"3199935","reservation_id":"107912","confirmation_number":"SJ12612934845","room_confirmation_number":"SJ12656060181","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"114373","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 20:50:30","reservation_modified_date_time":"2021-02-17 20:50:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114373","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":"3203762","reservation_id":"108466","confirmation_number":"SJ12698704665","room_confirmation_number":"SJ12683428426","room_stay_from":"2021-04-08","room_stay_to":"2021-04-19","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"275.00","grand_total":"309.38","paid_amount":"309.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114913","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 17:50:18","reservation_modified_date_time":"2021-02-24 17:50:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114913","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":"3206602","reservation_id":"108905","confirmation_number":"SJ12656602156","room_confirmation_number":"SJ12673437172","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"115371","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 12:27:07","reservation_modified_date_time":"2021-03-01 12:27:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115371","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":"3214175","reservation_id":"108092","confirmation_number":"SJ12671576272","room_confirmation_number":"SJ12681091358","room_stay_from":"2021-04-14","room_stay_to":"2021-04-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":"114559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-20 02:59:46","reservation_modified_date_time":"2021-03-11 22:44:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114559","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":"3227931","reservation_id":"106649","confirmation_number":"SJ12657566167","room_confirmation_number":"SJ12693659277","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"113068","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 20:52:13","reservation_modified_date_time":"2021-04-04 18:00:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113068","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":"3235204","reservation_id":"106678","confirmation_number":"SJ12674752462","room_confirmation_number":"SJ12628966949","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"113096","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 23:20:09","reservation_modified_date_time":"2021-04-15 23:55:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113096","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":"3235208","reservation_id":"107910","confirmation_number":"SJ12677913422","room_confirmation_number":"SJ12659434508","room_stay_from":"2021-04-15","room_stay_to":"2021-04-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":"114373","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 20:47:58","reservation_modified_date_time":"2021-04-15 23:55:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114373","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":"3207501","reservation_id":"109066","confirmation_number":"SJ12668579902","room_confirmation_number":"SJ12670184291","room_stay_from":"2021-04-15","room_stay_to":"2021-04-20","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":"115536","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 00:46:19","reservation_modified_date_time":"2021-03-03 00:46:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115536","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":"3235115","reservation_id":"111729","confirmation_number":"SJ12684594187","room_confirmation_number":"SJ12646726301","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","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":"118286","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 01:15:41","reservation_modified_date_time":"2021-04-15 20:34:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118286","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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"}]},{"room_stay_id":"3235136","reservation_id":"108547","confirmation_number":"SJ12685564795","room_confirmation_number":"SJ12654179249","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"25,25","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":"114984","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 16:27:10","reservation_modified_date_time":"2021-04-15 21:33:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114984","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":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}