{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-23","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":21,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1309,1310,1267,1268,1302,1303,1260,1261,1262,1263,1307,1308,1271,1272,1291,1711,1311,1312,1269,1270,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12691736929","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12640561526","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12645642842","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12699713763","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12670341344","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12675472684","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12678901416","room_stay_from":"2021-04-23","room_stay_to":"2021-04-24","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12632665660","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12675264719","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12647989130","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12695052303","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12638506996","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12663655670","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12667757878","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12644519252","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12622699145","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12687830099","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12672963789","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1305"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3202777","reservation_id":"108279","confirmation_number":"SJ12618475082","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"209.25,209.25,239.25","nightly_discount":"0,0,0","subtotal":"657.75","grand_total":"739.97","paid_amount":"739.97","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3849351446","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":"114738","customer_id":"114738","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 17:15:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"131.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226130","reservation_id":"109228","confirmation_number":"SJ12677972799","room_stay_from":"2021-04-18","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"191.3,191.3,191.3,191.3,191.3,289.3","nightly_discount":"0,0,0,0,0,0","subtotal":"1245.80","grand_total":"1401.53","paid_amount":"1401.53","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2114753229","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115696","customer_id":"115696","source_of_creation":"Booking.com","reservation_created_date":"2021-03-03 23:58:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"278.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"289.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":"3239158","reservation_id":"108276","confirmation_number":"SJ12644672036","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"209.25,209.25,239.25","nightly_discount":"0,0,0","subtotal":"657.75","grand_total":"739.97","paid_amount":"739.97","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3826223714","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":"114736","customer_id":"114736","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 17:11:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"131.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239162","reservation_id":"108247","confirmation_number":"SJ12695126762","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.58,154.58,181.58","nightly_discount":"0,0,0","subtotal":"490.74","grand_total":"552.09","paid_amount":"552.09","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-2642616403","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":"114715","customer_id":"114715","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 04:15:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"101.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.58","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":"3239354","reservation_id":"112649","confirmation_number":"SJ12640893806","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.20,343.20","nightly_discount":"0,0","subtotal":"630.40","grand_total":"709.20","paid_amount":"709.20","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-2869593074","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":"119239","customer_id":"119239","source_of_creation":"Booking.com","reservation_created_date":"2021-04-11 02:13:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"122.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.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":"3239854","reservation_id":"113645","confirmation_number":"SJ12675366204","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"258.48,308.88","nightly_discount":"0,0","subtotal":"567.36","grand_total":"638.28","paid_amount":"638.28","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2840477415","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":"120245","customer_id":"120245","source_of_creation":"Booking.com","reservation_created_date":"2021-04-22 18:42:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"111.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"308.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202409","reservation_id":"108217","confirmation_number":"SJ12638182436","room_stay_from":"2021-04-19","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,198.80,198.80,226.80,226.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1248.80","grand_total":"1404.90","paid_amount":"1404.90","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2539077142","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":"114681","customer_id":"114681","source_of_creation":"Booking.com","reservation_created_date":"2021-02-21 22:29:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"251.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202451","reservation_id":"108225","confirmation_number":"SJ12613420122","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"214.89,214.89,237.57,237.57","nightly_discount":"0,0,0,0","subtotal":"904.92","grand_total":"1018.04","paid_amount":"1018.04","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-2246854454","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":"114689","customer_id":"114689","source_of_creation":"Booking.com","reservation_created_date":"2021-02-21 23:57:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"180.89","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"237.57","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":"3224875","reservation_id":"111647","confirmation_number":"SJ12676671886","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"280.28,280.28","nightly_discount":"0,0","subtotal":"560.56","grand_total":"630.63","paid_amount":"630.63","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2118791052","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118204","customer_id":"118204","source_of_creation":"Booking.com","reservation_created_date":"2021-03-30 00:41:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"118.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"280.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227334","reservation_id":"108303","confirmation_number":"SJ12676952612","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,188.30,188.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-3154242148","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":"114760","customer_id":"114760","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 19:45:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"143.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227434","reservation_id":"112015","confirmation_number":"SJ12637358043","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,295.20","nightly_discount":"0,0","subtotal":"614.40","grand_total":"691.20","paid_amount":"691.20","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-2230584265","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":"118584","customer_id":"118584","source_of_creation":"Booking.com","reservation_created_date":"2021-04-03 21:54:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"119.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"319.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":"3229261","reservation_id":"110895","confirmation_number":"SJ12686447493","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"216.30,230.30,300.30,300.30","nightly_discount":"0,0,0,0","subtotal":"1047.20","grand_total":"1178.10","paid_amount":"1178.10","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3503900236","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":"117415","customer_id":"117415","source_of_creation":"Booking.com","reservation_created_date":"2021-03-21 18:11:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"206.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"300.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":"3235181","reservation_id":"112219","confirmation_number":"SJ12683107318","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,319.20","nightly_discount":"0,0","subtotal":"662.40","grand_total":"745.20","paid_amount":"745.20","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-2800030428","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":"118786","customer_id":"118786","source_of_creation":"Booking.com","reservation_created_date":"2021-04-06 01:30:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"128.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.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":"3200962","reservation_id":"108044","confirmation_number":"SJ12664906924","room_stay_from":"2021-04-23","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.25,224.25,194.25","nightly_discount":"0,0,0","subtotal":"642.75","grand_total":"723.10","paid_amount":"723.10","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3090934456","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":"114509","customer_id":"114509","source_of_creation":"Booking.com","reservation_created_date":"2021-02-19 16:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"129.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226268","reservation_id":"111868","confirmation_number":"SJ12634104097","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"273.32,253.07,205.83,205.83","nightly_discount":"0,0,0,0","subtotal":"938.05","grand_total":"1055.30","paid_amount":"1055.30","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3495364224","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118433","customer_id":"118433","source_of_creation":"Booking.com","reservation_created_date":"2021-04-02 01:48:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"222.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"273.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203653","reservation_id":"106362","confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,188.37,188.37,163.17,163.17,163.17","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1192.59","grand_total":"1341.66","paid_amount":"1341.66","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2673763646","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":"112757","customer_id":"112757","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 23:36:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"246.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.17","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3205394","reservation_id":"108719","confirmation_number":"SJ12658256285","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.56,210.56","nightly_discount":"0,0","subtotal":"389.12","grand_total":"437.76","paid_amount":"437.76","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1742141562","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":"115167","customer_id":"115167","source_of_creation":"Expedia","reservation_created_date":"2021-02-27 13:07:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"210.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215045","reservation_id":"110209","confirmation_number":"SJ12672875391","room_stay_from":"2021-04-19","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.04,145.04,167.44,184.24,223.44","nightly_discount":"0,0,0,0,0","subtotal":"865.20","grand_total":"973.35","paid_amount":"973.35","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1747173784","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":"116722","customer_id":"116722","source_of_creation":"Expedia","reservation_created_date":"2021-03-13 17:22:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235175","reservation_id":"108485","confirmation_number":"SJ12648436924","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.40,167.40,197.40","nightly_discount":"0,0,0","subtotal":"532.20","grand_total":"598.73","paid_amount":"598.73","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1741250027","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":"114931","customer_id":"114931","source_of_creation":"Expedia","reservation_created_date":"2021-02-24 21:37:08","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":"197.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":"3214804","reservation_id":"110177","confirmation_number":"SJ12610644402","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"332.16,332.16","nightly_discount":"0,0","subtotal":"664.32","grand_total":"747.36","paid_amount":"747.36","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1746980337","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":"116693","customer_id":"116693","source_of_creation":"Expedia","reservation_created_date":"2021-03-13 02:07:08","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":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"332.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216934","reservation_id":"110454","confirmation_number":"SJ12689106582","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,230.30,279.30,279.30","nightly_discount":"0,0,0,0","subtotal":"998.20","grand_total":"1122.98","paid_amount":"1122.98","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1748439431","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":"116966","customer_id":"116966","source_of_creation":"Expedia","reservation_created_date":"2021-03-16 22:38:09","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"279.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":"3220546","reservation_id":"110957","confirmation_number":"SJ12682071756","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"290.56,290.56","nightly_discount":"0,0","subtotal":"581.12","grand_total":"653.76","paid_amount":"653.76","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1750678637","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":"117494","customer_id":"117494","source_of_creation":"Expedia","reservation_created_date":"2021-03-22 13:37:14","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"290.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226152","reservation_id":"109826","confirmation_number":"SJ12686591222","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.40,239.40,239.40","nightly_discount":"0,0,0","subtotal":"634.20","grand_total":"713.48","paid_amount":"713.48","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1745483806","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":"116317","customer_id":"116317","source_of_creation":"Expedia","reservation_created_date":"2021-03-09 03:17:10","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":"126","group_rooms":null,"currentDayPrice":"239.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":"3229705","reservation_id":"110622","confirmation_number":"SJ12680227760","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.40,254.40,254.40","nightly_discount":"0,0,0","subtotal":"721.20","grand_total":"811.35","paid_amount":"811.35","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1749117851","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":"117133","customer_id":"117133","source_of_creation":"Expedia","reservation_created_date":"2021-03-18 14:47:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"254.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":"3236956","reservation_id":"108124","confirmation_number":"SJ12696320667","room_stay_from":"2021-04-19","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0,0","subtotal":"961.80","grand_total":"1082.03","paid_amount":"1082.03","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1739968816","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":"114586","customer_id":"114586","source_of_creation":"Expedia","reservation_created_date":"2021-02-20 18:42:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239261","reservation_id":"111503","confirmation_number":"SJ12613375479","room_stay_from":"2021-04-23","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.40,257.40,197.40","nightly_discount":"0,0,0","subtotal":"712.20","grand_total":"801.23","paid_amount":"801.23","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1753076821","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":"118071","customer_id":"118071","source_of_creation":"Expedia","reservation_created_date":"2021-03-28 15:37: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":"126","group_rooms":null,"currentDayPrice":"257.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3219682","reservation_id":"110837","confirmation_number":"SJ12628923868","room_stay_from":"2021-04-20","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.55,166.55,177.33,231.23","nightly_discount":"0,0,0,0","subtotal":"741.66","grand_total":"834.36","paid_amount":"834.36","room_type_id":"319","product_id":"1306","siteminder_id":"GAM-R2396440968","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":"117360","customer_id":"117360","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-20 21:37:09","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"231.23","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":"3237757","reservation_id":"107496","confirmation_number":"SJ12626501032","room_stay_from":"2021-04-19","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.08,153.08,153.08,153.08,174.64","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"786.96","grand_total":"885.33","paid_amount":"885.33","room_type_id":"411","product_id":"1296","siteminder_id":"GAM-R2325619527","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":"113954","customer_id":"113954","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-13 01:14:10","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.64","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239913","reservation_id":"107176","confirmation_number":"SJ12625470628","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.70,165.70","nightly_discount":"0,0","subtotal":"331.40","grand_total":"372.83","paid_amount":"372.83","room_type_id":"319","product_id":"1277","siteminder_id":"GAM-R2317700545","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":"113635","customer_id":"113635","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-08 21:34:12","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":"165.70","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":"3208470","reservation_id":"109233","confirmation_number":"SJ12672816426","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.02,243.38,243.38,163.02","nightly_discount":"0,0,0,0","subtotal":"812.80","grand_total":"914.40","paid_amount":"914.40","room_type_id":"412","product_id":"1316","siteminder_id":"GAM-R2360305570","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":"115701","customer_id":"115701","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-04 00:14:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"243.38","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3238314","reservation_id":"107635","confirmation_number":"SJ12614501894","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"360.06,360.06,353.69","nightly_discount":"0.00,0.00,0.00","subtotal":"1073.81","grand_total":"1244.39","paid_amount":"1244.39","room_type_id":"320","product_id":"1322","siteminder_id":"ABB-HMMBA38YB3","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1080.18","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114092","customer_id":"114092","source_of_creation":"Airbnb","reservation_created_date":"2021-02-14 21:53:06","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"31.77","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"353.69","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3238326","reservation_id":"108417","confirmation_number":"SJ12680090526","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"381.48,381.48,374.61","nightly_discount":"0.00,0.00,0.00","subtotal":"1137.57","grand_total":"1318.30","paid_amount":"1318.30","room_type_id":"320","product_id":"1328","siteminder_id":"ABB-HMAD2ZEJCW","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1144.44","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114871","customer_id":"114871","source_of_creation":"Airbnb","reservation_created_date":"2021-02-23 23:50:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"33.66","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"374.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3240298","reservation_id":"108520","confirmation_number":"SJ12664814010","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"8","room_stay_child_count":"0","nightly_price":"414.08,407.91","nightly_discount":"0.00,0.00","subtotal":"821.99","grand_total":"983.15","paid_amount":"983.15","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMF3DYCNXA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"828.16","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114960","customer_id":"114960","source_of_creation":"Airbnb","reservation_created_date":"2021-02-25 05:20:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"30.24","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"414.08","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":"3240281","reservation_id":"112334","confirmation_number":"SJ12694083777","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"340.94,340.94,340.94,332.76","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1355.58","grand_total":"1570.94","paid_amount":"1570.94","room_type_id":"319","product_id":"1913","siteminder_id":"ABB-HMFJHT24ZH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1363.76","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118903","customer_id":"118903","source_of_creation":"Airbnb","reservation_created_date":"2021-04-07 15:26:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"40.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"340.94","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":"3203889","reservation_id":"108477","confirmation_number":"SJ12658659294","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.00,265.50,265.50,228.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114923","customer_id":"114923","source_of_creation":"FE","reservation_created_date":"2021-02-24 20:25:52","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3221405","reservation_id":"110687","confirmation_number":"SJ12629677888","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,224.25,224.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1047.00","grand_total":"1177.88","paid_amount":"1177.88","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":"117198","customer_id":"117198","source_of_creation":"FE","reservation_created_date":"2021-03-19 03:42:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"299.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3137355","reservation_id":"100420","confirmation_number":"SJ12678073836","room_stay_from":"2021-04-17","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.00,212.00,212.00,212.00,212.00,212.00,277.00","nightly_discount":"27.70,21.20,21.10,21.10,21.10,21.10,27.70","subtotal":"1614.00","grand_total":"1634.63","paid_amount":"1634.63","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":"106453","customer_id":"106453","source_of_creation":"PMS","reservation_created_date":"2020-09-15 22:12:31","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"277.00","currentDayDiscount":"27.70","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229975","reservation_id":"111702","confirmation_number":"SJ12637617282","room_stay_from":"2021-04-23","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0.00","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","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":"118262","customer_id":"118262","source_of_creation":"PMS","reservation_created_date":"2021-03-30 19:00:29","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":"364.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":"3239000","reservation_id":"108546","confirmation_number":"SJ12654074847","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.25,209.25,246.75","nightly_discount":"10.46,10.46,12.34","subtotal":"665.25","grand_total":"710.99","paid_amount":"710.99","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114982","customer_id":"114982","source_of_creation":"PMS","reservation_created_date":"2021-02-25 16:15:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"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":"3239272","reservation_id":"110797","confirmation_number":"SJ12667407905","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"381.48,381.48,381.48","nightly_discount":"0.00,0.00,0.00","subtotal":"1144.44","grand_total":"1287.49","paid_amount":"1287.49","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":"117308","customer_id":"117308","source_of_creation":"PMS","reservation_created_date":"2021-03-20 14:52:15","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"381.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239895","reservation_id":"113646","confirmation_number":"SJ12659687085","room_stay_from":"2021-04-23","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0.00","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120247","customer_id":"120247","source_of_creation":"PMS","reservation_created_date":"2021-04-22 19:25:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"364.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":"3239897","reservation_id":"113646","confirmation_number":"SJ12677794769","room_stay_from":"2021-04-23","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0.00","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120247","customer_id":"120247","source_of_creation":"PMS","reservation_created_date":"2021-04-22 19:25:14","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":"364.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":"3205317","reservation_id":"108706","confirmation_number":"SJ12650908962","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,336.75,336.75","nightly_discount":"0.00,0.00,0.00","subtotal":"972.75","grand_total":"1094.35","paid_amount":"1094.35","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115155","customer_id":"115155","source_of_creation":"PMS","reservation_created_date":"2021-02-27 02:10:44","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"336.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":"3240654","reservation_id":"112293","confirmation_number":"SJ12666603069","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"300.30,300.30","nightly_discount":"0.00,0.00","subtotal":"600.60","grand_total":"675.68","paid_amount":"675.68","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118860","customer_id":"118860","source_of_creation":"PMS","reservation_created_date":"2021-04-07 00:23:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"300.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3211138","reservation_id":"108700","confirmation_number":"SJ12691038258","room_stay_from":"2021-04-18","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1159.00","grand_total":"1159.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-27 01:30:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"165.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3236954","reservation_id":"100701","confirmation_number":"SJ12688302981","room_stay_from":"2021-04-22","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"462.00","grand_total":"462.00","paid_amount":"140.63","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-09-22 00:31:37","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3204806","reservation_id":"108591","confirmation_number":"SJ12653667920","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"0.00","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-02-26 01:25:32","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":"3215882","reservation_id":"108592","confirmation_number":"SJ12694732411","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"685.13","paid_amount":"196.88","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:27:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185832","reservation_id":"95536","confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"869.99","grand_total":"869.99","paid_amount":"281.25","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":"2020-05-28 14:11:36","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":"87.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":"3229909","reservation_id":"95534","confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1219.96","grand_total":"1219.96","paid_amount":"393.75","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-28 14:06:38","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":"87.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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3226131","reservation_id":"109228","confirmation_number":"SJ12687361185","room_confirmation_number":"SJ12677972799","room_stay_from":"2021-04-18","room_stay_to":"2021-04-24","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":"1777","service_quantity":"1","customer_traveller_id":"115696","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-01 21:02:03","reservation_modified_date_time":"2021-04-01 21:02:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115696","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239275","reservation_id":"110797","confirmation_number":"SJ12679690694","room_confirmation_number":"SJ12667407905","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"117308","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-21 22:30:41","reservation_modified_date_time":"2021-04-21 22:30:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117308","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204211","reservation_id":"108520","confirmation_number":"SJ12692572338","room_confirmation_number":"SJ12664814010","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"100,100","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"201.20","paid_amount":"201.20","product_id":"1777","service_quantity":"1","customer_traveller_id":"114960","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-02-25 05:20:11","reservation_modified_date_time":"2021-02-25 05:20:11","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114960","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","sub_hotel_id":"126","currentDayPrice":"100","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":"3224876","reservation_id":"111647","confirmation_number":"SJ12612705445","room_confirmation_number":"SJ12676671886","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"118204","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-30 00:41:10","reservation_modified_date_time":"2021-03-30 00:41:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118204","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3237124","reservation_id":"112293","confirmation_number":"SJ12622984404","room_confirmation_number":"SJ12666603069","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"118860","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-19 00:21:25","reservation_modified_date_time":"2021-04-19 00:21:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118860","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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"}]},{"room_stay_id":"3226269","reservation_id":"111868","confirmation_number":"SJ12629374574","room_confirmation_number":"SJ12634104097","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","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":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"118433","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-02 01:48:12","reservation_modified_date_time":"2021-04-02 01:48:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118433","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3137356","reservation_id":"100420","confirmation_number":"SJ12640625081","room_confirmation_number":"SJ12678073836","room_stay_from":"2021-04-17","room_stay_to":"2021-04-24","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":"106453","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-15 22:12:31","reservation_modified_date_time":"2020-09-16 14:52:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106453","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":"3202778","reservation_id":"108279","confirmation_number":"SJ12682170043","room_confirmation_number":"SJ12618475082","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114738","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 17:15:14","reservation_modified_date_time":"2021-02-22 17:59:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114738","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":"3205395","reservation_id":"108719","confirmation_number":"SJ12656705513","room_confirmation_number":"SJ12658256285","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","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":"115167","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 13:07:07","reservation_modified_date_time":"2021-02-27 13:07:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115167","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":"3215046","reservation_id":"110209","confirmation_number":"SJ12678620265","room_confirmation_number":"SJ12672875391","room_stay_from":"2021-04-19","room_stay_to":"2021-04-24","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":"116722","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 17:22:12","reservation_modified_date_time":"2021-03-13 17:22:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116722","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":"3219683","reservation_id":"110837","confirmation_number":"SJ12624059455","room_confirmation_number":"SJ12628923868","room_stay_from":"2021-04-20","room_stay_to":"2021-04-24","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":"117360","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 21:37:09","reservation_modified_date_time":"2021-03-20 21:37:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117360","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":"3226132","reservation_id":"109228","confirmation_number":"SJ12661167663","room_confirmation_number":"SJ12677972799","room_stay_from":"2021-04-18","room_stay_to":"2021-04-24","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":"115696","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:58:12","reservation_modified_date_time":"2021-04-01 21:02:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115696","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229347","reservation_id":"108546","confirmation_number":"SJ12610971869","room_confirmation_number":"SJ12654074847","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","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":"114982","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 16:15:20","reservation_modified_date_time":"2021-04-07 02:52:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114982","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":"3229976","reservation_id":"111702","confirmation_number":"SJ12671043914","room_confirmation_number":"SJ12637617282","room_stay_from":"2021-04-23","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"118262","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 19:00:29","reservation_modified_date_time":"2021-04-07 19:46:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118262","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":"3235176","reservation_id":"108485","confirmation_number":"SJ12697536030","room_confirmation_number":"SJ12648436924","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","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":"114931","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 21:37:08","reservation_modified_date_time":"2021-04-15 23:05:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114931","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":"3237758","reservation_id":"107496","confirmation_number":"SJ12671910824","room_confirmation_number":"SJ12626501032","room_stay_from":"2021-04-19","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"25.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"113954","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-13 01:14:10","reservation_modified_date_time":"2021-04-19 21:38:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113954","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":"3238317","reservation_id":"107635","confirmation_number":"SJ12687941392","room_confirmation_number":"SJ12614501894","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","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":"114092","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 21:53:06","reservation_modified_date_time":"2021-04-21 12:12:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114092","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":"3238329","reservation_id":"108417","confirmation_number":"SJ12659003147","room_confirmation_number":"SJ12680090526","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","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":"114871","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 23:50:14","reservation_modified_date_time":"2021-04-21 12:14:39","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114871","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":"3239161","reservation_id":"108276","confirmation_number":"SJ12661582960","room_confirmation_number":"SJ12644672036","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","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":"114736","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 17:11:09","reservation_modified_date_time":"2021-04-21 21:02:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114736","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":"3239163","reservation_id":"108247","confirmation_number":"SJ12675950755","room_confirmation_number":"SJ12695126762","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","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":"114715","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 04:15:10","reservation_modified_date_time":"2021-04-21 21:02:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114715","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":"3239276","reservation_id":"110797","confirmation_number":"SJ12618326822","room_confirmation_number":"SJ12667407905","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","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":"117308","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 14:52:15","reservation_modified_date_time":"2021-04-21 22:30:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117308","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":"3239355","reservation_id":"112649","confirmation_number":"SJ12626097145","room_confirmation_number":"SJ12640893806","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","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":"119239","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-11 02:13:08","reservation_modified_date_time":"2021-04-22 00:47:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119239","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":"3239855","reservation_id":"113645","confirmation_number":"SJ12677960734","room_confirmation_number":"SJ12675366204","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","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":"120245","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 18:42:08","reservation_modified_date_time":"2021-04-22 18:42:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120245","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":"3239896","reservation_id":"113646","confirmation_number":"SJ12679926325","room_confirmation_number":"SJ12659687085","room_stay_from":"2021-04-23","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"120247","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 19:25:14","reservation_modified_date_time":"2021-04-22 19:25:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120247","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":"3239898","reservation_id":"113646","confirmation_number":"SJ12691212980","room_confirmation_number":"SJ12677794769","room_stay_from":"2021-04-23","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"120247","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 19:25:14","reservation_modified_date_time":"2021-04-22 19:25:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120247","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":"3202410","reservation_id":"108217","confirmation_number":"SJ12697238969","room_confirmation_number":"SJ12638182436","room_stay_from":"2021-04-19","room_stay_to":"2021-04-25","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":"114681","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 22:29:08","reservation_modified_date_time":"2021-02-21 22:29:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114681","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":"3202452","reservation_id":"108225","confirmation_number":"SJ12682473531","room_confirmation_number":"SJ12613420122","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","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":"114689","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 23:57:11","reservation_modified_date_time":"2021-02-21 23:57:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114689","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":"3205318","reservation_id":"108706","confirmation_number":"SJ12611926018","room_confirmation_number":"SJ12650908962","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","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":"115155","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 02:10:44","reservation_modified_date_time":"2021-02-27 02:10:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115155","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":"3211137","reservation_id":"108700","confirmation_number":"SJ12684099128","room_confirmation_number":"SJ12691038258","room_stay_from":"2021-04-18","room_stay_to":"2021-04-25","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":"115151","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 01:30:49","reservation_modified_date_time":"2021-03-07 15:18:15","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":"3214805","reservation_id":"110177","confirmation_number":"SJ12694322277","room_confirmation_number":"SJ12610644402","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","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":"116693","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 02:07:08","reservation_modified_date_time":"2021-03-13 02:07:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116693","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":"3216935","reservation_id":"110454","confirmation_number":"SJ12616414655","room_confirmation_number":"SJ12689106582","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","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":"116966","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 22:38:09","reservation_modified_date_time":"2021-03-16 22:38:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116966","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":"3220545","reservation_id":"110957","confirmation_number":"SJ12645038260","room_confirmation_number":"SJ12682071756","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","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":"117494","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 13:37:14","reservation_modified_date_time":"2021-03-22 13:37:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117494","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":"3224877","reservation_id":"111647","confirmation_number":"SJ12631040336","room_confirmation_number":"SJ12676671886","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","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":"118204","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 00:41:10","reservation_modified_date_time":"2021-03-30 00:41:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118204","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226153","reservation_id":"109826","confirmation_number":"SJ12674740515","room_confirmation_number":"SJ12686591222","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","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":"116317","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 03:17:10","reservation_modified_date_time":"2021-04-01 21:08:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116317","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":"3227335","reservation_id":"108303","confirmation_number":"SJ12657784253","room_confirmation_number":"SJ12676952612","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","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":"114760","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 19:45:11","reservation_modified_date_time":"2021-04-03 20:40:49","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114760","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":"3227435","reservation_id":"112015","confirmation_number":"SJ12693407127","room_confirmation_number":"SJ12637358043","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","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":"118584","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 21:54:08","reservation_modified_date_time":"2021-04-03 21:54:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118584","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":"3229262","reservation_id":"110895","confirmation_number":"SJ12699577904","room_confirmation_number":"SJ12686447493","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117415","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 18:11:13","reservation_modified_date_time":"2021-04-07 00:06:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117415","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":"3229706","reservation_id":"110622","confirmation_number":"SJ12631021197","room_confirmation_number":"SJ12680227760","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","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":"117133","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 14:47:09","reservation_modified_date_time":"2021-04-07 16:39:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117133","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":"3235182","reservation_id":"112219","confirmation_number":"SJ12615270533","room_confirmation_number":"SJ12683107318","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","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":"118786","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-06 01:30:12","reservation_modified_date_time":"2021-04-15 23:05:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118786","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":"3236957","reservation_id":"108124","confirmation_number":"SJ12675583552","room_confirmation_number":"SJ12696320667","room_stay_from":"2021-04-19","room_stay_to":"2021-04-25","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":"114586","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-20 18:42:13","reservation_modified_date_time":"2021-04-18 18:15:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114586","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":"3239914","reservation_id":"107176","confirmation_number":"SJ12627057106","room_confirmation_number":"SJ12625470628","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","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":"113635","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-08 21:34:12","reservation_modified_date_time":"2021-04-22 19:58:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113635","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":"3240301","reservation_id":"108520","confirmation_number":"SJ12654551620","room_confirmation_number":"SJ12664814010","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114960","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 05:20:11","reservation_modified_date_time":"2021-04-23 15:13:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114960","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":"3240652","reservation_id":"112293","confirmation_number":"SJ12618630390","room_confirmation_number":"SJ12666603069","room_stay_from":"2021-04-23","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118861","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 00:23:12","reservation_modified_date_time":"2021-04-23 23:06:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118860","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":"3200963","reservation_id":"108044","confirmation_number":"SJ12656269578","room_confirmation_number":"SJ12664906924","room_stay_from":"2021-04-23","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114509","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-19 16:13:10","reservation_modified_date_time":"2021-02-19 16:16:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114509","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":"3203890","reservation_id":"108477","confirmation_number":"SJ12669079365","room_confirmation_number":"SJ12658659294","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","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":"114923","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 20:25:52","reservation_modified_date_time":"2021-02-24 20:25:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114923","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":"3208471","reservation_id":"109233","confirmation_number":"SJ12640303614","room_confirmation_number":"SJ12672816426","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","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":"115701","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:14:12","reservation_modified_date_time":"2021-03-04 00:14:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115701","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":"3239262","reservation_id":"111503","confirmation_number":"SJ12687305635","room_confirmation_number":"SJ12613375479","room_stay_from":"2021-04-23","room_stay_to":"2021-04-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"118071","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 15:37:08","reservation_modified_date_time":"2021-04-21 22:26:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118071","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":"3221406","reservation_id":"110687","confirmation_number":"SJ12614112515","room_confirmation_number":"SJ12629677888","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","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":"117198","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 03:42:53","reservation_modified_date_time":"2021-03-24 01:08:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117198","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":"3226270","reservation_id":"111868","confirmation_number":"SJ12646682984","room_confirmation_number":"SJ12634104097","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","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":"118433","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-02 01:48:12","reservation_modified_date_time":"2021-04-02 01:48:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118433","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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":"3236955","reservation_id":"100701","confirmation_number":"SJ12652259620","room_confirmation_number":"SJ12688302981","room_stay_from":"2021-04-22","room_stay_to":"2021-04-27","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":"106727","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-22 00:31:37","reservation_modified_date_time":"2021-04-18 18:15:30","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":"3240282","reservation_id":"112334","confirmation_number":"SJ12694489162","room_confirmation_number":"SJ12694083777","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","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":"118903","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 15:26:29","reservation_modified_date_time":"2021-04-23 15:08:59","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118903","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":"3203654","reservation_id":"106362","confirmation_number":"SJ12667638930","room_confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"112757","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 23:36:12","reservation_modified_date_time":"2021-02-24 15:20:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112757","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":"3204807","reservation_id":"108591","confirmation_number":"SJ12659138449","room_confirmation_number":"SJ12653667920","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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":"115029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:25:32","reservation_modified_date_time":"2021-02-26 01:25:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215883","reservation_id":"108592","confirmation_number":"SJ12639140046","room_confirmation_number":"SJ12694732411","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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":"115030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:27:18","reservation_modified_date_time":"2021-03-15 01:48:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185833","reservation_id":"95536","confirmation_number":"SJ12671781895","room_confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:11:36","reservation_modified_date_time":"2021-01-27 21:49: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":"3229910","reservation_id":"95534","confirmation_number":"SJ12670678562","room_confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:06:38","reservation_modified_date_time":"2021-04-07 18:29:47","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[{"room_stay_id":"3240519","reservation_id":"108606","confirmation_number":"SJ12639795964","room_confirmation_number":"SJ12666036532","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"0.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-23 19:15:37","reservation_modified_date_time":"2021-04-23 19:15:37","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"115044","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-05-19","sub_hotel_id":"0","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}