> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# traveltransactionlog table

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

## traveltransactionlog Table (29)

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

## Fields

| Name                     | Description                                                                                                                                                                | Type                                              | Nullable |
| ------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------- | :------: |
| traveltransactionlog\_id | Primary key                                                                                                                                                                | PK                                                |    No    |
| ttime                    | Time/datestamp of event                                                                                                                                                    | DateTime                                          |    No    |
| prev\_record\_id         | Additional information                                                                                                                                                     | Id                                                |    No    |
| type                     | Type of event                                                                                                                                                              | Enum [TrlogTransType](./enums/trlogtranstype.mdx) |    No    |
| associate\_id            | Who did it                                                                                                                                                                 | FK [associate](./associate.mdx)                   |    No    |
| tablenumber              | Table that was updated                                                                                                                                                     | TableNumber                                       |    No    |
| record\_id               | Record that was updated                                                                                                                                                    | RecordId                                          |    No    |
| flags                    | Extra information about the operation, as a bit-masked field                                                                                                               | Enum [TtlFlags](./enums/ttlflags.mdx)             |    Yes   |
| 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                                               |    Yes   |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/traveltransactionlog.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=e6be367c958d966c90148c78512b1e58" alt="traveltransactionlog table relationship diagram" width="1009" height="899" data-path="media/loc/en/database/tables/traveltransactionlog.png" />

## Indexes

| Fields                                      | Types                 | Description |
| ------------------------------------------- | --------------------- | ----------- |
| ttime                                       | DateTime              | Index       |
| tablenumber, record\_id                     | TableNumber, RecordId | Index       |
| type, tablenumber, traveltransactionlog\_id | Enum, TableNumber, PK | Index       |

## Relationships

| Table                                                      | Description                                                                                                                                         |
| ---------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------- |
| [associate](./associate)                                   | Employees, resources and other users - except for External persons                                                                                  |
| [travelcurrent](./travelcurrent)                           | Information about this database and its place in the hierarchy                                                                                      |
| [travelgeneratedtransaction](./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](./traveller)                                   | Associates traveling out from this database                                                                                                         |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [travelgeneratedtransaction table](/en/database/tables/travelgeneratedtransaction.md)
- [travelcurrent table](/en/database/tables/travelcurrent.md)
- [traveller table](/en/database/tables/traveller.md)
- [SuperOffice.WebApi.Agents.DatabaseTableAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.DatabaseTableAgent.md)
- [SuperOffice.WebApi.Agents.IDatabaseTableAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.IDatabaseTableAgent.md)
- [What's new in version 10.3.9.718](/release-notes/database/changes-10.3.9.md)