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 #7781

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
8379 2026-07-01 00:00:00 1.00 1.00 0.00 0.00 0.00 100.00 0.00 100.00 0.00
Edit
8376 2026-06-28 00:00:00 7.00 3.00 308.90 0.00 121.20 0.00 17.95 448.05 448.05
Edit
8366 2026-06-26 00:00:00 4.00 2.00 0.00 0.00 100.00 0.00 0.00 100.00 100.00
Edit
8363 2026-06-27 00:00:00 9.00 6.00 0.00 0.00 729.00 0.00 38.02 767.02 767.02
Edit
8361 2026-06-24 00:00:00 1.00 1.00 0.00 0.00 0.00 100.00 0.00 100.00 0.00
Edit
8360 2026-06-22 00:00:00 12.00 10.00 72.76 0.00 463.35 0.00 10.04 546.15 546.15
Edit
8359 2026-06-21 00:00:00 11.00 4.00 0.00 0.00 970.45 0.00 0.00 970.45 970.45
Edit
8358 2026-06-20 00:00:00 13.00 8.00 0.00 0.00 1509.60 0.00 73.12 1582.72 1582.72
Edit
8357 2026-06-19 00:00:00 10.00 4.00 0.00 0.00 787.74 100.00 50.40 938.14 838.14
Edit
8356 2026-06-15 00:00:00 10.00 4.00 0.00 0.00 540.19 0.00 45.74 585.93 585.93
Edit
8355 2026-06-14 00:00:00 10.00 6.00 0.00 0.00 618.34 0.00 98.09 716.43 716.43
Edit
8354 2026-06-13 00:00:00 6.00 5.00 0.00 0.00 638.15 0.00 66.05 704.20 704.20
Edit
8353 2026-06-12 00:00:00 8.00 5.00 346.40 0.00 226.35 0.00 8.82 581.57 581.57
Edit
8352 2026-06-10 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
8351 2026-06-08 00:00:00 6.00 2.00 0.00 0.00 422.65 0.00 24.08 446.73 446.73
Edit
8350 2026-06-07 00:00:00 8.00 5.00 345.50 0.00 745.30 0.00 101.10 1191.90 1191.90
Edit
8349 2026-06-06 00:00:00 9.00 4.00 0.00 0.00 781.70 0.00 68.22 849.92 849.92
Edit
8348 2026-06-05 00:00:00 7.00 3.00 150.00 184.04 95.23 0.00 7.28 436.55 436.55
Edit
8347 2026-06-04 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
8346 2026-06-03 00:00:00 1.00 0.00 0.00 0.00 0.00 150.00 0.00 150.00 0.00
Edit
8345 2026-06-02 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
8344 2026-06-01 00:00:00 8.00 4.00 117.70 64.20 58.15 0.00 2.30 242.35 242.35
Edit
8222 2026-05-24 00:00:00 6.00 1.00 0.00 0.00 463.21 0.00 67.50 530.71 530.71
Edit
8131 2026-05-31 00:00:00 3.00 0.00 0.00 0.00 213.55 0.00 22.12 235.67 235.67
Edit
8088 2026-05-09 00:00:00 4.00 1.00 10.70 0.00 117.70 0.00 0.00 128.40 128.40
Edit
8079 2026-05-29 00:00:00 5.00 2.00 0.00 0.00 748.28 0.00 37.86 786.14 786.14
Edit
8040 2026-05-18 00:00:00 6.00 5.00 406.60 0.00 909.50 150.00 174.60 1640.70 1490.70
Edit
8035 2026-05-25 00:00:00 5.00 4.00 0.00 0.00 427.75 0.00 59.40 487.15 487.15
Edit
8017 2026-05-16 00:00:00 6.00 1.00 0.00 0.00 551.30 0.00 10.00 561.30 561.30
Edit
8001 2026-05-30 00:00:00 5.00 3.00 0.00 0.00 162.63 0.00 0.76 163.39 163.39
Edit
7997 2026-05-22 00:00:00 7.00 3.00 153.70 0.00 42.80 0.00 0.30 196.80 196.80
Edit
7995 2026-05-02 00:00:00 9.00 4.00 0.00 0.00 215.65 0.00 21.11 236.76 236.76
Edit
7980 2026-04-11 00:00:00 14.00 6.00 140.00 0.00 289.60 0.00 12.84 442.44 442.44
Edit
7919 2026-05-17 00:00:00 7.00 2.00 0.00 0.00 686.60 0.00 38.02 724.62 724.62
Edit
7910 2026-05-04 00:00:00 10.00 4.00 27.82 0.00 1123.30 0.00 88.81 1239.93 1239.93
Edit
7871 2026-02-07 00:00:00 32.00 7.00 235.00 0.00 2486.09 0.00 0.00 2721.09 2721.09
Edit
7811 2026-05-23 00:00:00 10.00 3.00 21.40 74.90 816.05 0.00 641.41 1553.76 1553.76
Edit
7806 2026-05-15 00:00:00 10.00 5.00 32.10 0.00 374.50 0.00 42.19 448.79 448.79
Edit
7805 2026-05-14 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
7804 2026-05-12 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
7803 2026-05-11 00:00:00 8.00 1.00 232.10 0.00 429.20 0.00 29.79 691.09 691.09
Edit
7802 2026-05-10 00:00:00 2.00 1.00 0.00 0.00 137.45 0.00 0.00 137.45 137.45
Edit
7800 2026-05-08 00:00:00 8.00 5.00 0.00 0.00 506.62 0.00 56.44 563.06 563.06
Edit
7799 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
7798 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
7796 2026-05-03 00:00:00 8.00 1.00 0.00 0.00 256.80 0.00 13.91 270.71 270.71
Edit
7794 2026-05-01 00:00:00 9.00 1.00 60.15 67.41 326.50 0.00 5.00 459.06 459.06
Edit
7793 2026-04-29 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
7792 2026-04-27 00:00:00 5.00 2.00 0.00 0.00 123.05 0.00 0.00 123.05 123.05
Edit
7791 2026-04-26 00:00:00 8.00 4.00 0.00 0.00 219.60 0.00 6.42 226.02 226.02
Edit
7790 2026-04-25 00:00:00 6.00 0.00 0.00 0.00 422.65 0.00 60.72 483.37 483.37
Edit
7789 2026-04-24 00:00:00 6.00 0.00 0.00 0.00 850.45 0.00 36.11 886.56 886.56
Edit
7788 2026-04-23 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
7787 2026-04-22 00:00:00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
7786 2026-04-20 00:00:00 8.00 0.00 573.00 0.00 436.56 0.00 73.79 1083.35 1083.35
Edit
7785 2026-04-19 00:00:00 9.00 2.00 56.00 23.54 133.88 0.00 43.27 256.69 256.69
Edit
7784 2026-04-18 00:00:00 15.00 5.00 187.25 0.00 753.15 0.00 86.49 1026.89 1026.89
Edit
7783 2026-04-17 00:00:00 11.00 2.00 30.25 0.00 166.80 0.00 14.75 211.80 211.80
Edit
7782 2026-04-14 00:00:00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
7781 2026-04-13 00:00:00 9.00 2.00 32.06 0.00 388.67 0.00 41.42 462.15 462.15
Edit
7780 2026-04-12 00:00:00 12.00 5.00 0.00 0.00 859.30 0.00 106.28 1025.58 1025.58
Edit
7778 2026-04-10 00:00:00 20.00 2.00 99.80 0.00 625.75 0.00 140.31 865.86 865.86
Edit
7777 2026-04-09 00:00:00 5.00 4.00 0.00 0.00 15.68 0.00 0.55 16.23 16.23
Edit
7776 2026-04-08 00:00:00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Edit
7775 2026-04-07 00:00:00 8.00 6.00 132.68 0.00 2.27 0.00 0.59 135.54 135.54
Edit
7774 2026-04-06 00:00:00 37.00 4.00 85.00 0.00 288.55 0.00 224.35 597.90 597.90
Edit
7773 2026-04-05 00:00:00 24.00 5.00 0.00 0.00 282.55 0.00 0.00 282.55 282.55
Edit
7772 2026-04-04 00:00:00 26.00 2.00 0.00 0.00 251.25 0.00 0.00 251.25 251.25
Edit
7771 2026-04-03 00:00:00 27.00 4.00 142.80 0.00 148.74 0.00 0.00 291.54 291.54
Edit
7233 2026-03-20 00:00:00 11.00 0.00 80.00 0.00 1296.93 0.00 0.00 1376.93 1376.93
Edit
6519 2026-02-20 00:00:00 13.00 3.00 150.00 0.00 999.17 100.00 0.00 1249.17 1149.17
Edit
6514 2026-01-02 00:00:00 21.00 7.00 120.00 0.00 1053.12 0.00 0.00 1173.12 1173.12
Edit
6184 2026-02-22 00:00:00 29.00 10.00 0.00 0.00 2345.25 0.00 0.00 2345.25 2345.25
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
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