Class TravelTransactionLogTableInfo
Table 'traveltransactionlog': Log of all updates made to the database, that need to be replicated.
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("traveltransactionlog")]
public class TravelTransactionLogTableInfo : TableInfo, ICloneable
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Fields
DictionaryTableName
Conceptual name of table TravelTransactionLog in the database dictionary: traveltransactionlog
Declaration
public const string DictionaryTableName = "traveltransactionlog"
Field Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Properties
ApplicationId
Field 'application_id' in table 'traveltransactionlog': Dictionary type Int, .NET type: Int32
ID of the application/client/owner of the context in which this record was written. This is primarily an Online feature, but the value int.MaxValue denotes the Win clientDeclaration
public Int32FieldInfo ApplicationId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AssociateId
Field 'associate_id' in table 'traveltransactionlog': Dictionary type FK, target: Associate, .NET type: Int32
Who did itDeclaration
public Int32FieldInfo AssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AssociateId_InnerJoin_Associate
Generated join from the foreign key AssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> AssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
DictionaryTableNumber
Table number for table TravelTransactionLog in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database
Declaration
public int DictionaryTableNumber { get; }
Property Value
Type | Description |
---|---|
Int32 |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Flags
Field 'flags' in table 'traveltransactionlog': Dictionary type Enum, .NET type: TtlFlags
Extra information about the operation, as a bit-masked fieldDeclaration
public TtlFlagsFieldInfo Flags { get; }
Property Value
Type | Description |
---|---|
TtlFlagsFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_TravelCurrent_FirstRecordnumber
Generated left outer join from the primary key TraveltransactionlogId on this table, to TravelCurrent.FirstRecordnumber.
Declaration
public TargetedLeftOuterJoin<TravelCurrentTableInfo> LeftOuterJoin_TravelCurrent_FirstRecordnumber { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TravelCurrentTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_TravelCurrent_LastRecordnumber
Generated left outer join from the primary key TraveltransactionlogId on this table, to TravelCurrent.LastRecordnumber.
Declaration
public TargetedLeftOuterJoin<TravelCurrentTableInfo> LeftOuterJoin_TravelCurrent_LastRecordnumber { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TravelCurrentTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_TravelGeneratedTransaction_TranlogfirstId
Generated left outer join from the primary key TraveltransactionlogId on this table, to TravelGeneratedTransaction.TranlogfirstId.
Declaration
public TargetedLeftOuterJoin<TravelGeneratedTransactionTableInfo> LeftOuterJoin_TravelGeneratedTransaction_TranlogfirstId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TravelGeneratedTransactionTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_TravelGeneratedTransaction_TranloglastId
Generated left outer join from the primary key TraveltransactionlogId on this table, to TravelGeneratedTransaction.TranloglastId.
Declaration
public TargetedLeftOuterJoin<TravelGeneratedTransactionTableInfo> LeftOuterJoin_TravelGeneratedTransaction_TranloglastId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TravelGeneratedTransactionTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_Traveller_LastPlaybacknumber
Generated left outer join from the primary key TraveltransactionlogId on this table, to Traveller.LastPlaybacknumber.
Declaration
public TargetedLeftOuterJoin<TravellerTableInfo> LeftOuterJoin_Traveller_LastPlaybacknumber { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TravellerTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_Traveller_LastRecordnumber
Generated left outer join from the primary key TraveltransactionlogId on this table, to Traveller.LastRecordnumber.
Declaration
public TargetedLeftOuterJoin<TravellerTableInfo> LeftOuterJoin_Traveller_LastRecordnumber { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TravellerTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
PrevRecordId
Field 'prev_record_id' in table 'traveltransactionlog': Dictionary type Id, .NET type: Int32
Additional informationDeclaration
public Int32FieldInfo PrevRecordId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RecordId
Field 'record_id' in table 'traveltransactionlog': Dictionary type RecordId, .NET type: Int32
Record that was updatedDeclaration
public Int32FieldInfo RecordId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Tablenumber
Field 'tablenumber' in table 'traveltransactionlog': Dictionary type TableNumber, .NET type: Int16
Table that was updatedDeclaration
public UInt16FieldInfo Tablenumber { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
TraveltransactionlogId
Field 'traveltransactionlog_id' in table 'traveltransactionlog': Dictionary type PK, .NET type: Int32
Primary keyDeclaration
public Int32FieldInfo TraveltransactionlogId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Ttime
Field 'ttime' in table 'traveltransactionlog': Dictionary type DateTime, .NET type: DateTime
Time/datestamp of eventDeclaration
public DateTimeFieldInfo Ttime { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Type
Field 'type' in table 'traveltransactionlog': Dictionary type Enum, .NET type: TrlogTransType
Type of eventDeclaration
public TrlogTransTypeFieldInfo Type { get; }
Property Value
Type | Description |
---|---|
TrlogTransTypeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Methods
IdxTablenumber(Int16)
Shortcut method for looking up using the database index Tablenumber, which spans the following fields:
Field | Description |
---|---|
Tablenumber | Table that was updated |
Declaration
public Restriction IdxTablenumber(short tablenumber)
Parameters
Type | Name | Description |
---|---|---|
Int16 | tablenumber |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxType(TrlogTransType)
Shortcut method for looking up using the database index Type, which spans the following fields:
Field | Description |
---|---|
Type | Type of event |
Declaration
public Restriction IdxType(TrlogTransType type)
Parameters
Type | Name | Description |
---|---|---|
TrlogTransType | type |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxTypeTablenumber(TrlogTransType, Int16)
Shortcut method for looking up using the database index TypeTablenumber, which spans the following fields:
Field | Description |
---|---|
Type | Type of event |
Tablenumber | Table that was updated |
Declaration
public Restriction IdxTypeTablenumber(TrlogTransType type, short tablenumber)
Parameters
Type | Name | Description |
---|---|---|
TrlogTransType | type | |
Int16 | tablenumber |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling