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.

Jump To Module

Backend Home Change Log Backup First

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

Customer Totals Daily Customer Totals

Payments

Add New Record

order_id

bigint(20) unsigned Â· required

payment_date

datetime Â· nullable

payment_type

varchar(100) Â· nullable

payment_method

varchar(100) Â· nullable

amount

decimal(10,2) Â· required

notes

text Â· nullable

legacy_payment_id

bigint(20) Â· nullable

source_payment_key

varchar(255) Â· nullable

idempotency_key

varchar(120) Â· nullable

square_payment_id

varchar(120) Â· nullable

created_at

datetime Â· required

Find Records

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

Results

Payments Rows

Action	payment_id	order_id	payment_date	payment_type	payment_method	amount	idempotency_key
Delete Edit	65191	106908	2026-07-20 00:00:00	Full Payment	Square	85.60	sq-term-1IHGNbGyLNEnDWCE
Delete Edit	65189	106907	2026-07-20 00:00:00	Tip	Square	14.44	sq-term-DZAGk3xxP39dZVCE-tip
Delete Edit	65188	106907	2026-07-20 00:00:00	Full Payment	Square	96.30	sq-term-DZAGk3xxP39dZVCE
Delete Edit	65187	106800	2026-07-20 00:00:00	Full Payment	Square	254.75	sq-term-7v35bju193siNXCE
Delete Edit	65186	106800	2026-07-20 00:00:00	Deposit	Square	200.00	sq-term-VSgUpNnyyiRsAZCE
Delete Edit	65184	106904	2026-07-20 00:00:00	Full Payment	Square	37.45	sq-term-lYPAbz07W0hbNZCE
Delete Edit	65182	106903	2026-07-20 00:00:00	Full Payment	Square	72.76	sq-term-9eGbOlAefNiEnVCE
Delete Edit	65181	106902	2026-07-20 00:00:00	Tip	Square	23.12	sq-term-9gBEW6iHo5kU0WCE-tip
Delete Edit	65180	106902	2026-07-20 00:00:00	Full Payment	Square	154.10	sq-term-9gBEW6iHo5kU0WCE
Delete Edit	65179	106901	2026-07-20 00:00:00	Tip	Cash	0.90	manual-129765-1784556997434-60845-tip-auto
Delete Edit	65178	106901	2026-07-20 00:00:00	Full Payment	Cash	32.10	manual-129765-1784556997434-35977-s1
Delete Edit	65177	106899	2026-07-20 00:00:00	Deposit	Square	90.00	sq-term-9OKFqspq1qT5yYCE
Delete Edit	65176	106872	2026-07-19 00:00:00	Tip		0.10	manual-129736-1784491761884-15082-tip-auto
Delete Edit	65175	106872	2026-07-19 00:00:00	Full Payment		74.90	manual-129736-1784491761884-10442-s1
Delete Edit	65174	106886	2026-07-19 00:00:00	Deposit	Square	100.00	sq-term-VyYMlSXSb690ZXCE
Delete Edit	65173	106842	2026-07-19 00:00:00	Tip	Square	4.00	sq-term-BGdTZJTliH0MWXCE-tip
Delete Edit	65172	106842	2026-07-19 00:00:00	Full Payment	Square	77.66	sq-term-BGdTZJTliH0MWXCE
Delete Edit	65171	106883	2026-07-19 00:00:00	Full Payment	Square	74.90	sq-term-RQGvP2lIZTHZFXCE
Delete Edit	65170	106894	2026-07-19 00:00:00	Tip	Square	16.05	sq-term-TFas3OYImgPOnYCE-tip
Delete Edit	65169	106894	2026-07-19 00:00:00	Full Payment	Square	107.00	sq-term-TFas3OYImgPOnYCE
Delete Edit	65168	106882	2026-07-19 00:00:00	Tip	Square	15.00	sq-term-lotXLCJPnSSxdYCE-tip
Delete Edit	65167	106882	2026-07-19 00:00:00	Full Payment	Square	100.00	sq-term-lotXLCJPnSSxdYCE
Delete Edit	65166	106881	2026-07-19 00:00:00	Tip	Square	10.43	sq-term-BC3d77VOVCCNQWCE-tip
Delete Edit	65165	106881	2026-07-19 00:00:00	Full Payment	Square	69.55	sq-term-BC3d77VOVCCNQWCE
Delete Edit	65164	106889	2026-07-19 00:00:00	Tip	Square	9.63	sq-term-Xx1jr9RUzuuUmZCE-tip
Delete Edit	65163	106889	2026-07-19 00:00:00	Full Payment	Square	64.20	sq-term-Xx1jr9RUzuuUmZCE
Delete Edit	65162	106877	2026-07-18 00:00:00	Full Payment	Square	100.00	sq-term-HprMybw22JN5fUCE
Delete Edit	65161	106876	2026-07-18 00:00:00	Tip	Square	4.82	sq-term-b3rp3stCPqsbyYCE-tip
Delete Edit	65160	106876	2026-07-18 00:00:00	Full Payment	Square	32.10	sq-term-b3rp3stCPqsbyYCE
Delete Edit	65156	106869	2026-06-28 00:00:00	Deposit	Cash	50.00	manual-129733-1782678898185-96232-dep1
Delete Edit	65155	106859	2026-06-28 00:00:00	Tip	Cash	11.85	manual-129723-1782672994568-15997-tip-auto
Delete Edit	65154	106859	2026-06-28 00:00:00	Full Payment	Cash	48.15	manual-129723-1782672994568-57479-s1
Delete Edit	65153	106871	2026-06-28 00:00:00	Tip		1.85	manual-129735-1782666233611-12081-tip-auto
Delete Edit	65152	106871	2026-06-28 00:00:00	Full Payment		48.15	manual-129735-1782666233611-6135-s1
Delete Edit	65151	106727	2026-06-28 00:00:00	Tip	Cash	0.80	manual-129591-1782662519161-59524-tip-auto
Delete Edit	65150	106727	2026-06-28 00:00:00	Balance	Cash	34.20	manual-129591-1782662519161-19817-s1
Delete Edit	65149	106852	2026-06-28 00:00:00	Full Payment	Square	73.05	sq-term-jfP4KSkN8cHtyXCE
Delete Edit	65148	106815	2026-06-28 00:00:00	Tip	Cash	3.45	manual-129679-1782657636508-87290-tip-auto
Delete Edit	65147	106815	2026-06-28 00:00:00	Full Payment	Cash	176.55	manual-129679-1782657636508-29764-s1
Delete Edit	65145	106868	2026-06-27 00:00:00	Full Payment	Square	187.25	sq-term-Ptb6lNzEEIkH8VCE
Delete Edit	65144	106867	2026-06-27 00:00:00	Tip	Square	18.19	sq-term-j1YZ1nGx5opbEXCE-tip
Delete Edit	65143	106867	2026-06-27 00:00:00	Full Payment	Square	90.95	sq-term-j1YZ1nGx5opbEXCE
Delete Edit	65142	106866	2026-06-27 00:00:00	Deposit	Square	100.00	sq-term-VqQke2CYj02yRWCE
Delete Edit	65141	106864	2026-06-27 00:00:00	Deposit	Square	100.00	sq-term-bNYUyLl0MCLHqWCE
Delete Edit	65138	106817	2026-06-27 00:00:00	Tip	Square	5.00	sq-term-PvGp8EYZkaFM7VCE-tip
Delete Edit	65137	106817	2026-06-27 00:00:00	Full Payment	Square	58.85	sq-term-PvGp8EYZkaFM7VCE
Delete Edit	65136	106826	2026-06-27 00:00:00	Tip	Square	6.00	manual-129690-1782571052251-13481-tip-auto
Delete Edit	65135	106826	2026-06-27 00:00:00	Full Payment	Square	63.55	manual-129690-1782571052251-52913-s1
Delete Edit	65134	106826	2026-06-27 00:00:00	Full Payment	Square	69.55	sq-term-bLBjDhXtPgyzpVCE
Delete Edit	65133	106862	2026-06-27 00:00:00	Tip	Square	8.83	sq-term-FmuusUjzE0qVZUCE-tip
Delete Edit	65132	106862	2026-06-27 00:00:00	Full Payment	Square	58.85	sq-term-FmuusUjzE0qVZUCE
Delete Edit	65131	106860	2026-06-26 00:00:00	Deposit	Square	100.00	sq-term-V4tFpEHe3yMQGYCE
Delete Edit	65130	106850	2026-06-22 00:00:00	Full Payment	Square	133.75	sq-term-7sK5VpsHWGoqO
Delete Edit	65129	106849	2026-06-22 00:00:00	Deposit	Square	60.00	sq-term-XmopOxbRIOiqO
Delete Edit	65128	106848	2026-06-22 00:00:00	Full Payment	Cash	42.80	manual-129712-1782153009029-39563-s1
Delete Edit	65126	106844	2026-06-22 00:00:00	Full Payment	Square	94.90	sq-term-VL9qLR5zAdVqO
Delete Edit	65125	106852	2026-06-22 00:00:00	Deposit	Square	70.00	sq-term-Ilv0DzzcvceqO
Delete Edit	65124	106790	2026-06-22 00:00:00	Tip	Square	10.00	sq-term-cKGrSaeuUNqqO-tip
Delete Edit	65123	106790	2026-06-22 00:00:00	Full Payment	Square	174.70	sq-term-cKGrSaeuUNqqO
Delete Edit	65122	106824	2026-06-22 00:00:00	Tip	Cash	0.04	manual-129688-1782133067887-54244-tip-auto
Delete Edit	65121	106824	2026-06-22 00:00:00	Full Payment	Cash	29.96	manual-129688-1782133067886-39672-s1
Delete Edit	65118	106770	2026-06-21 00:00:00	Balance		78.40	manual-129634-1782075248873-95175-s1
Delete Edit	65117	106753	2026-06-21 00:00:00	Full Payment	Square	292.11	sq-term-ayhi2Fyd5IcqO
Delete Edit	65116	106842	2026-06-21 00:00:00	Deposit	Square	70.00	sq-term-c1DI09XhpibqO
Delete Edit	65115	106841	2026-06-21 00:00:00	Full Payment	Square	26.75	sq-term-zvCLuLwZDjjqO
Delete Edit	65114	106823	2026-06-21 00:00:00	Full Payment	Square	294.25	sq-term-cD1sB2UHABoqO
Delete Edit	65113	106769	2026-06-21 00:00:00	Full Payment	Square	131.90	sq-term-gAdnH8pIsecqO
Delete Edit	65112	106845	2026-06-21 00:00:00	Full Payment	Square	77.04	sq-term-yuX4V86srNnqO
Delete Edit	65111	106835	2026-06-20 00:00:00	Full Payment		171.20	manual-129699-1781988021280-72898-s1
Delete Edit	65110	106839	2026-06-20 00:00:00	Full Payment		62.80	manual-129703-1781983725956-46874-s1
Delete Edit	65109	106840	2026-06-20 00:00:00	Tip	Square	25.00	sq-term-NAyVAbp6FhXqO-tip
Delete Edit	65108	106840	2026-06-20 00:00:00	Deposit	Square	100.00	sq-term-NAyVAbp6FhXqO
Delete Edit	65105	106833	2026-06-20 00:00:00	Full Payment	Square	69.55	sq-term-5bygWQxHgAgqO
Delete Edit	65104	106832	2026-06-20 00:00:00	Tip	Square	16.05	sq-term-Sp3TTs99JfbqO-tip
Delete Edit	65103	106832	2026-06-20 00:00:00	Full Payment	Square	64.20	sq-term-Sp3TTs99JfbqO