{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2021-11-06","total_rooms_exist":"1731,1732,1733,1738,1739,1741,1742,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754","departureCount":2,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1733","block_room_bookings":[{"confirmation_number":"CC12886294365","room_stay_from":"2021-11-06","room_stay_to":"2021-12-29","bundle_room":"0","product_id":"1733"}],"bundle_block_count":"1738,1739,1753,1754,1741,1742,1732,1733","bundle_block_bookings":[{"confirmation_number":"CCB12866107144","room_stay_from":"2021-11-05","room_stay_to":"2021-11-07","bundle_room":"1","product_id":"1740"},{"confirmation_number":"CCB12837818547","room_stay_from":"2021-11-06","room_stay_to":"2021-11-07","bundle_room":"1","product_id":"1755"},{"confirmation_number":"CCB12816698630","room_stay_from":"2021-11-06","room_stay_to":"2021-11-07","bundle_room":"1","product_id":"1743"},{"confirmation_number":"CCB12895640810","room_stay_from":"2021-11-06","room_stay_to":"2021-12-31","bundle_room":"1","product_id":"1737"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5330557","reservation_id":"124442","confirmation_number":"CC12895792217","room_stay_from":"2021-11-06","room_stay_to":"2021-11-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.90","nightly_discount":"0","subtotal":"144.90","grand_total":"163.73","paid_amount":"163.73","room_type_id":"345","product_id":"1741","siteminder_id":"BDC-3205097273","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":"132408","customer_id":"132408","source_of_creation":"Booking.com","reservation_created_date":"2021-10-13 23:56:02","canceled_nights_data":"","product_name":"15 One Bedroom","ota_service_fee_amount":"0","commision_charges":"21.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"144.90","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331467","reservation_id":"125089","confirmation_number":"CC12863442036","room_stay_from":"2021-11-06","room_stay_to":"2021-11-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.35,80.19,80.19","nightly_discount":"0,0,0","subtotal":"269.73","grand_total":"304.79","paid_amount":"304.79","room_type_id":"346","product_id":"1742","siteminder_id":"BDC-2302184131","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":"133278","customer_id":"133278","source_of_creation":"Booking.com","reservation_created_date":"2021-11-05 18:43:38","canceled_nights_data":"","product_name":"16 Hotel Room","ota_service_fee_amount":"0","commision_charges":"40.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"109.35","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331695","reservation_id":"125119","confirmation_number":"CC12898304751","room_stay_from":"2021-11-06","room_stay_to":"2021-11-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.50","nightly_discount":"0","subtotal":"121.50","grand_total":"137.30","paid_amount":"137.30","room_type_id":"343","product_id":"1739","siteminder_id":"BDC-3430535998","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":"133317","customer_id":"133317","source_of_creation":"Booking.com","reservation_created_date":"2021-11-06 17:00:50","canceled_nights_data":"","product_name":"14 Hotel Room","ota_service_fee_amount":"0","commision_charges":"18.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"128","currentDayPrice":"121.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5330918","reservation_id":"124808","confirmation_number":"CC12840690823","room_stay_from":"2021-11-05","room_stay_to":"2021-11-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.63,99.63","nightly_discount":"0,0","subtotal":"199.26","grand_total":"225.17","paid_amount":"225.17","room_type_id":"351","product_id":"1747","siteminder_id":"EXP-1849487499","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":"132876","customer_id":"132876","source_of_creation":"Expedia","reservation_created_date":"2021-10-27 13:12:03","canceled_nights_data":"","product_name":"20 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"99.63","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331369","reservation_id":"125073","confirmation_number":"CC12870478002","room_stay_from":"2021-11-05","room_stay_to":"2021-11-07","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.63,99.63","nightly_discount":"0,0","subtotal":"199.26","grand_total":"225.17","paid_amount":"225.17","room_type_id":"358","product_id":"1754","siteminder_id":"EXP-1853409734","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":"133254","customer_id":"133254","source_of_creation":"Expedia","reservation_created_date":"2021-11-05 02:58:12","canceled_nights_data":"","product_name":"28 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"99.63","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5327864","reservation_id":"123153","confirmation_number":"CC12889341663","room_stay_from":"2021-11-03","room_stay_to":"2021-11-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,90.00,146.00,146.00,90.00,90.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"652.00","grand_total":"736.76","paid_amount":"736.76","room_type_id":"348","product_id":"1744","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":"130845","customer_id":"130845","source_of_creation":"FE","reservation_created_date":"2021-09-16 18:50:26","canceled_nights_data":"","product_name":"17 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"146.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"5322608","reservation_id":"120905","confirmation_number":"CC12882867047","room_stay_from":"2021-08-10","room_stay_to":"2021-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,169.00,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,56.66,0.20,56.66,56.66,56.66,56.66,56.66,56.66,56.66","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"6198.82","grand_total":"7004.67","paid_amount":"7004.67","room_type_id":"354","product_id":"1750","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":"128308","customer_id":"128308","source_of_creation":"PMS","reservation_created_date":"2021-08-09 14:06:07","canceled_nights_data":"","product_name":"24 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"56.66","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328475","reservation_id":"123909","confirmation_number":"CC12816128407","room_stay_from":"2021-10-29","room_stay_to":"2021-11-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.00,165.00,165.00,200.00,200.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"3135.00","grand_total":"3542.55","paid_amount":"3542.55","room_type_id":"356","product_id":"1752","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":"131740","customer_id":"131740","source_of_creation":"PMS","reservation_created_date":"2021-09-29 18:46:30","canceled_nights_data":"","product_name":"26 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"140.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328740","reservation_id":"115682","confirmation_number":"CC12839288399","room_stay_from":"2021-11-04","room_stay_to":"2021-11-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,146.00,146.00","nightly_discount":"0.00,0.00,0.00","subtotal":"382.00","grand_total":"431.66","paid_amount":"431.66","room_type_id":"355","product_id":"1751","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":"122446","customer_id":"122446","source_of_creation":"PMS","reservation_created_date":"2021-05-22 17:08:04","canceled_nights_data":"","product_name":"25 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"146.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329247","reservation_id":"110360","confirmation_number":"CC12854432862","room_stay_from":"2021-04-18","room_stay_to":"2022-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,0.00,63.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,0.00,83.33,83.33,0.00,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,73.33,0.00,0.00,0.00,73.33,73.33,73.33,73.33,73.33,73.33,40.33,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"6762.05","grand_total":"7641.11","paid_amount":"7639.98","room_type_id":"349","product_id":"1745","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":"108159","customer_id":"108159","source_of_creation":"PMS","reservation_created_date":"2021-04-10 18:16:41","canceled_nights_data":"","product_name":"18 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329883","reservation_id":"97842","confirmation_number":"CC12878581286","room_stay_from":"2020-09-07","room_stay_to":"2022-02-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.95,70.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"3835.75","grand_total":"4334.40","paid_amount":"221.20","room_type_id":"336","product_id":"1731","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":"103911","customer_id":"103911","source_of_creation":"PMS","reservation_created_date":"2020-07-16 23:49:34","canceled_nights_data":"","product_name":"2 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329986","reservation_id":"124910","confirmation_number":"CC12859709237","room_stay_from":"2021-11-01","room_stay_to":"2021-11-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1610.00","grand_total":"1819.30","paid_amount":"1819.30","room_type_id":"353","product_id":"1749","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":"133025","customer_id":"133025","source_of_creation":"PMS","reservation_created_date":"2021-10-30 19:36:44","canceled_nights_data":"","product_name":"23 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"115.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330148","reservation_id":"124845","confirmation_number":"CC12844053173","room_stay_from":"2021-11-04","room_stay_to":"2021-11-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"143.00,175.00,175.00","nightly_discount":"0.00,0.00,0.00","subtotal":"493.00","grand_total":"557.09","paid_amount":"557.09","room_type_id":"342","product_id":"1738","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":"132323","customer_id":"132323","source_of_creation":"PMS","reservation_created_date":"2021-10-28 16:17:54","canceled_nights_data":"","product_name":"12 One bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"175.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330330","reservation_id":"124019","confirmation_number":"CC12846014317","room_stay_from":"2021-10-20","room_stay_to":"2022-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,0.10,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.43,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,0.10,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0","subtotal":"8333.30","grand_total":"9416.63","paid_amount":"2825.00","room_type_id":"352","product_id":"1748","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":"131886","customer_id":"131886","source_of_creation":"PMS","reservation_created_date":"2021-10-01 19:07:25","canceled_nights_data":"","product_name":"22 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"83.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"5305164","reservation_id":"122128","confirmation_number":"CC12872596739","room_stay_from":"2021-09-19","room_stay_to":"2022-01-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.43,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,0.00,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.43,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.43,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.33,83.43,83.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"10000.00","grand_total":"10000.00","paid_amount":"7500.00","room_type_id":"350","product_id":"1746","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"129697","customer_id":"129697","source_of_creation":"PMS","reservation_created_date":"2021-08-28 22:18:58","canceled_nights_data":"","product_name":"19 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"83.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329657","reservation_id":"89952","confirmation_number":"CC12864084414","room_stay_from":"2021-06-21","room_stay_to":"2022-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,90.00,70.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,0.00,90.00,90.00,0.00,0.00,90.00,90.00,90.00,90.00,90.00,0.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,90.00,100.00,100.00,150.00,150.00,150.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"20380.00","grand_total":"20380.00","paid_amount":"12610.00","room_type_id":"337","product_id":"1732","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"78453","customer_id":"78453","source_of_creation":"PMS","reservation_created_date":"2021-05-30 16:24:26","canceled_nights_data":"","product_name":"3 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331828","reservation_id":"122135","confirmation_number":"CC12838102381","room_stay_from":"2021-08-29","room_stay_to":"2021-11-06","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,0.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00,35.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2380.00","grand_total":"2380.00","paid_amount":"1853.00","room_type_id":"338","product_id":"1733","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"111167","customer_id":"111167","source_of_creation":"PMS","reservation_created_date":"2021-08-29 12:09:53","canceled_nights_data":"","product_name":"4 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5329431","reservation_id":"124845","confirmation_number":"CC12821053299","room_confirmation_number":"CC12844053173","room_stay_from":"2021-11-04","room_stay_to":"2021-11-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1761","service_quantity":"1","product_name":"Travelling with pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-28 16:17:55","reservation_modified_date_time":"2021-10-28 16:17:55","customer_id":"132323","parentCustTravId":"132323","customer_traveller_id":"132323","static_pos_type":"petfee","product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-04","sub_hotel_id":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"112","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5329604","reservation_id":"123909","confirmation_number":"CC12838065429","room_confirmation_number":"CC12816128407","room_stay_from":"2021-10-29","room_stay_to":"2021-11-09","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"220.00","grand_total":"248.60","paid_amount":"248.60","product_id":"1761","service_quantity":"1","product_name":"Travelling with pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-29 16:26:50","reservation_modified_date_time":"2021-10-29 16:26:50","customer_id":"131740","parentCustTravId":"131740","customer_traveller_id":"131740","static_pos_type":"petfee","product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-10-29","sub_hotel_id":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"112","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"5331809","reservation_id":"125119","confirmation_number":"CC12832538519","room_confirmation_number":"CC12898304751","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"100.00","grand_total":"100.00","paid_amount":"0.00","product_id":"1769","service_quantity":"1","product_name":"Refundable Security Deposit for less than 7 day stay.","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-06 20:58:09","reservation_modified_date_time":"2021-11-06 20:58:09","customer_id":"133317","parentCustTravId":"133317","customer_traveller_id":"133317","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","parentRoomStayFrom":"2021-11-06","sub_hotel_id":"128","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"htl_taxable":[{"room_stay_id":"5330521","reservation_id":"124839","confirmation_number":"CC12839683222","room_stay_from":"2021-11-02","room_stay_to":"2021-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"102.50,81.18,81.18,110.70,110.70,81.18,81.18,81.18,81.18","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"810.98","grand_total":"916.41","paid_amount":"916.41","room_type_id":"357","product_id":"1753","siteminder_id":"HTL-1849968799","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":"93825","customer_id":"93825","source_of_creation":"Expedia","reservation_created_date":"2021-10-28 13:23:16","canceled_nights_data":"","product_name":"27 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"110.70","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}]}}