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 4458/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
434142 2020-07-20 payment 9008 Visa CARD -11,860.12 cityLedgerAccount #76 opera:ft:11884891 Final Payment
434141 2020-07-19 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884883 cash_drop
434140 2020-07-17 payment 9008 Visa CARD -187.20 cityLedgerAccount #81 opera:ft:11884869
434139 2020-07-17 credit 8501 Allowance Bad Debt Write Off ALW -174.55 cityLedgerAccount #79 opera:ft:11884867 7 months later
434138 2020-07-17 credit 1056 Allowance Experience Fee ALW 60.00 cityLedgerAccount #1 opera:ft:11884863 paid to the guest [Ind. Charge Transfer...
434137 2020-07-17 charge 1011 Sales Tax 5.58 cityLedgerAccount #1 opera:ft:11884861 [Ind. Charge Transfer to ACCOUNT#:EXP100...
185 2020-07-17 transfer 9003 Direct Bill -65.58 cityLedgerAccount #9 opera:9003:11884866 Direct Bill
434136 2020-07-16 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884853 cash_drop
434135 2020-07-16 payment 9008 Visa CARD -1,696.47 cityLedgerAccount #19 opera:ft:11884852
434134 2020-07-10 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884810 cash_drop
434133 2020-07-08 transfer 9993 Check Drop Trans. Code (Inte... 0.00 opera:ft:11884801 cash_drop
434132 2020-07-08 payment 9001 Check CHECK 1,624.29 cityLedgerAccount #72 opera:ft:11884798 1 per 50 comp
434131 2020-07-08 charge 1010 Room Tax -190.29 cityLedgerAccount #72 opera:ft:11884796
434130 2020-07-08 charge 1000 Room Charge RTX -1,624.29 cityLedgerAccount #72 opera:ft:11884795 1 per 50 comp
184 2020-07-08 transfer 9003 Direct Bill -1,624.29 cityLedgerAccount #72 opera:9003:11884797 Direct Bill 1 per 50 COmp
434129 2020-07-03 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884774 cash_drop
434128 2020-07-02 transfer 9993 Check Drop Trans. Code (Inte... 10,358.36 opera:ft:11884745 cash_drop
434127 2020-07-02 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884744 cash_drop
434126 2020-07-02 payment 9001 Check CHECK -358.36 cityLedgerAccount #26 opera:ft:11884743 1254
434125 2020-06-29 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884703 cash_drop
434124 2020-06-26 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884603 cash_drop
434123 2020-06-22 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884353 cash_drop
434122 2020-06-22 transfer 9993 Check Drop Trans. Code (Inte... 100.00 opera:ft:11884352 cash_drop
434121 2020-06-22 payment 9001 Check CHECK -100.00 cityLedgerAccount #17 opera:ft:11884351 0000354545
434120 2020-06-22 charge 8102 Vendor Commission (Received) MSC 100.00 cityLedgerAccount #17 opera:ft:11884349 Ocotber Referal
183 2020-06-22 transfer 9003 Direct Bill 100.00 cityLedgerAccount #17 opera:9003:11884350 Direct Bill
434119 2020-06-21 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884344 cash_drop
434118 2020-06-19 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884323 cash_drop
182 2020-06-19 transfer 9003 Direct Bill 187.20 cityLedgerAccount #81 opera:9003:11884318 Direct Bill
181 2020-06-19 transfer 9003 Direct Bill 224.20 cityLedgerAccount #80 opera:9003:11884317 Direct Bill
180 2020-06-19 transfer 9003 Direct Bill 131.20 cityLedgerAccount #78 opera:9003:11884315 Direct Bill
434117 2020-06-15 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11884085 cash_drop
434116 2020-06-15 credit 8501 Allowance Bad Debt Write Off ALW -158.00 cityLedgerAccount #68 opera:ft:11884083 Per Larry Lamy
434115 2020-06-13 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11883998 cash_drop
434114 2020-06-12 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11883953 cash_drop
434113 2020-06-11 transfer 9993 Check Drop Trans. Code (Inte... 33.26 opera:ft:11883828 cash_drop
434112 2020-06-11 payment 9001 Check CHECK -33.26 cityLedgerAccount #26 opera:ft:11883827 1252
434111 2020-06-07 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11883642 cash_drop
434110 2020-06-04 transfer 9993 Check Drop Trans. Code (Inte... 74,263.04 opera:ft:11883503 cash_drop
434109 2020-06-04 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11883502 cash_drop
434108 2020-06-04 payment 9001 Check CHECK -74,263.04 cityLedgerAccount #72 opera:ft:11883501 11304
434107 2020-05-31 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11883306 cash_drop
434106 2020-05-30 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11883256 cash_drop
434105 2020-05-26 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11883050 cash_drop
434104 2020-05-25 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11882999 cash_drop
434103 2020-05-22 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11882848 cash_drop
434102 2020-05-21 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11882797 cash_drop
434101 2020-05-20 transfer 9993 Check Drop Trans. Code (Inte... 1,082.88 opera:ft:11882742 cash_drop
434100 2020-05-20 payment 9001 Check CHECK -1,082.88 cityLedgerAccount #5 opera:ft:11882730 #51815
434099 2020-05-20 charge 8528 Sales Tax Adjustment 0.05 cityLedgerAccount #15 opera:ft:11882728
434098 2020-05-20 payment 9006 American Express CARD -15,670.22 cityLedgerAccount #15 opera:ft:11882727 Final Payment
179 2020-05-20 transfer 9003 Direct Bill 0.05 cityLedgerAccount #15 opera:9003:11882729 Direct Bill adju
434097 2020-05-17 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11882543 cash_drop
434096 2020-05-16 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11882484 cash_drop
434095 2020-05-15 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11882425 cash_drop
434094 2020-05-14 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11882363 cash_drop
434093 2020-05-14 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11882362 cash_drop
434092 2020-05-14 charge 2103 Seed Lunch LUN -5.00 cityLedgerAccount #26 opera:ft:11882360 20% 10/22/19
434091 2020-05-14 credit 2096 Allowance Terras ALW -16.00 cityLedgerAccount #26 opera:ft:11882358 Negotiated discount
434090 2020-05-14 credit 2096 Allowance Terras ALW -10.80 cityLedgerAccount #26 opera:ft:11882357 Negotiated discount
434089 2020-05-14 charge 2103 Seed Lunch LUN -2.20 cityLedgerAccount #26 opera:ft:11882355 20%
434088 2020-05-14 charge 8528 Sales Tax Adjustment -6.87 cityLedgerAccount #26 opera:ft:11882353 adjustment
434087 2020-05-14 credit 2097 Allowance Terras Beverage ALW -8.00 cityLedgerAccount #26 opera:ft:11882351 20% not 10%
434086 2020-05-14 credit 2097 Allowance Terras Beverage ALW -6.40 cityLedgerAccount #26 opera:ft:11882350 20% not 10%
434085 2020-05-14 credit 2097 Allowance Terras Beverage ALW -3.60 cityLedgerAccount #26 opera:ft:11882349 20% not 10%
434084 2020-05-14 credit 2096 Allowance Terras ALW -11.10 cityLedgerAccount #26 opera:ft:11882348 20% not 10%
434083 2020-05-14 charge 2103 Seed Lunch LUN -1.30 cityLedgerAccount #26 opera:ft:11882347 20% not 10%
434082 2020-05-14 credit 2096 Allowance Terras ALW -16.10 cityLedgerAccount #26 opera:ft:11882346 20% not 10%
434081 2020-05-14 charge 1011 Sales Tax -5.58 cityLedgerAccount #1 opera:ft:11882257
434080 2020-05-14 credit 1056 Allowance Experience Fee ALW -60.00 cityLedgerAccount #1 opera:ft:11882256 paid to the guest
178 2020-05-14 transfer 9003 Direct Bill 185.40 cityLedgerAccount #26 opera:9003:11882345 Direct Bill
177 2020-05-14 transfer 9003 Direct Bill 55.47 cityLedgerAccount #26 opera:9003:11882336 Direct Bill
176 2020-05-14 transfer 9003 Direct Bill -331.24 cityLedgerAccount #27 opera:9003:11882305 Direct Bill
175 2020-05-14 transfer 9003 Direct Bill 331.24 cityLedgerAccount #27 opera:9003:11882285 Direct Bill
174 2020-05-14 transfer 9003 Direct Bill 320.51 cityLedgerAccount #77 opera:9003:11882267 Direct Bill
173 2020-05-14 transfer 9003 Direct Bill 410.97 cityLedgerAccount #76 opera:9003:11882263 Direct Bill
172 2020-05-14 transfer 9003 Direct Bill 25,749.15 cityLedgerAccount #76 opera:9003:11882262 Direct Bill
171 2020-05-14 transfer 9003 Direct Bill -14,300.00 cityLedgerAccount #76 opera:9003:11882261 Direct Bill
170 2020-05-14 transfer 9003 Direct Bill 2,522.69 cityLedgerAccount #75 opera:9003:11882260 Direct Bill
169 2020-05-14 transfer 9003 Direct Bill -250.00 cityLedgerAccount #75 opera:9003:11882259 Direct Bill
434079 2020-05-13 transfer 9991 Cash Drop Trans. Code (Inter... 1,070.40 opera:ft:11882197 cash_drop
434078 2020-05-13 charge 8090 Finance Charge MSC -16.06 cityLedgerAccount #12 opera:ft:11882195 was able to resolve within a week
434077 2020-05-13 payment 9011 Electronic Check / Wire Tran... WIRE -1,070.40 cityLedgerAccount #12 opera:ft:11882194 5.13.20
168 2020-05-11 transfer 9003 Direct Bill 30.06 cityLedgerAccount #27 opera:9003:11882036 Direct Bill
434076 2020-05-08 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11881859 cash_drop
434075 2020-05-06 charge 9700 Balance Forward MSC 17,387.04 cityLedgerAccount #47 opera:ft:11881593 From Ocotber 2020 Deposit
434074 2020-05-06 charge 8528 Sales Tax Adjustment 0.04 cityLedgerAccount #47 opera:ft:11881591 adju
434073 2020-05-06 credit 8500 Allowance InHouse Comps (901... ALW -150.80 cityLedgerAccount #55 opera:ft:11881588 per adam
434072 2020-05-06 credit 7015 Spa Massage Discount DSC -377.00 cityLedgerAccount #55 opera:ft:11881586 house
167 2020-05-06 transfer 9003 Direct Bill 0.04 cityLedgerAccount #47 opera:9003:11881592 Direct Bill adj
166 2020-05-05 transfer 9003 Direct Bill 289.85 cityLedgerAccount #1 opera:9003:11881513 Direct Bill
434071 2020-05-04 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11881453 cash_drop
434070 2020-05-01 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11881066 cash_drop
434069 2020-05-01 charge 8090 Finance Charge MSC 16.06 cityLedgerAccount #12 opera:ft:11881062 1.5% charge
165 2020-05-01 transfer 9003 Direct Bill 16.06 cityLedgerAccount #12 opera:9003:11881063 Direct Bill
434068 2020-04-30 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11880999 cash_drop
434067 2020-04-29 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:11880920 cash_drop
434066 2020-04-28 charge 2061 Banquet Sales Tax -9.39 cityLedgerAccount #70 opera:ft:11880845
434065 2020-04-28 credit 2063 Allowance Catering Food ALW -100.99 cityLedgerAccount #70 opera:ft:11880844 adju
434064 2020-04-28 charge 1010 Room Tax -892.53 cityLedgerAccount #72 opera:ft:11880837
Sum (balance): 9,915.18