uid	title	description	so.generated	keywords	so.topic	so.envir
table-VisibleFor	VisibleFor table	Visible for rights, who may see this appointment/document, sale, salehist or selection	true	database table VisibleFor	reference	onsite, online

VisibleFor Table (196)

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

Fields

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

[!includedetails]

Fields	Types	Description
VisibleFor_id	PK	Clustered, Unique
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

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

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.