Modify Data Type Loan & Deposito

Anonymous
plain_text
01/02/2024 6:25 AM
1.6 KB
22
Indexable
ALTER TABLE [bsi].[mrms].[irrbb_loanPrepaymentRate]
ALTER COLUMN totalEarlyPrepayment numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_loanPrepaymentRate]
ALTER COLUMN totalOutstanding numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_loanPrepaymentRate]
ALTER COLUMN totalEarlyPrepayment numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_loanPrepaymentRate]
ALTER COLUMN totalOutstanding numeric(32,2);

ALTER TABLE [bsi].[mrms].[LoanPrepaymentRateEquation]
ALTER COLUMN totalEarlyPrepayment numeric(32,2);

ALTER TABLE [bsi].[mrms].[LoanPrepaymentRateEquation]
ALTER COLUMN totalOutstanding numeric(32,2);


ALTER TABLE [bsi].[mrms].[DepositoRedemptionRateEquation]
ALTER COLUMN balance numeric(32,2);

ALTER TABLE [bsi].[mrms].[DepositoRedemptionRateEquation]
ALTER COLUMN ew numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_depositoRedemptionRate]
ALTER COLUMN balance numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_depositoRedemptionRate]
ALTER COLUMN ew numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_depositoRedemptionRate]
ALTER COLUMN balance numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_depositoRedemptionRate]
ALTER COLUMN ew numeric(32,2);
Editor is loading...
Leave a Comment