Business Table (61)

Business MDO list item table. Business list table

Fields

NameDescriptionTypeNull
business_idPrimary keyPK
nameThe list itemString(239)
rankRank orderUShort●
tooltipTooltip or other descriptionString(254)●
deleted0 -> record is active 1 -> record is ‘deleted’ and should not be shown in listsUShort●
registeredRegistered whenUtcDateTime
registered_associate_idRegistered by whomFK associate
updatedLast updated whenUtcDateTime
updated_associate_idLast updated by whomFK associate
updatedCountNumber of updates made to this recordUShort

Business table relationship diagram

Indexes

FieldsTypesDescription
business_idPKClustered, Unique
nameString(239)Unique

Relationships

TableDescription
associateEmployees, resources and other users - except for External persons
BusinessGroupLinkUser group link table for Business, for MDO item hiding
BusinessHeadingLinkHeading link table for Business, for MDO headers
contactCompanies and Organizations.
personPersons

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user’s Role.