{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-10-02","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":12,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1281","block_room_bookings":[{"confirmation_number":"SJ12621027210","room_stay_from":"2021-10-02","room_stay_to":"2021-10-04","bundle_room":"0","product_id":"1281"}],"bundle_block_count":"1260,1261,1291,1711,1309,1310,1267,1268,1269,1270,1271,1272,1262,1263,1311,1312,1304,1305,1307,1308,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12693039615","room_stay_from":"2021-10-01","room_stay_to":"2021-10-04","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12655398867","room_stay_from":"2021-10-01","room_stay_to":"2021-10-06","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12613657902","room_stay_from":"2021-09-29","room_stay_to":"2021-10-04","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12677976331","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12622425121","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12656001539","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12660524166","room_stay_from":"2021-09-30","room_stay_to":"2021-10-03","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12693354958","room_stay_from":"2021-09-30","room_stay_to":"2021-10-03","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12633643229","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12672575077","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12672276516","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12689518021","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12656387023","room_stay_from":"2021-09-29","room_stay_to":"2021-10-03","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12680746972","room_stay_from":"2021-09-29","room_stay_to":"2021-10-03","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12612853739","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12687155413","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3290544","reservation_id":"120051","confirmation_number":"SJ12679238805","room_stay_from":"2021-09-30","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"941.50","grand_total":"1059.19","paid_amount":"1059.19","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-3898178341","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":"127291","customer_id":"127291","source_of_creation":"Booking.com","reservation_created_date":"2021-07-25 17:59:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"191.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3292545","reservation_id":"120400","confirmation_number":"SJ12643388883","room_stay_from":"2021-10-02","room_stay_to":"2021-10-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,181.30,181.30,181.30","nightly_discount":"0,0,0,0","subtotal":"795.20","grand_total":"894.60","paid_amount":"894.60","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2152076869","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":"127679","customer_id":"127679","source_of_creation":"Booking.com","reservation_created_date":"2021-07-30 14:41:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"161.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"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":"5178751","reservation_id":"121708","confirmation_number":"SJ12645747305","room_stay_from":"2021-09-30","room_stay_to":"2021-10-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.50,186.54,186.54,129.84,129.84,129.84,129.84,129.84","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1140.78","grand_total":"1283.38","paid_amount":"1283.38","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2819451398","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":"129251","customer_id":"129251","source_of_creation":"Booking.com","reservation_created_date":"2021-08-22 19:10:19","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":"186.54","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":"5178753","reservation_id":"121708","confirmation_number":"SJ12694032522","room_stay_from":"2021-09-30","room_stay_to":"2021-10-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.68,200.72,200.72,144.02,144.02,144.02,144.02,144.02","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1254.22","grand_total":"1411.00","paid_amount":"1411.00","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-2819451398","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":"129251","customer_id":"129251","source_of_creation":"Booking.com","reservation_created_date":"2021-08-22 19:10:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"503.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"200.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":"5304872","reservation_id":"117538","confirmation_number":"SJ12697700220","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.87,156.87,112.77,112.77","nightly_discount":"0,0,0,0","subtotal":"539.28","grand_total":"606.69","paid_amount":"606.69","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-2341626868","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":"124499","customer_id":"124499","source_of_creation":"Booking.com","reservation_created_date":"2021-06-18 15:39:20","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"156.87","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":"5311113","reservation_id":"120256","confirmation_number":"SJ12692839070","room_stay_from":"2021-09-30","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"299.25,359.25,359.25","nightly_discount":"0,0,0","subtotal":"1017.75","grand_total":"1144.97","paid_amount":"1144.97","room_type_id":"320","product_id":"1321","siteminder_id":"BDC-2406718540","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":"127521","customer_id":"127521","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 10:53:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"196.69","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"359.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5312592","reservation_id":"118981","confirmation_number":"SJ12677956076","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"339.15","nightly_discount":"0","subtotal":"339.15","grand_total":"381.55","paid_amount":"381.55","room_type_id":"320","product_id":"1329","siteminder_id":"BDC-3833311131","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":"126082","customer_id":"126082","source_of_creation":"Booking.com","reservation_created_date":"2021-07-09 05:35:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"65.55","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"339.15","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":"5315161","reservation_id":"122884","confirmation_number":"SJ12619360704","room_stay_from":"2021-09-30","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"156.3,240.3,240.3,170.3","nightly_discount":"0,0,0,0","subtotal":"807.20","grand_total":"908.10","paid_amount":"908.10","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3146695274","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130549","customer_id":"130549","source_of_creation":"Booking.com","reservation_created_date":"2021-09-11 17:45:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"362.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"240.3","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":"5315167","reservation_id":"122884","confirmation_number":"SJ12678963631","room_stay_from":"2021-09-30","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"156.3,240.3,240.3,170.3","nightly_discount":"0,0,0,0","subtotal":"807.20","grand_total":"908.10","paid_amount":"908.10","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3146695274","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":"130549","customer_id":"130549","source_of_creation":"Booking.com","reservation_created_date":"2021-09-11 17:45:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"240.3","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":"5318759","reservation_id":"114195","confirmation_number":"SJ12664164118","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"141.18,141.18,101.49,101.49","nightly_discount":"0,0,0,0","subtotal":"485.34","grand_total":"546.01","paid_amount":"546.01","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-3539320998","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":"120836","customer_id":"120836","source_of_creation":"Booking.com","reservation_created_date":"2021-04-30 13:14:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"105.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"141.18","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":"5322052","reservation_id":"123432","confirmation_number":"SJ12695605090","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"153.40,153.40","nightly_discount":"0.00,0.00","subtotal":"306.80","grand_total":"345.15","paid_amount":"345.15","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3112123046","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131394","customer_id":"131394","source_of_creation":"Booking.com","reservation_created_date":"2021-09-21 20:16:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"64.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"50.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":"5322117","reservation_id":"122450","confirmation_number":"SJ12634007658","room_stay_from":"2021-09-27","room_stay_to":"2021-09-28","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"645.30","nightly_discount":"0.00","subtotal":"645.30","grand_total":"725.97","paid_amount":"725.97","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-2786425672","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":"130046","customer_id":"130046","source_of_creation":"Booking.com","reservation_created_date":"2021-09-03 01:26:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"93.33","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"524.47","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":"3305102","reservation_id":"121423","confirmation_number":"SJ12687633291","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1818078453","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":"128895","customer_id":"128895","source_of_creation":"Expedia","reservation_created_date":"2021-08-18 21:13:12","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":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305130","reservation_id":"121424","confirmation_number":"SJ12635711491","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1818078456","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":"128896","customer_id":"128896","source_of_creation":"Expedia","reservation_created_date":"2021-08-18 21:13:16","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305139","reservation_id":"121426","confirmation_number":"SJ12615404530","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1818078454","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":"128898","customer_id":"128898","source_of_creation":"Expedia","reservation_created_date":"2021-08-18 21:13:26","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","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305141","reservation_id":"121425","confirmation_number":"SJ12644702640","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1818078451","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":"128897","customer_id":"128897","source_of_creation":"Expedia","reservation_created_date":"2021-08-18 21:13:21","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":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305146","reservation_id":"121427","confirmation_number":"SJ12619780305","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1818078470","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":"128899","customer_id":"128899","source_of_creation":"Expedia","reservation_created_date":"2021-08-18 21:13:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5311117","reservation_id":"120006","confirmation_number":"SJ12661074539","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"339.32","nightly_discount":"0","subtotal":"339.32","grand_total":"381.74","paid_amount":"381.74","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1806183276","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":"127235","customer_id":"127235","source_of_creation":"Expedia","reservation_created_date":"2021-07-24 19:45:06","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"339.32","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":"5320118","reservation_id":"123878","confirmation_number":"SJ12693195847","room_stay_from":"2021-10-01","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.60,173.60","nightly_discount":"0,0","subtotal":"347.20","grand_total":"390.60","paid_amount":"390.60","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1836405512","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":"131665","customer_id":"131665","source_of_creation":"Expedia","reservation_created_date":"2021-09-29 06:20:16","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":"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":"5320163","reservation_id":"119155","confirmation_number":"SJ12635681899","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,100.24,100.24","nightly_discount":"0,0,0,0","subtotal":"479.36","grand_total":"539.28","paid_amount":"539.28","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1799416619","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":"126285","customer_id":"126285","source_of_creation":"Expedia","reservation_created_date":"2021-07-12 00:50:23","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5320633","reservation_id":"123959","confirmation_number":"SJ12634630040","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.12","nightly_discount":"0","subtotal":"176.12","grand_total":"198.14","paid_amount":"198.14","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1837071464","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":"131809","customer_id":"131809","source_of_creation":"Expedia","reservation_created_date":"2021-09-30 16:40:11","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":"126","group_rooms":null,"currentDayPrice":"176.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5320666","reservation_id":"123918","confirmation_number":"SJ12687810231","room_stay_from":"2021-10-01","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.96,200.96","nightly_discount":"0,0","subtotal":"401.92","grand_total":"452.16","paid_amount":"452.16","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1836742855","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":"131752","customer_id":"131752","source_of_creation":"Expedia","reservation_created_date":"2021-09-29 22:45:11","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":"200.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"}]},{"room_stay_id":"5321074","reservation_id":"123347","confirmation_number":"SJ12666709229","room_stay_from":"2021-10-01","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"184.96,184.96","nightly_discount":"0.00,0.00","subtotal":"369.92","grand_total":"416.16","paid_amount":"416.16","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1832440978","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":"131070","customer_id":"131070","source_of_creation":"Expedia","reservation_created_date":"2021-09-20 15:55:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5321369","reservation_id":"121428","confirmation_number":"SJ12633914162","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1818078459","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":"128900","customer_id":"128900","source_of_creation":"Expedia","reservation_created_date":"2021-08-18 21:13:35","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":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5321653","reservation_id":"123085","confirmation_number":"SJ12650822526","room_stay_from":"2021-10-01","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.40,173.40,137.40","nightly_discount":"0,0,0","subtotal":"484.20","grand_total":"544.73","paid_amount":"544.73","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1830248302","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":"130767","customer_id":"130767","source_of_creation":"Expedia","reservation_created_date":"2021-09-15 16:30:12","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","group_rooms":null,"currentDayPrice":"173.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5315164","reservation_id":"118026","confirmation_number":"SJ12617392807","room_stay_from":"2021-09-29","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.26,107.26,150.38,150.38,112.65","nightly_discount":"0,0,0,0,0","subtotal":"627.93","grand_total":"706.42","paid_amount":"706.42","room_type_id":"319","product_id":"1306","siteminder_id":"GAM-R2614949986","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":"125016","customer_id":"125016","source_of_creation":"Getaroom.com","reservation_created_date":"2021-06-25 02:06:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"150.38","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":"5322038","reservation_id":"124023","confirmation_number":"SJ12693264926","room_stay_from":"2021-11-19","room_stay_to":"2021-11-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.18,184.18","nightly_discount":"0,0","subtotal":"368.36","grand_total":"414.41","paid_amount":"0.00","room_type_id":"319","product_id":"1274","siteminder_id":"GAM-R2841803245","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":"131892","customer_id":"131892","source_of_creation":"Getaroom.com","reservation_created_date":"2021-10-01 20:54:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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"}]}],"gam_non_taxable":[{"room_stay_id":"3283564","reservation_id":"118406","confirmation_number":"SJ12679571226","room_stay_from":"2021-10-01","room_stay_to":"2021-10-03","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.38,153.38","nightly_discount":"0,0","subtotal":"306.76","grand_total":"345.11","paid_amount":"345.11","room_type_id":"413","product_id":"1266","siteminder_id":"GAM-R2627665120","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":"131881","customer_id":"131881","source_of_creation":"Getaroom.com","reservation_created_date":"2021-06-30 19:10:12","service_canceled_date_time":"2021-10-02 13:37:34","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"345.11","sub_hotel_id":"126","deltaChange":"172.56","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5318998","reservation_id":"118779","confirmation_number":"SJ12680130694","room_stay_from":"2021-09-27","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.33,177.33,177.33,177.33,177.33,177.33,170.01","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1233.99","grand_total":"1430.00","paid_amount":"1430.04","room_type_id":"319","product_id":"1319","siteminder_id":"ABB-HMWSDQT89K","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1241.31","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125868","customer_id":"125868","source_of_creation":"Airbnb","reservation_created_date":"2021-07-06 05:54:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"36.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"177.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"5320068","reservation_id":"119291","confirmation_number":"SJ12613756401","room_stay_from":"2021-09-29","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"329.46,329.46,329.46,321.55","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1309.93","grand_total":"1517.99","paid_amount":"1518.04","room_type_id":"320","product_id":"1330","siteminder_id":"ABB-HMD2XB85CN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1317.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126419","customer_id":"126419","source_of_creation":"Airbnb","reservation_created_date":"2021-07-14 02:28:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"38.76","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"321.55","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":"5322017","reservation_id":"123726","confirmation_number":"SJ12662178735","room_stay_from":"2021-10-02","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"238.16,235.00","nightly_discount":"0.00,0.00","subtotal":"473.16","grand_total":"555.98","paid_amount":"555.98","room_type_id":"412","product_id":"1921","siteminder_id":"ABB-HMCHBJ9NS2","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"476.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131497","customer_id":"131497","source_of_creation":"Airbnb","reservation_created_date":"2021-09-26 23:55:24","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"15.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"238.16","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":"5322023","reservation_id":"119167","confirmation_number":"SJ12624983704","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"323.34,323.34,317.52","nightly_discount":"0.00,0.00,0.00","subtotal":"964.20","grand_total":"1117.38","paid_amount":"1117.38","room_type_id":"320","product_id":"1328","siteminder_id":"ABB-HM3YSDJNH9","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"970.02","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126296","customer_id":"126296","source_of_creation":"Airbnb","reservation_created_date":"2021-07-12 12:02:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"28.53","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"323.34","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":"5322102","reservation_id":"122957","confirmation_number":"SJ12628159974","room_stay_from":"2021-10-03","room_stay_to":"2021-10-05","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.12,210.12","nightly_discount":"0,0","subtotal":"420.24","grand_total":"486.60","paid_amount":"0.00","room_type_id":"319","product_id":"1307","siteminder_id":"ABB-HM3NPT3E4P","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"420.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130626","customer_id":"130626","source_of_creation":"Airbnb","reservation_created_date":"2021-09-13 03:35:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"12.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3305122","reservation_id":"113465","confirmation_number":"SJ12666493251","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,134.25,134.25","nightly_discount":"0.00,0.00,0.00","subtotal":"455.25","grand_total":"512.15","paid_amount":"512.15","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":"120058","customer_id":"120058","source_of_creation":"FE","reservation_created_date":"2021-04-20 15:35:49","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":"186.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305128","reservation_id":"113466","confirmation_number":"SJ12676441888","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,134.25,134.25","nightly_discount":"0.00,0.00,0.00","subtotal":"455.25","grand_total":"512.15","paid_amount":"512.15","room_type_id":"319","product_id":"1943","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120059","customer_id":"120059","source_of_creation":"FE","reservation_created_date":"2021-04-20 15:39:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"186.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304232","reservation_id":"122009","confirmation_number":"SJ12665230991","room_stay_from":"2021-10-02","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.15,169.15","nightly_discount":"0.00,0.00","subtotal":"423.30","grand_total":"476.22","paid_amount":"476.22","room_type_id":"413","product_id":"1265","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":"129548","customer_id":"129548","source_of_creation":"FE","reservation_created_date":"2021-08-27 16:24:18","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"254.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3282069","reservation_id":"119118","confirmation_number":"SJ12674720913","room_stay_from":"2021-10-02","room_stay_to":"2021-10-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.15,177.65,177.65,177.65,177.65,177.65,237.15","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1362.55","grand_total":"1532.87","paid_amount":"1532.87","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126238","customer_id":"126238","source_of_creation":"PMS","reservation_created_date":"2021-07-11 15:59:20","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":"0","group_rooms":null,"currentDayPrice":"237.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":"3290502","reservation_id":"117116","confirmation_number":"SJ12674453126","room_stay_from":"2021-09-29","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,149.25,209.25,209.25,156.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"873.75","grand_total":"982.97","paid_amount":"140.63","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124051","customer_id":"124051","source_of_creation":"PMS","reservation_created_date":"2021-06-12 20:41:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3290505","reservation_id":"117116","confirmation_number":"SJ12656357603","room_stay_from":"2021-09-29","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,149.25,209.25,209.25,156.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"873.75","grand_total":"982.97","paid_amount":"140.63","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124051","customer_id":"124051","source_of_creation":"PMS","reservation_created_date":"2021-06-12 20:41:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5315152","reservation_id":"113504","confirmation_number":"SJ12651747828","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,134.25,134.25","nightly_discount":"0.00,0.00,0.00","subtotal":"455.25","grand_total":"512.15","paid_amount":"512.15","room_type_id":"319","product_id":"1288","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":"120101","customer_id":"120101","source_of_creation":"PMS","reservation_created_date":"2021-04-20 23:33:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"186.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5317875","reservation_id":"123535","confirmation_number":"SJ12695569009","room_stay_from":"2021-09-30","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,216.75,216.75,171.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"754.50","grand_total":"848.82","paid_amount":"848.82","room_type_id":"319","product_id":"1301","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":"131270","customer_id":"131270","source_of_creation":"PMS","reservation_created_date":"2021-09-23 14:38:29","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":"216.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5320177","reservation_id":"123890","confirmation_number":"SJ12655213737","room_stay_from":"2021-09-29","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"149.25,149.25,216.75,216.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"732.00","grand_total":"823.50","paid_amount":"823.50","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":"131713","customer_id":"131713","source_of_creation":"PMS","reservation_created_date":"2021-09-29 14:41:22","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":"216.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5322289","reservation_id":"124047","confirmation_number":"SJ12681559863","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.90","nightly_discount":"0.00","subtotal":"266.90","grand_total":"300.27","paid_amount":"300.27","room_type_id":"412","product_id":"1316","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":"131934","customer_id":"131934","source_of_creation":"PMS","reservation_created_date":"2021-10-02 18:18:49","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"266.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5302606","reservation_id":"109246","confirmation_number":"SJ12668625472","room_stay_from":"2021-10-01","room_stay_to":"2021-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-04 00:38:48","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5302672","reservation_id":"110553","confirmation_number":"SJ12656309986","room_stay_from":"2021-09-29","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"520.02","grand_total":"520.02","paid_amount":"168.75","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 19:04:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0","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":"5303218","reservation_id":"119919","confirmation_number":"SJ12619012542","room_stay_from":"2021-10-01","room_stay_to":"2021-10-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-07-23 21:01:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303240","reservation_id":"119937","confirmation_number":"SJ12674833462","room_stay_from":"2021-10-01","room_stay_to":"2021-10-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"0.00","room_type_id":"319","product_id":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-07-23 22:54:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303368","reservation_id":"113204","confirmation_number":"SJ12694460600","room_stay_from":"2021-10-02","room_stay_to":"2021-10-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 17:00:27","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":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318761","reservation_id":"122764","confirmation_number":"SJ12648315512","room_stay_from":"2021-09-26","room_stay_to":"2021-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.85,97.85,97.85,97.85,97.85,97.85,97.85","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"684.95","grand_total":"684.95","paid_amount":"0.00","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-09-09 00:41:35","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"97.85","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5320832","reservation_id":"119917","confirmation_number":"SJ12611029289","room_stay_from":"2021-10-01","room_stay_to":"2021-10-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-07-23 20:40:27","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5320884","reservation_id":"117956","confirmation_number":"SJ12650880496","room_stay_from":"2021-09-30","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-24 02:34:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5320886","reservation_id":"117956","confirmation_number":"SJ12669532157","room_stay_from":"2021-09-30","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-24 02:34:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5322171","reservation_id":"124036","confirmation_number":"SJ12679092559","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"84.38","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":"2021-10-02 16:40:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5322322","reservation_id":"114391","confirmation_number":"SJ12642705199","room_stay_from":"2021-10-01","room_stay_to":"2021-10-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"413","product_id":"1273","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-05-02 22:44:12","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":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5322334","reservation_id":"114478","confirmation_number":"SJ12680069759","room_stay_from":"2021-10-02","room_stay_to":"2021-10-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"87.57,87.57,87.57,87.57,87.57,87.57,87.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"613.00","grand_total":"613.00","paid_amount":"0.00","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-05-04 01:41:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"87.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":"5322156","reservation_id":"123268","confirmation_number":"SJ12621193128","room_stay_from":"2021-10-05","room_stay_to":"2021-10-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.57,87.57,87.57,87.57,87.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"437.85","grand_total":"437.85","paid_amount":"0.00","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-09-18 20:31:51","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","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":"5315162","reservation_id":"122884","confirmation_number":"SJ12613258534","room_confirmation_number":"SJ12619360704","room_stay_from":"2021-09-30","room_stay_to":"2021-10-04","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"130549","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-09-19 14:28:45","reservation_modified_date_time":"2021-09-19 14:28:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130549","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5315168","reservation_id":"122884","confirmation_number":"SJ12684214004","room_confirmation_number":"SJ12678963631","room_stay_from":"2021-09-30","room_stay_to":"2021-10-04","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"130549","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-09-19 14:29:20","reservation_modified_date_time":"2021-09-19 14:29:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130549","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5320179","reservation_id":"123890","confirmation_number":"SJ12619025925","room_confirmation_number":"SJ12655213737","room_stay_from":"2021-09-29","room_stay_to":"2021-10-03","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":"1777","service_quantity":"1","customer_traveller_id":"131713","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-09-29 14:41:22","reservation_modified_date_time":"2021-09-29 14:41:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131713","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":"5320661","reservation_id":"123726","confirmation_number":"SJ12638941632","room_confirmation_number":"SJ12662178735","room_stay_from":"2021-10-02","room_stay_to":"2021-10-04","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"50.30","paid_amount":"50.30","product_id":"1777","service_quantity":"1","customer_traveller_id":"131497","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-09-30 17:13:51","reservation_modified_date_time":"2021-09-30 17:13:51","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131497","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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"}]}],"extra_person_non_taxable":[{"room_stay_id":"5322323","reservation_id":"114391","confirmation_number":"SJ12668663475","room_confirmation_number":"SJ12642705199","room_stay_from":"2021-10-01","room_stay_to":"2021-10-08","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"175.00","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"82465","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-10-02 20:07:27","reservation_modified_date_time":"2021-10-02 20:07:27","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"Reservation created with partial past date","deltaChange":"25.00","currentDayPrice":"25","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"}]}],"resort_fee_taxable":[{"room_stay_id":"3251045","reservation_id":"114478","confirmation_number":"SJ12655831879","room_confirmation_number":"SJ12680069759","room_stay_from":"2021-10-02","room_stay_to":"2021-10-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 01:41:46","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3282070","reservation_id":"119118","confirmation_number":"SJ12630851111","room_confirmation_number":"SJ12674720913","room_stay_from":"2021-10-02","room_stay_to":"2021-10-09","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":"126238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-11 15:59:20","reservation_modified_date_time":"2021-07-11 15:59:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126238","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":"3290504","reservation_id":"117116","confirmation_number":"SJ12688248533","room_confirmation_number":"SJ12674453126","room_stay_from":"2021-09-29","room_stay_to":"2021-10-04","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":"124051","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-12 20:41:15","reservation_modified_date_time":"2021-07-26 18:40:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124051","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":"3290506","reservation_id":"117116","confirmation_number":"SJ12620380953","room_confirmation_number":"SJ12656357603","room_stay_from":"2021-09-29","room_stay_to":"2021-10-04","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":"124051","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-12 20:41:15","reservation_modified_date_time":"2021-07-26 18:41:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124051","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":"3290545","reservation_id":"120051","confirmation_number":"SJ12615177296","room_confirmation_number":"SJ12679238805","room_stay_from":"2021-09-30","room_stay_to":"2021-10-05","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"127291","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-25 17:59:18","reservation_modified_date_time":"2021-07-26 19:14:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127291","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3292546","reservation_id":"120400","confirmation_number":"SJ12666212684","room_confirmation_number":"SJ12643388883","room_stay_from":"2021-10-02","room_stay_to":"2021-10-06","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":"127679","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-30 14:41:10","reservation_modified_date_time":"2021-07-30 14:41:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127679","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":"3305103","reservation_id":"121423","confirmation_number":"SJ12639134957","room_confirmation_number":"SJ12687633291","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"128895","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 21:13:12","reservation_modified_date_time":"2021-08-19 22:03:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128895","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":"3305123","reservation_id":"113465","confirmation_number":"SJ12635837248","room_confirmation_number":"SJ12666493251","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","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":"120058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 15:35:49","reservation_modified_date_time":"2021-08-19 22:05:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120058","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":"3305129","reservation_id":"113466","confirmation_number":"SJ12624450388","room_confirmation_number":"SJ12676441888","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","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":"120059","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 15:39:27","reservation_modified_date_time":"2021-08-19 22:06:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120059","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":"3305132","reservation_id":"121424","confirmation_number":"SJ12630089299","room_confirmation_number":"SJ12635711491","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"128896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 21:13:16","reservation_modified_date_time":"2021-08-19 22:06:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128896","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":"3305140","reservation_id":"121426","confirmation_number":"SJ12674907435","room_confirmation_number":"SJ12615404530","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"128898","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 21:13:26","reservation_modified_date_time":"2021-08-19 22:07:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128898","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":"3305142","reservation_id":"121425","confirmation_number":"SJ12697982862","room_confirmation_number":"SJ12644702640","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"128897","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 21:13:21","reservation_modified_date_time":"2021-08-19 22:07:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128897","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":"3305147","reservation_id":"121427","confirmation_number":"SJ12675262208","room_confirmation_number":"SJ12619780305","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"128899","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 21:13:31","reservation_modified_date_time":"2021-08-19 22:08:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128899","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":"5178752","reservation_id":"121708","confirmation_number":"SJ12627416836","room_confirmation_number":"SJ12645747305","room_stay_from":"2021-09-30","room_stay_to":"2021-10-08","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":"129251","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-22 19:10:19","reservation_modified_date_time":"2021-08-22 19:14:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129251","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":"5178754","reservation_id":"121708","confirmation_number":"SJ12668324990","room_confirmation_number":"SJ12694032522","room_stay_from":"2021-09-30","room_stay_to":"2021-10-08","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":"129251","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-22 19:10:25","reservation_modified_date_time":"2021-08-22 19:15:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129251","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":"5302605","reservation_id":"109246","confirmation_number":"SJ12698061203","room_confirmation_number":"SJ12668625472","room_stay_from":"2021-10-01","room_stay_to":"2021-10-04","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":"115715","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:38:48","reservation_modified_date_time":"2021-08-25 19:06:09","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5302671","reservation_id":"110553","confirmation_number":"SJ12633206833","room_confirmation_number":"SJ12656309986","room_stay_from":"2021-09-29","room_stay_to":"2021-10-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117065","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 19:04:57","reservation_modified_date_time":"2021-08-25 19:06:10","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":"5303217","reservation_id":"119919","confirmation_number":"SJ12615581101","room_confirmation_number":"SJ12619012542","room_stay_from":"2021-10-01","room_stay_to":"2021-10-06","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":"127137","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-23 21:01:01","reservation_modified_date_time":"2021-08-25 19:06:20","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303239","reservation_id":"119937","confirmation_number":"SJ12694932599","room_confirmation_number":"SJ12674833462","room_stay_from":"2021-10-01","room_stay_to":"2021-10-06","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":"127162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-23 22:54:34","reservation_modified_date_time":"2021-08-25 19:06:20","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303367","reservation_id":"113204","confirmation_number":"SJ12652496217","room_confirmation_number":"SJ12694460600","room_stay_from":"2021-10-02","room_stay_to":"2021-10-09","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":"119794","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 17:00:27","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304233","reservation_id":"122009","confirmation_number":"SJ12618573075","room_confirmation_number":"SJ12665230991","room_stay_from":"2021-10-02","room_stay_to":"2021-10-04","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":"129548","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-27 16:24:18","reservation_modified_date_time":"2021-08-27 16:24:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129548","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":"5304873","reservation_id":"117538","confirmation_number":"SJ12624089743","room_confirmation_number":"SJ12697700220","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"124499","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-18 15:39:20","reservation_modified_date_time":"2021-08-28 16:02:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124499","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":"5311116","reservation_id":"120256","confirmation_number":"SJ12644931985","room_confirmation_number":"SJ12692839070","room_stay_from":"2021-09-30","room_stay_to":"2021-10-03","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":"127521","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-28 10:53:07","reservation_modified_date_time":"2021-09-09 14:56:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127521","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":"5311120","reservation_id":"120006","confirmation_number":"SJ12680214113","room_confirmation_number":"SJ12661074539","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","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":"127235","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-24 19:45:06","reservation_modified_date_time":"2021-09-09 14:56:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127235","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":"5312595","reservation_id":"118981","confirmation_number":"SJ12676024750","room_confirmation_number":"SJ12677956076","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"126082","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-09 05:35:11","reservation_modified_date_time":"2021-09-13 14:57:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126082","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5315153","reservation_id":"113504","confirmation_number":"SJ12613049631","room_confirmation_number":"SJ12651747828","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","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":"120101","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 23:33:54","reservation_modified_date_time":"2021-09-19 14:26:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120101","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":"5315163","reservation_id":"122884","confirmation_number":"SJ12634934385","room_confirmation_number":"SJ12619360704","room_stay_from":"2021-09-30","room_stay_to":"2021-10-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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"130549","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-11 17:45:13","reservation_modified_date_time":"2021-09-19 14:28:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130549","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5315166","reservation_id":"118026","confirmation_number":"SJ12613397956","room_confirmation_number":"SJ12617392807","room_stay_from":"2021-09-29","room_stay_to":"2021-10-04","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":"125016","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-25 02:06:08","reservation_modified_date_time":"2021-09-19 14:29:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125016","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":"5315169","reservation_id":"122884","confirmation_number":"SJ12691054432","room_confirmation_number":"SJ12678963631","room_stay_from":"2021-09-30","room_stay_to":"2021-10-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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"130549","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-11 17:45:41","reservation_modified_date_time":"2021-09-19 14:29:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130549","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":"5317876","reservation_id":"123535","confirmation_number":"SJ12618015789","room_confirmation_number":"SJ12695569009","room_stay_from":"2021-09-30","room_stay_to":"2021-10-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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"131270","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-23 14:38:29","reservation_modified_date_time":"2021-09-25 13:01:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131270","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":"5318760","reservation_id":"114195","confirmation_number":"SJ12646809043","room_confirmation_number":"SJ12664164118","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"120836","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-30 13:14:09","reservation_modified_date_time":"2021-09-26 19:13:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120836","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":"5318762","reservation_id":"122764","confirmation_number":"SJ12665102667","room_confirmation_number":"SJ12648315512","room_stay_from":"2021-09-26","room_stay_to":"2021-10-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"131918","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-09 00:41:35","reservation_modified_date_time":"2021-09-26 19:14:11","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318999","reservation_id":"118779","confirmation_number":"SJ12681842918","room_confirmation_number":"SJ12680130694","room_stay_from":"2021-09-27","room_stay_to":"2021-10-04","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"125868","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-06 05:54:31","reservation_modified_date_time":"2021-09-27 12:16:05","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125868","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":"5320071","reservation_id":"119291","confirmation_number":"SJ12619940432","room_confirmation_number":"SJ12613756401","room_stay_from":"2021-09-29","room_stay_to":"2021-10-03","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":"126419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-14 02:28:09","reservation_modified_date_time":"2021-09-29 12:35:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126419","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":"5320117","reservation_id":"123878","confirmation_number":"SJ12662290035","room_confirmation_number":"SJ12693195847","room_stay_from":"2021-10-01","room_stay_to":"2021-10-03","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":"131665","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-29 06:20:16","reservation_modified_date_time":"2021-09-29 14:10:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131665","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":"5320164","reservation_id":"119155","confirmation_number":"SJ12656037062","room_confirmation_number":"SJ12635681899","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"126285","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-12 00:50:23","reservation_modified_date_time":"2021-09-29 14:35:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126285","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":"5320178","reservation_id":"123890","confirmation_number":"SJ12618883923","room_confirmation_number":"SJ12655213737","room_stay_from":"2021-09-29","room_stay_to":"2021-10-03","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":"131713","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-29 14:41:22","reservation_modified_date_time":"2021-09-29 14:41:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131713","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":"5320634","reservation_id":"123959","confirmation_number":"SJ12641139034","room_confirmation_number":"SJ12634630040","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","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":"131809","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-30 16:40:11","reservation_modified_date_time":"2021-09-30 16:40:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131809","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":"5320665","reservation_id":"123918","confirmation_number":"SJ12690932013","room_confirmation_number":"SJ12687810231","room_stay_from":"2021-10-01","room_stay_to":"2021-10-03","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":"131752","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-29 22:45:11","reservation_modified_date_time":"2021-09-29 22:45:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131752","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":"5320833","reservation_id":"119917","confirmation_number":"SJ12654799024","room_confirmation_number":"SJ12611029289","room_stay_from":"2021-10-01","room_stay_to":"2021-10-06","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":"127135","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-23 20:40:27","reservation_modified_date_time":"2021-09-30 21:17:42","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":"5320885","reservation_id":"117956","confirmation_number":"SJ12647313948","room_confirmation_number":"SJ12650880496","room_stay_from":"2021-09-30","room_stay_to":"2021-10-05","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":"124947","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 02:34:11","reservation_modified_date_time":"2021-09-30 22:56:13","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":"5320887","reservation_id":"117956","confirmation_number":"SJ12657993822","room_confirmation_number":"SJ12669532157","room_stay_from":"2021-09-30","room_stay_to":"2021-10-05","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":"124947","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 02:34:12","reservation_modified_date_time":"2021-09-30 22:56:41","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":"5321076","reservation_id":"123347","confirmation_number":"SJ12688130699","room_confirmation_number":"SJ12666709229","room_stay_from":"2021-10-01","room_stay_to":"2021-10-03","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":"131070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-20 15:55:06","reservation_modified_date_time":"2021-10-01 15:07:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131070","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":"5321370","reservation_id":"121428","confirmation_number":"SJ12631387636","room_confirmation_number":"SJ12633914162","room_stay_from":"2021-10-01","room_stay_to":"2021-10-05","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":"128900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 21:13:35","reservation_modified_date_time":"2021-10-01 19:38:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128900","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":"5321654","reservation_id":"123085","confirmation_number":"SJ12628182915","room_confirmation_number":"SJ12650822526","room_stay_from":"2021-10-01","room_stay_to":"2021-10-04","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":"130767","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-15 16:30:12","reservation_modified_date_time":"2021-10-01 23:06:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130767","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":"5322018","reservation_id":"123726","confirmation_number":"SJ12690969342","room_confirmation_number":"SJ12662178735","room_stay_from":"2021-10-02","room_stay_to":"2021-10-04","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"131497","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-26 23:55:24","reservation_modified_date_time":"2021-10-02 13:15:01","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131497","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"5322026","reservation_id":"119167","confirmation_number":"SJ12611350995","room_confirmation_number":"SJ12624983704","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-12 12:02:11","reservation_modified_date_time":"2021-10-02 13:17:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126296","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":"5322172","reservation_id":"124036","confirmation_number":"SJ12697647342","room_confirmation_number":"SJ12679092559","room_stay_from":"2021-10-02","room_stay_to":"2021-10-05","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":"131922","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-10-02 16:40:08","reservation_modified_date_time":"2021-10-02 16:40:19","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5322290","reservation_id":"124047","confirmation_number":"SJ12651653752","room_confirmation_number":"SJ12681559863","room_stay_from":"2021-10-02","room_stay_to":"2021-10-03","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":"131934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-10-02 18:18:49","reservation_modified_date_time":"2021-10-02 18:18:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131934","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":"5322324","reservation_id":"114391","confirmation_number":"SJ12671525824","room_confirmation_number":"SJ12642705199","room_stay_from":"2021-10-01","room_stay_to":"2021-10-08","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":"121062","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-02 22:44:12","reservation_modified_date_time":"2021-10-02 20:07:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5322037","reservation_id":"124023","confirmation_number":"SJ12669489977","room_confirmation_number":"SJ12693264926","room_stay_from":"2021-11-19","room_stay_to":"2021-11-21","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"131892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-10-01 20:54:02","reservation_modified_date_time":"2021-10-02 13:53:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131892","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":"5322104","reservation_id":"122957","confirmation_number":"SJ12641681593","room_confirmation_number":"SJ12628159974","room_stay_from":"2021-10-03","room_stay_to":"2021-10-05","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"130626","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-13 03:35:05","reservation_modified_date_time":"2021-10-02 15:32:15","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130626","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","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":"5322157","reservation_id":"123268","confirmation_number":"SJ12681922193","room_confirmation_number":"SJ12621193128","room_stay_from":"2021-10-05","room_stay_to":"2021-10-10","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":"130980","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-18 20:31:51","reservation_modified_date_time":"2021-10-02 16:35:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3283565","reservation_id":"118406","confirmation_number":"SJ12665246433","room_confirmation_number":"SJ12679571226","room_stay_from":"2021-10-01","room_stay_to":"2021-10-03","room_stay_status":"Canceled","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-30 19:10:12","reservation_modified_date_time":"2021-07-13 21:39:55","customer_id":"131881","parentCustTravId":"131881","customer_traveller_id":"131881","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-10-02 13:37:34","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2021-10-01","sub_hotel_id":"126","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"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":"5322111","reservation_id":"122450","confirmation_number":"SJ12697445141","room_confirmation_number":"SJ12634007658","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.26","paid_amount":"56.26","product_id":"1869","service_quantity":"2","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-02 15:41:14","reservation_modified_date_time":"2021-10-02 15:41:14","customer_id":"130046","parentCustTravId":"130046","customer_traveller_id":"131920","static_pos_type":null,"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-09-27","sub_hotel_id":"126","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5322114","reservation_id":"122450","confirmation_number":"SJ12629072514","room_confirmation_number":"SJ12634007658","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-02 15:46:36","reservation_modified_date_time":"2021-10-02 15:46:36","customer_id":"130046","parentCustTravId":"130046","customer_traveller_id":"131920","static_pos_type":null,"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-09-27","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5322390","reservation_id":"124059","confirmation_number":"SJ12672252636","room_confirmation_number":"SJ12648625799","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-02 22:03:54","reservation_modified_date_time":"2021-10-02 22:03:54","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}