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

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

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	6605	64472	106656	129520	495296	Chad Cave	2026-05-09 00:00:00	Square	Full Payment	credit
Delete Edit	6603	64470	106649	129513	495291	Liz Cochran	2026-05-09 00:00:00	Square	Deposit	credit
Delete Edit	6601	64468	106648	129512	489019	Chevy Stern	2026-05-09 00:00:00	Square	Deposit	credit
Delete Edit	6597	64465	104138	129385	489078	Lauren Dodzweit	2026-04-18 00:00:00	Square	Tip	tip
Delete Edit	6596	64464	104138	129385	489078	Lauren Dodzweit	2026-04-18 00:00:00	Square	Full Payment	credit
Delete Edit	6592	64460	106657	129521	495297	Diego Martinez	2026-05-09 00:00:00	Square	Full Payment	credit
Delete Edit	6591	64459	8148	6199	24983	Lauren Munson	2026-04-25 00:00:00	Square	Tip	tip
Delete Edit	6590	64458	8148	6199	24983	Lauren Munson	2026-04-25 00:00:00	Square	Full Payment	credit
Delete Edit	6589	64457	8148	6199	24983	Lauren Munson	2026-03-21 00:00:00		deposit	credit
Delete Edit	6587	64456	104134	129381	489076	Kristina Chace	2026-04-18 00:00:00	Square	Tip	tip
Delete Edit	6586	64455	104134	129381	489076	Kristina Chace	2026-04-18 00:00:00	Square	Full Payment	credit
Delete Edit	6584	64454	106583	129447	429498	Darin Richter	2026-04-25 00:00:00	Square	Tip	tip
Delete Edit	6583	64453	106583	129447	429498	Darin Richter	2026-04-25 00:00:00	Square	Full Payment	credit
Delete Edit	6582	64452	106640	129504	495289	Femi Olawore	2026-05-03 00:00:00	Square	Full Payment	credit
Delete Edit	6581	64451	104139	129386	3501	Beverly Oconnor	2026-05-08 00:00:00	Cash	Payment	cash
Delete Edit	6577	64448	106654	129518	495295	Catrello Griffin	2026-05-08 00:00:00	Square	Tip	tip
Delete Edit	6576	64447	106654	129518	495295	Catrello Griffin	2026-05-08 00:00:00	Square	Full Payment	credit
Delete Edit	6574	64446	106652	129516	495294	Jessica Jensen	2026-05-08 00:00:00	Square	Tip	tip
Delete Edit	6573	64445	106652	129516	495294	Jessica Jensen	2026-05-08 00:00:00	Square	Full Payment	credit
Delete Edit	6568	64442	106651	129515	495293	Jill Bodkins	2026-05-08 00:00:00	Square	Tip	tip
Delete Edit	6567	64441	106651	129515	495293	Jill Bodkins	2026-05-08 00:00:00	Square	Full Payment	credit
Delete Edit	6563	64435	106644	129508	495290	Tammy Geiger	2026-05-08 00:00:00	Square	Deposit	credit
Delete Edit	6556	64437	106653	129517	495246	Jessica Boydston	2026-05-08 00:00:00	Square	Full Payment	credit
Delete Edit	6550	64432	106643	129507	2796	Jennifer Ackett	2026-05-08 00:00:00	Square	Tip	tip
Delete Edit	6549	64431	106643	129507	2796	Jennifer Ackett	2026-05-08 00:00:00	Square	Full Payment	credit
Delete Edit	6547	64430	5343	5399	3501	Beverly Oconnor	2026-03-20 00:00:00		payment	credit
Delete Edit	6546	64429	5343	5399	3501	Beverly Oconnor	2026-03-06 00:00:00		deposit	credit
Delete Edit	6545	64428	106570	129434	495254	Kelsey Renke	2026-04-24 00:00:00	Square	Full Payment	credit
Delete Edit	6544	64427	106602	129466	495273	Venkatesh Chanda	2026-05-01 00:00:00	Square	Full Payment	credit
Delete Edit	6538	64422	106588	129452	495268	Isabel Covert	2026-05-04 00:00:00	Square	Tip	tip
Delete Edit	6537	64421	106588	129452	495268	Isabel Covert	2026-05-04 00:00:00	Square	Full Payment	credit
Delete Edit	6536	64420	106642	129506	429508	Nadine Guetti	2026-05-04 00:00:00	Square	Full Payment	credit
Delete Edit	6533	64418	106634	129498	495286	Meiah Luttrell	2026-05-04 00:00:00	Square	Tip	tip
Delete Edit	6532	64417	106634	129498	495286	Meiah Luttrell	2026-05-04 00:00:00	Square	Full Payment	credit
Delete Edit	6528	64414	106633	129497	495285	Malia Swenson	2026-05-04 00:00:00	Square	Deposit	credit
Delete Edit	6525	64411	106562	129426	495247	Pat Stone	2026-04-25 00:00:00	Square	Full Payment	credit
Delete Edit	6524	64410	104104	129351	489068	Mary Anne Hawton	2026-05-04 00:00:00	Cash	Full Payment	cash
Delete Edit	6522	64407	106573	129437	495256	Sandra Prece	2026-05-04 00:00:00	Square	Full Payment	credit
Delete Edit	6521	64405	106573	129437	495256	Sandra Prece	2026-04-24 00:00:00	Square	Deposit	credit
Delete Edit	6485	64395	106575	129439	495258	Jan Murch	2026-05-04 00:00:00	Square	Full Payment	credit
Delete Edit	6484	64394	106575	129439	495258	Jan Murch	2026-04-24 00:00:00	Square	Full Payment	credit
Delete Edit	6481	64392	106587	129451	495267	Dan Sacher-Brown	2026-05-04 00:00:00	Square	Tip	tip
Delete Edit	6480	64391	106587	129451	495267	Dan Sacher-Brown	2026-05-04 00:00:00	Square	Full Payment	credit
Delete Edit	6475	64387	557	307	3456	Michelle Corcoran	2026-05-04 00:00:00	Square	Payment	credit
Delete Edit	6474	64386	557	307	3456	Michelle Corcoran	2026-02-23 00:00:00		deposit	credit
Delete Edit	6473	64388	104147	129394	489082	Wanda Laezza	2026-04-17 00:00:00	Square	Full Payment	credit
Delete Edit	6466	64382	106628	129492	3463	Jennifer Rosenberg	2026-05-02 00:00:00	Square	Full Payment	credit
Delete Edit	6465	64381	106621	129485	495281	Elizabeth Cox	2026-05-03 00:00:00	Square	Full Payment	credit
Delete Edit	6463	64379	106620	129484	495280	James Louie	2026-05-03 00:00:00	Square	Full Payment	credit
Delete Edit	6461	64377	106641	129505	1500	Yaritza Alvarado	2026-05-03 00:00:00	Square	Full Payment	credit
Delete Edit	6458	64374	106638	129502	495288	Nikole Oak	2026-05-03 00:00:00	Square	Full Payment	credit
Delete Edit	6457	64373	106638	129502	495288	Nikole Oak	2026-05-03 00:00:00	Square	Tip	tip
Delete Edit	6453	64368	121	295	1500	Yaritza Alvarado	2026-01-30 00:00:00		payment	credit
Delete Edit	6446	64361	106572	129436	1257	Cheryl Gundry	2026-04-24 00:00:00	Square	Full Payment	credit
Delete Edit	6444	64360	103599	128973	3226	Emiliano Delgado	2026-04-18 00:00:00	Square	Tip	tip
Delete Edit	6443	64359	103599	128973	3226	Emiliano Delgado	2026-04-18 00:00:00	Square	Full Payment	credit
Delete Edit	6442	64358	104095	129342	489065	Karina Almanzan	2026-04-12 00:00:00	Square	Full Payment	credit
Delete Edit	6438	64357	103760	129007	488985	Dacia Grey	2026-04-05 00:00:00		Deposit	credit
Delete Edit	6433	64352	106593	129457	495271	Havva Ruddell	2026-04-26 00:00:00	Square	Full Payment	credit
Delete Edit	6429	64349	103747	128994	488980	Megan Gunther	2026-04-04 00:00:00	Square	Full Payment	credit
Delete Edit	6428	64348	106607	129471	495277	Maryann Sutherland	2026-05-02 00:00:00	Square	Deposit	credit
Delete Edit	6426	64346	106606	129470	495276	Kara Knowles	2026-05-02 00:00:00	Square	Deposit	credit
Delete Edit	6424	64344	103752	128999	488981	Chantel Morton	2026-05-02 00:00:00	Square	Tip	tip
Delete Edit	6423	64343	103752	128999	488981	Chantel Morton	2026-05-02 00:00:00	Square	Deposit	credit
Delete Edit	6422	64342	103752	128999	488981	Chantel Morton	2026-04-05 00:00:00	Square	Deposit	credit
Delete Edit	6420	64341	103821	129068	488997	Tj Aguilar	2026-04-11 00:00:00	Square	Tip	tip
Delete Edit	6419	64340	103821	129068	488997	Tj Aguilar	2026-04-11 00:00:00	Square	Full Payment	credit
Delete Edit	6418	64339	106604	129468	495275	Frances Kellner	2026-05-01 00:00:00	Check	Full Payment	check
Delete Edit	6416	64336	104079	129326	847	Cassie Cardi	2026-05-01 00:00:00	Cash	Final Payment	cash
Delete Edit	6415	64333	104079	129326	847	Cassie Cardi	2026-05-01 00:00:00	Square	Deposit	credit
Delete Edit	6410	64329	104127	129374	489075	Isabelle Buakey	2026-04-17 00:00:00	Square	Full Payment	credit
Delete Edit	6409	64328	106601	129465	2681	Karley Martin	2026-05-01 00:00:00	Square	Full Payment	credit
Delete Edit	6406	64326	106612	129476	495278	Lynn Asare	2026-05-01 00:00:00	Square	Tip	tip
Delete Edit	6405	64325	106612	129476	495278	Lynn Asare	2026-05-01 00:00:00	Square	Full Payment	credit
Delete Edit	6401	64322	106600	129464	2468	Roxann Diaz	2026-05-01 00:00:00	Cash	Full Payment	cash