Finding table name and field for warehouse on SO header or lines in databse log

(0) Share

Report

Posted on by Chourouk Souissi

Hello,

I need to track warehouse change on Sales order using databse log

but I cannot find the table name or field name

Can you please help

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Danny Bilodeau 4,687 Super User 2025 Season 2 on at

Like (0)

Report

RE: Finding table name and field for warehouse on SO header or lines in databse log

Hi Chourouk,

You will find under the <Trade> node. If you select Show Table names, you will find these:

Was this reply helpful? Yes No
Chourouk Souissi 45 on at

Like (0)

Report

RE: Finding table name and field for warehouse on SO header or lines in databse log

Hello Danny,

thank you for your reply

I couldnt find the field related to Warehouse on that table

Could you please help?

thanks

Was this reply helpful? Yes No
Verified answer

Danny Bilodeau 4,687 Super User 2025 Season 2 on at

Like (0)

Report

RE: Finding table name and field for warehouse on SO header or lines in databse log

Hi Chourouk,

In the Sales Table, the warehouse field name is actually <InventLocationID>. You can validate in the table itself if you have the table viewer extension for Google.

In the SalesLine table, you have to look for teh field <InventDimID>. There is a unique InventDim value for a specific combination of all inventory dimensions (Product, Storage and Tracing). Any changes in one of these will cause the InventDim to be changed.

Kind regards,

Danny

Was this reply helpful? Yes No
Chourouk Souissi 45 on at

Like (0)

Report

RE: Finding table name and field for warehouse on SO header or lines in databse log

Thank you Danny for your reply

As InventDimID do not show the old and new values for the Warehouse directly I used Sales table (InventLocationId)

Was this reply helpful? Yes No