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 4428/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
806 2022-02-23 transfer 9003 Direct Bill 3,372.85 cityLedgerAccount #38 opera:9003:12684229 Direct Bill
436521 2022-02-22 transfer 9991 Cash Drop Trans. Code (Inter... 50,041.55 opera:ft:12683211 cash_drop
436520 2022-02-22 transfer 9991 Cash Drop Trans. Code (Inter... 44.00 opera:ft:12683210 cash_drop
436519 2022-02-22 payment 9011 Electronic Check / Wire Tran... WIRE -45,041.55 cityLedgerAccount #94 opera:ft:12680834 B021822
805 2022-02-22 transfer 9003 Direct Bill 1,427.19 cityLedgerAccount #38 opera:9003:12682543 Direct Bill
436518 2022-02-21 payment 9007 Master Card CARD -24,986.46 cityLedgerAccount #161 opera:ft:12679627
436517 2022-02-21 payment 9008 Visa CARD -4,940.71 cityLedgerAccount #101 opera:ft:12679561
436516 2022-02-21 payment 9008 Visa CARD -5,000.00 cityLedgerAccount #178 opera:ft:12679539
436515 2022-02-21 charge 2061 Banquet Sales Tax -17.41 cityLedgerAccount #161 opera:ft:12679335
436514 2022-02-21 charge 2052 Banquet Room Rental RST -497.31 cityLedgerAccount #161 opera:ft:12679334 adju
436513 2022-02-21 transfer 9991 Cash Drop Trans. Code (Inter... 1,500.00 opera:ft:12679175 cash_drop
804 2022-02-21 transfer 9003 Direct Bill -514.72 cityLedgerAccount #161 opera:9003:12679336 Direct Bill
436512 2022-02-20 transfer 9991 Cash Drop Trans. Code (Inter... 102.57 opera:ft:12678094 cash_drop
436511 2022-02-20 transfer 9991 Cash Drop Trans. Code (Inter... 540.00 opera:ft:12677976 cash_drop
436510 2022-02-19 transfer 9991 Cash Drop Trans. Code (Inter... 313.69 opera:ft:12676078 cash_drop
436509 2022-02-19 payment 9007 Master Card CARD -25.00 opera:ft:12674951
436508 2022-02-19 charge 8010 Other Revenue MSC 25.00 opera:ft:12674950 Water Bottle
436507 2022-02-18 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:12674137 cash_drop
436506 2022-02-18 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:12674136 cash_drop
436505 2022-02-18 payment 9006 American Express CARD -7,773.51 cityLedgerAccount #180 opera:ft:12673454
436504 2022-02-18 transfer 9991 Cash Drop Trans. Code (Inter... 3.00 opera:ft:12673388 cash_drop
803 2022-02-18 transfer 9003 Direct Bill 2,796.00 cityLedgerAccount #181 opera:9003:12673473 Direct Bill
802 2022-02-18 transfer 9003 Direct Bill 12,364.54 cityLedgerAccount #181 opera:9003:12673472 Direct Bill
801 2022-02-18 transfer 9003 Direct Bill 4,172.64 cityLedgerAccount #181 opera:9003:12673471 Direct Bill
800 2022-02-18 transfer 9003 Direct Bill -19,000.00 cityLedgerAccount #181 opera:9003:12673470 Direct Bill
799 2022-02-18 transfer 9003 Direct Bill 663.00 cityLedgerAccount #181 opera:9003:12673469 Direct Bill
436503 2022-02-17 transfer 9991 Cash Drop Trans. Code (Inter... 77,053.97 opera:ft:12672048 cash_drop
436502 2022-02-17 payment 9007 Master Card CARD -3,375.23 cityLedgerAccount #172 opera:ft:12671592
436501 2022-02-17 payment 9011 Electronic Check / Wire Tran... WIRE -77,053.97 cityLedgerAccount #94 opera:ft:12671502 021522 -
798 2022-02-17 transfer 9003 Direct Bill 207,175.30 cityLedgerAccount #94 opera:9003:12671527 Direct Bill
797 2022-02-17 transfer 9003 Direct Bill -500.00 cityLedgerAccount #94 opera:9003:12671437 Direct Bill
436500 2022-02-15 transfer 9991 Cash Drop Trans. Code (Inter... 228.00 opera:ft:12669225 cash_drop
436499 2022-02-15 credit 8500 Allowance InHouse Comps (901... ALW 20.00 cityLedgerAccount #24 opera:ft:12668920
436498 2022-02-15 credit 8500 Allowance InHouse Comps (901... ALW -50.20 cityLedgerAccount #24 opera:ft:12668918 comp
436497 2022-02-15 credit 8500 Allowance InHouse Comps (901... ALW -60.20 cityLedgerAccount #24 opera:ft:12668916 comp
436496 2022-02-15 charge 2302 IRD Lunch Sales Tax -6.05 cityLedgerAccount #24 opera:ft:12668914 programs
436495 2022-02-15 charge 2095 Terras Sales Tax -23.34 cityLedgerAccount #24 opera:ft:12668913 programs
436494 2022-02-15 charge 2084 Terras Dinner DNR -251.00 cityLedgerAccount #24 opera:ft:12668912 programs
436493 2022-02-15 charge 2009 In-Room Dining Sales Tax -2.42 cityLedgerAccount #24 opera:ft:12668911 programs
436492 2022-02-15 charge 2009 In-Room Dining Sales Tax -2.33 cityLedgerAccount #24 opera:ft:12668910 programs
436491 2022-02-15 charge 2002 In-Room Dining Lunch LUN -60.00 cityLedgerAccount #24 opera:ft:12668909 programs
436490 2022-02-15 charge 2001 In Room Dining Breakfast BRK -21.00 cityLedgerAccount #24 opera:ft:12668908 programs
436489 2022-02-15 charge 2001 In Room Dining Breakfast BRK -20.00 cityLedgerAccount #24 opera:ft:12668907 programs
436488 2022-02-15 charge 1010 Room Tax -66.88 cityLedgerAccount #24 opera:ft:12668905 guest checked out already
436487 2022-02-15 charge 1001 Room Charge RTX -504.00 cityLedgerAccount #24 opera:ft:12668903 guest checked out already
436486 2022-02-15 charge 2001 In Room Dining Breakfast BRK 21.00 cityLedgerAccount #24 opera:ft:12668896 [Ind. Charge Transfer from ACCOUNT#: CHO...
436485 2022-02-15 charge 2001 In Room Dining Breakfast BRK -21.00 cityLedgerAccount #101 opera:ft:12668895 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436484 2022-02-15 charge 2000 In-Room Dining Delivery Fee RST 5.00 cityLedgerAccount #24 opera:ft:12668894
436483 2022-02-15 charge 2008 In Room Dining Gratuity NRV 9.20 cityLedgerAccount #24 opera:ft:12668893 [Ind. Charge Transfer from ACCOUNT#: CHO...
436482 2022-02-15 charge 2000 In-Room Dining Delivery Fee RST -5.00 cityLedgerAccount #101 opera:ft:12668892 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436481 2022-02-15 charge 2008 In Room Dining Gratuity NRV -9.20 cityLedgerAccount #101 opera:ft:12668891 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436480 2022-02-15 charge 2009 In-Room Dining Sales Tax 2.42 cityLedgerAccount #24 opera:ft:12668890 [Ind. Charge Transfer from ACCOUNT#: CHO...
436479 2022-02-15 charge 2009 In-Room Dining Sales Tax -2.42 cityLedgerAccount #101 opera:ft:12668889 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436478 2022-02-15 charge 2084 Terras Dinner DNR 251.00 cityLedgerAccount #24 opera:ft:12668888 [Ind. Charge Transfer from ACCOUNT#: CHO...
436477 2022-02-15 charge 2084 Terras Dinner DNR -251.00 cityLedgerAccount #101 opera:ft:12668887 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436476 2022-02-15 charge 2094 Terras Dinner Gratuity NRV 50.20 cityLedgerAccount #24 opera:ft:12668886 [Ind. Charge Transfer from ACCOUNT#: CHO...
436475 2022-02-15 charge 2094 Terras Dinner Gratuity NRV -50.20 cityLedgerAccount #101 opera:ft:12668884 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436474 2022-02-15 charge 2095 Terras Sales Tax 23.34 cityLedgerAccount #24 opera:ft:12668883 [Ind. Charge Transfer from ACCOUNT#: CHO...
436473 2022-02-15 charge 2095 Terras Sales Tax -23.34 cityLedgerAccount #101 opera:ft:12668881 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436472 2022-02-15 charge 2001 In Room Dining Breakfast BRK 20.00 cityLedgerAccount #24 opera:ft:12668879 [Ind. Charge Transfer from ACCOUNT#: CHO...
436471 2022-02-15 charge 2001 In Room Dining Breakfast BRK -20.00 cityLedgerAccount #101 opera:ft:12668878 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436470 2022-02-15 charge 2000 In-Room Dining Delivery Fee RST 5.00 cityLedgerAccount #24 opera:ft:12668877
436469 2022-02-15 charge 2008 In Room Dining Gratuity NRV 14.00 cityLedgerAccount #24 opera:ft:12668876 [Ind. Charge Transfer from ACCOUNT#: CHO...
436468 2022-02-15 charge 2000 In-Room Dining Delivery Fee RST -5.00 cityLedgerAccount #101 opera:ft:12668875 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436467 2022-02-15 charge 2008 In Room Dining Gratuity NRV -14.00 cityLedgerAccount #101 opera:ft:12668874 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436466 2022-02-15 charge 2009 In-Room Dining Sales Tax 2.33 cityLedgerAccount #24 opera:ft:12668873 [Ind. Charge Transfer from ACCOUNT#: CHO...
436465 2022-02-15 charge 2009 In-Room Dining Sales Tax -2.33 cityLedgerAccount #101 opera:ft:12668872 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436464 2022-02-15 charge 2002 In-Room Dining Lunch LUN 60.00 cityLedgerAccount #24 opera:ft:12668871 [Ind. Charge Transfer from ACCOUNT#: CHO...
436463 2022-02-15 charge 2002 In-Room Dining Lunch LUN -60.00 cityLedgerAccount #101 opera:ft:12668870 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436462 2022-02-15 charge 2000 In-Room Dining Delivery Fee RST 5.00 cityLedgerAccount #24 opera:ft:12668869
436461 2022-02-15 charge 2008 In Room Dining Gratuity NRV 17.00 cityLedgerAccount #24 opera:ft:12668868 [Ind. Charge Transfer from ACCOUNT#: CHO...
436460 2022-02-15 charge 2000 In-Room Dining Delivery Fee RST -5.00 cityLedgerAccount #101 opera:ft:12668867 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436459 2022-02-15 charge 2008 In Room Dining Gratuity NRV -17.00 cityLedgerAccount #101 opera:ft:12668866 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436458 2022-02-15 charge 2302 IRD Lunch Sales Tax 6.05 cityLedgerAccount #24 opera:ft:12668865 [Ind. Charge Transfer from ACCOUNT#: CHO...
436457 2022-02-15 charge 2302 IRD Lunch Sales Tax -6.05 cityLedgerAccount #101 opera:ft:12668864 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436456 2022-02-15 charge 1001 Room Charge RTX 504.00 cityLedgerAccount #24 opera:ft:12668863 [Ind. Charge Transfer from ACCOUNT#: CHO...
436455 2022-02-15 charge 1001 Room Charge RTX -504.00 cityLedgerAccount #101 opera:ft:12668862 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
436454 2022-02-15 charge 1010 Room Tax 66.88 cityLedgerAccount #24 opera:ft:12668861 [Ind. Charge Transfer from ACCOUNT#: CHO...
436453 2022-02-15 charge 1010 Room Tax -66.88 cityLedgerAccount #101 opera:ft:12668860 [Ind. Charge Transfer to ACCOUNT#:CIVANA...
796 2022-02-15 transfer 9003 Direct Bill 1,047.42 cityLedgerAccount #24 opera:9003:12668898 Direct Bill
795 2022-02-15 transfer 9003 Direct Bill -608.26 cityLedgerAccount #101 opera:9003:12668836 Direct Bill
794 2022-02-14 transfer 9003 Direct Bill 2,477.10 cityLedgerAccount #101 opera:9003:12667331 Direct Bill
793 2022-02-14 transfer 9003 Direct Bill 1,582.05 cityLedgerAccount #101 opera:9003:12667330 Direct Bill
792 2022-02-14 transfer 9003 Direct Bill 2,537.24 cityLedgerAccount #101 opera:9003:12667324 Direct Bill
436452 2022-02-13 transfer 9991 Cash Drop Trans. Code (Inter... 571.84 opera:ft:12665924 cash_drop
436451 2022-02-13 payment 9006 American Express CARD -25.00 opera:ft:12665797
436450 2022-02-13 charge 2017 Guest Experience Gratuity NRV 3.53 opera:ft:12665796
436449 2022-02-13 charge 8026 Retail sales tax 1.83 opera:ft:12665795
436448 2022-02-13 charge 7100 Sundries 9.3% Tax Inclusive MSC 25.00 opera:ft:12665794
436447 2022-02-12 transfer 9991 Cash Drop Trans. Code (Inter... 300.00 opera:ft:12665113 cash_drop
436446 2022-02-12 transfer 9991 Cash Drop Trans. Code (Inter... 216.00 opera:ft:12665112 cash_drop
436445 2022-02-11 transfer 9991 Cash Drop Trans. Code (Inter... 991.00 opera:ft:12663545 cash_drop
436444 2022-02-11 transfer 9993 Check Drop Trans. Code (Inte... 238.15 opera:ft:12663544 cash_drop
436443 2022-02-11 transfer 9991 Cash Drop Trans. Code (Inter... 8.00 opera:ft:12663543 cash_drop
436442 2022-02-11 charge 1010 Room Tax -84.66 cityLedgerAccount #161 opera:ft:12662632
436441 2022-02-11 charge 1004 No Show Revenue RTX -638.00 cityLedgerAccount #161 opera:ft:12662631 Duplicates
436440 2022-02-11 charge 1011 Sales Tax 95.72 cityLedgerAccount #32 opera:ft:12662421
436439 2022-02-11 charge 2069 Third Party Vendor RST 1,125.00 cityLedgerAccount #32 opera:ft:12662420
436438 2022-02-11 payment 9007 Master Card CARD -5,000.00 cityLedgerAccount #172 opera:ft:12662370
436437 2022-02-11 payment 9008 Visa CARD -4,151.88 cityLedgerAccount #171 opera:ft:12662363
Sum (balance): 172,762.09