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 3449/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
87108 2026-03-25 charge 7002 Spa Massage SPA 279.10 reservation #3093 6116 opera:ft:17172975 CLARKE
87107 2026-03-25 payment 9008 Visa CARD -219.84 reservation #862 1745 opera:ft:17172974
87106 2026-03-25 payment 9007 Master Card CARD -141.12 reservation #2558 4204 opera:ft:17172972
87105 2026-03-25 charge 1010 Room Tax 213.38 reservation #1515 7089 opera:ft:17172971
87104 2026-03-25 charge 1028 Cancellation/Forfeited Depos... MSC 1,821.38 reservation #1515 7089 opera:ft:17172970 AP rate that left early
87103 2026-03-25 charge 1010 Room Tax 3.87 reservation #3135 7027 opera:ft:17172969
87102 2026-03-25 charge 1028 Cancellation/Forfeited Depos... MSC 33.07 reservation #3135 7027 opera:ft:17172968 amex overage
87101 2026-03-25 charge 1010 Room Tax 3.87 reservation #2813 7087 opera:ft:17172967
87100 2026-03-25 charge 1028 Cancellation/Forfeited Depos... MSC 33.05 reservation #2813 7087 opera:ft:17172966 amexfhr
87099 2026-03-25 charge 2018 Alcohol Sales Tax 1.30 reservation #2766 4916 opera:ft:17172965
87098 2026-03-25 charge 3516 Terras Lunch Liquor ALC 14.00 reservation #2766 4916 opera:ft:17172964
87097 2026-03-25 payment 9008 Visa CARD -59.41 reservation #2457 4012 opera:ft:17172961
87096 2026-03-25 charge 2174 INCLU Rate Inclusion -558.20 reservation #2457 4012 opera:ft:17172960 used spa allowance on last day
87095 2026-03-25 charge 7014 Spa Sales Tax 9.61 houseAccount #13 7860 opera:ft:17172956
87094 2026-03-25 charge 7012 Spa Service Charge SPA 103.40 houseAccount #13 7860 opera:ft:17172955
87093 2026-03-25 charge 7000 Spa Skin Care SPA 245.00 houseAccount #13 7860 opera:ft:17172954
87092 2026-03-25 charge 7002 Spa Massage SPA 225.00 houseAccount #13 7860 opera:ft:17172953
87091 2026-03-25 charge 3105 Spa F&B Tax 2.79 reservation #1829 3052 opera:ft:17172952
87090 2026-03-25 charge 2136 Spa Pool Service Charge RST 6.00 reservation #1829 3052 opera:ft:17172951
87089 2026-03-25 charge 3104 Spa F&B Gratuity NRV 1.21 reservation #1829 3052 opera:ft:17172950
87088 2026-03-25 charge 3100 Spa Food RST 30.00 reservation #1829 3052 opera:ft:17172949
87087 2026-03-25 charge 2116 Seed Lunch Sales Tax 1.67 reservation #1399 2480 opera:ft:17172948
87086 2026-03-25 charge 1900 Seed Service Charge RST 3.24 reservation #1399 2480 opera:ft:17172947
87085 2026-03-25 charge 2103 Seed Lunch LUN 18.00 reservation #1399 2480 opera:ft:17172946
87084 2026-03-25 payment 9028 F&B Visa CARD -78.88 houseAccount #19 7866 opera:ft:17172945
87083 2026-03-25 charge 2018 Alcohol Sales Tax 3.26 houseAccount #19 7866 opera:ft:17172944
87082 2026-03-25 charge 3105 Spa F&B Tax 2.42 houseAccount #19 7866 opera:ft:17172943
87081 2026-03-25 charge 2136 Spa Pool Service Charge RST 12.20 houseAccount #19 7866 opera:ft:17172942
87080 2026-03-25 charge 3102 Spa Wine ALC 18.00 houseAccount #19 7866 opera:ft:17172941
87079 2026-03-25 charge 3103 Spa Liquor ALC 17.00 houseAccount #19 7866 opera:ft:17172940
87078 2026-03-25 charge 3100 Spa Food RST 26.00 houseAccount #19 7866 opera:ft:17172939
87077 2026-03-25 charge 2018 Alcohol Sales Tax 6.32 reservation #1547 2654 opera:ft:17172938
87076 2026-03-25 charge 3105 Spa F&B Tax 1.67 reservation #1547 2654 opera:ft:17172937
87075 2026-03-25 charge 2136 Spa Pool Service Charge RST 17.20 reservation #1547 2654 opera:ft:17172936
87074 2026-03-25 charge 3104 Spa F&B Gratuity NRV 5.00 reservation #1547 2654 opera:ft:17172935
87073 2026-03-25 charge 3103 Spa Liquor ALC 68.00 reservation #1547 2654 opera:ft:17172934
87072 2026-03-25 charge 3100 Spa Food RST 18.00 reservation #1547 2654 opera:ft:17172933
87071 2026-03-25 payment 9028 F&B Visa CARD -6.24 houseAccount #19 7866 opera:ft:17172932
87070 2026-03-25 charge 2058 Food Retail Sales Tax 0.84 houseAccount #19 7866 opera:ft:17172931
87069 2026-03-25 credit 7042 Spa Merchandise Discount DSC -3.60 houseAccount #19 7866 opera:ft:17172930
87068 2026-03-25 charge 2104 Food Retail RST 9.00 houseAccount #19 7866 opera:ft:17172929
87067 2026-03-25 payment 9028 F&B Visa CARD -30.59 houseAccount #19 7866 opera:ft:17172926
87066 2026-03-25 charge 2140 Terras Lunch Sales Tax 2.09 houseAccount #19 7866 opera:ft:17172925
87065 2026-03-25 charge 2141 Terras Lunch Gratuity NRV 6.00 houseAccount #19 7866 opera:ft:17172924
87064 2026-03-25 charge 2083 Terras Lunch LUN 22.50 houseAccount #19 7866 opera:ft:17172923
87063 2026-03-25 payment 9026 F&B American Express CARD -29.59 houseAccount #20 7867 opera:ft:17172922
87062 2026-03-25 charge 2140 Terras Lunch Sales Tax 2.09 houseAccount #20 7867 opera:ft:17172921
87061 2026-03-25 charge 2141 Terras Lunch Gratuity NRV 5.00 houseAccount #20 7867 opera:ft:17172920
87060 2026-03-25 charge 2083 Terras Lunch LUN 22.50 houseAccount #20 7867 opera:ft:17172919
87059 2026-03-25 charge 2140 Terras Lunch Sales Tax 4.74 reservation #1861 3102 opera:ft:17172918
87058 2026-03-25 charge 1699 Terras Lunch Service Charge LUN 9.18 reservation #1861 3102 opera:ft:17172917
87057 2026-03-25 charge 2083 Terras Lunch LUN 51.00 reservation #1861 3102 opera:ft:17172916
87056 2026-03-25 payment 9027 F&B Mastercard CARD -18.62 houseAccount #23 7873 opera:ft:17172915
87055 2026-03-25 charge 3105 Spa F&B Tax 1.34 houseAccount #23 7873 opera:ft:17172914
87054 2026-03-25 charge 2136 Spa Pool Service Charge RST 2.88 houseAccount #23 7873 opera:ft:17172913
87053 2026-03-25 credit 3106 Spa Food Discount DSC -3.60 houseAccount #23 7873 opera:ft:17172912
87052 2026-03-25 charge 3100 Spa Food RST 18.00 houseAccount #23 7873 opera:ft:17172911
87051 2026-03-25 charge 3105 Spa F&B Tax 3.16 reservation #2578 4245 opera:ft:17172910
87050 2026-03-25 charge 2136 Spa Pool Service Charge RST 6.80 reservation #2578 4245 opera:ft:17172909
87049 2026-03-25 charge 3100 Spa Food RST 34.00 reservation #2578 4245 opera:ft:17172908
87048 2026-03-25 charge 2140 Terras Lunch Sales Tax 8.18 reservation #269 865 opera:ft:17172907
87047 2026-03-25 charge 2141 Terras Lunch Gratuity NRV 16.00 reservation #269 865 opera:ft:17172906
87046 2026-03-25 charge 2083 Terras Lunch LUN 88.00 reservation #269 865 opera:ft:17172905
87045 2026-03-25 charge 3105 Spa F&B Tax 3.35 reservation #2847 5214 opera:ft:17172904
87044 2026-03-25 charge 2136 Spa Pool Service Charge RST 7.20 reservation #2847 5214 opera:ft:17172903
87043 2026-03-25 charge 3100 Spa Food RST 36.00 reservation #2847 5214 opera:ft:17172902
87042 2026-03-25 charge 2140 Terras Lunch Sales Tax 3.91 reservation #53 399 opera:ft:17172901
87041 2026-03-25 charge 1699 Terras Lunch Service Charge LUN 7.56 reservation #53 399 opera:ft:17172900
87040 2026-03-25 charge 2083 Terras Lunch LUN 42.00 reservation #53 399 opera:ft:17172899
87039 2026-03-25 charge 2018 Alcohol Sales Tax 1.58 reservation #2198 3560 opera:ft:17172898
87038 2026-03-25 charge 3105 Spa F&B Tax 2.79 reservation #2198 3560 opera:ft:17172897
87037 2026-03-25 charge 2136 Spa Pool Service Charge RST 9.40 reservation #2198 3560 opera:ft:17172896
87036 2026-03-25 charge 3104 Spa F&B Gratuity NRV 3.00 reservation #2198 3560 opera:ft:17172895
87035 2026-03-25 charge 3103 Spa Liquor ALC 17.00 reservation #2198 3560 opera:ft:17172894
87034 2026-03-25 charge 3100 Spa Food RST 30.00 reservation #2198 3560 opera:ft:17172893
87033 2026-03-25 charge 2018 Alcohol Sales Tax 6.32 guest #900 7318 opera:ft:17172892
87032 2026-03-25 charge 3105 Spa F&B Tax 1.67 guest #900 7318 opera:ft:17172891
87031 2026-03-25 charge 2136 Spa Pool Service Charge RST 17.20 guest #900 7318 opera:ft:17172890
87030 2026-03-25 charge 3103 Spa Liquor ALC 68.00 guest #900 7318 opera:ft:17172889
87029 2026-03-25 charge 3100 Spa Food RST 18.00 guest #900 7318 opera:ft:17172888
87028 2026-03-25 charge 2140 Terras Lunch Sales Tax 2.98 reservation #862 1745 opera:ft:17172887
87027 2026-03-25 charge 1699 Terras Lunch Service Charge LUN 5.76 reservation #862 1745 opera:ft:17172886
87026 2026-03-25 charge 2083 Terras Lunch LUN 32.00 reservation #862 1745 opera:ft:17172885
87025 2026-03-25 charge 3105 Spa F&B Tax 1.77 reservation #2766 4916 opera:ft:17172884
87024 2026-03-25 charge 2136 Spa Pool Service Charge RST 3.80 reservation #2766 4916 opera:ft:17172883
87023 2026-03-25 charge 3104 Spa F&B Gratuity NRV 4.00 reservation #2766 4916 opera:ft:17172882
87022 2026-03-25 charge 3100 Spa Food RST 19.00 reservation #2766 4916 opera:ft:17172881
87021 2026-03-25 payment 9028 F&B Visa CARD -91.12 houseAccount #19 7866 opera:ft:17172880
87020 2026-03-25 charge 3105 Spa F&B Tax 5.12 houseAccount #19 7866 opera:ft:17172879
87019 2026-03-25 charge 2136 Spa Pool Service Charge RST 11.00 houseAccount #19 7866 opera:ft:17172878
87018 2026-03-25 charge 3104 Spa F&B Gratuity NRV 20.00 houseAccount #19 7866 opera:ft:17172877
87017 2026-03-25 charge 3100 Spa Food RST 55.00 houseAccount #19 7866 opera:ft:17172876
87016 2026-03-25 charge 7123 Fitness Boutique - Accesorie... CLS 80.00 houseAccount #13 7860 opera:ft:17172875
87015 2026-03-25 charge 8026 Retail sales tax 7.44 houseAccount #13 7860 opera:ft:17172874
87014 2026-03-25 payment 9027 F&B Mastercard CARD -65.47 houseAccount #23 7873 opera:ft:17172873
87013 2026-03-25 charge 2018 Alcohol Sales Tax 2.60 houseAccount #23 7873 opera:ft:17172872
87012 2026-03-25 charge 3105 Spa F&B Tax 1.67 houseAccount #23 7873 opera:ft:17172871
87011 2026-03-25 charge 2136 Spa Pool Service Charge RST 9.20 houseAccount #23 7873 opera:ft:17172870
87010 2026-03-25 charge 3104 Spa F&B Gratuity NRV 6.00 houseAccount #23 7873 opera:ft:17172869
87009 2026-03-25 charge 3103 Spa Liquor ALC 28.00 houseAccount #23 7873 opera:ft:17172868
Sum (balance): 2,821.35