Applied Migrations
Migration Name ExecDate ExecTime
0_RemoveUnderscore.sql 2079/06/26 2:10 PM
0_1_MasterSettings.sql 2079/06/26 2:10 PM
0_2_DCS_Enhancements.sql 2079/06/26 2:10 PM
0_3_SpAndFunctions.sql 2079/06/26 2:10 PM
0_4_Saving_Enhancements.sql 2079/06/26 2:10 PM
0_5_Salary_Enhancements.sql 2079/06/26 2:10 PM
0_6_System_Refresh_Enhancements.sql 2079/06/26 2:10 PM
0_7_Loan_Enhancements.sql 2079/06/26 2:10 PM
0_8_Loan_Sp_Enhancements.sql 2079/06/26 2:10 PM
0_91_Bug Fixes.sql 2079/06/26 2:10 PM
0_93_BeforeNextGenChanges.sql 2079/06/26 2:10 PM
0_9_InfoUpdates.sql 2079/06/26 2:10 PM
1_migration_history_table.sql 2079/06/26 2:10 PM
2_dashboard.sql 2079/06/26 2:10 PM
3_IdentityInformation.sql 2079/06/26 2:10 PM
4_mac_management_tables.sql 2079/06/26 2:10 PM
5_messaging_tables.sql 2079/06/26 2:10 PM
6_DynamicLedgerListTable.sql 2079/06/26 2:10 PM
7_source_of_income_id_null.sql 2079/06/26 2:10 PM
8_SourceOfIncome.sql 2079/06/26 2:10 PM
9_Alter-auth_Tasks-table.sql 2079/06/26 2:10 PM
10_LoanDynamicTxnLedger.sql 2079/06/26 2:10 PM
11_notifications_table.sql 2079/06/26 2:10 PM
12_Alter_notification_table.sql 2079/06/26 2:10 PM
13_PasswordReset.sql 2079/06/26 2:10 PM
14_AddIsPasswordResetToAuthUsersTable.sql 2079/06/26 2:10 PM
15_DisplayName_TellerId_In_MacWhiteList.sql 2079/06/26 2:10 PM
16_MemberAccount_LastKycUpdated.sql 2079/06/26 2:10 PM
17_AcCodeCopomis field added to acc_COALedgers.sql 2079/06/26 2:10 PM
18_AddSearchTxnKey to Transactions table.sql 2079/06/26 2:10 PM
19_DayCloseSystem.sql 2079/06/26 2:10 PM
20_GetNepaliDateTimeFunction.sql 2081/02/14 8:20 PM
21_DayCloseDetails-columns-added.sql 2079/06/26 2:10 PM
22_sysMastersettings-column-add.sql 2079/06/26 2:10 PM
23_create-calendar-setting.sql 2079/06/26 2:10 PM
24_alter-sys_OrgCalenderDetails.sql 2079/06/26 2:10 PM
25_CoaMaterializedView.sql 2081/02/14 8:20 PM
26_smspayment_setting.sql 2079/06/26 2:10 PM
27_Migration_smsSetup.sql 2079/06/26 2:10 PM
28_migration_smsSetup_beforeLoanExpire.sql 2079/06/26 2:10 PM
29_migration_smsSetup_englishNepali.sql 2079/06/26 2:10 PM
30_migration_sms_alert_template_create_table.sql 2079/06/26 2:10 PM
31_migration-sms-alert-template.sql 2079/06/26 2:10 PM
32_all.sql 2079/06/26 2:10 PM
33_TellerVaultTransaction.sql 2079/06/26 2:10 PM
34_TellerVaultTransaction_RecStatus_Column.sql 2079/06/26 2:10 PM
35_Approve_System.sql 2079/06/26 2:10 PM
36_ApproveSystem_apv_pendingList_columns_addition.sql 2079/06/26 2:10 PM
37_migration_memID_pendingApv_list.sql 2079/06/26 2:10 PM
38_GlobalDynamicUploadSetupAndListTable.sql 2079/06/26 2:10 PM
39_DynamicUpload_add_remarks.sql 2079/06/26 2:10 PM
40_DynamicUpload_rename_doc_extensions_to_doc_file_types.sql 2079/06/26 2:10 PM
41_DynamicUploadSetup_name_to_ncarchar.sql 2079/06/26 2:10 PM
42_Disabled RecStatus added in Member Types.sql 2079/06/26 2:10 PM
43_Create_Table_AppUpdateConfig.sql 2079/06/26 2:10 PM
44_additional_columns_appupdateconfig.sql 2079/06/26 2:10 PM
45_IsCompleted_column_added_to_AppUpdateConfig.sql 2079/06/26 2:10 PM
46_group_message_viewer.sql 2079/06/26 2:10 PM
47_IsOnline col added for Active-InActive status.sql 2079/06/26 2:10 PM
49_CommissionAccountNo column added in Commission Setup.sql 2079/06/26 2:10 PM
50_migration_alter_NWSCofficecode.sql 2079/06/26 2:10 PM
51_organization table mobile number column.sql 2079/06/26 2:10 PM
52_acc_Bank table alter query.sql 2079/06/26 2:10 PM
53_altering fin_MemberAccount table.sql 2079/06/26 2:10 PM
54_dashboard notification sp.sql 2081/02/14 8:20 PM
55_migration_utilitydeno_table.sql 2079/06/26 2:10 PM
56_migration_smssetup_fixeddaynotification.sql 2079/06/26 2:10 PM
57_NewChanges_1.sql 2079/06/26 2:10 PM
58_RollbackDate added to usertransfertable.sql 2079/06/26 2:10 PM
59_migration_insert_added_utilitycommission_setup.sql 2079/06/26 2:10 PM
60_migration_insert_smstemplate_demo_data.sql 2079/06/26 2:10 PM
61_udf_FindMaxDate.sql 2081/02/14 8:20 PM
61_Computername column in sys_mac-whitelist table.sql 2079/06/26 2:10 PM
61_SettingsForNewIntSp.sql 2079/06/26 2:10 PM
62_f_DeleteFutureCalculatedInterest.sql 2081/02/14 8:20 PM
62_MoneyLaunderingColumn RecStatus added in identification_information.sql 2079/06/26 2:10 PM
65_SavingAccMaterialVw.sql 2081/02/14 8:20 PM
66_VoucherSplitSp.sql 2081/02/14 8:20 PM
67_NewVoucherCoreSp.sql 2079/07/16 2:46 PM
68_NewIntCalnSp.sql 2081/02/14 8:20 PM
69_NewIntAccumulationSP.sql 2081/02/14 8:20 PM
70_SearchTxnKeyFunction.sql 2079/07/16 2:46 PM
71_SourceBranchId field added in apv_PendingList table.sql 2079/06/26 2:10 PM
73_AdditionalVoucherQuery.sql 2079/06/26 2:10 PM
74_udf_GetFullMemberName_Function.sql 2081/02/14 8:20 PM
75_udf_GetLedgerName_Function.sql 2081/02/14 8:20 PM
76_Removing_Inventory_And_Payroll.sql 2079/06/26 2:10 PM
77_creating api setting table.sql 2079/06/26 2:10 PM
78_fin_AccountsKeyMap table added.sql 2079/06/26 2:10 PM
79_fin_AccountsKeyMap Function.sql 2081/02/14 8:20 PM
80_generate reference key for existing data.sql 2079/06/26 2:10 PM
637638522040_Data Key Added in DepositTemp Table.sql 2079/06/26 2:10 PM
637677320616_JvStrictMode col added in master setting.sql 2079/06/26 2:10 PM
637682548934_added_AcceptTxnAfterMaturity_on_depositAccDetails.sql 2079/06/26 2:10 PM
637828610409_add_column_ReceiptCopySameRow_in_mastersettings.sql 2079/06/26 2:10 PM
637828611023_add_column_BlockDepositAfterMaturity_in_mastersettings.sql 2079/06/26 2:10 PM
637884776142_Accounts Enhancements.sql 2079/06/26 2:10 PM
637886421784_setting default value to disable money laundering setting by default.sql 2079/06/26 2:10 PM
637888144339_Enhancements.sql 2079/06/26 2:10 PM
637891700962_SchedularTime_column_add_in_sys_MasterSettings.sql 2079/06/26 2:10 PM
637892523233_Scheduled_Task_Notification_added_on_auth_role.sql 2079/06/26 2:10 PM
637896795303_col alter of user_notification and notification table.sql 2079/06/26 2:10 PM
637904679605_PK_FK implementaton of teller vault.sql 2079/06/26 2:10 PM
637920207790_smsapi_url_row_insert.sql 2079/06/26 2:10 PM
637925366031_nextgen default database setup.sql 2079/06/26 2:10 PM
637926348260_SubGroupChanges.sql 2079/06/26 2:10 PM
637927118825_dbo.GetUserErrors sp.sql 2081/02/14 8:20 PM
637927190064_Add new user error type.sql 2079/06/26 2:10 PM
637927805945_new function udf_GetLedgerBalance.sql 2081/02/14 8:20 PM
637931756110_Add temp api config for finstock api.sql 2079/06/26 2:10 PM
637936732442_drop all foreign keys.sql 2079/06/26 2:10 PM
637936732638_drop all NCIs.sql 2079/06/26 2:10 PM
637936732782_SavingAccMaterialVw modify as view.sql 2079/06/26 2:10 PM
637936732901_fin_MemberAccount schema changes.sql 2079/06/26 2:10 PM
637936732988_fin_MemberDependent schema changes.sql 2079/06/26 2:10 PM
637936733277_SavingAccMaterialVw re-modify as matview.sql 2079/06/26 2:10 PM
637937387352_fin_Member_Nominies schema changes.sql 2079/06/26 2:10 PM
637937388762_fin_Membership schema changes.sql 2079/06/26 2:10 PM
637937391897_fin_SharePurchase schema changes.sql 2079/06/26 2:10 PM
637937395524_fin_ShareReturn schema changes.sql 2079/06/26 2:10 PM
637937397515_acc_MemberType schema changes.sql 2079/06/26 2:10 PM
637937399436_fin_AutoShareAccountNo schema changes.sql 2079/06/26 2:10 PM
637937400838_fin_AutomaticMember schema changes.sql 2079/06/26 2:10 PM
637939139071_Removed Day Opener Role.sql 2079/06/26 2:10 PM
637940233045_acc_BranchTransaction schema changes.sql 2079/06/26 2:10 PM
637941005841_Alterng com_State table.sql 2079/06/26 2:10 PM
637941019138_Altering com_District table.sql 2079/06/26 2:10 PM
637942603773_Creating com_PalikaType Table.sql 2079/06/26 2:10 PM
637943445262_Altering com_Palika table.sql 2079/06/26 2:10 PM
637943494477_Creating com_Zone table.sql 2079/06/26 2:10 PM
637944351310_com_TitleGender table added.sql 2079/06/26 2:10 PM
637944552383_acc_FinancialYear schema modification.sql 2079/06/26 2:10 PM
637944552453_sys_DayCloseDetails schema changes.sql 2079/06/26 2:10 PM
637946285831_fin_Fees schema modification.sql 2079/06/26 2:10 PM
637949693531_cleansing-member-address-ward.sql 2079/06/26 2:10 PM
637950412135_Altering RecVersion Data Type.sql 2079/06/26 2:10 PM
637952080880_Usermanagement Enhancements.sql 2079/06/26 2:10 PM
637952080881_mf_MemberInfoVm.sql 2079/06/26 2:10 PM
637953112211_SearchTxnKey Update.sql 2079/06/26 2:11 PM
637955615517_ReRun Share Certificate.sql 2079/06/26 2:11 PM
637957186483_add-user-teller.sql 2079/06/26 2:11 PM
637964179485_Updating data size of DepositAmount in fin_Deposit and DTotal and WTotal in fin_Account from (12,2) to (18,2).sql 2079/06/26 2:11 PM
637967717673_MemberAccount_MotherFatherInLaw.sql 2079/06/26 2:11 PM
637988522405_EServiceAutoJobs_DataType_Change.sql 2079/06/26 2:11 PM
637989424007_fin_SavingIntMode table creation.sql 2079/06/26 2:11 PM
637992898089_sms alert default template.sql 2079/06/26 2:11 PM
637993535477_LoanIntAndFineSp.sql 2079/12/28 12:20 PM
637995290880_Replace updated template variables.sql 2079/06/26 2:11 PM
637995392092_emiHistoryLogTableBugFix.sql 2079/06/26 2:11 PM
637997232841_palika name modification.sql 2079/06/26 2:11 PM
637999811575_Auth Task Enhancements.sql 2079/06/26 2:11 PM
999999999992_Altering Data Type.sql 2079/06/26 2:11 PM
999999999993_Fixing Issue Before FK Implementation.sql 2079/06/26 2:11 PM
999999999995_Drop ForeignKeys.sql 2079/06/26 2:11 PM
999999999996_OrgId ForeignKeys.sql 2079/06/26 2:11 PM
999999999997_BranchId ForeignKeys.sql 2079/06/26 2:11 PM
999999999998_Adding Foreign Keys_Except_BranchIdOrgId.sql 2079/06/26 2:11 PM
999999999999_Adding All Default Constraints_NoAuto.sql 2079/06/26 2:11 PM
637948624540_adding share certificate template setup table.sql 2079/06/26 2:13 PM
65_SearchTxnKeyFunction.sql 2081/02/14 8:20 PM
638011009140_Altering fin_ProtectedFund and fin_DividendAmount.sql 2079/08/23 11:18 AM
638013568319_Verified Column Add In Txn Table.sql 2079/08/23 11:18 AM
638013568400_NewVoucherCoreSp.sql 2081/02/14 8:20 PM
638017835208_tasks humanization.sql 2081/02/14 8:20 PM
638039506970_Day Close Step - Txn Verification System.sql 2079/08/23 11:18 AM
638042826476_Adding FiscalYears In Starting No.sql 2079/08/23 11:18 AM
638057516720_RenamedIsLoginDbBackupToDbBackupOnDayClose.sql 2079/08/23 11:18 AM
638058352103_Col Add - Signature change log.sql 2079/08/23 11:18 AM
638059219065_Adding FinSmart Module.sql 2079/08/23 11:18 AM
638059253776_DeleteOldCalculatedInterest.sql 2079/08/23 11:18 AM
638064459879_Default Session Timeout.sql 2079/09/06 12:37 PM
638065318669_com_palika table update.sql 2079/09/06 12:37 PM
638067049484_Utilitiy Setup Fixup.sql 2079/09/06 12:37 PM
638067953151_getLedgerBalanceFunction Enhancement.sql 2079/09/06 12:37 PM
638069757737_Loan Attachment Migration To DynamicUploadList Table.sql 2079/09/06 12:37 PM
638071385494_NCI on transaction table.sql 2079/10/15 10:41 PM
638071402688_SMS Setup Default Configuration.sql 2079/10/15 10:41 PM
638076581553_Altering OpeningAmount of acc_Bank.sql 2079/10/15 10:41 PM
638079184695_Delete previously inserted multiple associate accounts.sql 2079/10/15 10:41 PM
638079288875_Fix RecBy not update on withdraw.sql 2079/10/15 10:41 PM
638079966195_Source of income seeding.sql 2079/10/15 10:41 PM
638080114511_updating auto verifiable sourceTypeIds as verified.sql 2079/10/15 10:41 PM
638082631320_default session timeout seeding.sql 2079/10/15 10:41 PM
638082864051_altering acc_Tax_TaxPercent column to decimal datatype.sql 2079/10/15 10:41 PM
638083454218_added mastersetting balanceTransferBeforeMaturity.sql 2079/10/15 10:41 PM
638091274317_account member swap tasks seeding.sql 2079/10/15 10:41 PM
638092069865_loan member swap tasks seeding.sql 2079/10/15 10:41 PM
638095583392_OutOfBound Account Maturity Date Fixup.sql 2079/10/15 10:41 PM
638096545836_Updating Deposit Interest Remarks To Upto.sql 2079/10/15 10:41 PM
638097406475_coa group rename loan mgmt charge to mgmt charge.sql 2079/10/15 10:41 PM
638098930536_auth_task enhancement.sql 2079/10/15 10:41 PM
638099741949_enable hang fire mastersetting.sql 2079/10/15 10:41 PM
638099886497_getAccHolderName function.sql 2081/02/14 8:20 PM
638099901938_Interst associate sourcetypeid fixing.sql 2079/10/15 10:41 PM
638099932795_alter sheetId data type.sql 2079/10/15 10:41 PM
638101583371_add AuditLogDetails column on sys_AuditLog.sql 2079/10/15 10:41 PM
638101661620_add RecStatus column on sys_AuditLog.sql 2079/10/15 10:41 PM
638101734090_update member swap taskname.sql 2079/10/15 10:41 PM
638101798914_ReIndexing.sql 2079/10/15 10:41 PM
638103386672_member swap auth task enhancement.sql 2079/10/15 10:41 PM
638103478285_auth seeding.sql 2079/10/15 10:41 PM
638104295494_Seeding day close details from 2079_06_01.sql 2079/10/15 10:41 PM
638104538320_GetEnglishDate Function.sql 2081/02/14 8:20 PM
638105194587_getDashboardNotification_Sp.sql 2081/02/14 8:20 PM
0_CreatingUser.sql 2081/02/14 8:20 PM
20_Tbl_ModuleInfo.sql 2081/02/14 8:20 PM
21_Tbl_ProcessingCode.sql 2081/02/14 8:20 PM
22_Tbl_OperatorCodes.sql 2081/02/14 8:20 PM
23_Tbl_TxnLog.sql 2081/02/14 8:20 PM
24_Tbl_ResponseCode.sql 2081/02/14 8:20 PM
30_Fun_GetAccountBalance.sql 2081/02/14 8:20 PM
31_Fun_GetAccuredInterest.sql 2081/02/14 8:20 PM
32_Fun_GetMiniStatement.sql 2081/02/14 8:20 PM
33_Fun_IsInValidAccount.sql 2081/02/14 8:20 PM
34_Fun_IsAccountClosed.sql 2081/02/14 8:20 PM
35_Fun_GetDeductedBalance.sql 2081/02/14 8:20 PM
36_Fun_IsInvalidBranch.sql 2081/02/14 8:20 PM
37_Fun_IsLedgerIdValid.sql 2081/02/14 8:20 PM
38_Fun_IsAccountBlock.sql 2081/02/14 8:20 PM
39_Fun_GetLedgerIdByAccountNo.sql 2081/02/14 8:20 PM
40_Fun_FilterAcNo.sql 2081/02/14 8:20 PM
40_Fun_GetLoanDuePriAndInt.sql 2081/02/14 8:20 PM
41_Fun_GetValidationResponseCode.sql 2081/02/14 8:20 PM
42_Fun_TxnAccessValidation.sql 2081/02/14 8:20 PM
50_Pro_InsertTxnLog.sql 2081/02/14 8:20 PM
51_Pro_UpdateTxnLog.sql 2081/02/14 8:20 PM
52_Pro_GetAccInfo_Prob.sql 2081/02/14 8:20 PM
53_Pro_BalanceInquiry.sql 2081/02/14 8:20 PM
54_Pro_MiniStatement.sql 2081/02/14 8:20 PM
55_Pro_FullStatement.sql 2081/02/14 8:20 PM
56_Pro_AddDeposit.sql 2081/02/14 8:20 PM
58_Pro_AddWithdraw.sql 2081/02/14 8:20 PM
59_Pro_LoanInquiry.sql 2081/02/14 8:20 PM
60_Pro_ChequeBookRequest.sql 2081/02/14 8:20 PM
61_Pro_ChequeStop.sql 2081/02/14 8:20 PM
62_Pro_AddBankTxn_NotDone.sql 2081/02/14 8:20 PM
63_Pro_AccValidation.sql 2081/02/14 8:20 PM
90_Pro_FundTransfer.sql 2081/02/14 8:20 PM
91_Pro_MemberInfo.sql 2081/02/14 8:20 PM
92_p_GetOrgBranches.sql 2081/02/14 8:20 PM
93_p_GetOrgTransactionLedgers.sql 2081/02/14 8:20 PM
99_PermissionAccessToUser.sql 2081/02/14 8:20 PM
638107980401_mf_MemberInfoVw.sql 2081/02/14 8:20 PM
638108520620_char khata assets tasks.sql 2080/01/08 10:59 AM
638109478908_char khata liabilities tasks.sql 2080/01/08 10:59 AM
638112116992_char khata expenses tasks.sql 2080/01/08 10:59 AM
638112134121_char khata income tasks.sql 2080/01/08 10:59 AM
638112860589_char khata permission transfer.sql 2080/01/08 10:59 AM
638113020223_RefreshSystem.sql 2081/02/14 8:20 PM
638113020682_system refresh refactor.sql 2080/01/08 10:59 AM
638115515300_Tax rate fixes of v12 interest data.sql 2080/01/08 10:59 AM
638120482550_Adding isopening in loanintcaln table.sql 2080/01/08 11:00 AM
638120482551_LoanIntAndFineSp.sql 2081/02/14 8:20 PM
638120559779_ComputeLoanReceivableInDayOpen Master setting.sql 2080/01/08 11:00 AM
638122336977_alter datattype of MinBalance of sms_FeatureList table.sql 2080/01/08 11:00 AM
638137179880_altering data type of ml_SourceOfIncome table.sql 2080/01/08 11:00 AM
638139736481_Removed_Unused_MasterSettings.sql 2080/01/08 11:00 AM
638144952509_DenoInDayVoucher master setting.sql 2080/01/08 11:00 AM
638145634295_DbBakOnDayOpen Mastersetting.sql 2080/01/08 11:00 AM
638148432762_Update branch from and branch to.sql 2080/01/08 11:00 AM
638150866689_getCalculatedSavingInterest Function.sql 2081/02/14 8:20 PM
638151679785_AllowBankWithdrawOnMinus MasterSetting.sql 2080/01/08 11:00 AM
638157788376_Update smsapi url.sql 2080/01/08 11:00 AM
638158572278_Update smsapi token.sql 2080/01/08 11:00 AM
638161186248_add_atm_terminal.sql 2080/01/08 11:00 AM
638168290001_Loan tenure adjustment if more than 240.sql 2080/01/08 11:00 AM
638169133214_disabled finsmart module active.sql 2080/01/08 11:00 AM
638169147389_TaxRangeSeed.sql 2080/01/08 11:00 AM
638172427932_Date Add Nepali Update.sql 2081/02/14 8:20 PM
638172478431_InterestMenuChangesTasksUpdate.sql 2080/01/08 11:00 AM
638178551413_Deleting App warmup in tasks.sql 2080/03/31 8:25 PM
638180385279_Withdraw IBT BranchFrom and To Bug Fixes.sql 2080/03/31 8:25 PM
638182002659_TaxRangeSeed Enhancement.sql 2080/03/31 8:25 PM
638182806928_Interest table sourceTypeId fixes.sql 2080/03/31 8:25 PM
638184531656_interest_source_type_id_fix.sql 2080/03/31 8:25 PM
638186231398_Mother Name added.sql 2080/03/31 8:25 PM
638195027977_add_referred_by_member.sql 2080/03/31 8:25 PM
638198388263_extend_collateral_query.sql 2080/03/31 8:25 PM
638201008951_add_member_swap_log.sql 2080/03/31 8:25 PM
638206112304_update_province_to_koshi.sql 2080/03/31 8:25 PM
638207154389_lrpf_accumulator.sql 2080/03/31 8:25 PM
638222680488_change_log.sql 2080/03/31 8:25 PM
638232924932_update_koshi_name.sql 2080/03/31 8:25 PM
638239926891_Day Open Operation Step Log Table Added.sql 2080/03/31 8:25 PM
638239960878_Updating DayOperationSteps.sql 2080/03/31 8:25 PM
638241553304_Altering DayCloseDetails table.sql 2080/03/31 8:25 PM
638249508877_add_allow_future_Date_login_to_master_setting.sql 2080/03/31 8:25 PM
638250251405_default_value_for_allow_future_date_login.sql 2080/03/31 8:25 PM
638252973057_increase_narration_column_size.sql 2080/04/16 9:42 PM
638249376776_New Auth Permission Added.sql 2080/09/17 2:48 PM
638252040799_Col add in sys_DayOperationSteps table.sql 2080/09/17 2:48 PM
638258988313_Action Type added in identification.sql 2080/09/17 2:48 PM
638263315247_add_loan_payment_through_ledger_permission.sql 2080/09/17 2:48 PM
638271817491_add_access_device.sql 2080/09/17 2:48 PM
638273554177_add_access_device_action_log.sql 2080/09/17 2:48 PM
638275197811_add_single_user_single_device.sql 2080/09/17 2:48 PM
638275289911_add_loan_calc_sp.sql 2081/02/14 8:20 PM
638278819082_add_ibt_report_view_permission.sql 2080/09/17 2:48 PM
638281260331_organization member detail.sql 2080/09/17 2:48 PM
638281441257_add_bank_balance_setting.sql 2080/09/17 2:48 PM
638282232167_remove_kosh_from_cash_group.sql 2080/09/17 2:48 PM
638283156924_update_monthly_report_query.sql 2080/09/17 2:48 PM
638289916983_add_dcs_ibt_saving_master_settings.sql 2080/09/17 2:48 PM
638291791819_extend_depreciation_ledger_name_col.sql 2080/09/17 2:48 PM
638296968731_add_status_query.sql.sql 2080/09/17 2:48 PM
638312422293_alter member locality name lang.sql 2080/09/17 2:48 PM
638314088346_org_column_dta_type_update.sql 2080/09/17 2:48 PM
638314195098_member_account_remove_spaces.sql 2080/09/17 2:48 PM
638318460039_add_full_name_derived_persisted_column.sql 2080/09/17 2:48 PM
638319332256_add_use_member_temp_add_in_bill.sql 2080/09/17 2:48 PM
638320365631_add_branch_id_passbook_log.sql 2080/09/17 2:48 PM
638320365868_data_maintain_passbook_log.sql 2080/09/17 2:48 PM
638325312236_interest_rate_change_log_modify.sql 2080/09/17 2:48 PM
638327084117_alter_locality_lang_nvarchar.sql 2080/09/17 2:48 PM
638327136009_add_address_map_view.sql 2081/02/14 8:20 PM
638327216213_add_full_address_temp.sql 2080/09/17 2:48 PM
638327228145_interest_old_rate_update.sql 2080/09/17 2:48 PM
638327231093_add_proc_handle_nepali_member_Address.sql 2081/02/14 8:20 PM
638330511665_add_last_int_caln_update_query.sql 2081/02/14 8:20 PM
638331389835_migrate_old_guaranteE_data.sql 2080/09/17 2:48 PM
638364242943_add_verified_by_column.sql 2080/09/17 2:48 PM
638368524503_add_UseNepaliNameInDCS.sql 2080/09/17 2:48 PM
638368706608_add_Remarks_column_in_RenewLog.sql 2080/09/17 2:48 PM
638370227482_add_login_time_span_master_settings.sql 2080/09/17 2:48 PM
638370247710_add_Login_Time_Span_table.sql 2080/09/17 2:48 PM
638373793577_add_Login_time_violation_log_table.sql 2080/09/17 2:48 PM
638382383475_add_dcs_txn_pin.sql 2080/09/17 2:48 PM
638384153056_add_dcs_token_temp.sql 2080/09/17 2:48 PM
638385793917_add_ledger_watcher_table.sql 2080/09/24 2:42 PM
638387530164_update_query_for_monthly_report.sql 2080/09/24 2:42 PM
638402213312_add_cheque_required.sql 2080/10/10 10:05 PM
638271785893_branch wise cheque configurations including new configurtion.sql 2081/02/08 4:50 AM
638432643110_add_use_all_member_name_field_sys_master.sql 2081/02/08 4:50 AM
638441176419_add_chequerequiredontransfer.sql 2081/02/08 4:50 AM
638445439008_add-bank-category.sql 2081/02/08 4:50 AM
638445439501_add-bankcatagory-to-acc_bank.sql 2081/02/08 4:50 AM
638445512133_add-loan-tageta-patra-setup.sql 2081/02/08 4:50 AM
638448903976_LoanGetFopEligible.sql 2081/02/14 8:20 PM
638452496902__add_account_message.sql 2081/02/08 4:50 AM
638454035253_add_ShowQuickLinksInDashboar_mastersetting.sql 2081/02/08 4:50 AM
638454063633_add_loan_int_fine_edit_permission.sql 2081/02/08 4:50 AM
638459282584_quick_links_enable_by_default.sql 2081/02/08 4:50 AM
638463743213_add_sys_Widget_table.sql 2081/02/08 4:50 AM
638463743530_add_sys_manager_widget_table.sql 2081/02/08 4:50 AM
638463743847_add_sys_user_wise_widget_table.sql 2081/02/08 4:50 AM
638466386391_widget_seed_for_all_users.sql 2081/02/08 4:50 AM
638473295275_DateAddNepaliWithoutHolidays_Function.sql 2081/02/14 8:20 PM
638482576331_add-document-type .sql 2081/02/08 4:50 AM
638482576751_Update-citizenNo-documentNo.sql 2081/02/08 4:50 AM
638483474727_update_login_log_fail_to_failed.sql 2081/02/08 4:50 AM
638486987371__Member_Education_Qualification.sql 2081/02/08 4:50 AM
638487843104_add_acc_FinancialYearWiseStartingNo_table.sql 2081/02/08 4:50 AM
638487845863_ seeding_day_voucher_no_financialYear_wise.sql 2081/02/08 4:50 AM
638489632795_add_YCStepId_in_Acc_YearCloseValue.sql 2081/02/08 4:50 AM
638500922975_Update_Nepali_Date.sql 2081/02/08 4:50 AM
638518042952_update_financial_year_period.sql 2081/02/08 4:50 AM
Unapplied Migrations
General Migration Queries
Db Stored Queries
20_GetNepaliDateTimeFunction.sql Apply
25_CoaMaterializedView.sql Apply
54_dashboard notification sp.sql Apply
61_udf_FindMaxDate.sql Apply
62_f_DeleteFutureCalculatedInterest.sql Apply
65_SearchTxnKeyFunction.sql Apply
65_SavingAccMaterialVw.sql Apply
66_VoucherSplitSp.sql Apply
68_NewIntCalnSp.sql Apply
69_NewIntAccumulationSP.sql Apply
74_udf_GetFullMemberName_Function.sql Apply
75_udf_GetLedgerName_Function.sql Apply
79_fin_AccountsKeyMap Function.sql Apply
637927118825_dbo.GetUserErrors sp.sql Apply
637927805945_new function udf_GetLedgerBalance.sql Apply
638013568400_NewVoucherCoreSp.sql Apply
638017835208_tasks humanization.sql Apply
638099886497_getAccHolderName function.sql Apply
638104538320_GetEnglishDate Function.sql Apply
638105194587_getDashboardNotification_Sp.sql Apply
638107980401_mf_MemberInfoVw.sql Apply
638113020223_RefreshSystem.sql Apply
638120482551_LoanIntAndFineSp.sql Apply
638150866689_getCalculatedSavingInterest Function.sql Apply
638172427932_Date Add Nepali Update.sql Apply
638275289911_add_loan_calc_sp.sql Apply
638327136009_add_address_map_view.sql Apply
638327231093_add_proc_handle_nepali_member_Address.sql Apply
638330511665_add_last_int_caln_update_query.sql Apply
638448903976_LoanGetFopEligible.sql Apply
638473295275_DateAddNepaliWithoutHolidays_Function.sql Apply
FinSmart Queries
0_CreatingUser.sql Apply
20_Tbl_ModuleInfo.sql Apply
21_Tbl_ProcessingCode.sql Apply
22_Tbl_OperatorCodes.sql Apply
23_Tbl_TxnLog.sql Apply
24_Tbl_ResponseCode.sql Apply
30_Fun_GetAccountBalance.sql Apply
31_Fun_GetAccuredInterest.sql Apply
32_Fun_GetMiniStatement.sql Apply
33_Fun_IsInValidAccount.sql Apply
34_Fun_IsAccountClosed.sql Apply
35_Fun_GetDeductedBalance.sql Apply
36_Fun_IsInvalidBranch.sql Apply
37_Fun_IsLedgerIdValid.sql Apply
38_Fun_IsAccountBlock.sql Apply
39_Fun_GetLedgerIdByAccountNo.sql Apply
40_Fun_FilterAcNo.sql Apply
40_Fun_GetLoanDuePriAndInt.sql Apply
41_Fun_GetValidationResponseCode.sql Apply
42_Fun_TxnAccessValidation.sql Apply
50_Pro_InsertTxnLog.sql Apply
51_Pro_UpdateTxnLog.sql Apply
52_Pro_GetAccInfo_Prob.sql Apply
53_Pro_BalanceInquiry.sql Apply
54_Pro_MiniStatement.sql Apply
55_Pro_FullStatement.sql Apply
56_Pro_AddDeposit.sql Apply
58_Pro_AddWithdraw.sql Apply
59_Pro_LoanInquiry.sql Apply
60_Pro_ChequeBookRequest.sql Apply
61_Pro_ChequeStop.sql Apply
62_Pro_AddBankTxn_NotDone.sql Apply
63_Pro_AccValidation.sql Apply
90_Pro_FundTransfer.sql Apply
91_Pro_MemberInfo.sql Apply
92_p_GetOrgBranches.sql Apply
93_p_GetOrgTransactionLedgers.sql Apply
99_PermissionAccessToUser.sql Apply