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 2019/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
225415 2026-05-08 payment 9006 American Express CARD -114.40 guest #8182 11790 opera:ft:17362197
225414 2026-05-08 credit 8105 Shopify Commission ALW -8.73 guest #8182 14418 opera:ft:17362196
225413 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #8182 14418 opera:ft:17362195
225412 2026-05-08 charge 7033 Spa Package SPA -4.53 guest #8182 14418 opera:ft:17362194
225411 2026-05-08 charge 2018 Alcohol Sales Tax 2.05 houseAccount #18 14529 opera:ft:17362191
225410 2026-05-08 charge 2087 Terras Dinner Liquor ALC 22.00 houseAccount #18 14529 opera:ft:17362190
225409 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8180 14419 opera:ft:17362189
225408 2026-05-08 payment 9006 American Express CARD -22.00 guest #8180 11789 opera:ft:17362188
225407 2026-05-08 credit 8105 Shopify Commission ALW -8.73 guest #8180 14419 opera:ft:17362187
225406 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #8180 14419 opera:ft:17362186
225405 2026-05-08 charge 7033 Spa Package SPA -4.53 guest #8180 14419 opera:ft:17362185
225404 2026-05-08 charge 9996 Spa Package Profit 43.41 guest #8173 11781 opera:ft:17362182
225403 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8173 14437 opera:ft:17362180
225402 2026-05-08 credit 8105 Shopify Commission ALW -8.73 guest #8173 14437 opera:ft:17362179
225401 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #8173 14437 opera:ft:17362178
225400 2026-05-08 charge 7033 Spa Package SPA -4.53 guest #8173 14437 opera:ft:17362177
225399 2026-05-08 charge 9996 Spa Package Profit 148.86 guest #6904 8961 opera:ft:17362174
225398 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #6904 14417 opera:ft:17362171
225397 2026-05-08 charge 7800 Programs Sales Tax -2.55 guest #6904 8961 opera:ft:17362170
225396 2026-05-08 charge 8096 No Show Class CLS -30.00 guest #6904 8961 opera:ft:17362169 spa
225395 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #7165 14413 opera:ft:17362168
225394 2026-05-08 charge 9996 Spa Package Profit 173.66 guest #7621 10520 opera:ft:17362165
225393 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #7621 14441 opera:ft:17362163
225392 2026-05-08 payment 9007 Master Card CARD -64.48 guest #7621 10520 opera:ft:17362160
225391 2026-05-08 charge 7800 Programs Sales Tax -2.55 guest #7621 10520 opera:ft:17362159
225390 2026-05-08 charge 8096 No Show Class CLS -30.00 guest #7621 10520 opera:ft:17362158 spa
225389 2026-05-08 charge 9996 Spa Package Profit 74.42 guest #650 11634 opera:ft:17362157
225388 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #650 14405 opera:ft:17362154
225387 2026-05-08 charge 3205 Terras Dinner Sales Tax 13.67 reservation #1526 2633 opera:ft:17362153
225386 2026-05-08 charge 2094 Terras Dinner Gratuity NRV 30.00 reservation #1526 2633 opera:ft:17362152
225385 2026-05-08 charge 2084 Terras Dinner DNR 147.00 reservation #1526 2633 opera:ft:17362151
225384 2026-05-08 charge 9996 Spa Package Profit 173.66 guest #7919 11179 opera:ft:17362150
225383 2026-05-08 charge 9996 Spa Package Profit 49.62 guest #5050 4610 opera:ft:17362149
225382 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #5050 14412 opera:ft:17362147
225381 2026-05-08 payment 9006 American Express CARD -68.95 guest #5050 4610 opera:ft:17362144
225380 2026-05-08 charge 9996 Spa Package Profit 1,494.79 guest #4883 4346 opera:ft:17362143
225379 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 27.76 guest #4883 14414 opera:ft:17362141
225378 2026-05-08 credit 8105 Shopify Commission ALW -27.46 guest #4883 14414 opera:ft:17362140
225377 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #4883 14414 opera:ft:17362139
225376 2026-05-08 charge 3007 Amusement Tax -96.67 guest #4883 14414 opera:ft:17362138
225375 2026-05-08 charge 8086 Resort Day Passes MSC -1,631.04 guest #4883 14414 opera:ft:17362137
225374 2026-05-08 charge 9996 Spa Package Profit 148.86 guest #8777 13325 opera:ft:17362134
225373 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #8777 14475 opera:ft:17362132
225372 2026-05-08 payment 9006 American Express CARD -193.26 guest #8777 13325 opera:ft:17362129
225371 2026-05-08 credit 8105 Shopify Commission ALW -17.46 guest #8777 14475 opera:ft:17362128
225370 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #8777 14475 opera:ft:17362127
225369 2026-05-08 charge 7033 Spa Package SPA -9.06 guest #8777 14475 opera:ft:17362126
225368 2026-05-08 charge 9996 Spa Package Profit 86.83 guest #8692 13123 opera:ft:17362123
225367 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8692 14420 opera:ft:17362121
225366 2026-05-08 payment 9008 Visa CARD -54.31 guest #8692 13123 opera:ft:17362118
225365 2026-05-08 credit 8105 Shopify Commission ALW -8.73 guest #8692 14420 opera:ft:17362117
225364 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #8692 14420 opera:ft:17362116
225363 2026-05-08 charge 7033 Spa Package SPA -4.53 guest #8692 14420 opera:ft:17362115
225362 2026-05-08 charge 9996 Spa Package Profit 161.26 guest #8568 12810 opera:ft:17362112
225361 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #8568 14445 opera:ft:17362108
225360 2026-05-08 charge 9996 Spa Package Profit 86.83 guest #8681 13107 opera:ft:17362107
225359 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8681 14421 opera:ft:17362105
225358 2026-05-08 payment 9008 Visa CARD -77.58 guest #8681 13107 opera:ft:17362102
225357 2026-05-08 charge 7800 Programs Sales Tax -1.28 guest #8681 13107 opera:ft:17362101
225356 2026-05-08 charge 8096 No Show Class CLS -15.00 guest #8681 13107 opera:ft:17362100 spa
225355 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #8678 14464 opera:ft:17362099
225354 2026-05-08 payment 9006 American Express CARD -47.00 guest #8678 13102 opera:ft:17362098
225353 2026-05-08 charge 7161 Shopify - Day Pass Inclusion MSC -6.21 guest #8678 14464 opera:ft:17362097 not absorb
225352 2026-05-08 charge 7800 Programs Sales Tax -1.28 guest #8678 13102 opera:ft:17362096
225351 2026-05-08 charge 8096 No Show Class CLS -15.00 guest #8678 13102 opera:ft:17362095 spa
225350 2026-05-08 charge 9996 Spa Package Profit 86.83 guest #8470 12432 opera:ft:17362094
225349 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8470 14439 opera:ft:17362092
225348 2026-05-08 payment 9006 American Express CARD -64.93 guest #8470 12432 opera:ft:17362089
225347 2026-05-08 charge 7800 Programs Sales Tax -1.28 guest #8470 12432 opera:ft:17362088
225346 2026-05-08 charge 8096 No Show Class CLS -15.00 guest #8470 12432 opera:ft:17362087 spa
225345 2026-05-08 charge 9996 Spa Package Profit 43.41 guest #8616 12945 opera:ft:17362086
225344 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8616 14435 opera:ft:17362082
225343 2026-05-08 charge 9996 Spa Package Profit 86.83 guest #9084 14276 opera:ft:17362081
225342 2026-05-08 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9084 14447 opera:ft:17362079
225341 2026-05-08 credit 8105 Shopify Commission ALW -8.73 guest #9084 14447 opera:ft:17362078
225340 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #9084 14447 opera:ft:17362077
225339 2026-05-08 charge 7033 Spa Package SPA -4.53 guest #9084 14447 opera:ft:17362076
225338 2026-05-08 charge 2018 Alcohol Sales Tax 4.84 reservation #1960 3269 opera:ft:17362073
225337 2026-05-08 charge 3205 Terras Dinner Sales Tax 1.58 reservation #1960 3269 opera:ft:17362072
225336 2026-05-08 charge 2094 Terras Dinner Gratuity NRV 14.00 reservation #1960 3269 opera:ft:17362071
225335 2026-05-08 charge 2086 Terras Dinner Wine ALC 15.00 reservation #1960 3269 opera:ft:17362070
225334 2026-05-08 charge 2087 Terras Dinner Liquor ALC 37.00 reservation #1960 3269 opera:ft:17362069
225333 2026-05-08 charge 2084 Terras Dinner DNR 17.00 reservation #1960 3269 opera:ft:17362068
225332 2026-05-08 charge 3205 Terras Dinner Sales Tax 11.72 reservation #2790 4965 opera:ft:17362067
225331 2026-05-08 charge 1698 Terras Dinner Service Charge DNR 22.68 reservation #2790 4965 opera:ft:17362066
225330 2026-05-08 charge 2084 Terras Dinner DNR 126.00 reservation #2790 4965 opera:ft:17362065
225329 2026-05-08 charge 2018 Alcohol Sales Tax 1.40 reservation #2790 4965 opera:ft:17362064
225328 2026-05-08 charge 2094 Terras Dinner Gratuity NRV 3.00 reservation #2790 4965 opera:ft:17362063
225327 2026-05-08 charge 2086 Terras Dinner Wine ALC 15.00 reservation #2790 4965 opera:ft:17362062
225326 2026-05-08 charge 7515 Class Late Cancellation Fee CLS -30.00 guest #8568 14473 opera:ft:17362061 Guest said they switched classes
225325 2026-05-08 payment 9007 Master Card CARD -101.81 guest #8568 12810 opera:ft:17362059
225324 2026-05-08 charge 3205 Terras Dinner Sales Tax 14.04 reservation #4561 11939 opera:ft:17362058
225323 2026-05-08 charge 1698 Terras Dinner Service Charge DNR 27.18 reservation #4561 11939 opera:ft:17362057
225322 2026-05-08 charge 2084 Terras Dinner DNR 151.00 reservation #4561 11939 opera:ft:17362056
225321 2026-05-08 charge 2018 Alcohol Sales Tax 4.93 reservation #4458 11431 opera:ft:17362055
225320 2026-05-08 charge 3205 Terras Dinner Sales Tax 14.60 reservation #4458 11431 opera:ft:17362054
225319 2026-05-08 charge 2094 Terras Dinner Gratuity NRV 40.47 reservation #4458 11431 opera:ft:17362053
225318 2026-05-08 charge 2087 Terras Dinner Liquor ALC 53.00 reservation #4458 11431 opera:ft:17362052
225317 2026-05-08 charge 2084 Terras Dinner DNR 157.00 reservation #4458 11431 opera:ft:17362051
225316 2026-05-08 charge 7800 Programs Sales Tax -2.55 guest #8568 14473 opera:ft:17362050
Sum (balance): 1,218.24