FirmName

The FirmName table is a public form of the Firm table that may be distributed to any user. It is created automatically from the Firm table.

Metadata

  • Base Table Class: Static
  • Default Size: Firm = 50

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this FirmName.
StatusSet of Status4
ShortNameString24The short text identifier of this FirmName.
NameString48The long text identifier of this FirmName.
FirmTypeOne of FirmType1
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.
OwnerUserForeign key to User8The Id of the User that owns this FirmName.
OwnerGroupForeign key to Group8The Id of the Group that owns this FirmName.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this FirmName.
CreateUserForeign key to User8The Id of the User that created this FirmName.
CreateTimestampInteger (unsigned)8The time at which this FirmName was created.
UpdateUserForeign key to User8The Id of the User that last updated this FirmName.
UpdateTimestampInteger (unsigned)8The time at which this FirmName was last updated.