{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-12-16","total_rooms_exist":63,"departureCount":8,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"25","block_room_bookings":[],"bundle_block_count":"11","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3047073","reservation_id":"80422","confirmation_number":"SJ12616914973","room_stay_from":"2019-12-19","room_stay_to":"2019-12-20","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-3637482567","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":"88717","customer_id":"88717","source_of_creation":"Booking.com","reservation_created_date":"2019-07-09 02:29:05","service_canceled_date_time":"2019-12-16 22:45:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"32.22","deltaChange":"179.00","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":[],"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":"3046958","reservation_id":"88293","confirmation_number":"SJ12640967678","room_stay_from":"2019-12-16","room_stay_to":"2019-12-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.55,111.55","nightly_discount":"0,0","subtotal":"223.10","grand_total":"288.08","paid_amount":"288.08","room_type_id":"413","product_id":"1263","siteminder_id":"ABB-HMYX8JNYWA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"223.10","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94573","customer_id":"94573","source_of_creation":"Airbnb","reservation_created_date":"2019-12-14 16:40:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 209","ota_service_fee_amount":"29.67","commision_charges":"6.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.55","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3049657","reservation_id":"87993","confirmation_number":"SJ12694815975","room_stay_from":"2019-12-16","room_stay_to":"2019-12-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.79,129.79,129.79,129.79,129.79","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"648.95","grand_total":"837.95","paid_amount":"837.95","room_type_id":"319","product_id":"1312","siteminder_id":"ABB-HMAJMM3Q3B","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"648.95","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94367","customer_id":"94367","source_of_creation":"Airbnb","reservation_created_date":"2019-12-07 18:12:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"86.3","commision_charges":"20.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3047245","reservation_id":"88341","confirmation_number":"SJ12692478219","room_stay_from":"2019-12-15","room_stay_to":"2019-12-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.00,115.00","nightly_discount":"0.00,0.00","subtotal":"304.00","grand_total":"342.00","paid_amount":"342.00","room_type_id":"319","product_id":"1711","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":"94596","customer_id":"94596","source_of_creation":"PMS","reservation_created_date":"2019-12-15 14:27:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"115.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":"3047775","reservation_id":"88391","confirmation_number":"SJ12686598267","room_stay_from":"2019-12-16","room_stay_to":"2019-12-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00","nightly_discount":"0.00,0.00","subtotal":"230.00","grand_total":"258.75","paid_amount":"258.75","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"94623","customer_id":"94623","source_of_creation":"PMS","reservation_created_date":"2019-12-16 18:15:20","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":"115.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":"3048531","reservation_id":"88392","confirmation_number":"SJ12618425195","room_stay_from":"2019-12-16","room_stay_to":"2019-12-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"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":"0","traveller_tax_exempt":"0","customer_traveller_id":"94172","customer_id":"94172","source_of_creation":"PMS","reservation_created_date":"2019-12-16 18:30:43","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":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":"3041520","reservation_id":"87511","confirmation_number":"SJ12675066992","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-11-25 19:06:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3046886","reservation_id":"83430","confirmation_number":"SJ12696199912","room_stay_from":"2019-12-14","room_stay_to":"2019-12-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2019-08-30 12:19:17","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":"3047077","reservation_id":"73450","confirmation_number":"SJ12676443078","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-03-28 18:35:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3047085","reservation_id":"87509","confirmation_number":"SJ12685317846","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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":"1304","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-11-25 19:02:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","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":"3048883","reservation_id":"87512","confirmation_number":"SJ12653752726","room_stay_from":"2019-12-14","room_stay_to":"2019-12-20","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":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-11-25 19:09:15","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":"3048918","reservation_id":"83921","confirmation_number":"SJ12667268460","room_stay_from":"2019-12-14","room_stay_to":"2019-12-20","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":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-09-11 15:44:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3049482","reservation_id":"86852","confirmation_number":"SJ12638335503","room_stay_from":"2019-12-15","room_stay_to":"2019-12-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"695.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":"695.00","grand_total":"695.00","paid_amount":"0.00","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2019-11-08 15:32:17","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.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":"3047018","reservation_id":"80994","confirmation_number":"SJ12634517646","room_stay_from":"2019-12-14","room_stay_to":"2019-12-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"275.63","paid_amount":"275.63","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-07-19 03:37:20","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":"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":"3047649","reservation_id":"72042","confirmation_number":"SJ12687301125","room_stay_from":"2019-12-15","room_stay_to":"2019-12-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"410.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,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":"1264","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-15 17:07:12","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":"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":"3048118","reservation_id":"87154","confirmation_number":"SJ12654905844","room_stay_from":"2019-12-15","room_stay_to":"2019-12-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,0.00","nightly_discount":"0.00,0.00","subtotal":"245.00","grand_total":"275.63","paid_amount":"275.63","room_type_id":"413","product_id":"1260","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-11-14 23:52:50","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":"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":"3048872","reservation_id":"87153","confirmation_number":"SJ12662581426","room_stay_from":"2019-12-14","room_stay_to":"2019-12-20","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":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-11-14 23:47:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3062521","reservation_id":"83663","confirmation_number":"SJ12647040318","room_stay_from":"2019-12-15","room_stay_to":"2019-12-21","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":"318","product_id":"1282","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-09-05 18:21:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","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":"3047835","reservation_id":"86778","confirmation_number":"SJ12660828046","room_stay_from":"2019-12-16","room_stay_to":"2019-12-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"575.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"575.00","grand_total":"646.88","paid_amount":"0.00","room_type_id":"413","product_id":"1265","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-11-07 01:03:29","service_canceled_date_time":"2019-12-16 21:40:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"575.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3046437","reservation_id":"73421","confirmation_number":"SJ12637061252","room_stay_from":"2019-12-13","room_stay_to":"2019-12-20","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":"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-03-28 16:39:24","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.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":"3046451","reservation_id":"72730","confirmation_number":"SJ12674026724","room_stay_from":"2019-12-13","room_stay_to":"2019-12-20","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":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-21 16:27:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3046557","reservation_id":"72739","confirmation_number":"SJ12626401087","room_stay_from":"2019-12-13","room_stay_to":"2019-12-18","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":"1308","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 16:52:52","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":"","currentDayPrice":"82.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":"3046559","reservation_id":"73423","confirmation_number":"SJ12692989710","room_stay_from":"2019-12-13","room_stay_to":"2019-12-20","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":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-28 16:46:34","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":"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":"3046564","reservation_id":"72738","confirmation_number":"SJ12632631655","room_stay_from":"2019-12-13","room_stay_to":"2019-12-18","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":"1307","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 16:51:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.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":"3046819","reservation_id":"83411","confirmation_number":"SJ12621548891","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-08-30 00:56:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3046850","reservation_id":"85040","confirmation_number":"SJ12695690226","room_stay_from":"2019-12-14","room_stay_to":"2019-12-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.67,81.67,81.66","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"245.00","paid_amount":"245.00","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-10-03 05:19:22","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":"81.66","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":"3046856","reservation_id":"83417","confirmation_number":"SJ12634387694","room_stay_from":"2019-12-14","room_stay_to":"2019-12-19","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":"1302","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-08-30 01:40:30","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":"82.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":"3046883","reservation_id":"72044","confirmation_number":"SJ12643587619","room_stay_from":"2019-12-14","room_stay_to":"2019-12-19","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":"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-15 17:11:25","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.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":"3046934","reservation_id":"85768","confirmation_number":"SJ12654198020","room_stay_from":"2019-12-14","room_stay_to":"2019-12-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.67,81.67,81.66","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"245.00","paid_amount":"245.00","room_type_id":"319","product_id":"1303","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-10-16 23:17:19","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":"81.66","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":"3048372","reservation_id":"73893","confirmation_number":"SJ12682402090","room_stay_from":"2019-12-13","room_stay_to":"2019-12-18","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":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-04-02 21:07:59","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":"82.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":"3048597","reservation_id":"85036","confirmation_number":"SJ12682126116","room_stay_from":"2019-12-16","room_stay_to":"2019-12-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.67,81.67,81.66","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"245.00","paid_amount":"245.00","room_type_id":"319","product_id":"1306","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-10-03 05:01:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"81.67","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":"3049086","reservation_id":"72388","confirmation_number":"SJ12661094118","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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 14:48:48","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":"3063044","reservation_id":"85761","confirmation_number":"SJ12665943338","room_stay_from":"2019-12-15","room_stay_to":"2019-12-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"412","product_id":"1866","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-10-16 22:17:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.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":"3063048","reservation_id":"85764","confirmation_number":"SJ12614258973","room_stay_from":"2019-12-16","room_stay_to":"2019-12-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-10-16 22:49:42","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":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3041521","reservation_id":"87511","confirmation_number":"SJ12696862902","room_confirmation_number":"SJ12675066992","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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":"94032","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-25 19:06:37","reservation_modified_date_time":"2019-11-25 19:06:37","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":"3046438","reservation_id":"73421","confirmation_number":"SJ12624981539","room_confirmation_number":"SJ12637061252","room_stay_from":"2019-12-13","room_stay_to":"2019-12-20","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":"84252","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-28 16:39:24","reservation_modified_date_time":"2019-12-13 05:15:56","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":"3046452","reservation_id":"72730","confirmation_number":"SJ12621155700","room_confirmation_number":"SJ12674026724","room_stay_from":"2019-12-13","room_stay_to":"2019-12-20","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":"83815","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 16:27:56","reservation_modified_date_time":"2019-12-13 05:16:56","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":"3046558","reservation_id":"72739","confirmation_number":"SJ12619524285","room_confirmation_number":"SJ12626401087","room_stay_from":"2019-12-13","room_stay_to":"2019-12-18","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":"83822","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 16:52:52","reservation_modified_date_time":"2019-12-13 05:16:15","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":"3046562","reservation_id":"73423","confirmation_number":"SJ12635859721","room_confirmation_number":"SJ12692989710","room_stay_from":"2019-12-13","room_stay_to":"2019-12-20","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":"84254","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-28 16:46:34","reservation_modified_date_time":"2019-12-13 05:15:34","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":"3046566","reservation_id":"72738","confirmation_number":"SJ12692403656","room_confirmation_number":"SJ12632631655","room_stay_from":"2019-12-13","room_stay_to":"2019-12-18","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":"83822","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 16:51:37","reservation_modified_date_time":"2019-12-13 05:16:35","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3046821","reservation_id":"83411","confirmation_number":"SJ12617741870","room_confirmation_number":"SJ12621548891","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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":"90748","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-30 00:56:31","reservation_modified_date_time":"2019-12-14 05:46:19","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":"3046853","reservation_id":"85040","confirmation_number":"SJ12672997714","room_confirmation_number":"SJ12695690226","room_stay_from":"2019-12-14","room_stay_to":"2019-12-17","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":"92288","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-03 05:19:22","reservation_modified_date_time":"2019-12-14 05:32:54","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3046857","reservation_id":"83417","confirmation_number":"SJ12664673812","room_confirmation_number":"SJ12634387694","room_stay_from":"2019-12-14","room_stay_to":"2019-12-19","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":"90752","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-30 01:40:30","reservation_modified_date_time":"2019-12-14 05:34:06","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":"3046885","reservation_id":"72044","confirmation_number":"SJ12630546906","room_confirmation_number":"SJ12643587619","room_stay_from":"2019-12-14","room_stay_to":"2019-12-19","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":"83319","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-15 17:11:25","reservation_modified_date_time":"2019-12-14 13:33:35","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3046887","reservation_id":"83430","confirmation_number":"SJ12619323666","room_confirmation_number":"SJ12696199912","room_stay_from":"2019-12-14","room_stay_to":"2019-12-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"90763","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-30 12:19:17","reservation_modified_date_time":"2019-08-30 12:19:17","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","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":"3046935","reservation_id":"85768","confirmation_number":"SJ12676681461","room_confirmation_number":"SJ12654198020","room_stay_from":"2019-12-14","room_stay_to":"2019-12-17","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":"92786","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-16 23:17:19","reservation_modified_date_time":"2019-12-14 05:31:34","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":"3046959","reservation_id":"88293","confirmation_number":"SJ12630255695","room_confirmation_number":"SJ12640967678","room_stay_from":"2019-12-16","room_stay_to":"2019-12-18","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":"94573","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-14 16:40:04","reservation_modified_date_time":"2019-12-14 16:40:04","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94573","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":"3047020","reservation_id":"80994","confirmation_number":"SJ12673693548","room_confirmation_number":"SJ12634517646","room_stay_from":"2019-12-14","room_stay_to":"2019-12-17","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":"53.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"89113","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-19 03:37:20","reservation_modified_date_time":"2019-12-14 20:07:58","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":"3047078","reservation_id":"73450","confirmation_number":"SJ12672181425","room_confirmation_number":"SJ12676443078","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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":"84275","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-28 18:35:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3047087","reservation_id":"87509","confirmation_number":"SJ12676325271","room_confirmation_number":"SJ12685317846","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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":"94030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-25 19:02:15","reservation_modified_date_time":"2019-11-25 19:02:15","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":"3047246","reservation_id":"88341","confirmation_number":"SJ12613281984","room_confirmation_number":"SJ12692478219","room_stay_from":"2019-12-15","room_stay_to":"2019-12-17","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":"94596","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-15 14:27:08","reservation_modified_date_time":"2019-12-15 14:27:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94596","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":"3047650","reservation_id":"72042","confirmation_number":"SJ12689376934","room_confirmation_number":"SJ12687301125","room_stay_from":"2019-12-15","room_stay_to":"2019-12-20","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":"89.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"83317","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-15 17:07:12","reservation_modified_date_time":"2019-12-16 01:37:36","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":"3047776","reservation_id":"88391","confirmation_number":"SJ12663668837","room_confirmation_number":"SJ12686598267","room_stay_from":"2019-12-16","room_stay_to":"2019-12-18","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":"94623","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-16 18:15:20","reservation_modified_date_time":"2019-12-16 18:15:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94623","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":"3048119","reservation_id":"87154","confirmation_number":"SJ12676764975","room_confirmation_number":"SJ12654905844","room_stay_from":"2019-12-15","room_stay_to":"2019-12-17","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":"53.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"93728","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-14 23:52:50","reservation_modified_date_time":"2019-12-15 05:31:59","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":"3048373","reservation_id":"73893","confirmation_number":"SJ12635049657","room_confirmation_number":"SJ12682402090","room_stay_from":"2019-12-13","room_stay_to":"2019-12-18","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":"84522","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-02 21:07:59","reservation_modified_date_time":"2019-12-18 05:10:21","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":"3048532","reservation_id":"88392","confirmation_number":"SJ12613943693","room_confirmation_number":"SJ12618425195","room_stay_from":"2019-12-16","room_stay_to":"2019-12-18","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":"94172","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-16 18:30:43","reservation_modified_date_time":"2019-12-16 18:30:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94172","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":"3048598","reservation_id":"85036","confirmation_number":"SJ12686136032","room_confirmation_number":"SJ12682126116","room_stay_from":"2019-12-16","room_stay_to":"2019-12-19","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":"92284","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-03 05:01:01","reservation_modified_date_time":"2019-12-19 12:43:43","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":"3048874","reservation_id":"87153","confirmation_number":"SJ12691957395","room_confirmation_number":"SJ12662581426","room_stay_from":"2019-12-14","room_stay_to":"2019-12-20","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":"96.87","product_id":"1776","service_quantity":"1","customer_traveller_id":"93727","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-14 23:47:07","reservation_modified_date_time":"2019-12-20 12:49:23","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":"3048884","reservation_id":"87512","confirmation_number":"SJ12619040029","room_confirmation_number":"SJ12653752726","room_stay_from":"2019-12-14","room_stay_to":"2019-12-20","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":"93835","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-25 19:09:15","reservation_modified_date_time":"2019-11-25 19:09:15","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":"3048919","reservation_id":"83921","confirmation_number":"SJ12657136438","room_confirmation_number":"SJ12667268460","room_stay_from":"2019-12-14","room_stay_to":"2019-12-20","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":"91484","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-11 15:44:07","reservation_modified_date_time":"2019-09-11 15:44:07","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":"3049088","reservation_id":"72388","confirmation_number":"SJ12623989839","room_confirmation_number":"SJ12661094118","room_stay_from":"2019-12-14","room_stay_to":"2019-12-21","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":"83531","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-18 14:48:48","reservation_modified_date_time":"2019-12-21 15:58:43","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":"3049483","reservation_id":"86852","confirmation_number":"SJ12682638703","room_confirmation_number":"SJ12638335503","room_stay_from":"2019-12-15","room_stay_to":"2019-12-22","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":"93515","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-08 15:32:17","reservation_modified_date_time":"2019-12-22 15:16:02","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"3049659","reservation_id":"87993","confirmation_number":"SJ12688069960","room_confirmation_number":"SJ12694815975","room_stay_from":"2019-12-16","room_stay_to":"2019-12-21","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"94367","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-07 18:12:10","reservation_modified_date_time":"2019-12-23 12:16:17","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94367","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":"3062522","reservation_id":"83663","confirmation_number":"SJ12621130317","room_confirmation_number":"SJ12647040318","room_stay_from":"2019-12-15","room_stay_to":"2019-12-21","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,25.00","subtotal":"150.00","grand_total":"140.63","paid_amount":"68.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"91051","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-05 18:21:41","reservation_modified_date_time":"2020-01-28 00:07:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063045","reservation_id":"85761","confirmation_number":"SJ12659928415","room_confirmation_number":"SJ12665943338","room_stay_from":"2019-12-15","room_stay_to":"2019-12-18","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":"92779","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-16 22:17:09","reservation_modified_date_time":"2020-01-29 13:29:10","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063049","reservation_id":"85764","confirmation_number":"SJ12676881413","room_confirmation_number":"SJ12614258973","room_stay_from":"2019-12-16","room_stay_to":"2019-12-19","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":"92782","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-16 22:49:42","reservation_modified_date_time":"2020-01-29 13:32:24","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3047811","reservation_id":"87993","confirmation_number":"SJ12676867838","room_confirmation_number":"SJ12694815975","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"200.00","grand_total":"225.00","paid_amount":"0.00","product_id":"1861","service_quantity":"1","product_name":"Incidentals","parentTypeOfRes":"reservation","reservation_created_date":"2019-12-16 19:06:32","reservation_modified_date_time":"2019-12-16 19:06:39","customer_id":"94367","parentCustTravId":"94367","customer_traveller_id":"94367","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-12-21 14:24:46","canceled_nights_data":"","product_attribute_values":null,"currentDayPrice":200,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3047902","reservation_id":"88407","confirmation_number":"SJ12610475472","room_confirmation_number":"SJ12639802419","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"100.00","grand_total":"100.00","paid_amount":"100.00","product_id":null,"service_quantity":"1","product_name":"Gift Card","parentTypeOfRes":"reservation","reservation_created_date":"2019-12-17 02:40:48","reservation_modified_date_time":"2019-12-17 02:40:48","customer_id":"94637","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}