• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

traveltransactionlog Table (29)

Some tooltip text!
• 3 minutes to read
 • 3 minutes to read

Log of all updates made to the database, that need to be replicated.

Fields

Name Description Type Null
traveltransactionlog_id Primary key PK
ttime Time/datestamp of event DateTime
prev_record_id Additional information Id
type Type of event Enum TrlogTransType
associate_id Who did it FK associate
tablenumber Table that was updated TableNumber
record_id Record that was updated RecordId
flags Extra information about the operation, as a bit-masked field Enum TtlFlags ●
application_id 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 client Int ●

traveltransactionlog table relationship diagram

Value for field type in traveltransctionlog

This is the type of update the log record refers to.  Valid types are:

Type ID Comment
Unknown 0 Unknown - used when initializing
Insert 4352 A record has been inserted
Update 4608 A record has been updated
Delete 4864 A record has been deleted
UpdateOwner 5120 The owning associate_id of the target record has been updated, old value in PrevrecordId
OldUpdateContact 5376 (Obsolete) The contact_id of the target record has been updated, old value in PrevRecordId
OldUpdateProject 5632 (Obsolete) The project_id of the target record has been updated, old value in PrevRecordId
DeleteAreaUserInclusion 5888 A previously included (data inclusion) user has been removed from an area
DeleteAreaUserAssignment 6144 A previously assigned (login rights) user has been delete from an Area
PublishUdef 6400 A new layout for User-defined fields has been published (tablenumber = 7, 8, 9 or 10 (check table udeffield)
UpdateFieldPart1 8192 (Reserved) Bitmap of updated fields
UpdateFieldPart2 8193 (Reserved) Bitmap of updated fields
UpdateFieldPart3 8194 (Reserved) Bitmap of updated fields
UpdateFieldPart4 8195 (Reserved) Bitmap of updated fields
UpdateFieldPart5 8196 (Reserved) Bitmap of updated fields
UpdateFieldPart6 8197 (Reserved) Bitmap of updated fields
UpdateFieldPart7 8198 (Reserved) Bitmap of updated fields
UpdateFieldPart8 8199 (Reserved) Bitmap of updated fields
UpdateContact 10000 The + contact_id_ of the target record has been changed, old value in PrevRecordId
UpdateProject 20000 The + project_id_ of the target record has been updated, old value in PrevRecordId

Indexes

Fields Types Description
traveltransactionlog_id PK Clustered, Unique
ttime DateTime Index
tablenumber, record_id TableNumber, RecordId Index
type, tablenumber, traveltransactionlog_id Enum, TableNumber, PK Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
travelcurrent Information about this database and its place in the hierarchy
travelgeneratedtransaction Record of all generated replication data files from this database (*.dwn files from mother database to child, *.up from child database to mother)
traveller Associates traveling out from this database

Replication Flags

  • None

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top