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

ver 4.05 Server: jcouture.net				Printed 11/26/25 14:28 Page: 1
SELECT * FROM inventory WHERE loc='234' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1215	DS2423	DS2423P	IC, 4kb w/Counter, TSOC		234		TSOC	8.23	../datasheets/DS2423	2	06009
1330	ACCELEROMETER	ADXL210EB	IC, Dual Axis Accelerometer	I2C	234	ADXL210		29.95	../datasheets/ACCELEROMETER	1	11108
1528	COMPASS	29123	Module, Compass, Hitachi		234			29.95	../datasheets/COMPASS	1	05103
1529	ACCELEROMETER	zzz	1	1	234	1	ea	1.00	../datasheets/ACCELEROMETER	1	1	1	ea
1544	TEMPHUM	zzz	Module, Temp and Humidity		234			29.95	../datasheets/TEMPHUM	1	05079
2086	USBUART	USBUART	USB to UART Bridge	USB	234	CP2102		0.00	../datasheets/USBUART	1	unk
2109	AHT10	AHT10	AHT10 Precision Temperature and Humidity	I2C	234	AHT10	module	1.57	../datasheets/AHT10	6	Temu