{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-08-02","total_rooms_exist":44,"departureCount":5,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"9","block_room_bookings":[],"bundle_block_count":"4","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3005227","reservation_id":"80197","confirmation_number":"SJ12620541702","room_stay_from":"2019-08-01","room_stay_to":"2019-08-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"234.00,249.00,249.00,224.00","nightly_discount":"0,0,0,0","subtotal":"956.00","grand_total":"1075.50","paid_amount":"1075.50","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-2287724161","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":"89678","customer_id":"89678","source_of_creation":"Booking.com","reservation_created_date":"2019-07-04 22:59:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"172.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"249.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":"3004512","reservation_id":"81658","confirmation_number":"SJ12650134367","room_stay_from":"2019-08-01","room_stay_to":"2019-08-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"119.20,179.20,179.20","nightly_discount":"0,0,0","subtotal":"477.60","grand_total":"537.30","paid_amount":"537.30","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1310588870","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":"89531","customer_id":"89531","source_of_creation":"Expedia","reservation_created_date":"2019-07-29 16:47:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"104.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3004630","reservation_id":"81660","confirmation_number":"SJ12629408313","room_stay_from":"2019-08-01","room_stay_to":"2019-08-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"113.24,170.24,170.24","nightly_discount":"0,0,0","subtotal":"453.72","grand_total":"510.44","paid_amount":"510.44","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1310592772","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":"89533","customer_id":"89533","source_of_creation":"Expedia","reservation_created_date":"2019-07-29 16:57:10","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":"170.24","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":"3004971","reservation_id":"81719","confirmation_number":"SJ12689065546","room_stay_from":"2019-08-02","room_stay_to":"2019-08-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20","nightly_discount":"0","subtotal":"187.20","grand_total":"210.60","paid_amount":"210.60","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1311504559","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":"89588","customer_id":"89588","source_of_creation":"Expedia","reservation_created_date":"2019-07-30 20:32:09","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","migrated_id":"","currentDayPrice":"187.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":"3005949","reservation_id":"81879","confirmation_number":"SJ12662138889","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.64,177.84","nightly_discount":"0,0","subtotal":"321.48","grand_total":"361.66","paid_amount":"361.66","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1313530079","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":"89710","customer_id":"89710","source_of_creation":"Expedia","reservation_created_date":"2019-08-02 14:12:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.64","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3006031","reservation_id":"81221","confirmation_number":"SJ12644505977","room_stay_from":"2019-08-02","room_stay_to":"2019-08-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.20,171.20,151.20","nightly_discount":"0,0,0","subtotal":"493.60","grand_total":"555.30","paid_amount":"555.30","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1305791611","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":"89245","customer_id":"89245","source_of_creation":"Expedia","reservation_created_date":"2019-07-22 21:00:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"171.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"}]}],"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":[{"room_stay_id":"3005563","reservation_id":"81788","confirmation_number":"SJ12655622973","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"225.48,225.48","nightly_discount":"0,0","subtotal":"450.96","grand_total":"606.42","paid_amount":"606.42","room_type_id":"319","product_id":"1305","siteminder_id":"ABB-HMADKZN4CY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"450.96","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89645","customer_id":"89645","source_of_creation":"Airbnb","reservation_created_date":"2019-07-31 23:54:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"73.27","commision_charges":"17.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.48","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3007549","reservation_id":"81817","confirmation_number":"SJ12667594194","room_stay_from":"2019-08-01","room_stay_to":"2019-08-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"236.68,236.68,236.68,236.68","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"946.72","grand_total":"1222.44","paid_amount":"1106.56","room_type_id":"319","product_id":"1309","siteminder_id":"ABB-HMAQKE4DZE","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"946.72","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89662","customer_id":"89662","source_of_creation":"Airbnb","reservation_created_date":"2019-08-01 14:49:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"125.9","commision_charges":"29.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"236.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2938624","reservation_id":"70021","confirmation_number":"SJ12663891924","room_stay_from":"2019-07-31","room_stay_to":"2019-08-03","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"386.00,398.00,428.00","nightly_discount":"0.00,0.00,0.00","subtotal":"1212.00","grand_total":"1363.50","paid_amount":"1363.50","room_type_id":"320","product_id":"1320","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":"82191","customer_id":"82191","source_of_creation":"FE","reservation_created_date":"2019-02-22 02:31:40","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"428.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":"3005404","reservation_id":"81735","confirmation_number":"SJ12656561318","room_stay_from":"2019-08-01","room_stay_to":"2019-08-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,214.00,214.00","nightly_discount":"0.00,0.00,0.00","subtotal":"577.00","grand_total":"649.13","paid_amount":"649.13","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89604","customer_id":"89604","source_of_creation":"FE","reservation_created_date":"2019-07-31 03:12:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"214.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3005220","reservation_id":"80485","confirmation_number":"SJ12648077020","room_stay_from":"2019-08-01","room_stay_to":"2019-08-04","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"378.00,408.00,408.00","nightly_discount":"0.00,0.00,0.00","subtotal":"1194.00","grand_total":"1343.25","paid_amount":"1343.25","room_type_id":"320","product_id":"1330","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88764","customer_id":"88764","source_of_creation":"PMS","reservation_created_date":"2019-07-10 17:00:31","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"408.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"}]}],"pms_non_taxable":[{"room_stay_id":"3001892","reservation_id":"81217","confirmation_number":"SJ12650332213","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-07-22 18:44:39","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":"3003245","reservation_id":"76135","confirmation_number":"SJ12633458591","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"1274","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-05-09 23:35:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3004265","reservation_id":"81215","confirmation_number":"SJ12671912081","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"1312","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-07-22 18:34:57","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":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3004268","reservation_id":"81216","confirmation_number":"SJ12695976056","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"1311","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":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-07-22 18:40:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"negotiated_taxable":[{"room_stay_id":"3003587","reservation_id":"72160","confirmation_number":"SJ12644598124","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"565.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":"565.00","grand_total":"635.63","paid_amount":"635.63","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 17:30:04","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","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":"3005417","reservation_id":"73552","confirmation_number":"SJ12643113531","room_stay_from":"2019-08-01","room_stay_to":"2019-08-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"405.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"405.00","grand_total":"455.63","paid_amount":"455.63","room_type_id":"319","product_id":"1301","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 18:12:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","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":"3006752","reservation_id":"73551","confirmation_number":"SJ12649595979","room_stay_from":"2019-07-30","room_stay_to":"2019-08-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"405.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"405.00","grand_total":"455.63","paid_amount":"455.63","room_type_id":"319","product_id":"1306","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 18:07:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3004044","reservation_id":"72944","confirmation_number":"SJ12611830713","room_stay_from":"2019-07-28","room_stay_to":"2019-08-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.71,80.71,80.71,80.71,80.71,80.71,80.74","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"565.00","grand_total":"565.00","paid_amount":"565.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-23 18:16:53","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":"80.71","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":"3004416","reservation_id":"73858","confirmation_number":"SJ12621518715","room_stay_from":"2019-07-29","room_stay_to":"2019-08-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.00,81.00,81.00,81.00,81","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"405.00","grand_total":"405.00","paid_amount":"405.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":"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 16:55:26","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":"81","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":"3005402","reservation_id":"73861","confirmation_number":"SJ12694867842","room_stay_from":"2019-08-01","room_stay_to":"2019-08-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.00,81.00,81.00,81.00,81","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"405.00","grand_total":"405.00","paid_amount":"405.00","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-04-02 17:01:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"81.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":"3005878","reservation_id":"80884","confirmation_number":"SJ12628619715","room_stay_from":"2019-08-02","room_stay_to":"2019-08-09","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":"0.00","room_type_id":"319","product_id":"1313","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-07-17 20:53:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","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":"3005882","reservation_id":"73945","confirmation_number":"SJ12685671497","room_stay_from":"2019-08-02","room_stay_to":"2019-08-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.33,73.33,73.34","nightly_discount":"0.00,0.00,0.00","subtotal":"220.00","grand_total":"220.00","paid_amount":"220.00","room_type_id":"319","product_id":"1291","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 17:53:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.33","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":"3005899","reservation_id":"73437","confirmation_number":"SJ12653289676","room_stay_from":"2019-08-02","room_stay_to":"2019-08-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.33,73.33,73.34","nightly_discount":"0.00,0.00,0.00","subtotal":"220.00","grand_total":"220.00","paid_amount":"220.00","room_type_id":"413","product_id":"1273","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-28 17:34:33","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","migrated_id":"","currentDayPrice":"73.33","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":"3005903","reservation_id":"72945","confirmation_number":"SJ12697741736","room_stay_from":"2019-08-02","room_stay_to":"2019-08-09","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":"1266","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-23 18:20:25","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":"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":"3022992","reservation_id":"73869","confirmation_number":"SJ12668127316","room_stay_from":"2019-08-02","room_stay_to":"2019-08-07","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":"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":"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:17: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":"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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3004999","reservation_id":"73551","confirmation_number":"SJ12688119867","room_confirmation_number":"SJ12649595979","room_stay_from":"2019-07-30","room_stay_to":"2019-08-04","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"82465","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-07-30 21:29:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","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":"3005564","reservation_id":"81788","confirmation_number":"SJ12620703509","room_confirmation_number":"SJ12655622973","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"105.00","paid_amount":"105.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"89645","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-08-01 17:14:31","reservation_modified_date_time":"2019-08-01 17:14:31","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89645","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2938625","reservation_id":"70021","confirmation_number":"SJ12611627763","room_confirmation_number":"SJ12663891924","room_stay_from":"2019-07-31","room_stay_to":"2019-08-03","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":"82191","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-22 02:31:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82191","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":"3001893","reservation_id":"81217","confirmation_number":"SJ12629691250","room_confirmation_number":"SJ12650332213","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"89242","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-22 18:44:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","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":"3003246","reservation_id":"76135","confirmation_number":"SJ12616009622","room_confirmation_number":"SJ12633458591","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"85831","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-05-09 23:35:30","reservation_modified_date_time":"0000-00-00 00:00:00","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":"3003589","reservation_id":"72160","confirmation_number":"SJ12658926559","room_confirmation_number":"SJ12644598124","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"126.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"83385","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-16 17:30:04","reservation_modified_date_time":"0000-00-00 00:00:00","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":"3004045","reservation_id":"72944","confirmation_number":"SJ12618974939","room_confirmation_number":"SJ12611830713","room_stay_from":"2019-07-28","room_stay_to":"2019-08-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":"83944","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-23 18:16:53","reservation_modified_date_time":"0000-00-00 00:00:00","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":"3004267","reservation_id":"81215","confirmation_number":"SJ12651198328","room_confirmation_number":"SJ12671912081","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"89241","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-22 18:34:57","reservation_modified_date_time":"0000-00-00 00:00:00","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":"3004269","reservation_id":"81216","confirmation_number":"SJ12621822310","room_confirmation_number":"SJ12695976056","room_stay_from":"2019-07-27","room_stay_to":"2019-08-03","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":"89241","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-22 18:40:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","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":"3004417","reservation_id":"73858","confirmation_number":"SJ12627345921","room_confirmation_number":"SJ12621518715","room_stay_from":"2019-07-29","room_stay_to":"2019-08-03","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":"84489","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-02 16:55:26","reservation_modified_date_time":"0000-00-00 00:00:00","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":"3004513","reservation_id":"81658","confirmation_number":"SJ12670748404","room_confirmation_number":"SJ12650134367","room_stay_from":"2019-08-01","room_stay_to":"2019-08-04","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":"89531","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-29 16:47:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89531","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":"3004631","reservation_id":"81660","confirmation_number":"SJ12637520774","room_confirmation_number":"SJ12629408313","room_stay_from":"2019-08-01","room_stay_to":"2019-08-04","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":"89533","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-29 16:57:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89533","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":"3004972","reservation_id":"81719","confirmation_number":"SJ12698967888","room_confirmation_number":"SJ12689065546","room_stay_from":"2019-08-02","room_stay_to":"2019-08-03","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":"89588","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-30 20:32:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89588","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":"3005224","reservation_id":"80485","confirmation_number":"SJ12637644244","room_confirmation_number":"SJ12648077020","room_stay_from":"2019-08-01","room_stay_to":"2019-08-04","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":"88764","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-10 17:00:31","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88764","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":"3005228","reservation_id":"80197","confirmation_number":"SJ12693212034","room_confirmation_number":"SJ12620541702","room_stay_from":"2019-08-01","room_stay_to":"2019-08-05","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":"89678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-04 22:59: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":"89678","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":"3005403","reservation_id":"73861","confirmation_number":"SJ12649740091","room_confirmation_number":"SJ12694867842","room_stay_from":"2019-08-01","room_stay_to":"2019-08-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":"84494","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-02 17:01:33","reservation_modified_date_time":"2019-08-01 09:09:35","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":"3005405","reservation_id":"81735","confirmation_number":"SJ12638446896","room_confirmation_number":"SJ12656561318","room_stay_from":"2019-08-01","room_stay_to":"2019-08-04","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":"89604","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-31 03:12:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89604","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":"3005418","reservation_id":"73552","confirmation_number":"SJ12645131977","room_confirmation_number":"SJ12643113531","room_stay_from":"2019-08-01","room_stay_to":"2019-08-05","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":"90.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"84337","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-29 18:12:22","reservation_modified_date_time":"2019-08-01 09:10:08","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":"3005565","reservation_id":"81788","confirmation_number":"SJ12619749072","room_confirmation_number":"SJ12655622973","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","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":"89645","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-31 23:54:09","reservation_modified_date_time":"2019-07-31 23:54:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89645","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3005879","reservation_id":"80884","confirmation_number":"SJ12666346499","room_confirmation_number":"SJ12628619715","room_stay_from":"2019-08-02","room_stay_to":"2019-08-09","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":"89047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-17 20:53:10","reservation_modified_date_time":"2019-08-02 08:40:54","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":"3005883","reservation_id":"73945","confirmation_number":"SJ12679012971","room_confirmation_number":"SJ12685671497","room_stay_from":"2019-08-02","room_stay_to":"2019-08-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":"84552","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-03 17:53:07","reservation_modified_date_time":"2019-08-02 08: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":"3005900","reservation_id":"73437","confirmation_number":"SJ12666724961","room_confirmation_number":"SJ12653289676","room_stay_from":"2019-08-02","room_stay_to":"2019-08-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":"84266","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-28 17:34:33","reservation_modified_date_time":"2019-08-02 08:43:45","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":"3005904","reservation_id":"72945","confirmation_number":"SJ12693118923","room_confirmation_number":"SJ12697741736","room_stay_from":"2019-08-02","room_stay_to":"2019-08-09","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":"83386","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-23 18:20:25","reservation_modified_date_time":"2019-08-02 08:44:14","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":"3005950","reservation_id":"81879","confirmation_number":"SJ12620108158","room_confirmation_number":"SJ12662138889","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","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":"89710","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-02 14:12:07","reservation_modified_date_time":"2019-08-02 14:12:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89710","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":"3006032","reservation_id":"81221","confirmation_number":"SJ12636109355","room_confirmation_number":"SJ12644505977","room_stay_from":"2019-08-02","room_stay_to":"2019-08-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":"89245","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-22 21:00:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89245","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":"3006753","reservation_id":"73551","confirmation_number":"SJ12698554167","room_confirmation_number":"SJ12649595979","room_stay_from":"2019-07-30","room_stay_to":"2019-08-04","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":"90.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"84335","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-29 18:07:54","reservation_modified_date_time":"2019-08-04 14:41:55","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":"3007550","reservation_id":"81817","confirmation_number":"SJ12699358440","room_confirmation_number":"SJ12667594194","room_stay_from":"2019-08-01","room_stay_to":"2019-08-05","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"89662","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-01 14:49:07","reservation_modified_date_time":"2019-08-05 21:59:58","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89662","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3022994","reservation_id":"73869","confirmation_number":"SJ12658779248","room_confirmation_number":"SJ12668127316","room_stay_from":"2019-08-02","room_stay_to":"2019-08-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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"84501","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-02 17:17:08","reservation_modified_date_time":"2019-09-27 01:59:14","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3005965","reservation_id":"72622","confirmation_number":"SJ12688228928","room_confirmation_number":"SJ12619534879","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"53.75","paid_amount":"53.75","product_id":"1704","service_quantity":"1","product_name":"Pet Penalty","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 14:40:11","reservation_modified_date_time":"2019-08-02 14:40:24","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"83718","static_pos_type":"petfee","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"}]},{"room_stay_id":"3006097","reservation_id":"81901","confirmation_number":"SJ12647070026","room_confirmation_number":"SJ12632933556","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":"28.13","paid_amount":"28.13","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 20:05:47","reservation_modified_date_time":"2019-08-02 20:05:47","customer_id":"89727","parentCustTravId":"89727","customer_traveller_id":"89727","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":"25.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"}]},{"room_stay_id":"3006223","reservation_id":"81922","confirmation_number":"SJ12638625013","room_confirmation_number":"SJ12619882366","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.65","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Fish Special","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:55:08","reservation_modified_date_time":"2019-08-03 01:55:08","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":"4.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3006144","reservation_id":"81904","confirmation_number":"SJ12688935691","room_confirmation_number":"SJ12690174524","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.00","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Jeff Hayward","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 21:59:55","reservation_modified_date_time":"2019-08-02 21:59:55","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":"4.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3006183","reservation_id":"81919","confirmation_number":"SJ12641214587","room_confirmation_number":"SJ12619365684","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-08-03 00:56:45","reservation_modified_date_time":"2019-08-03 00:56:45","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":[]},{"room_stay_id":"3006197","reservation_id":"81920","confirmation_number":"SJ12689315208","room_confirmation_number":"SJ12678305387","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"30.00","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Jeff Hayward","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:26:39","reservation_modified_date_time":"2019-08-03 01:26:39","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":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3006220","reservation_id":"81922","confirmation_number":"SJ12615413088","room_confirmation_number":"SJ12619882366","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-08-03 01:55:08","reservation_modified_date_time":"2019-08-03 01:55:08","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":[]},{"room_stay_id":"3006228","reservation_id":"81923","confirmation_number":"SJ12634946704","room_confirmation_number":"SJ12612735495","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.00","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Jeff Hayward","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 02:41:12","reservation_modified_date_time":"2019-08-03 02:41:12","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":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3006236","reservation_id":"81926","confirmation_number":"SJ12624442426","room_confirmation_number":"SJ12661221671","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-08-03 02:56:49","reservation_modified_date_time":"2019-08-03 02:56:49","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":"3006145","reservation_id":"81904","confirmation_number":"SJ12631188994","room_confirmation_number":"SJ12690174524","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":"18.00","paid_amount":"18.00","product_id":null,"service_quantity":"2","product_name":"Rum Runner","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 21:59:55","reservation_modified_date_time":"2019-08-02 21:59:55","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":"16.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006147","reservation_id":"81905","confirmation_number":"SJ12627356018","room_confirmation_number":"SJ12611404682","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":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 22:38:53","reservation_modified_date_time":"2019-08-02 22:38:53","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":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006153","reservation_id":"81907","confirmation_number":"SJ12615628907","room_confirmation_number":"SJ12670638429","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":"2","product_name":"Titos","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:17:21","reservation_modified_date_time":"2019-08-02 23:17:21","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":"6.48","product_attribute_values":null,"currentDayPrice":"12.96","currentDayDiscount":"6.48","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006158","reservation_id":"81908","confirmation_number":"SJ12631723397","room_confirmation_number":"SJ12680941537","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":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"Wine","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:22:05","reservation_modified_date_time":"2019-08-02 23:22:05","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"wine","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006159","reservation_id":"81908","confirmation_number":"SJ12683371787","room_confirmation_number":"SJ12680941537","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":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"Sandbar Sunday Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:22:05","reservation_modified_date_time":"2019-08-02 23:22:05","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":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006165","reservation_id":"81910","confirmation_number":"SJ12615361497","room_confirmation_number":"SJ12662496786","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Virgin Daiquiri","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:44:25","reservation_modified_date_time":"2019-08-02 23:44:25","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":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006167","reservation_id":"81911","confirmation_number":"SJ12619882470","room_confirmation_number":"SJ12668001832","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-08-02 23:51:18","reservation_modified_date_time":"2019-08-02 23:51:18","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":"3006169","reservation_id":"81912","confirmation_number":"SJ12637096584","room_confirmation_number":"SJ12613540150","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"$1 Upcharge","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:52:47","reservation_modified_date_time":"2019-08-02 23:52:47","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":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006171","reservation_id":"81913","confirmation_number":"SJ12625971615","room_confirmation_number":"SJ12662220559","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-08-02 23:58:49","reservation_modified_date_time":"2019-08-02 23:58:49","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":"3006175","reservation_id":"81915","confirmation_number":"SJ12663739223","room_confirmation_number":"SJ12673474323","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"2","product_name":"Virgin Daiquiri","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 00:12:09","reservation_modified_date_time":"2019-08-03 00:12:09","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":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006177","reservation_id":"81916","confirmation_number":"SJ12681954504","room_confirmation_number":"SJ12691982025","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":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"Michelob Ultra","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 00:23:11","reservation_modified_date_time":"2019-08-03 00:23:11","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":"7.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006184","reservation_id":"81919","confirmation_number":"SJ12662513510","room_confirmation_number":"SJ12619365684","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":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"House Tequila","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 00:56:45","reservation_modified_date_time":"2019-08-03 00:56: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":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006185","reservation_id":"81919","confirmation_number":"SJ12693441831","room_confirmation_number":"SJ12619365684","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"$1 Upcharge","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 00:56:45","reservation_modified_date_time":"2019-08-03 00:56:45","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":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006186","reservation_id":"81919","confirmation_number":"SJ12640484632","room_confirmation_number":"SJ12619365684","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-08-03 00:56:45","reservation_modified_date_time":"2019-08-03 00:56:45","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":"3006198","reservation_id":"81920","confirmation_number":"SJ12647913148","room_confirmation_number":"SJ12678305387","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":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"House Tequila","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:26:39","reservation_modified_date_time":"2019-08-03 01:26:39","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":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006222","reservation_id":"81922","confirmation_number":"SJ12659730217","room_confirmation_number":"SJ12619882366","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":"House Gin","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:55:08","reservation_modified_date_time":"2019-08-03 01:55:08","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":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006224","reservation_id":"81922","confirmation_number":"SJ12682898800","room_confirmation_number":"SJ12619882366","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"4","product_name":"$1 Upcharge","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:55:08","reservation_modified_date_time":"2019-08-03 01:55:08","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":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006225","reservation_id":"81922","confirmation_number":"SJ12693348768","room_confirmation_number":"SJ12619882366","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":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:55:08","reservation_modified_date_time":"2019-08-03 01:55:08","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":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006229","reservation_id":"81923","confirmation_number":"SJ12668070175","room_confirmation_number":"SJ12612735495","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":"18.00","paid_amount":"18.00","product_id":null,"service_quantity":"2","product_name":"Pina Colada","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 02:41:12","reservation_modified_date_time":"2019-08-03 02:41:12","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":"16.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006230","reservation_id":"81923","confirmation_number":"SJ12620643095","room_confirmation_number":"SJ12612735495","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.85","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Floater","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 02:41:12","reservation_modified_date_time":"2019-08-03 02:41:12","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":"1.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006237","reservation_id":"81926","confirmation_number":"SJ12659615221","room_confirmation_number":"SJ12661221671","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"2","product_name":"House Pinot Grigio","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 02:56:49","reservation_modified_date_time":"2019-08-03 02:56:49","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"wine","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006240","reservation_id":"81927","confirmation_number":"SJ12617855043","room_confirmation_number":"SJ12667149187","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-08-03 03:09:44","reservation_modified_date_time":"2019-08-03 03:09: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":"3006241","reservation_id":"81927","confirmation_number":"SJ12671517649","room_confirmation_number":"SJ12667149187","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"$1 Upcharge","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 03:09:44","reservation_modified_date_time":"2019-08-03 03:09: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":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3006242","reservation_id":"81927","confirmation_number":"SJ12630408513","room_confirmation_number":"SJ12667149187","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":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 03:09:44","reservation_modified_date_time":"2019-08-03 03:09: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":"4.63","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":"3005909","reservation_id":"81870","confirmation_number":"SJ12676795437","room_confirmation_number":"SJ12656205574","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-08-02 10:10:35","reservation_modified_date_time":"2019-08-02 10:10:35","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"}]},{"room_stay_id":"3006154","reservation_id":"81907","confirmation_number":"SJ12667463111","room_confirmation_number":"SJ12670638429","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.02","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Pizza 12\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:17:21","reservation_modified_date_time":"2019-08-02 23:17:21","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":"6.51","product_attribute_values":null,"currentDayPrice":"13.02","currentDayDiscount":"6.51","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006156","reservation_id":"81908","confirmation_number":"SJ12684002775","room_confirmation_number":"SJ12680941537","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.51","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Island fries","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:22:05","reservation_modified_date_time":"2019-08-02 23:22:05","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":"6.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006157","reservation_id":"81908","confirmation_number":"SJ12695829005","room_confirmation_number":"SJ12680941537","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.51","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Chicken wings","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:22:05","reservation_modified_date_time":"2019-08-02 23:22:05","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":"6.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006172","reservation_id":"81913","confirmation_number":"SJ12665700117","room_confirmation_number":"SJ12662220559","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.16","grand_total":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"1","product_name":"Pizza 12\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 23:58:49","reservation_modified_date_time":"2019-08-02 23:58:49","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":"11.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006187","reservation_id":"81919","confirmation_number":"SJ12652893987","room_confirmation_number":"SJ12619365684","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"16.74","grand_total":"18.00","paid_amount":"18.00","product_id":null,"service_quantity":"1","product_name":"Pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 00:56:45","reservation_modified_date_time":"2019-08-03 00:56:45","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":"16.74","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006199","reservation_id":"81920","confirmation_number":"SJ12644852166","room_confirmation_number":"SJ12678305387","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.51","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Island fries","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:26:39","reservation_modified_date_time":"2019-08-03 01:26:39","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":"6.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006200","reservation_id":"81920","confirmation_number":"SJ12661957510","room_confirmation_number":"SJ12678305387","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.46","grand_total":"21.99","paid_amount":"21.99","product_id":null,"service_quantity":"1","product_name":"Bianca pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:26:39","reservation_modified_date_time":"2019-08-03 01:26:39","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":"20.46","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006221","reservation_id":"81922","confirmation_number":"SJ12622528259","room_confirmation_number":"SJ12619882366","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.51","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Chicken wings","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 01:55:08","reservation_modified_date_time":"2019-08-03 01:55:08","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":"6.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006234","reservation_id":"81925","confirmation_number":"SJ12699433895","room_confirmation_number":"SJ12644040947","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":"21.00","paid_amount":"21.00","product_id":null,"service_quantity":"7","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 02:51:41","reservation_modified_date_time":"2019-08-03 02:51:41","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":"19.53","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3006238","reservation_id":"81926","confirmation_number":"SJ12641599255","room_confirmation_number":"SJ12661221671","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"14.88","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"1","product_name":"Margherita pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-03 02:56:49","reservation_modified_date_time":"2019-08-03 02:56:49","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":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}