Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `journal_detail`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view