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

ver 4.05 Server: jcouture.net				Printed 03/20/26 04:39 Page: 1
SELECT * FROM inventory WHERE markings='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
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
1309	ICM7212	ICM7212	1	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
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
1374	MCP40101	241744	IC, MCP41010, 10K Pot, DIP8	1	593	1	DIP08	1.49	../datasheets/MCP40101	15	06077	1
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
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

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

ver 4.05 Server: jcouture.net				Printed 03/20/26 04:39 Page: 2
SELECT * FROM inventory WHERE markings='1' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
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
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
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
1728	DS1624	DS1624	1	I2C	***	1	ea	1.00	../datasheets/DS1624	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
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
1856	ESP8266	ESP8266	ESP8266 Dev 201 WiFi Modules	I2C	804	1	module	15.25	../datasheets/ESP8266	1	15068	1
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
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
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

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

ver 4.05 Server: jcouture.net				Printed 03/20/26 04:39 Page: 3
SELECT * FROM inventory WHERE markings='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
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
2030	1	1	DC Power Plug Adapters 2.5mm to 2.1mm	1	471	1	ea	0.60	../datasheets/1	20	17010	EBAY - greenforcecells
2039	ULN2803	ULN2803	ULN2803 SOIC	1	121	1	SOIC18	0.24	Datasheet	20	17035	EBAY - jk_parts
2045	arduino	arduino	ATTiny85 programmer	I2C	424	1	module	0.98	../datasheets/arduino	2	17034	EBAY - alice1101983
2049	DHT11	DHT11	Sensor, Temperature/Humidity, DHT11	1	446	1	ea	0.93	Datasheet	10	17043	EBAY - alice1101983
2052	resistor	resistor	Resistor Array, 3k3 ohm	1	332	1	1	0.07	../datasheets/resistor	25	17066	also 333
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
2120	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
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
2130	1	1	duffle bag	1	1	1	ea	111.20	../datasheets/1	1	19028	llbean	ea
2131	1	1	Phones Samsung Galaxy S7	1	1	1	ea	0.00	../datasheets/1	1	16180	Sprint	ea
2132	1	1	1	1	1	1	ea	1.00	../datasheets/1	1	1	1	ea
2134	1	1	Glasses	1	1	1	ea	486.75	../datasheets/1	1	18084	Kaiser	ea
2136	1	1	Esp32 book	1	1	1	ea	19.00	../datasheets/1	1	21066	randomnerdtutorials.com	ea
2138	1	1	Donut House 102 units, free shipping	1	1	1	ea	54.69	../datasheets/1	1	14095	LJSCoffee	ea
2142	1	1	Echo Dot	1	1	1	ea		../datasheets/1	1			ea
2144	1	1	Brother PT65 Marker Tape	1	1	1	ea	17.99	../datasheets/1	1	16080	EBAY - kingsale4u	ea
2147	1	1	Batteries for APC UPS 1500	1	1	1	ea	32.62	../datasheets/1	1	17008	EBAY - replaceupsbattery	ea
2148	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1

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