Class CounterValueBulkImportFacade
Typed facade for an object[] that contains all the fields of the CounterValue table, intended for use with DatabaseOperations.DatabaseOperations.ImportTable for bulk import of data.
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class CounterValueBulkImportFacadeRemarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Constructors
CounterValueBulkImportFacade()
Typed facade for an object[] that contains all the fields of the CounterValue table, intended for use with DatabaseOperations.DatabaseOperations.ImportTable for bulk import of data.
Declaration
public CounterValueBulkImportFacade()Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Properties
AmountClassId
Sale amount class, for splitting sale counters by amounts
Declaration
public int AmountClassId { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.ContactId
Link to contact, 0 if this counter is not for contacts
Declaration
public int ContactId { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.CounterValueId
Primary key
Declaration
public int CounterValueId { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Direction
Same as task.direction: Direction: 0 = none, 1 = incoming, 2 = outgoing
Enums are stored as short's in the array, as they would otherwise be converted to their string representation during a bulk insert
Declaration
public short Direction { get; set; }Property Value
| Type | Description |
|---|---|
| short |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Extra1Count
Total registered records of this type in the second period (there are up to three period definitions)
Declaration
public uint Extra1Count { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Extra1Id
Spare ID for future links
Declaration
public int Extra1Id { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Extra2Count
Total records with status Not Completed in the second period (there are up to three period definitions)
Declaration
public uint Extra2Count { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Extra2Id
Spare ID for future links
Declaration
public int Extra2Id { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Extra3Count
Total registered records of this type in the third period (there are up to three period definitions)
Declaration
public uint Extra3Count { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Extra4Count
Total records with status Not Completed in the third period (there are up to three period definitions)
Declaration
public uint Extra4Count { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.IntentId
Link to Intent list
Declaration
public int IntentId { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.LastCompleted
ActiveDate/SaleDate/CreatedAt of last COMPLETED activity/sale/ticket of this type
Declaration
public DateTime LastCompleted { get; set; }Property Value
| Type | Description |
|---|---|
| DateTime |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.LastDoBy
ActiveDate/SaleDate/CreatedAt of last NOT COMPLETED activity/sale/ticket of this type
Declaration
public DateTime LastDoBy { get; set; }Property Value
| Type | Description |
|---|---|
| DateTime |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.LastRegistered
ActiveDate/SaleDate/CreatedAt of last activity/sale/ticket of this type
Declaration
public DateTime LastRegistered { get; set; }Property Value
| Type | Description |
|---|---|
| DateTime |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.NotCompleted
Total records with status Not Completed
Declaration
public uint NotCompleted { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.NotCompletedInPeriod
Total records with status Not Completed in the first period (there are up to three period definitions)
Declaration
public uint NotCompletedInPeriod { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.PersonId
Link to person, 0 if this counter is not for person (always 0 in 6.0)
Declaration
public int PersonId { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.ProjectId
Link to project, 0 if this counter is not for project
Declaration
public int ProjectId { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.RecordType
Same as task.record_type: 1 = app, 2 = doc, 3 = email, 4 = fax, 5 = phone, 6 = todo - see EAppntRecordTypes
Enums are stored as short's in the array, as they would otherwise be converted to their string representation during a bulk insert
Declaration
public short RecordType { get; set; }Property Value
| Type | Description |
|---|---|
| short |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Registered
Registered when in UTC.
Declaration
public DateTime Registered { get; set; }Property Value
| Type | Description |
|---|---|
| DateTime |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.RegisteredAssociateId
Registered by whom
Declaration
public int RegisteredAssociateId { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.RowData
Typed facade for an object[] that contains all the fields of the CounterValue table, intended for use with DatabaseOperations.DatabaseOperations.ImportTable for bulk import of data.
Declaration
public object[] RowData { get; }Property Value
| Type | Description |
|---|---|
| object[] |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.SaleStatus
Sale status: 0 = Unknown, 1 = open, 2 = closed, 3 = lost, 4 = all sales
Enums are stored as short's in the array, as they would otherwise be converted to their string representation during a bulk insert
Declaration
public SaleStatus SaleStatus { get; set; }Property Value
| Type | Description |
|---|---|
| SaleStatus |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.TotalReg
Total registered records of this type
Declaration
public uint TotalReg { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.TotalRegInPeriod
Total registered records of this type in the first period (there are up to three period definitions)
Declaration
public uint TotalRegInPeriod { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Updated
Last updated when in UTC.
Declaration
public DateTime Updated { get; set; }Property Value
| Type | Description |
|---|---|
| DateTime |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.UpdatedAssociateId
Last updated by whom
Declaration
public int UpdatedAssociateId { get; set; }Property Value
| Type | Description |
|---|---|
| int |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.UpdatedCount
Number of updates made to this record
Declaration
public short UpdatedCount { get; set; }Property Value
| Type | Description |
|---|---|
| short |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.Operators
implicit operator object[](CounterValueBulkImportFacade)
Typed facade for an object[] that contains all the fields of the CounterValue table, intended for use with DatabaseOperations.DatabaseOperations.ImportTable for bulk import of data.
Declaration
public static implicit operator object[](CounterValueBulkImportFacade r)Parameters
| Type | Name | Description |
|---|---|---|
| CounterValueBulkImportFacade | r |
Returns
| Type | Description |
|---|---|
| object[] |
Remarks
The bulk import system is based on generic row data, represented as an array of object. While this fits the bulk import functionality well, it may be convenient to have a typed, named way of accessing the elements of such an object. This class has an object[] as its data carrier, together with strongly typed access members.
On creation, the array is dimensioned and all members initialized with 'blank' values for their types (never null). There is an implicit conversion operator to object[], and it is also possible to access the array directly.