shackfitness.online / 127.0.0.1 / truckingbusiness / qashio_erp_transactions

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (1456 total, Query took 0.0040 seconds.) [transaction_category: CARD_LOADING... - CARD_LOADING...]

SELECT * FROM `qashio_erp_transactions` ORDER BY `transaction_category` ASC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	qashio_id Immutable Qashio transaction ref	transaction_category 1 Normalized e.g. PURCHASE, CASH_WITHDRAWAL	transaction_time	billing_amount	billing_currency	transaction_amount	transaction_currency	memo	merchant_name	expense_category_name	card_name	card_last_four	card_holder_name	raw_json	synced_at	assigned_trip_id	assigned_kind	assigned_at	voided	voided_at	linked_trip_expense_id	linked_advance_tracker_id	marked_synced User reconciliation flag	remark	clearing_delta	qashio_txn_id	parent_txn_id	message_type
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4621	4621	dsfsdfsdwe	CARD_LOADING	2026-01-01 12:35:23.000	112.0400	AED	112.0400	AED	saqr fix	NULL	NULL	18694 DXB Harbajan	5449	Syed Zakir	{"id": "142b3ad7-c49f-4927-84f2-4d6f69826e7f", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	142b3ad7-c49f-4927-84f2-4d6f69826e7f	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4622	4622	12345	CARD_LOADING	2026-01-01 12:37:38.000	308.9000	AED	308.9000	AED	saqr fix	NULL	NULL	46772 DXB Jagdeep	5340	Syed Zakir	{"id": "72439127-1407-4268-b9f9-60bff4b57690", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	72439127-1407-4268-b9f9-60bff4b57690	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4623	4623	23456	CARD_LOADING	2026-01-01 12:40:03.000	319.6800	AED	319.6800	AED	saqr fix	NULL	NULL	82702 DXB Joginder	5241	Syed Zakir	{"id": "ebf0e370-f56d-43a4-af16-5d970fb6734a", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	ebf0e370-f56d-43a4-af16-5d970fb6734a	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4624	4624	3456	CARD_LOADING	2026-01-01 12:41:54.000	1136.5600	AED	1136.5600	AED	saqr fix	NULL	NULL	14523 DXB Amkar Singh	2509	Syed Zakir	{"id": "b4855d0e-26aa-41a3-8eec-28dfab5c8f81", "qa...	2026-04-17 20:11:30	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	b4855d0e-26aa-41a3-8eec-28dfab5c8f81	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4625	4625	4568	CARD_LOADING	2026-01-01 12:43:44.000	287.4500	AED	287.4500	AED	saqr fix	NULL	NULL	45253 DXB Didar	4947	Syed Zakir	{"id": "823b252b-366c-43ee-81ce-bb1c06dce2e0", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	823b252b-366c-43ee-81ce-bb1c06dce2e0	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4626	4626	5678	CARD_LOADING	2026-01-01 12:45:39.000	252.4000	AED	252.4300	AED	saqr fix	NULL	NULL	56300 DXB Gurdev	2517	Syed Zakir	{"id": "6f861a3c-ce0f-417c-9514-9bdfb3ed0f9b", "qa...	2026-04-17 20:07:35	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	6f861a3c-ce0f-417c-9514-9bdfb3ed0f9b	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4627	4627	6789	CARD_LOADING	2026-01-01 12:47:25.000	1500.0000	AED	1500.0000	AED	saqr fix	NULL	NULL	18864 DXB Jaswinder	5142	Syed Zakir	{"id": "1fc6d250-8260-4e4e-9995-21528b08fc56", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	1fc6d250-8260-4e4e-9995-21528b08fc56	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4629	4629	789	CARD_LOADING	2026-01-01 12:48:14.000	810.3900	AED	810.3900	AED	saqr fix	NULL	NULL	22004 DXB Kashmir	5043	Syed Zakir	{"id": "dbebb49f-20df-41f5-938a-326b94bab202", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	dbebb49f-20df-41f5-938a-326b94bab202	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4630	4630	897	CARD_LOADING	2026-01-01 12:49:46.000	815.6300	AED	815.6300	AED	saqr fix	NULL	NULL	Office Government Card	3249	Syed Zakir	{"id": "33033e59-b285-480a-b282-e90771fec540", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	33033e59-b285-480a-b282-e90771fec540	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4631	4631	8987	CARD_LOADING	2026-01-01 13:20:25.000	633.6400	AED	633.6400	AED	saqr fix	NULL	NULL	Software card	7531	Syed Zakir	{"id": "8041e778-c4f1-49a7-bb8f-9882895bc6dc", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	8041e778-c4f1-49a7-bb8f-9882895bc6dc	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 4652	4652	5555	CARD_LOADING	2026-01-01 13:22:26.000	213.0000	AED	213.0000	AED	saqr fix	NULL	NULL	Kulwant Singh 25362 Dxb	5647	Syed Zakir	{"id": "a020acbf-05fe-4559-a6f9-f96b2d4fb897", "qa...	2026-04-17 18:39:09	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	a020acbf-05fe-4559-a6f9-f96b2d4fb897	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24605	24605	CT0u6enkp2q118dj	CARD_LOADING	2026-01-02 15:08:04.643	2000.0000	AED	2000.0000	AED	NULL	NULL	NULL	18694 DXB Harbajan	5449	Syed Zakir	{"id": "6c540bbd-0bfb-4c48-a82d-653ad09b20da", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	6c540bbd-0bfb-4c48-a82d-653ad09b20da	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24604	24604	CT45m3b3vfu4u40x	CARD_LOADING	2026-01-02 15:08:17.405	2500.0000	AED	2500.0000	AED	NULL	NULL	NULL	82702 DXB Joginder	5241	Syed Zakir	{"id": "b52416a9-3b4b-49c3-ab97-0e311347014e", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	b52416a9-3b4b-49c3-ab97-0e311347014e	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24596	24596	CT62mqh0esz8atkv	CARD_LOADING	2026-01-03 04:57:08.916	1800.0000	AED	1800.0000	AED	NULL	NULL	NULL	45253 DXB Didar	4947	Syed Zakir	{"id": "823b252b-366c-43ee-81ce-bb1c06dce2e0", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	823b252b-366c-43ee-81ce-bb1c06dce2e0	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24595	24595	CTt672fdyrk8gfe5	CARD_LOADING	2026-01-03 04:58:11.420	1300.0000	AED	1300.0000	AED	NULL	NULL	NULL	22004 DXB Kashmir	5043	Syed Zakir	{"id": "19462001-9519-4be6-ac57-5a2cfe3370ad", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	19462001-9519-4be6-ac57-5a2cfe3370ad	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24586	24586	CT0u4ffj7ey7ange	CARD_LOADING	2026-01-03 16:31:42.817	1018.0000	AED	1018.0000	AED	NULL	NULL	NULL	Office Government Card	3249	Syed Zakir	{"id": "c0ac13bf-0ec9-4908-87d9-aeef2f8e4b5d", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	c0ac13bf-0ec9-4908-87d9-aeef2f8e4b5d	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24585	24585	CTd8t410pz8tsxy3	CARD_LOADING	2026-01-03 16:32:47.511	1700.0000	AED	1700.0000	AED	NULL	NULL	NULL	46772 DXB Jagdeep	5340	Syed Zakir	{"id": "d2f455c6-8990-4d13-93a1-5a63d3f14c8e", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	d2f455c6-8990-4d13-93a1-5a63d3f14c8e	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24584	24584	CTqqsvuajby1txj7	CARD_LOADING	2026-01-03 18:10:29.371	1700.0000	AED	1700.0000	AED	NULL	NULL	NULL	46772 DXB Jagdeep	5340	Syed Zakir	{"id": "97152ba3-e84c-4456-bf86-157ba8074231", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	97152ba3-e84c-4456-bf86-157ba8074231	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24583	24583	CTfaascwwiae7nb6	CARD_LOADING	2026-01-03 18:10:49.365	300.0000	AED	300.0000	AED	NULL	NULL	NULL	18694 DXB Harbajan	5449	Syed Zakir	{"id": "e01ac7f2-fbf6-4ec7-ab87-eb0f6bc1e4d1", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	e01ac7f2-fbf6-4ec7-ab87-eb0f6bc1e4d1	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24582	24582	CTcckmafiw5oumcw	CARD_LOADING	2026-01-03 18:11:41.915	800.0000	AED	800.0000	AED	NULL	NULL	NULL	Kulwant Singh 25362 Dxb	5647	Syed Zakir	{"id": "5289eb63-d6d7-4242-b943-a9cf0e248e2c", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	5289eb63-d6d7-4242-b943-a9cf0e248e2c	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24581	24581	CT3fxfxoxgmhc8b5	CARD_LOADING	2026-01-03 18:11:49.835	300.0000	AED	300.0000	AED	NULL	NULL	NULL	18694 DXB Harbajan	5449	Syed Zakir	{"id": "9189c22a-1dd9-4cc3-9b99-a620f41dd65d", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	9189c22a-1dd9-4cc3-9b99-a620f41dd65d	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24580	24580	CTn58ju6rqpc9f2c	CARD_LOADING	2026-01-03 18:14:02.705	750.0000	AED	750.0000	AED	NULL	NULL	NULL	56300 DXB Gurdev	2517	Syed Zakir	{"id": "96a56fef-538d-445e-85b9-513fac77e2fe", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	96a56fef-538d-445e-85b9-513fac77e2fe	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24579	24579	CT8eh7hub0h95ndj	CARD_LOADING	2026-01-03 18:15:37.630	502.0000	AED	502.0000	AED	NULL	NULL	NULL	48472 DUBAI SHEIKAR	5548	Syed Zakir	{"id": "0a65216f-7643-4b2c-b5f6-5e4b402cbd76", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	0a65216f-7643-4b2c-b5f6-5e4b402cbd76	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24578	24578	CT4bej9fo0uh04qp	CARD_LOADING	2026-01-03 21:40:43.255	800.0000	AED	800.0000	AED	NULL	NULL	NULL	46772 DXB Jagdeep	5340	Syed Zakir	{"id": "0a9f196b-78e5-4f36-9fe3-4af4613e4d2b", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	0a9f196b-78e5-4f36-9fe3-4af4613e4d2b	9349ccad-4473-473b-938d-4b9ebebb3194	api
Edit	Copy	Delete DELETE FROM qashio_erp_transactions WHERE `qashio_erp_transactions`.`id` = 24577	24577	CTapo5ebez73zv6x	CARD_LOADING	2026-01-03 21:41:23.559	2100.0000	AED	2100.0000	AED	NULL	NULL	NULL	18694 DXB Harbajan	5449	Syed Zakir	{"id": "9fa1cd05-0d93-45fe-98b1-7f0f0931ecef", "qa...	2026-04-17 18:39:29	NULL	NULL	NULL	0	NULL	NULL	NULL	1	NULL	NULL	9fa1cd05-0d93-45fe-98b1-7f0f0931ecef	9349ccad-4473-473b-938d-4b9ebebb3194	api

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view