/* Before Execute the Following Code, Run the Software v.22.04.03 */

DELETE FROM Transactions WHERE ParentForm = 'Day Process'
GO

UPDATE AccountTypes SET IsShare_Deduction_In_Salary = 1 WHERE IsShareAccount = 1
GO

UPDATE AccountTypes SET GLAccountNo_Share_Fee = 'GA18' WHERE IsShare_Deduction_In_Salary = 1
GO

UPDATE Accounts SET Salary_Share_Amount = 500, Salary_Share_Fee=50 WHERE AccountTypesID IN (SELECT ID FROM AccountTypes
WHERE IsShare_Deduction_In_Salary = 1)
GO

UPDATE AccountTypes SET Loan_EMI_Method = 'Installment' WHERE ID = 4
GO

UPDATE Accounts_EMI_Details SET IsUsed = 0
GO

UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS714' AND EMI_Installment <= 24 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS741' AND EMI_Installment <= 22 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS742' AND EMI_Installment <= 23 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS743' AND EMI_Installment <= 23 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS744' AND EMI_Installment <= 23 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS745' AND EMI_Installment <= 23 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS747' AND EMI_Installment <= 23 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS748' AND EMI_Installment <= 22 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS749' AND EMI_Installment <= 20 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS751' AND EMI_Installment <= 19 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS754' AND EMI_Installment <= 21 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS756' AND EMI_Installment <= 21 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS757' AND EMI_Installment <= 18 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS759' AND EMI_Installment <= 20 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS761' AND EMI_Installment <= 20 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS762' AND EMI_Installment <= 18 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS763' AND EMI_Installment <= 20 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS765' AND EMI_Installment <= 20 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS766' AND EMI_Installment <= 19 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS770' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS771' AND EMI_Installment <= 18 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS773' AND EMI_Installment <= 19 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS774' AND EMI_Installment <= 19 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS775' AND EMI_Installment <= 13 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS776' AND EMI_Installment <= 17 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS777' AND EMI_Installment <= 18 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS778' AND EMI_Installment <= 15 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS779' AND EMI_Installment <= 17 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS780' AND EMI_Installment <= 18 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS781' AND EMI_Installment <= 15 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS783' AND EMI_Installment <= 15 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS784' AND EMI_Installment <= 15 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS785' AND EMI_Installment <= 16 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS787' AND EMI_Installment <= 15 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS788' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS789' AND EMI_Installment <= 16 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS792' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS793' AND EMI_Installment <= 15 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS794' AND EMI_Installment <= 15 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS795' AND EMI_Installment <= 15 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS796' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS797' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS801' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS802' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS803' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS804' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS805' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS806' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS807' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS808' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS809' AND EMI_Installment <= 14 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS813' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS814' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS815' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS816' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS817' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS818' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS819' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS820' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS821' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS823' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS824' AND EMI_Installment <= 11 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS825' AND EMI_Installment <= 11 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS826' AND EMI_Installment <= 11 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS827' AND EMI_Installment <= 11 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS828' AND EMI_Installment <= 11 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS829' AND EMI_Installment <= 11 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS831' AND EMI_Installment <= 10 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS832' AND EMI_Installment <= 10 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS833' AND EMI_Installment <= 10 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS834' AND EMI_Installment <= 10 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS835' AND EMI_Installment <= 10 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS836' AND EMI_Installment <= 10 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS837' AND EMI_Installment <= 9 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS838' AND EMI_Installment <= 8 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS839' AND EMI_Installment <= 8 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS840' AND EMI_Installment <= 8 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS841' AND EMI_Installment <= 8 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS842' AND EMI_Installment <= 8 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS843' AND EMI_Installment <= 8 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS844' AND EMI_Installment <= 7 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS845' AND EMI_Installment <= 7 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS846' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS847' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS848' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS849' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS850' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS851' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS852' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS853' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS854' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS855' AND EMI_Installment <= 5 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS856' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS857' AND EMI_Installment <= 5 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS858' AND EMI_Installment <= 5 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS859' AND EMI_Installment <= 5 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS860' AND EMI_Installment <= 5 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS861' AND EMI_Installment <= 4 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS862' AND EMI_Installment <= 6 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS863' AND EMI_Installment <= 4 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS864' AND EMI_Installment <= 4 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS865' AND EMI_Installment <= 4 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS866' AND EMI_Installment <= 4 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS867' AND EMI_Installment <= 3 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS868' AND EMI_Installment <= 3 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS869' AND EMI_Installment <= 3 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS870' AND EMI_Installment <= 3 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS871' AND EMI_Installment <= 3 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS872' AND EMI_Installment <= 1 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS873' AND EMI_Installment <= 1 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS874' AND EMI_Installment <= 1 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS875' AND EMI_Installment <= 1 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS876' AND EMI_Installment <= 1 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS877' AND EMI_Installment <= 1 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS878' AND EMI_Installment <= 1 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS879' AND EMI_Installment <= 18 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS880' AND EMI_Installment <= 18 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS881' AND EMI_Installment <= 12 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS882' AND EMI_Installment <= 24 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS883' AND EMI_Installment <= 24 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS884' AND EMI_Installment <= 24 
GO
UPDATE Accounts_EMI_Details SET IsUsed = 1 WHERE AccountNo = 'MS885' AND EMI_Installment <= 24 
GO