martsolutions.org / 127.0.0.1 / oapi_db / zra_normal_sales_invoice_items

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

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.

Customize the navigation tree.

Navigation tree

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.

Servers display options.

Servers

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.

Databases display options.

Databases

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

Tables display options.

Tables

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

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

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

Browse mode

Customize browse mode.

Browse mode

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

Showing rows 0 - 24 (500 total, Query took 0.0502 seconds.) [itemNm: TAX SUPPORT SERVICE... - TAX SUPPORT SERVICE...]

SELECT * FROM `zra_normal_sales_invoice_items` ORDER BY `itemNm` DESC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	invoiceId	itemSeq	itemCd	itemClsCd	itemNm 1	bcd	pkgUnitCd	pkg	qtyUnitCd	qty	prc	splyAmt	dcRt	dcAmt	isrccCd	isrccNm	isrcRt	isrcAmt	vatCatCd	exciseTxCatCd	tlCatCd	iplCatCd	vatTaxblAmt	vatAmt	exciseTaxblAmt	tlTaxblAmt	iplTaxblAmt	iplAmt	tlAmt	exciseTxAmt	totAmt
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 260	260	179	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	10366.4560	10366.4560	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	8936.6000	1429.8560	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	10366.4560
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 522	522	345	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	6557.2944	6557.2944	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	5652.8400	904.4544	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	6557.2944
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 269	269	184	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	464.0000	464.0000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	400.0000	64.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	464.0000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 273	273	187	2	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	75.4000	75.4000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	65.0000	10.4000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	75.4000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 275	275	188	2	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	0.7500	75.4000	56.5500	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	48.7500	7.8000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	56.5500
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 277	277	189	2	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	16.5000	75.4000	1244.1000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	1072.5000	171.6000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	1244.1000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 278	278	190	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.5000	75.4000	113.1000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	97.5000	15.6000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	113.1000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 535	535	356	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	7500.0000	7500.0000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	6465.5200	1034.4800	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	7500.0000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 282	282	193	2	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	2.5000	92.8000	232.0000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	200.0000	32.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	232.0000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 284	284	194	2	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	4.5000	92.8000	417.6000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	360.0000	57.6000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	417.6000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 286	286	195	2	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	4.5000	92.8000	417.6000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	360.0000	57.6000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	417.6000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 542	542	361	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	9657.6496	9657.6496	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	8325.5600	1332.0896	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	9657.6496
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 289	289	197	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	580.0000	580.0000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	500.0000	80.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	580.0000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 296	296	203	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.5000	75.4000	113.1000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	97.5000	15.6000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	113.1000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 304	304	208	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.5000	92.8000	139.2000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	120.0000	19.2000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	139.2000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 305	305	209	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	15.5000	92.8000	1438.4000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	1240.0000	198.4000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	1438.4000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 307	307	211	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	2.5000	92.8000	232.0000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	200.0000	32.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	232.0000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 54	54	47	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	220.0056	220.0056	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	189.6600	30.3456	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	220.0056
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 58	58	48	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	220.0056	220.0056	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	189.6600	30.3456	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	220.0056
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 320	320	218	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	500.0064	500.0064	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	431.0400	68.9664	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	500.0064
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 323	323	219	3	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	17400.0000	17400.0000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	15000.0000	2400.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	17400.0000
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 328	328	222	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	20800.0064	20800.0064	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	17931.0400	2868.9664	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	20800.0064
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 329	329	223	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	10562.9136	10562.9136	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	9105.9600	1456.9536	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	10562.9136
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 346	346	233	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	500.0064	500.0064	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	431.0400	68.9664	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	500.0064
Edit	Copy	Delete DELETE FROM zra_normal_sales_invoice_items WHERE `zra_normal_sales_invoice_items`.`id` = 347	347	234	1	ZMORBS0000013	80101514	Tax Support Service		NT	0.0000	NO	1.0000	2320.0000	2320.0000	0.0000	0.0000			0.00	0.0000	A	NULL	NULL	NULL	2000.0000	320.0000	0.0000	0.0000	0.0000	0.0000	0.0000	0.0000	2320.0000

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view