NEW3.02.00 · Released 15 August 2019
NEWfinPOWER Connect
Released in
3.02.00
15 August 2019
  1. Opened3 Apr
  2. Closed3 Apr
  3. Released15 Aug
Article 16036 Job J022129

Database changes; Replace "Other" field with "Properties" field

The "Other" field in various tables has been renamed "Properties".This affects the following tables:

  • Account
  • AccountArchiveClient
  • AccountLedger
  • AccountPayArrange
  • AccountRole
  • BankBranch
  • Calendar
  • CashRegister
  • Certificate
  • Client
  • ClientEmployment
  • ClientType
  • DecisionCard
  • Department
  • GlAccount
  • IdType
  • InformationList
  • LogSeverity
  • MailboxItem
  • PageSetSavedItem
  • ParameterSet
  • Pool
  • ProductType
  • Queue
  • QueueItem
  • SecurityStmtGroup
  • StatisticType
  • TaxCategory
  • TransactionType
  • User
  • UserPolicy
  • WorkflowHistory

The "Properties" field has been added. This affects the following tables:

  • AccountAppAccount
  • AccountArchive
  • AccountClient
  • AccountingPeriod
  • BankAccountSuspense
  • BatchBankTransaction
  • ClientBankAccount
  • ClientContactAddress
  • ClientContactMethod
  • ClientStatistic
  • TaxPeriod

The "Other" field in various tables has been removed. This affects the following tables:

  • AccountApp
  • AccountAppApplicant
  • AccountAppCalc
  • AccountAppCollateral
  • AccountAppType
  • AccountDisbursement
  • AccountHistory
  • AccountSec
  • AccountType
  • AccountTypePromotion
  • AccountTypeStdTran
  • BankAccount
  • BankAccountService
  • Branch
  • ClientGroup
  • Document
  • Element
  • Entity
  • ExternalParty
  • ExternalPartyComm
  • PageSet
  • PaymentMethod
  • Portal
  • PortalResource
  • ReportTemplate
  • Script
  • SecuredPartyGroup
  • SecurityStmt
  • SecurityStmtItem
  • SecurityType
  • UserGroup
  • WebConfig
  • WebSubscriber
  • Workflow
  • WorkflowItem
  • WorkflowType