Article Details
Id:11216
Product:finPOWER Connect
Type:NEW
Version:2.00.00
Opened:08/10/2012
Closed:10/07/2013
Released:04/10/2013
Job: J010495

Database; new indexes added

The following indexes have been added (or changed) in the database.

Note, where "(extended)" is noted the index will only be added in SQL Server databases. Access databases are limited by the number of indexes they support.

  • Account
    • Description (extended)
  • AccountArchive
    • AccountId
    • ExternalId
    • Description
  • Client
    • FirstName
    • ExternalId (extended)
    • CrossReference (extended) - was a regular index but now dropped to allow FirstName to be indexed
    • LegalName (extended)
    • OrganisationNumber (extended)
    • BusinessNumber (extended)
    • IndividualNumber (extended)
  • ClientContactAddress:
    • StreetAddressFull (extended)
    • Suburb
    • City
    • State
  • ClientContactMethod:
    • Value
  • ClientId:
    • Value
  • SecurityStmt:
    • Description
    • ExternalId (new field in version 2)
    • RegisterId
  • SecurityStmtItem:
    • Make
    • Model
    • RegisterId