Taking Northwind as example. At what stage of the transaction should the List Price, Sub Total, and Taxes be added to the order details table.
So basically the current list price is displayed but this can change at any given time and hence needs to be recorded in the order details. At what point should this be done - When the order is being allocated, invoiced or shipped.
I messed around the Northwind database to get to where I am with my database so some functionality may have been broken which obviously I need to amend. Also the Northwind Traders database has some frustrations which luckily I have been able to take care of (for instance putting back stock when an order is canceled)