traveltransactionlog table - SuperOffice

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	No
associate_id	Who did it	FK associate	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	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

traveltransactionlog table relationship diagram

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	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.