server-protech.tail538b7e.ts.net / 127.0.0.1 / sistem / ledger_entries

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 (47 total, Query took 0.1981 seconds.) [transaction_date: 2026-01-19... - 2026-03-27...]

SELECT * FROM `ledger_entries` ORDER BY `transaction_date` ASC

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

Filter rows:

Sort by key:

			id	tenant_id	chart_of_account_id	source_id	transaction_date 1	reference_number	source_type	amount	mutation_type debit/credit or inflow/outflow (define consistentl…	description	created_at	updated_at
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '10185af9-d886-4809-8675-d18a1eccbd65'	10185af9-d886-4809-8675-d18a1eccbd65	16e7cbea-e676-4e48-9746-48c2cc97408e	538fd5a2-f85e-451a-8699-d7ce50a846b4	cb9f5203-8ae4-4ee0-bd6e-d484e9f61965	2026-01-19	1001	cash_bank_payment	638250.00	debit	internet biznet	2026-04-28 07:08:26	2026-04-28 07:08:26
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '198721e7-f0c0-4d6b-8963-01f5dda1a34b'	198721e7-f0c0-4d6b-8963-01f5dda1a34b	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	cb9f5203-8ae4-4ee0-bd6e-d484e9f61965	2026-01-19	1001	cash_bank_payment	638250.00	credit	internet biznet	2026-04-28 07:08:26	2026-04-28 07:08:26
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '226a44a7-1208-4628-b080-46fc493b46c9'	226a44a7-1208-4628-b080-46fc493b46c9	16e7cbea-e676-4e48-9746-48c2cc97408e	66552d06-26fc-4ce2-bf57-50b444f8096c	b581ed6a-b3eb-462b-ac46-9eb4553e6ca2	2026-01-23	1002	cash_bank_payment	48470.00	debit	Air Januari, Air Februari, Kebersihan Januari, Ins...	2026-04-29 08:36:37	2026-04-29 08:36:37
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '6fcbeb72-ea95-4733-ade8-3e1f27b80622'	6fcbeb72-ea95-4733-ade8-3e1f27b80622	16e7cbea-e676-4e48-9746-48c2cc97408e	66552d06-26fc-4ce2-bf57-50b444f8096c	b581ed6a-b3eb-462b-ac46-9eb4553e6ca2	2026-01-23	1002	cash_bank_payment	48470.00	debit	Air Januari, Air Februari, Kebersihan Januari, Ins...	2026-04-29 08:36:37	2026-04-29 08:36:37
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '732ca8e2-8c46-48e4-acad-7c9d896dc6fa'	732ca8e2-8c46-48e4-acad-7c9d896dc6fa	16e7cbea-e676-4e48-9746-48c2cc97408e	c8491b92-b0af-4d6d-b105-36dc77faa533	b581ed6a-b3eb-462b-ac46-9eb4553e6ca2	2026-01-23	1002	cash_bank_payment	500000.00	debit	Air Januari, Air Februari, Kebersihan Januari, Ins...	2026-04-29 08:36:37	2026-04-29 08:36:37
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'b4015dad-73bf-4c06-9b93-1c9e508d4998'	b4015dad-73bf-4c06-9b93-1c9e508d4998	16e7cbea-e676-4e48-9746-48c2cc97408e	538fd5a2-f85e-451a-8699-d7ce50a846b4	b581ed6a-b3eb-462b-ac46-9eb4553e6ca2	2026-01-23	1002	cash_bank_payment	86114.00	debit	Air Januari, Air Februari, Kebersihan Januari, Ins...	2026-04-29 08:36:37	2026-04-29 08:36:37
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'f7f571c2-a9d9-490c-8b68-0fcb4496a920'	f7f571c2-a9d9-490c-8b68-0fcb4496a920	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	b581ed6a-b3eb-462b-ac46-9eb4553e6ca2	2026-01-23	1002	cash_bank_payment	683054.00	credit	Air Januari, Air Februari, Kebersihan Januari, Ins...	2026-04-29 08:36:37	2026-04-29 08:36:37
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '2da0bd8b-ff91-4c50-8048-95a142300621'	2da0bd8b-ff91-4c50-8048-95a142300621	16e7cbea-e676-4e48-9746-48c2cc97408e	538fd5a2-f85e-451a-8699-d7ce50a846b4	b7980427-831f-4be8-9ed5-0a1831eedc01	2026-01-28	1003	cash_bank_payment	166500.00	debit	Wifi tlp Telkomsel	2026-04-28 07:09:27	2026-04-28 07:09:27
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '97152b13-2a27-40e8-8658-891270d57fb8'	97152b13-2a27-40e8-8658-891270d57fb8	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	b7980427-831f-4be8-9ed5-0a1831eedc01	2026-01-28	1003	cash_bank_payment	166500.00	credit	Wifi tlp Telkomsel	2026-04-28 07:09:27	2026-04-28 07:09:27
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '3f924359-18fc-4989-88cf-2a40c91ba2de'	3f924359-18fc-4989-88cf-2a40c91ba2de	16e7cbea-e676-4e48-9746-48c2cc97408e	538fd5a2-f85e-451a-8699-d7ce50a846b4	b6ed1c8c-97d5-4e0f-8e33-6106ec10f8b6	2026-02-07	1005	cash_bank_payment	86114.00	debit	CCTV 2pcs + Pasang, Wifi + tlp Telkomsel, Kebersi...	2026-04-29 08:42:49	2026-04-29 08:42:49
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '437274c8-70f0-4b9a-a60c-2b71771f6c5a'	437274c8-70f0-4b9a-a60c-2b71771f6c5a	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	b6ed1c8c-97d5-4e0f-8e33-6106ec10f8b6	2026-02-07	1005	cash_bank_payment	1986114.00	credit	CCTV 2pcs + Pasang, Wifi + tlp Telkomsel, Kebersi...	2026-04-29 08:42:49	2026-04-29 08:42:49
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '6faefaad-4a03-4293-ae1d-67b7ffca6755'	6faefaad-4a03-4293-ae1d-67b7ffca6755	16e7cbea-e676-4e48-9746-48c2cc97408e	41edc202-bb95-4333-be08-3c00adfb39b2	b6ed1c8c-97d5-4e0f-8e33-6106ec10f8b6	2026-02-07	1005	cash_bank_payment	500000.00	debit	CCTV 2pcs + Pasang, Wifi + tlp Telkomsel, Kebersi...	2026-04-29 08:42:49	2026-04-29 08:42:49
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'd49023b0-61e4-4d13-bd77-dab47bfcc525'	d49023b0-61e4-4d13-bd77-dab47bfcc525	16e7cbea-e676-4e48-9746-48c2cc97408e	c8491b92-b0af-4d6d-b105-36dc77faa533	b6ed1c8c-97d5-4e0f-8e33-6106ec10f8b6	2026-02-07	1005	cash_bank_payment	1400000.00	debit	CCTV 2pcs + Pasang, Wifi + tlp Telkomsel, Kebersi...	2026-04-29 08:42:49	2026-04-29 08:42:49
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '706a5b0c-3883-4f5d-971d-823021568413'	706a5b0c-3883-4f5d-971d-823021568413	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	7f8e9a77-fd3f-4bfe-9623-982a44ca5212	2026-02-17	1015	cash_bank_payment	408315.00	credit	Internet February	2026-04-29 08:41:34	2026-04-29 08:41:34
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '77149219-1177-4841-ac25-8856ac03313e'	77149219-1177-4841-ac25-8856ac03313e	16e7cbea-e676-4e48-9746-48c2cc97408e	538fd5a2-f85e-451a-8699-d7ce50a846b4	7f8e9a77-fd3f-4bfe-9623-982a44ca5212	2026-02-17	1015	cash_bank_payment	408315.00	debit	Internet February	2026-04-29 08:41:34	2026-04-29 08:41:34
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '6bcdfd78-afcd-49f6-a2b1-10b6c3ab6384'	6bcdfd78-afcd-49f6-a2b1-10b6c3ab6384	16e7cbea-e676-4e48-9746-48c2cc97408e	1c036b4e-9655-44ad-9920-2aba6dcdec96	7200e61b-2cc2-47e8-96b1-b23611a78f78	2026-02-21	1006	cash_bank_payment	7500000.00	debit	PJT 1thn Kontrak	2026-04-28 07:10:27	2026-04-28 07:10:27
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '7754933e-1087-42e4-b6dc-3b1b8595d51f'	7754933e-1087-42e4-b6dc-3b1b8595d51f	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	7200e61b-2cc2-47e8-96b1-b23611a78f78	2026-02-21	1006	cash_bank_payment	7500000.00	credit	PJT 1thn Kontrak	2026-04-28 07:10:27	2026-04-28 07:10:27
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'c00f2095-3efc-48f5-ac30-a8e2d8c8fb82'	c00f2095-3efc-48f5-ac30-a8e2d8c8fb82	16e7cbea-e676-4e48-9746-48c2cc97408e	1c036b4e-9655-44ad-9920-2aba6dcdec96	dbe92a79-3daf-485c-9d7e-faf6137f84cf	2026-03-09	1007	cash_bank_payment	1000000.00	debit	Akta Sewa	2026-04-28 07:10:36	2026-04-28 07:10:36
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'dd98f685-903b-46f4-b96e-48da3f4e8d90'	dd98f685-903b-46f4-b96e-48da3f4e8d90	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	dbe92a79-3daf-485c-9d7e-faf6137f84cf	2026-03-09	1007	cash_bank_payment	1000000.00	credit	Akta Sewa	2026-04-28 07:10:36	2026-04-28 07:10:36
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '4c0053a0-999f-4912-bf93-d41aa4e9a2ef'	4c0053a0-999f-4912-bf93-d41aa4e9a2ef	16e7cbea-e676-4e48-9746-48c2cc97408e	538fd5a2-f85e-451a-8699-d7ce50a846b4	b8a69c62-e824-4a97-8d30-9ab9254b52e7	2026-03-13	1008	cash_bank_payment	408315.00	debit	Wifi + tlp Telkomsel	2026-04-28 07:10:47	2026-04-28 07:10:47
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'ec0a8da8-69a2-4e90-9838-6c5436180b12'	ec0a8da8-69a2-4e90-9838-6c5436180b12	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	b8a69c62-e824-4a97-8d30-9ab9254b52e7	2026-03-13	1008	cash_bank_payment	408315.00	credit	Wifi + tlp Telkomsel	2026-04-28 07:10:47	2026-04-28 07:10:47
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = '27fe4448-4da5-4f1b-8162-c1dc93cec096'	27fe4448-4da5-4f1b-8162-c1dc93cec096	16e7cbea-e676-4e48-9746-48c2cc97408e	1c036b4e-9655-44ad-9920-2aba6dcdec96	49f76040-7a3d-438a-9f24-95c635d3a0af	2026-03-17	1009	cash_bank_payment	500000.00	debit	Revisi Akta PJT	2026-04-28 07:10:59	2026-04-28 07:10:59
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'c5f6358c-7f9f-4ad1-aed5-f79a15a4fdd9'	c5f6358c-7f9f-4ad1-aed5-f79a15a4fdd9	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	49f76040-7a3d-438a-9f24-95c635d3a0af	2026-03-17	1009	cash_bank_payment	500000.00	credit	Revisi Akta PJT	2026-04-28 07:10:59	2026-04-28 07:10:59
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'a96e590f-2933-48c7-a367-1aeeee4f4294'	a96e590f-2933-48c7-a367-1aeeee4f4294	16e7cbea-e676-4e48-9746-48c2cc97408e	262e8db8-4471-44d4-bd14-5b378ab2dc2d	6a00b9f5-d5f4-4c24-8463-bd54f2697f25	2026-03-27	1010	cash_bank_payment	5298470.00	credit	PLN Maret, Air Maret, Aspal Teras depan Pagar	2026-04-28 07:11:25	2026-04-28 07:11:25
Edit	Copy	Delete DELETE FROM ledger_entries WHERE `ledger_entries`.`id` = 'c61900c9-d1cd-46f1-bdc8-73e59b15351d'	c61900c9-d1cd-46f1-bdc8-73e59b15351d	16e7cbea-e676-4e48-9746-48c2cc97408e	66552d06-26fc-4ce2-bf57-50b444f8096c	6a00b9f5-d5f4-4c24-8463-bd54f2697f25	2026-03-27	1010	cash_bank_payment	48470.00	debit	PLN Maret, Air Maret, Aspal Teras depan Pagar	2026-04-28 07:11:25	2026-04-28 07:11:25

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view