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