{ "hotel_id": "128", "sub_hotel_id": 0, "room_type": "hotel", "date": "2019-10-24", "total_rooms_exist": 18, "departureCount": 2, "holdBlockRooms": { "hold_room_count": "0", "hold_room_bookings": [], "block_room_count": "5", "block_room_bookings": [], "bundle_block_count": "0", "bundle_block_bookings": [] }, "resvInfo": { "bdc_taxable": [{ "room_stay_id": "3031672", "reservation_id": "86116", "confirmation_number": "CC12826459371", "room_stay_from": "2019-10-23", "room_stay_to": "2019-10-26", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "55.89,51.84,76.14", "nightly_discount": "0,0,0", "subtotal": "183.87", "grand_total": "207.77", "paid_amount": "207.77", "room_type_id": "354", "product_id": "1750", "siteminder_id": "BDC-2575413843", "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": "92980", "customer_id": "92980", "source_of_creation": "Booking.com", "reservation_created_date": "2019-10-23 04:01:06", "canceled_nights_data": "", "product_name": "24 Studio", "ota_service_fee_amount": "0", "commision_charges": "27.58", "resv_is_no_show": "0", "is_bundle": "0", "migrated_id": "", "currentDayPrice": "51.84", "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": "3032137", "reservation_id": "86178", "confirmation_number": "CC12874382513", "room_stay_from": "2019-10-24", "room_stay_to": "2019-10-25", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "64.80", "nightly_discount": "0", "subtotal": "64.80", "grand_total": "73.23", "paid_amount": "73.23", "room_type_id": "349", "product_id": "1745", "siteminder_id": "BDC-3873971406", "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": "93028", "customer_id": "93028", "source_of_creation": "Booking.com", "reservation_created_date": "2019-10-24 20:10:08", "canceled_nights_data": "", "product_name": "18 One Bedroom", "ota_service_fee_amount": "0", "commision_charges": "9.72", "resv_is_no_show": "0", "is_bundle": "0", "migrated_id": "", "currentDayPrice": "64.80", "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": "3032403", "reservation_id": "86136", "confirmation_number": "CC12855940873", "room_stay_from": "2019-10-24", "room_stay_to": "2019-10-26", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "55.08,55.08", "nightly_discount": "0,0", "subtotal": "110.16", "grand_total": "124.48", "paid_amount": "124.48", "room_type_id": "346", "product_id": "1742", "siteminder_id": "BDC-2194415637", "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": "92996", "customer_id": "92996", "source_of_creation": "Booking.com", "reservation_created_date": "2019-10-23 19:22:11", "canceled_nights_data": "", "product_name": "16 Hotel Room", "ota_service_fee_amount": "0", "commision_charges": "8.26", "resv_is_no_show": "0", "is_bundle": "0", "migrated_id": "", "currentDayPrice": "55.08", "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": "3037559", "reservation_id": "85688", "confirmation_number": "CC12893450683", "room_stay_from": "2019-10-15", "room_stay_to": "2019-11-19", "room_stay_status": "Closed", "room_stay_guest_count": "1", "room_stay_child_count": "0", "nightly_price": "65.70,57.15,57.15,57.15,57.15,57.15,57.15,71.48,71.42,71.42,71.42,71.42,71.42,71.42,71.48,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42,71.42", "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", "subtotal": "2408.48", "grand_total": "2721.58", "paid_amount": "2721.58", "room_type_id": "343", "product_id": "1739", "siteminder_id": "BDC-3652137410", "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": "92722", "customer_id": "92722", "source_of_creation": "Booking.com", "reservation_created_date": "2019-10-15 14:36:10", "canceled_nights_data": "", "product_name": "14 Hotel Room", "ota_service_fee_amount": "0", "commision_charges": "9.86", "resv_is_no_show": "0", "is_bundle": "0", "migrated_id": "", "currentDayPrice": "71.42", "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" }] }], "bdc_non_taxable": [], "exp_taxable": [], "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": "3031851", "reservation_id": "85319", "confirmation_number": "CC12841677076", "room_stay_from": "2019-10-23", "room_stay_to": "2019-10-29", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "83.00,98.00,108.00,108.00,83.00,83.00", "nightly_discount": "0.00,0.00,0.00,0.00,0.00,0.00", "subtotal": "563.00", "grand_total": "636.19", "paid_amount": "636.19", "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": "91368", "customer_id": "91368", "source_of_creation": "FE", "reservation_created_date": "2019-10-08 21:15:25", "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": "", "currentDayPrice": "98.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": "3031592", "reservation_id": "86103", "confirmation_number": "CC12837638336", "room_stay_from": "2019-10-22", "room_stay_to": "2019-10-25", "room_stay_status": "Closed", "room_stay_guest_count": "1", "room_stay_child_count": "0", "nightly_price": "65.00,65.00,65.00", "nightly_discount": "0.00,0.00,0.00", "subtotal": "195.00", "grand_total": "220.35", "paid_amount": "220.35", "room_type_id": "357", "product_id": "1753", "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": "92968", "customer_id": "92968", "source_of_creation": "PMS", "reservation_created_date": "2019-10-23 00:30:28", "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": "", "currentDayPrice": "65.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": "3032049", "reservation_id": "86166", "confirmation_number": "CC12880339072", "room_stay_from": "2019-10-24", "room_stay_to": "2019-10-25", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "54.00", "nightly_discount": "0.00", "subtotal": "54.00", "grand_total": "61.02", "paid_amount": "61.02", "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": "93022", "customer_id": "93022", "source_of_creation": "PMS", "reservation_created_date": "2019-10-24 15:47:40", "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": "", "currentDayPrice": "54.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": "3040773", "reservation_id": "83358", "confirmation_number": "CC12859363953", "room_stay_from": "2019-09-03", "room_stay_to": "2019-12-26", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,0.00,0.00,0.00,0.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,0.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.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", "subtotal": "5945.00", "grand_total": "6717.85", "paid_amount": "6717.85", "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": "90722", "customer_id": "90722", "source_of_creation": "PMS", "reservation_created_date": "2019-08-28 20:31:07", "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": "", "currentDayPrice": "50.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": "3042538", "reservation_id": "85005", "confirmation_number": "CC12868836785", "room_stay_from": "2019-10-02", "room_stay_to": "2019-11-29", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.00,45.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", "subtotal": "2610.00", "grand_total": "2949.30", "paid_amount": "3051.00", "room_type_id": "351", "product_id": "1747", "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": "92256", "customer_id": "92256", "source_of_creation": "PMS", "reservation_created_date": "2019-10-02 19:06:54", "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": "", "currentDayPrice": "45.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": "3032352", "reservation_id": "86206", "confirmation_number": "CC12850212926", "room_stay_from": "2019-10-24", "room_stay_to": "2019-10-25", "room_stay_status": "Checked-In", "room_stay_guest_count": "1", "room_stay_child_count": "0", "nightly_price": "40.00", "nightly_discount": "0.00", "subtotal": "40.00", "grand_total": "45.20", "paid_amount": "45.20", "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": "92826", "customer_id": "92826", "source_of_creation": "PMS", "reservation_created_date": "2019-10-25 08:24:17", "service_canceled_date_time": "", "canceled_nights_data": "", "product_name": "22 One Bedroom", "ota_service_fee_amount": "0", "commision_charges": "0.00", "deltaChange": "0.00", "changedComment": "reservation is canceled but amt paid", "currentDayPrice": 40, "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" }] }], "pms_non_taxable": [{ "room_stay_id": "3031730", "reservation_id": "82893", "confirmation_number": "CC12884419298", "room_stay_from": "2019-10-24", "room_stay_to": "2019-10-26", "room_stay_status": "Closed", "room_stay_guest_count": "1", "room_stay_child_count": "0", "nightly_price": "67.50,67.50", "nightly_discount": "0.00,0.00", "subtotal": "135.00", "grand_total": "135.00", "paid_amount": "135.00", "room_type_id": "345", "product_id": "1741", "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": "90383", "customer_id": "90383", "source_of_creation": "PMS", "reservation_created_date": "2019-08-18 21:03:26", "canceled_nights_data": "", "product_name": "15 One Bedroom", "ota_service_fee_amount": "0", "commision_charges": "0.00", "resv_is_no_show": "0", "is_bundle": "0", "migrated_id": "", "currentDayPrice": "67.50", "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": "3031803", "reservation_id": "85907", "confirmation_number": "CC12892361268", "room_stay_from": "2019-10-19", "room_stay_to": "2019-10-28", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "80.00,80.00,80.00,80.00,80.00,81.00,81.00,81.00,81.00", "nightly_discount": "0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00", "subtotal": "724.00", "grand_total": "724.00", "paid_amount": "724.00", "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": "1", "traveller_tax_exempt": "1", "customer_traveller_id": "92845", "customer_id": "92845", "source_of_creation": "PMS", "reservation_created_date": "2019-10-19 00:19:59", "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": "", "currentDayPrice": "81.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": "3041588", "reservation_id": "75682", "confirmation_number": "CC12875991159", "room_stay_from": "2019-06-01", "room_stay_to": "2019-11-26", "room_stay_status": "Closed", "room_stay_guest_count": "2", "room_stay_child_count": "0", "nightly_price": "566.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.86,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.86,0.00,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,0.20,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.86,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,0.20,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,466.82,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", "subtotal": "12500.00", "grand_total": "12500.00", "paid_amount": "12500.00", "room_type_id": "358", "product_id": "1754", "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": "85530", "customer_id": "85530", "source_of_creation": "PMS", "reservation_created_date": "2019-05-02 18:10:48", "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": "", "currentDayPrice": "66.66", "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" }] }], "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": "3031937", "reservation_id": "86116", "confirmation_number": "CC12822191852", "room_confirmation_number": "CC12826459371", "room_stay_from": "2019-10-23", "room_stay_to": "2019-10-26", "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": "64.20", "paid_amount": "64.20", "product_id": "1761", "service_quantity": "1", "product_name": "Travelling with pet", "parentTypeOfRes": "reservation", "reservation_created_date": "2019-10-23 22:58:25", "reservation_modified_date_time": "2019-10-23 22:58:25", "customer_id": "92980", "parentCustTravId": "92980", "customer_traveller_id": "92980", "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", "currentDayPrice": "20.00", "currentDayDiscount": "0.00", "productIsTaxExempt": false, "alcoholicDrinks": false, "taxes": [{ "tax_id": "113", "tax_name": "Sales Tax", "tax_percentage": "7.00" }] }], "gift_shop_non_taxable": [{ "room_stay_id": "3030095", "reservation_id": "85907", "confirmation_number": "CC12841133512", "room_confirmation_number": "CC12892361268", "room_stay_from": "2019-10-19", "room_stay_to": "2019-10-25", "room_stay_status": "Active", "nightly_price": "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", "subtotal": "120.00", "grand_total": "120.00", "paid_amount": "120.00", "product_id": "1761", "service_quantity": "1", "product_name": "Travelling with pet", "parentTypeOfRes": "reservation", "reservation_created_date": "2019-10-19 00:21:44", "reservation_modified_date_time": "2019-10-19 00:21:44", "customer_id": "92845", "parentCustTravId": "92845", "customer_traveller_id": "92845", "static_pos_type": "petfee", "product_is_timebound": "1", "tax_exempt_status": "1", "traveller_tax_exempt": "1", "product_discount": "0.00", "product_attribute_values": null, "is_tip_product": "0", "currentDayPrice": "20.00", "currentDayDiscount": "0.00", "productIsTaxExempt": true, "alcoholicDrinks": false, "taxes": [{ "tax_id": "113", "tax_name": "Sales Tax", "tax_percentage": "7.00" }] }], "bar_taxable": [], "bar_non_taxable": [], "restaurant_taxable": [], "restaurant_non_taxable": [] } }