{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-02-12","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":23,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1917","block_room_bookings":[{"confirmation_number":"SJ12665300085","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","bundle_room":"0","product_id":"1917"}],"bundle_block_count":"1267,1268,1291,1711,1307,1308,1271,1272,1262,1263,1309,1310,1311,1312,1304,1305,1260,1261,1269,1270,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12646020251","room_stay_from":"2021-02-06","room_stay_to":"2021-02-13","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12645750718","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12613656934","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12673161587","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12679302973","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12692464207","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12620635961","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12685438410","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12694118173","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12634147475","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12630357587","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12653872140","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12641472790","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12698323672","room_stay_from":"2021-02-11","room_stay_to":"2021-02-16","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12626092954","room_stay_from":"2021-02-12","room_stay_to":"2021-02-20","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12692218566","room_stay_from":"2021-02-12","room_stay_to":"2021-02-20","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3175821","reservation_id":"104968","confirmation_number":"SJ12688721086","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"3","nightly_price":"303.07,303.07,357.07","nightly_discount":"0,0,0","subtotal":"963.21","grand_total":"1083.61","paid_amount":"1083.61","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-3836791672","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":"111339","customer_id":"111339","source_of_creation":"Booking.com","reservation_created_date":"2021-01-07 23:38:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"186.88","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"357.07","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":"3190936","reservation_id":"106801","confirmation_number":"SJ12612276880","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"428.40","nightly_discount":"0","subtotal":"428.40","grand_total":"481.95","paid_amount":"481.95","room_type_id":"320","product_id":"1910","siteminder_id":"BDC-3771775149","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":"113225","customer_id":"113225","source_of_creation":"Booking.com","reservation_created_date":"2021-02-03 03:10:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"81.61","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"428.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":"3192840","reservation_id":"106898","confirmation_number":"SJ12667354189","room_stay_from":"2021-02-06","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"180.87,129.84,129.84,129.84,129.84,146.85,203.55","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1050.63","grand_total":"1181.96","paid_amount":"1181.96","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-2644296789","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":"113804","customer_id":"113804","source_of_creation":"Booking.com","reservation_created_date":"2021-02-04 16:51:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"220.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"203.55","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":"3192999","reservation_id":"107021","confirmation_number":"SJ12693761871","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.88,258.48","nightly_discount":"0,0","subtotal":"423.36","grand_total":"476.28","paid_amount":"476.28","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-2934043322","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":"113459","customer_id":"113459","source_of_creation":"Booking.com","reservation_created_date":"2021-02-06 16:28:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"85.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"258.48","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3194278","reservation_id":"107165","confirmation_number":"SJ12639967694","room_stay_from":"2021-02-08","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.30,146.30,146.30,160.30,251.30","nightly_discount":"0,0,0,0,0","subtotal":"850.50","grand_total":"956.82","paid_amount":"956.82","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2110205826","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":"113620","customer_id":"113620","source_of_creation":"Booking.com","reservation_created_date":"2021-02-08 17:15:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.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":"3195365","reservation_id":"107024","confirmation_number":"SJ12686092641","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"274.63","nightly_discount":"0","subtotal":"274.63","grand_total":"308.96","paid_amount":"308.96","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3003332013","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":"113464","customer_id":"113464","source_of_creation":"Booking.com","reservation_created_date":"2021-02-06 16:54:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"53.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"274.63","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":"3196794","reservation_id":"107453","confirmation_number":"SJ12629003066","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"274.63","nightly_discount":"0","subtotal":"274.63","grand_total":"308.96","paid_amount":"308.96","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3370220250","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":"113908","customer_id":"113908","source_of_creation":"Booking.com","reservation_created_date":"2021-02-12 17:01:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"53.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"274.63","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":"3171540","reservation_id":"104364","confirmation_number":"SJ12659274035","room_stay_from":"2021-02-10","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"212.80,212.80,240.80,240.80","nightly_discount":"0,0,0,0","subtotal":"907.20","grand_total":"1020.60","paid_amount":"1020.60","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3323369891","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":"110714","customer_id":"110714","source_of_creation":"Booking.com","reservation_created_date":"2020-12-29 03:42:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"181.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"240.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":"3181510","reservation_id":"105665","confirmation_number":"SJ12612720905","room_stay_from":"2021-02-10","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,268.80,296.80","nightly_discount":"0,0,0,0","subtotal":"963.20","grand_total":"1083.60","paid_amount":"1083.60","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3384855733","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":"112070","customer_id":"112070","source_of_creation":"Booking.com","reservation_created_date":"2021-01-19 21:31:07","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"191.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"268.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":"3191425","reservation_id":"106882","confirmation_number":"SJ12626839969","room_stay_from":"2021-02-12","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"258.48,287.28","nightly_discount":"0,0","subtotal":"545.76","grand_total":"613.98","paid_amount":"613.98","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3165084651","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":"113314","customer_id":"113314","source_of_creation":"Booking.com","reservation_created_date":"2021-02-04 11:45:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"107.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"258.48","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174790","reservation_id":"104825","confirmation_number":"SJ12641553290","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"232.20,232.20,218.70","nightly_discount":"0,0,0","subtotal":"683.10","grand_total":"768.49","paid_amount":"768.49","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-2269279999","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":"111173","customer_id":"111173","source_of_creation":"Booking.com","reservation_created_date":"2021-01-06 00:33:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"136.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"232.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3175118","reservation_id":"104869","confirmation_number":"SJ12628788655","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.75,216.75,201.75","nightly_discount":"0,0,0","subtotal":"635.25","grand_total":"714.65","paid_amount":"714.65","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-3836757890","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":"111221","customer_id":"111221","source_of_creation":"Booking.com","reservation_created_date":"2021-01-06 16:44:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"216.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3194668","reservation_id":"103347","confirmation_number":"SJ12673829867","room_stay_from":"2021-02-10","room_stay_to":"2021-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,202.30,202.30,188.30,174.30,174.30,174.30,174.30","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1638.70","grand_total":"1843.54","paid_amount":"1843.54","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3204904452","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":"109517","customer_id":"109517","source_of_creation":"Booking.com","reservation_created_date":"2020-12-01 16:14:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"335.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"202.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":"3196973","reservation_id":"105062","confirmation_number":"SJ12664604647","room_stay_from":"2021-02-12","room_stay_to":"2021-02-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,279.30,279.30,251.30,251.30,251.30,251.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1815.10","grand_total":"2041.99","paid_amount":"282.72","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-3820856153","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":"111437","customer_id":"111437","source_of_creation":"Booking.com","reservation_created_date":"2021-01-09 17:28:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"358.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"251.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":"3196768","reservation_id":"107387","confirmation_number":"SJ12687555056","room_stay_from":"2021-02-28","room_stay_to":"2021-03-04","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.18,146.85,146.85,146.85","nightly_discount":"0,0,0,0","subtotal":"581.73","grand_total":"654.45","paid_amount":"0.00","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3868732228","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":"113843","customer_id":"113843","source_of_creation":"Booking.com","reservation_created_date":"2021-02-12 00:19:21","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":"","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":"3197088","reservation_id":"107324","confirmation_number":"SJ12684831793","room_stay_from":"2021-03-10","room_stay_to":"2021-03-15","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"212.3,233.3,261.3,261.3,240.3","nightly_discount":"0,0,0,0,0","subtotal":"1208.50","grand_total":"1359.57","paid_amount":"238.84","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2301763702","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":"113781","customer_id":"113781","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 01:35:19","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"262.55","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":"3180711","reservation_id":"105540","confirmation_number":"SJ12691698165","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,171.75,246.75","nightly_discount":"0,0,0","subtotal":"590.25","grand_total":"664.03","paid_amount":"664.03","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1730783370","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":"111956","customer_id":"111956","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 01:21:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188160","reservation_id":"105440","confirmation_number":"SJ12659028184","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,171.75,246.75","nightly_discount":"0,0,0","subtotal":"590.25","grand_total":"664.03","paid_amount":"664.03","room_type_id":"319","product_id":"1276","siteminder_id":"EXP-1730423338","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":"111847","customer_id":"111847","source_of_creation":"Expedia","reservation_created_date":"2021-01-16 13:21:11","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":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3193387","reservation_id":"107058","confirmation_number":"SJ12667722143","room_stay_from":"2021-02-07","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"131.04,131.04,131.04,131.04,142.24,215.04","nightly_discount":"0,0,0,0,0,0","subtotal":"881.44","grand_total":"991.62","paid_amount":"991.62","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1735890176","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":"113504","customer_id":"113504","source_of_creation":"Expedia","reservation_created_date":"2021-02-06 23:15:07","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":"126","group_rooms":null,"currentDayPrice":"215.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3195668","reservation_id":"104827","confirmation_number":"SJ12619940287","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.60,173.60","nightly_discount":"0,0","subtotal":"323.20","grand_total":"363.60","paid_amount":"363.60","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1727832398","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":"111174","customer_id":"111174","source_of_creation":"Expedia","reservation_created_date":"2021-01-06 00:46:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","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":"173.60","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":"3195688","reservation_id":"107317","confirmation_number":"SJ12688254046","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.72","nightly_discount":"0","subtotal":"223.72","grand_total":"251.69","paid_amount":"251.69","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1737026135","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":"113776","customer_id":"113776","source_of_creation":"Expedia","reservation_created_date":"2021-02-11 00:57:06","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.72","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":"3196048","reservation_id":"107266","confirmation_number":"SJ12699428753","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.56,229.76","nightly_discount":"0.00,0.00","subtotal":"376.32","grand_total":"423.36","paid_amount":"423.36","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1736787757","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":"113733","customer_id":"113733","source_of_creation":"Expedia","reservation_created_date":"2021-02-10 04:20:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"229.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3177892","reservation_id":"105212","confirmation_number":"SJ12643311409","room_stay_from":"2021-02-10","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"139.44,139.44,184.24,206.64","nightly_discount":"0,0,0,0","subtotal":"669.76","grand_total":"753.48","paid_amount":"753.48","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1729305938","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":"111595","customer_id":"111595","source_of_creation":"Expedia","reservation_created_date":"2021-01-12 03:11:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.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":"3194775","reservation_id":"106535","confirmation_number":"SJ12650962281","room_stay_from":"2021-02-11","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,246.75,276.75","nightly_discount":"0,0,0","subtotal":"695.25","grand_total":"782.15","paid_amount":"782.15","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1734109027","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":"112952","customer_id":"112952","source_of_creation":"Expedia","reservation_created_date":"2021-01-31 06:16:21","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3179039","reservation_id":"105359","confirmation_number":"SJ12665602754","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.00,318.00,318.00","nightly_discount":"0,0,0","subtotal":"924.00","grand_total":"1039.50","paid_amount":"324.00","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1730075987","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":"111750","customer_id":"111750","source_of_creation":"Expedia","reservation_created_date":"2021-01-15 02:51:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"288.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185514","reservation_id":"104749","confirmation_number":"SJ12622421694","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"251.44,273.84,273.84,262.64","nightly_discount":"0,0,0,0","subtotal":"1061.76","grand_total":"1194.48","paid_amount":"1194.48","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1727603021","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":"111102","customer_id":"111102","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 01:46:12","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":"273.84","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":"3196313","reservation_id":"106879","confirmation_number":"SJ12651213705","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.40,254.40,242.40","nightly_discount":"0,0,0","subtotal":"727.20","grand_total":"818.10","paid_amount":"818.10","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1735177042","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":"113311","customer_id":"113311","source_of_creation":"Expedia","reservation_created_date":"2021-02-04 06:45:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"230.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3196892","reservation_id":"104384","confirmation_number":"SJ12681577314","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"254.25,254.25,239.25","nightly_discount":"0.00,0.00,0.00","subtotal":"747.75","grand_total":"841.22","paid_amount":"841.22","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1726108003","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":"110740","customer_id":"110740","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 19:21:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"254.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":"3196950","reservation_id":"104389","confirmation_number":"SJ12685440999","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"204.25,204.25,189.25","nightly_discount":"0.00,0.00,0.00","subtotal":"597.75","grand_total":"672.47","paid_amount":"672.47","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1726114806","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":"110745","customer_id":"110745","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 19:51:23","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"204.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":"3176771","reservation_id":"105076","confirmation_number":"SJ12680398413","room_stay_from":"2021-02-10","room_stay_to":"2021-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.24,156.24,201.04,223.44,223.44,201.04","nightly_discount":"0,0,0,0,0,0","subtotal":"1161.44","grand_total":"1306.62","paid_amount":"1306.62","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1728737440","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":"111450","customer_id":"111450","source_of_creation":"Expedia","reservation_created_date":"2021-01-09 19:21:09","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3196298","reservation_id":"102037","confirmation_number":"SJ12657555655","room_stay_from":"2021-02-11","room_stay_to":"2021-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.56,268.16,268.16,210.56,210.56,191.36","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1359.36","grand_total":"1529.28","paid_amount":"1529.28","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1711824190","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":"108156","customer_id":"108156","source_of_creation":"Expedia","reservation_created_date":"2020-10-28 15:53:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"268.16","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":"3153911","reservation_id":"102511","confirmation_number":"SJ12696497632","room_stay_from":"2021-02-12","room_stay_to":"2021-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.96,280.96,268.16,255.36,255.36,255.36,255.36,280.96","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2132.48","grand_total":"2399.04","paid_amount":"2399.04","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1715171854","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":"108675","customer_id":"108675","source_of_creation":"Expedia","reservation_created_date":"2020-11-11 01:23:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"280.96","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3190762","reservation_id":"104817","confirmation_number":"SJ12610956809","room_stay_from":"2021-02-12","room_stay_to":"2021-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.77,155.77,144.99,134.21","nightly_discount":"0,0,0,0","subtotal":"590.74","grand_total":"664.59","paid_amount":"664.59","room_type_id":"413","product_id":"1265","siteminder_id":"GAM-R2270329080","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":"111163","customer_id":"111163","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-05 22:56:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"155.77","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3185505","reservation_id":"105830","confirmation_number":"SJ12693039952","room_stay_from":"2021-02-06","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"258.64,258.64,258.64,258.64,258.64,258.64,258.64","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1810.48","grand_total":"2096.38","paid_amount":"2096.38","room_type_id":"319","product_id":"1314","siteminder_id":"ABB-HMYHMR5YHQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1810.48","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112237","customer_id":"112237","source_of_creation":"Airbnb","reservation_created_date":"2021-01-22 02:54:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"53.25","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"258.64","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"}]},{"room_stay_id":"3196264","reservation_id":"104324","confirmation_number":"SJ12677350002","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"263.61","nightly_discount":"0.00","subtotal":"263.61","grand_total":"305.49","paid_amount":"305.49","room_type_id":"319","product_id":"1277","siteminder_id":"ABB-HMSB5SNESS","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"265.20","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110679","customer_id":"110679","source_of_creation":"Airbnb","reservation_created_date":"2020-12-28 02:39:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"7.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"263.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3195274","reservation_id":"105436","confirmation_number":"SJ12656067872","room_stay_from":"2021-02-10","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"292.74,292.74,292.74,285.71","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1163.93","grand_total":"1348.85","paid_amount":"1348.85","room_type_id":"412","product_id":"1921","siteminder_id":"ABB-HM8RPNR5KT","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1170.96","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111843","customer_id":"111843","source_of_creation":"Airbnb","reservation_created_date":"2021-01-16 04:37:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"34.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"292.74","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":"3195260","reservation_id":"104529","confirmation_number":"SJ12675288265","room_stay_from":"2021-02-10","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.84,246.84,246.84,246.84,239.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1226.79","grand_total":"1421.69","paid_amount":"1421.69","room_type_id":"319","product_id":"1274","siteminder_id":"ABB-HMXAT9D4K8","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1234.20","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110876","customer_id":"110876","source_of_creation":"Airbnb","reservation_created_date":"2021-01-01 18:47:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"36.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.84","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":"3195839","reservation_id":"104694","confirmation_number":"SJ12623856121","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.40,251.43,251.43,251.43","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"999.69","grand_total":"1158.50","paid_amount":"1158.50","room_type_id":"319","product_id":"1288","siteminder_id":"ABB-HMHFJFMA5N","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1005.72","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111047","customer_id":"111047","source_of_creation":"Airbnb","reservation_created_date":"2021-01-04 13:35:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"29.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3190782","reservation_id":"106767","confirmation_number":"SJ12623460766","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"1","nightly_price":"322.15,407.15","nightly_discount":"0.00,0.00","subtotal":"729.30","grand_total":"820.47","paid_amount":"820.47","room_type_id":"320","product_id":"1321","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":"113189","customer_id":"113189","source_of_creation":"FE","reservation_created_date":"2021-02-02 21:35:54","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1262,1263","currentDayPrice":"407.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":"3191248","reservation_id":"106851","confirmation_number":"SJ12662916105","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65","nightly_discount":"0.00","subtotal":"279.65","grand_total":"314.60","paid_amount":"314.60","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112311","customer_id":"112311","source_of_creation":"FE","reservation_created_date":"2021-02-03 21:40:26","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"279.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3195268","reservation_id":"106611","confirmation_number":"SJ12656496839","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,194.25,269.25","nightly_discount":"0.00,0.00,0.00","subtotal":"635.25","grand_total":"714.65","paid_amount":"714.65","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113015","customer_id":"113015","source_of_creation":"FE","reservation_created_date":"2021-02-01 14:10:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3195287","reservation_id":"105558","confirmation_number":"SJ12695332301","room_stay_from":"2021-02-11","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,269.25,299.25","nightly_discount":"0.00,0.00,0.00","subtotal":"762.75","grand_total":"858.10","paid_amount":"858.10","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111978","customer_id":"111978","source_of_creation":"FE","reservation_created_date":"2021-01-18 16:13:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197060","reservation_id":"104600","confirmation_number":"SJ12639792755","room_stay_from":"2021-07-11","room_stay_to":"2021-07-16","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"261.75,261.75,261.75,261.75,291.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1338.75","grand_total":"1506.10","paid_amount":"294.47","room_type_id":"320","product_id":"1321","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":"110949","customer_id":"110949","source_of_creation":"FE","reservation_created_date":"2021-01-02 20:43:59","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3188154","reservation_id":"106520","confirmation_number":"SJ12634167043","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"275.00","nightly_discount":"0.00","subtotal":"275.00","grand_total":"309.38","paid_amount":"309.38","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112929","customer_id":"112929","source_of_creation":"PMS","reservation_created_date":"2021-01-30 22:47:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"275.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":"3175062","reservation_id":"104867","confirmation_number":"SJ12667940435","room_stay_from":"2021-02-12","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.65,220.65","nightly_discount":"0.00,0.00","subtotal":"441.30","grand_total":"496.47","paid_amount":"496.47","room_type_id":"413","product_id":"1267","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":"111220","customer_id":"111220","source_of_creation":"PMS","reservation_created_date":"2021-01-06 16:40:49","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"220.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3195285","reservation_id":"104871","confirmation_number":"SJ12611298980","room_stay_from":"2021-02-12","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.50,186.50","nightly_discount":"0.00,0.00","subtotal":"373.00","grand_total":"419.63","paid_amount":"419.63","room_type_id":"319","product_id":"1286","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":"111222","customer_id":"111222","source_of_creation":"PMS","reservation_created_date":"2021-01-06 17:11:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"186.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":"3196309","reservation_id":"105385","confirmation_number":"SJ12655654118","room_stay_from":"2021-02-12","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"275.15,305.15","nightly_discount":"0.00,0.00","subtotal":"580.30","grand_total":"652.84","paid_amount":"652.84","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111783","customer_id":"111783","source_of_creation":"PMS","reservation_created_date":"2021-01-15 19:50:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"275.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":"3189341","reservation_id":"106562","confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"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,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,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,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","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":"101703","customer_id":"101703","source_of_creation":"PMS","reservation_created_date":"2021-01-31 18:54:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3146778","reservation_id":"98513","confirmation_number":"SJ12631556581","room_stay_from":"2021-02-08","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"570.00","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-02 22:19:48","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146780","reservation_id":"98512","confirmation_number":"SJ12634555956","room_stay_from":"2021-02-06","room_stay_to":"2021-02-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"794.99","grand_total":"794.99","paid_amount":"196.88","room_type_id":"413","product_id":"1268","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":"2020-08-02 22:18:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.57","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":"3146830","reservation_id":"100700","confirmation_number":"SJ12668626813","room_stay_from":"2021-02-09","room_stay_to":"2021-02-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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":"2020-09-22 00:28:50","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192041","reservation_id":"104924","confirmation_number":"SJ12663174632","room_stay_from":"2021-02-07","room_stay_to":"2021-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,113.33,113.33,113.34","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"910.00","grand_total":"910.00","paid_amount":"225.00","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-07 01:19:48","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.33","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":"3146816","reservation_id":"99529","confirmation_number":"SJ12650735969","room_stay_from":"2021-02-11","room_stay_to":"2021-02-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"0.00","room_type_id":"413","product_id":"1269","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":"2020-08-26 00:49:44","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3196969","reservation_id":"104916","confirmation_number":"SJ12681820157","room_stay_from":"2021-02-12","room_stay_to":"2021-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"795.00","grand_total":"795.00","paid_amount":"196.88","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-07 00:59: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","currentDayPrice":"113.57","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":"3196798","reservation_id":"107457","confirmation_number":"SJ12661443256","room_stay_from":"2021-02-05","room_stay_to":"2021-02-08","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"0.00","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-12 18:14:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"Reservation created for complete past date","deltaChange":"339.99","currentDayPrice":0,"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":"3190780","reservation_id":"106767","confirmation_number":"SJ12619359520","room_confirmation_number":"SJ12623460766","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","room_stay_status":"Active","nightly_price":"50.00,50.00","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"113189","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-02-02 21:35:54","reservation_modified_date_time":"2021-02-02 21:35:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113189","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190993","reservation_id":"104389","confirmation_number":"SJ12671209721","room_confirmation_number":"SJ12685440999","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"110745","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-03 14:29:07","reservation_modified_date_time":"2021-02-03 14:29:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110745","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3146777","reservation_id":"98513","confirmation_number":"SJ12628787094","room_confirmation_number":"SJ12631556581","room_stay_from":"2021-02-08","room_stay_to":"2021-02-13","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":"104541","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-02 22:19:48","reservation_modified_date_time":"2020-10-17 22:06:32","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":"3146779","reservation_id":"98512","confirmation_number":"SJ12653038330","room_confirmation_number":"SJ12634555956","room_stay_from":"2021-02-06","room_stay_to":"2021-02-13","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":"104540","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-02 22:18:15","reservation_modified_date_time":"2020-10-17 22:06:32","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":"3175822","reservation_id":"104968","confirmation_number":"SJ12676662509","room_confirmation_number":"SJ12688721086","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"111339","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 23:38:09","reservation_modified_date_time":"2021-01-07 23:38:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111339","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":"3180712","reservation_id":"105540","confirmation_number":"SJ12630922748","room_confirmation_number":"SJ12691698165","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"111956","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 01:21:09","reservation_modified_date_time":"2021-01-18 01:21:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111956","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":"3185506","reservation_id":"105830","confirmation_number":"SJ12638221547","room_confirmation_number":"SJ12693039952","room_stay_from":"2021-02-06","room_stay_to":"2021-02-13","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":"112237","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-22 02:54:11","reservation_modified_date_time":"2021-01-27 15:38:11","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112237","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","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":"3188155","reservation_id":"106520","confirmation_number":"SJ12617290806","room_confirmation_number":"SJ12634167043","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","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":"112929","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 22:47:15","reservation_modified_date_time":"2021-01-30 22:47:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112929","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":"3188161","reservation_id":"105440","confirmation_number":"SJ12690761778","room_confirmation_number":"SJ12659028184","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"111847","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 13:21:11","reservation_modified_date_time":"2021-01-30 22:52:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111847","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":"3190781","reservation_id":"106767","confirmation_number":"SJ12684061327","room_confirmation_number":"SJ12623460766","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","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":"113189","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:35:54","reservation_modified_date_time":"2021-02-02 21:35:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113189","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":"3190937","reservation_id":"106801","confirmation_number":"SJ12652088674","room_confirmation_number":"SJ12612276880","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","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":"113225","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 03:10:13","reservation_modified_date_time":"2021-02-03 03:10:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113225","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":"3191249","reservation_id":"106851","confirmation_number":"SJ12676326001","room_confirmation_number":"SJ12662916105","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"113276","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 21:40:26","reservation_modified_date_time":"2021-02-03 21:40:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112311","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":"3192841","reservation_id":"106898","confirmation_number":"SJ12689636468","room_confirmation_number":"SJ12667354189","room_stay_from":"2021-02-06","room_stay_to":"2021-02-13","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":"113804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 16:51:07","reservation_modified_date_time":"2021-02-06 14:12:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113804","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":"3193000","reservation_id":"107021","confirmation_number":"SJ12643576344","room_confirmation_number":"SJ12693761871","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","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":"113459","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-06 16:28:12","reservation_modified_date_time":"2021-02-06 16:28:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113459","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":"3193388","reservation_id":"107058","confirmation_number":"SJ12615066692","room_confirmation_number":"SJ12667722143","room_stay_from":"2021-02-07","room_stay_to":"2021-02-13","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":"113504","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-06 23:15:07","reservation_modified_date_time":"2021-02-07 15:53:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113504","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":"3194277","reservation_id":"107165","confirmation_number":"SJ12696668774","room_confirmation_number":"SJ12639967694","room_stay_from":"2021-02-08","room_stay_to":"2021-02-13","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":"113620","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-08 17:15:46","reservation_modified_date_time":"2021-02-08 19:08:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113620","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":"3195269","reservation_id":"106611","confirmation_number":"SJ12615138333","room_confirmation_number":"SJ12656496839","room_stay_from":"2021-02-10","room_stay_to":"2021-02-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"113015","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 14:10:51","reservation_modified_date_time":"2021-02-10 13:56:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113015","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":"3195366","reservation_id":"107024","confirmation_number":"SJ12620321375","room_confirmation_number":"SJ12686092641","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","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":"113464","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-06 16:54:12","reservation_modified_date_time":"2021-02-10 15:40:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113464","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":"3195669","reservation_id":"104827","confirmation_number":"SJ12683041725","room_confirmation_number":"SJ12619940287","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","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":"111174","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 00:46:12","reservation_modified_date_time":"2021-02-10 23:55:02","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111174","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":"3195689","reservation_id":"107317","confirmation_number":"SJ12625841977","room_confirmation_number":"SJ12688254046","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","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":"113776","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 00:57:06","reservation_modified_date_time":"2021-02-11 00:57:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113776","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":"3196049","reservation_id":"107266","confirmation_number":"SJ12635403478","room_confirmation_number":"SJ12699428753","room_stay_from":"2021-02-11","room_stay_to":"2021-02-13","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":"113733","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-10 04:20:09","reservation_modified_date_time":"2021-02-11 22:03:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113733","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":"3196265","reservation_id":"104324","confirmation_number":"SJ12673024402","room_confirmation_number":"SJ12677350002","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","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":"110679","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-28 02:39:10","reservation_modified_date_time":"2021-02-12 13:17:39","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110679","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":"3196795","reservation_id":"107453","confirmation_number":"SJ12641709923","room_confirmation_number":"SJ12629003066","room_stay_from":"2021-02-12","room_stay_to":"2021-02-13","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":"113908","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 17:01:10","reservation_modified_date_time":"2021-02-12 18:13:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113908","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":"3146829","reservation_id":"100700","confirmation_number":"SJ12689802830","room_confirmation_number":"SJ12668626813","room_stay_from":"2021-02-09","room_stay_to":"2021-02-14","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":"106725","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-22 00:28:50","reservation_modified_date_time":"2020-10-17 22:06:32","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":"3171541","reservation_id":"104364","confirmation_number":"SJ12640479535","room_confirmation_number":"SJ12659274035","room_stay_from":"2021-02-10","room_stay_to":"2021-02-14","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":"110714","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 03:42:13","reservation_modified_date_time":"2020-12-29 15:08:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110714","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":"3175063","reservation_id":"104867","confirmation_number":"SJ12619871078","room_confirmation_number":"SJ12667940435","room_stay_from":"2021-02-12","room_stay_to":"2021-02-14","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":"111220","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 16:40:49","reservation_modified_date_time":"2021-01-06 16:40:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111220","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":"3177891","reservation_id":"105212","confirmation_number":"SJ12650285246","room_confirmation_number":"SJ12643311409","room_stay_from":"2021-02-10","room_stay_to":"2021-02-14","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":"111595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-12 03:11:14","reservation_modified_date_time":"2021-01-12 13:04:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111595","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":"3181511","reservation_id":"105665","confirmation_number":"SJ12625513423","room_confirmation_number":"SJ12612720905","room_stay_from":"2021-02-10","room_stay_to":"2021-02-14","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":"112070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 21:31:07","reservation_modified_date_time":"2021-01-19 21:31:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112070","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":"3191426","reservation_id":"106882","confirmation_number":"SJ12633496083","room_confirmation_number":"SJ12626839969","room_stay_from":"2021-02-12","room_stay_to":"2021-02-14","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":"113314","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 11:45:11","reservation_modified_date_time":"2021-02-04 11:45:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113314","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":"3194776","reservation_id":"106535","confirmation_number":"SJ12646675965","room_confirmation_number":"SJ12650962281","room_stay_from":"2021-02-11","room_stay_to":"2021-02-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"112952","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 06:16:21","reservation_modified_date_time":"2021-02-09 16:54:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112952","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":"3195275","reservation_id":"105436","confirmation_number":"SJ12621853469","room_confirmation_number":"SJ12656067872","room_stay_from":"2021-02-10","room_stay_to":"2021-02-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111843","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 04:37:09","reservation_modified_date_time":"2021-02-10 14:09:51","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111843","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":"3195286","reservation_id":"104871","confirmation_number":"SJ12648261697","room_confirmation_number":"SJ12611298980","room_stay_from":"2021-02-12","room_stay_to":"2021-02-14","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":"111222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 17:11:49","reservation_modified_date_time":"2021-02-10 14:18:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111222","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":"3195288","reservation_id":"105558","confirmation_number":"SJ12625490186","room_confirmation_number":"SJ12695332301","room_stay_from":"2021-02-11","room_stay_to":"2021-02-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"111978","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 16:13:53","reservation_modified_date_time":"2021-02-10 14:19:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111978","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":"3196310","reservation_id":"105385","confirmation_number":"SJ12634801987","room_confirmation_number":"SJ12655654118","room_stay_from":"2021-02-12","room_stay_to":"2021-02-14","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":"111783","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 19:50:09","reservation_modified_date_time":"2021-02-12 15:44:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111783","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":"3174791","reservation_id":"104825","confirmation_number":"SJ12626177762","room_confirmation_number":"SJ12641553290","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","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":"111173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 00:33:07","reservation_modified_date_time":"2021-01-06 00:33:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111173","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":"3175117","reservation_id":"104869","confirmation_number":"SJ12640129589","room_confirmation_number":"SJ12628788655","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","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":"111221","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 16:44:27","reservation_modified_date_time":"2021-01-06 17:40:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111221","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":"3179040","reservation_id":"105359","confirmation_number":"SJ12613121233","room_confirmation_number":"SJ12665602754","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","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":"111750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 02:51:08","reservation_modified_date_time":"2021-01-15 02:51:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111750","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":"3185517","reservation_id":"104749","confirmation_number":"SJ12699904679","room_confirmation_number":"SJ12622421694","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","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":"111102","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 01:46:12","reservation_modified_date_time":"2021-01-27 15:39:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111102","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":"3192042","reservation_id":"104924","confirmation_number":"SJ12666545212","room_confirmation_number":"SJ12663174632","room_stay_from":"2021-02-07","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"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","subtotal":"200.00","grand_total":"225.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111281","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 01:19:48","reservation_modified_date_time":"2021-02-04 23:29: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":"3195261","reservation_id":"104529","confirmation_number":"SJ12662427710","room_confirmation_number":"SJ12675288265","room_stay_from":"2021-02-10","room_stay_to":"2021-02-15","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":"110876","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 18:47:07","reservation_modified_date_time":"2021-02-10 13:53:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110876","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":"3195840","reservation_id":"104694","confirmation_number":"SJ12653328895","room_confirmation_number":"SJ12623856121","room_stay_from":"2021-02-11","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-04 13:35:10","reservation_modified_date_time":"2021-02-11 14:36:34","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111047","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":"3196314","reservation_id":"106879","confirmation_number":"SJ12682522441","room_confirmation_number":"SJ12651213705","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","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":"113311","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 06:45:06","reservation_modified_date_time":"2021-02-12 15:45:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113311","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":"3196894","reservation_id":"104384","confirmation_number":"SJ12684557788","room_confirmation_number":"SJ12681577314","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"110740","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 19:21:10","reservation_modified_date_time":"2021-02-12 20:53:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110740","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3196951","reservation_id":"104389","confirmation_number":"SJ12677729522","room_confirmation_number":"SJ12685440999","room_stay_from":"2021-02-12","room_stay_to":"2021-02-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"25.00,25.00,0.00","subtotal":"75.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"110745","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 19:51:23","reservation_modified_date_time":"2021-02-12 21:37:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110745","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146815","reservation_id":"99529","confirmation_number":"SJ12629660027","room_confirmation_number":"SJ12650735969","room_stay_from":"2021-02-11","room_stay_to":"2021-02-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-26 00:49:44","reservation_modified_date_time":"2020-10-17 22:06:32","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":"3176772","reservation_id":"105076","confirmation_number":"SJ12674751634","room_confirmation_number":"SJ12680398413","room_stay_from":"2021-02-10","room_stay_to":"2021-02-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"111450","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 19:21:09","reservation_modified_date_time":"2021-01-09 19:21:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111450","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":"3190765","reservation_id":"104817","confirmation_number":"SJ12652253817","room_confirmation_number":"SJ12610956809","room_stay_from":"2021-02-12","room_stay_to":"2021-02-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 22:56:11","reservation_modified_date_time":"2021-02-02 22:54:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111163","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":"3196299","reservation_id":"102037","confirmation_number":"SJ12635837150","room_confirmation_number":"SJ12657555655","room_stay_from":"2021-02-11","room_stay_to":"2021-02-17","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"108156","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 15:53:08","reservation_modified_date_time":"2021-02-12 15:10:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108156","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":"3194672","reservation_id":"103347","confirmation_number":"SJ12661236710","room_confirmation_number":"SJ12673829867","room_stay_from":"2021-02-10","room_stay_to":"2021-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"109517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-01 16:14:10","reservation_modified_date_time":"2021-02-09 14:47:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109517","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":"3196970","reservation_id":"104916","confirmation_number":"SJ12610341990","room_confirmation_number":"SJ12681820157","room_stay_from":"2021-02-12","room_stay_to":"2021-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 00:59:32","reservation_modified_date_time":"2021-02-12 22:00:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3196974","reservation_id":"105062","confirmation_number":"SJ12646977340","room_confirmation_number":"SJ12664604647","room_stay_from":"2021-02-12","room_stay_to":"2021-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111437","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 17:28:12","reservation_modified_date_time":"2021-02-12 22:00:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111437","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":"3153912","reservation_id":"102511","confirmation_number":"SJ12679640377","room_confirmation_number":"SJ12696497632","room_stay_from":"2021-02-12","room_stay_to":"2021-02-20","room_stay_status":"Active","nightly_price":"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","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108675","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-11 01:23:10","reservation_modified_date_time":"2020-11-11 01:23:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108675","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":"3189342","reservation_id":"106562","confirmation_number":"SJ12674501286","room_confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"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,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,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,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,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,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,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,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,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:54:06","reservation_modified_date_time":"2021-02-01 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101703","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3196767","reservation_id":"107387","confirmation_number":"SJ12622348080","room_confirmation_number":"SJ12687555056","room_stay_from":"2021-02-28","room_stay_to":"2021-03-04","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113843","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 00:19:21","reservation_modified_date_time":"2021-02-12 18:02:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113843","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":"3196799","reservation_id":"107457","confirmation_number":"SJ12684464614","room_confirmation_number":"SJ12661443256","room_stay_from":"2021-02-05","room_stay_to":"2021-02-08","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":"113912","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 18:14:14","reservation_modified_date_time":"2021-02-12 18:14:14","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"Reservation created for complete past date","deltaChange":"75.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":"3197063","reservation_id":"104600","confirmation_number":"SJ12694814357","room_confirmation_number":"SJ12639792755","room_stay_from":"2021-07-11","room_stay_to":"2021-07-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110949","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 20:43:59","reservation_modified_date_time":"2021-02-12 23:44:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110949","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197090","reservation_id":"107324","confirmation_number":"SJ12658427989","room_confirmation_number":"SJ12684831793","room_stay_from":"2021-03-10","room_stay_to":"2021-03-15","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113781","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 01:35:19","reservation_modified_date_time":"2021-02-13 01:16:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113781","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3196250","reservation_id":"107425","confirmation_number":"SJ12654188419","room_confirmation_number":"SJ12611626239","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"2.00","paid_amount":"2.00","product_id":"1667","service_quantity":"1","product_name":"Koozie","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-12 12:06:31","reservation_modified_date_time":"2021-02-12 12:06:31","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":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3196715","reservation_id":"107452","confirmation_number":"SJ12640737393","room_confirmation_number":"SJ12648834940","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"5.00","paid_amount":"5.00","product_id":"1660","service_quantity":"2","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-12 17:00:27","reservation_modified_date_time":"2021-02-12 17:00:27","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":"4.66","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3197111","reservation_id":"107499","confirmation_number":"SJ12651319610","room_confirmation_number":"SJ12656345583","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":"1659","service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-13 02:28:20","reservation_modified_date_time":"2021-02-13 02:28:20","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.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3196904","reservation_id":"102037","confirmation_number":"SJ12629756909","room_confirmation_number":"SJ12657555655","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"75.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-12 21:12:20","reservation_modified_date_time":"2021-02-12 21:12:20","customer_id":"108156","parentCustTravId":"108156","customer_traveller_id":"108156","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-02-11","sub_hotel_id":"126","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}