digi-gov.com / 127.0.0.1 / accounting / journal_detail

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

SELECT * FROM `journal_detail`

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

Filter rows:

			journal_detail_id	journal_id	account_id	subsidiary	subsidiary_description	subsidiary_type	bank	SUBACCOUNTID	Memorandom	GroupEntryD	RECONDATE	_CMP	_BRN	_CHR	INV_REF	GS	DEBITS	CREDITS	DueDate	ATC_CODE	ATC_RATE	ATC_DESCRIPTION	imported_from_excel	WVAT With VAT	UNITID	UNITNAME	SOF	SOFID	SOFCode	SubFundName	SubFundID	FundClassName	FundClassID	migrationGUID	STAT	OtherRemarks	ARE_No	FacilityID	CFTypeID
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 6769	6769	514	3	DBP1	DBP-0735-021564-030	OTHER ACCOUNTS	False	25		be3f3fa7-088f-46ab-99db-c91161343d0d		0	0	0		NONE	0.000000	7158.620000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 6770	6770	514	92	SHW-783	Toyota/Wagon(Fortuner)-SHW-783	OTHER ACCOUNTS	False	811		be3f3fa7-088f-46ab-99db-c91161343d0d		0	0	0		NONE	7158.620000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 6827	6827	517	92	SJW - 763	Toyota Hilux	OTHER ACCOUNTS	False	814		dbf740a7-ccb6-4467-9989-97f2388085d8		0	0	0		NONE	8304.220000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 6828	6828	517	3	DBP1	DBP-0735-021564-030	OTHER ACCOUNTS	False	25		dbf740a7-ccb6-4467-9989-97f2388085d8		0	0	0		NONE	0.000000	8304.220000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7494	7494	518	51	SASAN	Antonita Sasan	OTHER ACCOUNTS	False	224		065487b4-77d9-4154-9584-f452948bac77		0	0	0		NONE	0.000000	5368.600000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7495	7495	518	355			OTHER ACCOUNTS	False	8329		065487b4-77d9-4154-9584-f452948bac77		0	0	1		NONE	5632.440000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7496	7496	518	356			OTHER ACCOUNTS	False	8329		065487b4-77d9-4154-9584-f452948bac77		0	0	1		NONE	1000.000000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7497	7497	518	370			OTHER ACCOUNTS	False	8329		065487b4-77d9-4154-9584-f452948bac77		0	0	1		NONE	1351.790000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7498	7498	518	371			OTHER ACCOUNTS	False	8329		065487b4-77d9-4154-9584-f452948bac77		0	0	1		NONE	100.000000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7499	7499	518	372			OTHER ACCOUNTS	False	8329		065487b4-77d9-4154-9584-f452948bac77		0	0	1		NONE	150.000000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7500	7500	518	373			OTHER ACCOUNTS	False	8329		065487b4-77d9-4154-9584-f452948bac77		0	0	1		NONE	100.000000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7501	7501	518	258	LIFE	Life & Retirement Insurance Premium	OTHER ACCOUNTS	False	4586		065487b4-77d9-4154-9584-f452948bac77		0	0	0		NONE	0.000000	2365.630000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7502	7502	518	259	PREMIUMS	Pag-ibig Premiums	OTHER ACCOUNTS	False	4609		065487b4-77d9-4154-9584-f452948bac77		0	0	0		NONE	0.000000	200.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7503	7503	518	260	PHILHEALTH	Phil. Health Insurance	OTHER ACCOUNTS	False	4615		065487b4-77d9-4154-9584-f452948bac77		0	0	0		NONE	0.000000	300.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7504	7504	518	258	STATE	State Insurance	OTHER ACCOUNTS	False	4598		065487b4-77d9-4154-9584-f452948bac77		0	0	0		NONE	0.000000	100.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7505	7505	519	3	LBP3A	LBP - NAGA (PHIC HCI A# 4312-1000-32)	OTHER ACCOUNTS	False	39		7ce4ac5f-cd2c-45af-96a2-22f41067af59		0	0	0		NONE	0.000000	18.930000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7506	7506	519	257	BIR2	Taxes Withheld - Creditors	OTHER ACCOUNTS	False	4556		7ce4ac5f-cd2c-45af-96a2-22f41067af59		0	0	0		NONE	0.000000	1.070000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7507	7507	519	597	PHIC HCI CHRGS	LBP transactions for PHIC HCI charges	OTHER ACCOUNTS	False	6069		7ce4ac5f-cd2c-45af-96a2-22f41067af59		0	0	0		NONE	20.000000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7508	7508	520	269	4A-1	1% Retention - 4A Agroscience Corporation	OTHER ACCOUNTS	False	4859		50683ae7-0b58-4270-9e17-e801cb110093		0	0	0		NONE	4960.000000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7509	7509	520	3	DBP1	DBP-0735-021564-030	OTHER ACCOUNTS	False	25		50683ae7-0b58-4270-9e17-e801cb110093		0	0	0		NONE	0.000000	4960.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7510	7510	521	3	DBP1	DBP-0735-021564-030	OTHER ACCOUNTS	False	25		55088a52-48b6-453e-9420-d83e62d11c7e		0	0	0		NONE	0.000000	6958.700000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7511	7511	521	92	AAH-7143	Toyota Hilux ARE # D4075	OTHER ACCOUNTS	False	795		55088a52-48b6-453e-9420-d83e62d11c7e		0	0	0		NONE	6958.700000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7512	7512	522	3	DBP1	DBP-0735-021564-030	OTHER ACCOUNTS	False	25		8407f000-c608-4221-88c1-1a3bd3e5c554		0	0	0		NONE	0.000000	7940.990000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7513	7513	522	92	SKG-453	Dump Truck	OTHER ACCOUNTS	False	820		8407f000-c608-4221-88c1-1a3bd3e5c554		0	0	0		NONE	7940.990000	0.000000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0
Edit	Copy	Delete DELETE FROM journal_detail WHERE `journal_detail`.`journal_detail_id` = 7514	7514	523	3	DBP1	DBP-0735-021564-030	OTHER ACCOUNTS	False	25		9cbb807f-80ac-4b67-8131-5f1165d25e0e		0	0	0		NONE	0.000000	7170.210000	0001-01-01		0		0	No	0			1			0		0		A		0	0	0

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.