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 12:56 Page: 1
SELECT * FROM inventory WHERE partid='1' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
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
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
2138	1	1	Donut House 102 units, free shipping	1	1	1	ea	54.69	../datasheets/1	1	14095	LJSCoffee	ea
2142	1	1	Echo Dot	1	1	1	ea		../datasheets/1	1			ea
2144	1	1	Brother PT65 Marker Tape	1	1	1	ea	17.99	../datasheets/1	1	16080	EBAY - kingsale4u	ea
2147	1	1	Batteries for APC UPS 1500	1	1	1	ea	32.62	../datasheets/1	1	17008	EBAY - replaceupsbattery	ea
2148	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2149	1	1	SO-239 UHF Jack Connectors	1	1	1	ea	16.45	../datasheets/1	1	21099	showmecables	ea
2150	1	1	1	1	1	1	1	1.00	../datasheets/1	1	1	1	1
2152	1	1	Coffee - (180ct) - Donut House	1	1	1	ea	89.99	../datasheets/1	1	14058	Costco	ea
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
2155	1	1	Essential Oils - Laurie	1	1	1	ea	57.08	../datasheets/1	1	15054	EBAY - Sunshine	ea
2156	1	1	HBridge, qty 5	1	1	1	ea	11.57	../datasheets/1	1	16175	EBAY - alice1101983	ea
2158	1	1	Sensor, DS18B20 Waterproof qty 10	1	1	1	ea	16.99	../datasheets/1	1	16060	EBAY - yuero-2014	ea
2159	1	1	Coffee (80 ct) Donut House	1	1	1	ea	32.99	../datasheets/1	1	14065	Costco	ea
2160	1	1	Float Valves, Qty 5	1	1	1	ea	19.95	../datasheets/1	1	16041	EBAY - topnotchqualityforless	ea

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