Test Page - This page is for testing purposes only. It is not intended for production use. All Tests

Ledger transactions (folio_transactions)

Reset
447467 rows (page 2057/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
221735 2026-05-07 charge 7012 Spa Service Charge SPA 49.50 houseAccount #13 14209 opera:ft:17356859
221734 2026-05-07 credit 7015 Spa Massage Discount DSC -90.00 houseAccount #13 14209 opera:ft:17356858
221733 2026-05-07 charge 7002 Spa Massage SPA 225.00 houseAccount #13 14209 opera:ft:17356857
221732 2026-05-07 charge 7014 Spa Sales Tax 4.81 guest #5172 4897 opera:ft:17356854 CLIFTON
221731 2026-05-07 charge 7012 Spa Service Charge SPA 51.70 guest #5172 4897 opera:ft:17356853 CLIFTON
221730 2026-05-07 charge 7000 Spa Skin Care SPA 235.00 guest #5172 4897 opera:ft:17356852 CLIFTON
221729 2026-05-07 charge 7014 Spa Sales Tax 4.60 guest #5172 4897 opera:ft:17356851 CLIFTON
221728 2026-05-07 charge 7012 Spa Service Charge SPA 49.50 guest #5172 4897 opera:ft:17356850 CLIFTON
221727 2026-05-07 charge 7002 Spa Massage SPA 225.00 guest #5172 4897 opera:ft:17356849 CLIFTON
221726 2026-05-07 payment 9028 F&B Visa CARD -13.12 houseAccount #19 14234 opera:ft:17356848
221725 2026-05-07 charge 3105 Spa F&B Tax 1.12 houseAccount #19 14234 opera:ft:17356847
221724 2026-05-07 credit 3106 Spa Food Discount DSC -8.00 houseAccount #19 14234 opera:ft:17356846
221723 2026-05-07 charge 3100 Spa Food RST 20.00 houseAccount #19 14234 opera:ft:17356845
221722 2026-05-07 charge 7014 Spa Sales Tax 4.60 houseAccount #15 14222 opera:ft:17356844 SPA TRAINING
221721 2026-05-07 charge 7012 Spa Service Charge SPA 49.50 houseAccount #15 14222 opera:ft:17356843 SPA TRAINING
221720 2026-05-07 charge 7002 Spa Massage SPA 225.00 houseAccount #15 14222 opera:ft:17356842 SPA TRAINING
221719 2026-05-07 charge 3105 Spa F&B Tax 11.44 reservation #2106 3432 opera:ft:17356841
221718 2026-05-07 charge 2136 Spa Pool Service Charge RST 24.60 reservation #2106 3432 opera:ft:17356840
221717 2026-05-07 charge 3100 Spa Food RST 123.00 reservation #2106 3432 opera:ft:17356839
221716 2026-05-07 charge 7515 Class Late Cancellation Fee CLS -30.00 reservation #4231 14259 opera:ft:17356838 Guest was told at check in she would nop...
221715 2026-05-07 charge 2116 Seed Lunch Sales Tax 3.07 reservation #1111 2125 opera:ft:17356837
221714 2026-05-07 charge 1900 Seed Service Charge RST 5.94 reservation #1111 2125 opera:ft:17356836
221713 2026-05-07 charge 2103 Seed Lunch LUN 33.00 reservation #1111 2125 opera:ft:17356835
221712 2026-05-07 payment 9006 American Express CARD 30.00 reservation #4231 10694 opera:ft:17356834
221711 2026-05-07 payment 9027 F&B Mastercard CARD -10.84 houseAccount #23 14227 opera:ft:17356833
221710 2026-05-07 charge 2116 Seed Lunch Sales Tax 0.84 houseAccount #23 14227 opera:ft:17356832
221709 2026-05-07 charge 2115 Seed Lunch Gratuity NRV 1.00 houseAccount #23 14227 opera:ft:17356831
221708 2026-05-07 credit 2073 Seed Lunch Food Discount DSC -6.00 houseAccount #23 14227 opera:ft:17356830
221707 2026-05-07 charge 2103 Seed Lunch LUN 15.00 houseAccount #23 14227 opera:ft:17356829
221706 2026-05-07 charge 2116 Seed Lunch Sales Tax 0.47 reservation #4253 10766 opera:ft:17356828
221705 2026-05-07 charge 2115 Seed Lunch Gratuity NRV 1.00 reservation #4253 10766 opera:ft:17356827
221704 2026-05-07 charge 2103 Seed Lunch LUN 5.00 reservation #4253 10766 opera:ft:17356826
221703 2026-05-07 charge 2116 Seed Lunch Sales Tax 2.93 reservation #2838 5182 opera:ft:17356825
221702 2026-05-07 charge 1900 Seed Service Charge RST 5.67 reservation #2838 5182 opera:ft:17356824
221701 2026-05-07 charge 2103 Seed Lunch LUN 31.50 reservation #2838 5182 opera:ft:17356823
221700 2026-05-07 charge 2116 Seed Lunch Sales Tax 3.07 reservation #3117 6146 opera:ft:17356822
221699 2026-05-07 charge 2103 Seed Lunch LUN 33.00 reservation #3117 6146 opera:ft:17356821
221698 2026-05-07 charge 2018 Alcohol Sales Tax 2.60 reservation #4930 13574 opera:ft:17356820
221697 2026-05-07 charge 2137 Terras Bar Gratuity NRV 5.00 reservation #4930 13574 opera:ft:17356819
221696 2026-05-07 charge 2129 Terras Bar Liquor ALC 28.00 reservation #4930 13574 opera:ft:17356818
221695 2026-05-07 payment 9008 Visa CARD -2,614.62 reservation #1178 2209 opera:ft:17356815
221694 2026-05-07 payment 9027 F&B Mastercard CARD -53.81 houseAccount #23 14227 opera:ft:17356814
221693 2026-05-07 charge 2140 Terras Lunch Sales Tax 3.81 houseAccount #23 14227 opera:ft:17356813
221692 2026-05-07 charge 2141 Terras Lunch Gratuity NRV 9.00 houseAccount #23 14227 opera:ft:17356812
221691 2026-05-07 charge 2083 Terras Lunch LUN 41.00 houseAccount #23 14227 opera:ft:17356811
221690 2026-05-07 charge 2174 INCLU Rate Inclusion -279.10 reservation #1178 2209 opera:ft:17356810 didn't use spa treatment on day 1
221689 2026-05-07 payment 9028 F&B Visa CARD -5.00 houseAccount #19 14234 opera:ft:17356809
221688 2026-05-07 charge 2116 Seed Lunch Sales Tax 0.33 houseAccount #19 14234 opera:ft:17356808
221687 2026-05-07 charge 2115 Seed Lunch Gratuity NRV 1.07 houseAccount #19 14234 opera:ft:17356807
221686 2026-05-07 credit 2073 Seed Lunch Food Discount DSC -2.40 houseAccount #19 14234 opera:ft:17356806
221685 2026-05-07 charge 2103 Seed Lunch LUN 6.00 houseAccount #19 14234 opera:ft:17356805
221684 2026-05-07 charge 2077 Alcohol Sales Tax Discount -1.40 houseAccount #28 14231 opera:ft:17356804
221683 2026-05-07 charge 2018 Alcohol Sales Tax 1.40 houseAccount #28 14231 opera:ft:17356803
221682 2026-05-07 charge 2142 Terras Sales Tax Discount -1.30 houseAccount #28 14231 opera:ft:17356802
221681 2026-05-07 charge 2302 IRD Lunch Sales Tax 1.30 houseAccount #28 14231 opera:ft:17356801
221680 2026-05-07 charge 8602 Rooms-COMP - Grat MSC -5.00 houseAccount #28 14231 opera:ft:17356800
221679 2026-05-07 charge 2008 In Room Dining Gratuity NRV 5.00 houseAccount #28 14231 opera:ft:17356799
221678 2026-05-07 charge 8531 Use Tax 5.6% 0.21 houseAccount #28 14231 opera:ft:17356798
221677 2026-05-07 charge 1976 Cost of Sales - Wine ALC 3.75 houseAccount #28 14231 opera:ft:17356797
221676 2026-05-07 charge 8600 Rooms-COMP- Bev MSC -3.96 houseAccount #28 14231 opera:ft:17356796
221675 2026-05-07 charge 1978 IRD Dinner Wine AA ALC -15.00 houseAccount #28 14231 opera:ft:17356795
221674 2026-05-07 charge 3520 In Room Dining Lunch Wine ALC 15.00 houseAccount #28 14231 opera:ft:17356794
221673 2026-05-07 charge 8531 Use Tax 5.6% 0.24 houseAccount #28 14231 opera:ft:17356793
221672 2026-05-07 charge 1977 Cost of Sales - Food Outlet... RST 4.20 houseAccount #28 14231 opera:ft:17356792
221671 2026-05-07 charge 8601 Rooms-COMP - Food MSC -4.44 houseAccount #28 14231 opera:ft:17356791
221670 2026-05-07 credit 2020 IRD Lunch Food Discount DSC -14.00 houseAccount #28 14231 opera:ft:17356790
221669 2026-05-07 charge 2002 In-Room Dining Lunch LUN 14.00 houseAccount #28 14231 opera:ft:17356789
221668 2026-05-07 charge 7115 Professional Products SPA 24.00 houseAccount #13 14209 opera:ft:17356788
221667 2026-05-07 charge 7013 Spa Gratuity NRV 10.80 houseAccount #13 14209 opera:ft:17356787
221666 2026-05-07 charge 8026 Retail sales tax 5.91 houseAccount #13 14209 opera:ft:17356786
221665 2026-05-07 charge 7012 Spa Service Charge SPA 39.60 houseAccount #13 14209 opera:ft:17356785
221664 2026-05-07 charge 7003 Spa Nail Care SPA 180.00 houseAccount #13 14209 opera:ft:17356784
221663 2026-05-07 charge 3105 Spa F&B Tax 1.40 reservation #3327 6926 opera:ft:17356783
221662 2026-05-07 charge 2136 Spa Pool Service Charge RST 3.00 reservation #3327 6926 opera:ft:17356782
221661 2026-05-07 charge 3100 Spa Food RST 15.00 reservation #3327 6926 opera:ft:17356781
221660 2026-05-07 charge 7002 Spa Massage SPA -235.00 houseAccount #13 14209 opera:ft:17356779
221659 2026-05-07 charge 2118 Pool Bar Sale Tax 2.79 reservation #2462 4021 opera:ft:17356778
221658 2026-05-07 charge 2114 Pool Bar Service Charge ALC 6.00 reservation #2462 4021 opera:ft:17356777
221657 2026-05-07 charge 2105 Pool Bar Food ALC 30.00 reservation #2462 4021 opera:ft:17356776
221656 2026-05-07 charge 2118 Pool Bar Sale Tax 1.77 reservation #3682 8587 opera:ft:17356775
221655 2026-05-07 charge 2114 Pool Bar Service Charge ALC 3.80 reservation #3682 8587 opera:ft:17356774
221654 2026-05-07 charge 2112 Pool Bar Gratuity NRV 4.00 reservation #3682 8587 opera:ft:17356773
221653 2026-05-07 charge 2105 Pool Bar Food ALC 19.00 reservation #3682 8587 opera:ft:17356772
221652 2026-05-07 charge 2118 Pool Bar Sale Tax 7.25 reservation #4684 12287 opera:ft:17356771
221651 2026-05-07 charge 2114 Pool Bar Service Charge ALC 15.60 reservation #4684 12287 opera:ft:17356770
221650 2026-05-07 charge 2112 Pool Bar Gratuity NRV 10.00 reservation #4684 12287 opera:ft:17356769
221649 2026-05-07 charge 2105 Pool Bar Food ALC 78.00 reservation #4684 12287 opera:ft:17356768
221648 2026-05-07 charge 2018 Alcohol Sales Tax 4.19 reservation #4687 12297 opera:ft:17356767
221647 2026-05-07 charge 2118 Pool Bar Sale Tax 5.30 reservation #4687 12297 opera:ft:17356766
221646 2026-05-07 charge 2114 Pool Bar Service Charge ALC 20.40 reservation #4687 12297 opera:ft:17356765
221645 2026-05-07 charge 2108 Pool Bar Liquor ALC 45.00 reservation #4687 12297 opera:ft:17356764
221644 2026-05-07 charge 2105 Pool Bar Food ALC 57.00 reservation #4687 12297 opera:ft:17356763
221643 2026-05-07 charge 2140 Terras Lunch Sales Tax 5.39 houseAccount #24 14229 opera:ft:17356762
221642 2026-05-07 charge 1699 Terras Lunch Service Charge LUN 10.44 houseAccount #24 14229 opera:ft:17356761
221641 2026-05-07 charge 2083 Terras Lunch LUN 58.00 houseAccount #24 14229 opera:ft:17356760
221640 2026-05-07 charge 2018 Alcohol Sales Tax 1.58 reservation #4835 13194 opera:ft:17356759
221639 2026-05-07 charge 2118 Pool Bar Sale Tax 3.35 reservation #4835 13194 opera:ft:17356758
221638 2026-05-07 charge 2114 Pool Bar Service Charge ALC 10.60 reservation #4835 13194 opera:ft:17356757
221637 2026-05-07 charge 2108 Pool Bar Liquor ALC 17.00 reservation #4835 13194 opera:ft:17356756
221636 2026-05-07 charge 2105 Pool Bar Food ALC 36.00 reservation #4835 13194 opera:ft:17356755
Sum (balance): -1,043.05