digi-gov.com / 127.0.0.1 / accounting / journal_main

There are no favorite tables.

New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
- lgis_app
- lgis_dum_app
lgu_repository
mysql
online_hr
performance
- performance_management
- performance_schema
qpsii
queue
repository
service_request_db

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 :

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 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 (51318 total, Query took 0.0023 seconds.)

SELECT * FROM `journal_main`

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

Filter rows:

			journal_id	STATUS	ApprovalStatus	SERIESNUMBER	TransNo	OfficeId	RespId	ProjectId	TIN	DVNum	OBRID	OBRNum	SOF_ID	SOF_NAME	SOF_CODE	trans_type	Type	FrmCaption	trans_date	PostingDate	memo	userid	username	po_id	save_date	name_id	Name_type	PayeeName	address	MOP	GroupEntry	VENDORID	CheckDate	CheckNumber	BankName	vc_reason	CancelledDate	imported_from_excel	AttachmentTBL	Sheet	obligated	CompleteDocs	avail_fund	CancelledBy	ias_status	ias_cancel_reason	ias_approverId	ias_logDateTime	migrationGUID	CheckAmount	BankAccountID	DVID	DVNO	EntryType
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 514	514	POSTED	For Approval	2022-3-11351	11351	0	0	0		1766	0	1476	1			Check Disbursement			2022-03-23	NULL	payment of insurance	132	Kelvin Ray L. Ababa	0	2022-03-21 16:30:39	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			be3f3fa7-088f-46ab-99db-c91161343d0d	0	0001-01-01	77710042			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 516	516	POSTED	For Approval	2024-3-00001	00001	0	0	0		2403-475	29570	1548	1			Cash Disbursement			2024-03-27	NULL	jo salary period for the month of March 1-15 , 202...	287	Sheila S. De Gracia	0	2022-03-21 16:54:19	0	Business	JOVELYN ALBERTO ET.AL			8f65da0f-0617-452a-b39b-845fe29cadce	0	0001-01-01				NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 517	517	POSTED	For Approval	22-03-11352	11352	0	0	0		1769	0	1501	1			Check Disbursement			2022-03-22	NULL	Payment of insurance premium - 1011	287	Sheila S. De Gracia	0	2022-03-22 09:43:11	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			dbf740a7-ccb6-4467-9989-97f2388085d8	0	0001-01-01	77710045			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 518	518	POSTED	For Approval	2022-3-00002	00002	0	0	0		2203-271-A	0		1			Cash Disbursement			2022-03-22	NULL	Salary for the period March 1-15-2022-1011-casual	287	Sheila S. De Gracia	0	2022-03-22 09:50:53	0	Business	GLICERIA LAWAS			065487b4-77d9-4154-9584-f452948bac77	0	0001-01-01				NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 519	519	POSTED	For Approval	2022-3-11353	11353	0	0	0		76-B	0		3			Check Disbursement			2022-03-29	NULL	e-claims (beacon portal) Php 10 for the period Feb...	304	Camille Faith Bolo	0	2022-03-22 10:17:35	0	Business	BIZBOX INC.			7ce4ac5f-cd2c-45af-96a2-22f41067af59	0	0001-01-01	9370			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 520	520	POSTED	For Approval	2022-3-11354	11354	0	0	0		1774	0		1			Check Disbursement			2022-03-23	NULL	Withdrawal of retention per Voucher # 101-2201-014...	287	Sheila S. De Gracia	0	2022-03-22 10:25:14	0	Business	4A AGROSCIENCE CORPORATION			50683ae7-0b58-4270-9e17-e801cb110093	0	0001-01-01	77710050			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 521	521	POSTED	For Approval	2022-3-11355	11355	0	0	0		1765	0	1500	1			Check Disbursement			2022-03-23	NULL	Payment of insurance premium 3/23/2022 to 3/23/202...	287	Sheila S. De Gracia	0	2022-03-22 10:45:42	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			55088a52-48b6-453e-9420-d83e62d11c7e	0	0001-01-01	77710041			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 522	522	POSTED	For Approval	2022-3-11356	11356	0	0	0		1767	0	1472	1			Check Disbursement			2022-03-23	NULL	Payment of Insurance for SKG453 DUMP TRUCK	132	Kelvin Ray L. Ababa	0	2022-03-22 10:51:47	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			8407f000-c608-4221-88c1-1a3bd3e5c554	0	0001-01-01	77710043			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 523	523	POSTED	For Approval	2022-3-11357	11357	0	0	0		1770	0	1475	1			Check Disbursement			2022-03-23	NULL	Payment of insurance premium 4/1/2022 to 4/1/2023 ...	287	Sheila S. De Gracia	0	2022-03-22 10:53:12	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			9cbb807f-80ac-4b67-8131-5f1165d25e0e	0	0001-01-01	77710046			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 524	524	POSTED	For Approval	2022-3-11358	11358	0	0	0		1768	0	1474	1			Check Disbursement			2022-03-23	NULL	Payment of insurance	132	Kelvin Ray L. Ababa	0	2022-03-22 10:56:38	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			0f508d36-c745-4da6-be29-816749a6ed80	0	0001-01-01	77710044			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 525	525	POSTED	For Approval	2022-3-11359	11359	0	0	0		1771	0	1471	1			Check Disbursement			2022-03-23	NULL	Payment of insurance premium 3/26/2022 to 3/26/202...	287	Sheila S. De Gracia	0	2022-03-22 10:58:18	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			5ea0b71c-0013-429d-b53b-6965f6ae9657	0	0001-01-01	77710047			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 526	526	POSTED	For Approval	2022-3-11360	11360	0	0	0		1772	0	1470	1			Check Disbursement			2022-03-23	NULL	Payment of insurance premium 4/1/2022 to 4/1/2023 ...	287	Sheila S. De Gracia	0	2022-03-22 10:59:41	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			09da0f9c-b502-4a65-9bfb-b255064e8869	0	0001-01-01	77710048			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 527	527	POSTED	For Approval	2022-3-11361	11361	0	0	0		1773	0	1469	1			Check Disbursement			2022-03-23	NULL	Payment of insurance premium 3/23/2022 to 3/23/202...	287	Sheila S. De Gracia	0	2022-03-22 11:00:52	0	Business	GOVERNMENT SERVICE INSURANCE SYSTEM			d400cc22-330f-460a-8376-a4306d5843b9	0	0001-01-01	77710049			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 528	528	POSTED	For Approval	2022-3-00003	00003	0	0	0		2203-520	0		1			Cash Disbursement			2022-03-28	NULL	JO-March 1-15-2022-1011-Task Force	287	Sheila S. De Gracia	0	2022-03-22 11:30:10	0	Business	ALFON JOHN ALFERZ ET. AL			eccc9ecd-2bfc-4e30-abca-a98516088736	0	0001-01-01				NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 529	529	POSTED	For Approval	2022-3-11362	11362	0	0	0		1789	0	1449	1			Check Disbursement			2022-03-24	NULL	Payment of meals & snacks Feb 23, 2022 - 4411	287	Sheila S. De Gracia	0	2022-03-22 13:10:59	0	Business	NIETAS FOODEES AND GOODEES			094a48e2-b2d1-4693-be34-f144c11ec24c	0	0001-01-01	77710065			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 530	530	POSTED	For Approval	2022-3-11363	11363	0	0	0		1856	0	1438	1			Check Disbursement			2022-03-22	NULL	Payment of supply and delivery of fabricated barri...	287	Sheila S. De Gracia	0	2022-03-22 13:14:29	0	Business	MACRO STAR MARKETING			299f8b5c-9f69-4dff-b6ed-b323d9c03838	0	0001-01-01	77710134			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 531	531	POSTED	For Approval	2022-3-11364	11364	0	0	0		1842	0	1502	1			Check Disbursement			2022-03-28	NULL	Improvement of Food Court (adjacent) @ Brgy. East ...	287	Sheila S. De Gracia	0	2022-03-22 13:19:15	0	Business	E.C MANUBAG BUILDERS			d4a88470-cc43-44ad-a6b2-89a073c54576	0	0001-01-01	77710119			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 532	532	POSTED	For Approval	2022-3-00004	00004	0	0	0		2203-516	0		1			Cash Disbursement			2022-03-25	NULL	JO/OT-Feb. 1-28-2022-1011-services	287	Sheila S. De Gracia	0	2022-03-22 14:00:52	0	Business	LAURO CAÑETE			c5ede9fd-7956-49f6-a872-261440411d0b	0	0001-01-01				NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 533	533	POSTED	For Approval	2022-3-00005	00005	0	0	0		2203-490	0		1			Cash Disbursement			2022-03-22	NULL	JO-March 1-15-2022-1011-services	287	Sheila S. De Gracia	0	2022-03-22 14:07:22	0	Business	CONChita Delicano et. al.			dfcc378b-ca54-4a2d-b127-0d08e58dcda2	0	0001-01-01				NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 534	534	POSTED	For Approval	2022-3-11365	11365	0	0	0		1775	0	1527	1			Check Disbursement			2022-03-23	NULL	Reimbursement of cellphone load Jan-Mar 2022 - 761...	287	Sheila S. De Gracia	0	2022-03-22 13:54:06	0	Business	MARIA BRENDA GABATO			129b308b-8d0f-459f-ad79-cccd9aac17c7	0	0001-01-01	77710051			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 535	535	POSTED	For Approval	2022-3-11366	11366	0	0	0		1746	0	1130	1			Check Disbursement			2022-03-22	NULL	Professional fee February 15-22 . 2022 -4411	287	Sheila S. De Gracia	0	2022-03-22 14:12:57	0	Business	DR. PRESCILLA DIANA KHO			93f49194-f629-40dc-af6a-b74be813e9ae	0	0001-01-01	77710022			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 536	536	POSTED	For Approval	2022-3-11367	11367	0	0	0		1777	0	12870	1			Check Disbursement			2022-03-23	NULL	Reimbursement of noodles, coffee and canned sardin...	287	Sheila S. De Gracia	0	2022-03-22 14:08:19	0	Business	ROWENA R. ARNOZA			8bc5d0de-abf9-4650-aa29-135a2ef46f27	0	0001-01-01	77710053			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 537	537	POSTED	For Approval	2022-3-00001	00001	0	0	0		03-001	0		1			General Journal			2022-03-31	NULL	To set up payables for Trust Fund collection on Ma...	304	Camille Faith Bolo	0	2022-03-22 14:12:16	0	Business				02233d53-df84-468f-a964-7b5fcc861536	0	NULL				NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 538	538	POSTED	For Approval	2022-3-11368	11368	0	0	0		1748	0		1			Check Disbursement			2022-03-22	NULL	Payment of accountable forms - 1091	287	Sheila S. De Gracia	0	2022-03-22 14:17:06	0	Business	BUREAU OF TREASURY FAO BUREAU OF INTERNAL REVENUE			378ba1d7-7a62-4a0c-a57b-90c1fe2f18fe	0	0001-01-01	77710024			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing
Edit	Copy	Delete DELETE FROM journal_main WHERE `journal_main`.`journal_id` = 539	539	POSTED	For Approval	2022-3-11369	11369	0	0	0		1862	0	12839	1			Check Disbursement			2022-03-29	NULL	Payment of supplies for Typhoon Odette response op...	287	Sheila S. De Gracia	0	2022-03-22 14:24:23	0	Business	VTB CONSUMER GOODS TRADING			3bd9ba40-9c5c-483c-a585-f84aeb5a1117	0	0001-01-01	77710140			NULL	0	Journal		0	0	0	0	For Approval	NULL	0	NULL		0.000000	0	0		Pre-Closing

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.