1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143
| USE 'XXXXXX'
-- Check user rights
IF CURRENT_USER != 'dbo'
BEGIN
RAISERROR(15247, 20, 1) WITH NOWAIT;
RETURN
END;
IF NOT EXISTS(SELECT VERSION FROM dbo.DB_VERSION WHERE VERSION LIKE '2.3.23.%')
RAISERROR('Wrong database version', 20, 1) WITH LOG;
GO
-- Initialize transaction
BEGIN TRANSACTION U2_T1;
-- Start flow
BEGIN
DECLARE @old_code NVARCHAR(10)
-- Initialize values
SET @old_code = 'XXXXX'
IF @old_code is null
RAISERROR('old_code must contain a legal value', 20, 1) WITH LOG;
IF NOT EXISTS(SELECT ACC_CODE FROM ACCOUNTS WHERE ACC_CODE = @old_code)
RAISERROR('new_code doesn''t exists in table ACCOUNTS', 20, 1) WITH LOG;
DELETE ACC_GROUP_CONTENT WHERE ACC_CODE = @old_code
DELETE ACC_GROUPING WHERE POOLING_ACC = @old_code
DELETE ACCOUNT_ID WHERE ACC_CODE = @old_code
DELETE ARCHIVING_ACCOUNTS WHERE ACCOUNT_CODE = @old_code
DELETE ARCHIVING_REJECT_REASON WHERE ACCOUNT_CODE = @old_code
DELETE AUDIT_CASH_LEDGER_INFO WHERE ACC_CODE = @old_code
DELETE AUDIT_CASH_TRAN_INFO WHERE DEBIT_ACC_CODE = @old_code
DELETE AUDIT_CASH_TRAN_INFO WHERE CREDIT_ACC_CODE = @old_code
DELETE AUDIT_REC_ACC_INFO WHERE ACC_CODE = @old_code
DELETE AUDIT_REC_BANK_INFO WHERE ACC_CODE = @old_code
DELETE BK_CLAIM_LEDGER WHERE ACC_CODE = @old_code
DELETE BK_MAN_CONTROL WHERE ACC_CODE = @old_code
DELETE BK_MAN_LEDGER WHERE ACC_CODE = @old_code
DELETE BK_MAN_LEDGER_UNIQUE WHERE ACC_CODE = @old_code
DELETE BK_MAN_LOCK WHERE ACC_CODE = @old_code
DELETE BK_MAN_REPORT WHERE ACC_CODE = @old_code
DELETE BK_MAN_STAT WHERE ACC_CODE = @old_code
DELETE BK_MAN_TEMP WHERE ACC_CODE = @old_code
DELETE BUDGET_EXCEPTIONS WHERE ACC_CODE = @old_code
DELETE CASH_BALANCES WHERE ACC_CODE = @old_code
DELETE CASH_DISC_LEDGER WHERE ACC_CODE = @old_code
DELETE CASH_INT_FLOW_COND WHERE ACC_CODE = @old_code
DELETE CASH_LEDGER WHERE ACC_CODE = @old_code
DELETE CASH_MODEL WHERE ACC_CODE = @old_code
DELETE CASH_MODEL WHERE BENEFICIARY_ACC = @old_code
DELETE CASH_MODEL WHERE CASH_ACC = @old_code
DELETE CASH_POOL_COND WHERE ACC_CODE = @old_code
DELETE CASH_PREMIUM_LEDGER WHERE ACC_CODE = @old_code
DELETE CASH_TRANSACTIONS WHERE DEBIT_ACC_CODE = @old_code
DELETE CASH_TRANSACTIONS WHERE CREDIT_ACC_CODE = @old_code
DELETE COMMERC_ARCH WHERE CHARGE_ACC = @old_code
DELETE COMMERC_TRANSFER WHERE CHARGE_ACC = @old_code
DELETE COMMERCIAL_MODEL WHERE ACC_CODE = @old_code
DELETE COMMERCIAL_MODEL WHERE CHARGE_ACC = @old_code
DELETE COMMISSION_COND WHERE ACC_CODE = @old_code
DELETE CREDIT_COND WHERE ACC_CODE = @old_code
DELETE DISCOUNT_MODELS WHERE ACC_CODE = @old_code
DELETE DOM_MASS_TRANSFER WHERE ACC_CODE = @old_code
DELETE DOM_STAND_MODELS WHERE ACC_CODE = @old_code
DELETE DOM_STAND_MOULD WHERE ACC_CODE = @old_code
DELETE DOMESTIC_MODEL WHERE BENEFICIARY_ACC = @old_code
DELETE DOMESTIC_MODEL WHERE ACC_CODE = @old_code
DELETE DOMESTIC_MOULD WHERE ACC_CODE = @old_code
DELETE DRAFTS_POST WHERE ACCOUNT_CODE = @old_code
DELETE FEE_LINKS WHERE ACC_CODE = @old_code
DELETE FINANCING_COND WHERE ACC_CODE = @old_code
DELETE FX_HOLDINGS WHERE ACC_CODE = @old_code
DELETE FX_HOLDINGS WHERE CNT_ACC_CODE = @old_code
DELETE HOLDING_COUPLES WHERE HOLDING_ACC = @old_code
DELETE HOLDING_COUPLES WHERE FILIAL_ACC = @old_code
DELETE IBC_FLOW_LINK WHERE ACC_CODE = @old_code
DELETE IBC_FLOW_LIST WHERE ACC_CODE = @old_code
DELETE INTERCMP_PAYMENTS WHERE ISSUER_ACC_CODE = @old_code
DELETE INTERCMP_PAYMENTS WHERE BENEFICIARY_ACC_CODE = @old_code
DELETE INTERNAT_ARCH WHERE CHARGE_ACC = @old_code
DELETE INTERNAT_MODEL WHERE ACC_CODE = @old_code
DELETE INTERNAT_MODEL WHERE CHARGE_ACC = @old_code
DELETE INTERNAT_TRANSFER WHERE CHARGE_ACC = @old_code
DELETE INVESTMENT_COND WHERE ACC_CODE = @old_code
DELETE LIMITS_ACCOUNTS WHERE ACC_CODE = @old_code
DELETE LIMITS_ACCOUNTS_CREDIT WHERE ACC_CODE = @old_code
DELETE LIMITS_ACCOUNTS_DEBIT WHERE ACC_CODE = @old_code
DELETE LOAN_FLOWS WHERE ACC_CODE = @old_code
DELETE LOANS WHERE AMORT_CMP_ACC = @old_code
DELETE LOANS WHERE ADDIT_PAYMENT_CMP_ACCOUNT=@old_code
DELETE LOANS WHERE PAYMENTS_CMP_ACC = @old_code
DELETE LOANS WHERE INT_CMP_ACC = @old_code
DELETE LOANS WHERE FEE_CMP_ACC = @old_code
DELETE MUTUAL_FUNDS WHERE ACC_CODE = @old_code
DELETE MUTUAL_FUNDS WHERE DEPOSIT_CMP_ACC = @old_code
DELETE MUTUAL_FUNDS WHERE FEE_CMP_ACC = @old_code
DELETE NREC_ACC WHERE ACC_CODE = @old_code
DELETE NREC_BANK WHERE ACC_CODE = @old_code
DELETE OVERDRAFT_COND WHERE ACC_CODE = @old_code
DELETE PAYMENT WHERE ACC_CODE = @old_code
DELETE PAYMENT WHERE CASH_ACC = @old_code
DELETE PAYMENT WHERE CHARGE_ACC = @old_code
DELETE PAYMENT_ARCH WHERE CHARGE_ACC = @old_code
DELETE PAYMENT_ARCH WHERE ACC_CODE = @old_code
DELETE PAYMENT_ARCH WHERE CASH_ACC = @old_code
DELETE PAYMENT_MODEL WHERE ACC_CODE = @old_code
DELETE PAYMENT_MODEL WHERE CASH_ACC = @old_code
DELETE PRE_GROUP WHERE ACC_CODE = @old_code
DELETE PRE_REC WHERE PRE_REC_ACC_CODE = @old_code
DELETE REC_ACC WHERE ACC_CODE = @old_code
DELETE REC_ACC_ARH WHERE ACC_CODE = @old_code
DELETE REC_BANK WHERE ACC_CODE = @old_code
DELETE REC_BANK_ARH WHERE ACC_CODE = @old_code
DELETE SHORT_TERMS WHERE FEE_CMP_ACC = @old_code
DELETE SHORT_TERMS WHERE RED_CMP_ACC = @old_code
DELETE SHORT_TERMS WHERE INT_CMP_ACC = @old_code
DELETE SHORT_TERMS WHERE DEPOSIT_CMP_ACC = @old_code
DELETE SHORT_TERMS WHERE ACC_CODE = @old_code
DELETE SPE_RAP_ACCOUNTS WHERE ACC_CODE = @old_code
DELETE STANDING_DEPOSITS WHERE ACC_CODE = @old_code
DELETE STANDING_DEPOSITS WHERE CHARGE_ACC_CODE = @old_code
DELETE STANDING_DEPOSITS WHERE UNPAID_ACC_CODE = @old_code
DELETE STANDING_PROFILES WHERE ACC_CODE = @old_code
DELETE STANDINGS WHERE ACC_CODE = @old_code
DELETE STANDINGS_ARCHIVE WHERE ACC_CODE = @old_code
DELETE STATS_REC_AR WHERE ACC_CODE = @old_code
DELETE SUFFIXES WHERE ACC_CODE = @old_code
DELETE TRANSFER_PROFILE WHERE ACC_CODE = @old_code
DELETE TRANSFER_PROFILE WHERE CASH_ACC = @old_code
DELETE VALUE_TERMS WHERE ACC_CODE = @old_code
DELETE ZERO_BALANCING_ACCOUNT WHERE BANK_ACCOUNT = @old_code
DELETE FROM ACCOUNTS WHERE ACC_CODE = @old_code
END;
GO
COMMIT TRAN U2_T1; |
Partager