BATCHPLEDGEWRITEOFF

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
REVENUEID	uniqueidentifier
WRITEOFFTOTALAMOUNT	money	yes	Default = 0
DATE	datetime	yes
POSTSTATUSCODE	tinyint		Default = 1
POSTSTATUS	nvarchar(11) (Computed)	yes	CASE [POSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Do not post' WHEN 255 THEN N'None' END
POSTDATE	datetime	yes
REASON	nvarchar(300)		Default = ''
RECOGNITIONCREDITADJUSTMENTCODE	tinyint		Default = 0
SEQUENCE	int		Default = 0
USERMANUALLYADJUSTEDRECOGNITIONCREDITS	bit		Default = 0
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
RECOGNITIONCREDITADJUSTMENT	nvarchar(49) (Computed)	yes	CASE [RECOGNITIONCREDITADJUSTMENTCODE] WHEN 0 THEN N'Reduce recognition credits by proportional amount' WHEN 1 THEN N'Reduce recognition credits by write-off amount' WHEN 2 THEN N'Manually reduce recognition credits' WHEN 3 THEN N'Do not adjust recognition credits' END

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier		BATCH.ID
REASONCODEID	uniqueidentifier	yes	WRITEOFFREASONCODE.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHPLEDGEWRITEOFF_BATCHID	BATCHID
IX_BATCHPLEDGEWRITEOFF_DATEADDED	DATEADDED			yes
IX_BATCHPLEDGEWRITEOFF_DATECHANGED	DATECHANGED
PK_BATCHPLEDGEWRITEOFF	ID	yes	yes
UIX_BATCHPLEDGEWRITEOFF_REVENUEID_BATCHID	REVENUEID, BATCHID	yes

Triggers

Trigger Name	Description
TR_BATCHPLEDGEWRITEOFF_AUDIT_UPDATE
TR_BATCHPLEDGEWRITEOFF_AUDIT_DELETE

Referenced by

Referenced by	Field
BATCHPLEDGEWRITEOFFBATCHSYSTEMMESSAGES	BATCHPLEDGEWRITEOFFID
BATCHPLEDGEWRITEOFFBATCHUSERMESSAGE	ID
BATCHPLEDGEWRITEOFFINSTALLMENT	BATCHPLEDGEWRITEOFFID
BATCHPLEDGEWRITEOFFRECOGNITIONCREDITS	BATCHPLEDGEWRITEOFFID