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

Ledger transactions (folio_transactions)

Reset
600817 rows (page 5988/6009)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
346 2021-07-20 transfer 9003 Direct Bill — 264.00 cityLedgerAccount #80 — — — opera:9003:12283924 Direct Bill
345 2021-07-20 transfer 9003 Direct Bill — -1,370.10 cityLedgerAccount #73 — — — opera:9003:12283749 Direct Bill
586731 2021-07-19 transfer 9991 Cash Drop Trans. Code (Inter... — 48,082.49 — — — — opera:ft:12282844 cash_drop
586730 2021-07-19 charge 2061 Banquet Sales Tax — -1.59 cityLedgerAccount #100 — — — opera:ft:12282461 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
586729 2021-07-19 charge 2061 Banquet Sales Tax — -25.42 cityLedgerAccount #100 — — — opera:ft:12282459 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
586728 2021-07-19 charge 2059 Banquet Service Charge RST -49.28 cityLedgerAccount #100 — — — opera:ft:12282457 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
586727 2021-07-19 charge 2059 Banquet Service Charge RST -3.08 cityLedgerAccount #100 — — — opera:ft:12282455 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
586726 2021-07-19 charge 2047 Banquet Liquor ALC -224.00 cityLedgerAccount #100 — — — opera:ft:12282451 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
586725 2021-07-19 charge 2047 Banquet Liquor ALC -14.00 cityLedgerAccount #100 — — — opera:ft:12282449 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
586724 2021-07-19 transfer 9991 Cash Drop Trans. Code (Inter... — 205.00 — — — — opera:ft:12282387 cash_drop
586723 2021-07-18 transfer 9991 Cash Drop Trans. Code (Inter... — 322.00 — — — — opera:ft:12280890 cash_drop
586722 2021-07-17 transfer 9991 Cash Drop Trans. Code (Inter... — 45.91 — — — — opera:ft:12280038 cash_drop
344 2021-07-15 transfer 9003 Direct Bill — 1,454.72 cityLedgerAccount #100 — — — opera:9003:12275264 Direct Bill
586721 2021-07-12 transfer 9991 Cash Drop Trans. Code (Inter... — 300.00 — — — — opera:ft:12271889 cash_drop
586720 2021-07-10 transfer 9991 Cash Drop Trans. Code (Inter... — 400.00 — — — — opera:ft:12269306 cash_drop
586719 2021-07-09 transfer 9993 Check Drop Trans. Code (Inte... — 16,500.00 — — — — opera:ft:12268375 cash_drop
586718 2021-07-09 transfer 9991 Cash Drop Trans. Code (Inter... — 43.00 — — — — opera:ft:12268374 cash_drop
586717 2021-07-09 transfer 9991 Cash Drop Trans. Code (Inter... — 288.00 — — — — opera:ft:12268373 cash_drop
586716 2021-07-08 transfer 9991 Cash Drop Trans. Code (Inter... — 30.00 — — — — opera:ft:12266748 cash_drop
586715 2021-07-08 transfer 9991 Cash Drop Trans. Code (Inter... — 641.26 — — — — opera:ft:12266274 cash_drop
586714 2021-07-07 transfer 9991 Cash Drop Trans. Code (Inter... — 128.97 — — — — opera:ft:12265426 cash_drop
343 2021-07-06 transfer 9003 Direct Bill — 190.51 cityLedgerAccount #26 — — — opera:9003:12263539 Direct Bill
342 2021-07-06 transfer 9003 Direct Bill — -25,465.29 cityLedgerAccount #73 — — — opera:9003:12263536 Direct Bill
341 2021-07-06 transfer 9003 Direct Bill — 72,757.97 cityLedgerAccount #73 — — — opera:9003:12263535 Direct Bill
586713 2021-07-03 payment 9008 Visa CARD -3.00 — — — — opera:ft:12258964
586712 2021-07-03 charge 2017 Guest Experience Gratuity NRV 0.42 — — — — opera:ft:12258963
586711 2021-07-03 charge 8026 Retail sales tax — 0.22 — — — — opera:ft:12258962
586710 2021-07-03 charge 7100 Sundries 9.3% Tax Inclusive MSC 3.00 — — — — opera:ft:12258961
586709 2021-07-02 transfer 9991 Cash Drop Trans. Code (Inter... — 368.93 — — — — opera:ft:12257663 cash_drop
586708 2021-07-02 charge 1010 Room Tax — -308.61 cityLedgerAccount #80 — — — opera:ft:12257007
586707 2021-07-02 charge 8520 Room Adjustment RTX -2,325.60 cityLedgerAccount #80 — — — opera:ft:12257006 see if it changes market code
586706 2021-07-02 charge 1010 Room Tax — 44.07 cityLedgerAccount #80 — — — opera:ft:12256996
586705 2021-07-02 charge 8520 Room Adjustment RTX 332.10 cityLedgerAccount #80 — — — opera:ft:12256995 wrong market code
586704 2021-07-02 charge 1010 Room Tax — 43.71 cityLedgerAccount #80 — — — opera:ft:12256994
586703 2021-07-02 charge 8520 Room Adjustment RTX 329.40 cityLedgerAccount #80 — — — opera:ft:12256993 wrong market code
586702 2021-07-02 charge 1010 Room Tax — 44.07 cityLedgerAccount #80 — — — opera:ft:12256992
586701 2021-07-02 charge 8520 Room Adjustment RTX 332.10 cityLedgerAccount #80 — — — opera:ft:12256991 wrong market code
586700 2021-07-02 charge 1010 Room Tax — 44.07 cityLedgerAccount #80 — — — opera:ft:12256990
586699 2021-07-02 charge 8520 Room Adjustment RTX 332.10 cityLedgerAccount #80 — — — opera:ft:12256989 wrong market code
586698 2021-07-02 charge 1010 Room Tax — 44.55 cityLedgerAccount #80 — — — opera:ft:12256988
586697 2021-07-02 charge 8520 Room Adjustment RTX 335.70 cityLedgerAccount #80 — — — opera:ft:12256987 wrong market code
586696 2021-07-02 charge 1010 Room Tax — 44.07 cityLedgerAccount #80 — — — opera:ft:12256986
586695 2021-07-02 charge 8520 Room Adjustment RTX 332.10 cityLedgerAccount #80 — — — opera:ft:12256985 wrong market code
586694 2021-07-02 charge 1010 Room Tax — 44.07 cityLedgerAccount #80 — — — opera:ft:12256984
586693 2021-07-02 charge 8520 Room Adjustment RTX 332.10 cityLedgerAccount #80 — — — opera:ft:12256983 wrong market code
340 2021-07-02 transfer 9003 Direct Bill — 299.11 cityLedgerAccount #17 — — — opera:9003:12257060 Direct Bill
339 2021-07-02 transfer 9003 Direct Bill — -2,634.21 cityLedgerAccount #80 — — — opera:9003:12257008 Direct Bill adjust
586692 2021-07-01 transfer 9993 Check Drop Trans. Code (Inte... — 30,125.98 — — — — opera:ft:12256394 cash_drop
586691 2021-07-01 charge 1010 Room Tax — -44.07 cityLedgerAccount #80 — — — opera:ft:12255942
586690 2021-07-01 charge 8520 Room Adjustment RTX -332.10 cityLedgerAccount #80 — — — opera:ft:12255941 Per Camilla, Negotiated
586689 2021-07-01 charge 1010 Room Tax — -43.71 cityLedgerAccount #80 — — — opera:ft:12255940
586688 2021-07-01 charge 8520 Room Adjustment RTX -329.40 cityLedgerAccount #80 — — — opera:ft:12255939 Per Camilla, Negotiated
586687 2021-07-01 charge 1010 Room Tax — -44.07 cityLedgerAccount #80 — — — opera:ft:12255938
586686 2021-07-01 charge 8520 Room Adjustment RTX -332.10 cityLedgerAccount #80 — — — opera:ft:12255937 Per Camilla, Negotiated
586685 2021-07-01 charge 1010 Room Tax — -44.07 cityLedgerAccount #80 — — — opera:ft:12255936
586684 2021-07-01 charge 8520 Room Adjustment RTX -332.10 cityLedgerAccount #80 — — — opera:ft:12255935 Per Camilla, Negotiated
586683 2021-07-01 charge 1010 Room Tax — -44.55 cityLedgerAccount #80 — — — opera:ft:12255934
586682 2021-07-01 charge 8520 Room Adjustment RTX -335.70 cityLedgerAccount #80 — — — opera:ft:12255933 Per Camilla, Negotiated
586681 2021-07-01 charge 1010 Room Tax — -44.07 cityLedgerAccount #80 — — — opera:ft:12255932
586680 2021-07-01 charge 8520 Room Adjustment RTX -332.10 cityLedgerAccount #80 — — — opera:ft:12255931 Per Camilla, Negotiated
586679 2021-07-01 charge 1010 Room Tax — -44.07 cityLedgerAccount #80 — — — opera:ft:12255930
586678 2021-07-01 charge 8520 Room Adjustment RTX -332.10 cityLedgerAccount #80 — — — opera:ft:12255929 Per Camilla, Negotiated
586677 2021-07-01 payment 9001 Check CHECK -19,262.53 cityLedgerAccount #97 — — — opera:ft:12255435 062421 - 7426
586676 2021-07-01 payment 9001 Check CHECK -113.45 cityLedgerAccount #17 — — — opera:ft:12255418 061521 - 1390
586675 2021-06-30 transfer 9991 Cash Drop Trans. Code (Inter... — 88,409.49 — — — — opera:ft:12254999 cash_drop
586674 2021-06-30 credit 8103 Group Commission ALW -45,444.47 cityLedgerAccount #73 — — — opera:ft:12254601 Chopra Comm
586673 2021-06-30 payment 9011 Electronic Check / Wire Tran... WIRE -62,944.20 cityLedgerAccount #73 — — — opera:ft:12254598
338 2021-06-30 transfer 9003 Direct Bill — 2,995.23 cityLedgerAccount #80 — — — opera:9003:12254673 Direct Bill
337 2021-06-30 transfer 9003 Direct Bill — -45,444.47 cityLedgerAccount #73 — — — opera:9003:12254602 Direct Bill
586672 2021-06-29 transfer 9993 Check Drop Trans. Code (Inte... — 7,500.00 — — — — opera:ft:12253633 cash_drop
586671 2021-06-29 transfer 9991 Cash Drop Trans. Code (Inter... — 800.00 — — — — opera:ft:12253588 cash_drop
586670 2021-06-28 transfer 9991 Cash Drop Trans. Code (Inter... — 0.00 — — — — opera:ft:12252177 cash_drop
586669 2021-06-27 transfer 9991 Cash Drop Trans. Code (Inter... — 4,057.66 — — — — opera:ft:12245614 cash_drop
586668 2021-06-27 transfer 9991 Cash Drop Trans. Code (Inter... — 3.00 — — — — opera:ft:12245530 cash_drop
586667 2021-06-27 transfer 9991 Cash Drop Trans. Code (Inter... — 450.00 — — — — opera:ft:12245082 cash_drop
586666 2021-06-26 transfer 9991 Cash Drop Trans. Code (Inter... — 888.00 — — — — opera:ft:12243836 cash_drop
586665 2021-06-24 transfer 9991 Cash Drop Trans. Code (Inter... — 29,624.61 — — — — opera:ft:12240257 cash_drop
586664 2021-06-24 transfer 9991 Cash Drop Trans. Code (Inter... — 220.00 — — — — opera:ft:12240256 cash_drop
586663 2021-06-24 credit 8103 Group Commission ALW -31,545.49 cityLedgerAccount #73 — — — opera:ft:12239798 April
586662 2021-06-24 payment 9011 Electronic Check / Wire Tran... WIRE -29,624.61 cityLedgerAccount #73 — — — opera:ft:12239385 5.21.21
336 2021-06-24 transfer 9003 Direct Bill — -31,545.49 cityLedgerAccount #73 — — — opera:9003:12239799 Direct Bill
335 2021-06-24 transfer 9003 Direct Bill — -5,167.38 cityLedgerAccount #73 — — — opera:9003:12239471 Direct Bill
334 2021-06-24 transfer 9003 Direct Bill — -9,391.80 cityLedgerAccount #73 — — — opera:9003:12239469 Direct Bill
586661 2021-06-23 transfer 9991 Cash Drop Trans. Code (Inter... — 0.00 — — — — opera:ft:12238874 cash_drop
586660 2021-06-23 payment 9006 American Express CARD -29,293.88 cityLedgerAccount #94 — — — opera:ft:12238123
586659 2021-06-23 payment 9007 Master Card CARD -9,089.77 cityLedgerAccount #99 — — — opera:ft:12238109
586658 2021-06-22 transfer 9991 Cash Drop Trans. Code (Inter... — 100.00 — — — — opera:ft:12237787 cash_drop
586657 2021-06-21 transfer 9991 Cash Drop Trans. Code (Inter... — 180.00 — — — — opera:ft:12236638 cash_drop
586656 2021-06-21 transfer 9991 Cash Drop Trans. Code (Inter... — 80.00 — — — — opera:ft:12236150 cash_drop
333 2021-06-21 transfer 9003 Direct Bill — 107,089.28 cityLedgerAccount #73 — — — opera:9003:12236185 Direct Bill
332 2021-06-21 transfer 9003 Direct Bill — 62.46 cityLedgerAccount #96 — — — opera:9003:12235899 Direct Bill
586655 2021-06-20 transfer 9991 Cash Drop Trans. Code (Inter... — 503.00 — — — — opera:ft:12234635 cash_drop
586654 2021-06-18 transfer 9991 Cash Drop Trans. Code (Inter... — 28.29 — — — — opera:ft:12231197 cash_drop
586653 2021-06-18 transfer 9991 Cash Drop Trans. Code (Inter... — 3.00 — — — — opera:ft:12231119 cash_drop
331 2021-06-17 transfer 9003 Direct Bill — 4,133.93 cityLedgerAccount #99 — — — opera:9003:12228892 Direct Bill
330 2021-06-17 transfer 9003 Direct Bill — 5,955.84 cityLedgerAccount #99 — — — opera:9003:12228891 Direct Bill
329 2021-06-17 transfer 9003 Direct Bill — -1,000.00 cityLedgerAccount #99 — — — opera:9003:12228890 Direct Bill
586652 2021-06-16 transfer 9993 Check Drop Trans. Code (Inte... — 7,500.00 — — — — opera:ft:12228051 cash_drop
586651 2021-06-16 transfer 9991 Cash Drop Trans. Code (Inter... — 4.00 — — — — opera:ft:12227583 cash_drop
328 2021-06-16 transfer 9003 Direct Bill — -12,000.00 cityLedgerAccount #98 — — — opera:9003:12227664 Direct Bill
Sum (balance): 68,747.56