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

ver 4.05 Server: jcouture.net				Printed 11/26/25 14:30 Page: 1
SELECT * FROM inventory WHERE comm='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
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
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
1328	74175	74175	1	1	106	1061	ea	1.00	Datasheet	1	1	1	ea
1374	MCP40101	241744	IC, MCP41010, 10K Pot, DIP8	1	593	1	DIP08	1.49	../datasheets/MCP40101	15	06077	1
1443	T1006MJ	T1006MJ	IC, Triac, 600V, 10A, TO-220	1	126	T1006MJ	TO220	1.00	../datasheets/T1006MJ	10	07036	1
1453	LD33V	LM7833	IC, Voltage Regulator, 3.3V, 1.5A	1	113	LD33V	TO220	0.89	Datasheet	6	1	Also see 343
1513	PIC16F648	1	1	1	352	1	ea	1.00	../datasheets/PIC16F648	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
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
1734	shorting	152671	Shorting Blocks, Black, w/tab	1	402	1	1	0.15	../datasheets/shorting	10	12010	1	1

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

ver 4.05 Server: jcouture.net				Printed 11/26/25 14:30 Page: 2
SELECT * FROM inventory WHERE comm='1' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
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
1855	CD4050	CD4050	1	1	233	CD4050BE	ea	1.00	../datasheets/CD4050	1	1	1	ea
1883	UDN2981	UDN2981	1	1	124	1	ea	1.00	Data Link	1	1	1	ea
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
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
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
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
2052	resistor	resistor	Resistor Array, 3k3 ohm	1	332	1	1	0.07	../datasheets/resistor	25	17066	also 333
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
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
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

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