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

Ledger transactions (folio_transactions)

Reset
460317 rows (page 1473/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
289971 2026-06-03 charge 9996 Spa Package Profit 74.43 guest #10103 17099 opera:ft:17435819
289970 2026-06-03 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #10103 18173 opera:ft:17435817
289969 2026-06-03 credit 8105 Shopify Commission ALW -8.73 guest #10103 18173 opera:ft:17435816
289968 2026-06-03 credit 8105 Shopify Commission ALW -0.30 guest #10103 18173 opera:ft:17435815
289967 2026-06-03 charge 7033 Spa Package SPA -4.53 guest #10103 18173 opera:ft:17435814
289966 2026-06-03 charge 9996 Spa Package Profit 62.02 guest #9112 14243 opera:ft:17435811
289965 2026-06-03 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9112 18201 opera:ft:17435809
289964 2026-06-03 credit 8105 Shopify Commission ALW -8.73 guest #9112 18201 opera:ft:17435808
289963 2026-06-03 credit 8105 Shopify Commission ALW -0.30 guest #9112 18201 opera:ft:17435807
289962 2026-06-03 charge 7033 Spa Package SPA -4.53 guest #9112 18201 opera:ft:17435806
289961 2026-06-03 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8856 18158 opera:ft:17435803
289960 2026-06-03 charge 2018 Alcohol Sales Tax 2.79 reservation #4630 12089 opera:ft:17435800
289959 2026-06-03 charge 3205 Terras Dinner Sales Tax 4.37 reservation #4630 12089 opera:ft:17435799
289958 2026-06-03 charge 2094 Terras Dinner Gratuity NRV 16.00 reservation #4630 12089 opera:ft:17435798
289957 2026-06-03 charge 2086 Terras Dinner Wine ALC 30.00 reservation #4630 12089 opera:ft:17435797
289956 2026-06-03 charge 2084 Terras Dinner DNR 47.00 reservation #4630 12089 opera:ft:17435796
289955 2026-06-03 charge 2018 Alcohol Sales Tax 1.40 reservation #4602 12036 opera:ft:17435795
289954 2026-06-03 charge 3511 IRD Dinner Sales Tax 3.07 reservation #4602 12036 opera:ft:17435794
289953 2026-06-03 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #4602 12036 opera:ft:17435793
289952 2026-06-03 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #4602 12036 opera:ft:17435792
289951 2026-06-03 charge 2007 In-Room Dining Service Charg... RST 8.60 reservation #4602 12036 opera:ft:17435791
289950 2026-06-03 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #4602 12036 opera:ft:17435790
289949 2026-06-03 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #4602 12036 opera:ft:17435789
289948 2026-06-03 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #4602 12036 opera:ft:17435788
289947 2026-06-03 charge 2008 In Room Dining Gratuity NRV 15.00 reservation #4602 12036 opera:ft:17435787
289946 2026-06-03 charge 2005 In-Room Dining Dinner Wine ALC 15.00 reservation #4602 12036 opera:ft:17435786
289945 2026-06-03 charge 2003 In-Room Dining Dinner DNR 28.00 reservation #4602 12036 opera:ft:17435785
289944 2026-06-03 charge 2058 Food Retail Sales Tax 0.56 reservation #5625 17360 opera:ft:17435784
289943 2026-06-03 charge 3511 IRD Dinner Sales Tax 8.46 reservation #5625 17360 opera:ft:17435783
289942 2026-06-03 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #5625 17360 opera:ft:17435782
289941 2026-06-03 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #5625 17360 opera:ft:17435781
289940 2026-06-03 charge 2007 In-Room Dining Service Charg... RST 18.40 reservation #5625 17360 opera:ft:17435780
289939 2026-06-03 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #5625 17360 opera:ft:17435779
289938 2026-06-03 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #5625 17360 opera:ft:17435778
289937 2026-06-03 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #5625 17360 opera:ft:17435777
289936 2026-06-03 charge 2184 In Room Dining Food Retail RST 6.00 reservation #5625 17360 opera:ft:17435776
289935 2026-06-03 charge 2003 In-Room Dining Dinner DNR 86.00 reservation #5625 17360 opera:ft:17435775
289934 2026-06-03 charge 3205 Terras Dinner Sales Tax 5.58 reservation #5315 15748 opera:ft:17435774
289933 2026-06-03 charge 1698 Terras Dinner Service Charge DNR 10.80 reservation #5315 15748 opera:ft:17435773
289932 2026-06-03 charge 2084 Terras Dinner DNR 60.00 reservation #5315 15748 opera:ft:17435772
289931 2026-06-03 charge 7014 Spa Sales Tax 4.81 houseAccount #13 18135 opera:ft:17435771
289930 2026-06-03 charge 7012 Spa Service Charge SPA 51.70 houseAccount #13 18135 opera:ft:17435770
289929 2026-06-03 charge 7002 Spa Massage SPA 235.00 houseAccount #13 18135 opera:ft:17435769
289928 2026-06-03 charge 7013 Spa Gratuity NRV 35.25 reservation #4991 13929 opera:ft:17435768 SULLIVAN
289927 2026-06-03 charge 7002 Spa Massage SPA 235.00 reservation #4991 13929 opera:ft:17435767 SULLIVAN
289926 2026-06-03 charge 7014 Spa Sales Tax 4.81 reservation #4732 12650 opera:ft:17435766 KUGEL
289925 2026-06-03 charge 7012 Spa Service Charge SPA 51.70 reservation #4732 12650 opera:ft:17435765 KUGEL
289924 2026-06-03 charge 7002 Spa Massage SPA 235.00 reservation #4732 12650 opera:ft:17435764 KUGEL
289923 2026-06-03 charge 2018 Alcohol Sales Tax 3.16 reservation #4533 11797 opera:ft:17435763
289922 2026-06-03 charge 2137 Terras Bar Gratuity NRV 6.00 reservation #4533 11797 opera:ft:17435762
289921 2026-06-03 charge 2129 Terras Bar Liquor ALC 34.00 reservation #4533 11797 opera:ft:17435761
289920 2026-06-03 charge 7014 Spa Sales Tax 9.82 reservation #4754 12808 opera:ft:17435760 JOHNSON
289919 2026-06-03 charge 7012 Spa Service Charge SPA 27.40 reservation #4754 12808 opera:ft:17435759 JOHNSON
289918 2026-06-03 charge 7012 Spa Service Charge SPA 78.20 reservation #4754 12808 opera:ft:17435758 JOHNSON
289917 2026-06-03 charge 7001 Spa Body Treatment SPA 480.00 reservation #4754 12808 opera:ft:17435757 JOHNSON
289916 2026-06-03 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #5505 18549 opera:ft:17435756 canceled 06.03 10:59AM
289915 2026-06-03 charge 7014 Spa Sales Tax 4.81 houseAccount #6 18446 opera:ft:17435755 BLANCO
289914 2026-06-03 charge 7012 Spa Service Charge SPA 51.70 houseAccount #6 18446 opera:ft:17435754 BLANCO
289913 2026-06-03 charge 7002 Spa Massage SPA 235.00 houseAccount #6 18446 opera:ft:17435753 BLANCO
289912 2026-06-03 charge 7515 Class Late Cancellation Fee CLS 45.00 reservation #4475 18551 opera:ft:17435752 canceled 06.03 10:57AM
289911 2026-06-03 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #292 875 opera:ft:17435751 cancled 06.03 11:30AM
289910 2026-06-03 charge 7515 Class Late Cancellation Fee CLS 30.00 reservation #295 878 opera:ft:17435750 canceled 06.03 01:07PM
289909 2026-06-03 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #4602 18632 opera:ft:17435749 canceled 06.03 06:40PM
289908 2026-06-03 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #705 1511 opera:ft:17435748 canceled 06.03 04:43PM
289907 2026-06-03 charge 7014 Spa Sales Tax 6.44 reservation #5739 17793 opera:ft:17435747 LAVINE
289906 2026-06-03 charge 7012 Spa Service Charge SPA 69.30 reservation #5739 17793 opera:ft:17435746 LAVINE
289905 2026-06-03 charge 7001 Spa Body Treatment SPA 240.00 reservation #5739 17793 opera:ft:17435745 LAVINE
289904 2026-06-03 charge 7002 Spa Massage SPA 75.00 reservation #5739 17793 opera:ft:17435744 LAVINE
289903 2026-06-03 charge 7014 Spa Sales Tax 5.22 reservation #5406 16259 opera:ft:17435743 BALL
289902 2026-06-03 charge 7012 Spa Service Charge SPA 56.10 reservation #5406 16259 opera:ft:17435742 BALL
289901 2026-06-03 charge 7002 Spa Massage SPA 255.00 reservation #5406 16259 opera:ft:17435741 BALL
289900 2026-06-03 charge 2018 Alcohol Sales Tax 6.51 reservation #4823 13133 opera:ft:17435740
289899 2026-06-03 charge 3205 Terras Dinner Sales Tax 10.51 reservation #4823 13133 opera:ft:17435739
289898 2026-06-03 charge 2094 Terras Dinner Gratuity NRV 40.00 reservation #4823 13133 opera:ft:17435738
289897 2026-06-03 charge 2087 Terras Dinner Liquor ALC 70.00 reservation #4823 13133 opera:ft:17435737
289896 2026-06-03 charge 2084 Terras Dinner DNR 113.00 reservation #4823 13133 opera:ft:17435736
289895 2026-06-03 charge 7014 Spa Sales Tax 4.40 reservation #4825 13135 opera:ft:17435735 HODZIC
289894 2026-06-03 charge 7012 Spa Service Charge SPA 47.30 reservation #4825 13135 opera:ft:17435734 HODZIC
289893 2026-06-03 charge 7002 Spa Massage SPA 215.00 reservation #4825 13135 opera:ft:17435733 HODZIC
289892 2026-06-03 charge 7014 Spa Sales Tax 9.41 reservation #4619 12068 opera:ft:17435732 HACKNEY
289891 2026-06-03 charge 7012 Spa Service Charge SPA 101.20 reservation #4619 12068 opera:ft:17435731 HACKNEY
289890 2026-06-03 charge 7002 Spa Massage SPA 460.00 reservation #4619 12068 opera:ft:17435730 HACKNEY
289889 2026-06-03 charge 7014 Spa Sales Tax 5.83 reservation #4779 12969 opera:ft:17435729 OLDENKAMP
289888 2026-06-03 charge 7012 Spa Service Charge SPA 62.70 reservation #4779 12969 opera:ft:17435728 OLDENKAMP
289887 2026-06-03 charge 7002 Spa Massage SPA 285.00 reservation #4779 12969 opera:ft:17435727 OLDENKAMP
289886 2026-06-03 charge 7013 Spa Gratuity NRV 22.50 reservation #4471 11525 opera:ft:17435726 OKA
289885 2026-06-03 charge 7002 Spa Massage SPA 225.00 reservation #4471 11525 opera:ft:17435725 OKA
289884 2026-06-03 charge 7014 Spa Sales Tax 4.91 reservation #5710 17671 opera:ft:17435724 TURNER
289883 2026-06-03 charge 7012 Spa Service Charge SPA 52.80 reservation #5710 17671 opera:ft:17435723 TURNER
289882 2026-06-03 charge 7001 Spa Body Treatment SPA 240.00 reservation #5710 17671 opera:ft:17435722 TURNER
289881 2026-06-03 charge 3511 IRD Dinner Sales Tax 2.05 reservation #5207 17936 opera:ft:17435721
289880 2026-06-03 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #5207 17936 opera:ft:17435720
289879 2026-06-03 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #5207 17936 opera:ft:17435719
289878 2026-06-03 charge 2007 In-Room Dining Service Charg... RST 3.40 reservation #5207 17936 opera:ft:17435718
289877 2026-06-03 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #5207 17936 opera:ft:17435717
289876 2026-06-03 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #5207 17936 opera:ft:17435716
289875 2026-06-03 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #5207 17936 opera:ft:17435715
289874 2026-06-03 charge 2008 In Room Dining Gratuity NRV 5.00 reservation #5207 17936 opera:ft:17435714
289873 2026-06-03 charge 2003 In-Room Dining Dinner DNR 17.00 reservation #5207 17936 opera:ft:17435713
289872 2026-06-03 charge 3205 Terras Dinner Sales Tax 3.63 reservation #5413 16296 opera:ft:17435712
Sum (balance): 5,151.02