• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

VisibleFor Table (196)

Some tooltip text!
• 3 minutes to read
 • 3 minutes to read

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

VisibleFor table relationship diagram

Indexes

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

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top