{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-03-18","total_rooms_exist":52,"departureCount":11,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"23","block_room_bookings":[],"bundle_block_count":"2","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2929594","reservation_id":"61417","confirmation_number":"SJ12638331211","room_stay_from":"2019-03-13","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"266.00,266.00,341.00,341.00,266.00,266.00","nightly_discount":"0,0,0,0,0,0","subtotal":"1746.00","grand_total":"1964.25","paid_amount":"2133.00","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-1770458182","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":"78762","customer_id":"78762","source_of_creation":"Booking.com","reservation_created_date":"2018-11-28 22:03:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"314.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"266.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":"2949630","reservation_id":"71861","confirmation_number":"SJ12695786027","room_stay_from":"2019-03-17","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"289.00,289.00","nightly_discount":"0,0","subtotal":"578.00","grand_total":"650.25","paid_amount":"650.25","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-1457252528","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":"83200","customer_id":"83200","source_of_creation":"Booking.com","reservation_created_date":"2019-03-13 19:15:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"104.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"289.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":"2950560","reservation_id":"72027","confirmation_number":"SJ12631051388","room_stay_from":"2019-03-16","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.00,289.00,289.00","nightly_discount":"0.00,0.00,0.00","subtotal":"877.00","grand_total":"986.63","paid_amount":"986.63","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-1677494443","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":"83303","customer_id":"83303","source_of_creation":"Booking.com","reservation_created_date":"2019-03-15 15:47:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"78.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"289.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":"2951249","reservation_id":"69752","confirmation_number":"SJ12684747382","room_stay_from":"2019-03-17","room_stay_to":"2019-03-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"302.00,302.00,302.00","nightly_discount":"0,0,0","subtotal":"906.00","grand_total":"1019.25","paid_amount":"1019.25","room_type_id":"319","product_id":"1278","siteminder_id":"BDC-1150675960","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":"82029","customer_id":"82029","source_of_creation":"Booking.com","reservation_created_date":"2019-02-18 16:15:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"163.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"302.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":"2951709","reservation_id":"71169","confirmation_number":"SJ12697603935","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.10","nightly_discount":"0","subtotal":"260.10","grand_total":"292.62","paid_amount":"292.62","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-1111909545","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":"82810","customer_id":"82810","source_of_creation":"Booking.com","reservation_created_date":"2019-03-07 03:51:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"46.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"260.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2952200","reservation_id":"72133","confirmation_number":"SJ12679503051","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"339.00,339.00,339.00,339.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1356.00","grand_total":"1525.50","paid_amount":"1525.50","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-3542256480","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":"83363","customer_id":"83363","source_of_creation":"Booking.com","reservation_created_date":"2019-03-16 06:24:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"122.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"339.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2926955","reservation_id":"66540","confirmation_number":"SJ12688409410","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.75,207.75,207.75,207.75","nightly_discount":"0,0,0,0","subtotal":"831.00","grand_total":"934.88","paid_amount":"934.88","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1178437770","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":"80178","customer_id":"80178","source_of_creation":"Expedia","reservation_created_date":"2019-01-12 23:20:09","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":"207.75","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":"2939858","reservation_id":"70251","confirmation_number":"SJ12625822641","room_stay_from":"2019-03-17","room_stay_to":"2019-03-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.20,231.20,231.20,231.20","nightly_discount":"0,0,0,0","subtotal":"924.80","grand_total":"1040.40","paid_amount":"1040.40","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1204643257","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":"82285","customer_id":"82285","source_of_creation":"Expedia","reservation_created_date":"2019-02-24 19:44:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"231.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2939950","reservation_id":"65176","confirmation_number":"SJ12671191811","room_stay_from":"2019-03-10","room_stay_to":"2019-03-20","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"199.50,199.50,199.50,199.50,199.50,255.75,255.75,199.50,199.50,199.50","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"2107.50","grand_total":"2370.94","paid_amount":"2370.94","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1172089696","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":"79305","customer_id":"79305","source_of_creation":"Expedia","reservation_created_date":"2019-01-02 09:50:10","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":"199.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2940118","reservation_id":"70283","confirmation_number":"SJ12617495981","room_stay_from":"2019-03-17","room_stay_to":"2019-03-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.20,231.20,231.20,231.20,231.20","nightly_discount":"0,0,0,0,0","subtotal":"1156.00","grand_total":"1300.50","paid_amount":"1300.50","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1204836523","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":"82303","customer_id":"82303","source_of_creation":"Expedia","reservation_created_date":"2019-02-25 02:09:06","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":"231.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2941422","reservation_id":"70515","confirmation_number":"SJ12615615693","room_stay_from":"2019-03-18","room_stay_to":"2019-03-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.20,231.20,231.20","nightly_discount":"0,0,0","subtotal":"693.60","grand_total":"780.30","paid_amount":"780.30","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1207052432","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":"82455","customer_id":"82455","source_of_creation":"Expedia","reservation_created_date":"2019-02-28 04:30:09","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":"231.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2943910","reservation_id":"60369","confirmation_number":"SJ12676812019","room_stay_from":"2019-03-14","room_stay_to":"2019-03-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.50,255.75,255.75,199.50,199.50,199.50,199.50","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1509.00","grand_total":"1697.63","paid_amount":"1697.63","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1148266598","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":"77075","customer_id":"77075","source_of_creation":"Expedia","reservation_created_date":"2018-11-15 01:44:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"199.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2950574","reservation_id":"69972","confirmation_number":"SJ12610582314","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.20","nightly_discount":"0","subtotal":"231.20","grand_total":"260.10","paid_amount":"260.10","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1202887584","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":"82167","customer_id":"82167","source_of_creation":"Expedia","reservation_created_date":"2019-02-21 19:34:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 332","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"231.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2950579","reservation_id":"70901","confirmation_number":"SJ12634636909","room_stay_from":"2019-03-17","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"339.00,339.00","nightly_discount":"0,0","subtotal":"678.00","grand_total":"762.75","paid_amount":"762.75","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1209594518","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":"82653","customer_id":"82653","source_of_creation":"Expedia","reservation_created_date":"2019-03-04 03:39:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"339.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":"2952338","reservation_id":"68528","confirmation_number":"SJ12659825646","room_stay_from":"2019-03-15","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.80,272.80,212.80,450.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1209.00","grand_total":"1360.13","paid_amount":"1360.13","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1191290255","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":"81377","customer_id":"81377","source_of_creation":"Expedia","reservation_created_date":"2019-02-03 14:49:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"450.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2949679","reservation_id":"71781","confirmation_number":"SJ12646694946","room_stay_from":"2019-03-15","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"216.97,216.97,216.97,216.97","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"867.88","grand_total":"976.36","paid_amount":"976.36","room_type_id":"319","product_id":"1305","siteminder_id":"HTN-78815645-CMCPVW","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":"83145","customer_id":"83145","source_of_creation":"HotelTonight","reservation_created_date":"2019-03-12 20:02:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"216.97","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"2939719","reservation_id":"70243","confirmation_number":"SJ12639433677","room_stay_from":"2019-03-17","room_stay_to":"2019-03-22","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"303.83,303.83,303.83,303.83,303.83","nightly_discount":"0,0,0,0,0","subtotal":"1519.15","grand_total":"1991.76","paid_amount":"1991.76","room_type_id":"413","product_id":"1271","siteminder_id":"ABB-HMTT52X2YF","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"125.00","roomAmt_airbnb_taxpaid":"1519.15","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82278","customer_id":"82278","source_of_creation":"Airbnb","reservation_created_date":"2019-02-24 16:54:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","ota_service_fee_amount":"218.65","commision_charges":"50.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"303.83","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":"2939964","reservation_id":"67933","confirmation_number":"SJ12651338107","room_stay_from":"2019-03-16","room_stay_to":"2019-03-21","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"243.91,243.91,243.91,243.91,243.91","nightly_discount":"0,0,0,0,0","subtotal":"1219.55","grand_total":"1635.06","paid_amount":"1635.06","room_type_id":"319","product_id":"1313","siteminder_id":"ABB-HMAAXWXNQZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"1219.55","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81016","customer_id":"81016","source_of_creation":"Airbnb","reservation_created_date":"2019-01-27 13:19:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"195.45","commision_charges":"45.45","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"243.91","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":"2945163","reservation_id":"71149","confirmation_number":"SJ12680292822","room_stay_from":"2019-03-16","room_stay_to":"2019-03-23","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"300.84,300.84,300.84,300.84,300.84,300.84,300.84","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2105.88","grand_total":"2719.16","paid_amount":"2719.16","room_type_id":"413","product_id":"1267","siteminder_id":"ABB-HMAHQKSE58","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"2105.88","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82801","customer_id":"82801","source_of_creation":"Airbnb","reservation_created_date":"2019-03-07 01:26:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"280.07","commision_charges":"65.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"300.84","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":"2948519","reservation_id":"67081","confirmation_number":"SJ12681653146","room_stay_from":"2019-03-14","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"308.46,308.46,308.46,308.46,308.46","nightly_discount":"0,0,0,0,0","subtotal":"1542.30","grand_total":"1991.47","paid_amount":"1991.47","room_type_id":"319","product_id":"1276","siteminder_id":"ABB-HMX4HCMSAP","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1542.30","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80448","customer_id":"80448","source_of_creation":"Airbnb","reservation_created_date":"2019-01-17 16:23:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"205.1","commision_charges":"47.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"308.46","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":"2950604","reservation_id":"72148","confirmation_number":"SJ12670277827","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"255.33","nightly_discount":"0","subtotal":"255.33","grand_total":"335.73","paid_amount":"335.73","room_type_id":"318","product_id":"1281","siteminder_id":"ABB-HMANJRZ8WP","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"255.33","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83375","customer_id":"83375","source_of_creation":"Airbnb","reservation_created_date":"2019-03-16 16:14:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"37.28","commision_charges":"8.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.33","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":"2951714","reservation_id":"68299","confirmation_number":"SJ12629523895","room_stay_from":"2019-03-18","room_stay_to":"2019-03-20","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"235.93,235.93","nightly_discount":"0,0","subtotal":"471.86","grand_total":"621.34","paid_amount":"621.34","room_type_id":"318","product_id":"1289","siteminder_id":"ABB-HMRMWKY3MF","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"471.86","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81268","customer_id":"81268","source_of_creation":"Airbnb","reservation_created_date":"2019-02-01 04:21:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"69.4","commision_charges":"16.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"235.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2909292","reservation_id":"65152","confirmation_number":"SJ12697979554","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"554.26","nightly_discount":"0.00","subtotal":"554.26","grand_total":"623.54","paid_amount":"623.54","room_type_id":"320","product_id":"1320","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":"79283","customer_id":"79283","source_of_creation":"FE","reservation_created_date":"2019-01-02 00:06:16","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"554.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":"2919252","reservation_id":"67157","confirmation_number":"SJ12625832644","room_stay_from":"2019-03-16","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"341.33,266.43,266.43","nightly_discount":"0.00,0.00,0.00","subtotal":"874.19","grand_total":"983.46","paid_amount":"983.46","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80487","customer_id":"80487","source_of_creation":"FE","reservation_created_date":"2019-01-18 12:22:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"266.43","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":"2936628","reservation_id":"69629","confirmation_number":"SJ12653789077","room_stay_from":"2019-03-18","room_stay_to":"2019-03-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.43,266.43,266.43","nightly_discount":"0.00,0.00,0.00","subtotal":"799.29","grand_total":"899.20","paid_amount":"899.20","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81969","customer_id":"81969","source_of_creation":"FE","reservation_created_date":"2019-02-16 23:18:48","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"266.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2942242","reservation_id":"70685","confirmation_number":"SJ12612239043","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"900.00","grand_total":"1012.50","paid_amount":"1012.50","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82535","customer_id":"82535","source_of_creation":"PMS","reservation_created_date":"2019-03-02 00:22:11","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":"225.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2946877","reservation_id":"69747","confirmation_number":"SJ12684681055","room_stay_from":"2019-03-18","room_stay_to":"2019-03-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"266.43,266.43,266.43,266.43,341.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1407.05","grand_total":"1582.93","paid_amount":"1582.93","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82026","customer_id":"82026","source_of_creation":"PMS","reservation_created_date":"2019-02-18 14:31:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"266.43","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":"2951472","reservation_id":"71438","confirmation_number":"SJ12648222496","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75598","customer_id":"75598","source_of_creation":"PMS","reservation_created_date":"2019-03-09 16:51:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2951902","reservation_id":"70323","confirmation_number":"SJ12643672370","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"289.00,289.00,289.00,289.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1156.00","grand_total":"1300.50","paid_amount":"1300.50","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82330","customer_id":"82330","source_of_creation":"PMS","reservation_created_date":"2019-02-25 19:48:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"289.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":"2952344","reservation_id":"70622","confirmation_number":"SJ12664086941","room_stay_from":"2019-03-15","room_stay_to":"2019-03-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.00,299.00,289.00,289.00,289.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1465.00","grand_total":"1648.13","paid_amount":"1648.13","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82515","customer_id":"82515","source_of_creation":"PMS","reservation_created_date":"2019-03-01 15:36: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":"289.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":"2926852","reservation_id":"67792","confirmation_number":"SJ12610887608","room_stay_from":"2019-03-16","room_stay_to":"2019-03-23","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":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-01-25 16:44:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"2935903","reservation_id":"69499","confirmation_number":"SJ12650632517","room_stay_from":"2019-03-16","room_stay_to":"2019-03-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"1155.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1155.00","grand_total":"1155.00","paid_amount":"1155.00","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2019-02-15 17:23:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2951913","reservation_id":"58877","confirmation_number":"SJ12674948667","room_stay_from":"2019-03-18","room_stay_to":"2019-03-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1307","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2018-10-25 15:36:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2939720","reservation_id":"70243","confirmation_number":"SJ12662959236","room_confirmation_number":"SJ12639433677","room_stay_from":"2019-03-17","room_stay_to":"2019-03-22","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"131.25","paid_amount":"131.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"82278","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-02-24 16:54: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":"82278","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"2939965","reservation_id":"67933","confirmation_number":"SJ12670393533","room_confirmation_number":"SJ12651338107","room_stay_from":"2019-03-16","room_stay_to":"2019-03-21","room_stay_status":"Active","nightly_price":"50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"262.50","paid_amount":"262.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"81016","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-02-24 20:39:49","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81016","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"2950605","reservation_id":"72148","confirmation_number":"SJ12667643967","room_confirmation_number":"SJ12670277827","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"26.25","paid_amount":"26.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"83375","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-03-16 16:14: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":"83375","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"2951715","reservation_id":"68299","confirmation_number":"SJ12639543866","room_confirmation_number":"SJ12629523895","room_stay_from":"2019-03-18","room_stay_to":"2019-03-20","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"52.50","paid_amount":"52.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"81268","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-03-18 11:15:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81268","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"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":"2952202","reservation_id":"72133","confirmation_number":"SJ12680783857","room_confirmation_number":"SJ12679503051","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"83363","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-03-19 00:39:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83363","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2909293","reservation_id":"65152","confirmation_number":"SJ12624155846","room_confirmation_number":"SJ12697979554","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"79283","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-02 00:06:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79283","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":"2919253","reservation_id":"67157","confirmation_number":"SJ12619073222","room_confirmation_number":"SJ12625832644","room_stay_from":"2019-03-16","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"80487","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-18 12:22:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80487","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":"2926853","reservation_id":"67792","confirmation_number":"SJ12614945398","room_confirmation_number":"SJ12610887608","room_stay_from":"2019-03-16","room_stay_to":"2019-03-23","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":"80907","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-25 16:44:45","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74797","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":"2926956","reservation_id":"66540","confirmation_number":"SJ12652843392","room_confirmation_number":"SJ12688409410","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"80178","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-12 23:20: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":"80178","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":"2929595","reservation_id":"61417","confirmation_number":"SJ12649237698","room_confirmation_number":"SJ12638331211","room_stay_from":"2019-03-13","room_stay_to":"2019-03-19","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"78762","product_attribute_values":"resort_fee#&#flat_rate#&#25.00","reservation_created_date":"2018-11-28 22:03: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":"78762","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":"2935904","reservation_id":"69499","confirmation_number":"SJ12699776593","room_confirmation_number":"SJ12650632517","room_stay_from":"2019-03-16","room_stay_to":"2019-03-23","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":"81919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-15 17:23:53","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":"2936629","reservation_id":"69629","confirmation_number":"SJ12647069511","room_confirmation_number":"SJ12653789077","room_stay_from":"2019-03-18","room_stay_to":"2019-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"81969","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-16 23:18:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81969","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":"2939721","reservation_id":"70243","confirmation_number":"SJ12657061439","room_confirmation_number":"SJ12639433677","room_stay_from":"2019-03-17","room_stay_to":"2019-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"82278","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-24 16:54: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":"82278","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":"2939859","reservation_id":"70251","confirmation_number":"SJ12663978815","room_confirmation_number":"SJ12625822641","room_stay_from":"2019-03-17","room_stay_to":"2019-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"82285","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-24 19:44: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":"82285","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":"2939953","reservation_id":"65176","confirmation_number":"SJ12615217432","room_confirmation_number":"SJ12671191811","room_stay_from":"2019-03-10","room_stay_to":"2019-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"79305","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-02 09:50: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":"79305","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":"2939966","reservation_id":"67933","confirmation_number":"SJ12675256020","room_confirmation_number":"SJ12651338107","room_stay_from":"2019-03-16","room_stay_to":"2019-03-21","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":"81016","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-27 13:19:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81016","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":"2940119","reservation_id":"70283","confirmation_number":"SJ12648595778","room_confirmation_number":"SJ12617495981","room_stay_from":"2019-03-17","room_stay_to":"2019-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"82303","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-25 02:09:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82303","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":"2941423","reservation_id":"70515","confirmation_number":"SJ12699335508","room_confirmation_number":"SJ12615615693","room_stay_from":"2019-03-18","room_stay_to":"2019-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"82455","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-28 04:30: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":"82455","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":"2942243","reservation_id":"70685","confirmation_number":"SJ12631362247","room_confirmation_number":"SJ12612239043","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"82535","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-02 00:22:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82535","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":"2943911","reservation_id":"60369","confirmation_number":"SJ12642701275","room_confirmation_number":"SJ12676812019","room_stay_from":"2019-03-14","room_stay_to":"2019-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"77075","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":"77075","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":"2945165","reservation_id":"71149","confirmation_number":"SJ12647950758","room_confirmation_number":"SJ12680292822","room_stay_from":"2019-03-16","room_stay_to":"2019-03-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"82801","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-07 01:26:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82801","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":"2946880","reservation_id":"69747","confirmation_number":"SJ12660879613","room_confirmation_number":"SJ12684681055","room_stay_from":"2019-03-18","room_stay_to":"2019-03-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"82026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-18 14:31:02","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82026","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":"2948520","reservation_id":"67081","confirmation_number":"SJ12682716129","room_confirmation_number":"SJ12681653146","room_stay_from":"2019-03-14","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"80448","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-01-17 16:23:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80448","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":"2949631","reservation_id":"71861","confirmation_number":"SJ12627112735","room_confirmation_number":"SJ12695786027","room_stay_from":"2019-03-17","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"83200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-13 19:15:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83200","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":"2949681","reservation_id":"71781","confirmation_number":"SJ12660981114","room_confirmation_number":"SJ12646694946","room_stay_from":"2019-03-15","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"83145","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-12 20:02:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83145","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":"2950561","reservation_id":"72027","confirmation_number":"SJ12665940572","room_confirmation_number":"SJ12631051388","room_stay_from":"2019-03-16","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"83303","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-15 15:47:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83303","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":"2950575","reservation_id":"69972","confirmation_number":"SJ12636043748","room_confirmation_number":"SJ12610582314","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"82167","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-21 19:34: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":"82167","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":"2950581","reservation_id":"70901","confirmation_number":"SJ12663264584","room_confirmation_number":"SJ12634636909","room_stay_from":"2019-03-17","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"82653","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-04 03:39:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82653","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":"2950606","reservation_id":"72148","confirmation_number":"SJ12656875070","room_confirmation_number":"SJ12670277827","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"83375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-16 16:14: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":"83375","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":"2951250","reservation_id":"69752","confirmation_number":"SJ12647590373","room_confirmation_number":"SJ12684747382","room_stay_from":"2019-03-17","room_stay_to":"2019-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"82029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-18 16:15:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82029","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":"2951473","reservation_id":"71438","confirmation_number":"SJ12610852129","room_confirmation_number":"SJ12648222496","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"75598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-09 16:51:34","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75598","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"2951710","reservation_id":"71169","confirmation_number":"SJ12650612130","room_confirmation_number":"SJ12697603935","room_stay_from":"2019-03-18","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"82810","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-07 03:51:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82810","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":"2951716","reservation_id":"68299","confirmation_number":"SJ12658486590","room_confirmation_number":"SJ12629523895","room_stay_from":"2019-03-18","room_stay_to":"2019-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"81268","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-01 04:21:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81268","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":"2951904","reservation_id":"70323","confirmation_number":"SJ12685211041","room_confirmation_number":"SJ12643672370","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"82330","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-25 19:48:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82330","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":"2951915","reservation_id":"58877","confirmation_number":"SJ12614871097","room_confirmation_number":"SJ12674948667","room_stay_from":"2019-03-18","room_stay_to":"2019-03-23","room_stay_status":"Active","nightly_price":"0,0,0,0,0.00","nightly_discount":"0,0,0,0,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"76312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2018-10-25 15:41:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74797","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"}]},{"room_stay_id":"2952203","reservation_id":"72133","confirmation_number":"SJ12659458650","room_confirmation_number":"SJ12679503051","room_stay_from":"2019-03-18","room_stay_to":"2019-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"83363","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-16 06:24:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83363","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":"2952339","reservation_id":"68528","confirmation_number":"SJ12610083706","room_confirmation_number":"SJ12659825646","room_stay_from":"2019-03-15","room_stay_to":"2019-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"81377","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-03 14:49:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81377","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":"2952345","reservation_id":"70622","confirmation_number":"SJ12690913911","room_confirmation_number":"SJ12664086941","room_stay_from":"2019-03-15","room_stay_to":"2019-03-20","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":"82515","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-01 15:36:17","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82515","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":"2966597","reservation_id":"72400","confirmation_number":"SJ12655351986","room_confirmation_number":"SJ12640619731","room_stay_from":"2019-04-17","room_stay_to":"2019-04-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"83542","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-18 17:01:04","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3036078","reservation_id":"72375","confirmation_number":"SJ12646054535","room_confirmation_number":"SJ12663238496","room_stay_from":"2019-11-01","room_stay_to":"2019-11-07","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":"122.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"83518","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-18 13:53:21","reservation_modified_date_time":"2019-11-01 04:30:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3039206","reservation_id":"72382","confirmation_number":"SJ12643828211","room_confirmation_number":"SJ12688771059","room_stay_from":"2019-11-15","room_stay_to":"2019-11-17","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":"83525","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-18 14:26:21","reservation_modified_date_time":"2019-11-15 08:16:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3042969","reservation_id":"72384","confirmation_number":"SJ12661570210","room_confirmation_number":"SJ12626220005","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","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":"125.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"83527","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-18 14:30:25","reservation_modified_date_time":"2019-11-30 06:13:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2952051","reservation_id":"60369","confirmation_number":"SJ12622115784","room_confirmation_number":"SJ12676812019","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":"1660","service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 20:05:46","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"77075","parentCustTravId":"77075","customer_traveller_id":"77075","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"2.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2951936","reservation_id":"72393","confirmation_number":"SJ12643124005","room_confirmation_number":"SJ12697893451","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":null,"service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 15:45: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":"2.33","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":"2952112","reservation_id":"71149","confirmation_number":"SJ12672977881","room_confirmation_number":"SJ12680292822","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.00","grand_total":"6.00","paid_amount":"6.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 22:16:19","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"82801","parentCustTravId":"82801","customer_traveller_id":"82801","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":"6.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2952195","reservation_id":"70323","confirmation_number":"SJ12611288479","room_confirmation_number":"SJ12643672370","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.00","grand_total":"5.00","paid_amount":"5.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:20:51","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"82330","parentCustTravId":"82330","customer_traveller_id":"82330","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"1","currentDayPrice":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2952095","reservation_id":"72424","confirmation_number":"SJ12625951160","room_confirmation_number":"SJ12679621472","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.00","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 21:37:23","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2952137","reservation_id":"72437","confirmation_number":"SJ12645527110","room_confirmation_number":"SJ12658841755","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 Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 22:33: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":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2952196","reservation_id":"72452","confirmation_number":"SJ12622984565","room_confirmation_number":"SJ12617908604","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":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:21: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":"3.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2952215","reservation_id":"72456","confirmation_number":"SJ12614531707","room_confirmation_number":"SJ12623510806","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.00","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:56:59","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":"2952236","reservation_id":"72463","confirmation_number":"SJ12622131157","room_confirmation_number":"SJ12684482598","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.00","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 01:36:56","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":"2952247","reservation_id":"72466","confirmation_number":"SJ12647283689","room_confirmation_number":"SJ12652714824","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":null,"service_quantity":"1","product_name":"Customer Tip for Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 02:05:47","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":"3.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2952248","reservation_id":"72467","confirmation_number":"SJ12631837871","room_confirmation_number":"SJ12699789586","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 Marina Russian","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 02:06:46","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":[]}],"bar_taxable":[{"room_stay_id":"2952096","reservation_id":"71149","confirmation_number":"SJ12674720699","room_confirmation_number":"SJ12680292822","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":"1641","service_quantity":"1","product_name":"Wine","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 21:53:41","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"82801","parentCustTravId":"82801","customer_traveller_id":"82801","static_pos_type":"wine","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"3.71","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952097","reservation_id":"71149","confirmation_number":"SJ12677838039","room_confirmation_number":"SJ12680292822","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":"1840","service_quantity":"3","product_name":"No Tan Lines","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 21:53:41","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"82801","parentCustTravId":"82801","customer_traveller_id":"82801","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":"13.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952098","reservation_id":"71149","confirmation_number":"SJ12674848209","room_confirmation_number":"SJ12680292822","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":"1405","service_quantity":"1","product_name":"Margarita on the Rocks","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 21:53:41","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"82801","parentCustTravId":"82801","customer_traveller_id":"82801","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952189","reservation_id":"70323","confirmation_number":"SJ12685560849","room_confirmation_number":"SJ12643672370","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":"14.00","paid_amount":"14.00","product_id":"1405","service_quantity":"2","product_name":"Margarita on the Rocks","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:14:18","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"82330","parentCustTravId":"82330","customer_traveller_id":"82330","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":"12.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952065","reservation_id":"72424","confirmation_number":"SJ12637763305","room_confirmation_number":"SJ12679621472","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":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 20:52:03","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952094","reservation_id":"72429","confirmation_number":"SJ12637524113","room_confirmation_number":"SJ12647203096","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-03-18 21:30:03","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":"2952109","reservation_id":"72431","confirmation_number":"SJ12691210428","room_confirmation_number":"SJ12657247014","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-03-18 22:13:28","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":"2952111","reservation_id":"72432","confirmation_number":"SJ12691140446","room_confirmation_number":"SJ12617287703","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":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 22:15:49","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952135","reservation_id":"72437","confirmation_number":"SJ12686382473","room_confirmation_number":"SJ12658841755","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"Mango Rum Punch","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 22:32:11","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":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952136","reservation_id":"72437","confirmation_number":"SJ12677847868","room_confirmation_number":"SJ12658841755","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-03-18 22:32:11","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":"2952161","reservation_id":"72442","confirmation_number":"SJ12684406124","room_confirmation_number":"SJ12686325813","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Bombay","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 23:07: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":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952162","reservation_id":"72442","confirmation_number":"SJ12679117145","room_confirmation_number":"SJ12686325813","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":"Bloody Mary","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 23:07: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":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952169","reservation_id":"72444","confirmation_number":"SJ12644680320","room_confirmation_number":"SJ12684681769","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.85","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Soda","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 23:29:08","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":"1.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952193","reservation_id":"72452","confirmation_number":"SJ12630380324","room_confirmation_number":"SJ12617908604","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"Mango Rum Punch","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:19:49","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":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952194","reservation_id":"72452","confirmation_number":"SJ12619594403","room_confirmation_number":"SJ12617908604","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":"Mud Slide","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:19:49","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":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952211","reservation_id":"72455","confirmation_number":"SJ12627536868","room_confirmation_number":"SJ12687824740","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":"14.00","paid_amount":"14.00","product_id":null,"service_quantity":"2","product_name":"Van Gogh Espresso","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:52:56","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":"12.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952212","reservation_id":"72455","confirmation_number":"SJ12680763528","room_confirmation_number":"SJ12687824740","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":"Absolut","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:52:56","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":"2952214","reservation_id":"72456","confirmation_number":"SJ12638302521","room_confirmation_number":"SJ12623510806","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-03-19 00:56:05","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.71","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952217","reservation_id":"72457","confirmation_number":"SJ12644541104","room_confirmation_number":"SJ12623894882","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Jagermeister","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 00:57:32","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952218","reservation_id":"72457","confirmation_number":"SJ12666650932","room_confirmation_number":"SJ12623894882","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-03-19 00:57:32","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":"2952233","reservation_id":"72463","confirmation_number":"SJ12627813466","room_confirmation_number":"SJ12684482598","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":"House Pinot Noir","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 01:22:19","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":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952235","reservation_id":"72464","confirmation_number":"SJ12649909890","room_confirmation_number":"SJ12666622691","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":null,"service_quantity":"3","product_name":"Jack Daniels","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 01:35:55","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":"16.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952240","reservation_id":"72466","confirmation_number":"SJ12695683979","room_confirmation_number":"SJ12652714824","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.85","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Soda","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 01:54:24","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":"1.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952241","reservation_id":"72466","confirmation_number":"SJ12683330924","room_confirmation_number":"SJ12652714824","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":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"3","product_name":"Michelob Ultra","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 01:54:24","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":"11.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952243","reservation_id":"72467","confirmation_number":"SJ12641988819","room_confirmation_number":"SJ12699789586","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Absolut","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 01:56:31","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952244","reservation_id":"72467","confirmation_number":"SJ12651233558","room_confirmation_number":"SJ12699789586","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"2","product_name":"Mango Rum Punch","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 01:56:31","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":"14.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952246","reservation_id":"72468","confirmation_number":"SJ12659337811","room_confirmation_number":"SJ12631943319","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 Rum","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 02:04:02","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":"2952269","reservation_id":"72475","confirmation_number":"SJ12672041463","room_confirmation_number":"SJ12698110337","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":null,"service_quantity":"3","product_name":"Virgin Daiquiri","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 02:35:48","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":"16.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952270","reservation_id":"72475","confirmation_number":"SJ12623692646","room_confirmation_number":"SJ12698110337","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":"Islamorada Ale Draft","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 02:35:48","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"13.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"2952271","reservation_id":"72475","confirmation_number":"SJ12620350994","room_confirmation_number":"SJ12698110337","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-03-19 02:35:48","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"6.48","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":"2952177","reservation_id":"70323","confirmation_number":"SJ12671366104","room_confirmation_number":"SJ12643672370","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"3.00","paid_amount":"3.00","product_id":"1658","service_quantity":"1","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-18 23:59:54","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"82330","parentCustTravId":"82330","customer_traveller_id":"82330","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":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2952253","reservation_id":"72470","confirmation_number":"SJ12681984230","room_confirmation_number":"SJ12648022306","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"5","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 02:12:46","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"2952279","reservation_id":"72478","confirmation_number":"SJ12697090736","room_confirmation_number":"SJ12654609592","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"3","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-03-19 02:56:44","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"8.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}