{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-07-01","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":22,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1304,1286","block_room_bookings":[{"confirmation_number":"SJ12675759026","room_stay_from":"2021-06-29","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJ12645807054","room_stay_from":"2021-06-30","room_stay_to":"2021-07-07","bundle_room":"0","product_id":"1286"}],"bundle_block_count":"1309,1310,1271,1272,1260,1261,1307,1308,1269,1270,1262,1263,1291,1711,1267,1268,1311,1312,1304,1305,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12664546988","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12690154160","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12691702315","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12655400355","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12655144040","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12618783356","room_stay_from":"2021-06-30","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12672385239","room_stay_from":"2021-06-30","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12679042220","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12694543091","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12616130265","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12672374981","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12635840573","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12688303794","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12667005822","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12644699058","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12684629838","room_stay_from":"2021-06-29","room_stay_to":"2021-07-04","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12622350821","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12676664296","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3228496","reservation_id":"112124","confirmation_number":"SJ12617525714","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"265.30,265.30,265.30,279.30","nightly_discount":"0,0,0,0","subtotal":"1075.20","grand_total":"1209.60","paid_amount":"1209.60","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-2357570489","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":"118693","customer_id":"118693","source_of_creation":"Booking.com","reservation_created_date":"2021-04-04 23:35:17","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1271,1272","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":"3231742","reservation_id":"112574","confirmation_number":"SJ12675456502","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.27,144.27,144.27,144.27,144.27","nightly_discount":"0,0,0,0,0","subtotal":"721.35","grand_total":"811.52","paid_amount":"811.52","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2161126573","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":"119153","customer_id":"119153","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 02:14:24","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"144.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240562","reservation_id":"113719","confirmation_number":"SJ12617869053","room_stay_from":"2021-06-26","room_stay_to":"2021-07-02","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,181.30,181.30,181.30,181.30,195.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1150.80","grand_total":"1294.65","paid_amount":"1294.65","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3790806539","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":"120330","customer_id":"120330","source_of_creation":"Booking.com","reservation_created_date":"2021-04-23 18:43:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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":"3249760","reservation_id":"114970","confirmation_number":"SJ12664749078","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.92,178.92,178.92,178.92,191.52","nightly_discount":"0,0,0,0,0","subtotal":"907.20","grand_total":"1020.60","paid_amount":"1020.60","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-2337402390","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":"121691","customer_id":"121691","source_of_creation":"Booking.com","reservation_created_date":"2021-05-11 01:14:09","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"185.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"191.52","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":"3252225","reservation_id":"113305","confirmation_number":"SJ12629389107","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"181.30,181.30,181.30,181.30","nightly_discount":"0,0,0,0","subtotal":"725.20","grand_total":"815.85","paid_amount":"815.85","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2576395432","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":"119889","customer_id":"119889","source_of_creation":"Booking.com","reservation_created_date":"2021-04-18 17:07:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"151.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3274702","reservation_id":"116254","confirmation_number":"SJ12616701735","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.15","nightly_discount":"0","subtotal":"237.15","grand_total":"266.80","paid_amount":"266.80","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-3473704743","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":"123113","customer_id":"123113","source_of_creation":"Booking.com","reservation_created_date":"2021-05-31 17:16:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"47.19","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"237.15","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276316","reservation_id":"118439","confirmation_number":"SJ12643051345","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"253.15","nightly_discount":"0","subtotal":"253.15","grand_total":"284.80","paid_amount":"284.80","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-3991083519","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125472","customer_id":"125472","source_of_creation":"Booking.com","reservation_created_date":"2021-07-01 02:55:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"54.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"253.15","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3224415","reservation_id":"111572","confirmation_number":"SJ12697294787","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"279.30,314.30,314.30,314.30","nightly_discount":"0,0,0,0","subtotal":"1222.20","grand_total":"1374.98","paid_amount":"1374.98","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-2755994797","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":"118130","customer_id":"118130","source_of_creation":"Booking.com","reservation_created_date":"2021-03-29 03:21:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"238.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","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":"3233507","reservation_id":"112476","confirmation_number":"SJ12669647181","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"198.02,229.52,229.52,229.52","nightly_discount":"0,0,0,0","subtotal":"886.58","grand_total":"997.40","paid_amount":"997.40","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3404464107","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119048","customer_id":"119048","source_of_creation":"Booking.com","reservation_created_date":"2021-04-08 23:22:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"391.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.02","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":"3233512","reservation_id":"112476","confirmation_number":"SJ12620609595","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"223.02,254.52,254.52,254.52","nightly_discount":"0,0,0,0","subtotal":"986.58","grand_total":"1109.90","paid_amount":"1109.90","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3404464107","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":"119048","customer_id":"119048","source_of_creation":"Booking.com","reservation_created_date":"2021-04-08 23:22:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"391.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.02","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":"3233520","reservation_id":"112404","confirmation_number":"SJ12660249731","room_stay_from":"2021-07-01","room_stay_to":"2021-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,230.30,230.30,230.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"1046.50","grand_total":"1177.32","paid_amount":"1177.32","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3214038580","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":"118977","customer_id":"118977","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 23:53:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"210.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3228473","reservation_id":"111976","confirmation_number":"SJ12697263046","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.24,128.24,128.24,139.44","nightly_discount":"0,0,0,0","subtotal":"524.16","grand_total":"589.68","paid_amount":"589.68","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1755389957","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":"118540","customer_id":"118540","source_of_creation":"Expedia","reservation_created_date":"2021-04-03 13:57:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3236459","reservation_id":"112835","confirmation_number":"SJ12694326082","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,174.30","nightly_discount":"0,0,0,0","subtotal":"655.20","grand_total":"737.10","paid_amount":"737.10","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1758913165","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":"119419","customer_id":"119419","source_of_creation":"Expedia","reservation_created_date":"2021-04-13 00:09:43","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":"174.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":"3274896","reservation_id":"112143","confirmation_number":"SJ12668996453","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.24,128.24,128.24,139.44","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"524.16","grand_total":"589.68","paid_amount":"589.68","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1755976586","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":"118712","customer_id":"118712","source_of_creation":"Expedia","reservation_created_date":"2021-04-05 12:52:12","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":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3275792","reservation_id":"113607","confirmation_number":"SJ12678732883","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.32","nightly_discount":"0","subtotal":"169.32","grand_total":"190.49","paid_amount":"190.49","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1762379211","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":"120210","customer_id":"120210","source_of_creation":"Expedia","reservation_created_date":"2021-04-22 03:10:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"169.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":"3246200","reservation_id":"114423","confirmation_number":"SJ12689062824","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","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,212.80,296.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1304.80","grand_total":"1467.90","paid_amount":"1467.90","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1766568511","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":"121098","customer_id":"121098","source_of_creation":"Expedia","reservation_created_date":"2021-05-03 15:45:17","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"212.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":"3275552","reservation_id":"113861","confirmation_number":"SJ12661440393","room_stay_from":"2021-06-29","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"181.30,181.30,195.30,279.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"837.20","grand_total":"941.85","paid_amount":"941.85","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1763596228","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":"120485","customer_id":"120485","source_of_creation":"Expedia","reservation_created_date":"2021-04-25 17:44:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3233541","reservation_id":"112167","confirmation_number":"SJ12628638523","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.00,265.50,265.50","nightly_discount":"0,0,0","subtotal":"759.00","grand_total":"853.88","paid_amount":"853.88","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1756065598","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":"118739","customer_id":"118739","source_of_creation":"Expedia","reservation_created_date":"2021-04-05 17:47:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"228.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235863","reservation_id":"113153","confirmation_number":"SJ12610349241","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.25,299.25,299.25","nightly_discount":"0,0,0","subtotal":"807.75","grand_total":"908.72","paid_amount":"908.72","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1760488135","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":"119743","customer_id":"119743","source_of_creation":"Expedia","reservation_created_date":"2021-04-17 00:18: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":"209.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":"3272432","reservation_id":"111666","confirmation_number":"SJ12610771285","room_stay_from":"2021-06-30","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,195.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0","subtotal":"1067.50","grand_total":"1200.94","paid_amount":"1200.94","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1753740236","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":"118222","customer_id":"118222","source_of_creation":"Expedia","reservation_created_date":"2021-03-30 04:17:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3276109","reservation_id":"118415","confirmation_number":"SJ12616856730","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"219.19","nightly_discount":"0","subtotal":"219.19","grand_total":"246.59","paid_amount":"246.59","room_type_id":"318","product_id":"1282","siteminder_id":"HTN-165930098-3XYPXG","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":"125443","customer_id":"125443","source_of_creation":"HotelTonight","reservation_created_date":"2021-06-30 21:10:07","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"219.19","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3275003","reservation_id":"111476","confirmation_number":"SJ12677242204","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"139.60,139.60,139.60,139.60,150.38,177.33,177.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1063.44","grand_total":"1196.37","paid_amount":"1196.37","room_type_id":"318","product_id":"1281","siteminder_id":"GAM-R2411890958","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":"125295","customer_id":"125295","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-28 00:09:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"150.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3274241","reservation_id":"114944","confirmation_number":"SJ12680919922","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"301.87,313.14,313.14,313.14,313.14,313.14","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1867.57","grand_total":"2164.26","paid_amount":"2164.26","room_type_id":"319","product_id":"1942","siteminder_id":"ABB-HMEJRRDNKW","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1878.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121666","customer_id":"121666","source_of_creation":"Airbnb","reservation_created_date":"2021-05-10 20:59:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"55.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"313.14","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":"3276327","reservation_id":"117616","confirmation_number":"SJ12658291912","room_stay_from":"2021-07-01","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"352.72,357.00","nightly_discount":"0.00,0.00","subtotal":"709.72","grand_total":"822.47","paid_amount":"822.47","room_type_id":"319","product_id":"1301","siteminder_id":"ABB-HM3KS8QDMC","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"714.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124585","customer_id":"124585","source_of_creation":"Airbnb","reservation_created_date":"2021-06-19 10:38:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"21.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"352.72","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":"3232266","reservation_id":"112637","confirmation_number":"SJ12649037576","room_stay_from":"2021-06-30","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"322.15,339.15","nightly_discount":"0.00,0.00","subtotal":"661.30","grand_total":"743.97","paid_amount":"743.97","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":"119222","customer_id":"119222","source_of_creation":"FE","reservation_created_date":"2021-04-10 22:22:14","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":"339.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3275794","reservation_id":"105306","confirmation_number":"SJ12646031307","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"134.25,134.25,134.25,134.25,134.25","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"671.25","grand_total":"755.15","paid_amount":"755.15","room_type_id":"413","product_id":"1260","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":"111692","customer_id":"111692","source_of_creation":"FE","reservation_created_date":"2021-01-14 02:13:51","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"134.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":"3228491","reservation_id":"110190","confirmation_number":"SJ12690257418","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"2","nightly_price":"261.75,261.75,261.75,299.25,336.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1421.25","grand_total":"1598.90","paid_amount":"1598.90","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":"116708","customer_id":"116708","source_of_creation":"FE","reservation_created_date":"2021-03-13 13:51:14","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":"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"}]},{"room_stay_id":"3272334","reservation_id":"111482","confirmation_number":"SJ12659438467","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"284.25,299.25,336.75","nightly_discount":"0.00,0.00,0.00","subtotal":"920.25","grand_total":"1035.28","paid_amount":"1035.28","room_type_id":"320","product_id":"1322","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":"118029","customer_id":"118029","source_of_creation":"FE","reservation_created_date":"2021-03-28 01:11:43","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","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":"1267,1268","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":[{"room_stay_id":"3276344","reservation_id":"114843","confirmation_number":"SJ12640766434","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"220.15","nightly_discount":"0.00","subtotal":"220.15","grand_total":"220.15","paid_amount":"217.03","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":"1","traveller_tax_exempt":"1","customer_traveller_id":"121579","customer_id":"121579","source_of_creation":"FE","reservation_created_date":"2021-05-09 20:16:18","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","taxExmptApplied":-27.52,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_taxable":[{"room_stay_id":"3224185","reservation_id":"108831","confirmation_number":"SJ12627091441","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.75,261.75,261.75,299.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1084.50","grand_total":"1220.07","paid_amount":"1220.07","room_type_id":"320","product_id":"1910","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115289","customer_id":"115289","source_of_creation":"PMS","reservation_created_date":"2021-02-28 16:21:42","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1309,1310","currentDayPrice":"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"}]},{"room_stay_id":"3233608","reservation_id":"112851","confirmation_number":"SJ12687338516","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"211.65,313.65,313.65","nightly_discount":"0.00,0.00,0.00","subtotal":"838.95","grand_total":"943.82","paid_amount":"943.82","room_type_id":"319","product_id":"1312","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":"119428","customer_id":"119428","source_of_creation":"PMS","reservation_created_date":"2021-04-13 01:35:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","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":"211.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":"3260066","reservation_id":"116264","confirmation_number":"SJ12687282636","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.30,300.30,300.30,300.30,314.30,349.30,349.30","nightly_discount":"15.02,15.02,15.02,15.02,15.72,17.47,17.47","subtotal":"2214.10","grand_total":"2366.28","paid_amount":"2366.28","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123123","customer_id":"123123","source_of_creation":"PMS","reservation_created_date":"2021-05-31 18:55:16","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"314.30","currentDayDiscount":"15.72","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272445","reservation_id":"112852","confirmation_number":"SJ12649659485","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"211.65,313.65,313.65","nightly_discount":"0.00,0.00,0.00","subtotal":"838.95","grand_total":"943.82","paid_amount":"943.82","room_type_id":"319","product_id":"1311","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":"119428","customer_id":"119428","source_of_creation":"PMS","reservation_created_date":"2021-04-13 01:37:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"211.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":"3276058","reservation_id":"112853","confirmation_number":"SJ12667607621","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"211.65,313.65,313.65","nightly_discount":"0.00,0.00,0.00","subtotal":"838.95","grand_total":"943.82","paid_amount":"943.82","room_type_id":"319","product_id":"1313","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":"119428","customer_id":"119428","source_of_creation":"PMS","reservation_created_date":"2021-04-13 01:42:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"211.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":"3276295","reservation_id":"117570","confirmation_number":"SJ12649718492","room_stay_from":"2021-07-08","room_stay_to":"2021-07-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.00","nightly_discount":"15.25","subtotal":"305.00","grand_total":"325.97","paid_amount":"297.87","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123886","customer_id":"123886","source_of_creation":"PMS","reservation_created_date":"2021-06-18 21:05:58","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":"AAA","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3217780","reservation_id":"99180","confirmation_number":"SJ12696204199","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-17 19:33:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3275431","reservation_id":"109198","confirmation_number":"SJ12650305238","room_stay_from":"2021-06-29","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 20:41: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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3275602","reservation_id":"109200","confirmation_number":"SJ12619720102","room_stay_from":"2021-06-29","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 21:18:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240567","reservation_id":"109222","confirmation_number":"SJ12690007735","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 23:39:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271830","reservation_id":"109220","confirmation_number":"SJ12641803244","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 23:33:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272438","reservation_id":"109221","confirmation_number":"SJ12696315862","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 23:36:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276164","reservation_id":"109220","confirmation_number":"SJ12677351266","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 23:33:25","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":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3220615","reservation_id":"110999","confirmation_number":"SJ12614629439","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-22 19:18:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3233574","reservation_id":"110536","confirmation_number":"SJ12653912583","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:14:31","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":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3260047","reservation_id":"108378","confirmation_number":"SJ12639516716","room_stay_from":"2021-06-29","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1305","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-23 02:42:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","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":"3276257","reservation_id":"110534","confirmation_number":"SJ12611391505","room_stay_from":"2021-06-25","room_stay_to":"2021-07-01","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,174.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:00:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"87.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276262","reservation_id":"110535","confirmation_number":"SJ12655075815","room_stay_from":"2021-06-25","room_stay_to":"2021-07-01","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,174.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:12:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"87.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3276317","reservation_id":"118439","confirmation_number":"SJ12658270528","room_confirmation_number":"SJ12643051345","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"125472","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-07-01 14:29:54","reservation_modified_date_time":"2021-07-01 14:29:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125472","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3228494","reservation_id":"110190","confirmation_number":"SJ12637523949","room_confirmation_number":"SJ12690257418","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"116708","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-05 18:33:56","reservation_modified_date_time":"2021-04-05 18:33:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116708","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272337","reservation_id":"111482","confirmation_number":"SJ12689904306","room_confirmation_number":"SJ12659438467","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","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":"1777","service_quantity":"1","customer_traveller_id":"118029","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-23 19:11:39","reservation_modified_date_time":"2021-06-23 19:11:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118029","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3233609","reservation_id":"112851","confirmation_number":"SJ12629723295","room_confirmation_number":"SJ12687338516","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"119428","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-13 01:39:33","reservation_modified_date_time":"2021-04-13 01:39:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119428","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":"3272446","reservation_id":"112852","confirmation_number":"SJ12642889898","room_confirmation_number":"SJ12649659485","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"119428","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-23 20:44:47","reservation_modified_date_time":"2021-06-23 20:44:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119428","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":"3276059","reservation_id":"112853","confirmation_number":"SJ12637962735","room_confirmation_number":"SJ12667607621","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"119428","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-30 20:17:02","reservation_modified_date_time":"2021-06-30 20:17:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119428","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3233508","reservation_id":"112476","confirmation_number":"SJ12614838249","room_confirmation_number":"SJ12669647181","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"119048","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-13 00:32:18","reservation_modified_date_time":"2021-04-13 00:32:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3217781","reservation_id":"99180","confirmation_number":"SJ12654750415","room_confirmation_number":"SJ12696204199","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","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":"105159","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 19:33:02","reservation_modified_date_time":"2021-03-18 01:30: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"}]},{"room_stay_id":"3224188","reservation_id":"108831","confirmation_number":"SJ12611009634","room_confirmation_number":"SJ12627091441","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","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":"115289","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-28 16:21:43","reservation_modified_date_time":"2021-03-28 18:43:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115289","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":"3228474","reservation_id":"111976","confirmation_number":"SJ12653212786","room_confirmation_number":"SJ12697263046","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","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":"118540","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 13:57:41","reservation_modified_date_time":"2021-04-05 18:30:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118540","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":"3228499","reservation_id":"112124","confirmation_number":"SJ12685166691","room_confirmation_number":"SJ12617525714","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","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":"118693","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 23:35:17","reservation_modified_date_time":"2021-04-05 18:34:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118693","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":"3231744","reservation_id":"112574","confirmation_number":"SJ12612322535","room_confirmation_number":"SJ12675456502","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","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":"119153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 02:14:24","reservation_modified_date_time":"2021-04-10 13:50:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119153","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":"3232267","reservation_id":"112637","confirmation_number":"SJ12660820072","room_confirmation_number":"SJ12649037576","room_stay_from":"2021-06-30","room_stay_to":"2021-07-02","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":"119222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 22:22:14","reservation_modified_date_time":"2021-04-10 22:22:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119222","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":"3236458","reservation_id":"112835","confirmation_number":"SJ12661990843","room_confirmation_number":"SJ12694326082","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","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":"119419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 00:09:43","reservation_modified_date_time":"2021-04-17 20:41:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119419","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":"3240561","reservation_id":"113719","confirmation_number":"SJ12628381146","room_confirmation_number":"SJ12617869053","room_stay_from":"2021-06-26","room_stay_to":"2021-07-02","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":"120330","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 18:43:25","reservation_modified_date_time":"2021-04-23 19:31:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120330","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":"3249761","reservation_id":"114970","confirmation_number":"SJ12620960775","room_confirmation_number":"SJ12664749078","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","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":"121691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 01:14:09","reservation_modified_date_time":"2021-05-11 01:14:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121691","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":"3252226","reservation_id":"113305","confirmation_number":"SJ12675948005","room_confirmation_number":"SJ12629389107","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","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":"119889","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 17:07:08","reservation_modified_date_time":"2021-05-15 15:15:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119889","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":"3274705","reservation_id":"116254","confirmation_number":"SJ12698721609","room_confirmation_number":"SJ12616701735","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","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":"123113","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 17:16:12","reservation_modified_date_time":"2021-06-28 16:04:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123113","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":"3274897","reservation_id":"112143","confirmation_number":"SJ12671826244","room_confirmation_number":"SJ12668996453","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","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":"118712","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-05 12:52:12","reservation_modified_date_time":"2021-06-28 21:49:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118712","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":"3275432","reservation_id":"109198","confirmation_number":"SJ12618455134","room_confirmation_number":"SJ12650305238","room_stay_from":"2021-06-29","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115668","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 20:41:31","reservation_modified_date_time":"2021-06-29 19:57:06","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":"3275603","reservation_id":"109200","confirmation_number":"SJ12670919179","room_confirmation_number":"SJ12619720102","room_stay_from":"2021-06-29","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 21:18:14","reservation_modified_date_time":"2021-06-29 22:55:41","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3275793","reservation_id":"113607","confirmation_number":"SJ12623422132","room_confirmation_number":"SJ12678732883","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","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":"120210","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 03:10:08","reservation_modified_date_time":"2021-06-30 13:53:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120210","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":"3275796","reservation_id":"105306","confirmation_number":"SJ12676811150","room_confirmation_number":"SJ12646031307","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","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":"111692","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 02:13:51","reservation_modified_date_time":"2021-06-30 13:53:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111692","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":"3276110","reservation_id":"118415","confirmation_number":"SJ12680313801","room_confirmation_number":"SJ12616856730","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","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":"125443","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-30 21:10:07","reservation_modified_date_time":"2021-06-30 21:10:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125443","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":"3276318","reservation_id":"118439","confirmation_number":"SJ12645724231","room_confirmation_number":"SJ12643051345","room_stay_from":"2021-07-01","room_stay_to":"2021-07-02","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":"125472","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-01 02:55:10","reservation_modified_date_time":"2021-07-01 14:29:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125472","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3228495","reservation_id":"110190","confirmation_number":"SJ12656243803","room_confirmation_number":"SJ12690257418","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","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":"116708","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 13:51:14","reservation_modified_date_time":"2021-04-05 18:33:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116708","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":"3240568","reservation_id":"109222","confirmation_number":"SJ12648389914","room_confirmation_number":"SJ12690007735","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115690","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:39:58","reservation_modified_date_time":"2021-04-23 19:40:26","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":"3246199","reservation_id":"114423","confirmation_number":"SJ12688969029","room_confirmation_number":"SJ12689062824","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","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":"121098","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-03 15:45:17","reservation_modified_date_time":"2021-05-03 15:45:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121098","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":"3271831","reservation_id":"109220","confirmation_number":"SJ12677621745","room_confirmation_number":"SJ12641803244","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115688","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:33:25","reservation_modified_date_time":"2021-06-22 15:14:24","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":"3272338","reservation_id":"111482","confirmation_number":"SJ12657601918","room_confirmation_number":"SJ12659438467","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"118029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 01:11:43","reservation_modified_date_time":"2021-06-23 19:11:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118029","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":"3272439","reservation_id":"109221","confirmation_number":"SJ12644051344","room_confirmation_number":"SJ12696315862","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115689","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:36:13","reservation_modified_date_time":"2021-06-23 20:44:14","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3274242","reservation_id":"114944","confirmation_number":"SJ12613396407","room_confirmation_number":"SJ12680919922","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121666","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-10 20:59:02","reservation_modified_date_time":"2021-06-27 12:58:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121666","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":"3275553","reservation_id":"113861","confirmation_number":"SJ12657412357","room_confirmation_number":"SJ12661440393","room_stay_from":"2021-06-29","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"120485","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-25 17:44:09","reservation_modified_date_time":"2021-06-29 22:22:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120485","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":"3276165","reservation_id":"109220","confirmation_number":"SJ12669288440","room_confirmation_number":"SJ12677351266","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116656","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:33:25","reservation_modified_date_time":"2021-06-30 23:08: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":"3276328","reservation_id":"117616","confirmation_number":"SJ12681562952","room_confirmation_number":"SJ12658291912","room_stay_from":"2021-07-01","room_stay_to":"2021-07-03","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":"124585","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-19 10:38:09","reservation_modified_date_time":"2021-07-01 14:39:35","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124585","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":"3220616","reservation_id":"110999","confirmation_number":"SJ12692038445","room_confirmation_number":"SJ12614629439","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117538","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 19:18:20","reservation_modified_date_time":"2021-03-22 19:18:20","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3233542","reservation_id":"112167","confirmation_number":"SJ12671427163","room_confirmation_number":"SJ12628638523","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"118739","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-05 17:47:08","reservation_modified_date_time":"2021-04-13 00:45:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118739","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":"3233575","reservation_id":"110536","confirmation_number":"SJ12611939897","room_confirmation_number":"SJ12653912583","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117049","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:14:31","reservation_modified_date_time":"2021-04-13 01:03:37","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":"3233610","reservation_id":"112851","confirmation_number":"SJ12673810285","room_confirmation_number":"SJ12687338516","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"119428","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 01:35:24","reservation_modified_date_time":"2021-04-13 01:39:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119428","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":"3235864","reservation_id":"113153","confirmation_number":"SJ12677621153","room_confirmation_number":"SJ12610349241","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"119743","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 00:18:12","reservation_modified_date_time":"2021-04-17 00:18:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119743","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":"3260049","reservation_id":"108378","confirmation_number":"SJ12688455501","room_confirmation_number":"SJ12639516716","room_stay_from":"2021-06-29","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114829","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:42:33","reservation_modified_date_time":"2021-05-31 18:48:09","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3260067","reservation_id":"116264","confirmation_number":"SJ12621452758","room_confirmation_number":"SJ12687282636","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","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":"123123","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 18:55:16","reservation_modified_date_time":"2021-05-31 18:55:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123123","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":"3272447","reservation_id":"112852","confirmation_number":"SJ12688519950","room_confirmation_number":"SJ12649659485","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"119428","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 01:37:09","reservation_modified_date_time":"2021-06-23 20:44:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119428","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":"3275001","reservation_id":"111476","confirmation_number":"SJ12639912371","room_confirmation_number":"SJ12677242204","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","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":"125295","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 00:09:08","reservation_modified_date_time":"2021-06-28 22:33:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125295","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":"3276060","reservation_id":"112853","confirmation_number":"SJ12658997263","room_confirmation_number":"SJ12667607621","room_stay_from":"2021-07-01","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"119428","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 01:42:04","reservation_modified_date_time":"2021-06-30 20:17:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119428","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":"3224416","reservation_id":"111572","confirmation_number":"SJ12687437878","room_confirmation_number":"SJ12697294787","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"118130","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-29 03:21:09","reservation_modified_date_time":"2021-03-29 03:21:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118130","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":"3233509","reservation_id":"112476","confirmation_number":"SJ12637629763","room_confirmation_number":"SJ12669647181","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"119048","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 23:22:11","reservation_modified_date_time":"2021-04-13 00:32:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3233513","reservation_id":"112476","confirmation_number":"SJ12685225154","room_confirmation_number":"SJ12620609595","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"119048","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 23:22:16","reservation_modified_date_time":"2021-04-13 00:32:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119048","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":"3272433","reservation_id":"111666","confirmation_number":"SJ12634566415","room_confirmation_number":"SJ12610771285","room_stay_from":"2021-06-30","room_stay_to":"2021-07-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"118222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 04:17:11","reservation_modified_date_time":"2021-06-23 20:43:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118222","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":"3233522","reservation_id":"112404","confirmation_number":"SJ12671899671","room_confirmation_number":"SJ12660249731","room_stay_from":"2021-07-01","room_stay_to":"2021-07-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"118977","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 23:53:10","reservation_modified_date_time":"2021-04-13 00:37:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118977","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":"3276258","reservation_id":"110534","confirmation_number":"SJ12680818406","room_confirmation_number":"SJ12611391505","room_stay_from":"2021-06-25","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:00:57","reservation_modified_date_time":"2021-07-01 11:58:35","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276263","reservation_id":"110535","confirmation_number":"SJ12657000227","room_confirmation_number":"SJ12655075815","room_stay_from":"2021-06-25","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:12:07","reservation_modified_date_time":"2021-07-01 11:59:24","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276296","reservation_id":"117570","confirmation_number":"SJ12620453228","room_confirmation_number":"SJ12649718492","room_stay_from":"2021-07-08","room_stay_to":"2021-07-09","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":"123886","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-18 21:05:58","reservation_modified_date_time":"2021-07-01 13:33:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123886","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3276343","reservation_id":"114843","confirmation_number":"SJ12680833465","room_confirmation_number":"SJ12640766434","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.00","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"121579","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-09 20:16:18","reservation_modified_date_time":"2021-07-01 14:51:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"121579","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","taxExmptApplied":-3.13,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gift_shop_taxable":[{"room_stay_id":"3276259","reservation_id":"110534","confirmation_number":"SJ12615424776","room_confirmation_number":"SJ12611391505","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-01 11:58:45","reservation_modified_date_time":"2021-07-01 11:58:45","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"117047","static_pos_type":null,"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-06-25","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276264","reservation_id":"110535","confirmation_number":"SJ12640689477","room_confirmation_number":"SJ12655075815","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-01 11:59:33","reservation_modified_date_time":"2021-07-01 11:59:33","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"117047","static_pos_type":null,"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-06-25","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276441","reservation_id":"118474","confirmation_number":"SJ12653541754","room_confirmation_number":"SJ12641309422","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-01 18:59:19","reservation_modified_date_time":"2021-07-01 18:59:19","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}