RefCountRange Table (172)
•
Environment: onsite, online
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 |
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.