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

ver 4.05 Server: jcouture.net				Printed 05/02/26 07:41 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
1110	CONN	zzz	1	1	***	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
1184	HEADER	zzz	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
1205	WIRE	zzz	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
1300	DECODER	123748	1	1	233	HT120D	ea	1.00	../datasheets/DECODER	1	1	1	ea
1309	ICM7212	ICM7212	1	1	1	1	ea	1.00	Datasheet	1	1	1	ea
1310	MM5450	J26171	1	1	***	1	ea	1.00	Datasheet	1	1	1	ea
1327	74175	49795	1	I2C	***	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
1377	DUAL555	24328	1	1	595	1	ea	1.00	../datasheets/DUAL555	1	1	1	ea
1406	MAX232CPE	MAX232CPE	1	1	***	1	ea	1.00	../datasheets/MAX232CPE	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

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

ver 4.05 Server: jcouture.net				Printed 05/02/26 07:41 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?
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
1574	PCB	zzz	1	1	***	1	ea	1.00	../datasheets/PCB	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
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
1651	RESISTOR	107676	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
1728	DS1624	DS1624	1	I2C	***	1	ea	1.00	../datasheets/DS1624	1	1	1	ea
1792	BLOCK	2124445	1	1	173	1	ea	1.00	../datasheets/BLOCK	1	1	1	ea
1808	BC517	1	1	1	***	1	ea	1.00	../datasheets/BC517	1	1	1	ea
1815	TIP145	zzz	1	1	***	1	ea	1.00	../datasheets/TIP145	1	1	1	ea
1828	DEVKIT-SITEPLAYER	SitePlayer	1	1	book	1	ea	1.00	../datasheets/DEVKIT-SITEPLAYER	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
1929	AMP	AMP	1	1	1	1	ea	1.00	../datasheets/AMP	1	1	1

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

ver 4.05 Server: jcouture.net				Printed 05/02/26 07:41 Page: 3
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?
1958	DHT11	DHT11	1	SPI	446	1	ea	1.00	Datasheet	1	1	1
1969	DIP08	DIP08	1	1	301	1	ea	1.00	../datasheets/DIP08	1	1	1	ea
1976	DIP24	DIP24	1	1	306	1	ea	1.00	../datasheets/DIP24	1	1	1	ea
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