Recent
`mysql`.`event`
`oapi_db`.`zra_normal_sales_invoice`
`performance_schema`.`file_instances`
`performance_schema`.`mutex_instances`
`restoapi`.`db_connection`
`performance_schema`.`socket_instances`
`adminpanel`.`initializes`
`oapi_db`.`users`
`oapi_db`.`zra_item`
`performance_schema`.`session_connect_attrs`
Favorites
There are no favorite tables.
New
adminpanel
cooperative
information_schema
medvantm_pharmacy_db
mysql
oapi_db
performance_schema
phpmyadmin
restoapi
test
wyteboxdb
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: oapi_db
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press 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
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`cart`.*
`cart`.`id`
`cart`.`user_id`
`cart`.`pid`
`cart`.`name`
`cart`.`price`
`cart`.`quantity`
`cart`.`image`
`company_credentials`.*
`company_credentials`.`id`
`company_credentials`.`company`
`company_credentials`.`tpin`
`company_credentials`.`branch`
`company_credentials`.`address`
`logs`.*
`logs`.`id`
`logs`.`url`
`logs`.`response_code`
`logs`.`response_message`
`logs`.`last_retrieved`
`logs`.`timestamp`
`logs`.`status`
`message`.*
`message`.`id`
`message`.`user_id`
`message`.`name`
`message`.`email`
`message`.`number`
`message`.`message`
`notice`.*
`notice`.`id`
`notice`.`page_name`
`notice`.`function_name`
`notice`.`message`
`notice`.`timestamp`
`orders`.*
`orders`.`id`
`orders`.`user_id`
`orders`.`name`
`orders`.`number`
`orders`.`email`
`orders`.`method`
`orders`.`address`
`orders`.`total_products`
`orders`.`total_price`
`orders`.`placed_on`
`orders`.`payment_status`
`products`.*
`products`.`id`
`products`.`name`
`products`.`details`
`products`.`price`
`products`.`image`
`purchase_invoices`.*
`purchase_invoices`.`id`
`purchase_invoices`.`spplrTpin`
`purchase_invoices`.`spplrNm`
`purchase_invoices`.`spplrBhfId`
`purchase_invoices`.`spplrInvcNo`
`purchase_invoices`.`rcptTyCd`
`purchase_invoices`.`pmtTyCd`
`purchase_invoices`.`cfmDt`
`purchase_invoices`.`salesDt`
`purchase_invoices`.`stockRlsDt`
`purchase_invoices`.`totItemCnt`
`purchase_invoices`.`totTaxblAmt`
`purchase_invoices`.`totTaxAmt`
`purchase_invoices`.`totAmt`
`purchase_invoices`.`remark`
`purchase_items`.*
`purchase_items`.`id`
`purchase_items`.`invoice_id`
`purchase_items`.`itemSeq`
`purchase_items`.`itemCd`
`purchase_items`.`itemClsCd`
`purchase_items`.`itemNm`
`purchase_items`.`pkgUnitCd`
`purchase_items`.`pkg`
`purchase_items`.`qtyUnitCd`
`purchase_items`.`qty`
`purchase_items`.`prc`
`purchase_items`.`splyAmt`
`purchase_items`.`dcRt`
`purchase_items`.`dcAmt`
`purchase_items`.`vatCatCd`
`purchase_items`.`vatTaxblAmt`
`purchase_items`.`vatAmt`
`purchase_items`.`totAmt`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`password`
`users`.`user_type`
`wishlist`.*
`wishlist`.`id`
`wishlist`.`user_id`
`wishlist`.`pid`
`wishlist`.`name`
`wishlist`.`price`
`wishlist`.`image`
`zra_codes`.*
`zra_codes`.`id`
`zra_codes`.`cdCls`
`zra_codes`.`cdClsNm`
`zra_codes`.`userDfnNm1`
`zra_codes`.`cd`
`zra_codes`.`cdNm`
`zra_codes`.`userDfnCd1`
`zra_credentials`.*
`zra_credentials`.`id`
`zra_credentials`.`tin`
`zra_credentials`.`taxprNm`
`zra_credentials`.`bsnsActv`
`zra_credentials`.`bhfId`
`zra_credentials`.`bhfNm`
`zra_credentials`.`bhfOpenDt`
`zra_credentials`.`prvncNm`
`zra_credentials`.`dstrtNm`
`zra_credentials`.`sctrNm`
`zra_credentials`.`locDesc`
`zra_credentials`.`hqYn`
`zra_credentials`.`mgrNm`
`zra_credentials`.`mgrTelNo`
`zra_credentials`.`mgrEmail`
`zra_credentials`.`sdcId`
`zra_credentials`.`mrcNo`
`zra_credentials`.`lastPchsInvcNo`
`zra_credentials`.`lastSaleRcptNo`
`zra_credentials`.`lastInvcNo`
`zra_credentials`.`lastSaleInvcNo`
`zra_credentials`.`lastTrainInvcNo`
`zra_credentials`.`lastProfrmInvcNo`
`zra_credentials`.`lastCopyInvcNo`
`zra_credentials`.`status`
`zra_customer`.*
`zra_customer`.`id`
`zra_customer`.`tpin`
`zra_customer`.`bhfId`
`zra_customer`.`custNo`
`zra_customer`.`custTpin`
`zra_customer`.`custNm`
`zra_customer`.`adrs`
`zra_customer`.`email`
`zra_customer`.`faxNo`
`zra_customer`.`useYn`
`zra_customer`.`remark`
`zra_customer`.`regrNm`
`zra_customer`.`regrId`
`zra_customer`.`modrNm`
`zra_customer`.`modrId`
`zra_imported_items`.*
`zra_imported_items`.`id`
`zra_imported_items`.`resultDt`
`zra_imported_items`.`taskCd`
`zra_imported_items`.`dclDe`
`zra_imported_items`.`itemSeq`
`zra_imported_items`.`dclNo`
`zra_imported_items`.`hsCd`
`zra_imported_items`.`itemNm`
`zra_imported_items`.`imptItemsttsCd`
`zra_imported_items`.`orgnNatCd`
`zra_imported_items`.`exptNatCd`
`zra_imported_items`.`pkg`
`zra_imported_items`.`pkgUnitCd`
`zra_imported_items`.`qty`
`zra_imported_items`.`qtyUnitCd`
`zra_imported_items`.`totWt`
`zra_imported_items`.`netWt`
`zra_imported_items`.`spplrNm`
`zra_imported_items`.`agntNm`
`zra_imported_items`.`invcFcurAmt`
`zra_imported_items`.`invcFcurCd`
`zra_imported_items`.`invcFcurExcrt`
`zra_imported_items`.`dclRefNum`
`zra_imported_items`.`prcd`
`zra_item`.*
`zra_item`.`id`
`zra_item`.`tpin`
`zra_item`.`bhfId`
`zra_item`.`itemCd`
`zra_item`.`itemClsCd`
`zra_item`.`itemTyCd`
`zra_item`.`itemNm`
`zra_item`.`itemStdNm`
`zra_item`.`orgnNatCd`
`zra_item`.`pkgUnitCd`
`zra_item`.`qtyUnitCd`
`zra_item`.`vatCatCd`
`zra_item`.`iplCatCd`
`zra_item`.`tlCatCd`
`zra_item`.`exciseTxCatCd`
`zra_item`.`btchNo`
`zra_item`.`bcd`
`zra_item`.`dftPrc`
`zra_item`.`manufacturerTpin`
`zra_item`.`manufacturerItemCd`
`zra_item`.`rrp`
`zra_item`.`svcChargeYn`
`zra_item`.`rentalYn`
`zra_item`.`addInfo`
`zra_item`.`sftyQty`
`zra_item`.`isrcAplcbYn`
`zra_item`.`useYn`
`zra_item`.`regrNm`
`zra_item`.`regrId`
`zra_item`.`modrNm`
`zra_item`.`modrId`
`zra_item_class`.*
`zra_item_class`.`id`
`zra_item_class`.`itemClsCd`
`zra_item_class`.`itemClsNm`
`zra_item_class`.`itemClsLvl`
`zra_item_class`.`taxTyCd`
`zra_item_class`.`mjrTgYn`
`zra_item_class`.`useYn`
`zra_normal_sales_invoice`.*
`zra_normal_sales_invoice`.`id`
`zra_normal_sales_invoice`.`tpin`
`zra_normal_sales_invoice`.`bhfId`
`zra_normal_sales_invoice`.`refInvcNo`
`zra_normal_sales_invoice`.`orgInvcNo`
`zra_normal_sales_invoice`.`orgSdcId`
`zra_normal_sales_invoice`.`cisInvcNo`
`zra_normal_sales_invoice`.`custTpin`
`zra_normal_sales_invoice`.`custNm`
`zra_normal_sales_invoice`.`salesTyCd`
`zra_normal_sales_invoice`.`rcptTyCd`
`zra_normal_sales_invoice`.`pmtTyCd`
`zra_normal_sales_invoice`.`salesSttsCd`
`zra_normal_sales_invoice`.`cfmDt`
`zra_normal_sales_invoice`.`salesDt`
`zra_normal_sales_invoice`.`stockRlsDt`
`zra_normal_sales_invoice`.`cnclReqDt`
`zra_normal_sales_invoice`.`cnclDt`
`zra_normal_sales_invoice`.`rfdDt`
`zra_normal_sales_invoice`.`rfdRsnCd`
`zra_normal_sales_invoice`.`taxblAmtA`
`zra_normal_sales_invoice`.`taxblAmtB`
`zra_normal_sales_invoice`.`taxblAmtC1`
`zra_normal_sales_invoice`.`taxblAmtC2`
`zra_normal_sales_invoice`.`taxblAmtC3`
`zra_normal_sales_invoice`.`taxblAmtD`
`zra_normal_sales_invoice`.`taxblAmtRvat`
`zra_normal_sales_invoice`.`taxblAmtE`
`zra_normal_sales_invoice`.`taxblAmtF`
`zra_normal_sales_invoice`.`taxblAmtIpl1`
`zra_normal_sales_invoice`.`taxblAmtIpl2`
`zra_normal_sales_invoice`.`taxblAmtTl`
`zra_normal_sales_invoice`.`taxblAmtEcm`
`zra_normal_sales_invoice`.`taxblAmtExeeg`
`zra_normal_sales_invoice`.`taxblAmtTot`
`zra_normal_sales_invoice`.`taxAmtA`
`zra_normal_sales_invoice`.`taxAmtB`
`zra_normal_sales_invoice`.`taxAmtC1`
`zra_normal_sales_invoice`.`taxAmtC2`
`zra_normal_sales_invoice`.`taxAmtC3`
`zra_normal_sales_invoice`.`taxAmtD`
`zra_normal_sales_invoice`.`taxAmtRvat`
`zra_normal_sales_invoice`.`taxAmtE`
`zra_normal_sales_invoice`.`taxAmtF`
`zra_normal_sales_invoice`.`taxAmtIpl1`
`zra_normal_sales_invoice`.`taxAmtIpl2`
`zra_normal_sales_invoice`.`taxAmtTl`
`zra_normal_sales_invoice`.`taxAmtEcm`
`zra_normal_sales_invoice`.`taxAmtExeeg`
`zra_normal_sales_invoice`.`taxAmtTot`
`zra_normal_sales_invoice`.`taxRtA`
`zra_normal_sales_invoice`.`taxRtB`
`zra_normal_sales_invoice`.`taxRtC1`
`zra_normal_sales_invoice`.`taxRtC2`
`zra_normal_sales_invoice`.`taxRtC3`
`zra_normal_sales_invoice`.`taxRtD`
`zra_normal_sales_invoice`.`tlAmt`
`zra_normal_sales_invoice`.`taxRtRvat`
`zra_normal_sales_invoice`.`taxRtE`
`zra_normal_sales_invoice`.`taxRtF`
`zra_normal_sales_invoice`.`taxRtIpl1`
`zra_normal_sales_invoice`.`taxRtIpl2`
`zra_normal_sales_invoice`.`taxRtTl`
`zra_normal_sales_invoice`.`taxRtEcm`
`zra_normal_sales_invoice`.`taxRtExeeg`
`zra_normal_sales_invoice`.`taxRtTot`
`zra_normal_sales_invoice`.`totItemCnt`
`zra_normal_sales_invoice`.`totTaxblAmt`
`zra_normal_sales_invoice`.`totTaxAmt`
`zra_normal_sales_invoice`.`totAmt`
`zra_normal_sales_invoice`.`cashDcRt`
`zra_normal_sales_invoice`.`cashDcAmt`
`zra_normal_sales_invoice`.`remark`
`zra_normal_sales_invoice`.`regrId`
`zra_normal_sales_invoice`.`regrNm`
`zra_normal_sales_invoice`.`modrId`
`zra_normal_sales_invoice`.`modrNm`
`zra_normal_sales_invoice`.`prchrAcptcYn`
`zra_normal_sales_invoice`.`saleCtyCd`
`zra_normal_sales_invoice`.`lpoNumber`
`zra_normal_sales_invoice`.`invcAdjustReason`
`zra_normal_sales_invoice`.`dbtRsnCd`
`zra_normal_sales_invoice`.`currencyTyCd`
`zra_normal_sales_invoice`.`exchangeRt`
`zra_normal_sales_invoice`.`destnCountryCd`
`zra_normal_sales_invoice`.`prcd`
`zra_normal_sales_invoice`.`prnt`
`zra_normal_sales_invoice`.`rcptNo`
`zra_normal_sales_invoice`.`intrlData`
`zra_normal_sales_invoice`.`rcptSign`
`zra_normal_sales_invoice`.`vsdcRcptPbctDate`
`zra_normal_sales_invoice`.`sdcId`
`zra_normal_sales_invoice`.`mrcNo`
`zra_normal_sales_invoice`.`qrCodeUrl`
`zra_normal_sales_invoice_items`.*
`zra_normal_sales_invoice_items`.`id`
`zra_normal_sales_invoice_items`.`invoiceId`
`zra_normal_sales_invoice_items`.`itemSeq`
`zra_normal_sales_invoice_items`.`itemCd`
`zra_normal_sales_invoice_items`.`itemClsCd`
`zra_normal_sales_invoice_items`.`itemNm`
`zra_normal_sales_invoice_items`.`bcd`
`zra_normal_sales_invoice_items`.`pkgUnitCd`
`zra_normal_sales_invoice_items`.`pkg`
`zra_normal_sales_invoice_items`.`qtyUnitCd`
`zra_normal_sales_invoice_items`.`qty`
`zra_normal_sales_invoice_items`.`prc`
`zra_normal_sales_invoice_items`.`splyAmt`
`zra_normal_sales_invoice_items`.`dcRt`
`zra_normal_sales_invoice_items`.`dcAmt`
`zra_normal_sales_invoice_items`.`isrccCd`
`zra_normal_sales_invoice_items`.`isrccNm`
`zra_normal_sales_invoice_items`.`isrcRt`
`zra_normal_sales_invoice_items`.`isrcAmt`
`zra_normal_sales_invoice_items`.`vatCatCd`
`zra_normal_sales_invoice_items`.`exciseTxCatCd`
`zra_normal_sales_invoice_items`.`tlCatCd`
`zra_normal_sales_invoice_items`.`iplCatCd`
`zra_normal_sales_invoice_items`.`vatTaxblAmt`
`zra_normal_sales_invoice_items`.`vatAmt`
`zra_normal_sales_invoice_items`.`exciseTaxblAmt`
`zra_normal_sales_invoice_items`.`tlTaxblAmt`
`zra_normal_sales_invoice_items`.`iplTaxblAmt`
`zra_normal_sales_invoice_items`.`iplAmt`
`zra_normal_sales_invoice_items`.`tlAmt`
`zra_normal_sales_invoice_items`.`exciseTxAmt`
`zra_normal_sales_invoice_items`.`totAmt`
`zra_purchase_invoice`.*
`zra_purchase_invoice`.`id`
`zra_purchase_invoice`.`tpin`
`zra_purchase_invoice`.`bhfId`
`zra_purchase_invoice`.`refInvcNo`
`zra_purchase_invoice`.`orgInvcNo`
`zra_purchase_invoice`.`orgSdcId`
`zra_purchase_invoice`.`cisInvcNo`
`zra_purchase_invoice`.`spplrTpin`
`zra_purchase_invoice`.`spplrBhfId`
`zra_purchase_invoice`.`spplrNm`
`zra_purchase_invoice`.`spplrInvcNo`
`zra_purchase_invoice`.`regTyCd`
`zra_purchase_invoice`.`pchsTyCd`
`zra_purchase_invoice`.`rcptTyCd`
`zra_purchase_invoice`.`pmtTyCd`
`zra_purchase_invoice`.`pchsSttsCd`
`zra_purchase_invoice`.`cfmDt`
`zra_purchase_invoice`.`pchsDt`
`zra_purchase_invoice`.`cnclReqDt`
`zra_purchase_invoice`.`cnclDt`
`zra_purchase_invoice`.`taxblAmtA`
`zra_purchase_invoice`.`taxblAmtB`
`zra_purchase_invoice`.`taxblAmtC1`
`zra_purchase_invoice`.`taxblAmtC2`
`zra_purchase_invoice`.`taxblAmtC3`
`zra_purchase_invoice`.`taxblAmtD`
`zra_purchase_invoice`.`taxblAmtRvat`
`zra_purchase_invoice`.`taxblAmtE`
`zra_purchase_invoice`.`taxblAmtF`
`zra_purchase_invoice`.`taxblAmtIpl1`
`zra_purchase_invoice`.`taxblAmtIpl2`
`zra_purchase_invoice`.`taxblAmtTl`
`zra_purchase_invoice`.`taxblAmtEcm`
`zra_purchase_invoice`.`taxblAmtExeeg`
`zra_purchase_invoice`.`taxblAmtTot`
`zra_purchase_invoice`.`taxAmtA`
`zra_purchase_invoice`.`taxAmtB`
`zra_purchase_invoice`.`taxAmtC1`
`zra_purchase_invoice`.`taxAmtC2`
`zra_purchase_invoice`.`taxAmtC3`
`zra_purchase_invoice`.`taxAmtD`
`zra_purchase_invoice`.`taxAmtRvat`
`zra_purchase_invoice`.`taxAmtE`
`zra_purchase_invoice`.`taxAmtF`
`zra_purchase_invoice`.`taxAmtIpl1`
`zra_purchase_invoice`.`taxAmtIpl2`
`zra_purchase_invoice`.`taxAmtTl`
`zra_purchase_invoice`.`taxAmtEcm`
`zra_purchase_invoice`.`taxAmtExeeg`
`zra_purchase_invoice`.`taxAmtTot`
`zra_purchase_invoice`.`taxRtA`
`zra_purchase_invoice`.`taxRtB`
`zra_purchase_invoice`.`taxRtC1`
`zra_purchase_invoice`.`taxRtC2`
`zra_purchase_invoice`.`taxRtC3`
`zra_purchase_invoice`.`taxRtD`
`zra_purchase_invoice`.`tlAmt`
`zra_purchase_invoice`.`taxRtRvat`
`zra_purchase_invoice`.`taxRtE`
`zra_purchase_invoice`.`taxRtF`
`zra_purchase_invoice`.`taxRtIpl1`
`zra_purchase_invoice`.`taxRtIpl2`
`zra_purchase_invoice`.`taxRtTl`
`zra_purchase_invoice`.`taxRtEcm`
`zra_purchase_invoice`.`taxRtExeeg`
`zra_purchase_invoice`.`taxRtTot`
`zra_purchase_invoice`.`totItemCnt`
`zra_purchase_invoice`.`totTaxblAmt`
`zra_purchase_invoice`.`totTaxAmt`
`zra_purchase_invoice`.`totAmt`
`zra_purchase_invoice`.`remark`
`zra_purchase_invoice`.`regrId`
`zra_purchase_invoice`.`regrNm`
`zra_purchase_invoice`.`modrId`
`zra_purchase_invoice`.`modrNm`
`zra_purchase_invoice`.`prcd`
`zra_purchase_invoice`.`prnt`
`zra_purchase_invoice`.`rcptNo`
`zra_purchase_invoice`.`intrlData`
`zra_purchase_invoice`.`rcptSign`
`zra_purchase_invoice`.`vsdcRcptPbctDate`
`zra_purchase_invoice`.`sdcId`
`zra_purchase_invoice`.`mrcNo`
`zra_purchase_invoice`.`qrCodeUrl`
`zra_purchase_invoice_items`.*
`zra_purchase_invoice_items`.`id`
`zra_purchase_invoice_items`.`invoiceId`
`zra_purchase_invoice_items`.`itemSeq`
`zra_purchase_invoice_items`.`itemCd`
`zra_purchase_invoice_items`.`itemClsCd`
`zra_purchase_invoice_items`.`itemNm`
`zra_purchase_invoice_items`.`bcd`
`zra_purchase_invoice_items`.`pkgUnitCd`
`zra_purchase_invoice_items`.`pkg`
`zra_purchase_invoice_items`.`qtyUnitCd`
`zra_purchase_invoice_items`.`qty`
`zra_purchase_invoice_items`.`prc`
`zra_purchase_invoice_items`.`splyAmt`
`zra_purchase_invoice_items`.`dcRt`
`zra_purchase_invoice_items`.`dcAmt`
`zra_purchase_invoice_items`.`isrccCd`
`zra_purchase_invoice_items`.`isrccNm`
`zra_purchase_invoice_items`.`isrcRt`
`zra_purchase_invoice_items`.`isrcAmt`
`zra_purchase_invoice_items`.`vatCatCd`
`zra_purchase_invoice_items`.`exciseTxCatCd`
`zra_purchase_invoice_items`.`tlCatCd`
`zra_purchase_invoice_items`.`iplCatCd`
`zra_purchase_invoice_items`.`vatTaxblAmt`
`zra_purchase_invoice_items`.`vatAmt`
`zra_purchase_invoice_items`.`exciseTaxblAmt`
`zra_purchase_invoice_items`.`tlTaxblAmt`
`zra_purchase_invoice_items`.`iplTaxblAmt`
`zra_purchase_invoice_items`.`iplAmt`
`zra_purchase_invoice_items`.`tlAmt`
`zra_purchase_invoice_items`.`exciseTxAmt`
`zra_purchase_invoice_items`.`totAmt`
`zra_save_stock_item`.*
`zra_save_stock_item`.`id`
`zra_save_stock_item`.`tpin`
`zra_save_stock_item`.`bhfId`
`zra_save_stock_item`.`sarNo`
`zra_save_stock_item`.`sarTyCd`
`zra_save_stock_item`.`orgSarNo`
`zra_save_stock_item`.`regTyCd`
`zra_save_stock_item`.`custTpin`
`zra_save_stock_item`.`custNm`
`zra_save_stock_item`.`custBhfId`
`zra_save_stock_item`.`ocrnDt`
`zra_save_stock_item`.`totItemCnt`
`zra_save_stock_item`.`totTaxblAmt`
`zra_save_stock_item`.`totTaxAmt`
`zra_save_stock_item`.`totAmount`
`zra_save_stock_item`.`remark`
`zra_save_stock_item`.`regrId`
`zra_save_stock_item`.`regrNm`
`zra_save_stock_item`.`modrNm`
`zra_save_stock_item`.`modrId`
`zra_save_stock_item`.`itemSeq`
`zra_save_stock_item`.`itemNm`
`zra_save_stock_item`.`itemCd`
`zra_save_stock_item`.`itemClsCd`
`zra_save_stock_item`.`pkgUnitCd`
`zra_save_stock_item`.`vatCatCd`
`zra_save_stock_item`.`qtyUnitCd`
`zra_save_stock_item`.`pkg`
`zra_save_stock_item`.`qty`
`zra_save_stock_item`.`prc`
`zra_save_stock_item`.`splyAmt`
`zra_save_stock_item`.`totDcAmt`
`zra_save_stock_item`.`taxAmt`
`zra_save_stock_item`.`taxblAmt`
`zra_save_stock_item`.`totAmt`
`zra_stock_master`.*
`zra_stock_master`.`id`
`zra_stock_master`.`tpin`
`zra_stock_master`.`bhfId`
`zra_stock_master`.`regrId`
`zra_stock_master`.`regrNm`
`zra_stock_master`.`modrNm`
`zra_stock_master`.`modrId`
`zra_stock_master`.`itemCd`
`zra_stock_master`.`rsdQty`
`zra_stock_master`.`Modification_date`
`cart`.*
`cart`.`id`
`cart`.`user_id`
`cart`.`pid`
`cart`.`name`
`cart`.`price`
`cart`.`quantity`
`cart`.`image`
`company_credentials`.*
`company_credentials`.`id`
`company_credentials`.`company`
`company_credentials`.`tpin`
`company_credentials`.`branch`
`company_credentials`.`address`
`logs`.*
`logs`.`id`
`logs`.`url`
`logs`.`response_code`
`logs`.`response_message`
`logs`.`last_retrieved`
`logs`.`timestamp`
`logs`.`status`
`message`.*
`message`.`id`
`message`.`user_id`
`message`.`name`
`message`.`email`
`message`.`number`
`message`.`message`
`notice`.*
`notice`.`id`
`notice`.`page_name`
`notice`.`function_name`
`notice`.`message`
`notice`.`timestamp`
`orders`.*
`orders`.`id`
`orders`.`user_id`
`orders`.`name`
`orders`.`number`
`orders`.`email`
`orders`.`method`
`orders`.`address`
`orders`.`total_products`
`orders`.`total_price`
`orders`.`placed_on`
`orders`.`payment_status`
`products`.*
`products`.`id`
`products`.`name`
`products`.`details`
`products`.`price`
`products`.`image`
`purchase_invoices`.*
`purchase_invoices`.`id`
`purchase_invoices`.`spplrTpin`
`purchase_invoices`.`spplrNm`
`purchase_invoices`.`spplrBhfId`
`purchase_invoices`.`spplrInvcNo`
`purchase_invoices`.`rcptTyCd`
`purchase_invoices`.`pmtTyCd`
`purchase_invoices`.`cfmDt`
`purchase_invoices`.`salesDt`
`purchase_invoices`.`stockRlsDt`
`purchase_invoices`.`totItemCnt`
`purchase_invoices`.`totTaxblAmt`
`purchase_invoices`.`totTaxAmt`
`purchase_invoices`.`totAmt`
`purchase_invoices`.`remark`
`purchase_items`.*
`purchase_items`.`id`
`purchase_items`.`invoice_id`
`purchase_items`.`itemSeq`
`purchase_items`.`itemCd`
`purchase_items`.`itemClsCd`
`purchase_items`.`itemNm`
`purchase_items`.`pkgUnitCd`
`purchase_items`.`pkg`
`purchase_items`.`qtyUnitCd`
`purchase_items`.`qty`
`purchase_items`.`prc`
`purchase_items`.`splyAmt`
`purchase_items`.`dcRt`
`purchase_items`.`dcAmt`
`purchase_items`.`vatCatCd`
`purchase_items`.`vatTaxblAmt`
`purchase_items`.`vatAmt`
`purchase_items`.`totAmt`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`password`
`users`.`user_type`
`wishlist`.*
`wishlist`.`id`
`wishlist`.`user_id`
`wishlist`.`pid`
`wishlist`.`name`
`wishlist`.`price`
`wishlist`.`image`
`zra_codes`.*
`zra_codes`.`id`
`zra_codes`.`cdCls`
`zra_codes`.`cdClsNm`
`zra_codes`.`userDfnNm1`
`zra_codes`.`cd`
`zra_codes`.`cdNm`
`zra_codes`.`userDfnCd1`
`zra_credentials`.*
`zra_credentials`.`id`
`zra_credentials`.`tin`
`zra_credentials`.`taxprNm`
`zra_credentials`.`bsnsActv`
`zra_credentials`.`bhfId`
`zra_credentials`.`bhfNm`
`zra_credentials`.`bhfOpenDt`
`zra_credentials`.`prvncNm`
`zra_credentials`.`dstrtNm`
`zra_credentials`.`sctrNm`
`zra_credentials`.`locDesc`
`zra_credentials`.`hqYn`
`zra_credentials`.`mgrNm`
`zra_credentials`.`mgrTelNo`
`zra_credentials`.`mgrEmail`
`zra_credentials`.`sdcId`
`zra_credentials`.`mrcNo`
`zra_credentials`.`lastPchsInvcNo`
`zra_credentials`.`lastSaleRcptNo`
`zra_credentials`.`lastInvcNo`
`zra_credentials`.`lastSaleInvcNo`
`zra_credentials`.`lastTrainInvcNo`
`zra_credentials`.`lastProfrmInvcNo`
`zra_credentials`.`lastCopyInvcNo`
`zra_credentials`.`status`
`zra_customer`.*
`zra_customer`.`id`
`zra_customer`.`tpin`
`zra_customer`.`bhfId`
`zra_customer`.`custNo`
`zra_customer`.`custTpin`
`zra_customer`.`custNm`
`zra_customer`.`adrs`
`zra_customer`.`email`
`zra_customer`.`faxNo`
`zra_customer`.`useYn`
`zra_customer`.`remark`
`zra_customer`.`regrNm`
`zra_customer`.`regrId`
`zra_customer`.`modrNm`
`zra_customer`.`modrId`
`zra_imported_items`.*
`zra_imported_items`.`id`
`zra_imported_items`.`resultDt`
`zra_imported_items`.`taskCd`
`zra_imported_items`.`dclDe`
`zra_imported_items`.`itemSeq`
`zra_imported_items`.`dclNo`
`zra_imported_items`.`hsCd`
`zra_imported_items`.`itemNm`
`zra_imported_items`.`imptItemsttsCd`
`zra_imported_items`.`orgnNatCd`
`zra_imported_items`.`exptNatCd`
`zra_imported_items`.`pkg`
`zra_imported_items`.`pkgUnitCd`
`zra_imported_items`.`qty`
`zra_imported_items`.`qtyUnitCd`
`zra_imported_items`.`totWt`
`zra_imported_items`.`netWt`
`zra_imported_items`.`spplrNm`
`zra_imported_items`.`agntNm`
`zra_imported_items`.`invcFcurAmt`
`zra_imported_items`.`invcFcurCd`
`zra_imported_items`.`invcFcurExcrt`
`zra_imported_items`.`dclRefNum`
`zra_imported_items`.`prcd`
`zra_item`.*
`zra_item`.`id`
`zra_item`.`tpin`
`zra_item`.`bhfId`
`zra_item`.`itemCd`
`zra_item`.`itemClsCd`
`zra_item`.`itemTyCd`
`zra_item`.`itemNm`
`zra_item`.`itemStdNm`
`zra_item`.`orgnNatCd`
`zra_item`.`pkgUnitCd`
`zra_item`.`qtyUnitCd`
`zra_item`.`vatCatCd`
`zra_item`.`iplCatCd`
`zra_item`.`tlCatCd`
`zra_item`.`exciseTxCatCd`
`zra_item`.`btchNo`
`zra_item`.`bcd`
`zra_item`.`dftPrc`
`zra_item`.`manufacturerTpin`
`zra_item`.`manufacturerItemCd`
`zra_item`.`rrp`
`zra_item`.`svcChargeYn`
`zra_item`.`rentalYn`
`zra_item`.`addInfo`
`zra_item`.`sftyQty`
`zra_item`.`isrcAplcbYn`
`zra_item`.`useYn`
`zra_item`.`regrNm`
`zra_item`.`regrId`
`zra_item`.`modrNm`
`zra_item`.`modrId`
`zra_item_class`.*
`zra_item_class`.`id`
`zra_item_class`.`itemClsCd`
`zra_item_class`.`itemClsNm`
`zra_item_class`.`itemClsLvl`
`zra_item_class`.`taxTyCd`
`zra_item_class`.`mjrTgYn`
`zra_item_class`.`useYn`
`zra_normal_sales_invoice`.*
`zra_normal_sales_invoice`.`id`
`zra_normal_sales_invoice`.`tpin`
`zra_normal_sales_invoice`.`bhfId`
`zra_normal_sales_invoice`.`refInvcNo`
`zra_normal_sales_invoice`.`orgInvcNo`
`zra_normal_sales_invoice`.`orgSdcId`
`zra_normal_sales_invoice`.`cisInvcNo`
`zra_normal_sales_invoice`.`custTpin`
`zra_normal_sales_invoice`.`custNm`
`zra_normal_sales_invoice`.`salesTyCd`
`zra_normal_sales_invoice`.`rcptTyCd`
`zra_normal_sales_invoice`.`pmtTyCd`
`zra_normal_sales_invoice`.`salesSttsCd`
`zra_normal_sales_invoice`.`cfmDt`
`zra_normal_sales_invoice`.`salesDt`
`zra_normal_sales_invoice`.`stockRlsDt`
`zra_normal_sales_invoice`.`cnclReqDt`
`zra_normal_sales_invoice`.`cnclDt`
`zra_normal_sales_invoice`.`rfdDt`
`zra_normal_sales_invoice`.`rfdRsnCd`
`zra_normal_sales_invoice`.`taxblAmtA`
`zra_normal_sales_invoice`.`taxblAmtB`
`zra_normal_sales_invoice`.`taxblAmtC1`
`zra_normal_sales_invoice`.`taxblAmtC2`
`zra_normal_sales_invoice`.`taxblAmtC3`
`zra_normal_sales_invoice`.`taxblAmtD`
`zra_normal_sales_invoice`.`taxblAmtRvat`
`zra_normal_sales_invoice`.`taxblAmtE`
`zra_normal_sales_invoice`.`taxblAmtF`
`zra_normal_sales_invoice`.`taxblAmtIpl1`
`zra_normal_sales_invoice`.`taxblAmtIpl2`
`zra_normal_sales_invoice`.`taxblAmtTl`
`zra_normal_sales_invoice`.`taxblAmtEcm`
`zra_normal_sales_invoice`.`taxblAmtExeeg`
`zra_normal_sales_invoice`.`taxblAmtTot`
`zra_normal_sales_invoice`.`taxAmtA`
`zra_normal_sales_invoice`.`taxAmtB`
`zra_normal_sales_invoice`.`taxAmtC1`
`zra_normal_sales_invoice`.`taxAmtC2`
`zra_normal_sales_invoice`.`taxAmtC3`
`zra_normal_sales_invoice`.`taxAmtD`
`zra_normal_sales_invoice`.`taxAmtRvat`
`zra_normal_sales_invoice`.`taxAmtE`
`zra_normal_sales_invoice`.`taxAmtF`
`zra_normal_sales_invoice`.`taxAmtIpl1`
`zra_normal_sales_invoice`.`taxAmtIpl2`
`zra_normal_sales_invoice`.`taxAmtTl`
`zra_normal_sales_invoice`.`taxAmtEcm`
`zra_normal_sales_invoice`.`taxAmtExeeg`
`zra_normal_sales_invoice`.`taxAmtTot`
`zra_normal_sales_invoice`.`taxRtA`
`zra_normal_sales_invoice`.`taxRtB`
`zra_normal_sales_invoice`.`taxRtC1`
`zra_normal_sales_invoice`.`taxRtC2`
`zra_normal_sales_invoice`.`taxRtC3`
`zra_normal_sales_invoice`.`taxRtD`
`zra_normal_sales_invoice`.`tlAmt`
`zra_normal_sales_invoice`.`taxRtRvat`
`zra_normal_sales_invoice`.`taxRtE`
`zra_normal_sales_invoice`.`taxRtF`
`zra_normal_sales_invoice`.`taxRtIpl1`
`zra_normal_sales_invoice`.`taxRtIpl2`
`zra_normal_sales_invoice`.`taxRtTl`
`zra_normal_sales_invoice`.`taxRtEcm`
`zra_normal_sales_invoice`.`taxRtExeeg`
`zra_normal_sales_invoice`.`taxRtTot`
`zra_normal_sales_invoice`.`totItemCnt`
`zra_normal_sales_invoice`.`totTaxblAmt`
`zra_normal_sales_invoice`.`totTaxAmt`
`zra_normal_sales_invoice`.`totAmt`
`zra_normal_sales_invoice`.`cashDcRt`
`zra_normal_sales_invoice`.`cashDcAmt`
`zra_normal_sales_invoice`.`remark`
`zra_normal_sales_invoice`.`regrId`
`zra_normal_sales_invoice`.`regrNm`
`zra_normal_sales_invoice`.`modrId`
`zra_normal_sales_invoice`.`modrNm`
`zra_normal_sales_invoice`.`prchrAcptcYn`
`zra_normal_sales_invoice`.`saleCtyCd`
`zra_normal_sales_invoice`.`lpoNumber`
`zra_normal_sales_invoice`.`invcAdjustReason`
`zra_normal_sales_invoice`.`dbtRsnCd`
`zra_normal_sales_invoice`.`currencyTyCd`
`zra_normal_sales_invoice`.`exchangeRt`
`zra_normal_sales_invoice`.`destnCountryCd`
`zra_normal_sales_invoice`.`prcd`
`zra_normal_sales_invoice`.`prnt`
`zra_normal_sales_invoice`.`rcptNo`
`zra_normal_sales_invoice`.`intrlData`
`zra_normal_sales_invoice`.`rcptSign`
`zra_normal_sales_invoice`.`vsdcRcptPbctDate`
`zra_normal_sales_invoice`.`sdcId`
`zra_normal_sales_invoice`.`mrcNo`
`zra_normal_sales_invoice`.`qrCodeUrl`
`zra_normal_sales_invoice_items`.*
`zra_normal_sales_invoice_items`.`id`
`zra_normal_sales_invoice_items`.`invoiceId`
`zra_normal_sales_invoice_items`.`itemSeq`
`zra_normal_sales_invoice_items`.`itemCd`
`zra_normal_sales_invoice_items`.`itemClsCd`
`zra_normal_sales_invoice_items`.`itemNm`
`zra_normal_sales_invoice_items`.`bcd`
`zra_normal_sales_invoice_items`.`pkgUnitCd`
`zra_normal_sales_invoice_items`.`pkg`
`zra_normal_sales_invoice_items`.`qtyUnitCd`
`zra_normal_sales_invoice_items`.`qty`
`zra_normal_sales_invoice_items`.`prc`
`zra_normal_sales_invoice_items`.`splyAmt`
`zra_normal_sales_invoice_items`.`dcRt`
`zra_normal_sales_invoice_items`.`dcAmt`
`zra_normal_sales_invoice_items`.`isrccCd`
`zra_normal_sales_invoice_items`.`isrccNm`
`zra_normal_sales_invoice_items`.`isrcRt`
`zra_normal_sales_invoice_items`.`isrcAmt`
`zra_normal_sales_invoice_items`.`vatCatCd`
`zra_normal_sales_invoice_items`.`exciseTxCatCd`
`zra_normal_sales_invoice_items`.`tlCatCd`
`zra_normal_sales_invoice_items`.`iplCatCd`
`zra_normal_sales_invoice_items`.`vatTaxblAmt`
`zra_normal_sales_invoice_items`.`vatAmt`
`zra_normal_sales_invoice_items`.`exciseTaxblAmt`
`zra_normal_sales_invoice_items`.`tlTaxblAmt`
`zra_normal_sales_invoice_items`.`iplTaxblAmt`
`zra_normal_sales_invoice_items`.`iplAmt`
`zra_normal_sales_invoice_items`.`tlAmt`
`zra_normal_sales_invoice_items`.`exciseTxAmt`
`zra_normal_sales_invoice_items`.`totAmt`
`zra_purchase_invoice`.*
`zra_purchase_invoice`.`id`
`zra_purchase_invoice`.`tpin`
`zra_purchase_invoice`.`bhfId`
`zra_purchase_invoice`.`refInvcNo`
`zra_purchase_invoice`.`orgInvcNo`
`zra_purchase_invoice`.`orgSdcId`
`zra_purchase_invoice`.`cisInvcNo`
`zra_purchase_invoice`.`spplrTpin`
`zra_purchase_invoice`.`spplrBhfId`
`zra_purchase_invoice`.`spplrNm`
`zra_purchase_invoice`.`spplrInvcNo`
`zra_purchase_invoice`.`regTyCd`
`zra_purchase_invoice`.`pchsTyCd`
`zra_purchase_invoice`.`rcptTyCd`
`zra_purchase_invoice`.`pmtTyCd`
`zra_purchase_invoice`.`pchsSttsCd`
`zra_purchase_invoice`.`cfmDt`
`zra_purchase_invoice`.`pchsDt`
`zra_purchase_invoice`.`cnclReqDt`
`zra_purchase_invoice`.`cnclDt`
`zra_purchase_invoice`.`taxblAmtA`
`zra_purchase_invoice`.`taxblAmtB`
`zra_purchase_invoice`.`taxblAmtC1`
`zra_purchase_invoice`.`taxblAmtC2`
`zra_purchase_invoice`.`taxblAmtC3`
`zra_purchase_invoice`.`taxblAmtD`
`zra_purchase_invoice`.`taxblAmtRvat`
`zra_purchase_invoice`.`taxblAmtE`
`zra_purchase_invoice`.`taxblAmtF`
`zra_purchase_invoice`.`taxblAmtIpl1`
`zra_purchase_invoice`.`taxblAmtIpl2`
`zra_purchase_invoice`.`taxblAmtTl`
`zra_purchase_invoice`.`taxblAmtEcm`
`zra_purchase_invoice`.`taxblAmtExeeg`
`zra_purchase_invoice`.`taxblAmtTot`
`zra_purchase_invoice`.`taxAmtA`
`zra_purchase_invoice`.`taxAmtB`
`zra_purchase_invoice`.`taxAmtC1`
`zra_purchase_invoice`.`taxAmtC2`
`zra_purchase_invoice`.`taxAmtC3`
`zra_purchase_invoice`.`taxAmtD`
`zra_purchase_invoice`.`taxAmtRvat`
`zra_purchase_invoice`.`taxAmtE`
`zra_purchase_invoice`.`taxAmtF`
`zra_purchase_invoice`.`taxAmtIpl1`
`zra_purchase_invoice`.`taxAmtIpl2`
`zra_purchase_invoice`.`taxAmtTl`
`zra_purchase_invoice`.`taxAmtEcm`
`zra_purchase_invoice`.`taxAmtExeeg`
`zra_purchase_invoice`.`taxAmtTot`
`zra_purchase_invoice`.`taxRtA`
`zra_purchase_invoice`.`taxRtB`
`zra_purchase_invoice`.`taxRtC1`
`zra_purchase_invoice`.`taxRtC2`
`zra_purchase_invoice`.`taxRtC3`
`zra_purchase_invoice`.`taxRtD`
`zra_purchase_invoice`.`tlAmt`
`zra_purchase_invoice`.`taxRtRvat`
`zra_purchase_invoice`.`taxRtE`
`zra_purchase_invoice`.`taxRtF`
`zra_purchase_invoice`.`taxRtIpl1`
`zra_purchase_invoice`.`taxRtIpl2`
`zra_purchase_invoice`.`taxRtTl`
`zra_purchase_invoice`.`taxRtEcm`
`zra_purchase_invoice`.`taxRtExeeg`
`zra_purchase_invoice`.`taxRtTot`
`zra_purchase_invoice`.`totItemCnt`
`zra_purchase_invoice`.`totTaxblAmt`
`zra_purchase_invoice`.`totTaxAmt`
`zra_purchase_invoice`.`totAmt`
`zra_purchase_invoice`.`remark`
`zra_purchase_invoice`.`regrId`
`zra_purchase_invoice`.`regrNm`
`zra_purchase_invoice`.`modrId`
`zra_purchase_invoice`.`modrNm`
`zra_purchase_invoice`.`prcd`
`zra_purchase_invoice`.`prnt`
`zra_purchase_invoice`.`rcptNo`
`zra_purchase_invoice`.`intrlData`
`zra_purchase_invoice`.`rcptSign`
`zra_purchase_invoice`.`vsdcRcptPbctDate`
`zra_purchase_invoice`.`sdcId`
`zra_purchase_invoice`.`mrcNo`
`zra_purchase_invoice`.`qrCodeUrl`
`zra_purchase_invoice_items`.*
`zra_purchase_invoice_items`.`id`
`zra_purchase_invoice_items`.`invoiceId`
`zra_purchase_invoice_items`.`itemSeq`
`zra_purchase_invoice_items`.`itemCd`
`zra_purchase_invoice_items`.`itemClsCd`
`zra_purchase_invoice_items`.`itemNm`
`zra_purchase_invoice_items`.`bcd`
`zra_purchase_invoice_items`.`pkgUnitCd`
`zra_purchase_invoice_items`.`pkg`
`zra_purchase_invoice_items`.`qtyUnitCd`
`zra_purchase_invoice_items`.`qty`
`zra_purchase_invoice_items`.`prc`
`zra_purchase_invoice_items`.`splyAmt`
`zra_purchase_invoice_items`.`dcRt`
`zra_purchase_invoice_items`.`dcAmt`
`zra_purchase_invoice_items`.`isrccCd`
`zra_purchase_invoice_items`.`isrccNm`
`zra_purchase_invoice_items`.`isrcRt`
`zra_purchase_invoice_items`.`isrcAmt`
`zra_purchase_invoice_items`.`vatCatCd`
`zra_purchase_invoice_items`.`exciseTxCatCd`
`zra_purchase_invoice_items`.`tlCatCd`
`zra_purchase_invoice_items`.`iplCatCd`
`zra_purchase_invoice_items`.`vatTaxblAmt`
`zra_purchase_invoice_items`.`vatAmt`
`zra_purchase_invoice_items`.`exciseTaxblAmt`
`zra_purchase_invoice_items`.`tlTaxblAmt`
`zra_purchase_invoice_items`.`iplTaxblAmt`
`zra_purchase_invoice_items`.`iplAmt`
`zra_purchase_invoice_items`.`tlAmt`
`zra_purchase_invoice_items`.`exciseTxAmt`
`zra_purchase_invoice_items`.`totAmt`
`zra_save_stock_item`.*
`zra_save_stock_item`.`id`
`zra_save_stock_item`.`tpin`
`zra_save_stock_item`.`bhfId`
`zra_save_stock_item`.`sarNo`
`zra_save_stock_item`.`sarTyCd`
`zra_save_stock_item`.`orgSarNo`
`zra_save_stock_item`.`regTyCd`
`zra_save_stock_item`.`custTpin`
`zra_save_stock_item`.`custNm`
`zra_save_stock_item`.`custBhfId`
`zra_save_stock_item`.`ocrnDt`
`zra_save_stock_item`.`totItemCnt`
`zra_save_stock_item`.`totTaxblAmt`
`zra_save_stock_item`.`totTaxAmt`
`zra_save_stock_item`.`totAmount`
`zra_save_stock_item`.`remark`
`zra_save_stock_item`.`regrId`
`zra_save_stock_item`.`regrNm`
`zra_save_stock_item`.`modrNm`
`zra_save_stock_item`.`modrId`
`zra_save_stock_item`.`itemSeq`
`zra_save_stock_item`.`itemNm`
`zra_save_stock_item`.`itemCd`
`zra_save_stock_item`.`itemClsCd`
`zra_save_stock_item`.`pkgUnitCd`
`zra_save_stock_item`.`vatCatCd`
`zra_save_stock_item`.`qtyUnitCd`
`zra_save_stock_item`.`pkg`
`zra_save_stock_item`.`qty`
`zra_save_stock_item`.`prc`
`zra_save_stock_item`.`splyAmt`
`zra_save_stock_item`.`totDcAmt`
`zra_save_stock_item`.`taxAmt`
`zra_save_stock_item`.`taxblAmt`
`zra_save_stock_item`.`totAmt`
`zra_stock_master`.*
`zra_stock_master`.`id`
`zra_stock_master`.`tpin`
`zra_stock_master`.`bhfId`
`zra_stock_master`.`regrId`
`zra_stock_master`.`regrNm`
`zra_stock_master`.`modrNm`
`zra_stock_master`.`modrId`
`zra_stock_master`.`itemCd`
`zra_stock_master`.`rsdQty`
`zra_stock_master`.`Modification_date`
`cart`.*
`cart`.`id`
`cart`.`user_id`
`cart`.`pid`
`cart`.`name`
`cart`.`price`
`cart`.`quantity`
`cart`.`image`
`company_credentials`.*
`company_credentials`.`id`
`company_credentials`.`company`
`company_credentials`.`tpin`
`company_credentials`.`branch`
`company_credentials`.`address`
`logs`.*
`logs`.`id`
`logs`.`url`
`logs`.`response_code`
`logs`.`response_message`
`logs`.`last_retrieved`
`logs`.`timestamp`
`logs`.`status`
`message`.*
`message`.`id`
`message`.`user_id`
`message`.`name`
`message`.`email`
`message`.`number`
`message`.`message`
`notice`.*
`notice`.`id`
`notice`.`page_name`
`notice`.`function_name`
`notice`.`message`
`notice`.`timestamp`
`orders`.*
`orders`.`id`
`orders`.`user_id`
`orders`.`name`
`orders`.`number`
`orders`.`email`
`orders`.`method`
`orders`.`address`
`orders`.`total_products`
`orders`.`total_price`
`orders`.`placed_on`
`orders`.`payment_status`
`products`.*
`products`.`id`
`products`.`name`
`products`.`details`
`products`.`price`
`products`.`image`
`purchase_invoices`.*
`purchase_invoices`.`id`
`purchase_invoices`.`spplrTpin`
`purchase_invoices`.`spplrNm`
`purchase_invoices`.`spplrBhfId`
`purchase_invoices`.`spplrInvcNo`
`purchase_invoices`.`rcptTyCd`
`purchase_invoices`.`pmtTyCd`
`purchase_invoices`.`cfmDt`
`purchase_invoices`.`salesDt`
`purchase_invoices`.`stockRlsDt`
`purchase_invoices`.`totItemCnt`
`purchase_invoices`.`totTaxblAmt`
`purchase_invoices`.`totTaxAmt`
`purchase_invoices`.`totAmt`
`purchase_invoices`.`remark`
`purchase_items`.*
`purchase_items`.`id`
`purchase_items`.`invoice_id`
`purchase_items`.`itemSeq`
`purchase_items`.`itemCd`
`purchase_items`.`itemClsCd`
`purchase_items`.`itemNm`
`purchase_items`.`pkgUnitCd`
`purchase_items`.`pkg`
`purchase_items`.`qtyUnitCd`
`purchase_items`.`qty`
`purchase_items`.`prc`
`purchase_items`.`splyAmt`
`purchase_items`.`dcRt`
`purchase_items`.`dcAmt`
`purchase_items`.`vatCatCd`
`purchase_items`.`vatTaxblAmt`
`purchase_items`.`vatAmt`
`purchase_items`.`totAmt`
`users`.*
`users`.`id`
`users`.`name`
`users`.`email`
`users`.`password`
`users`.`user_type`
`wishlist`.*
`wishlist`.`id`
`wishlist`.`user_id`
`wishlist`.`pid`
`wishlist`.`name`
`wishlist`.`price`
`wishlist`.`image`
`zra_codes`.*
`zra_codes`.`id`
`zra_codes`.`cdCls`
`zra_codes`.`cdClsNm`
`zra_codes`.`userDfnNm1`
`zra_codes`.`cd`
`zra_codes`.`cdNm`
`zra_codes`.`userDfnCd1`
`zra_credentials`.*
`zra_credentials`.`id`
`zra_credentials`.`tin`
`zra_credentials`.`taxprNm`
`zra_credentials`.`bsnsActv`
`zra_credentials`.`bhfId`
`zra_credentials`.`bhfNm`
`zra_credentials`.`bhfOpenDt`
`zra_credentials`.`prvncNm`
`zra_credentials`.`dstrtNm`
`zra_credentials`.`sctrNm`
`zra_credentials`.`locDesc`
`zra_credentials`.`hqYn`
`zra_credentials`.`mgrNm`
`zra_credentials`.`mgrTelNo`
`zra_credentials`.`mgrEmail`
`zra_credentials`.`sdcId`
`zra_credentials`.`mrcNo`
`zra_credentials`.`lastPchsInvcNo`
`zra_credentials`.`lastSaleRcptNo`
`zra_credentials`.`lastInvcNo`
`zra_credentials`.`lastSaleInvcNo`
`zra_credentials`.`lastTrainInvcNo`
`zra_credentials`.`lastProfrmInvcNo`
`zra_credentials`.`lastCopyInvcNo`
`zra_credentials`.`status`
`zra_customer`.*
`zra_customer`.`id`
`zra_customer`.`tpin`
`zra_customer`.`bhfId`
`zra_customer`.`custNo`
`zra_customer`.`custTpin`
`zra_customer`.`custNm`
`zra_customer`.`adrs`
`zra_customer`.`email`
`zra_customer`.`faxNo`
`zra_customer`.`useYn`
`zra_customer`.`remark`
`zra_customer`.`regrNm`
`zra_customer`.`regrId`
`zra_customer`.`modrNm`
`zra_customer`.`modrId`
`zra_imported_items`.*
`zra_imported_items`.`id`
`zra_imported_items`.`resultDt`
`zra_imported_items`.`taskCd`
`zra_imported_items`.`dclDe`
`zra_imported_items`.`itemSeq`
`zra_imported_items`.`dclNo`
`zra_imported_items`.`hsCd`
`zra_imported_items`.`itemNm`
`zra_imported_items`.`imptItemsttsCd`
`zra_imported_items`.`orgnNatCd`
`zra_imported_items`.`exptNatCd`
`zra_imported_items`.`pkg`
`zra_imported_items`.`pkgUnitCd`
`zra_imported_items`.`qty`
`zra_imported_items`.`qtyUnitCd`
`zra_imported_items`.`totWt`
`zra_imported_items`.`netWt`
`zra_imported_items`.`spplrNm`
`zra_imported_items`.`agntNm`
`zra_imported_items`.`invcFcurAmt`
`zra_imported_items`.`invcFcurCd`
`zra_imported_items`.`invcFcurExcrt`
`zra_imported_items`.`dclRefNum`
`zra_imported_items`.`prcd`
`zra_item`.*
`zra_item`.`id`
`zra_item`.`tpin`
`zra_item`.`bhfId`
`zra_item`.`itemCd`
`zra_item`.`itemClsCd`
`zra_item`.`itemTyCd`
`zra_item`.`itemNm`
`zra_item`.`itemStdNm`
`zra_item`.`orgnNatCd`
`zra_item`.`pkgUnitCd`
`zra_item`.`qtyUnitCd`
`zra_item`.`vatCatCd`
`zra_item`.`iplCatCd`
`zra_item`.`tlCatCd`
`zra_item`.`exciseTxCatCd`
`zra_item`.`btchNo`
`zra_item`.`bcd`
`zra_item`.`dftPrc`
`zra_item`.`manufacturerTpin`
`zra_item`.`manufacturerItemCd`
`zra_item`.`rrp`
`zra_item`.`svcChargeYn`
`zra_item`.`rentalYn`
`zra_item`.`addInfo`
`zra_item`.`sftyQty`
`zra_item`.`isrcAplcbYn`
`zra_item`.`useYn`
`zra_item`.`regrNm`
`zra_item`.`regrId`
`zra_item`.`modrNm`
`zra_item`.`modrId`
`zra_item_class`.*
`zra_item_class`.`id`
`zra_item_class`.`itemClsCd`
`zra_item_class`.`itemClsNm`
`zra_item_class`.`itemClsLvl`
`zra_item_class`.`taxTyCd`
`zra_item_class`.`mjrTgYn`
`zra_item_class`.`useYn`
`zra_normal_sales_invoice`.*
`zra_normal_sales_invoice`.`id`
`zra_normal_sales_invoice`.`tpin`
`zra_normal_sales_invoice`.`bhfId`
`zra_normal_sales_invoice`.`refInvcNo`
`zra_normal_sales_invoice`.`orgInvcNo`
`zra_normal_sales_invoice`.`orgSdcId`
`zra_normal_sales_invoice`.`cisInvcNo`
`zra_normal_sales_invoice`.`custTpin`
`zra_normal_sales_invoice`.`custNm`
`zra_normal_sales_invoice`.`salesTyCd`
`zra_normal_sales_invoice`.`rcptTyCd`
`zra_normal_sales_invoice`.`pmtTyCd`
`zra_normal_sales_invoice`.`salesSttsCd`
`zra_normal_sales_invoice`.`cfmDt`
`zra_normal_sales_invoice`.`salesDt`
`zra_normal_sales_invoice`.`stockRlsDt`
`zra_normal_sales_invoice`.`cnclReqDt`
`zra_normal_sales_invoice`.`cnclDt`
`zra_normal_sales_invoice`.`rfdDt`
`zra_normal_sales_invoice`.`rfdRsnCd`
`zra_normal_sales_invoice`.`taxblAmtA`
`zra_normal_sales_invoice`.`taxblAmtB`
`zra_normal_sales_invoice`.`taxblAmtC1`
`zra_normal_sales_invoice`.`taxblAmtC2`
`zra_normal_sales_invoice`.`taxblAmtC3`
`zra_normal_sales_invoice`.`taxblAmtD`
`zra_normal_sales_invoice`.`taxblAmtRvat`
`zra_normal_sales_invoice`.`taxblAmtE`
`zra_normal_sales_invoice`.`taxblAmtF`
`zra_normal_sales_invoice`.`taxblAmtIpl1`
`zra_normal_sales_invoice`.`taxblAmtIpl2`
`zra_normal_sales_invoice`.`taxblAmtTl`
`zra_normal_sales_invoice`.`taxblAmtEcm`
`zra_normal_sales_invoice`.`taxblAmtExeeg`
`zra_normal_sales_invoice`.`taxblAmtTot`
`zra_normal_sales_invoice`.`taxAmtA`
`zra_normal_sales_invoice`.`taxAmtB`
`zra_normal_sales_invoice`.`taxAmtC1`
`zra_normal_sales_invoice`.`taxAmtC2`
`zra_normal_sales_invoice`.`taxAmtC3`
`zra_normal_sales_invoice`.`taxAmtD`
`zra_normal_sales_invoice`.`taxAmtRvat`
`zra_normal_sales_invoice`.`taxAmtE`
`zra_normal_sales_invoice`.`taxAmtF`
`zra_normal_sales_invoice`.`taxAmtIpl1`
`zra_normal_sales_invoice`.`taxAmtIpl2`
`zra_normal_sales_invoice`.`taxAmtTl`
`zra_normal_sales_invoice`.`taxAmtEcm`
`zra_normal_sales_invoice`.`taxAmtExeeg`
`zra_normal_sales_invoice`.`taxAmtTot`
`zra_normal_sales_invoice`.`taxRtA`
`zra_normal_sales_invoice`.`taxRtB`
`zra_normal_sales_invoice`.`taxRtC1`
`zra_normal_sales_invoice`.`taxRtC2`
`zra_normal_sales_invoice`.`taxRtC3`
`zra_normal_sales_invoice`.`taxRtD`
`zra_normal_sales_invoice`.`tlAmt`
`zra_normal_sales_invoice`.`taxRtRvat`
`zra_normal_sales_invoice`.`taxRtE`
`zra_normal_sales_invoice`.`taxRtF`
`zra_normal_sales_invoice`.`taxRtIpl1`
`zra_normal_sales_invoice`.`taxRtIpl2`
`zra_normal_sales_invoice`.`taxRtTl`
`zra_normal_sales_invoice`.`taxRtEcm`
`zra_normal_sales_invoice`.`taxRtExeeg`
`zra_normal_sales_invoice`.`taxRtTot`
`zra_normal_sales_invoice`.`totItemCnt`
`zra_normal_sales_invoice`.`totTaxblAmt`
`zra_normal_sales_invoice`.`totTaxAmt`
`zra_normal_sales_invoice`.`totAmt`
`zra_normal_sales_invoice`.`cashDcRt`
`zra_normal_sales_invoice`.`cashDcAmt`
`zra_normal_sales_invoice`.`remark`
`zra_normal_sales_invoice`.`regrId`
`zra_normal_sales_invoice`.`regrNm`
`zra_normal_sales_invoice`.`modrId`
`zra_normal_sales_invoice`.`modrNm`
`zra_normal_sales_invoice`.`prchrAcptcYn`
`zra_normal_sales_invoice`.`saleCtyCd`
`zra_normal_sales_invoice`.`lpoNumber`
`zra_normal_sales_invoice`.`invcAdjustReason`
`zra_normal_sales_invoice`.`dbtRsnCd`
`zra_normal_sales_invoice`.`currencyTyCd`
`zra_normal_sales_invoice`.`exchangeRt`
`zra_normal_sales_invoice`.`destnCountryCd`
`zra_normal_sales_invoice`.`prcd`
`zra_normal_sales_invoice`.`prnt`
`zra_normal_sales_invoice`.`rcptNo`
`zra_normal_sales_invoice`.`intrlData`
`zra_normal_sales_invoice`.`rcptSign`
`zra_normal_sales_invoice`.`vsdcRcptPbctDate`
`zra_normal_sales_invoice`.`sdcId`
`zra_normal_sales_invoice`.`mrcNo`
`zra_normal_sales_invoice`.`qrCodeUrl`
`zra_normal_sales_invoice_items`.*
`zra_normal_sales_invoice_items`.`id`
`zra_normal_sales_invoice_items`.`invoiceId`
`zra_normal_sales_invoice_items`.`itemSeq`
`zra_normal_sales_invoice_items`.`itemCd`
`zra_normal_sales_invoice_items`.`itemClsCd`
`zra_normal_sales_invoice_items`.`itemNm`
`zra_normal_sales_invoice_items`.`bcd`
`zra_normal_sales_invoice_items`.`pkgUnitCd`
`zra_normal_sales_invoice_items`.`pkg`
`zra_normal_sales_invoice_items`.`qtyUnitCd`
`zra_normal_sales_invoice_items`.`qty`
`zra_normal_sales_invoice_items`.`prc`
`zra_normal_sales_invoice_items`.`splyAmt`
`zra_normal_sales_invoice_items`.`dcRt`
`zra_normal_sales_invoice_items`.`dcAmt`
`zra_normal_sales_invoice_items`.`isrccCd`
`zra_normal_sales_invoice_items`.`isrccNm`
`zra_normal_sales_invoice_items`.`isrcRt`
`zra_normal_sales_invoice_items`.`isrcAmt`
`zra_normal_sales_invoice_items`.`vatCatCd`
`zra_normal_sales_invoice_items`.`exciseTxCatCd`
`zra_normal_sales_invoice_items`.`tlCatCd`
`zra_normal_sales_invoice_items`.`iplCatCd`
`zra_normal_sales_invoice_items`.`vatTaxblAmt`
`zra_normal_sales_invoice_items`.`vatAmt`
`zra_normal_sales_invoice_items`.`exciseTaxblAmt`
`zra_normal_sales_invoice_items`.`tlTaxblAmt`
`zra_normal_sales_invoice_items`.`iplTaxblAmt`
`zra_normal_sales_invoice_items`.`iplAmt`
`zra_normal_sales_invoice_items`.`tlAmt`
`zra_normal_sales_invoice_items`.`exciseTxAmt`
`zra_normal_sales_invoice_items`.`totAmt`
`zra_purchase_invoice`.*
`zra_purchase_invoice`.`id`
`zra_purchase_invoice`.`tpin`
`zra_purchase_invoice`.`bhfId`
`zra_purchase_invoice`.`refInvcNo`
`zra_purchase_invoice`.`orgInvcNo`
`zra_purchase_invoice`.`orgSdcId`
`zra_purchase_invoice`.`cisInvcNo`
`zra_purchase_invoice`.`spplrTpin`
`zra_purchase_invoice`.`spplrBhfId`
`zra_purchase_invoice`.`spplrNm`
`zra_purchase_invoice`.`spplrInvcNo`
`zra_purchase_invoice`.`regTyCd`
`zra_purchase_invoice`.`pchsTyCd`
`zra_purchase_invoice`.`rcptTyCd`
`zra_purchase_invoice`.`pmtTyCd`
`zra_purchase_invoice`.`pchsSttsCd`
`zra_purchase_invoice`.`cfmDt`
`zra_purchase_invoice`.`pchsDt`
`zra_purchase_invoice`.`cnclReqDt`
`zra_purchase_invoice`.`cnclDt`
`zra_purchase_invoice`.`taxblAmtA`
`zra_purchase_invoice`.`taxblAmtB`
`zra_purchase_invoice`.`taxblAmtC1`
`zra_purchase_invoice`.`taxblAmtC2`
`zra_purchase_invoice`.`taxblAmtC3`
`zra_purchase_invoice`.`taxblAmtD`
`zra_purchase_invoice`.`taxblAmtRvat`
`zra_purchase_invoice`.`taxblAmtE`
`zra_purchase_invoice`.`taxblAmtF`
`zra_purchase_invoice`.`taxblAmtIpl1`
`zra_purchase_invoice`.`taxblAmtIpl2`
`zra_purchase_invoice`.`taxblAmtTl`
`zra_purchase_invoice`.`taxblAmtEcm`
`zra_purchase_invoice`.`taxblAmtExeeg`
`zra_purchase_invoice`.`taxblAmtTot`
`zra_purchase_invoice`.`taxAmtA`
`zra_purchase_invoice`.`taxAmtB`
`zra_purchase_invoice`.`taxAmtC1`
`zra_purchase_invoice`.`taxAmtC2`
`zra_purchase_invoice`.`taxAmtC3`
`zra_purchase_invoice`.`taxAmtD`
`zra_purchase_invoice`.`taxAmtRvat`
`zra_purchase_invoice`.`taxAmtE`
`zra_purchase_invoice`.`taxAmtF`
`zra_purchase_invoice`.`taxAmtIpl1`
`zra_purchase_invoice`.`taxAmtIpl2`
`zra_purchase_invoice`.`taxAmtTl`
`zra_purchase_invoice`.`taxAmtEcm`
`zra_purchase_invoice`.`taxAmtExeeg`
`zra_purchase_invoice`.`taxAmtTot`
`zra_purchase_invoice`.`taxRtA`
`zra_purchase_invoice`.`taxRtB`
`zra_purchase_invoice`.`taxRtC1`
`zra_purchase_invoice`.`taxRtC2`
`zra_purchase_invoice`.`taxRtC3`
`zra_purchase_invoice`.`taxRtD`
`zra_purchase_invoice`.`tlAmt`
`zra_purchase_invoice`.`taxRtRvat`
`zra_purchase_invoice`.`taxRtE`
`zra_purchase_invoice`.`taxRtF`
`zra_purchase_invoice`.`taxRtIpl1`
`zra_purchase_invoice`.`taxRtIpl2`
`zra_purchase_invoice`.`taxRtTl`
`zra_purchase_invoice`.`taxRtEcm`
`zra_purchase_invoice`.`taxRtExeeg`
`zra_purchase_invoice`.`taxRtTot`
`zra_purchase_invoice`.`totItemCnt`
`zra_purchase_invoice`.`totTaxblAmt`
`zra_purchase_invoice`.`totTaxAmt`
`zra_purchase_invoice`.`totAmt`
`zra_purchase_invoice`.`remark`
`zra_purchase_invoice`.`regrId`
`zra_purchase_invoice`.`regrNm`
`zra_purchase_invoice`.`modrId`
`zra_purchase_invoice`.`modrNm`
`zra_purchase_invoice`.`prcd`
`zra_purchase_invoice`.`prnt`
`zra_purchase_invoice`.`rcptNo`
`zra_purchase_invoice`.`intrlData`
`zra_purchase_invoice`.`rcptSign`
`zra_purchase_invoice`.`vsdcRcptPbctDate`
`zra_purchase_invoice`.`sdcId`
`zra_purchase_invoice`.`mrcNo`
`zra_purchase_invoice`.`qrCodeUrl`
`zra_purchase_invoice_items`.*
`zra_purchase_invoice_items`.`id`
`zra_purchase_invoice_items`.`invoiceId`
`zra_purchase_invoice_items`.`itemSeq`
`zra_purchase_invoice_items`.`itemCd`
`zra_purchase_invoice_items`.`itemClsCd`
`zra_purchase_invoice_items`.`itemNm`
`zra_purchase_invoice_items`.`bcd`
`zra_purchase_invoice_items`.`pkgUnitCd`
`zra_purchase_invoice_items`.`pkg`
`zra_purchase_invoice_items`.`qtyUnitCd`
`zra_purchase_invoice_items`.`qty`
`zra_purchase_invoice_items`.`prc`
`zra_purchase_invoice_items`.`splyAmt`
`zra_purchase_invoice_items`.`dcRt`
`zra_purchase_invoice_items`.`dcAmt`
`zra_purchase_invoice_items`.`isrccCd`
`zra_purchase_invoice_items`.`isrccNm`
`zra_purchase_invoice_items`.`isrcRt`
`zra_purchase_invoice_items`.`isrcAmt`
`zra_purchase_invoice_items`.`vatCatCd`
`zra_purchase_invoice_items`.`exciseTxCatCd`
`zra_purchase_invoice_items`.`tlCatCd`
`zra_purchase_invoice_items`.`iplCatCd`
`zra_purchase_invoice_items`.`vatTaxblAmt`
`zra_purchase_invoice_items`.`vatAmt`
`zra_purchase_invoice_items`.`exciseTaxblAmt`
`zra_purchase_invoice_items`.`tlTaxblAmt`
`zra_purchase_invoice_items`.`iplTaxblAmt`
`zra_purchase_invoice_items`.`iplAmt`
`zra_purchase_invoice_items`.`tlAmt`
`zra_purchase_invoice_items`.`exciseTxAmt`
`zra_purchase_invoice_items`.`totAmt`
`zra_save_stock_item`.*
`zra_save_stock_item`.`id`
`zra_save_stock_item`.`tpin`
`zra_save_stock_item`.`bhfId`
`zra_save_stock_item`.`sarNo`
`zra_save_stock_item`.`sarTyCd`
`zra_save_stock_item`.`orgSarNo`
`zra_save_stock_item`.`regTyCd`
`zra_save_stock_item`.`custTpin`
`zra_save_stock_item`.`custNm`
`zra_save_stock_item`.`custBhfId`
`zra_save_stock_item`.`ocrnDt`
`zra_save_stock_item`.`totItemCnt`
`zra_save_stock_item`.`totTaxblAmt`
`zra_save_stock_item`.`totTaxAmt`
`zra_save_stock_item`.`totAmount`
`zra_save_stock_item`.`remark`
`zra_save_stock_item`.`regrId`
`zra_save_stock_item`.`regrNm`
`zra_save_stock_item`.`modrNm`
`zra_save_stock_item`.`modrId`
`zra_save_stock_item`.`itemSeq`
`zra_save_stock_item`.`itemNm`
`zra_save_stock_item`.`itemCd`
`zra_save_stock_item`.`itemClsCd`
`zra_save_stock_item`.`pkgUnitCd`
`zra_save_stock_item`.`vatCatCd`
`zra_save_stock_item`.`qtyUnitCd`
`zra_save_stock_item`.`pkg`
`zra_save_stock_item`.`qty`
`zra_save_stock_item`.`prc`
`zra_save_stock_item`.`splyAmt`
`zra_save_stock_item`.`totDcAmt`
`zra_save_stock_item`.`taxAmt`
`zra_save_stock_item`.`taxblAmt`
`zra_save_stock_item`.`totAmt`
`zra_stock_master`.*
`zra_stock_master`.`id`
`zra_stock_master`.`tpin`
`zra_stock_master`.`bhfId`
`zra_stock_master`.`regrId`
`zra_stock_master`.`regrNm`
`zra_stock_master`.`modrNm`
`zra_stock_master`.`modrId`
`zra_stock_master`.`itemCd`
`zra_stock_master`.`rsdQty`
`zra_stock_master`.`Modification_date`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
cart
company_credentials
logs
message
notice
orders
products
purchase_invoices
purchase_items
users
wishlist
zra_codes
zra_credentials
zra_customer
zra_imported_items
zra_item
zra_item_class
zra_normal_sales_invoice
zra_normal_sales_invoice_items
zra_purchase_invoice
zra_purchase_invoice_items
zra_save_stock_item
zra_stock_master
SQL query on database
oapi_db
: