RefCountRange table - SuperOffice

RefCountRange Table (172)

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

Fields

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

Indexes

Fields	Types	Description
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.

Related topics

RefCounts table soap_access table Get For Date Range Document properties EntityCounts table Get appointments

⌘I