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 1984/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
228750 2026-05-09 charge 2087 Terras Dinner Liquor ALC 18.00 reservation #4349 11152 opera:ft:17365972
228749 2026-05-09 charge 2084 Terras Dinner DNR 59.00 reservation #4349 11152 opera:ft:17365971
228748 2026-05-09 charge 3511 IRD Dinner Sales Tax 1.77 reservation #4764 12847 opera:ft:17365970
228747 2026-05-09 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #4764 12847 opera:ft:17365969
228746 2026-05-09 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #4764 12847 opera:ft:17365968
228745 2026-05-09 charge 2007 In-Room Dining Service Charg... RST 2.80 reservation #4764 12847 opera:ft:17365967
228744 2026-05-09 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #4764 12847 opera:ft:17365966
228743 2026-05-09 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #4764 12847 opera:ft:17365965
228742 2026-05-09 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #4764 12847 opera:ft:17365964
228741 2026-05-09 charge 2008 In Room Dining Gratuity NRV 5.00 reservation #4764 12847 opera:ft:17365963
228740 2026-05-09 charge 2003 In-Room Dining Dinner DNR 14.00 reservation #4764 12847 opera:ft:17365962
228739 2026-05-09 charge 2018 Alcohol Sales Tax 2.98 reservation #4458 11431 opera:ft:17365961
228738 2026-05-09 charge 3205 Terras Dinner Sales Tax 2.42 reservation #4458 11431 opera:ft:17365960
228737 2026-05-09 charge 2094 Terras Dinner Gratuity NRV 16.60 reservation #4458 11431 opera:ft:17365959
228736 2026-05-09 charge 2087 Terras Dinner Liquor ALC 32.00 reservation #4458 11431 opera:ft:17365958
228735 2026-05-09 charge 2084 Terras Dinner DNR 26.00 reservation #4458 11431 opera:ft:17365957
228734 2026-05-09 charge 7008 Spa Credit SPA -301.13 reservation #2834 14594 opera:ft:17365956 balance. credits were already given thro...
228733 2026-05-09 charge 2138 Terras Bar Sales Tax 1.30 reservation #4658 14463 opera:ft:17365955
228732 2026-05-09 charge 1901 Terras Lounge Service Charge RST 2.52 reservation #4658 14463 opera:ft:17365954
228731 2026-05-09 charge 2125 Terras Bar ALC 14.00 reservation #4658 14463 opera:ft:17365953
228730 2026-05-09 charge 1901 Terras Lounge Service Charge RST 2.52 reservation #4658 14463 opera:ft:17365952
228729 2026-05-09 charge 3205 Terras Dinner Sales Tax 2.98 reservation #4761 12844 opera:ft:17365951
228728 2026-05-09 charge 2094 Terras Dinner Gratuity NRV 5.00 reservation #4761 12844 opera:ft:17365950
228727 2026-05-09 charge 2084 Terras Dinner DNR 32.00 reservation #4761 12844 opera:ft:17365949
228726 2026-05-09 charge 2138 Terras Bar Sales Tax 2.23 reservation #2643 4430 opera:ft:17365948
228725 2026-05-09 charge 1901 Terras Lounge Service Charge RST 4.32 reservation #2643 4430 opera:ft:17365947
228724 2026-05-09 charge 2125 Terras Bar ALC 24.00 reservation #2643 4430 opera:ft:17365946
228723 2026-05-09 charge 2018 Alcohol Sales Tax 6.51 reservation #3965 9467 opera:ft:17365945
228722 2026-05-09 charge 3205 Terras Dinner Sales Tax 3.53 reservation #3965 9467 opera:ft:17365944
228721 2026-05-09 charge 2094 Terras Dinner Gratuity NRV 23.96 reservation #3965 9467 opera:ft:17365943
228720 2026-05-09 charge 2087 Terras Dinner Liquor ALC 70.00 reservation #3965 9467 opera:ft:17365942
228719 2026-05-09 charge 2084 Terras Dinner DNR 38.00 reservation #3965 9467 opera:ft:17365941
228718 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 35.22 guest #959 14598 opera:ft:17365940
228717 2026-05-09 payment 9008 Visa CARD -209.79 guest #959 10078 opera:ft:17365939
228716 2026-05-09 charge 7161 Shopify - Day Pass Inclusion MSC -1,066.80 guest #959 14599 opera:ft:17365938 not absorb
228715 2026-05-09 charge 2018 Alcohol Sales Tax 3.44 reservation #4401 11291 opera:ft:17365937
228714 2026-05-09 charge 2137 Terras Bar Gratuity NRV 8.00 reservation #4401 11291 opera:ft:17365936
228713 2026-05-09 charge 2129 Terras Bar Liquor ALC 37.00 reservation #4401 11291 opera:ft:17365935
228712 2026-05-09 credit 8105 Shopify Commission ALW -34.92 guest #959 14598 opera:ft:17365934
228711 2026-05-09 credit 8105 Shopify Commission ALW -0.30 guest #959 14598 opera:ft:17365933
228710 2026-05-09 charge 7033 Spa Package SPA 1,396.00 guest #959 14598 opera:ft:17365932
228709 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #7691 14547 opera:ft:17365929
228708 2026-05-09 payment 9028 F&B Visa CARD -45.25 houseAccount #19 14495 opera:ft:17365928
228707 2026-05-09 charge 2018 Alcohol Sales Tax 1.67 houseAccount #19 14495 opera:ft:17365927
228706 2026-05-09 charge 2138 Terras Bar Sales Tax 1.58 houseAccount #19 14495 opera:ft:17365926
228705 2026-05-09 charge 2137 Terras Bar Gratuity NRV 7.00 houseAccount #19 14495 opera:ft:17365925
228704 2026-05-09 charge 2129 Terras Bar Liquor ALC 18.00 houseAccount #19 14495 opera:ft:17365924
228703 2026-05-09 charge 2125 Terras Bar ALC 17.00 houseAccount #19 14495 opera:ft:17365923
228702 2026-05-09 payment 9007 Master Card CARD -40.00 guest #7691 10736 opera:ft:17365922
228701 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #7191 14563 opera:ft:17365921
228700 2026-05-09 charge 7161 Shopify - Day Pass Inclusion MSC -297.71 guest #7191 9464 opera:ft:17365920 not absorb
228699 2026-05-09 credit 8105 Shopify Commission ALW -8.73 guest #7191 14563 opera:ft:17365919
228698 2026-05-09 credit 8105 Shopify Commission ALW -0.30 guest #7191 14563 opera:ft:17365918
228697 2026-05-09 charge 7033 Spa Package SPA 349.00 guest #7191 14563 opera:ft:17365917
228696 2026-05-09 charge 9996 Spa Package Profit 744.27 guest #7588 10374 opera:ft:17365914
228695 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 14.03 guest #7588 14562 opera:ft:17365912
228694 2026-05-09 payment 9008 Visa CARD -183.15 guest #7588 10374 opera:ft:17365909
228693 2026-05-09 credit 8105 Shopify Commission ALW -13.73 guest #7588 14562 opera:ft:17365908
228692 2026-05-09 credit 8105 Shopify Commission ALW -0.30 guest #7588 14562 opera:ft:17365907
228691 2026-05-09 charge 3007 Amusement Tax -51.27 guest #7588 14562 opera:ft:17365906
228690 2026-05-09 charge 8086 Resort Day Passes MSC -865.12 guest #7588 14562 opera:ft:17365905
228689 2026-05-09 charge 9996 Spa Package Profit 62.03 guest #5978 6671 opera:ft:17365902
228688 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #5978 14558 opera:ft:17365900
228687 2026-05-09 payment 9008 Visa CARD -40.00 guest #5978 6671 opera:ft:17365897
228686 2026-05-09 charge 9996 Spa Package Profit 99.24 guest #5444 5459 opera:ft:17365896
228685 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #5444 14557 opera:ft:17365893
228684 2026-05-09 charge 7800 Programs Sales Tax -1.28 guest #5444 5459 opera:ft:17365892
228683 2026-05-09 charge 8096 No Show Class CLS -15.00 guest #5444 5459 opera:ft:17365891 spa
228682 2026-05-09 charge 9996 Spa Package Profit 111.64 guest #8727 13178 opera:ft:17365890
228681 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #8727 14580 opera:ft:17365887
228680 2026-05-09 charge 2018 Alcohol Sales Tax 4.28 reservation #4930 13574 opera:ft:17365886
228679 2026-05-09 charge 2138 Terras Bar Sales Tax 2.23 reservation #4930 13574 opera:ft:17365885
228678 2026-05-09 charge 2137 Terras Bar Gratuity NRV 15.00 reservation #4930 13574 opera:ft:17365884
228677 2026-05-09 charge 2128 Terras Bar Wine ALC 28.00 reservation #4930 13574 opera:ft:17365883
228676 2026-05-09 charge 2129 Terras Bar Liquor ALC 18.00 reservation #4930 13574 opera:ft:17365882
228675 2026-05-09 charge 2125 Terras Bar ALC 24.00 reservation #4930 13574 opera:ft:17365881
228674 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #5662 14560 opera:ft:17365880
228673 2026-05-09 payment 9008 Visa CARD -161.54 guest #5662 6017 opera:ft:17365879
228672 2026-05-09 charge 2018 Alcohol Sales Tax 1.40 reservation #4930 13574 opera:ft:17365878
228671 2026-05-09 charge 2138 Terras Bar Sales Tax 5.77 reservation #4930 13574 opera:ft:17365877
228670 2026-05-09 charge 2137 Terras Bar Gratuity NRV 20.00 reservation #4930 13574 opera:ft:17365876
228669 2026-05-09 charge 2128 Terras Bar Wine ALC 15.00 reservation #4930 13574 opera:ft:17365875
228668 2026-05-09 charge 2125 Terras Bar ALC 62.00 reservation #4930 13574 opera:ft:17365874
228667 2026-05-09 charge 7161 Shopify - Day Pass Inclusion MSC -12.40 guest #5662 14560 opera:ft:17365873 not absorb
228666 2026-05-09 charge 9996 Spa Package Profit 18.60 guest #106 11683 opera:ft:17365872
228665 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #106 14548 opera:ft:17365869
228664 2026-05-09 charge 9996 Spa Package Profit 62.02 guest #8144 11682 opera:ft:17365868
228663 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8144 14549 opera:ft:17365865
228662 2026-05-09 charge 9996 Spa Package Profit 74.43 guest #7622 10526 opera:ft:17365864
228661 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #7622 14543 opera:ft:17365862
228660 2026-05-09 charge 7800 Programs Sales Tax -1.28 guest #7622 10526 opera:ft:17365860
228659 2026-05-09 charge 8096 No Show Class CLS -15.00 guest #7622 10526 opera:ft:17365859 spa
228658 2026-05-09 charge 9996 Spa Package Profit 316.34 guest #5112 4771 opera:ft:17365858
228657 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 43.95 guest #5112 14597 opera:ft:17365856
228656 2026-05-09 payment 9007 Master Card CARD -353.59 guest #5112 4771 opera:ft:17365853
228655 2026-05-09 charge 7800 Programs Sales Tax -1.28 guest #5112 4771 opera:ft:17365852
228654 2026-05-09 charge 8096 No Show Class CLS -15.00 guest #5112 4771 opera:ft:17365851 spa
228653 2026-05-09 charge 7161 Shopify - Day Pass Inclusion MSC -558.20 guest #6828 14592 opera:ft:17365850 not absorb
228652 2026-05-09 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #6828 14540 opera:ft:17365849
228651 2026-05-09 payment 9008 Visa CARD -67.23 guest #6828 8736 opera:ft:17365848
Sum (balance): -209.23