• 4750: Added "audit" related columns to table BailmentAccountCurtailmentDirectDebit

• 4755: Updated CurtailmentPayment table, renamed Amount to RepaymentAmount, added CurtailmentDirectDebit and Status.

• 4760: Renamed the BailmentAccountCurtailmentDirectDebit table to BailmentAccountCurtailmentDirectDebit_HistoricNotUsed.

• 4780: Added TotalFacilityLimit column to table LoAcc

• 4800: Added ProviderMessageIdentifier column to table Cmm

• 4805: Added VariableLoanQuotePaymentScheduleReport column to table AccTyp

• 4815: Added CurtailmentScheduleValidationAmount to the BailmentAccount table

• 4710: Added columns in LoAcc table to accommodate rate change notification schedule instalment requirements

• 4715: Added column UserSelectedCurtailmentScheduleId to BailmentAccount table

• 4725: Added column ActualOcrRateChangePercentage to InterestRateChangeNotification table

• 4730: Added column VariableLoanQuoteOption to AccQuoPrf table

• 4735: Added column LoanMaturityDate,FrequencyNumber to AccQuo table

• 4745: Added renamed RepeatDaily to Repeat and changed from a bool to a tinyInt in ServerJob table

• 4655:Merge duplicate rows in table GenHis and table GenCls. Deleted table Branch and related foreign keys

• 4665: Added IsDeprecated column in LicencedModule table

• 4670: Deleted tables AccMthCom and AccMthComInv.  Deleted MthComPdDte, MthComManAmt, MthComManDocAmt, MthComManDocUseFlg, MthComManUseFlg, MthComManVolBon, NoMonthlyCommissionPaid, MthComManVolBonUseFlg columns from the acc table 

• 4680:Deleted tables ProjectAccount, ProposedAccount, ProjectBasicGoal, ProjectCommunication, BudgetValue, ProjectTargetPeriodBasicGoal,BaseGoal, ProjectGoalType, Project, ProjectPriority, ProjectStatus, ProjectTargetPeriod and licensed module ProjectManagement from table LicencedModule

• 4690: Added columns in AccTyp table to support transfer of interest between call accounts

• 4695: Added column TwoFactorAuthenticationExempt in Stf table, if not exists

• 4570:Added column NoWordGeneratedAttachment in table CmmTyp

• 4575: Added column HasReplacementFieldsForFileAttachment in table Cmm

• 4580: Added table PaymentCycle

• 4585: Added column PaymentCycleId in table LoAcc 

• 4605: Added table InterestRateChangeNotification

• 4610: Added column CalculationType, ProjectedFirstInstalmentNumber, ProjectedSecondInstalmentNumber, CalculationDate, ProjectedSecondInstalmentAmount,ProjectedSecondDirectDebitAmount, drop column PaymentCycleId in table InterestRateChangeNotification.

• 4615: Added column InterestRateChangeNotified to the LoAcc table

• 4620:Added columns to accommodate Dividend processing in table AccTyp

• 4625:Added column ExcludeFromInterestCalculation to AccountTransactionType table

• 4630:Added columns in Acc table to maintain cache for transactions excluded from interest calculation

• 4635:Added columns in LoAcc table to maintain correct instalment amount

• 4645: Added column LeaseSettlementValue in LeAcc table

• 4650: Added columns RepeatDaily and StartDateTime in ServerJob table

• 4651: Added column TwoFactorAuthenticationExempt in Stf table 

• 4510:Added column AllowOverrideFreeFloorplanEndDate in table FloorPlanProfile

• 4530: Added table StockAuditCheckListReportDataStore

• 4540: Added column AllowLeaseQuoteImportDetail in table AccQuoPrf

• 4440: Added column Notes1,  Notes2, CurtailmentScheduleId in table SecMak

• 4445: Added column CurtailmentScheduleOnSecurityMakeId in table BailmentAccount

• 4450: Added column ModifiedBy, ModifiedAt, CreatedBy, CreatedAt in table CurtailmentPayment

• 4460: Added column SecDateOfDeath, SecStatus in table Cli

• 4465: Added column TwoFactorEmailAddress, TwoFactorEmailAddressConfirmed, TwoFactorSecretKey, TwoFactorAuthenticationEnabled, TwoFactorOtpExpiry in table Stf

• 4470: Added column TwoFactorAuthenticationEmailVerificationCode, TwoFactorAuthenticationEmailVerificationCodeExpiry columns in table Stf

• 4480: Added column CommunicationTypeId in table CreditStatus

• 4485: Added column FFPDaysThirtyDaysPercentage, FFPDaysSixtyDaysPercentage, FFPDaysNinetyDaysPercentage columns in table PPFCFeesRule

• 4490: Added ServerController and ServerJob tables

• 4175: Added AddAccountCodeToReportFilenames to the CommuncationType table

• 4180: Added FixedFor in AccIpf table

• 4190: Added PpsrRefreshTokenExpiryDateTime to the Stf table

• 4030: Added IsLivestock to the AccTyp table

• 4035: Added IsLivestock to the BailmentAsset table

• 4040: Added LivestockAverageNetValue, LivestockOriginalCount, LivestockCurrentCount to the BailmentAccount table

• 4045: Added BmtLivestockFeeFutureTransferAccTrnTypNum and BmtLivestockFeeCurrentTransferAccTrnTypNum to the AccTyp table

• 4050: Removed LivestockAverageNetValue from BailmentAccount table

• 4055: Added LivestockMaturityDate field to the BailmentAccount table

• 4060: Added Quantity, CurrentCount field to the Invoice table

• 4065: Added LivestockFeeTransactionId, TaxLivestockFeeTransactionId field to the InvoicedTransaction table

• 4070:  Added BmtLivestockFeeFutureTransferAccTrnTypNum to AccTyp table

• 4075: Added LivestockGrazierTransactionId, OffsettingLivestockGrazierTransactionId to InvoicedTransaction table 

• 4080: Added DistributorId, DistributorCode, IsLivestock to the DirectDebitReportDataStore table

• 4085: Deleted LivestockGrazierTransactionId, OffsettingLivestockGrazierTransactionId from InvoicedTransaction table

• 4090: Moved LivestockOriginalCount and LivestockCurrentCount from the BailmentAccount to the BailmentAsset table and added LivestockAverageNetValue to the BailmentAsset table

• 4095: Added AccountManagerId to CreditReview table

• 4100: Added AccountStatementCreation and AllowEarlyTerminationQuoteCreation to the AccTyp table

• 4120: Remove AllowEarlyTerminationQuoteCreation flag from the AccTyp table

• 4135: Added ProcessorInvoiceNumber field to Invoice table

• 4140: Added security operation for bailment dealer Account summary report

• 4145: Added BmtLivestockCapitalisedInterestAccTrnTypNum to AccTyp as a foreign key to AccountTransactionType.ID

• 4155: Deleted LivestockFeeTransactionId, TaxLivestockFeeTransactionId from InvociedTransaction table

• 4160: Added LivestockCount table. Columns are BailmentAccountId,StockCount, StockChangedDate,IsTermination. BailmentAccountId is foreign key to Bailment Account

• 4165: Added ReviewDate to the Distributor table

• 3990: Added InternalAuditor to the StockAuditor table

• 4000: Added ExternalStockAuditSystemId to the StockAudit table, added StockAuditItem table

• 4005: Added IncludeInNextAudit to the BailmentDealer table

• 4010: Added BailmentExternalTerminationReasonId to AccTyp Table

• 4015 : Added RequestedExternalAuditDate to the StockAudit table

• 4020: Added Id to the StockAuditItem table and made the primary key

• 4025: Added ExternalAuditReceived to the StockAudit table

• 3950: Added DirectCreditMaturityTranTypNum to AccTyp Table

• 3945: Corrected column definitions for EngineNumber, ModelNumber, VINHIN in table BailmentDealerStockDetail.

• 3865: Added MaturityDate in UfAcc table

• 3870: Added LoanDirectDebitPath to DlAcc table; Added LoanDirectDebitPath to DirectDebitReportDataStore table; renamed DlAcc.LeaseDirectDebitBankNum to DirectDebitBankNum; renamed DlAcc.LeaseInvoiceDirectDebitBankNum to InvoiceDirectDebitBankNum; renamed DirectDebitReportDataStore.LeaseDirectDebitBankId to DirectDebitBankId; renamed DirectDebitReportDataStore.LeaseInvoiceDirectDebitBankId to InvoiceDirectDebitBankId

• 3875: Added HpXNPVInterestVarianceTrnTypNum in AccTyp table

• 3890: Added IgnoreDayOneRule to AccountTransactionType table

• 3715: Added FinancialYearStart into Cur table

• 3720::Add a new column to the AccTrn table called 'WriteOff' and record the status of the write off indicator/checkbox for each created transaction

• 3725: Added CompanyNumber into CbStm table

• 3735: Added EarlyMaturedFlag to DpAcc table

• 3740: Drop FinancialYearStart column and add FinancialYearMonthStart column in Cur table

• 3750: Drop columns ChargedInt, WrtOffInt in AccTyp table

• 3460: Added CB_ALLOW_SUSPENDED_POSTING flag into Ctl Table

• 3765: added HpNPVDiscAccTrnTypNum, DefaultNPVRate to AccTyp table

• 3770: Removed SessionExpires from the stf table

• 3790: Added ExposePrincipalInterestProfile to the AccTyp table

• 3795: Added LetterTermDate, LetterTermAmount into Acc table and TermDays into AccLet table

• 3850: Added AllowDuplicateEngineNo into Distributor table and DistributorId column into BailmentAsset table

• 3860: Added CertReq into UfAcc table

• 3671: Added PasswordHistory table

• 3675: Added PayableClient column to BailmentAccount table

• 3690: Dropped constraint FK_Disbursement_HpAcc, added constraint FK_Disbursement_Acc

• 3695: Added FacilityFeeEndDate column to LoAcc table

• 3700: Added FirstPaymentIndicator into LeAcc table

• 3708: Added AllowWebTransfer into BailmentDealer table

• 3640: Added StockNumber into BailmentDealerStockDetail

• 3645: Updated the table CliCli Primary Key to include the column RelNum

• 3655: Added a column to Disbursment to indicate if the make immediate payout

• 3665: Added DoNotSendOverdueLetters to the BailmentDealer table

• 3485: Created table InterestRateSummaryDetail

• 3495: Updated table LeaseAssetType with corresponding values from LeAss

• 3505: Dropped column DepnMethodInd and DepnRate on table LeAss

• 3507:Fixed the conflict that arise when adding foreign key constraint in UpgradeToVersion3510

• 3510: Added foreign key relationship in AccTyp table with TerminationReason table

• 3515: Added BmtPostAssetSalesFeeAccTrnTypNum to the AccTyp table

• 3520: Added foreign key relationship in InterestRateSummaryDetail table with Acc and DealerAccount table

• 3530: Added HpChgCombinedLegerInterest to the AccTyp table

• 3535: Added PostAssetSaleFeeAccruedAmount and PostAssetSaleFeeAccruedDate to the CachedBailmentAccountInterest table

• 3540: Added PostAssetSaleFeeAccruedPosted to the BailmentAccount table

• 3550: Added DepnRate and DepnMethodInd columns back to the LeAss table and populated the data from LeaseAssetType table

• 3555: Trigger that will be fired when the contents in the LeaseAssetType table being updated

• 3565: Changed the types for column TaxDepnMethod and TaxDepnRate for table LeaseAssetType and DepnMethodInd and DepnRate for table LeAss. Re-Created the View AsstType to match the old AssetTyp table

• 3575: As the Straight Line option of TaxDepnMethod is no longer required therefore it is masked out within the code and its place in the enum becomes placeholder,i.e. Index number of other options remain the same values. In order not to display the item(s) with the value of Straight Line, the sql script associated with this number set the RecordState to inactive.

• 3580: Added table DirectDebitReportDataStore

• 3585: Added Column IsPayouts in AccVarFld table

• 3590: Added table Disbursement

• 3600: Added stored proc CalculatePayoutsCostItemTotal

• 3610: Add column AccountCode, TotalCostItem,delete foreign key constraint in Disbursement

• 3615: Added StartDate and EndDate to the AccTrn table, Added BailmentDealerInterestStartDate, BailmentDealerInterestEndDate, PostAssetSaleFeeAccruedStartDate, PostAssetSaleFeeAccruedEndDate, DefaultInterestStartDate to the CachedBailmentAccountInterest table

• 3620: Added columns PayoutBankId, QuoteCode, QuoteDealerId in table Disbursement

• 3625 Added CachedPayoutReport to store the report data permanently

• 3630 Added AllowGroupLimit to the BailmentDealer table

• 3185: Added ClientId to Invoice table

• 3190: Added CashbookDCExportHeaderReference and CashbookDCExportHeaderReference to the CbBnk table

• 3200: Added FeesAccountID to the BailmentDealer table and IsFeesAccount to the ACC table

• 3220: Added BailmentDealerPPFCFeesAccTrnTypNum, BailmentDealerPPFCFeesTaxAccTrnTypNum, BailmentDistributorPPFCFeesAccTrnTypNum, BailmentDistributorPPFCFeesTaxAccTrnTypNum to the AccTyp table

• 3225: Added PPFCInvoiceReportFile to Company table

• 3235: Added AdHocInvoiceReportFile to Company table

• 3240: Created table PpfcFeesRules

• 3250: Added EmailAddress to the Stf table

• 3265: Added PrepaidFinanceCharges_Percentage and PrepaidFinanceCharges_Dollar to PPFCFeesRule table

• 3280: Created table DistributorPPFCFeesRule table

• 3285: Created table AdHocInvoice with columns:

InvoiceNumber, InvoiceDate, TransactionTypeId, InvoiceDescription, InvoiceNetAmount

• 3295: Added column IsInternational to table PayTyp

• 3305:  Added column for BmtAccountPayableGLCodeNum

• 3310: Added BailmentDealerPayableAccount table

• 3320: Added AccountId to Invoice table

• 3325 Added DIS_FEE_DIRECT_DEBIT_DAYS into Ctl table

• 3330 Added PostBailmentDirectDebitFileName into CbBnk table

• 3345 Added BailmentLiability table

• 3350 Added DealerStockDetail table

• 3355 Added ChargedInt (Interest Charged) and WrtOffInt (Interest Write Off) into AccTpe table

• 3360 Dropped tables BailmentDealerLiability and BailmentDealerStockDetail .

• 3375 Added BailmentLiability table

• 3380 Added DealerStockDetail table

• 3385 Added column FloorPlanStockListReportFile in company table

• 3390 Added BMT_FLOOR_PLAN_STOCK_LIST into Ctl table

• 3395 Added TaxDepnMethod, TaxDepnRate into AsstTyp table

• 3400 Added column BmtDealerTransferTermReasonId into AccTyp table

• 3405 Added RecordState into AsstTyp table

• 3410 Created a new table LeaseAssetType and Update the old  AsstTyp table

• 3415 Added Stored proc to find matching assets for dealer transfer

• 3425 Added LeaseDirectDebitPath, LeaseDirectDebitBankAccount, LeaseInvoiceDirectDebitPath, LeaseInvoiceDirectDebitBankAccount to Acc table

• 3430 Added Stored proc to update DueInFull and FreeFloorPlanPeriodEndDate

• 3450 Stored proc to update account details on asset dealer transfer

• 3455: Moved columns LeaseDirectDebitPath, LeaseDirectDebitBankNum, LeaseInvoiceDirectDebitPath, LeaseInvoiceDirectDebitBankNum from table ACc to table DlAcc

• 3460 Added new foreign key constraint for SecFinCol to LeaseAssetType

• 3465 Created UNIQUE NONCLUSTERED INDEX [IX_LeaseAssetType] ON [dbo].[LeaseAssetType]

• 3466 Added table JointClient

• 3150: Added BmtThirdPartyTerminationReasonId to AccTyp table

• 3155: Added AllowReferral to BailmentDealer table

• 3160: Added the following columns:

• DefaultAge, DefaultKilometres, and DefaultAdvanceRate to Distributor

• Age, Kilometres, and AdvanceRate to BailmentAsset

• 3080: Added StockNumber to BailmentAsset table

• 3085: Added DistributorFloorPlanProfile to InvoicedTransaction

• 3090: Added PrimaryFacilityLimit to Distributor

• 3095: Added CurtailmentSchedule and CurtailmentSchedulePeriod tables

• 3100: Added UnitFundValuation to AccTyp table

• 3105: Added DefaultCurtailmentScheduleId to Distributor table

• 3110:

• Removed BMT_OVR_CURTAILMENT_PMT_CNT, BMT_CURTAILMENT_SPREAD_MIN and BMT_CURTAILMENT_SPREAD_MAX records from the ctl table

• Removed CurtailmentSpreadPercentage from the BailmentAccount table

• 3125: Added AmalgamationCliNum to AccQuo table

• 3130: Added SuspendCashbookBatch to CbStm table

• 3140: Added ReceivablesInvoiceReportFile to RecTyp

• 3025:

• Added BailmentDealerSalesUsers table with colums:

• BailmentDealerID links to BailmentDealer table with foreign key

• StfId links to Stf  table with foreign key

• Dropped column SalesUserId from BailmentDealer table

• Data migrated to BailmentDealerSalesUsers table

• 3035: Added PasswordExpiryDate and ApiUser columns to stf table

• 3040: Added LastSuccessfulLogin to stf table

• 3045: Added UsePaymentDays to FloorPlanProfile table

• 3050: Added PaymentDate to AccTrn table

• 3055: Added DoNotUseOverrideRate to Distributor table

• 3065: Added DealerOverrideRate and DealerPostDueInFullOverrideRate to the BailmentDealer table

• 3070:

• Dropped DealerOverrideRate and DealerPostDueInFullOverrideRate from the BailmentDealer table

• Added DistributorRateProfile table

• 3076: Added UnusedFacilityIncludePrincipalRepayments to AccTyp table

• 3078: Added CollateralItemRegistryId to SecFinCol table

• 3079: Dropped column FacilityFeeStartPostingDate from LoAcc table

• 3079.1: Added SessionExpires to Stf table

• 2095: Added Session date to Stf table

• 3000: Added GridPreset and ColumnPreset tables

• 2075: Added LetterType to AccLet table.  Added AccLetExpiryDate and ResetAccLetExpiryDate to Acc table.

• 2080: Added Security Operation GeneralLedgerTrialBalanceReport

• 2090: Replaced GetAccountCommunicationExpiryDate scalar function.

• 1995: Added AssetPaidinFull date to BailmentAccount table

• 1975: Added BailmentOrder table and LastOrderNumber column to BailmentDealer

• 1970: Added column WarrantyDate to BailmentAccount table

• 2000: Added column BailmentOrderID to BailmentAccount table

• 2005: Added columns FreeFloorPlanPeriodEndDate and DueInFullDate to BailmentAccount table

• 2010: Added column GSTRules to Cur table

• 2015: Inserted default value for Bailment Curtailment Model control

• 2030: Added column CurtailmentModel to BailmentAccount table

• 2040: Added column CurtailmentPaymentTaxTransactionTypeNum to AccTyp with related foreign keys

• 2045: Added column BailmentAccountId to Invoice table with related foreign keys

• 2050: Added GetFreeFloorPlanPeriodEndDate and GetDueInFullDate functions

• 2055: Added CurtailmentInvoiceReportFile to Company table

• 2060: Added column CurtailmentTaxTransferTransactionTypeNumto AccTyp with related foreign keys

• 2065: Dropped column HasCurtailmentArrangement from BailmentAccount table

• 2070: Added column AdvancedCurtailmentTaxTotal to Invoice table

• 2071: Changed OriginatingAccount column length to 10 on CbStm and AccTrn tables

• 2072: Added DealerMargin to BailmentDealer

• 2073: Added LastFailedLogin and FailedLoginCount to Stf table

• 2073.2: Added AlpIdx index to Stf. Unique code enforcement.
  

• 1940: Added columns UnusedFacilityIncludeArrears, FacilityFeeAccTrnTypNum to AccTyp

• 1945: Added columns FacilityRate, FacilityFeeNextPostingDate, FacilityFrequency, FacilityDay, FacilityFeePreviousPostingDate to LoAcc

• 1960: Added column FacilityFeeStartPostingDate to table LoAcc

• 1920: Added NoCurtailment column to BailmentDealer

• 1925: Add IntendedCurtailmentPayment column to BailmentAccount

• 1930: Add CurtailmentPaymentProcessedDate column to BailmentAccount

• 1936:

• Added Category to Tag

• Added Code to Tag

• Added Description to Tag

• Removed Value from Tag

• 1937: Added CurtailmentDirectDebit  table

• 1880: Added Curtailment Spread MIN/MAX to Ctl
  

• 1835:

• Added Tag table

• Added ClientTag table

• 1840

• Added IsPIERate to WithholdingTaxCode

• Altered Wth view to add IsPIERate

• 1845: Changed Wth.Des to be varchar

• 1825: Added MortgageReference to LoAcc

• 1830: Changed definition of CreditStatus.Notes to nvarchar(max)

• 1760: Foreign key relationship, SecMak to BailmentAsset

• 1765: Added HpInsuranceRebateIndicator column to AccTyp

• 1770: Added PasswordHash column to Stf

• 1780: Dropped Password column from Stf

• 1785: Added foreign key from Distributor.SecurityMakeForEDIAccounts to SecMak

• 1795: Added SalesUserId to BailmentDealer and foreign key to Stf

• Added table Funder

• Added FunderId column to BailmentAccount table

• Added BusinessNumber column to Cli table