I plan to develop a stock control system.

My problem is whether to
keep Openning Qty in a Single Table eg. opnbal.dbf
keep Stock Out Qty in different Table eg. StkOut.dbf
keep Stock in Qty in a Table eg. StkIn.dbf

Or to keep openning,out and in qty in single table?

Which 1 is better design?