traveltransactionlog Table (29)
•
Environment: onsite, online
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 | ● |
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.