ai.surenasolutions.in / 127.0.0.1 / aiskgl / sb_ca_account_feetransaction_receipt

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.

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.

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.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

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

Press Ctrl+Enter to execute query

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

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

			ftrid	AcademicYear	SID	Fee1	Fee2	Fee3	Fee4	Fee5	Fee6	Fee7	Fee8	Fee9	Fee10	Fee11	Fee12	Fee13	Fee14	Fee15	Fee16	Fee17	Fee18	Fee19	Fee20	Fee21	Fee22	Fee23	Fee24	Fee25	Fee26	Fee27	Fee28	Fee29	Fee30	Transport	Hostel	Hostel_Deposit	Fine_Fee	DOP	User	ModifiedUser	rnd	hostel_rno	df_rno	sfrno	cfrno	Ed	SyllabusType	Class	PaymentType	Bank	PayStatus 1	CheckClearanceDate	ChequeNo	CCReferenceNo	Reason	bounce_amount	wrongaccountdeposite	modified_at
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 3645	3645	21	4646	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4860	0	0	0	2021-09-29	ADM1001	ADM1001	23576	0	0	0	0		1	8	POS	CARD SWIPE#000225	Not Success	2021-09-29	CARD SWIPE#000225					2021-09-29 15:47:29
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 256	256	21	5368	25000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-07-02	ACC1234	ACC1234	9315	0	0	0	0		2	9	Cash	-	Success	0000-00-00	-					2021-07-02 12:20:27
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 512	512	21	4734	25000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-06-07	ADM1001	ADM1001	8434	0	0	0	0		2	9	POS	1410 TFR-UPI/115866328475/U ARUN-ID-4734	Success	2021-06-07	1410 TFR-UPI/115866328475/U ARUN-ID-4734					2021-07-21 15:04:27
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 768	768	21	3204	20000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-07-28	ACC1234	ACC1234	14554	0	0	0	0		1	3	POS	UPI 120943892676 Bank of Baroda	Success	2021-07-28	UPI 120943892676					2021-07-28 13:45:18
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 1024	1024	21	5048	10000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-08-02	ACC1234	ACC1234	1680	0	0	0	0		5	16	POS	UPI:121441135135	Success	2021-08-02	UPI:121441135135					2021-08-02 10:40:51
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 1280	1280	21	5576	0	0	0	0	15000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-08-05	ACC1115	ACC1115	30248	0	0	0	0		1	1	Cash	-	Success	0000-00-00	-					2021-08-05 13:23:02
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 1536	1536	21	556	10000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-08-10	ACC1115	ACC1115	7207	0	0	0	0		2	9	Cash	-	Success	0000-00-00	-					2021-08-10 14:26:11
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 1792	1792	21	65	15000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-08-16	ACC1115	ACC1115	25009	0	0	0	0		1	4	Cash	-	Success	0000-00-00	-					2021-08-16 16:41:20
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 2048	2048	21	5134	0	0	0	0	0	0	0	0	0	5000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	10000	0	0	2021-08-22	ACC1234	ACC1234	6955	0	0	0	0		5	15	POS	1410 TRF UTR:123422890528 ID NO:5134	Success	2021-08-22	UTR:123422890528					2021-08-22 16:55:22
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 2304	2304	21	3957	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	7000	0	0	2021-08-23	ACC1115	ACC1115	18497	0	0	0	0		2	9	POS	IDBI-1410/UPI:123517732445/ID-3957	Success	2021-08-23	UPI:123517732445					2021-08-23 17:21:04
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 2560	2560	21	18	15000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-08-26	ACC1234	ACC1234	566	0	0	0	0		1	4	Cash	-	Success	0000-00-00	-					2021-08-26 17:17:17
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 2816	2816	21	5476	0	0	0	0	0	0	0	0	0	5000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-09-01	ACC1115	ACC1115	8052	0	0	0	0		2	8	Cash	-	Success	0000-00-00	-					2021-09-01 15:56:59
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 3072	3072	21	3741	15000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-09-13	ACC1234	ACC1234	27117	0	0	0	0		1	7	Cash	-	Success	0000-00-00	-					2021-09-13 16:07:59
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 3328	3328	21	4364	40	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5760	0	0	0	2021-09-23	ADM1001	ADM1001	21990	0	0	0	0		3	8	Cash	-	Success	0000-00-00	-					2021-09-23 09:15:30
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 3584	3584	21	5125	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5000	0	0	0	2021-09-28	ADM1001	ADM1001	29759	0	0	0	0		5	16	Cash	-	Success	0000-00-00	-					2021-09-28 13:19:59
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 3840	3840	21	5163	10200	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-10-04	ACC1115	ACC1115	31967	0	0	0	0		5	16	Cash	-	Success	0000-00-00	-					2021-10-04 13:36:26
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 4096	4096	21	5189	17700	0	0	0	0	0	0	0	0	994	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	21306	0	0	2021-10-20	ACC1115	ACC1115	28525	0	0	0	0		2	10	Cash	-	Success	0000-00-00	-					2021-10-20 12:40:04
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 4352	4352	21	3890	25000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	15000	0	0	2021-10-21	ACC1115	ACC1115	7198	0	0	0	0		3	8	Cash	-	Success	0000-00-00	-					2021-10-21 09:17:13
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 4608	4608	21	5785	280	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4860	0	0	0	2021-10-23	ACC1234	ACC1234	18638	0	0	0	0		3	5	Cash	-	Success	0000-00-00	-					2021-10-23 13:01:03
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 4864	4864	21	2640	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5220	0	0	0	2021-10-27	ACC1115	ACC1115	20709	0	0	0	0		1	3	Cash	-	Success	0000-00-00	-					2021-10-27 09:47:25
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 5120	5120	21	4416	20000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-10-23	ADM1001	ADM1001	13108	0	0	0	0		2	10	POS	1410 tfr-UPI/129679685497/VASANTH S K	Success	2021-10-23	1410 tfr-UPI/129679685497/VASANTH S K					2021-11-12 11:12:53
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 5376	5376	21	4821	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20000	0	0	2021-11-22	ACC1234	ACC1234	21690	0	0	0	0		2	9	Cash	-	Success	0000-00-00	-					2021-11-22 13:47:32
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 5632	5632	21	5174	10000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-11-22	ACC1259	ACC1259	29139	0	0	0	0		2	10	POS	AX011326000004909054-PAYMENT_SUCCESS	Success	2021-11-22	AX011326000004909054-PAYMENT_SUCCESS					2021-11-22 17:11:35
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 5888	5888	21	4348	25000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5000	0	0	2021-11-23	ACC1115	ACC1115	13791	0	0	0	0		3	9	Cash	-	Success	0000-00-00	-					2021-11-23 16:50:41
Edit	Copy	Delete DELETE FROM sb_ca_account_feetransaction_receipt WHERE `sb_ca_account_feetransaction_receipt`.`ftrid` = 6144	6144	21	5182	23000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2021-11-27	ADM1001	ADM1001	25353	0	0	0	0		2	8	POS	AX011331000004929744-PAYMENT_SUCCESS	Success	2021-11-27	AX011331000004929744-PAYMENT_SUCCESS					2021-11-27 09:30:25

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customize browse mode.