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

ver 4.05 Server: jcouture.net				Printed 11/26/25 13:13 Page: 1
SELECT * FROM inventory WHERE qoh='50' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1027	CABLE	UBC	Cable Tap		***			10.00	../datasheets/CABLE	50	11051
1028	CABLE	70594	Cable Ties, screw mount		***			0.15	../datasheets/CABLE	50	11106
1075	CONN	DCJ-1	Connector, Jack, 2.1mm, PCB, Power	POWER	471	1	1	0.35	../datasheets/CONN	50	16071	1	1
1174	GROMMET	GMT-1	Grommet		wkbn			0.03	../datasheets/GROMMET	50	05132
1477	LM7805	AMS1117	IC, Voltage Regulator, 5V, 1A		112	AMS1117 5.0	SOT223	0.08	Data Link	50	15090	also see LM1117
1555	2N7000	119423	MOSFET, NCh, 60V@300mA		225	2N7000	TO92	0.07	Datasheet	50	12031
1782	PUSHBUTTON	PUSHBUTTON	Switch, Push Button, 1cm x 1cm		572				../datasheets/PUSHBUTTON	50
1799	J117	J117	Transistor, PNP, 100V@2A, Darlington Power w/ diode		122	J117	TO220		Datasheet	50
1933	LEDRGB	LED	LED, RGB		565		ea	0.11	../datasheets/LEDRGB	50	14002	pin seq: RED,GND,GRE,BLU
1970	DIP18	DIP18	Socket DIP18		303		DIP18		../datasheets/DIP18	50
1977	DIP16	DIP16	Socket DIP16		302		DIP16	0.10	../datasheets/DIP16	50	16070
1991	cap	cap	Capacitors, .47uf, 250v		206	brownish red, 2 pin cap	ea	0.20	../datasheets/cap	50	16111
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
2004	TIP41C	TIP41C	Transistor, Power, TIP41C, NPN, 100V, 6A		111	TIP41	TO220	0.14	Datasheet	50	16167
2068	LM358	555	IC, LM358 (555 clone)		262		SOIC08	$0.026	Datasheet	50	17099
2076	LEDRGB		LED, RGB, diffused tri-color		565		5mmLED	0.05	../datasheets/LEDRGB	50	17099