{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-01-24","total_rooms_exist":49,"departureCount":16,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"18","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2877475","reservation_id":"56322","confirmation_number":"SJ12622348667","room_stay_from":"2019-01-21","room_stay_to":"2019-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.40,194.40,194.40,217.80,217.80","nightly_discount":"0,0,0,0,0","subtotal":"1018.80","grand_total":"1146.15","paid_amount":"1146.15","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-1381609079","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":"75048","customer_id":"75048","source_of_creation":"Booking.com","reservation_created_date":"2018-09-15 00:53:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"183.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"217.80","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":"2923974","reservation_id":"61307","confirmation_number":"SJ12660734324","room_stay_from":"2019-01-23","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.00,239.00","nightly_discount":"0,0","subtotal":"478.00","grand_total":"537.75","paid_amount":"537.75","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-1438483260","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":"77395","customer_id":"77395","source_of_creation":"Booking.com","reservation_created_date":"2018-11-26 17:18:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"86.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"239.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":"2925796","reservation_id":"67627","confirmation_number":"SJ12648998370","room_stay_from":"2019-01-23","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00","nightly_discount":"0,0","subtotal":"298.00","grand_total":"335.25","paid_amount":"335.25","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-1446837755","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":"80815","customer_id":"80815","source_of_creation":"Booking.com","reservation_created_date":"2019-01-23 18:49:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"53.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.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":"2925841","reservation_id":"67575","confirmation_number":"SJ12650400907","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00","nightly_discount":"0","subtotal":"149.00","grand_total":"167.63","paid_amount":"167.63","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-1804885015","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":"80770","customer_id":"80770","source_of_creation":"Booking.com","reservation_created_date":"2019-01-22 22:42:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"26.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.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":"2925843","reservation_id":"66768","confirmation_number":"SJ12619542008","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00","nightly_discount":"0","subtotal":"149.00","grand_total":"167.63","paid_amount":"167.63","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-1717987163","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":"80264","customer_id":"80264","source_of_creation":"Booking.com","reservation_created_date":"2019-01-14 17:12:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"26.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2889751","reservation_id":"56122","confirmation_number":"SJ12635310527","room_stay_from":"2019-01-22","room_stay_to":"2019-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.25,131.25,131.25,146.25,146.25,131.25,131.25,131.25,131.25,131.25","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1342.50","grand_total":"1510.32","paid_amount":"1510.32","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1112495299","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":"74950","customer_id":"74950","source_of_creation":"Expedia","reservation_created_date":"2018-09-11 17:27:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"294.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.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":"2918282","reservation_id":"66955","confirmation_number":"SJ12647295668","room_stay_from":"2019-01-24","room_stay_to":"2019-01-26","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"119.20,215.20","nightly_discount":"0,0","subtotal":"334.40","grand_total":"376.20","paid_amount":"376.20","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1180731100","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":"80387","customer_id":"80387","source_of_creation":"Expedia","reservation_created_date":"2019-01-16 16:06:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.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":"2920685","reservation_id":"67432","confirmation_number":"SJ12672000517","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00","nightly_discount":"0","subtotal":"149.00","grand_total":"167.63","paid_amount":"167.63","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1183283422","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":"80648","customer_id":"80648","source_of_creation":"Expedia","reservation_created_date":"2019-01-21 00:25:17","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":"149.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":"2921027","reservation_id":"67248","confirmation_number":"SJ12667318334","room_stay_from":"2019-01-22","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00","nightly_discount":"0,0,0","subtotal":"447.00","grand_total":"502.88","paid_amount":"587.26","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1182375831","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":"80538","customer_id":"80538","source_of_creation":"Expedia","reservation_created_date":"2019-01-19 04:35:15","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":"149.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":"2923937","reservation_id":"67571","confirmation_number":"SJ12663138430","room_stay_from":"2019-01-24","room_stay_to":"2019-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,229.00","nightly_discount":"0,0","subtotal":"378.00","grand_total":"425.25","paid_amount":"425.25","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1184499019","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":"79236","customer_id":"79236","source_of_creation":"Expedia","reservation_created_date":"2019-01-22 22:20:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.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":"2925632","reservation_id":"67282","confirmation_number":"SJ12623593126","room_stay_from":"2019-01-23","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20","nightly_discount":"0,0","subtotal":"238.40","grand_total":"268.20","paid_amount":"268.20","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1182624169","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":"80568","customer_id":"80568","source_of_creation":"Expedia","reservation_created_date":"2019-01-19 18:15:10","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":"119.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":"2925839","reservation_id":"66161","confirmation_number":"SJ12677037055","room_stay_from":"2019-01-24","room_stay_to":"2019-01-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,269.00,269.00","nightly_discount":"0,0,0","subtotal":"687.00","grand_total":"772.88","paid_amount":"772.88","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1176720347","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":"79768","customer_id":"79768","source_of_creation":"Expedia","reservation_created_date":"2019-01-10 00:50:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.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"}]}],"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":"2916395","reservation_id":"66304","confirmation_number":"SJ12691528932","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.53","nightly_discount":"0","subtotal":"144.53","grand_total":"186.63","paid_amount":"186.63","room_type_id":"413","product_id":"1267","siteminder_id":"ABB-HMMAWTHAYX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"144.53","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79983","customer_id":"79983","source_of_creation":"Airbnb","reservation_created_date":"2019-01-11 02:00:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"19.22","commision_charges":"4.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.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":"2918754","reservation_id":"67059","confirmation_number":"SJ12685506453","room_stay_from":"2019-01-20","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.53,144.53,144.53,144.53,144.53","nightly_discount":"0,0,0,0,0","subtotal":"722.65","grand_total":"933.13","paid_amount":"933.13","room_type_id":"319","product_id":"1301","siteminder_id":"ABB-HMX9SNSZRB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"722.65","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80425","customer_id":"80425","source_of_creation":"Airbnb","reservation_created_date":"2019-01-17 04:32:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"96.1","commision_charges":"22.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.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":"2920922","reservation_id":"67473","confirmation_number":"SJ12627803887","room_stay_from":"2019-01-24","room_stay_to":"2019-01-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.13,222.13,222.13","nightly_discount":"0,0,0","subtotal":"666.39","grand_total":"860.48","paid_amount":"860.48","room_type_id":"413","product_id":"1268","siteminder_id":"ABB-HMACXSR93X","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"666.39","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80683","customer_id":"80683","source_of_creation":"Airbnb","reservation_created_date":"2019-01-21 18:36:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"88.62","commision_charges":"20.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"222.13","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2908852","reservation_id":"65053","confirmation_number":"SJ12644173395","room_stay_from":"2019-01-19","room_stay_to":"2019-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79228","customer_id":"79228","source_of_creation":"PMS","reservation_created_date":"2019-01-01 15:34:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2915180","reservation_id":"66342","confirmation_number":"SJ12630158060","room_stay_from":"2019-01-19","room_stay_to":"2019-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74796","customer_id":"74796","source_of_creation":"PMS","reservation_created_date":"2019-01-11 17:18:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2926021","reservation_id":"57171","confirmation_number":"SJ12618523174","room_stay_from":"2019-01-23","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"290.25","paid_amount":"290.25","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74747","customer_id":"74747","source_of_creation":"PMS","reservation_created_date":"2019-01-22 16:05:03","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":"129.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":"2926405","reservation_id":"67720","confirmation_number":"SJ12685542608","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00","nightly_discount":"0.00","subtotal":"149.00","grand_total":"167.63","paid_amount":"167.63","room_type_id":"319","product_id":"1311","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":"80864","customer_id":"80864","source_of_creation":"PMS","reservation_created_date":"2019-01-24 19:35:48","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":"149.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":"2926969","reservation_id":"66049","confirmation_number":"SJ12680267400","room_stay_from":"2019-01-19","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.03,202.23,202.23,202.23,202.23,472.26","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1526.21","grand_total":"1716.99","paid_amount":"1716.99","room_type_id":"319","product_id":"1304","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79708","customer_id":"79708","source_of_creation":"PMS","reservation_created_date":"2019-01-09 13:18:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"472.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2927113","reservation_id":"60271","confirmation_number":"SJ12643127886","room_stay_from":"2019-01-05","room_stay_to":"2019-01-26","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"745.00,0.00,0.00,0.00,0.00,0.00,0.00,745.00,0.00,0.00,0.00,0.00,0.00,0.00,745.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2235.00","grand_total":"2235.00","paid_amount":"2235.00","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"77010","customer_id":"77010","source_of_creation":"PMS","reservation_created_date":"2018-11-13 18:38:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2927581","reservation_id":"58483","confirmation_number":"SJ12699177097","room_stay_from":"2019-01-01","room_stay_to":"2019-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2772.00","grand_total":"3118.50","paid_amount":"3118.50","room_type_id":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76112","customer_id":"76112","source_of_creation":"PMS","reservation_created_date":"2018-10-19 17:38:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 332","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"2926559","reservation_id":"63910","confirmation_number":"SJ12665369973","room_stay_from":"2019-01-19","room_stay_to":"2019-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"745.00,0.00,0.00,0.00,0.00,0.00,0.00,745.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1490.00","grand_total":"1490.00","paid_amount":"1490.00","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2018-12-21 16:31:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2927247","reservation_id":"64580","confirmation_number":"SJ12696538549","room_stay_from":"2019-01-18","room_stay_to":"2019-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"745.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"745.00","grand_total":"745.00","paid_amount":"745.00","room_type_id":"319","product_id":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"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-28 19:59:21","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2960515","reservation_id":"59319","confirmation_number":"SJ12613777623","room_stay_from":"2019-01-19","room_stay_to":"2019-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"745.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"745.00","grand_total":"745.00","paid_amount":"745.00","room_type_id":"319","product_id":"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":"76475","customer_id":"76475","source_of_creation":"PMS","reservation_created_date":"2018-10-30 18:08:40","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":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2899708","reservation_id":"56322","confirmation_number":"SJ12631271953","room_confirmation_number":"SJ12622348667","room_stay_from":"2019-01-21","room_stay_to":"2019-01-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"75048","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":"75048","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":"2899763","reservation_id":"56122","confirmation_number":"SJ12635272612","room_confirmation_number":"SJ12635310527","room_stay_from":"2019-01-22","room_stay_to":"2019-02-01","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,0,0,0,0,0,0,0,0,0","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"74950","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":"74950","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":"2908853","reservation_id":"65053","confirmation_number":"SJ12648703054","room_confirmation_number":"SJ12644173395","room_stay_from":"2019-01-19","room_stay_to":"2019-01-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"79238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-01 15:34:25","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79228","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2915181","reservation_id":"66342","confirmation_number":"SJ12683258416","room_confirmation_number":"SJ12630158060","room_stay_from":"2019-01-19","room_stay_to":"2019-01-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"80085","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-11 17:18:51","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74796","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2916397","reservation_id":"66304","confirmation_number":"SJ12668447200","room_confirmation_number":"SJ12691528932","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","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":"79983","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-11 02:00:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79983","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":"2918283","reservation_id":"66955","confirmation_number":"SJ12614679114","room_confirmation_number":"SJ12647295668","room_stay_from":"2019-01-24","room_stay_to":"2019-01-26","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":"80387","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-16 16:06: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":"80387","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":"2918755","reservation_id":"67059","confirmation_number":"SJ12674629416","room_confirmation_number":"SJ12685506453","room_stay_from":"2019-01-20","room_stay_to":"2019-01-25","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":"80425","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-17 04:32: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":"80425","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":"2920686","reservation_id":"67432","confirmation_number":"SJ12635180902","room_confirmation_number":"SJ12672000517","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","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":"80648","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-21 00:25:17","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80648","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":"2920923","reservation_id":"67473","confirmation_number":"SJ12697833987","room_confirmation_number":"SJ12627803887","room_stay_from":"2019-01-24","room_stay_to":"2019-01-27","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":"80683","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-21 18:36: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":"80683","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":"2921029","reservation_id":"67248","confirmation_number":"SJ12683192873","room_confirmation_number":"SJ12667318334","room_stay_from":"2019-01-22","room_stay_to":"2019-01-25","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"80538","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-19 04:35:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80538","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":"2923938","reservation_id":"67571","confirmation_number":"SJ12653398723","room_confirmation_number":"SJ12663138430","room_stay_from":"2019-01-24","room_stay_to":"2019-01-26","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":"79236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-22 22:20: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":"79236","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":"2923975","reservation_id":"61307","confirmation_number":"SJ12614953507","room_confirmation_number":"SJ12660734324","room_stay_from":"2019-01-23","room_stay_to":"2019-01-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"77395","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":"77395","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":"2925634","reservation_id":"67282","confirmation_number":"SJ12683176997","room_confirmation_number":"SJ12623593126","room_stay_from":"2019-01-23","room_stay_to":"2019-01-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"80568","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-19 18:15: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":"80568","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":"2925798","reservation_id":"67627","confirmation_number":"SJ12688756327","room_confirmation_number":"SJ12648998370","room_stay_from":"2019-01-23","room_stay_to":"2019-01-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"80815","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-23 18:49: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":"80815","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":"2925840","reservation_id":"66161","confirmation_number":"SJ12699298797","room_confirmation_number":"SJ12677037055","room_stay_from":"2019-01-24","room_stay_to":"2019-01-27","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":"79768","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-10 00:50: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":"79768","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":"2925842","reservation_id":"67575","confirmation_number":"SJ12619089101","room_confirmation_number":"SJ12650400907","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","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":"80770","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-22 22:42:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80770","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":"2925844","reservation_id":"66768","confirmation_number":"SJ12622560491","room_confirmation_number":"SJ12619542008","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","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":"80264","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-14 17:12: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":"80264","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":"2926022","reservation_id":"57171","confirmation_number":"SJ12615623264","room_confirmation_number":"SJ12618523174","room_stay_from":"2019-01-23","room_stay_to":"2019-01-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"74747","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-22 16:05:03","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74747","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2926406","reservation_id":"67720","confirmation_number":"SJ12682561250","room_confirmation_number":"SJ12685542608","room_stay_from":"2019-01-24","room_stay_to":"2019-01-25","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":"80864","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-24 19:35:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80864","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":"2926971","reservation_id":"66049","confirmation_number":"SJ12679575322","room_confirmation_number":"SJ12680267400","room_stay_from":"2019-01-19","room_stay_to":"2019-01-25","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":"79708","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-09 13:18:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79708","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":"2927248","reservation_id":"64580","confirmation_number":"SJ12617294632","room_confirmation_number":"SJ12696538549","room_stay_from":"2019-01-18","room_stay_to":"2019-01-25","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":"79062","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2018-12-28 19:59:21","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":"2927920","reservation_id":"58483","confirmation_number":"SJ12694251644","room_confirmation_number":"SJ12699177097","room_stay_from":"2019-01-01","room_stay_to":"2019-02-01","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"76112","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-27 17:48:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76112","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"2926560","reservation_id":"63910","confirmation_number":"SJ12628176183","room_confirmation_number":"SJ12665369973","room_stay_from":"2019-01-19","room_stay_to":"2019-02-02","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"77106","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2018-12-21 16:31:27","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"77106","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gift_shop_taxable":[{"room_stay_id":"2926507","reservation_id":"66168","confirmation_number":"SJ12641156755","room_confirmation_number":"SJ12660442199","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"26.99","grand_total":"29.01","paid_amount":"29.01","product_id":"1703","service_quantity":"1","product_name":"Damage Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 23:47:20","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79772","parentCustTravId":"79772","customer_traveller_id":"79772","static_pos_type":"damagefee","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":"26.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2926038","reservation_id":"67696","confirmation_number":"SJ12660566458","room_confirmation_number":"SJ12687667389","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-01-24 13:33:06","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":"2926057","reservation_id":"67700","confirmation_number":"SJ12614284053","room_confirmation_number":"SJ12671215392","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-01-24 14:30:28","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":"2926404","reservation_id":"67723","confirmation_number":"SJ12649709660","room_confirmation_number":"SJ12638787956","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Koozie","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 19:49:49","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":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"2926460","reservation_id":"66768","confirmation_number":"SJ12619243360","room_confirmation_number":"SJ12619542008","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.00","grand_total":"3.00","paid_amount":"3.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Patti Donovan","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 21:47:03","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80264","parentCustTravId":"80264","customer_traveller_id":"80264","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":"3.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2926652","reservation_id":"66768","confirmation_number":"SJ12639720781","room_confirmation_number":"SJ12619542008","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 Raymond Wood","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:03:52","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80264","parentCustTravId":"80264","customer_traveller_id":"80264","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":"2926140","reservation_id":"67709","confirmation_number":"SJ12624368274","room_confirmation_number":"SJ12670908722","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 Patti Donovan","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 17:17:22","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":"2926479","reservation_id":"67745","confirmation_number":"SJ12636242922","room_confirmation_number":"SJ12660493391","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.00","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Raymond Wood","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 23:11:40","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":"4.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2926504","reservation_id":"67747","confirmation_number":"SJ12647241773","room_confirmation_number":"SJ12665171400","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.00","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Raymond Wood","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 23:30:30","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":"4.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2926572","reservation_id":"67752","confirmation_number":"SJ12635230304","room_confirmation_number":"SJ12653949320","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.00","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Raymond Wood","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 00:37:41","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":"8.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2926604","reservation_id":"67759","confirmation_number":"SJ12631988661","room_confirmation_number":"SJ12612973552","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":null,"service_quantity":"1","product_name":"Customer Tip for Raymond Wood","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 01:20:12","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.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2926658","reservation_id":"67765","confirmation_number":"SJ12680169352","room_confirmation_number":"SJ12654046046","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Raymond Wood","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:14:39","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2926665","reservation_id":"67768","confirmation_number":"SJ12638372470","room_confirmation_number":"SJ12658297850","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Raymond Wood","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:16:43","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[{"room_stay_id":"2926461","reservation_id":"66768","confirmation_number":"SJ12676688848","room_confirmation_number":"SJ12619542008","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-01-24 21:47:03","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80264","parentCustTravId":"80264","customer_traveller_id":"80264","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":"2926462","reservation_id":"66768","confirmation_number":"SJ12637114056","room_confirmation_number":"SJ12619542008","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":"1393","service_quantity":"1","product_name":"Islamorada Ale Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 21:47:03","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80264","parentCustTravId":"80264","customer_traveller_id":"80264","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":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926653","reservation_id":"66768","confirmation_number":"SJ12699421804","room_confirmation_number":"SJ12619542008","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":"1411","service_quantity":"1","product_name":"Patron Silver","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:03:52","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80264","parentCustTravId":"80264","customer_traveller_id":"80264","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":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926654","reservation_id":"66768","confirmation_number":"SJ12625604707","room_confirmation_number":"SJ12619542008","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":"18.00","paid_amount":"18.00","product_id":"1601","service_quantity":"3","product_name":"Tanqueray","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:03:52","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80264","parentCustTravId":"80264","customer_traveller_id":"80264","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":"16.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926656","reservation_id":"66768","confirmation_number":"SJ12658953692","room_confirmation_number":"SJ12619542008","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":"24.00","paid_amount":"24.00","product_id":"1601","service_quantity":"4","product_name":"Tanqueray","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:03:52","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80264","parentCustTravId":"80264","customer_traveller_id":"80264","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":"22.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926064","reservation_id":"67703","confirmation_number":"SJ12614199373","room_confirmation_number":"SJ12663427439","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 15:24:28","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":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2926141","reservation_id":"67709","confirmation_number":"SJ12614075762","room_confirmation_number":"SJ12670908722","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 17:17:22","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926160","reservation_id":"67711","confirmation_number":"SJ12617391700","room_confirmation_number":"SJ12664889681","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Sandbar Sunday Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 17:51:38","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926161","reservation_id":"67711","confirmation_number":"SJ12682555186","room_confirmation_number":"SJ12664889681","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-01-24 17:51:38","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":"2926385","reservation_id":"67719","confirmation_number":"SJ12613986622","room_confirmation_number":"SJ12670046855","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":"Michelob Ultra","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 19:34:02","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":"2926402","reservation_id":"67722","confirmation_number":"SJ12620071223","room_confirmation_number":"SJ12671060507","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":"Michelob Ultra","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 19:48:42","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":"2926434","reservation_id":"67729","confirmation_number":"SJ12643016871","room_confirmation_number":"SJ12614855042","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":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 20:38:43","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":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926454","reservation_id":"67735","confirmation_number":"SJ12652217402","room_confirmation_number":"SJ12654502160","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-01-24 21:33:10","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926455","reservation_id":"67735","confirmation_number":"SJ12684544933","room_confirmation_number":"SJ12654502160","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":"Wine","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 21:33:10","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"wine","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":"2926464","reservation_id":"67738","confirmation_number":"SJ12696192717","room_confirmation_number":"SJ12640765863","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":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"3","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 21:49:27","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":"2926466","reservation_id":"67739","confirmation_number":"SJ12645560196","room_confirmation_number":"SJ12619733792","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-01-24 22:05:50","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":"2926469","reservation_id":"67740","confirmation_number":"SJ12697976103","room_confirmation_number":"SJ12619773230","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":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 22:33:06","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":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926471","reservation_id":"67741","confirmation_number":"SJ12676659569","room_confirmation_number":"SJ12623136847","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-01-24 22:34:13","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926473","reservation_id":"67742","confirmation_number":"SJ12696949999","room_confirmation_number":"SJ12627568969","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":"Wine","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 22:35:13","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"wine","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":"2926475","reservation_id":"67743","confirmation_number":"SJ12697628166","room_confirmation_number":"SJ12667204639","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-01-24 22:54:18","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":"2926477","reservation_id":"67744","confirmation_number":"SJ12681239898","room_confirmation_number":"SJ12665623053","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-01-24 23:05:02","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":"2926480","reservation_id":"67745","confirmation_number":"SJ12679873156","room_confirmation_number":"SJ12660493391","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":"Jack Daniels","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 23:11: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"}]},{"room_stay_id":"2926481","reservation_id":"67745","confirmation_number":"SJ12649210518","room_confirmation_number":"SJ12660493391","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":"Wine","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 23:11:40","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"wine","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":"2926505","reservation_id":"67747","confirmation_number":"SJ12685554810","room_confirmation_number":"SJ12665171400","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Gin","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-24 23:30:30","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926506","reservation_id":"67747","confirmation_number":"SJ12645619387","room_confirmation_number":"SJ12665171400","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-01-24 23:30:30","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":"2926573","reservation_id":"67752","confirmation_number":"SJ12661883259","room_confirmation_number":"SJ12653949320","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 00:37:41","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926575","reservation_id":"67752","confirmation_number":"SJ12632963687","room_confirmation_number":"SJ12653949320","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 00:37:41","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926598","reservation_id":"67756","confirmation_number":"SJ12685103625","room_confirmation_number":"SJ12685784762","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"Sandbar Sunday Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 01:01:58","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":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926605","reservation_id":"67759","confirmation_number":"SJ12695563677","room_confirmation_number":"SJ12612973552","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":"25.00","paid_amount":"25.00","product_id":null,"service_quantity":"5","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 01:20:12","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":"23.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926610","reservation_id":"67760","confirmation_number":"SJ12663275030","room_confirmation_number":"SJ12674982314","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Shock Top Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 01:30:56","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926645","reservation_id":"67764","confirmation_number":"SJ12673152788","room_confirmation_number":"SJ12639355748","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-01-25 02:31:31","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":"2926659","reservation_id":"67765","confirmation_number":"SJ12641165997","room_confirmation_number":"SJ12654046046","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":"Patron Silver","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:14:39","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":"2926660","reservation_id":"67765","confirmation_number":"SJ12658090385","room_confirmation_number":"SJ12654046046","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":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"3","product_name":"House Whiskey","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:14:39","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":"13.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2926661","reservation_id":"67765","confirmation_number":"SJ12631937266","room_confirmation_number":"SJ12654046046","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":"Tanqueray","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:14:39","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":"2926666","reservation_id":"67768","confirmation_number":"SJ12615053963","room_confirmation_number":"SJ12658297850","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":"20.00","paid_amount":"20.00","product_id":null,"service_quantity":"4","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:16:43","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":"18.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"bar_non_taxable":[],"restaurant_taxable":[{"room_stay_id":"2926655","reservation_id":"66768","confirmation_number":"SJ12619608499","room_confirmation_number":"SJ12619542008","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"14.88","grand_total":"16.00","paid_amount":"16.00","product_id":"1541","service_quantity":"1","product_name":"Pizza 12\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 03:03:52","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"80264","parentCustTravId":"80264","customer_traveller_id":"80264","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2926574","reservation_id":"67752","confirmation_number":"SJ12612105910","room_confirmation_number":"SJ12653949320","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"16.74","grand_total":"18.00","paid_amount":"18.00","product_id":null,"service_quantity":"1","product_name":"Bianca pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 00:37:41","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"16.74","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2926600","reservation_id":"67757","confirmation_number":"SJ12648044511","room_confirmation_number":"SJ12637204401","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"14.88","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"Pizza 16\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 01:12:44","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"7.44","product_attribute_values":null,"currentDayPrice":"14.88","currentDayDiscount":"7.44","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2926602","reservation_id":"67758","confirmation_number":"SJ12639982204","room_confirmation_number":"SJ12633055706","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.51","grand_total":"3.50","paid_amount":"3.50","product_id":null,"service_quantity":"1","product_name":"Chicken wings","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-25 01:13:33","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"3.26","product_attribute_values":null,"currentDayPrice":"6.51","currentDayDiscount":"3.26","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}