Class CounterValueRecordData
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the CounterValue table.
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class CounterValueRecordData : ObjectRemarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Constructors
CounterValueRecordData()
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the CounterValue table.
Declaration
public CounterValueRecordData()Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Fields
AmountClassId
Sale amount class, for splitting sale counters by amounts
Declaration
public int AmountClassIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
ContactId
Link to contact, 0 if this counter is not for contacts
Declaration
public int ContactIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
CounterValueId
Primary key
Declaration
public int CounterValueIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Direction
Same as task.direction: Direction: 0 = none, 1 = incoming, 2 = outgoing
Declaration
public short DirectionField Value
| Type | Description |
|---|---|
| Int16 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Extra1Count
Total registered records of this type in the second period (there are up to three period definitions)
Declaration
public uint Extra1CountField Value
| Type | Description |
|---|---|
| UInt32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Extra1Id
Spare ID for future links
Declaration
public int Extra1IdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Extra2Count
Total records with status Not Completed in the second period (there are up to three period definitions)
Declaration
public uint Extra2CountField Value
| Type | Description |
|---|---|
| UInt32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Extra2Id
Spare ID for future links
Declaration
public int Extra2IdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Extra3Count
Total registered records of this type in the third period (there are up to three period definitions)
Declaration
public uint Extra3CountField Value
| Type | Description |
|---|---|
| UInt32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Extra4Count
Total records with status Not Completed in the third period (there are up to three period definitions)
Declaration
public uint Extra4CountField Value
| Type | Description |
|---|---|
| UInt32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
IntentId
Link to Intent list
Declaration
public int IntentIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
LastCompleted
ActiveDate/SaleDate/CreatedAt of last COMPLETED activity/sale/ticket of this type
Declaration
public DateTime LastCompletedField Value
| Type | Description |
|---|---|
| DateTime |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
LastDoBy
ActiveDate/SaleDate/CreatedAt of last NOT COMPLETED activity/sale/ticket of this type
Declaration
public DateTime LastDoByField Value
| Type | Description |
|---|---|
| DateTime |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
LastRegistered
ActiveDate/SaleDate/CreatedAt of last activity/sale/ticket of this type
Declaration
public DateTime LastRegisteredField Value
| Type | Description |
|---|---|
| DateTime |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
NotCompleted
Total records with status Not Completed
Declaration
public uint NotCompletedField Value
| Type | Description |
|---|---|
| UInt32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
NotCompletedInPeriod
Total records with status Not Completed in the first period (there are up to three period definitions)
Declaration
public uint NotCompletedInPeriodField Value
| Type | Description |
|---|---|
| UInt32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
PersonId
Link to person, 0 if this counter is not for person (always 0 in 6.0)
Declaration
public int PersonIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
ProjectId
Link to project, 0 if this counter is not for project
Declaration
public int ProjectIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
RecordType
Same as task.record_type: 1 = app, 2 = doc, 3 = email, 4 = fax, 5 = phone, 6 = todo - see EAppntRecordTypes
Declaration
public short RecordTypeField Value
| Type | Description |
|---|---|
| Int16 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Registered
Registered when in UTC.
Declaration
public DateTime RegisteredField Value
| Type | Description |
|---|---|
| DateTime |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
RegisteredAssociateId
Registered by whom
Declaration
public int RegisteredAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
SaleStatus
Sale status: 0 = Unknown, 1 = open, 2 = closed, 3 = lost, 4 = all sales
Declaration
public SaleStatus SaleStatusField Value
| Type | Description |
|---|---|
| SaleStatus |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
TotalReg
Total registered records of this type
Declaration
public uint TotalRegField Value
| Type | Description |
|---|---|
| UInt32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
TotalRegInPeriod
Total registered records of this type in the first period (there are up to three period definitions)
Declaration
public uint TotalRegInPeriodField Value
| Type | Description |
|---|---|
| UInt32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Updated
Last updated when in UTC.
Declaration
public DateTime UpdatedField Value
| Type | Description |
|---|---|
| DateTime |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
UpdatedAssociateId
Last updated by whom
Declaration
public int UpdatedAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
UpdatedCount
Number of updates made to this record
Declaration
public short UpdatedCountField Value
| Type | Description |
|---|---|
| Int16 |
Remarks
Please use this class instead of a full CounterValueRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding CounterValueTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.