REVENUELETTER

Stores information pertaining to revenue details and their corresponding letters.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
PROCESSDATE	datetime	yes		Date acknowledgement process was run for this letter.
ACKNOWLEDGEDATE	datetime	yes		Date letter was sent.
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
OUTOFDATE	bit		Default = 0	Specifies whether or not the letter is out of date and should be re-acknowledged.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
REVENUEID	uniqueidentifier		FINANCIALTRANSACTION.ID	A foreign key to the REVENUE table.
LETTERCODEID	uniqueidentifier	yes	LETTERCODE.LOCALID	A foreign key to the LETTERCODE table.
ACKNOWLEDGEMENTPROCESSSTATUSID	uniqueidentifier	yes	ACKNOWLEDGEMENTPROCESSSTATUS.ID	A foreign key to the ACKNOWLEDGEMENTPROCESSSTATUS table.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
ACKNOWLEDGEEID	uniqueidentifier		CONSTITUENT.LOCALID	A foreign key to the CONSTITUENT table.
MKTPACKAGEID	uniqueidentifier	yes	MKTPACKAGE.ID	FK to MKTPACKAGE
MKTSEGMENTATIONACTIVATEPROCESSSTATUSID	uniqueidentifier	yes	MKTSEGMENTATIONACTIVATEPROCESSSTATUS.ID	A foreign key to the MKTSEGMENTATIONACTIVATEPROCESSSTATUS table

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_REVENUELETTER_ACKNOWLEDGEEID	ACKNOWLEDGEEID
IX_REVENUELETTER_DATEADDED	DATEADDED			yes
IX_REVENUELETTER_DATECHANGED	DATECHANGED
IX_REVENUELETTER_MKTPACKAGEID	MKTPACKAGEID
IX_REVENUELETTER_REVENUEID_LETTERCODEID	REVENUEID, LETTERCODEID
IX_REVENUELETTER_REVENUEID_MKTPACKAGEID	REVENUEID, MKTPACKAGEID
PK_REVENUELETTER	ID	yes	yes

Triggers

Trigger Name	Description
TR_REVENUELETTER_AUDIT_UPDATE
TR_REVENUELETTER_AUDIT_DELETE
TR_REVENUELETTER_AUDIT_ETLDELETEDID

Referenced by

Referenced by	Field
REVENUELETTERMARKETING	ID