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

ver 4.05 Server: jcouture.net				Printed 03/20/26 05:56 Page: 1
SELECT * FROM inventory WHERE qoh='100' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1039	CAP	29962	Cap, 100uF, 50V, Radial, for Voltage Regs		221			0.12	../datasheets/CAP	100	12010
1050	CAP	15335	Cap, Cerm 10pf		203			0.05	../datasheets/CAP	100	07036
1052	CAP	1946367	Cap, Electrolytic, Radial Lead, 10uF, 25V		216			0.05	../datasheets/CAP	100	12031
1098	CONN	100765	Connector, pin, female		drw			0.09	../datasheets/CONN	100	05027
1099	CONN	145357	Connector, pin, male		drw			0.14	../datasheets/CONN	100	05027
1139	1N4001	821-1N4001	Diode, 1N4001, Rectifier, 50V, 1A (used with relays)		161	1N4001		0.02	Datasheet	100	04060
1140	1N4004	35991	Diode, 1N4004, Rectifier, 400V, 1A (used with 7805)		161	1N4004		0.03	Datasheet	100	05001
1142	1N4148	78-1N4148	Diode, 1N4148, Switching Diode		161	1N4148		0.02	Datasheet	100	04060
1143	1N4004	1N4004	Diode, 1N4004, Diode, 1A		145	1N4004		0.03	Datasheet	100	06077
1145	1N914	1N914TR	Diode, 1N914, Switching Diode (for high speed relay switching)		161	1N914		0.02	Datasheet	100	05132
1200	WIRE	zzz	Hook-up Wire, 22ga, 100ft, solid, brown		wkbn			0.04	../datasheets/WIRE	100	05025
1201	WIRE	zzz	Hook-up Wire, 22ga, 100ft, solid, gray		wkbn			0.04	../datasheets/WIRE	100	05025
1203	WIRE	zzz	Hook-up Wire, 22ga, 100ft, solid, Orange		wkbn			0.04	../datasheets/WIRE	100	05025
1490	LED	LED	LED, Green		553				Datasheet	100
1496	LEDORG	3836353401	LED, Orange		564			0.07	../datasheets/LEDORG	100	04048
1501	LEDRED	351-5001	LED, Red		146			0.19	../datasheets/LEDRED	100	04006
1502	LHG2062	94553	LED, Red/Green, (based on polarity)		123		T1		Datasheet	100
1506	LED	LED	LED, Yellow		552				Datasheet	100
1671	YYY	661790	Resistor, 15K, 1/2 watt		333			0.03	../datasheets/YYY	100	07036
1760	SPACER	SPC-5	Spacer, .6", nylon		wkbn			0.03	../datasheets/SPACER	100	05132
1761	SPACER	SPC-5	Spacer, .6", nylon		wkbn			0.03	../datasheets/SPACER	100	06043
1781	SWITCH	122972	Switch, Push Button		444			0.19	../datasheets/SWITCH	100	06077
1801	2N3904	2N3904	Transistor, NPN, 100ma,amp/switch	1	584	1	1	0.13	Datasheet	100	06076	1	1
1804	2N2222	PN2222A	Transistor, NPN, 40, 100@150ma, 251		585		TO18	0.15	Datasheet	100	06076
1890	LM1117	AMS1117	Voltage Regulator, 3.3V, 1A,	POWER	262		SOT223	0.04	Data Link	100	15087	also see LM1117, also in drawer 113
1891	MMBT3904	3904	Transistor, NPN, 40V 200ma		111		SOT233	0.03	Data Link	100	15096

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

ver 4.05 Server: jcouture.net				Printed 03/20/26 05:56 Page: 2
SELECT * FROM inventory WHERE qoh='100' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1897			Header, female, 8pin, long leg		403			0.14	../datasheets/	100	15106
1956	connector	connector	Connector, PCB, Blue, 2 conductor		173		ea	0.07	../datasheets/connector	100	16020
1961	header	header	Headers, 10pin, qty 100, long leg		431			0.17	../datasheets/header	100	16032
1984	RJ45	RJ45	RJ45 Modular Jacks, RED,GRE,BLU,YEL,BLK		473		ea	0.71	../datasheets/RJ45	100	16074	additional jacks in stock
1990	pcb	pcb	header, pcb, female, 40pin		415		ea	0.13	../datasheets/pcb	100	16119	additional in 472
1997	photoresistor	photoresistor	Photoresistors		321		ea	0.14	../datasheets/photoresistor	100	16156
2035			Plastic Waterproof Connectors		263		ea	15.99	../datasheets/	100	17031	EBAY - topgearsltd