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
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class TravelIDMappingFields

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