{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-02-01","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":21,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1319,1270,1307,1260,1266,1269,1271,1267,1866","block_room_bookings":[{"confirmation_number":"SJ12656567093","room_stay_from":"2021-02-01","room_stay_to":"2021-02-02","bundle_room":"0","product_id":"1319"},{"confirmation_number":"SJ12696286314","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJ12661595862","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJ12639163648","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJ12615918857","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1266"},{"confirmation_number":"SJ12666358552","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJ12636218409","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJ12672878894","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJ12676856509","room_stay_from":"2021-01-27","room_stay_to":"2021-02-20","bundle_room":"0","product_id":"1866"}],"bundle_block_count":"1262,1263,1267,1268,1260,1261,1271,1272,1269,1270,1307,1308,1309,1310,1304,1305,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12681311035","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12623940637","room_stay_from":"2021-01-31","room_stay_to":"2021-02-02","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12663654096","room_stay_from":"2021-02-01","room_stay_to":"2021-02-02","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12670771581","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12699575505","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12691560331","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12620410679","room_stay_from":"2021-02-01","room_stay_to":"2021-02-04","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12624440417","room_stay_from":"2021-01-30","room_stay_to":"2021-02-06","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12639148117","room_stay_from":"2021-02-01","room_stay_to":"2021-02-06","bundle_room":"1","product_id":"1332"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3189013","reservation_id":"106600","confirmation_number":"SJ12654501419","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.28,143.28","nightly_discount":"0,0","subtotal":"286.56","grand_total":"322.38","paid_amount":"322.38","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3679993958","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":"113024","customer_id":"113024","source_of_creation":"Booking.com","reservation_created_date":"2021-02-01 03:04:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"60.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"143.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188495","reservation_id":"106421","confirmation_number":"SJ12667965927","room_stay_from":"2021-02-01","room_stay_to":"2021-02-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,163.17,163.17","nightly_discount":"0,0,0,0","subtotal":"652.68","grand_total":"734.26","paid_amount":"734.26","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-3542358396","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":"112817","customer_id":"112817","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 16:30:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"135.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.17","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":"3178328","reservation_id":"104952","confirmation_number":"SJ12686583874","room_stay_from":"2021-01-30","room_stay_to":"2021-02-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,139.30,174.30,174.30,174.30,174.30,202.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1220.10","grand_total":"1372.62","paid_amount":"1372.62","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-3318394968","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":"111315","customer_id":"111315","source_of_creation":"Booking.com","reservation_created_date":"2021-01-07 18:05:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3183468","reservation_id":"105315","confirmation_number":"SJ12659686367","room_stay_from":"2021-01-23","room_stay_to":"2021-02-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.86,129.84,129.84,129.84,129.84,129.84,163.86,163.86,129.84,158.19,158.19,158.19,158.19,180.87","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2084.25","grand_total":"2344.78","paid_amount":"2344.78","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2111298720","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":"111703","customer_id":"111703","source_of_creation":"Booking.com","reservation_created_date":"2021-01-14 05:12:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"158.19","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3180930","reservation_id":"105186","confirmation_number":"SJ12611283912","room_stay_from":"2021-01-17","room_stay_to":"2021-02-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"101.49,101.49,101.49,101.49,101.49,146.85,146.85,101.49,101.49,101.49,101.49,101.49,146.85,146.85,101.49,141.18,141.18,141.18,141.18,163.86,163.86","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2596.23","grand_total":"2920.76","paid_amount":"2920.76","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2941467212","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":"111980","customer_id":"111980","source_of_creation":"Booking.com","reservation_created_date":"2021-01-11 19:43:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"561.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"141.18","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":"3189445","reservation_id":"106599","confirmation_number":"SJ12690191129","room_stay_from":"2021-02-14","room_stay_to":"2021-02-18","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"232.47,219.87,219.87,219.87","nightly_discount":"0,0,0,0","subtotal":"892.08","grand_total":"1003.59","paid_amount":"261.53","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-2713740449","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":"113023","customer_id":"113023","source_of_creation":"Booking.com","reservation_created_date":"2021-02-01 02:49:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3186623","reservation_id":"96861","confirmation_number":"SJ12689207827","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.20,175.20","nightly_discount":"0,0","subtotal":"350.40","grand_total":"394.20","paid_amount":"394.20","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1672336653","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":"102987","customer_id":"102987","source_of_creation":"Expedia","reservation_created_date":"2020-06-20 12:58:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"175.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":"3185077","reservation_id":"105566","confirmation_number":"SJ12699873775","room_stay_from":"2021-02-01","room_stay_to":"2021-02-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.40,155.40,155.40","nightly_discount":"0,0,0","subtotal":"466.20","grand_total":"524.48","paid_amount":"524.48","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1730945584","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":"111987","customer_id":"111987","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 18:56:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","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":"155.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188123","reservation_id":"106486","confirmation_number":"SJ12625018680","room_stay_from":"2021-01-30","room_stay_to":"2021-02-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.04,117.04,128.24,128.24,128.24","nightly_discount":"0,0,0,0,0","subtotal":"646.80","grand_total":"727.65","paid_amount":"727.65","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1733959932","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":"112894","customer_id":"112894","source_of_creation":"Expedia","reservation_created_date":"2021-01-30 18:16:12","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":"128.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186890","reservation_id":"104536","confirmation_number":"SJ12687539359","room_stay_from":"2021-01-31","room_stay_to":"2021-02-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.30,174.30,174.30,174.30,174.30,202.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1045.80","grand_total":"1176.53","paid_amount":"1176.53","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1726850752","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":"110886","customer_id":"110886","source_of_creation":"Expedia","reservation_created_date":"2021-01-01 20:31:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188501","reservation_id":"104114","confirmation_number":"SJ12631981420","room_stay_from":"2021-01-31","room_stay_to":"2021-02-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.04,139.44,139.44,139.44,139.44,161.84","nightly_discount":"0,0,0,0,0,0","subtotal":"836.64","grand_total":"941.22","paid_amount":"941.22","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1724661926","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":"110446","customer_id":"110446","source_of_creation":"Expedia","reservation_created_date":"2020-12-22 16:06:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188691","reservation_id":"104528","confirmation_number":"SJ12694773985","room_stay_from":"2021-01-31","room_stay_to":"2021-02-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.04,139.44,139.44,139.44,139.44,161.84","nightly_discount":"0,0,0,0,0,0","subtotal":"836.64","grand_total":"941.22","paid_amount":"941.22","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1726823300","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":"110875","customer_id":"110875","source_of_creation":"Expedia","reservation_created_date":"2021-01-01 18:31:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186627","reservation_id":"104210","confirmation_number":"SJ12694254661","room_stay_from":"2021-01-31","room_stay_to":"2021-02-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.84,156.24,156.24,156.24,156.24,178.64,178.64,156.24","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1272.32","grand_total":"1431.36","paid_amount":"1431.36","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1725081157","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":"110544","customer_id":"110544","source_of_creation":"Expedia","reservation_created_date":"2020-12-24 18:21:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"156.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185954","reservation_id":"102734","confirmation_number":"SJ12622133038","room_stay_from":"2021-01-30","room_stay_to":"2021-02-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,117.04,139.44,139.44,139.44,139.44,161.84,161.84,139.44,139.44","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1416.80","grand_total":"1593.90","paid_amount":"1593.90","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1716539758","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":"108879","customer_id":"108879","source_of_creation":"Expedia","reservation_created_date":"2020-11-16 17:38:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"283.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3188486","reservation_id":"105314","confirmation_number":"SJ12613481731","room_stay_from":"2021-02-01","room_stay_to":"2021-02-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.86,163.86,163.86,163.86","nightly_discount":"0,0,0,0","subtotal":"655.44","grand_total":"737.37","paid_amount":"737.37","room_type_id":"319","product_id":"1312","siteminder_id":"GAM-R2281109692","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":"111702","customer_id":"111702","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-14 04:02:09","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":"126","group_rooms":null,"currentDayPrice":"163.86","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3186215","reservation_id":"105774","confirmation_number":"SJ12639200483","room_stay_from":"2021-01-28","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.57,195.43,195.43,195.43,195.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"971.29","grand_total":"1125.60","paid_amount":"1125.60","room_type_id":"413","product_id":"1273","siteminder_id":"ABB-HMAE4N5YW2","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"977.15","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112176","customer_id":"112176","source_of_creation":"Airbnb","reservation_created_date":"2021-01-21 03:44:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"28.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.43","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":"3188071","reservation_id":"106388","confirmation_number":"SJ12621941236","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.88,197.88,194.32","nightly_discount":"0.00,0.00,0.00","subtotal":"590.08","grand_total":"683.82","paid_amount":"683.82","room_type_id":"319","product_id":"1314","siteminder_id":"ABB-HMNPN3KT5F","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"593.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112784","customer_id":"112784","source_of_creation":"Airbnb","reservation_created_date":"2021-01-29 03:08:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"17.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.32","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":"3188883","reservation_id":"105700","confirmation_number":"SJ12631430252","room_stay_from":"2021-01-31","room_stay_to":"2021-02-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.37,194.82,194.82","nightly_discount":"0.00,0.00,0.00","subtotal":"581.01","grand_total":"673.30","paid_amount":"673.30","room_type_id":"319","product_id":"1293","siteminder_id":"ABB-HMPMH988F8","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"584.46","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112097","customer_id":"112097","source_of_creation":"Airbnb","reservation_created_date":"2021-01-20 01:04:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"17.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.82","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":"3189059","reservation_id":"105253","confirmation_number":"SJ12644235412","room_stay_from":"2021-02-01","room_stay_to":"2021-02-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.82,235.82,235.82,235.82,228.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1172.14","grand_total":"1358.37","paid_amount":"1358.37","room_type_id":"412","product_id":"1297","siteminder_id":"ABB-HMHKQZPJ5Q","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1179.10","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111636","customer_id":"111636","source_of_creation":"Airbnb","reservation_created_date":"2021-01-13 02:46:19","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"34.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"235.82","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":"3189823","reservation_id":"106594","confirmation_number":"SJ12655845080","room_stay_from":"2021-03-17","room_stay_to":"2021-03-19","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"266.20,266.20","nightly_discount":"0.00,0.00","subtotal":"532.40","grand_total":"631.66","paid_amount":"0.00","room_type_id":"318","product_id":"1282","siteminder_id":"ABB-HMA53FS3MP","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"532.40","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113017","customer_id":"113017","source_of_creation":"Airbnb","reservation_created_date":"2021-02-01 01:31:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"18.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3186565","reservation_id":"104741","confirmation_number":"SJ12637994078","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.65,177.65,211.65","nightly_discount":"0.00,0.00,0.00","subtotal":"600.95","grand_total":"676.07","paid_amount":"676.07","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":"111096","customer_id":"111096","source_of_creation":"FE","reservation_created_date":"2021-01-05 00:09:21","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"211.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188712","reservation_id":"106035","confirmation_number":"SJ12630014490","room_stay_from":"2021-01-31","room_stay_to":"2021-02-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.25,171.75,171.75","nightly_discount":"6.71,8.59,8.59","subtotal":"477.75","grand_total":"510.59","paid_amount":"510.59","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":"112462","customer_id":"112462","source_of_creation":"FE","reservation_created_date":"2021-01-25 01:20:17","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","group_rooms":null,"currentDayPrice":"171.75","currentDayDiscount":"8.59","productIsTaxExempt":false,"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":"3178334","reservation_id":"105105","confirmation_number":"SJ12669352072","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.97,159.97,159.97","nightly_discount":"0.00,0.00,0.00","subtotal":"479.91","grand_total":"539.90","paid_amount":"539.90","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":"111527","customer_id":"111527","source_of_creation":"PMS","reservation_created_date":"2021-01-10 02:27:53","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":"159.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188350","reservation_id":"105813","confirmation_number":"SJ12616125677","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.00,165.00,165.00","nightly_discount":"0.00,0.00,0.00","subtotal":"500.00","grand_total":"562.50","paid_amount":"562.50","room_type_id":"413","product_id":"1263","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":"112219","customer_id":"112219","source_of_creation":"PMS","reservation_created_date":"2021-01-21 22:51:18","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","group_rooms":null,"currentDayPrice":"165.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":"3188433","reservation_id":"106538","confirmation_number":"SJ12647633689","room_stay_from":"2021-01-31","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.15,169.15","nightly_discount":"0.00,0.00","subtotal":"321.30","grand_total":"361.47","paid_amount":"361.47","room_type_id":"413","product_id":"1262","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":"112957","customer_id":"112957","source_of_creation":"PMS","reservation_created_date":"2021-01-31 14:33:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"169.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":"3189125","reservation_id":"106340","confirmation_number":"SJ12612921347","room_stay_from":"2021-01-29","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.00,157.00,157.00,157.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110829","customer_id":"110829","source_of_creation":"PMS","reservation_created_date":"2021-01-28 18:39:59","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"157.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":"3189118","reservation_id":"106479","confirmation_number":"SJ12650376777","room_stay_from":"2021-02-25","room_stay_to":"2021-03-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"381.65,339.15,347.65,347.65,347.65","nightly_discount":"38.17,33.92,34.77,34.77,34.77","subtotal":"1763.75","grand_total":"1785.77","paid_amount":"381.65","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":"111951","customer_id":"111951","source_of_creation":"PMS","reservation_created_date":"2021-01-30 16:29:00","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":"special123","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189280","reservation_id":"106167","confirmation_number":"SJ12681963616","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.65,228.65,228.65,177.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"812.60","grand_total":"914.18","paid_amount":"1161.85","room_type_id":"319","product_id":"1276","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":"112575","customer_id":"112575","source_of_creation":"PMS","reservation_created_date":"2021-01-26 16:25:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"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":"3189341","reservation_id":"106562","confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"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,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,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,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,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","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":"101703","customer_id":"101703","source_of_creation":"PMS","reservation_created_date":"2021-01-31 18:54:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3151625","reservation_id":"101519","confirmation_number":"SJ12610908281","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"20.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":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-10-14 01:35:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181195","reservation_id":"105599","confirmation_number":"SJ12614459366","room_stay_from":"2021-01-29","room_stay_to":"2021-02-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-19 02:32:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3187878","reservation_id":"104912","confirmation_number":"SJ12618179277","room_stay_from":"2021-02-01","room_stay_to":"2021-02-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-07 00:44:23","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3151626","reservation_id":"101519","confirmation_number":"SJ12685059247","room_confirmation_number":"SJ12610908281","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"64.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"107597","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-14 01:35:25","reservation_modified_date_time":"2020-11-04 02:04:24","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3178335","reservation_id":"105105","confirmation_number":"SJ12631761676","room_confirmation_number":"SJ12669352072","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"111527","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-10 02:27:53","reservation_modified_date_time":"2021-01-13 03:14:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111527","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":"3186216","reservation_id":"105774","confirmation_number":"SJ12648813031","room_confirmation_number":"SJ12639200483","room_stay_from":"2021-01-28","room_stay_to":"2021-02-02","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112176","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 03:44:11","reservation_modified_date_time":"2021-01-28 14:12:03","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112176","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":"3186567","reservation_id":"104741","confirmation_number":"SJ12615545442","room_confirmation_number":"SJ12637994078","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"111096","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 00:09:21","reservation_modified_date_time":"2021-01-28 23:40:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111096","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":"3188072","reservation_id":"106388","confirmation_number":"SJ12620404474","room_confirmation_number":"SJ12621941236","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","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":"112784","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 03:08:11","reservation_modified_date_time":"2021-01-30 20:53:41","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112784","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":"3188352","reservation_id":"105813","confirmation_number":"SJ12668623082","room_confirmation_number":"SJ12616125677","room_stay_from":"2021-01-30","room_stay_to":"2021-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"112219","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 22:51:18","reservation_modified_date_time":"2021-01-31 00:34:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112219","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":"3188434","reservation_id":"106538","confirmation_number":"SJ12694172258","room_confirmation_number":"SJ12647633689","room_stay_from":"2021-01-31","room_stay_to":"2021-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"112957","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 14:33:12","reservation_modified_date_time":"2021-01-31 14:33:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112957","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":"3189126","reservation_id":"106340","confirmation_number":"SJ12680333916","room_confirmation_number":"SJ12612921347","room_stay_from":"2021-01-29","room_stay_to":"2021-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,25.00,25.00","subtotal":"100.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"110829","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 18:39:59","reservation_modified_date_time":"2021-02-01 15:18:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110829","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"-25.00","currentDayPrice":"25.00","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3183958","reservation_id":"106035","confirmation_number":"SJ12679990732","room_confirmation_number":"SJ12630014490","room_stay_from":"2021-01-31","room_stay_to":"2021-02-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"112462","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 01:20:17","reservation_modified_date_time":"2021-01-25 01:20:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112462","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":"3186624","reservation_id":"96861","confirmation_number":"SJ12623878630","room_confirmation_number":"SJ12689207827","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"102987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 12:58:10","reservation_modified_date_time":"2021-01-28 23:48:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102987","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":"3188884","reservation_id":"105700","confirmation_number":"SJ12655349147","room_confirmation_number":"SJ12631430252","room_stay_from":"2021-01-31","room_stay_to":"2021-02-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112097","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 01:04:11","reservation_modified_date_time":"2021-01-31 22:50:50","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112097","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":"3189014","reservation_id":"106600","confirmation_number":"SJ12679161423","room_confirmation_number":"SJ12654501419","room_stay_from":"2021-02-01","room_stay_to":"2021-02-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"113024","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 03:04:07","reservation_modified_date_time":"2021-02-01 03:04:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113024","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":"3185079","reservation_id":"105566","confirmation_number":"SJ12623456204","room_confirmation_number":"SJ12699873775","room_stay_from":"2021-02-01","room_stay_to":"2021-02-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"111987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 18:56:10","reservation_modified_date_time":"2021-01-26 21:18:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111987","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":"3188124","reservation_id":"106486","confirmation_number":"SJ12667433690","room_confirmation_number":"SJ12625018680","room_stay_from":"2021-01-30","room_stay_to":"2021-02-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"112894","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 18:16:12","reservation_modified_date_time":"2021-01-30 21:58:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112894","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":"3181196","reservation_id":"105599","confirmation_number":"SJ12680900258","room_confirmation_number":"SJ12614459366","room_stay_from":"2021-01-29","room_stay_to":"2021-02-05","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":"112020","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 02:32:42","reservation_modified_date_time":"2021-01-19 02:32:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188487","reservation_id":"105314","confirmation_number":"SJ12637075495","room_confirmation_number":"SJ12613481731","room_stay_from":"2021-02-01","room_stay_to":"2021-02-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111702","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 04:02:09","reservation_modified_date_time":"2021-01-31 15:31:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111702","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":"3188496","reservation_id":"106421","confirmation_number":"SJ12657496827","room_confirmation_number":"SJ12667965927","room_stay_from":"2021-02-01","room_stay_to":"2021-02-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112817","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 16:30:12","reservation_modified_date_time":"2021-01-31 15:37:49","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112817","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":"3178331","reservation_id":"104952","confirmation_number":"SJ12674939564","room_confirmation_number":"SJ12686583874","room_stay_from":"2021-01-30","room_stay_to":"2021-02-06","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":"111315","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 18:05:28","reservation_modified_date_time":"2021-01-13 03:12:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111315","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":"3183469","reservation_id":"105315","confirmation_number":"SJ12676831990","room_confirmation_number":"SJ12659686367","room_stay_from":"2021-01-23","room_stay_to":"2021-02-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"111703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 05:12:22","reservation_modified_date_time":"2021-01-24 01:25:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111703","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":"3186893","reservation_id":"104536","confirmation_number":"SJ12640768550","room_confirmation_number":"SJ12687539359","room_stay_from":"2021-01-31","room_stay_to":"2021-02-06","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":"110886","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 20:31:06","reservation_modified_date_time":"2021-01-29 13:06:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110886","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":"3187880","reservation_id":"104912","confirmation_number":"SJ12619752620","room_confirmation_number":"SJ12618179277","room_stay_from":"2021-02-01","room_stay_to":"2021-02-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111267","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 00:44:23","reservation_modified_date_time":"2021-01-30 17:45:07","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188502","reservation_id":"104114","confirmation_number":"SJ12691743140","room_confirmation_number":"SJ12631981420","room_stay_from":"2021-01-31","room_stay_to":"2021-02-06","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":"110446","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 16:06:12","reservation_modified_date_time":"2021-01-31 16:04:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110446","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":"3188695","reservation_id":"104528","confirmation_number":"SJ12693151104","room_confirmation_number":"SJ12694773985","room_stay_from":"2021-01-31","room_stay_to":"2021-02-06","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":"110875","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 18:31:09","reservation_modified_date_time":"2021-01-31 19:40:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110875","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":"3189060","reservation_id":"105253","confirmation_number":"SJ12614048062","room_confirmation_number":"SJ12644235412","room_stay_from":"2021-02-01","room_stay_to":"2021-02-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111636","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-13 02:46:19","reservation_modified_date_time":"2021-02-01 13:51:53","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111636","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":"3180931","reservation_id":"105186","confirmation_number":"SJ12691123842","room_confirmation_number":"SJ12611283912","room_stay_from":"2021-01-17","room_stay_to":"2021-02-07","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25","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,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"525.00","grand_total":"590.63","paid_amount":"590.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"111980","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 19:43:02","reservation_modified_date_time":"2021-01-18 16:40:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111980","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186628","reservation_id":"104210","confirmation_number":"SJ12666947835","room_confirmation_number":"SJ12694254661","room_stay_from":"2021-01-31","room_stay_to":"2021-02-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110544","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-24 18:21:06","reservation_modified_date_time":"2021-01-28 23:50:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110544","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":"3185955","reservation_id":"102734","confirmation_number":"SJ12693216091","room_confirmation_number":"SJ12622133038","room_stay_from":"2021-01-30","room_stay_to":"2021-02-09","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"108879","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-16 17:38:10","reservation_modified_date_time":"2021-01-27 23:44:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108879","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189115","reservation_id":"106479","confirmation_number":"SJ12697416058","room_confirmation_number":"SJ12650376777","room_stay_from":"2021-02-25","room_stay_to":"2021-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111951","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 16:29:00","reservation_modified_date_time":"2021-02-01 15:15:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111951","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189281","reservation_id":"106167","confirmation_number":"SJ12676813202","room_confirmation_number":"SJ12681963616","room_stay_from":"2021-01-28","room_stay_to":"2021-02-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"112575","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 16:25:20","reservation_modified_date_time":"2021-02-01 18:20:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112575","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":"3189342","reservation_id":"106562","confirmation_number":"SJ12674501286","room_confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"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,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,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,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,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,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,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,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,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":"101703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:54:06","reservation_modified_date_time":"2021-02-01 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101703","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":"3189444","reservation_id":"106599","confirmation_number":"SJ12625163560","room_confirmation_number":"SJ12690191129","room_stay_from":"2021-02-14","room_stay_to":"2021-02-18","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113023","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 02:49:27","reservation_modified_date_time":"2021-02-01 19:34:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113023","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":"3189825","reservation_id":"106594","confirmation_number":"SJ12636134248","room_confirmation_number":"SJ12655845080","room_stay_from":"2021-03-17","room_stay_to":"2021-03-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113017","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 01:31:24","reservation_modified_date_time":"2021-02-02 00:06:26","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113017","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3189223","reservation_id":"106626","confirmation_number":"SJ12693211614","room_confirmation_number":"SJ12690742241","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-02-01 17:22:52","reservation_modified_date_time":"2021-02-01 17:22:52","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}