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

RefCounts Table (171)

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

Number counter for all tables that generate numbers, e.g. templates, contacts... This table is used for the number allocation system and should not be confused with sequence, used for allocating internal ID's. This table is replicated during generation of satellites and during local update for travellers, using special logic. By default it contains rows for the SuperOffice standard counters, including one row for each DocTemplate record. It is permissible to add new rows to this table, and such records are maintainable through the Maintenance client. Changing the contents of the standard records is not recommended.

Fields

Name Description Type Null
RefCounts_id Primary key PK
fieldId The field (and thereby table) this counter is assigned to FieldId
recordId Record id in target table, used when there are separate counters for each target record Id
currentValue Current value of counter Id
travelPrefix size of prefix for Travel use of ths counter UInt
satPrefix size of prefix for Satellite use of this counter UInt
flags Unique, active, read-only, allow blank, … Enum RefcountFlags
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

RefCounts table relationship diagram

Value for flag field in refcounts

flags ID Comment
Unknown 0 Unknown - used when initializing
Allocate  1 Perform number allocation automatically
Unique 2 Check that entered values are unique
ReadOnly 4 Target field is read-only in GUI
AllowBlank 8 Blank is a legal value

Indexes

Fields Types Description
RefCounts_id PK Clustered, Unique
fieldId FieldId Index
recordId Id Index
fieldId, recordId FieldId, Id Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
RefCountRange Number allocation system, for keeping track of ranges of numbers loaned out to travel and satellite databases

Replication Flags

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