{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-12-23","total_rooms_exist":63,"departureCount":1,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"13","block_room_bookings":[],"bundle_block_count":"8","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3044258","reservation_id":"87822","confirmation_number":"SJ12681365226","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,359.00","nightly_discount":"0,0,0,0","subtotal":"1352.60","grand_total":"1521.68","paid_amount":"1521.68","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3165248506","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":"94262","customer_id":"94262","source_of_creation":"Booking.com","reservation_created_date":"2019-12-03 22:40:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"243.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3049629","reservation_id":"88582","confirmation_number":"SJ12699489419","room_stay_from":"2019-12-23","room_stay_to":"2019-12-25","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"269.1,269.1","nightly_discount":"0,0","subtotal":"538.20","grand_total":"605.48","paid_amount":"605.48","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2112134352","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94779","customer_id":"94779","source_of_creation":"Booking.com","reservation_created_date":"2019-12-23 03:26:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"96.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"269.1","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3042039","reservation_id":"87078","confirmation_number":"SJ12632913282","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"271.20,271.20,271.20,287.20,343.20","nightly_discount":"0,0,0,0,0","subtotal":"1444.00","grand_total":"1624.50","paid_amount":"1624.50","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1379419406","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":"93662","customer_id":"93662","source_of_creation":"Expedia","reservation_created_date":"2019-11-13 02:15:12","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":"271.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3042346","reservation_id":"87077","confirmation_number":"SJ12640846626","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"271.20,271.20,271.20,287.20,343.20","nightly_discount":"0,0,0,0,0","subtotal":"1444.00","grand_total":"1624.50","paid_amount":"1624.50","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1379419409","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":"93661","customer_id":"93661","source_of_creation":"Expedia","reservation_created_date":"2019-11-13 02:15:09","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":"271.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3049051","reservation_id":"84548","confirmation_number":"SJ12661626543","room_stay_from":"2019-12-23","room_stay_to":"2019-12-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"284.24,284.24,284.24","nightly_discount":"0,0,0","subtotal":"852.72","grand_total":"959.31","paid_amount":"959.31","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1347612303","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91921","customer_id":"91921","source_of_creation":"Expedia","reservation_created_date":"2019-09-22 23:17: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":"284.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3049811","reservation_id":"83658","confirmation_number":"SJ12669648447","room_stay_from":"2019-12-23","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"355.30,355.30,355.30,374.30,440.80,440.80,431.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2753.10","grand_total":"3097.24","paid_amount":"3097.24","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1336599694","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":"91046","customer_id":"91046","source_of_creation":"Expedia","reservation_created_date":"2019-09-05 17:47:11","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":"355.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3050439","reservation_id":"88562","confirmation_number":"SJ12689898856","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.24,189.24,181.64,350.00,350.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1260.12","grand_total":"1417.64","paid_amount":"1417.64","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1611263306","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":"94760","customer_id":"94760","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 21:07:09","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":"189.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3049504","reservation_id":"88554","confirmation_number":"SJ12652417544","room_stay_from":"2019-12-22","room_stay_to":"2019-12-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.18,142.93","nightly_discount":"0,0","subtotal":"347.11","grand_total":"390.50","paid_amount":"390.50","room_type_id":"319","product_id":"1260","siteminder_id":"HTN-112330670-MLEEAP","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":"94752","customer_id":"94752","source_of_creation":"HotelTonight","reservation_created_date":"2019-12-22 17:49:11","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":"142.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3049904","reservation_id":"88630","confirmation_number":"SJ12624789115","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.39,165.39,158.74,251.73,298.23","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1039.48","grand_total":"1169.41","paid_amount":"1169.41","room_type_id":"319","product_id":"1304","siteminder_id":"HTN-112503034-Q7LNLZ","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":"94818","customer_id":"94818","source_of_creation":"HotelTonight","reservation_created_date":"2019-12-24 02:06:07","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":"165.39","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3048980","reservation_id":"85941","confirmation_number":"SJ12667002640","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"351.58,351.58,351.58,351.58","nightly_discount":"0,0,0,0","subtotal":"1406.32","grand_total":"1864.14","paid_amount":"1864.14","room_type_id":"413","product_id":"1263","siteminder_id":"ABB-HMAB8KCHBN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"1406.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92865","customer_id":"92865","source_of_creation":"Airbnb","reservation_created_date":"2019-10-19 17:22:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 209","ota_service_fee_amount":"213.62","commision_charges":"49.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"351.58","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":"3049983","reservation_id":"87244","confirmation_number":"SJ12623760183","room_stay_from":"2019-12-21","room_stay_to":"2019-12-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"749.81,749.81,1499.61","nightly_discount":"0.00,0.00,0.00","subtotal":"2999.23","grand_total":"3872.72","paid_amount":"3872.72","room_type_id":"413","product_id":"1261","siteminder_id":"ABB-HMAPB23XN3","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"2999.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93806","customer_id":"93806","source_of_creation":"Airbnb","reservation_created_date":"2019-11-17 15:50:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"398.87","commision_charges":"92.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"1499.61","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":"3049144","reservation_id":"88520","confirmation_number":"SJ12677341205","room_stay_from":"2019-12-23","room_stay_to":"2019-12-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.10,215.10","nightly_discount":"0.00,0.00","subtotal":"430.20","grand_total":"483.98","paid_amount":"483.98","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78428","customer_id":"78428","source_of_creation":"PMS","reservation_created_date":"2019-12-21 17:52:03","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":"215.10","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":"3049972","reservation_id":"88525","confirmation_number":"SJ12675146753","room_stay_from":"2019-12-21","room_stay_to":"2019-12-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.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":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93806","customer_id":"93806","source_of_creation":"PMS","reservation_created_date":"2019-12-21 20:48:21","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":"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":"3043527","reservation_id":"87758","confirmation_number":"SJ12680317762","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-02 14:05:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3043529","reservation_id":"87759","confirmation_number":"SJ12655944302","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-02 14:07:31","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":"3043531","reservation_id":"87760","confirmation_number":"SJ12683116504","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","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-12-02 14:09:01","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":"3050659","reservation_id":"87756","confirmation_number":"SJ12660406277","room_stay_from":"2019-12-19","room_stay_to":"2019-12-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-02 14:01:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3051091","reservation_id":"87757","confirmation_number":"SJ12664033587","room_stay_from":"2019-12-21","room_stay_to":"2019-12-27","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-12-02 14:03:53","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"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3063029","reservation_id":"88227","confirmation_number":"SJ12640661925","room_stay_from":"2019-12-19","room_stay_to":"2019-12-24","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","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":"1917","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-12-13 02:02:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3048983","reservation_id":"85941","confirmation_number":"SJ12684293024","room_confirmation_number":"SJ12667002640","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"210.00","paid_amount":"210.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"92865","product_attribute_values":"extra_person#","reservation_created_date":"2019-12-20 21:39:36","reservation_modified_date_time":"2019-12-20 21:39:36","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92865","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":"3049052","reservation_id":"84548","confirmation_number":"SJ12643038974","room_confirmation_number":"SJ12661626543","room_stay_from":"2019-12-23","room_stay_to":"2019-12-26","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"91921","product_attribute_values":"extra_person#","reservation_created_date":"2019-12-21 12:11:00","reservation_modified_date_time":"2019-12-21 12:11:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91921","canceled_nights_data":"","currentDayPrice":"25","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":"3049630","reservation_id":"88582","confirmation_number":"SJ12638662037","room_confirmation_number":"SJ12699489419","room_stay_from":"2019-12-23","room_stay_to":"2019-12-25","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"94779","product_attribute_values":"extra_person#.00","reservation_created_date":"2019-12-23 03:26:08","reservation_modified_date_time":"2019-12-23 03:26:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94779","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3042040","reservation_id":"87078","confirmation_number":"SJ12638731320","room_confirmation_number":"SJ12632913282","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","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":"93662","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-13 02:15:12","reservation_modified_date_time":"2019-11-13 02:15:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93662","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":"3042347","reservation_id":"87077","confirmation_number":"SJ12687541918","room_confirmation_number":"SJ12640846626","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","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":"93661","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-13 02:15:09","reservation_modified_date_time":"2019-11-13 02:15:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93661","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":"3043528","reservation_id":"87758","confirmation_number":"SJ12637863261","room_confirmation_number":"SJ12680317762","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","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":"94202","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-02 14:05:24","reservation_modified_date_time":"2019-12-02 14:05:24","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":"3043530","reservation_id":"87759","confirmation_number":"SJ12635413580","room_confirmation_number":"SJ12655944302","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","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":"94203","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-02 14:07:31","reservation_modified_date_time":"2019-12-02 14:07:31","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":"3043532","reservation_id":"87760","confirmation_number":"SJ12612581355","room_confirmation_number":"SJ12683116504","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","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":"94204","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-02 14:09:01","reservation_modified_date_time":"2019-12-02 14:09:01","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":"3044259","reservation_id":"87822","confirmation_number":"SJ12641854105","room_confirmation_number":"SJ12681365226","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"94262","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-03 22:40:11","reservation_modified_date_time":"2019-12-03 22:40:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94262","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":"3048984","reservation_id":"85941","confirmation_number":"SJ12630088516","room_confirmation_number":"SJ12667002640","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"92865","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-10-19 17:22:08","reservation_modified_date_time":"2019-10-19 17:22:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92865","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":"3049053","reservation_id":"84548","confirmation_number":"SJ12678789504","room_confirmation_number":"SJ12661626543","room_stay_from":"2019-12-23","room_stay_to":"2019-12-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"91921","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-22 23:17:10","reservation_modified_date_time":"2019-09-22 23:17:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91921","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":"3049145","reservation_id":"88520","confirmation_number":"SJ12666705033","room_confirmation_number":"SJ12677341205","room_stay_from":"2019-12-23","room_stay_to":"2019-12-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94723","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-21 17:52:03","reservation_modified_date_time":"2019-12-21 17:52:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78428","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":"3049505","reservation_id":"88554","confirmation_number":"SJ12676793424","room_confirmation_number":"SJ12652417544","room_stay_from":"2019-12-22","room_stay_to":"2019-12-24","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":"94752","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-22 17:49:11","reservation_modified_date_time":"2019-12-22 17:49:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94752","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":"3049631","reservation_id":"88582","confirmation_number":"SJ12618702770","room_confirmation_number":"SJ12699489419","room_stay_from":"2019-12-23","room_stay_to":"2019-12-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94779","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-23 03:26:08","reservation_modified_date_time":"2019-12-23 03:26:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94779","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":"3049812","reservation_id":"83658","confirmation_number":"SJ12629013572","room_confirmation_number":"SJ12669648447","room_stay_from":"2019-12-23","room_stay_to":"2019-12-30","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":"91046","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-05 17:47:11","reservation_modified_date_time":"2019-09-05 17:47:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91046","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":"3049974","reservation_id":"88525","confirmation_number":"SJ12633640939","room_confirmation_number":"SJ12675146753","room_stay_from":"2019-12-21","room_stay_to":"2019-12-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"93806","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-21 20:48:21","reservation_modified_date_time":"2019-12-21 20:48:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93806","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":"3049985","reservation_id":"87244","confirmation_number":"SJ12635861870","room_confirmation_number":"SJ12623760183","room_stay_from":"2019-12-21","room_stay_to":"2019-12-24","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":"93806","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-17 15:50:09","reservation_modified_date_time":"2019-12-24 16:19:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93806","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":"3050441","reservation_id":"88562","confirmation_number":"SJ12660353055","room_confirmation_number":"SJ12689898856","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","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":"94760","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-22 21:07:09","reservation_modified_date_time":"2019-12-25 21:43:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94760","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":"3050660","reservation_id":"87756","confirmation_number":"SJ12657328991","room_confirmation_number":"SJ12660406277","room_stay_from":"2019-12-19","room_stay_to":"2019-12-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"94200","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-02 14:01:33","reservation_modified_date_time":"2019-12-02 14:01:33","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":"3051092","reservation_id":"87757","confirmation_number":"SJ12615523774","room_confirmation_number":"SJ12664033587","room_stay_from":"2019-12-21","room_stay_to":"2019-12-27","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":"94201","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-02 14:03:53","reservation_modified_date_time":"2019-12-02 14:03:53","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":"3063030","reservation_id":"88227","confirmation_number":"SJ12666386989","room_confirmation_number":"SJ12640661925","room_stay_from":"2019-12-19","room_stay_to":"2019-12-24","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":"94536","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-13 02:02:50","reservation_modified_date_time":"2020-01-29 12:44:44","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":[],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3049838","reservation_id":"88624","confirmation_number":"SJ12652465902","room_confirmation_number":"SJ12669436752","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2019-12-23 21:57:32","reservation_modified_date_time":"2019-12-23 21:57:32","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}