{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-01-01","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":11,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1272,1289","block_room_bookings":[{"confirmation_number":"SJ12650067376","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJ12615466762","room_stay_from":"2021-01-01","room_stay_to":"2021-01-15","bundle_room":"0"}],"bundle_block_count":"1269,1270,1271,1272,1302,1303,1307,1308,1309,1310,1267,1268,1260,1261,1311,1312,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":"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":"SJB12638697996","room_stay_from":"2021-01-01","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":"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":"442.08","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":"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":"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":"415.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":"346.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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"}]},{"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":"Canceled","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","service_canceled_date_time":"2021-01-01 19:16:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"316.94","reservation_status_type":"","total_paid_amount":"0.00","deltaChange":-365.2,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"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":"Canceled","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","service_canceled_date_time":"2021-01-01 19:16:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"316.94","reservation_status_type":"room_dates_changed","total_paid_amount":"0.00","deltaChange":-365.2,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3172443","reservation_id":"104502","confirmation_number":"SJ12629851352","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"335.83,228.74","nightly_discount":"0,0","subtotal":"564.57","grand_total":"635.14","paid_amount":"635.14","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2698155602","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":"110857","customer_id":"110857","source_of_creation":"Booking.com","reservation_created_date":"2021-01-01 06:31:11","service_canceled_date_time":"2021-01-02 04:29:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"110.62","deltaChange":"691.39","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"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":"511.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":"3172709","reservation_id":"104544","confirmation_number":"SJ12623191569","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"335.92","nightly_discount":"0","subtotal":"335.92","grand_total":"377.91","paid_amount":"377.91","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1726884892","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":"110896","customer_id":"110896","source_of_creation":"Expedia","reservation_created_date":"2021-01-01 22:56:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"currentDayPrice":"335.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":"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,"sub_hotel_id":"126","group_rooms":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,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"425.27","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,"sub_hotel_id":"126","group_rooms":"1291,1711","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"}]},{"room_stay_id":"3172626","reservation_id":"102871","confirmation_number":"SJ12671598490","room_stay_from":"2021-01-01","room_stay_to":"2021-01-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,121.15","nightly_discount":"0.00,0.00,0.00","subtotal":"539.75","grand_total":"726.34","paid_amount":"726.34","room_type_id":"412","product_id":"1297","siteminder_id":"ABB-HMFZKA2ZRR","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"627.90","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109007","customer_id":"109007","source_of_creation":"Airbnb","reservation_created_date":"2020-11-20 05:06:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"96.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"209.30","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":"3172733","reservation_id":"104461","confirmation_number":"SJ12633748844","room_stay_from":"2021-01-01","room_stay_to":"2021-01-04","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"295.80,295.80,290.48","nightly_discount":"0.00,0.00,0.00","subtotal":"882.08","grand_total":"1022.20","paid_amount":"1022.20","room_type_id":"413","product_id":"1261","siteminder_id":"ABB-HMCTH5P2AK","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"887.40","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110814","customer_id":"110814","source_of_creation":"Airbnb","reservation_created_date":"2020-12-31 03:07:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"26.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"currentDayPrice":"295.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"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":"500.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"}]},{"room_stay_id":"3171791","reservation_id":"104409","confirmation_number":"SJ12627524521","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"494.00,300.90","nightly_discount":"0.00,0.00","subtotal":"794.90","grand_total":"894.27","paid_amount":"894.27","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110758","customer_id":"110758","source_of_creation":"FE","reservation_created_date":"2020-12-29 23:45:17","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"494.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":"3172534","reservation_id":"101832","confirmation_number":"SJ12628526933","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","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":"1066.50","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107928","customer_id":"107928","source_of_creation":"FE","reservation_created_date":"2020-10-22 04:13:34","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":"","changedComment":"both dates changed","deltaChange":"-454.00","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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3172655","reservation_id":"104537","confirmation_number":"SJ12691239597","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"338.00","nightly_discount":"0.00","subtotal":"338.00","grand_total":"380.25","paid_amount":"380.25","room_type_id":"319","product_id":"1306","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":"110887","customer_id":"110887","source_of_creation":"PMS","reservation_created_date":"2021-01-01 20:35:35","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":"","currentDayPrice":"338.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":"3172663","reservation_id":"104537","confirmation_number":"SJ12680304331","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"338.00","nightly_discount":"0.00","subtotal":"338.00","grand_total":"380.25","paid_amount":"380.25","room_type_id":"319","product_id":"1307","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":"110887","customer_id":"110887","source_of_creation":"PMS","reservation_created_date":"2021-01-01 20:35:35","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"338.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":"3172749","reservation_id":"104550","confirmation_number":"SJ12628189982","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00","nightly_discount":"0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110900","customer_id":"110900","source_of_creation":"PMS","reservation_created_date":"2021-01-02 00:23:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"200.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":"3172752","reservation_id":"104550","confirmation_number":"SJ12689329059","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00","nightly_discount":"0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110900","customer_id":"110900","source_of_creation":"PMS","reservation_created_date":"2021-01-02 00:23:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"200.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":"3172754","reservation_id":"104550","confirmation_number":"SJ12654120502","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00","nightly_discount":"0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","room_type_id":"319","product_id":"1917","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":"110900","customer_id":"110900","source_of_creation":"PMS","reservation_created_date":"2021-01-02 00:23:53","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":"","currentDayPrice":"200.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":"3172756","reservation_id":"104550","confirmation_number":"SJ12627314388","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00","nightly_discount":"0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110900","customer_id":"110900","source_of_creation":"PMS","reservation_created_date":"2021-01-02 00:23:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"200.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":"3171379","reservation_id":"104355","confirmation_number":"SJ12665100737","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"422.10,251.65","nightly_discount":"0.00,0.00","subtotal":"673.75","grand_total":"757.97","paid_amount":"757.97","room_type_id":"412","product_id":"1315","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":"110702","customer_id":"110702","source_of_creation":"PMS","reservation_created_date":"2020-12-28 23:14: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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"422.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172536","reservation_id":"104522","confirmation_number":"SJ12637195860","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.00,250.00","nightly_discount":"0.00,0.00","subtotal":"500.00","grand_total":"562.50","paid_amount":"562.50","room_type_id":"319","product_id":"1287","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":"109440","customer_id":"109440","source_of_creation":"PMS","reservation_created_date":"2021-01-01 17:33:05","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":"","currentDayPrice":"250.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"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":"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":"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":"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":"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":"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":"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":"114.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":"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":"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":"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":"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":"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":"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":"114.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":"114.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":"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":"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":"113.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":"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"}]},{"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":"Canceled","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","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-12-19 09:39:15","reservation_modified_date_time":"2020-12-19 09:39:15","customer_id":"110287","parentCustTravId":"110287","customer_traveller_id":"110287","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-01 19:16:37","canceled_nights_data":"","product_attribute_values":"extra_person#&#25.00","parentRoomStayFrom":"2020-12-31","deltaChange":-50,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"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":"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":"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":"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":"3172656","reservation_id":"104537","confirmation_number":"SJ12634070976","room_confirmation_number":"SJ12691239597","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"110887","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 20:35:35","reservation_modified_date_time":"2021-01-01 20:35:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110887","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":"3172664","reservation_id":"104537","confirmation_number":"SJ12634183965","room_confirmation_number":"SJ12680304331","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110887","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 20:35:35","reservation_modified_date_time":"2021-01-01 20:40:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110887","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172710","reservation_id":"104544","confirmation_number":"SJ12658440188","room_confirmation_number":"SJ12623191569","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"110896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 22:56:08","reservation_modified_date_time":"2021-01-01 22:56:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110896","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":"3172751","reservation_id":"104550","confirmation_number":"SJ12630599289","room_confirmation_number":"SJ12628189982","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 00:23:52","reservation_modified_date_time":"2021-01-02 00:24:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110900","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172753","reservation_id":"104550","confirmation_number":"SJ12673862134","room_confirmation_number":"SJ12689329059","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 00:23:52","reservation_modified_date_time":"2021-01-02 00:25:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110900","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172755","reservation_id":"104550","confirmation_number":"SJ12695318420","room_confirmation_number":"SJ12654120502","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 00:23:53","reservation_modified_date_time":"2021-01-02 00:25:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110900","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172757","reservation_id":"104550","confirmation_number":"SJ12651718396","room_confirmation_number":"SJ12627314388","room_stay_from":"2021-01-01","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 00:23:53","reservation_modified_date_time":"2021-01-02 00:25:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110900","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.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":"3171380","reservation_id":"104355","confirmation_number":"SJ12676245259","room_confirmation_number":"SJ12665100737","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"110702","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-28 23:14:44","reservation_modified_date_time":"2020-12-28 23:25:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110702","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":"3171792","reservation_id":"104409","confirmation_number":"SJ12690913891","room_confirmation_number":"SJ12627524521","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"110758","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 23:45:17","reservation_modified_date_time":"2020-12-29 23:45:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110758","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":"3172535","reservation_id":"101832","confirmation_number":"SJ12658499940","room_confirmation_number":"SJ12628526933","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"107928","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-22 04:13:34","reservation_modified_date_time":"2021-01-01 17:29:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107928","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"-25.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":"3172537","reservation_id":"104522","confirmation_number":"SJ12651523427","room_confirmation_number":"SJ12637195860","room_stay_from":"2021-01-01","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"109440","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 17:33:05","reservation_modified_date_time":"2021-01-01 17:33:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109440","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":"3172627","reservation_id":"102871","confirmation_number":"SJ12651813152","room_confirmation_number":"SJ12671598490","room_stay_from":"2021-01-01","room_stay_to":"2021-01-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"109007","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 05:06:06","reservation_modified_date_time":"2021-01-01 20:24:33","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109007","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","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":"3172735","reservation_id":"104461","confirmation_number":"SJ12673946854","room_confirmation_number":"SJ12633748844","room_stay_from":"2021-01-01","room_stay_to":"2021-01-04","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":"110814","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 03:07:06","reservation_modified_date_time":"2021-01-01 23:48:56","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110814","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":"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"}]},{"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":"Canceled","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-12-19 09:39:15","reservation_modified_date_time":"2020-12-19 09:39:15","customer_id":"110287","parentCustTravId":"110287","customer_traveller_id":"110287","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-01 19:16:37","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2020-12-31","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"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":"Canceled","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-12-19 09:39:11","reservation_modified_date_time":"2020-12-24 19:44:09","customer_id":"110287","parentCustTravId":"110287","customer_traveller_id":"110287","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-01 19:16:56","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2020-12-31","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3172498","reservation_id":"103525","confirmation_number":"SJ12694135632","room_confirmation_number":"SJ12639810697","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":"8.00","paid_amount":"8.00","product_id":"1663","service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-01 15:57:55","reservation_modified_date_time":"2021-01-01 15:57:55","customer_id":"109755","parentCustTravId":"109755","customer_traveller_id":"109755","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2020-12-30","currentDayPrice":"7.44","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":[]}}