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

Ledger transactions (folio_transactions)

Reset
447462 rows (page 4369/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
440517 2023-12-01 charge 2204 Rental Tax 212.94 cityLedgerAccount #21 opera:ft:14444256
440516 2023-12-01 charge 2156 Rental Revenue MSC 6,084.00 cityLedgerAccount #21 opera:ft:14444255 Monthly rent
440515 2023-12-01 transfer 9991 Cash Drop Trans. Code (Inter... 41,560.56 opera:ft:14443708 cash_drop
440514 2023-12-01 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:14443707 cash_drop
440513 2023-12-01 transfer 9991 Cash Drop Trans. Code (Inter... 736.72 opera:ft:14443706 cash_drop
2697 2023-12-01 transfer 9003 Direct Bill 357.00 cityLedgerAccount #228 opera:9003:14452505 Direct Bill
2696 2023-12-01 transfer 9003 Direct Bill 6,296.94 cityLedgerAccount #21 opera:9003:14444257 Direct Bill Monthly rent
440512 2023-11-30 transfer 9991 Cash Drop Trans. Code (Inter... 41,668.82 opera:ft:14440958 cash_drop
440511 2023-11-30 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:14440957 cash_drop
440510 2023-11-30 transfer 9991 Cash Drop Trans. Code (Inter... 1,500.00 opera:ft:14440956 cash_drop
440509 2023-11-30 payment 9011 Electronic Check / Wire Tran... WIRE -41,668.82 cityLedgerAccount #155 opera:ft:14439960
440508 2023-11-30 charge 1010 Room Tax 150.64 cityLedgerAccount #243 opera:ft:14439596
440507 2023-11-30 charge 1022 Group Rooms Attrition MSC 1,135.22 cityLedgerAccount #243 opera:ft:14439595
440506 2023-11-30 payment 9006 American Express CARD -2,473.78 cityLedgerAccount #243 opera:ft:14439591
2695 2023-11-30 transfer 9003 Direct Bill 1,285.86 cityLedgerAccount #243 opera:9003:14439597 Direct Bill
440505 2023-11-29 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:14438303 cash_drop
440504 2023-11-29 transfer 9991 Cash Drop Trans. Code (Inter... 427.55 opera:ft:14438302 cash_drop
440503 2023-11-29 credit 8501 Allowance Bad Debt Write Off ALW -426.09 cityLedgerAccount #348 opera:ft:14436904 august transient, emails, canary , fd fi...
440502 2023-11-29 charge 2129 Terras Bar Liquor ALC -10.00 cityLedgerAccount #311 opera:ft:14436893 comp
440501 2023-11-29 charge 2129 Terras Bar Liquor ALC -12.00 cityLedgerAccount #311 opera:ft:14436892 comp
440500 2023-11-29 charge 2087 Terras Dinner Liquor ALC -30.00 cityLedgerAccount #311 opera:ft:14436891 comp
440499 2023-11-29 charge 2087 Terras Dinner Liquor ALC -42.00 cityLedgerAccount #311 opera:ft:14436890 comp
440498 2023-11-29 charge 2018 Alcohol Sales Tax -2.79 cityLedgerAccount #311 opera:ft:14436880 comp
440497 2023-11-29 charge 2018 Alcohol Sales Tax -3.16 cityLedgerAccount #311 opera:ft:14436879 comp
440496 2023-11-29 charge 2018 Alcohol Sales Tax -2.98 cityLedgerAccount #311 opera:ft:14436878 comp
440495 2023-11-29 charge 2018 Alcohol Sales Tax -2.23 cityLedgerAccount #311 opera:ft:14436877 comp
440494 2023-11-29 charge 2018 Alcohol Sales Tax -3.91 cityLedgerAccount #311 opera:ft:14436876 comp
440493 2023-11-29 charge 2018 Alcohol Sales Tax -2.42 cityLedgerAccount #311 opera:ft:14436875 comp
440492 2023-11-29 charge 2086 Terras Dinner Wine ALC -24.00 cityLedgerAccount #311 opera:ft:14436874 comp
440491 2023-11-29 charge 2128 Terras Bar Wine ALC -24.00 cityLedgerAccount #311 opera:ft:14436873 comp
440490 2023-11-29 charge 2128 Terras Bar Wine ALC -20.00 cityLedgerAccount #311 opera:ft:14436872 comp
440489 2023-11-29 charge 3102 Spa Wine ALC -26.00 cityLedgerAccount #311 opera:ft:14436871 comp
440488 2023-11-29 credit 1071 Resort Credit ALW -4,648.33 cityLedgerAccount #372 opera:ft:14436861 m13 group per Julia L
440487 2023-11-29 credit 3501 Allowance Spa Massage ALW -4,904.10 cityLedgerAccount #372 opera:ft:14436860 m13 group spa allowance
440486 2023-11-29 charge 8522 Banquet Adjustment (In house... RST -3,283.94 cityLedgerAccount #372 opera:ft:14436859 m13 group, wiaiving of dinner / breakfas...
440485 2023-11-29 charge 1010 Room Tax -370.63 cityLedgerAccount #372 opera:ft:14436858
440484 2023-11-29 credit 1021 Room Allowance ALW -3,163.63 cityLedgerAccount #372 opera:ft:14436857 Waiving of the Ealry check outs
440483 2023-11-29 payment 9007 Master Card CARD -14,156.80 cityLedgerAccount #161 opera:ft:14436856
440482 2023-11-29 credit 8501 Allowance Bad Debt Write Off ALW -1,095.45 cityLedgerAccount #349 opera:ft:14436850 4 MONTHS TRYING TO COLLECT...U=GUEST USE...
440481 2023-11-29 charge 1010 Room Tax -0.60 cityLedgerAccount #371 opera:ft:14436822
440480 2023-11-29 credit 1021 Room Allowance ALW -5.10 cityLedgerAccount #371 opera:ft:14436821 CC were down and not taken at check in a...
440479 2023-11-29 charge 2204 Rental Tax -7.00 cityLedgerAccount #370 opera:ft:14436742
440478 2023-11-29 charge 2052 Banquet Room Rental RST -200.00 cityLedgerAccount #370 opera:ft:14436741 per Marc S and Claudine J
440477 2023-11-29 payment 9006 American Express CARD -820.60 cityLedgerAccount #336 opera:ft:14436730
440476 2023-11-29 payment 9005 Gift Card Payment GIFT_CARD -484.79 cityLedgerAccount #347 opera:ft:14436697 I HEART
2694 2023-11-29 transfer 9003 Direct Bill -16,000.00 cityLedgerAccount #372 opera:9003:14436862 Direct Bill
440475 2023-11-28 transfer 9991 Cash Drop Trans. Code (Inter... 17,791.25 opera:ft:14435339 cash_drop
440474 2023-11-27 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:14432837 cash_drop
440473 2023-11-27 transfer 9991 Cash Drop Trans. Code (Inter... 19.67 opera:ft:14432836 cash_drop
440472 2023-11-24 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:14424463 cash_drop
2693 2023-11-24 transfer 9003 Direct Bill 10,393.47 cityLedgerAccount #161 opera:9003:14423385 Direct Bill
2692 2023-11-24 transfer 9003 Direct Bill 3,370.98 cityLedgerAccount #161 opera:9003:14423384 Direct Bill
2691 2023-11-24 transfer 9003 Direct Bill -500.00 cityLedgerAccount #161 opera:9003:14423383 Direct Bill
2690 2023-11-24 transfer 9003 Direct Bill 892.35 cityLedgerAccount #161 opera:9003:14423382 Direct Bill
2689 2023-11-24 transfer 9003 Direct Bill 5,030.50 cityLedgerAccount #373 opera:9003:14423372 Direct Bill
440471 2023-11-22 transfer 9991 Cash Drop Trans. Code (Inter... 99,246.87 opera:ft:14420347 cash_drop
440470 2023-11-22 payment 9011 Electronic Check / Wire Tran... WIRE -83,281.87 cityLedgerAccount #155 opera:ft:14419910
440469 2023-11-22 payment 9007 Master Card CARD -9,736.05 cityLedgerAccount #148 opera:ft:14419111
440468 2023-11-21 payment 9006 American Express CARD 9,734.89 cityLedgerAccount #372 opera:ft:14414884
440467 2023-11-21 payment 9007 Master Card CARD -273.17 cityLedgerAccount #346 opera:ft:14414517
2796 2023-11-21 transfer 9003 Direct Bill 76.21 cityLedgerAccount #375 opera:9003:14568616 Direct Bill
2795 2023-11-21 transfer 9003 Direct Bill -76.21 cityLedgerAccount #368 opera:9003:14568615 Direct Bill
2794 2023-11-21 transfer 9003 Direct Bill 613.37 cityLedgerAccount #375 opera:9003:14568614 Direct Bill
2793 2023-11-21 transfer 9003 Direct Bill -613.37 cityLedgerAccount #368 opera:9003:14568613 Direct Bill
2688 2023-11-21 transfer 9003 Direct Bill 76.21 cityLedgerAccount #368 opera:9003:14417648 Direct Bill
2687 2023-11-21 transfer 9003 Direct Bill 613.37 cityLedgerAccount #368 opera:9003:14417644 Direct Bill
2686 2023-11-21 transfer 9003 Direct Bill 3,283.94 cityLedgerAccount #372 opera:9003:14414879 Direct Bill
2685 2023-11-21 transfer 9003 Direct Bill 6,432.00 cityLedgerAccount #372 opera:9003:14414878 Direct Bill
2684 2023-11-21 transfer 9003 Direct Bill 1,444.94 cityLedgerAccount #372 opera:9003:14414877 Direct Bill
2683 2023-11-21 transfer 9003 Direct Bill 1,980.00 cityLedgerAccount #372 opera:9003:14414876 Direct Bill
2682 2023-11-21 transfer 9003 Direct Bill 4,904.10 cityLedgerAccount #372 opera:9003:14414875 Direct Bill
2681 2023-11-21 transfer 9003 Direct Bill 50,564.68 cityLedgerAccount #372 opera:9003:14414874 Direct Bill
2680 2023-11-21 transfer 9003 Direct Bill 36,807.92 cityLedgerAccount #372 opera:9003:14414873 Direct Bill
2679 2023-11-21 transfer 9003 Direct Bill -99,152.47 cityLedgerAccount #372 opera:9003:14414872 Direct Bill
440466 2023-11-20 transfer 9991 Cash Drop Trans. Code (Inter... 15,965.00 opera:ft:14413403 cash_drop
440465 2023-11-20 transfer 9991 Cash Drop Trans. Code (Inter... 1,885.42 opera:ft:14413402 cash_drop
2678 2023-11-20 transfer 9003 Direct Bill 5.10 cityLedgerAccount #371 opera:9003:14411974 Direct Bill
440464 2023-11-19 transfer 9991 Cash Drop Trans. Code (Inter... 493.56 opera:ft:14410057 cash_drop
440463 2023-11-18 transfer 9991 Cash Drop Trans. Code (Inter... 205.00 opera:ft:14407392 cash_drop
440462 2023-11-17 transfer 9991 Cash Drop Trans. Code (Inter... 110.00 opera:ft:14404356 cash_drop
440461 2023-11-17 charge 8090 Finance Charge MSC -8.75 cityLedgerAccount #365 opera:ft:14402937 adj
440460 2023-11-17 payment 9006 American Express CARD -3,702.71 cityLedgerAccount #365 opera:ft:14402934
440459 2023-11-17 charge 2204 Rental Tax 8.75 cityLedgerAccount #365 opera:ft:14402862
440458 2023-11-17 charge 2052 Banquet Room Rental RST 250.00 cityLedgerAccount #365 opera:ft:14402861 duplictae
2792 2023-11-17 transfer 9003 Direct Bill 1,113.91 cityLedgerAccount #375 opera:9003:14568612 Direct Bill
2791 2023-11-17 transfer 9003 Direct Bill -1,113.91 cityLedgerAccount #368 opera:9003:14568611 Direct Bill
2790 2023-11-17 transfer 9003 Direct Bill 2,412.20 cityLedgerAccount #375 opera:9003:14568610 Direct Bill
2789 2023-11-17 transfer 9003 Direct Bill -2,412.20 cityLedgerAccount #368 opera:9003:14568609 Direct Bill
2788 2023-11-17 transfer 9003 Direct Bill 57.92 cityLedgerAccount #375 opera:9003:14568608 Direct Bill
2787 2023-11-17 transfer 9003 Direct Bill -57.92 cityLedgerAccount #368 opera:9003:14568607 Direct Bill
2786 2023-11-17 transfer 9003 Direct Bill 41.98 cityLedgerAccount #375 opera:9003:14568606 Direct Bill
2785 2023-11-17 transfer 9003 Direct Bill -41.98 cityLedgerAccount #368 opera:9003:14568605 Direct Bill
2677 2023-11-17 transfer 9003 Direct Bill -8.75 cityLedgerAccount #365 opera:9003:14402938 Direct Bill
2676 2023-11-17 transfer 9003 Direct Bill 1,267.10 cityLedgerAccount #148 opera:9003:14402846 Direct Bill
2675 2023-11-17 transfer 9003 Direct Bill 11,713.86 cityLedgerAccount #148 opera:9003:14402845 Direct Bill
2674 2023-11-17 transfer 9003 Direct Bill 11,999.09 cityLedgerAccount #148 opera:9003:14402844 Direct Bill
2673 2023-11-17 transfer 9003 Direct Bill -15,244.00 cityLedgerAccount #148 opera:9003:14402843 Direct Bill
2672 2023-11-17 transfer 9003 Direct Bill 6,757.85 cityLedgerAccount #370 opera:9003:14402831 Direct Bill
2671 2023-11-17 transfer 9003 Direct Bill 1,952.00 cityLedgerAccount #370 opera:9003:14402830 Direct Bill
2670 2023-11-17 transfer 9003 Direct Bill -5,418.00 cityLedgerAccount #370 opera:9003:14402829 Direct Bill
Sum (balance): 95,375.20