{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-09-01","total_rooms_exist":44,"departureCount":10,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"9","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3015685","reservation_id":"83476","confirmation_number":"SJ12661411228","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00","nightly_discount":"0,0,0,0","subtotal":"556.00","grand_total":"625.50","paid_amount":"625.50","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-3678993653","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":"90787","customer_id":"90787","source_of_creation":"Booking.com","reservation_created_date":"2019-08-31 15:28:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"100.08","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":"3015696","reservation_id":"83503","confirmation_number":"SJ12647785191","room_stay_from":"2019-09-01","room_stay_to":"2019-09-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00","nightly_discount":"0","subtotal":"139.00","grand_total":"156.38","paid_amount":"156.38","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-3133984795","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":"90804","customer_id":"90804","source_of_creation":"Booking.com","reservation_created_date":"2019-09-01 11:39:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"25.02","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":"3015852","reservation_id":"83519","confirmation_number":"SJ12679824085","room_stay_from":"2019-09-01","room_stay_to":"2019-09-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.00","nightly_discount":"0","subtotal":"164.00","grand_total":"184.50","paid_amount":"184.50","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3329693909","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":"90820","customer_id":"90820","source_of_creation":"Booking.com","reservation_created_date":"2019-09-01 19:00:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"29.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"164.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":"3014268","reservation_id":"83275","confirmation_number":"SJ12622441776","room_stay_from":"2019-08-31","room_stay_to":"2019-09-01","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.24","nightly_discount":"0","subtotal":"174.24","grand_total":"196.02","paid_amount":"196.02","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-3082978075","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":"90658","customer_id":"90658","source_of_creation":"Booking.com","reservation_created_date":"2019-08-27 02:43:13","service_canceled_date_time":"2019-09-01 11:09:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"31.36","deltaChange":0,"changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3013353","reservation_id":"82963","confirmation_number":"SJ12676240723","room_stay_from":"2019-08-29","room_stay_to":"2019-09-02","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"113.24,139.84,139.84,136.04","nightly_discount":"0,0,0,0","subtotal":"528.96","grand_total":"595.08","paid_amount":"595.08","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1325906406","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":"90435","customer_id":"90435","source_of_creation":"Expedia","reservation_created_date":"2019-08-20 17:18:15","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":"136.04","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":"3014531","reservation_id":"81133","confirmation_number":"SJ12659977365","room_stay_from":"2019-08-30","room_stay_to":"2019-09-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.24,132.24,145.92","nightly_discount":"0,0,0","subtotal":"410.40","grand_total":"461.70","paid_amount":"461.70","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1304509276","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":"89188","customer_id":"89188","source_of_creation":"Expedia","reservation_created_date":"2019-07-20 23:40:09","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":"145.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":"3019231","reservation_id":"82809","confirmation_number":"SJ12694235088","room_stay_from":"2019-09-01","room_stay_to":"2019-09-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0.00","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1323834659","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":"90333","customer_id":"90333","source_of_creation":"Expedia","reservation_created_date":"2019-08-17 14:47:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3015816","reservation_id":"83510","confirmation_number":"SJ12646814557","room_stay_from":"2019-09-01","room_stay_to":"2019-09-02","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"134.83","nightly_discount":"0","subtotal":"134.83","grand_total":"174.10","paid_amount":"174.10","room_type_id":"413","product_id":"1269","siteminder_id":"ABB-HMAMNFXKS5","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"134.83","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90811","customer_id":"90811","source_of_creation":"Airbnb","reservation_created_date":"2019-09-01 15:33:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 218","ota_service_fee_amount":"17.93","commision_charges":"4.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.83","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":"3016059","reservation_id":"83527","confirmation_number":"SJ12618517878","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00","nightly_discount":"0.00,0.00","subtotal":"278.00","grand_total":"312.75","paid_amount":"312.75","room_type_id":"413","product_id":"1261","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":"90826","customer_id":"90826","source_of_creation":"PMS","reservation_created_date":"2019-09-02 00:44:55","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":"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":"3015782","reservation_id":"83019","confirmation_number":"SJ12656570000","room_stay_from":"2019-08-31","room_stay_to":"2019-09-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00","nightly_discount":"0.00","subtotal":"184.00","grand_total":"207.00","paid_amount":"207.00","room_type_id":"319","product_id":"1308","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":"90481","customer_id":"90481","source_of_creation":"PMS","reservation_created_date":"2019-08-21 22:58:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","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":"5.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3010689","reservation_id":"82551","confirmation_number":"SJ12674509678","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","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-08-12 23:06:29","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":"3017080","reservation_id":"82553","confirmation_number":"SJ12691315748","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","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":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-08-12 23:19:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3015497","reservation_id":"80228","confirmation_number":"SJ12685988422","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.07,74.07,74.08","nightly_discount":"0.00,0.00,0.00","subtotal":"222.22","grand_total":"250.00","paid_amount":"250.00","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-07-05 19:00:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.07","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":"3015825","reservation_id":"72753","confirmation_number":"SJ12670654027","room_stay_from":"2019-08-29","room_stay_to":"2019-09-01","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"370.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"370.00","grand_total":"416.25","paid_amount":"416.25","room_type_id":"413","product_id":"1261","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 17:03:49","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3010690","reservation_id":"82551","confirmation_number":"SJ12689310263","room_confirmation_number":"SJ12674509678","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","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":"90148","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-12 23:06:29","reservation_modified_date_time":"2019-08-12 23:06:29","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":"3013356","reservation_id":"82963","confirmation_number":"SJ12692119096","room_confirmation_number":"SJ12676240723","room_stay_from":"2019-08-29","room_stay_to":"2019-09-02","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":"90435","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-20 17:18:15","reservation_modified_date_time":"2019-08-20 17:18:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90435","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":"3014533","reservation_id":"81133","confirmation_number":"SJ12616864579","room_confirmation_number":"SJ12659977365","room_stay_from":"2019-08-30","room_stay_to":"2019-09-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"89188","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-20 23:40:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89188","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":"3015498","reservation_id":"80228","confirmation_number":"SJ12625641242","room_confirmation_number":"SJ12685988422","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"88599","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-05 19:00:07","reservation_modified_date_time":"2019-08-31 04:39:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","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":"3015686","reservation_id":"83476","confirmation_number":"SJ12643462017","room_confirmation_number":"SJ12661411228","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"90787","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-31 15:28:07","reservation_modified_date_time":"2019-08-31 15:28:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90787","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":"3015698","reservation_id":"83503","confirmation_number":"SJ12670479328","room_confirmation_number":"SJ12647785191","room_stay_from":"2019-09-01","room_stay_to":"2019-09-02","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"90804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-01 11:39:09","reservation_modified_date_time":"2019-09-01 11:39:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90804","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":"3015817","reservation_id":"83510","confirmation_number":"SJ12633049842","room_confirmation_number":"SJ12646814557","room_stay_from":"2019-09-01","room_stay_to":"2019-09-02","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"90811","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-01 15:33:05","reservation_modified_date_time":"2019-09-01 15:33:05","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90811","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":"3015853","reservation_id":"83519","confirmation_number":"SJ12694124129","room_confirmation_number":"SJ12679824085","room_stay_from":"2019-09-01","room_stay_to":"2019-09-02","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"90820","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-01 19:00:07","reservation_modified_date_time":"2019-09-01 19:00:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90820","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":"3016061","reservation_id":"83527","confirmation_number":"SJ12669721489","room_confirmation_number":"SJ12618517878","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90826","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-02 00:44:55","reservation_modified_date_time":"2019-09-02 00:44:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90826","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":"3017081","reservation_id":"82553","confirmation_number":"SJ12652864248","room_confirmation_number":"SJ12691315748","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","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":"90151","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-12 23:19:47","reservation_modified_date_time":"2019-08-12 23:19:47","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":"3019232","reservation_id":"82809","confirmation_number":"SJ12636224807","room_confirmation_number":"SJ12694235088","room_stay_from":"2019-09-01","room_stay_to":"2019-09-02","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"90333","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-17 14:47:05","reservation_modified_date_time":"2019-09-14 18:01:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90333","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3015806","reservation_id":"82988","confirmation_number":"SJ12676393049","room_confirmation_number":"SJ12628675114","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"18.60","grand_total":"40.00","paid_amount":"40.00","product_id":"1757","service_quantity":"2","product_name":"Pool Towels","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-01 15:13:48","reservation_modified_date_time":"2019-09-01 15:13:48","customer_id":"90458","parentCustTravId":"90458","customer_traveller_id":"90458","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"37.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3015829","reservation_id":"72753","confirmation_number":"SJ12691103349","room_confirmation_number":"SJ12670654027","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.26","paid_amount":"10.00","product_id":"1869","service_quantity":"2","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-01 16:29:16","reservation_modified_date_time":"2019-09-01 16:29:16","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"83837","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3015848","reservation_id":"83510","confirmation_number":"SJ12629968286","room_confirmation_number":"SJ12646814557","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"53.76","paid_amount":"53.76","product_id":"1868","service_quantity":"2","product_name":"Golf Cart Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-01 17:57:29","reservation_modified_date_time":"2019-09-01 17:57:29","customer_id":"90811","parentCustTravId":"90811","customer_traveller_id":"90811","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3015849","reservation_id":"83510","confirmation_number":"SJ12693270148","room_confirmation_number":"SJ12646814557","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.65","grand_total":"5.00","paid_amount":"5.00","product_id":"1666","service_quantity":"1","product_name":"Golf Balls","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-01 17:58:45","reservation_modified_date_time":"2019-09-01 17:58:45","customer_id":"90811","parentCustTravId":"90811","customer_traveller_id":"90811","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"4.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[{"room_stay_id":"3015855","reservation_id":"83510","confirmation_number":"SJ12691296853","room_confirmation_number":"SJ12646814557","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"3.00","paid_amount":"3.00","product_id":"1658","service_quantity":"1","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-01 19:08:39","reservation_modified_date_time":"2019-09-01 19:08:39","customer_id":"90811","parentCustTravId":"90811","customer_traveller_id":"90811","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3015932","reservation_id":"83532","confirmation_number":"SJ12611344584","room_confirmation_number":"SJ12695219654","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"3","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 02:29:02","reservation_modified_date_time":"2019-09-02 02:29:02","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"8.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}