Database

Live Table Manager

Search, add, edit, and delete records in the live workflow tables, including the payment transaction ledger. Every save and delete is logged.

This is a direct live-data tool. Create a backup snapshot before deleting or doing broad edits.

Daily Customer Totals

Edit Record #4726

int(11) · nullable
datetime · required
decimal(10,2) · required
decimal(10,2) · required
decimal(10,2) · required
decimal(10,2) · required
decimal(10,2) · required
decimal(10,2) · required
decimal(10,2) · required
decimal(10,2) · required
varchar(100) · nullable
varchar(255) · nullable
varchar(50) · nullable
text · nullable
tinyint(1) · required
decimal(10,2) · required
decimal(10,2) · required
varchar(255) · nullable
varchar(100) · nullable
datetime · required
varchar(40) · nullable
decimal(10,2) · required
Cancel Edit

Search

Find Records

Showing up to 75 newest/matching records. Use table-specific pages for normal workflow edits when possible.

Results

Daily Customer Totals Rows

Action daily_customer_totals_idcustomer_namecustomer_datetotal_customersnew_customerscash_salescheck_salescredit_card_salesedwardstipstotal_salestotal_sales_no_edwards
Edit
6180 2026-05-09 00:00:00 8.00 6.00 10.70 0.00 565.85 0.00 0.00 576.55 576.55
Edit
6171 2026-05-01 00:00:00 10.00 4.00 60.15 67.41 401.40 0.00 23.72 552.68 552.68
Edit
6126 2026-04-18 00:00:00 15.00 4.00 187.25 0.00 653.15 0.00 86.49 926.89 926.89
Edit
6115 2026-05-03 00:00:00 11.00 8.00 0.00 0.00 256.80 0.00 13.91 270.71 270.71
Edit
6103 2026-04-25 00:00:00 9.00 6.00 0.00 0.00 747.65 0.00 92.72 840.37 840.37
Edit
6099 2026-05-08 00:00:00 9.00 8.00 100.00 0.00 506.62 0.00 56.44 663.06 663.06
Edit
6032 2026-04-27 00:00:00 7.00 6.00 0.00 0.00 123.05 150.00 0.00 273.05 123.05
Edit
6030 2026-03-20 00:00:00 12.00 1.00 80.00 0.00 1376.93 0.00 0.00 1456.93 1456.93
Edit
6018 2026-05-06 00:00:00 1.00 1.00 0.00 0.00 0.00 150.00 0.00 150.00 0.00
Edit
6016 2026-05-05 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
6014 2026-05-04 00:00:00 13.00 8.00 27.82 0.00 1246.84 0.00 88.81 1363.47 1363.47
Edit
6002 2026-04-13 00:00:00 10.00 3.00 32.06 0.00 475.92 0.00 41.42 770.69 770.69
Edit
5999 2026-04-24 00:00:00 6.00 1.00 0.00 0.00 850.45 0.00 36.11 886.56 886.56
Edit
5944 2026-02-23 00:00:00 14.00 0.00 0.00 0.00 1744.72 0.00 0.00 1744.72 1744.72
Edit
5942 2026-04-17 00:00:00 12.00 3.00 30.25 0.00 166.80 0.00 14.75 211.80 211.80
Edit
5893 2026-01-30 00:00:00 17.00 0.00 0.00 0.00 1208.13 0.00 0.00 1208.13 1208.13
Edit
5888 2026-05-02 00:00:00 7.00 3.00 0.00 0.00 335.65 0.00 21.11 356.76 356.76
Edit
5822 2026-04-05 00:00:00 38.00 11.00 200.00 0.00 1057.74 0.00 0.59 1258.33 1258.33
Edit
5813 2026-04-26 00:00:00 10.00 6.00 0.00 0.00 428.25 0.00 37.72 465.97 465.97
Edit
5811 2026-04-12 00:00:00 12.00 5.00 0.00 0.00 859.30 0.00 106.28 965.58 965.58
Edit
5809 2026-04-04 00:00:00 40.00 8.00 143.00 0.00 921.93 0.00 0.00 1064.93 1064.93
Edit
5797 2026-04-11 00:00:00 15.00 6.00 140.00 0.00 503.60 0.00 12.84 656.44 656.44
Edit
5791 2026-04-03 00:00:00 41.00 9.00 385.80 0.00 2985.54 0.00 0.00 3371.34 3371.34
Edit
5637 2026-03-23 00:00:00 45.00 7.00 40.00 0.00 788.43 0.00 90.95 919.38 919.38
Edit
5561 2026-03-28 00:00:00 34.00 11.00 0.00 0.00 1045.07 0.00 109.92 1154.99 1154.99
Edit
5557 2026-03-21 00:00:00 29.00 9.00 150.00 0.00 3173.32 0.00 235.40 3558.72 3558.72
Edit
5542 2026-04-10 00:00:00 11.00 7.00 204.00 0.00 791.05 0.00 0.00 995.05 995.05
Edit
5517 Spreadsheet Import 2026-04-23 00:00:00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
5516 Spreadsheet Import 2026-04-22 00:00:00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
5515 Spreadsheet Import 2026-04-21 00:00:00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
5514 Spreadsheet Import 2026-04-20 00:00:00 9.00 4.00 403.00 0.00 490.25 0.00 0.00 893.25 893.25
Edit
5513 Spreadsheet Import 2026-04-19 00:00:00 18.00 8.00 56.00 23.54 158.49 0.00 0.00 238.03 238.03
Edit
5510 Spreadsheet Import 2026-04-16 00:00:00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
5509 Spreadsheet Import 2026-04-15 00:00:00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
5508 Spreadsheet Import 2026-04-14 00:00:00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
5503 Spreadsheet Import 2026-04-09 00:00:00 1.00 1.00 0.00 0.00 18.88 150.00 0.00 168.88 18.88
Edit
5502 Spreadsheet Import 2026-04-08 00:00:00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
5501 Spreadsheet Import 2026-04-07 00:00:00 1.00 1.00 0.00 0.00 2.27 0.00 0.00 2.27 2.27
Edit
5500 Spreadsheet Import 2026-04-06 00:00:00 9.00 5.00 85.00 0.00 530.18 0.00 0.00 615.18 615.18
Edit
5496 Spreadsheet Import 2026-04-02 00:00:00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
5296 2026-03-29 00:00:00 40.00 0.00 0.00 0.00 377.17 0.00 0.00 377.17 377.17
Edit
5292 2026-02-16 00:00:00 14.00 0.00 0.00 0.00 944.25 0.00 0.00 944.25 944.25
Edit
4990 Daily Total 2026-02-20 00:00:00 14.00 3.00 150.00 0.00 1149.17 100.00 0.00 1399.17 1299.17
Edit
4986 Daily Total 2026-01-31 00:00:00 28.00 8.00 200.00 0.00 3169.77 0.00 0.00 3369.77 3369.77
Edit
4798 Daily Total 2026-03-30 00:00:00 44.00 5.00 0.00 0.00 859.54 0.00 80.25 859.54 859.54
Edit
4774 Daily Total 2026-03-08 00:00:00 29.00 4.00 20.00 24.00 1350.47 0.00 0.00 1394.47 1394.47
Edit
4772 Daily Total 2026-03-07 00:00:00 30.00 8.00 70.00 0.00 2019.02 0.00 0.00 2089.02 2089.02
Edit
4771 Daily Total 2026-03-02 00:00:00 26.00 6.00 50.00 0.00 1957.65 0.00 0.00 2007.65 2007.65
Edit
4769 Daily Total 2026-03-01 00:00:00 31.00 7.00 20.00 0.00 1712.05 0.00 0.00 1732.05 1732.05
Edit
4768 Daily Total 2026-02-28 00:00:00 28.00 7.00 0.00 107.00 5189.26 0.00 0.00 5296.26 5296.26
Edit
4767 Daily Total 2026-02-27 00:00:00 28.00 10.00 0.00 0.00 1442.20 0.00 0.00 1442.20 1442.20
Edit
4764 Daily Total 2026-02-22 00:00:00 30.00 10.00 0.00 0.00 2345.25 0.00 0.00 2345.25 2345.25
Edit
4763 Daily Total 2026-02-21 00:00:00 29.00 10.00 0.00 0.00 3091.95 0.00 0.00 3091.95 3091.95
Edit
4761 Daily Total 2026-02-13 00:00:00 26.00 9.00 20.00 0.00 749.03 200.00 0.00 969.03 769.03
Edit
4757 Daily Total 2026-02-08 00:00:00 37.00 8.00 90.00 0.00 2026.95 0.00 0.00 2116.95 2116.95
Edit
4756 Daily Total 2026-02-06 00:00:00 16.00 2.00 60.00 0.00 562.40 0.00 0.00 622.40 622.40
Edit
4755 Daily Total 2026-02-02 00:00:00 30.00 4.00 15.00 0.00 2111.11 0.00 0.00 2126.11 2126.11
Edit
4754 Daily Total 2026-02-01 00:00:00 39.00 11.00 188.00 0.00 2035.61 0.00 0.00 2223.61 2223.61
Edit
4746 Daily Total 2026-01-25 00:00:00 30.00 11.00 0.00 0.00 1876.49 0.00 0.00 1876.49 1876.49
Edit
4742 Daily Total 2026-02-12 00:00:00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
4741 Daily Total 2026-02-09 00:00:00 31.00 7.00 79.78 0.00 1656.36 0.00 0.00 1736.14 1736.14
Edit
4739 Daily Total 2026-01-24 00:00:00 26.00 5.00 100.00 0.00 1093.77 0.00 0.00 1193.77 1193.77
Edit
4737 Daily Total 2026-01-23 00:00:00 31.00 6.00 461.25 0.00 1148.39 0.00 0.00 1609.64 1609.64
Edit
4735 Daily Total 2026-01-18 00:00:00 32.00 6.00 100.00 0.00 1626.74 0.00 0.00 1726.74 1726.74
Edit
4732 Daily Total 2026-01-17 00:00:00 30.00 4.00 218.00 0.00 1930.82 0.00 0.00 2148.82 2148.82
Edit
4731 Daily Total 2026-01-16 00:00:00 33.00 7.00 21.00 0.00 2305.87 0.00 0.00 2326.87 2326.87
Edit
4730 Daily Total 2026-01-11 00:00:00 35.00 10.00 91.00 0.00 1195.84 0.00 0.00 1286.84 1286.84
Edit
4726 Daily Total 2026-01-10 00:00:00 31.00 7.00 220.00 0.00 1870.80 0.00 0.00 2090.80 2090.80
Edit
4724 Daily Total 2026-01-09 00:00:00 21.00 9.00 123.00 0.00 888.16 0.00 0.00 1011.16 1011.16
Edit
4723 Daily Total 2026-01-05 00:00:00 33.00 6.00 36.00 0.00 3689.15 0.00 0.00 3725.15 3725.15
Edit
4719 Daily Total 2026-01-04 00:00:00 19.00 2.00 60.00 0.00 1524.45 0.00 0.00 1584.45 1584.45
Edit
4717 Daily Total 2026-01-03 00:00:00 23.00 4.00 242.00 0.00 1846.62 0.00 0.00 2088.62 2088.62
Edit
4716 Daily Total 2026-01-02 00:00:00 22.00 7.00 120.00 0.00 1111.97 0.00 0.00 1231.97 1231.97
Edit
4715 Daily Total 2025-12-28 00:00:00 18.00 6.00 0.00 0.00 1980.60 0.00 0.00 1980.60 1980.60
Edit
4542 Daily Total 2026-03-27 00:00:00 21.00 9.00 0.00 0.00 710.24 0.00 0.00 710.24 710.24