{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-10-24","total_rooms_exist":44,"departureCount":3,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"11","block_room_bookings":[],"bundle_block_count":"2","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3010511","reservation_id":"82663","confirmation_number":"SJ12694779520","room_stay_from":"2019-10-23","room_stay_to":"2019-10-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,169.00,239.00","nightly_discount":"0,0,0","subtotal":"557.00","grand_total":"626.63","paid_amount":"167.63","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3790940389","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":"90234","customer_id":"90234","source_of_creation":"Booking.com","reservation_created_date":"2019-08-15 03:24:11","service_canceled_date_time":"2019-10-24 11:42:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"100.26","deltaChange":0,"changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3019371","reservation_id":"84111","confirmation_number":"SJ12632131941","room_stay_from":"2019-10-21","room_stay_to":"2019-10-25","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"323.00,323.00,0.00,363.00","nightly_discount":"0,0,0,0","subtotal":"1009.00","grand_total":"1135.13","paid_amount":"1135.13","room_type_id":"320","product_id":"1330","siteminder_id":"EXP-1342614784","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":"91623","customer_id":"91623","source_of_creation":"Expedia","reservation_created_date":"2019-09-15 01:42:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"363.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":"3024199","reservation_id":"84937","confirmation_number":"SJ12695764094","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.20,159.20,0.00","nightly_discount":"0,0,0","subtotal":"270.40","grand_total":"304.20","paid_amount":"304.20","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1352878774","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":"92198","customer_id":"92198","source_of_creation":"Expedia","reservation_created_date":"2019-10-01 01:17:09","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":"111.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3025473","reservation_id":"85155","confirmation_number":"SJ12657149461","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,199.00,0.00","nightly_discount":"0,0,0","subtotal":"338.00","grand_total":"380.25","paid_amount":"380.25","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1356016231","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":"92364","customer_id":"92364","source_of_creation":"Expedia","reservation_created_date":"2019-10-05 19:32:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.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":"3026752","reservation_id":"85376","confirmation_number":"SJ12640779917","room_stay_from":"2019-10-22","room_stay_to":"2019-10-27","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"139.00,139.00,0.00,199.00,199.00","nightly_discount":"0,0,0,0,0","subtotal":"676.00","grand_total":"760.50","paid_amount":"760.50","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1358824283","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":"92524","customer_id":"92524","source_of_creation":"Expedia","reservation_created_date":"2019-10-10 02:21:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.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":"3027728","reservation_id":"85320","confirmation_number":"SJ12656329963","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,199.00,0.00","nightly_discount":"0,0,0","subtotal":"338.00","grand_total":"380.25","paid_amount":"380.25","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1357994203","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":"92479","customer_id":"92479","source_of_creation":"Expedia","reservation_created_date":"2019-10-08 21:51:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.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":"3028563","reservation_id":"85677","confirmation_number":"SJ12644024108","room_stay_from":"2019-10-24","room_stay_to":"2019-10-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.20,159.20,0.00,111.20","nightly_discount":"0,0,0,0","subtotal":"381.60","grand_total":"429.30","paid_amount":"429.30","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1361956443","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":"92708","customer_id":"92708","source_of_creation":"Expedia","reservation_created_date":"2019-10-15 03:51:10","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":"111.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3028940","reservation_id":"85709","confirmation_number":"SJ12612225720","room_stay_from":"2019-10-22","room_stay_to":"2019-10-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.20,111.20,0.00","nightly_discount":"0,0,0","subtotal":"222.40","grand_total":"250.20","paid_amount":"250.20","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1362568865","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":"92740","customer_id":"92740","source_of_creation":"Expedia","reservation_created_date":"2019-10-16 01:36:05","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":"0.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":"3029362","reservation_id":"85783","confirmation_number":"SJ12657567490","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,199.00,0.00","nightly_discount":"0,0,0","subtotal":"368.00","grand_total":"414.00","paid_amount":"414.00","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1362914641","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":"92799","customer_id":"92799","source_of_creation":"Expedia","reservation_created_date":"2019-10-17 05:12:11","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":"169.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":"3030570","reservation_id":"85145","confirmation_number":"SJ12666895407","room_stay_from":"2019-10-22","room_stay_to":"2019-10-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.20,111.20,0.00","nightly_discount":"0,0,0","subtotal":"222.40","grand_total":"250.20","paid_amount":"250.20","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1355910689","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":"92356","customer_id":"92356","source_of_creation":"Expedia","reservation_created_date":"2019-10-05 15:37:07","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","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":"3030577","reservation_id":"85286","confirmation_number":"SJ12637928245","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.20,159.20,0.00","nightly_discount":"0,0,0","subtotal":"270.40","grand_total":"304.20","paid_amount":"304.20","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1357366433","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":"92455","customer_id":"92455","source_of_creation":"Expedia","reservation_created_date":"2019-10-08 00:37:11","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":"111.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3030892","reservation_id":"86024","confirmation_number":"SJ12644560524","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,199.00,0.00","nightly_discount":"0,0,0","subtotal":"368.00","grand_total":"414.00","paid_amount":"414.00","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1365439239","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":"92901","customer_id":"92901","source_of_creation":"Expedia","reservation_created_date":"2019-10-20 22:41:07","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":"169.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":"3031637","reservation_id":"86039","confirmation_number":"SJ12646179477","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"114.92,135.32","nightly_discount":"0,0","subtotal":"250.24","grand_total":"281.52","paid_amount":"281.52","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1365745873","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":"92912","customer_id":"92912","source_of_creation":"Expedia","reservation_created_date":"2019-10-21 12:41:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.92","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":"3031826","reservation_id":"84806","confirmation_number":"SJ12668709783","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.72,169.32","nightly_discount":"0,0","subtotal":"291.04","grand_total":"327.42","paid_amount":"327.42","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1351360201","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":"92104","customer_id":"92104","source_of_creation":"Expedia","reservation_created_date":"2019-09-28 14:07:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"121.72","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":"3031830","reservation_id":"84944","confirmation_number":"SJ12664566205","room_stay_from":"2019-10-23","room_stay_to":"2019-10-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.12,129.00","nightly_discount":"0.00,0.00","subtotal":"237.12","grand_total":"266.76","paid_amount":"266.76","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1352964406","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":"92204","customer_id":"92204","source_of_creation":"Expedia","reservation_created_date":"2019-10-01 04:12:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.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"}]}],"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":"3026580","reservation_id":"85353","confirmation_number":"SJ12631079717","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.63,173.63,173.63","nightly_discount":"0,0,0","subtotal":"520.89","grand_total":"672.59","paid_amount":"672.59","room_type_id":"319","product_id":"1309","siteminder_id":"ABB-HMAKK3JSM3","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"520.89","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92506","customer_id":"92506","source_of_creation":"Airbnb","reservation_created_date":"2019-10-09 17:53:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"69.27","commision_charges":"16.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.63","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"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3032008","reservation_id":"86062","confirmation_number":"SJ12663649023","room_stay_from":"2019-10-23","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"278.00","grand_total":"312.75","paid_amount":"312.75","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92932","customer_id":"92932","source_of_creation":"PMS","reservation_created_date":"2019-10-21 23:37:17","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":"","changedComment":"Nightly price or discount changed","deltaChange":"36.00","currentDayPrice":"139.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":"3032030","reservation_id":"86161","confirmation_number":"SJ12687912927","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00","nightly_discount":"0.00,0.00","subtotal":"338.00","grand_total":"380.25","paid_amount":"380.25","room_type_id":"413","product_id":"1260","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":"93017","customer_id":"93017","source_of_creation":"PMS","reservation_created_date":"2019-10-24 14:05:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.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":"3032044","reservation_id":"86164","confirmation_number":"SJ12641547911","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"222.75","paid_amount":"222.75","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"93019","customer_id":"93019","source_of_creation":"PMS","reservation_created_date":"2019-10-24 15:35:45","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":"99.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":"3024092","reservation_id":"84920","confirmation_number":"SJ12669385112","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-09-30 19:32:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3024176","reservation_id":"84926","confirmation_number":"SJ12630768200","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-09-30 20:53:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3024178","reservation_id":"84927","confirmation_number":"SJ12664093249","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-09-30 21:05:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3030492","reservation_id":"85625","confirmation_number":"SJ12641164975","room_stay_from":"2019-10-20","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"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-10-14 12:53:41","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"}]}],"negotiated_taxable":[{"room_stay_id":"3032626","reservation_id":"72639","confirmation_number":"SJ12680168758","room_stay_from":"2019-10-20","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"575.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"575.00","grand_total":"646.88","paid_amount":"646.88","room_type_id":"319","product_id":"1305","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"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:59:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3042793","reservation_id":"73318","confirmation_number":"SJ12674593865","room_stay_from":"2019-10-24","room_stay_to":"2019-10-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"410.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"410.00","grand_total":"461.25","paid_amount":"461.25","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-27 18:30:26","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":"410.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":"2951781","reservation_id":"72371","confirmation_number":"SJ12662994046","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.14,82.14,82.14,82.14,82.14,82.14,82.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"575.00","grand_total":"575.00","paid_amount":"575.00","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-18 13:45:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.14","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2951788","reservation_id":"72372","confirmation_number":"SJ12635294045","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.14,82.14,82.14,82.14,82.14,82.14,82.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"575.00","grand_total":"575.00","paid_amount":"575.00","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-18 13:47:45","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":"82.14","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3030137","reservation_id":"72638","confirmation_number":"SJ12670961370","room_stay_from":"2019-10-18","room_stay_to":"2019-10-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.14,82.14,82.14,82.14,82.14,82.14,82.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"575.00","grand_total":"575.00","paid_amount":"575.00","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-21 00:57:45","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":"82.16","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":"3030470","reservation_id":"84763","confirmation_number":"SJ12693745888","room_stay_from":"2019-10-20","room_stay_to":"2019-10-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.00,82.00,82.00,82.00,82","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"410.00","grand_total":"410.00","paid_amount":"410.00","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-09-27 03:54:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82","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":"3032041","reservation_id":"86164","confirmation_number":"SJ12691629346","room_confirmation_number":"SJ12641547911","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"25.00,25.00","subtotal":"50.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"93019","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-10-24 15:35:45","reservation_modified_date_time":"2019-10-24 15:35:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93019","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2951783","reservation_id":"72371","confirmation_number":"SJ12693401541","room_confirmation_number":"SJ12662994046","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","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":"83514","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-18 13:45:27","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":"2951789","reservation_id":"72372","confirmation_number":"SJ12677430615","room_confirmation_number":"SJ12635294045","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","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":"83515","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-18 13:47:45","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":"3019372","reservation_id":"84111","confirmation_number":"SJ12658601356","room_confirmation_number":"SJ12632131941","room_stay_from":"2019-10-21","room_stay_to":"2019-10-25","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":"91623","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-15 01:42:10","reservation_modified_date_time":"2019-09-15 01:42:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91623","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":"3024093","reservation_id":"84920","confirmation_number":"SJ12685497249","room_confirmation_number":"SJ12669385112","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"92184","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-30 19:32:20","reservation_modified_date_time":"2019-09-30 19:32:20","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":"3024177","reservation_id":"84926","confirmation_number":"SJ12616340675","room_confirmation_number":"SJ12630768200","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"92189","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-30 20:53:24","reservation_modified_date_time":"2019-09-30 20:53:24","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":"3024179","reservation_id":"84927","confirmation_number":"SJ12627598499","room_confirmation_number":"SJ12664093249","room_stay_from":"2019-10-19","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"92184","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-30 21:05:41","reservation_modified_date_time":"2019-09-30 21:05:41","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":"3024200","reservation_id":"84937","confirmation_number":"SJ12670272358","room_confirmation_number":"SJ12695764094","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"92198","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-01 01:17:09","reservation_modified_date_time":"2019-10-01 01:17:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92198","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":"3025475","reservation_id":"85155","confirmation_number":"SJ12682096215","room_confirmation_number":"SJ12657149461","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"92364","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-05 19:32:09","reservation_modified_date_time":"2019-10-05 19:32:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92364","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":"3026581","reservation_id":"85353","confirmation_number":"SJ12621040331","room_confirmation_number":"SJ12631079717","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"92506","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-09 17:53:04","reservation_modified_date_time":"2019-10-09 17:53:04","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92506","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":"3026753","reservation_id":"85376","confirmation_number":"SJ12610683092","room_confirmation_number":"SJ12640779917","room_stay_from":"2019-10-22","room_stay_to":"2019-10-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"92524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-10 02:21:11","reservation_modified_date_time":"2019-10-10 02:21:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92524","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":"3027729","reservation_id":"85320","confirmation_number":"SJ12665555428","room_confirmation_number":"SJ12656329963","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"92479","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-08 21:51:11","reservation_modified_date_time":"2019-10-08 21:51:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92479","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":"3028564","reservation_id":"85677","confirmation_number":"SJ12689426718","room_confirmation_number":"SJ12644024108","room_stay_from":"2019-10-24","room_stay_to":"2019-10-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"92708","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-15 03:51:10","reservation_modified_date_time":"2019-10-15 03:51:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92708","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":"3028941","reservation_id":"85709","confirmation_number":"SJ12670072689","room_confirmation_number":"SJ12612225720","room_stay_from":"2019-10-22","room_stay_to":"2019-10-25","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":"92740","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-16 01:36:05","reservation_modified_date_time":"2019-10-16 01:36:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92740","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":"3029363","reservation_id":"85783","confirmation_number":"SJ12666478125","room_confirmation_number":"SJ12657567490","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"92799","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-17 05:12:11","reservation_modified_date_time":"2019-10-17 05:12:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92799","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":"3030138","reservation_id":"72638","confirmation_number":"SJ12617049088","room_confirmation_number":"SJ12670961370","room_stay_from":"2019-10-18","room_stay_to":"2019-10-25","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":"83731","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 00:57:45","reservation_modified_date_time":"2019-10-18 09:23: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":"3030471","reservation_id":"84763","confirmation_number":"SJ12689437826","room_confirmation_number":"SJ12693745888","room_stay_from":"2019-10-20","room_stay_to":"2019-10-25","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":"92070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-27 03:54:30","reservation_modified_date_time":"2019-10-20 04:10:47","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":"3030493","reservation_id":"85625","confirmation_number":"SJ12615075401","room_confirmation_number":"SJ12641164975","room_stay_from":"2019-10-20","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"92663","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-14 12:53:41","reservation_modified_date_time":"2019-10-14 12:53:41","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3030572","reservation_id":"85145","confirmation_number":"SJ12638841352","room_confirmation_number":"SJ12666895407","room_stay_from":"2019-10-22","room_stay_to":"2019-10-25","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":"92356","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-05 15:37:07","reservation_modified_date_time":"2019-10-05 15:37:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92356","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":"3030578","reservation_id":"85286","confirmation_number":"SJ12613654485","room_confirmation_number":"SJ12637928245","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"92455","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-08 00:37:11","reservation_modified_date_time":"2019-10-08 00:37:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92455","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":"3030893","reservation_id":"86024","confirmation_number":"SJ12668165997","room_confirmation_number":"SJ12644560524","room_stay_from":"2019-10-24","room_stay_to":"2019-10-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"92901","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-20 22:41:07","reservation_modified_date_time":"2019-10-20 22:41:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92901","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":"3031638","reservation_id":"86039","confirmation_number":"SJ12684988136","room_confirmation_number":"SJ12646179477","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"92912","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-21 12:41:06","reservation_modified_date_time":"2019-10-21 12:41:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92912","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":"3031827","reservation_id":"84806","confirmation_number":"SJ12656241241","room_confirmation_number":"SJ12668709783","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"92104","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-28 14:07:09","reservation_modified_date_time":"2019-09-28 14:07:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92104","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":"3031831","reservation_id":"84944","confirmation_number":"SJ12652060628","room_confirmation_number":"SJ12664566205","room_stay_from":"2019-10-23","room_stay_to":"2019-10-25","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":"92204","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-01 04:12:08","reservation_modified_date_time":"2019-10-23 17:31:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92204","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":"3032009","reservation_id":"86062","confirmation_number":"SJ12644165513","room_confirmation_number":"SJ12663649023","room_stay_from":"2019-10-23","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"92932","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-21 23:37:17","reservation_modified_date_time":"2019-10-24 12:42:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92932","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":"3032031","reservation_id":"86161","confirmation_number":"SJ12612999515","room_confirmation_number":"SJ12687912927","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"93017","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-24 14:05:19","reservation_modified_date_time":"2019-10-24 14:05:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93017","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":"3032045","reservation_id":"86164","confirmation_number":"SJ12662298813","room_confirmation_number":"SJ12641547911","room_stay_from":"2019-10-24","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"93019","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-24 15:35:45","reservation_modified_date_time":"2019-10-24 15:35:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93019","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":"3032627","reservation_id":"72639","confirmation_number":"SJ12658159803","room_confirmation_number":"SJ12680168758","room_stay_from":"2019-10-20","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"125.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"83732","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 00:59:43","reservation_modified_date_time":"2019-10-20 04:11:38","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":"3042795","reservation_id":"73318","confirmation_number":"SJ12677372654","room_confirmation_number":"SJ12674593865","room_stay_from":"2019-10-24","room_stay_to":"2019-10-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"61.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"84186","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-27 18:30:26","reservation_modified_date_time":"2019-11-29 23:57:31","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":"3010512","reservation_id":"82663","confirmation_number":"SJ12662948785","room_confirmation_number":"SJ12694779520","room_stay_from":"2019-10-23","room_stay_to":"2019-10-26","room_stay_status":"Canceled","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-15 03:24:11","reservation_modified_date_time":"2019-08-15 03:24:11","customer_id":"90234","parentCustTravId":"90234","customer_traveller_id":"90234","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-24 11:42:10","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":0,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3032343","reservation_id":"86202","confirmation_number":"SJ12648258110","room_confirmation_number":"SJ12665670620","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"7.50","paid_amount":"7.50","product_id":null,"service_quantity":"3","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 02:44:11","reservation_modified_date_time":"2019-10-25 02:44:11","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":"6.99","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":"3032172","reservation_id":"86183","confirmation_number":"SJ12641054155","room_confirmation_number":"SJ12692507553","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 LaRae Lobdell","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 21:55:35","reservation_modified_date_time":"2019-10-24 21:55:35","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":"3032192","reservation_id":"86184","confirmation_number":"SJ12687072657","room_confirmation_number":"SJ12657098095","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 LaRae Lobdell","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 22:32:35","reservation_modified_date_time":"2019-10-24 22:32:35","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":[]},{"room_stay_id":"3032200","reservation_id":"86186","confirmation_number":"SJ12642517726","room_confirmation_number":"SJ12686789248","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.00","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for LaRae Lobdell","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 23:22:13","reservation_modified_date_time":"2019-10-24 23:22:13","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":"8.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3032205","reservation_id":"86188","confirmation_number":"SJ12684659094","room_confirmation_number":"SJ12637093698","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 LaRae Lobdell","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 23:34:23","reservation_modified_date_time":"2019-10-24 23:34:23","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":"3032215","reservation_id":"86189","confirmation_number":"SJ12638979280","room_confirmation_number":"SJ12622129121","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 LaRae Lobdell","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 23:49:50","reservation_modified_date_time":"2019-10-24 23:49:50","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":"3032233","reservation_id":"86192","confirmation_number":"SJ12628811489","room_confirmation_number":"SJ12647187300","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 LaRae Lobdell","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 00:41:21","reservation_modified_date_time":"2019-10-25 00:41:21","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":"3032251","reservation_id":"86195","confirmation_number":"SJ12691503387","room_confirmation_number":"SJ12629929331","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 LaRae Lobdell","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 01:09:59","reservation_modified_date_time":"2019-10-25 01:09:59","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":[]},{"room_stay_id":"3032261","reservation_id":"86199","confirmation_number":"SJ12620717181","room_confirmation_number":"SJ12668789045","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.00","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for LaRae Lobdell","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 01:24:28","reservation_modified_date_time":"2019-10-25 01:24:28","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":"6.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[{"room_stay_id":"3032135","reservation_id":"86177","confirmation_number":"SJ12647170681","room_confirmation_number":"SJ12690642534","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-10-24 20:07:15","reservation_modified_date_time":"2019-10-24 20:07:15","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":"3032162","reservation_id":"86182","confirmation_number":"SJ12686071287","room_confirmation_number":"SJ12614985947","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-10-24 21:39:01","reservation_modified_date_time":"2019-10-24 21:39:01","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3032173","reservation_id":"86183","confirmation_number":"SJ12627914564","room_confirmation_number":"SJ12692507553","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-10-24 21:55:36","reservation_modified_date_time":"2019-10-24 21:55:36","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":"3032174","reservation_id":"86183","confirmation_number":"SJ12659043332","room_confirmation_number":"SJ12692507553","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-10-24 21:55:36","reservation_modified_date_time":"2019-10-24 21:55:36","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":"3032193","reservation_id":"86184","confirmation_number":"SJ12626111038","room_confirmation_number":"SJ12657098095","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-10-24 22:32:35","reservation_modified_date_time":"2019-10-24 22:32:35","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":"3032194","reservation_id":"86184","confirmation_number":"SJ12610869330","room_confirmation_number":"SJ12657098095","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.90","grand_total":"15.01","paid_amount":"15.01","product_id":null,"service_quantity":"1","product_name":"Oban Scotch","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 22:32:35","reservation_modified_date_time":"2019-10-24 22:32:35","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":"3032195","reservation_id":"86184","confirmation_number":"SJ12642678528","room_confirmation_number":"SJ12657098095","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":"Johnny Walker Black","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 22:32:35","reservation_modified_date_time":"2019-10-24 22:32:35","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":"3032196","reservation_id":"86184","confirmation_number":"SJ12636390988","room_confirmation_number":"SJ12657098095","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-10-24 22:32:35","reservation_modified_date_time":"2019-10-24 22:32: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":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3032201","reservation_id":"86186","confirmation_number":"SJ12684854047","room_confirmation_number":"SJ12686789248","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":null,"service_quantity":"4","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 23:22:13","reservation_modified_date_time":"2019-10-24 23:22: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":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3032206","reservation_id":"86188","confirmation_number":"SJ12630485113","room_confirmation_number":"SJ12637093698","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":"Bud Light Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 23:34:23","reservation_modified_date_time":"2019-10-24 23:34:23","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":"3032210","reservation_id":"86189","confirmation_number":"SJ12694674717","room_confirmation_number":"SJ12622129121","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-10-24 23:44:05","reservation_modified_date_time":"2019-10-24 23:44: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":"3032211","reservation_id":"86189","confirmation_number":"SJ12663219875","room_confirmation_number":"SJ12622129121","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":"18.00","paid_amount":"18.00","product_id":null,"service_quantity":"6","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-24 23:44:05","reservation_modified_date_time":"2019-10-24 23:44: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":"16.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3032226","reservation_id":"86190","confirmation_number":"SJ12647677939","room_confirmation_number":"SJ12621741556","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 Chardonnay","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 00:14:51","reservation_modified_date_time":"2019-10-25 00:14:51","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":"3032227","reservation_id":"86190","confirmation_number":"SJ12654467903","room_confirmation_number":"SJ12621741556","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 Cabernet Sauvignon","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 00:14:51","reservation_modified_date_time":"2019-10-25 00:14:51","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":"3032230","reservation_id":"86191","confirmation_number":"SJ12615629261","room_confirmation_number":"SJ12625611449","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-10-25 00:27:20","reservation_modified_date_time":"2019-10-25 00:27:20","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":"3032231","reservation_id":"86191","confirmation_number":"SJ12697469894","room_confirmation_number":"SJ12625611449","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":"Deep Eddy","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 00:27:20","reservation_modified_date_time":"2019-10-25 00:27:20","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":"3032234","reservation_id":"86192","confirmation_number":"SJ12612064602","room_confirmation_number":"SJ12647187300","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"2","product_name":"Hendriks","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 00:41:21","reservation_modified_date_time":"2019-10-25 00:41: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":"0.00","product_attribute_values":null,"currentDayPrice":"14.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3032245","reservation_id":"86193","confirmation_number":"SJ12643785614","room_confirmation_number":"SJ12688071886","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.34","grand_total":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"1","product_name":"Pina Colada","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 00:43:58","reservation_modified_date_time":"2019-10-25 00:43:58","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":"3032246","reservation_id":"86193","confirmation_number":"SJ12657355301","room_confirmation_number":"SJ12688071886","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"White Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 00:43:58","reservation_modified_date_time":"2019-10-25 00:43:58","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":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3032252","reservation_id":"86195","confirmation_number":"SJ12686462283","room_confirmation_number":"SJ12629929331","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"14.00","paid_amount":"14.00","product_id":null,"service_quantity":"2","product_name":"Titos","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 01:09:59","reservation_modified_date_time":"2019-10-25 01:09:59","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"12.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3032253","reservation_id":"86195","confirmation_number":"SJ12694824711","room_confirmation_number":"SJ12629929331","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":"Captain Morgan","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 01:09:59","reservation_modified_date_time":"2019-10-25 01:09:59","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":"3032254","reservation_id":"86195","confirmation_number":"SJ12624110239","room_confirmation_number":"SJ12629929331","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-10-25 01:09:59","reservation_modified_date_time":"2019-10-25 01:09:59","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":"3032258","reservation_id":"86197","confirmation_number":"SJ12646590591","room_confirmation_number":"SJ12662786689","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 01:13:59","reservation_modified_date_time":"2019-10-25 01:13:59","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":"3032262","reservation_id":"86199","confirmation_number":"SJ12648114668","room_confirmation_number":"SJ12668789045","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":null,"service_quantity":"4","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-25 01:24:28","reservation_modified_date_time":"2019-10-25 01:24:28","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":"18.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}