Stock Table Name

[Former Member]

Hai to All,

What's the table name for Storing Stock Details,

Regards,

Anitha

[former_member204969 · Accepted solution]

OITW is for Item/warehouse and

OINM for warehouse journal.

[Former Member]

Hi Anitha,

It depends on the stock data that you require, but here are the main tables:

The main table for storing stock data is the OITM table. (AITM stores the history of changes)

The prices are stored in ITM1

Warehouse information is stored in OITW.

If you require more tables then you can open up query generator, press tab in the top left hand corner and it will give you a list of all table names and descriptions.

Regards,

Adrian

[Former Member]

Thanks Adrian,

I find it out................