{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-05-09","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":18,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1915,1274,1273","block_room_bookings":[{"confirmation_number":"SJ12620876023","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1915"},{"confirmation_number":"SJ12613703832","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1274"},{"confirmation_number":"SJ12642030840","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1273"}],"bundle_block_count":"1267,1268,1269,1270,1271,1272,1260,1261,1262,1263,1302,1303,1311,1312,1307,1308,1304,1305,1291,1711,1309,1310","bundle_block_bookings":[{"confirmation_number":"SJB12649960024","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12638186137","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12612603453","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12628250153","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12667406109","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12633084657","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12674157460","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12624192858","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12629818712","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12649939778","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12678695974","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12657595815","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12688959357","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12624212039","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12621831340","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12678319967","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12660100258","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12689853253","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12653204889","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12651992909","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","bundle_room":"0","product_id":"1310"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3186655","reservation_id":"106369","confirmation_number":"SJ12638304106","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"5","nightly_price":"315.29,315.29,290.99","nightly_discount":"0,0,0","subtotal":"921.57","grand_total":"1036.77","paid_amount":"1036.77","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-3542327806","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":"112766","customer_id":"112766","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 00:30:28","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"488.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"290.99","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":"3186710","reservation_id":"106369","confirmation_number":"SJ12623093770","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"234.92,234.92,210.62","nightly_discount":"0,0,0","subtotal":"680.46","grand_total":"765.51","paid_amount":"765.51","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-3542327806","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112766","customer_id":"112766","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 00:30:20","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"488.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"210.62","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":"3186715","reservation_id":"106369","confirmation_number":"SJ12658997057","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"254.54,254.54,230.24","nightly_discount":"0,0,0","subtotal":"739.32","grand_total":"831.74","paid_amount":"831.74","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-3542327806","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":"112766","customer_id":"112766","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 00:30:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"488.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"230.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":"3215145","reservation_id":"110225","confirmation_number":"SJ12641959346","room_stay_from":"2021-04-30","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.37,251.37,163.17,163.17,163.17,163.17,163.17,207.27,207.27,163.17","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1896.30","grand_total":"2133.34","paid_amount":"2133.34","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3439332408","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":"116739","customer_id":"116739","source_of_creation":"Booking.com","reservation_created_date":"2021-03-13 20:21:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"386.33","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":"3220872","reservation_id":"111050","confirmation_number":"SJ12634835401","room_stay_from":"2021-05-03","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,209.30,209.30,251.30,251.30,209.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1549.10","grand_total":"1742.74","paid_amount":"1742.74","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3995442698","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":"117592","customer_id":"117592","source_of_creation":"Booking.com","reservation_created_date":"2021-03-23 01:57:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"310.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.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":"3229946","reservation_id":"108244","confirmation_number":"SJ12646989304","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.80,226.80,226.80,198.80","nightly_discount":"0,0,0,0","subtotal":"830.20","grand_total":"933.98","paid_amount":"933.98","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2657268158","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":"114713","customer_id":"114713","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 03:54:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"167.44","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":"3237992","reservation_id":"113469","confirmation_number":"SJ12621219875","room_stay_from":"2021-05-08","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"308.88,215.28","nightly_discount":"0,0","subtotal":"524.16","grand_total":"589.68","paid_amount":"589.68","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-3837803565","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":"120063","customer_id":"120063","source_of_creation":"Booking.com","reservation_created_date":"2021-04-20 15:50:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"103.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3247628","reservation_id":"114659","confirmation_number":"SJ12686567802","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"205.78","nightly_discount":"0","subtotal":"205.78","grand_total":"231.50","paid_amount":"231.50","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3221998155","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":"121354","customer_id":"121354","source_of_creation":"Booking.com","reservation_created_date":"2021-05-06 18:29:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"41.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"205.78","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":"3237345","reservation_id":"113094","confirmation_number":"SJ12658487927","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"315.50,218.00,218.00,218.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"969.50","grand_total":"1090.69","paid_amount":"1090.69","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2651493356","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":"119677","customer_id":"119677","source_of_creation":"Booking.com","reservation_created_date":"2021-04-16 15:08:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"218.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":"3248441","reservation_id":"110398","confirmation_number":"SJ12653392901","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,160.30,139.30,139.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"648.20","grand_total":"729.23","paid_amount":"729.23","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3427364607","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":"116913","customer_id":"116913","source_of_creation":"Booking.com","reservation_created_date":"2021-03-16 00:29:18","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":"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":"3237333","reservation_id":"113011","confirmation_number":"SJ12671187460","room_stay_from":"2021-05-08","room_stay_to":"2021-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.61,181.64,181.64,181.64,199.86","nightly_discount":"0,0,0,0,0","subtotal":"1005.39","grand_total":"1131.06","paid_amount":"1131.06","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-3999431651","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":"119596","customer_id":"119596","source_of_creation":"Booking.com","reservation_created_date":"2021-04-15 00:39:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"203.45","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.64","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":"3229944","reservation_id":"107893","confirmation_number":"SJ12666604318","room_stay_from":"2021-05-07","room_stay_to":"2021-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,181.30,160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1241.10","grand_total":"1396.24","paid_amount":"1396.24","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3924566244","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":"114354","customer_id":"114354","source_of_creation":"Booking.com","reservation_created_date":"2021-02-17 17:34:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"254.90","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":"3248707","reservation_id":"114785","confirmation_number":"SJ12659881484","room_stay_from":"2021-07-21","room_stay_to":"2021-07-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.35,161.35","nightly_discount":"0,0","subtotal":"322.70","grand_total":"363.04","paid_amount":"181.52","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3661073822","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":"121513","customer_id":"121513","source_of_creation":"Booking.com","reservation_created_date":"2021-05-08 18:22:28","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3219447","reservation_id":"110766","confirmation_number":"SJ12611936199","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"359.25,314.25,284.25","nightly_discount":"0,0,0","subtotal":"957.75","grand_total":"1077.47","paid_amount":"1077.47","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1749714019","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":"121521","customer_id":"117278","source_of_creation":"Expedia","reservation_created_date":"2021-03-19 21:47:08","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":"126","group_rooms":"1291,1711","currentDayPrice":"314.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":"3227777","reservation_id":"112071","confirmation_number":"SJ12661848392","room_stay_from":"2021-05-06","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,299.25,299.25,224.25,224.25","nightly_discount":"0,0,0,0,0","subtotal":"1316.25","grand_total":"1480.78","paid_amount":"1480.78","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1755694807","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":"118638","customer_id":"118638","source_of_creation":"Expedia","reservation_created_date":"2021-04-04 14:42:40","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":"224.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3230435","reservation_id":"112423","confirmation_number":"SJ12654482186","room_stay_from":"2021-05-07","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"284.40,284.40,224.40,224.40","nightly_discount":"0,0,0,0","subtotal":"1017.60","grand_total":"1144.80","paid_amount":"1144.80","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1757113043","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":"118996","customer_id":"118996","source_of_creation":"Expedia","reservation_created_date":"2021-04-08 04:22:12","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"224.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3230576","reservation_id":"112436","confirmation_number":"SJ12686457235","room_stay_from":"2021-05-09","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"4","nightly_price":"300.16,300.16","nightly_discount":"0,0","subtotal":"600.32","grand_total":"675.36","paid_amount":"675.36","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1757204966","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":"119007","customer_id":"119007","source_of_creation":"Expedia","reservation_created_date":"2021-04-08 13:49:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"300.16","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":"3248383","reservation_id":"110941","confirmation_number":"SJ12625702045","room_stay_from":"2021-05-09","room_stay_to":"2021-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.30,160.30,160.30,188.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1750544570","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":"117479","customer_id":"117479","source_of_creation":"Expedia","reservation_created_date":"2021-03-22 01:58:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219066","reservation_id":"110758","confirmation_number":"SJ12673721071","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.04,181.44,159.04,159.04,181.44,181.44","nightly_discount":"0,0,0,0,0,0","subtotal":"1077.44","grand_total":"1212.12","paid_amount":"1212.12","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1749702460","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":"117271","customer_id":"117271","source_of_creation":"Expedia","reservation_created_date":"2021-03-19 21:17:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228336","reservation_id":"107196","confirmation_number":"SJ12665831114","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.30,160.30,139.30,139.30,139.30,139.30,188.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1094.10","grand_total":"1230.87","paid_amount":"1230.87","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1736436642","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":"113657","customer_id":"113657","source_of_creation":"Expedia","reservation_created_date":"2021-02-09 01:15:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"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":"3248723","reservation_id":"114730","confirmation_number":"SJ12698672073","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75,269.25","nightly_discount":"0,0,0,0,0","subtotal":"1256.25","grand_total":"1413.28","paid_amount":"277.60","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1768316958","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121445","customer_id":"121445","source_of_creation":"Expedia","reservation_created_date":"2021-05-07 20:35:52","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3248283","reservation_id":"111964","confirmation_number":"SJ12674719329","room_stay_from":"2021-05-08","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.44,320.28","nightly_discount":"0.00,0.00","subtotal":"636.72","grand_total":"737.87","paid_amount":"737.87","room_type_id":"319","product_id":"1288","siteminder_id":"ABB-HMW8TNR22J","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"640.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118526","customer_id":"118526","source_of_creation":"Airbnb","reservation_created_date":"2021-04-03 03:34:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"18.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"320.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3248751","reservation_id":"114678","confirmation_number":"SJ12681939249","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"245.36","nightly_discount":"0.00","subtotal":"245.36","grand_total":"284.34","paid_amount":"284.34","room_type_id":"413","product_id":"1262","siteminder_id":"ABB-HMDCPSNZ5Z","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"246.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121379","customer_id":"121379","source_of_creation":"Airbnb","reservation_created_date":"2021-05-06 22:34:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"7.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"245.36","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3248755","reservation_id":"114692","confirmation_number":"SJ12658318056","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"245.73","nightly_discount":"0.00","subtotal":"245.73","grand_total":"288.59","paid_amount":"288.59","room_type_id":"413","product_id":"1264","siteminder_id":"ABB-HMHZTWRZR8","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"247.34","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121396","customer_id":"121396","source_of_creation":"Airbnb","reservation_created_date":"2021-05-07 03:20:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"8.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"245.73","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":"3248870","reservation_id":"114818","confirmation_number":"SJ12686578908","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.37","nightly_discount":"0.00","subtotal":"245.37","grand_total":"284.35","paid_amount":"284.35","room_type_id":"413","product_id":"1265","siteminder_id":"ABB-HM8CXDHCDR","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"246.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121560","customer_id":"121560","source_of_creation":"Airbnb","reservation_created_date":"2021-05-09 14:50:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"7.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"245.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3248336","reservation_id":"111970","confirmation_number":"SJ12689687091","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.58,304.98,304.98","nightly_discount":"0.00,0.00,0.00","subtotal":"909.54","grand_total":"1054.03","paid_amount":"1054.03","room_type_id":"319","product_id":"1293","siteminder_id":"ABB-HMY8W45ZXZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"914.94","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118532","customer_id":"118532","source_of_creation":"Airbnb","reservation_created_date":"2021-04-03 05:21:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"26.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"304.98","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":"3248760","reservation_id":"110406","confirmation_number":"SJ12639010302","room_stay_from":"2021-05-09","room_stay_to":"2021-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.10,199.10,199.10,193.13,199.10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"989.53","grand_total":"1146.75","paid_amount":"1146.75","room_type_id":"319","product_id":"1301","siteminder_id":"ABB-HMBFZWMKF2","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"995.50","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116920","customer_id":"116920","source_of_creation":"Airbnb","reservation_created_date":"2021-03-16 02:53:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"29.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"199.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3248698","reservation_id":"114793","confirmation_number":"SJ12655988711","room_stay_from":"2021-05-31","room_stay_to":"2021-06-02","room_stay_status":"Active","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"376.36,376.36","nightly_discount":"0.00,0","subtotal":"752.72","grand_total":"886.78","paid_amount":"0.00","room_type_id":"320","product_id":"1328","siteminder_id":"ABB-HMAJ3RBMD5","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"752.72","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121528","customer_id":"121528","source_of_creation":"Airbnb","reservation_created_date":"2021-05-08 19:39:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"25.08","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3248887","reservation_id":"111307","confirmation_number":"SJ12681288342","room_stay_from":"2021-06-06","room_stay_to":"2021-06-07","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"412.08","nightly_discount":"0","subtotal":"412.08","grand_total":"463.59","paid_amount":"0.00","room_type_id":"320","product_id":"1328","siteminder_id":"ABB-HMWD4Y2X2S","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"412.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117842","customer_id":"117842","source_of_creation":"Airbnb","reservation_created_date":"2021-03-26 01:52:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"12.12","resv_is_no_show":"0","is_bundle":"1","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3206470","reservation_id":"108881","confirmation_number":"SJ12692197742","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,224.25,224.25,171.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"769.50","grand_total":"865.69","paid_amount":"865.69","room_type_id":"413","product_id":"1263","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":"115345","customer_id":"115345","source_of_creation":"FE","reservation_created_date":"2021-03-01 00:18:46","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","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":"171.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":"3207410","reservation_id":"109032","confirmation_number":"SJ12661565286","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"336.75,336.75,284.25","nightly_discount":"0.00,0.00,0.00","subtotal":"957.75","grand_total":"1077.47","paid_amount":"1077.47","room_type_id":"320","product_id":"1328","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":"115491","customer_id":"115491","source_of_creation":"FE","reservation_created_date":"2021-03-02 17:32:25","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":"","sub_hotel_id":"0","group_rooms":"1302,1303","currentDayPrice":"284.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":"3226974","reservation_id":"111980","confirmation_number":"SJ12611022747","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,224.25","nightly_discount":"0.00,0.00,0.00","subtotal":"822.75","grand_total":"925.60","paid_amount":"925.60","room_type_id":"318","product_id":"1281","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":"118545","customer_id":"118545","source_of_creation":"FE","reservation_created_date":"2021-04-03 14:49:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3234668","reservation_id":"113023","confirmation_number":"SJ12678640539","room_stay_from":"2021-05-09","room_stay_to":"2021-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.75,201.75,201.75","nightly_discount":"0.00,0.00,0.00","subtotal":"605.25","grand_total":"680.90","paid_amount":"680.90","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":"119605","customer_id":"119605","source_of_creation":"FE","reservation_created_date":"2021-04-15 03:16:39","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","group_rooms":null,"currentDayPrice":"201.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216731","reservation_id":"109581","confirmation_number":"SJ12638613154","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"259.47,259.47,259.47,259.47,259.47,259.47","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1556.82","grand_total":"1751.42","paid_amount":"1751.42","room_type_id":"320","product_id":"1910","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":"116060","customer_id":"116060","source_of_creation":"FE","reservation_created_date":"2021-03-06 17:01:47","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","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":"1309,1310","currentDayPrice":"259.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3218375","reservation_id":"110616","confirmation_number":"SJ12673310378","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"322.15,381.65,381.65,322.15","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1407.60","grand_total":"1583.55","paid_amount":"1583.55","room_type_id":"320","product_id":"1332","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":"117129","customer_id":"117129","source_of_creation":"PMS","reservation_created_date":"2021-03-18 14:13:45","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","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":"1311,1312","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":"3219678","reservation_id":"110835","confirmation_number":"SJ12666218882","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.25,359.25,359.25,314.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1347.00","grand_total":"1515.38","paid_amount":"1515.38","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":"117359","customer_id":"117359","source_of_creation":"PMS","reservation_created_date":"2021-03-20 21:12:15","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":"314.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":"3247693","reservation_id":"114666","confirmation_number":"SJ12694047338","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","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":"318","product_id":"1282","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":"119290","customer_id":"119290","source_of_creation":"PMS","reservation_created_date":"2021-05-06 20:14:47","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":"","sub_hotel_id":"0","group_rooms":null,"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":"3248896","reservation_id":"114590","confirmation_number":"SJ12695554552","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.15","nightly_discount":"12.71","subtotal":"254.15","grand_total":"271.62","paid_amount":"271.62","room_type_id":"319","product_id":"1318","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":"121280","customer_id":"121280","source_of_creation":"PMS","reservation_created_date":"2021-05-05 18:18:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","currentDayPrice":"254.15","currentDayDiscount":"12.71","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3221948","reservation_id":"111216","confirmation_number":"SJ12612511583","room_stay_from":"2021-05-08","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00","nightly_discount":"20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40","subtotal":"2652.00","grand_total":"2685.15","paid_amount":"2685.15","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102743","customer_id":"102743","source_of_creation":"PMS","reservation_created_date":"2021-03-24 23:11:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"204.00","currentDayDiscount":"20.40","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3204825","reservation_id":"108598","confirmation_number":"SJ12666931534","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:46:19","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":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3217062","reservation_id":"110484","confirmation_number":"SJ12657273553","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 02:40:27","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":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229905","reservation_id":"110482","confirmation_number":"SJ12638617405","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 02:31:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229069","reservation_id":"109894","confirmation_number":"SJ12647133042","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-10 00:15:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3241568","reservation_id":"110987","confirmation_number":"SJ12610517571","room_stay_from":"2021-05-09","room_stay_to":"2021-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-22 18:31:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3246872","reservation_id":"110988","confirmation_number":"SJ12644241804","room_stay_from":"2021-05-09","room_stay_to":"2021-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-22 18:36:20","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227768","reservation_id":"108702","confirmation_number":"SJ12674341216","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.85,108.85,108.85,108.85,108.85,108.85,108.85","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"761.95","grand_total":"761.95","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-27 01:46:00","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"108.85","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3186713","reservation_id":"106369","confirmation_number":"SJ12665853162","room_confirmation_number":"SJ12623093770","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"112766","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-01-29 02:23:56","reservation_modified_date_time":"2021-01-29 02:23:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112766","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3247777","reservation_id":"114692","confirmation_number":"SJ12626508303","room_confirmation_number":"SJ12658318056","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.15","paid_amount":"25.15","product_id":"1777","service_quantity":"1","customer_traveller_id":"121396","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-05-07 03:20:06","reservation_modified_date_time":"2021-05-07 03:20:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121396","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.59","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3237339","reservation_id":"113094","confirmation_number":"SJ12647039808","room_confirmation_number":"SJ12658487927","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"119677","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-19 14:58:02","reservation_modified_date_time":"2021-04-19 14:58:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119677","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":"3248684","reservation_id":"110409","confirmation_number":"SJ12669168801","room_confirmation_number":"SJ12615063376","room_stay_from":"2021-05-28","room_stay_to":"2021-05-31","room_stay_status":"Active","nightly_price":"75,75,75","nightly_discount":"0.00,0.00,0","subtotal":"225.00","grand_total":"253.13","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"116923","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-05-09 12:12:48","reservation_modified_date_time":"2021-05-09 12:12:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116923","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3186656","reservation_id":"106369","confirmation_number":"SJ12668588940","room_confirmation_number":"SJ12638304106","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"112766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 00:30:28","reservation_modified_date_time":"2021-01-29 00:30:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112766","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":"3186714","reservation_id":"106369","confirmation_number":"SJ12681969494","room_confirmation_number":"SJ12623093770","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"112766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 00:30:20","reservation_modified_date_time":"2021-01-29 02:23:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112766","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3186718","reservation_id":"106369","confirmation_number":"SJ12619817711","room_confirmation_number":"SJ12658997057","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"112766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 00:30:12","reservation_modified_date_time":"2021-01-29 02:24:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112766","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":"3204826","reservation_id":"108598","confirmation_number":"SJ12620468288","room_confirmation_number":"SJ12666931534","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:46:19","reservation_modified_date_time":"2021-02-26 01:46:19","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3206471","reservation_id":"108881","confirmation_number":"SJ12696235626","room_confirmation_number":"SJ12692197742","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","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":"115345","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 00:18:46","reservation_modified_date_time":"2021-03-01 00:18:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115345","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":"3207413","reservation_id":"109032","confirmation_number":"SJ12669713520","room_confirmation_number":"SJ12661565286","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"115517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 17:32:25","reservation_modified_date_time":"2021-03-02 22:05:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115491","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":"3215146","reservation_id":"110225","confirmation_number":"SJ12695699378","room_confirmation_number":"SJ12641959346","room_stay_from":"2021-04-30","room_stay_to":"2021-05-10","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"116739","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 20:21:07","reservation_modified_date_time":"2021-03-13 20:21:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116739","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":"3217063","reservation_id":"110484","confirmation_number":"SJ12621201721","room_confirmation_number":"SJ12657273553","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116997","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 02:40:27","reservation_modified_date_time":"2021-03-17 02:40:27","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":"3218378","reservation_id":"110616","confirmation_number":"SJ12657946816","room_confirmation_number":"SJ12673310378","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","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":"117129","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 14:13:45","reservation_modified_date_time":"2021-03-18 21:58:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117129","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":"3219677","reservation_id":"110835","confirmation_number":"SJ12693443800","room_confirmation_number":"SJ12666218882","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","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":"117359","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 21:12:15","reservation_modified_date_time":"2021-03-20 21:21:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117359","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":"3220873","reservation_id":"111050","confirmation_number":"SJ12668424495","room_confirmation_number":"SJ12634835401","room_stay_from":"2021-05-03","room_stay_to":"2021-05-10","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":"117592","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 01:57:07","reservation_modified_date_time":"2021-03-23 01:57:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117592","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":"3226975","reservation_id":"111980","confirmation_number":"SJ12694311854","room_confirmation_number":"SJ12611022747","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"118545","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 14:49:16","reservation_modified_date_time":"2021-04-03 14:49:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118545","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":"3229906","reservation_id":"110482","confirmation_number":"SJ12695614782","room_confirmation_number":"SJ12638617405","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116995","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 02:31:43","reservation_modified_date_time":"2021-04-07 18:28:09","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":"3229947","reservation_id":"108244","confirmation_number":"SJ12650352368","room_confirmation_number":"SJ12646989304","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","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":"114713","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 03:54:12","reservation_modified_date_time":"2021-04-07 19:25:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114713","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":"3237993","reservation_id":"113469","confirmation_number":"SJ12699562333","room_confirmation_number":"SJ12621219875","room_stay_from":"2021-05-08","room_stay_to":"2021-05-10","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":"120063","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 15:50:10","reservation_modified_date_time":"2021-04-20 15:50:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120063","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":"3247629","reservation_id":"114659","confirmation_number":"SJ12637739102","room_confirmation_number":"SJ12686567802","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","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":"121354","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-06 18:29:08","reservation_modified_date_time":"2021-05-06 18:29:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121354","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":"3247694","reservation_id":"114666","confirmation_number":"SJ12652923384","room_confirmation_number":"SJ12694047338","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","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":"119290","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-06 20:14:47","reservation_modified_date_time":"2021-05-06 20:14:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119290","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":"3248284","reservation_id":"111964","confirmation_number":"SJ12635565744","room_confirmation_number":"SJ12674719329","room_stay_from":"2021-05-08","room_stay_to":"2021-05-10","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":"118526","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 03:34:08","reservation_modified_date_time":"2021-05-08 13:03:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118526","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":"3248752","reservation_id":"114678","confirmation_number":"SJ12617819286","room_confirmation_number":"SJ12681939249","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121379","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-06 22:34:12","reservation_modified_date_time":"2021-05-09 13:39:29","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121379","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":"3248756","reservation_id":"114692","confirmation_number":"SJ12654990451","room_confirmation_number":"SJ12658318056","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121396","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-07 03:20:06","reservation_modified_date_time":"2021-05-09 13:40:35","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121396","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3248871","reservation_id":"114818","confirmation_number":"SJ12625880310","room_confirmation_number":"SJ12686578908","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121560","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-09 14:50:11","reservation_modified_date_time":"2021-05-09 16:44:46","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121560","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":"3248897","reservation_id":"114590","confirmation_number":"SJ12625949337","room_confirmation_number":"SJ12695554552","room_stay_from":"2021-05-09","room_stay_to":"2021-05-10","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":"121280","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-05 18:18:30","reservation_modified_date_time":"2021-05-09 17:51:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121280","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":"3219450","reservation_id":"110766","confirmation_number":"SJ12655960819","room_confirmation_number":"SJ12611936199","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","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":"121521","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 21:47:08","reservation_modified_date_time":"2021-03-20 17:27:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117278","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":"3227776","reservation_id":"112071","confirmation_number":"SJ12619350665","room_confirmation_number":"SJ12661848392","room_stay_from":"2021-05-06","room_stay_to":"2021-05-11","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":"118638","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 14:42:40","reservation_modified_date_time":"2021-04-04 14:42:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118638","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":"3229070","reservation_id":"109894","confirmation_number":"SJ12615271485","room_confirmation_number":"SJ12647133042","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 00:15:32","reservation_modified_date_time":"2021-04-06 19:15:08","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":"3230436","reservation_id":"112423","confirmation_number":"SJ12640868598","room_confirmation_number":"SJ12654482186","room_stay_from":"2021-05-07","room_stay_to":"2021-05-11","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":"118996","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 04:22:12","reservation_modified_date_time":"2021-04-08 04:22:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118996","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":"3230575","reservation_id":"112436","confirmation_number":"SJ12677586730","room_confirmation_number":"SJ12686457235","room_stay_from":"2021-05-09","room_stay_to":"2021-05-11","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":"119007","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 13:49:15","reservation_modified_date_time":"2021-04-08 13:49:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119007","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":"3248337","reservation_id":"111970","confirmation_number":"SJ12612189156","room_confirmation_number":"SJ12689687091","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","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":"118532","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 05:21:06","reservation_modified_date_time":"2021-05-08 15:14:13","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118532","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":"3234669","reservation_id":"113023","confirmation_number":"SJ12615227640","room_confirmation_number":"SJ12678640539","room_stay_from":"2021-05-09","room_stay_to":"2021-05-12","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":"119605","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 03:16:39","reservation_modified_date_time":"2021-04-15 03:16:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119605","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":"3237346","reservation_id":"113094","confirmation_number":"SJ12699819764","room_confirmation_number":"SJ12658487927","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","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":"119677","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-16 15:08:37","reservation_modified_date_time":"2021-04-19 14:59:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119677","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":"3241569","reservation_id":"110987","confirmation_number":"SJ12647564518","room_confirmation_number":"SJ12610517571","room_stay_from":"2021-05-09","room_stay_to":"2021-05-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117525","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 18:31:34","reservation_modified_date_time":"2021-04-24 23:21:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3246873","reservation_id":"110988","confirmation_number":"SJ12669719702","room_confirmation_number":"SJ12644241804","room_stay_from":"2021-05-09","room_stay_to":"2021-05-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117526","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 18:36:20","reservation_modified_date_time":"2021-05-04 21:48:20","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248442","reservation_id":"110398","confirmation_number":"SJ12694097655","room_confirmation_number":"SJ12653392901","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","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":"116913","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 00:29:18","reservation_modified_date_time":"2021-05-08 17:26:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116913","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":"3237334","reservation_id":"113011","confirmation_number":"SJ12694592245","room_confirmation_number":"SJ12671187460","room_stay_from":"2021-05-08","room_stay_to":"2021-05-13","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":"119596","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 00:39:08","reservation_modified_date_time":"2021-04-19 14:57:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119596","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":"3248384","reservation_id":"110941","confirmation_number":"SJ12689898697","room_confirmation_number":"SJ12625702045","room_stay_from":"2021-05-09","room_stay_to":"2021-05-13","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":"117479","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 01:58:32","reservation_modified_date_time":"2021-05-08 16:04:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117479","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":"3216734","reservation_id":"109581","confirmation_number":"SJ12659341794","room_confirmation_number":"SJ12638613154","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","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":"116060","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 17:01:47","reservation_modified_date_time":"2021-03-16 19:22:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116060","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":"3219067","reservation_id":"110758","confirmation_number":"SJ12667456995","room_confirmation_number":"SJ12673721071","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","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":"117271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 21:17:09","reservation_modified_date_time":"2021-03-19 21:17:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117271","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":"3229945","reservation_id":"107893","confirmation_number":"SJ12644276854","room_confirmation_number":"SJ12666604318","room_stay_from":"2021-05-07","room_stay_to":"2021-05-14","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":"114354","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 17:34:12","reservation_modified_date_time":"2021-04-07 19:25:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114354","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":"3248761","reservation_id":"110406","confirmation_number":"SJ12641820055","room_confirmation_number":"SJ12639010302","room_stay_from":"2021-05-09","room_stay_to":"2021-05-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116920","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 02:53:26","reservation_modified_date_time":"2021-05-09 13:44:44","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116920","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":"3227769","reservation_id":"108702","confirmation_number":"SJ12649453863","room_confirmation_number":"SJ12674341216","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","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":"115153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 01:46:00","reservation_modified_date_time":"2021-04-04 16:02:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"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":"3228337","reservation_id":"107196","confirmation_number":"SJ12659137670","room_confirmation_number":"SJ12665831114","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","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":"113657","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 01:15:07","reservation_modified_date_time":"2021-04-05 16:34:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113657","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":"3221949","reservation_id":"111216","confirmation_number":"SJ12699827433","room_confirmation_number":"SJ12612511583","room_stay_from":"2021-05-08","room_stay_to":"2021-05-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"365.63","paid_amount":"365.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"102743","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 23:11:28","reservation_modified_date_time":"2021-03-24 23:11:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102743","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248697","reservation_id":"114793","confirmation_number":"SJ12658950628","room_confirmation_number":"SJ12655988711","room_stay_from":"2021-05-31","room_stay_to":"2021-06-02","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":"121528","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-08 19:39:13","reservation_modified_date_time":"2021-05-09 12:13:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121528","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3248706","reservation_id":"114785","confirmation_number":"SJ12695242081","room_confirmation_number":"SJ12659881484","room_stay_from":"2021-07-21","room_stay_to":"2021-07-23","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121513","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-08 18:22:28","reservation_modified_date_time":"2021-05-09 12:18:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121513","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248722","reservation_id":"114730","confirmation_number":"SJ12665573673","room_confirmation_number":"SJ12698672073","room_stay_from":"2021-05-16","room_stay_to":"2021-05-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121445","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-07 20:35:52","reservation_modified_date_time":"2021-05-09 12:23:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121445","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248890","reservation_id":"111307","confirmation_number":"SJ12650445536","room_confirmation_number":"SJ12681288342","room_stay_from":"2021-06-06","room_stay_to":"2021-06-07","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117842","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 01:52:13","reservation_modified_date_time":"2021-05-09 17:22:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117842","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","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3248923","reservation_id":"114831","confirmation_number":"SJ12623864101","room_confirmation_number":"SJ12617416363","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"30.00","paid_amount":"30.00","product_id":"1662","service_quantity":"3","product_name":"Extra Chair or Umbrella","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-09 18:37:34","reservation_modified_date_time":"2021-05-09 18:37:34","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"27.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3249097","reservation_id":"114875","confirmation_number":"SJ12684414638","room_confirmation_number":"SJ12639100131","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-10 02:12:08","reservation_modified_date_time":"2021-05-10 02:12:08","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}