{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-09","total_rooms_exist":"1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1281,1282,1286,1287,1288,1289,1291,1293,1294,1296,1297,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1318,1319,1711,1756,1866,1913,1915,1916,1917,1918,1919,1920,1921,1922,1923,1942,1943","departureCount":9,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1301,1923,1313,1920,1943,1314,1922,1921,1919,1918,1262,1270","block_room_bookings":[{"confirmation_number":"SJ12699845061","room_stay_from":"2020-01-03","room_stay_to":"2020-01-04","bundle_room":"0"},{"confirmation_number":"SJ12693730510","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12673593636","room_stay_from":"2019-11-09","room_stay_to":"2019-11-20","bundle_room":"0"},{"confirmation_number":"SJ12665324838","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12665140393","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12657221101","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12648030950","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12638549225","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632903645","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12613532835","room_stay_from":"2019-12-18","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1260,1261,1267,1268,1291,1711,1271,1272","bundle_block_bookings":[{"confirmation_number":"SJB12651359310","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","bundle_room":"1"},{"confirmation_number":"SJB12647277414","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","bundle_room":"1"},{"confirmation_number":"SJB12639031428","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","bundle_room":"1"},{"confirmation_number":"SJB12611155243","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3052764","reservation_id":"88947","confirmation_number":"SJ12693498453","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.15,135.15,135.15","nightly_discount":"0,0,0","subtotal":"405.45","grand_total":"456.13","paid_amount":"456.13","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3677562479","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":"95030","customer_id":"95030","source_of_creation":"Booking.com","reservation_created_date":"2019-12-30 00:18:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"85.14","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.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":"3054475","reservation_id":"89363","confirmation_number":"SJ12633293904","room_stay_from":"2020-01-07","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.95,135.95,135.95,236.83","nightly_discount":"0,0,0,0","subtotal":"644.68","grand_total":"725.26","paid_amount":"725.26","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3749023576","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":"95347","customer_id":"95347","source_of_creation":"Booking.com","reservation_created_date":"2020-01-05 00:38:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"135.38","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.95","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":"3053910","reservation_id":"82681","confirmation_number":"SJ12678429053","room_stay_from":"2020-01-05","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.00,256.00,256.00,256.00,256.00,277.00,277.00,256.00,256.00,256.00,256.00,256.00,277.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"3391.00","grand_total":"3814.88","paid_amount":"3814.88","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-3546252125","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":"90250","customer_id":"90250","source_of_creation":"Booking.com","reservation_created_date":"2019-08-15 14:53:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"610.38","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"256.00","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":"3049064","reservation_id":"88513","confirmation_number":"SJ12649029680","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.48,114.48,114.48","nightly_discount":"0,0,0","subtotal":"343.44","grand_total":"386.37","paid_amount":"386.37","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1610716726","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":"94717","customer_id":"94717","source_of_creation":"Expedia","reservation_created_date":"2019-12-21 13:22:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"114.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":"3053209","reservation_id":"88671","confirmation_number":"SJ12652471074","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71","nightly_discount":"0","subtotal":"102.71","grand_total":"115.55","paid_amount":"115.55","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1612224371","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":"94846","customer_id":"94846","source_of_creation":"Expedia","reservation_created_date":"2019-12-25 07:02:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"102.71","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":"3054590","reservation_id":"89426","confirmation_number":"SJ12673953258","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,102.71,102.71","nightly_discount":"0,0,0","subtotal":"308.13","grand_total":"346.65","paid_amount":"346.65","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1617854747","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":"95392","customer_id":"95392","source_of_creation":"Expedia","reservation_created_date":"2020-01-05 22:32:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"102.71","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":"3055152","reservation_id":"89273","confirmation_number":"SJ12647955014","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,102.71","nightly_discount":"0,0","subtotal":"205.42","grand_total":"231.10","paid_amount":"231.10","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1616927621","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":"95289","customer_id":"95289","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 23:17:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"102.71","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":"3056180","reservation_id":"89481","confirmation_number":"SJ12648087730","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"102.71","nightly_discount":"0.00","subtotal":"102.71","grand_total":"115.55","paid_amount":"115.55","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1391779164","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":"95461","customer_id":"95461","source_of_creation":"Expedia","reservation_created_date":"2020-01-07 00:53:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"102.71","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":"3056486","reservation_id":"89625","confirmation_number":"SJ12635995766","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.71,173.77","nightly_discount":"0.00,0.00","subtotal":"276.48","grand_total":"311.04","paid_amount":"311.04","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1392044994","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":"95615","customer_id":"95615","source_of_creation":"Expedia","reservation_created_date":"2020-01-09 12:08:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"102.71","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":"3053274","reservation_id":"89187","confirmation_number":"SJ12691990249","room_stay_from":"2020-01-04","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.39,102.71,102.71,102.71,102.71,102.71,178.94,178.94,102.71,102.71,102.71","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0","subtotal":"1333.95","grand_total":"1500.70","paid_amount":"1500.70","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1616419412","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":"95220","customer_id":"95220","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 01:27:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"102.71","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3050234","reservation_id":"88681","confirmation_number":"SJ12641420568","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"412","product_id":"1294","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":"94172","customer_id":"94172","source_of_creation":"PMS","reservation_created_date":"2019-12-25 16:06:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"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":"3051257","reservation_id":"87891","confirmation_number":"SJ12668081159","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00","nightly_discount":"0.00","subtotal":"199.00","grand_total":"223.88","paid_amount":"223.88","room_type_id":"319","product_id":"1319","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":"75598","customer_id":"75598","source_of_creation":"PMS","reservation_created_date":"2019-12-05 20:15:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"199.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":"3056042","reservation_id":"84273","confirmation_number":"SJ12681427677","room_stay_from":"2020-01-10","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00","subtotal":"357.00","grand_total":"401.63","paid_amount":"401.63","room_type_id":"319","product_id":"1302","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":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-09-17 22:25:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3040208","reservation_id":"82209","confirmation_number":"SJ12641800269","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"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","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-08-07 21:25:33","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","currentDayPrice":"0.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":"3053955","reservation_id":"86396","confirmation_number":"SJ12618645465","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"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","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2019-10-29 01:50:52","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","currentDayPrice":"0.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":"3054387","reservation_id":"88781","confirmation_number":"SJ12636937722","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"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","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74796","customer_id":"74796","source_of_creation":"PMS","reservation_created_date":"2019-12-27 17:21:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.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":"3049672","reservation_id":"87250","confirmation_number":"SJ12674050194","room_stay_from":"2020-01-09","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"476.00","grand_total":"476.00","paid_amount":"476.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":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"91749","customer_id":"91749","source_of_creation":"PMS","reservation_created_date":"2019-11-17 18:05:10","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","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3055624","reservation_id":"89234","confirmation_number":"SJ12698230410","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.14,222.14,222.14,222.14,222.14,222.14,222.14","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1554.98","grand_total":"1554.98","paid_amount":"0.00","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-01-03 17:08:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"222.14","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"}]}],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3049065","reservation_id":"88513","confirmation_number":"SJ12643237409","room_confirmation_number":"SJ12649029680","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"94717","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-21 13:22:08","reservation_modified_date_time":"2019-12-21 13:22:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94717","canceled_nights_data":"","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":"3050235","reservation_id":"88681","confirmation_number":"SJ12693216846","room_confirmation_number":"SJ12641420568","room_stay_from":"2020-01-06","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"94854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-25 16:06:13","reservation_modified_date_time":"2019-12-25 16:06:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94172","canceled_nights_data":"","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":"3051259","reservation_id":"87891","confirmation_number":"SJ12678582590","room_confirmation_number":"SJ12668081159","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"75598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-05 20:15:12","reservation_modified_date_time":"2019-12-05 20:15:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75598","canceled_nights_data":"","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":"3052766","reservation_id":"88947","confirmation_number":"SJ12683115384","room_confirmation_number":"SJ12693498453","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"95030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-30 00:18:12","reservation_modified_date_time":"2019-12-30 00:18:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95030","canceled_nights_data":"","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":"3053210","reservation_id":"88671","confirmation_number":"SJ12665973427","room_confirmation_number":"SJ12652471074","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"94846","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-25 07:02:10","reservation_modified_date_time":"2019-12-25 07:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94846","canceled_nights_data":"","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":"3054591","reservation_id":"89426","confirmation_number":"SJ12636071960","room_confirmation_number":"SJ12673953258","room_stay_from":"2020-01-07","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"95392","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-05 22:32:08","reservation_modified_date_time":"2020-01-05 22:32:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95392","canceled_nights_data":"","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":"3055154","reservation_id":"89273","confirmation_number":"SJ12666867462","room_confirmation_number":"SJ12647955014","room_stay_from":"2020-01-08","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"95289","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-03 23:17:08","reservation_modified_date_time":"2020-01-03 23:17:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95289","canceled_nights_data":"","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":"3056181","reservation_id":"89481","confirmation_number":"SJ12618169770","room_confirmation_number":"SJ12648087730","room_stay_from":"2020-01-09","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"95461","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-07 00:53:09","reservation_modified_date_time":"2020-01-10 13:17:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95461","canceled_nights_data":"","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":"3040209","reservation_id":"82209","confirmation_number":"SJ12661407005","room_confirmation_number":"SJ12641800269","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"89945","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-07 21:25:33","reservation_modified_date_time":"2019-08-07 21:25:33","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","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":"3053956","reservation_id":"86396","confirmation_number":"SJ12692216439","room_confirmation_number":"SJ12618645465","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"93158","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-29 01:50:52","reservation_modified_date_time":"2019-10-29 01:50:52","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","canceled_nights_data":"","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":"3054042","reservation_id":"89234","confirmation_number":"SJ12650543293","room_confirmation_number":"SJ12698230410","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"95259","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-03 17:08:46","reservation_modified_date_time":"2020-01-04 18:55:43","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","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":"3054388","reservation_id":"88781","confirmation_number":"SJ12639105693","room_confirmation_number":"SJ12636937722","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","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":"94934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-27 17:21:37","reservation_modified_date_time":"2019-12-27 17:21:37","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74796","canceled_nights_data":"","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":"3054476","reservation_id":"89363","confirmation_number":"SJ12646876387","room_confirmation_number":"SJ12633293904","room_stay_from":"2020-01-07","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"95347","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-05 00:38:06","reservation_modified_date_time":"2020-01-05 00:38:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95347","canceled_nights_data":"","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":"3056487","reservation_id":"89625","confirmation_number":"SJ12681287556","room_confirmation_number":"SJ12635995766","room_stay_from":"2020-01-09","room_stay_to":"2020-01-11","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":"95615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-09 12:08:10","reservation_modified_date_time":"2020-01-11 00:14:02","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95615","canceled_nights_data":"","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":"3049674","reservation_id":"87250","confirmation_number":"SJ12673735084","room_confirmation_number":"SJ12674050194","room_stay_from":"2020-01-09","room_stay_to":"2020-01-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"93811","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-17 18:05:10","reservation_modified_date_time":"2019-11-17 18:05:10","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"91749","canceled_nights_data":"","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":"3053275","reservation_id":"89187","confirmation_number":"SJ12654474834","room_confirmation_number":"SJ12691990249","room_stay_from":"2020-01-04","room_stay_to":"2020-01-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"275.00","grand_total":"309.38","paid_amount":"309.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"95220","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-03 01:27:05","reservation_modified_date_time":"2020-01-03 01:27:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95220","canceled_nights_data":"","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":"3053911","reservation_id":"82681","confirmation_number":"SJ12667680396","room_confirmation_number":"SJ12678429053","room_stay_from":"2020-01-05","room_stay_to":"2020-01-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"365.63","paid_amount":"365.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"90250","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-15 14:53:11","reservation_modified_date_time":"2019-08-15 14:53:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90250","canceled_nights_data":"","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3055649","reservation_id":"84273","confirmation_number":"SJ12629524166","room_confirmation_number":"SJ12681427677","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-06 20:59:22","reservation_modified_date_time":"2020-01-09 14:03:07","customer_id":"91749","parentCustTravId":"91749","customer_traveller_id":"91753","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"25.00","product_attribute_values":null,"is_tip_product":"0","changedComment":"price, discount or quantity changed","deltaChange":"-25.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}