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 #2166
• Add New Item from PO# 1

ver 4.05 Server: jcouture.net				Printed 01/25/26 16:19 Page: 1
SELECT * FROM inventory WHERE description='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
1089	RJ45	115844	1	1	143	1	ea	1.00	../datasheets/RJ45	1	1	1
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
1198	WIRE	36791	1	1	wkbn	1	ea	1.00	../datasheets/WIRE	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
1295	CD4055	CD4055	1	1	106	1061	ea	1.00	Datasheet	1	1	1	ea
1309	ICM7212	ICM7212	1	1	1	1	ea	1.00	Datasheet	1	1	1	ea
1328	74175	74175	1	1	106	1061	ea	1.00	Datasheet	1	1	1	ea
1332	RC4558	251125	1	1	231	RC4558	ea	1.00	Datasheet	1	1	1	ea
1358	L4620	L4620	1	I2C	226	1	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
1494	UT188X	ILED-8	1	IR	125	1	ea	1.00	Datasheet	1	1	1	ea
1500	LED	LED	1	1	551	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
1521	SX18	zzz	1	I2C	352	1	ea	1.00	../datasheets/SX18	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
1547	USB-SD	USBwiz-OEM	1	1	273	USBwiz-OEM	ea	1.00	../datasheets/USB-SD	1	1	1	ea
1577	PIEZO	PE-36	1	1	235	1	ea	1.00	../datasheets/PIEZO	1	1	1	ea
1584	BANANNA	BPL-R	1	1	162	1	ea	1.00	../datasheets/BANANNA	1	1	1	ea

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

ver 4.05 Server: jcouture.net				Printed 01/25/26 16:19 Page: 2
SELECT * FROM inventory WHERE description='1' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1620	RA330R	1	1	1	136	898-3-330R	ea	1.00	../datasheets/RA330R	1	1	1	ea
1632	RESISTOR	660-CF1/2L104J	1	1	300	1	ea	1.00	../datasheets/RESISTOR	1	1	1	ea
1711	LLM2638	LLM2638	1	IR	125	BLU/GRE	ea	1.00	Datasheet	1	1	1	ea
1792	BLOCK	2124445	1	1	173	1	ea	1.00	../datasheets/BLOCK	1	1	1	ea
1851	LEDT10	1	1	1	224	1	ea	1.00	../datasheets/LEDT10	1	1	1
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
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
1899	1	1	1	Contact	463	1	ea	1.00	../datasheets/1	1	1	1
1927	SOIL	SOIL	1	SPI	1	1	ea	1.00	../datasheets/SOIL	1	1	1
1958	DHT11	DHT11	1	SPI	446	1	ea	1.00	Datasheet	1	1	1
1989	LED	LED	1	1	581	1	ea	1.00	Data Link	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
2053	resistor	resistor	1	1	333	1	ea	1.00	../datasheets/resistor	1	1	1
2120	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2132	1	1	1	1	1	1	ea	1.00	../datasheets/1	1	1	1	ea
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