{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-08-23","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":13,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1273,1291,1264,1271,1756,1301,1314,1289,1921","block_room_bookings":[{"confirmation_number":"SJ12646427749","room_stay_from":"2021-08-13","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1273"},{"confirmation_number":"SJ12661674363","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJ12677785061","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1264"},{"confirmation_number":"SJ12640354932","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJ12659689952","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1756"},{"confirmation_number":"SJ12695565593","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1301"},{"confirmation_number":"SJ12647737163","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1314"},{"confirmation_number":"SJ12669866915","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12679795588","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1921"}],"bundle_block_count":"1260,1261,1304,1305,1291,1711,1262,1263,1307,1308,1311,1312,1302,1303,1269,1270,1309,1310,1271,1272,1267,1268","bundle_block_bookings":[{"confirmation_number":"SJB12622872088","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12637171200","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12688828514","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12655865910","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12669306396","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12620058753","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12653735161","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12661822481","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12663195191","room_stay_from":"2021-08-22","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12670661239","room_stay_from":"2021-08-22","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12661739072","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12664827599","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12670566446","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12667549079","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12621825725","room_stay_from":"2021-08-22","room_stay_to":"2021-08-24","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12684255350","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","bundle_room":"1","product_id":"1322"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3244056","reservation_id":"114186","confirmation_number":"SJ12627199091","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"244.30,244.30,244.30,244.30,244.30,314.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1535.80","grand_total":"1727.78","paid_amount":"1727.78","room_type_id":"320","product_id":"1329","siteminder_id":"BDC-3749509754","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":"120827","customer_id":"120827","source_of_creation":"Booking.com","reservation_created_date":"2021-04-30 02:13:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"303.44","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"244.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":"3293904","reservation_id":"120488","confirmation_number":"SJ12678815947","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.30,300.30,230.30,230.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1752.10","grand_total":"1971.12","paid_amount":"1971.12","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-3035373619","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":"127802","customer_id":"127802","source_of_creation":"Booking.com","reservation_created_date":"2021-07-31 20:58:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.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":"3300440","reservation_id":"120923","confirmation_number":"SJ12627898509","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.83,201.83,201.83","nightly_discount":"0,0,0","subtotal":"605.49","grand_total":"681.17","paid_amount":"681.17","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3946308228","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":"128334","customer_id":"128334","source_of_creation":"Booking.com","reservation_created_date":"2021-08-08 02:26:22","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":"201.83","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":"3303478","reservation_id":"121282","confirmation_number":"SJ12634904040","room_stay_from":"2021-08-21","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.87,139.12,139.12","nightly_discount":"0,0,0","subtotal":"478.11","grand_total":"537.88","paid_amount":"537.88","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2725140938","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":"128753","customer_id":"128753","source_of_creation":"Booking.com","reservation_created_date":"2021-08-16 16:10:18","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305834","reservation_id":"121613","confirmation_number":"SJ12640639749","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"941.50","grand_total":"1059.19","paid_amount":"1059.19","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3010268276","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":"129114","customer_id":"129114","source_of_creation":"Booking.com","reservation_created_date":"2021-08-20 22:28:37","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":"160.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305979","reservation_id":"117746","confirmation_number":"SJ12686652854","room_stay_from":"2021-08-22","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"2","nightly_price":"269.2,293.2","nightly_discount":"0,0","subtotal":"562.40","grand_total":"632.70","paid_amount":"632.70","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-2180637446","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124721","customer_id":"124721","source_of_creation":"Booking.com","reservation_created_date":"2021-06-21 05:12:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"128.23","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"293.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"4151078","reservation_id":"115765","confirmation_number":"SJ12627565711","room_stay_from":"2021-08-23","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.37,125.37,125.37,125.37,188.37,188.37,125.37","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1003.59","grand_total":"1129.04","paid_amount":"1129.04","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3927548053","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":"122542","customer_id":"122542","source_of_creation":"Booking.com","reservation_created_date":"2021-05-24 01:46:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"212.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"125.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"}]}],"bdc_non_taxable":[{"room_stay_id":"3305988","reservation_id":"120326","confirmation_number":"SJ12658726997","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"228.74","nightly_discount":"0","subtotal":"228.74","grand_total":"228.74","paid_amount":"253.74","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-3605167798","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"127595","customer_id":"127595","source_of_creation":"Booking.com","reservation_created_date":"2021-07-29 04:51:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"45.67","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"228.74","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_taxable":[{"room_stay_id":"3173084","reservation_id":"104602","confirmation_number":"SJ12693312759","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.20,159.20","nightly_discount":"0,0","subtotal":"318.40","grand_total":"358.20","paid_amount":"358.20","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1727086101","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":"110953","customer_id":"110953","source_of_creation":"Expedia","reservation_created_date":"2021-01-02 20:51:08","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"159.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":"3305852","reservation_id":"121614","confirmation_number":"SJ12667172152","room_stay_from":"2021-08-21","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,142.24,142.24,142.24","nightly_discount":"0,0,0,0","subtotal":"594.16","grand_total":"668.43","paid_amount":"668.43","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1819053484","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":"129115","customer_id":"129115","source_of_creation":"Expedia","reservation_created_date":"2021-08-20 22:44:21","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":"142.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":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3305350","reservation_id":"121204","confirmation_number":"SJ12636106363","room_stay_from":"2021-08-20","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.02,256.02,256.02,249.88","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1017.94","grand_total":"1179.65","paid_amount":"1179.65","room_type_id":"319","product_id":"1306","siteminder_id":"ABB-HMSKWNXWXH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1024.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128672","customer_id":"128672","source_of_creation":"Airbnb","reservation_created_date":"2021-08-14 23:40:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"30.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"249.88","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":"5179025","reservation_id":"117723","confirmation_number":"SJ12615970802","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"345.77","nightly_discount":"0.00","subtotal":"345.77","grand_total":"400.69","paid_amount":"400.69","room_type_id":"320","product_id":"1910","siteminder_id":"ABB-HMR52ZTRHH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"347.82","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124699","customer_id":"124699","source_of_creation":"Airbnb","reservation_created_date":"2021-06-20 21:57:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"10.23","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"345.77","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":"5208348","reservation_id":"121175","confirmation_number":"SJ12663819545","room_stay_from":"2021-08-21","room_stay_to":"2021-08-24","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.13,268.26,251.37","nightly_discount":"0.00,0.00,0.00","subtotal":"698.76","grand_total":"804.78","paid_amount":"804.78","room_type_id":"319","product_id":"1293","siteminder_id":"ABB-HMT3WZ5SWX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"567.12","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128636","customer_id":"128636","source_of_creation":"Airbnb","reservation_created_date":"2021-08-14 15:52:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"16.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"251.37","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":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3293167","reservation_id":"120464","confirmation_number":"SJ12650427639","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127768","customer_id":"127768","source_of_creation":"FE","reservation_created_date":"2021-07-31 13:51:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3303716","reservation_id":"119398","confirmation_number":"SJ12613112540","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"322.15","nightly_discount":"0.00","subtotal":"322.15","grand_total":"362.42","paid_amount":"362.42","room_type_id":"320","product_id":"1330","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126445","customer_id":"126445","source_of_creation":"FE","reservation_created_date":"2021-07-15 17:23:26","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"322.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":"3305297","reservation_id":"116002","confirmation_number":"SJ12622216430","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,149.25,149.25,149.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"597.00","grand_total":"671.63","paid_amount":"671.63","room_type_id":"412","product_id":"1316","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":"122811","customer_id":"122811","source_of_creation":"FE","reservation_created_date":"2021-05-27 19:50:54","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"149.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":"5178977","reservation_id":"121746","confirmation_number":"SJ12653752952","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"194.65,194.65","nightly_discount":"0.00,0.00","subtotal":"389.30","grand_total":"437.97","paid_amount":"437.97","room_type_id":"318","product_id":"1281","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":"129290","customer_id":"129290","source_of_creation":"FE","reservation_created_date":"2021-08-23 13:44:27","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":"","sub_hotel_id":"0","currentDayPrice":"194.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3276386","reservation_id":"118466","confirmation_number":"SJ12669343965","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.15","nightly_discount":"0.00","subtotal":"220.15","grand_total":"247.67","paid_amount":"247.67","room_type_id":"319","product_id":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125497","customer_id":"125497","source_of_creation":"PMS","reservation_created_date":"2021-07-01 16:15:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"220.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":"3305921","reservation_id":"120114","confirmation_number":"SJ12656866521","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"227.15,227.15,201.65","nightly_discount":"22.72,22.72,20.17","subtotal":"655.95","grand_total":"664.14","paid_amount":"664.14","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112991","customer_id":"112991","source_of_creation":"PMS","reservation_created_date":"2021-07-26 17:07:49","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":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"227.15","currentDayDiscount":"22.72","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5208457","reservation_id":"121637","confirmation_number":"SJ12652845327","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15,169.15,169.15","nightly_discount":"8.46,8.46,8.46","subtotal":"507.45","grand_total":"542.33","paid_amount":"542.33","room_type_id":"413","product_id":"1272","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":"129155","customer_id":"129155","source_of_creation":"PMS","reservation_created_date":"2021-08-21 14:06:27","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":"AAA","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"169.15","currentDayDiscount":"8.46","productIsTaxExempt":false,"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":[{"room_stay_id":"5204819","reservation_id":"115356","confirmation_number":"SJ12610691787","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"489.38","paid_amount":"0.00","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-16 23:19:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":"32.63","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5205772","reservation_id":"110723","confirmation_number":"SJ12645910859","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"489.38","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-19 15:58:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":"21.75","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5206010","reservation_id":"115170","confirmation_number":"SJ12658016821","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"489.38","paid_amount":"0.00","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-13 22:45:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"87.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":"5206017","reservation_id":"115171","confirmation_number":"SJ12620798016","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"489.38","paid_amount":"0.00","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-13 22:55:27","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","currentDayPrice":"87.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":"5206262","reservation_id":"116034","confirmation_number":"SJ12673544332","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"685.13","paid_amount":"0.00","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-27 22:26:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":"21.75","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5207368","reservation_id":"109238","confirmation_number":"SJ12697338412","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"292.51","paid_amount":"0.00","room_type_id":"413","product_id":"1263","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-04 00:23:31","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":"0","currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207473","reservation_id":"116025","confirmation_number":"SJ12684052436","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"489.38","paid_amount":"0.00","room_type_id":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-27 22:07:22","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","taxExmptApplied":"21.75","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5207550","reservation_id":"109237","confirmation_number":"SJ12637814402","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"292.51","paid_amount":"0.00","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-04 00:21:21","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":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207564","reservation_id":"113203","confirmation_number":"SJ12618451415","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"685.13","paid_amount":"196.88","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 16:55:59","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":"0","taxExmptApplied":"21.75","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5207571","reservation_id":"115465","confirmation_number":"SJ12633728053","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"489.38","paid_amount":"0.00","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-18 20:42:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","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":"87.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":"5207669","reservation_id":"116608","confirmation_number":"SJ12698046361","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"489.38","paid_amount":"140.63","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-05 19:26:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":"32.63","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5207676","reservation_id":"113556","confirmation_number":"SJ12666552314","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"292.51","paid_amount":"0.00","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-21 19:21:01","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207683","reservation_id":"113196","confirmation_number":"SJ12611002764","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"292.51","paid_amount":"84.38","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 16:16:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":"10.83","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207690","reservation_id":"112820","confirmation_number":"SJ12688775751","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"292.50","paid_amount":"84.38","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-12 22:49:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":"10.83","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207697","reservation_id":"110546","confirmation_number":"SJ12630285376","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"292.51","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:43:57","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","currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207912","reservation_id":"121699","confirmation_number":"SJ12691790189","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"292.51","paid_amount":"0.00","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-08-22 18:09:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","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":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207919","reservation_id":"112812","confirmation_number":"SJ12656847200","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"520.02","grand_total":"585.02","paid_amount":"168.75","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-12 22:05:51","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":"10.83","changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5198546","reservation_id":"110558","confirmation_number":"SJ12617419895","room_stay_from":"2021-10-11","room_stay_to":"2021-10-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"433.35","grand_total":"487.52","paid_amount":"0.00","room_type_id":"319","product_id":"1307","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 19:31:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207983","reservation_id":"95471","confirmation_number":"SJ12622152239","room_stay_from":"2020-07-08","room_stay_to":"2020-07-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"264.38","paid_amount":"235.00","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109931","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 14:50:53","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":"29.38","changedComment":"Nightly price or discount 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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3251038","reservation_id":"114466","confirmation_number":"SJ12687913738","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1286","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-05-04 00:24:43","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":"102.28","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":"3251042","reservation_id":"114476","confirmation_number":"SJ12623629284","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1287","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-05-04 01:34:06","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":"102.28","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":"3251044","reservation_id":"114477","confirmation_number":"SJ12668182506","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1288","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-05-04 01:37:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.28","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":"3263303","reservation_id":"116679","confirmation_number":"SJ12698204146","room_stay_from":"2021-08-22","room_stay_to":"2021-08-29","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00,102.00,102.00,102.00,104.00,102.00,102.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-06-06 20:41:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.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":"3305301","reservation_id":"116636","confirmation_number":"SJ12658926127","room_stay_from":"2021-08-22","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00,102.00,102.00,102.00,102.00,102.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"412","product_id":"1297","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-06-06 01:33:41","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.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":"5183552","reservation_id":"85386","confirmation_number":"SJ12633364557","room_stay_from":"2019-12-13","room_stay_to":"2019-12-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"319","product_id":"1303","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":"2019-10-10 04:07:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","taxExmptApplied":-30.63,"changedComment":"Nightly price or discount changed","deltaChange":"70.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5184449","reservation_id":"80668","confirmation_number":"SJ12625686731","room_stay_from":"2019-12-17","room_stay_to":"2019-12-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.66,81.66,81.68","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"245.00","paid_amount":"245.00","room_type_id":"413","product_id":"1261","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":"2019-07-13 19:10:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","taxExmptApplied":-30.63,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5186246","reservation_id":"109173","confirmation_number":"SJ12636497667","room_stay_from":"2021-06-15","room_stay_to":"2021-06-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"52.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"226.00","grand_total":"226.00","paid_amount":"226.00","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 19:11:19","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"Nightly price or discount changed","deltaChange":"-34.01","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5186298","reservation_id":"89234","confirmation_number":"SJ12698230410","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"610.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":"610.00","grand_total":"610.00","paid_amount":"196.88","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":"109931","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-01-03 17:08:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","changedComment":"Nightly price or discount changed","deltaChange":"-944.98","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5186328","reservation_id":"72051","confirmation_number":"SJ12662099314","room_stay_from":"2019-06-08","room_stay_to":"2019-06-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"575.00","nightly_discount":"0.00","subtotal":"575.00","grand_total":"575.00","paid_amount":"196.88","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"106975","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-15 17:47:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","taxExmptApplied":-71.88,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3376304","reservation_id":"112340","confirmation_number":"SJ12647773932","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"0.00","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-07 15:42:53","service_canceled_date_time":"2021-08-23 15:13:03","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_1","total_paid_amount":"0.00","sub_hotel_id":"0","deltaChange":-174,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5182659","reservation_id":"85739","confirmation_number":"SJ12668471508","room_stay_from":"2019-12-06","room_stay_to":"2019-12-20","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"575.00,0.00,0.00,0.00,0.00,0.00,0.00,575.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,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1150.00","grand_total":"1150.00","paid_amount":"1150.00","room_type_id":"319","product_id":"1305","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-10-16 20:01:44","service_canceled_date_time":"2021-08-23 15:58:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_1","total_paid_amount":"1150.00","sub_hotel_id":"0","deltaChange":"1150.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3305982","reservation_id":"117746","confirmation_number":"SJ12647487010","room_confirmation_number":"SJ12686652854","room_stay_from":"2021-08-22","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"124721","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-21 14:25:37","reservation_modified_date_time":"2021-08-21 14:25:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124721","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5178979","reservation_id":"121746","confirmation_number":"SJ12650124274","room_confirmation_number":"SJ12653752952","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"50.00,50.00","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"129290","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-23 13:44:27","reservation_modified_date_time":"2021-08-23 13:44:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129290","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50.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":"5195357","reservation_id":"120282","confirmation_number":"SJ12668584533","room_confirmation_number":"SJ12659331424","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0,0","subtotal":"200.00","grand_total":"225.00","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"127544","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-23 17:27:09","reservation_modified_date_time":"2021-08-23 17:27:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127544","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":"5208031","reservation_id":"97300","confirmation_number":"SJ12628003989","room_confirmation_number":"SJ12675601843","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"103388","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-23 17:58:02","reservation_modified_date_time":"2021-08-23 17:58:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103388","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","changedComment":"Reservation created for complete past date","deltaChange":"50.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":"3173085","reservation_id":"104602","confirmation_number":"SJ12684154331","room_confirmation_number":"SJ12693312759","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"110953","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 20:51:08","reservation_modified_date_time":"2021-01-02 20:51:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110953","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":"3244057","reservation_id":"114186","confirmation_number":"SJ12648021467","room_confirmation_number":"SJ12627199091","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","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":"120827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-30 02:13:08","reservation_modified_date_time":"2021-04-30 02:13:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120827","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":"3251037","reservation_id":"114466","confirmation_number":"SJ12686060898","room_confirmation_number":"SJ12687913738","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"121160","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 00:24:43","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3251041","reservation_id":"114476","confirmation_number":"SJ12617705605","room_confirmation_number":"SJ12623629284","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"121172","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 01:34:06","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3251043","reservation_id":"114477","confirmation_number":"SJ12616665124","room_confirmation_number":"SJ12668182506","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","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":"121173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 01:37:16","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3263304","reservation_id":"116679","confirmation_number":"SJ12634301979","room_confirmation_number":"SJ12698204146","room_stay_from":"2021-08-22","room_stay_to":"2021-08-29","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":"123577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-06 20:41:47","reservation_modified_date_time":"2021-06-06 20:41:47","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276387","reservation_id":"118466","confirmation_number":"SJ12680839182","room_confirmation_number":"SJ12669343965","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"125497","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-01 16:15:50","reservation_modified_date_time":"2021-07-01 16:15:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125497","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":"3293168","reservation_id":"120464","confirmation_number":"SJ12668105463","room_confirmation_number":"SJ12650427639","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"127768","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-31 13:51:19","reservation_modified_date_time":"2021-07-31 13:51:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127768","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":"3293903","reservation_id":"120488","confirmation_number":"SJ12648395364","room_confirmation_number":"SJ12678815947","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"127802","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-31 20:58:37","reservation_modified_date_time":"2021-07-31 22:30:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127802","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":"3300439","reservation_id":"120923","confirmation_number":"SJ12624907432","room_confirmation_number":"SJ12627898509","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"128334","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-08 02:26:22","reservation_modified_date_time":"2021-08-09 15:26:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128334","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":"3303477","reservation_id":"121282","confirmation_number":"SJ12659374914","room_confirmation_number":"SJ12634904040","room_stay_from":"2021-08-21","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"128753","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-16 16:10:18","reservation_modified_date_time":"2021-08-16 16:10:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128753","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":"3303719","reservation_id":"119398","confirmation_number":"SJ12695929242","room_confirmation_number":"SJ12613112540","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126445","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-15 17:23:26","reservation_modified_date_time":"2021-08-17 13:33:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126445","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":"3305298","reservation_id":"116002","confirmation_number":"SJ12689953781","room_confirmation_number":"SJ12622216430","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"122811","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 19:50:54","reservation_modified_date_time":"2021-08-20 12:57:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122811","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":"3305302","reservation_id":"116636","confirmation_number":"SJ12673565883","room_confirmation_number":"SJ12658926127","room_stay_from":"2021-08-22","room_stay_to":"2021-08-29","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":"123528","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-06 01:33:41","reservation_modified_date_time":"2021-08-20 12:57:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305351","reservation_id":"121204","confirmation_number":"SJ12646847638","room_confirmation_number":"SJ12636106363","room_stay_from":"2021-08-20","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"128672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-14 23:40:16","reservation_modified_date_time":"2021-08-20 14:10:30","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128672","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":"3305833","reservation_id":"121613","confirmation_number":"SJ12658838639","room_confirmation_number":"SJ12640639749","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","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":"129114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 22:28:37","reservation_modified_date_time":"2021-08-21 01:22:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129114","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":"3305851","reservation_id":"121614","confirmation_number":"SJ12668718502","room_confirmation_number":"SJ12667172152","room_stay_from":"2021-08-21","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"129115","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 22:44:21","reservation_modified_date_time":"2021-08-21 01:30:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129115","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":"3305922","reservation_id":"120114","confirmation_number":"SJ12698292301","room_confirmation_number":"SJ12656866521","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"112991","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-26 17:07:49","reservation_modified_date_time":"2021-08-21 13:06:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112991","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":"3305983","reservation_id":"117746","confirmation_number":"SJ12680558979","room_confirmation_number":"SJ12686652854","room_stay_from":"2021-08-22","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"124721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-21 05:12:13","reservation_modified_date_time":"2021-08-21 14:25:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124721","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"4151088","reservation_id":"115765","confirmation_number":"SJ12648855885","room_confirmation_number":"SJ12627565711","room_stay_from":"2021-08-23","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"122542","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-24 01:46:11","reservation_modified_date_time":"2021-08-21 18:58:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122542","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":"5178978","reservation_id":"121746","confirmation_number":"SJ12691122264","room_confirmation_number":"SJ12653752952","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"129290","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-23 13:44:27","reservation_modified_date_time":"2021-08-23 13:44:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129290","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":"5179028","reservation_id":"117723","confirmation_number":"SJ12627091436","room_confirmation_number":"SJ12615970802","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","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":"124699","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-20 21:57:10","reservation_modified_date_time":"2021-08-23 15:15:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124699","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":"5204818","reservation_id":"115356","confirmation_number":"SJ12636431603","room_confirmation_number":"SJ12610691787","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122082","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-16 23:19:12","reservation_modified_date_time":"2021-08-23 17:36:58","collect_which":"","tax_exempt_status":"0","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":"5205771","reservation_id":"110723","confirmation_number":"SJ12676370179","room_confirmation_number":"SJ12645910859","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117234","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 15:58:17","reservation_modified_date_time":"2021-08-23 17:37:09","collect_which":"","tax_exempt_status":"0","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":"5206009","reservation_id":"115170","confirmation_number":"SJ12660256326","room_confirmation_number":"SJ12658016821","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121878","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-13 22:45:08","reservation_modified_date_time":"2021-08-23 17:37:11","collect_which":"","tax_exempt_status":"0","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":"5206016","reservation_id":"115171","confirmation_number":"SJ12687735657","room_confirmation_number":"SJ12620798016","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121879","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-13 22:55:27","reservation_modified_date_time":"2021-08-23 17:37:11","collect_which":"","tax_exempt_status":"0","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":"5206261","reservation_id":"116034","confirmation_number":"SJ12684069053","room_confirmation_number":"SJ12673544332","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"122844","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 22:26:38","reservation_modified_date_time":"2021-08-23 17:37:13","collect_which":"","tax_exempt_status":"0","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":"5207367","reservation_id":"109238","confirmation_number":"SJ12659147387","room_confirmation_number":"SJ12697338412","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:23:31","reservation_modified_date_time":"2021-08-23 17:37:23","collect_which":"","tax_exempt_status":"0","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":"5207472","reservation_id":"116025","confirmation_number":"SJ12632554861","room_confirmation_number":"SJ12684052436","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122839","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 22:07:22","reservation_modified_date_time":"2021-08-23 17:37:24","collect_which":"","tax_exempt_status":"0","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":"5207549","reservation_id":"109237","confirmation_number":"SJ12678762603","room_confirmation_number":"SJ12637814402","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115705","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:21:21","reservation_modified_date_time":"2021-08-23 17:37:25","collect_which":"","tax_exempt_status":"0","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":"5207563","reservation_id":"113203","confirmation_number":"SJ12646508609","room_confirmation_number":"SJ12618451415","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"119793","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 16:55:59","reservation_modified_date_time":"2021-08-23 17:37:25","collect_which":"","tax_exempt_status":"0","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":"5207570","reservation_id":"115465","confirmation_number":"SJ12660676634","room_confirmation_number":"SJ12633728053","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122207","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-18 20:42:52","reservation_modified_date_time":"2021-08-23 17:37:25","collect_which":"","tax_exempt_status":"0","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":"5207668","reservation_id":"116608","confirmation_number":"SJ12641874173","room_confirmation_number":"SJ12698046361","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123498","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-05 19:26:07","reservation_modified_date_time":"2021-08-23 17:37:26","collect_which":"","tax_exempt_status":"0","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":"5207675","reservation_id":"113556","confirmation_number":"SJ12648012742","room_confirmation_number":"SJ12666552314","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120157","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 19:21:01","reservation_modified_date_time":"2021-08-23 17:37:26","collect_which":"","tax_exempt_status":"0","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":"5207682","reservation_id":"113196","confirmation_number":"SJ12693709680","room_confirmation_number":"SJ12611002764","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119784","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 16:16:43","reservation_modified_date_time":"2021-08-23 17:37:26","collect_which":"","tax_exempt_status":"0","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":"5207689","reservation_id":"112820","confirmation_number":"SJ12612534144","room_confirmation_number":"SJ12688775751","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119407","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 22:49:58","reservation_modified_date_time":"2021-08-23 17:37:26","collect_which":"","tax_exempt_status":"0","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":"5207696","reservation_id":"110546","confirmation_number":"SJ12678297463","room_confirmation_number":"SJ12630285376","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:43:57","reservation_modified_date_time":"2021-08-23 17:37:26","collect_which":"","tax_exempt_status":"0","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":"5207911","reservation_id":"121699","confirmation_number":"SJ12685050977","room_confirmation_number":"SJ12691790189","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129244","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-22 18:09:25","reservation_modified_date_time":"2021-08-23 17:37:28","collect_which":"","tax_exempt_status":"0","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":"5207918","reservation_id":"112812","confirmation_number":"SJ12662187630","room_confirmation_number":"SJ12656847200","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119400","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 22:05:51","reservation_modified_date_time":"2021-08-23 17:37:28","collect_which":"","tax_exempt_status":"0","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":"5208349","reservation_id":"121175","confirmation_number":"SJ12677374442","room_confirmation_number":"SJ12663819545","room_stay_from":"2021-08-21","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"128636","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-14 15:52:08","reservation_modified_date_time":"2021-08-23 20:55:22","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128636","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-50.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"5208459","reservation_id":"121637","confirmation_number":"SJ12683738395","room_confirmation_number":"SJ12652845327","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"129155","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-21 14:06:27","reservation_modified_date_time":"2021-08-23 21:38:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129155","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5207934","reservation_id":"110558","confirmation_number":"SJ12649075712","room_confirmation_number":"SJ12617419895","room_stay_from":"2021-10-11","room_stay_to":"2021-10-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 19:31:57","reservation_modified_date_time":"2021-08-23 17:37:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3443754","reservation_id":"112340","confirmation_number":"SJ12661664478","room_confirmation_number":"SJ12647773932","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Canceled","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-07 15:42:53","reservation_modified_date_time":"2021-08-21 17:18:52","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"118909","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-23 15:13:03","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2021-08-21","sub_hotel_id":"0","deltaChange":-50,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3305991","reservation_id":"120326","confirmation_number":"SJ12640687265","room_confirmation_number":"SJ12658726997","room_stay_from":"2021-08-23","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"127595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-29 04:51:09","reservation_modified_date_time":"2021-08-21 14:26:15","collect_which":"hotel_collect","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"127595","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.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"}]}],"gift_shop_taxable":[{"room_stay_id":"5179085","reservation_id":"121754","confirmation_number":"SJ12643530203","room_confirmation_number":"SJ12692887107","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":"1663","service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-23 15:25:26","reservation_modified_date_time":"2021-08-23 15:25:26","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":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"5208533","reservation_id":"121815","confirmation_number":"SJ12687702769","room_confirmation_number":"SJ12622958002","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 00:45:29","reservation_modified_date_time":"2021-08-24 00:45:29","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"5208499","reservation_id":"121699","confirmation_number":"SJ12641271568","room_confirmation_number":"SJ12691790189","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"0.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-23 22:56:33","reservation_modified_date_time":"2021-08-23 22:56:33","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"129244","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-08-22","sub_hotel_id":"0","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}