Inventory List 4

• Main Menu
• List Purchase Orders
• Inventory
  • List Inventory, QTY>0, order by ID DESC
  • List Inventory, QTY>0 order alpha description
  • List all Inventory Items (even those with qoh of zero)
  • List Inventory w/o Photos
  • Clear Deleted Records
  • Add PO to Inventory
  • List only I2C Devices
  • List only SOIC Devices
• Parts List
• List Datasheets
• Leave Feedback
• Datasheet Catalog
• All Datasheet
• DB Instructions

• Add New Item #2163
• Add New Item from PO# 251

ver 4.05 Server: jcouture.net				Printed 11/26/25 13:13 Page: 1
SELECT * FROM inventory WHERE loc='251' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1118	USBB	2096245	Connector, USB B-type		251			0.35	../datasheets/USBB	5	12031	USB Device
1770	SWITCH	18235	Switch Grab Bag, 50 pcs		251			8.75	../datasheets/SWITCH	1	05001
1774	SWITCH	149948	Switch, Button, SPST, PCB		251			0.23	../datasheets/SWITCH	10	05076
1775	SWITCH	3833215707	Switch, DPDT		251			0.74	../datasheets/SWITCH	10	04048
1776	SWITCH	158060	Switch, DPST, Panel		251			1.05	../datasheets/SWITCH	10	05076
1777	SWITCH	LRS-25	Switch, Lighted, Round, 120AC		251			1.35	../datasheets/SWITCH	3	05132
1778	SWITCH	71597	Switch, PCB mount, SPDT		251			1.09	../datasheets/SWITCH	10	05076
1779	SWITCH	MPB-132	Switch, PCB, SPST (lot 4)		251			0.25	../datasheets/SWITCH	20	05026
1784		71597	Switch, SPDT		251			0.89	../datasheets/	10	12031
1979	SWITCH	SWITCH	Switch, DPDT Center off	1	251	blue	ea	0.90	../datasheets/SWITCH	5	16066	1
2107	2107		Switch Inline 10A		251		ea	2.00	../datasheets/2107	4	23048