| CounterValue_id | Primary key | PK | No |
| contact_id | Link to contact, 0 if this counter is not for contacts | FK contact | No |
| person_id | Link to person, 0 if this counter is not for person (always 0 in 6.0) | FK person | No |
| project_id | Link to project, 0 if this counter is not for project | FK project | No |
| extra1_id | Spare ID for future links | Id | No |
| extra2_id | Spare ID for future links | Id | No |
| record_type | Same as task.record_type: 1 = app, 2 = doc, 3 = email, 4 = fax, 5 = phone, 6 = todo - see EAppntRecordTypes | Enum AppntRecordType | No |
| direction | Same as task.direction: Direction: 0 = none, 1 = incoming, 2 = outgoing | Enum AppntDirection | No |
| intent_id | Link to Intent list | FK Intent | No |
| sale_status | Sale status: 0 = Unknown, 1 = open, 2 = closed, 3 = lost, 4 = all sales | Enum SaleStatus | No |
| amountClassId | Sale amount class, for splitting sale counters by amounts | FK AmountClass | No |
| totalReg | Total registered records of this type | UInt | No |
| totalRegInPeriod | Total registered records of this type in the first period (there are up to three period definitions) | UInt | No |
| notCompleted | Total records with status Not Completed | UInt | No |
| notCompletedInPeriod | Total records with status Not Completed in the first period (there are up to three period definitions) | UInt | No |
| lastRegistered | ActiveDate/SaleDate/CreatedAt of last activity/sale/ticket of this type | DateTime | Yes |
| lastCompleted | ActiveDate/SaleDate/CreatedAt of last COMPLETED activity/sale/ticket of this type | DateTime | Yes |
| lastDoBy | ActiveDate/SaleDate/CreatedAt of last NOT COMPLETED activity/sale/ticket of this type | DateTime | Yes |
| extra1_count | Total registered records of this type in the second period (there are up to three period definitions) | UInt | Yes |
| extra2_count | Total records with status Not Completed in the second period (there are up to three period definitions) | UInt | Yes |
| extra3_count | Total registered records of this type in the third period (there are up to three period definitions) | UInt | Yes |
| extra4_count | Total records with status Not Completed in the third period (there are up to three period definitions) | UInt | Yes |
| 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 |
