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 #2168
• Add New Item from PO# RJ45

ver 4.05 Server: jcouture.net				Printed 03/20/26 02:04 Page: 1
SELECT * FROM inventory WHERE partid='RJ45' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1089	RJ45	115844	1	1	143	1	ea	1.00	../datasheets/RJ45	1	1	1
1980	RJ45	RJ45	Connector, Jack, PCB, RJ45		143	4	ea	0.47	../datasheets/RJ45	10	16068
1984	RJ45	RJ45	RJ45 Modular Jacks, RED,GRE,BLU,YEL,BLK		473		ea	0.71	../datasheets/RJ45	100	16074	additional jacks in stock
2037	RJ45	RJ45	RJ45 Jacks, PCB, Vertical Mount, type 5		453		ea	$0.10	../datasheets/RJ45	30	17017	EBAY - lucky.warm
2038	RJ45	RJ45	RJ45 Jacks, PCB, type 4		453		ea	2.08	../datasheets/RJ45	20	17040	EBAY - cpthreego