Transactions

Fields

Field	Field Type	Null	Notes	Description
ID	int
TransactionID	int
TransactionType	nvarchar(100)
Data	ntext	yes
ProcessedDate	datetime	yes
IsDeleted	bit		Default = 0
BeginDownload	datetime	yes
EndDownload	datetime	yes
BBNCUserID	int	yes
BackOfficeID	int	yes
DownloadUserID	int	yes	Default = 0

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_Transactions_EndDownload_DownloadUserID_BeginDownLoad	EndDownload, DownloadUserID, BeginDownload
PK_Transactions	ID			yes