Hi,

I am in the process of writing a basic report in SQL for a colleague however I am having trouble finding descriptions for codes.

In the stock transactions screen there are 2 columns called Movement Type and Document Type.

In the STOJOU table in the database I can find these columns however they are represented by an integer value rather than a description like the stock transactions screen.

Which table(s) do I need to link in order to get these descriptions into a query?

Thanks

Regards

Ben