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

ver 4.05 Server: jcouture.net				Printed 11/26/25 13:13 Page: 1
SELECT * FROM inventory WHERE price='1' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1016	BLANK	503-41084-BWB	1	1	***	1	ea	1.00	../datasheets/BLANK	1	1	1	ea
1038	CAP	zzz	1	1	221	1	ea	1.00	../datasheets/CAP	1	1	1	ea
1064	CONN	RAD-9SL	1	1	144	1	ea	1.00	../datasheets/CONN	1	1	1	ea
1120	CONN	649-66226-008	1	1	206	1	ea	1.00	../datasheets/CONN	1	1	1	ea
1178	HEADER	517-836-03-36	1	1	***	1	ea	1.00	../datasheets/HEADER	1	1	1	ea
1204	WIRE	36855	1	1	wkbn	1	ea	1.00	../datasheets/WIRE	1	1	1	ea
1219	831	116100	1	1	999	1	ea	1.00	../datasheets/831	1	1	1	ea
1242	LM380	LM380	IC, Audio Amp, LM380, 2.5W, 10-22V		231	LM380N	DIP14	1.00	Datasheet	4	04007
1295	CD4055	CD4055	1	1	106	1061	ea	1.00	Datasheet	1	1	1	ea
1328	74175	74175	1	1	106	1061	ea	1.00	Datasheet	1	1	1	ea
1362	74174	49779	1	1W	***	1	ea	1.00	../datasheets/74174	1	1	1	ea
1369	LM	526-NTE1509	1	1W	***	LM3915	ea	1.00	../datasheets/LM	1	1	1	ea
1423	DS1307	DS1307	1	I2C	101	DS1307	ea	1.00	Datasheet	1	1	1	ea
1443	T1006MJ	T1006MJ	IC, Triac, 600V, 10A, TO-220	1	126	T1006MJ	TO220	1.00	../datasheets/T1006MJ	10	07036	1
1494	UT188X	ILED-8	1	IR	125	1	ea	1.00	Datasheet	1	1	1	ea
1513	PIC16F648	1	1	1	352	1	ea	1.00	../datasheets/PIC16F648	1	1	1	ea
1529	ACCELEROMETER	zzz	1	1	234	1	ea	1.00	../datasheets/ACCELEROMETER	1	1	1	ea
1535	LCD420	zzz	1	1	drw	1	ea	1.00	../datasheets/LCD420	1	1	1	ea
1577	PIEZO	PE-36	1	1	235	1	ea	1.00	../datasheets/PIEZO	1	1	1	ea
1585	screwdriver	127271	UPS 260W	1	bench	1	ea	1.00	../datasheets/screwdriver	1	1	1	ea
1620	RA330R	1	1	1	136	898-3-330R	ea	1.00	../datasheets/RA330R	1	1	1	ea
1674	PR15W1KR	1K-15	Resistor, Power, 15W 1KR		353	CP-15 DALE 15W	CerSand	1.00	../datasheets/PR15W1KR	10	13012	AEC	CerSand
1677	PR23W4KR	4K-23	Resistor, Power, 23W 4KR		353	RW33V402T	WireWound	1.00	../datasheets/PR23W4KR	5	13012	AEC	WireWound
1792	BLOCK	2124445	1	1	173	1	ea	1.00	../datasheets/BLOCK	1	1	1	ea
1853	MCP23017	MCP23017	1	I2C	141	MCP23017	ea	1.00	Datasheet	1	1	1	ea
1855	CD4050	CD4050	1	1	233	CD4050BE	ea	1.00	../datasheets/CD4050	1	1	1	ea

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

ver 4.05 Server: jcouture.net				Printed 11/26/25 13:13 Page: 2
SELECT * FROM inventory WHERE price='1' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1863	ESP8266	ESP8266	1	I2C	804	1	ea	1.00	../datasheets/ESP8266	1	1	1
1883	UDN2981	UDN2981	1	1	124	1	ea	1.00	Data Link	1	1	1	ea
1927	SOIL	SOIL	1	SPI	1	1	ea	1.00	../datasheets/SOIL	1	1	1
2014	sonoff	sonoff	1	WiFi	820	1	ea	1.00	../datasheets/sonoff	1	1	1
2016	1	1	1	1	1	1	ea	1.00	../datasheets/1	1	1	1
2048	JM08AD	JM08AD	1	1	133	JM08AD	ea	1.00	../datasheets/JM08AD	1	1	1	ea
2120	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2148	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2150	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2153	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2154	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1