Class DBC.TravelIDMappingFields

Fields for TravelIDMapping, Mapping of primary keys between Travel databases and the mother database All travel database transactions get a high id to be able to see that this entry came from a database outside the central database. When update files are read into the central database, they get a normal low id. This table remembers the high travel id to map it to the low central id as long as this travel user is travelling.

Inheritance

Object

DBC.TravelIDMappingFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class TravelIDMappingFields : Object

Fields

AssociateId

TravelIDMapping.AssociateId: Associate id (traveller)

Declaration

public const string AssociateId = "associate_id"

Field Value

Type	Description
String

CdbName

TravelIDMapping.CdbName: Conceptual database name if != standard database

Declaration

public const string CdbName = "cdbName"

Field Value

Type	Description
String

Counter

TravelIDMapping.Counter: How many consecutive ID's

Declaration

public const string Counter = "counter"

Field Value

Type	Description
String

LocalId

TravelIDMapping.LocalId: ID on traveller

Declaration

public const string LocalId = "local_id"

Field Value

Type	Description
String

ParentId

TravelIDMapping.ParentId: ID on parent database

Declaration

public const string ParentId = "parent_id"

Field Value

Type	Description
String

Registered

TravelIDMapping.Registered: Registered when

Declaration

public const string Registered = "registered"

Field Value

Type	Description
String

RegisteredAssociateId

TravelIDMapping.RegisteredAssociateId: Registered by whom

Declaration

public const string RegisteredAssociateId = "registered_associate_id"

Field Value

Type	Description
String

TableNumber

TravelIDMapping.TableNumber: Database table number

Declaration

public const string TableNumber = "table_number"

Field Value

Type	Description
String

TravelidmappingId

TravelIDMapping.TravelidmappingId: Primary key

Declaration

public const string TravelidmappingId = "travelidmapping_id"

Field Value

Type	Description
String

Updated

TravelIDMapping.Updated: Last updated when

Declaration

public const string Updated = "updated"

Field Value

Type	Description
String

UpdatedAssociateId

TravelIDMapping.UpdatedAssociateId: Last updated by whom

Declaration

public const string UpdatedAssociateId = "updated_associate_id"

Field Value

Type	Description
String

UpdatedCount

TravelIDMapping.UpdatedCount: Number of updates made to this record

Declaration

public const string UpdatedCount = "updatedCount"

Field Value

Type	Description
String