Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/resources/sql/ @ 36562 – Rev 37124

Rev 37030 | Last modification | Compare with Previous | View Log | RSS feed

Last modification

Rev 37074 2026-07-14 10:12:16
Author: amit
Log message:
Add T3.1 re-tag SQL: manual scheme-reversal legs ADDITIONAL_SCHEME -> OTHERS

One-time reconciliation applied to hadb1: 19 manual scheme/incentive clawback
wallet legs (Rs 2,25,110) whose offer_payout was never rejected (MARGINS CN still
stands) were re-tagged ADDITIONAL_SCHEME -> OTHERS so the account-statement
scheme-adjustment line nets out. Money unchanged (reference_type + description
only). Includes backup + verify + rollback. Backup table
transaction._bak_addl_scheme_others_20260710.

Path	Last modification			Log	RSS
add_credit_block_log.sql	37030	11 d 9 h	amit	Log	RSS
add_credit_note_id_to_returnorderinfo.sql	36817	38 d 9 h	amit	Log	RSS
add_idx_account_statement_perf.sql	36691	53 d 6 h	amit	Log	RSS
add_idx_uwh_timestamp_reftype.sql	36330	88 d 8 h	amit	Log	RSS
add_irn_error_message.sql	36675	54 d 4 h	amit	Log	RSS
add_reference_to_offer_scheme.sql	36451	77 d 6 h	amit	Log	RSS
add_uk_fofo_order_fofo_invoice.sql	36362	87 d 4 h	amit	Log	RSS
alter_monitor_type_normal_to_base.sql	36443	78 d 8 h	amit	Log	RSS
backfill_dn_return_credit_note_id.sql	36926	23 d 10 h	amit	Log	RSS
backfill_po_rejected_orders.sql	36790	43 d 11 h	amit	Log	RSS
catalog_monitor_type.sql	36441	78 d 10 h	amit	Log	RSS
cleanup_abandoned_draft_orders.sql	36795	40 d 11 h	amit	Log	RSS
cleanup_phantom_payment_failed.sql	36795	40 d 11 h	amit	Log	RSS
contact_us.sql	36888	26 d 11 h	aman	Log	RSS
create_cron_batch_tables.sql	36305	90 d 16 h	amit	Log	RSS
fix_invoice_receiveDate_from_purchase.sql	36314	89 d 12 h	amit	Log	RSS
flagship_credit_schema.sql	36557	63 d 18 h	amit	Log	RSS
mail_outbox.sql	35956	133 d 11 h	amit	Log	RSS
migration_bulk_order_approval_report_menu.sql	35966	133 d 10 h	amit	Log	RSS
migration_dn_status_retailer_ack.sql	36446	78 d 0 h	amit	Log	RSS
migration_dummy_warehouses.sql	36309	90 d 0 h	amit	Log	RSS
migration_gst_to_fofo_store.sql	35908	138 d 13 h	amit	Log	RSS
migration_hdfc_payment_credited_flag.sql	36943	22 d 7 h	amit	Log	RSS
migration_imei_net_margin_modal_api.sql	36407	82 d 4 h	amit	Log	RSS
migration_lead_live_location.sql	36711	52 d 5 h	ranu	Log	RSS
migration_lead_visit_approval.sql	36642	57 d 4 h	ranu	Log	RSS
migration_loan_imei_table.sql	36958	18 d 8 h	amit	Log	RSS
migration_menu_icons.sql	36567	63 d 10 h	amit	Log	RSS
migration_order_wallet_adjustment.sql	36713	52 d 5 h	amit	Log	RSS
migration_outlet_name_to_fofo_store.sql	36439	78 d 12 h	amit	Log	RSS
migration_po_transaction_mapping.sql	36910	24 d 12 h	amit	Log	RSS
migration_requested_hid_allocation_approved_by.sql	36894	26 d 9 h	amit	Log	RSS
migration_running_balance_wallet_history.sql	36515	69 d 5 h	amit	Log	RSS
migration_scheme_item_windowing.sql	36406	82 d 6 h	amit	Log	RSS
migration_unsettled_purchase_return_menu.sql	36318	89 d 5 h	aman	Log	RSS
model_flagship_schema.sql	36565	63 d 10 h	amit	Log	RSS
reconcile_inventory_snapshot.sql	36512	69 d 8 h	amit	Log	RSS
retag_manual_scheme_reversals_to_others.sql	37074	4 d 14 h	amit	Log	RSS
solr_update_failures.sql	35547	185 d 8 h	amit	Log	RSS
void_net_settled_stranded_orders.sql	36796	40 d 10 h	amit	Log	RSS