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

ver 4.05 Server: jcouture.net				Printed 01/25/26 16:17 Page: 1
SELECT * FROM inventory WHERE pkg='EA' 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# EA

ver 4.05 Server: jcouture.net				Printed 01/25/26 16:17 Page: 2
SELECT * FROM inventory WHERE pkg='EA' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
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
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
1931	antenna	antenna	Antenna, WiFi		809		ea	2.25	../datasheets/antenna	1	14002
1933	LEDRGB	LED	LED, RGB		565		ea	0.11	../datasheets/LEDRGB	50	14002	pin seq: RED,GND,GRE,BLU
1934	flow sensor	flow sensor	Sensor, Flow, Water, 1/2"		shop		ea	4.06	../datasheets/flow sensor	2	14002
1937	ARDUINO	ARDUINO	Ethernet Shield, W5100	1	805	1	ea	8.97	../datasheets/ARDUINO	1	14002	1
1945	rotary	rotary	Rotary Encoder Module Brick Sensor Development Board For Arduino		432		ea	0.99	../datasheets/rotary	5	15067
1947	flow sensor	flow sensor	Sensor, Flow, Water, 1.5"	digital	101		ea	16.18	../datasheets/flow sensor	1	16009
1948	flow sensor	flow sensor	Sensor, Flow, Water, 1.25"	digital	101		ea	16.18	../datasheets/flow sensor	1	16010
1952	switch	switch	Switch, magnetic proximity		271		ea	2.00	../datasheets/switch	2
1954	PH	PH	PH sensor				ea	7.00	../datasheets/PH	1	16030
1956	connector	connector	Connector, PCB, Blue, 2 conductor		173		ea	0.07	../datasheets/connector	100	16020
1958	DHT11	DHT11	1	SPI	446	1	ea	1.00	Datasheet	1	1	1
1967	DS18B20	DS18B20	Sensor submersible DS18B20 Temp	1W	500		EA	1.70	Datasheet	10	16060
1978	RELAY	RELAY	Relay DPDT 12vdc Omron LY2NJ 10A and base		806	OMRON LY2N-J	ea	4.44	Data Link	5	16053
1979	SWITCH	SWITCH	Switch, DPDT Center off	1	251	blue	ea	0.90	../datasheets/SWITCH	5	16066	1

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

ver 4.05 Server: jcouture.net				Printed 01/25/26 16:17 Page: 3
SELECT * FROM inventory WHERE pkg='EA' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1980	RJ45	RJ45	Connector, Jack, PCB, RJ45		143	4	ea	0.47	../datasheets/RJ45	10	16068
1984	RJ45	RJ45	RJ45 Modular Jacks, RED,GRE,BLU,YEL,BLK		473		ea	0.71	../datasheets/RJ45	100	16074	additional jacks in stock
1989	LED	LED	1	1	581	1	ea	1.00	Data Link	1	1	1
1990	pcb	pcb	header, pcb, female, 40pin		415		ea	0.13	../datasheets/pcb	100	16119	additional in 472
1991	cap	cap	Capacitors, .47uf, 250v		206	brownish red, 2 pin cap	ea	0.20	../datasheets/cap	50	16111
1992	barrier	barrier	Barrier Terminal Strips, Euro, 10A, 12pos, 380V		A31	white plastic	ea	0.73	../datasheets/barrier	10	16097
1993	1N4728	1N4728	Diode, Zener, 1N4728, 3.3V, 1watt		114	1N4728	ea	0.04	Datasheet	50	16124
1994	1N4733	1N4733	Diode, Zener, 1N4733, 5.1V, 49mA,1W		114	1N4733	ea	0.04	Datasheet	50	16124
1995	1N4742A	1N4742A	Diode, Zener, 1N4742A, 12V, 1W		114	1N4742A	ea	0.04	Datasheet	50	16124
1996	Shrink Tubing	Shrink Tubing	Shrink Tubing		361		ea	11.34	../datasheets/Shrink Tubing	3	16146	EBAY - topitem.hsi	ea
1997	photoresistor	photoresistor	Photoresistors		321		ea	0.14	../datasheets/photoresistor	100	16156
2005	MP3	MP3	MP3 Player	serial	261		ea	2.15	../datasheets/MP3	2
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
2026	jack	jack	Phone Jacks, 3.5mm		345		ea	0.30	../datasheets/jack	10	17001	EBAY - leiqingjun1973
2027			Arduino Ultimate Starter Kit				ea	37.75	../datasheets/	1	16207	EBAY - alice1101983
2030	1	1	DC Power Plug Adapters 2.5mm to 2.1mm	1	471	1	ea	0.60	../datasheets/1	20	17010	EBAY - greenforcecells
2031	arduino	arduino	Arduino Pro Mini P328, 5V, 16mHz		425	10	ea	1.86	../datasheets/arduino	10	17019	EBAY - alice1101983
2032	arduino	arduino	Arduino FTDI Programmer		423	FTDI	ea	1.85	../datasheets/arduino	10	17019	EBAY - alice1101983
2033	header	header	Header, PCB, 1x40		435		ea	0.07	../datasheets/header	70	17018	EBAY - jinbostore
2034	header	header	Header, PCB, 1x40		414		ea	0.07	../datasheets/header	30	17018	EBAY - jinbostore
2035			Plastic Waterproof Connectors		263		ea	15.99	../datasheets/	100	17031	EBAY - topgearsltd
2036			DC Pwr Jack, 2.1mm, panel mount		471		ea	1.90	../datasheets/	20	17016	EBAY - good-module
2037	RJ45	RJ45	RJ45 Jacks, PCB, Vertical Mount, type 5		453		ea	$0.10	../datasheets/RJ45	30	17017	EBAY - lucky.warm
2038	RJ45	RJ45	RJ45 Jacks, PCB, type 4		453		ea	2.08	../datasheets/RJ45	20	17040	EBAY - cpthreego
2041	PCB	PCB	Printed Circuit Board, Blue, 80 x 100 mm, Board # 1681A				ea	2.12	../datasheets/PCB	13	17039	TinySine Electronics

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

ver 4.05 Server: jcouture.net				Printed 01/25/26 16:17 Page: 4
SELECT * FROM inventory WHERE pkg='EA' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
2048	JM08AD	JM08AD	1	1	133	JM08AD	ea	1.00	../datasheets/JM08AD	1	1	1	ea
2049	DHT11	DHT11	Sensor, Temperature/Humidity, DHT11	1	446	1	ea	0.93	Datasheet	10	17043	EBAY - alice1101983
2050	screws	screws	Laptop Screw Set		331		ea	2.62	../datasheets/screws	1	17052	EBAY - tianxinshops	ea
2053	resistor	resistor	1	1	333	1	ea	1.00	../datasheets/resistor	1	1	1
2058	mega	mega	Arduino Mega	i2c	805	1	ea	10.09	Data Link	2	17070	EBAY - alice1101983
2059	TCS34725	TCS34725	Sensor, Light Color TCS34725	I2C	131	Purple module TCS34725	ea	3.93	Datasheet	3	17070	EBAY - alice1101983
2066	shorting	shorting	Shorting Block	na	334		ea	0.02	../datasheets/shorting	500	17095
2071	PCB	PCB	PCB Adapter Board QFP/TQFP/FQFP/LQFP to DIP		253	TQFP 32-64pin	ea	0.29	../datasheets/PCB	25	17099
2079	ESP8266	ESP8266	ESP8266-01 Adapter Board		433		ea	0.68	../datasheets/ESP8266	10	17101
2096	Buzzer Piezo		Buzzer 3.3v 10pcs		235	B written on top	ea	0.86	../datasheets/Buzzer Piezo	10	20004	AMZ
2097	led	32327	LED BARGRAPH Red, Grn, Yel,		362	rgy	EA	0.49	../datasheets/led	30	MPJA
2099			Waterproof connectors,10 pin		351		ea	15.07	../datasheets/	10	22012	AMZ
2100	RELA Y		Relay Module, 8 relay		806		ea	7.23	Data Link	2	22014	AMZ
2101	ESP32	WROOM-32U	ESP32 32U External Antenna		809	ESP32-WROOM-32U	ea	7.36	Datasheet	6	22016	AMZ
2106	2106		DC Power Plug Adapters 5.5mm to 2.1mm		471		ea	2.00	../datasheets/2106	5	23049
2107	2107		Switch Inline 10A		251		ea	2.00	../datasheets/2107	4	23048
2114	BattH18650		Battery HOlder,3.7V, 18650		826		ea	0.20	../datasheets/BattH18650	5	temu 24050
2115	XY-T01	XY-T01	Temperature Controller - PCB w/Display		814		ea	9.89	Data Link	1
2116	W1209	W1209	Thermostat Temp Control w/relay 12VDC		814	W1209	ea	1.82	Data Link	5
2117	2117	2117	Adjustable 1.2-25VDC 9A power supply		814		ea	4.24	Data Link	2
2118	2118	2118	Digital LED Temp Controller - 24VDC		814	2118	ea	5.48	Data Link	1
2119	XH-3001	XH-3001	Microcontroller Digital Temp Controller - 110VAC		814		ea	3.98	Data Link	3
2121	1	1	ibuprofin, 200mg	1	1	1	ea	9.85	../datasheets/1	1	24066	amz	ea
2122	1	1	T-Shirts for Nancy and Chris	1	1	1	ea	49.93	../datasheets/1	1	20027	Computer Gear	ea
2123	1	1	Power Resistors, 50ohm, 10W	1	1	1	ea	4.80	../datasheets/1	1	16141	EBAY - andwind	ea
2126	1	1	QRP Sensor	1	1	1	ea	181.97	../datasheets/1	1	16196	Atlas Scientific	ea

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