Hi,
We are looking to dump a lot of BC tables to a datawarehouse for analysis. Time has come to look at "items" and Im having a hard time figuring out what the "master" table is when it comes to items.
From what I can tell the item ledger entry contains most of it. However the value entry table contains information related to costs and value that might not be in the item ledger. This can occur when we revalue items or recieved goods gets invoiced. There is also the warehouse entries which gives extra information about bins (which we use)
But what is actually the point of the item journal line table? To be honest it almost seem like it has the information from the other tables so maybe thats the master I should use, or are there transactions I would miss then?
