Drop files here

SQL upload ( 0 ) x-

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

Full texts id patient_type patient_no mrno name voucher_header_id voucher_no txn_no shift package_id total_amount recv_against crdr_number counter_code counter_desc transaction_type transaction_date receipt_type remarks account_balance account_balance_type pay_recv_against ot_adv Filled in casee transection is received as OT adva… pharmacy_credit_limit hospital_credit_limit created_date created_by modified_date modified_by finance_status voucher_discount_approval_id Credit Note table id voucher_discount_amount Credit Note amount locationname
1 I IP/18/000006 MR/18/000159 Mrs KESHAWPATI   NULLNULLTN/18/000001 NULL10700.00 normal PR/18/000001 FD01 Registration Counter 1 R 2018-02-01 14:15:24 A 0.00 I hospital ot_adv NULL0.00 2018-02-01 14:15:24 000013 NULLNULL0 NULLNULLAEH
2 I IP/18/000006 MR/18/000159 Mrs KESHAWPATI   NULLNULLTN/18/000002 G01 NULL50.00 normal PR/18/000002 FD02 Registration Counter 2 R 2018-02-01 14:22:36 A 0.00 I hospital NULLNULL0.00 2018-02-01 14:22:36 000144 NULLNULL0 NULLNULLAEH
3 I IP/18/000007 MR/18/000167 Mrs SHIV LALI NULLNULLTN/18/000003 NULL7500.00 normal PR/18/000003 FD01 Registration Counter 1 R 2018-02-01 14:34:57 A 0.00 I hospital ot_adv NULL0.00 2018-02-01 14:34:57 000013 NULLNULL0 NULLNULLAEH
4 I IP/18/000008 MR/18/000196 Mrs KOYLA   NULLNULLTN/18/000004 NULL7500.00 normal PR/18/000004 FD01 Registration Counter 1 R 2018-02-01 14:56:20 A 0.00 I hospital ot_adv NULL0.00 2018-02-01 14:56:20 000013 NULLNULL0 NULLNULLAEH
5 I IP/18/000010 MR/18/000223 Mrs JASKALA   NULLNULLTN/18/000005 NULL10700.00 normal PR/18/000005 FD01 Registration Counter 1 R 2018-02-02 11:33:30 A 0.00 I hospital NULLNULL0.00 2018-02-02 11:33:30 000013 NULLNULL0 NULLNULLAEH
6 I IP/18/000011 MR/18/000258 Mr NARENDRA BAHADUR SINGH NULLNULLTN/18/000006 NULL7500.00 normal PR/18/000006 FD01 Registration Counter 1 R 2018-02-02 12:04:06 A 0.00 I hospital NULLNULL0.00 2018-02-02 12:04:06 000013 NULLNULL0 NULLNULLAEH
7 I IP/18/000012 MR/18/000660 Mrs MURTA DEVI NULLNULLTN/18/000007 NULL19700.00 normal PR/18/000007 FD01 Registration Counter 1 R 2018-02-06 11:34:44 A 0.00 I hospital ot_adv NULL0.00 2018-02-06 11:34:44 000013 NULLNULL0 NULLNULLAEH
8 I IP/18/000014 MR/18/000672 Mr RAM MILAN   NULLNULLTN/18/000008 NULL7500.00 normal PR/18/000008 FD01 Registration Counter 1 R 2018-02-06 12:02:11 A 0.00 I hospital ot_adv NULL0.00 2018-02-06 12:02:11 000013 NULLNULL0 NULLNULLAEH
9 I IP/18/000015 MR/18/000694 Mrs KAILASA DEVI NULLNULLTN/18/000009 NULL1600.00 normal PR/18/000009 FD01 Registration Counter 1 R 2018-02-06 12:08:12 A 0.00 I hospital ot_adv NULL0.00 2018-02-06 12:08:12 000013 NULLNULL0 NULLNULLAEH
10 I IP/18/000030 MR/18/000711 Mrs RAJPATI   NULLNULLTN/18/000010 G01 NULL2500.00 normal PR/18/000010 FD02 Registration Counter 2 R 2018-02-06 12:27:28 A 0.00 I hospital ot_adv NULL0.00 2018-02-06 12:27:28 000144 NULLNULL0 NULLNULLAEH
11 I IP/18/000031 MR/18/000677 Mrs SHYAMA DEVI NULLNULLTN/18/000011 G01 NULL7500.00 normal PR/18/000011 FD02 Registration Counter 2 R 2018-02-06 12:44:46 A 0.00 I hospital ot_adv NULL0.00 2018-02-06 12:44:46 000144 NULLNULL0 NULLNULLAEH
12 I IP/18/000031 MR/18/000677 Mrs SHYAMA DEVI NULLNULLTN/18/000012 G01 NULL50.00 normal PR/18/000012 FD02 Registration Counter 2 R 2018-02-06 12:47:51 A 0.00 I hospital NULLNULL0.00 2018-02-06 12:47:51 000144 NULLNULL0 NULLNULLAEH
13 I IP/18/000013 MR/18/000666 Mr SHAKIL  AHMAD NULLNULLTN/18/000013 G01 NULL7500.00 normal PR/18/000013 FD02 Registration Counter 2 R 2018-02-06 15:07:06 A 0.00 I hospital ot_adv NULL0.00 2018-02-06 15:07:06 000144 NULLNULL0 NULLNULLAEH
14 I IP/18/000172 MR/18/001450 Mrs DHANRAJI   NULLNULLTN/18/000014 G01 NULL2500.00 normal PR/18/000014 FD02 Registration Counter 2 R 2018-02-10 16:27:01 A 0.00 I hospital ot_adv NULL0.00 2018-02-10 16:27:01 000144 NULLNULL0 NULLNULLAEH
15 I IP/18/000174 MR/18/001465 Mrs RAMPATI   NULLNULLTN/18/000015 G02 NULL2500.00 normal PR/18/000015 FD03 Registration Counter 3 R 2018-02-10 16:57:07 A 0.00 I hospital ot_adv NULL0.00 2018-02-10 16:57:07 000012 NULLNULL0 NULLNULLAEH
16 I IP/18/000175 MR/18/001467 Mr RAM CHANDAR NULLNULLTN/18/000016 G02 NULL2500.00 normal PR/18/000016 FD03 Registration Counter 3 R 2018-02-10 16:58:04 A 0.00 I hospital NULLNULL0.00 2018-02-10 16:58:04 000012 NULLNULL0 NULLNULLAEH
17 I IP/18/000176 MR/18/001464 Mrs SHAKINA   NULLNULLTN/18/000017 G02 NULL2500.00 normal PR/18/000017 FD03 Registration Counter 3 R 2018-02-10 16:59:27 A 0.00 I hospital ot_adv NULL0.00 2018-02-10 16:59:27 000012 NULLNULL0 NULLNULLAEH
18 I IP/18/000177 MR/18/001473 Mrs RUKHSANA KHATOON NULLNULLTN/18/000018 G02 NULL5100.00 normal PR/18/000018 FD03 Registration Counter 3 R 2018-02-10 17:00:43 A 0.00 I hospital ot_adv NULL0.00 2018-02-10 17:00:43 000012 NULLNULL0 NULLNULLAEH
19 I IP/18/000178 MR/18/001476 Mr MOHD SADAL NULLNULLTN/18/000019 G02 NULL10700.00 normal PR/18/000019 FD03 Registration Counter 3 R 2018-02-10 17:02:01 A 0.00 I hospital ot_adv NULL0.00 2018-02-10 17:02:01 000012 NULLNULL0 NULLNULLAEH
20 I IP/18/000179 MR/18/001475 Mr HABIBULLAH   NULLNULLTN/18/000020 G02 NULL7500.00 normal PR/18/000020 FD03 Registration Counter 3 R 2018-02-10 17:03:20 A 0.00 I hospital NULLNULL0.00 2018-02-10 17:03:20 000012 NULLNULL0 NULLNULLAEH
21 I IP/18/000173 MR/18/001470 Mrs RAM PIYARI NULLNULLTN/18/000021 G02 NULL2500.00 normal PR/18/000021 FD03 Registration Counter 3 R 2018-02-10 17:04:47 A 0.00 I hospital ot_adv NULL0.00 2018-02-10 17:04:47 000012 NULLNULL0 NULLNULLAEH
22 I IP/18/000180 MR/18/001472 Mr AHMAD HASAN NULLNULLTN/18/000022 G02 NULL7500.00 normal PR/18/000022 FD03 Registration Counter 3 R 2018-02-10 17:22:24 A 0.00 I hospital ot_adv NULL0.00 2018-02-10 17:22:24 000012 NULLNULL0 NULLNULLAEH
23 I IP/18/000290 MR/18/001648 Mrs LILAWATI   NULLNULLTN/18/000023 NULL10700.00 normal PR/18/000023 FD01 Registration Counter 1 R 2018-02-13 11:49:21 A 0.00 I hospital ot_adv NULL0.00 2018-02-13 11:49:21 000013 NULLNULL0 NULLNULLAEH
24 I IP/18/000291 MR/18/001632 Mrs KALINDI   NULLNULLTN/18/000024 NULL7500.00 normal PR/18/000024 FD01 Registration Counter 1 R 2018-02-13 11:54:31 A 0.00 I hospital ot_adv NULL0.00 2018-02-13 11:54:31 000013 NULLNULL0 NULLNULLAEH
25 I IP/18/000302 MR/18/001873 Mrs SHAIL KUMARI NULLNULLTN/18/000025 NULL7500.00 normal PR/18/000025 FD01 Registration Counter 1 R 2018-02-13 13:01:18 A 0.00 I hospital ot_adv NULL0.00 2018-02-13 13:01:18 000013 NULLNULL0 NULLNULLAEH