Item Name/Number in ODBC

Each item needs to have a name. The value of field "Item Name/Number" can be found in "ITEMS" table under "FULL_NAME" in ODBC.

Example query:
select FULL_NAME from ITEMS where item_id = <item ID>;