10 Commerce Tables should be update while Order Transaction complete.

10 Commerce Tables Required to Know the Order complete details (i.e Order Status, Timeplaced, Used Promocodes, Payment Mode, Plug-in Name .. etc.)

ORDERS : Each row in this table represents an order in a store
$db2 "select * from orders where orders_id=(orders_id)"

ORDERITEMS : Each row of this table represents an order item in an order
$db2 "select * from orderitems where orders_id=(orders_id)"

PX_CDUSAGE : This table contains all the promotion code usage information.
$db2 "select * from px_cdusage where orders_id=(orders_id)"

PX_USAGE : This table contains statistics about promotion usage
$db2 "select * from px_usage  where orders_id=(orders_id)"


PPCPAYINST (orders_id) : This table stores the value object Payment Instruction in WebSphere Commerce which contains the detailed information required by plug-ins to process financial transactions. The amount in the payment instruction can be used by plug-ins to determine what is the maximum target amount the payments subsystem intends to consume collectively.
$db2 "select * from ppcpayinst  where orders_id=(orders_id)"

PPCPAYMENT (PPCPAYINST_ID) : This table stores the information of the value object container Payment for payment-related transactions in the payments subsystem.
$db2 "select * from ppcpayment  where ppcpayinst_id=(ppcpayinst_id)" - get from ppcpayinst table.

PPCEXTDATA(PPCPAYINST_ID) : This table stores the non-standard protocol data required in the financial transaction which goes beyond the standard attributes defined in the payment instruction. It can be associated with a payment instruction or a financial transaction. When associated with a payment instruction, it can be used by all the financal transactions executed against the same payment instruction. When associated with a financial transaction, this extra data can be used by this same transaction and subsequent transactions.
$db2 "select * from ppcextdata  where ppcpayinst_id=(ppcpayinst_id)" - get from ppcpayinst table.

EDPORDER (ORDER_ID) : This table stores the information of the value object container Credit for credit-related transactions in the payments subsystem.
$db2 "select * from edporder  where orders_id=(orders_id)"

EDPPAYINST (EDPORDER_ID) : This table stores the information of the value object container Payment Instruction in Payment Rules.
$db2 "select * from edppayinst  where edporder_id=(edporder_id)" - get from edporder table.


Reference : 
https://www-01.ibm.com/support/knowledgecenter/SSZLC2_8.0.0/com.ibm.commerce.database.doc/database/edppayinst.htm