{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-03-20","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":18,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1302,1303,1267,1268,1262,1263,1311,1312,1260,1261,1291,1711,1304,1305,1307,1308,1269,1270,1309,1310,1271,1272","bundle_block_bookings":[{"confirmation_number":"SJB12615595655","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12639146895","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12610585305","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12615360176","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12684014702","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12611974579","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12690052931","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12620527420","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12674659521","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12669900341","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12654073298","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12613872108","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12676167275","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12687074072","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12630496005","room_stay_from":"2021-03-16","room_stay_to":"2021-03-23","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12654194868","room_stay_from":"2021-03-16","room_stay_to":"2021-03-23","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12680996016","room_stay_from":"2021-03-20","room_stay_to":"2021-03-24","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12678109342","room_stay_from":"2021-03-20","room_stay_to":"2021-03-24","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12645865376","room_stay_from":"2021-03-20","room_stay_to":"2021-03-25","bundle_room":"1","product_id":"1324"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3181235","reservation_id":"105613","confirmation_number":"SJ12698902436","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"286.30,286.30,286.30,286.30,314.30,314.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1773.80","grand_total":"1995.53","paid_amount":"1995.53","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3268807783","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":"112034","customer_id":"112034","source_of_creation":"Booking.com","reservation_created_date":"2021-01-19 03:57:25","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"346.28","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"314.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186773","reservation_id":"106355","confirmation_number":"SJ12663383071","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"276.07,303.07,303.07","nightly_discount":"0,0,0","subtotal":"882.21","grand_total":"992.49","paid_amount":"992.49","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-3542333661","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":"112752","customer_id":"112752","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 22:48:22","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":"126","group_rooms":"1267,1268","currentDayPrice":"303.07","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":"3199162","reservation_id":"107780","confirmation_number":"SJ12640907882","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"210.87,210.87","nightly_discount":"0,0","subtotal":"421.74","grand_total":"474.46","paid_amount":"474.46","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2382679519","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":"114236","customer_id":"114236","source_of_creation":"Booking.com","reservation_created_date":"2021-02-16 13:42:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"210.87","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":"3215364","reservation_id":"110257","confirmation_number":"SJ12658606532","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-3196053210","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":"116774","customer_id":"116774","source_of_creation":"Booking.com","reservation_created_date":"2021-03-14 09:02:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"70.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"364.65","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":"3218554","reservation_id":"110689","confirmation_number":"SJ12650084651","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"328.19","nightly_discount":"0","subtotal":"328.19","grand_total":"369.21","paid_amount":"369.21","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3240751252","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":"117200","customer_id":"117200","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 04:17:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"63.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"328.19","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218601","reservation_id":"106225","confirmation_number":"SJ12644731106","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20","nightly_discount":"0,0","subtotal":"478.40","grand_total":"538.20","paid_amount":"538.20","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2862928196","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":"112631","customer_id":"112631","source_of_creation":"Booking.com","reservation_created_date":"2021-01-27 02:21:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"95.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.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":"3195784","reservation_id":"105389","confirmation_number":"SJ12656476633","room_stay_from":"2021-03-15","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,181.30,181.30,209.30,209.30,181.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1325.10","grand_total":"1490.74","paid_amount":"1490.74","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3841989126","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":"111787","customer_id":"111787","source_of_creation":"Booking.com","reservation_created_date":"2021-01-15 20:55:27","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204318","reservation_id":"107202","confirmation_number":"SJ12613533233","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"310.50,310.50,295.50","nightly_discount":"0,0,0","subtotal":"916.50","grand_total":"1031.07","paid_amount":"1031.07","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-3118479975","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":"113664","customer_id":"113664","source_of_creation":"Booking.com","reservation_created_date":"2021-02-09 03:17:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"178.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"310.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204943","reservation_id":"105755","confirmation_number":"SJ12637689180","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"4","nightly_price":"272.77,272.77,248.47","nightly_discount":"0,0,0","subtotal":"794.01","grand_total":"893.26","paid_amount":"893.26","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-3941507199","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":"112153","customer_id":"112153","source_of_creation":"Booking.com","reservation_created_date":"2021-01-20 23:06:18","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"156.42","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"272.77","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3207349","reservation_id":"109038","confirmation_number":"SJ12615924289","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,261.75","nightly_discount":"0,0,0","subtotal":"860.25","grand_total":"967.78","paid_amount":"967.78","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2328077573","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":"115502","customer_id":"115502","source_of_creation":"Booking.com","reservation_created_date":"2021-03-02 19:58:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"168.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"299.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3209446","reservation_id":"107383","confirmation_number":"SJ12651285864","room_stay_from":"2021-03-20","room_stay_to":"2021-03-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.30,202.30,202.30,202.30","nightly_discount":"0,0,0,0","subtotal":"823.20","grand_total":"926.10","paid_amount":"926.10","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2817389957","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":"113840","customer_id":"113840","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 23:58:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"166.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"216.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190090","reservation_id":"104629","confirmation_number":"SJ12610099839","room_stay_from":"2021-03-20","room_stay_to":"2021-03-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.37,163.17,163.17,163.17,163.17,163.17,188.37","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1192.59","grand_total":"1341.66","paid_amount":"1341.66","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-2459824362","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":"110985","customer_id":"110985","source_of_creation":"Booking.com","reservation_created_date":"2021-01-03 08:11:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"246.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.37","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":"3219478","reservation_id":"110720","confirmation_number":"SJ12613155638","room_stay_from":"2021-06-22","room_stay_to":"2021-06-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.30,195.30,195.30,223.30","nightly_discount":"0,0,0,0","subtotal":"809.20","grand_total":"910.35","paid_amount":"219.72","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2878775983","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":"117231","customer_id":"117231","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 15:46:20","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"163.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219549","reservation_id":"110753","confirmation_number":"SJ12693081916","room_stay_from":"2021-04-18","room_stay_to":"2021-04-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.25,209.25,209.25","nightly_discount":"0,0,0","subtotal":"642.75","grand_total":"723.10","paid_amount":"252.28","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3806750463","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":"117264","customer_id":"117264","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 20:28:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219580","reservation_id":"110784","confirmation_number":"SJ12652010227","room_stay_from":"2021-05-28","room_stay_to":"2021-06-01","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"335.30,335.30,293.30,293.30","nightly_discount":"0,0,0,0","subtotal":"1257.20","grand_total":"1414.35","paid_amount":"377.22","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3996876929","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":"117294","customer_id":"117294","source_of_creation":"Booking.com","reservation_created_date":"2021-03-20 02:18:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"244.32","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219757","reservation_id":"110756","confirmation_number":"SJ12690226732","room_stay_from":"2021-04-13","room_stay_to":"2021-04-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.86,199.86,218.09","nightly_discount":"0,0,0","subtotal":"617.81","grand_total":"695.04","paid_amount":"224.84","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3813875517","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":"117266","customer_id":"117266","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 21:07:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219827","reservation_id":"110760","confirmation_number":"SJ12674138557","room_stay_from":"2021-06-11","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.58,181.58,154.58","nightly_discount":"0,0,0","subtotal":"517.74","grand_total":"582.46","paid_amount":"204.28","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-3240727205","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":"117272","customer_id":"117272","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 21:18:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3183634","reservation_id":"105983","confirmation_number":"SJ12698964259","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"173.04,173.04,173.04,173.04,195.44,195.44","nightly_discount":"0,0,0,0,0,0","subtotal":"1083.04","grand_total":"1218.42","paid_amount":"1218.42","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1732379634","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":"112407","customer_id":"112407","source_of_creation":"Expedia","reservation_created_date":"2021-01-24 16:41:28","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":"195.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190438","reservation_id":"104405","confirmation_number":"SJ12691851776","room_stay_from":"2021-03-17","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.84,161.84,184.24,184.24","nightly_discount":"0,0,0,0","subtotal":"692.16","grand_total":"778.68","paid_amount":"778.68","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1726154407","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":"110754","customer_id":"110754","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 22:51:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192534","reservation_id":"106992","confirmation_number":"SJ12623105215","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.96,216.96","nightly_discount":"0,0","subtotal":"433.92","grand_total":"488.16","paid_amount":"488.16","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1735627930","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":"113429","customer_id":"113429","source_of_creation":"Expedia","reservation_created_date":"2021-02-05 22:30:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"216.96","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":"3204386","reservation_id":"106169","confirmation_number":"SJ12682371586","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"194.25,224.25,224.25","nightly_discount":"0,0,0","subtotal":"642.75","grand_total":"723.10","paid_amount":"723.10","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1732883244","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":"112576","customer_id":"112576","source_of_creation":"Expedia","reservation_created_date":"2021-01-26 16:31:15","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":"126","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218595","reservation_id":"107855","confirmation_number":"SJ12694501069","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"216.96,216.96","nightly_discount":"0,0","subtotal":"433.92","grand_total":"488.16","paid_amount":"488.16","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1738860159","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":"114313","customer_id":"114313","source_of_creation":"Expedia","reservation_created_date":"2021-02-17 01:08:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"216.96","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":"3219599","reservation_id":"109282","confirmation_number":"SJ12679230656","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"271.32","nightly_discount":"0","subtotal":"271.32","grand_total":"305.24","paid_amount":"305.24","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1743693222","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":"115751","customer_id":"115751","source_of_creation":"Expedia","reservation_created_date":"2021-03-04 01:42:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"271.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199665","reservation_id":"106255","confirmation_number":"SJ12661291649","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.40,179.40,155.40","nightly_discount":"0,0,0","subtotal":"514.20","grand_total":"578.48","paid_amount":"578.48","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1733169446","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":"112665","customer_id":"112665","source_of_creation":"Expedia","reservation_created_date":"2021-01-27 18:06:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.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":"3219179","reservation_id":"106491","confirmation_number":"SJ12629349535","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"197.40,197.40,173.40","nightly_discount":"0.00,0.00,0.00","subtotal":"568.20","grand_total":"639.23","paid_amount":"639.23","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1733962739","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":"112900","customer_id":"112900","source_of_creation":"Expedia","reservation_created_date":"2021-01-30 18:31:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"197.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216057","reservation_id":"109301","confirmation_number":"SJ12626360266","room_stay_from":"2021-03-20","room_stay_to":"2021-03-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"321.75,284.25,284.25,284.25,284.25,284.25,321.75","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2064.75","grand_total":"2322.85","paid_amount":"361.97","room_type_id":"319","product_id":"1276","siteminder_id":"EXP-1743749354","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":"115769","customer_id":"115769","source_of_creation":"Expedia","reservation_created_date":"2021-03-04 04:17:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"321.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192213","reservation_id":"106941","confirmation_number":"SJ12653587252","room_stay_from":"2021-03-20","room_stay_to":"2021-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.24,161.84,161.84,161.84,161.84,161.84,184.24,184.24,161.84,161.84","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1685.60","grand_total":"1896.30","paid_amount":"1896.30","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1735394557","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":"113376","customer_id":"113376","source_of_creation":"Expedia","reservation_created_date":"2021-02-05 01:55:42","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3198552","reservation_id":"105582","confirmation_number":"SJ12661606594","room_stay_from":"2021-03-20","room_stay_to":"2021-03-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.20,148.42,148.42,148.42","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"612.46","grand_total":"689.01","paid_amount":"689.01","room_type_id":"319","product_id":"1301","siteminder_id":"HTN-149842125-JF947A","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":"112003","customer_id":"112003","source_of_creation":"HotelTonight","reservation_created_date":"2021-01-18 23:10:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"167.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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3219668","reservation_id":"109975","confirmation_number":"SJ12639894008","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"330.33","nightly_discount":"0","subtotal":"330.33","grand_total":"371.62","paid_amount":"371.62","room_type_id":"413","product_id":"1272","siteminder_id":"GAM-R2373812576","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":"116474","customer_id":"116474","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-10 17:53:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"330.33","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3218039","reservation_id":"105511","confirmation_number":"SJ12624321203","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.50,262.14,262.14","nightly_discount":"0.00,0.00,0.00","subtotal":"781.78","grand_total":"905.97","paid_amount":"905.97","room_type_id":"413","product_id":"1266","siteminder_id":"ABB-HMJDXFX2MN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"786.42","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111926","customer_id":"111926","source_of_creation":"Airbnb","reservation_created_date":"2021-01-17 17:18:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"23.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"262.14","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3218060","reservation_id":"106788","confirmation_number":"SJ12688690931","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"392.64,399.84,399.84","nightly_discount":"0.00,0.00,0.00","subtotal":"1192.32","grand_total":"1381.74","paid_amount":"1381.74","room_type_id":"320","product_id":"1332","siteminder_id":"ABB-HM9YDYYTKC","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1199.52","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113211","customer_id":"113211","source_of_creation":"Airbnb","reservation_created_date":"2021-02-03 01:01:19","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"35.28","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"399.84","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":"3218754","reservation_id":"106798","confirmation_number":"SJ12632406384","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.92,298.30","nightly_discount":"0.00,0.00","subtotal":"600.22","grand_total":"695.57","paid_amount":"695.57","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HM5483T9WZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"603.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113222","customer_id":"113222","source_of_creation":"Airbnb","reservation_created_date":"2021-02-03 02:48:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"17.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"298.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":"3219378","reservation_id":"109597","confirmation_number":"SJ12666378749","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"500.86","nightly_discount":"0.00","subtotal":"500.86","grand_total":"580.42","paid_amount":"580.42","room_type_id":"320","product_id":"1714","siteminder_id":"ABB-HMT5X9CBE5","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"503.88","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116075","customer_id":"116075","source_of_creation":"Airbnb","reservation_created_date":"2021-03-06 19:52:06","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"14.82","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"500.86","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":"3215957","reservation_id":"104462","confirmation_number":"SJ12688246677","room_stay_from":"2021-03-15","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"248.15,248.15,248.15,248.15,248.15,248.15,237.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1726.80","grand_total":"2001.11","paid_amount":"2001.11","room_type_id":"319","product_id":"1319","siteminder_id":"ABB-HMDYAXS9C4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1737.05","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110815","customer_id":"110815","source_of_creation":"Airbnb","reservation_created_date":"2020-12-31 04:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"51.09","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"248.15","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":"3219386","reservation_id":"106446","confirmation_number":"SJ12685190048","room_stay_from":"2021-03-20","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"252.95,256.02","nightly_discount":"0.00,0.00","subtotal":"508.97","grand_total":"589.82","paid_amount":"589.82","room_type_id":"319","product_id":"1314","siteminder_id":"ABB-HMEAP5FC8N","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"512.04","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112847","customer_id":"112847","source_of_creation":"Airbnb","reservation_created_date":"2021-01-29 21:31:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"15.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"252.95","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":"3219692","reservation_id":"107507","confirmation_number":"SJ12675212880","room_stay_from":"2021-03-20","room_stay_to":"2021-03-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"332.72,332.72,332.72,332.72,322.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1653.78","grand_total":"1916.49","paid_amount":"1916.49","room_type_id":"412","product_id":"1921","siteminder_id":"ABB-HMB9MRHFMZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1663.60","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113965","customer_id":"113965","source_of_creation":"Airbnb","reservation_created_date":"2021-02-13 14:35:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"48.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"332.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3218191","reservation_id":"105357","confirmation_number":"SJ12635648603","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00","nightly_discount":"0,0","subtotal":"238.00","grand_total":"267.75","paid_amount":"267.75","room_type_id":"319","product_id":"1913","siteminder_id":"HWR-303122358","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":"111748","customer_id":"111748","source_of_creation":"Hotwire","reservation_created_date":"2021-01-15 01:48:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"119.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":"3200122","reservation_id":"105012","confirmation_number":"SJ12669938089","room_stay_from":"2021-03-20","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"119.00,99.00","nightly_discount":"0,0","subtotal":"218.00","grand_total":"245.25","paid_amount":"245.25","room_type_id":"413","product_id":"1260","siteminder_id":"HWR-303091359","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":"111380","customer_id":"111380","source_of_creation":"Hotwire","reservation_created_date":"2021-01-08 17:34:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"119.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3219666","reservation_id":"109545","confirmation_number":"SJ12683779217","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"339.15","nightly_discount":"0.00","subtotal":"339.15","grand_total":"381.55","paid_amount":"381.55","room_type_id":"413","product_id":"1265","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":"116027","customer_id":"116027","source_of_creation":"FE","reservation_created_date":"2021-03-06 00:58:45","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"339.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185563","reservation_id":"105469","confirmation_number":"SJ12639372780","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"306.75,336.75,336.75,306.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1287.00","grand_total":"1447.88","paid_amount":"1447.88","room_type_id":"320","product_id":"1329","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":"111878","customer_id":"111878","source_of_creation":"FE","reservation_created_date":"2021-01-16 20:30:46","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","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":"1304,1305","currentDayPrice":"336.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218299","reservation_id":"105853","confirmation_number":"SJ12689670857","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"216.75,246.75,246.75,216.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"927.00","grand_total":"1042.88","paid_amount":"1042.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112257","customer_id":"112257","source_of_creation":"FE","reservation_created_date":"2021-01-22 15:32:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3176284","reservation_id":"105013","confirmation_number":"SJ12690887633","room_stay_from":"2021-03-16","room_stay_to":"2021-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"306.75,306.75,306.75,336.75,336.75,306.75,306.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2207.25","grand_total":"2483.15","paid_amount":"2483.15","room_type_id":"320","product_id":"1323","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":"111377","customer_id":"111377","source_of_creation":"FE","reservation_created_date":"2021-01-08 17:41:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","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":"1269,1270","currentDayPrice":"336.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3216097","reservation_id":"110363","confirmation_number":"SJ12656091858","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0.00","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"319","product_id":"1277","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":"116874","customer_id":"116874","source_of_creation":"PMS","reservation_created_date":"2021-03-15 17:40:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"364.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216921","reservation_id":"106087","confirmation_number":"SJ12663709695","room_stay_from":"2021-03-17","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,209.30,209.30","nightly_discount":"9.07,9.07,10.47,10.47","subtotal":"781.20","grand_total":"834.89","paid_amount":"834.89","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112509","customer_id":"112509","source_of_creation":"PMS","reservation_created_date":"2021-01-25 19:09:56","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.30","currentDayDiscount":"10.47","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204324","reservation_id":"106335","confirmation_number":"SJ12649884231","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.50,265.50,265.50,235.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1002.00","grand_total":"1127.25","paid_amount":"1127.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":"112730","customer_id":"112730","source_of_creation":"PMS","reservation_created_date":"2021-01-28 16:48:35","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":"265.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218331","reservation_id":"105586","confirmation_number":"SJ12697872291","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,224.25,224.25,194.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"837.00","grand_total":"941.63","paid_amount":"941.63","room_type_id":"319","product_id":"1286","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":"112007","customer_id":"112007","source_of_creation":"PMS","reservation_created_date":"2021-01-18 23:46:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219158","reservation_id":"108734","confirmation_number":"SJ12653140862","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"364.65,364.65,322.15","nightly_discount":"18.23,18.23,16.11","subtotal":"1051.45","grand_total":"1123.74","paid_amount":"1123.74","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":"115187","customer_id":"115187","source_of_creation":"PMS","reservation_created_date":"2021-02-27 16:36:22","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"364.65","currentDayDiscount":"18.23","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186740","reservation_id":"105559","confirmation_number":"SJ12639093755","room_stay_from":"2021-03-18","room_stay_to":"2021-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,224.25,224.25,194.25,194.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1031.25","grand_total":"1160.15","paid_amount":"1160.15","room_type_id":"319","product_id":"1916","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":"111979","customer_id":"111979","source_of_creation":"PMS","reservation_created_date":"2021-01-18 16:24:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218328","reservation_id":"105794","confirmation_number":"SJ12633230040","room_stay_from":"2021-03-18","room_stay_to":"2021-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.65,279.65,279.65,279.65,279.65","nightly_discount":"0.00,0.00,0,0,0","subtotal":"1364.25","grand_total":"1534.78","paid_amount":"1534.78","room_type_id":"319","product_id":"1915","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":"112199","customer_id":"112199","source_of_creation":"PMS","reservation_created_date":"2021-01-21 18:09:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"279.65","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":"3191338","reservation_id":"106783","confirmation_number":"SJ12615109250","room_stay_from":"2021-03-20","room_stay_to":"2021-03-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"336.75,306.75,306.75,306.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1257.00","grand_total":"1414.13","paid_amount":"1414.13","room_type_id":"320","product_id":"1910","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113205","customer_id":"113205","source_of_creation":"PMS","reservation_created_date":"2021-02-03 00:18:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1309,1310","currentDayPrice":"336.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3193461","reservation_id":"106658","confirmation_number":"SJ12666188576","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-01 22:04:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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"}]},{"room_stay_id":"3198823","reservation_id":"95532","confirmation_number":"SJ12633661106","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"794.99","grand_total":"794.99","paid_amount":"0.00","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-28 13:54:56","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":"","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":"3211124","reservation_id":"105424","confirmation_number":"SJ12644018896","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","paid_amount":"0.00","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-01-16 02:35:22","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":"178.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":"3190076","reservation_id":"106306","confirmation_number":"SJ12619317972","room_stay_from":"2021-03-20","room_stay_to":"2021-03-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.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":"2021-01-28 00:13: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":"","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3199160","reservation_id":"107780","confirmation_number":"SJ12633292361","room_confirmation_number":"SJ12640907882","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"114236","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-16 17:48:14","reservation_modified_date_time":"2021-02-16 17:48:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114236","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218300","reservation_id":"105853","confirmation_number":"SJ12696087677","room_confirmation_number":"SJ12689670857","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"25.00,25.00,0.00,0.00","subtotal":"100.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"112257","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-18 20:32:28","reservation_modified_date_time":"2021-03-18 20:33:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112257","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219331","reservation_id":"110771","confirmation_number":"SJ12647645420","room_confirmation_number":"SJ12690558838","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"117282","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-20 13:48:37","reservation_modified_date_time":"2021-03-20 13:48:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117282","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","changedComment":"Reservation created for complete past date","deltaChange":"25.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219511","reservation_id":"109682","confirmation_number":"SJ12619143098","room_confirmation_number":"SJ12681922802","room_stay_from":"2021-03-22","room_stay_to":"2021-03-25","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"116169","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-20 17:51:41","reservation_modified_date_time":"2021-03-20 17:51:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116169","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3181236","reservation_id":"105613","confirmation_number":"SJ12685821092","room_confirmation_number":"SJ12698902436","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","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":"112034","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 03:57:25","reservation_modified_date_time":"2021-01-19 03:57:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112034","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3183633","reservation_id":"105983","confirmation_number":"SJ12664731509","room_confirmation_number":"SJ12698964259","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","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":"112407","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 16:41:28","reservation_modified_date_time":"2021-01-24 17:20:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112407","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186772","reservation_id":"106355","confirmation_number":"SJ12625327187","room_confirmation_number":"SJ12663383071","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","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":"112752","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 22:48:22","reservation_modified_date_time":"2021-01-29 03:09:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190439","reservation_id":"104405","confirmation_number":"SJ12694732822","room_confirmation_number":"SJ12691851776","room_stay_from":"2021-03-17","room_stay_to":"2021-03-21","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":"110754","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 22:51:10","reservation_modified_date_time":"2021-02-02 18:50:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110754","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192535","reservation_id":"106992","confirmation_number":"SJ12653786359","room_confirmation_number":"SJ12623105215","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"113429","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 22:30:12","reservation_modified_date_time":"2021-02-05 22:30:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113429","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3193462","reservation_id":"106658","confirmation_number":"SJ12666744684","room_confirmation_number":"SJ12666188576","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","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":"113076","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 22:04:12","reservation_modified_date_time":"2021-02-07 16:43:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199161","reservation_id":"107780","confirmation_number":"SJ12650308146","room_confirmation_number":"SJ12640907882","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"114236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 13:42:17","reservation_modified_date_time":"2021-02-16 17:48:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114236","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204387","reservation_id":"106169","confirmation_number":"SJ12637861055","room_confirmation_number":"SJ12682371586","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","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":"112576","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 16:31:15","reservation_modified_date_time":"2021-02-25 15:42:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112576","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215365","reservation_id":"110257","confirmation_number":"SJ12627560685","room_confirmation_number":"SJ12658606532","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","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":"116774","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-14 09:02:12","reservation_modified_date_time":"2021-03-14 09:02:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116774","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216098","reservation_id":"110363","confirmation_number":"SJ12682898736","room_confirmation_number":"SJ12656091858","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","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":"116874","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-15 17:40:10","reservation_modified_date_time":"2021-03-15 17:40:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116874","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216922","reservation_id":"106087","confirmation_number":"SJ12630861654","room_confirmation_number":"SJ12663709695","room_stay_from":"2021-03-17","room_stay_to":"2021-03-21","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":"112509","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 19:09:56","reservation_modified_date_time":"2021-03-16 22:17:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112509","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218040","reservation_id":"105511","confirmation_number":"SJ12688211615","room_confirmation_number":"SJ12624321203","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","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":"111926","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 17:18:11","reservation_modified_date_time":"2021-03-18 14:26:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111926","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3218063","reservation_id":"106788","confirmation_number":"SJ12651688484","room_confirmation_number":"SJ12688690931","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","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":"113211","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 01:01:19","reservation_modified_date_time":"2021-03-18 14:30:19","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113211","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3218192","reservation_id":"105357","confirmation_number":"SJ12678357835","room_confirmation_number":"SJ12635648603","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"111748","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 01:48:10","reservation_modified_date_time":"2021-03-18 17:10:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111748","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218555","reservation_id":"110689","confirmation_number":"SJ12668591302","room_confirmation_number":"SJ12650084651","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","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":"117200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 04:17:10","reservation_modified_date_time":"2021-03-19 04:17:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117200","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218598","reservation_id":"107855","confirmation_number":"SJ12675436334","room_confirmation_number":"SJ12694501069","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"114313","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 01:08:17","reservation_modified_date_time":"2021-03-19 12:50:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114313","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218602","reservation_id":"106225","confirmation_number":"SJ12619537746","room_confirmation_number":"SJ12644731106","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"112631","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 02:21:11","reservation_modified_date_time":"2021-03-19 12:51:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112631","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218755","reservation_id":"106798","confirmation_number":"SJ12650375922","room_confirmation_number":"SJ12632406384","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"113222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 02:48:12","reservation_modified_date_time":"2021-03-19 16:02:54","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3219381","reservation_id":"109597","confirmation_number":"SJ12639019709","room_confirmation_number":"SJ12666378749","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","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":"116075","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 19:52:06","reservation_modified_date_time":"2021-03-20 15:24:53","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116075","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3219600","reservation_id":"109282","confirmation_number":"SJ12675052629","room_confirmation_number":"SJ12679230656","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","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":"115751","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 01:42:11","reservation_modified_date_time":"2021-03-20 19:39:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115751","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219667","reservation_id":"109545","confirmation_number":"SJ12650512356","room_confirmation_number":"SJ12683779217","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","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":"116027","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 00:58:45","reservation_modified_date_time":"2021-03-20 21:09:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116027","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219669","reservation_id":"109975","confirmation_number":"SJ12640280046","room_confirmation_number":"SJ12639894008","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","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":"116474","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 17:53:10","reservation_modified_date_time":"2021-03-20 21:09:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116474","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185566","reservation_id":"105469","confirmation_number":"SJ12628605254","room_confirmation_number":"SJ12639372780","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","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":"111878","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 20:30:46","reservation_modified_date_time":"2021-01-27 16:01:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111878","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3195785","reservation_id":"105389","confirmation_number":"SJ12613660095","room_confirmation_number":"SJ12656476633","room_stay_from":"2021-03-15","room_stay_to":"2021-03-22","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":"111787","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 20:55:27","reservation_modified_date_time":"2021-02-11 13:37:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111787","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199666","reservation_id":"106255","confirmation_number":"SJ12657725353","room_confirmation_number":"SJ12661291649","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","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":"112665","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 18:06:18","reservation_modified_date_time":"2021-02-17 16:23:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112665","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200124","reservation_id":"105012","confirmation_number":"SJ12615304753","room_confirmation_number":"SJ12669938089","room_stay_from":"2021-03-20","room_stay_to":"2021-03-22","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":"111380","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-08 17:34:11","reservation_modified_date_time":"2021-02-18 11:17:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204319","reservation_id":"107202","confirmation_number":"SJ12623042019","room_confirmation_number":"SJ12613533233","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","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":"113664","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 03:17:11","reservation_modified_date_time":"2021-02-25 14:53:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113664","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204325","reservation_id":"106335","confirmation_number":"SJ12687493051","room_confirmation_number":"SJ12649884231","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","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":"112730","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 16:48:35","reservation_modified_date_time":"2021-02-25 14:54:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112730","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204944","reservation_id":"105755","confirmation_number":"SJ12643710663","room_confirmation_number":"SJ12637689180","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"112153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 23:06:18","reservation_modified_date_time":"2021-02-26 11:52:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3207350","reservation_id":"109038","confirmation_number":"SJ12626471164","room_confirmation_number":"SJ12615924289","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","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":"115502","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 19:58:13","reservation_modified_date_time":"2021-03-02 20:03:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115502","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215958","reservation_id":"104462","confirmation_number":"SJ12682627802","room_confirmation_number":"SJ12688246677","room_stay_from":"2021-03-15","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110815","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 04:01:06","reservation_modified_date_time":"2021-03-15 12:38:01","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110815","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3218301","reservation_id":"105853","confirmation_number":"SJ12696059365","room_confirmation_number":"SJ12689670857","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","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":"112257","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-22 15:32:42","reservation_modified_date_time":"2021-03-18 20:33:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112257","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218332","reservation_id":"105586","confirmation_number":"SJ12668206512","room_confirmation_number":"SJ12697872291","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","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":"112007","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:46:36","reservation_modified_date_time":"2021-03-18 21:24:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112007","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219159","reservation_id":"108734","confirmation_number":"SJ12674513742","room_confirmation_number":"SJ12653140862","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"25.00,25.00,0.00","subtotal":"75.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"115187","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 16:36:22","reservation_modified_date_time":"2021-03-19 22:25:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115187","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219180","reservation_id":"106491","confirmation_number":"SJ12655786397","room_confirmation_number":"SJ12629349535","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","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":"112900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 18:31:07","reservation_modified_date_time":"2021-03-19 22:59:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112900","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219387","reservation_id":"106446","confirmation_number":"SJ12670374680","room_confirmation_number":"SJ12685190048","room_stay_from":"2021-03-20","room_stay_to":"2021-03-22","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":"112847","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 21:31:06","reservation_modified_date_time":"2021-03-20 15:49:17","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112847","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3176285","reservation_id":"105013","confirmation_number":"SJ12630098404","room_confirmation_number":"SJ12690887633","room_stay_from":"2021-03-16","room_stay_to":"2021-03-23","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":"111377","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-08 17:41:13","reservation_modified_date_time":"2021-01-08 17:41:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111377","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186741","reservation_id":"105559","confirmation_number":"SJ12632455561","room_confirmation_number":"SJ12639093755","room_stay_from":"2021-03-18","room_stay_to":"2021-03-23","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":"111979","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 16:24:15","reservation_modified_date_time":"2021-01-29 03:07:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111979","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218330","reservation_id":"105794","confirmation_number":"SJ12620652603","room_confirmation_number":"SJ12633230040","room_stay_from":"2021-03-18","room_stay_to":"2021-03-23","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":"112199","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 18:09:56","reservation_modified_date_time":"2021-03-18 21:24:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112199","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3191341","reservation_id":"106783","confirmation_number":"SJ12677849326","room_confirmation_number":"SJ12615109250","room_stay_from":"2021-03-20","room_stay_to":"2021-03-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"113205","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 00:18:10","reservation_modified_date_time":"2021-02-04 01:26:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113205","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3198553","reservation_id":"105582","confirmation_number":"SJ12645115809","room_confirmation_number":"SJ12661606594","room_stay_from":"2021-03-20","room_stay_to":"2021-03-24","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112003","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:10:12","reservation_modified_date_time":"2021-02-15 19:30:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112003","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3209447","reservation_id":"107383","confirmation_number":"SJ12695722214","room_confirmation_number":"SJ12651285864","room_stay_from":"2021-03-20","room_stay_to":"2021-03-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"113840","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 23:58:07","reservation_modified_date_time":"2021-03-05 05:04:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113840","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219408","reservation_id":"107507","confirmation_number":"SJ12697002690","room_confirmation_number":"SJ12675212880","room_stay_from":"2021-03-20","room_stay_to":"2021-03-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113965","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-13 14:35:08","reservation_modified_date_time":"2021-03-20 16:10:46","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113965","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3198825","reservation_id":"95532","confirmation_number":"SJ12672827816","room_confirmation_number":"SJ12633661106","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","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":"101718","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 13:54:56","reservation_modified_date_time":"2021-02-16 01:23:47","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211123","reservation_id":"105424","confirmation_number":"SJ12621938761","room_confirmation_number":"SJ12644018896","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","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":"111827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 02:35:22","reservation_modified_date_time":"2021-03-07 15:18:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"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":"3190078","reservation_id":"106306","confirmation_number":"SJ12672567784","room_confirmation_number":"SJ12619317972","room_stay_from":"2021-03-20","room_stay_to":"2021-03-27","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":"112701","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 00:13:53","reservation_modified_date_time":"2021-02-02 16:40:39","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190093","reservation_id":"104629","confirmation_number":"SJ12684983652","room_confirmation_number":"SJ12610099839","room_stay_from":"2021-03-20","room_stay_to":"2021-03-27","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":"110985","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-03 08:11:12","reservation_modified_date_time":"2021-02-02 16:48:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110985","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216056","reservation_id":"109301","confirmation_number":"SJ12674210335","room_confirmation_number":"SJ12626360266","room_stay_from":"2021-03-20","room_stay_to":"2021-03-27","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":"115769","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 04:17:32","reservation_modified_date_time":"2021-03-15 16:46:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115769","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192212","reservation_id":"106941","confirmation_number":"SJ12694466807","room_confirmation_number":"SJ12653587252","room_stay_from":"2021-03-20","room_stay_to":"2021-03-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"113376","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 01:55:42","reservation_modified_date_time":"2021-02-05 14:08:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113376","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219479","reservation_id":"110720","confirmation_number":"SJ12627999593","room_confirmation_number":"SJ12613155638","room_stay_from":"2021-06-22","room_stay_to":"2021-06-26","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117231","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 15:46:20","reservation_modified_date_time":"2021-03-20 17:45:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117231","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219548","reservation_id":"110753","confirmation_number":"SJ12665484288","room_confirmation_number":"SJ12693081916","room_stay_from":"2021-04-18","room_stay_to":"2021-04-21","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":"117264","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 20:28:17","reservation_modified_date_time":"2021-03-20 18:24:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117264","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219583","reservation_id":"110784","confirmation_number":"SJ12677327360","room_confirmation_number":"SJ12652010227","room_stay_from":"2021-05-28","room_stay_to":"2021-06-01","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117294","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 02:18:11","reservation_modified_date_time":"2021-03-20 19:03:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117294","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219756","reservation_id":"110756","confirmation_number":"SJ12664795823","room_confirmation_number":"SJ12690226732","room_stay_from":"2021-04-13","room_stay_to":"2021-04-16","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":"117266","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 21:07:28","reservation_modified_date_time":"2021-03-20 23:52:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117266","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219826","reservation_id":"110760","confirmation_number":"SJ12662577901","room_confirmation_number":"SJ12674138557","room_stay_from":"2021-06-11","room_stay_to":"2021-06-14","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":"117272","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 21:18:22","reservation_modified_date_time":"2021-03-21 02:48:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117272","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3219342","reservation_id":"106983","confirmation_number":"SJ12688916313","room_confirmation_number":"SJ12638298540","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"112.52","paid_amount":"112.52","product_id":"1710","service_quantity":"4","product_name":"Late Departure Check-Out","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-20 13:59:47","reservation_modified_date_time":"2021-03-20 13:59:47","customer_id":"113419","parentCustTravId":"113419","customer_traveller_id":"113419","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-13","sub_hotel_id":"126","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"3219366","reservation_id":"105487","confirmation_number":"SJ12642995109","room_confirmation_number":"SJ12697747327","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1861","service_quantity":"1","product_name":"Incidentals","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-20 15:03:07","reservation_modified_date_time":"2021-03-20 15:03:22","customer_id":"111902","parentCustTravId":"111902","customer_traveller_id":"111902","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-13","sub_hotel_id":"126","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"3219439","reservation_id":"106156","confirmation_number":"SJ12649235491","room_confirmation_number":"SJ12622430278","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1861","service_quantity":"1","product_name":"Incidentals","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-20 17:11:38","reservation_modified_date_time":"2021-03-20 17:11:38","customer_id":"112569","parentCustTravId":"112569","customer_traveller_id":"112569","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-17","sub_hotel_id":"0","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"3219578","reservation_id":"110822","confirmation_number":"SJ12660589072","room_confirmation_number":"SJ12659607835","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":"1660","service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-20 18:59:57","reservation_modified_date_time":"2021-03-20 18:59:57","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"2.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3219438","reservation_id":"106156","confirmation_number":"SJ12620942796","room_confirmation_number":"SJ12622430278","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"75.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-20 17:11:27","reservation_modified_date_time":"2021-03-20 17:11:27","customer_id":"112569","parentCustTravId":"112569","customer_traveller_id":"112569","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-17","sub_hotel_id":"0","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3219603","reservation_id":"106941","confirmation_number":"SJ12625415157","room_confirmation_number":"SJ12653587252","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"75.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-20 19:49:18","reservation_modified_date_time":"2021-03-20 19:49:18","customer_id":"113376","parentCustTravId":"113376","customer_traveller_id":"113376","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-20","sub_hotel_id":"126","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}