Subversion Repositories SmartDukaan
(root)/trunk/profitmandi-dao/src/main/resources/sql/void_net_settled_stranded_orders.sql – Rev 36796
Directory listing | Details | Blame | View Log | RSS feed
Last modification
- Rev 36796 – 39 d 2 h
- Author: amit
- Log message:
- Add migration: void net-settled stranded status=0 orders
Captures the two ad-hoc cleanups run on hadb1 (the live DB): rejected-txn orders
the PO_REJECTED backfill missed (non-standard refund) -> PO_REJECTED(91), and
non-rejected status=0 orders whose wallet debit was reversed by a non-standard
entry -> refund_timestamp. Net-settled only; net-committed/awaiting-approval POs
left untouched. Temp-table form to avoid locking the live DB. Idempotent.
