VisibleFor table - SuperOffice

VisibleFor Table (196)

Visible for rights, who may see this appointment/document, sale, salehist or selection

Fields

Name	Description	Type	Nullable
VisibleFor_id	Primary key	PK	No
tableId	ID of table this right is valid for	TableNumber	No
recordId	ID of row this right applies to	RecordId	No
forAll	1 = visible to all, 0 = not visible to all	Id	No
forGroupId	0 = not visible to any particular group, or ID of group	FK UserGroup	No
forAssocId	0 = not visible to any particular associate, or ID of associate	FK associate	No
encryptedCheck	Encrypted checksum field, to prevent tampering	String(254)	No
appointmentId	Shortcut: appointment id, if tableId = appointment; to give faster joins	FK appointment	Yes
saleId	Shortcut: sale id, if tableId = sale to give faster joins	FK sale	Yes
saleHistId	Shortcut: salehist id, if tableId = salehist to give faster joins	FK SaleHist	Yes
selectionId	Shortcut: selection id, if tableId = selection to give faster joins	FK selection	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

VisibleFor table relationship diagram

Indexes

Fields	Types	Description
appointmentId	FK	Index
saleId	FK	Index
saleHistId	FK	Index
selectionId	FK	Index
recordId, tableId	RecordId, TableNumber	Index
tableId, recordId, forAll, forGroupId, forAssocId	TableNumber, RecordId, Id, FK, FK	Index

Relationships

Table	Description
appointment	Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this.
associate	Employees, resources and other users - except for External persons
sale	Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels.
SaleHist	Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here.
selection	Selections
UserGroup	Secondary user groups

Replication Flags

Area Management controlled table. Contents replicated to satellites and traveller databases.
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.

Related topics

visiblefor selection table sale table appointment table udappntlarge table udappntsmall table

⌘I