{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-09-10","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":10,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1281,1289,1296","block_room_bookings":[{"confirmation_number":"SJ12642939796","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","bundle_room":"0","product_id":"1281"},{"confirmation_number":"SJ12691733232","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12676238580","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","bundle_room":"0","product_id":"1296"}],"bundle_block_count":"1269,1270,1271,1272,1307,1308,1309,1310,1311,1312,1302,1303,1267,1268,1304,1305,1291,1711,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":"SJB12659389870","room_stay_from":"2021-09-10","room_stay_to":"2021-09-11","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12692555552","room_stay_from":"2021-09-10","room_stay_to":"2021-09-11","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12616902880","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12612951249","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","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":"251.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":"118.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3282029","reservation_id":"119114","confirmation_number":"SJ12672168517","room_stay_from":"2021-09-10","room_stay_to":"2021-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.32,166.32,141.12,141.12","nightly_discount":"0,0,0,0","subtotal":"614.88","grand_total":"691.74","paid_amount":"691.74","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3154442873","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":"126233","customer_id":"126233","source_of_creation":"Booking.com","reservation_created_date":"2021-07-11 15:27:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"128.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"166.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3299683","reservation_id":"120898","confirmation_number":"SJ12643492296","room_stay_from":"2021-09-10","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.27,207.27,191.52,156.87,156.87","nightly_discount":"0,0,0,0,0","subtotal":"919.80","grand_total":"1034.78","paid_amount":"1034.78","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3358998987","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":"128297","customer_id":"128297","source_of_creation":"Booking.com","reservation_created_date":"2021-08-07 18:17:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"188.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"207.27","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":"3302910","reservation_id":"120253","confirmation_number":"SJ12672369640","room_stay_from":"2021-09-10","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,186.75","nightly_discount":"0,0,0","subtotal":"680.25","grand_total":"765.28","paid_amount":"765.28","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-3865202159","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":"127518","customer_id":"127518","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 04:38:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"135.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"5310300","reservation_id":"121739","confirmation_number":"SJ12612444357","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.19,213.19","nightly_discount":"0,0","subtotal":"426.38","grand_total":"479.68","paid_amount":"479.68","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3043840479","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":"129284","customer_id":"129284","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 04:55:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"85.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"213.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":"5311320","reservation_id":"121930","confirmation_number":"SJ12632546432","room_stay_from":"2021-09-10","room_stay_to":"2021-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,139.30,139.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3056422772","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":"129467","customer_id":"129467","source_of_creation":"Booking.com","reservation_created_date":"2021-08-25 23:19:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5311703","reservation_id":"121691","confirmation_number":"SJ12668430519","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"323.28,323.28","nightly_discount":"0,0","subtotal":"646.56","grand_total":"727.38","paid_amount":"727.38","room_type_id":"320","product_id":"1321","siteminder_id":"BDC-2687108144","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":"129234","customer_id":"129234","source_of_creation":"Booking.com","reservation_created_date":"2021-08-22 15:50:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"125.38","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"323.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":"5311630","reservation_id":"122802","confirmation_number":"SJ12659965202","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":"199.87,199.87,139.12","nightly_discount":"0,0,0","subtotal":"538.86","grand_total":"606.21","paid_amount":"224.85","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3539755903","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":"130459","customer_id":"130459","source_of_creation":"Booking.com","reservation_created_date":"2021-09-09 17:49:24","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","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":"5311851","reservation_id":"122450","confirmation_number":"SJ12634007658","room_stay_from":"2021-09-28","room_stay_to":"2021-10-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.83,120.83,201.83,201.83","nightly_discount":"0,0,0,0","subtotal":"645.32","grand_total":"725.99","paid_amount":"135.93","room_type_id":"319","product_id":"1293","siteminder_id":"BDC-2786425672","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":"130517","customer_id":"130046","source_of_creation":"Booking.com","reservation_created_date":"2021-09-03 01:26:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"93.33","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"}]}],"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":"117.04","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":"167.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":"247.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":"167.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":"5310579","reservation_id":"121940","confirmation_number":"SJ12646997337","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.56,226.56","nightly_discount":"0,0","subtotal":"453.12","grand_total":"509.76","paid_amount":"509.76","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1821397200","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":"129480","customer_id":"129480","source_of_creation":"Expedia","reservation_created_date":"2021-08-26 11:16:10","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":"226.56","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":"5311318","reservation_id":"122327","confirmation_number":"SJ12624946650","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.36,191.36","nightly_discount":"0,0","subtotal":"382.72","grand_total":"430.56","paid_amount":"430.56","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1823862549","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":"129916","customer_id":"129916","source_of_creation":"Expedia","reservation_created_date":"2021-09-01 01:06:17","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":"126","group_rooms":null,"currentDayPrice":"191.36","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":"119.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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5307343","reservation_id":"120420","confirmation_number":"SJ12633755659","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.92,301.92","nightly_discount":"0,0","subtotal":"603.84","grand_total":"699.19","paid_amount":"695.57","room_type_id":"319","product_id":"1287","siteminder_id":"ABB-HM3EJ8HRPB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"603.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127701","customer_id":"127701","source_of_creation":"Airbnb","reservation_created_date":"2021-07-30 16:58:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"17.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"301.92","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"}]},{"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","group_rooms":null,"currentDayPrice":"197.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"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":"269.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":"198.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":"269.25","currentDayDiscount":"13.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"}]},{"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":"269.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":"269.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":"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":"224.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5311607","reservation_id":"122831","confirmation_number":"SJ12698040363","room_stay_from":"2021-09-10","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"381.65","nightly_discount":"0.00","subtotal":"381.65","grand_total":"429.35","paid_amount":"429.35","room_type_id":"320","product_id":"1714","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":"130492","customer_id":"130492","source_of_creation":"PMS","reservation_created_date":"2021-09-10 12:24:33","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","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","currentDayPrice":"381.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":"5311691","reservation_id":"122840","confirmation_number":"SJ12680807407","room_stay_from":"2021-09-10","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"254.15","nightly_discount":"12.71","subtotal":"254.15","grand_total":"271.62","paid_amount":"271.62","room_type_id":"413","product_id":"1266","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":"130496","customer_id":"130496","source_of_creation":"PMS","reservation_created_date":"2021-09-10 15:58:40","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"FLRES","sub_hotel_id":"0","currentDayPrice":"254.15","currentDayDiscount":"12.71","productIsTaxExempt":false,"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":"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":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"520.02","grand_total":"520.02","paid_amount":"168.75","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":"5303150","reservation_id":"118490","confirmation_number":"SJ12633296873","room_stay_from":"2021-09-10","room_stay_to":"2021-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-07-01 22:04:11","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":"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":"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":"5309813","reservation_id":"119208","confirmation_number":"SJ12688113451","room_stay_from":"2021-09-10","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1314","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-07-12 21:59:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"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":"5310601","reservation_id":"121126","confirmation_number":"SJ12628582138","room_stay_from":"2021-09-10","room_stay_to":"2021-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.57,109.57,109.57,109.57,109.57,109.57,109.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"767.00","grand_total":"767.00","paid_amount":"767.00","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-08-13 11:48:00","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"109.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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"}]},{"room_stay_id":"5311778","reservation_id":"119010","confirmation_number":"SJ12616111394","room_stay_from":"2021-09-10","room_stay_to":"2021-09-16","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":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-07-09 19:25:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","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"}]}],"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"}]}],"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":"3282030","reservation_id":"119114","confirmation_number":"SJ12649043474","room_confirmation_number":"SJ12672168517","room_stay_from":"2021-09-10","room_stay_to":"2021-09-14","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":"126233","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-11 15:27:07","reservation_modified_date_time":"2021-07-11 15:27:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126233","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":"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":"3299684","reservation_id":"120898","confirmation_number":"SJ12612690711","room_confirmation_number":"SJ12643492296","room_stay_from":"2021-09-10","room_stay_to":"2021-09-15","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":"128297","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-07 18:17:07","reservation_modified_date_time":"2021-08-07 18:17:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128297","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":"3302911","reservation_id":"120253","confirmation_number":"SJ12661574370","room_confirmation_number":"SJ12672369640","room_stay_from":"2021-09-10","room_stay_to":"2021-09-13","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":"127518","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-28 04:38:13","reservation_modified_date_time":"2021-08-15 15:31:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127518","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":"5303149","reservation_id":"118490","confirmation_number":"SJ12681797759","room_confirmation_number":"SJ12633296873","room_stay_from":"2021-09-10","room_stay_to":"2021-09-17","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":"125526","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-01 22:04:11","reservation_modified_date_time":"2021-08-25 19:06:18","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":"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":"5307345","reservation_id":"120420","confirmation_number":"SJ12670421225","room_confirmation_number":"SJ12633755659","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"127701","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-30 16:58:10","reservation_modified_date_time":"2021-09-01 16:32:17","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127701","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","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":"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":"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":"5309814","reservation_id":"119208","confirmation_number":"SJ12666657655","room_confirmation_number":"SJ12688113451","room_stay_from":"2021-09-10","room_stay_to":"2021-09-15","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":"126335","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-12 21:59:49","reservation_modified_date_time":"2021-09-07 12:50:25","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":"5310301","reservation_id":"121739","confirmation_number":"SJ12675380786","room_confirmation_number":"SJ12612444357","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","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":"129284","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-23 04:55:10","reservation_modified_date_time":"2021-09-07 20:22:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129284","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":"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":"5310580","reservation_id":"121940","confirmation_number":"SJ12644813310","room_confirmation_number":"SJ12646997337","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","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":"129480","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-26 11:16:10","reservation_modified_date_time":"2021-09-08 17:50:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129480","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":"5310602","reservation_id":"121126","confirmation_number":"SJ12692933569","room_confirmation_number":"SJ12628582138","room_stay_from":"2021-09-10","room_stay_to":"2021-09-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"128577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-13 11:48:00","reservation_modified_date_time":"2021-09-08 17:58:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"5311319","reservation_id":"122327","confirmation_number":"SJ12667492077","room_confirmation_number":"SJ12624946650","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","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":"129916","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-01 01:06:17","reservation_modified_date_time":"2021-09-09 21:22:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129916","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":"5311321","reservation_id":"121930","confirmation_number":"SJ12646179874","room_confirmation_number":"SJ12632546432","room_stay_from":"2021-09-10","room_stay_to":"2021-09-14","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":"129467","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 23:19:16","reservation_modified_date_time":"2021-09-09 21:23:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129467","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":"5311608","reservation_id":"122831","confirmation_number":"SJ12680499882","room_confirmation_number":"SJ12698040363","room_stay_from":"2021-09-10","room_stay_to":"2021-09-11","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":"130492","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-10 12:24:33","reservation_modified_date_time":"2021-09-10 12:24:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130492","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":"5311692","reservation_id":"122840","confirmation_number":"SJ12685756786","room_confirmation_number":"SJ12680807407","room_stay_from":"2021-09-10","room_stay_to":"2021-09-11","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":"130496","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-10 15:58:40","reservation_modified_date_time":"2021-09-10 15:58:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130496","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":"5311706","reservation_id":"121691","confirmation_number":"SJ12668963731","room_confirmation_number":"SJ12668430519","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","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":"129234","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-22 15:50:14","reservation_modified_date_time":"2021-09-10 16:22:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129234","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":"5311779","reservation_id":"119010","confirmation_number":"SJ12672759601","room_confirmation_number":"SJ12616111394","room_stay_from":"2021-09-10","room_stay_to":"2021-09-16","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":"126114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-09 19:25:50","reservation_modified_date_time":"2021-09-10 19:50: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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5311629","reservation_id":"122802","confirmation_number":"SJ12612529480","room_confirmation_number":"SJ12659965202","room_stay_from":"2021-09-17","room_stay_to":"2021-09-20","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":"130459","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-09 17:49:24","reservation_modified_date_time":"2021-09-10 14:21:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130459","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":"5311852","reservation_id":"122450","confirmation_number":"SJ12637534286","room_confirmation_number":"SJ12634007658","room_stay_from":"2021-09-28","room_stay_to":"2021-10-02","room_stay_status":"Active","nightly_price":"25.00,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"130517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-03 01:26:14","reservation_modified_date_time":"2021-09-10 23:03:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130046","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}