I need to create a data model for stock control .The database is from sage 200 .I have a query regarding this.The stock control module has Stock item,Bin Item and Warehouse Item tables and their quantities constantly change.I am creating a data model with dimensions on one side and all events on one side so should I create separate event tables for stockitem,binitem and warehouseitem or integrate all into one event called stocks.Will give you more information if you require.thanks in advance.
