Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: drugissue_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 (906169 total, Query took 0.0006 seconds.)
SELECT * FROM `drugissue_details`

Full texts id drugissue_id item_type short_code item_code item_name frequency avl_qty req_qty issue_qty authenticate balance_qty base_unit rate other_item pre_discount_amount discount_indicator discount_amount discount_actual_amount amount created_date created_by modified_date modified_by p_pack_id p_pack_amt p_pack_qty p_advance finance_status tax_rate tax_rate_amount batch_nos locationname cgst igst utgst sgst hsn_code aft_discount_amount_tot discount_amount_tot
1 2 N PHR/CCN/00106 VIGAMOX-E/D 1396 1 1 NULL0 272.00 Medicine                     Frequency Qty Days Re 259.05 F NULLNULL272.00 2017-06-30 06:32:50 20 2017-06-30 12:02:50 20 NULL0.00 0 0.00 0 5.00 12.95 267583F APH 6.47 0.00 0.00 6.47 0.00 0.00
2 2 N PHR/CCN/00027 DIFLUCOR E/D 835 1 1 NULL0 124.00 Medicine                     Frequency Qty Days Re 118.10 F NULLNULL124.00 2017-06-30 06:32:50 20 2017-06-30 12:02:50 20 NULL0.00 0 0.00 0 5.00 5.90 CA0227B APH 2.95 0.00 0.00 2.95 0.00 0.00
3 2 N PHR/CCN/00083 NEVENAC E/D 1010 1 1 NULL0 267.00 Medicine                     Frequency Qty Days Re 254.29 F NULLNULL267.00 2017-06-30 06:32:50 20 2017-06-30 12:02:50 20 NULL0.00 0 0.00 0 5.00 12.71 274984F APH 6.36 0.00 0.00 6.36 0.00 0.00
4 2 N PHR/CCN/00104 TROPICACYL-5ML E/D 1166 1 1 NULL0 37.50 Medicine                     Frequency Qty Days Re 35.71 F NULLNULL37.50 2017-06-30 06:32:50 20 2017-06-30 12:02:50 20 NULL0.00 0 0.00 0 5.00 1.79 TR1611 APH 0.90 0.00 0.00 0.90 0.00 0.00
5 2 N PHR/CCN/00040 HIDOL PLUS TAB 26940 2 2 NULL0 2.90 Medicine                     Frequency Qty Days Re 5.52 F NULLNULL5.80 2017-06-30 06:32:50 20 2017-06-30 12:02:50 20 NULL0.00 0 0.00 0 5.00 0.28 LF12/181/02 APH 0.14 0.00 0.00 0.14 0.00 0.00
6 3 N PHR/CCN/00106 VIGAMOX-E/D 1395 1 1 NULL0 272.00 Medicine                     Frequency Qty Days Re 259.05 F NULLNULL272.00 2017-06-30 08:45:42 20 2017-06-30 14:15:42 20 NULL0.00 0 0.00 0 5.00 12.95 267583F APH 6.47 0.00 0.00 6.47 0.00 0.00
7 3 N PHR/CCN/00027 DIFLUCOR E/D 834 1 1 NULL0 124.00 Medicine                     Frequency Qty Days Re 118.10 F NULLNULL124.00 2017-06-30 08:45:42 20 2017-06-30 14:15:42 20 NULL0.00 0 0.00 0 5.00 5.90 CA0227B APH 2.95 0.00 0.00 2.95 0.00 0.00
8 3 N PHR/CCN/00083 NEVENAC E/D 1009 1 1 NULL0 267.00 Medicine                     Frequency Qty Days Re 254.29 F NULLNULL267.00 2017-06-30 08:45:42 20 2017-06-30 14:15:42 20 NULL0.00 0 0.00 0 5.00 12.71 274984F APH 6.36 0.00 0.00 6.36 0.00 0.00
9 3 N PHR/CCN/00104 TROPICACYL-5ML E/D 1165 1 1 NULL0 37.50 Medicine                     Frequency Qty Days Re 35.71 F NULLNULL37.50 2017-06-30 08:45:42 20 2017-06-30 14:15:42 20 NULL0.00 0 0.00 0 5.00 1.79 TR1611 APH 0.90 0.00 0.00 0.90 0.00 0.00
10 3 N PHR/CCN/00040 HIDOL PLUS TAB 26938 2 2 NULL0 2.90 Medicine                     Frequency Qty Days Re 5.52 F NULLNULL5.80 2017-06-30 08:45:42 20 2017-06-30 14:15:42 20 NULL0.00 0 0.00 0 5.00 0.28 LF12/181/02 APH 0.14 0.00 0.00 0.14 0.00 0.00
11 4 N PHR/CCN/00013 APDROP-PD E/D 1991 4 4 NULL0 26.00 Medicine                     Frequency Qty Days Re 99.05 F NULLNULL104.00 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 4.95 AD0036K APH 2.48 0.00 0.00 2.48 0.00 0.00
12 4 N PHR/CCN/00027 DIFLUCOR E/D 833 5 5 NULL0 124.00 Medicine                     Frequency Qty Days Re 590.48 F NULLNULL620.00 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 29.52 CA0227B APH 14.76 0.00 0.00 14.76 0.00 0.00
13 4 N PHR/CCN/00085 OLOPAT-KT E/D 70 6 6 NULL0 125.50 Medicine                     Frequency Qty Days Re 717.14 F NULLNULL753.00 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 35.86 SN0146H APH 17.93 0.00 0.00 17.93 0.00 0.00
14 4 N PHR/CCN/00093 SOFTDROP E/D 868 5 5 NULL0 167.00 Medicine                     Frequency Qty Days Re 795.24 F NULLNULL835.00 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 39.76 N0076K APH 19.88 0.00 0.00 19.88 0.00 0.00
15 4 N PHR/CCN/00107 VIRSON GEL-E/D 39 2 2 NULL0 92.75 Medicine                     Frequency Qty Days Re 176.67 F NULLNULL185.50 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 8.83 V306 APH 4.42 0.00 0.00 4.42 0.00 0.00
16 4 N PHR/CCN/00083 NEVENAC E/D 1008 13 13 NULL0 267.00 Medicine                     Frequency Qty Days Re 3305.71 F NULLNULL3471.00 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 165.29 274984F APH 82.64 0.00 0.00 82.64 0.00 0.00
17 4 N PHR/CCN/00086 PATADAY E/D 155 4 4 NULL0 362.00 Medicine                     Frequency Qty Days Re 1379.05 F NULLNULL1448.00 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 68.95 264247F APH 34.48 0.00 0.00 34.48 0.00 0.00
18 4 N PHR/CCN/00095 TEAR NATURALE FORTE E/D 1055 16 16 NULL0 187.00 Medicine                     Frequency Qty Days Re 2849.52 F NULLNULL2992.00 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 142.48 278415F APH 71.24 0.00 0.00 71.24 0.00 0.00
19 4 N PHR/CCN/00106 VIGAMOX-E/D 1394 9 9 NULL0 272.00 Medicine                     Frequency Qty Days Re 2331.43 F NULLNULL2448.00 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 116.57 267583F APH 58.28 0.00 0.00 58.28 0.00 0.00
20 4 N PHR/CCN/00020 ACULAR-LS E/D 142 1 1 NULL0 88.53 Medicine                     Frequency Qty Days Re 84.31 F NULLNULL88.53 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 4.22 PT0002 APH 2.11 0.00 0.00 2.11 0.00 0.00
21 4 N PHR/CCN/00022 COMBIGAN E/D 131 2 2 NULL0 385.53 Medicine                     Frequency Qty Days Re 734.34 F NULLNULL771.06 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 36.72 PT0001 APH 18.36 0.00 0.00 18.36 0.00 0.00
22 4 N PHR/CCN/00036 FLUR E/D 235 1 1 NULL0 133.82 Medicine                     Frequency Qty Days Re 127.45 F NULLNULL133.82 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 6.37 PT0042 APH 3.19 0.00 0.00 3.19 0.00 0.00
23 4 N PHR/CCN/00037 FML E/D 97 5 5 NULL0 105.22 Medicine                     Frequency Qty Days Re 501.05 F NULLNULL526.10 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 25.05 P2003 APH 12.53 0.00 0.00 12.53 0.00 0.00
24 4 N PHR/CCN/00038 FML-T E/D 220 4 4 NULL0 136.94 Medicine                     Frequency Qty Days Re 521.68 F NULLNULL547.76 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 26.08 PT0137 APH 13.04 0.00 0.00 13.04 0.00 0.00
25 4 N PHR/CCN/00060 L-PRED E/D 17 3 3 NULL0 142.38 Medicine                     Frequency Qty Days Re 406.80 F NULLNULL427.14 2017-06-30 09:07:24 20 2017-06-30 14:37:24 20 NULL0.00 0 0.00 0 5.00 20.34 PT0016 APH 10.17 0.00 0.00 10.17 0.00 0.00