Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NETCOMMUNITYTRANSACTIONID int   Default = 0 Indicates the transaction number in Blackbaud NetCommunity if this was a NetCommunity transaction.
 NETCOMMUNITYPAGENAME nvarchar(1000)   Default = '' Name of the NetCommunity page from which this registration originated if it came from NetCommunity.
 NETCOMMUNITYPAGEID int   Default = 0 ID of the NetCommunity page from which this registration originated if it came from NetCommunity.
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 EMAILID int   Default = 0 Indicates the email ID used to generate this transaction if this transaction was the result of an email click-through from NetCommunity.
 EMAILNAME nvarchar(255)   Default = '' Indicates the email name used to generate this transaction if this transaction was the result of an email click-through from NetCommunity.
 EMAILSUBJECT nvarchar(255)   Default = '' Indicates the email subject used to generate this transaction if this transaction was the result of an email click-through from NetCommunity.
 EMAILCAMPAIGNNAME nvarchar(255)   Default = '' Indicates the email campaign used to generate this transaction if this transaction was the result of an email click-through from NetCommunity.
 ISTEAMFUNDRAISINGOFFLINEGIFT bit   Default = 0 Indicates that the gift is a team fundraising offline gift.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   FINANCIALTRANSACTION.ID Primary Key.
 NETCOMMUNITYAPPEALID uniqueidentifier APPEAL.LOCALID Indicates the source appeal for this transaction if it was specified by NetCommunity.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_REVENUEBBNC_DATEADDED DATEADDED    
 IX_REVENUEBBNC_DATECHANGED DATECHANGED      
 PK_REVENUEBBNC ID  

Trigger Name Description
 TR_REVENUEBBNC_AUDIT_UPDATE
 TR_REVENUEBBNC_AUDIT_DELETE

Entity-Relationship diagram of this table