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 #2197
• Add New Item from PO# CRYSTAL

ver 4.05 Server: jcouture.net				Printed 10/29/26 21:59 Page: 1
SELECT * FROM inventory WHERE partid='CRYSTAL' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1121	CRYSTAL	14533	Crystal, 3.579545 (for DTMF Tone Generation)		574		CRYSTAL	0.59	../datasheets/CRYSTAL	5	12031	use with DTMF generator
1122	CRYSTAL	325243	Crystal, 32.768khz, 50ppm, 10.5pf, 4w, RTC		574		CRYSTAL	0.22	../datasheets/CRYSTAL	15	06077
1123	CRYSTAL	815-AB38T-32.768KHZ	Crystal, 32.768khz, 50ppm, 10.5pf, 4w, RTC		574		CRYSTAL	0.20	../datasheets/CRYSTAL	25	04060	Cookbook1-124
2069	CRYSTAL	HC-49C	Crystal, 20mhz, HC49S		574	20.000	CRYSTAL	0.05	../datasheets/CRYSTAL	20	17099
2085	CRYSTAL	crystal16	1	1	574	16.00	ea	1.00	../datasheets/CRYSTAL	1	1	1	ea