Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: finalbill_rev_details
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





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

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (425 total, Query took 0.0023 seconds.)
SELECT * FROM `finalbill_rev_details`

Full texts id finalbill_id finalbill_detail_id major_code minor_code service_id service_desc reason actual_quantity quantity rate amount reversal_amt packqty packamt adv_refund lab_based_on created_date locationname
1 466 1057 PROMAJ CATIOL 119 SICS SQR EDGE LENS Service Not Available 1.00 1.00 2500.00 2500.00 2500.00 1.00 0.00 NULLNULL2018-02-19 16:34:38 AEH
2 607 1361 PROMAJ CATIOL 118 SICS SIMPLE LENS Service Not Available 1.00 1.00 1600.00 1500.00 1500.00 1.00 0.00 NULLNULL2018-02-22 17:30:35 AEH
3 616 1383 PROMAJ CATIOL 118 SICS SIMPLE LENS Service Not Available 1.00 1.00 1600.00 1500.00 1500.00 1.00 0.00 NULLNULL2018-02-22 17:31:03 AEH
4 1215 2665 PROMAJ CATIOL 118 SICS SIMPLE LENS Other 1.00 1.00 1600.00 1500.00 1500.00 1.00 0.00 NULLNULL2018-03-26 17:32:14 AEH
5 1302 2880 PROMAJ CATIOL 119 SICS SQR EDGE LENS Patient Request 1.00 1.00 2500.00 2500.00 2500.00 1.00 0.00 NULLNULL2018-05-15 17:29:04 AEH
6 1473 3380 PROMAJ CATIOL 119 SICS SQR EDGE LENS Service Not Available 1.00 1.00 2500.00 2500.00 2500.00 1.00 0.00 NULLNULL2018-06-18 12:23:20 AEH
7 1566 3656 PROMAJ GLUSUR 106 PHACO ACRY SOFT (MICS-IQ) LENS Wrong Entry 1.00 1.00 20000.00 19000.00 19000.00 1.00 0.00 NULLNULL2018-07-05 15:35:08 AEH
8 1615 3826 PROMAJ GLUSUR 102 PHACO BAUSCH AND LOMB LENS Wrong Entry 1.00 1.00 13200.00 13200.00 13200.00 1.00 0.00 NULLNULL2018-07-10 11:24:54 AEH
9 1696 4063 PROMAJ CATIOL 101 PHACO GOLD LENS Patient Request 1.00 1.00 10700.00 10700.00 10700.00 1.00 0.00 NULLNULL2018-07-16 16:51:26 AEH
10 1696 4064 PROMAJ GLUSUR 102 PHACO BAUSCH AND LOMB LENS Wrong Entry 1.00 1.00 13200.00 13200.00 13200.00 1.00 0.00 NULLNULL2018-07-16 17:07:42 AEH
11 1882 4640 PROMAJ CATIOL 105 PHACO ABBOTT SENSAR  LENS Wrong Entry 1.00 1.00 15200.00 14200.00 14200.00 1.00 0.00 NULLNULL2018-08-02 12:38:35 AEH
12 2136 5393 PROMAJ CATIOL 101 PHACO GOLD LENS Wrong Entry 1.00 1.00 10700.00 10200.00 10200.00 1.00 0.00 NULLNULL2018-08-03 16:47:36 AEH
13 2489 6453 PROMAJ CATIOL 118 SICS SIMPLE LENS Patient Request 1.00 1.00 1600.00 1500.00 1500.00 1.00 0.00 NULLNULL2018-09-13 17:50:27 AEH
14 2709 7080 PROMAJ CATIOL 101 PHACO GOLD LENS Patient Request 1.00 1.00 10700.00 10700.00 10700.00 1.00 0.00 NULLNULL2018-09-24 12:23:20 AEH
15 2709 7080 LABMAJ BIOCHM 17 RBS Patient Request 1.00 1.00 50.00 50.00 50.00 1.00 0.00 NULLNULL2018-09-24 12:23:20 AEH
16 2875 7526 PROMAJ CATIOL 118 SICS SIMPLE LENS Wrong Entry 1.00 1.00 1600.00 1500.00 1500.00 1.00 0.00 NULLNULL2018-09-29 16:26:58 AEH
17 3070 8112 PROMAJ GLUSUR 99 PHACO JANTA LENS Wrong Entry 1.00 1.00 5100.00 5100.00 5100.00 1.00 0.00 NULLNULL2018-10-09 15:57:06 AEH
18 3274 8655 PROMAJ OTHSUR 123 DCR WITH INTUBATION TUBE Other 1.00 1.00 7200.00 7200.00 7200.00 1.00 0.00 NULLNULL2018-09-14 11:47:38 AEH
19 3424 9028 PROMAJ GLUSUR 100 PHACO RYCF LENS Wrong Entry 1.00 1.00 7500.00 7500.00 7500.00 1.00 0.00 NULLNULL2018-10-23 10:57:32 AEH
20 3900 10293 PROMAJ GLUSUR 100 PHACO RYCF LENS Patient Request 1.00 1.00 7500.00 7500.00 7500.00 1.00 0.00 NULLNULL2018-10-10 14:48:37 AEH
21 3906 10311 PROMAJ GLUSUR 100 PHACO RYCF LENS Patient Request 1.00 1.00 7500.00 7500.00 7500.00 1.00 0.00 NULLNULL2018-10-09 18:11:07 AEH
22 3909 10321 PROMAJ CATIOL 119 SICS SQR EDGE LENS Patient Request 1.00 1.00 2500.00 2500.00 2500.00 1.00 0.00 NULLNULL2018-10-12 17:26:42 AEH
23 3953 10445 PROMAJ CATIOL 118 SICS SIMPLE LENS Patient Request 1.00 1.00 1600.00 1500.00 1500.00 1.00 0.00 NULLNULL2018-10-29 12:53:46 AEH
24 3974 10513 PROMAJ CATIOL 101 PHACO GOLD LENS Patient Request 1.00 1.00 10700.00 10700.00 10700.00 1.00 0.00 NULLNULL2018-10-31 16:53:24 AEH
25 4083 10852 PROMAJ RETINA 91 PPV+EL Service Not Available 1.00 1.00 16000.00 16000.00 16000.00 1.00 0.00 NULLNULL2018-11-14 10:38:39 AEH