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

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	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	10019	65116	106842	129706	3140	Berkley Lunt	2026-06-21 00:00:00	Square	Deposit	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
Delete Edit	9986	65046	106770	129634	495358	Chloe	2026-06-08 00:00:00	Square	Tip	tip
Delete Edit	9985	65045	106770	129634	495358	Chloe	2026-06-08 00:00:00	Square	Deposit	credit
Delete Edit	9983	65084	106738	129602	495345	Lisa Voyles	2026-06-15 00:00:00	Square	Full Payment	credit
Delete Edit	9982	64870	106738	129602	495345	Lisa Voyles	2026-05-29 00:00:00	Square	Deposit	credit
Delete Edit	9981	65083	106820	129684	495377	Andy Miller	2026-06-15 00:00:00	Square	Full Payment	credit
Delete Edit	9979	65082	106819	129683	495376	Kim Miller	2026-06-15 00:00:00	Square	Tip	tip
Delete Edit	9978	65081	106819	129683	495376	Kim Miller	2026-06-15 00:00:00	Square	Full Payment	credit
Delete Edit	9976	65080	106700	129564	3302	Loren Van De Griek	2026-06-15 00:00:00	Square	Full Payment	credit
Delete Edit	9975	64710	106700	129564	3302	Loren Van De Griek	2026-05-18 00:00:00	Square	Deposit	credit
Delete Edit	9973	65079	106779	129643	148004	Sheylla Aceves	2026-06-15 00:00:00	Square	Tip	tip
Delete Edit	9972	65078	106779	129643	148004	Sheylla Aceves	2026-06-15 00:00:00	Square	Full Payment	credit
Delete Edit	9970	65076	106811	129675	3255	Julianna Mazza	2026-06-14 00:00:00	Square	Tip	tip
Delete Edit	9969	65075	106811	129675	3255	Julianna Mazza	2026-06-14 00:00:00	Square	Full Payment	credit
Delete Edit	9967	65074	106812	129676	495375	Briana Flouro	2026-06-14 00:00:00	Square	Tip	tip
Delete Edit	9966	65073	106812	129676	495375	Briana Flouro	2026-06-14 00:00:00	Square	Full Payment	credit
Delete Edit	9965	65072	106684	129548	495311	Laurie Ziemer	2026-06-14 00:00:00	Square	Tip	tip
Delete Edit	9964	65071	106684	129548	495311	Laurie Ziemer	2026-06-14 00:00:00	Square	Full Payment	credit
Delete Edit	9963	64613	106684	129548	495311	Laurie Ziemer	2026-05-16 00:00:00	Square	Deposit	credit
Delete Edit	9962	65070	106730	129594	495338	Mary Dego	2026-06-14 00:00:00	Square	Tip	tip
Delete Edit	9961	65069	106730	129594	495338	Mary Dego	2026-06-14 00:00:00	Square	Full Payment	credit
Delete Edit	9960	64842	106730	129594	495338	Mary Dego	2026-05-25 00:00:00	Cash	Deposit	cash
Delete Edit	9958	65068	106813	129677	495359	Edward Weber	2026-06-14 00:00:00	Square	Tip	tip
Delete Edit	9957	65067	106813	129677	495359	Edward Weber	2026-06-14 00:00:00	Square	Full Payment	credit
Delete Edit	9956	65066	106806	129670	495373	Gabriel Paez	2026-06-13 00:00:00	Square	Full Payment	credit
Delete Edit	9955	65065	106808	129672	2728	Marie Campbell	2026-06-13 00:00:00	Square	Full Payment	credit