{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-02-18","total_rooms_exist":50,"departureCount":17,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"20","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":"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":"233.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":"2934740","reservation_id":"69015","confirmation_number":"SJ12695158873","room_stay_from":"2019-02-17","room_stay_to":"2019-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"259.00,259.00,259.00","nightly_discount":"0.00,0.00,0.00","subtotal":"777.00","grand_total":"874.13","paid_amount":"874.13","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-1869458952","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":"81659","customer_id":"81659","source_of_creation":"Booking.com","reservation_created_date":"2019-02-09 19:11:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"139.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"259.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":"2935442","reservation_id":"69281","confirmation_number":"SJ12658845248","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"269.10","nightly_discount":"0","subtotal":"269.10","grand_total":"302.74","paid_amount":"302.74","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-1839203145","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":"81784","customer_id":"81784","source_of_creation":"Booking.com","reservation_created_date":"2019-02-12 04:40:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"48.44","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":"2935450","reservation_id":"68151","confirmation_number":"SJ12655781567","room_stay_from":"2019-02-17","room_stay_to":"2019-02-19","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":"413","product_id":"1260","siteminder_id":"BDC-1417373648","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":"81205","customer_id":"81205","source_of_creation":"Booking.com","reservation_created_date":"2019-01-30 20:32:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","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":"2936935","reservation_id":"68164","confirmation_number":"SJ12646108387","room_stay_from":"2019-02-17","room_stay_to":"2019-02-22","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":"1314","siteminder_id":"BDC-1190512064","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":"81206","customer_id":"81206","source_of_creation":"Booking.com","reservation_created_date":"2019-01-30 20:58:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","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":"2936937","reservation_id":"68260","confirmation_number":"SJ12687285946","room_stay_from":"2019-02-17","room_stay_to":"2019-02-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"259.00,259.00,259.00,259.00,259.00","nightly_discount":"0,0,0,0,0","subtotal":"1295.00","grand_total":"1456.88","paid_amount":"1456.88","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-1019081249","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":"81252","customer_id":"81252","source_of_creation":"Booking.com","reservation_created_date":"2019-01-31 22:02:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"233.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"259.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":"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":"2937105","reservation_id":"68068","confirmation_number":"SJ12651718195","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"242.19","nightly_discount":"0","subtotal":"242.19","grand_total":"272.46","paid_amount":"272.46","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-1820722747","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":"81137","customer_id":"81137","source_of_creation":"Booking.com","reservation_created_date":"2019-01-29 10:22:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"43.59","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":"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":"189.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":"2927719","reservation_id":"67976","confirmation_number":"SJ12662226257","room_stay_from":"2019-02-17","room_stay_to":"2019-02-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.20,199.20,199.20,199.20,199.20,199.20","nightly_discount":"0,0,0,0,0,0","subtotal":"1195.20","grand_total":"1344.60","paid_amount":"1344.60","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1187376378","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":"81047","customer_id":"81047","source_of_creation":"Expedia","reservation_created_date":"2019-01-27 23:05:14","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":"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"}]},{"room_stay_id":"2930691","reservation_id":"63078","confirmation_number":"SJ12611499065","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"243.00,243.00,243.00,250.50","nightly_discount":"0,0,0,0","subtotal":"979.50","grand_total":"1101.94","paid_amount":"1101.94","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1160868553","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":"78472","customer_id":"78472","source_of_creation":"Expedia","reservation_created_date":"2018-12-09 13:25:12","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":"243.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":"2931194","reservation_id":"68657","confirmation_number":"SJ12643710435","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00","nightly_discount":"0","subtotal":"249.00","grand_total":"280.13","paid_amount":"280.13","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1192218648","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":"81461","customer_id":"81461","source_of_creation":"Expedia","reservation_created_date":"2019-02-05 02:14:12","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":"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":"2931635","reservation_id":"68748","confirmation_number":"SJ12676565781","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.20,199.20,199.20,199.20","nightly_discount":"0,0,0,0","subtotal":"796.80","grand_total":"896.40","paid_amount":"896.40","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1192937979","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":"81510","customer_id":"81510","source_of_creation":"Expedia","reservation_created_date":"2019-02-06 05:04:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]},{"room_stay_id":"2935399","reservation_id":"68947","confirmation_number":"SJ12620548079","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"1313","siteminder_id":"EXP-1194665319","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":"81627","customer_id":"81627","source_of_creation":"Expedia","reservation_created_date":"2019-02-08 21:29:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]},{"room_stay_id":"2935409","reservation_id":"65771","confirmation_number":"SJ12636818575","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"309.00","nightly_discount":"0","subtotal":"309.00","grand_total":"347.63","paid_amount":"347.63","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1174630831","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":"79577","customer_id":"79577","source_of_creation":"Expedia","reservation_created_date":"2019-01-06 20:35:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"309.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":"2935411","reservation_id":"68652","confirmation_number":"SJ12631477976","room_stay_from":"2019-02-18","room_stay_to":"2019-02-20","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":"1306","siteminder_id":"EXP-1192182148","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":"81456","customer_id":"81456","source_of_creation":"Expedia","reservation_created_date":"2019-02-05 00:59:11","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":"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":"2935699","reservation_id":"68039","confirmation_number":"SJ12694438182","room_stay_from":"2019-02-14","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"199.20,199.20,199.20,199.20,199.20","nightly_discount":"0,0,0,0,0","subtotal":"996.00","grand_total":"1120.50","paid_amount":"1120.50","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1187897337","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":"81108","customer_id":"81108","source_of_creation":"Expedia","reservation_created_date":"2019-01-28 19:40:11","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":"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"}]},{"room_stay_id":"2937148","reservation_id":"69395","confirmation_number":"SJ12613405481","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"1","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":"1312","siteminder_id":"EXP-1197827215","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":"81860","customer_id":"81860","source_of_creation":"Expedia","reservation_created_date":"2019-02-13 21:35:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]},{"room_stay_id":"2937343","reservation_id":"69783","confirmation_number":"SJ12684990395","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.20","nightly_discount":"0","subtotal":"231.20","grand_total":"260.10","paid_amount":"260.10","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1201017935","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":"82048","customer_id":"82048","source_of_creation":"Expedia","reservation_created_date":"2019-02-19 01:14:13","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":"231.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":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"2928060","reservation_id":"68018","confirmation_number":"SJ12696464104","room_stay_from":"2019-02-18","room_stay_to":"2019-02-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"265.78,265.78,265.78,265.78,265.78","nightly_discount":"0,0,0,0,0","subtotal":"1328.90","grand_total":"1715.95","paid_amount":"1715.95","room_type_id":"413","product_id":"1272","siteminder_id":"ABB-HM3T4EHJ5B","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1328.90","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81090","customer_id":"81090","source_of_creation":"Airbnb","reservation_created_date":"2019-01-28 16:19:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"176.75","commision_charges":"41.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"265.78","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":"2931331","reservation_id":"68663","confirmation_number":"SJ12674848262","room_stay_from":"2019-02-18","room_stay_to":"2019-02-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"241.53,241.53,241.53","nightly_discount":"0,0,0","subtotal":"724.59","grand_total":"935.62","paid_amount":"935.62","room_type_id":"319","product_id":"1304","siteminder_id":"ABB-HM5XSXAQZH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"724.59","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81465","customer_id":"81465","source_of_creation":"Airbnb","reservation_created_date":"2019-02-05 03:33:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"96.36","commision_charges":"22.41","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"}]},{"room_stay_id":"2937394","reservation_id":"69012","confirmation_number":"SJ12687184723","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","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":"319","product_id":"1310","siteminder_id":"ABB-HMXQM9WBSQ","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":"81657","customer_id":"81657","source_of_creation":"Airbnb","reservation_created_date":"2019-02-09 18:55:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","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"}]},{"room_stay_id":"2948770","reservation_id":"67860","confirmation_number":"SJ12619044159","room_stay_from":"2019-02-16","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"241.53,241.53,241.53","nightly_discount":"0.00,0.00,0.00","subtotal":"724.59","grand_total":"935.62","paid_amount":"983.77","room_type_id":"413","product_id":"1271","siteminder_id":"ABB-HMZC8RDDXE","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"724.59","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80953","customer_id":"80953","source_of_creation":"Airbnb","reservation_created_date":"2019-01-26 16:21:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","ota_service_fee_amount":"96.36","commision_charges":"22.41","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"241.53","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2935404","reservation_id":"61026","confirmation_number":"SJ12630744781","room_stay_from":"2019-02-14","room_stay_to":"2019-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.93,341.33,341.33,319.93,287.83,287.83","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1898.18","grand_total":"2135.45","paid_amount":"2135.45","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"77331","customer_id":"77331","source_of_creation":"FE","reservation_created_date":"2018-11-23 22:29:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"287.83","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":"2935447","reservation_id":"57117","confirmation_number":"SJ12670910030","room_stay_from":"2019-02-16","room_stay_to":"2019-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.00,209.00,209.00,209.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"856.00","grand_total":"963.00","paid_amount":"963.00","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75409","customer_id":"75409","source_of_creation":"FE","reservation_created_date":"2018-09-25 23:47:03","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"209.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":"2936483","reservation_id":"67969","confirmation_number":"SJ12671754570","room_stay_from":"2019-02-16","room_stay_to":"2019-02-19","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":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81044","customer_id":"81044","source_of_creation":"FE","reservation_created_date":"2019-01-27 22:24:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"2931949","reservation_id":"68283","confirmation_number":"SJ12628127599","room_stay_from":"2019-02-17","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"259.00,259.00","nightly_discount":"0.00,0.00","subtotal":"518.00","grand_total":"582.75","paid_amount":"582.75","room_type_id":"319","product_id":"1307","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":"81258","customer_id":"81258","source_of_creation":"PMS","reservation_created_date":"2019-02-01 01:42:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"259.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":"2933300","reservation_id":"68790","confirmation_number":"SJ12693715920","room_stay_from":"2019-02-18","room_stay_to":"2019-02-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"259.00,259.00,259.00","nightly_discount":"0.00,0.00,0.00","subtotal":"777.00","grand_total":"874.13","paid_amount":"874.13","room_type_id":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81543","customer_id":"81543","source_of_creation":"PMS","reservation_created_date":"2019-02-06 21:29:32","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":"259.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":"2933314","reservation_id":"69004","confirmation_number":"SJ12612326553","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","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":"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":"77890","customer_id":"77890","source_of_creation":"PMS","reservation_created_date":"2019-02-09 17:07:32","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":"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":"2934179","reservation_id":"68788","confirmation_number":"SJ12680408991","room_stay_from":"2019-02-18","room_stay_to":"2019-02-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00","subtotal":"597.00","grand_total":"671.63","paid_amount":"671.63","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81542","customer_id":"81542","source_of_creation":"PMS","reservation_created_date":"2019-02-06 21:13:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"199.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":"2935401","reservation_id":"68977","confirmation_number":"SJ12638513943","room_stay_from":"2019-02-17","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"259.00,259.00","nightly_discount":"0.00,0.00","subtotal":"518.00","grand_total":"582.75","paid_amount":"582.75","room_type_id":"319","product_id":"1303","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":"81638","customer_id":"81638","source_of_creation":"PMS","reservation_created_date":"2019-02-09 01:56:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"259.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":"2936823","reservation_id":"67889","confirmation_number":"SJ12672329525","room_stay_from":"2019-02-17","room_stay_to":"2019-02-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00,249.00,249.00,249.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"996.00","grand_total":"1120.50","paid_amount":"1120.50","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":"80978","customer_id":"80978","source_of_creation":"PMS","reservation_created_date":"2019-01-26 22:16:05","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"}]},{"room_stay_id":"2937154","reservation_id":"63496","confirmation_number":"SJ12630717142","room_stay_from":"2019-02-14","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.93,319.93,319.93,319.93,259.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1538.72","grand_total":"1731.06","paid_amount":"1731.06","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78594","customer_id":"78594","source_of_creation":"PMS","reservation_created_date":"2018-12-14 20:31:36","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":"259.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":"2937225","reservation_id":"69511","confirmation_number":"SJ12688742815","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"412","product_id":"1297","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":"75598","customer_id":"75598","source_of_creation":"PMS","reservation_created_date":"2019-02-15 18:43:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2937524","reservation_id":"68849","confirmation_number":"SJ12671849592","room_stay_from":"2019-02-17","room_stay_to":"2019-02-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.00,249.00,249.00,249.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"996.00","grand_total":"1120.50","paid_amount":"1120.50","room_type_id":"412","product_id":"1315","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":"81575","customer_id":"81575","source_of_creation":"PMS","reservation_created_date":"2019-02-07 17:38:12","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.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":"2938324","reservation_id":"66382","confirmation_number":"SJ12669886063","room_stay_from":"2019-02-18","room_stay_to":"2019-02-21","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":"1268","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":"80107","customer_id":"80107","source_of_creation":"PMS","reservation_created_date":"2019-01-11 21:18:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","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"}]}],"pms_non_taxable":[{"room_stay_id":"2937801","reservation_id":"69396","confirmation_number":"SJ12612259938","room_stay_from":"2019-02-16","room_stay_to":"2019-02-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","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":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-02-13 21:40:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"2960465","reservation_id":"62874","confirmation_number":"SJ12659198146","room_stay_from":"2019-02-17","room_stay_to":"2019-02-24","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":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2018-12-07 17:33:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"2936226","reservation_id":"67564","confirmation_number":"SJ12638905833","room_stay_from":"2019-02-16","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.44,124.44,124.45","nightly_discount":"0.00,0.00,0.00","subtotal":"373.33","grand_total":"420.00","paid_amount":"420.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":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-01-22 20:38:49","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":"124.45","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"}]}],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2930692","reservation_id":"63078","confirmation_number":"SJ12641753640","room_confirmation_number":"SJ12611499065","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"78472","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-02-03 18:29:28","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78472","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"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":"2927720","reservation_id":"67976","confirmation_number":"SJ12640511147","room_confirmation_number":"SJ12662226257","room_stay_from":"2019-02-17","room_stay_to":"2019-02-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"81047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-27 23:05:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81047","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":"2928061","reservation_id":"68018","confirmation_number":"SJ12614370649","room_confirmation_number":"SJ12696464104","room_stay_from":"2019-02-18","room_stay_to":"2019-02-23","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":"81090","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-28 16:19:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81090","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":"2930693","reservation_id":"63078","confirmation_number":"SJ12641368648","room_confirmation_number":"SJ12611499065","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"78472","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":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78472","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":"2931195","reservation_id":"68657","confirmation_number":"SJ12646931888","room_confirmation_number":"SJ12643710435","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"81461","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-05 02:14: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":"81461","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":"2931333","reservation_id":"68663","confirmation_number":"SJ12682890225","room_confirmation_number":"SJ12674848262","room_stay_from":"2019-02-18","room_stay_to":"2019-02-21","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":"81465","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-05 03:33:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81465","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":"2931636","reservation_id":"68748","confirmation_number":"SJ12644042233","room_confirmation_number":"SJ12676565781","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","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":"81510","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-06 05:04: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":"81510","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":"2931950","reservation_id":"68283","confirmation_number":"SJ12658948331","room_confirmation_number":"SJ12628127599","room_stay_from":"2019-02-17","room_stay_to":"2019-02-19","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":"81258","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-01 01:42:22","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81258","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":"2933301","reservation_id":"68790","confirmation_number":"SJ12695975096","room_confirmation_number":"SJ12693715920","room_stay_from":"2019-02-18","room_stay_to":"2019-02-21","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":"81543","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-06 21:29:32","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81543","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":"2933315","reservation_id":"69004","confirmation_number":"SJ12681685171","room_confirmation_number":"SJ12612326553","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","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-09 17:07:32","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":"2934180","reservation_id":"68788","confirmation_number":"SJ12677922147","room_confirmation_number":"SJ12680408991","room_stay_from":"2019-02-18","room_stay_to":"2019-02-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"81542","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-06 21:13:46","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81542","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":"2934741","reservation_id":"69015","confirmation_number":"SJ12659639407","room_confirmation_number":"SJ12695158873","room_stay_from":"2019-02-17","room_stay_to":"2019-02-20","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":"81659","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-09 19:11: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":"81659","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":"2935400","reservation_id":"68947","confirmation_number":"SJ12610396287","room_confirmation_number":"SJ12620548079","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"81627","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-08 21:29: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":"81627","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":"2935403","reservation_id":"68977","confirmation_number":"SJ12627541332","room_confirmation_number":"SJ12638513943","room_stay_from":"2019-02-17","room_stay_to":"2019-02-19","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":"81638","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-09 01:56:38","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81638","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":"2935406","reservation_id":"61026","confirmation_number":"SJ12698289260","room_confirmation_number":"SJ12630744781","room_stay_from":"2019-02-14","room_stay_to":"2019-02-20","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":"77331","product_attribute_values":"resort_fee#&#flat_rate#&#25.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77331","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":"2935410","reservation_id":"65771","confirmation_number":"SJ12659904838","room_confirmation_number":"SJ12636818575","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"79577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-06 20:35: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":"79577","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":"2935412","reservation_id":"68652","confirmation_number":"SJ12691253935","room_confirmation_number":"SJ12631477976","room_stay_from":"2019-02-18","room_stay_to":"2019-02-20","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":"81456","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-05 00:59: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":"81456","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":"2935443","reservation_id":"69281","confirmation_number":"SJ12634103564","room_confirmation_number":"SJ12658845248","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"81784","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-12 04:40: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":"81784","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":"2935449","reservation_id":"57117","confirmation_number":"SJ12627563459","room_confirmation_number":"SJ12670910030","room_stay_from":"2019-02-16","room_stay_to":"2019-02-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"75409","product_attribute_values":"resort_fee#&#flat_rate#&#25.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75409","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":"2935451","reservation_id":"68151","confirmation_number":"SJ12665771726","room_confirmation_number":"SJ12655781567","room_stay_from":"2019-02-17","room_stay_to":"2019-02-19","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":"81205","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-30 20:32: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":"81205","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":"2935700","reservation_id":"68039","confirmation_number":"SJ12638717503","room_confirmation_number":"SJ12694438182","room_stay_from":"2019-02-14","room_stay_to":"2019-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"81108","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-28 19:40:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81108","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":"2936227","reservation_id":"67564","confirmation_number":"SJ12667697191","room_confirmation_number":"SJ12638905833","room_stay_from":"2019-02-16","room_stay_to":"2019-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"80759","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-22 20:38:49","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2936484","reservation_id":"67969","confirmation_number":"SJ12694552350","room_confirmation_number":"SJ12671754570","room_stay_from":"2019-02-16","room_stay_to":"2019-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"81044","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-27 22:24:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81044","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":"2936824","reservation_id":"67889","confirmation_number":"SJ12672171733","room_confirmation_number":"SJ12672329525","room_stay_from":"2019-02-17","room_stay_to":"2019-02-21","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":"80978","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-26 22:16:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80978","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":"2936936","reservation_id":"68164","confirmation_number":"SJ12617248298","room_confirmation_number":"SJ12646108387","room_stay_from":"2019-02-17","room_stay_to":"2019-02-22","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":"81206","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-30 20:58: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":"81206","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":"2936938","reservation_id":"68260","confirmation_number":"SJ12629910575","room_confirmation_number":"SJ12687285946","room_stay_from":"2019-02-17","room_stay_to":"2019-02-22","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":"81252","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-31 22:02: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":"81252","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":"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":"2937106","reservation_id":"68068","confirmation_number":"SJ12693614168","room_confirmation_number":"SJ12651718195","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"81137","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-29 10:22:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81137","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":"2937149","reservation_id":"69395","confirmation_number":"SJ12620906590","room_confirmation_number":"SJ12613405481","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"81860","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-13 21:35:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81860","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":"2937155","reservation_id":"63496","confirmation_number":"SJ12689578989","room_confirmation_number":"SJ12630717142","room_stay_from":"2019-02-14","room_stay_to":"2019-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"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":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78594","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":"2937226","reservation_id":"69511","confirmation_number":"SJ12648632889","room_confirmation_number":"SJ12688742815","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"75598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-15 18:43:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75598","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":"2937344","reservation_id":"69783","confirmation_number":"SJ12681816153","room_confirmation_number":"SJ12684990395","room_stay_from":"2019-02-18","room_stay_to":"2019-02-19","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":"82048","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-19 01:14:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82048","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":"2937395","reservation_id":"69012","confirmation_number":"SJ12628998283","room_confirmation_number":"SJ12687184723","room_stay_from":"2019-02-18","room_stay_to":"2019-02-22","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":"81657","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-09 18:55: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":"81657","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":"2937525","reservation_id":"68849","confirmation_number":"SJ12623239427","room_confirmation_number":"SJ12671849592","room_stay_from":"2019-02-17","room_stay_to":"2019-02-21","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":"81575","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-07 17:38:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81575","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":"","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":"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":"2938326","reservation_id":"66382","confirmation_number":"SJ12627795002","room_confirmation_number":"SJ12669886063","room_stay_from":"2019-02-18","room_stay_to":"2019-02-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"80107","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-11 21:18:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80107","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":"2948772","reservation_id":"67860","confirmation_number":"SJ12634140961","room_confirmation_number":"SJ12619044159","room_stay_from":"2019-02-16","room_stay_to":"2019-02-19","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"80953","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-26 16:21:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80953","canceled_nights_data":"","currentDayPrice":"0.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":"2960466","reservation_id":"62874","confirmation_number":"SJ12662639004","room_confirmation_number":"SJ12659198146","room_stay_from":"2019-02-17","room_stay_to":"2019-02-24","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":"78425","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-19 18:54:31","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":"2938270","reservation_id":"69790","confirmation_number":"SJ12610438293","room_confirmation_number":"SJ12686346717","room_stay_from":"2019-02-22","room_stay_to":"2019-02-23","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":"82053","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-19 04:33: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":"82053","canceled_nights_data":"","changedComment":"both dates 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"}]},{"room_stay_id":"2947656","reservation_id":"69758","confirmation_number":"SJ12653506342","room_confirmation_number":"SJ12632886448","room_stay_from":"2019-03-11","room_stay_to":"2019-03-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":"82034","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-18 18:58:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82034","canceled_nights_data":"","changedComment":"both dates 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":[],"gift_shop_taxable":[{"room_stay_id":"2937206","reservation_id":"67807","confirmation_number":"SJ12629204533","room_confirmation_number":"SJ12679029013","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"18.60","grand_total":"40.00","paid_amount":"40.00","product_id":"1757","service_quantity":"2","product_name":"Pool Towels","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 18:30:06","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80919","parentCustTravId":"80919","customer_traveller_id":"80919","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"37.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2937098","reservation_id":"69739","confirmation_number":"SJ12673819896","room_confirmation_number":"SJ12696230713","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"43.00","paid_amount":"43.00","product_id":null,"service_quantity":"2","product_name":"Visor","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 09:01:51","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2937099","reservation_id":"69739","confirmation_number":"SJ12675609217","room_confirmation_number":"SJ12696230713","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.95","grand_total":"22.52","paid_amount":"22.52","product_id":null,"service_quantity":"1","product_name":"Salt Scrub of the Keys","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 09:01:51","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":"20.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2937100","reservation_id":"69739","confirmation_number":"SJ12655735474","room_confirmation_number":"SJ12696230713","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.88","paid_amount":"26.88","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 09:01:51","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2937277","reservation_id":"69772","confirmation_number":"SJ12682370794","room_confirmation_number":"SJ12683149182","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":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Coconut","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 22:00:36","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":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"gift_shop_non_taxable":[{"room_stay_id":"2937257","reservation_id":"56181","confirmation_number":"SJ12639266358","room_confirmation_number":"SJ12637611281","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.00","grand_total":"5.00","paid_amount":"5.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 20:21:46","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"74985","parentCustTravId":"74985","customer_traveller_id":"74985","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":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2937269","reservation_id":"56181","confirmation_number":"SJ12691092025","room_confirmation_number":"SJ12637611281","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.00","grand_total":"5.00","paid_amount":"5.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 21:32:16","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"74985","parentCustTravId":"74985","customer_traveller_id":"74985","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":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2937298","reservation_id":"61026","confirmation_number":"SJ12629635961","room_confirmation_number":"SJ12630744781","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":"1231","service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:13:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"77331","parentCustTravId":"77331","customer_traveller_id":"77331","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":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2937279","reservation_id":"69769","confirmation_number":"SJ12689821719","room_confirmation_number":"SJ12659433441","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-18 22:02:08","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":"2937306","reservation_id":"69777","confirmation_number":"SJ12633598237","room_confirmation_number":"SJ12653848660","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.00","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-19 00:04:23","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":"6.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[{"room_stay_id":"2937167","reservation_id":"62166","confirmation_number":"SJ12628059450","room_confirmation_number":"SJ12688581085","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 15:42:22","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"78594","parentCustTravId":"78594","customer_traveller_id":"78594","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":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2937170","reservation_id":"62166","confirmation_number":"SJ12637104629","room_confirmation_number":"SJ12688581085","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 15:44:59","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"78594","parentCustTravId":"78594","customer_traveller_id":"78594","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":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2937258","reservation_id":"56181","confirmation_number":"SJ12674196332","room_confirmation_number":"SJ12637611281","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.34","grand_total":"18.00","paid_amount":"18.00","product_id":"1364","service_quantity":"2","product_name":"Strawberry Daiquiri","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 20:21:46","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"74985","parentCustTravId":"74985","customer_traveller_id":"74985","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":"16.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937259","reservation_id":"56181","confirmation_number":"SJ12689399627","room_confirmation_number":"SJ12637611281","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-18 20:21:46","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"74985","parentCustTravId":"74985","customer_traveller_id":"74985","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":"2937270","reservation_id":"56181","confirmation_number":"SJ12669040415","room_confirmation_number":"SJ12637611281","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.34","grand_total":"18.00","paid_amount":"18.00","product_id":"1364","service_quantity":"2","product_name":"Strawberry Daiquiri","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 21:32:16","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"74985","parentCustTravId":"74985","customer_traveller_id":"74985","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":"16.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937271","reservation_id":"56181","confirmation_number":"SJ12660334848","room_confirmation_number":"SJ12637611281","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-18 21:32:16","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"74985","parentCustTravId":"74985","customer_traveller_id":"74985","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":"2937299","reservation_id":"61026","confirmation_number":"SJ12666107405","room_confirmation_number":"SJ12630744781","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":"1420","service_quantity":"2","product_name":"Sandbar Sunday Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:13:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"77331","parentCustTravId":"77331","customer_traveller_id":"77331","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":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937300","reservation_id":"61026","confirmation_number":"SJ12677085167","room_confirmation_number":"SJ12630744781","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":"4.00","paid_amount":"4.00","product_id":"1425","service_quantity":"2","product_name":"Soda","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:13:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"77331","parentCustTravId":"77331","customer_traveller_id":"77331","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":"3.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937301","reservation_id":"61026","confirmation_number":"SJ12612510162","room_confirmation_number":"SJ12630744781","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":"1640","service_quantity":"1","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:13:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"77331","parentCustTravId":"77331","customer_traveller_id":"77331","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":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937302","reservation_id":"61026","confirmation_number":"SJ12677651596","room_confirmation_number":"SJ12630744781","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.34","grand_total":"27.00","paid_amount":"27.00","product_id":"1399","service_quantity":"3","product_name":"Johnny Walker Black","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:13:42","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"77331","parentCustTravId":"77331","customer_traveller_id":"77331","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":"25.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937267","reservation_id":"69769","confirmation_number":"SJ12652861176","room_confirmation_number":"SJ12659433441","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":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"$1 Upcharge","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 21:16:47","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937268","reservation_id":"69769","confirmation_number":"SJ12640047357","room_confirmation_number":"SJ12659433441","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":"Margarita on the Rocks","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 21:16:47","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":"2937278","reservation_id":"69772","confirmation_number":"SJ12661666158","room_confirmation_number":"SJ12683149182","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"4","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 22:00:36","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":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937290","reservation_id":"69775","confirmation_number":"SJ12668876736","room_confirmation_number":"SJ12697507262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.34","grand_total":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"1","product_name":"Johnny Walker Black","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 22:50:37","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":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937291","reservation_id":"69775","confirmation_number":"SJ12650693080","room_confirmation_number":"SJ12697507262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"4","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 22:50:37","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":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937292","reservation_id":"69775","confirmation_number":"SJ12680748647","room_confirmation_number":"SJ12697507262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 22:50:37","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":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937294","reservation_id":"69776","confirmation_number":"SJ12689909019","room_confirmation_number":"SJ12613535111","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":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Jack Daniels","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:02:48","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":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937295","reservation_id":"69776","confirmation_number":"SJ12620473214","room_confirmation_number":"SJ12613535111","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":"Corona","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:02:48","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":"2937304","reservation_id":"69777","confirmation_number":"SJ12632699386","room_confirmation_number":"SJ12653848660","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:58:22","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":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937305","reservation_id":"69777","confirmation_number":"SJ12691959045","room_confirmation_number":"SJ12653848660","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":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"Bud Light","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-18 23:58:22","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":"7.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937313","reservation_id":"69780","confirmation_number":"SJ12698134493","room_confirmation_number":"SJ12681331467","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-19 00:41:39","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":"2937346","reservation_id":"69784","confirmation_number":"SJ12625583408","room_confirmation_number":"SJ12628625343","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":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"2","product_name":"Bacardi","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-19 01:14:52","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":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2937353","reservation_id":"69785","confirmation_number":"SJ12621388838","room_confirmation_number":"SJ12624285711","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":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"2","product_name":"Captain Morgan","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-19 01:49:40","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":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}