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 misc='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
1044	CAP	93778	Cap, 220uF, 50V	1	200	1	1	0.15	../datasheets/CAP	10	04058	1	1
1045	CAP	zzz	Cap, 4.7uF, 50V, Radial	1	200	1	1	0.08	../datasheets/CAP	10	05026	1	1
1048	CAP	31115	Cap, 47uf, 50v	1	E--	1	1	0.06	../datasheets/CAP	200	06077	1	1
1051	CAP	134820	Cap, cerm variable	1	201	1	1	0.49	../datasheets/CAP	5	07036	1	1
1064	CONN	RAD-9SL	1	1	144	1	ea	1.00	../datasheets/CONN	1	1	1	ea
1075	CONN	DCJ-1	Connector, Jack, 2.1mm, PCB, Power	POWER	471	1	1	0.35	../datasheets/CONN	50	16071	1	1
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
1271	74151	245754	IC, Decoder, 1-8, 74ALS151N	1	593	DM74ALS151	DIP16	0.37	../datasheets/74151	2	1	1
1295	CD4055	CD4055	1	1	106	1061	ea	1.00	Datasheet	1	1	1	ea
1305	MM5450	26171	IC, Display Driver, 7seg, 8digit, 15ma, Serialin, ComAno	1	135	HE412AB	DIP40	3.95	Datasheet	5	12031	1
1309	ICM7212	ICM7212	1	1	1	1	ea	1.00	Datasheet	1	1	1	ea
1323	MC145436P	MC145436P	IC, DTMF, Decoder, Receiver, MC145436P	DTMF	232	2322	1	3.99	Datasheet	1	04059	1	1
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
1334	24C164	X24164	IC, EEPROM, 2K * 8 (16k bit)	I2C	101	X24164P	DIP08	0.25	../datasheets/24C164	10	04030	1
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
1374	MCP40101	241744	IC, MCP41010, 10K Pot, DIP8	1	593	1	DIP08	1.49	../datasheets/MCP40101	15	06077	1

• 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 misc='1' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1391	AD5220	AD5220	IC, Pot, Digital, 10k, 128 steps	SPI	134	AD5220	SOIC08	2.48	../datasheets/AD5220	2	04001	1
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
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
1585	screwdriver	127271	UPS 260W	1	bench	1	ea	1.00	../datasheets/screwdriver	1	1	1	ea
1616	RELAY	138430	Relay, SPST, w/diode, 1A, 5Vdc, EDR2D	1	236	EDR2D1A	DIP14	1.95	Data Link	10	05076	1
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
1734	shorting	152671	Shorting Blocks, Black, w/tab	1	402	1	1	0.15	../datasheets/shorting	10	12010	1	1
1780	PUSHBUTTON	1586074	Switch, PCB, Tactile Switches, .24 x .24	1	271	1	1	0.29	../datasheets/PUSHBUTTON	10	12010	1	1
1792	BLOCK	2124445	1	1	173	1	ea	1.00	../datasheets/BLOCK	1	1	1	ea
1801	2N3904	2N3904	Transistor, NPN, 100ma,amp/switch	1	584	1	1	0.13	Datasheet	100	06076	1	1
1802	TIP41C	179371	Transistor, NPN, 100V@6A	1	111	1	TO220	0.40	Datasheet	10	04058	1
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
1856	ESP8266	ESP8266	ESP8266 Dev 201 WiFi Modules	I2C	804	1	module	15.25	../datasheets/ESP8266	1	15068	1

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

ver 4.05 Server: jcouture.net				Printed 01/25/26 16:19 Page: 3
SELECT * FROM inventory WHERE misc='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
1895	PCA9685	PCA9685	PCA9685 PWM Servo Motor Driver, 16 channel	I2C	335	1	module	3.89	Datasheet	3	15106	1
1899	1	1	1	Contact	463	1	ea	1.00	../datasheets/1	1	1	1
1925	MPU6050	MPU6050	Sensor, Accelerometer MPU6050	I2C	1	ITG/MPU	module	3.07	Datasheet	2	14002	1
1927	SOIL	SOIL	1	SPI	1	1	ea	1.00	../datasheets/SOIL	1	1	1
1928	AMP	AMP	Amplifier, Audio, 3W	1	1	PAM8403	module	1.40	../datasheets/AMP	5	14002	1
1937	ARDUINO	ARDUINO	Ethernet Shield, W5100	1	805	1	ea	8.97	../datasheets/ARDUINO	1	14002	1
1942	MICROSD	MICROSD	Micro SD Storage Board Mciro SD TF Card Memory Shield Module SPI For Arduino	SPI	372	1	module	0.99	../datasheets/MICROSD	5	16006	1
1958	DHT11	DHT11	1	SPI	446	1	ea	1.00	Datasheet	1	1	1
1960	HD74LS07	SN74LS07	IC, Hex Buffer, 30V, 40ma, HD74LS07P	1	233	HD74LS07P	DIP14	0.79	../datasheets/HD74LS07	10	16017	1
1979	SWITCH	SWITCH	Switch, DPDT Center off	1	251	blue	ea	0.90	../datasheets/SWITCH	5	16066	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
2089	MQ135	MQ135	Sensor Hazardous Gas Detection	1	132	FC-22 SBX	module	1.52	Datasheet	1	EBAY alice11011983, po	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