Account; added UserDecimal fields

Ten new User decimal (currency/ money) fields have been added to the Account table/ object.

These are stored as separate numeric columns in the database so can be easily queried upon - as compared to User Data and User0 to User9 fields.

The new columns are not used by finPOWER Connect itself, so you are free to use for whatever purpose you require. Of course, you must script reading and writing them to be of any use.

They are accessed via the finAccount object, UserDecimal property. This is an indexed property, with a valid range of 0 through 9.

Dim Account As finAccount

Account = finBL.CreateAccount()

If Account.Load("[AccountId]") Then
  Account.UserDecimal(0) = Value

  Main = Account.Save
Else
  Main = False
End If