POSTTOGLPROCESSTRANSACTIONTYPEFILTER

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
TYPECODE	tinyint		Default = 0
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
TYPE	nvarchar(27) (Computed)	yes	CASE [TYPECODE] WHEN 0 THEN N'Payment' WHEN 1 THEN N'Pledge' WHEN 2 THEN N'Recurring gift' WHEN 3 THEN N'Matching gift claim' WHEN 4 THEN N'Planned gift' WHEN 5 THEN N'Order' WHEN 6 THEN N'Grant award' WHEN 7 THEN N'Auction donation' WHEN 8 THEN N'Donor challenge claim' WHEN 15 THEN N'Membership installment plan' WHEN 20 THEN N'Write off' WHEN 21 THEN N'Sold stock' WHEN 22 THEN N'Sold property' WHEN 23 THEN N'Refund' WHEN 26 THEN N'Payout' WHEN 27 THEN N'Sold Gift-in-kind' END

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_POSTTOGLPROCESSTRANSACTIONTYPEFILTER_DATEADDED	DATEADDED			yes
IX_POSTTOGLPROCESSTRANSACTIONTYPEFILTER_DATECHANGED	DATECHANGED
IX_POSTTOGLPROCESSTRANSACTIONTYPEFILTER_POSTTOGLPROCESSID	POSTTOGLPROCESSID
PK_POSTTOGLPROCESSTRANSACTIONTYPEFILTER	ID	yes	yes

Triggers

Trigger Name	Description
TR_POSTTOGLPROCESSTRANSACTIONTYPEFILTER_AUDIT_UPDATE
TR_POSTTOGLPROCESSTRANSACTIONTYPEFILTER_AUDIT_DELETE