Transaction Table

Identifies transaction for the entity at its state upon export.

Table 18. The Transaction Table

Attribute	Data Type	Definition
TransactionID	int	A key identifying a specific transaction.
HSFTransID	nvarchar	Identifies the transaction number of the export transaction in Strategic Finance.
AnalysisID	int	A reference to the Analysis table.
ExportDate	int	The date of export.
HSFArchiveNumber	int	Stores the archive number.
UserName	nvarchar	Stores the username of the user who performed the transaction.
ServerID	nvarchar	A string identifying the sourceStrategic Finance server.
DBName	nvarchar	A string identifying the source database.
PushType	nvarchar	Identifies the event triggering the transaction. For example, consolidation run, entity check in, etc.