{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-10-03","total_rooms_exist":44,"departureCount":2,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"9","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3022569","reservation_id":"74615","confirmation_number":"SJ12691667619","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.10","nightly_discount":"0","subtotal":"134.10","grand_total":"150.87","paid_amount":"150.87","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-3028619015","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":"84974","customer_id":"84974","source_of_creation":"Booking.com","reservation_created_date":"2019-04-13 01:43:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"24.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.10","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":"3023083","reservation_id":"84767","confirmation_number":"SJ12615604022","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.20,135.20,0.00","nightly_discount":"0,0,0","subtotal":"246.40","grand_total":"277.20","paid_amount":"277.20","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1350577958","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":"92074","customer_id":"92074","source_of_creation":"Expedia","reservation_created_date":"2019-09-27 06:02:10","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":"","currentDayPrice":"111.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3023728","reservation_id":"84841","confirmation_number":"SJ12614504776","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.20,135.20,0.00","nightly_discount":"0,0,0","subtotal":"246.40","grand_total":"277.20","paid_amount":"277.20","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1351637694","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":"92120","customer_id":"92120","source_of_creation":"Expedia","reservation_created_date":"2019-09-29 01:02:09","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","migrated_id":"","currentDayPrice":"111.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3024469","reservation_id":"84987","confirmation_number":"SJ12688539070","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"111.20,135.20,0.00","nightly_discount":"0,0,0","subtotal":"246.40","grand_total":"277.20","paid_amount":"277.20","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1353706596","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":"92239","customer_id":"92239","source_of_creation":"Expedia","reservation_created_date":"2019-10-02 07:52:10","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","migrated_id":"","currentDayPrice":"111.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3024725","reservation_id":"84524","confirmation_number":"SJ12637869565","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.20,111.20,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"222.40","grand_total":"250.20","paid_amount":"250.20","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1347178510","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":"91904","customer_id":"91904","source_of_creation":"Expedia","reservation_created_date":"2019-09-22 02:42:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.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"}]}],"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":[],"pms_non_taxable":[{"room_stay_id":"3017861","reservation_id":"83841","confirmation_number":"SJ12684821516","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-09-09 18:35:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3017866","reservation_id":"83842","confirmation_number":"SJ12633296996","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"1277","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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-09-09 18:40:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3017868","reservation_id":"83843","confirmation_number":"SJ12635062081","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"1278","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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-09-09 18:45:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3022584","reservation_id":"83840","confirmation_number":"SJ12610426084","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-09-09 18:31:36","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":"","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":"3023819","reservation_id":"78866","confirmation_number":"SJ12651507273","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","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","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","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-06-17 20:42:03","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","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[{"room_stay_id":"3024697","reservation_id":"73567","confirmation_number":"SJ12666288148","room_stay_from":"2019-10-02","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"370.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"370.00","grand_total":"416.25","paid_amount":"416.25","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-29 19:28:08","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":"","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":"3025360","reservation_id":"74363","confirmation_number":"SJ12660626619","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"515.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":"515.00","grand_total":"579.38","paid_amount":"579.38","room_type_id":"319","product_id":"1303","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-04-09 15:58:55","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3025987","reservation_id":"73568","confirmation_number":"SJ12627641871","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"370.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"370.00","grand_total":"416.25","paid_amount":"416.25","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-29 19:31:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"370.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":"3042768","reservation_id":"73441","confirmation_number":"SJ12635166177","room_stay_from":"2019-10-02","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"220.00,230.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"450.00","grand_total":"506.25","paid_amount":"506.25","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-28 17:57:53","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":"","currentDayPrice":"230.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":"2950903","reservation_id":"72183","confirmation_number":"SJ12616965184","room_stay_from":"2019-10-04","room_stay_to":"2019-10-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"540.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":"540.00","grand_total":"607.50","paid_amount":"0.00","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-16 18:53:23","service_canceled_date_time":"2019-10-03 04:11:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":0,"changedComment":"reservation is canceled but amt paid","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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3023080","reservation_id":"73863","confirmation_number":"SJ12615231804","room_stay_from":"2019-09-27","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.00","room_type_id":"413","product_id":"1269","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":"2019-04-02 17:05:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.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":"3023369","reservation_id":"73935","confirmation_number":"SJ12654948258","room_stay_from":"2019-09-27","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.00","room_type_id":"412","product_id":"1316","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":"2019-04-03 15:50:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.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":"3023499","reservation_id":"72636","confirmation_number":"SJ12630110652","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.00","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-21 00:52:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3023691","reservation_id":"72179","confirmation_number":"SJ12641035401","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.00","room_type_id":"319","product_id":"1288","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":"2019-03-16 18:46:19","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":"","currentDayPrice":"73.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3024245","reservation_id":"73566","confirmation_number":"SJ12662544946","room_stay_from":"2019-10-01","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.00,74.00,74.00,74.00,74","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"370.00","grand_total":"370.00","paid_amount":"370.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":"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":"2019-03-29 19:26:35","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":"","currentDayPrice":"74.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":"3024740","reservation_id":"73563","confirmation_number":"SJ12645776133","room_stay_from":"2019-09-28","room_stay_to":"2019-10-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.00,74.00,74.00,74.00,74","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"370.00","grand_total":"370.00","paid_amount":"370.00","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-29 19:19:03","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":0,"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":"3024854","reservation_id":"72181","confirmation_number":"SJ12659295188","room_stay_from":"2019-09-28","room_stay_to":"2019-10-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"515.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"579.38","paid_amount":"579.38","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-16 18:51:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":0,"currentDayPrice":0,"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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3017862","reservation_id":"83841","confirmation_number":"SJ12685701712","room_confirmation_number":"SJ12684821516","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"91173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-09 18:35:28","reservation_modified_date_time":"2019-09-09 18:35:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3017867","reservation_id":"83842","confirmation_number":"SJ12698297296","room_confirmation_number":"SJ12633296996","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"91174","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-09 18:40:41","reservation_modified_date_time":"2019-09-09 18:40:41","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3017869","reservation_id":"83843","confirmation_number":"SJ12654100921","room_confirmation_number":"SJ12635062081","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"91175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-09 18:45:50","reservation_modified_date_time":"2019-09-09 18:45:50","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3022570","reservation_id":"74615","confirmation_number":"SJ12631918930","room_confirmation_number":"SJ12691667619","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","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":"84974","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-13 01:43:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84974","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":"3022585","reservation_id":"83840","confirmation_number":"SJ12680359949","room_confirmation_number":"SJ12610426084","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"91172","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-09 18:31:36","reservation_modified_date_time":"2019-09-09 18:31:36","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3023082","reservation_id":"73863","confirmation_number":"SJ12643555285","room_confirmation_number":"SJ12615231804","room_stay_from":"2019-09-27","room_stay_to":"2019-10-04","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":"84495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-02 17:05:28","reservation_modified_date_time":"2019-09-27 04:41:27","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":"3023084","reservation_id":"84767","confirmation_number":"SJ12613176920","room_confirmation_number":"SJ12615604022","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","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":"92074","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-27 06:02:10","reservation_modified_date_time":"2019-09-27 06:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92074","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":"3023370","reservation_id":"73935","confirmation_number":"SJ12699779029","room_confirmation_number":"SJ12654948258","room_stay_from":"2019-09-27","room_stay_to":"2019-10-04","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":"84543","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-03 15:50:05","reservation_modified_date_time":"2019-09-27 18:32:28","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":"3023500","reservation_id":"72636","confirmation_number":"SJ12651950442","room_confirmation_number":"SJ12630110652","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"83729","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 00:52:09","reservation_modified_date_time":"2019-09-28 04:54:59","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":"3023692","reservation_id":"72179","confirmation_number":"SJ12674674791","room_confirmation_number":"SJ12641035401","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"83402","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-16 18:46:19","reservation_modified_date_time":"2019-09-28 04:56:16","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":"3023729","reservation_id":"84841","confirmation_number":"SJ12695964759","room_confirmation_number":"SJ12614504776","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","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":"92120","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-29 01:02:09","reservation_modified_date_time":"2019-09-29 01:02:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92120","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":"3023821","reservation_id":"78866","confirmation_number":"SJ12671194530","room_confirmation_number":"SJ12651507273","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","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":"87803","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-06-17 20:42:03","reservation_modified_date_time":"0000-00-00 00:00:00","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":"3024247","reservation_id":"73566","confirmation_number":"SJ12613440942","room_confirmation_number":"SJ12662544946","room_stay_from":"2019-10-01","room_stay_to":"2019-10-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"84268","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-29 19:26:35","reservation_modified_date_time":"2019-10-01 13:19:10","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":"3024470","reservation_id":"84987","confirmation_number":"SJ12622731493","room_confirmation_number":"SJ12688539070","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","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":"92239","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-02 07:52:10","reservation_modified_date_time":"2019-10-02 07:52:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92239","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":"3024701","reservation_id":"73567","confirmation_number":"SJ12624815333","room_confirmation_number":"SJ12666288148","room_stay_from":"2019-10-02","room_stay_to":"2019-10-07","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":"94.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"84268","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-29 19:28:08","reservation_modified_date_time":"2019-10-02 23:08:54","collect_which":"","tax_exempt_status":"0","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":"3024726","reservation_id":"84524","confirmation_number":"SJ12637871992","room_confirmation_number":"SJ12637869565","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","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":"91904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-22 02:42:06","reservation_modified_date_time":"2019-10-03 01:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91904","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":"3025362","reservation_id":"74363","confirmation_number":"SJ12637477515","room_confirmation_number":"SJ12660626619","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","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":"132.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"84814","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-09 15:58:55","reservation_modified_date_time":"2019-10-05 14:00:51","collect_which":"","tax_exempt_status":"0","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":"3025989","reservation_id":"73568","confirmation_number":"SJ12698567092","room_confirmation_number":"SJ12627641871","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","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":"94.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"84348","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-29 19:31:08","reservation_modified_date_time":"2019-10-03 16:41:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3042770","reservation_id":"73441","confirmation_number":"SJ12656539361","room_confirmation_number":"SJ12635166177","room_stay_from":"2019-10-02","room_stay_to":"2019-10-07","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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"84268","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-28 17:57:53","reservation_modified_date_time":"2019-11-29 23:22:50","collect_which":"","tax_exempt_status":"0","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3024850","reservation_id":"72181","confirmation_number":"SJ12692462088","room_confirmation_number":"SJ12659295188","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":"56.26","paid_amount":"56.26","product_id":"1869","service_quantity":"2","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 12:41:34","reservation_modified_date_time":"2019-10-03 12:41:34","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"83403","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"50.00","currentDayDiscount":"0.00","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":[{"room_stay_id":"3025043","reservation_id":"85086","confirmation_number":"SJ12672981220","room_confirmation_number":"SJ12681981533","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Jeff Hayward","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-04 00:32:10","reservation_modified_date_time":"2019-10-04 00:32:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[{"room_stay_id":"3024980","reservation_id":"85067","confirmation_number":"SJ12672684096","room_confirmation_number":"SJ12694258734","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"14.00","paid_amount":"14.00","product_id":null,"service_quantity":"2","product_name":"Bloody Mary","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 19:33:13","reservation_modified_date_time":"2019-10-03 19:33:13","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"12.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3024986","reservation_id":"85070","confirmation_number":"SJ12651910768","room_confirmation_number":"SJ12695658254","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Bloody Mary","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 19:53:45","reservation_modified_date_time":"2019-10-03 19:53:45","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3024990","reservation_id":"85072","confirmation_number":"SJ12683422543","room_confirmation_number":"SJ12650393954","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Bloody Mary","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 20:28:44","reservation_modified_date_time":"2019-10-03 20:28:44","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3024995","reservation_id":"85073","confirmation_number":"SJ12632390783","room_confirmation_number":"SJ12655544775","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Titos","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 20:47:02","reservation_modified_date_time":"2019-10-03 20:47:02","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3024996","reservation_id":"85073","confirmation_number":"SJ12619558126","room_confirmation_number":"SJ12655544775","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Islamorada Ale Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 20:47:02","reservation_modified_date_time":"2019-10-03 20:47:02","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3024998","reservation_id":"85074","confirmation_number":"SJ12686294367","room_confirmation_number":"SJ12619589761","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.34","grand_total":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"1","product_name":"Pina Colada","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 20:47:44","reservation_modified_date_time":"2019-10-03 20:47:44","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3025007","reservation_id":"85078","confirmation_number":"SJ12629616876","room_confirmation_number":"SJ12692656354","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Titos","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 21:26:05","reservation_modified_date_time":"2019-10-03 21:26:05","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3025041","reservation_id":"85085","confirmation_number":"SJ12638789145","room_confirmation_number":"SJ12628583090","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"5","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-04 00:07:18","reservation_modified_date_time":"2019-10-04 00:07:18","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"13.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3025044","reservation_id":"85086","confirmation_number":"SJ12691872535","room_confirmation_number":"SJ12681981533","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-04 00:32:10","reservation_modified_date_time":"2019-10-04 00:32:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3025045","reservation_id":"85086","confirmation_number":"SJ12658032236","room_confirmation_number":"SJ12681981533","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"14.00","paid_amount":"14.00","product_id":null,"service_quantity":"2","product_name":"Titos","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-04 00:32:10","reservation_modified_date_time":"2019-10-04 00:32:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"12.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3025047","reservation_id":"85087","confirmation_number":"SJ12623889502","room_confirmation_number":"SJ12644673897","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.71","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"4","product_name":"Corona","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-04 00:33:01","reservation_modified_date_time":"2019-10-04 00:33:01","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"14.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"bar_non_taxable":[],"restaurant_taxable":[{"room_stay_id":"3025057","reservation_id":"85090","confirmation_number":"SJ12657427915","room_confirmation_number":"SJ12670080722","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-04 01:36:18","reservation_modified_date_time":"2019-10-04 01:36:18","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}