Test Page - This page is for testing purposes only. It is not intended for production use.
All Tests
Ledger transactions (folio_transactions)
| ID |
Date |
Type |
Code |
Tx type |
Amount |
Holder |
Billable |
Folio |
Item |
Hash |
Reason / Description |
| 19171 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #604 |
— |
1367 |
— |
opera:ft:17095952 |
HUANG
|
| 19170 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.01
|
reservation #1491 |
— |
2594 |
— |
opera:ft:17095945 |
WARREN
|
| 19169 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
53.90
|
reservation #1491 |
— |
2594 |
— |
opera:ft:17095944 |
WARREN
|
| 19168 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
245.00
|
reservation #1491 |
— |
2594 |
— |
opera:ft:17095943 |
WARREN
|
| 19167 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #1491 |
— |
2594 |
— |
opera:ft:17095942 |
WARREN
|
| 19166 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #1491 |
— |
2594 |
— |
opera:ft:17095941 |
WARREN
|
| 19165 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #1491 |
— |
2594 |
— |
opera:ft:17095940 |
WARREN
|
| 19164 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.01
|
reservation #373 |
— |
1122 |
— |
opera:ft:17095939 |
KUYPERS
|
| 19163 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
53.90
|
reservation #373 |
— |
1122 |
— |
opera:ft:17095938 |
KUYPERS
|
| 19162 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
245.00
|
reservation #373 |
— |
1122 |
— |
opera:ft:17095937 |
KUYPERS
|
| 19161 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
1.74
|
houseAccount #13 |
— |
4717 |
— |
opera:ft:17095936 |
|
| 19160 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
18.70
|
houseAccount #13 |
— |
4717 |
— |
opera:ft:17095935 |
|
| 19159 |
2026-03-05 |
credit |
3525
Allowance Spa Nail
|
ALW |
-34.00
|
houseAccount #13 |
— |
4717 |
— |
opera:ft:17095934 |
|
| 19158 |
2026-03-05 |
charge |
7003
Spa Nail Care
|
SPA |
85.00
|
houseAccount #13 |
— |
4717 |
— |
opera:ft:17095933 |
|
| 19157 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.52
|
reservation #1467 |
— |
2562 |
— |
opera:ft:17095932 |
REED
|
| 19156 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
50.30
|
reservation #1467 |
— |
2562 |
— |
opera:ft:17095931 |
REED
|
| 19155 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
9.10
|
reservation #1467 |
— |
2562 |
— |
opera:ft:17095930 |
REED
|
| 19154 |
2026-03-05 |
charge |
7000
Spa Skin Care
|
SPA |
270.00
|
reservation #1467 |
— |
2562 |
— |
opera:ft:17095929 |
REED
|
| 19153 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.63
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095926 |
SPA COMP & ALLOWANCE
|
| 19152 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
60.50
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095925 |
SPA COMP & ALLOWANCE
|
| 19151 |
2026-03-05 |
credit |
7027
Spa Body Treatment Discount
|
DSC |
-235.00
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095924 |
SPA COMP & ALLOWANCE
|
| 19150 |
2026-03-05 |
credit |
7015
Spa Massage Discount
|
DSC |
-40.00
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095923 |
SPA COMP & ALLOWANCE
|
| 19149 |
2026-03-05 |
charge |
7001
Spa Body Treatment
|
SPA |
235.00
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095922 |
SPA COMP & ALLOWANCE
|
| 19148 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
40.00
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095921 |
SPA COMP & ALLOWANCE
|
| 19147 |
2026-03-05 |
charge |
9996
Spa Package Profit
|
— |
62.03
|
guest #3385 |
— |
2768 |
— |
opera:ft:17095917 |
|
| 19146 |
2026-03-05 |
charge |
7008
Spa Credit
|
SPA |
-7.10
|
guest #3385 |
— |
2768 |
— |
opera:ft:17095916 |
guest had not such great experiance with...
|
| 19145 |
2026-03-05 |
credit |
8105
Shopify Commission
|
ALW |
-8.73
|
guest #3385 |
— |
4791 |
— |
opera:ft:17095915 |
|
| 19144 |
2026-03-05 |
credit |
8105
Shopify Commission
|
ALW |
-0.30
|
guest #3385 |
— |
4791 |
— |
opera:ft:17095914 |
|
| 19143 |
2026-03-05 |
charge |
7033
Spa Package
|
SPA |
7.87
|
guest #3385 |
— |
4791 |
— |
opera:ft:17095913 |
|
| 19142 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #373 |
— |
1122 |
— |
opera:ft:17095910 |
KUYPERS
|
| 19141 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #373 |
— |
1122 |
— |
opera:ft:17095909 |
KUYPERS
|
| 19140 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #373 |
— |
1122 |
— |
opera:ft:17095908 |
KUYPERS
|
| 19139 |
2026-03-05 |
charge |
9996
Spa Package Profit
|
— |
62.03
|
guest #3723 |
— |
3107 |
— |
opera:ft:17095907 |
|
| 19138 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #378 |
— |
4954 |
— |
opera:ft:17095906 |
SAVAGE
|
| 19137 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #378 |
— |
4954 |
— |
opera:ft:17095905 |
SAVAGE
|
| 19136 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #378 |
— |
4954 |
— |
opera:ft:17095904 |
SAVAGE
|
| 19135 |
2026-03-05 |
payment |
9006
American Express
|
CARD |
-93.37
|
guest #3723 |
— |
3107 |
— |
opera:ft:17095903 |
|
| 19134 |
2026-03-05 |
credit |
8105
Shopify Commission
|
ALW |
-8.73
|
guest #3723 |
— |
4773 |
— |
opera:ft:17095902 |
|
| 19133 |
2026-03-05 |
credit |
8105
Shopify Commission
|
ALW |
-0.30
|
guest #3723 |
— |
4773 |
— |
opera:ft:17095901 |
|
| 19132 |
2026-03-05 |
charge |
7033
Spa Package
|
SPA |
7.87
|
guest #3723 |
— |
4773 |
— |
opera:ft:17095900 |
|
| 19131 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095897 |
SPA COMP & ALLOWANCE
|
| 19130 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095896 |
SPA COMP & ALLOWANCE
|
| 19129 |
2026-03-05 |
credit |
7015
Spa Massage Discount
|
DSC |
-225.00
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095895 |
SPA COMP & ALLOWANCE
|
| 19128 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
houseAccount #17 |
— |
4722 |
— |
opera:ft:17095894 |
SPA COMP & ALLOWANCE
|
| 19127 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.01
|
reservation #1253 |
— |
2310 |
— |
opera:ft:17095890 |
HILL
|
| 19126 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
53.90
|
reservation #1253 |
— |
2310 |
— |
opera:ft:17095889 |
HILL
|
| 19125 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
245.00
|
reservation #1253 |
— |
2310 |
— |
opera:ft:17095888 |
HILL
|
| 19124 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.63
|
reservation #1162 |
— |
2190 |
— |
opera:ft:17095887 |
MUELLER
|
| 19123 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
60.50
|
reservation #1162 |
— |
2190 |
— |
opera:ft:17095886 |
MUELLER
|
| 19122 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
275.00
|
reservation #1162 |
— |
2190 |
— |
opera:ft:17095885 |
MUELLER
|
| 19121 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
guest #3723 |
— |
3107 |
— |
opera:ft:17095881 |
JOHNSON
|
| 19120 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
guest #3723 |
— |
3107 |
— |
opera:ft:17095880 |
JOHNSON
|
| 19119 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
guest #3723 |
— |
3107 |
— |
opera:ft:17095879 |
JOHNSON
|
| 19118 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #2272 |
— |
3658 |
— |
opera:ft:17095874 |
BUSSANMAS
|
| 19117 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #2272 |
— |
3658 |
— |
opera:ft:17095873 |
BUSSANMAS
|
| 19116 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #2272 |
— |
3658 |
— |
opera:ft:17095872 |
BUSSANMAS
|
| 19115 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #2272 |
— |
3658 |
— |
opera:ft:17095871 |
BUSSANMAS
|
| 19114 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #2272 |
— |
3658 |
— |
opera:ft:17095870 |
BUSSANMAS
|
| 19113 |
2026-03-05 |
charge |
7000
Spa Skin Care
|
SPA |
225.00
|
reservation #2272 |
— |
3658 |
— |
opera:ft:17095869 |
BUSSANMAS
|
| 19112 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
8.80
|
reservation #909 |
— |
1820 |
— |
opera:ft:17095868 |
KIRKMAN
|
| 19111 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
94.60
|
reservation #909 |
— |
1820 |
— |
opera:ft:17095867 |
KIRKMAN
|
| 19110 |
2026-03-05 |
charge |
7001
Spa Body Treatment
|
SPA |
150.90
|
reservation #909 |
— |
1820 |
— |
opera:ft:17095866 |
KIRKMAN
|
| 19109 |
2026-03-05 |
charge |
7001
Spa Body Treatment
|
SPA |
279.10
|
reservation #909 |
— |
1820 |
— |
opera:ft:17095865 |
KIRKMAN
|
| 19108 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.01
|
reservation #604 |
— |
1367 |
— |
opera:ft:17095864 |
HUANG
|
| 19107 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
53.90
|
reservation #604 |
— |
1367 |
— |
opera:ft:17095863 |
HUANG
|
| 19106 |
2026-03-05 |
charge |
7000
Spa Skin Care
|
SPA |
245.00
|
reservation #604 |
— |
1367 |
— |
opera:ft:17095862 |
HUANG
|
| 19105 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
guest #4485 |
— |
4416 |
— |
opera:ft:17095861 |
HALL
|
| 19104 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
guest #4485 |
— |
4416 |
— |
opera:ft:17095860 |
HALL
|
| 19103 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
guest #4485 |
— |
4416 |
— |
opera:ft:17095859 |
HALL
|
| 19102 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
guest #3469 |
— |
2876 |
— |
opera:ft:17095858 |
HERRERA
|
| 19101 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
guest #3469 |
— |
2876 |
— |
opera:ft:17095857 |
HERRERA
|
| 19100 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
guest #3469 |
— |
2876 |
— |
opera:ft:17095856 |
HERRERA
|
| 19099 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #909 |
— |
1820 |
— |
opera:ft:17095855 |
KIRKMAN
|
| 19098 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #909 |
— |
1820 |
— |
opera:ft:17095854 |
KIRKMAN
|
| 19097 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #909 |
— |
1820 |
— |
opera:ft:17095853 |
KIRKMAN
|
| 19096 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.40
|
reservation #1675 |
— |
2840 |
— |
opera:ft:17095852 |
THIESSEN
|
| 19095 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
47.30
|
reservation #1675 |
— |
2840 |
— |
opera:ft:17095851 |
THIESSEN
|
| 19094 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
215.00
|
reservation #1675 |
— |
2840 |
— |
opera:ft:17095850 |
THIESSEN
|
| 19093 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #1675 |
— |
2840 |
— |
opera:ft:17095849 |
THIESSEN
|
| 19092 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #1675 |
— |
2840 |
— |
opera:ft:17095848 |
THIESSEN
|
| 19091 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #1675 |
— |
2840 |
— |
opera:ft:17095847 |
THIESSEN
|
| 19090 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.01
|
guest #1690 |
— |
4821 |
— |
opera:ft:17095846 |
TWIBELL
|
| 19089 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
53.90
|
guest #1690 |
— |
4821 |
— |
opera:ft:17095845 |
TWIBELL
|
| 19088 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
245.00
|
guest #1690 |
— |
4821 |
— |
opera:ft:17095844 |
TWIBELL
|
| 19087 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #1740 |
— |
2935 |
— |
opera:ft:17095843 |
FLYNN
|
| 19086 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #1740 |
— |
2935 |
— |
opera:ft:17095842 |
FLYNN
|
| 19085 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #1740 |
— |
2935 |
— |
opera:ft:17095841 |
FLYNN
|
| 19084 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.60
|
reservation #1740 |
— |
2935 |
— |
opera:ft:17095840 |
FLYNN
|
| 19083 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
49.50
|
reservation #1740 |
— |
2935 |
— |
opera:ft:17095839 |
FLYNN
|
| 19082 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
225.00
|
reservation #1740 |
— |
2935 |
— |
opera:ft:17095838 |
FLYNN
|
| 19081 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
3.68
|
houseAccount #13 |
— |
4717 |
— |
opera:ft:17095837 |
|
| 19080 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
39.60
|
houseAccount #13 |
— |
4717 |
— |
opera:ft:17095836 |
|
| 19079 |
2026-03-05 |
charge |
7003
Spa Nail Care
|
SPA |
180.00
|
houseAccount #13 |
— |
4717 |
— |
opera:ft:17095835 |
|
| 19078 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.63
|
reservation #1162 |
— |
2190 |
— |
opera:ft:17095834 |
MUELLER
|
| 19077 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
60.50
|
reservation #1162 |
— |
2190 |
— |
opera:ft:17095833 |
MUELLER
|
| 19076 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
275.00
|
reservation #1162 |
— |
2190 |
— |
opera:ft:17095832 |
MUELLER
|
| 19075 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
4.40
|
reservation #552 |
— |
1307 |
— |
opera:ft:17095831 |
HEMRAJ
|
| 19074 |
2026-03-05 |
charge |
7012
Spa Service Charge
|
SPA |
47.30
|
reservation #552 |
— |
1307 |
— |
opera:ft:17095830 |
HEMRAJ
|
| 19073 |
2026-03-05 |
charge |
7002
Spa Massage
|
SPA |
215.00
|
reservation #552 |
— |
1307 |
— |
opera:ft:17095829 |
HEMRAJ
|
| 19072 |
2026-03-05 |
charge |
7014
Spa Sales Tax
|
— |
5.01
|
reservation #552 |
— |
1307 |
— |
opera:ft:17095828 |
HEMRAJ
|
| Sum (balance): |
7,618.96 |
|