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

Payment Transactions Ledger

Edit Record #10057

payment_id

bigint(20) unsigned Â· nullable

order_id

bigint(20) unsigned Â· nullable

visit_id

int(10) unsigned Â· nullable

customer_id

int(10) unsigned Â· nullable

customer_name

varchar(255) Â· nullable

transaction_date

datetime Â· required

payment_method

varchar(80) Â· nullable

payment_type

varchar(80) Â· nullable

bucket

varchar(20) Â· required

amount

decimal(12,2) Â· required

tip_amount

decimal(12,2) Â· required

is_new_customer

tinyint(1) Â· required

source

varchar(40) Â· required

created_at

datetime Â· required

updated_at

datetime Â· required

external_payment_id

varchar(120) Â· nullable

Cancel Edit

Find Records

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

Results

Payment Transactions Ledger Rows

Action	customer_payment_transaction_id	payment_id	order_id	visit_id	customer_id	customer_name	transaction_date	payment_method	payment_type	bucket
Delete Edit	10088	65191	106908	129775	3466	Brant Wenger	2026-07-20 00:00:00	Square	Full Payment	credit
Delete Edit	10086	65189	106907	129771	495422	Sally Barber	2026-07-20 00:00:00	Square	Tip	tip
Delete Edit	10085	65188	106907	129771	495422	Sally Barber	2026-07-20 00:00:00	Square	Full Payment	credit
Delete Edit	10083	65187	106800	129664	495372	Florine Bostick	2026-07-20 00:00:00	Square	Full Payment	credit
Delete Edit	10082	65186	106800	129664	495372	Florine Bostick	2026-07-20 00:00:00	Square	Deposit	credit
Delete Edit	10080	65184	106904	129768	495287	Lora L Darby	2026-07-20 00:00:00	Square	Full Payment	credit
Delete Edit	10079	65182	106903	129767	495421	Juliet Colson	2026-07-20 00:00:00	Square	Full Payment	credit
Delete Edit	10077	65181	106902	129766	495420	Heather Graham	2026-07-20 00:00:00	Square	Tip	tip
Delete Edit	10076	65180	106902	129766	495420	Heather Graham	2026-07-20 00:00:00	Square	Full Payment	credit
Delete Edit	10075	65177	106899	129763	495418	Tanner Hayes	2026-07-20 00:00:00	Square	Deposit	credit
Delete Edit	10074	65174	106886	129750	489014	Marichely Cordero	2026-07-19 00:00:00	Square	Deposit	credit
Delete Edit	10073	65173	106842	129706	3140	Berkley Lunt	2026-07-19 00:00:00	Square	Tip	tip
Delete Edit	10072	65172	106842	129706	3140	Berkley Lunt	2026-07-19 00:00:00	Square	Full Payment	credit
Delete Edit	10071	65116	106842	129706	3140	Berkley Lunt	2026-06-21 00:00:00	Square	Deposit	credit
Delete Edit	10070	65171	106883	129747	495413	Krishina Worrell	2026-07-19 00:00:00	Square	Full Payment	credit
Delete Edit	10068	65170	106894	129758	495417	Ashley Hopkins	2026-07-19 00:00:00	Square	Tip	tip
Delete Edit	10067	65169	106894	129758	495417	Ashley Hopkins	2026-07-19 00:00:00	Square	Full Payment	credit
Delete Edit	10065	65168	106882	129746	495412	Crystal Ferguson	2026-07-19 00:00:00	Square	Tip	tip
Delete Edit	10064	65167	106882	129746	495412	Crystal Ferguson	2026-07-19 00:00:00	Square	Full Payment	credit
Delete Edit	10062	65166	106881	129745	495411	Jaymie Travis	2026-07-19 00:00:00	Square	Tip	tip
Delete Edit	10061	65165	106881	129745	495411	Jaymie Travis	2026-07-19 00:00:00	Square	Full Payment	credit
Delete Edit	10059	65164	106889	129753	2709	Kourtney Cheatum	2026-07-19 00:00:00	Square	Tip	tip
Delete Edit	10058	65163	106889	129753	2709	Kourtney Cheatum	2026-07-19 00:00:00	Square	Full Payment	credit
Delete Edit	10057	65162	106877	129741	495409	Madison Little	2026-07-18 00:00:00	Square	Full Payment	credit
Delete Edit	10055	65161	106876	129740	495408	Gregory Frankson	2026-07-18 00:00:00	Square	Tip	tip
Delete Edit	10054	65160	106876	129740	495408	Gregory Frankson	2026-07-18 00:00:00	Square	Full Payment	credit
Delete Edit	10049	65149	106852	129716	495391	Edmund Marotta	2026-06-28 00:00:00	Square	Full Payment	credit
Delete Edit	10048	65125	106852	129716	495391	Edmund Marotta	2026-06-22 00:00:00	Square	Deposit	credit
Delete Edit	10047	65145	106868	129732	495403	Krissy Hem	2026-06-27 00:00:00	Square	Full Payment	credit
Delete Edit	10045	65144	106867	129731	495402	Ginger Holman	2026-06-27 00:00:00	Square	Tip	tip
Delete Edit	10044	65143	106867	129731	495402	Ginger Holman	2026-06-27 00:00:00	Square	Full Payment	credit
Delete Edit	10043	65142	106866	129730	495401	Kayla Weaver	2026-06-27 00:00:00	Square	Deposit	credit
Delete Edit	10042	65141	106864	129728	495400	Monica Ross	2026-06-27 00:00:00	Square	Deposit	credit
Delete Edit	10038	65138	106817	129681	2160	Haley Wysenski	2026-06-27 00:00:00	Square	Tip	tip
Delete Edit	10037	65137	106817	129681	2160	Haley Wysenski	2026-06-27 00:00:00	Square	Full Payment	credit
Delete Edit	10036	65134	106826	129690	495345	Lisa Voyles	2026-06-27 00:00:00	Square	Full Payment	credit
Delete Edit	10034	65133	106862	129726	495398	Arlene Nanan	2026-06-27 00:00:00	Square	Tip	tip
Delete Edit	10033	65132	106862	129726	495398	Arlene Nanan	2026-06-27 00:00:00	Square	Full Payment	credit
Delete Edit	10032	65131	106860	129724	495396	Kariann Adams	2026-06-26 00:00:00	Square	Deposit	credit
Delete Edit	10031	65130	106850	129714	495390	Kelly King Bray	2026-06-22 00:00:00	Square	Full Payment	credit
Delete Edit	10030	65129	106849	129713	495389	Brianna Hamlett	2026-06-22 00:00:00	Square	Deposit	credit
Delete Edit	10028	65041	106794	129658	1252	Jade Dang	2026-06-08 00:00:00	Square	Tip	tip
Delete Edit	10027	65040	106794	129658	1252	Jade Dang	2026-06-08 00:00:00	Square	Full Payment	credit
Delete Edit	10026	65126	106844	129708	3468	Morgan Spiro	2026-06-22 00:00:00	Square	Full Payment	credit
Delete Edit	10024	65124	106790	129654	495367	Stephanie McGovern	2026-06-22 00:00:00	Square	Tip	tip
Delete Edit	10023	65123	106790	129654	495367	Stephanie McGovern	2026-06-22 00:00:00	Square	Full Payment	credit
Delete Edit	10022	65033	106790	129654	495367	Stephanie McGovern	2026-06-08 00:00:00	Square	Full Payment	credit
Delete Edit	10020	65117	106753	129617	2082	Eternity Rodriguez	2026-06-21 00:00:00	Square	Full Payment	credit
Delete Edit	10018	65115	106841	129705	495387	Kala Grant	2026-06-21 00:00:00	Square	Full Payment	credit
Delete Edit	10017	65114	106823	129687	2185	Jerry Anderson	2026-06-21 00:00:00	Square	Full Payment	credit
Delete Edit	10016	65113	106769	129633	495357	Crystal Wormsley	2026-06-21 00:00:00	Square	Full Payment	credit
Delete Edit	10015	65112	106845	129709	3388	Keyla Jimenez	2026-06-21 00:00:00	Square	Full Payment	credit
Delete Edit	10014	65109	106840	129704	495384	Mallory Delay	2026-06-20 00:00:00	Square	Tip	tip
Delete Edit	10013	65108	106840	129704	495384	Mallory Delay	2026-06-20 00:00:00	Square	Deposit	credit
Delete Edit	10011	65105	106833	129697	2592	Melanie Demid	2026-06-20 00:00:00	Square	Full Payment	credit
Delete Edit	10009	65104	106832	129696	495383	Lisandra Perez	2026-06-20 00:00:00	Square	Tip	tip
Delete Edit	10008	65103	106832	129696	495383	Lisandra Perez	2026-06-20 00:00:00	Square	Full Payment	credit
Delete Edit	10006	65102	106831	129695	495382	Mahi Patel	2026-06-20 00:00:00	Square	Tip	tip
Delete Edit	10005	65101	106831	129695	495382	Mahi Patel	2026-06-20 00:00:00	Square	Full Payment	credit
Delete Edit	10004	65100	106805	129669	3466	Brant Wenger	2026-06-20 00:00:00	Square	Deposit	credit
Delete Edit	10003	65099	106795	129659	1850	Stephanie/Dante	2026-06-20 00:00:00	Square	Full Payment	credit
Delete Edit	10001	65098	106775	129639	495361	Marcos Anthony Ayende	2026-06-20 00:00:00	Square	Tip	tip
Delete Edit	10000	65097	106775	129639	495361	Marcos Anthony Ayende	2026-06-20 00:00:00	Square	Full Payment	credit
Delete Edit	9999	65096	106649	129513	495291	Liz Cochran	2026-06-20 00:00:00	Square	Tip	tip
Delete Edit	9998	65095	106649	129513	495291	Liz Cochran	2026-06-20 00:00:00	Square	Full Payment	credit
Delete Edit	9997	64470	106649	129513	495291	Liz Cochran	2026-05-09 00:00:00	Square	Deposit	credit
Delete Edit	9996	65094	106825	129689	2755	Jen Surratt	2026-06-19 00:00:00	Square	Tip	tip
Delete Edit	9995	65093	106825	129689	2755	Jen Surratt	2026-06-19 00:00:00	Square	Full Payment	credit
Delete Edit	9994	65092	106828	129692	495379	Rachel Bissett	2026-06-19 00:00:00	Square	Deposit	credit
Delete Edit	9993	65091	106748	129612	3340	Vanessa Bonano	2026-06-19 00:00:00	Square	Tip	tip
Delete Edit	9992	65090	106748	129612	3340	Vanessa Bonano	2026-06-19 00:00:00	Square	Full Payment	credit
Delete Edit	9991	64898	106748	129612	3340	Vanessa Bonano	2026-01-25 00:00:00		Deposit	credit
Delete Edit	9989	65089	106827	129691	495378	John Mraz	2026-06-19 00:00:00	Square	Tip	tip
Delete Edit	9988	65088	106827	129691	495378	John Mraz	2026-06-19 00:00:00	Square	Full Payment	credit
Delete Edit	9987	65085	106734	129598	495341	Taylor Ward	2026-06-19 00:00:00		Balance	credit