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