{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-09-25","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":24,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1276,1271,1289,1315","block_room_bookings":[{"confirmation_number":"SJ12617653652","room_stay_from":"2021-09-20","room_stay_to":"2021-09-30","bundle_room":"0","product_id":"1276"},{"confirmation_number":"SJ12637205544","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJ12694975965","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12624916217","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","bundle_room":"0","product_id":"1315"}],"bundle_block_count":"1262,1263,1267,1268,1309,1310,1304,1305,1291,1711,1269,1270,1302,1303,1311,1312,1260,1261,1307,1308,1271,1272","bundle_block_bookings":[{"confirmation_number":"SJB12641765398","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12682852709","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12690009414","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12610490552","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12629562732","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12693918652","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12629112873","room_stay_from":"2021-09-25","room_stay_to":"2021-10-01","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12698967207","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12628278794","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12666712835","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12689523456","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12640515046","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12641474475","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12651937947","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12642424582","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12654841210","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","bundle_room":"1","product_id":"1324"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5314502","reservation_id":"123216","confirmation_number":"SJ12688108875","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"186.48,121.68","nightly_discount":"0,0","subtotal":"308.16","grand_total":"346.68","paid_amount":"346.68","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-3193590020","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":"130924","customer_id":"130924","source_of_creation":"Booking.com","reservation_created_date":"2021-09-17 21:51:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"64.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"186.48","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":"5314660","reservation_id":"118900","confirmation_number":"SJ12683409513","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.08,168.08,114.08","nightly_discount":"0,0,0","subtotal":"450.24","grand_total":"506.52","paid_amount":"506.52","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2187748117","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":"125991","customer_id":"125991","source_of_creation":"Booking.com","reservation_created_date":"2021-07-08 00:57:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"94.53","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"168.08","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":"5315120","reservation_id":"120216","confirmation_number":"SJ12658473700","room_stay_from":"2021-09-25","room_stay_to":"2021-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,195.30,195.30,195.30,195.30,195.30,251.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1479.10","grand_total":"1663.99","paid_amount":"1663.99","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3865278715","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":"127477","customer_id":"127477","source_of_creation":"Booking.com","reservation_created_date":"2021-07-27 19:27:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"297.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"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":"5316047","reservation_id":"123340","confirmation_number":"SJ12649449201","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.09","nightly_discount":"0","subtotal":"221.09","grand_total":"248.72","paid_amount":"248.72","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2343495903","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":"131059","customer_id":"131059","source_of_creation":"Booking.com","reservation_created_date":"2021-09-20 09:09:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"44.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"221.09","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":"5317601","reservation_id":"123605","confirmation_number":"SJ12650412289","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.57,120.89,120.89","nightly_discount":"0,0,0","subtotal":"417.35","grand_total":"469.52","paid_amount":"469.52","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2682566773","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":"131337","customer_id":"131337","source_of_creation":"Booking.com","reservation_created_date":"2021-09-24 18:54:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"88.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"175.57","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":"5317914","reservation_id":"123639","confirmation_number":"SJ12635575139","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"198.98","nightly_discount":"0","subtotal":"198.98","grand_total":"223.85","paid_amount":"223.85","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-3221094103","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":"131379","customer_id":"131379","source_of_creation":"Booking.com","reservation_created_date":"2021-09-25 13:48:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"86.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"198.98","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":"5317916","reservation_id":"123639","confirmation_number":"SJ12690453213","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"208.4","nightly_discount":"0","subtotal":"208.40","grand_total":"234.45","paid_amount":"234.45","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3221094103","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131379","customer_id":"131379","source_of_creation":"Booking.com","reservation_created_date":"2021-09-25 13:48:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"86.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"208.4","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":"5318213","reservation_id":"123432","confirmation_number":"SJ12695605090","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"221.20,221.20","nightly_discount":"185.60,0.00","subtotal":"442.40","grand_total":"288.90","paid_amount":"288.90","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3112123046","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131394","customer_id":"131394","source_of_creation":"Booking.com","reservation_created_date":"2021-09-21 20:16:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"64.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-185.60","currentDayPrice":"221.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318049","reservation_id":"123568","confirmation_number":"SJ12689366714","room_stay_from":"2021-11-08","room_stay_to":"2021-11-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.85,146.85,146.85,146.85,186.54,186.54","nightly_discount":"0,0,0,0,0,0","subtotal":"960.48","grand_total":"1080.54","paid_amount":"165.20","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3946041411","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":"131305","customer_id":"131305","source_of_creation":"Booking.com","reservation_created_date":"2021-09-23 22:28:41","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","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":"5314535","reservation_id":"123218","confirmation_number":"SJ12622605945","room_stay_from":"2021-09-22","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"100.44,100.44,150.84,150.84","nightly_discount":"0,0,0,0","subtotal":"502.56","grand_total":"565.38","paid_amount":"565.38","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1831376431","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130928","customer_id":"130928","source_of_creation":"Expedia","reservation_created_date":"2021-09-17 22:30:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"150.84","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":"5314699","reservation_id":"123245","confirmation_number":"SJ12638263172","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.44,161.84,161.84,111.44","nightly_discount":"0,0,0,0","subtotal":"546.56","grand_total":"614.88","paid_amount":"614.88","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1831589654","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":"130951","customer_id":"130951","source_of_creation":"Expedia","reservation_created_date":"2021-09-18 13:55:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"161.84","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":"5314852","reservation_id":"123254","confirmation_number":"SJ12636831453","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"312.12","nightly_discount":"0","subtotal":"312.12","grand_total":"351.14","paid_amount":"351.14","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1831661545","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":"130966","customer_id":"130966","source_of_creation":"Expedia","reservation_created_date":"2021-09-18 17:35:10","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":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"312.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5315379","reservation_id":"123305","confirmation_number":"SJ12639339153","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.96,200.96","nightly_discount":"0,0","subtotal":"401.92","grand_total":"452.16","paid_amount":"452.16","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1832003950","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":"131020","customer_id":"131020","source_of_creation":"Expedia","reservation_created_date":"2021-09-19 16:40:13","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"200.96","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5316464","reservation_id":"123445","confirmation_number":"SJ12648642263","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.96,127.36","nightly_discount":"0,0","subtotal":"312.32","grand_total":"351.36","paid_amount":"351.36","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1833134052","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":"131175","customer_id":"131175","source_of_creation":"Expedia","reservation_created_date":"2021-09-21 23:05:06","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.96","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5317423","reservation_id":"123583","confirmation_number":"SJ12672467442","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"295.12","nightly_discount":"0","subtotal":"295.12","grand_total":"332.01","paid_amount":"332.01","room_type_id":"320","product_id":"1330","siteminder_id":"EXP-1834305928","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":"131318","customer_id":"131318","source_of_creation":"Expedia","reservation_created_date":"2021-09-24 12:35:10","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":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"295.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318423","reservation_id":"123673","confirmation_number":"SJ12640583178","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"196.52","nightly_discount":"0","subtotal":"196.52","grand_total":"221.09","paid_amount":"221.09","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1834975409","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":"131434","customer_id":"131434","source_of_creation":"Expedia","reservation_created_date":"2021-09-26 01:45:10","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","currentDayPrice":"196.52","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":"5318429","reservation_id":"123674","confirmation_number":"SJ12635560409","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.52","nightly_discount":"0","subtotal":"213.52","grand_total":"240.21","paid_amount":"240.21","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1834986515","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":"131435","customer_id":"131435","source_of_creation":"Expedia","reservation_created_date":"2021-09-26 02:25:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"213.52","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":"3202497","reservation_id":"108238","confirmation_number":"SJ12693546087","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"171.94,193.50,193.50,171.94","nightly_discount":"0,0,0,0","subtotal":"730.88","grand_total":"822.24","paid_amount":"822.24","room_type_id":"320","product_id":"1321","siteminder_id":"GAM-R2341254488","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":"114706","customer_id":"114706","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-22 02:54:12","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":null,"sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"193.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":"5315490","reservation_id":"123318","confirmation_number":"SJ12688344303","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.02,178.02,122.58","nightly_discount":"0,0,0","subtotal":"478.62","grand_total":"538.45","paid_amount":"538.45","room_type_id":"319","product_id":"1288","siteminder_id":"GAM-R2815870066","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":"131032","customer_id":"131032","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-19 19:41:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"178.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":"5318396","reservation_id":"123652","confirmation_number":"SJ12684512455","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.15","nightly_discount":"0","subtotal":"189.15","grand_total":"212.80","paid_amount":"212.80","room_type_id":"319","product_id":"1311","siteminder_id":"GAM-R2828696701","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":"131393","customer_id":"131393","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-25 17:43:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"189.15","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":"5318416","reservation_id":"123008","confirmation_number":"SJ12637070569","room_stay_from":"2021-09-24","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.16,161.16,96.48,96.48","nightly_discount":"0,0,0,0","subtotal":"515.28","grand_total":"579.69","paid_amount":"579.69","room_type_id":"319","product_id":"1291","siteminder_id":"GAM-R2804350421","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":"129179","customer_id":"129179","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-14 15:09:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"161.16","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":"5318426","reservation_id":"123632","confirmation_number":"SJ12683468827","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.90,114.92,114.92","nightly_discount":"0,0,0","subtotal":"396.74","grand_total":"446.34","paid_amount":"446.34","room_type_id":"412","product_id":"1866","siteminder_id":"GAM-R2827984133","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":"131372","customer_id":"131372","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-25 04:17:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"166.90","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5317336","reservation_id":"113530","confirmation_number":"SJ12618340664","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,200.33","nightly_discount":"0.00,0.00,0.00","subtotal":"608.33","grand_total":"704.97","paid_amount":"704.97","room_type_id":"413","product_id":"1260","siteminder_id":"ABB-HMKNHQRD4F","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"612.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120124","customer_id":"120124","source_of_creation":"Airbnb","reservation_created_date":"2021-04-21 14:51:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"18.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"200.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"5317608","reservation_id":"123257","confirmation_number":"SJ12686817641","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.81,237.66","nightly_discount":"0.00,0.00","subtotal":"472.47","grand_total":"547.53","paid_amount":"547.53","room_type_id":"413","product_id":"1261","siteminder_id":"ABB-HMWPBSW4QM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"475.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130970","customer_id":"130970","source_of_creation":"Airbnb","reservation_created_date":"2021-09-18 18:25:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"13.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"237.66","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"5317623","reservation_id":"123440","confirmation_number":"SJ12660620688","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.66,237.66,233.45","nightly_discount":"0.00,0.00,0.00","subtotal":"708.77","grand_total":"821.37","paid_amount":"821.37","room_type_id":"319","product_id":"1942","siteminder_id":"ABB-HM9FMXK3JH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"712.98","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131171","customer_id":"131171","source_of_creation":"Airbnb","reservation_created_date":"2021-09-21 22:18:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"20.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"237.66","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":"5317802","reservation_id":"119106","confirmation_number":"SJ12661778281","room_stay_from":"2021-09-24","room_stay_to":"2021-09-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.52,179.52,179.52,179.52,179.52,173.06","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1070.66","grand_total":"1240.75","paid_amount":"1240.75","room_type_id":"319","product_id":"1301","siteminder_id":"ABB-HMCR9RXFQX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1077.12","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126224","customer_id":"126224","source_of_creation":"Airbnb","reservation_created_date":"2021-07-11 14:27:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"31.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"5317853","reservation_id":"119277","confirmation_number":"SJ12610151860","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.52,179.52,176.29","nightly_discount":"0.00,0.00,0.00","subtotal":"535.33","grand_total":"620.37","paid_amount":"620.37","room_type_id":"413","product_id":"1266","siteminder_id":"ABB-HMJBAYRP2Y","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"538.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126407","customer_id":"126407","source_of_creation":"Airbnb","reservation_created_date":"2021-07-13 22:39:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"15.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"179.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"5317907","reservation_id":"123581","confirmation_number":"SJ12671224866","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.48","nightly_discount":"0.00","subtotal":"235.48","grand_total":"277.36","paid_amount":"277.36","room_type_id":"319","product_id":"1318","siteminder_id":"ABB-HM2WQSPDD3","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"265.20","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131316","customer_id":"131316","source_of_creation":"Airbnb","reservation_created_date":"2021-09-24 05:03:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"7.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"235.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3230491","reservation_id":"112433","confirmation_number":"SJ12637780160","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"269.25,239.25,239.25","nightly_discount":"0.00,0.00,0.00","subtotal":"747.75","grand_total":"841.22","paid_amount":"841.22","room_type_id":"320","product_id":"1322","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":"119005","customer_id":"119005","source_of_creation":"FE","reservation_created_date":"2021-04-08 12:48:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1267,1268","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":"5310432","reservation_id":"115141","confirmation_number":"SJ12675161523","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"239.25,299.25,299.25","nightly_discount":"0.00,0.00,0.00","subtotal":"837.75","grand_total":"942.47","paid_amount":"942.47","room_type_id":"320","product_id":"1323","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121847","customer_id":"121847","source_of_creation":"FE","reservation_created_date":"2021-05-13 15:42:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1269,1270","currentDayPrice":"299.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":"5312479","reservation_id":"122949","confirmation_number":"SJ12613090192","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.50,265.50,265.50","nightly_discount":"0.00,0.00,0.00","subtotal":"721.50","grand_total":"811.69","paid_amount":"811.69","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130619","customer_id":"130619","source_of_creation":"FE","reservation_created_date":"2021-09-13 00:57:03","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"265.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"5309446","reservation_id":"120677","confirmation_number":"SJ12652566869","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"265.20","nightly_discount":"0.00","subtotal":"265.20","grand_total":"298.35","paid_amount":"298.35","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128030","customer_id":"128030","source_of_creation":"PMS","reservation_created_date":"2021-08-03 17:49:12","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":"265.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5313332","reservation_id":"123053","confirmation_number":"SJ12618258892","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"220.15,143.65","nightly_discount":"0.00,0.00","subtotal":"363.80","grand_total":"409.28","paid_amount":"409.28","room_type_id":"413","product_id":"1273","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":"130730","customer_id":"130730","source_of_creation":"PMS","reservation_created_date":"2021-09-15 00:51:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"220.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5314072","reservation_id":"123087","confirmation_number":"SJ12611538183","room_stay_from":"2021-09-20","room_stay_to":"2021-09-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,149.25,149.25,149.25,216.75,216.75,149.25,149.25,149.25","nightly_discount":"14.93,14.93,14.93,14.93,21.68,21.68,14.93,14.93,14.93","subtotal":"1478.25","grand_total":"1496.68","paid_amount":"1496.68","room_type_id":"319","product_id":"1310","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":"88476","customer_id":"88476","source_of_creation":"PMS","reservation_created_date":"2021-09-15 17:00:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"216.75","currentDayDiscount":"21.68","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5314926","reservation_id":"123264","confirmation_number":"SJ12668641736","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"220.15,220.15","nightly_discount":"0.00,0.00","subtotal":"440.30","grand_total":"495.34","paid_amount":"495.34","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130977","customer_id":"130977","source_of_creation":"PMS","reservation_created_date":"2021-09-18 20:03:42","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"220.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5318435","reservation_id":"123676","confirmation_number":"SJ12666615043","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.20,101.60","nightly_discount":"0.00,0.00","subtotal":"256.80","grand_total":"288.90","paid_amount":"288.90","room_type_id":"412","product_id":"1297","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":"131437","customer_id":"131437","source_of_creation":"PMS","reservation_created_date":"2021-09-26 04:25:29","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"155.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3304853","reservation_id":"120392","confirmation_number":"SJ12657139706","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","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":"0.00","room_type_id":"319","product_id":"1312","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-07-30 11:50:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"109.58","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":"5303072","reservation_id":"117567","confirmation_number":"SJ12625971188","room_stay_from":"2021-09-24","room_stay_to":"2021-10-01","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":"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-18 20:52:27","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":"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":"5303116","reservation_id":"117955","confirmation_number":"SJ12666348140","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"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-06-24 02:32:17","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":"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":"5303246","reservation_id":"119942","confirmation_number":"SJ12649827785","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","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":"1943","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-23 23:48:06","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":"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":"5303248","reservation_id":"119944","confirmation_number":"SJ12691754816","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-07-23 23:51:44","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","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":"5303310","reservation_id":"119943","confirmation_number":"SJ12617887920","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","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":"1309","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-23 23:49:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"5303322","reservation_id":"119949","confirmation_number":"SJ12663023087","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"1305","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-07-24 00:52:44","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":"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":"5303350","reservation_id":"119960","confirmation_number":"SJ12618528685","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"1304","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-24 02:24:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","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":"5309871","reservation_id":"119530","confirmation_number":"SJ12676964991","room_stay_from":"2021-09-24","room_stay_to":"2021-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.85,112.85,112.85,112.85,112.85,112.85,112.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"790.00","grand_total":"790.00","paid_amount":"0.00","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-07-17 19:14:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"112.85","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":"5314666","reservation_id":"116171","confirmation_number":"SJ12623550995","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-30 00:22:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"5314997","reservation_id":"121558","confirmation_number":"SJ12618450478","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","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.57","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"766.99","grand_total":"766.99","paid_amount":"0.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":"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-20 12:06:30","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":"109.57","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5315990","reservation_id":"117582","confirmation_number":"SJ12692838958","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-18 22:30:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"5316179","reservation_id":"118626","confirmation_number":"SJ12622419940","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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-03 21:41:30","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5310435","reservation_id":"115141","confirmation_number":"SJ12610858895","room_confirmation_number":"SJ12675161523","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"121847","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-09-08 14:40:35","reservation_modified_date_time":"2021-09-08 14:40:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121847","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5313333","reservation_id":"123053","confirmation_number":"SJ12665963598","room_confirmation_number":"SJ12618258892","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"130730","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-09-15 00:51:05","reservation_modified_date_time":"2021-09-15 00:51:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130730","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5314536","reservation_id":"123218","confirmation_number":"SJ12619254591","room_confirmation_number":"SJ12622605945","room_stay_from":"2021-09-22","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"130928","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-09-17 22:30:11","reservation_modified_date_time":"2021-09-17 22:30:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130928","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5314928","reservation_id":"123264","confirmation_number":"SJ12689769596","room_confirmation_number":"SJ12668641736","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"50.00,50.00","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"130977","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-09-18 20:03:42","reservation_modified_date_time":"2021-09-18 20:03:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130977","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5317917","reservation_id":"123639","confirmation_number":"SJ12667084010","room_confirmation_number":"SJ12690453213","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"131379","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-09-25 13:48:18","reservation_modified_date_time":"2021-09-25 13:48:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131379","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"5318193","reservation_id":"123432","confirmation_number":"SJ12617117997","room_confirmation_number":"SJ12695605090","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"25.00,25.00","subtotal":"100.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"131394","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-09-25 17:59:06","reservation_modified_date_time":"2021-09-25 17:59:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131394","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-25.00","currentDayPrice":"50","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3202498","reservation_id":"108238","confirmation_number":"SJ12675137606","room_confirmation_number":"SJ12693546087","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"114706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 02:54:12","reservation_modified_date_time":"2021-02-22 02:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114706","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":"3230492","reservation_id":"112433","confirmation_number":"SJ12624568313","room_confirmation_number":"SJ12637780160","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","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":"119005","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 12:48:11","reservation_modified_date_time":"2021-04-08 12:48:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119005","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":"3304855","reservation_id":"120392","confirmation_number":"SJ12652453013","room_confirmation_number":"SJ12657139706","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","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":"127669","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-30 11:50:52","reservation_modified_date_time":"2021-08-19 17:19:19","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":"5303071","reservation_id":"117567","confirmation_number":"SJ12693902418","room_confirmation_number":"SJ12625971188","room_stay_from":"2021-09-24","room_stay_to":"2021-10-01","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":"124528","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-18 20:52:27","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":"5303115","reservation_id":"117955","confirmation_number":"SJ12690784852","room_confirmation_number":"SJ12666348140","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"124946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 02:32:17","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":"5303245","reservation_id":"119942","confirmation_number":"SJ12650132281","room_confirmation_number":"SJ12649827785","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","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":"127169","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-23 23:48:06","reservation_modified_date_time":"2021-08-25 19:06:20","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":"5303247","reservation_id":"119944","confirmation_number":"SJ12693158504","room_confirmation_number":"SJ12691754816","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"127171","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-23 23:51:44","reservation_modified_date_time":"2021-08-25 19:06:20","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":"5303309","reservation_id":"119943","confirmation_number":"SJ12647800860","room_confirmation_number":"SJ12617887920","room_stay_from":"2021-09-22","room_stay_to":"2021-09-27","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":"127170","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-23 23:49:57","reservation_modified_date_time":"2021-08-25 19:06:21","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":"5303321","reservation_id":"119949","confirmation_number":"SJ12635971910","room_confirmation_number":"SJ12663023087","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"127175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-24 00:52:44","reservation_modified_date_time":"2021-08-25 19:06:21","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":"5303349","reservation_id":"119960","confirmation_number":"SJ12626932755","room_confirmation_number":"SJ12618528685","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"127188","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-24 02:24:32","reservation_modified_date_time":"2021-08-25 19:06:22","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":"5309448","reservation_id":"120677","confirmation_number":"SJ12670543990","room_confirmation_number":"SJ12652566869","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","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":"128030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-03 17:49:13","reservation_modified_date_time":"2021-09-06 15:59:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128030","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":"5309873","reservation_id":"119530","confirmation_number":"SJ12668010275","room_confirmation_number":"SJ12676964991","room_stay_from":"2021-09-24","room_stay_to":"2021-10-01","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":"126688","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 19:14:47","reservation_modified_date_time":"2021-09-07 13:15:54","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":"5310436","reservation_id":"115141","confirmation_number":"SJ12676639333","room_confirmation_number":"SJ12675161523","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"121847","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-13 15:42:11","reservation_modified_date_time":"2021-09-08 14:40:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121847","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":"5312480","reservation_id":"122949","confirmation_number":"SJ12613011838","room_confirmation_number":"SJ12613090192","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"130619","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-13 00:57:03","reservation_modified_date_time":"2021-09-13 00:57:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130619","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":"5313334","reservation_id":"123053","confirmation_number":"SJ12636002667","room_confirmation_number":"SJ12618258892","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","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":"130730","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-15 00:51:05","reservation_modified_date_time":"2021-09-15 00:51:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130730","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":"5313578","reservation_id":"123087","confirmation_number":"SJ12698774683","room_confirmation_number":"SJ12611538183","room_stay_from":"2021-09-20","room_stay_to":"2021-09-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"88476","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-15 17:00:38","reservation_modified_date_time":"2021-09-15 17:00:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88476","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":"5314503","reservation_id":"123216","confirmation_number":"SJ12622479787","room_confirmation_number":"SJ12688108875","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","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":"130924","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-17 21:51:09","reservation_modified_date_time":"2021-09-17 21:51:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130924","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":"5314537","reservation_id":"123218","confirmation_number":"SJ12643141940","room_confirmation_number":"SJ12622605945","room_stay_from":"2021-09-22","room_stay_to":"2021-09-26","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":"130928","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-17 22:30:11","reservation_modified_date_time":"2021-09-17 22:30:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130928","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5314661","reservation_id":"118900","confirmation_number":"SJ12633505878","room_confirmation_number":"SJ12683409513","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"125991","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-08 00:57:11","reservation_modified_date_time":"2021-09-18 13:20:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125991","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":"5314667","reservation_id":"116171","confirmation_number":"SJ12651408012","room_confirmation_number":"SJ12623550995","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123017","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-30 00:22:56","reservation_modified_date_time":"2021-09-18 13:21:49","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":"5314700","reservation_id":"123245","confirmation_number":"SJ12688255585","room_confirmation_number":"SJ12638263172","room_stay_from":"2021-09-23","room_stay_to":"2021-09-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"130951","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-18 13:55:08","reservation_modified_date_time":"2021-09-18 13:55:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130951","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":"5314853","reservation_id":"123254","confirmation_number":"SJ12617435593","room_confirmation_number":"SJ12636831453","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","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":"130966","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-18 17:35:10","reservation_modified_date_time":"2021-09-18 17:35:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130966","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":"5314927","reservation_id":"123264","confirmation_number":"SJ12649231225","room_confirmation_number":"SJ12668641736","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","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":"130977","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-18 20:03:42","reservation_modified_date_time":"2021-09-18 20:03:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130977","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":"5314998","reservation_id":"121558","confirmation_number":"SJ12662167838","room_confirmation_number":"SJ12618450478","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","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":"130927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 12:06:30","reservation_modified_date_time":"2021-09-18 21:08:21","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":"5315121","reservation_id":"120216","confirmation_number":"SJ12697285107","room_confirmation_number":"SJ12658473700","room_stay_from":"2021-09-25","room_stay_to":"2021-10-02","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":"127477","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-27 19:27:10","reservation_modified_date_time":"2021-09-19 14:12:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127477","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":"5315380","reservation_id":"123305","confirmation_number":"SJ12645676964","room_confirmation_number":"SJ12639339153","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","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":"131020","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-19 16:40:13","reservation_modified_date_time":"2021-09-19 16:40:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131020","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":"5315491","reservation_id":"123318","confirmation_number":"SJ12620449769","room_confirmation_number":"SJ12688344303","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","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":"131032","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-19 19:41:08","reservation_modified_date_time":"2021-09-19 19:41:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131032","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":"5315991","reservation_id":"117582","confirmation_number":"SJ12663937491","room_confirmation_number":"SJ12692838958","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124549","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-18 22:30:47","reservation_modified_date_time":"2021-09-20 19:51:32","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":"5316048","reservation_id":"123340","confirmation_number":"SJ12611119457","room_confirmation_number":"SJ12649449201","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"131059","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-20 09:09:12","reservation_modified_date_time":"2021-09-20 23:18:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131059","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":"5316180","reservation_id":"118626","confirmation_number":"SJ12672681959","room_confirmation_number":"SJ12622419940","room_stay_from":"2021-09-24","room_stay_to":"2021-09-29","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":"125704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-03 21:41:30","reservation_modified_date_time":"2021-09-21 13:22:40","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":"5316465","reservation_id":"123445","confirmation_number":"SJ12687740346","room_confirmation_number":"SJ12648642263","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","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":"131175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-21 23:05:06","reservation_modified_date_time":"2021-09-21 23:05:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131175","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":"5317338","reservation_id":"113530","confirmation_number":"SJ12640799654","room_confirmation_number":"SJ12618340664","room_stay_from":"2021-09-23","room_stay_to":"2021-09-26","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":"120124","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 14:51:08","reservation_modified_date_time":"2021-09-23 22:23:21","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120124","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":"5317424","reservation_id":"123583","confirmation_number":"SJ12615264539","room_confirmation_number":"SJ12672467442","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","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":"131318","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-24 12:35:10","reservation_modified_date_time":"2021-09-24 12:35:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131318","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":"5317602","reservation_id":"123605","confirmation_number":"SJ12696021685","room_confirmation_number":"SJ12650412289","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","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":"131337","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-24 18:54:08","reservation_modified_date_time":"2021-09-24 18:54:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131337","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":"5317609","reservation_id":"123257","confirmation_number":"SJ12617313933","room_confirmation_number":"SJ12686817641","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"130970","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-18 18:25:09","reservation_modified_date_time":"2021-09-24 19:06:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130970","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":"5317624","reservation_id":"123440","confirmation_number":"SJ12677304537","room_confirmation_number":"SJ12660620688","room_stay_from":"2021-09-24","room_stay_to":"2021-09-27","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":"131171","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-21 22:18:08","reservation_modified_date_time":"2021-09-24 19:40:28","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131171","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":"5317803","reservation_id":"119106","confirmation_number":"SJ12647364902","room_confirmation_number":"SJ12661778281","room_stay_from":"2021-09-24","room_stay_to":"2021-09-30","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126224","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-11 14:27:32","reservation_modified_date_time":"2021-09-25 00:16:50","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126224","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":"5317854","reservation_id":"119277","confirmation_number":"SJ12691062752","room_confirmation_number":"SJ12610151860","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","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":"126407","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-13 22:39:07","reservation_modified_date_time":"2021-09-25 12:44:32","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126407","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":"5317908","reservation_id":"123581","confirmation_number":"SJ12680190592","room_confirmation_number":"SJ12671224866","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"131316","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-24 05:03:08","reservation_modified_date_time":"2021-09-25 13:20:50","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131316","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","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":"5317915","reservation_id":"123639","confirmation_number":"SJ12616958619","room_confirmation_number":"SJ12635575139","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","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":"131379","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-25 13:48:12","reservation_modified_date_time":"2021-09-25 13:48:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131379","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":"5317918","reservation_id":"123639","confirmation_number":"SJ12632604079","room_confirmation_number":"SJ12690453213","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"131379","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-25 13:48:18","reservation_modified_date_time":"2021-09-25 13:48:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131379","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"5318214","reservation_id":"123432","confirmation_number":"SJ12622493401","room_confirmation_number":"SJ12695605090","room_stay_from":"2021-09-24","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"131394","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-21 20:16:13","reservation_modified_date_time":"2021-09-25 18:05:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131394","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5318397","reservation_id":"123652","confirmation_number":"SJ12687749528","room_confirmation_number":"SJ12684512455","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","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":"131393","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-25 17:43:12","reservation_modified_date_time":"2021-09-26 00:42:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131393","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":"5318419","reservation_id":"123008","confirmation_number":"SJ12622581525","room_confirmation_number":"SJ12637070569","room_stay_from":"2021-09-24","room_stay_to":"2021-09-28","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":"129179","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-14 15:09:07","reservation_modified_date_time":"2021-09-26 01:37:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129179","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":"5318424","reservation_id":"123673","confirmation_number":"SJ12617545458","room_confirmation_number":"SJ12640583178","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","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":"131434","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-26 01:45:10","reservation_modified_date_time":"2021-09-26 01:55:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131434","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":"5318427","reservation_id":"123632","confirmation_number":"SJ12663865043","room_confirmation_number":"SJ12683468827","room_stay_from":"2021-09-25","room_stay_to":"2021-09-28","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":"131372","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-25 04:17:08","reservation_modified_date_time":"2021-09-26 02:01:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131372","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":"5318430","reservation_id":"123674","confirmation_number":"SJ12614091762","room_confirmation_number":"SJ12635560409","room_stay_from":"2021-09-25","room_stay_to":"2021-09-26","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":"131435","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-26 02:25:10","reservation_modified_date_time":"2021-09-26 02:25:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131435","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":"5318436","reservation_id":"123676","confirmation_number":"SJ12624098988","room_confirmation_number":"SJ12666615043","room_stay_from":"2021-09-25","room_stay_to":"2021-09-27","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":"131437","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-26 04:25:29","reservation_modified_date_time":"2021-09-26 04:25:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131437","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":"5318048","reservation_id":"123568","confirmation_number":"SJ12644085081","room_confirmation_number":"SJ12689366714","room_stay_from":"2021-11-08","room_stay_to":"2021-11-14","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":"131305","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-23 22:28:41","reservation_modified_date_time":"2021-09-25 14:24:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131305","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}