{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-08-01","total_rooms_exist":44,"departureCount":9,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"10","block_room_bookings":[],"bundle_block_count":"4","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3005062","reservation_id":"81738","confirmation_number":"SJ12672513335","room_stay_from":"2019-07-31","room_stay_to":"2019-08-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00","nightly_discount":"0,0","subtotal":"298.00","grand_total":"335.25","paid_amount":"335.25","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3440137666","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":"89606","customer_id":"89606","source_of_creation":"Booking.com","reservation_created_date":"2019-07-31 11:22:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"53.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.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"}]},{"room_stay_id":"3005215","reservation_id":"81085","confirmation_number":"SJ12661073592","room_stay_from":"2019-08-01","room_stay_to":"2019-08-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"217.89","nightly_discount":"0","subtotal":"217.89","grand_total":"245.12","paid_amount":"245.13","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-3948573416","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":"89158","customer_id":"89158","source_of_creation":"Booking.com","reservation_created_date":"2019-07-20 12:42:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"39.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"217.89","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":"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":"234.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":"119.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":"113.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"}]}],"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":"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":"398.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":"149.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":"378.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":"3003129","reservation_id":"72153","confirmation_number":"SJ12679319776","room_stay_from":"2019-07-26","room_stay_to":"2019-08-02","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":"1273","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 16:49:18","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":"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":"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":"405.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":"3006062","reservation_id":"72622","confirmation_number":"SJ12619534879","room_stay_from":"2019-07-26","room_stay_to":"2019-08-02","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":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-21 00:25:06","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":"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.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":"3004742","reservation_id":"74374","confirmation_number":"SJ12619396970","room_stay_from":"2019-07-30","room_stay_to":"2019-08-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"80.00,80.00,80","nightly_discount":"0.00,0.00,0.00","subtotal":"240.00","grand_total":"240.00","paid_amount":"240.00","room_type_id":"413","product_id":"1268","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-09 16:45:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80","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"}]}],"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"}]}],"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":"3003130","reservation_id":"72153","confirmation_number":"SJ12617680501","room_confirmation_number":"SJ12679319776","room_stay_from":"2019-07-26","room_stay_to":"2019-08-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"126.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"83381","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-16 16:49:18","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":"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":"3004743","reservation_id":"74374","confirmation_number":"SJ12684288056","room_confirmation_number":"SJ12619396970","room_stay_from":"2019-07-30","room_stay_to":"2019-08-02","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":"84823","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-09 16:45:58","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":"3005063","reservation_id":"81738","confirmation_number":"SJ12644926977","room_confirmation_number":"SJ12672513335","room_stay_from":"2019-07-31","room_stay_to":"2019-08-02","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":"89606","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-31 11:22:06","reservation_modified_date_time":"2019-07-31 11:22:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89606","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":"3005217","reservation_id":"81085","confirmation_number":"SJ12668610075","room_confirmation_number":"SJ12661073592","room_stay_from":"2019-08-01","room_stay_to":"2019-08-02","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"89158","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-20 12:42: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":"89158","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":"3006064","reservation_id":"72622","confirmation_number":"SJ12661612393","room_confirmation_number":"SJ12619534879","room_stay_from":"2019-07-26","room_stay_to":"2019-08-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"126.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"83718","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 00:25:06","reservation_modified_date_time":"2019-08-02 18:19:43","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":"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3005539","reservation_id":"73552","confirmation_number":"SJ12673861282","room_confirmation_number":"SJ12643113531","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":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 16:31:22","reservation_modified_date_time":"2019-08-01 16:31:22","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"84337","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":"3005559","reservation_id":"73843","confirmation_number":"SJ12638116875","room_confirmation_number":"SJ12662498509","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.26","paid_amount":"56.26","product_id":"1869","service_quantity":"2","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 17:01:43","reservation_modified_date_time":"2019-08-01 17:01:43","customer_id":"74459","parentCustTravId":"74459","customer_traveller_id":"95412","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3005800","reservation_id":"81475","confirmation_number":"SJ12611145692","room_confirmation_number":"SJ12638330684","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.00","grand_total":"2.00","paid_amount":"2.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Cassy Holliday","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:44:36","reservation_modified_date_time":"2019-08-01 22:44:36","customer_id":"82679","parentCustTravId":"82679","customer_traveller_id":"82679","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":"1","currentDayPrice":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3005810","reservation_id":"80485","confirmation_number":"SJ12626401847","room_confirmation_number":"SJ12648077020","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":"1231","service_quantity":"1","product_name":"Customer Tip for Cassy Holliday","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:59:32","reservation_modified_date_time":"2019-08-01 22:59:32","customer_id":"88764","parentCustTravId":"88764","customer_traveller_id":"88764","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":"1","currentDayPrice":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3005802","reservation_id":"81849","confirmation_number":"SJ12638324284","room_confirmation_number":"SJ12684480439","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.60","grand_total":"2.60","paid_amount":"2.60","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cassy Holliday","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:45:39","reservation_modified_date_time":"2019-08-01 22:45: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":"2.60","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3005852","reservation_id":"81856","confirmation_number":"SJ12618566697","room_confirmation_number":"SJ12676793166","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.00","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cassy Holliday","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 00:44:36","reservation_modified_date_time":"2019-08-02 00:44:36","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":"7.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[{"room_stay_id":"3005801","reservation_id":"81475","confirmation_number":"SJ12696251561","room_confirmation_number":"SJ12638330684","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":"12.00","paid_amount":"12.00","product_id":"1640","service_quantity":"4","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:44:36","reservation_modified_date_time":"2019-08-01 22:44:36","customer_id":"82679","parentCustTravId":"82679","customer_traveller_id":"82679","static_pos_type":"beer","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":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005811","reservation_id":"80485","confirmation_number":"SJ12658534817","room_confirmation_number":"SJ12648077020","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":"20.00","paid_amount":"20.00","product_id":"1385","service_quantity":"4","product_name":"House Rum","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:59:32","reservation_modified_date_time":"2019-08-01 22:59:32","customer_id":"88764","parentCustTravId":"88764","customer_traveller_id":"88764","static_pos_type":"liquor","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":"18.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005788","reservation_id":"81848","confirmation_number":"SJ12650757038","room_confirmation_number":"SJ12685283624","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":"Domestic Draft Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:11:39","reservation_modified_date_time":"2019-08-01 22:11:39","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":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005789","reservation_id":"81848","confirmation_number":"SJ12647605055","room_confirmation_number":"SJ12685283624","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":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Wine","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:11:39","reservation_modified_date_time":"2019-08-01 22:11:39","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":"3.71","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005791","reservation_id":"81849","confirmation_number":"SJ12612524288","room_confirmation_number":"SJ12684480439","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":"Crown Royal","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:14:47","reservation_modified_date_time":"2019-08-01 22:14:47","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":"3005792","reservation_id":"81849","confirmation_number":"SJ12674145681","room_confirmation_number":"SJ12684480439","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":"Domestic Draft Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:14:47","reservation_modified_date_time":"2019-08-01 22:14:47","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":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005793","reservation_id":"81849","confirmation_number":"SJ12620122161","room_confirmation_number":"SJ12684480439","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-01 22:14:47","reservation_modified_date_time":"2019-08-01 22:14:47","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":"3005804","reservation_id":"81852","confirmation_number":"SJ12668800758","room_confirmation_number":"SJ12663627504","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":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"3","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:47:35","reservation_modified_date_time":"2019-08-01 22:47:35","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":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005806","reservation_id":"81853","confirmation_number":"SJ12644517577","room_confirmation_number":"SJ12661855056","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":"Crown Royal","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:53:07","reservation_modified_date_time":"2019-08-01 22:53:07","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":"3005807","reservation_id":"81853","confirmation_number":"SJ12685992973","room_confirmation_number":"SJ12661855056","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Domestic Draft Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:53:07","reservation_modified_date_time":"2019-08-01 22:53:07","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005808","reservation_id":"81853","confirmation_number":"SJ12677919376","room_confirmation_number":"SJ12661855056","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":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"3","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:53:07","reservation_modified_date_time":"2019-08-01 22:53:07","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":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005809","reservation_id":"81853","confirmation_number":"SJ12675118586","room_confirmation_number":"SJ12661855056","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":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 22:53:07","reservation_modified_date_time":"2019-08-01 22:53:07","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":"13.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005835","reservation_id":"81856","confirmation_number":"SJ12677214834","room_confirmation_number":"SJ12676793166","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-02 00:03:20","reservation_modified_date_time":"2019-08-02 00:03:20","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":"3005837","reservation_id":"81856","confirmation_number":"SJ12667602767","room_confirmation_number":"SJ12676793166","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 00:03:20","reservation_modified_date_time":"2019-08-02 00:03:20","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005838","reservation_id":"81856","confirmation_number":"SJ12627062425","room_confirmation_number":"SJ12676793166","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":"Rum Runner","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 00:03:20","reservation_modified_date_time":"2019-08-02 00:03:20","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":"3005839","reservation_id":"81856","confirmation_number":"SJ12653789736","room_confirmation_number":"SJ12676793166","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 00:03:20","reservation_modified_date_time":"2019-08-02 00:03:20","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":"3005848","reservation_id":"81858","confirmation_number":"SJ12657007083","room_confirmation_number":"SJ12656237907","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 00:33:44","reservation_modified_date_time":"2019-08-02 00:33:44","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":"3005849","reservation_id":"81858","confirmation_number":"SJ12644771820","room_confirmation_number":"SJ12656237907","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":"Miller Lite","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 00:33:44","reservation_modified_date_time":"2019-08-02 00:33:44","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":"3005851","reservation_id":"81859","confirmation_number":"SJ12612011413","room_confirmation_number":"SJ12654631946","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 Rum","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 00:34:13","reservation_modified_date_time":"2019-08-02 00:34:13","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005854","reservation_id":"81860","confirmation_number":"SJ12639258401","room_confirmation_number":"SJ12633508680","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":"Strawberry Daiquiri","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 01:00:47","reservation_modified_date_time":"2019-08-02 01:00: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":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005855","reservation_id":"81860","confirmation_number":"SJ12694207233","room_confirmation_number":"SJ12633508680","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 01:00:47","reservation_modified_date_time":"2019-08-02 01:00: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":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3005866","reservation_id":"81861","confirmation_number":"SJ12619321536","room_confirmation_number":"SJ12659384729","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":"21.00","paid_amount":"21.00","product_id":null,"service_quantity":"3","product_name":"Bailey's","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 01:35:13","reservation_modified_date_time":"2019-08-02 01:35:13","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"19.44","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":"3005608","reservation_id":"81840","confirmation_number":"SJ12670864485","room_confirmation_number":"SJ12620120538","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":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"3","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-01 19:23:13","reservation_modified_date_time":"2019-08-01 19:23:13","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":"8.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3005836","reservation_id":"81856","confirmation_number":"SJ12689701147","room_confirmation_number":"SJ12676793166","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":"Smoked Fish Dip","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 00:03:20","reservation_modified_date_time":"2019-08-02 00:03:20","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":"3005871","reservation_id":"81863","confirmation_number":"SJ12661450425","room_confirmation_number":"SJ12685617614","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":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-02 02:46:37","reservation_modified_date_time":"2019-08-02 02:46:37","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":"5.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}