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

ver 4.05 Server: jcouture.net				Printed 11/26/25 13:13 Page: 1
SELECT * FROM inventory WHERE loc='565' AND QOH>0 PO Num				Location: Description:
ID#	Item#	VenStk#	Description	Comm	LOC	Markings	PKG	PriceEA	Datasheet	QOH	Vendor/PO	Misc	Photo?
1485	LEDBlue	2006764	LED, Blue. T1		565			0.39	../datasheets/LEDBlue	20	12010	Green looking outer shell
1503	LEDWHT	LED-115	LED, White	LED	565	5	LED5	0.65	../datasheets/LEDWHT	10	06043		LED5
1563	NEON	210243	Neon Lamp, 60-120V, .3ma	NEON	565	7		0.23	../datasheets/NEON	10	06044
1933	LEDRGB	LED	LED, RGB		565		ea	0.11	../datasheets/LEDRGB	50	14002	pin seq: RED,GND,GRE,BLU
2076	LEDRGB		LED, RGB, diffused tri-color		565		5mmLED	0.05	../datasheets/LEDRGB	50	17099