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

Ledger transactions (folio_transactions)

Reset
460315 rows (page 3012/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
141606 2026-04-11 charge 2086 Terras Dinner Wine ALC 20.00 houseAccount #19 10459 opera:ft:17253236
141605 2026-04-11 charge 2087 Terras Dinner Liquor ALC 18.00 houseAccount #19 10459 opera:ft:17253235
141604 2026-04-11 payment 9027 F&B Mastercard CARD -45.00 houseAccount #23 10462 opera:ft:17253234
141603 2026-04-11 charge 2018 Alcohol Sales Tax 3.26 houseAccount #23 10462 opera:ft:17253233
141602 2026-04-11 charge 2094 Terras Dinner Gratuity NRV 6.74 houseAccount #23 10462 opera:ft:17253232
141601 2026-04-11 charge 2087 Terras Dinner Liquor ALC 35.00 houseAccount #23 10462 opera:ft:17253231
141600 2026-04-11 charge 3205 Terras Dinner Sales Tax 3.63 guest #963 5008 opera:ft:17253230
141599 2026-04-11 charge 2094 Terras Dinner Gratuity NRV 8.00 guest #963 5008 opera:ft:17253229
141598 2026-04-11 charge 2084 Terras Dinner DNR 39.00 guest #963 5008 opera:ft:17253228
141597 2026-04-11 charge 3205 Terras Dinner Sales Tax 5.30 guest #5285 5011 opera:ft:17253227
141596 2026-04-11 charge 2094 Terras Dinner Gratuity NRV 12.00 guest #5285 5011 opera:ft:17253226
141595 2026-04-11 charge 2084 Terras Dinner DNR 57.00 guest #5285 5011 opera:ft:17253225
141594 2026-04-11 charge 3205 Terras Dinner Sales Tax 5.30 guest #5286 5012 opera:ft:17253224
141593 2026-04-11 charge 2094 Terras Dinner Gratuity NRV 12.00 guest #5286 5012 opera:ft:17253223
141592 2026-04-11 charge 2084 Terras Dinner DNR 57.00 guest #5286 5012 opera:ft:17253222
141591 2026-04-11 charge 2077 Alcohol Sales Tax Discount -1.40 houseAccount #28 10465 opera:ft:17253221
141590 2026-04-11 charge 2018 Alcohol Sales Tax 1.40 houseAccount #28 10465 opera:ft:17253220
141589 2026-04-11 charge 1999 IRD Sales Tax Discount -1.30 houseAccount #28 10465 opera:ft:17253219
141588 2026-04-11 charge 3511 IRD Dinner Sales Tax 1.30 houseAccount #28 10465 opera:ft:17253218
141587 2026-04-11 charge 8602 Rooms-COMP - Grat MSC -5.00 houseAccount #28 10465 opera:ft:17253217
141586 2026-04-11 charge 2008 In Room Dining Gratuity NRV 5.00 houseAccount #28 10465 opera:ft:17253216
141585 2026-04-11 charge 8531 Use Tax 5.6% 0.21 houseAccount #28 10465 opera:ft:17253215
141584 2026-04-11 charge 1976 Cost of Sales - Wine ALC 3.75 houseAccount #28 10465 opera:ft:17253214
141583 2026-04-11 charge 8600 Rooms-COMP- Bev MSC -3.96 houseAccount #28 10465 opera:ft:17253213
141582 2026-04-11 charge 1978 IRD Dinner Wine AA ALC -15.00 houseAccount #28 10465 opera:ft:17253212
141581 2026-04-11 charge 2005 In-Room Dining Dinner Wine ALC 15.00 houseAccount #28 10465 opera:ft:17253211
141580 2026-04-11 charge 8531 Use Tax 5.6% 0.24 houseAccount #28 10465 opera:ft:17253210
141579 2026-04-11 charge 1977 Cost of Sales - Food Outlet... RST 4.20 houseAccount #28 10465 opera:ft:17253209
141578 2026-04-11 charge 8601 Rooms-COMP - Food MSC -4.44 houseAccount #28 10465 opera:ft:17253208
141577 2026-04-11 charge 2224 IRD Dinner AA DNR -14.00 houseAccount #28 10465 opera:ft:17253207
141576 2026-04-11 charge 2003 In-Room Dining Dinner DNR 14.00 houseAccount #28 10465 opera:ft:17253206
141575 2026-04-11 charge 2058 Food Retail Sales Tax 1.12 houseAccount #28 10550 opera:ft:17253205
141574 2026-04-11 charge 1999 IRD Sales Tax Discount -2.23 houseAccount #28 10465 opera:ft:17253204
141573 2026-04-11 charge 3511 IRD Dinner Sales Tax 2.23 houseAccount #28 10465 opera:ft:17253203
141572 2026-04-11 charge 8602 Rooms-COMP - Grat MSC -5.00 houseAccount #28 10465 opera:ft:17253202
141571 2026-04-11 charge 2008 In Room Dining Gratuity NRV 5.00 houseAccount #28 10465 opera:ft:17253201
141570 2026-04-11 charge 8531 Use Tax 5.6% 0.40 houseAccount #28 10465 opera:ft:17253199
141569 2026-04-11 charge 1977 Cost of Sales - Food Outlet... RST 7.20 houseAccount #28 10465 opera:ft:17253198
141568 2026-04-11 charge 8601 Rooms-COMP - Food MSC -7.60 houseAccount #28 10465 opera:ft:17253197
141567 2026-04-11 charge 2224 IRD Dinner AA DNR -24.00 houseAccount #28 10465 opera:ft:17253196
141566 2026-04-11 charge 2003 In-Room Dining Dinner DNR 24.00 houseAccount #28 10465 opera:ft:17253195
141565 2026-04-11 charge 7014 Spa Sales Tax 5.12 reservation #553 1290 opera:ft:17253194 MOONEY
141564 2026-04-11 charge 7012 Spa Service Charge SPA 55.00 reservation #553 1290 opera:ft:17253193 MOONEY
141563 2026-04-11 charge 7001 Spa Body Treatment SPA 250.00 reservation #553 1290 opera:ft:17253192 MOONEY
141562 2026-04-11 charge 7014 Spa Sales Tax 4.40 reservation #2751 4801 opera:ft:17253191 LAZARCHUK
141561 2026-04-11 charge 7012 Spa Service Charge SPA 47.30 reservation #2751 4801 opera:ft:17253190 LAZARCHUK
141560 2026-04-11 charge 7002 Spa Massage SPA 215.00 reservation #2751 4801 opera:ft:17253189 LAZARCHUK
141559 2026-04-11 charge 7161 Shopify - Day Pass Inclusion MSC -279.10 guest #4215 3503 opera:ft:17253188 was billed to incorrect room
141558 2026-04-11 charge 7014 Spa Sales Tax 4.81 reservation #3487 7695 opera:ft:17253187 FORD
141557 2026-04-11 charge 7012 Spa Service Charge SPA 51.70 reservation #3487 7695 opera:ft:17253186 FORD
141556 2026-04-11 charge 7002 Spa Massage SPA 235.00 reservation #3487 7695 opera:ft:17253185 FORD
141555 2026-04-11 charge 7014 Spa Sales Tax 4.40 reservation #2237 3594 opera:ft:17253184 LOUSTALOT
141554 2026-04-11 charge 7012 Spa Service Charge SPA 47.30 reservation #2237 3594 opera:ft:17253183 LOUSTALOT
141553 2026-04-11 charge 7002 Spa Massage SPA 215.00 reservation #2237 3594 opera:ft:17253182 LOUSTALOT
141552 2026-04-11 charge 7014 Spa Sales Tax 4.40 reservation #3632 8377 opera:ft:17253181 PEREIRA
141551 2026-04-11 charge 7012 Spa Service Charge SPA 47.30 reservation #3632 8377 opera:ft:17253180 PEREIRA
141550 2026-04-11 charge 7002 Spa Massage SPA 215.00 reservation #3632 8377 opera:ft:17253179 PEREIRA
141549 2026-04-11 charge 7014 Spa Sales Tax 4.91 guest #6530 10517 opera:ft:17253178 SHELTON
141548 2026-04-11 charge 7012 Spa Service Charge SPA 52.80 guest #6530 10517 opera:ft:17253177 SHELTON
141547 2026-04-11 charge 7001 Spa Body Treatment SPA 240.00 guest #6530 10517 opera:ft:17253176 SHELTON
141546 2026-04-11 charge 7014 Spa Sales Tax 4.81 reservation #3487 7695 opera:ft:17253175 FORD
141545 2026-04-11 charge 7012 Spa Service Charge SPA 51.70 reservation #3487 7695 opera:ft:17253174 FORD
141544 2026-04-11 charge 7002 Spa Massage SPA 235.00 reservation #3487 7695 opera:ft:17253173 FORD
141543 2026-04-11 charge 7014 Spa Sales Tax 6.95 reservation #3979 9548 opera:ft:17253172 INYANG
141542 2026-04-11 charge 7012 Spa Service Charge SPA 74.80 reservation #3979 9548 opera:ft:17253171 INYANG
141541 2026-04-11 charge 7000 Spa Skin Care SPA 340.00 reservation #3979 9548 opera:ft:17253170 INYANG
141540 2026-04-11 charge 7014 Spa Sales Tax 4.81 reservation #2517 4129 opera:ft:17253169 TSANG
141539 2026-04-11 charge 7012 Spa Service Charge SPA 51.70 reservation #2517 4129 opera:ft:17253168 TSANG
141538 2026-04-11 charge 7002 Spa Massage SPA 235.00 reservation #2517 4129 opera:ft:17253167 TSANG
141537 2026-04-11 charge 7014 Spa Sales Tax 5.83 reservation #2243 3600 opera:ft:17253166 PESCIA
141536 2026-04-11 charge 7012 Spa Service Charge SPA 62.70 reservation #2243 3600 opera:ft:17253165 PESCIA
141535 2026-04-11 charge 7002 Spa Massage SPA 285.00 reservation #2243 3600 opera:ft:17253164 PESCIA
141534 2026-04-11 charge 7014 Spa Sales Tax 4.60 reservation #2751 4801 opera:ft:17253163 LAZARCHUK
141533 2026-04-11 charge 7012 Spa Service Charge SPA 49.50 reservation #2751 4801 opera:ft:17253162 LAZARCHUK
141532 2026-04-11 charge 7002 Spa Massage SPA 225.00 reservation #2751 4801 opera:ft:17253161 LAZARCHUK
141531 2026-04-11 charge 7013 Spa Gratuity NRV 66.00 houseAccount #13 10447 opera:ft:17253160
141530 2026-04-11 charge 7000 Spa Skin Care SPA 330.00 houseAccount #13 10447 opera:ft:17253159
141529 2026-04-11 charge 7014 Spa Sales Tax 4.60 reservation #2235 3592 opera:ft:17253158 CARMEN
141528 2026-04-11 charge 7012 Spa Service Charge SPA 49.50 reservation #2235 3592 opera:ft:17253157 CARMEN
141527 2026-04-11 charge 7002 Spa Massage SPA 225.00 reservation #2235 3592 opera:ft:17253156 CARMEN
141526 2026-04-11 charge 7014 Spa Sales Tax 10.43 reservation #3750 10402 opera:ft:17253155 CAVALLARI
141525 2026-04-11 charge 7012 Spa Service Charge SPA 64.00 reservation #3750 10402 opera:ft:17253154 CAVALLARI
141524 2026-04-11 charge 7012 Spa Service Charge SPA 48.20 reservation #3750 10402 opera:ft:17253153 CAVALLARI
141523 2026-04-11 charge 7002 Spa Massage SPA 510.00 reservation #3750 10402 opera:ft:17253152 CAVALLARI
141522 2026-04-11 charge 7014 Spa Sales Tax 4.60 reservation #2022 3320 opera:ft:17253151 PETERS
141521 2026-04-11 charge 7012 Spa Service Charge SPA 49.50 reservation #2022 3320 opera:ft:17253150 PETERS
141520 2026-04-11 charge 7002 Spa Massage SPA 225.00 reservation #2022 3320 opera:ft:17253149 PETERS
141519 2026-04-11 charge 7014 Spa Sales Tax 5.42 reservation #415 1147 opera:ft:17253148 RAJPURKAR
141518 2026-04-11 charge 7012 Spa Service Charge SPA 58.30 reservation #415 1147 opera:ft:17253147 RAJPURKAR
141517 2026-04-11 charge 7002 Spa Massage SPA 265.00 reservation #415 1147 opera:ft:17253146 RAJPURKAR
141516 2026-04-11 charge 7014 Spa Sales Tax 5.12 reservation #553 1290 opera:ft:17253145 MOONEY
141515 2026-04-11 charge 7012 Spa Service Charge SPA 55.00 reservation #553 1290 opera:ft:17253144 MOONEY
141514 2026-04-11 charge 7001 Spa Body Treatment SPA 250.00 reservation #553 1290 opera:ft:17253143 MOONEY
141513 2026-04-11 charge 7014 Spa Sales Tax 4.91 reservation #1300 2358 opera:ft:17253142 ARNOLD
141512 2026-04-11 charge 7012 Spa Service Charge SPA 52.80 reservation #1300 2358 opera:ft:17253141 ARNOLD
141511 2026-04-11 charge 7001 Spa Body Treatment SPA 240.00 reservation #1300 2358 opera:ft:17253140 ARNOLD
141510 2026-04-11 charge 7014 Spa Sales Tax 9.00 houseAccount #13 10447 opera:ft:17253139
141509 2026-04-11 charge 7012 Spa Service Charge SPA 96.80 houseAccount #13 10447 opera:ft:17253138
141508 2026-04-11 charge 7000 Spa Skin Care SPA 225.00 houseAccount #13 10447 opera:ft:17253137
141507 2026-04-11 charge 7002 Spa Massage SPA 215.00 houseAccount #13 10447 opera:ft:17253136
Sum (balance): 6,365.27