{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-09-09","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":7,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1269,1270,1271,1272,1307,1308,1309,1310,1311,1312,1302,1303,1267,1268,1304,1305,1291,1711,1260,1261,1262,1263","bundle_block_bookings":[{"confirmation_number":"SJB12639282813","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12698871940","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12623026050","room_stay_from":"2021-09-05","room_stay_to":"2021-09-11","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12676955157","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12647557290","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12635628086","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12672032359","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12672297906","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12632128562","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12656100144","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12610196115","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12686553101","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12623068929","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12670012814","room_stay_from":"2021-09-08","room_stay_to":"2021-09-10","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12656354887","room_stay_from":"2021-09-09","room_stay_to":"2021-09-10","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12661457715","room_stay_from":"2021-09-09","room_stay_to":"2021-09-10","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12688370040","room_stay_from":"2021-09-09","room_stay_to":"2021-09-10","bundle_room":"0","product_id":"1263"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3225706","reservation_id":"111800","confirmation_number":"SJ12690694839","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"251.30,223.30,223.30,223.30,223.30,223.30,251.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1619.10","grand_total":"1821.49","paid_amount":"1821.49","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-3270329196","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":"118357","customer_id":"118357","source_of_creation":"Booking.com","reservation_created_date":"2021-03-31 23:53:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"322.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"223.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":"3256011","reservation_id":"115744","confirmation_number":"SJ12656389710","room_stay_from":"2021-09-08","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.16,95.82,118.50,118.50,95.82,95.82,95.82","nightly_discount":"0,0,0,0,0,0,0","subtotal":"727.44","grand_total":"818.37","paid_amount":"818.37","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2615072902","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":"122519","customer_id":"122519","source_of_creation":"Booking.com","reservation_created_date":"2021-05-23 19:44:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"162.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"95.82","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":"5304673","reservation_id":"122060","confirmation_number":"SJ12635698674","room_stay_from":"2021-09-08","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.20,183.20","nightly_discount":"0,0","subtotal":"366.40","grand_total":"412.20","paid_amount":"412.20","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-3363959270","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":"129612","customer_id":"129612","source_of_creation":"Booking.com","reservation_created_date":"2021-08-28 01:40:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"74.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"183.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":"5305859","reservation_id":"121150","confirmation_number":"SJ12663517871","room_stay_from":"2021-09-08","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"160.02,160.02,160.02,160.02,160.02,160.02,160.02","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1120.14","grand_total":"1260.16","paid_amount":"1260.16","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3273137917","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":"128605","customer_id":"128605","source_of_creation":"Booking.com","reservation_created_date":"2021-08-13 22:15:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"233.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.02","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":"5307634","reservation_id":"122396","confirmation_number":"SJ12631147058","room_stay_from":"2021-09-08","room_stay_to":"2021-09-10","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-3225114848","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":"129991","customer_id":"129991","source_of_creation":"Booking.com","reservation_created_date":"2021-09-02 04:40:13","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":"5309562","reservation_id":"114568","confirmation_number":"SJ12638896256","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.25,164.25,149.25","nightly_discount":"0,0,0","subtotal":"477.75","grand_total":"537.47","paid_amount":"537.47","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2420043246","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":"121261","customer_id":"121261","source_of_creation":"Booking.com","reservation_created_date":"2021-05-05 13:02:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"99.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"149.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5310954","reservation_id":"122782","confirmation_number":"SJ12617779509","room_stay_from":"2021-09-09","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.01","nightly_discount":"0","subtotal":"137.01","grand_total":"154.14","paid_amount":"154.14","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3422842897","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":"130444","customer_id":"130444","source_of_creation":"Booking.com","reservation_created_date":"2021-09-09 10:01:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"29.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"137.01","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":"5311206","reservation_id":"119065","confirmation_number":"SJ12651004347","room_stay_from":"2021-09-17","room_stay_to":"2021-09-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,118.30","nightly_discount":"0,0,0","subtotal":"466.90","grand_total":"525.27","paid_amount":"196.09","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3044962710","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":"126173","customer_id":"126173","source_of_creation":"Booking.com","reservation_created_date":"2021-07-10 18:11:21","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"97.53","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5311489","reservation_id":"121980","confirmation_number":"SJ12688482930","room_stay_from":"2021-11-11","room_stay_to":"2021-11-13","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"172.48,222.88","nightly_discount":"0,0","subtotal":"395.36","grand_total":"444.78","paid_amount":"178.40","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3043781196","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129521","customer_id":"129521","source_of_creation":"Booking.com","reservation_created_date":"2021-08-26 22:58:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"98.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"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":"3280082","reservation_id":"118880","confirmation_number":"SJ12643027053","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.84,105.84,94.64,117.04","nightly_discount":"0,0,0,0","subtotal":"423.36","grand_total":"476.28","paid_amount":"476.28","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1797304727","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":"125966","customer_id":"125966","source_of_creation":"Expedia","reservation_created_date":"2021-07-07 21:06:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"94.64","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":"3295810","reservation_id":"119506","confirmation_number":"SJ12698871048","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,230.30,153.30,153.30,153.30,139.30,167.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1248.10","grand_total":"1404.12","paid_amount":"1404.12","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1802464427","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":"126659","customer_id":"126659","source_of_creation":"Expedia","reservation_created_date":"2021-07-17 16:00:13","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":"139.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":"5030983","reservation_id":"121666","confirmation_number":"SJ12664999426","room_stay_from":"2021-09-09","room_stay_to":"2021-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.80,247.80,247.80,177.80,177.80","nightly_discount":"0,0,0,0,0","subtotal":"1029.00","grand_total":"1157.63","paid_amount":"1157.63","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1819402088","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":"129202","customer_id":"129202","source_of_creation":"Expedia","reservation_created_date":"2021-08-21 20:59:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"177.80","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":"5306895","reservation_id":"121919","confirmation_number":"SJ12614958037","room_stay_from":"2021-09-08","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.44,111.44,167.44,167.44","nightly_discount":"0,0,0,0","subtotal":"557.76","grand_total":"627.48","paid_amount":"627.48","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1821172306","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":"129454","customer_id":"129454","source_of_creation":"Expedia","reservation_created_date":"2021-08-25 21:36:08","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":"111.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":"5311276","reservation_id":"113654","confirmation_number":"SJ12660340283","room_stay_from":"2022-01-23","room_stay_to":"2022-01-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.20,199.20","nightly_discount":"0,0","subtotal":"398.40","grand_total":"448.20","paid_amount":"0.00","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1762640100","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":"120255","customer_id":"120255","source_of_creation":"Expedia","reservation_created_date":"2021-04-22 21:19:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"79.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"From 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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5307346","reservation_id":"118935","confirmation_number":"SJ12610570746","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"108.49,108.49,97.01,119.97,119.97","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"553.93","grand_total":"623.17","paid_amount":"623.17","room_type_id":"319","product_id":"1942","siteminder_id":"GAM-R2645863439","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":"126029","customer_id":"126029","source_of_creation":"Getaroom.com","reservation_created_date":"2021-07-08 16:57:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"97.01","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5311492","reservation_id":"119734","confirmation_number":"SJ12688570776","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.94,200.94,197.38","nightly_discount":"0.00,0.00,0.00","subtotal":"599.26","grand_total":"694.46","paid_amount":"694.46","room_type_id":"319","product_id":"1288","siteminder_id":"ABB-HMTZA3Q8ZX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"602.82","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126927","customer_id":"126927","source_of_creation":"Airbnb","reservation_created_date":"2021-07-20 19:23:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"17.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"200.94","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":"5311210","reservation_id":"122375","confirmation_number":"SJ12641526066","room_stay_from":"2021-09-08","room_stay_to":"2021-09-09","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.50","nightly_discount":"0.00","subtotal":"181.50","grand_total":"210.34","paid_amount":"210.34","room_type_id":"413","product_id":"1262","siteminder_id":"ABB-HMRKMPNS4Y","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"182.58","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129968","customer_id":"129968","source_of_creation":"Airbnb","reservation_created_date":"2021-09-01 23:50:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"5.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-1.08","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.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":"3273890","reservation_id":"118120","confirmation_number":"SJ12625200294","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"239.25,269.25,269.25,239.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1017.00","grand_total":"1144.13","paid_amount":"1144.13","room_type_id":"320","product_id":"1328","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":"125121","customer_id":"125121","source_of_creation":"FE","reservation_created_date":"2021-06-26 15:11:23","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","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":"1302,1303","currentDayPrice":"239.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":"3276930","reservation_id":"118547","confirmation_number":"SJ12621528288","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.00,265.50,183.00,183.00,183.00,168.00,198.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1468.50","grand_total":"1652.07","paid_amount":"1652.07","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":"125581","customer_id":"125581","source_of_creation":"FE","reservation_created_date":"2021-07-02 18:14:42","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":"168.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3250005","reservation_id":"115004","confirmation_number":"SJ12677525080","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,269.25,269.25,239.25","nightly_discount":"11.96,13.46,13.46,11.96","subtotal":"1017.00","grand_total":"1086.93","paid_amount":"1086.93","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":"121716","customer_id":"121716","source_of_creation":"PMS","reservation_created_date":"2021-05-11 17:43:41","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":"AAA","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"239.25","currentDayDiscount":"11.96","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3250017","reservation_id":"115004","confirmation_number":"SJ12626577734","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.25,269.25,269.25,239.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"967.00","grand_total":"1087.88","paid_amount":"1087.88","room_type_id":"320","product_id":"1910","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121716","customer_id":"121716","source_of_creation":"PMS","reservation_created_date":"2021-05-11 17:43:43","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1309,1310","currentDayPrice":"189.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":"3250021","reservation_id":"115004","confirmation_number":"SJ12657067827","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,269.25,269.25,189.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"967.00","grand_total":"1087.88","paid_amount":"1087.88","room_type_id":"320","product_id":"1332","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":"121716","customer_id":"121716","source_of_creation":"PMS","reservation_created_date":"2021-05-11 17:43:42","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","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":"1311,1312","currentDayPrice":"239.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":"3294702","reservation_id":"120167","confirmation_number":"SJ12612968384","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.00,194.00,194.00,194.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"776.00","grand_total":"873.00","paid_amount":"873.00","room_type_id":"319","product_id":"1293","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":"98630","customer_id":"98630","source_of_creation":"PMS","reservation_created_date":"2021-07-27 00:42:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"194.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":"5310498","reservation_id":"121411","confirmation_number":"SJ12677091391","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"149.25,149.25,224.25","nightly_discount":"0.00,0.00,0.00","subtotal":"522.75","grand_total":"588.10","paid_amount":"588.10","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128881","customer_id":"128881","source_of_creation":"PMS","reservation_created_date":"2021-08-18 18:38:03","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"5311515","reservation_id":"122800","confirmation_number":"SJ12656070890","room_stay_from":"2021-09-09","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.20","nightly_discount":"12.46","subtotal":"249.20","grand_total":"266.34","paid_amount":"266.34","room_type_id":"320","product_id":"1321","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":"130456","customer_id":"130456","source_of_creation":"PMS","reservation_created_date":"2021-09-09 17:27:58","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"FLRES","sub_hotel_id":"0","currentDayPrice":"249.20","currentDayDiscount":"12.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":[],"negotiated_non_taxable":[{"room_stay_id":"3295149","reservation_id":"117770","confirmation_number":"SJ12624447202","room_stay_from":"2021-09-05","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"640.00","grand_total":"640.00","paid_amount":"140.63","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2021-06-21 16:50:06","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":"128.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":"5302826","reservation_id":"113235","confirmation_number":"SJ12652002656","room_stay_from":"2021-09-05","room_stay_to":"2021-09-11","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"522.00","grand_total":"522.00","paid_amount":"168.75","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 18:25:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"5303008","reservation_id":"116488","confirmation_number":"SJ12633393707","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","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":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1275","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-06-03 22:55:33","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":"0","group_rooms":null,"currentDayPrice":"86.67","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":"5303054","reservation_id":"113561","confirmation_number":"SJ12628256823","room_stay_from":"2021-09-09","room_stay_to":"2021-09-15","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,86.67","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"520.02","grand_total":"520.02","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":"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-21 19:37:44","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","group_rooms":null,"currentDayPrice":"86.67","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":"5309408","reservation_id":"116003","confirmation_number":"SJ12694325562","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"260.01","paid_amount":"84.38","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-27 19:59:17","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":"86.67","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":"5309811","reservation_id":"116771","confirmation_number":"SJ12697603548","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","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":"260.01","paid_amount":"84.38","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-06-08 00:23:30","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":"86.67","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":"5310153","reservation_id":"116043","confirmation_number":"SJ12657978495","room_stay_from":"2021-09-09","room_stay_to":"2021-09-12","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":"260.01","paid_amount":"84.38","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-28 00:08:08","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","group_rooms":null,"currentDayPrice":"86.67","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":"5310272","reservation_id":"110548","confirmation_number":"SJ12622110776","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"260.00","paid_amount":"84.38","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:51:46","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","group_rooms":null,"currentDayPrice":"86.66","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":"5310638","reservation_id":"114389","confirmation_number":"SJ12623138511","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","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":"260.01","paid_amount":"84.38","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-02 22:38:41","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","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5310500","reservation_id":"121411","confirmation_number":"SJ12658306293","room_confirmation_number":"SJ12677091391","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"128881","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-09-08 15:41:31","reservation_modified_date_time":"2021-09-08 15:41:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128881","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5311378","reservation_id":"122312","confirmation_number":"SJ12638788271","room_confirmation_number":"SJ12664605038","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","room_stay_status":"Active","nightly_price":"100,100","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"201.20","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"129900","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-09-09 21:42:50","reservation_modified_date_time":"2021-09-09 21:42:50","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129900","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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":"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3225707","reservation_id":"111800","confirmation_number":"SJ12620493139","room_confirmation_number":"SJ12690694839","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"118357","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 23:53:10","reservation_modified_date_time":"2021-03-31 23:53:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118357","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":"3250006","reservation_id":"115004","confirmation_number":"SJ12669689039","room_confirmation_number":"SJ12677525080","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","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":"121716","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 17:43:41","reservation_modified_date_time":"2021-05-11 17:43:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121716","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":"3250020","reservation_id":"115004","confirmation_number":"SJ12642668009","room_confirmation_number":"SJ12626577734","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","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":"121716","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 17:43:43","reservation_modified_date_time":"2021-05-11 17:44:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121716","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":"3250024","reservation_id":"115004","confirmation_number":"SJ12636410735","room_confirmation_number":"SJ12657067827","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","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":"121716","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 17:43:42","reservation_modified_date_time":"2021-05-11 17:44:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121716","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":"3256012","reservation_id":"115744","confirmation_number":"SJ12679855893","room_confirmation_number":"SJ12656389710","room_stay_from":"2021-09-08","room_stay_to":"2021-09-15","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":"122519","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-23 19:44:09","reservation_modified_date_time":"2021-05-23 19:44:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122519","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":"3273891","reservation_id":"118120","confirmation_number":"SJ12680691508","room_confirmation_number":"SJ12625200294","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","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":"125121","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-26 15:11:23","reservation_modified_date_time":"2021-06-26 15:11:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125121","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":"3276931","reservation_id":"118547","confirmation_number":"SJ12646064025","room_confirmation_number":"SJ12621528288","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"125581","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-02 18:14:42","reservation_modified_date_time":"2021-07-02 18:31:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125581","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":"3280083","reservation_id":"118880","confirmation_number":"SJ12679879516","room_confirmation_number":"SJ12643027053","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","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":"125966","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-07 21:06:10","reservation_modified_date_time":"2021-07-07 21:06:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125966","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":"3294703","reservation_id":"120167","confirmation_number":"SJ12655207817","room_confirmation_number":"SJ12612968384","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","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":"98630","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-27 00:42:33","reservation_modified_date_time":"2021-08-02 12:22:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98630","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":"3295151","reservation_id":"117770","confirmation_number":"SJ12635518628","room_confirmation_number":"SJ12624447202","room_stay_from":"2021-09-05","room_stay_to":"2021-09-10","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":"124743","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-21 16:50:06","reservation_modified_date_time":"2021-08-02 19:43:23","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74459","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":"3295812","reservation_id":"119506","confirmation_number":"SJ12655312424","room_confirmation_number":"SJ12698871048","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"126659","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 16:00:13","reservation_modified_date_time":"2021-08-03 19:12:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126659","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":"5030985","reservation_id":"121666","confirmation_number":"SJ12682508468","room_confirmation_number":"SJ12664999426","room_stay_from":"2021-09-09","room_stay_to":"2021-09-14","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":"129202","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-21 20:59:09","reservation_modified_date_time":"2021-08-21 20:59:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129202","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":"5302825","reservation_id":"113235","confirmation_number":"SJ12677799485","room_confirmation_number":"SJ12652002656","room_stay_from":"2021-09-05","room_stay_to":"2021-09-11","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":"119827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 18:25:05","reservation_modified_date_time":"2021-08-25 19:06:13","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":"5303007","reservation_id":"116488","confirmation_number":"SJ12648738217","room_confirmation_number":"SJ12633393707","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","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":"123360","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-03 22:55:33","reservation_modified_date_time":"2021-08-25 19:06:16","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":"5303053","reservation_id":"113561","confirmation_number":"SJ12642397102","room_confirmation_number":"SJ12628256823","room_stay_from":"2021-09-09","room_stay_to":"2021-09-15","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":"120162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 19:37:44","reservation_modified_date_time":"2021-08-25 19:06:17","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":"5304674","reservation_id":"122060","confirmation_number":"SJ12643384994","room_confirmation_number":"SJ12635698674","room_stay_from":"2021-09-08","room_stay_to":"2021-09-10","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":"129612","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-28 01:40:10","reservation_modified_date_time":"2021-08-28 01:40:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129612","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":"5305861","reservation_id":"121150","confirmation_number":"SJ12644104128","room_confirmation_number":"SJ12663517871","room_stay_from":"2021-09-08","room_stay_to":"2021-09-15","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":"128605","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-13 22:15:08","reservation_modified_date_time":"2021-08-30 13:17:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128605","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":"5306896","reservation_id":"121919","confirmation_number":"SJ12685597775","room_confirmation_number":"SJ12614958037","room_stay_from":"2021-09-08","room_stay_to":"2021-09-12","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":"129454","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 21:36:08","reservation_modified_date_time":"2021-08-31 22:50:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129454","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":"5307348","reservation_id":"118935","confirmation_number":"SJ12630863427","room_confirmation_number":"SJ12610570746","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"126029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-08 16:57:07","reservation_modified_date_time":"2021-09-01 16:32:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126029","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":"5307635","reservation_id":"122396","confirmation_number":"SJ12661867792","room_confirmation_number":"SJ12631147058","room_stay_from":"2021-09-08","room_stay_to":"2021-09-10","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":"129991","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-02 04:40:13","reservation_modified_date_time":"2021-09-02 04:40:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129991","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":"5309409","reservation_id":"116003","confirmation_number":"SJ12660236699","room_confirmation_number":"SJ12694325562","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"122813","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 19:59:17","reservation_modified_date_time":"2021-09-06 15:13:28","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":"5309563","reservation_id":"114568","confirmation_number":"SJ12659911139","room_confirmation_number":"SJ12638896256","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"121261","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-05 13:02:12","reservation_modified_date_time":"2021-09-06 18:16:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121261","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":"5309812","reservation_id":"116771","confirmation_number":"SJ12636108376","room_confirmation_number":"SJ12697603548","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","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":"123679","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-08 00:23:30","reservation_modified_date_time":"2021-09-07 12:48:28","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":"5310154","reservation_id":"116043","confirmation_number":"SJ12625895009","room_confirmation_number":"SJ12657978495","room_stay_from":"2021-09-09","room_stay_to":"2021-09-12","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":"122852","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-28 00:08:08","reservation_modified_date_time":"2021-09-07 16:03:35","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":"5310273","reservation_id":"110548","confirmation_number":"SJ12695403678","room_confirmation_number":"SJ12622110776","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"117060","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:51:46","reservation_modified_date_time":"2021-09-07 19:32:33","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":"5310504","reservation_id":"121411","confirmation_number":"SJ12676350100","room_confirmation_number":"SJ12677091391","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","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":"128881","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 18:38:03","reservation_modified_date_time":"2021-09-08 15:41:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128881","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":"5310639","reservation_id":"114389","confirmation_number":"SJ12675044611","room_confirmation_number":"SJ12623138511","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","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":"121059","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-02 22:38:41","reservation_modified_date_time":"2021-09-08 18:34:58","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":"5310955","reservation_id":"122782","confirmation_number":"SJ12662442473","room_confirmation_number":"SJ12617779509","room_stay_from":"2021-09-09","room_stay_to":"2021-09-10","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":"130444","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-09 10:01:11","reservation_modified_date_time":"2021-09-09 10:01:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130444","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":"5311493","reservation_id":"119734","confirmation_number":"SJ12632321684","room_confirmation_number":"SJ12688570776","room_stay_from":"2021-09-08","room_stay_to":"2021-09-11","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":"126927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 19:23:06","reservation_modified_date_time":"2021-09-09 22:54:16","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126927","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":"5311518","reservation_id":"122800","confirmation_number":"SJ12695228566","room_confirmation_number":"SJ12656070890","room_stay_from":"2021-09-09","room_stay_to":"2021-09-10","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":"130456","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-09 17:27:58","reservation_modified_date_time":"2021-09-09 23:17:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130456","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":"5311209","reservation_id":"119065","confirmation_number":"SJ12675365017","room_confirmation_number":"SJ12651004347","room_stay_from":"2021-09-17","room_stay_to":"2021-09-20","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-10 18:11:21","reservation_modified_date_time":"2021-09-09 18:53:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126173","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":"5311279","reservation_id":"113654","confirmation_number":"SJ12642633500","room_confirmation_number":"SJ12660340283","room_stay_from":"2022-01-23","room_stay_to":"2022-01-25","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120255","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 21:19:07","reservation_modified_date_time":"2021-09-09 20:15:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120255","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"From 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":"5311491","reservation_id":"121980","confirmation_number":"SJ12671937641","room_confirmation_number":"SJ12688482930","room_stay_from":"2021-11-11","room_stay_to":"2021-11-13","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129521","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-26 22:58:13","reservation_modified_date_time":"2021-09-09 22:49:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129521","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}