{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-12-31","total_rooms_exist":"1281,1282,1289,1274,1275,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":7,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1272","block_room_bookings":[{"confirmation_number":"SJ12650067376","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"0"}],"bundle_block_count":"1269,1270,1271,1272,1302,1303,1307,1308,1311,1312,1309,1310,1267,1268,1260,1261,1262,1263,1304,1305,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12640979238","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"1"},{"confirmation_number":"SJB12684310208","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"1"},{"confirmation_number":"SJB12664160685","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12670410030","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12686072323","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"1"},{"confirmation_number":"SJB12654692936","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","bundle_room":"1"},{"confirmation_number":"SJB12653566913","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12659810324","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12699144844","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12651817263","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12622508305","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","bundle_room":"1"},{"confirmation_number":"SJB12696286409","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","bundle_room":"0"},{"confirmation_number":"SJB12661730140","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","bundle_room":"0"},{"confirmation_number":"SJB12656771494","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","bundle_room":"0"},{"confirmation_number":"SJB12621069051","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","bundle_room":"0"},{"confirmation_number":"SJB12665885997","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","bundle_room":"0"},{"confirmation_number":"SJB12698006168","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","bundle_room":"0"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3165859","reservation_id":"103181","confirmation_number":"SJ12639424000","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,343.20,343.20,343.20,343.20","nightly_discount":"0,0,0,0,0","subtotal":"1716.00","grand_total":"1930.50","paid_amount":"1930.50","room_type_id":"319","product_id":"1307","siteminder_id":"BDC-2628802841","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":"109333","customer_id":"109333","source_of_creation":"Booking.com","reservation_created_date":"2020-11-27 15:49:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"331.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169108","reservation_id":"103969","confirmation_number":"SJ12641150932","room_stay_from":"2020-12-31","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"373.15","nightly_discount":"0","subtotal":"373.15","grand_total":"419.80","paid_amount":"419.80","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-2443834266","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":"110278","customer_id":"110278","source_of_creation":"Booking.com","reservation_created_date":"2020-12-19 01:47:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"71.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"373.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":"3170611","reservation_id":"102894","confirmation_number":"SJ12662571034","room_stay_from":"2020-12-28","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,343.20,343.20,343.20","nightly_discount":"0,0,0,0","subtotal":"1372.80","grand_total":"1544.40","paid_amount":"1544.40","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3372657390","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":"109026","customer_id":"109026","source_of_creation":"Booking.com","reservation_created_date":"2020-11-20 18:39:22","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"265.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172352","reservation_id":"104489","confirmation_number":"SJ12625968028","room_stay_from":"2020-12-31","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"419.90","nightly_discount":"0","subtotal":"419.90","grand_total":"472.39","paid_amount":"472.39","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-2126772678","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":"110844","customer_id":"110844","source_of_creation":"Booking.com","reservation_created_date":"2020-12-31 20:58:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"80.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"currentDayPrice":"419.90","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":"3163068","reservation_id":"103595","confirmation_number":"SJ12691111785","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"413.28,413.28,442.08","nightly_discount":"0,0,0","subtotal":"1268.64","grand_total":"1427.22","paid_amount":"1427.22","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3370388875","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":"109841","customer_id":"109841","source_of_creation":"Booking.com","reservation_created_date":"2020-12-08 03:03:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"241.86","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"413.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3165850","reservation_id":"103359","confirmation_number":"SJ12667756358","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,343.20,343.20,343.20,343.20,343.20,375.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2434.40","grand_total":"2738.70","paid_amount":"2738.70","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-2916961103","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":"109530","customer_id":"109530","source_of_creation":"Booking.com","reservation_created_date":"2020-12-01 20:51:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","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":"343.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3167231","reservation_id":"103977","confirmation_number":"SJ12664684739","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"365.2,365.2","nightly_discount":"0,0","subtotal":"730.40","grand_total":"821.70","paid_amount":"0.00","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2516456043","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":"110287","customer_id":"110287","source_of_creation":"Booking.com","reservation_created_date":"2020-12-19 09:39:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"316.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"365.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169738","reservation_id":"103977","confirmation_number":"SJ12640785281","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"365.2,365.2","nightly_discount":"0,0","subtotal":"730.40","grand_total":"821.70","paid_amount":"0.00","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-2516456043","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":"110287","customer_id":"110287","source_of_creation":"Booking.com","reservation_created_date":"2020-12-19 09:39:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"316.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"365.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170174","reservation_id":"102806","confirmation_number":"SJ12676225026","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"383.20,383.20,383.20,383.20,383.20,383.20,415.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2714.40","grand_total":"3053.70","paid_amount":"3053.70","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2974326312","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"350.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108949","customer_id":"108949","source_of_creation":"Booking.com","reservation_created_date":"2020-11-18 14:39:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"520.09","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"383.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170617","reservation_id":"103635","confirmation_number":"SJ12662486630","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.60,346.12","nightly_discount":"0,0","subtotal":"662.72","grand_total":"745.56","paid_amount":"745.56","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2468767478","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":"109880","customer_id":"109880","source_of_creation":"Booking.com","reservation_created_date":"2020-12-09 05:32:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"128.29","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"316.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172132","reservation_id":"104455","confirmation_number":"SJ12667411093","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"373.15,373.15","nightly_discount":"0,0","subtotal":"746.30","grand_total":"839.59","paid_amount":"839.59","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3815449524","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":"110808","customer_id":"110808","source_of_creation":"Booking.com","reservation_created_date":"2020-12-30 22:38:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"143.33","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"373.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":"3171917","reservation_id":"104143","confirmation_number":"SJ12620208022","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"5","nightly_price":"530.10,530.10,530.10","nightly_discount":"0,0,0","subtotal":"1590.30","grand_total":"1789.09","paid_amount":"1789.09","room_type_id":"320","product_id":"1321","siteminder_id":"BDC-3059573289","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":"110476","customer_id":"110476","source_of_creation":"Booking.com","reservation_created_date":"2020-12-23 14:28:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"299.75","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"530.10","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":"3153220","reservation_id":"102032","confirmation_number":"SJ12695810025","room_stay_from":"2020-12-28","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"424.00,424.00,424.00,424.00","nightly_discount":"0,0,0,0","subtotal":"1696.00","grand_total":"1908.00","paid_amount":"1908.00","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1711808488","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":"108151","customer_id":"108151","source_of_creation":"Expedia","reservation_created_date":"2020-10-28 14:59:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"424.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":"3168833","reservation_id":"104102","confirmation_number":"SJ12621329822","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"271.4,271.4,271.4,271.4,271.4","nightly_discount":"0,0,0,0,0","subtotal":"1357.00","grand_total":"1526.63","paid_amount":"1526.63","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1724622327","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"125.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110436","customer_id":"110436","source_of_creation":"Expedia","reservation_created_date":"2020-12-22 10:01:07","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"271.4","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":"3169733","reservation_id":"102832","confirmation_number":"SJ12622754069","room_stay_from":"2020-12-30","room_stay_to":"2021-01-01","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"359.10,359.10","nightly_discount":"0,0","subtotal":"718.20","grand_total":"807.98","paid_amount":"807.98","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1717141440","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":"108971","customer_id":"108971","source_of_creation":"Expedia","reservation_created_date":"2020-11-19 02:03:10","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":"359.10","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":"3172349","reservation_id":"103797","confirmation_number":"SJ12646173411","room_stay_from":"2020-12-29","room_stay_to":"2021-01-01","room_stay_status":"Checked-Out","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"647.36,647.36,647.36","nightly_discount":"0.00,0.00,0.00","subtotal":"1942.08","grand_total":"2184.84","paid_amount":"2184.84","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1722856106","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110727","customer_id":"110071","source_of_creation":"Expedia","reservation_created_date":"2020-12-14 15:16:09","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":"","changedComment":"To date changed","deltaChange":"564.32","currentDayPrice":"647.36","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3167904","reservation_id":"104016","confirmation_number":"SJ12685124954","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"278.40,278.40,278.40,278.40,278.40,278.40","nightly_discount":"0,0,0,0,0,0","subtotal":"1670.40","grand_total":"1879.20","paid_amount":"1879.20","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1724240014","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":"110339","customer_id":"110339","source_of_creation":"Expedia","reservation_created_date":"2020-12-20 17:26:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"278.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170744","reservation_id":"104034","confirmation_number":"SJ12683191956","room_stay_from":"2020-12-28","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"296.40,296.40,296.40,296.40,296.40","nightly_discount":"0,0,0,0,0","subtotal":"1482.00","grand_total":"1667.25","paid_amount":"1667.25","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1724312609","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":"110366","customer_id":"110366","source_of_creation":"Expedia","reservation_created_date":"2020-12-21 00:11:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"296.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170892","reservation_id":"102450","confirmation_number":"SJ12633528958","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"7","room_stay_child_count":"0","nightly_price":"479.20,479.20,479.20,479.20,479.20,511.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2907.20","grand_total":"3270.60","paid_amount":"3270.60","room_type_id":"320","product_id":"1910","siteminder_id":"EXP-1714598226","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":"108615","customer_id":"108615","source_of_creation":"Expedia","reservation_created_date":"2020-11-08 22:45:26","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":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"479.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170926","reservation_id":"104306","confirmation_number":"SJ12618570825","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"318.92,375.20,375.20","nightly_discount":"0,0,0","subtotal":"1069.32","grand_total":"1202.99","paid_amount":"1202.99","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1725634360","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":"110660","customer_id":"110660","source_of_creation":"Expedia","reservation_created_date":"2020-12-27 19:21:08","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"375.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171137","reservation_id":"104052","confirmation_number":"SJ12685641931","room_stay_from":"2020-12-28","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"348.00,348.00,348.00,348.00,348.00","nightly_discount":"0,0,0,0,0","subtotal":"1740.00","grand_total":"1957.50","paid_amount":"1957.50","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1724412884","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":"110384","customer_id":"110384","source_of_creation":"Expedia","reservation_created_date":"2020-12-21 14:19:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"348.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":"3171516","reservation_id":"104205","confirmation_number":"SJ12684399844","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"439.00,439.00","nightly_discount":"0,0","subtotal":"878.00","grand_total":"987.75","paid_amount":"987.75","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1725069586","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":"110540","customer_id":"110540","source_of_creation":"Expedia","reservation_created_date":"2020-12-24 17:06:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"439.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":"3172221","reservation_id":"104469","confirmation_number":"SJ12678527921","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"310.92,310.92,215.72","nightly_discount":"0,0,0","subtotal":"837.56","grand_total":"942.26","paid_amount":"1026.64","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1726578621","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110823","customer_id":"110823","source_of_creation":"Expedia","reservation_created_date":"2020-12-31 16:31:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"currentDayPrice":"310.92","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":"3170792","reservation_id":"104293","confirmation_number":"SJ12688411107","room_stay_from":"2020-12-30","room_stay_to":"2021-01-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"469.00,469.00,469.00,230.30,181.30,167.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1985.90","grand_total":"2234.14","paid_amount":"2234.14","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1725588537","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":"110649","customer_id":"110649","source_of_creation":"Expedia","reservation_created_date":"2020-12-27 14:41:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"469.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3172391","reservation_id":"104443","confirmation_number":"SJ12624976389","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"430.44,425.27","nightly_discount":"0.00,0.00","subtotal":"855.71","grand_total":"991.66","paid_amount":"991.66","room_type_id":"319","product_id":"1319","siteminder_id":"ABB-HMJBZSRPQA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"860.88","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110792","customer_id":"110792","source_of_creation":"Airbnb","reservation_created_date":"2020-12-30 19:50:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"25.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"currentDayPrice":"430.44","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":"3171856","reservation_id":"104414","confirmation_number":"SJ12688948753","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"398.31,398.31,398.31,398.31","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1593.24","grand_total":"1844.83","paid_amount":"1835.27","room_type_id":"318","product_id":"1282","siteminder_id":"ABB-HMWK4CXSSN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1593.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110763","customer_id":"110763","source_of_creation":"Airbnb","reservation_created_date":"2020-12-30 01:48:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"46.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"398.31","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":"3172139","reservation_id":"102093","confirmation_number":"SJ12638499642","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"575.34,575.34,575.34,460.27","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"2186.29","grand_total":"3221.90","paid_amount":"3221.90","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMXBTXX9WF","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"2301.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108225","customer_id":"108225","source_of_creation":"Airbnb","reservation_created_date":"2020-10-30 00:23:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"345.2","commision_charges":"374.64","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"575.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3172385","reservation_id":"104259","confirmation_number":"SJ12631688230","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"2","nightly_price":"574.26,574.26,489.54","nightly_discount":"0.00,0.00,0.00","subtotal":"1638.06","grand_total":"1909.67","paid_amount":"1909.67","room_type_id":"320","product_id":"1714","siteminder_id":"ABB-HMSPBN2YQC","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"1647.78","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110609","customer_id":"110609","source_of_creation":"Airbnb","reservation_created_date":"2020-12-26 19:03:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"50.67","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"currentDayPrice":"574.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[{"room_stay_id":"3172224","reservation_id":"104470","confirmation_number":"SJ12612272295","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"430.94,430.94","nightly_discount":"0,0","subtotal":"861.88","grand_total":"1005.62","paid_amount":"1000.45","room_type_id":"319","product_id":"1942","siteminder_id":"ABB-HM3CQN4SHH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"861.88","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110824","customer_id":"110824","source_of_creation":"Airbnb","reservation_created_date":"2020-12-31 16:34:06","service_canceled_date_time":"2020-12-31 16:37:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"26.82","deltaChange":"1050.45","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3168413","reservation_id":"101832","confirmation_number":"SJ12628526933","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"454.00,494.00","nightly_discount":"0.00,0.00","subtotal":"948.00","grand_total":"1066.50","paid_amount":"510.75","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107928","customer_id":"107928","source_of_creation":"FE","reservation_created_date":"2020-10-22 04:13:34","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"454.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":"3169735","reservation_id":"96198","confirmation_number":"SJ12634219277","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.04,239.04,239.04,239.04,239.04,239.04,239.04","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1673.28","grand_total":"1882.44","paid_amount":"1882.44","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":"102321","customer_id":"102321","source_of_creation":"FE","reservation_created_date":"2020-06-09 23:53:34","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"239.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171913","reservation_id":"103525","confirmation_number":"SJ12639810697","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"466.65,466.65,500.65","nightly_discount":"0.00,0.00,0.00","subtotal":"1433.95","grand_total":"1613.20","paid_amount":"1613.20","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":"109755","customer_id":"109755","source_of_creation":"FE","reservation_created_date":"2020-12-06 14:01:32","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":"466.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":"3168968","reservation_id":"104122","confirmation_number":"SJ12673366310","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"370.50,370.50,370.50,370.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1482.00","grand_total":"1667.25","paid_amount":"1667.25","room_type_id":"411","product_id":"1296","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":"110455","customer_id":"110455","source_of_creation":"FE","reservation_created_date":"2020-12-22 20:25:05","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"370.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"}]}],"fe_non_taxable":[],"pms_taxable":[],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3146856","reservation_id":"96857","confirmation_number":"SJ12641178022","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.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-06-20 02:30:57","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.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":"3162645","reservation_id":"97094","confirmation_number":"SJ12626056536","room_stay_from":"2020-12-25","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"794.99","grand_total":"794.99","paid_amount":"196.88","room_type_id":"412","product_id":"1315","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-06-26 00:21:44","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168576","reservation_id":"95495","confirmation_number":"SJ12674753883","room_stay_from":"2020-12-29","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1306","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:46: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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146704","reservation_id":"95487","confirmation_number":"SJ12673847493","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"580.73","grand_total":"580.73","paid_amount":"196.88","room_type_id":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:28:02","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","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":"3146706","reservation_id":"95488","confirmation_number":"SJ12637731060","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"580.73","grand_total":"580.73","paid_amount":"196.88","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:28:43","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","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":"3146708","reservation_id":"95489","confirmation_number":"SJ12619590336","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"580.73","grand_total":"580.73","paid_amount":"196.88","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:29:39","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","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":"3153337","reservation_id":"102019","confirmation_number":"SJ12621765128","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00,78.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"582.00","grand_total":"582.00","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-10-28 01:26:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.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":"3146850","reservation_id":"96755","confirmation_number":"SJ12627282701","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"616.44","grand_total":"616.44","paid_amount":"196.88","room_type_id":"319","product_id":"1915","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-06-18 14:24:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","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":"3146852","reservation_id":"96755","confirmation_number":"SJ12622659123","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"616.44","grand_total":"616.44","paid_amount":"196.88","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-18 14:24:51","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","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":"3146854","reservation_id":"96755","confirmation_number":"SJ12637553566","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"616.44","grand_total":"616.44","paid_amount":"196.88","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-18 14:24:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","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":"3152361","reservation_id":"95494","confirmation_number":"SJ12621861390","room_stay_from":"2020-12-29","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"462.00","grand_total":"462.00","paid_amount":"140.63","room_type_id":"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":"2020-05-27 16:45:02","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.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":"3170673","reservation_id":"101518","confirmation_number":"SJ12651133298","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"618.00","grand_total":"618.00","paid_amount":"196.88","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-10-14 01:33:37","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.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":"3170931","reservation_id":"100153","confirmation_number":"SJ12668031535","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"77.86,77.86,77.86,77.86,77.86,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"616.44","grand_total":"616.44","paid_amount":"196.88","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-09-09 00:33:49","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","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":"3171135","reservation_id":"97463","confirmation_number":"SJ12681868729","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"304.99","grand_total":"304.99","paid_amount":"84.38","room_type_id":"319","product_id":"1943","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-07-06 22:32:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3168834","reservation_id":"104102","confirmation_number":"SJ12645508437","room_confirmation_number":"SJ12621329822","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1777","service_quantity":"1","customer_traveller_id":"110436","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-12-22 10:01:07","reservation_modified_date_time":"2020-12-22 10:01:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110436","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.00","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":"3172350","reservation_id":"103797","confirmation_number":"SJ12626106280","room_confirmation_number":"SJ12646173411","room_stay_from":"2020-12-29","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"50.00,50.00,0.88","nightly_discount":"0.00,0.00,0.00","subtotal":"100.88","grand_total":"113.49","paid_amount":"113.49","product_id":"1777","service_quantity":"1","customer_traveller_id":"110727","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-12-31 20:40:58","reservation_modified_date_time":"2020-12-31 20:42:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110071","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","changedComment":"Reservation created with partial past date","deltaChange":"100.00","currentDayPrice":"0.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3167232","reservation_id":"103977","confirmation_number":"SJ12685024311","room_confirmation_number":"SJ12664684739","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"110287","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-12-19 09:39:15","reservation_modified_date_time":"2020-12-19 09:39:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","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":"3169739","reservation_id":"103977","confirmation_number":"SJ12652713936","room_confirmation_number":"SJ12640785281","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"110287","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-12-24 19:44:09","reservation_modified_date_time":"2020-12-24 19:44:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","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":"3172222","reservation_id":"104469","confirmation_number":"SJ12694804700","room_confirmation_number":"SJ12678527921","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"110823","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-12-31 16:31:09","reservation_modified_date_time":"2020-12-31 16:31:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110823","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","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":"3146855","reservation_id":"96857","confirmation_number":"SJ12640738224","room_confirmation_number":"SJ12641178022","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","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":"102873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 02:30:57","reservation_modified_date_time":"2020-10-17 22:06:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3153221","reservation_id":"102032","confirmation_number":"SJ12644617436","room_confirmation_number":"SJ12695810025","room_stay_from":"2020-12-28","room_stay_to":"2021-01-01","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":"108151","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 14:59:06","reservation_modified_date_time":"2020-11-08 17:45:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108151","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3162646","reservation_id":"97094","confirmation_number":"SJ12689407031","room_confirmation_number":"SJ12626056536","room_stay_from":"2020-12-25","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103214","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 00:21:44","reservation_modified_date_time":"2020-12-07 14:41:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3165860","reservation_id":"103181","confirmation_number":"SJ12670210606","room_confirmation_number":"SJ12639424000","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","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":"109333","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-27 15:49:10","reservation_modified_date_time":"2020-12-16 16:17:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109333","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168577","reservation_id":"95495","confirmation_number":"SJ12644924635","room_confirmation_number":"SJ12674753883","room_stay_from":"2020-12-29","room_stay_to":"2021-01-01","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":"101684","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:46:41","reservation_modified_date_time":"2020-12-21 19:26:02","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168835","reservation_id":"104102","confirmation_number":"SJ12651477408","room_confirmation_number":"SJ12621329822","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","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":"110436","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 10:01:07","reservation_modified_date_time":"2020-12-22 10:01:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110436","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169109","reservation_id":"103969","confirmation_number":"SJ12656436630","room_confirmation_number":"SJ12641150932","room_stay_from":"2020-12-31","room_stay_to":"2021-01-01","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":"110278","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-19 01:47:10","reservation_modified_date_time":"2020-12-23 14:26:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110278","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169734","reservation_id":"102832","confirmation_number":"SJ12699028407","room_confirmation_number":"SJ12622754069","room_stay_from":"2020-12-30","room_stay_to":"2021-01-01","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":"108971","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-19 02:03:10","reservation_modified_date_time":"2020-12-24 19:40:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108971","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170612","reservation_id":"102894","confirmation_number":"SJ12679514419","room_confirmation_number":"SJ12662571034","room_stay_from":"2020-12-28","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"109026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 18:39:22","reservation_modified_date_time":"2020-12-26 23:34:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109026","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3172351","reservation_id":"103797","confirmation_number":"SJ12667160271","room_confirmation_number":"SJ12646173411","room_stay_from":"2020-12-29","room_stay_to":"2021-01-01","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":"110727","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-14 15:16:09","reservation_modified_date_time":"2020-12-31 20:42:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110071","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172353","reservation_id":"104489","confirmation_number":"SJ12675903760","room_confirmation_number":"SJ12625968028","room_stay_from":"2020-12-31","room_stay_to":"2021-01-01","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":"110844","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 20:58:13","reservation_modified_date_time":"2020-12-31 20:58:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110844","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146703","reservation_id":"95487","confirmation_number":"SJ12631629088","room_confirmation_number":"SJ12673847493","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:28:02","reservation_modified_date_time":"2020-10-17 22:06:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146705","reservation_id":"95488","confirmation_number":"SJ12641723483","room_confirmation_number":"SJ12637731060","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:28:43","reservation_modified_date_time":"2020-10-17 22:06:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146707","reservation_id":"95489","confirmation_number":"SJ12687269033","room_confirmation_number":"SJ12619590336","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:29:39","reservation_modified_date_time":"2020-10-17 22:06:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3153338","reservation_id":"102019","confirmation_number":"SJ12683695838","room_confirmation_number":"SJ12621765128","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108137","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 01:26:53","reservation_modified_date_time":"2020-11-08 20:52:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3163069","reservation_id":"103595","confirmation_number":"SJ12629632631","room_confirmation_number":"SJ12691111785","room_stay_from":"2020-12-30","room_stay_to":"2021-01-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"109841","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-08 03:03:09","reservation_modified_date_time":"2020-12-08 03:03:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109841","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3165851","reservation_id":"103359","confirmation_number":"SJ12658912222","room_confirmation_number":"SJ12667756358","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"109530","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-01 20:51:27","reservation_modified_date_time":"2020-12-16 16:13:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109530","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3167233","reservation_id":"103977","confirmation_number":"SJ12699853678","room_confirmation_number":"SJ12664684739","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110287","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-19 09:39:15","reservation_modified_date_time":"2020-12-19 09:39:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3167905","reservation_id":"104016","confirmation_number":"SJ12614226892","room_confirmation_number":"SJ12685124954","room_stay_from":"2020-12-27","room_stay_to":"2021-01-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":"110339","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-20 17:26:12","reservation_modified_date_time":"2020-12-20 17:26:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110339","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168414","reservation_id":"101832","confirmation_number":"SJ12658499940","room_confirmation_number":"SJ12628526933","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107928","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-22 04:13:34","reservation_modified_date_time":"2020-12-21 13:13:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107928","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169737","reservation_id":"96198","confirmation_number":"SJ12678366034","room_confirmation_number":"SJ12634219277","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"102321","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 23:53:34","reservation_modified_date_time":"2020-12-24 19:43:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102321","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169740","reservation_id":"103977","confirmation_number":"SJ12647935361","room_confirmation_number":"SJ12640785281","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110287","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-19 09:39:11","reservation_modified_date_time":"2020-12-24 19:44:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170176","reservation_id":"102806","confirmation_number":"SJ12699468217","room_confirmation_number":"SJ12676225026","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"108949","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-18 14:39:12","reservation_modified_date_time":"2020-12-26 14:38:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108949","canceled_nights_data":"","posAmt_airbnb_taxpaid":"350.00","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":"3170618","reservation_id":"103635","confirmation_number":"SJ12617298610","room_confirmation_number":"SJ12662486630","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"109880","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-09 05:32:08","reservation_modified_date_time":"2020-12-26 23:38:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109880","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170745","reservation_id":"104034","confirmation_number":"SJ12614836396","room_confirmation_number":"SJ12683191956","room_stay_from":"2020-12-28","room_stay_to":"2021-01-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":"110366","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-21 00:11:07","reservation_modified_date_time":"2020-12-27 12:34:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110366","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170895","reservation_id":"102450","confirmation_number":"SJ12638405517","room_confirmation_number":"SJ12633528958","room_stay_from":"2020-12-27","room_stay_to":"2021-01-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":"108615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-08 22:45:26","reservation_modified_date_time":"2020-12-27 18:37:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108615","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170927","reservation_id":"104306","confirmation_number":"SJ12613535687","room_confirmation_number":"SJ12618570825","room_stay_from":"2020-12-30","room_stay_to":"2021-01-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"110660","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-27 19:21:08","reservation_modified_date_time":"2020-12-27 19:21:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110660","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171138","reservation_id":"104052","confirmation_number":"SJ12634056432","room_confirmation_number":"SJ12685641931","room_stay_from":"2020-12-28","room_stay_to":"2021-01-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":"110384","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-21 14:19:07","reservation_modified_date_time":"2020-12-28 17:18:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110384","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171517","reservation_id":"104205","confirmation_number":"SJ12668828798","room_confirmation_number":"SJ12684399844","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"110540","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-24 17:06:12","reservation_modified_date_time":"2020-12-29 14:36:49","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110540","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171916","reservation_id":"103525","confirmation_number":"SJ12641295891","room_confirmation_number":"SJ12639810697","room_stay_from":"2020-12-30","room_stay_to":"2021-01-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"109755","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 14:01:32","reservation_modified_date_time":"2020-12-30 16:38:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109755","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172133","reservation_id":"104455","confirmation_number":"SJ12695180656","room_confirmation_number":"SJ12667411093","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"110808","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 22:38:12","reservation_modified_date_time":"2020-12-30 22:38:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110808","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172392","reservation_id":"104443","confirmation_number":"SJ12691470663","room_confirmation_number":"SJ12624976389","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","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":"110792","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 19:50:11","reservation_modified_date_time":"2020-12-31 23:03:25","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110792","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3146849","reservation_id":"96755","confirmation_number":"SJ12616352970","room_confirmation_number":"SJ12627282701","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 14:24:52","reservation_modified_date_time":"2020-10-17 22:06:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3146851","reservation_id":"96755","confirmation_number":"SJ12679356732","room_confirmation_number":"SJ12622659123","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 14:24:51","reservation_modified_date_time":"2020-10-17 22:06:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3146853","reservation_id":"96755","confirmation_number":"SJ12680575456","room_confirmation_number":"SJ12637553566","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 14:24:51","reservation_modified_date_time":"2020-10-17 22:06:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3152363","reservation_id":"95494","confirmation_number":"SJ12641268815","room_confirmation_number":"SJ12621861390","room_stay_from":"2020-12-29","room_stay_to":"2021-01-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101683","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:45:02","reservation_modified_date_time":"2020-11-05 20:38:43","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168969","reservation_id":"104122","confirmation_number":"SJ12620990003","room_confirmation_number":"SJ12673366310","room_stay_from":"2020-12-30","room_stay_to":"2021-01-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":"110455","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 20:25:05","reservation_modified_date_time":"2020-12-22 20:25:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110455","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170674","reservation_id":"101518","confirmation_number":"SJ12636012730","room_confirmation_number":"SJ12651133298","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107596","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-14 01:33:37","reservation_modified_date_time":"2020-12-26 23:51:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170932","reservation_id":"100153","confirmation_number":"SJ12697579487","room_confirmation_number":"SJ12668031535","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"106171","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-09 00:33:49","reservation_modified_date_time":"2020-12-27 19:39:39","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171136","reservation_id":"97463","confirmation_number":"SJ12674155514","room_confirmation_number":"SJ12681868729","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"103551","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-06 22:32:42","reservation_modified_date_time":"2020-12-28 17:18:24","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171857","reservation_id":"104414","confirmation_number":"SJ12671179752","room_confirmation_number":"SJ12688948753","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110763","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 01:48:07","reservation_modified_date_time":"2020-12-30 13:09:26","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110763","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3171920","reservation_id":"104143","confirmation_number":"SJ12649686271","room_confirmation_number":"SJ12620208022","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"110476","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-23 14:28:14","reservation_modified_date_time":"2020-12-30 16:38:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110476","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172142","reservation_id":"102093","confirmation_number":"SJ12646382893","room_confirmation_number":"SJ12638499642","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108225","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-30 00:23:09","reservation_modified_date_time":"2020-12-30 23:05:44","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108225","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3172223","reservation_id":"104469","confirmation_number":"SJ12651473228","room_confirmation_number":"SJ12678527921","room_stay_from":"2020-12-31","room_stay_to":"2021-01-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":"110823","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 16:31:09","reservation_modified_date_time":"2020-12-31 16:31:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110823","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172388","reservation_id":"104259","confirmation_number":"SJ12656315593","room_confirmation_number":"SJ12631688230","room_stay_from":"2020-12-31","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110609","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-26 19:03:11","reservation_modified_date_time":"2020-12-31 22:48:21","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110609","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","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":"3170793","reservation_id":"104293","confirmation_number":"SJ12667211257","room_confirmation_number":"SJ12688411107","room_stay_from":"2020-12-30","room_stay_to":"2021-01-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"110649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-27 14:41:09","reservation_modified_date_time":"2020-12-27 15:27:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110649","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3172440","reservation_id":"104500","confirmation_number":"SJ12628862875","room_confirmation_number":"SJ12649833231","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-01-01 03:43:44","reservation_modified_date_time":"2021-01-01 03:43:44","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","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":[]}}