Enterprise_static_change

Metadata

  • Base Table Class: Change
  • Not in MDB
  • Default Size: 1000

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this Enterprise_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 Enterprise_static_change.
ShortNameString24The short text identifier of this Enterprise_static_change.
ExternalFKInteger (unsigned)8
NameString48The long text identifier of this Enterprise_static_change.
CountryForeign key to Country8
SettlementCurrencyForeign key to Instrument8
MetaDataString1024
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 Enterprise_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 Enterprise_static.
CreateTimestampInteger (unsigned)8The time at which this Enterprise_static was created.
UpdateUserForeign key to User8The Id of the User that last updated this Enterprise_static.
UpdateTimestampInteger (unsigned)8The time at which this Enterprise_static was last updated.