{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-02-13","total_rooms_exist":49,"departureCount":16,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"18","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2868827","reservation_id":"56181","confirmation_number":"SJ12637611281","room_stay_from":"2019-02-02","room_stay_to":"2019-02-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,193.00,193.00,193.00,193.00,193.00,215.00,215.00,193.00,193.00,193.00,193.00,193.00,215.00,215.00,193.00,193.00,193.00,193.00,193.00,215.00,215.00,193.00","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","subtotal":"4593.00","grand_total":"5167.13","paid_amount":"5167.13","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-1735826395","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":"74985","customer_id":"74985","source_of_creation":"Booking.com","reservation_created_date":"2018-09-12 21:05:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"826.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"193.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2930716","reservation_id":"68311","confirmation_number":"SJ12664323853","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"242.19,242.19","nightly_discount":"0,0","subtotal":"484.38","grand_total":"544.93","paid_amount":"544.93","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-1673564237","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":"81278","customer_id":"81278","source_of_creation":"Booking.com","reservation_created_date":"2019-02-01 14:18:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"87.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"242.19","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":"2930720","reservation_id":"65994","confirmation_number":"SJ12634533606","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"259.20,269.10","nightly_discount":"0,0","subtotal":"528.30","grand_total":"594.34","paid_amount":"594.34","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-1996869998","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":"79676","customer_id":"79676","source_of_creation":"Booking.com","reservation_created_date":"2019-01-08 21:22:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"95.09","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"269.10","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":"2931953","reservation_id":"68413","confirmation_number":"SJ12651296720","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"219.60,246.60","nightly_discount":"0,0","subtotal":"466.20","grand_total":"524.48","paid_amount":"524.48","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-1941058500","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":"81336","customer_id":"81336","source_of_creation":"Booking.com","reservation_created_date":"2019-02-02 17:40:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"83.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"219.60","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":"2932194","reservation_id":"68800","confirmation_number":"SJ12692960213","room_stay_from":"2019-02-12","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.10,197.10,224.10,251.10,251.10,233.10,233.10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1586.70","grand_total":"1785.04","paid_amount":"1785.04","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-1956060997","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":"81546","customer_id":"81546","source_of_creation":"Booking.com","reservation_created_date":"2019-02-06 22:50:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"285.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"197.10","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":"2932243","reservation_id":"68812","confirmation_number":"SJ12664168598","room_stay_from":"2019-02-13","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.10,224.10,224.10","nightly_discount":"0,0,0","subtotal":"672.30","grand_total":"756.34","paid_amount":"756.34","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2040842062","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":"81550","customer_id":"81550","source_of_creation":"Booking.com","reservation_created_date":"2019-02-07 00:45:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"121.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"224.10","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":"2932727","reservation_id":"68628","confirmation_number":"SJ12669259461","room_stay_from":"2019-02-09","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00,249.00,249.00,249.00,249.00","nightly_discount":"0,0,0,0,0","subtotal":"1245.00","grand_total":"1400.63","paid_amount":"1400.63","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-1538749798","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":"81444","customer_id":"81444","source_of_creation":"Booking.com","reservation_created_date":"2019-02-04 21:12:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"224.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"249.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2934153","reservation_id":"68899","confirmation_number":"SJ12663447271","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00,249.00","nightly_discount":"0,0","subtotal":"498.00","grand_total":"560.25","paid_amount":"560.25","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-1367716912","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":"81597","customer_id":"81597","source_of_creation":"Booking.com","reservation_created_date":"2019-02-08 03:28:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"89.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"249.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2934225","reservation_id":"68604","confirmation_number":"SJ12699024047","room_stay_from":"2019-02-12","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00,249.00,249.00","nightly_discount":"0,0,0","subtotal":"747.00","grand_total":"840.38","paid_amount":"840.38","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-1800886629","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":"81430","customer_id":"81430","source_of_creation":"Booking.com","reservation_created_date":"2019-02-04 16:54:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"134.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"249.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2934833","reservation_id":"68998","confirmation_number":"SJ12696159305","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"319","product_id":"1303","siteminder_id":"BDC-1546309627","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":"81649","customer_id":"81649","source_of_creation":"Booking.com","reservation_created_date":"2019-02-09 16:08:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","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"}]},{"room_stay_id":"2935000","reservation_id":"69324","confirmation_number":"SJ12671416641","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"219.00,219.00","nightly_discount":"0,0","subtotal":"438.00","grand_total":"492.75","paid_amount":"492.75","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-1469919298","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":"81816","customer_id":"81816","source_of_creation":"Booking.com","reservation_created_date":"2019-02-12 22:18:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"39.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"219.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2935214","reservation_id":"69370","confirmation_number":"SJ12692225423","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.10,224.10","nightly_discount":"0,0","subtotal":"448.20","grand_total":"504.23","paid_amount":"504.23","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-1793187263","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":"81840","customer_id":"81840","source_of_creation":"Booking.com","reservation_created_date":"2019-02-13 14:05:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"40.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"224.10","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":"2935302","reservation_id":"69289","confirmation_number":"SJ12647716504","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.10,224.10","nightly_discount":"0,0","subtotal":"448.20","grand_total":"504.23","paid_amount":"504.23","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-1448611077","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":"81790","customer_id":"81790","source_of_creation":"Booking.com","reservation_created_date":"2019-02-12 13:48:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"80.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"224.10","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":"2937101","reservation_id":"62166","confirmation_number":"SJ12688581085","room_stay_from":"2019-02-13","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"349.00,381.00,402.00,402.00,381.00,349.00","nightly_discount":"0,0,0,0,0,0","subtotal":"2264.00","grand_total":"2547.00","paid_amount":"2547.00","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-1474007297","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":"78594","customer_id":"78594","source_of_creation":"Booking.com","reservation_created_date":"2018-12-04 20:42:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"407.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"349.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2937858","reservation_id":"56337","confirmation_number":"SJ12657923994","room_stay_from":"2019-02-10","room_stay_to":"2019-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.00,189.00,241.00,241.00,241.00,219.00,219.00,189.00,189.00,189.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2106.00","grand_total":"2369.25","paid_amount":"2369.25","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-1779250561","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":"75054","customer_id":"75054","source_of_creation":"Booking.com","reservation_created_date":"2018-09-15 12:20:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"379.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"241.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2931412","reservation_id":"68539","confirmation_number":"SJ12622929058","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.20,175.20","nightly_discount":"0,0","subtotal":"350.40","grand_total":"394.20","paid_amount":"394.20","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1191338038","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":"81388","customer_id":"81388","source_of_creation":"Expedia","reservation_created_date":"2019-02-03 16:39:08","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":"175.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":"2934566","reservation_id":"69122","confirmation_number":"SJ12617746030","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00,249.00","nightly_discount":"0,0","subtotal":"498.00","grand_total":"560.25","paid_amount":"560.25","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1195571709","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":"81695","customer_id":"81695","source_of_creation":"Expedia","reservation_created_date":"2019-02-10 16:24: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":"249.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2934765","reservation_id":"68920","confirmation_number":"SJ12692080500","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00,249.00","nightly_discount":"0,0","subtotal":"498.00","grand_total":"560.25","paid_amount":"560.25","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1194526056","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":"81611","customer_id":"81611","source_of_creation":"Expedia","reservation_created_date":"2019-02-08 17:15:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"249.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2935352","reservation_id":"69387","confirmation_number":"SJ12697790597","room_stay_from":"2019-02-13","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.20","nightly_discount":"0","subtotal":"199.20","grand_total":"224.10","paid_amount":"224.10","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1197709010","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":"81854","customer_id":"81854","source_of_creation":"Expedia","reservation_created_date":"2019-02-13 18:15:08","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":"199.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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2932218","reservation_id":"68806","confirmation_number":"SJ12657826033","room_stay_from":"2019-02-07","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.95,154.95,154.95,154.95,154.95,154.95,154.95","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1084.65","grand_total":"1220.23","paid_amount":"1220.23","room_type_id":"318","product_id":"1282","siteminder_id":"HTN-75509658-WN3T2C","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":"81549","customer_id":"81549","source_of_creation":"HotelTonight","reservation_created_date":"2019-02-07 00:00:07","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":"154.95","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":"2934473","reservation_id":"69216","confirmation_number":"SJ12698542007","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.46,145.46","nightly_discount":"0,0","subtotal":"290.92","grand_total":"327.29","paid_amount":"327.29","room_type_id":"411","product_id":"1296","siteminder_id":"HTN-75963594-9JK2MP","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":"81751","customer_id":"81751","source_of_creation":"HotelTonight","reservation_created_date":"2019-02-11 20:11:09","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":"145.46","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":"2935060","reservation_id":"69352","confirmation_number":"SJ12681475988","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.39,165.39","nightly_discount":"0,0","subtotal":"330.78","grand_total":"372.13","paid_amount":"372.13","room_type_id":"319","product_id":"1306","siteminder_id":"HTN-76094901-QL96V6","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":"81827","customer_id":"81827","source_of_creation":"HotelTonight","reservation_created_date":"2019-02-13 03:01:09","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":"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":"2934352","reservation_id":"69200","confirmation_number":"SJ12634894685","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"226.23,226.23,226.23,226.23","nightly_discount":"0,0,0,0","subtotal":"904.92","grand_total":"1192.59","paid_amount":"1192.59","room_type_id":"319","product_id":"1307","siteminder_id":"ABB-HM8HCW3SER","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"904.92","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81741","customer_id":"81741","source_of_creation":"Airbnb","reservation_created_date":"2019-02-11 15:12:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"133.64","commision_charges":"31.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"226.23","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":"2934831","reservation_id":"68227","confirmation_number":"SJ12633628423","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.43,212.43","nightly_discount":"0,0","subtotal":"424.86","grand_total":"548.59","paid_amount":"548.59","room_type_id":"319","product_id":"1308","siteminder_id":"ABB-HMZ8F2NZW9","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"424.86","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81225","customer_id":"81225","source_of_creation":"Airbnb","reservation_created_date":"2019-01-31 03:30:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"56.5","commision_charges":"13.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"212.43","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":"2935123","reservation_id":"69213","confirmation_number":"SJ12627585632","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"201.98,201.98","nightly_discount":"0,0","subtotal":"403.96","grand_total":"533.68","paid_amount":"533.68","room_type_id":"319","product_id":"1276","siteminder_id":"ABB-HMKBEQSAEH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"403.96","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81748","customer_id":"81748","source_of_creation":"Airbnb","reservation_created_date":"2019-02-11 18:58:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"60.38","commision_charges":"14.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"201.98","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":"2935362","reservation_id":"67879","confirmation_number":"SJ12669074724","room_stay_from":"2019-02-13","room_stay_to":"2019-02-17","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"241.53,241.53,241.53,241.53","nightly_discount":"0,0,0,0","subtotal":"966.12","grand_total":"1247.49","paid_amount":"1247.49","room_type_id":"413","product_id":"1260","siteminder_id":"ABB-HMDBXXDPR4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"966.12","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80968","customer_id":"80968","source_of_creation":"Airbnb","reservation_created_date":"2019-01-26 20:13:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"128.48","commision_charges":"29.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"241.53","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2927748","reservation_id":"67987","confirmation_number":"SJ12677844050","room_stay_from":"2019-02-13","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00,249.00,249.00","nightly_discount":"0.00,0.00,0.00","subtotal":"747.00","grand_total":"840.38","paid_amount":"840.38","room_type_id":"413","product_id":"1267","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":"81053","customer_id":"81053","source_of_creation":"FE","reservation_created_date":"2019-01-28 00:58:01","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":"249.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2932822","reservation_id":"67556","confirmation_number":"SJ12633447448","room_stay_from":"2019-02-10","room_stay_to":"2019-02-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"866.67,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":"866.67","grand_total":"975.00","paid_amount":"975.00","room_type_id":"319","product_id":"1291","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":"80751","customer_id":"80751","source_of_creation":"PMS","reservation_created_date":"2019-01-22 18:03:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","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":"2934221","reservation_id":"66380","confirmation_number":"SJ12671680957","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.43,266.43,277.13,309.23","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1119.22","grand_total":"1259.12","paid_amount":"1259.12","room_type_id":"413","product_id":"1266","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":"80105","customer_id":"80105","source_of_creation":"PMS","reservation_created_date":"2019-01-11 20:54:49","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":"277.13","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":"2934583","reservation_id":"69240","confirmation_number":"SJ12687867830","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.00,190.00,190.00,190.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"760.00","grand_total":"855.00","paid_amount":"855.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":"0","traveller_tax_exempt":"0","customer_traveller_id":"77890","customer_id":"77890","source_of_creation":"PMS","reservation_created_date":"2019-02-11 23:11:11","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":"190.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":"2934842","reservation_id":"69227","confirmation_number":"SJ12640908191","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"219.00,219.00,219.00,219.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"876.00","grand_total":"985.50","paid_amount":"985.50","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":"81759","customer_id":"81759","source_of_creation":"PMS","reservation_created_date":"2019-02-11 21:14:07","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":"219.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":"2935168","reservation_id":"69338","confirmation_number":"SJ12627469642","room_stay_from":"2019-02-13","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"219.20","nightly_discount":"0.00","subtotal":"219.20","grand_total":"246.60","paid_amount":"246.60","room_type_id":"318","product_id":"1281","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":"81821","customer_id":"81821","source_of_creation":"PMS","reservation_created_date":"2019-02-13 00:16:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"219.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2935185","reservation_id":"69377","confirmation_number":"SJ12640181282","room_stay_from":"2019-02-13","room_stay_to":"2019-02-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00","nightly_discount":"0.00","subtotal":"249.00","grand_total":"280.13","paid_amount":"280.13","room_type_id":"319","product_id":"1288","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":"81847","customer_id":"81847","source_of_creation":"PMS","reservation_created_date":"2019-02-13 16:11:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"249.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":"2935208","reservation_id":"68794","confirmation_number":"SJ12630157965","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"225.00,225.00","nightly_discount":"0.00,0.00","subtotal":"450.00","grand_total":"506.25","paid_amount":"506.25","room_type_id":"413","product_id":"1272","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":"74747","customer_id":"74747","source_of_creation":"PMS","reservation_created_date":"2019-02-06 22:08:45","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":"225.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":"2935304","reservation_id":"69378","confirmation_number":"SJ12663801549","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.00,202.00","nightly_discount":"0.00,0.00","subtotal":"404.00","grand_total":"454.50","paid_amount":"454.50","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"81848","customer_id":"81848","source_of_creation":"PMS","reservation_created_date":"2019-02-13 16:13:48","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":"202.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":"2917424","reservation_id":"66792","confirmation_number":"SJ12664291990","room_stay_from":"2019-02-09","room_stay_to":"2019-02-16","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":"1","customer_traveller_id":"79228","customer_id":"79228","source_of_creation":"PMS","reservation_created_date":"2019-01-14 19:54: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":"2927164","reservation_id":"65515","confirmation_number":"SJ12623441833","room_stay_from":"2019-02-09","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"1155.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":"1155.00","grand_total":"1155.00","paid_amount":"1155.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":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2019-01-04 20:30:25","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":"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":"2934023","reservation_id":"69145","confirmation_number":"SJ12661910883","room_stay_from":"2019-02-10","room_stay_to":"2019-02-15","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":"1302","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":"79228","customer_id":"79228","source_of_creation":"PMS","reservation_created_date":"2019-02-10 21:54:19","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":true,"taxes":[]},{"room_stay_id":"2935893","reservation_id":"60456","confirmation_number":"SJ12672666189","room_stay_from":"2019-02-09","room_stay_to":"2019-02-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"1155.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":"1155.00","grand_total":"1155.00","paid_amount":"1155.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":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2018-11-16 13:08:07","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":"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":"2930718","reservation_id":"68311","confirmation_number":"SJ12649630440","room_confirmation_number":"SJ12664323853","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"81278","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-02-03 18:47:28","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81278","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"}]},{"room_stay_id":"2934354","reservation_id":"69200","confirmation_number":"SJ12617492017","room_confirmation_number":"SJ12634894685","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"105.00","paid_amount":"105.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"81741","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-02-11 15:43:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81741","canceled_nights_data":"","currentDayPrice":"25","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":"2934834","reservation_id":"68998","confirmation_number":"SJ12644360420","room_confirmation_number":"SJ12696159305","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81649","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-02-12 17:49:50","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81649","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"}]},{"room_stay_id":"2934844","reservation_id":"69227","confirmation_number":"SJ12655802748","room_confirmation_number":"SJ12640908191","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","room_stay_status":"Active","nightly_price":"25.00,25.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"81759","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-02-12 17:51:26","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81759","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":"2935124","reservation_id":"69213","confirmation_number":"SJ12650212440","room_confirmation_number":"SJ12627585632","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"52.50","paid_amount":"52.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"81748","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-02-13 12:34:56","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81748","canceled_nights_data":"","currentDayPrice":"25","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":"2937102","reservation_id":"62166","confirmation_number":"SJ12637830103","room_confirmation_number":"SJ12688581085","room_stay_from":"2019-02-13","room_stay_to":"2019-02-19","room_stay_status":"Active","nightly_price":"50,50,50,50,50,50","nightly_discount":"0,0,0,0,0,0","subtotal":"300.00","grand_total":"337.50","paid_amount":"337.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"78594","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-02-18 10:35:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78594","canceled_nights_data":"","currentDayPrice":"50","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2899661","reservation_id":"56181","confirmation_number":"SJ12685794143","room_confirmation_number":"SJ12637611281","room_stay_from":"2019-02-02","room_stay_to":"2019-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","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","subtotal":"575.00","grand_total":"646.88","paid_amount":"646.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"74985","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":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74985","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2927166","reservation_id":"65515","confirmation_number":"SJ12693833590","room_confirmation_number":"SJ12623441833","room_stay_from":"2019-02-09","room_stay_to":"2019-02-16","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":"79463","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-04 20:30:25","reservation_modified_date_time":"0000-00-00 00:00:00","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":"2927749","reservation_id":"67987","confirmation_number":"SJ12628778185","room_confirmation_number":"SJ12677844050","room_stay_from":"2019-02-13","room_stay_to":"2019-02-16","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":"81054","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-28 00:58:01","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81053","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":"2930719","reservation_id":"68311","confirmation_number":"SJ12688788121","room_confirmation_number":"SJ12664323853","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"81278","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-01 14:18:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81278","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":"2930721","reservation_id":"65994","confirmation_number":"SJ12611233134","room_confirmation_number":"SJ12634533606","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"79676","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-08 21:22:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79676","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":"2931413","reservation_id":"68539","confirmation_number":"SJ12660251114","room_confirmation_number":"SJ12622929058","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"81388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-03 16:39:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81388","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":"2931954","reservation_id":"68413","confirmation_number":"SJ12649502369","room_confirmation_number":"SJ12651296720","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81336","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-02 17:40:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81336","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":"2932195","reservation_id":"68800","confirmation_number":"SJ12678597120","room_confirmation_number":"SJ12692960213","room_stay_from":"2019-02-12","room_stay_to":"2019-02-19","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":"81546","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-06 22:50:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81546","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":"2932219","reservation_id":"68806","confirmation_number":"SJ12699751839","room_confirmation_number":"SJ12657826033","room_stay_from":"2019-02-07","room_stay_to":"2019-02-14","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":"81549","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-07 00:00:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81549","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":"2932244","reservation_id":"68812","confirmation_number":"SJ12697093862","room_confirmation_number":"SJ12664168598","room_stay_from":"2019-02-13","room_stay_to":"2019-02-16","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":"81550","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-07 00:45:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81550","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":"2932729","reservation_id":"68628","confirmation_number":"SJ12670173541","room_confirmation_number":"SJ12669259461","room_stay_from":"2019-02-09","room_stay_to":"2019-02-14","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":"81444","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-04 21:12:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81444","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":"2932823","reservation_id":"67556","confirmation_number":"SJ12671599219","room_confirmation_number":"SJ12633447448","room_stay_from":"2019-02-10","room_stay_to":"2019-02-17","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":"80751","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-22 18:03:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80751","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":"2934024","reservation_id":"69145","confirmation_number":"SJ12622723702","room_confirmation_number":"SJ12661910883","room_stay_from":"2019-02-10","room_stay_to":"2019-02-15","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":"81712","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-10 21:54:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","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":"2934154","reservation_id":"68899","confirmation_number":"SJ12622591040","room_confirmation_number":"SJ12663447271","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"81597","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-08 03:28:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81597","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":"2934224","reservation_id":"66380","confirmation_number":"SJ12641183958","room_confirmation_number":"SJ12671680957","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","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":"80105","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-11 20:54:49","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80105","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":"2934227","reservation_id":"68604","confirmation_number":"SJ12652682152","room_confirmation_number":"SJ12699024047","room_stay_from":"2019-02-12","room_stay_to":"2019-02-15","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":"81430","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-04 16:54:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81430","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":"2934355","reservation_id":"69200","confirmation_number":"SJ12648086576","room_confirmation_number":"SJ12634894685","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","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":"81741","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-11 15:12: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":"81741","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":"2934474","reservation_id":"69216","confirmation_number":"SJ12612900496","room_confirmation_number":"SJ12698542007","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"81751","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-11 20:11:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81751","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":"2934567","reservation_id":"69122","confirmation_number":"SJ12618484316","room_confirmation_number":"SJ12617746030","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81695","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-10 16:24:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81695","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":"2934584","reservation_id":"69240","confirmation_number":"SJ12626068116","room_confirmation_number":"SJ12687867830","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","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":"77890","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-11 23:11:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77890","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":"2934766","reservation_id":"68920","confirmation_number":"SJ12643640578","room_confirmation_number":"SJ12692080500","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"81611","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-08 17:15:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81611","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":"2934832","reservation_id":"68227","confirmation_number":"SJ12659090814","room_confirmation_number":"SJ12633628423","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"81225","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-31 03:30: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":"81225","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":"2934835","reservation_id":"68998","confirmation_number":"SJ12692893037","room_confirmation_number":"SJ12696159305","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-09 16:08:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81649","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":"2934843","reservation_id":"69227","confirmation_number":"SJ12642325900","room_confirmation_number":"SJ12640908191","room_stay_from":"2019-02-11","room_stay_to":"2019-02-15","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":"81759","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-11 21:14:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81759","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":"2935001","reservation_id":"69324","confirmation_number":"SJ12693131127","room_confirmation_number":"SJ12671416641","room_stay_from":"2019-02-12","room_stay_to":"2019-02-14","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":"81816","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-12 22:18:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81816","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":"2935061","reservation_id":"69352","confirmation_number":"SJ12642172370","room_confirmation_number":"SJ12681475988","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-13 03:01:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81827","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":"2935125","reservation_id":"69213","confirmation_number":"SJ12649996280","room_confirmation_number":"SJ12627585632","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81748","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-11 18:58: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":"81748","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":"2935169","reservation_id":"69338","confirmation_number":"SJ12680138562","room_confirmation_number":"SJ12627469642","room_stay_from":"2019-02-13","room_stay_to":"2019-02-14","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":"81821","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-13 00:16:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81821","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":"2935186","reservation_id":"69377","confirmation_number":"SJ12678998159","room_confirmation_number":"SJ12640181282","room_stay_from":"2019-02-13","room_stay_to":"2019-02-14","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":"81847","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-13 16:11:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81847","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":"2935209","reservation_id":"68794","confirmation_number":"SJ12683429709","room_confirmation_number":"SJ12630157965","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"74747","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-06 22:08:45","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74747","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":"2935215","reservation_id":"69370","confirmation_number":"SJ12671209943","room_confirmation_number":"SJ12692225423","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81840","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-13 14:05:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81840","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"2935303","reservation_id":"69289","confirmation_number":"SJ12611843471","room_confirmation_number":"SJ12647716504","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81790","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-12 13:48:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81790","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":"2935305","reservation_id":"69378","confirmation_number":"SJ12691973820","room_confirmation_number":"SJ12663801549","room_stay_from":"2019-02-13","room_stay_to":"2019-02-15","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":"81848","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-13 16:13:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81848","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"-50.00","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":"2935353","reservation_id":"69387","confirmation_number":"SJ12675109363","room_confirmation_number":"SJ12697790597","room_stay_from":"2019-02-13","room_stay_to":"2019-02-14","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":"81854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-13 18:15:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81854","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":"2935363","reservation_id":"67879","confirmation_number":"SJ12678929270","room_confirmation_number":"SJ12669074724","room_stay_from":"2019-02-13","room_stay_to":"2019-02-17","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":"80968","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-26 20:13: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":"80968","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":"2935894","reservation_id":"60456","confirmation_number":"SJ12663601021","room_confirmation_number":"SJ12672666189","room_stay_from":"2019-02-09","room_stay_to":"2019-02-15","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":"77105","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-12 16:44:00","reservation_modified_date_time":"0000-00-00 00:00:00","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":"2937103","reservation_id":"62166","confirmation_number":"SJ12684862366","room_confirmation_number":"SJ12688581085","room_stay_from":"2019-02-13","room_stay_to":"2019-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"78594","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":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78594","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2937859","reservation_id":"56337","confirmation_number":"SJ12615680735","room_confirmation_number":"SJ12657923994","room_stay_from":"2019-02-10","room_stay_to":"2019-02-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,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,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"75054","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":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75054","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":"2937802","reservation_id":"69396","confirmation_number":"SJ12658827463","room_confirmation_number":"SJ12612259938","room_stay_from":"2019-02-16","room_stay_to":"2019-02-21","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":"81861","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-13 21:40:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"2917425","reservation_id":"66792","confirmation_number":"SJ12644972438","room_confirmation_number":"SJ12664291990","room_stay_from":"2019-02-09","room_stay_to":"2019-02-16","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":"79228","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-14 19:54:31","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"79228","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":[{"room_stay_id":"2935555","reservation_id":"68806","confirmation_number":"SJ12651193922","room_confirmation_number":"SJ12657826033","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.00","grand_total":"4.00","paid_amount":"4.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:18:20","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81549","parentCustTravId":"81549","customer_traveller_id":"81549","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"1","currentDayPrice":"4.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2935503","reservation_id":"69402","confirmation_number":"SJ12634652129","room_confirmation_number":"SJ12674329751","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.00","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-13 22:46:53","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2935524","reservation_id":"69410","confirmation_number":"SJ12652506403","room_confirmation_number":"SJ12643501505","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 00:39:52","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2935532","reservation_id":"69411","confirmation_number":"SJ12632006653","room_confirmation_number":"SJ12680239014","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 01:14:16","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2935562","reservation_id":"69424","confirmation_number":"SJ12612061441","room_confirmation_number":"SJ12656161365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:23:33","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[{"room_stay_id":"2935537","reservation_id":"69352","confirmation_number":"SJ12683845615","room_confirmation_number":"SJ12681475988","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":"1620","service_quantity":"2","product_name":"Bottled Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 01:37:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81827","parentCustTravId":"81827","customer_traveller_id":"81827","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935538","reservation_id":"69352","confirmation_number":"SJ12648835803","room_confirmation_number":"SJ12681475988","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.85","grand_total":"6.00","paid_amount":"6.00","product_id":"1425","service_quantity":"3","product_name":"Soda","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 01:37:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81827","parentCustTravId":"81827","customer_traveller_id":"81827","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"5.55","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935556","reservation_id":"68806","confirmation_number":"SJ12624844879","room_confirmation_number":"SJ12657826033","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.71","grand_total":"4.00","paid_amount":"4.00","product_id":"1350","service_quantity":"1","product_name":"Bud Light Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:18:20","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81549","parentCustTravId":"81549","customer_traveller_id":"81549","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"3.71","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935557","reservation_id":"68806","confirmation_number":"SJ12669052068","room_confirmation_number":"SJ12657826033","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"7.00","paid_amount":"7.00","product_id":"1417","service_quantity":"1","product_name":"Rum Punch","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:18:20","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81549","parentCustTravId":"81549","customer_traveller_id":"81549","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935517","reservation_id":"69409","confirmation_number":"SJ12620733524","room_confirmation_number":"SJ12682676359","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.71","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Budweiser","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 00:29:13","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.71","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935523","reservation_id":"69411","confirmation_number":"SJ12675624945","room_confirmation_number":"SJ12680239014","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 00:39:17","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935531","reservation_id":"69414","confirmation_number":"SJ12659220896","room_confirmation_number":"SJ12667602367","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.71","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Budweiser","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 01:04:10","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.71","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935542","reservation_id":"69417","confirmation_number":"SJ12650960349","room_confirmation_number":"SJ12621935497","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.71","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Budweiser","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 01:52:51","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.71","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935547","reservation_id":"69419","confirmation_number":"SJ12690010854","room_confirmation_number":"SJ12635683595","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Titos","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 02:49:05","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935548","reservation_id":"69419","confirmation_number":"SJ12689614867","room_confirmation_number":"SJ12635683595","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Sandbar Sunday Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 02:49:05","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935551","reservation_id":"69421","confirmation_number":"SJ12616690988","room_confirmation_number":"SJ12654850077","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"Fireball","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:06:17","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935553","reservation_id":"69422","confirmation_number":"SJ12686750587","room_confirmation_number":"SJ12695069834","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.71","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"4","product_name":"Miller Lite","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:14:08","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"14.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935554","reservation_id":"69422","confirmation_number":"SJ12642858735","room_confirmation_number":"SJ12695069834","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.71","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"4","product_name":"Budweiser","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:14:08","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"14.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2935563","reservation_id":"69424","confirmation_number":"SJ12631984814","room_confirmation_number":"SJ12656161365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"5","product_name":"Jack Daniels","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:23:33","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"27.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"bar_non_taxable":[],"restaurant_taxable":[{"room_stay_id":"2935539","reservation_id":"69352","confirmation_number":"SJ12644568475","room_confirmation_number":"SJ12681475988","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"14.88","grand_total":"16.00","paid_amount":"16.00","product_id":"1544","service_quantity":"1","product_name":"Margherita pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 01:37:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81827","parentCustTravId":"81827","customer_traveller_id":"81827","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935540","reservation_id":"69352","confirmation_number":"SJ12645216510","room_confirmation_number":"SJ12681475988","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.44","grand_total":"8.00","paid_amount":"8.00","product_id":"1649","service_quantity":"1","product_name":"Kids Pepperoni pizza 8\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 01:37:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"81827","parentCustTravId":"81827","customer_traveller_id":"81827","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935500","reservation_id":"69402","confirmation_number":"SJ12662687960","room_confirmation_number":"SJ12674329751","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"16.74","grand_total":"18.00","paid_amount":"18.00","product_id":null,"service_quantity":"1","product_name":"Hawaiian pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-13 22:45:54","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":"16.74","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935507","reservation_id":"69405","confirmation_number":"SJ12661091516","room_confirmation_number":"SJ12661256147","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"16.74","grand_total":"18.00","paid_amount":"18.00","product_id":null,"service_quantity":"1","product_name":"Hawaiian pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-13 23:16:53","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":"16.74","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935509","reservation_id":"69406","confirmation_number":"SJ12637352118","room_confirmation_number":"SJ12677312054","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"14.88","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"1","product_name":"Gluten Free pizza 10\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-13 23:32:44","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":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935510","reservation_id":"69406","confirmation_number":"SJ12617828969","room_confirmation_number":"SJ12677312054","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.02","grand_total":"14.00","paid_amount":"14.00","product_id":null,"service_quantity":"1","product_name":"Gluten Free pizza 10\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-13 23:32:44","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":"13.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935514","reservation_id":"69408","confirmation_number":"SJ12626020531","room_confirmation_number":"SJ12660989076","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"14.88","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"1","product_name":"Pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 00:19:00","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":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935519","reservation_id":"69410","confirmation_number":"SJ12642695829","room_confirmation_number":"SJ12643501505","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.37","grand_total":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"1","product_name":"Kids Cheese pizza 8\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 00:38:40","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":"8.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935520","reservation_id":"69410","confirmation_number":"SJ12653752513","room_confirmation_number":"SJ12643501505","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"18.60","grand_total":"20.00","paid_amount":"20.00","product_id":null,"service_quantity":"1","product_name":"Supreme pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 00:38:40","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":"18.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935521","reservation_id":"69410","confirmation_number":"SJ12613985561","room_confirmation_number":"SJ12643501505","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.51","grand_total":"35.00","paid_amount":"35.00","product_id":null,"service_quantity":"5","product_name":"Chicken wings","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 00:38:40","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":"32.55","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935546","reservation_id":"69419","confirmation_number":"SJ12679242471","room_confirmation_number":"SJ12635683595","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.51","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Chicken wings","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 02:49:05","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":"6.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935564","reservation_id":"69424","confirmation_number":"SJ12687578436","room_confirmation_number":"SJ12656161365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.51","grand_total":"7.00","paid_amount":"7.00","product_id":null,"service_quantity":"1","product_name":"Chicken wings","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:23:33","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":"6.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2935570","reservation_id":"69426","confirmation_number":"SJ12634852526","room_confirmation_number":"SJ12678963956","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":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"4","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-14 03:43:01","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":"11.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}