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

ver 4.05 Server: jcouture.net				Printed 11/26/25 12:56 Page: 1
SELECT * FROM inventory WHERE stocknum='resistor' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1985	resistor	resistor	Resistors, SMD 1206, 64 * 10 pieces		581		SMD 1206	0.01	../datasheets/resistor	640	16089
2018	resistor	resistor	Power Resistor, 5R6, 5W		353			$0.40	../datasheets/resistor	5	16199
2019	resistor	resistor	Resistor, Power, 6R 100W		272			1.40	../datasheets/resistor	5	16164
2020	resistor	resistor	Resistor, Power, 2R 100W		272			1.40	../datasheets/resistor	5	16164
2021	resistor	resistor	Resistor, Power, 4R 100W		272			1.40	../datasheets/resistor	5	16164
2051	resistor	resistor	Resistor Array, 680 ohm		332			0.07	../datasheets/resistor	25	17066	also 333
2052	resistor	resistor	Resistor Array, 3k3 ohm	1	332	1	1	0.07	../datasheets/resistor	25	17066	also 333
2053	resistor	resistor	Resistor Array, 2K0 ohm		333			0.07	../datasheets/resistor	25	17066	also 332
2054	resistor	resistor	Resistor Array, 3k0 ohm		332			0.07	../datasheets/resistor	25	17066	also 333
2055	resistor	resistor	Resistor Array, 10K ohm		333			0.07	../datasheets/resistor	25	17066	also 332
2056	resistor	resistor	Resistor Array, 100K ohm		333			0.07	../datasheets/resistor	25	17066	also 332