{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-08-09","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":18,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1311,1312,1304,1305,1309,1310,1260,1261,1307,1308,1267,1268,1269,1270,1271,1272,1302,1303,1291,1711,1262,1263","bundle_block_bookings":[{"confirmation_number":"SJB12692360149","room_stay_from":"2021-08-05","room_stay_to":"2021-08-10","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12617426404","room_stay_from":"2021-08-05","room_stay_to":"2021-08-10","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12687611141","room_stay_from":"2021-08-07","room_stay_to":"2021-08-10","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12626925154","room_stay_from":"2021-08-07","room_stay_to":"2021-08-10","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12683580995","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12623422494","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12619851193","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12623018462","room_stay_from":"2021-08-06","room_stay_to":"2021-08-12","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12683042705","room_stay_from":"2021-08-06","room_stay_to":"2021-08-12","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12678461995","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12621210006","room_stay_from":"2021-08-06","room_stay_to":"2021-08-12","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12610009881","room_stay_from":"2021-08-05","room_stay_to":"2021-08-12","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12672906763","room_stay_from":"2021-08-08","room_stay_to":"2021-08-12","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12653797446","room_stay_from":"2021-08-08","room_stay_to":"2021-08-12","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12617663444","room_stay_from":"2021-08-08","room_stay_to":"2021-08-13","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12698792484","room_stay_from":"2021-08-09","room_stay_to":"2021-08-13","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12632168109","room_stay_from":"2021-08-09","room_stay_to":"2021-08-13","bundle_room":"0","product_id":"1263"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3265108","reservation_id":"112312","confirmation_number":"SJ12697318504","room_stay_from":"2021-08-04","room_stay_to":"2021-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"113.17,113.17,169.87,169.87,113.17,113.17","nightly_discount":"0,0,0,0,0,0","subtotal":"792.42","grand_total":"891.47","paid_amount":"891.47","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-3354912563","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"300.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118879","customer_id":"118879","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 03:42:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"223.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"113.17","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3283534","reservation_id":"119183","confirmation_number":"SJ12668155210","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"303.20,303.20","nightly_discount":"0,0","subtotal":"606.40","grand_total":"682.20","paid_amount":"682.20","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2502609340","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":"126306","customer_id":"126306","source_of_creation":"Booking.com","reservation_created_date":"2021-07-12 16:05:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"236.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"303.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3283548","reservation_id":"119183","confirmation_number":"SJ12671575220","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"253.2,253.2","nightly_discount":"0,0","subtotal":"506.40","grand_total":"569.70","paid_amount":"569.70","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2502609340","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":"126306","customer_id":"126306","source_of_creation":"Booking.com","reservation_created_date":"2021-07-12 16:05:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"236.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"253.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3296951","reservation_id":"115173","confirmation_number":"SJ12614937442","room_stay_from":"2021-08-05","room_stay_to":"2021-08-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"207.27,251.37,251.37,188.37,188.37,188.37","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1275.12","grand_total":"1434.51","paid_amount":"1434.51","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3516636708","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":"121880","customer_id":"121880","source_of_creation":"Booking.com","reservation_created_date":"2021-05-13 23:05:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"256.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300655","reservation_id":"120984","confirmation_number":"SJ12679832860","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"193.75,193.75","nightly_discount":"0,0","subtotal":"387.50","grand_total":"435.94","paid_amount":"217.97","room_type_id":"320","product_id":"1910","siteminder_id":"BDC-3328637396","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":"128404","customer_id":"128404","source_of_creation":"Booking.com","reservation_created_date":"2021-08-09 17:42:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"78.76","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"193.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276033","reservation_id":"118394","confirmation_number":"SJ12625147973","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"246.75,246.75,246.75","nightly_discount":"0,0,0","subtotal":"740.25","grand_total":"832.78","paid_amount":"832.78","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3852970763","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":"125416","customer_id":"125416","source_of_creation":"Booking.com","reservation_created_date":"2021-06-30 16:31:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"146.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3296365","reservation_id":"109248","confirmation_number":"SJ12612809765","room_stay_from":"2021-08-05","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.77,150.57,150.57,112.77,112.77,112.77,112.77","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"864.99","grand_total":"973.11","paid_amount":"973.11","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-3211958803","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":"115716","customer_id":"115716","source_of_creation":"Booking.com","reservation_created_date":"2021-03-04 00:40:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"187.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"112.77","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3296659","reservation_id":"109236","confirmation_number":"SJ12624835831","room_stay_from":"2021-08-05","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.77,112.77,112.77,112.77,112.77,112.77,112.77","nightly_discount":"0,0,0,0,0,0,0","subtotal":"789.39","grand_total":"888.06","paid_amount":"888.06","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3769025419","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":"115704","customer_id":"115704","source_of_creation":"Booking.com","reservation_created_date":"2021-03-04 00:20:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"187.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"112.77","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3205841","reservation_id":"108787","confirmation_number":"SJ12639174320","room_stay_from":"2021-08-06","room_stay_to":"2021-08-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.57,150.57,112.77,112.77,112.77,112.77,112.77","nightly_discount":"0,0,0,0,0,0,0","subtotal":"864.99","grand_total":"973.11","paid_amount":"973.11","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2880753641","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":"115244","customer_id":"115244","source_of_creation":"Booking.com","reservation_created_date":"2021-02-27 23:08:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"187.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"112.77","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3177129","reservation_id":"105120","confirmation_number":"SJ12695607851","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.30,125.30,125.30,125.30,167.30","nightly_discount":"0,0,0,0,0","subtotal":"668.50","grand_total":"752.07","paid_amount":"752.07","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-2313467628","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":"111504","customer_id":"111504","source_of_creation":"Booking.com","reservation_created_date":"2021-01-10 16:45:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"142.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"125.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":"3205005","reservation_id":"108642","confirmation_number":"SJ12669726894","room_stay_from":"2021-08-07","room_stay_to":"2021-08-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.30,125.30,125.30,125.30,125.30,125.30,167.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"961.10","grand_total":"1081.24","paid_amount":"1081.24","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-3411857448","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":"115079","customer_id":"115079","source_of_creation":"Booking.com","reservation_created_date":"2021-02-26 15:23:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"204.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"125.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":"3294597","reservation_id":"119852","confirmation_number":"SJ12698550119","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.27,207.27,207.27,194.67,226.17","nightly_discount":"0,0,0,0,0","subtotal":"1042.65","grand_total":"1172.98","paid_amount":"1172.98","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2249419301","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":"127050","customer_id":"127050","source_of_creation":"Booking.com","reservation_created_date":"2021-07-22 18:33:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"210.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"207.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300273","reservation_id":"118500","confirmation_number":"SJ12667507574","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"194.3,194.3,194.3,215.3,215.3","nightly_discount":"0,0,0,0,0","subtotal":"1013.50","grand_total":"1140.19","paid_amount":"1140.19","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3107254204","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":"125538","customer_id":"125538","source_of_creation":"Booking.com","reservation_created_date":"2021-07-02 01:03:20","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":"194.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":"3300440","reservation_id":"120923","confirmation_number":"SJ12627898509","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.83,201.83,201.83","nightly_discount":"0,0,0","subtotal":"605.49","grand_total":"681.17","paid_amount":"227.06","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3946308228","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":"128334","customer_id":"128334","source_of_creation":"Booking.com","reservation_created_date":"2021-08-08 02:26:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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":"3300491","reservation_id":"113834","confirmation_number":"SJ12655737749","room_stay_from":"2021-08-21","room_stay_to":"2021-08-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"188.37,125.37","nightly_discount":"0,0","subtotal":"313.74","grand_total":"352.96","paid_amount":"211.92","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2521097594","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":"120460","customer_id":"120460","source_of_creation":"Booking.com","reservation_created_date":"2021-04-25 13:07:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"59.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300712","reservation_id":"118841","confirmation_number":"SJ12648868931","room_stay_from":"2021-08-11","room_stay_to":"2021-08-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,251.30,251.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"963.20","grand_total":"1083.60","paid_amount":"259.09","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3878346610","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":"125926","customer_id":"125926","source_of_creation":"Booking.com","reservation_created_date":"2021-07-07 02:08:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"145.41","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3295873","reservation_id":"110336","confirmation_number":"SJ12644993082","room_stay_from":"2021-08-07","room_stay_to":"2021-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.50,175.50,175.50","nightly_discount":"0,0,0","subtotal":"571.50","grand_total":"642.94","paid_amount":"642.94","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1747827522","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":"116854","customer_id":"116854","source_of_creation":"Expedia","reservation_created_date":"2021-03-15 12:02:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"175.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3299583","reservation_id":"115854","confirmation_number":"SJ12650772169","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.40,149.40,149.40","nightly_discount":"0,0,0","subtotal":"448.20","grand_total":"504.23","paid_amount":"504.23","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1775679571","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":"122635","customer_id":"122635","source_of_creation":"Expedia","reservation_created_date":"2021-05-25 14:06:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"149.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3294330","reservation_id":"120323","confirmation_number":"SJ12656044173","room_stay_from":"2021-08-09","room_stay_to":"2021-08-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.24,184.24,184.24,173.04","nightly_discount":"0,0,0,0","subtotal":"725.76","grand_total":"816.48","paid_amount":"816.48","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1808423339","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":"127592","customer_id":"127592","source_of_creation":"Expedia","reservation_created_date":"2021-07-29 03:46:37","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":"184.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300377","reservation_id":"114265","confirmation_number":"SJ12644883494","room_stay_from":"2021-08-05","room_stay_to":"2021-08-09","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"212.80,212.80,296.80,226.80","nightly_discount":"0,0,0,0","subtotal":"949.20","grand_total":"1067.85","paid_amount":"983.47","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1765851104","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":"120922","customer_id":"120922","source_of_creation":"Expedia","reservation_created_date":"2021-05-01 14:25:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300381","reservation_id":"114266","confirmation_number":"SJ12637466816","room_stay_from":"2021-08-05","room_stay_to":"2021-08-09","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,279.30,209.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"879.20","grand_total":"989.10","paid_amount":"904.72","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1765851108","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":"120923","customer_id":"120923","source_of_creation":"Expedia","reservation_created_date":"2021-05-01 14:25:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3300429","reservation_id":"120925","confirmation_number":"SJ12652647959","room_stay_from":"2021-08-12","room_stay_to":"2021-08-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.40,257.40,257.40","nightly_discount":"0,0,0","subtotal":"700.20","grand_total":"787.73","paid_amount":"0.00","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1813194947","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":"128336","customer_id":"128336","source_of_creation":"Expedia","reservation_created_date":"2021-08-08 03:41:36","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3260113","reservation_id":"116269","confirmation_number":"SJ12663141932","room_stay_from":"2021-08-07","room_stay_to":"2021-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.10,143.80,143.80","nightly_discount":"0,0,0","subtotal":"500.70","grand_total":"563.29","paid_amount":"563.29","room_type_id":"413","product_id":"1271","siteminder_id":"GAM-R2558214580","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":"123128","customer_id":"123128","source_of_creation":"Getaroom.com","reservation_created_date":"2021-05-31 20:16:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"143.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3299493","reservation_id":"111235","confirmation_number":"SJ12615874230","room_stay_from":"2021-08-07","room_stay_to":"2021-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"3","nightly_price":"405.96,405.96,398.65","nightly_discount":"0.00,0.00,0.00","subtotal":"1210.57","grand_total":"1402.89","paid_amount":"1402.89","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HM8CTR283Q","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1217.88","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117767","customer_id":"117767","source_of_creation":"Airbnb","reservation_created_date":"2021-03-25 02:10:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"35.82","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"398.65","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":"3300017","reservation_id":"116752","confirmation_number":"SJ12673694517","room_stay_from":"2021-08-08","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"385.54,385.54,385.54,375.09","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1531.71","grand_total":"1805.62","paid_amount":"1805.62","room_type_id":"320","product_id":"1328","siteminder_id":"ABB-HM38QMZKBN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"1542.16","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123659","customer_id":"123659","source_of_creation":"Airbnb","reservation_created_date":"2021-06-07 21:41:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"51.24","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"385.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3295869","reservation_id":"119195","confirmation_number":"SJ12649498421","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00","subtotal":"740.25","grand_total":"832.78","paid_amount":"832.78","room_type_id":"412","product_id":"1866","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":"126319","customer_id":"126319","source_of_creation":"FE","reservation_created_date":"2021-07-12 19:02:23","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":"0","group_rooms":null,"currentDayPrice":"246.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":"3300161","reservation_id":"117016","confirmation_number":"SJ12643689664","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.25,224.25,224.25","nightly_discount":"0.00,0.00,0.00","subtotal":"672.75","grand_total":"756.85","paid_amount":"756.85","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123956","customer_id":"123956","source_of_creation":"FE","reservation_created_date":"2021-06-11 13:47:37","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3295867","reservation_id":"119485","confirmation_number":"SJ12680819215","room_stay_from":"2021-08-08","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"265.50,265.50,265.50,265.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1062.00","grand_total":"1194.75","paid_amount":"1194.75","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126638","customer_id":"126638","source_of_creation":"FE","reservation_created_date":"2021-07-17 04:01:50","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"265.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298955","reservation_id":"110278","confirmation_number":"SJ12629103381","room_stay_from":"2021-08-05","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"134.25,179.25,179.25,134.25,134.25,134.25,134.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1029.75","grand_total":"1158.47","paid_amount":"1158.47","room_type_id":"413","product_id":"1272","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":"116792","customer_id":"116792","source_of_creation":"FE","reservation_created_date":"2021-03-14 16:34:57","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":"0","group_rooms":null,"currentDayPrice":"134.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":"3300610","reservation_id":"111638","confirmation_number":"SJ12622671714","room_stay_from":"2021-08-09","room_stay_to":"2021-08-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,261.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1002.00","grand_total":"1127.25","paid_amount":"1127.25","room_type_id":"320","product_id":"1321","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118193","customer_id":"118193","source_of_creation":"FE","reservation_created_date":"2021-03-29 23:19:39","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"246.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3294994","reservation_id":"114160","confirmation_number":"SJ12634072450","room_stay_from":"2021-08-04","room_stay_to":"2021-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.00,208.00,208.00,208.00,208.00,208.00","nightly_discount":"10.40,10.40,10.40,10.40,10.40,10.40","subtotal":"1248.00","grand_total":"1333.80","paid_amount":"1333.80","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":"120791","customer_id":"120791","source_of_creation":"PMS","reservation_created_date":"2021-04-29 17:35:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"208.00","currentDayDiscount":"10.40","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298941","reservation_id":"112274","confirmation_number":"SJ12619125133","room_stay_from":"2021-08-05","room_stay_to":"2021-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"246.75,314.25,314.25,246.75,246.75","nightly_discount":"12.34,15.71,15.71,12.34,12.34","subtotal":"1368.75","grand_total":"1462.85","paid_amount":"1462.85","room_type_id":"320","product_id":"1332","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118845","customer_id":"118845","source_of_creation":"PMS","reservation_created_date":"2021-04-06 20:06:29","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":"AAA","sub_hotel_id":"0","group_rooms":"1311,1312","currentDayPrice":"246.75","currentDayDiscount":"12.34","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300420","reservation_id":"120973","confirmation_number":"SJ12611525525","room_stay_from":"2021-08-09","room_stay_to":"2021-08-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65","nightly_discount":"0.00","subtotal":"279.65","grand_total":"314.60","paid_amount":"314.60","room_type_id":"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":"128394","customer_id":"128394","source_of_creation":"PMS","reservation_created_date":"2021-08-09 15:12:11","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","currentDayPrice":"279.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3257735","reservation_id":"113217","confirmation_number":"SJ12655773927","room_stay_from":"2021-08-06","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"322.15,322.15,322.15,322.15,322.15,322.15","nightly_discount":"16.11,16.11,16.11,16.11,16.11,16.11","subtotal":"1932.90","grand_total":"2065.77","paid_amount":"2065.77","room_type_id":"320","product_id":"1330","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109892","customer_id":"109892","source_of_creation":"PMS","reservation_created_date":"2021-04-17 17:39:00","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"322.15","currentDayDiscount":"16.11","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300524","reservation_id":"116819","confirmation_number":"SJ12661057162","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"254.15,254.15,254.15","nightly_discount":"0.00,0.00,0.00","subtotal":"762.45","grand_total":"857.75","paid_amount":"857.75","room_type_id":"413","product_id":"1261","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":"101236","customer_id":"101236","source_of_creation":"PMS","reservation_created_date":"2021-06-08 19:08:24","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","currentDayPrice":"254.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300617","reservation_id":"110435","confirmation_number":"SJ12622588080","room_stay_from":"2021-08-08","room_stay_to":"2021-08-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.00,153.00,153.00,153.00,153.00","nightly_discount":"0.00,0,0,0,0","subtotal":"765.00","grand_total":"860.63","paid_amount":"832.51","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":"116944","customer_id":"116944","source_of_creation":"PMS","reservation_created_date":"2021-03-16 17:06:19","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"153.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3289743","reservation_id":"113748","confirmation_number":"SJ12658837013","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"550.00","grand_total":"618.75","paid_amount":"140.63","room_type_id":"319","product_id":"1293","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":"114227","customer_id":"114227","source_of_creation":"PMS","reservation_created_date":"2021-04-24 02:36:17","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3298867","reservation_id":"113215","confirmation_number":"SJ12681023009","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 17:38:07","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":"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":"3300198","reservation_id":"112806","confirmation_number":"SJ12689848645","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-12 21:46:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298719","reservation_id":"110122","confirmation_number":"SJ12668796694","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"3","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.34","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-12 03:13:29","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":"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":"3298723","reservation_id":"110120","confirmation_number":"SJ12691877725","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","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":"260.01","room_type_id":"413","product_id":"1267","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-12 03:12:50","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3298915","reservation_id":"109352","confirmation_number":"SJ12645759289","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"260.01","room_type_id":"319","product_id":"1274","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 16:10:17","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","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":"3298917","reservation_id":"109353","confirmation_number":"SJ12641690575","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Active","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":"0.00","room_type_id":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-04 16:13:13","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":"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":"3300522","reservation_id":"109235","confirmation_number":"SJ12677691601","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1286","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:17:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","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":"3298157","reservation_id":"112031","confirmation_number":"SJ12632750363","room_stay_from":"2021-08-08","room_stay_to":"2021-08-13","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":"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-04-03 23:18:47","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":"3298919","reservation_id":"112802","confirmation_number":"SJ12673948594","room_stay_from":"2021-08-07","room_stay_to":"2021-08-14","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","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-12 21:31:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3300021","reservation_id":"112803","confirmation_number":"SJ12611149682","room_stay_from":"2021-08-07","room_stay_to":"2021-08-14","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,88.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"610.00","grand_total":"610.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-12 21:35:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3251036","reservation_id":"111330","confirmation_number":"SJ12637351359","room_stay_from":"2021-08-08","room_stay_to":"2021-08-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.14,105.14,105.14,105.14,105.14,105.14,105.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"736.00","grand_total":"736.00","paid_amount":"0.00","room_type_id":"319","product_id":"1288","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-03-26 13:43:09","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":"105.14","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":"3300736","reservation_id":"109515","confirmation_number":"SJ12660271212","room_stay_from":"2021-05-02","room_stay_to":"2021-05-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.85,111.85,111.85,111.85,111.85,111.85,111.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"783.00","grand_total":"783.00","paid_amount":"783.00","room_type_id":"319","product_id":"1915","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-03-05 19:15:08","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":"0","changedComment":"Nightly price or discount changed","deltaChange":"1.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"}]},{"room_stay_id":"3300746","reservation_id":"108702","confirmation_number":"SJ12674341216","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.85,108.85,108.85,108.85,108.85,108.85,108.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"762.00","grand_total":"762.00","paid_amount":"762.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-27 01:46:00","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"Nightly price or discount changed","deltaChange":"0.05","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"}]},{"room_stay_id":"3300758","reservation_id":"112000","confirmation_number":"SJ12619950454","room_stay_from":"2021-06-05","room_stay_to":"2021-06-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"103.71,103.71,103.71,103.71,103.71,207.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"726.00","grand_total":"726.00","paid_amount":"726.00","room_type_id":"319","product_id":"1916","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-04-03 19:14:55","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","changedComment":"Nightly price or discount changed","deltaChange":"103.74","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"}]},{"room_stay_id":"3300761","reservation_id":"105428","confirmation_number":"SJ12664246519","room_stay_from":"2021-06-06","room_stay_to":"2021-06-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.71,103.71,103.71,103.71,103.71,103.71,103.74","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"726.00","grand_total":"726.00","paid_amount":"726.00","room_type_id":"319","product_id":"1318","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-01-16 02:46:42","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","changedComment":"Nightly price or discount changed","deltaChange":"0.03","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"}]},{"room_stay_id":"3300763","reservation_id":"111341","confirmation_number":"SJ12656545344","room_stay_from":"2021-06-18","room_stay_to":"2021-06-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.71,106.71,106.71,106.71,106.71,213.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"747.00","grand_total":"747.00","paid_amount":"747.00","room_type_id":"319","product_id":"1306","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-03-26 14:26:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"Nightly price or discount changed","deltaChange":"0.03","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"}]},{"room_stay_id":"3300728","reservation_id":"110131","confirmation_number":"SJ12668817876","room_stay_from":"2021-05-01","room_stay_to":"2021-05-04","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.00,261.00,261.00","nightly_discount":"0.00,0.00,0.00","subtotal":"783.00","grand_total":"783.00","paid_amount":"783.00","room_type_id":"319","product_id":"1293","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-03-12 13:05:19","service_canceled_date_time":"2021-08-09 22:25:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"Room-Night-2-prices","total_paid_amount":"783.00","sub_hotel_id":"0","deltaChange":"783.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3265109","reservation_id":"112312","confirmation_number":"SJ12698784380","room_confirmation_number":"SJ12697318504","room_stay_from":"2021-08-04","room_stay_to":"2021-08-10","room_stay_status":"Active","nightly_price":"50,50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"300.00","grand_total":"337.50","paid_amount":"337.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"118879","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-10 15:12:09","reservation_modified_date_time":"2021-06-10 15:12:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118879","canceled_nights_data":"","posAmt_airbnb_taxpaid":"300.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3283549","reservation_id":"119183","confirmation_number":"SJ12612701892","room_confirmation_number":"SJ12671575220","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"126306","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-07-13 21:37:00","reservation_modified_date_time":"2021-07-13 21:37:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126306","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3263787","reservation_id":"116752","confirmation_number":"SJ12623923274","room_confirmation_number":"SJ12673694517","room_stay_from":"2021-08-08","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"201.20","paid_amount":"201.20","product_id":"1777","service_quantity":"1","customer_traveller_id":"123659","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-06-07 21:41:09","reservation_modified_date_time":"2021-06-07 21:41:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123659","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3300274","reservation_id":"118500","confirmation_number":"SJ12659903012","room_confirmation_number":"SJ12667507574","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","room_stay_status":"Active","nightly_price":"50,50,50,50,50","nightly_discount":"0,0,0,0,0","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"125538","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-09 00:24:45","reservation_modified_date_time":"2021-08-09 00:24:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125538","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3260114","reservation_id":"116269","confirmation_number":"SJ12659265449","room_confirmation_number":"SJ12663141932","room_stay_from":"2021-08-07","room_stay_to":"2021-08-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"123128","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 20:16:10","reservation_modified_date_time":"2021-05-31 20:16:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123128","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":"3265110","reservation_id":"112312","confirmation_number":"SJ12619411116","room_confirmation_number":"SJ12697318504","room_stay_from":"2021-08-04","room_stay_to":"2021-08-10","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"118879","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 03:42:10","reservation_modified_date_time":"2021-06-10 15:12:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118879","canceled_nights_data":"","posAmt_airbnb_taxpaid":"300.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":"3294995","reservation_id":"114160","confirmation_number":"SJ12656250792","room_confirmation_number":"SJ12634072450","room_stay_from":"2021-08-04","room_stay_to":"2021-08-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"120791","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-29 17:35:50","reservation_modified_date_time":"2021-08-02 17:02:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120791","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":"3295874","reservation_id":"110336","confirmation_number":"SJ12665440175","room_confirmation_number":"SJ12644993082","room_stay_from":"2021-08-07","room_stay_to":"2021-08-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"116854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-15 12:02:12","reservation_modified_date_time":"2021-08-03 20:04:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116854","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":"3298944","reservation_id":"112274","confirmation_number":"SJ12676422635","room_confirmation_number":"SJ12619125133","room_stay_from":"2021-08-05","room_stay_to":"2021-08-10","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":"118845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-06 20:06:29","reservation_modified_date_time":"2021-08-05 20:18:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118845","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":"3299496","reservation_id":"111235","confirmation_number":"SJ12646607182","room_confirmation_number":"SJ12615874230","room_stay_from":"2021-08-07","room_stay_to":"2021-08-10","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":"117767","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-25 02:10:11","reservation_modified_date_time":"2021-08-07 13:32:23","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117767","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":"3300421","reservation_id":"120973","confirmation_number":"SJ12680100351","room_confirmation_number":"SJ12611525525","room_stay_from":"2021-08-09","room_stay_to":"2021-08-10","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"128394","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-09 15:12:11","reservation_modified_date_time":"2021-08-09 15:12:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128394","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":"3283535","reservation_id":"119183","confirmation_number":"SJ12618864447","room_confirmation_number":"SJ12668155210","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"126306","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-12 16:05:18","reservation_modified_date_time":"2021-07-13 21:33:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126306","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":"3283550","reservation_id":"119183","confirmation_number":"SJ12643380710","room_confirmation_number":"SJ12671575220","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"126306","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-12 16:05:12","reservation_modified_date_time":"2021-07-13 21:37:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126306","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":"3295870","reservation_id":"119195","confirmation_number":"SJ12667150280","room_confirmation_number":"SJ12649498421","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"126319","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-12 19:02:23","reservation_modified_date_time":"2021-08-03 20:04:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126319","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":"3296952","reservation_id":"115173","confirmation_number":"SJ12697055218","room_confirmation_number":"SJ12614937442","room_stay_from":"2021-08-05","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"121880","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-13 23:05:10","reservation_modified_date_time":"2021-08-05 19:26:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121880","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":"3298866","reservation_id":"113215","confirmation_number":"SJ12679913009","room_confirmation_number":"SJ12681023009","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119806","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 17:38:07","reservation_modified_date_time":"2021-08-05 19:57:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3299584","reservation_id":"115854","confirmation_number":"SJ12682471757","room_confirmation_number":"SJ12650772169","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"122635","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-25 14:06:09","reservation_modified_date_time":"2021-08-07 15:53:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122635","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":"3300162","reservation_id":"117016","confirmation_number":"SJ12683059636","room_confirmation_number":"SJ12643689664","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"123956","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-11 13:47:37","reservation_modified_date_time":"2021-08-08 19:18:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123956","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":"3300199","reservation_id":"112806","confirmation_number":"SJ12615962401","room_confirmation_number":"SJ12689848645","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119397","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 21:46:02","reservation_modified_date_time":"2021-08-08 20:38:53","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":"3300658","reservation_id":"120984","confirmation_number":"SJ12624770865","room_confirmation_number":"SJ12679832860","room_stay_from":"2021-08-09","room_stay_to":"2021-08-11","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":"128404","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-09 17:42:10","reservation_modified_date_time":"2021-08-09 20:19:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128404","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":"3257738","reservation_id":"113217","confirmation_number":"SJ12685893876","room_confirmation_number":"SJ12655773927","room_stay_from":"2021-08-06","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"109892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 17:39:00","reservation_modified_date_time":"2021-05-27 14:11:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109892","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":"3276034","reservation_id":"118394","confirmation_number":"SJ12673862500","room_confirmation_number":"SJ12625147973","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"125416","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-30 16:31:12","reservation_modified_date_time":"2021-06-30 19:53:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125416","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":"3295868","reservation_id":"119485","confirmation_number":"SJ12623335884","room_confirmation_number":"SJ12680819215","room_stay_from":"2021-08-08","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"126638","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 04:01:50","reservation_modified_date_time":"2021-08-03 20:03:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126638","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":"3296366","reservation_id":"109248","confirmation_number":"SJ12685956587","room_confirmation_number":"SJ12612809765","room_stay_from":"2021-08-05","room_stay_to":"2021-08-12","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":"115716","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:40:12","reservation_modified_date_time":"2021-08-04 19:17:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115716","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":"3296660","reservation_id":"109236","confirmation_number":"SJ12633467141","room_confirmation_number":"SJ12624835831","room_stay_from":"2021-08-05","room_stay_to":"2021-08-12","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":"115704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:20:13","reservation_modified_date_time":"2021-08-05 13:22:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115704","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":"3298718","reservation_id":"110122","confirmation_number":"SJ12617915719","room_confirmation_number":"SJ12668796694","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116625","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 03:13:29","reservation_modified_date_time":"2021-08-05 19:57:07","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":"3298722","reservation_id":"110120","confirmation_number":"SJ12663043532","room_confirmation_number":"SJ12691877725","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"116625","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 03:12:50","reservation_modified_date_time":"2021-08-05 19:57:07","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":"3298914","reservation_id":"109352","confirmation_number":"SJ12685076096","room_confirmation_number":"SJ12645759289","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"115815","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 16:10:17","reservation_modified_date_time":"2021-08-05 19:57: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":"3298916","reservation_id":"109353","confirmation_number":"SJ12638628590","room_confirmation_number":"SJ12641690575","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115816","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 16:13:13","reservation_modified_date_time":"2021-08-05 19:57: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":"3298957","reservation_id":"110278","confirmation_number":"SJ12677640792","room_confirmation_number":"SJ12629103381","room_stay_from":"2021-08-05","room_stay_to":"2021-08-12","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":"116792","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-14 16:34:57","reservation_modified_date_time":"2021-08-05 21:41:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116792","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":"3300020","reservation_id":"116752","confirmation_number":"SJ12656822512","room_confirmation_number":"SJ12673694517","room_stay_from":"2021-08-08","room_stay_to":"2021-08-12","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":"123659","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-07 21:41:09","reservation_modified_date_time":"2021-08-08 13:16:13","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123659","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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":"3300523","reservation_id":"109235","confirmation_number":"SJ12618470539","room_confirmation_number":"SJ12677691601","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:17:56","reservation_modified_date_time":"2021-08-09 17:29:11","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":"3300525","reservation_id":"116819","confirmation_number":"SJ12616754662","room_confirmation_number":"SJ12661057162","room_stay_from":"2021-08-09","room_stay_to":"2021-08-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"101236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-08 19:08:24","reservation_modified_date_time":"2021-08-09 17:29:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101236","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":"3205842","reservation_id":"108787","confirmation_number":"SJ12626616235","room_confirmation_number":"SJ12639174320","room_stay_from":"2021-08-06","room_stay_to":"2021-08-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"115244","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 23:08:10","reservation_modified_date_time":"2021-02-27 23:08:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115244","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":"3294331","reservation_id":"120323","confirmation_number":"SJ12613221152","room_confirmation_number":"SJ12656044173","room_stay_from":"2021-08-09","room_stay_to":"2021-08-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"127592","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-29 03:46:37","reservation_modified_date_time":"2021-08-01 19:13:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127592","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":"3298156","reservation_id":"112031","confirmation_number":"SJ12690636110","room_confirmation_number":"SJ12632750363","room_stay_from":"2021-08-08","room_stay_to":"2021-08-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118602","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 23:18:47","reservation_modified_date_time":"2021-08-05 19:56:59","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":"3300613","reservation_id":"111638","confirmation_number":"SJ12675405951","room_confirmation_number":"SJ12622671714","room_stay_from":"2021-08-09","room_stay_to":"2021-08-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"118193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-29 23:19:39","reservation_modified_date_time":"2021-08-09 18:57:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118193","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":"3300618","reservation_id":"110435","confirmation_number":"SJ12613976860","room_confirmation_number":"SJ12622588080","room_stay_from":"2021-08-08","room_stay_to":"2021-08-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"116944","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 17:06:19","reservation_modified_date_time":"2021-08-09 19:09:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116944","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3177130","reservation_id":"105120","confirmation_number":"SJ12629770804","room_confirmation_number":"SJ12695607851","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"111504","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-10 16:45:11","reservation_modified_date_time":"2021-01-10 16:45:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111504","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":"3205006","reservation_id":"108642","confirmation_number":"SJ12682106033","room_confirmation_number":"SJ12669726894","room_stay_from":"2021-08-07","room_stay_to":"2021-08-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"115079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 15:23:07","reservation_modified_date_time":"2021-02-26 15:23:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115079","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":"3289744","reservation_id":"113748","confirmation_number":"SJ12684094158","room_confirmation_number":"SJ12658837013","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120364","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 02:36:17","reservation_modified_date_time":"2021-07-25 20:07:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114227","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":"3294598","reservation_id":"119852","confirmation_number":"SJ12677759140","room_confirmation_number":"SJ12698550119","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","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":"127050","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-22 18:33:32","reservation_modified_date_time":"2021-08-02 00:18:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127050","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":"3298918","reservation_id":"112802","confirmation_number":"SJ12654567861","room_confirmation_number":"SJ12673948594","room_stay_from":"2021-08-07","room_stay_to":"2021-08-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119393","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 21:31:45","reservation_modified_date_time":"2021-08-05 19:57: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":"3300022","reservation_id":"112803","confirmation_number":"SJ12670170606","room_confirmation_number":"SJ12611149682","room_stay_from":"2021-08-07","room_stay_to":"2021-08-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113117","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 21:35:59","reservation_modified_date_time":"2021-08-08 13:23:52","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":"3300275","reservation_id":"118500","confirmation_number":"SJ12643775789","room_confirmation_number":"SJ12667507574","room_stay_from":"2021-08-09","room_stay_to":"2021-08-14","room_stay_status":"Active","nightly_price":"25.00,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":"125538","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-02 01:03:20","reservation_modified_date_time":"2021-08-09 00:24:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125538","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":"3251035","reservation_id":"111330","confirmation_number":"SJ12698715315","room_confirmation_number":"SJ12637351359","room_stay_from":"2021-08-08","room_stay_to":"2021-08-15","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":"117863","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 13:43:09","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":"3300380","reservation_id":"114265","confirmation_number":"SJ12674542282","room_confirmation_number":"SJ12644883494","room_stay_from":"2021-08-05","room_stay_to":"2021-08-09","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":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"120922","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-01 14:25:09","reservation_modified_date_time":"2021-08-09 14:21:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120922","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":"3300382","reservation_id":"114266","confirmation_number":"SJ12620051344","room_confirmation_number":"SJ12637466816","room_stay_from":"2021-08-05","room_stay_to":"2021-08-09","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":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"120923","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-01 14:25:13","reservation_modified_date_time":"2021-08-09 14:21:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120923","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":"3300428","reservation_id":"120925","confirmation_number":"SJ12661350622","room_confirmation_number":"SJ12652647959","room_stay_from":"2021-08-12","room_stay_to":"2021-08-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"128336","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-08 03:41:36","reservation_modified_date_time":"2021-08-09 15:24:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128336","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":"3300439","reservation_id":"120923","confirmation_number":"SJ12624907432","room_confirmation_number":"SJ12627898509","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"128334","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-08 02:26:22","reservation_modified_date_time":"2021-08-09 15:26:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128334","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":"3300492","reservation_id":"113834","confirmation_number":"SJ12653680424","room_confirmation_number":"SJ12655737749","room_stay_from":"2021-08-21","room_stay_to":"2021-08-23","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":"120460","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-25 13:07:17","reservation_modified_date_time":"2021-08-09 16:41:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120460","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":"3300713","reservation_id":"118841","confirmation_number":"SJ12677503860","room_confirmation_number":"SJ12648868931","room_stay_from":"2021-08-11","room_stay_to":"2021-08-15","room_stay_status":"Active","nightly_price":"25.00,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"125926","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-07 02:08:09","reservation_modified_date_time":"2021-08-09 21:53:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125926","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3300747","reservation_id":"108702","confirmation_number":"SJ12649453863","room_confirmation_number":"SJ12674341216","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","room_stay_status":"Active","nightly_price":"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":"115153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 01:46:00","reservation_modified_date_time":"2021-08-09 22:46:01","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":"Nightly price or discount changed","deltaChange":"-175.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3300353","reservation_id":"120917","confirmation_number":"SJ12692448160","room_confirmation_number":"SJ12633073506","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-08-09 13:13:43","reservation_modified_date_time":"2021-08-09 13:13:43","customer_id":"128325","parentCustTravId":"128325","customer_traveller_id":"128325","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-08-08","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"}]},{"room_stay_id":"3300652","reservation_id":"120991","confirmation_number":"SJ12689002713","room_confirmation_number":"SJ12694764655","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-09 19:49:31","reservation_modified_date_time":"2021-08-09 19:49:31","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3272887","reservation_id":"111341","confirmation_number":"SJ12671230953","room_confirmation_number":"SJ12656545344","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-24 13:50:09","reservation_modified_date_time":"2021-06-24 13:50:09","customer_id":"77106","parentCustTravId":"77106","customer_traveller_id":"117875","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-09 22:56:39","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-06-18","sub_hotel_id":"0","deltaChange":-25,"changedComment":"reservation is canceled","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}