Article Details
Id:16036
Product:finPOWER Connect
Type:NEW
Version:3.02.00
Opened:03/04/2019
Closed:03/04/2019
Released:15/08/2019
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