PROCESSORTRANSACTIONSETTLEMENTIMPORT

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
MD5SUM	nvarchar(32)		Default = ''
FILENAME	nvarchar(100)		Default = ''
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
NAME	nvarchar(150)		Default = ''
HASAUTHCODE	bit		Default = 0
TOTALIMPORTTRANSACTIONS	int		Default = 0
ISDUPLICATEFILEUPLOAD	bit		Default = 0
STATUSCODE	tinyint		Default = 0
STATUS	nvarchar(34) (Computed)	yes	CASE [STATUSCODE] WHEN 0 THEN N'Processing' WHEN 1 THEN N'Successful' WHEN 2 THEN N'Invalid date or auth code column' WHEN 3 THEN N'Invalid amount column' WHEN 4 THEN N'Invalid date or card number column' END
DISBURSEMENTID	uniqueidentifier	yes
IMPORTTYPECODE	tinyint		Default = 0
IMPORTTYPE	nvarchar(16) (Computed)	yes	CASE [IMPORTTYPECODE] WHEN 0 THEN N'ManualFileUpload' WHEN 1 THEN N'BBMSAutoImport' END
VENDORID	nvarchar(4000)		Default = ''
DISBURSEMENTDATE	date	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_PROCESSORTRANSACTIONSETTLEMENTIMPORT_DATEADDED	DATEADDED			yes
IX_PROCESSORTRANSACTIONSETTLEMENTIMPORT_DATECHANGED	DATECHANGED
IX_PROCESSORTRANSACTIONSETTLEMENTIMPORT_MD5SUM	MD5SUM
PK_PROCESSORTRANSACTIONSETTLEMENTIMPORT	ID	yes	yes
UC_PROCESSORTRANSACTIONSETTLEMENTIMPORT_NAME	NAME	yes

Triggers

Trigger Name	Description
TR_PROCESSORTRANSACTIONSETTLEMENTIMPORT_AUDIT_UPDATE
TR_PROCESSORTRANSACTIONSETTLEMENTIMPORT_AUDIT_DELETE

Referenced by

Referenced by	Field
PROCESSORTRANSACTIONSETTLEMENTIMPORTROW	PROCESSORTRANSACTIONSETTLEMENTIMPORTID
PROCESSORTRANSACTIONSETTLEMENTIMPORTSTATUS	PARAMETERSETID
UNSETTLEDCREDITCARDTRANSACTION	PROCESSORTRANSACTIONSETTLEMENTIMPORTID