The table `itgen_transactions` holds: transactions are changes in the data registered by Invantive Estate in any table. Each change of an individual row is registered in ITGEN_TRANSACTIONS. The table can be used to analyze the origin on an unexpected change. Example: The transaction 534 took place yesterday as the user 'system' changed the budget for construction on the project 'City Hall' from 250.000 to 350.000. Its natural key code is `tan`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `action` (`varchar2(60)`, required): Action. The executed SQL action (select, insert, update or delete). - `comment_given` (`varchar2(128)`): Comment Given. Comment. - `logon_code` (`varchar2(128)`, required): User name. The name of the login account used by the user as defined in BUBS_USERS. - `machine` (`varchar2(128)`, required): Machine. Name of the workstation used to access the application. - `module` (`varchar2(128)`, required): Module. Name of the module installed. - `sessionid` (`varchar2(240)`, required): Session-ID. Unique ID of the session executing the transaction. - `table_name` (`varchar2(30)`, required): Table Name. Name of the business object changed. - `table_reference` (`number`, required): Table Reference. Value of the object's ID within the business object that changed. - `time` (`datetime`, required): Time. Time of the RDBMS server at which the event occurred. - `time_cs` (`number`, required): Time (cs). The number of 100th's of a second from some arbitrary epoch. This time is typically used to determine the difference in time between two events. - `transaction_number` (`number`, required): Transaction Number. Unique numeric code, introduced to create an artificial natural unique index and it's value is identical to the value of the column ID. ## Indexes The table has these indexes: - `itgen_tan_nk` (unique) on `transaction_number`. - `itgen_tan_pk` (unique) on `id`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].