[Quickfix-users] FIX orders

[Marcos S. <si...@ya...>]

Is it advisable to create separate tables for single order, cross, cancel , and replace orders and save the outgoing message depending on msgtype?
Also, is it advisable to create an execution report table to save the incoming FIX message regardless of order status ( tag 39 )?
I like to provide an audit log report to the exchange upon request.
Your prompt reply is much appreciated.