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 4215/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
12808 2026-03-02 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #1751 2955 opera:ft:17085406
12807 2026-03-02 charge 2008 In Room Dining Gratuity NRV 20.00 reservation #1751 2955 opera:ft:17085405
12806 2026-03-02 charge 2005 In-Room Dining Dinner Wine ALC 17.00 reservation #1751 2955 opera:ft:17085404
12805 2026-03-02 charge 2003 In-Room Dining Dinner DNR 77.00 reservation #1751 2955 opera:ft:17085403
12804 2026-03-02 charge 3511 IRD Dinner Sales Tax 6.60 reservation #2164 3512 opera:ft:17085402
12803 2026-03-02 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #2164 3512 opera:ft:17085401
12802 2026-03-02 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #2164 3512 opera:ft:17085400
12801 2026-03-02 charge 2007 In-Room Dining Service Charg... RST 13.20 reservation #2164 3512 opera:ft:17085399
12800 2026-03-02 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #2164 3512 opera:ft:17085398
12799 2026-03-02 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #2164 3512 opera:ft:17085397
12798 2026-03-02 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #2164 3512 opera:ft:17085396
12797 2026-03-02 charge 2003 In-Room Dining Dinner DNR 66.00 reservation #2164 3512 opera:ft:17085395
12796 2026-03-02 payment 9006 American Express CARD -201.34 guest #4618 4002 opera:ft:17085394
12795 2026-03-02 charge 9988 Spa Package Loss -84.26 guest #930 4047 opera:ft:17085385
12794 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #930 4445 opera:ft:17085383
12793 2026-03-02 payment 9006 American Express CARD -294.05 guest #930 4047 opera:ft:17085381
12792 2026-03-02 credit 8105 Shopify Commission ALW -17.46 guest #930 4445 opera:ft:17085380
12791 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #930 4445 opera:ft:17085379
12790 2026-03-02 charge 7161 Shopify - Day Pass Inclusion MSC 50.00 guest #930 4445 opera:ft:17085378
12789 2026-03-02 charge 8530 S&M - Promotion (Accounting... MSC -50.00 guest #930 4445 opera:ft:17085377
12788 2026-03-02 charge 7033 Spa Package SPA 0.00 guest #930 4047 opera:ft:17085376
12787 2026-03-02 charge 9996 Spa Package Profit 62.03 guest #4601 3991 opera:ft:17085373
12786 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #4601 4364 opera:ft:17085370
12785 2026-03-02 payment 9010 Discover CARD -39.62 guest #4601 3991 opera:ft:17085369
12784 2026-03-02 credit 8105 Shopify Commission ALW -8.73 guest #4601 4364 opera:ft:17085368
12783 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #4601 4364 opera:ft:17085367
12782 2026-03-02 charge 7033 Spa Package SPA 7.87 guest #4601 4364 opera:ft:17085366
12781 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #4597 4341 opera:ft:17085363
12780 2026-03-02 payment 9007 Master Card CARD -48.73 guest #4597 3987 opera:ft:17085362
12779 2026-03-02 credit 8105 Shopify Commission ALW -8.73 guest #4597 4341 opera:ft:17085361
12778 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #4597 4341 opera:ft:17085360
12777 2026-03-02 charge 7033 Spa Package SPA 7.87 guest #4597 4341 opera:ft:17085359
12776 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #4596 4340 opera:ft:17085356
12775 2026-03-02 payment 9007 Master Card CARD -65.00 guest #4596 3986 opera:ft:17085355
12774 2026-03-02 credit 8105 Shopify Commission ALW -8.73 guest #4596 4340 opera:ft:17085354
12773 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #4596 4340 opera:ft:17085353
12772 2026-03-02 charge 7033 Spa Package SPA 7.87 guest #4596 4340 opera:ft:17085352
12771 2026-03-02 charge 9996 Spa Package Profit 74.44 guest #4554 3930 opera:ft:17085349
12770 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #4554 4389 opera:ft:17085346
12769 2026-03-02 payment 9008 Visa CARD -177.01 guest #4554 3930 opera:ft:17085345
12768 2026-03-02 charge 9996 Spa Package Profit 31.03 guest #4522 3862 opera:ft:17085344
12767 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #4522 4418 opera:ft:17085342
12766 2026-03-02 charge 9996 Spa Package Profit 62.03 guest #4519 3858 opera:ft:17085341
12765 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #4519 4377 opera:ft:17085338
12764 2026-03-02 payment 9008 Visa CARD -15.00 guest #4519 3858 opera:ft:17085337
12763 2026-03-02 charge 9996 Spa Package Profit 124.06 guest #4497 3843 opera:ft:17085336
12762 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #4497 4358 opera:ft:17085333
12761 2026-03-02 payment 9006 American Express CARD -21.40 guest #4497 3843 opera:ft:17085332
12760 2026-03-02 credit 8105 Shopify Commission ALW -17.46 guest #4497 4358 opera:ft:17085331
12759 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #4497 4358 opera:ft:17085330
12758 2026-03-02 charge 7033 Spa Package SPA 15.74 guest #4497 4358 opera:ft:17085329
12757 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #4410 4337 opera:ft:17085326
12756 2026-03-02 payment 9008 Visa CARD -55.00 guest #4410 3737 opera:ft:17085325
12755 2026-03-02 charge 9996 Spa Package Profit 49.62 guest #1607 3179 opera:ft:17085324
12754 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #1607 4365 opera:ft:17085321
12753 2026-03-02 payment 9008 Visa CARD -35.70 guest #1607 3179 opera:ft:17085320
12752 2026-03-02 credit 8105 Shopify Commission ALW -8.73 guest #1607 4365 opera:ft:17085319
12751 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #1607 4365 opera:ft:17085318
12750 2026-03-02 charge 7033 Spa Package SPA 7.87 guest #1607 4365 opera:ft:17085317
12749 2026-03-02 charge 9996 Spa Package Profit 74.43 guest #3059 2481 opera:ft:17085314
12748 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #3059 4363 opera:ft:17085312
12747 2026-03-02 credit 8105 Shopify Commission ALW -8.73 guest #3059 4363 opera:ft:17085311
12746 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #3059 4363 opera:ft:17085310
12745 2026-03-02 charge 7033 Spa Package SPA 7.87 guest #3059 4363 opera:ft:17085309
12744 2026-03-02 charge 9996 Spa Package Profit 6.21 guest #2834 2289 opera:ft:17085306
12743 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #2834 4361 opera:ft:17085304
12742 2026-03-02 credit 8105 Shopify Commission ALW -8.73 guest #2834 4361 opera:ft:17085303
12741 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #2834 4361 opera:ft:17085302
12740 2026-03-02 charge 7033 Spa Package SPA 7.87 guest #2834 4361 opera:ft:17085301
12739 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #2530 4362 opera:ft:17085298
12738 2026-03-02 charge 9996 Spa Package Profit 62.03 guest #1950 1405 opera:ft:17085297
12737 2026-03-02 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #1950 4444 opera:ft:17085294
12736 2026-03-02 payment 9008 Visa CARD -54.64 guest #1950 1405 opera:ft:17085293
12735 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #1950 4444 opera:ft:17085292
12734 2026-03-02 credit 8105 Shopify Commission ALW -8.73 guest #1950 4444 opera:ft:17085291
12733 2026-03-02 charge 7033 Spa Package SPA 7.87 guest #1950 4444 opera:ft:17085290
12732 2026-03-02 charge 2018 Alcohol Sales Tax 3.16 reservation #1785 2995 opera:ft:17085287
12731 2026-03-02 charge 2137 Terras Bar Gratuity NRV 4.00 reservation #1785 2995 opera:ft:17085286
12730 2026-03-02 charge 2129 Terras Bar Liquor ALC 34.00 reservation #1785 2995 opera:ft:17085285
12729 2026-03-02 payment 9028 F&B Visa CARD -7.56 houseAccount #19 4308 opera:ft:17085275
12728 2026-03-02 charge 2138 Terras Bar Sales Tax 0.56 houseAccount #19 4308 opera:ft:17085274
12727 2026-03-02 charge 2137 Terras Bar Gratuity NRV 1.00 houseAccount #19 4308 opera:ft:17085273
12726 2026-03-02 charge 2125 Terras Bar ALC 6.00 houseAccount #19 4308 opera:ft:17085272
12725 2026-03-02 charge 2018 Alcohol Sales Tax 1.58 reservation #965 1907 opera:ft:17085271
12724 2026-03-02 charge 3205 Terras Dinner Sales Tax 7.35 reservation #965 1907 opera:ft:17085270
12723 2026-03-02 charge 2094 Terras Dinner Gratuity NRV 20.00 reservation #965 1907 opera:ft:17085269
12722 2026-03-02 charge 2087 Terras Dinner Liquor ALC 17.00 reservation #965 1907 opera:ft:17085268
12721 2026-03-02 charge 2084 Terras Dinner DNR 79.00 reservation #965 1907 opera:ft:17085267
12720 2026-03-02 charge 3205 Terras Dinner Sales Tax 21.11 reservation #153 4752 opera:ft:17085266
12719 2026-03-02 charge 1698 Terras Dinner Service Charge DNR 40.86 reservation #153 4752 opera:ft:17085265
12718 2026-03-02 charge 2084 Terras Dinner DNR 227.00 reservation #153 4752 opera:ft:17085264
12717 2026-03-02 credit 8105 Shopify Commission ALW -17.46 guest #4618 4356 opera:ft:17085263
12716 2026-03-02 credit 8105 Shopify Commission ALW -0.30 guest #4618 4356 opera:ft:17085262
12715 2026-03-02 charge 7033 Spa Package SPA 15.74 guest #4618 4356 opera:ft:17085261
12714 2026-03-02 payment 9025 F&B Cash CASH -16.40 houseAccount #22 4311 opera:ft:17085258
12713 2026-03-02 charge 2018 Alcohol Sales Tax 1.40 houseAccount #22 4311 opera:ft:17085257
12712 2026-03-02 charge 2128 Terras Bar Wine ALC 15.00 houseAccount #22 4311 opera:ft:17085256
12711 2026-03-02 charge 3205 Terras Dinner Sales Tax 13.21 reservation #1339 2416 opera:ft:17085255
12710 2026-03-02 charge 1698 Terras Dinner Service Charge DNR 25.56 reservation #1339 2416 opera:ft:17085254
12709 2026-03-02 charge 2084 Terras Dinner DNR 142.00 reservation #1339 2416 opera:ft:17085253
Sum (balance): 439.91