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 11:48 Page: 1
SELECT * FROM inventory WHERE pkg='1' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
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
1075	CONN	DCJ-1	Connector, Jack, 2.1mm, PCB, Power	POWER	471	1	1	0.35	../datasheets/CONN	50	16071	1	1
1323	MC145436P	MC145436P	IC, DTMF, Decoder, Receiver, MC145436P	DTMF	232	2322	1	3.99	Datasheet	1	04059	1	1
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
1801	2N3904	2N3904	Transistor, NPN, 100ma,amp/switch	1	584	1	1	0.13	Datasheet	100	06076	1	1
2052	resistor	resistor	Resistor Array, 3k3 ohm	1	332	1	1	0.07	../datasheets/resistor	25	17066	also 333
2120	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2148	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2150	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2153	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2154	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1