{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-01-08","total_rooms_exist":49,"departureCount":3,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"7","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2913558","reservation_id":"65959","confirmation_number":"SJ12670471274","room_stay_from":"2019-01-08","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.25,134.25","nightly_discount":"0,0","subtotal":"268.50","grand_total":"302.07","paid_amount":"302.07","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1175824996","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":"79661","customer_id":"79661","source_of_creation":"Expedia","reservation_created_date":"2019-01-08 17:46:10","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":"134.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"2913389","reservation_id":"65773","confirmation_number":"SJ12644606120","room_stay_from":"2019-01-08","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"123.63","nightly_discount":"0","subtotal":"123.63","grand_total":"171.70","paid_amount":"171.70","room_type_id":"319","product_id":"1305","siteminder_id":"ABB-HM4TE8NA3M","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"123.63","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79578","customer_id":"79578","source_of_creation":"Airbnb","reservation_created_date":"2019-01-06 20:43:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"23.09","commision_charges":"5.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.63","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"2913433","reservation_id":"65793","confirmation_number":"SJ12648534415","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"173.63,173.63","nightly_discount":"0,0","subtotal":"347.26","grand_total":"448.39","paid_amount":"448.39","room_type_id":"319","product_id":"1307","siteminder_id":"ABB-HMY8TS8F4A","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"347.26","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79583","customer_id":"79583","source_of_creation":"Airbnb","reservation_created_date":"2019-01-06 22:25:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"46.18","commision_charges":"10.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.63","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"},{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"}]},{"room_stay_id":"2913445","reservation_id":"64385","confirmation_number":"SJ12675913495","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"242.50,242.50","nightly_discount":"0,0","subtotal":"485.00","grand_total":"626.25","paid_amount":"626.25","room_type_id":"413","product_id":"1267","siteminder_id":"ABB-HMNSYF8A8M","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"485.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78996","customer_id":"78996","source_of_creation":"Airbnb","reservation_created_date":"2018-12-27 08:54:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"64.5","commision_charges":"15.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"242.50","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":"2913475","reservation_id":"62189","confirmation_number":"SJ12675398196","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"217.50,217.50","nightly_discount":"0.00,0.00","subtotal":"435.00","grand_total":"573.75","paid_amount":"573.75","room_type_id":"413","product_id":"1268","siteminder_id":"ABB-HMF4B39SSC","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"435.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"77993","customer_id":"77993","source_of_creation":"Airbnb","reservation_created_date":"2018-12-05 02:41:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"64.5","commision_charges":"15.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"217.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"},{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"}]}],"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":"2912001","reservation_id":"63934","confirmation_number":"SJ12610289675","room_stay_from":"2019-01-06","room_stay_to":"2019-01-11","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1310","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":"78819","customer_id":"78819","source_of_creation":"PMS","reservation_created_date":"2018-12-21 20:04:35","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2912974","reservation_id":"65917","confirmation_number":"SJ12648856985","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0.00,0.00","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"413","product_id":"1269","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":"79636","customer_id":"79636","source_of_creation":"PMS","reservation_created_date":"2019-01-08 02:17:03","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":"179.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":"2913890","reservation_id":"66036","confirmation_number":"SJ12638938165","room_stay_from":"2019-01-08","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"413","product_id":"1265","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":"79599","customer_id":"79599","source_of_creation":"PMS","reservation_created_date":"2019-01-09 03:11:10","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":"179.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":"2915081","reservation_id":"65252","confirmation_number":"SJ12631192793","room_stay_from":"2019-01-05","room_stay_to":"2019-01-11","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":"1277","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":"79228","customer_id":"79228","source_of_creation":"PMS","reservation_created_date":"2019-01-02 21:05:45","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":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":"2915571","reservation_id":"63656","confirmation_number":"SJ12620586098","room_stay_from":"2019-01-05","room_stay_to":"2019-01-12","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":"318","product_id":"1289","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":"74796","customer_id":"74796","source_of_creation":"PMS","reservation_created_date":"2018-12-17 15:45:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2919341","reservation_id":"63933","confirmation_number":"SJ12623310830","room_stay_from":"2019-01-05","room_stay_to":"2019-01-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,0.00,0.00,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,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":"1309","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":"78818","customer_id":"78818","source_of_creation":"PMS","reservation_created_date":"2018-12-21 19:56:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","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":"2927113","reservation_id":"60271","confirmation_number":"SJ12643127886","room_stay_from":"2019-01-05","room_stay_to":"2019-01-26","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"745.00,0.00,0.00,0.00,0.00,0.00,0.00,745.00,0.00,0.00,0.00,0.00,0.00,0.00,745.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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2235.00","grand_total":"2235.00","paid_amount":"2235.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":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"77010","customer_id":"77010","source_of_creation":"PMS","reservation_created_date":"2018-11-13 18:38:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.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":"2927581","reservation_id":"58483","confirmation_number":"SJ12699177097","room_stay_from":"2019-01-01","room_stay_to":"2019-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2772.00","grand_total":"3118.50","paid_amount":"3118.50","room_type_id":"411","product_id":"1296","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":"76112","customer_id":"76112","source_of_creation":"PMS","reservation_created_date":"2018-10-19 17:38:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 332","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"2960499","reservation_id":"59315","confirmation_number":"SJ12679746416","room_stay_from":"2019-01-05","room_stay_to":"2019-01-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"745.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":"745.00","grand_total":"745.00","paid_amount":"745.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":"1","traveller_tax_exempt":"0","customer_traveller_id":"76475","customer_id":"76475","source_of_creation":"PMS","reservation_created_date":"2018-10-30 17:51:57","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":"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":"2960510","reservation_id":"63714","confirmation_number":"SJ12668268913","room_stay_from":"2019-01-06","room_stay_to":"2019-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"745.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":"745.00","grand_total":"745.00","paid_amount":"745.00","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"76443","customer_id":"76443","source_of_creation":"PMS","reservation_created_date":"2018-12-18 16:58:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"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":"2960512","reservation_id":"63915","confirmation_number":"SJ12622117669","room_stay_from":"2019-01-06","room_stay_to":"2019-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"745.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":"745.00","grand_total":"745.00","paid_amount":"745.00","room_type_id":"319","product_id":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2018-12-21 17:02:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2960538","reservation_id":"59316","confirmation_number":"SJ12685801578","room_stay_from":"2019-01-06","room_stay_to":"2019-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"745.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":"745.00","grand_total":"745.00","paid_amount":"745.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":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"76475","customer_id":"76475","source_of_creation":"PMS","reservation_created_date":"2018-10-30 17:57:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":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":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2913391","reservation_id":"65773","confirmation_number":"SJ12614111589","room_confirmation_number":"SJ12644606120","room_stay_from":"2019-01-08","room_stay_to":"2019-01-09","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"52.50","paid_amount":"52.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"79578","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-01-08 13:46:04","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79578","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"2913476","reservation_id":"62189","confirmation_number":"SJ12644343599","room_confirmation_number":"SJ12675398196","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"52.50","paid_amount":"52.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"77993","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-01-08 14:43:44","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77993","canceled_nights_data":"","currentDayPrice":"25","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2912003","reservation_id":"63934","confirmation_number":"SJ12658429609","room_confirmation_number":"SJ12610289675","room_stay_from":"2019-01-06","room_stay_to":"2019-01-11","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"78819","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2018-12-21 20:04:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78819","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":"2912975","reservation_id":"65917","confirmation_number":"SJ12620006795","room_confirmation_number":"SJ12648856985","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","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":"79636","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-08 02:17:03","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79636","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":"2913392","reservation_id":"65773","confirmation_number":"SJ12666576287","room_confirmation_number":"SJ12644606120","room_stay_from":"2019-01-08","room_stay_to":"2019-01-09","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":"79578","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-06 20:43:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79578","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":"2913434","reservation_id":"65793","confirmation_number":"SJ12690292963","room_confirmation_number":"SJ12648534415","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","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":"79583","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-06 22:25:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79583","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":"2913447","reservation_id":"64385","confirmation_number":"SJ12696444266","room_confirmation_number":"SJ12675913495","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","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":"78996","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2018-12-27 08:54:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78996","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"2913477","reservation_id":"62189","confirmation_number":"SJ12669897338","room_confirmation_number":"SJ12675398196","room_stay_from":"2019-01-07","room_stay_to":"2019-01-09","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.20","product_id":"1776","service_quantity":"1","customer_traveller_id":"77993","product_attribute_values":"resort_fee#&#flat_rate#&#25.00","reservation_created_date":"2018-12-20 15:32:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77993","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"2913559","reservation_id":"65959","confirmation_number":"SJ12616720175","room_confirmation_number":"SJ12670471274","room_stay_from":"2019-01-08","room_stay_to":"2019-01-10","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":"79661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-08 17:46:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79661","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":"2913891","reservation_id":"66036","confirmation_number":"SJ12643656505","room_confirmation_number":"SJ12638938165","room_stay_from":"2019-01-08","room_stay_to":"2019-01-09","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":"79599","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-09 03:11:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79599","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":"2915082","reservation_id":"65252","confirmation_number":"SJ12621349791","room_confirmation_number":"SJ12631192793","room_stay_from":"2019-01-05","room_stay_to":"2019-01-11","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":"79344","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-02 21:05:45","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79228","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":"2915572","reservation_id":"63656","confirmation_number":"SJ12676982073","room_confirmation_number":"SJ12620586098","room_stay_from":"2019-01-05","room_stay_to":"2019-01-12","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":"74796","product_attribute_values":"resort_fee#&#flat_rate#&#25.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74796","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":"2919342","reservation_id":"63933","confirmation_number":"SJ12682103889","room_confirmation_number":"SJ12623310830","room_stay_from":"2019-01-05","room_stay_to":"2019-01-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,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,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":"78818","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2018-12-21 19:56:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78818","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":"2927920","reservation_id":"58483","confirmation_number":"SJ12694251644","room_confirmation_number":"SJ12699177097","room_stay_from":"2019-01-01","room_stay_to":"2019-02-01","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"76112","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-27 17:48:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76112","canceled_nights_data":"","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"}]}],"resort_fee_non_taxable":[{"room_stay_id":"2960513","reservation_id":"63915","confirmation_number":"SJ12617337409","room_confirmation_number":"SJ12622117669","room_stay_from":"2019-01-06","room_stay_to":"2019-01-13","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":"77106","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2018-12-21 17:02:41","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"77106","canceled_nights_data":"","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"}]}],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[{"room_stay_id":"2913895","reservation_id":"66038","confirmation_number":"SJ12677200501","room_confirmation_number":"SJ12639247976","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-09 03:36:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}