{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-25","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":30,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1302,1303,1311,1312,1307,1308,1269,1270,1271,1272,1309,1310,1262,1263,1260,1261,1267,1268,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12695252704","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12651322647","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12631337337","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12653011671","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12673178489","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12674784405","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12670599755","room_stay_from":"2021-04-25","room_stay_to":"2021-04-27","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12626690399","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12680339226","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12621381975","room_stay_from":"2021-04-25","room_stay_to":"2021-04-27","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12635983904","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12632531273","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12654322498","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","bundle_room":"1","product_id":"1714"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3200962","reservation_id":"108044","confirmation_number":"SJ12664906924","room_stay_from":"2021-04-23","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.25,224.25,194.25","nightly_discount":"0,0,0","subtotal":"642.75","grand_total":"723.10","paid_amount":"723.10","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3090934456","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":"114509","customer_id":"114509","source_of_creation":"Booking.com","reservation_created_date":"2021-02-19 16:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"129.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3221423","reservation_id":"110949","confirmation_number":"SJ12663575483","room_stay_from":"2021-04-24","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,215.20","nightly_discount":"0,0","subtotal":"534.40","grand_total":"601.20","paid_amount":"601.20","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-3971718957","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":"117486","customer_id":"117486","source_of_creation":"Booking.com","reservation_created_date":"2021-03-22 03:29:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.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":"3231080","reservation_id":"112492","confirmation_number":"SJ12676756070","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"309.14","nightly_discount":"0","subtotal":"309.14","grand_total":"347.79","paid_amount":"347.79","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3515108307","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":"119065","customer_id":"119065","source_of_creation":"Booking.com","reservation_created_date":"2021-04-09 02:37:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"60.15","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"309.14","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":"3238295","reservation_id":"113519","confirmation_number":"SJ12632660000","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.90","nightly_discount":"0","subtotal":"300.90","grand_total":"338.52","paid_amount":"338.52","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-2153744041","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":"120114","customer_id":"120114","source_of_creation":"Booking.com","reservation_created_date":"2021-04-21 03:31:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"58.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"300.90","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":"3241326","reservation_id":"113811","confirmation_number":"SJ12659755174","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.68","nightly_discount":"0","subtotal":"251.68","grand_total":"283.14","paid_amount":"283.14","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3326538495","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":"120432","customer_id":"120432","source_of_creation":"Booking.com","reservation_created_date":"2021-04-24 20:44:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"49.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.68","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":"3241368","reservation_id":"112635","confirmation_number":"SJ12635520122","room_stay_from":"2021-04-24","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,287.20","nightly_discount":"0,0","subtotal":"630.40","grand_total":"709.20","paid_amount":"709.20","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3736185818","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":"119220","customer_id":"119220","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 21:54:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"122.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"287.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":"3226268","reservation_id":"111868","confirmation_number":"SJ12634104097","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"273.32,253.07,205.83,205.83","nightly_discount":"0,0,0,0","subtotal":"938.05","grand_total":"1055.30","paid_amount":"1055.30","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3495364224","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118433","customer_id":"118433","source_of_creation":"Booking.com","reservation_created_date":"2021-04-02 01:48:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"222.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"205.83","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":"3240204","reservation_id":"111049","confirmation_number":"SJ12626262105","room_stay_from":"2021-04-25","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"193.75,193.75","nightly_discount":"0,0","subtotal":"387.50","grand_total":"435.94","paid_amount":"435.94","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2559617179","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":"117591","customer_id":"117591","source_of_creation":"Booking.com","reservation_created_date":"2021-03-23 01:49:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"78.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"193.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":"3241386","reservation_id":"111737","confirmation_number":"SJ12686300112","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.07,201.82,201.82","nightly_discount":"0,0,0","subtotal":"652.71","grand_total":"734.30","paid_amount":"734.30","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3766425896","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":"118296","customer_id":"118296","source_of_creation":"Booking.com","reservation_created_date":"2021-03-31 02:06:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.82","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":"3241437","reservation_id":"108874","confirmation_number":"SJ12677488536","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.25,186.75,186.75","nightly_discount":"0,0,0","subtotal":"597.75","grand_total":"672.47","paid_amount":"672.47","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3095990564","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":"115340","customer_id":"115340","source_of_creation":"Booking.com","reservation_created_date":"2021-02-28 22:17:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"186.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":"3186984","reservation_id":"106408","confirmation_number":"SJ12622282653","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.30,160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"829.50","grand_total":"933.19","paid_amount":"933.19","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3167840611","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":"112805","customer_id":"112805","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 14:25:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"171.81","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","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":"3203653","reservation_id":"106362","confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,188.37,188.37,163.17,163.17,163.17","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1192.59","grand_total":"1341.66","paid_amount":"1341.66","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2673763646","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":"112757","customer_id":"112757","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 23:36:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"246.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.37","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":"3225777","reservation_id":"108082","confirmation_number":"SJ12644271695","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"181.30,181.30,181.30,181.30,181.30","nightly_discount":"0,0,0,0,0","subtotal":"906.50","grand_total":"1019.82","paid_amount":"0.00","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-3165351230","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":"114547","customer_id":"114547","source_of_creation":"Booking.com","reservation_created_date":"2021-02-20 00:30:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"185.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.30","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":"3229813","reservation_id":"109832","confirmation_number":"SJ12639370317","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.85,146.85,146.85,146.85,146.85","nightly_discount":"0,0,0,0,0","subtotal":"734.25","grand_total":"826.03","paid_amount":"826.03","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-3548480543","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":"116323","customer_id":"116323","source_of_creation":"Booking.com","reservation_created_date":"2021-03-09 04:45:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"154.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"146.85","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":"3241860","reservation_id":"111648","confirmation_number":"SJ12673975702","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,209.30,209.30,209.30","nightly_discount":"0,0,0,0,0","subtotal":"1046.50","grand_total":"1177.32","paid_amount":"1177.32","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-2349742095","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":"118206","customer_id":"118206","source_of_creation":"Booking.com","reservation_created_date":"2021-03-30 00:49:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"210.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"209.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3238068","reservation_id":"113482","confirmation_number":"SJ12624189117","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"5","nightly_price":"339.32","nightly_discount":"0","subtotal":"339.32","grand_total":"381.74","paid_amount":"381.74","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1761787781","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":"120073","customer_id":"120073","source_of_creation":"Expedia","reservation_created_date":"2021-04-20 17:44:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"339.32","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":"3239261","reservation_id":"111503","confirmation_number":"SJ12613375479","room_stay_from":"2021-04-23","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.40,257.40,197.40","nightly_discount":"0,0,0","subtotal":"712.20","grand_total":"801.23","paid_amount":"801.23","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1753076821","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":"118071","customer_id":"118071","source_of_creation":"Expedia","reservation_created_date":"2021-03-28 15:37:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"197.40","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":"3241373","reservation_id":"112297","confirmation_number":"SJ12678532575","room_stay_from":"2021-04-24","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.36,210.56","nightly_discount":"0,0","subtotal":"465.92","grand_total":"524.16","paid_amount":"524.16","room_type_id":"319","product_id":"1307","siteminder_id":"EXP-1756643540","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":"118865","customer_id":"118865","source_of_creation":"Expedia","reservation_created_date":"2021-04-07 01:37:10","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"210.56","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":"3239412","reservation_id":"113610","confirmation_number":"SJ12696335359","room_stay_from":"2021-04-25","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.36,191.36","nightly_discount":"0,0","subtotal":"382.72","grand_total":"430.56","paid_amount":"430.56","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1762414716","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":"120213","customer_id":"120213","source_of_creation":"Expedia","reservation_created_date":"2021-04-22 05:24:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"191.36","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":"3241439","reservation_id":"111143","confirmation_number":"SJ12631675449","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"321.75,224.25,224.25","nightly_discount":"0,0,0","subtotal":"770.25","grand_total":"866.53","paid_amount":"866.53","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1751315031","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":"117674","customer_id":"117674","source_of_creation":"Expedia","reservation_created_date":"2021-03-24 00:17:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3241476","reservation_id":"111710","confirmation_number":"SJ12649963911","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"341.40,299.40,299.40","nightly_discount":"0.00,0.00,0.00","subtotal":"940.20","grand_total":"1057.73","paid_amount":"1057.73","room_type_id":"320","product_id":"1910","siteminder_id":"EXP-1753977484","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":"118270","customer_id":"118270","source_of_creation":"Expedia","reservation_created_date":"2021-03-30 21:07:06","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"299.40","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":"3220547","reservation_id":"109853","confirmation_number":"SJ12657862971","room_stay_from":"2021-04-24","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"296.80,198.80,198.80,198.80","nightly_discount":"0,0,0,0","subtotal":"893.20","grand_total":"1004.85","paid_amount":"1004.85","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1745625422","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":"116342","customer_id":"116342","source_of_creation":"Expedia","reservation_created_date":"2021-03-09 16:02:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240821","reservation_id":"111798","confirmation_number":"SJ12646026602","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.36,210.56,210.56","nightly_discount":"0,0,0","subtotal":"676.48","grand_total":"761.04","paid_amount":"761.04","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1754428884","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":"120388","customer_id":"118355","source_of_creation":"Expedia","reservation_created_date":"2021-03-31 23:23:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"255.36","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":"3209466","reservation_id":"109473","confirmation_number":"SJ12699179345","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"216.30,216.30,216.30,216.30,216.30","nightly_discount":"0,0,0,0,0","subtotal":"1081.50","grand_total":"1216.69","paid_amount":"1216.69","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1744192042","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":"115940","customer_id":"115940","source_of_creation":"Expedia","reservation_created_date":"2021-03-05 12:42:13","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"216.30","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":"3241866","reservation_id":"109340","confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"191.3,191.3,191.3,191.3,191.3","nightly_discount":"0,0,0,0,0","subtotal":"956.50","grand_total":"1076.07","paid_amount":"1076.07","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1743861784","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"125.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115805","customer_id":"115805","source_of_creation":"Expedia","reservation_created_date":"2021-03-04 15:32:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"191.3","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3240874","reservation_id":"113776","confirmation_number":"SJ12693709498","room_stay_from":"2021-04-24","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"244.80,195.16","nightly_discount":"0,0","subtotal":"439.96","grand_total":"494.96","paid_amount":"494.96","room_type_id":"413","product_id":"1264","siteminder_id":"HTN-159189886-DWP2C3","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":"120391","customer_id":"120391","source_of_creation":"HotelTonight","reservation_created_date":"2021-04-24 15:44:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.16","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3208470","reservation_id":"109233","confirmation_number":"SJ12672816426","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.02,243.38,243.38,163.02","nightly_discount":"0,0,0,0","subtotal":"812.80","grand_total":"914.40","paid_amount":"914.40","room_type_id":"412","product_id":"1316","siteminder_id":"GAM-R2360305570","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":"115701","customer_id":"115701","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-04 00:14:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.02","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":"3239915","reservation_id":"111811","confirmation_number":"SJ12637288962","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.40","nightly_discount":"0","subtotal":"208.40","grand_total":"234.45","paid_amount":"234.45","room_type_id":"319","product_id":"1277","siteminder_id":"GAM-R2421222996","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":"118368","customer_id":"118368","source_of_creation":"Getaroom.com","reservation_created_date":"2021-04-01 08:53:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"208.40","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3241623","reservation_id":"111789","confirmation_number":"SJ12657864593","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"298.08","nightly_discount":"0.00","subtotal":"298.08","grand_total":"345.43","paid_amount":"345.43","room_type_id":"413","product_id":"1269","siteminder_id":"ABB-HMXME3R8WQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"299.88","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118346","customer_id":"118346","source_of_creation":"Airbnb","reservation_created_date":"2021-03-31 22:18:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"8.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"298.08","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":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3240281","reservation_id":"112334","confirmation_number":"SJ12694083777","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"340.94,340.94,340.94,332.76","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1355.58","grand_total":"1570.94","paid_amount":"1570.94","room_type_id":"319","product_id":"1913","siteminder_id":"ABB-HMFJHT24ZH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1363.76","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118903","customer_id":"118903","source_of_creation":"Airbnb","reservation_created_date":"2021-04-07 15:26:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"40.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"340.94","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":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3241629","reservation_id":"112594","confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"294.56,302.42,302.42,302.42","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1201.82","grand_total":"1408.04","paid_amount":"1408.04","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HMAEN8DJMB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"1209.68","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119174","customer_id":"119174","source_of_creation":"Airbnb","reservation_created_date":"2021-04-10 14:42:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"38.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"294.56","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":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3203889","reservation_id":"108477","confirmation_number":"SJ12658659294","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.00,265.50,265.50,228.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114923","customer_id":"114923","source_of_creation":"FE","reservation_created_date":"2021-02-24 20:25:52","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","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":"228.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":"3235114","reservation_id":"111729","confirmation_number":"SJ12646726301","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"326.40","nightly_discount":"0.00","subtotal":"326.40","grand_total":"367.20","paid_amount":"367.20","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":"118286","customer_id":"118286","source_of_creation":"FE","reservation_created_date":"2021-03-31 01:15:41","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","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":"326.40","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":"3221405","reservation_id":"110687","confirmation_number":"SJ12629677888","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,224.25,224.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1047.00","grand_total":"1177.88","paid_amount":"1177.88","room_type_id":"319","product_id":"1318","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":"117198","customer_id":"117198","source_of_creation":"FE","reservation_created_date":"2021-03-19 03:42:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","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":"224.25","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":"3241388","reservation_id":"112287","confirmation_number":"SJ12695795393","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,246.75,246.75","nightly_discount":"0.00,0.00,0.00","subtotal":"792.75","grand_total":"891.85","paid_amount":"891.85","room_type_id":"319","product_id":"1286","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":"120329","customer_id":"111048","source_of_creation":"FE","reservation_created_date":"2021-04-06 23:41:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","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":"246.75","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":"3241826","reservation_id":"113656","confirmation_number":"SJ12633417059","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75","nightly_discount":"12.34,12.34,12.34","subtotal":"740.25","grand_total":"791.13","paid_amount":"791.13","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":"120256","customer_id":"120256","source_of_creation":"FE","reservation_created_date":"2021-04-22 21:32:50","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":"","promotion_code":"AAA","sub_hotel_id":"0","currentDayPrice":"246.75","currentDayDiscount":"12.34","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":"3230996","reservation_id":"112477","confirmation_number":"SJ12640020586","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"319","product_id":"1301","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":"119036","customer_id":"119036","source_of_creation":"FE","reservation_created_date":"2021-04-08 23:27:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","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":"246.75","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":"3241265","reservation_id":"111377","confirmation_number":"SJ12635010341","room_stay_from":"2021-04-24","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"321.75,246.75,246.75,246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1555.50","grand_total":"1749.94","paid_amount":"1749.94","room_type_id":"319","product_id":"1313","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":"117921","customer_id":"117921","source_of_creation":"FE","reservation_created_date":"2021-03-26 20:48:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","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":"3236952","reservation_id":"113173","confirmation_number":"SJ12683344315","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65","nightly_discount":"0.00","subtotal":"279.65","grand_total":"314.60","paid_amount":"314.60","room_type_id":"413","product_id":"1271","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":"119763","customer_id":"119763","source_of_creation":"PMS","reservation_created_date":"2021-04-17 13:18:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","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":"279.65","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":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3204810","reservation_id":"108593","confirmation_number":"SJ12622016529","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:30:39","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","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":"86.67","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":"3236954","reservation_id":"100701","confirmation_number":"SJ12688302981","room_stay_from":"2021-04-22","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"462.00","grand_total":"462.00","paid_amount":"140.63","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-09-22 00:31:37","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","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":"87.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":"3162577","reservation_id":"103547","confirmation_number":"SJ12676618165","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"168.76","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-12-06 22:32:44","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3181589","reservation_id":"105687","confirmation_number":"SJ12615222602","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-20 00:06:26","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","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":"86.67","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":"3197807","reservation_id":"107394","confirmation_number":"SJ12626812437","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-12 01:22:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","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":"86.67","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":"3204806","reservation_id":"108591","confirmation_number":"SJ12653667920","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:25:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","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":"87.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":"3215882","reservation_id":"108592","confirmation_number":"SJ12694732411","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"685.13","paid_amount":"196.88","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:27:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","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":"87.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":"3185832","reservation_id":"95536","confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"869.99","grand_total":"869.99","paid_amount":"281.25","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-28 14:11:36","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","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":"87.14","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":"3229909","reservation_id":"95534","confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1219.96","grand_total":"1219.96","paid_amount":"393.75","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-28 14:06:38","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","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":"87.14","currentDayDiscount":"0","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3226269","reservation_id":"111868","confirmation_number":"SJ12629374574","room_confirmation_number":"SJ12634104097","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"118433","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-02 01:48:12","reservation_modified_date_time":"2021-04-02 01:48:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118433","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","sub_hotel_id":"126","currentDayPrice":"50","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":"3239135","reservation_id":"112594","confirmation_number":"SJ12671345290","room_confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"100.60","paid_amount":"100.60","product_id":"1777","service_quantity":"1","customer_traveller_id":"119174","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-21 20:31:51","reservation_modified_date_time":"2021-04-21 20:31:51","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119174","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","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":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3241867","reservation_id":"109340","confirmation_number":"SJ12652298870","room_confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1777","service_quantity":"1","customer_traveller_id":"115805","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-25 19:29:35","reservation_modified_date_time":"2021-04-25 19:29:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.00","sub_hotel_id":"126","currentDayPrice":"25","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3200963","reservation_id":"108044","confirmation_number":"SJ12656269578","room_confirmation_number":"SJ12664906924","room_stay_from":"2021-04-23","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"25,25,25","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":"114509","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-19 16:13:10","reservation_modified_date_time":"2021-02-19 16:16:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114509","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","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":"3203890","reservation_id":"108477","confirmation_number":"SJ12669079365","room_confirmation_number":"SJ12658659294","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","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":"114923","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 20:25:52","reservation_modified_date_time":"2021-02-24 20:25:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114923","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3208471","reservation_id":"109233","confirmation_number":"SJ12640303614","room_confirmation_number":"SJ12672816426","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","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":"115701","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:14:12","reservation_modified_date_time":"2021-03-04 00:14:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115701","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3221424","reservation_id":"110949","confirmation_number":"SJ12642827183","room_confirmation_number":"SJ12663575483","room_stay_from":"2021-04-24","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"117486","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 03:29:15","reservation_modified_date_time":"2021-03-24 01:15:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117486","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3231081","reservation_id":"112492","confirmation_number":"SJ12616040387","room_confirmation_number":"SJ12676756070","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","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":"119065","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-09 02:37:07","reservation_modified_date_time":"2021-04-09 02:37:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119065","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3235115","reservation_id":"111729","confirmation_number":"SJ12684594187","room_confirmation_number":"SJ12646726301","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","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":"118286","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 01:15:41","reservation_modified_date_time":"2021-04-15 20:34:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118286","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3236953","reservation_id":"113173","confirmation_number":"SJ12620273218","room_confirmation_number":"SJ12683344315","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","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":"119763","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 13:18:11","reservation_modified_date_time":"2021-04-18 18:15:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119763","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3238069","reservation_id":"113482","confirmation_number":"SJ12640969622","room_confirmation_number":"SJ12624189117","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","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":"120073","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 17:44:11","reservation_modified_date_time":"2021-04-20 17:44:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120073","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3238296","reservation_id":"113519","confirmation_number":"SJ12614951394","room_confirmation_number":"SJ12632660000","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","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":"120114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 03:31:09","reservation_modified_date_time":"2021-04-21 03:31:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120114","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3239262","reservation_id":"111503","confirmation_number":"SJ12687305635","room_confirmation_number":"SJ12613375479","room_stay_from":"2021-04-23","room_stay_to":"2021-04-26","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":"118071","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 15:37:08","reservation_modified_date_time":"2021-04-21 22:26:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118071","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3239916","reservation_id":"111811","confirmation_number":"SJ12660369812","room_confirmation_number":"SJ12637288962","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","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":"118368","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-01 08:53:06","reservation_modified_date_time":"2021-04-22 19:58:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118368","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3240875","reservation_id":"113776","confirmation_number":"SJ12680308453","room_confirmation_number":"SJ12693709498","room_stay_from":"2021-04-24","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"120391","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 15:44:10","reservation_modified_date_time":"2021-04-24 15:44:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120391","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241327","reservation_id":"113811","confirmation_number":"SJ12668053518","room_confirmation_number":"SJ12659755174","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","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":"120432","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 20:44:12","reservation_modified_date_time":"2021-04-24 20:44:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120432","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241369","reservation_id":"112635","confirmation_number":"SJ12681046281","room_confirmation_number":"SJ12635520122","room_stay_from":"2021-04-24","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"119220","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 21:54:12","reservation_modified_date_time":"2021-04-24 21:39:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119220","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241375","reservation_id":"112297","confirmation_number":"SJ12633210437","room_confirmation_number":"SJ12678532575","room_stay_from":"2021-04-24","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"118865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 01:37:10","reservation_modified_date_time":"2021-04-24 21:40:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118865","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241625","reservation_id":"111789","confirmation_number":"SJ12674565567","room_confirmation_number":"SJ12657864593","room_stay_from":"2021-04-25","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118346","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 22:18:06","reservation_modified_date_time":"2021-04-25 12:12:03","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118346","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3204811","reservation_id":"108593","confirmation_number":"SJ12650189095","room_confirmation_number":"SJ12622016529","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115031","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:30:39","reservation_modified_date_time":"2021-02-26 01:30:39","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3221406","reservation_id":"110687","confirmation_number":"SJ12614112515","room_confirmation_number":"SJ12629677888","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","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":"117198","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 03:42:53","reservation_modified_date_time":"2021-03-24 01:08:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117198","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3226270","reservation_id":"111868","confirmation_number":"SJ12646682984","room_confirmation_number":"SJ12634104097","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","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":"118433","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-02 01:48:12","reservation_modified_date_time":"2021-04-02 01:48:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118433","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","sub_hotel_id":"126","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":"3236955","reservation_id":"100701","confirmation_number":"SJ12652259620","room_confirmation_number":"SJ12688302981","room_stay_from":"2021-04-22","room_stay_to":"2021-04-27","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"106727","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-22 00:31:37","reservation_modified_date_time":"2021-04-18 18:15:30","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3239413","reservation_id":"113610","confirmation_number":"SJ12652846043","room_confirmation_number":"SJ12696335359","room_stay_from":"2021-04-25","room_stay_to":"2021-04-27","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":"120213","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 05:24:09","reservation_modified_date_time":"2021-04-22 05:24:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120213","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3240205","reservation_id":"111049","confirmation_number":"SJ12666326059","room_confirmation_number":"SJ12626262105","room_stay_from":"2021-04-25","room_stay_to":"2021-04-27","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":"117591","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 01:49:09","reservation_modified_date_time":"2021-04-23 13:11:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117591","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3240282","reservation_id":"112334","confirmation_number":"SJ12694489162","room_confirmation_number":"SJ12694083777","room_stay_from":"2021-04-23","room_stay_to":"2021-04-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118903","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 15:26:29","reservation_modified_date_time":"2021-04-23 15:08:59","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118903","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3241387","reservation_id":"111737","confirmation_number":"SJ12684497646","room_confirmation_number":"SJ12686300112","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"118296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 02:06:25","reservation_modified_date_time":"2021-04-24 22:03:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118296","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241389","reservation_id":"112287","confirmation_number":"SJ12616492974","room_confirmation_number":"SJ12695795393","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"120329","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-06 23:41:34","reservation_modified_date_time":"2021-04-24 22:03:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3241438","reservation_id":"108874","confirmation_number":"SJ12637578126","room_confirmation_number":"SJ12677488536","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"115340","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-28 22:17:17","reservation_modified_date_time":"2021-04-24 22:32:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115340","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241440","reservation_id":"111143","confirmation_number":"SJ12681935334","room_confirmation_number":"SJ12631675449","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"117674","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 00:17:07","reservation_modified_date_time":"2021-04-24 22:32:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117674","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241479","reservation_id":"111710","confirmation_number":"SJ12688504041","room_confirmation_number":"SJ12649963911","room_stay_from":"2021-04-24","room_stay_to":"2021-04-27","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":"118270","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 21:07:06","reservation_modified_date_time":"2021-04-24 22:40:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118270","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3162578","reservation_id":"103547","confirmation_number":"SJ12659212250","room_confirmation_number":"SJ12676618165","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109780","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 22:32:44","reservation_modified_date_time":"2020-12-06 22:32:44","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3181590","reservation_id":"105687","confirmation_number":"SJ12616678092","room_confirmation_number":"SJ12615222602","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109780","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 00:06:26","reservation_modified_date_time":"2021-01-20 00:06:26","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3197809","reservation_id":"107394","confirmation_number":"SJ12620981836","room_confirmation_number":"SJ12626812437","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113851","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 01:22:15","reservation_modified_date_time":"2021-02-14 11:20:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3220548","reservation_id":"109853","confirmation_number":"SJ12643952456","room_confirmation_number":"SJ12657862971","room_stay_from":"2021-04-24","room_stay_to":"2021-04-28","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":"116342","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 16:02:13","reservation_modified_date_time":"2021-03-22 17:26:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116342","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3240822","reservation_id":"111798","confirmation_number":"SJ12667185752","room_confirmation_number":"SJ12646026602","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","room_stay_status":"Active","nightly_price":"25,25,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":"120388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 23:23:10","reservation_modified_date_time":"2021-04-24 15:17:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118355","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","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":"3241828","reservation_id":"113656","confirmation_number":"SJ12676989983","room_confirmation_number":"SJ12633417059","room_stay_from":"2021-04-25","room_stay_to":"2021-04-28","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":"120256","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 21:32:50","reservation_modified_date_time":"2021-04-25 18:45:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120256","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3186985","reservation_id":"106408","confirmation_number":"SJ12676184823","room_confirmation_number":"SJ12622282653","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","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":"112805","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:25:06","reservation_modified_date_time":"2021-01-29 14:25:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3230997","reservation_id":"112477","confirmation_number":"SJ12612977296","room_confirmation_number":"SJ12640020586","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","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":"119036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 23:27:41","reservation_modified_date_time":"2021-04-08 23:27:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119036","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3241630","reservation_id":"112594","confirmation_number":"SJ12631670970","room_confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119174","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 14:42:10","reservation_modified_date_time":"2021-04-25 12:27:04","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119174","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3203654","reservation_id":"106362","confirmation_number":"SJ12667638930","room_confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","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":"112757","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 23:36:12","reservation_modified_date_time":"2021-02-24 15:20:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112757","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","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":"3204807","reservation_id":"108591","confirmation_number":"SJ12659138449","room_confirmation_number":"SJ12653667920","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:25:32","reservation_modified_date_time":"2021-02-26 01:25:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3209467","reservation_id":"109473","confirmation_number":"SJ12645666649","room_confirmation_number":"SJ12699179345","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"115940","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 12:42:13","reservation_modified_date_time":"2021-03-05 12:42:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115940","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3215883","reservation_id":"108592","confirmation_number":"SJ12639140046","room_confirmation_number":"SJ12694732411","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:27:18","reservation_modified_date_time":"2021-03-15 01:48:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3225779","reservation_id":"108082","confirmation_number":"SJ12624173523","room_confirmation_number":"SJ12644271695","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114547","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-20 00:30:12","reservation_modified_date_time":"2021-04-01 12:28:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114547","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3229816","reservation_id":"109832","confirmation_number":"SJ12683788974","room_confirmation_number":"SJ12639370317","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"116323","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 04:45:11","reservation_modified_date_time":"2021-04-07 17:27:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116323","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241266","reservation_id":"111377","confirmation_number":"SJ12656905055","room_confirmation_number":"SJ12635010341","room_stay_from":"2021-04-24","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"117921","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 20:48:05","reservation_modified_date_time":"2021-04-24 19:27:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117921","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3241862","reservation_id":"111648","confirmation_number":"SJ12622373879","room_confirmation_number":"SJ12673975702","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"118206","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 00:49:07","reservation_modified_date_time":"2021-04-25 19:29:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118206","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3241868","reservation_id":"109340","confirmation_number":"SJ12638988346","room_confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"115805","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 15:32:11","reservation_modified_date_time":"2021-04-25 19:29:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.00","sub_hotel_id":"126","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":"3185833","reservation_id":"95536","confirmation_number":"SJ12671781895","room_confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:11:36","reservation_modified_date_time":"2021-01-27 21:49:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3229910","reservation_id":"95534","confirmation_number":"SJ12670678562","room_confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:06:38","reservation_modified_date_time":"2021-04-07 18:29:47","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3241662","reservation_id":"113839","confirmation_number":"SJ12638959370","room_confirmation_number":"SJ12614430471","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"10.00","paid_amount":"10.00","product_id":"1657","service_quantity":"1","product_name":"Visor","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-25 14:30:22","reservation_modified_date_time":"2021-04-25 14:30:22","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,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"9.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3241663","reservation_id":"113839","confirmation_number":"SJ12631279106","room_confirmation_number":"SJ12614430471","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"29.99","grand_total":"32.24","paid_amount":"32.24","product_id":"1664","service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-25 14:30:22","reservation_modified_date_time":"2021-04-25 14:30:22","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,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"29.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3241667","reservation_id":"113840","confirmation_number":"SJ12645075627","room_confirmation_number":"SJ12652236210","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"10.00","paid_amount":"10.00","product_id":"1657","service_quantity":"1","product_name":"Visor","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-25 14:33:24","reservation_modified_date_time":"2021-04-25 14:33:24","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,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"9.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3241893","reservation_id":"113872","confirmation_number":"SJ12674052050","room_confirmation_number":"SJ12614468267","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"20.00","paid_amount":"20.00","product_id":"1657","service_quantity":"2","product_name":"Visor","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-25 19:55:00","reservation_modified_date_time":"2021-04-25 19:55: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,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"18.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3241894","reservation_id":"113872","confirmation_number":"SJ12680672799","room_confirmation_number":"SJ12614468267","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"29.99","grand_total":"32.24","paid_amount":"32.24","product_id":"1664","service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-25 19:55:00","reservation_modified_date_time":"2021-04-25 19:55: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,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"29.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}