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# 235

ver 4.05 Server: jcouture.net				Printed 11/26/25 14:28 Page: 1
SELECT * FROM inventory WHERE loc='235' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1575	PIEZO	PE-49	Piezo		235			0.65	../datasheets/PIEZO	10	05132
1577	PIEZO	PE-36	1	1	235	1	ea	1.00	../datasheets/PIEZO	1	1	1	ea
1578	PIEZO	PE-47	Piezo Element, Mini (right size for PCB)		235			0.50	../datasheets/PIEZO	20	06043
1580	piezo	673871	Piezo Transducer, 3-8v		235			0.85	../datasheets/piezo	10	12010
2096	Buzzer Piezo		Buzzer 3.3v 10pcs		235	B written on top	ea	0.86	../datasheets/Buzzer Piezo	10	20004	AMZ