Account_static_change

Metadata

  • Base Table Class: Change
  • Not in MDB
  • Default Size: Account * 10 = 5000

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this Account_static.
StatusSet of Status4
TimestampInteger (unsigned)8The time at which this change record was generated. This is not the same as the business-level timestamp of this Account_static_change.
AccountCodeString40The human readable identifier of the Account. It is a free text field, up to a maximum of 40 characters.
AccountNameString254
AccountTypeForeign key to AccountType8
FirmForeign key to Firm8
ParentAccountForeign key to Account8
DefaultRatioInteger (signed)8
BankAccountForeign key to BankAccount8
ExternalFKInteger (unsigned)8
VirtualReferenceNumberString20
NeedsNewVirtualReferenceNumberInteger (unsigned)1
MetaDataString1024
SoftBlockInteger (unsigned)1
UpdateNumberInteger (unsigned)8A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record.
BCSequenceInteger (unsigned)8The sequence number of this Account_static_change message in the overall broadcast sequence.
ReloadedInteger (unsigned)1Set to true for change records that are generated during a normal startup from engine cache files.
InstanceIdInteger (unsigned)4
RunIdInteger (unsigned)4
ChangedFieldOne of KVPKey4
CreateUserForeign key to User8The Id of the User that created this Account_static.
CreateTimestampInteger (unsigned)8The time at which this Account_static was created.
UpdateUserForeign key to User8The Id of the User that last updated this Account_static.
UpdateTimestampInteger (unsigned)8The time at which this Account_static was last updated.
← Account
AccountLink →