travelgeneratedtransaction table - SuperOffice

travelgeneratedtransaction Table (30)

Record of all generated replication data files from this database (*.dwn files from mother database to child, *.up from child database to mother)

Fields

Name	Description	Type	Nullable
travelgeneratedtransaction_id	Primary key	PK	No
travel_id	Central=0, Departm.=H01000000-H7F000000, Travel=assoc_id	Id	Yes
tranlogfirst_id	This up/dwnfile holds transaction from traveltransactionlog_id = this number	FK traveltransactionlog	Yes
tranloglast_id	This up/dwnfile holds transaction to traveltransactionlog_id = this number	FK traveltransactionlog	Yes
recordstatus	gen, sent, ack.	UShort	Yes
transmissionnumber	sequence pr. user	UInt	Yes
transmissiontype	File or direct communication	UShort	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description
travel_id	Id	Index
transmissionnumber, travel_id	UInt, Id	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
traveltransactionlog	Log of all updates made to the database, that need to be replicated.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

traveltransactionlog table SQL Server schema for Database Mirroring associate table Blocked tables list extra_tables table ext_table table

⌘I