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

ver 4.05 Server: jcouture.net				Printed 11/26/25 13:18 Page: 1
SELECT * FROM inventory WHERE stocknum='zzz' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1017	DEVKIT-18X	zzz	Board, Development for 18x		***			0.00	../datasheets/DEVKIT-18X	2
1018	BOOK	zzz	Book, Understanding Signals Parts & Text		***				../datasheets/BOOK	20
1021	BREADBOARD	zzz	Breadboard, 270		drw			2.94	../datasheets/BREADBOARD	20	05025
1029	CABLE	zzz	Cable, 12', 3.5mm male/male		***			2.00	../datasheets/CABLE	1	11107
1038	CAP	zzz	1	1	221	1	ea	1.00	../datasheets/CAP	1	1	1	ea
1045	CAP	zzz	Cap, 4.7uF, 50V, Radial	1	200	1	1	0.08	../datasheets/CAP	10	05026	1	1
1046	CAP	zzz	Cap, 4700uF, 50V, Radial		200			1.10	../datasheets/CAP	10	05026
1047	CAP	zzz	Cap, 470uF, 50V, Radial		200			0.40	../datasheets/CAP	10	05026
1049	CAP	zzz	Cap, 47uF, 50V, Radial for Voltage Regs		200			0.15	../datasheets/CAP	10	05026
1100	CONN	zzz	Connector, Plug & Jack Set, 4 contact		152			0.28	../datasheets/CONN	20	05025
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
1205	WIRE	zzz	Hook-up Wire, 22ga, 100ft, solid, violet		wkbn			0.04	../datasheets/WIRE	100	05025
1393	AD5243	zzz	IC, Pot, Dual Digital, 10K, 256 step, Addressable	I2C	262		TSSOP20		Datasheet	2	05071	Nelson
1401	1808	zzz	IC, RAM, FM1808		246	FM1808		0.00	../datasheets/1808	4	05136
1471	LCD420	zzz	LCD Displays, 4x20		E--			10.00	../datasheets/LCD420	15	06080
1472	LCDKIT	zzz	LCD Kit #108		231			5.95	../datasheets/LCDKIT	1	11103
1518	PICAXE08	zzz	MCU, Picaxe 08	I2C	105		DIP08	0.00	../datasheets/PICAXE08	5	04006
1520	PICAXE18X	zzz	MCU, Picaxe 18X	I2C	105		DIP18	0.00	../datasheets/PICAXE18X	7	04006	ref: Picaxe ReadADC10
1521	SX18	zzz	MCU, SX18	I2C	352		DIP18	1.35	../datasheets/SX18	7	05102
1529	ACCELEROMETER	zzz	1	1	234	1	ea	1.00	../datasheets/ACCELEROMETER	1	1	1	ea
1534	LCD216	zzz	Module, LCD Panel, 2x16, SPI		163			29.95	../datasheets/LCD216	1	05103
1535	LCD420	zzz	1	1	drw	1	ea	1.00	../datasheets/LCD420	1	1	1	ea
1544	TEMPHUM	zzz	Module, Temp and Humidity		234			29.95	../datasheets/TEMPHUM	1	05079
1545	ULTRASONIC	zzz	Module, Ultrasonic Ping		273			29.95	../datasheets/ULTRASONIC	1	05103

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

ver 4.05 Server: jcouture.net				Printed 11/26/25 13:18 Page: 2
SELECT * FROM inventory WHERE stocknum='zzz' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1564	OBDII	zzz	OBD II Interface		drw			81.00	../datasheets/OBDII	1	06024
1567	OSCILLOSCOPE	zzz	Oscilloscope, USB, PC		wkbn			150.00	../datasheets/OSCILLOSCOPE	1	05103
1682	RESONATOR	zzz	Resonator, Ceramic, 10mhz		223			0.39	../datasheets/RESONATOR	18	05109
1686	RESONATOR	zzz	Resonator, Ceramic, 4mhz		223			0.39	../datasheets/RESONATOR	25	05109
1688	RESONATOR	zzz	Resonator, Ceramic, 8mhz		223			0.39	../datasheets/RESONATOR	19	05109
1699	USB-SD	zzz	Saelig SD Module		273			35.00	../datasheets/USB-SD	2	06034
1733	SERVO	zzz	Servos		E--			6.95	../datasheets/SERVO	15	06078
1747	DIP28	zzz	Socket, PDIP 28, .30 spacing		magshelf		DIP28	0.00	../datasheets/DIP28	29
1822	USB-1W	zzz	USB to 1Wire Converters		E--			25.00	../datasheets/USB-1W	3	06079
1823	USB-SPI	zzz	USB to Serial		E--			34.00	../datasheets/USB-SPI	15	06078
1825	WEATHER	zzz	Weather Stations		E--			75.00	../datasheets/WEATHER	3	06079
1826	DEVKIT-PINK	zzz	Web Server, PINK		E--			99.95	../datasheets/DEVKIT-PINK	2	06078
1832	WIRE	zzz	Wire, 1000 feet		E--			39.99	../datasheets/WIRE	1	06077
1833	WIRE	zzz	Wire, 1000 feet		E--			39.99	../datasheets/WIRE	1	06077
1834	WIRE	zzz	Wire, 1000 feet		E--			39.99	../datasheets/WIRE	1	06077
1835	WIRE	zzz	Wire, 1000 feet		E--			39.99	../datasheets/WIRE	1	06077
1836	WIRE	zzz	Wire, 1000 feet		E--			39.99	../datasheets/WIRE	1	06077
1837	WIRE	zzz	Wire, 1000 feet		E--			39.99	../datasheets/WIRE	1	06077