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 3209/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
122622 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #5674 9628 opera:ft:17219347
122621 2026-04-05 payment 9008 Visa CARD -111.20 guest #5674 5972 opera:ft:17219344
122620 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #5674 9628 opera:ft:17219343
122619 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #5674 9628 opera:ft:17219342
122618 2026-04-05 charge 7033 Spa Package SPA 7.87 guest #5674 9628 opera:ft:17219341
122617 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #6785 9716 opera:ft:17219338
122616 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #6783 9721 opera:ft:17219337
122615 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -291.51 guest #6783 8538 opera:ft:17219336 did not absorb
122614 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #6783 9721 opera:ft:17219335
122613 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #6783 9721 opera:ft:17219334
122612 2026-04-05 charge 7033 Spa Package SPA 349.00 guest #6783 9721 opera:ft:17219333
122611 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #6784 9646 opera:ft:17219330
122610 2026-04-05 payment 9008 Visa CARD -26.95 guest #6784 8539 opera:ft:17219329
122609 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -266.70 guest #6784 9719 opera:ft:17219328 did not absorb
122608 2026-04-05 charge 2018 Alcohol Sales Tax 3.72 reservation #557 1294 opera:ft:17219327
122607 2026-04-05 charge 3205 Terras Dinner Sales Tax 9.49 reservation #557 1294 opera:ft:17219326
122606 2026-04-05 charge 2094 Terras Dinner Gratuity NRV 30.00 reservation #557 1294 opera:ft:17219325
122605 2026-04-05 charge 2087 Terras Dinner Liquor ALC 40.00 reservation #557 1294 opera:ft:17219324
122604 2026-04-05 charge 2084 Terras Dinner DNR 102.00 reservation #557 1294 opera:ft:17219323
122603 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #6784 9646 opera:ft:17219322
122602 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #6784 9646 opera:ft:17219321
122601 2026-04-05 charge 7033 Spa Package SPA 349.00 guest #6784 9646 opera:ft:17219320
122600 2026-04-05 charge 2018 Alcohol Sales Tax 5.77 reservation #2924 5387 opera:ft:17219317
122599 2026-04-05 charge 3205 Terras Dinner Sales Tax 9.95 reservation #2924 5387 opera:ft:17219316
122598 2026-04-05 charge 2094 Terras Dinner Gratuity NRV 40.00 reservation #2924 5387 opera:ft:17219315
122597 2026-04-05 charge 2086 Terras Dinner Wine ALC 62.00 reservation #2924 5387 opera:ft:17219314
122596 2026-04-05 charge 2084 Terras Dinner DNR 107.00 reservation #2924 5387 opera:ft:17219313
122595 2026-04-05 charge 2018 Alcohol Sales Tax 2.42 reservation #555 1292 opera:ft:17219308
122594 2026-04-05 charge 3205 Terras Dinner Sales Tax 6.70 reservation #555 1292 opera:ft:17219307
122593 2026-04-05 charge 2094 Terras Dinner Gratuity NRV 20.00 reservation #555 1292 opera:ft:17219306
122592 2026-04-05 charge 2087 Terras Dinner Liquor ALC 26.00 reservation #555 1292 opera:ft:17219305
122591 2026-04-05 charge 2084 Terras Dinner DNR 72.00 reservation #555 1292 opera:ft:17219304
122590 2026-04-05 payment 9007 Master Card CARD -35.33 guest #6785 8541 opera:ft:17219303
122589 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -291.51 guest #6785 8541 opera:ft:17219302 did not absorb
122588 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #5673 9630 opera:ft:17219301
122587 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #5673 9630 opera:ft:17219300
122586 2026-04-05 charge 7033 Spa Package SPA 7.87 guest #5673 9630 opera:ft:17219299
122585 2026-04-05 charge 3205 Terras Dinner Sales Tax 7.72 reservation #498 1234 opera:ft:17219296
122584 2026-04-05 charge 2094 Terras Dinner Gratuity NRV 15.00 reservation #498 1234 opera:ft:17219295
122583 2026-04-05 charge 2084 Terras Dinner DNR 83.00 reservation #498 1234 opera:ft:17219294
122582 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #5672 9629 opera:ft:17219293
122581 2026-04-05 payment 9007 Master Card CARD -178.91 guest #5672 5970 opera:ft:17219292
122580 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #6785 9716 opera:ft:17219291
122579 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #6785 9716 opera:ft:17219290
122578 2026-04-05 charge 7033 Spa Package SPA 349.00 guest #6785 9716 opera:ft:17219289
122577 2026-04-05 charge 2018 Alcohol Sales Tax 1.30 reservation #3502 7794 opera:ft:17219286
122576 2026-04-05 charge 3205 Terras Dinner Sales Tax 6.23 reservation #3502 7794 opera:ft:17219285
122575 2026-04-05 charge 1698 Terras Dinner Service Charge DNR 12.06 reservation #3502 7794 opera:ft:17219284
122574 2026-04-05 charge 2087 Terras Dinner Liquor ALC 14.00 reservation #3502 7794 opera:ft:17219283
122573 2026-04-05 charge 2084 Terras Dinner DNR 67.00 reservation #3502 7794 opera:ft:17219282
122572 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -12.40 guest #5672 9629 opera:ft:17219281 not absorb
122571 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #6787 9648 opera:ft:17219280
122570 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #6787 9648 opera:ft:17219279
122569 2026-04-05 charge 7033 Spa Package SPA 349.00 guest #6787 9648 opera:ft:17219278
122568 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #6788 9642 opera:ft:17219275
122567 2026-04-05 payment 9007 Master Card CARD -92.37 guest #6788 8550 opera:ft:17219274
122566 2026-04-05 charge 2018 Alcohol Sales Tax 1.58 reservation #3194 6373 opera:ft:17219273
122565 2026-04-05 charge 2094 Terras Dinner Gratuity NRV 3.42 reservation #3194 6373 opera:ft:17219272
122564 2026-04-05 charge 2087 Terras Dinner Liquor ALC 17.00 reservation #3194 6373 opera:ft:17219271
122563 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #6573 9635 opera:ft:17219270
122562 2026-04-05 payment 9008 Visa CARD -175.00 guest #6573 8098 opera:ft:17219269
122561 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -291.51 guest #6788 9712 opera:ft:17219268 did not absorb
122560 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -279.10 guest #6573 9635 opera:ft:17219267 not absorb
122559 2026-04-05 charge 3205 Terras Dinner Sales Tax 21.48 reservation #3194 6373 opera:ft:17219266
122558 2026-04-05 charge 1698 Terras Dinner Service Charge DNR 41.58 reservation #3194 6373 opera:ft:17219265
122557 2026-04-05 charge 2084 Terras Dinner DNR 231.00 reservation #3194 6373 opera:ft:17219264
122556 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #6562 9644 opera:ft:17219263
122555 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -310.12 guest #6562 9644 opera:ft:17219262 not absorb
122554 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #6788 9642 opera:ft:17219261
122553 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #6788 9642 opera:ft:17219260
122552 2026-04-05 charge 7033 Spa Package SPA 349.00 guest #6788 9642 opera:ft:17219259
122551 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #6562 9644 opera:ft:17219256
122550 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #6562 9644 opera:ft:17219255
122549 2026-04-05 charge 7033 Spa Package SPA 349.00 guest #6562 9644 opera:ft:17219254
122548 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #6553 9643 opera:ft:17219251
122547 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -558.20 guest #6553 9643 opera:ft:17219250 not absorb
122546 2026-04-05 payment 9007 Master Card CARD -109.85 guest #6553 8084 opera:ft:17219249
122545 2026-04-05 charge 3205 Terras Dinner Sales Tax 2.79 reservation #1543 2632 opera:ft:17219248
122544 2026-04-05 charge 2094 Terras Dinner Gratuity NRV 6.00 reservation #1543 2632 opera:ft:17219247
122543 2026-04-05 charge 2084 Terras Dinner DNR 30.00 reservation #1543 2632 opera:ft:17219246
122542 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 26.49 guest #6545 9626 opera:ft:17219245
122541 2026-04-05 payment 9006 American Express CARD -365.15 guest #6545 8072 opera:ft:17219244
122540 2026-04-05 charge 3205 Terras Dinner Sales Tax 2.42 reservation #2100 3405 opera:ft:17219243
122539 2026-04-05 charge 1698 Terras Dinner Service Charge DNR 4.68 reservation #2100 3405 opera:ft:17219242
122538 2026-04-05 charge 2084 Terras Dinner DNR 26.00 reservation #2100 3405 opera:ft:17219241
122537 2026-04-05 credit 1071 Resort Credit ALW -100.00 guest #6545 8072 opera:ft:17219240 displaced from programs
122536 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #6790 9683 opera:ft:17219239
122535 2026-04-05 payment 9010 Discover CARD -59.89 guest #6790 8555 opera:ft:17219238
122534 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -353.53 guest #6790 9710 opera:ft:17219237 did not absorb
122533 2026-04-05 credit 8105 Shopify Commission ALW -8.73 guest #6790 9683 opera:ft:17219236
122532 2026-04-05 credit 8105 Shopify Commission ALW -0.30 guest #6790 9683 opera:ft:17219235
122531 2026-04-05 charge 7033 Spa Package SPA 349.00 guest #6790 9683 opera:ft:17219234
122530 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #6795 9641 opera:ft:17219231
122529 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -291.51 guest #6795 9709 opera:ft:17219230 did not absorb
122528 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC 282.48 guest #6795 9708 opera:ft:17219229 mistake
122527 2026-04-05 charge 7161 Shopify - Day Pass Inclusion MSC -282.48 guest #6795 9708 opera:ft:17219228 did not absorb
122526 2026-04-05 charge 9996 Spa Package Profit 62.02 guest #5922 6424 opera:ft:17219227
122525 2026-04-05 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #5922 9707 opera:ft:17219225
122524 2026-04-05 payment 9008 Visa CARD -100.68 guest #5922 6424 opera:ft:17219222
122523 2026-04-05 credit 8105 Shopify Commission ALW -17.46 guest #5922 9707 opera:ft:17219221
Sum (balance): -595.77