travelgeneratedtransaction Table (30)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
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 | Null |
|---|---|---|---|
| travelgeneratedtransaction_id | Primary key | PK | |
| travel_id | Central=0, Departm.=H01000000-H7F000000, Travel=assoc_id | Id | ● |
| tranlogfirst_id | This up/dwnfile holds transaction from traveltransactionlog_id = this number | FK traveltransactionlog | ● |
| tranloglast_id | This up/dwnfile holds transaction to traveltransactionlog_id = this number | FK traveltransactionlog | ● |
| recordstatus | gen, sent, ack. | UShort | ● |
| transmissionnumber | sequence pr. user | UInt | ● |
| transmissiontype | File or direct communication | UShort | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| travelgeneratedtransaction_id | PK | Clustered, Unique |
| 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.