item name

[roshan]

Hi,

how can i know item and their names from inventory.we are working on indian location.please tell how can i know the items and their name from backend,

which table will hold item name,number.....

please revert me back....

Regards
Roshan

[jucapeor]

Hi roshan, first at all excuse my english...
Ok, items and their names are saved in mtl_system_items_b table, the segment1 column is the user known item number but an identifier is added by oracle in column inventory_item_id, the item name is stored in description column, additionally items are organization-assigned, this relation is in the organization_id column.

Bye