www.kikkoman.mx / 127.0.0.1 / ksudms / deduction

Recent`ksuiso`.`ship_method`
`ksudms`.`ded_comment`
`ksuiso`.`req_type`
`phpmyadmin`.`pma__export_templates`
`ksudms`.`user`
`phpmyadmin`.`pma__navigationhiding`
`phpmyadmin`.`pma__userconfig`
`phpmyadmin`.`pma__table_info`
`ksutds`.`post_notes`
`mysql`.`time_zone`
FavoritesThere are no favorite tables.
New
cm9vdA==.ZG1zX2Rldg==cm9vdA==.ZG1zX2Rldg==0
dms_dev
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.a2lra28=cm9vdA==.a2lra28=0
kikko
cm9vdA==.a2lra29tYW5teA==cm9vdA==.a2lra29tYW5teA==0
kikkomanmx
cm9vdA==.a3N1ZG1zcm9vdA==.a3N1ZG1z0
ksudms
cm9vdA==.a3N1aXNvcm9vdA==.a3N1aXNv0
ksuiso
cm9vdA==.a3N1c3Nncm9vdA==.a3N1c3Nn0
ksussg
cm9vdA==.a3N1dGRzcm9vdA==.a3N1dGRz0
ksutds
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.cmVhZG1lX3RvX3JlY292ZXJfc3o=cm9vdA==.cmVhZG1lX3RvX3JlY292ZXJfc3o=0
readme_to_recover_sz
cm9vdA==.c2VjdXJlZF9pcA==cm9vdA==.c2VjdXJlZF9pcA==0
secured_ip
cm9vdA==.c3Rtcw==cm9vdA==.c3Rtcw==0
stms
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the 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.

Navigation tree

Customize the 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

Servers

Servers display options.

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.

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.

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-

Server: 127.0.0.1 »

Database: ksudms »

Table: deduction

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

Browse mode

Customize 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 (179330 total, Query took 0.0024 seconds.)

SELECT * FROM `deduction`

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

Filter rows:

			dedid	ded_status	ded_date	ded_amount	corpcustnum	corpcustname	ded_customer	ded_cust_name	ded_brokerid	bkr_name	slsmnid	slsmnname	ded_location	ded_reference	ded_checkno	ded_user	brk_id	brk_apprv_flag	brk_apprv_date	slsmgr	mgr_apprv_flag	mgr_apprv_date	correspondent	comments_flag	create_date	create_user	retrieved_flag	retrieved_date	retrieved_user	removed_date	removed_user
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'\'		NULL	NULL	NULL	NULL	NULL	012123	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL		0000-00-00	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000273167\'	00000273167	C	2014-04-04	1983.00	801023	WAKEFERN FOOD CORP	012274	WAKEFERN FOOD CORP	485	ESM/METRO-NY	401	CHRIS SHARP	040	000175154	2353866	LMARQUEZ	1020403485	Y	2016-02-24	csharp	Y	2016-02-26	NULL	2016-02-24	2015-04-09	Auto_KMS	Y	2016-02-26	Auto_Approve	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000273358\'	00000273358	D	2014-04-07	150.00	802001	SUPERVALU - CORPORATE	011960	SUPERVALU SHAW`S SUPERMARKETS, INC	483	ACOSTA-NEW ENGLAND	403	GEOFFREY CLAY	040	93762		LMARQUEZ	1020103991		0000-00-00	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-05-18	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000273442\'	00000273442	C	2014-04-08	339.83	801023	WAKEFERN FOOD CORP	012274	WAKEFERN FOOD CORP	485	ESM/METRO-NY	401	CHRIS SHARP	040	000175697	2355098	LMARQUEZ	1020403485	Y	2016-02-24	csharp	Y	2016-02-26	NULL	2016-02-24	2015-04-09	Auto_KMS	Y	2016-02-26	Auto_Approve	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000273556\'	00000273556	C	2014-04-12	1500.00	801028	SUPER STORE INDUSTRIES	013921	SUPER STORE INDUSTRIES	464	ACOSTA - PLEASANTON	104	JOHN STURGIS	010	RDR-3041272		LMARQUEZ	1020103991	Y	2015-06-26	NULL	Y	2015-07-07	NULL	2015-06-26	2015-04-09	Auto_KMS	Y	2015-07-07	Auto_Approve	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000273718\'	00000273718	D	2014-04-15	353.66	802008	UNITED NATURAL FOODS-UNFI	016416	UNITED NATURAL FOODS	521	NSSALES	105	SARAH HOLMES	010	01573203		CYAM	1020103991	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-04-20	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000273915\'	00000273915	D	2014-04-20	348.42	801022	ROUNDY`S INC	010475	ROUNDY`S INC	652	ACOSTA SALES- WAUKESHA	304	JOE LESLIE	030	R 0030672		LMARQUEZ	1020303000	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-05-02	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000273963\'	00000273963	D	2014-04-21	350.00	802001	SUPERVALU - CORPORATE	010366	SUPERVALU RETAIL CENTER	934	ACOSTA-SUPERVALU NE REGION	450	J. LESLIE-SUPERVALU	040	21208914	14134537	LMARQUEZ	1020103991	NULL	NULL			0000-00-00	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2016-06-08	Manu_Remove	2016-06-08	Luz
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000274201\'	00000274201	D	2014-04-29	661.79	801034	SAVE MART CORPORATE	011316	SAVE MART /LUCKY	464	ACOSTA - PLEASANTON	104	JOHN STURGIS	010	PRC20374E0114		LMARQUEZ	1020103991	Y	2015-06-02	NULL	NULL	NULL	NULL	2015-06-02	2015-04-09	Auto_KMS	Y	2015-07-30	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000274363\'	00000274363	D	2014-04-30	150.00	802001	SUPERVALU - CORPORATE	011960	SUPERVALU SHAW`S SUPERMARKETS, INC	483	ACOSTA-NEW ENGLAND	403	GEOFFREY CLAY	040	95236		LMARQUEZ	1020103991	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-05-09	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000274436\'	00000274436	D	2014-05-02	500.00	801008	NASH FINCH - CORPORATE	011411	NASH FINCH COMPANY	92	CROSSMARK-CHARLOTTE	501	BILL REESE	050	01579325		LMARQUEZ	1020503092	NULL	NULL	NULL	NULL	NULL	NULL	2015-05-06	2015-04-28	Auto_KMS	Y	2015-05-09	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000274729\'	00000274729	D	2014-05-10	150.42	803010	PFG	012035	PFG SPRINGFIELD	3	YANKEE MARKETERS	403	GEOFFREY CLAY	040	0117033		LMARQUEZ	1020403003	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-07-13	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000274918\'	00000274918	D	2014-05-12	277.41	801018	HADDON HOUSE	014825	HADDON HOUSE	485	ESM/METRO-NY	401	CHRIS SHARP	040	DM436820		LMARQUEZ	1020403485	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-07-13	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000274926\'	00000274926	C	2014-05-12	500.00	803010	PFG	011441	MIDDENDORF MEATS/PFG	487	OSAGE MARKETING	305	SEIICHI SHIMODA	030	46169-PFG	911116	LMARQUEZ	1020303487	Y	2015-09-20	sshimoda	Y	2015-09-23	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-09-23	Auto_Approve	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275410\'	00000275410	D	2014-05-20	485.00	804002	COSTCO - CORPORATE	010494	COSTCO WHOLESALE	73	ADOBE SALES - SF CLUB	104	JOHN STURGIS	010	01579542		LMARQUEZ	1020103087	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-07-09	Auto_KMS	Y	2015-07-15	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275411\'	00000275411	D	2014-05-20	5952.00	801035	DOLLAR TREE INC.	019269	DOLLAR TREE, INC	952	ACOSTA VALUE CHANNEL	403	GEOFFREY CLAY	040	01558242		LMARQUEZ	1020103991	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-05-09	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275416\'	00000275416	D	2014-05-20	100.00	016089	DORI FOODS	016089	DORI FOODS	100	INFUSION SALES GROUP-VA	402	HIDE YOSHIHASHI	040	VAR 15679	83764	LMARQUEZ	1020403997	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-11-12	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275432\'	00000275432	D	2014-05-20	1291.44	801028	SUPER STORE INDUSTRIES	013921	SUPER STORE INDUSTRIES	464	ACOSTA - PLEASANTON	104	JOHN STURGIS	010	PA1130896		LMARQUEZ	1020103991	Y	2015-06-02	NULL	NULL	NULL	NULL	2015-06-02	2015-04-09	Auto_KMS	Y	2015-07-30	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275443\'	00000275443	D	2014-05-20	187.12	801024	WINCO FOODS	012304	WINCO FOODS, INC.	465	ACOSTA	104	JOHN STURGIS	010	01574676		LMARQUEZ	1020103991	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-07-13	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275554\'	00000275554	D	2014-05-27	300.00	801034	SAVE MART CORPORATE	011316	SAVE MART /LUCKY	464	ACOSTA - PLEASANTON	104	JOHN STURGIS	010	802.2014.534		LMARQUEZ	1020103991	Y	2015-06-02	NULL	NULL	NULL	NULL	2015-06-02	2015-04-09	Auto_KMS	Y	2015-07-30	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275695\'	00000275695	D	2014-05-25	300.00	803010	PFG	012035	PFG SPRINGFIELD	3	YANKEE MARKETERS	403	GEOFFREY CLAY	040	0117687		LMARQUEZ	1020403003	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-07-13	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275835\'	00000275835	D	2014-05-28	169.68	801035	DOLLAR TREE INC.	019041	DOLLAR TREE, INC.	952	ACOSTA VALUE CHANNEL	403	GEOFFREY CLAY	040	01581828		LMARQUEZ	1020103991	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-04-20	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275875\'	00000275875	D	2014-05-30	2127.79	011568	OK GROCERY COMPANY	011568	OK GROCERY COMPANY	499	LOUIS F. LEEPER COMPANY	303	TOM DVORAK	030	01581718		LMARQUEZ	1020303499		0000-00-00	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-04-20	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000275985\'	00000275985	D	2014-06-02	513.72	801028	SUPER STORE INDUSTRIES	013921	SUPER STORE INDUSTRIES	464	ACOSTA - PLEASANTON	104	JOHN STURGIS	010	RDS-460905		LMARQUEZ	1020103991	Y	2015-06-02	NULL	NULL	NULL	NULL	2015-06-02	2015-04-09	Auto_KMS	Y	2015-07-30	Auto_Remove	NULL	NULL
Edit	Copy	Delete DELETE FROM `deduction` WHERE `deduction`.`dedid` = \'00000276039\'	00000276039	D	2014-06-03	139.92	801029	DPI CORPORATE	012857	DPI	463	ACOSTA SALES & MARKETING CO.	202	DAVID VOLLEBREGT	020	CLAWE1250257		CYAM	1020103991	NULL	NULL	NULL	NULL	NULL	NULL	0000-00-00	2015-04-09	Auto_KMS	Y	2015-04-20	Auto_Remove	NULL	NULL

Check all With selected:

Filter rows:

Query results operations