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

RefCountRange Table (172)

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

Number allocation system, for keeping track of ranges of numbers loaned out to travel and satellite databases

Fields

Name Description Type Null
RefCountRange_id Primary key PK
rangeStart Start of range that is in use UInt
rangeSize Size of in-use range UInt
RefCounts_id ID of counter this range is reserved for FK RefCounts
traveller_id ID of traveller (associate) who owns this range UShort
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
highestInUse The highest number (within the range) that is currently in use. This used to be the infamous preference! UInt

RefCountRange table relationship diagram

Indexes

Fields Types Description
RefCountRange_id PK Clustered, Unique
RefCounts_id FK Index
traveller_id UShort Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
RefCounts 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.

Replication Flags

  • None

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